diff --git a/src/util/migration/postgres/1760622755598-ApplicationCommands.ts b/src/util/migration/postgres/1760622755598-ApplicationCommands.ts
new file mode 100644
index 000000000..f1a107375
--- /dev/null
+++ b/src/util/migration/postgres/1760622755598-ApplicationCommands.ts
@@ -0,0 +1,14 @@
+import { MigrationInterface, QueryRunner } from "typeorm";
+
+export class ApplicationCommands1760622755598 implements MigrationInterface {
+ name = 'ApplicationCommands1760622755598'
+
+ public async up(queryRunner: QueryRunner): Promise<void> {
+ await queryRunner.query(`CREATE TABLE "application_commands" ("id" character varying NOT NULL, "type" integer NOT NULL DEFAULT '1', "application_id" character varying NOT NULL, "guild_id" character varying, "name" character varying NOT NULL, "name_localizations" text, "description" character varying NOT NULL, "description_localizations" text, "options" text, "default_member_permissions" character varying, "dm_permission" boolean NOT NULL DEFAULT true, "permissions" text, "nsfw" boolean NOT NULL DEFAULT false, "integration_types" text, "global_popularity_rank" integer NOT NULL DEFAULT '0', "contexts" text, "version" character varying NOT NULL DEFAULT '0', "handler" integer NOT NULL DEFAULT '0', CONSTRAINT "PK_0f73c2f025989c407947e1f75fe" PRIMARY KEY ("id"))`);
+ }
+
+ public async down(queryRunner: QueryRunner): Promise<void> {
+ await queryRunner.query(`DROP TABLE "application_commands"`);
+ }
+
+}
diff --git a/src/util/migration/postgres/1760622755599-ReconcileMigrationAttempts.ts b/src/util/migration/postgres/1760622755599-ReconcileMigrationAttempts.ts
new file mode 100644
index 000000000..0138817d5
--- /dev/null
+++ b/src/util/migration/postgres/1760622755599-ReconcileMigrationAttempts.ts
@@ -0,0 +1,74 @@
+// import { MigrationInterface, QueryRunner } from "typeorm";
+//
+// export class ApplicationCommands1760622755598 implements MigrationInterface {
+// name = 'ApplicationCommands1760622755598'
+//
+// public async up(queryRunner: QueryRunner): Promise<void> {
+// await queryRunner.query(`ALTER TABLE "webhooks" DROP CONSTRAINT "fk_d64f38834fa676f6caa4786ddd6"`);
+// await queryRunner.query(`ALTER TABLE "webhooks" DROP COLUMN "source_channel_id"`);
+// await queryRunner.query(`ALTER TABLE "webhooks" ADD "source_channel_id" character varying`);
+// await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "username"`);
+// await queryRunner.query(`ALTER TABLE "messages" ADD "username" character varying`);
+// await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "avatar"`);
+// await queryRunner.query(`ALTER TABLE "messages" ADD "avatar" character varying`);
+// await queryRunner.query(`ALTER TABLE "channels" ALTER COLUMN "default_thread_rate_limit_per_user" DROP NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "client_status" SET NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "friend_discovery_flags" DROP DEFAULT`);
+// await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "view_nsfw_guilds" DROP DEFAULT`);
+// await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "flags"`);
+// await queryRunner.query(`ALTER TABLE "users" ADD "flags" integer NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "public_flags"`);
+// await queryRunner.query(`ALTER TABLE "users" ADD "public_flags" integer NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "purchased_flags"`);
+// await queryRunner.query(`ALTER TABLE "users" ADD "purchased_flags" integer NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "team_members" DROP COLUMN "role"`);
+// await queryRunner.query(`ALTER TABLE "team_members" ADD "role" character varying NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "applications" DROP COLUMN "guild_id"`);
+// await queryRunner.query(`ALTER TABLE "applications" ADD "guild_id" character varying`);
+// await queryRunner.query(`ALTER TABLE "applications" DROP COLUMN "custom_install_url"`);
+// await queryRunner.query(`ALTER TABLE "applications" ADD "custom_install_url" character varying`);
+// await queryRunner.query(`ALTER TABLE "categories" DROP COLUMN "icon"`);
+// await queryRunner.query(`ALTER TABLE "categories" ADD "icon" character varying`);
+// await queryRunner.query(`ALTER TABLE "user_settings_protos" DROP COLUMN "userSettings"`);
+// await queryRunner.query(`ALTER TABLE "user_settings_protos" ADD "userSettings" character varying`);
+// await queryRunner.query(`ALTER TABLE "user_settings_protos" DROP COLUMN "frecencySettings"`);
+// await queryRunner.query(`ALTER TABLE "user_settings_protos" ADD "frecencySettings" character varying`);
+// await queryRunner.query(`ALTER TABLE "webhooks" ADD CONSTRAINT "FK_4495b7032a33c6b8b605d030398" FOREIGN KEY ("source_channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION`);
+// 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`);
+// }
+//
+// public async down(queryRunner: QueryRunner): Promise<void> {
+// await queryRunner.query(`ALTER TABLE "applications" DROP CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba"`);
+// await queryRunner.query(`ALTER TABLE "webhooks" DROP CONSTRAINT "FK_4495b7032a33c6b8b605d030398"`);
+// await queryRunner.query(`ALTER TABLE "user_settings_protos" DROP COLUMN "frecencySettings"`);
+// await queryRunner.query(`ALTER TABLE "user_settings_protos" ADD "frecencySettings" text`);
+// await queryRunner.query(`ALTER TABLE "user_settings_protos" DROP COLUMN "userSettings"`);
+// await queryRunner.query(`ALTER TABLE "user_settings_protos" ADD "userSettings" text`);
+// await queryRunner.query(`ALTER TABLE "categories" DROP COLUMN "icon"`);
+// await queryRunner.query(`ALTER TABLE "categories" ADD "icon" text`);
+// await queryRunner.query(`ALTER TABLE "applications" DROP COLUMN "custom_install_url"`);
+// await queryRunner.query(`ALTER TABLE "applications" ADD "custom_install_url" text`);
+// await queryRunner.query(`ALTER TABLE "applications" DROP COLUMN "guild_id"`);
+// await queryRunner.query(`ALTER TABLE "applications" ADD "guild_id" text`);
+// await queryRunner.query(`ALTER TABLE "team_members" DROP COLUMN "role"`);
+// await queryRunner.query(`ALTER TABLE "team_members" ADD "role" text NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "purchased_flags"`);
+// await queryRunner.query(`ALTER TABLE "users" ADD "purchased_flags" bigint NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "public_flags"`);
+// await queryRunner.query(`ALTER TABLE "users" ADD "public_flags" bigint NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "flags"`);
+// await queryRunner.query(`ALTER TABLE "users" ADD "flags" bigint NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "view_nsfw_guilds" SET DEFAULT true`);
+// await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "friend_discovery_flags" SET DEFAULT '0'`);
+// await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "client_status" DROP NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "channels" ALTER COLUMN "default_thread_rate_limit_per_user" SET NOT NULL`);
+// await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "avatar"`);
+// await queryRunner.query(`ALTER TABLE "messages" ADD "avatar" text`);
+// await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "username"`);
+// await queryRunner.query(`ALTER TABLE "messages" ADD "username" text`);
+// await queryRunner.query(`ALTER TABLE "webhooks" DROP COLUMN "source_channel_id"`);
+// await queryRunner.query(`ALTER TABLE "webhooks" ADD "source_channel_id" character varying(255) DEFAULT NULL`);
+// await queryRunner.query(`ALTER TABLE "webhooks" ADD CONSTRAINT "fk_d64f38834fa676f6caa4786ddd6" FOREIGN KEY ("source_channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION`);
+// }
+//
+// }
|
