Files
outline/server/migrations/20211003021903-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

25 lines
1.0 KiB
JavaScript

module.exports = {
up: async (queryInterface, Sequelize) => {
let tableName, constraintName;
tableName = "integrations";
constraintName = "integrations_authenticationId_fkey";
await queryInterface.sequelize.query(
`alter table "${tableName}" drop constraint "${constraintName}"`
);
await queryInterface.sequelize.query(`alter table "${tableName}"
add constraint "${constraintName}" foreign key("authenticationId") references "authentications" ("id")
on delete cascade`);
},
down: async (queryInterface, Sequelize) => {
let tableName, constraintName;
tableName = "integrations";
constraintName = "integrations_authenticationId_fkey";
await queryInterface.sequelize.query(
`alter table "${tableName}" drop constraint "${constraintName}"`
);
await queryInterface.sequelize.query(`alter table "${tableName}"
add constraint "${constraintName}" foreign key("authenticationId") references "authentications" ("id")
on delete no action`);
},
};