15b1069bcc
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
69 lines
3.2 KiB
JavaScript
69 lines
3.2 KiB
JavaScript
module.exports = {
|
|
up: async (queryInterface, Sequelize) => {
|
|
let tableName, constraintName;
|
|
tableName = "collection_users";
|
|
constraintName = "collection_users_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_users_userId_fkey";
|
|
await queryInterface.sequelize.query(
|
|
`alter table "${tableName}" drop constraint "${constraintName}"`
|
|
);
|
|
await queryInterface.sequelize.query(`alter table "${tableName}"\
|
|
add constraint "${constraintName}" foreign key("userId") references "users" ("id")
|
|
on delete cascade`);
|
|
tableName = "group_users";
|
|
constraintName = "group_users_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`);
|
|
constraintName = "group_users_userId_fkey";
|
|
await queryInterface.sequelize.query(
|
|
`alter table "${tableName}" drop constraint "${constraintName}"`
|
|
);
|
|
await queryInterface.sequelize.query(`alter table "${tableName}"
|
|
add constraint "${constraintName}" foreign key("userId") references "users" ("id")
|
|
on delete cascade`);
|
|
},
|
|
down: async (queryInterface, Sequelize) => {
|
|
let tableName, constraintName;
|
|
tableName = "collection_users";
|
|
constraintName = "collection_users_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_users_userId_fkey";
|
|
await queryInterface.sequelize.query(
|
|
`alter table "${tableName}" drop constraint "${constraintName}"`
|
|
);
|
|
await queryInterface.sequelize.query(`alter table "${tableName}"\
|
|
add constraint "${constraintName}" foreign key("userId") references "users" ("id")
|
|
on delete no action`);
|
|
tableName = "group_users";
|
|
constraintName = "group_users_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`);
|
|
constraintName = "group_users_userId_fkey";
|
|
await queryInterface.sequelize.query(
|
|
`alter table "${tableName}" drop constraint "${constraintName}"`
|
|
);
|
|
await queryInterface.sequelize.query(`alter table "${tableName}"
|
|
add constraint "${constraintName}" foreign key("userId") references "users" ("id")
|
|
on delete no action`);
|
|
},
|
|
};
|