xxxxxxxxxx
- Create Migration: npx sequelize-cli migration:generate --name NAME_OF_YOUR_MIGRATION/MIGRATION_TITLE
- Migration Up: npx sequelize-cli db:migrate
- Migration Down(one): npx sequelize-cli db:migrate:undo
- Migration Down(all): npx sequelize-cli db:migrate:undo:all
xxxxxxxxxx
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'),
},
)),
xxxxxxxxxx
queryInterface.createTable(
'Posts',
{
title: {
type: Sequelize.DataTypes.STRING(100),
allowNull: false
}
}
);
xxxxxxxxxx
$ yarn add github:scimonster/sequelize-auto-migrations#a063aa6535a3f580623581bf866cef2d609531ba