summary refs log tree commit diff
path: root/src/util/migrations/mariadb
diff options
context:
space:
mode:
Diffstat (limited to 'src/util/migrations/mariadb')
-rw-r--r--src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts27
1 files changed, 13 insertions, 14 deletions
diff --git a/src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts b/src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts

index 6e1ac3f8..21ee2027 100644 --- a/src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts +++ b/src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts
@@ -1,40 +1,39 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class guildMemberProfiles1661885910534 implements MigrationInterface { - name = 'guildMemberProfiles1661885910534' + name = "guildMemberProfiles1661885910534"; - 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\` varchar(255) NULL `); - await queryRunner.query(` + await queryRunner.query(` ALTER TABLE \`members\` ADD \`banner\` varchar(255) NULL `); - await queryRunner.query(` + await queryRunner.query(` ALTER TABLE \`members\` ADD \`bio\` varchar(255) NOT NULL `); - await queryRunner.query(` + await queryRunner.query(` ALTER TABLE \`members\` ADD \`communication_disabled_until\` datetime NULL `); - } + } - 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\` `); - } - + } }