diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2022-07-16 23:51:32 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2022-07-16 23:51:32 +0900 |
| commit | e4453e9ca8b31fc03ee55ce23f409a1b99955fba (patch) | |
| tree | f0c446ee7c65e4e4649a762106ee61979ba2c6f0 | |
| parent | 12.116.0-beta.1 (diff) | |
| download | misskey-e4453e9ca8b31fc03ee55ce23f409a1b99955fba.tar.gz misskey-e4453e9ca8b31fc03ee55ce23f409a1b99955fba.tar.bz2 misskey-e4453e9ca8b31fc03ee55ce23f409a1b99955fba.zip | |
Update 1651224615271-foreign-key.js
#8852
| -rw-r--r-- | packages/backend/migration/1651224615271-foreign-key.js | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/packages/backend/migration/1651224615271-foreign-key.js b/packages/backend/migration/1651224615271-foreign-key.js index 44ba7fb6c4..1f1510f845 100644 --- a/packages/backend/migration/1651224615271-foreign-key.js +++ b/packages/backend/migration/1651224615271-foreign-key.js @@ -28,7 +28,7 @@ export class foreignKeyReports1651224615271 { queryRunner.query(`CREATE INDEX "IDX_315c779174fe8247ab324f036e" ON "drive_file" ("isLink")`), queryRunner.query(`CREATE INDEX "IDX_f22169eb10657bded6d875ac8f" ON "note" ("channelId")`), - queryRunner.query(`CREATE INDEX "IDX_a9021cc2e1feb5f72d3db6e9f5" ON "abuse_user_report" ("targetUserId")`), + //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`); |