bullpen/backend/migrations/15-extend-bullpen-session.js

38 lines
1.4 KiB
JavaScript

// Migration 2: Remove columns from Users
/** @type {import('sequelize-cli').Migration} */
module.exports = {
async up(queryInterface, Sequelize) {
return Promise.all([
queryInterface.addColumn('BullpenSessions','precisionRate', {
type: Sequelize.INTEGER,
allowNull: false
}),
queryInterface.addColumn('BullpenSessions','strikeRate', {
type: Sequelize.INTEGER,
allowNull: false
}),
queryInterface.addColumn('BullpenSessions','ballRate', {
type: Sequelize.INTEGER,
allowNull: false
}),
queryInterface.addColumn('BullpenSessions','fastballRate', {
type: Sequelize.INTEGER,
allowNull: false
}),
queryInterface.addColumn('BullpenSessions','offSpeedRate', {
type: Sequelize.INTEGER,
allowNull: false
}),
]);
},
async down(queryInterface, Sequelize) {
return Promise.all([
queryInterface.removeColumn('BullpenSessions', 'precisionRate'),
queryInterface.removeColumn('BullpenSessions', 'strikeRate'),
queryInterface.removeColumn('BullpenSessions', 'ballRate'),
queryInterface.removeColumn('BullpenSessions', 'fastballRate'),
queryInterface.removeColumn('BullpenSessions', 'offSpeedRate')
]);
}
};