Resolve #5513

1 files changed, 14 insertions, 0 deletions

diff --git a/migration/1580543501339-v12-13.ts b/migration/1580543501339-v12-13.ts
new file mode 100644
index 0000000000..7f5d8b8030
--- /dev/null
+++ b/migration/1580543501339-v12-13.ts
@@ -0,0 +1,14 @@
+import {MigrationInterface, QueryRunner} from "typeorm";
+
+export class v12131580543501339 implements MigrationInterface {
+    name = 'v12131580543501339'
+
+    public async up(queryRunner: QueryRunner): Promise<any> {
+        await queryRunner.query(`CREATE INDEX "IDX_NOTE_TAGS" ON "note" USING gin ("tags")`, undefined);
+    }
+
+    public async down(queryRunner: QueryRunner): Promise<any> {
+        await queryRunner.query(`DROP INDEX "IDX_NOTE_TAGS"`, undefined);
+    }
+
+}