diff options
Diffstat (limited to 'util/src/migrations/sqlite/1660257795259-CodeCleanup2.ts')
| -rw-r--r-- | util/src/migrations/sqlite/1660257795259-CodeCleanup2.ts | 572 |
1 files changed, 0 insertions, 572 deletions
diff --git a/util/src/migrations/sqlite/1660257795259-CodeCleanup2.ts b/util/src/migrations/sqlite/1660257795259-CodeCleanup2.ts deleted file mode 100644 index 53698256..00000000 --- a/util/src/migrations/sqlite/1660257795259-CodeCleanup2.ts +++ /dev/null @@ -1,572 +0,0 @@ -import { MigrationInterface, QueryRunner } from "typeorm"; - -export class CodeCleanup21660257795259 implements MigrationInterface { - name = 'CodeCleanup21660257795259' - - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(` - CREATE TABLE "temporary_guilds" ( - "id" varchar PRIMARY KEY NOT NULL, - "afk_channel_id" varchar, - "afk_timeout" integer, - "banner" varchar, - "default_message_notifications" integer, - "description" varchar, - "discovery_splash" varchar, - "explicit_content_filter" integer, - "features" text NOT NULL, - "primary_category_id" integer, - "icon" varchar, - "large" boolean, - "max_members" integer, - "max_presences" integer, - "max_video_channel_users" integer, - "member_count" integer, - "presence_count" integer, - "template_id" varchar, - "mfa_level" integer, - "name" varchar NOT NULL, - "owner_id" varchar, - "preferred_locale" varchar, - "premium_subscription_count" integer, - "premium_tier" integer, - "public_updates_channel_id" varchar, - "rules_channel_id" varchar, - "region" varchar, - "splash" varchar, - "system_channel_id" varchar, - "system_channel_flags" integer, - "unavailable" boolean, - "verification_level" integer, - "welcome_screen" text NOT NULL, - "widget_channel_id" varchar, - "widget_enabled" boolean, - "nsfw_level" integer, - "nsfw" boolean, - "parent" varchar, - "premium_progress_bar_enabled" boolean NOT NULL, - CONSTRAINT "FK_f591a66b8019d87b0fe6c12dad6" FOREIGN KEY ("afk_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_e2a2f873a64a5cf62526de42325" FOREIGN KEY ("template_id") REFERENCES "templates" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_fc1a451727e3643ca572a3bb394" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_8d450b016dc8bec35f36729e4b0" FOREIGN KEY ("public_updates_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_95828668aa333460582e0ca6396" FOREIGN KEY ("rules_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_cfc3d3ad260f8121c95b31a1fce" FOREIGN KEY ("system_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_9d1d665379eefde7876a17afa99" FOREIGN KEY ("widget_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION - ) - `); - await queryRunner.query(` - INSERT INTO "temporary_guilds"( - "id", - "afk_channel_id", - "afk_timeout", - "banner", - "default_message_notifications", - "description", - "discovery_splash", - "explicit_content_filter", - "features", - "primary_category_id", - "icon", - "large", - "max_members", - "max_presences", - "max_video_channel_users", - "member_count", - "presence_count", - "template_id", - "mfa_level", - "name", - "owner_id", - "preferred_locale", - "premium_subscription_count", - "premium_tier", - "public_updates_channel_id", - "rules_channel_id", - "region", - "splash", - "system_channel_id", - "system_channel_flags", - "unavailable", - "verification_level", - "welcome_screen", - "widget_channel_id", - "widget_enabled", - "nsfw_level", - "nsfw", - "parent", - "premium_progress_bar_enabled" - ) - SELECT "id", - "afk_channel_id", - "afk_timeout", - "banner", - "default_message_notifications", - "description", - "discovery_splash", - "explicit_content_filter", - "features", - "primary_category_id", - "icon", - "large", - "max_members", - "max_presences", - "max_video_channel_users", - "member_count", - "presence_count", - "template_id", - "mfa_level", - "name", - "owner_id", - "preferred_locale", - "premium_subscription_count", - "premium_tier", - "public_updates_channel_id", - "rules_channel_id", - "region", - "splash", - "system_channel_id", - "system_channel_flags", - "unavailable", - "verification_level", - "welcome_screen", - "widget_channel_id", - "widget_enabled", - "nsfw_level", - "nsfw", - "parent", - "premium_progress_bar_enabled" - FROM "guilds" - `); - await queryRunner.query(` - DROP TABLE "guilds" - `); - await queryRunner.query(` - ALTER TABLE "temporary_guilds" - RENAME TO "guilds" - `); - await queryRunner.query(` - CREATE TABLE "temporary_guilds" ( - "id" varchar PRIMARY KEY NOT NULL, - "afk_channel_id" varchar, - "afk_timeout" integer, - "banner" varchar, - "default_message_notifications" integer, - "description" varchar, - "discovery_splash" varchar, - "explicit_content_filter" integer, - "features" text NOT NULL, - "primary_category_id" integer, - "icon" varchar, - "large" boolean, - "max_members" integer, - "max_presences" integer, - "max_video_channel_users" integer, - "member_count" integer, - "presence_count" integer, - "template_id" varchar, - "mfa_level" integer, - "name" varchar NOT NULL, - "owner_id" varchar, - "preferred_locale" varchar, - "premium_subscription_count" integer, - "premium_tier" integer, - "public_updates_channel_id" varchar, - "rules_channel_id" varchar, - "region" varchar, - "splash" varchar, - "system_channel_id" varchar, - "system_channel_flags" integer, - "unavailable" boolean, - "verification_level" integer, - "welcome_screen" text NOT NULL, - "widget_channel_id" varchar, - "widget_enabled" boolean, - "nsfw_level" integer, - "nsfw" boolean, - "parent" varchar, - "premium_progress_bar_enabled" boolean, - CONSTRAINT "FK_f591a66b8019d87b0fe6c12dad6" FOREIGN KEY ("afk_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_e2a2f873a64a5cf62526de42325" FOREIGN KEY ("template_id") REFERENCES "templates" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_fc1a451727e3643ca572a3bb394" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_8d450b016dc8bec35f36729e4b0" FOREIGN KEY ("public_updates_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_95828668aa333460582e0ca6396" FOREIGN KEY ("rules_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_cfc3d3ad260f8121c95b31a1fce" FOREIGN KEY ("system_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_9d1d665379eefde7876a17afa99" FOREIGN KEY ("widget_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION - ) - `); - await queryRunner.query(` - INSERT INTO "temporary_guilds"( - "id", - "afk_channel_id", - "afk_timeout", - "banner", - "default_message_notifications", - "description", - "discovery_splash", - "explicit_content_filter", - "features", - "primary_category_id", - "icon", - "large", - "max_members", - "max_presences", - "max_video_channel_users", - "member_count", - "presence_count", - "template_id", - "mfa_level", - "name", - "owner_id", - "preferred_locale", - "premium_subscription_count", - "premium_tier", - "public_updates_channel_id", - "rules_channel_id", - "region", - "splash", - "system_channel_id", - "system_channel_flags", - "unavailable", - "verification_level", - "welcome_screen", - "widget_channel_id", - "widget_enabled", - "nsfw_level", - "nsfw", - "parent", - "premium_progress_bar_enabled" - ) - SELECT "id", - "afk_channel_id", - "afk_timeout", - "banner", - "default_message_notifications", - "description", - "discovery_splash", - "explicit_content_filter", - "features", - "primary_category_id", - "icon", - "large", - "max_members", - "max_presences", - "max_video_channel_users", - "member_count", - "presence_count", - "template_id", - "mfa_level", - "name", - "owner_id", - "preferred_locale", - "premium_subscription_count", - "premium_tier", - "public_updates_channel_id", - "rules_channel_id", - "region", - "splash", - "system_channel_id", - "system_channel_flags", - "unavailable", - "verification_level", - "welcome_screen", - "widget_channel_id", - "widget_enabled", - "nsfw_level", - "nsfw", - "parent", - "premium_progress_bar_enabled" - FROM "guilds" - `); - await queryRunner.query(` - DROP TABLE "guilds" - `); - await queryRunner.query(` - ALTER TABLE "temporary_guilds" - RENAME TO "guilds" - `); - } - - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(` - ALTER TABLE "guilds" - RENAME TO "temporary_guilds" - `); - await queryRunner.query(` - CREATE TABLE "guilds" ( - "id" varchar PRIMARY KEY NOT NULL, - "afk_channel_id" varchar, - "afk_timeout" integer, - "banner" varchar, - "default_message_notifications" integer, - "description" varchar, - "discovery_splash" varchar, - "explicit_content_filter" integer, - "features" text NOT NULL, - "primary_category_id" integer, - "icon" varchar, - "large" boolean, - "max_members" integer, - "max_presences" integer, - "max_video_channel_users" integer, - "member_count" integer, - "presence_count" integer, - "template_id" varchar, - "mfa_level" integer, - "name" varchar NOT NULL, - "owner_id" varchar, - "preferred_locale" varchar, - "premium_subscription_count" integer, - "premium_tier" integer, - "public_updates_channel_id" varchar, - "rules_channel_id" varchar, - "region" varchar, - "splash" varchar, - "system_channel_id" varchar, - "system_channel_flags" integer, - "unavailable" boolean, - "verification_level" integer, - "welcome_screen" text NOT NULL, - "widget_channel_id" varchar, - "widget_enabled" boolean, - "nsfw_level" integer, - "nsfw" boolean, - "parent" varchar, - "premium_progress_bar_enabled" boolean NOT NULL, - CONSTRAINT "FK_f591a66b8019d87b0fe6c12dad6" FOREIGN KEY ("afk_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_e2a2f873a64a5cf62526de42325" FOREIGN KEY ("template_id") REFERENCES "templates" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_fc1a451727e3643ca572a3bb394" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_8d450b016dc8bec35f36729e4b0" FOREIGN KEY ("public_updates_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_95828668aa333460582e0ca6396" FOREIGN KEY ("rules_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_cfc3d3ad260f8121c95b31a1fce" FOREIGN KEY ("system_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_9d1d665379eefde7876a17afa99" FOREIGN KEY ("widget_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION - ) - `); - await queryRunner.query(` - INSERT INTO "guilds"( - "id", - "afk_channel_id", - "afk_timeout", - "banner", - "default_message_notifications", - "description", - "discovery_splash", - "explicit_content_filter", - "features", - "primary_category_id", - "icon", - "large", - "max_members", - "max_presences", - "max_video_channel_users", - "member_count", - "presence_count", - "template_id", - "mfa_level", - "name", - "owner_id", - "preferred_locale", - "premium_subscription_count", - "premium_tier", - "public_updates_channel_id", - "rules_channel_id", - "region", - "splash", - "system_channel_id", - "system_channel_flags", - "unavailable", - "verification_level", - "welcome_screen", - "widget_channel_id", - "widget_enabled", - "nsfw_level", - "nsfw", - "parent", - "premium_progress_bar_enabled" - ) - SELECT "id", - "afk_channel_id", - "afk_timeout", - "banner", - "default_message_notifications", - "description", - "discovery_splash", - "explicit_content_filter", - "features", - "primary_category_id", - "icon", - "large", - "max_members", - "max_presences", - "max_video_channel_users", - "member_count", - "presence_count", - "template_id", - "mfa_level", - "name", - "owner_id", - "preferred_locale", - "premium_subscription_count", - "premium_tier", - "public_updates_channel_id", - "rules_channel_id", - "region", - "splash", - "system_channel_id", - "system_channel_flags", - "unavailable", - "verification_level", - "welcome_screen", - "widget_channel_id", - "widget_enabled", - "nsfw_level", - "nsfw", - "parent", - "premium_progress_bar_enabled" - FROM "temporary_guilds" - `); - await queryRunner.query(` - DROP TABLE "temporary_guilds" - `); - await queryRunner.query(` - ALTER TABLE "guilds" - RENAME TO "temporary_guilds" - `); - await queryRunner.query(` - CREATE TABLE "guilds" ( - "id" varchar PRIMARY KEY NOT NULL, - "afk_channel_id" varchar, - "afk_timeout" integer, - "banner" varchar, - "default_message_notifications" integer, - "description" varchar, - "discovery_splash" varchar, - "explicit_content_filter" integer, - "features" text NOT NULL, - "primary_category_id" integer, - "icon" varchar, - "large" boolean, - "max_members" integer, - "max_presences" integer, - "max_video_channel_users" integer, - "member_count" integer, - "presence_count" integer, - "template_id" varchar, - "mfa_level" integer, - "name" varchar NOT NULL, - "owner_id" varchar, - "preferred_locale" varchar, - "premium_subscription_count" integer, - "premium_tier" integer, - "public_updates_channel_id" varchar, - "rules_channel_id" varchar, - "region" varchar, - "splash" varchar, - "system_channel_id" varchar, - "system_channel_flags" integer, - "unavailable" boolean, - "verification_level" integer, - "welcome_screen" text NOT NULL, - "widget_channel_id" varchar, - "widget_enabled" boolean, - "nsfw_level" integer, - "nsfw" boolean, - "parent" varchar, - "premium_progress_bar_enabled" boolean NOT NULL, - CONSTRAINT "FK_f591a66b8019d87b0fe6c12dad6" FOREIGN KEY ("afk_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_e2a2f873a64a5cf62526de42325" FOREIGN KEY ("template_id") REFERENCES "templates" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_fc1a451727e3643ca572a3bb394" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_8d450b016dc8bec35f36729e4b0" FOREIGN KEY ("public_updates_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_95828668aa333460582e0ca6396" FOREIGN KEY ("rules_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_cfc3d3ad260f8121c95b31a1fce" FOREIGN KEY ("system_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT "FK_9d1d665379eefde7876a17afa99" FOREIGN KEY ("widget_channel_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION - ) - `); - await queryRunner.query(` - INSERT INTO "guilds"( - "id", - "afk_channel_id", - "afk_timeout", - "banner", - "default_message_notifications", - "description", - "discovery_splash", - "explicit_content_filter", - "features", - "primary_category_id", - "icon", - "large", - "max_members", - "max_presences", - "max_video_channel_users", - "member_count", - "presence_count", - "template_id", - "mfa_level", - "name", - "owner_id", - "preferred_locale", - "premium_subscription_count", - "premium_tier", - "public_updates_channel_id", - "rules_channel_id", - "region", - "splash", - "system_channel_id", - "system_channel_flags", - "unavailable", - "verification_level", - "welcome_screen", - "widget_channel_id", - "widget_enabled", - "nsfw_level", - "nsfw", - "parent", - "premium_progress_bar_enabled" - ) - SELECT "id", - "afk_channel_id", - "afk_timeout", - "banner", - "default_message_notifications", - "description", - "discovery_splash", - "explicit_content_filter", - "features", - "primary_category_id", - "icon", - "large", - "max_members", - "max_presences", - "max_video_channel_users", - "member_count", - "presence_count", - "template_id", - "mfa_level", - "name", - "owner_id", - "preferred_locale", - "premium_subscription_count", - "premium_tier", - "public_updates_channel_id", - "rules_channel_id", - "region", - "splash", - "system_channel_id", - "system_channel_flags", - "unavailable", - "verification_level", - "welcome_screen", - "widget_channel_id", - "widget_enabled", - "nsfw_level", - "nsfw", - "parent", - "premium_progress_bar_enabled" - FROM "temporary_guilds" - `); - await queryRunner.query(` - DROP TABLE "temporary_guilds" - `); - } - -} |