From a4e7b9aa3422da873d22d0c80a79b1bbb530e31d Mon Sep 17 00:00:00 2001 From: Puyodead1 Date: Tue, 30 Aug 2022 15:00:23 -0400 Subject: regenerate migrations --- .../1661785263936-guild-member-profiles.ts | 63 ---------------------- .../1661885830688-guild-member-profiles.ts | 40 ++++++++++++++ 2 files changed, 40 insertions(+), 63 deletions(-) delete mode 100644 src/util/migrations/postgres/1661785263936-guild-member-profiles.ts create mode 100644 src/util/migrations/postgres/1661885830688-guild-member-profiles.ts (limited to 'src/util/migrations/postgres') diff --git a/src/util/migrations/postgres/1661785263936-guild-member-profiles.ts b/src/util/migrations/postgres/1661785263936-guild-member-profiles.ts deleted file mode 100644 index af0f2a33..00000000 --- a/src/util/migrations/postgres/1661785263936-guild-member-profiles.ts +++ /dev/null @@ -1,63 +0,0 @@ -import { MigrationInterface, QueryRunner } from "typeorm"; - -export class guildMemberProfiles1661785263936 implements MigrationInterface { - name = 'guildMemberProfiles1661785263936' - - public async up(queryRunner: QueryRunner): Promise { - await queryRunner.query(` - ALTER TABLE "connected_accounts" DROP COLUMN "external_id" - `); - await queryRunner.query(` - ALTER TABLE "connected_accounts" DROP COLUMN "integrations" - `); - await queryRunner.query(` - ALTER TABLE "members" - ADD "avatar" character varying - `); - await queryRunner.query(` - ALTER TABLE "members" - ADD "banner" character varying - `); - await queryRunner.query(` - ALTER TABLE "members" - ADD "bio" character varying NOT NULL - `); - await queryRunner.query(` - ALTER TABLE "members" - ADD "communication_disabled_until" TIMESTAMP - `); - await queryRunner.query(` - ALTER TABLE "connected_accounts" - ALTER COLUMN "access_token" - SET NOT NULL - `); - } - - public async down(queryRunner: QueryRunner): Promise { - await queryRunner.query(` - ALTER TABLE "connected_accounts" - ALTER COLUMN "access_token" DROP NOT NULL - `); - await queryRunner.query(` - ALTER TABLE "members" DROP COLUMN "communication_disabled_until" - `); - await queryRunner.query(` - ALTER TABLE "members" DROP COLUMN "bio" - `); - await queryRunner.query(` - ALTER TABLE "members" DROP COLUMN "banner" - `); - await queryRunner.query(` - ALTER TABLE "members" DROP COLUMN "avatar" - `); - await queryRunner.query(` - ALTER TABLE "connected_accounts" - ADD "integrations" text NOT NULL - `); - await queryRunner.query(` - ALTER TABLE "connected_accounts" - ADD "external_id" character varying NOT NULL - `); - } - -} diff --git a/src/util/migrations/postgres/1661885830688-guild-member-profiles.ts b/src/util/migrations/postgres/1661885830688-guild-member-profiles.ts new file mode 100644 index 00000000..b774743b --- /dev/null +++ b/src/util/migrations/postgres/1661885830688-guild-member-profiles.ts @@ -0,0 +1,40 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class guildMemberProfiles1661885830688 implements MigrationInterface { + name = 'guildMemberProfiles1661885830688' + + public async up(queryRunner: QueryRunner): Promise { + await queryRunner.query(` + ALTER TABLE "members" + ADD "avatar" character varying + `); + await queryRunner.query(` + ALTER TABLE "members" + ADD "banner" character varying + `); + await queryRunner.query(` + ALTER TABLE "members" + ADD "bio" character varying NOT NULL + `); + await queryRunner.query(` + ALTER TABLE "members" + ADD "communication_disabled_until" TIMESTAMP + `); + } + + public async down(queryRunner: QueryRunner): Promise { + await queryRunner.query(` + ALTER TABLE "members" DROP COLUMN "communication_disabled_until" + `); + await queryRunner.query(` + ALTER TABLE "members" DROP COLUMN "bio" + `); + await queryRunner.query(` + ALTER TABLE "members" DROP COLUMN "banner" + `); + await queryRunner.query(` + ALTER TABLE "members" DROP COLUMN "avatar" + `); + } + +} -- cgit 1.5.1