mirror of
https://iceshrimp.dev/limepotato/jormungandr-bite.git
synced 2024-11-24 19:07:32 -07:00
46 lines
2.1 KiB
TypeScript
46 lines
2.1 KiB
TypeScript
import { MigrationInterface, QueryRunner } from "typeorm";
|
|
export class nsfwDetection31655388169582 implements MigrationInterface {
|
|
name = "nsfwDetection31655388169582";
|
|
|
|
async up(queryRunner: QueryRunner): Promise<void> {
|
|
await queryRunner.query(
|
|
`ALTER TYPE "public"."meta_sensitiveimagedetectionsensitivity_enum" RENAME TO "meta_sensitiveimagedetectionsensitivity_enum_old"`,
|
|
);
|
|
await queryRunner.query(
|
|
`CREATE TYPE "public"."meta_sensitiveimagedetectionsensitivity_enum" AS ENUM('medium', 'low', 'high', 'veryLow', 'veryHigh')`,
|
|
);
|
|
await queryRunner.query(
|
|
`ALTER TABLE "meta" ALTER COLUMN "sensitiveImageDetectionSensitivity" DROP DEFAULT`,
|
|
);
|
|
await queryRunner.query(
|
|
`ALTER TABLE "meta" ALTER COLUMN "sensitiveImageDetectionSensitivity" TYPE "public"."meta_sensitiveimagedetectionsensitivity_enum" USING "sensitiveImageDetectionSensitivity"::"text"::"public"."meta_sensitiveimagedetectionsensitivity_enum"`,
|
|
);
|
|
await queryRunner.query(
|
|
`ALTER TABLE "meta" ALTER COLUMN "sensitiveImageDetectionSensitivity" SET DEFAULT 'medium'`,
|
|
);
|
|
await queryRunner.query(
|
|
`DROP TYPE "public"."meta_sensitiveimagedetectionsensitivity_enum_old"`,
|
|
);
|
|
}
|
|
|
|
async down(queryRunner: QueryRunner): Promise<void> {
|
|
await queryRunner.query(
|
|
`CREATE TYPE "public"."meta_sensitiveimagedetectionsensitivity_enum_old" AS ENUM('medium', 'low', 'high')`,
|
|
);
|
|
await queryRunner.query(
|
|
`ALTER TABLE "meta" ALTER COLUMN "sensitiveImageDetectionSensitivity" DROP DEFAULT`,
|
|
);
|
|
await queryRunner.query(
|
|
`ALTER TABLE "meta" ALTER COLUMN "sensitiveImageDetectionSensitivity" TYPE "public"."meta_sensitiveimagedetectionsensitivity_enum_old" USING "sensitiveImageDetectionSensitivity"::"text"::"public"."meta_sensitiveimagedetectionsensitivity_enum_old"`,
|
|
);
|
|
await queryRunner.query(
|
|
`ALTER TABLE "meta" ALTER COLUMN "sensitiveImageDetectionSensitivity" SET DEFAULT 'medium'`,
|
|
);
|
|
await queryRunner.query(
|
|
`DROP TYPE "public"."meta_sensitiveimagedetectionsensitivity_enum"`,
|
|
);
|
|
await queryRunner.query(
|
|
`ALTER TYPE "public"."meta_sensitiveimagedetectionsensitivity_enum_old" RENAME TO "meta_sensitiveimagedetectionsensitivity_enum"`,
|
|
);
|
|
}
|
|
}
|