3 files changed, 6 insertions, 49 deletions
diff --git a/src/util/migrations/mariadb/1661785289467-guild-member-profiles.ts b/src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts
index 223876f9..6e1ac3f8 100644
--- a/src/util/migrations/mariadb/1661785289467-guild-member-profiles.ts
+++ b/src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts
@@ -1,16 +1,10 @@
import { MigrationInterface, QueryRunner } from "typeorm";
-export class guildMemberProfiles1661785289467 implements MigrationInterface {
- name = 'guildMemberProfiles1661785289467'
+export class guildMemberProfiles1661885910534 implements MigrationInterface {
+ name = 'guildMemberProfiles1661885910534'
public async up(queryRunner: QueryRunner): Promise<void> {
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\` varchar(255) NULL
`);
@@ -26,16 +20,10 @@ export class guildMemberProfiles1661785289467 implements MigrationInterface {
ALTER TABLE \`members\`
ADD \`communication_disabled_until\` datetime NULL
`);
- await queryRunner.query(`
- ALTER TABLE \`connected_accounts\` CHANGE \`access_token\` \`access_token\` varchar(255) NOT NULL
- `);
}
public async down(queryRunner: QueryRunner): Promise<void> {
await queryRunner.query(`
- ALTER TABLE \`connected_accounts\` CHANGE \`access_token\` \`access_token\` varchar(255) NULL
- `);
- await queryRunner.query(`
ALTER TABLE \`members\` DROP COLUMN \`communication_disabled_until\`
`);
await queryRunner.query(`
@@ -47,14 +35,6 @@ export class guildMemberProfiles1661785289467 implements MigrationInterface {
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\` varchar(255) NOT NULL
- `);
}
}
diff --git a/src/util/migrations/postgres/1661785263936-guild-member-profiles.ts b/src/util/migrations/postgres/1661885830688-guild-member-profiles.ts
index af0f2a33..b774743b 100644
--- a/src/util/migrations/postgres/1661785263936-guild-member-profiles.ts
+++ b/src/util/migrations/postgres/1661885830688-guild-member-profiles.ts
@@ -1,16 +1,10 @@
import { MigrationInterface, QueryRunner } from "typeorm";
-export class guildMemberProfiles1661785263936 implements MigrationInterface {
- name = 'guildMemberProfiles1661785263936'
+export class guildMemberProfiles1661885830688 implements MigrationInterface {
+ name = 'guildMemberProfiles1661885830688'
public async up(queryRunner: QueryRunner): Promise<void> {
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
`);
@@ -26,19 +20,10 @@ export class guildMemberProfiles1661785263936 implements MigrationInterface {
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<void> {
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(`
@@ -50,14 +35,6 @@ export class guildMemberProfiles1661785263936 implements MigrationInterface {
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/sqlite/1661785235464-guild-member-profiles.ts b/src/util/migrations/sqlite/1661885742207-guild-member-profiles.ts
index 9a3b648d..24ec9c72 100644
--- a/src/util/migrations/sqlite/1661785235464-guild-member-profiles.ts
+++ b/src/util/migrations/sqlite/1661885742207-guild-member-profiles.ts
@@ -1,7 +1,7 @@
import { MigrationInterface, QueryRunner } from "typeorm";
-export class guildMemberProfiles1661785235464 implements MigrationInterface {
- name = 'guildMemberProfiles1661785235464'
+export class guildMemberProfiles1661885742207 implements MigrationInterface {
+ name = 'guildMemberProfiles1661885742207'
public async up(queryRunner: QueryRunner): Promise<void> {
await queryRunner.query(`
|