Merge branch 'fosscord:staging' into Bug-Report-Template
1 files changed, 53 insertions, 54 deletions
diff --git a/src/util/migrations/postgres/1660130561959-updated-applications.ts b/src/util/migrations/postgres/1660130561959-updated-applications.ts
index 8fab54c7..3d47d6d3 100644
--- a/src/util/migrations/postgres/1660130561959-updated-applications.ts
+++ b/src/util/migrations/postgres/1660130561959-updated-applications.ts
@@ -1,182 +1,181 @@
import { MigrationInterface, QueryRunner } from "typeorm";
export class updatedApplications1660130561959 implements MigrationInterface {
- name = 'updatedApplications1660130561959'
+ name = "updatedApplications1660130561959";
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
+ public async up(queryRunner: QueryRunner): Promise<void> {
+ await queryRunner.query(`
ALTER TABLE "applications" DROP CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "rpc_origins"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "primary_sku_id"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "slug"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "guild_id"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "type" text
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "hook" boolean NOT NULL
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "redirect_uris" text
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "rpc_application_state" integer
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "store_application_state" integer
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "verification_state" integer
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "interactions_endpoint_url" character varying
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "integration_public" boolean
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "integration_require_code_grant" boolean
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "discoverability_state" integer
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "discovery_eligibility_flags" integer
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "tags" text
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "install_params" text
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "bot_user_id" character varying
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD CONSTRAINT "UQ_2ce5a55796fe4c2f77ece57a647" UNIQUE ("bot_user_id")
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ALTER COLUMN "description" DROP NOT NULL
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "flags"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "flags" integer NOT NULL
`);
- await queryRunner.query(`
+ 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(`
+ public async down(queryRunner: QueryRunner): Promise<void> {
+ await queryRunner.query(`
ALTER TABLE "applications" DROP CONSTRAINT "FK_2ce5a55796fe4c2f77ece57a647"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "flags"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "flags" character varying NOT NULL
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ALTER COLUMN "description"
SET NOT NULL
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP CONSTRAINT "UQ_2ce5a55796fe4c2f77ece57a647"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "bot_user_id"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "install_params"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "tags"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "discovery_eligibility_flags"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "discoverability_state"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "integration_require_code_grant"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "integration_public"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "interactions_endpoint_url"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "verification_state"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "store_application_state"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "rpc_application_state"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "redirect_uris"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "hook"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications" DROP COLUMN "type"
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "guild_id" character varying
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "slug" character varying
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "primary_sku_id" character varying
`);
- await queryRunner.query(`
+ await queryRunner.query(`
ALTER TABLE "applications"
ADD "rpc_origins" text
`);
- await queryRunner.query(`
+ 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
`);
- }
-
+ }
}
|