diff options
Diffstat (limited to 'src/util/migrations/postgres/1661885830688-guild-member-profiles.ts')
-rw-r--r-- | src/util/migrations/postgres/1661885830688-guild-member-profiles.ts | 27 |
1 files changed, 13 insertions, 14 deletions
diff --git a/src/util/migrations/postgres/1661885830688-guild-member-profiles.ts b/src/util/migrations/postgres/1661885830688-guild-member-profiles.ts index 81671250..c6b69234 100644 --- a/src/util/migrations/postgres/1661885830688-guild-member-profiles.ts +++ b/src/util/migrations/postgres/1661885830688-guild-member-profiles.ts @@ -1,40 +1,39 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class guildMemberProfiles1661885830688 implements MigrationInterface { - name = 'guildMemberProfiles1661885830688' + name = "guildMemberProfiles1661885830688"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(` + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(` ALTER TABLE "members" ADD "avatar" character varying `); - await queryRunner.query(` + await queryRunner.query(` ALTER TABLE "members" ADD "banner" character varying `); - await queryRunner.query(` + await queryRunner.query(` ALTER TABLE "members" ADD "bio" character varying NOT NULL default '' `); - await queryRunner.query(` + await queryRunner.query(` ALTER TABLE "members" ADD "communication_disabled_until" TIMESTAMP `); - } + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(` + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(` ALTER TABLE "members" DROP COLUMN "communication_disabled_until" `); - await queryRunner.query(` + await queryRunner.query(` ALTER TABLE "members" DROP COLUMN "bio" `); - await queryRunner.query(` + await queryRunner.query(` ALTER TABLE "members" DROP COLUMN "banner" `); - await queryRunner.query(` + await queryRunner.query(` ALTER TABLE "members" DROP COLUMN "avatar" `); - } - + } } |