Add migrations

1 files changed, 246 insertions, 40 deletions

diff --git a/util/src/migrations/sqlite/1660110227241-modern_apps.ts b/util/src/migrations/sqlite/1660130536131-updated-applications.ts
index 34c0b4b2..b8cbcc33 100644
--- a/util/src/migrations/sqlite/1660110227241-modern_apps.ts
+++ b/util/src/migrations/sqlite/1660130536131-updated-applications.ts
@@ -1,7 +1,7 @@
 import { MigrationInterface, QueryRunner } from "typeorm";
 
-export class modernApps1660110227241 implements MigrationInterface {
-    name = 'modernApps1660110227241'
+export class updatedApplications1660130536131 implements MigrationInterface {
+    name = 'updatedApplications1660130536131'
 
     public async up(queryRunner: QueryRunner): Promise<void> {
         await queryRunner.query(`
@@ -152,19 +152,19 @@ export class modernApps1660110227241 implements MigrationInterface {
                 "flags" varchar NOT NULL,
                 "owner_id" varchar,
                 "team_id" varchar,
-                "type" text NOT NULL,
+                "type" text,
                 "hook" boolean NOT NULL,
-                "redirect_uris" text NOT NULL,
-                "rpc_application_state" integer NOT NULL,
-                "store_application_state" integer NOT NULL,
-                "verification_state" integer NOT NULL,
-                "interactions_endpoint_url" varchar NOT NULL,
-                "integration_public" boolean NOT NULL,
-                "integration_require_code_grant" boolean NOT NULL,
-                "discoverability_state" integer NOT NULL,
-                "discovery_eligibility_flags" integer NOT NULL,
-                "tags" text NOT NULL,
-                "install_params" text 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,
@@ -216,7 +216,7 @@ export class modernApps1660110227241 implements MigrationInterface {
                 "id" varchar PRIMARY KEY NOT NULL,
                 "name" varchar NOT NULL,
                 "icon" varchar,
-                "description" varchar NOT NULL,
+                "description" varchar,
                 "bot_public" boolean NOT NULL,
                 "bot_require_code_grant" boolean NOT NULL,
                 "terms_of_service_url" varchar,
@@ -224,22 +224,125 @@ export class modernApps1660110227241 implements MigrationInterface {
                 "summary" varchar,
                 "verify_key" varchar NOT NULL,
                 "cover_image" varchar,
-                "flags" varchar NOT NULL,
+                "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 NOT NULL,
+                "type" text,
                 "hook" boolean NOT NULL,
-                "redirect_uris" text NOT NULL,
-                "rpc_application_state" integer NOT NULL,
-                "store_application_state" integer NOT NULL,
-                "verification_state" integer NOT NULL,
-                "interactions_endpoint_url" varchar NOT NULL,
-                "integration_public" boolean NOT NULL,
-                "integration_require_code_grant" boolean NOT NULL,
-                "discoverability_state" integer NOT NULL,
-                "discovery_eligibility_flags" integer NOT NULL,
-                "tags" text NOT NULL,
-                "install_params" text 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,
@@ -327,6 +430,109 @@ export class modernApps1660110227241 implements MigrationInterface {
                 "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,
@@ -338,19 +544,19 @@ export class modernApps1660110227241 implements MigrationInterface {
                 "flags" varchar NOT NULL,
                 "owner_id" varchar,
                 "team_id" varchar,
-                "type" text NOT NULL,
+                "type" text,
                 "hook" boolean NOT NULL,
-                "redirect_uris" text NOT NULL,
-                "rpc_application_state" integer NOT NULL,
-                "store_application_state" integer NOT NULL,
-                "verification_state" integer NOT NULL,
-                "interactions_endpoint_url" varchar NOT NULL,
-                "integration_public" boolean NOT NULL,
-                "integration_require_code_grant" boolean NOT NULL,
-                "discoverability_state" integer NOT NULL,
-                "discovery_eligibility_flags" integer NOT NULL,
-                "tags" text NOT NULL,
-                "install_params" text 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,