diff options
Diffstat (limited to 'migration')
| -rw-r--r-- | migration/1621479946000-add-note-indexes.ts | 16 |
1 files changed, 16 insertions, 0 deletions
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<void> { + 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<void> { + await queryRunner.query(`DROP INDEX "IDX_NOTE_MENTIONS"`, undefined); + await queryRunner.query(`DROP INDEX "IDX_NOTE_VISIBLE_USER_IDS"`, undefined); + } + +} |