tm-apps-db

Information on using the Sequelize CLI to perform database migrations can be viewed here: http://docs.sequelizejs.com/en/latest/docs/migrations/

All migration javascript files should be placed in the migrations directory with a name of the form yyyyMMddhhmmss.js. An example of such a file is:

module.exports = {
    up: (queryInterface, sequelize) => {
        return queryInterface.addColumn('articles', 'a_new_column', sequelize.STRING)
    },
    down: (queryInterface, sequelize) => {
        return queryInterface.removeColumn('articles', 'a_new_column', sequelize.STRING)
    }
};

Each file should expose an up function and a down function. The up function applies a migration; in this case an extra column is added to the articles table. The down function should revert the migration applied by the up function; in this case removing the new column from the articles table.

To perform migrations you must be in the apps-consumer-scripts directory. Then run

$ npm run migrate

Migrations can be reversed by running

$ npm run migrate:undo