From da34acd35fdeca50cba2de809e85de1f22eb5b70 Mon Sep 17 00:00:00 2001 From: syuilo Date: Fri, 21 May 2021 14:13:03 +0900 Subject: Resolve #6563 (#7524) * Resolve #6563 * Update note.ts * Update generate-visibility-query.ts --- migration/1621479946000-add-note-indexes.ts | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 migration/1621479946000-add-note-indexes.ts (limited to 'migration') diff --git a/migration/1621479946000-add-note-indexes.ts b/migration/1621479946000-add-note-indexes.ts new file mode 100644 index 0000000000..53d49964a7 --- /dev/null +++ b/migration/1621479946000-add-note-indexes.ts @@ -0,0 +1,16 @@ +import {MigrationInterface, QueryRunner} from "typeorm"; + +export class addNoteIndexes1621479946000 implements MigrationInterface { + name = 'addNoteIndexes1621479946000' + + public async up(queryRunner: QueryRunner): Promise { + await queryRunner.query(`CREATE INDEX "IDX_NOTE_MENTIONS" ON "note" USING gin ("mentions")`, undefined); + await queryRunner.query(`CREATE INDEX "IDX_NOTE_VISIBLE_USER_IDS" ON "note" USING gin ("visibleUserIds")`, undefined); + } + + public async down(queryRunner: QueryRunner): Promise { + await queryRunner.query(`DROP INDEX "IDX_NOTE_MENTIONS"`, undefined); + await queryRunner.query(`DROP INDEX "IDX_NOTE_VISIBLE_USER_IDS"`, undefined); + } + +} -- cgit v1.2.3-freya