diff --git a/util/src/migrations/mariadb/1660130586602-updated-applications.ts b/util/src/migrations/mariadb/1660130586602-updated-applications.ts
deleted file mode 100644
index ec574416..00000000
--- a/util/src/migrations/mariadb/1660130586602-updated-applications.ts
+++ /dev/null
@@ -1,185 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class updatedApplications1660130586602 implements MigrationInterface {
- name = 'updatedApplications1660130586602'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP FOREIGN KEY \`FK_e5bf78cdbbe9ba91062d74c5aba\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`rpc_origins\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`primary_sku_id\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`slug\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`guild_id\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`type\` text NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`hook\` tinyint NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`redirect_uris\` text NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`rpc_application_state\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`store_application_state\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`verification_state\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`interactions_endpoint_url\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`integration_public\` tinyint NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`integration_require_code_grant\` tinyint NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`discoverability_state\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`discovery_eligibility_flags\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`tags\` text NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`install_params\` text NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`bot_user_id\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD UNIQUE INDEX \`IDX_2ce5a55796fe4c2f77ece57a64\` (\`bot_user_id\`)
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` CHANGE \`description\` \`description\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`flags\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`flags\` int NOT NULL
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX \`REL_2ce5a55796fe4c2f77ece57a64\` ON \`applications\` (\`bot_user_id\`)
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD CONSTRAINT \`FK_2ce5a55796fe4c2f77ece57a647\` FOREIGN KEY (\`bot_user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP FOREIGN KEY \`FK_2ce5a55796fe4c2f77ece57a647\`
- `);
- await queryRunner.query(`
- DROP INDEX \`REL_2ce5a55796fe4c2f77ece57a64\` ON \`applications\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`flags\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`flags\` varchar(255) NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` CHANGE \`description\` \`description\` varchar(255) NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP INDEX \`IDX_2ce5a55796fe4c2f77ece57a64\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`bot_user_id\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`install_params\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`tags\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`discovery_eligibility_flags\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`discoverability_state\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`integration_require_code_grant\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`integration_public\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`interactions_endpoint_url\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`verification_state\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`store_application_state\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`rpc_application_state\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`redirect_uris\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`hook\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`type\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`guild_id\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`slug\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`primary_sku_id\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`rpc_origins\` text NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD CONSTRAINT \`FK_e5bf78cdbbe9ba91062d74c5aba\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- }
-
-}
diff --git a/util/src/migrations/mariadb/1660131942703-apps_nullable_team.ts b/util/src/migrations/mariadb/1660131942703-apps_nullable_team.ts
deleted file mode 100644
index ac445772..00000000
--- a/util/src/migrations/mariadb/1660131942703-apps_nullable_team.ts
+++ /dev/null
@@ -1,18 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class appsNullableTeam1660131942703 implements MigrationInterface {
- name = 'appsNullableTeam1660131942703'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- DROP INDEX \`IDX_2ce5a55796fe4c2f77ece57a64\` ON \`applications\`
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- CREATE UNIQUE INDEX \`IDX_2ce5a55796fe4c2f77ece57a64\` ON \`applications\` (\`bot_user_id\`)
- `);
- }
-
-}
diff --git a/util/src/migrations/mariadb/1660416072362-InvitersAreDeletable.ts b/util/src/migrations/mariadb/1660416072362-InvitersAreDeletable.ts
deleted file mode 100644
index 8374eafb..00000000
--- a/util/src/migrations/mariadb/1660416072362-InvitersAreDeletable.ts
+++ /dev/null
@@ -1,56 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class InvitersAreDeletable1660416072362 implements MigrationInterface {
- name = 'InvitersAreDeletable1660416072362'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`invites\` DROP FOREIGN KEY \`FK_15c35422032e0b22b4ada95f48f\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_76ba283779c8441fd5ff819c8c\` ON \`users\`
- `);
- await queryRunner.query(`
- CREATE TABLE \`plugin_config\` (
- \`key\` varchar(255) NOT NULL,
- \`value\` text NULL,
- PRIMARY KEY (\`key\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\`
- ADD \`flags\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\`
- ADD \`default_thread_rate_limit_per_user\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`invites\`
- ADD CONSTRAINT \`FK_15c35422032e0b22b4ada95f48f\` FOREIGN KEY (\`inviter_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`invites\` DROP FOREIGN KEY \`FK_15c35422032e0b22b4ada95f48f\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\` DROP COLUMN \`default_thread_rate_limit_per_user\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\` DROP COLUMN \`flags\`
- `);
- await queryRunner.query(`
- DROP TABLE \`plugin_config\`
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX \`IDX_76ba283779c8441fd5ff819c8c\` ON \`users\` (\`settingsId\`)
- `);
- await queryRunner.query(`
- ALTER TABLE \`invites\`
- ADD CONSTRAINT \`FK_15c35422032e0b22b4ada95f48f\` FOREIGN KEY (\`inviter_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- }
-
-}
diff --git a/util/src/migrations/postgres/1660130561959-updated-applications.ts b/util/src/migrations/postgres/1660130561959-updated-applications.ts
deleted file mode 100644
index 8fab54c7..00000000
--- a/util/src/migrations/postgres/1660130561959-updated-applications.ts
+++ /dev/null
@@ -1,182 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class updatedApplications1660130561959 implements MigrationInterface {
- name = 'updatedApplications1660130561959'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "applications" DROP CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "rpc_origins"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "primary_sku_id"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "slug"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "guild_id"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "type" text
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "hook" boolean NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "redirect_uris" text
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "rpc_application_state" integer
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "store_application_state" integer
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "verification_state" integer
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "interactions_endpoint_url" character varying
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "integration_public" boolean
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "integration_require_code_grant" boolean
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "discoverability_state" integer
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "discovery_eligibility_flags" integer
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "tags" text
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "install_params" text
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "bot_user_id" character varying
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD CONSTRAINT "UQ_2ce5a55796fe4c2f77ece57a647" UNIQUE ("bot_user_id")
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ALTER COLUMN "description" DROP NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "flags"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "flags" integer NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD CONSTRAINT "FK_2ce5a55796fe4c2f77ece57a647" FOREIGN KEY ("bot_user_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "applications" DROP CONSTRAINT "FK_2ce5a55796fe4c2f77ece57a647"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "flags"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "flags" character varying NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ALTER COLUMN "description"
- SET NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP CONSTRAINT "UQ_2ce5a55796fe4c2f77ece57a647"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "bot_user_id"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "install_params"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "tags"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "discovery_eligibility_flags"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "discoverability_state"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "integration_require_code_grant"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "integration_public"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "interactions_endpoint_url"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "verification_state"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "store_application_state"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "rpc_application_state"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "redirect_uris"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "hook"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP COLUMN "type"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "guild_id" character varying
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "slug" character varying
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "primary_sku_id" character varying
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD "rpc_origins" text
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- }
-
-}
diff --git a/util/src/migrations/postgres/1660416055566-InvitersAreDeletable.ts b/util/src/migrations/postgres/1660416055566-InvitersAreDeletable.ts
deleted file mode 100644
index e6101318..00000000
--- a/util/src/migrations/postgres/1660416055566-InvitersAreDeletable.ts
+++ /dev/null
@@ -1,26 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class InvitersAreDeletable1660416055566 implements MigrationInterface {
- name = 'InvitersAreDeletable1660416055566'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "invites" DROP CONSTRAINT "FK_15c35422032e0b22b4ada95f48f"
- `);
- await queryRunner.query(`
- ALTER TABLE "invites"
- ADD CONSTRAINT "FK_15c35422032e0b22b4ada95f48f" FOREIGN KEY ("inviter_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "invites" DROP CONSTRAINT "FK_15c35422032e0b22b4ada95f48f"
- `);
- await queryRunner.query(`
- ALTER TABLE "invites"
- ADD CONSTRAINT "FK_15c35422032e0b22b4ada95f48f" FOREIGN KEY ("inviter_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- }
-
-}
diff --git a/util/src/migrations/sqlite/1660130536131-updated-applications.ts b/util/src/migrations/sqlite/1660130536131-updated-applications.ts
deleted file mode 100644
index b8cbcc33..00000000
--- a/util/src/migrations/sqlite/1660130536131-updated-applications.ts
+++ /dev/null
@@ -1,829 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class updatedApplications1660130536131 implements MigrationInterface {
- name = 'updatedApplications1660130536131'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- CREATE TABLE "temporary_applications" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "icon" varchar,
- "description" varchar NOT NULL,
- "rpc_origins" text,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" varchar,
- "privacy_policy_url" varchar,
- "summary" varchar,
- "verify_key" varchar NOT NULL,
- "primary_sku_id" varchar,
- "slug" varchar,
- "cover_image" varchar,
- "flags" varchar NOT NULL,
- "owner_id" varchar,
- "team_id" varchar,
- "guild_id" varchar,
- CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_applications"(
- "id",
- "name",
- "icon",
- "description",
- "rpc_origins",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "primary_sku_id",
- "slug",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "guild_id"
- )
- SELECT "id",
- "name",
- "icon",
- "description",
- "rpc_origins",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "primary_sku_id",
- "slug",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "guild_id"
- FROM "applications"
- `);
- await queryRunner.query(`
- DROP TABLE "applications"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_applications"
- RENAME TO "applications"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_applications" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "icon" varchar,
- "description" varchar NOT NULL,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" varchar,
- "privacy_policy_url" varchar,
- "summary" varchar,
- "verify_key" varchar NOT NULL,
- "cover_image" varchar,
- "flags" varchar NOT NULL,
- "owner_id" varchar,
- "team_id" varchar,
- CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_applications"(
- "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id"
- )
- SELECT "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id"
- FROM "applications"
- `);
- await queryRunner.query(`
- DROP TABLE "applications"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_applications"
- RENAME TO "applications"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_applications" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "icon" varchar,
- "description" varchar NOT NULL,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" varchar,
- "privacy_policy_url" varchar,
- "summary" varchar,
- "verify_key" varchar NOT NULL,
- "cover_image" varchar,
- "flags" varchar NOT NULL,
- "owner_id" varchar,
- "team_id" varchar,
- "type" text,
- "hook" boolean NOT NULL,
- "redirect_uris" text,
- "rpc_application_state" integer,
- "store_application_state" integer,
- "verification_state" integer,
- "interactions_endpoint_url" varchar,
- "integration_public" boolean,
- "integration_require_code_grant" boolean,
- "discoverability_state" integer,
- "discovery_eligibility_flags" integer,
- "tags" text,
- "install_params" text,
- "bot_user_id" varchar,
- CONSTRAINT "UQ_b7f6e13565e920916d902e1f431" UNIQUE ("bot_user_id"),
- CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_applications"(
- "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id"
- )
- SELECT "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id"
- FROM "applications"
- `);
- await queryRunner.query(`
- DROP TABLE "applications"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_applications"
- RENAME TO "applications"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_applications" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "icon" varchar,
- "description" varchar,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" varchar,
- "privacy_policy_url" varchar,
- "summary" varchar,
- "verify_key" varchar NOT NULL,
- "cover_image" varchar,
- "flags" integer NOT NULL,
- "owner_id" varchar,
- "team_id" varchar,
- "type" text,
- "hook" boolean NOT NULL,
- "redirect_uris" text,
- "rpc_application_state" integer,
- "store_application_state" integer,
- "verification_state" integer,
- "interactions_endpoint_url" varchar,
- "integration_public" boolean,
- "integration_require_code_grant" boolean,
- "discoverability_state" integer,
- "discovery_eligibility_flags" integer,
- "tags" text,
- "install_params" text,
- "bot_user_id" varchar,
- CONSTRAINT "UQ_b7f6e13565e920916d902e1f431" UNIQUE ("bot_user_id"),
- CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_applications"(
- "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "type",
- "hook",
- "redirect_uris",
- "rpc_application_state",
- "store_application_state",
- "verification_state",
- "interactions_endpoint_url",
- "integration_public",
- "integration_require_code_grant",
- "discoverability_state",
- "discovery_eligibility_flags",
- "tags",
- "install_params",
- "bot_user_id"
- )
- SELECT "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "type",
- "hook",
- "redirect_uris",
- "rpc_application_state",
- "store_application_state",
- "verification_state",
- "interactions_endpoint_url",
- "integration_public",
- "integration_require_code_grant",
- "discoverability_state",
- "discovery_eligibility_flags",
- "tags",
- "install_params",
- "bot_user_id"
- FROM "applications"
- `);
- await queryRunner.query(`
- DROP TABLE "applications"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_applications"
- RENAME TO "applications"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_applications" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "icon" varchar,
- "description" varchar,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" varchar,
- "privacy_policy_url" varchar,
- "summary" varchar,
- "verify_key" varchar NOT NULL,
- "cover_image" varchar,
- "flags" integer NOT NULL,
- "owner_id" varchar,
- "team_id" varchar,
- "type" text,
- "hook" boolean NOT NULL,
- "redirect_uris" text,
- "rpc_application_state" integer,
- "store_application_state" integer,
- "verification_state" integer,
- "interactions_endpoint_url" varchar,
- "integration_public" boolean,
- "integration_require_code_grant" boolean,
- "discoverability_state" integer,
- "discovery_eligibility_flags" integer,
- "tags" text,
- "install_params" text,
- "bot_user_id" varchar,
- CONSTRAINT "UQ_b7f6e13565e920916d902e1f431" UNIQUE ("bot_user_id"),
- CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT "FK_2ce5a55796fe4c2f77ece57a647" FOREIGN KEY ("bot_user_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_applications"(
- "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "type",
- "hook",
- "redirect_uris",
- "rpc_application_state",
- "store_application_state",
- "verification_state",
- "interactions_endpoint_url",
- "integration_public",
- "integration_require_code_grant",
- "discoverability_state",
- "discovery_eligibility_flags",
- "tags",
- "install_params",
- "bot_user_id"
- )
- SELECT "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "type",
- "hook",
- "redirect_uris",
- "rpc_application_state",
- "store_application_state",
- "verification_state",
- "interactions_endpoint_url",
- "integration_public",
- "integration_require_code_grant",
- "discoverability_state",
- "discovery_eligibility_flags",
- "tags",
- "install_params",
- "bot_user_id"
- FROM "applications"
- `);
- await queryRunner.query(`
- DROP TABLE "applications"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_applications"
- RENAME TO "applications"
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "applications"
- RENAME TO "temporary_applications"
- `);
- await queryRunner.query(`
- CREATE TABLE "applications" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "icon" varchar,
- "description" varchar,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" varchar,
- "privacy_policy_url" varchar,
- "summary" varchar,
- "verify_key" varchar NOT NULL,
- "cover_image" varchar,
- "flags" integer NOT NULL,
- "owner_id" varchar,
- "team_id" varchar,
- "type" text,
- "hook" boolean NOT NULL,
- "redirect_uris" text,
- "rpc_application_state" integer,
- "store_application_state" integer,
- "verification_state" integer,
- "interactions_endpoint_url" varchar,
- "integration_public" boolean,
- "integration_require_code_grant" boolean,
- "discoverability_state" integer,
- "discovery_eligibility_flags" integer,
- "tags" text,
- "install_params" text,
- "bot_user_id" varchar,
- CONSTRAINT "UQ_b7f6e13565e920916d902e1f431" UNIQUE ("bot_user_id"),
- CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "applications"(
- "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "type",
- "hook",
- "redirect_uris",
- "rpc_application_state",
- "store_application_state",
- "verification_state",
- "interactions_endpoint_url",
- "integration_public",
- "integration_require_code_grant",
- "discoverability_state",
- "discovery_eligibility_flags",
- "tags",
- "install_params",
- "bot_user_id"
- )
- SELECT "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "type",
- "hook",
- "redirect_uris",
- "rpc_application_state",
- "store_application_state",
- "verification_state",
- "interactions_endpoint_url",
- "integration_public",
- "integration_require_code_grant",
- "discoverability_state",
- "discovery_eligibility_flags",
- "tags",
- "install_params",
- "bot_user_id"
- FROM "temporary_applications"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_applications"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- RENAME TO "temporary_applications"
- `);
- await queryRunner.query(`
- CREATE TABLE "applications" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "icon" varchar,
- "description" varchar NOT NULL,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" varchar,
- "privacy_policy_url" varchar,
- "summary" varchar,
- "verify_key" varchar NOT NULL,
- "cover_image" varchar,
- "flags" varchar NOT NULL,
- "owner_id" varchar,
- "team_id" varchar,
- "type" text,
- "hook" boolean NOT NULL,
- "redirect_uris" text,
- "rpc_application_state" integer,
- "store_application_state" integer,
- "verification_state" integer,
- "interactions_endpoint_url" varchar,
- "integration_public" boolean,
- "integration_require_code_grant" boolean,
- "discoverability_state" integer,
- "discovery_eligibility_flags" integer,
- "tags" text,
- "install_params" text,
- "bot_user_id" varchar,
- CONSTRAINT "UQ_b7f6e13565e920916d902e1f431" UNIQUE ("bot_user_id"),
- CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "applications"(
- "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "type",
- "hook",
- "redirect_uris",
- "rpc_application_state",
- "store_application_state",
- "verification_state",
- "interactions_endpoint_url",
- "integration_public",
- "integration_require_code_grant",
- "discoverability_state",
- "discovery_eligibility_flags",
- "tags",
- "install_params",
- "bot_user_id"
- )
- SELECT "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "type",
- "hook",
- "redirect_uris",
- "rpc_application_state",
- "store_application_state",
- "verification_state",
- "interactions_endpoint_url",
- "integration_public",
- "integration_require_code_grant",
- "discoverability_state",
- "discovery_eligibility_flags",
- "tags",
- "install_params",
- "bot_user_id"
- FROM "temporary_applications"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_applications"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- RENAME TO "temporary_applications"
- `);
- await queryRunner.query(`
- CREATE TABLE "applications" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "icon" varchar,
- "description" varchar NOT NULL,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" varchar,
- "privacy_policy_url" varchar,
- "summary" varchar,
- "verify_key" varchar NOT NULL,
- "cover_image" varchar,
- "flags" varchar NOT NULL,
- "owner_id" varchar,
- "team_id" varchar,
- CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "applications"(
- "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id"
- )
- SELECT "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id"
- FROM "temporary_applications"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_applications"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- RENAME TO "temporary_applications"
- `);
- await queryRunner.query(`
- CREATE TABLE "applications" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "icon" varchar,
- "description" varchar NOT NULL,
- "rpc_origins" text,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" varchar,
- "privacy_policy_url" varchar,
- "summary" varchar,
- "verify_key" varchar NOT NULL,
- "primary_sku_id" varchar,
- "slug" varchar,
- "cover_image" varchar,
- "flags" varchar NOT NULL,
- "owner_id" varchar,
- "team_id" varchar,
- "guild_id" varchar,
- CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "applications"(
- "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id"
- )
- SELECT "id",
- "name",
- "icon",
- "description",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "cover_image",
- "flags",
- "owner_id",
- "team_id"
- FROM "temporary_applications"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_applications"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- RENAME TO "temporary_applications"
- `);
- await queryRunner.query(`
- CREATE TABLE "applications" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "icon" varchar,
- "description" varchar NOT NULL,
- "rpc_origins" text,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" varchar,
- "privacy_policy_url" varchar,
- "summary" varchar,
- "verify_key" varchar NOT NULL,
- "primary_sku_id" varchar,
- "slug" varchar,
- "cover_image" varchar,
- "flags" varchar NOT NULL,
- "owner_id" varchar,
- "team_id" varchar,
- "guild_id" varchar,
- CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "applications"(
- "id",
- "name",
- "icon",
- "description",
- "rpc_origins",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "primary_sku_id",
- "slug",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "guild_id"
- )
- SELECT "id",
- "name",
- "icon",
- "description",
- "rpc_origins",
- "bot_public",
- "bot_require_code_grant",
- "terms_of_service_url",
- "privacy_policy_url",
- "summary",
- "verify_key",
- "primary_sku_id",
- "slug",
- "cover_image",
- "flags",
- "owner_id",
- "team_id",
- "guild_id"
- FROM "temporary_applications"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_applications"
- `);
- }
-
-}
diff --git a/util/src/migrations/sqlite/1660416010862-InvitersAreDeletable.ts b/util/src/migrations/sqlite/1660416010862-InvitersAreDeletable.ts
deleted file mode 100644
index 9b29e119..00000000
--- a/util/src/migrations/sqlite/1660416010862-InvitersAreDeletable.ts
+++ /dev/null
@@ -1,246 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class InvitersAreDeletable1660416010862 implements MigrationInterface {
- name = 'InvitersAreDeletable1660416010862'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- CREATE TABLE "temporary_invites" (
- "code" varchar PRIMARY KEY NOT NULL,
- "temporary" boolean NOT NULL,
- "uses" integer NOT NULL,
- "max_uses" integer NOT NULL,
- "max_age" integer NOT NULL,
- "created_at" datetime NOT NULL,
- "expires_at" datetime NOT NULL,
- "guild_id" varchar,
- "channel_id" varchar,
- "inviter_id" varchar,
- "target_user_id" varchar,
- "target_user_type" integer,
- "vanity_url" boolean,
- CONSTRAINT "FK_11a0d394f8fc649c19ce5f16b59" FOREIGN KEY ("target_user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_6a15b051fe5050aa00a4b9ff0f6" FOREIGN KEY ("channel_id") REFERENCES "channels" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_3f4939aa1461e8af57fea3fb05d" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_invites"(
- "code",
- "temporary",
- "uses",
- "max_uses",
- "max_age",
- "created_at",
- "expires_at",
- "guild_id",
- "channel_id",
- "inviter_id",
- "target_user_id",
- "target_user_type",
- "vanity_url"
- )
- SELECT "code",
- "temporary",
- "uses",
- "max_uses",
- "max_age",
- "created_at",
- "expires_at",
- "guild_id",
- "channel_id",
- "inviter_id",
- "target_user_id",
- "target_user_type",
- "vanity_url"
- FROM "invites"
- `);
- await queryRunner.query(`
- DROP TABLE "invites"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_invites"
- RENAME TO "invites"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_invites" (
- "code" varchar PRIMARY KEY NOT NULL,
- "temporary" boolean NOT NULL,
- "uses" integer NOT NULL,
- "max_uses" integer NOT NULL,
- "max_age" integer NOT NULL,
- "created_at" datetime NOT NULL,
- "expires_at" datetime NOT NULL,
- "guild_id" varchar,
- "channel_id" varchar,
- "inviter_id" varchar,
- "target_user_id" varchar,
- "target_user_type" integer,
- "vanity_url" boolean,
- CONSTRAINT "FK_11a0d394f8fc649c19ce5f16b59" FOREIGN KEY ("target_user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_6a15b051fe5050aa00a4b9ff0f6" FOREIGN KEY ("channel_id") REFERENCES "channels" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_3f4939aa1461e8af57fea3fb05d" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_15c35422032e0b22b4ada95f48f" FOREIGN KEY ("inviter_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_invites"(
- "code",
- "temporary",
- "uses",
- "max_uses",
- "max_age",
- "created_at",
- "expires_at",
- "guild_id",
- "channel_id",
- "inviter_id",
- "target_user_id",
- "target_user_type",
- "vanity_url"
- )
- SELECT "code",
- "temporary",
- "uses",
- "max_uses",
- "max_age",
- "created_at",
- "expires_at",
- "guild_id",
- "channel_id",
- "inviter_id",
- "target_user_id",
- "target_user_type",
- "vanity_url"
- FROM "invites"
- `);
- await queryRunner.query(`
- DROP TABLE "invites"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_invites"
- RENAME TO "invites"
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "invites"
- RENAME TO "temporary_invites"
- `);
- await queryRunner.query(`
- CREATE TABLE "invites" (
- "code" varchar PRIMARY KEY NOT NULL,
- "temporary" boolean NOT NULL,
- "uses" integer NOT NULL,
- "max_uses" integer NOT NULL,
- "max_age" integer NOT NULL,
- "created_at" datetime NOT NULL,
- "expires_at" datetime NOT NULL,
- "guild_id" varchar,
- "channel_id" varchar,
- "inviter_id" varchar,
- "target_user_id" varchar,
- "target_user_type" integer,
- "vanity_url" boolean,
- CONSTRAINT "FK_11a0d394f8fc649c19ce5f16b59" FOREIGN KEY ("target_user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_6a15b051fe5050aa00a4b9ff0f6" FOREIGN KEY ("channel_id") REFERENCES "channels" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_3f4939aa1461e8af57fea3fb05d" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "invites"(
- "code",
- "temporary",
- "uses",
- "max_uses",
- "max_age",
- "created_at",
- "expires_at",
- "guild_id",
- "channel_id",
- "inviter_id",
- "target_user_id",
- "target_user_type",
- "vanity_url"
- )
- SELECT "code",
- "temporary",
- "uses",
- "max_uses",
- "max_age",
- "created_at",
- "expires_at",
- "guild_id",
- "channel_id",
- "inviter_id",
- "target_user_id",
- "target_user_type",
- "vanity_url"
- FROM "temporary_invites"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_invites"
- `);
- await queryRunner.query(`
- ALTER TABLE "invites"
- RENAME TO "temporary_invites"
- `);
- await queryRunner.query(`
- CREATE TABLE "invites" (
- "code" varchar PRIMARY KEY NOT NULL,
- "temporary" boolean NOT NULL,
- "uses" integer NOT NULL,
- "max_uses" integer NOT NULL,
- "max_age" integer NOT NULL,
- "created_at" datetime NOT NULL,
- "expires_at" datetime NOT NULL,
- "guild_id" varchar,
- "channel_id" varchar,
- "inviter_id" varchar,
- "target_user_id" varchar,
- "target_user_type" integer,
- "vanity_url" boolean,
- CONSTRAINT "FK_11a0d394f8fc649c19ce5f16b59" FOREIGN KEY ("target_user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_15c35422032e0b22b4ada95f48f" FOREIGN KEY ("inviter_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT "FK_6a15b051fe5050aa00a4b9ff0f6" FOREIGN KEY ("channel_id") REFERENCES "channels" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_3f4939aa1461e8af57fea3fb05d" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "invites"(
- "code",
- "temporary",
- "uses",
- "max_uses",
- "max_age",
- "created_at",
- "expires_at",
- "guild_id",
- "channel_id",
- "inviter_id",
- "target_user_id",
- "target_user_type",
- "vanity_url"
- )
- SELECT "code",
- "temporary",
- "uses",
- "max_uses",
- "max_age",
- "created_at",
- "expires_at",
- "guild_id",
- "channel_id",
- "inviter_id",
- "target_user_id",
- "target_user_type",
- "vanity_url"
- FROM "temporary_invites"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_invites"
- `);
- }
-
-}
|
