Files
outline/server/migrations/20211107021900-missing-cascades.js
Tom Moor 15b1069bcc chore: Move to Typescript (#2783)
This PR moves the entire project to Typescript. Due to the ~1000 ignores this will lead to a messy codebase for a while, but the churn is worth it – all of those ignore comments are places that were never type-safe previously.

closes #1282
2021-11-29 06:40:55 -08:00

39 lines
1.7 KiB
JavaScript

module.exports = {
up: async (queryInterface, Sequelize) => {
let tableName, constraintName;
tableName = "collection_groups";
constraintName = "collection_groups_collectionId_fkey";
await queryInterface.sequelize.query(
`alter table "${tableName}" drop constraint "${constraintName}"`
);
await queryInterface.sequelize.query(`alter table "${tableName}"
add constraint "${constraintName}" foreign key("collectionId") references "collections" ("id")
on delete cascade`);
constraintName = "collection_groups_groupId_fkey";
await queryInterface.sequelize.query(
`alter table "${tableName}" drop constraint "${constraintName}"`
);
await queryInterface.sequelize.query(`alter table "${tableName}"
add constraint "${constraintName}" foreign key("groupId") references "groups" ("id")
on delete cascade`);
},
down: async (queryInterface, Sequelize) => {
let tableName, constraintName;
tableName = "collection_groups";
constraintName = "collection_groups_collectionId_fkey";
await queryInterface.sequelize.query(
`alter table "${tableName}" drop constraint "${constraintName}"`
);
await queryInterface.sequelize.query(`alter table "${tableName}"
add constraint "${constraintName}" foreign key("collectionId") references "collections" ("id")
on delete no action`);
constraintName = "collection_groups_groupId_fkey";
await queryInterface.sequelize.query(
`alter table "${tableName}" drop constraint "${constraintName}"`
);
await queryInterface.sequelize.query(`alter table "${tableName}"
add constraint "${constraintName}" foreign key("groupId") references "groups" ("id")
on delete no action`);
},
};