JAVASCRIPT

sequelize generate migration

npx sequelize-cli migration:generate --name add-title-post-table

migrate db sequelize

// with sequelize-cli installed run
// create db
npx sequelize-cli db:create
// drop db
npx sequelize-cli db:drop
// migrate db
npx sequelize-cli db:migrate
// run all seeds
npx sequelize-cli db:seed:all

sequelize migration default value

queryInterface.addColumn('OrderBackups', 'my_column', {
  type: Sequelize.INTEGER,
  defaultValue: 0
})

sequelize migration

npx sequelize-cli migration:generate --name migration-skeleton

sequelize migration enum

queryInterface.changeColumn(
  'table_name',
  'Column_name',
  {
    type: Sequelize.TEXT,
  },
),
queryInterface.sequelize.query('drop type enum_tableName_columnName;')
.then(() => queryInterface.changeColumn(
  'table_name',
  'column_name',
  {
    type: Sequelize.ENUM('value1','value2'),
  },
)),

sequelize migration limit

queryInterface.createTable(
    'Posts',
    {
        title: {
            type: Sequelize.DataTypes.STRING(100),
            allowNull: false
        }
    }
);