Files
outline/server/migrations/20160814083127-paranoia-indeces.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

52 lines
2.0 KiB
JavaScript

module.exports = {
up: async (queryInterface, Sequelize) => {
// Remove old indeces
await queryInterface.removeIndex("documents", ["urlId"]);
await queryInterface.removeIndex("documents", ["id", "atlasId"]);
await queryInterface.removeIndex("documents", ["id", "teamId"]);
await queryInterface.removeIndex("documents", [
"parentDocumentId",
"atlasId",
]);
await queryInterface.removeIndex("atlases", ["id", "teamId"]);
// Add new ones
await queryInterface.addIndex("documents", ["id", "deletedAt"]);
await queryInterface.addIndex("documents", ["urlId", "deletedAt"]);
await queryInterface.addIndex("documents", ["id", "atlasId", "deletedAt"]);
await queryInterface.addIndex("documents", ["id", "teamId", "deletedAt"]);
await queryInterface.addIndex("documents", [
"parentDocumentId",
"atlasId",
"deletedAt",
]);
await queryInterface.addIndex("atlases", ["id", "deletedAt"]);
await queryInterface.addIndex("atlases", ["id", "teamId", "deletedAt"]);
},
down: async (queryInterface, Sequelize) => {
await queryInterface.addIndex("documents", ["urlId"]);
await queryInterface.addIndex("documents", ["id", "atlasId"]);
await queryInterface.addIndex("documents", ["id", "teamId"]);
await queryInterface.addIndex("documents", ["parentDocumentId", "atlasId"]);
await queryInterface.addIndex("atlases", ["id", "teamId"]);
await queryInterface.removeIndex("documents", ["id", "deletedAt"]);
await queryInterface.removeIndex("documents", ["urlId", "deletedAt"]);
await queryInterface.removeIndex("documents", [
"id",
"atlasId",
"deletedAt",
]);
await queryInterface.removeIndex("documents", [
"id",
"teamId",
"deletedAt",
]);
await queryInterface.removeIndex("documents", [
"parentDocumentId",
"atlasId",
"deletedAt",
]);
await queryInterface.removeIndex("atlases", ["id", "deletedAt"]);
await queryInterface.removeIndex("atlases", ["id", "teamId", "deletedAt"]);
},
};