quanyoumi/backend/migrations/0009-add-group-status.js

21 lines
521 B
JavaScript

/**
* 迁移 0009: 添加进群状态字段
* 为 Registrations 表添加 groupStatus 字段
*/
module.exports = {
async up(manager) {
console.log(' - 添加 Registrations.groupStatus 字段...');
await manager.executeSql(`
ALTER TABLE Registrations ADD COLUMN groupStatus INTEGER DEFAULT 0;
`);
},
async down(manager) {
console.log(' - 移除 Registrations.groupStatus 字段...');
await manager.executeSql(`
ALTER TABLE Registrations DROP COLUMN groupStatus;
`);
}
};