Add unique index

1 files changed, 13 insertions, 0 deletions

diff --git a/migration/1558266512381-UserListJoining.ts b/migration/1558266512381-UserListJoining.ts
new file mode 100644
index 0000000000..f4a917045d
--- /dev/null
+++ b/migration/1558266512381-UserListJoining.ts
@@ -0,0 +1,13 @@
+import {MigrationInterface, QueryRunner} from "typeorm";
+
+export class UserListJoining1558266512381 implements MigrationInterface {
+
+    public async up(queryRunner: QueryRunner): Promise<any> {
+        await queryRunner.query(`CREATE UNIQUE INDEX "IDX_90f7da835e4c10aca6853621e1" ON "user_list_joining" ("userId", "userListId") `);
+    }
+
+    public async down(queryRunner: QueryRunner): Promise<any> {
+        await queryRunner.query(`DROP INDEX "IDX_90f7da835e4c10aca6853621e1"`);
+    }
+
+}