Sequelize

http://docs.sequelizejs.com/manual/tutorial/migrations.html

http://sequelize.readthedocs.io/en/latest/docs/migrations/

install cli

npm install --save sequelize-cli

init

node_modules/.bin/sequelize init

config file : config/config.json

generate migration file

node_modules/.bin/sequelize migration:create --name create-ticket-tiers

running migrate

node_modules/.bin/sequelize db:migrate

undo migration

node_modules/.bin/sequelize db:migrate:undo

running seed

node_modules/.bin/sequelize db:seed:all

undo seed

node_modules/.bin/sequelize db:seed:undo

node_modules/.bin/sequelize db:seed:undo:all

create seed

node_modules/.bin/sequelize seed:generate --name demo-user

'use strict';

module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.bulkInsert('Users', [{
        firstName: 'John',
        lastName: 'Doe',
        email: '[email protected]'
      }], {});
  },

  down: (queryInterface, Sequelize) => {
    return queryInterface.bulkDelete('Users', null, {});
  }
};