firefish/packages/backend/migration-neko/1692825433698-emoji-moderator.js

18 lines
550 B
JavaScript
Raw Permalink Normal View History

2023-08-25 03:23:12 +09:00
export class EmojiModerator1692825433698 {
name = "EmojiModerator1692825433698";
async up(queryRunner) {
await queryRunner.query(
`CREATE TYPE "public"."user_emojimodperm_enum" AS ENUM('none', 'add', 'mod', 'full')`,
);
await queryRunner.query(
`ALTER TABLE "user" ADD "emojiModPerm" "public"."user_emojimodperm_enum" NOT NULL DEFAULT 'none'`,
);
}
async down(queryRunner) {
await queryRunner.query(`ALTER TABLE "user" DROP COLUMN "emojiModPerm"`);
await queryRunner.query(`DROP TYPE "public"."user_emojimodperm_enum"`);
}
}