Files
outline/server/migrations/20251212232400-add-authentications-service-teamid-index.js
Copilot d5dbf286cc Add missing database indexes for hooks.unfurl endpoint (#10870)
* Initial plan

* Add database indexes to improve hooks.unfurl performance

Co-authored-by: tommoor <380914+tommoor@users.noreply.github.com>

* Verify migrations and query plans for new indexes

Co-authored-by: tommoor <380914+tommoor@users.noreply.github.com>

* Address code review feedback: improve migration rollback order and add comments

Co-authored-by: tommoor <380914+tommoor@users.noreply.github.com>

* Change index column order to teamId first as requested

Co-authored-by: tommoor <380914+tommoor@users.noreply.github.com>

* Update .env.test

---------

Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com>
Co-authored-by: tommoor <380914+tommoor@users.noreply.github.com>
Co-authored-by: Tom Moor <tom@getoutline.com>
2025-12-12 19:02:20 -05:00

17 lines
373 B
JavaScript

"use strict";
module.exports = {
async up(queryInterface, Sequelize) {
await queryInterface.addIndex("authentications", ["teamId", "service"], {
name: "authentications_team_id_service",
});
},
async down(queryInterface, Sequelize) {
await queryInterface.removeIndex(
"authentications",
"authentications_team_id_service"
);
},
};