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"
- `);
- }
-
-}
|
