diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2020-10-22 23:10:23 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-10-22 23:10:23 +0900 |
| commit | adf01ed4a44dcdac20c6a21783595c9c3b8de83f (patch) | |
| tree | fb496b0f5814b5d6a35adeff34397cb95d148dfa /migration | |
| parent | Update dependencies :rocket: (diff) | |
| download | sharkey-adf01ed4a44dcdac20c6a21783595c9c3b8de83f.tar.gz sharkey-adf01ed4a44dcdac20c6a21783595c9c3b8de83f.tar.bz2 sharkey-adf01ed4a44dcdac20c6a21783595c9c3b8de83f.zip | |
Fix #6749 (#6754)
Diffstat (limited to 'migration')
| -rw-r--r-- | migration/1603094348345-refine-abuse-user-report.ts | 10 |
1 files changed, 2 insertions, 8 deletions
diff --git a/migration/1603094348345-refine-abuse-user-report.ts b/migration/1603094348345-refine-abuse-user-report.ts index 2c5c4b39c5..b11164ab1a 100644 --- a/migration/1603094348345-refine-abuse-user-report.ts +++ b/migration/1603094348345-refine-abuse-user-report.ts @@ -7,29 +7,23 @@ export class refineAbuseUserReport1603094348345 implements MigrationInterface { await queryRunner.query(`ALTER TABLE "abuse_user_report" DROP CONSTRAINT "FK_d049123c413e68ca52abe734203"`); await queryRunner.query(`DROP INDEX "IDX_d049123c413e68ca52abe73420"`); await queryRunner.query(`DROP INDEX "IDX_5cd442c3b2e74fdd99dae20243"`); - await queryRunner.query(`ALTER TABLE "abuse_user_report" DROP COLUMN "userId"`); - await queryRunner.query(`ALTER TABLE "abuse_user_report" ADD "targetUserId" character varying(32) NOT NULL`); + await queryRunner.query(`ALTER TABLE "abuse_user_report" RENAME COLUMN "userId" TO "targetUserId"`); await queryRunner.query(`ALTER TABLE "abuse_user_report" ADD "assigneeId" character varying(32)`); await queryRunner.query(`ALTER TABLE "abuse_user_report" ADD "resolved" boolean NOT NULL DEFAULT false`); await queryRunner.query(`ALTER TABLE "abuse_user_report" DROP COLUMN "comment"`); await queryRunner.query(`ALTER TABLE "abuse_user_report" ADD "comment" character varying(2048) NOT NULL`); - await queryRunner.query(`CREATE INDEX "IDX_a9021cc2e1feb5f72d3db6e9f5" ON "abuse_user_report" ("targetUserId") `); await queryRunner.query(`CREATE INDEX "IDX_2b15aaf4a0dc5be3499af7ab6a" ON "abuse_user_report" ("resolved") `); - await queryRunner.query(`ALTER TABLE "abuse_user_report" ADD CONSTRAINT "FK_a9021cc2e1feb5f72d3db6e9f5f" FOREIGN KEY ("targetUserId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION`); await queryRunner.query(`ALTER TABLE "abuse_user_report" ADD CONSTRAINT "FK_08b883dd5fdd6f9c4c1572b36de" FOREIGN KEY ("assigneeId") REFERENCES "user"("id") ON DELETE SET NULL ON UPDATE NO ACTION`); } public async down(queryRunner: QueryRunner): Promise<void> { await queryRunner.query(`ALTER TABLE "abuse_user_report" DROP CONSTRAINT "FK_08b883dd5fdd6f9c4c1572b36de"`); - await queryRunner.query(`ALTER TABLE "abuse_user_report" DROP CONSTRAINT "FK_a9021cc2e1feb5f72d3db6e9f5f"`); await queryRunner.query(`DROP INDEX "IDX_2b15aaf4a0dc5be3499af7ab6a"`); - await queryRunner.query(`DROP INDEX "IDX_a9021cc2e1feb5f72d3db6e9f5"`); await queryRunner.query(`ALTER TABLE "abuse_user_report" DROP COLUMN "comment"`); await queryRunner.query(`ALTER TABLE "abuse_user_report" ADD "comment" character varying(512) NOT NULL`); await queryRunner.query(`ALTER TABLE "abuse_user_report" DROP COLUMN "resolved"`); await queryRunner.query(`ALTER TABLE "abuse_user_report" DROP COLUMN "assigneeId"`); - await queryRunner.query(`ALTER TABLE "abuse_user_report" DROP COLUMN "targetUserId"`); - await queryRunner.query(`ALTER TABLE "abuse_user_report" ADD "userId" character varying(32) NOT NULL`); + await queryRunner.query(`ALTER TABLE "abuse_user_report" RENAME COLUMN "targetUserId" TO "userId"`); await queryRunner.query(`CREATE UNIQUE INDEX "IDX_5cd442c3b2e74fdd99dae20243" ON "abuse_user_report" ("userId", "reporterId") `); await queryRunner.query(`CREATE INDEX "IDX_d049123c413e68ca52abe73420" ON "abuse_user_report" ("userId") `); await queryRunner.query(`ALTER TABLE "abuse_user_report" ADD CONSTRAINT "FK_d049123c413e68ca52abe734203" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION`); |