From a4e7b9aa3422da873d22d0c80a79b1bbb530e31d Mon Sep 17 00:00:00 2001 From: Puyodead1 Date: Tue, 30 Aug 2022 15:00:23 -0400 Subject: regenerate migrations --- .../mariadb/1661785289467-guild-member-profiles.ts | 60 --------- .../mariadb/1661885910534-guild-member-profiles.ts | 40 ++++++ .../1661785263936-guild-member-profiles.ts | 63 ---------- .../1661885830688-guild-member-profiles.ts | 40 ++++++ .../sqlite/1661785235464-guild-member-profiles.ts | 136 --------------------- .../sqlite/1661885742207-guild-member-profiles.ts | 136 +++++++++++++++++++++ 6 files changed, 216 insertions(+), 259 deletions(-) delete mode 100644 src/util/migrations/mariadb/1661785289467-guild-member-profiles.ts create mode 100644 src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts delete mode 100644 src/util/migrations/postgres/1661785263936-guild-member-profiles.ts create mode 100644 src/util/migrations/postgres/1661885830688-guild-member-profiles.ts delete mode 100644 src/util/migrations/sqlite/1661785235464-guild-member-profiles.ts create mode 100644 src/util/migrations/sqlite/1661885742207-guild-member-profiles.ts diff --git a/src/util/migrations/mariadb/1661785289467-guild-member-profiles.ts b/src/util/migrations/mariadb/1661785289467-guild-member-profiles.ts deleted file mode 100644 index 223876f9..00000000 --- a/src/util/migrations/mariadb/1661785289467-guild-member-profiles.ts +++ /dev/null @@ -1,60 +0,0 @@ -import { MigrationInterface, QueryRunner } from "typeorm"; - -export class guildMemberProfiles1661785289467 implements MigrationInterface { - name = 'guildMemberProfiles1661785289467' - - 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\` varchar(255) NULL - `); - await queryRunner.query(` - ALTER TABLE \`members\` - ADD \`banner\` varchar(255) NULL - `); - await queryRunner.query(` - ALTER TABLE \`members\` - ADD \`bio\` varchar(255) NOT NULL - `); - await queryRunner.query(` - 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 { - 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(` - 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\` varchar(255) NOT NULL - `); - } - -} diff --git a/src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts b/src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts new file mode 100644 index 00000000..6e1ac3f8 --- /dev/null +++ b/src/util/migrations/mariadb/1661885910534-guild-member-profiles.ts @@ -0,0 +1,40 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class guildMemberProfiles1661885910534 implements MigrationInterface { + name = 'guildMemberProfiles1661885910534' + + public async up(queryRunner: QueryRunner): Promise { + await queryRunner.query(` + ALTER TABLE \`members\` + ADD \`avatar\` varchar(255) NULL + `); + await queryRunner.query(` + ALTER TABLE \`members\` + ADD \`banner\` varchar(255) NULL + `); + await queryRunner.query(` + ALTER TABLE \`members\` + ADD \`bio\` varchar(255) NOT NULL + `); + await queryRunner.query(` + ALTER TABLE \`members\` + ADD \`communication_disabled_until\` datetime NULL + `); + } + + 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\` + `); + } + +} 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" + `); + } + +} diff --git a/src/util/migrations/sqlite/1661785235464-guild-member-profiles.ts b/src/util/migrations/sqlite/1661785235464-guild-member-profiles.ts deleted file mode 100644 index 9a3b648d..00000000 --- a/src/util/migrations/sqlite/1661785235464-guild-member-profiles.ts +++ /dev/null @@ -1,136 +0,0 @@ -import { MigrationInterface, QueryRunner } from "typeorm"; - -export class guildMemberProfiles1661785235464 implements MigrationInterface { - name = 'guildMemberProfiles1661785235464' - - public async up(queryRunner: QueryRunner): Promise { - await queryRunner.query(` - DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" - `); - await queryRunner.query(` - CREATE TABLE "temporary_members" ( - "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL, - "id" varchar NOT NULL, - "guild_id" varchar NOT NULL, - "nick" varchar, - "joined_at" datetime NOT NULL, - "premium_since" datetime, - "deaf" boolean NOT NULL, - "mute" boolean NOT NULL, - "pending" boolean NOT NULL, - "settings" text NOT NULL, - "last_message_id" varchar, - "joined_by" varchar, - "avatar" varchar, - "banner" varchar, - "bio" varchar NOT NULL, - "communication_disabled_until" datetime, - CONSTRAINT "FK_28b53062261b996d9c99fa12404" FOREIGN KEY ("id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION, - CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION - ) - `); - await queryRunner.query(` - INSERT INTO "temporary_members"( - "index", - "id", - "guild_id", - "nick", - "joined_at", - "premium_since", - "deaf", - "mute", - "pending", - "settings", - "last_message_id", - "joined_by" - ) - SELECT "index", - "id", - "guild_id", - "nick", - "joined_at", - "premium_since", - "deaf", - "mute", - "pending", - "settings", - "last_message_id", - "joined_by" - FROM "members" - `); - await queryRunner.query(` - DROP TABLE "members" - `); - await queryRunner.query(` - ALTER TABLE "temporary_members" - RENAME TO "members" - `); - await queryRunner.query(` - CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id") - `); - } - - public async down(queryRunner: QueryRunner): Promise { - await queryRunner.query(` - DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" - `); - await queryRunner.query(` - ALTER TABLE "members" - RENAME TO "temporary_members" - `); - await queryRunner.query(` - CREATE TABLE "members" ( - "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL, - "id" varchar NOT NULL, - "guild_id" varchar NOT NULL, - "nick" varchar, - "joined_at" datetime NOT NULL, - "premium_since" datetime, - "deaf" boolean NOT NULL, - "mute" boolean NOT NULL, - "pending" boolean NOT NULL, - "settings" text NOT NULL, - "last_message_id" varchar, - "joined_by" varchar, - CONSTRAINT "FK_28b53062261b996d9c99fa12404" FOREIGN KEY ("id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION, - CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION - ) - `); - await queryRunner.query(` - INSERT INTO "members"( - "index", - "id", - "guild_id", - "nick", - "joined_at", - "premium_since", - "deaf", - "mute", - "pending", - "settings", - "last_message_id", - "joined_by" - ) - SELECT "index", - "id", - "guild_id", - "nick", - "joined_at", - "premium_since", - "deaf", - "mute", - "pending", - "settings", - "last_message_id", - "joined_by" - FROM "temporary_members" - `); - await queryRunner.query(` - DROP TABLE "temporary_members" - `); - await queryRunner.query(` - CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id") - `); - } - -} diff --git a/src/util/migrations/sqlite/1661885742207-guild-member-profiles.ts b/src/util/migrations/sqlite/1661885742207-guild-member-profiles.ts new file mode 100644 index 00000000..24ec9c72 --- /dev/null +++ b/src/util/migrations/sqlite/1661885742207-guild-member-profiles.ts @@ -0,0 +1,136 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class guildMemberProfiles1661885742207 implements MigrationInterface { + name = 'guildMemberProfiles1661885742207' + + public async up(queryRunner: QueryRunner): Promise { + await queryRunner.query(` + DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" + `); + await queryRunner.query(` + CREATE TABLE "temporary_members" ( + "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL, + "id" varchar NOT NULL, + "guild_id" varchar NOT NULL, + "nick" varchar, + "joined_at" datetime NOT NULL, + "premium_since" datetime, + "deaf" boolean NOT NULL, + "mute" boolean NOT NULL, + "pending" boolean NOT NULL, + "settings" text NOT NULL, + "last_message_id" varchar, + "joined_by" varchar, + "avatar" varchar, + "banner" varchar, + "bio" varchar NOT NULL, + "communication_disabled_until" datetime, + CONSTRAINT "FK_28b53062261b996d9c99fa12404" FOREIGN KEY ("id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION, + CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION + ) + `); + await queryRunner.query(` + INSERT INTO "temporary_members"( + "index", + "id", + "guild_id", + "nick", + "joined_at", + "premium_since", + "deaf", + "mute", + "pending", + "settings", + "last_message_id", + "joined_by" + ) + SELECT "index", + "id", + "guild_id", + "nick", + "joined_at", + "premium_since", + "deaf", + "mute", + "pending", + "settings", + "last_message_id", + "joined_by" + FROM "members" + `); + await queryRunner.query(` + DROP TABLE "members" + `); + await queryRunner.query(` + ALTER TABLE "temporary_members" + RENAME TO "members" + `); + await queryRunner.query(` + CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id") + `); + } + + public async down(queryRunner: QueryRunner): Promise { + await queryRunner.query(` + DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" + `); + await queryRunner.query(` + ALTER TABLE "members" + RENAME TO "temporary_members" + `); + await queryRunner.query(` + CREATE TABLE "members" ( + "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL, + "id" varchar NOT NULL, + "guild_id" varchar NOT NULL, + "nick" varchar, + "joined_at" datetime NOT NULL, + "premium_since" datetime, + "deaf" boolean NOT NULL, + "mute" boolean NOT NULL, + "pending" boolean NOT NULL, + "settings" text NOT NULL, + "last_message_id" varchar, + "joined_by" varchar, + CONSTRAINT "FK_28b53062261b996d9c99fa12404" FOREIGN KEY ("id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION, + CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION + ) + `); + await queryRunner.query(` + INSERT INTO "members"( + "index", + "id", + "guild_id", + "nick", + "joined_at", + "premium_since", + "deaf", + "mute", + "pending", + "settings", + "last_message_id", + "joined_by" + ) + SELECT "index", + "id", + "guild_id", + "nick", + "joined_at", + "premium_since", + "deaf", + "mute", + "pending", + "settings", + "last_message_id", + "joined_by" + FROM "temporary_members" + `); + await queryRunner.query(` + DROP TABLE "temporary_members" + `); + await queryRunner.query(` + CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id") + `); + } + +} -- cgit 1.4.1