diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2025-06-03 19:05:24 -0400 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2025-06-03 19:05:24 -0400 |
| commit | 99e3d4506232f13e311afe1a5bd942b721b2cabe (patch) | |
| tree | 249986229ae7f389ddb26b21f0093068ed059c22 /packages/backend/migration | |
| parent | fix query plans with IDX_instance_host_key (diff) | |
| download | sharkey-99e3d4506232f13e311afe1a5bd942b721b2cabe.tar.gz sharkey-99e3d4506232f13e311afe1a5bd942b721b2cabe.tar.bz2 sharkey-99e3d4506232f13e311afe1a5bd942b721b2cabe.zip | |
create IDX_note_for_timelines
Diffstat (limited to 'packages/backend/migration')
| -rw-r--r-- | packages/backend/migration/1748991828473-create-IDX_note_for_timelines.js | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/packages/backend/migration/1748991828473-create-IDX_note_for_timelines.js b/packages/backend/migration/1748991828473-create-IDX_note_for_timelines.js new file mode 100644 index 0000000000..2ea7fe95d2 --- /dev/null +++ b/packages/backend/migration/1748991828473-create-IDX_note_for_timelines.js @@ -0,0 +1,19 @@ +/* + * SPDX-FileCopyrightText: hazelnoot and other Sharkey contributors + * SPDX-License-Identifier: AGPL-3.0-only + */ + +export class CreateIDXNoteForTimelines1748991828473 { + async up(queryRunner) { + await queryRunner.query(` + create index "IDX_note_for_timelines" + on "note" ("id" desc, "channelId", "visibility", "userHost") + include ("userId", "userHost", "replyId", "replyUserId", "replyUserHost", "renoteId", "renoteUserId", "renoteUserHost") + NULLS NOT DISTINCT`); + await queryRunner.query(`comment on index "IDX_note_for_timelines" is 'Covering index for timeline queries'`); + } + + async down(queryRunner) { + await queryRunner.query(`DROP INDEX "IDX_note_for_timelines"`); + } +} |