diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2022-07-17 05:12:59 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2022-07-17 05:12:59 +0900 |
| commit | bec2d9e3fafd721f116066f6a7e3ff0507b27de9 (patch) | |
| tree | 70b66bfb422c3d9a837c2222de34631cb23c57ae /packages | |
| parent | fix(client): fix deck style (diff) | |
| download | misskey-bec2d9e3fafd721f116066f6a7e3ff0507b27de9.tar.gz misskey-bec2d9e3fafd721f116066f6a7e3ff0507b27de9.tar.bz2 misskey-bec2d9e3fafd721f116066f6a7e3ff0507b27de9.zip | |
Update 1651224615271-foreign-key.js
#8852
Diffstat (limited to 'packages')
| -rw-r--r-- | packages/backend/migration/1651224615271-foreign-key.js | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/packages/backend/migration/1651224615271-foreign-key.js b/packages/backend/migration/1651224615271-foreign-key.js index 1f1510f845..535d21731a 100644 --- a/packages/backend/migration/1651224615271-foreign-key.js +++ b/packages/backend/migration/1651224615271-foreign-key.js @@ -30,9 +30,9 @@ export class foreignKeyReports1651224615271 { queryRunner.query(`CREATE INDEX "IDX_f22169eb10657bded6d875ac8f" ON "note" ("channelId")`), //queryRunner.query(`CREATE INDEX "IDX_a9021cc2e1feb5f72d3db6e9f5" ON "abuse_user_report" ("targetUserId")`), - queryRunner.query(`DELETE FROM "abuse_user_report" WHERE "targetUserId" NOT IN (SELECT "id" FROM "user")`).then(() => { - queryRunner.query(`ALTER TABLE "abuse_user_report" ADD CONSTRAINT "FK_a9021cc2e1feb5f72d3db6e9f5f" FOREIGN KEY ("targetUserId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION`); - }), + //queryRunner.query(`DELETE FROM "abuse_user_report" WHERE "targetUserId" NOT IN (SELECT "id" FROM "user")`).then(() => { + // queryRunner.query(`ALTER TABLE "abuse_user_report" ADD CONSTRAINT "FK_a9021cc2e1feb5f72d3db6e9f5f" FOREIGN KEY ("targetUserId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION`); + //}), queryRunner.query(`ALTER TABLE "poll" ADD CONSTRAINT "UQ_da851e06d0dfe2ef397d8b1bf1b" UNIQUE ("noteId")`), queryRunner.query(`ALTER TABLE "user_keypair" ADD CONSTRAINT "UQ_f4853eb41ab722fe05f81cedeb6" UNIQUE ("userId")`), |