17 lines
546 B
JavaScript
17 lines
546 B
JavaScript
'use strict';
|
|
|
|
module.exports = {
|
|
async up(queryInterface) {
|
|
await queryInterface.sequelize.query(`
|
|
ALTER TABLE falukant_data.party
|
|
ADD COLUMN IF NOT EXISTS relationship_id INTEGER NULL
|
|
REFERENCES falukant_data.relationship(id) ON DELETE SET NULL;
|
|
CREATE INDEX IF NOT EXISTS party_relationship_id_idx
|
|
ON falukant_data.party (relationship_id);
|
|
`);
|
|
},
|
|
async down(queryInterface) {
|
|
await queryInterface.sequelize.query(`ALTER TABLE falukant_data.party DROP COLUMN IF EXISTS relationship_id;`);
|
|
}
|
|
};
|