36 lines
1.3 KiB
JavaScript
36 lines
1.3 KiB
JavaScript
'use strict';
|
|
|
|
module.exports = {
|
|
up: (queryInterface, Sequelize) => {
|
|
return queryInterface.sequelize.transaction((t) => {
|
|
return Promise.all([
|
|
queryInterface.removeColumn('unscheduledIncidents', 'chargeType'),
|
|
queryInterface.addColumn('unscheduledIncidents', 'chargePrice', {
|
|
type: Sequelize.FLOAT,
|
|
after: 'doorLockEventTimestamp'
|
|
}),
|
|
queryInterface.addColumn('unscheduledIncidents', 'timeIntervalsToCharge', {
|
|
type: Sequelize.INTEGER,
|
|
after: 'chargePrice'
|
|
}),
|
|
queryInterface.renameColumn('unscheduledIncidents', 'chargeFee', 'totalChargeFee')
|
|
]);
|
|
});
|
|
},
|
|
|
|
down: (queryInterface, Sequelize) => {
|
|
return queryInterface.sequelize.transaction((t) => {
|
|
return Promise.all([
|
|
queryInterface.renameColumn('unscheduledIncidents', 'totalChargeFee', 'chargeFee'),
|
|
queryInterface.removeColumn('unscheduledIncidents', 'timeIntervalsToCharge'),
|
|
queryInterface.removeColumn('unscheduledIncidents', 'chargePrice'),
|
|
queryInterface.addColumn('unscheduledIncidents', 'chargeType', {
|
|
type: Sequelize.ENUM,
|
|
values: ['unlocked', 'unscheduled'],
|
|
after: 'doorLockEventTimestamp'
|
|
}),
|
|
]);
|
|
});
|
|
}
|
|
};
|