diff --git a/util/src/migrations/mariadb/1659901151025-initial.ts b/util/src/migrations/mariadb/1659901151025-initial.ts
deleted file mode 100644
index d15e0add..00000000
--- a/util/src/migrations/mariadb/1659901151025-initial.ts
+++ /dev/null
@@ -1,1219 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class initial1659901151025 implements MigrationInterface {
- name = 'initial1659901151025'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- CREATE TABLE \`config\` (
- \`key\` varchar(255) NOT NULL,
- \`value\` text NULL,
- PRIMARY KEY (\`key\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`relationships\` (
- \`id\` varchar(255) NOT NULL,
- \`from_id\` varchar(255) NOT NULL,
- \`to_id\` varchar(255) NOT NULL,
- \`nickname\` varchar(255) NULL,
- \`type\` int NOT NULL,
- UNIQUE INDEX \`IDX_a0b2ff0a598df0b0d055934a17\` (\`from_id\`, \`to_id\`),
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`connected_accounts\` (
- \`id\` varchar(255) NOT NULL,
- \`user_id\` varchar(255) NULL,
- \`access_token\` varchar(255) NOT NULL,
- \`friend_sync\` tinyint NOT NULL,
- \`name\` varchar(255) NOT NULL,
- \`revoked\` tinyint NOT NULL,
- \`show_activity\` tinyint NOT NULL,
- \`type\` varchar(255) NOT NULL,
- \`verified\` tinyint NOT NULL,
- \`visibility\` int NOT NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`users\` (
- \`id\` varchar(255) NOT NULL,
- \`username\` varchar(255) NOT NULL,
- \`discriminator\` varchar(255) NOT NULL,
- \`avatar\` varchar(255) NULL,
- \`accent_color\` int NULL,
- \`banner\` varchar(255) NULL,
- \`phone\` varchar(255) NULL,
- \`desktop\` tinyint NOT NULL,
- \`mobile\` tinyint NOT NULL,
- \`premium\` tinyint NOT NULL,
- \`premium_type\` int NOT NULL,
- \`bot\` tinyint NOT NULL,
- \`bio\` varchar(255) NOT NULL,
- \`system\` tinyint NOT NULL,
- \`nsfw_allowed\` tinyint NOT NULL,
- \`mfa_enabled\` tinyint NOT NULL,
- \`totp_secret\` varchar(255) NULL,
- \`totp_last_ticket\` varchar(255) NULL,
- \`created_at\` datetime NOT NULL,
- \`premium_since\` datetime NULL,
- \`verified\` tinyint NOT NULL,
- \`disabled\` tinyint NOT NULL,
- \`deleted\` tinyint NOT NULL,
- \`email\` varchar(255) NULL,
- \`flags\` varchar(255) NOT NULL,
- \`public_flags\` int NOT NULL,
- \`rights\` bigint NOT NULL,
- \`data\` text NOT NULL,
- \`fingerprints\` text NOT NULL,
- \`settings\` text NOT NULL,
- \`extended_settings\` text NOT NULL,
- \`notes\` text NOT NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`backup_codes\` (
- \`id\` varchar(255) NOT NULL,
- \`code\` varchar(255) NOT NULL,
- \`consumed\` tinyint NOT NULL,
- \`expired\` tinyint NOT NULL,
- \`user_id\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`bans\` (
- \`id\` varchar(255) NOT NULL,
- \`user_id\` varchar(255) NULL,
- \`guild_id\` varchar(255) NULL,
- \`executor_id\` varchar(255) NULL,
- \`ip\` varchar(255) NOT NULL,
- \`reason\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`recipients\` (
- \`id\` varchar(255) NOT NULL,
- \`channel_id\` varchar(255) NOT NULL,
- \`user_id\` varchar(255) NOT NULL,
- \`closed\` tinyint NOT NULL DEFAULT 0,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`roles\` (
- \`id\` varchar(255) NOT NULL,
- \`guild_id\` varchar(255) NULL,
- \`color\` int NOT NULL,
- \`hoist\` tinyint NOT NULL,
- \`managed\` tinyint NOT NULL,
- \`mentionable\` tinyint NOT NULL,
- \`name\` varchar(255) NOT NULL,
- \`permissions\` varchar(255) NOT NULL,
- \`position\` int NOT NULL,
- \`icon\` varchar(255) NULL,
- \`unicode_emoji\` varchar(255) NULL,
- \`tags\` text NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`members\` (
- \`index\` int NOT NULL AUTO_INCREMENT,
- \`id\` varchar(255) NOT NULL,
- \`guild_id\` varchar(255) NOT NULL,
- \`nick\` varchar(255) NULL,
- \`joined_at\` datetime NOT NULL,
- \`premium_since\` bigint NULL,
- \`deaf\` tinyint NOT NULL,
- \`mute\` tinyint NOT NULL,
- \`pending\` tinyint NOT NULL,
- \`settings\` text NOT NULL,
- \`last_message_id\` varchar(255) NULL,
- \`joined_by\` varchar(255) NULL,
- UNIQUE INDEX \`IDX_bb2bf9386ac443afbbbf9f12d3\` (\`id\`, \`guild_id\`),
- PRIMARY KEY (\`index\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`webhooks\` (
- \`id\` varchar(255) NOT NULL,
- \`type\` int NOT NULL,
- \`name\` varchar(255) NULL,
- \`avatar\` varchar(255) NULL,
- \`token\` varchar(255) NULL,
- \`guild_id\` varchar(255) NULL,
- \`channel_id\` varchar(255) NULL,
- \`application_id\` varchar(255) NULL,
- \`user_id\` varchar(255) NULL,
- \`source_guild_id\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`stickers\` (
- \`id\` varchar(255) NOT NULL,
- \`name\` varchar(255) NOT NULL,
- \`description\` varchar(255) NULL,
- \`available\` tinyint NULL,
- \`tags\` varchar(255) NULL,
- \`pack_id\` varchar(255) NULL,
- \`guild_id\` varchar(255) NULL,
- \`user_id\` varchar(255) NULL,
- \`type\` int NOT NULL,
- \`format_type\` int NOT NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`attachments\` (
- \`id\` varchar(255) NOT NULL,
- \`filename\` varchar(255) NOT NULL,
- \`size\` int NOT NULL,
- \`url\` varchar(255) NOT NULL,
- \`proxy_url\` varchar(255) NOT NULL,
- \`height\` int NULL,
- \`width\` int NULL,
- \`content_type\` varchar(255) NULL,
- \`message_id\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`messages\` (
- \`id\` varchar(255) NOT NULL,
- \`channel_id\` varchar(255) NULL,
- \`guild_id\` varchar(255) NULL,
- \`author_id\` varchar(255) NULL,
- \`member_id\` varchar(255) NULL,
- \`webhook_id\` varchar(255) NULL,
- \`application_id\` varchar(255) NULL,
- \`content\` varchar(255) NULL,
- \`timestamp\` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
- \`edited_timestamp\` datetime NULL,
- \`tts\` tinyint NULL,
- \`mention_everyone\` tinyint NULL,
- \`embeds\` text NOT NULL,
- \`reactions\` text NOT NULL,
- \`nonce\` text NULL,
- \`pinned\` tinyint NULL,
- \`type\` int NOT NULL,
- \`activity\` text NULL,
- \`flags\` varchar(255) NULL,
- \`message_reference\` text NULL,
- \`interaction\` text NULL,
- \`components\` text NULL,
- \`message_reference_id\` varchar(255) NULL,
- INDEX \`IDX_86b9109b155eb70c0a2ca3b4b6\` (\`channel_id\`),
- INDEX \`IDX_05535bc695e9f7ee104616459d\` (\`author_id\`),
- UNIQUE INDEX \`IDX_3ed7a60fb7dbe04e1ba9332a8b\` (\`channel_id\`, \`id\`),
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`read_states\` (
- \`id\` varchar(255) NOT NULL,
- \`channel_id\` varchar(255) NOT NULL,
- \`user_id\` varchar(255) NOT NULL,
- \`last_message_id\` varchar(255) NULL,
- \`public_ack\` varchar(255) NULL,
- \`notifications_cursor\` varchar(255) NULL,
- \`last_pin_timestamp\` datetime NULL,
- \`mention_count\` int NULL,
- UNIQUE INDEX \`IDX_0abf8b443321bd3cf7f81ee17a\` (\`channel_id\`, \`user_id\`),
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`invites\` (
- \`code\` varchar(255) NOT NULL,
- \`temporary\` tinyint NOT NULL,
- \`uses\` int NOT NULL,
- \`max_uses\` int NOT NULL,
- \`max_age\` int NOT NULL,
- \`created_at\` datetime NOT NULL,
- \`expires_at\` datetime NOT NULL,
- \`guild_id\` varchar(255) NULL,
- \`channel_id\` varchar(255) NULL,
- \`inviter_id\` varchar(255) NULL,
- \`target_user_id\` varchar(255) NULL,
- \`target_user_type\` int NULL,
- \`vanity_url\` tinyint NULL,
- PRIMARY KEY (\`code\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`voice_states\` (
- \`id\` varchar(255) NOT NULL,
- \`guild_id\` varchar(255) NULL,
- \`channel_id\` varchar(255) NULL,
- \`user_id\` varchar(255) NULL,
- \`session_id\` varchar(255) NOT NULL,
- \`token\` varchar(255) NULL,
- \`deaf\` tinyint NOT NULL,
- \`mute\` tinyint NOT NULL,
- \`self_deaf\` tinyint NOT NULL,
- \`self_mute\` tinyint NOT NULL,
- \`self_stream\` tinyint NULL,
- \`self_video\` tinyint NOT NULL,
- \`suppress\` tinyint NOT NULL,
- \`request_to_speak_timestamp\` datetime NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`channels\` (
- \`id\` varchar(255) NOT NULL,
- \`created_at\` datetime NOT NULL,
- \`name\` varchar(255) NULL,
- \`icon\` text NULL,
- \`type\` int NOT NULL,
- \`last_message_id\` varchar(255) NULL,
- \`guild_id\` varchar(255) NULL,
- \`parent_id\` varchar(255) NULL,
- \`owner_id\` varchar(255) NULL,
- \`last_pin_timestamp\` int NULL,
- \`default_auto_archive_duration\` int NULL,
- \`position\` int NULL,
- \`permission_overwrites\` text NULL,
- \`video_quality_mode\` int NULL,
- \`bitrate\` int NULL,
- \`user_limit\` int NULL,
- \`nsfw\` tinyint NULL,
- \`rate_limit_per_user\` int NULL,
- \`topic\` varchar(255) NULL,
- \`retention_policy_id\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`emojis\` (
- \`id\` varchar(255) NOT NULL,
- \`animated\` tinyint NOT NULL,
- \`available\` tinyint NOT NULL,
- \`guild_id\` varchar(255) NOT NULL,
- \`user_id\` varchar(255) NULL,
- \`managed\` tinyint NOT NULL,
- \`name\` varchar(255) NOT NULL,
- \`require_colons\` tinyint NOT NULL,
- \`roles\` text NOT NULL,
- \`groups\` text NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`templates\` (
- \`id\` varchar(255) NOT NULL,
- \`code\` varchar(255) NOT NULL,
- \`name\` varchar(255) NOT NULL,
- \`description\` varchar(255) NULL,
- \`usage_count\` int NULL,
- \`creator_id\` varchar(255) NULL,
- \`created_at\` datetime NOT NULL,
- \`updated_at\` datetime NOT NULL,
- \`source_guild_id\` varchar(255) NULL,
- \`serialized_source_guild\` text NOT NULL,
- UNIQUE INDEX \`IDX_be38737bf339baf63b1daeffb5\` (\`code\`),
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`guilds\` (
- \`id\` varchar(255) NOT NULL,
- \`afk_channel_id\` varchar(255) NULL,
- \`afk_timeout\` int NULL,
- \`banner\` varchar(255) NULL,
- \`default_message_notifications\` int NULL,
- \`description\` varchar(255) NULL,
- \`discovery_splash\` varchar(255) NULL,
- \`explicit_content_filter\` int NULL,
- \`features\` text NOT NULL,
- \`primary_category_id\` int NULL,
- \`icon\` varchar(255) NULL,
- \`large\` tinyint NULL,
- \`max_members\` int NULL,
- \`max_presences\` int NULL,
- \`max_video_channel_users\` int NULL,
- \`member_count\` int NULL,
- \`presence_count\` int NULL,
- \`template_id\` varchar(255) NULL,
- \`mfa_level\` int NULL,
- \`name\` varchar(255) NOT NULL,
- \`owner_id\` varchar(255) NULL,
- \`preferred_locale\` varchar(255) NULL,
- \`premium_subscription_count\` int NULL,
- \`premium_tier\` int NULL,
- \`public_updates_channel_id\` varchar(255) NULL,
- \`rules_channel_id\` varchar(255) NULL,
- \`region\` varchar(255) NULL,
- \`splash\` varchar(255) NULL,
- \`system_channel_id\` varchar(255) NULL,
- \`system_channel_flags\` int NULL,
- \`unavailable\` tinyint NULL,
- \`verification_level\` int NULL,
- \`welcome_screen\` text NOT NULL,
- \`widget_channel_id\` varchar(255) NULL,
- \`widget_enabled\` tinyint NULL,
- \`nsfw_level\` int NULL,
- \`nsfw\` tinyint NULL,
- \`parent\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`team_members\` (
- \`id\` varchar(255) NOT NULL,
- \`membership_state\` int NOT NULL,
- \`permissions\` text NOT NULL,
- \`team_id\` varchar(255) NULL,
- \`user_id\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`teams\` (
- \`id\` varchar(255) NOT NULL,
- \`icon\` varchar(255) NULL,
- \`name\` varchar(255) NOT NULL,
- \`owner_user_id\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`applications\` (
- \`id\` varchar(255) NOT NULL,
- \`name\` varchar(255) NOT NULL,
- \`icon\` varchar(255) NULL,
- \`description\` varchar(255) NOT NULL,
- \`rpc_origins\` text NULL,
- \`bot_public\` tinyint NOT NULL,
- \`bot_require_code_grant\` tinyint NOT NULL,
- \`terms_of_service_url\` varchar(255) NULL,
- \`privacy_policy_url\` varchar(255) NULL,
- \`summary\` varchar(255) NULL,
- \`verify_key\` varchar(255) NOT NULL,
- \`primary_sku_id\` varchar(255) NULL,
- \`slug\` varchar(255) NULL,
- \`cover_image\` varchar(255) NULL,
- \`flags\` varchar(255) NOT NULL,
- \`owner_id\` varchar(255) NULL,
- \`team_id\` varchar(255) NULL,
- \`guild_id\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`audit_logs\` (
- \`id\` varchar(255) NOT NULL,
- \`user_id\` varchar(255) NULL,
- \`action_type\` int NOT NULL,
- \`options\` text NULL,
- \`changes\` text NOT NULL,
- \`reason\` varchar(255) NULL,
- \`target_id\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`categories\` (
- \`id\` int NOT NULL,
- \`name\` varchar(255) NULL,
- \`localizations\` text NOT NULL,
- \`is_primary\` tinyint NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`rate_limits\` (
- \`id\` varchar(255) NOT NULL,
- \`executor_id\` varchar(255) NOT NULL,
- \`hits\` int NOT NULL,
- \`blocked\` tinyint NOT NULL,
- \`expires_at\` datetime NOT NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`sessions\` (
- \`id\` varchar(255) NOT NULL,
- \`user_id\` varchar(255) NULL,
- \`session_id\` varchar(255) NOT NULL,
- \`activities\` text NULL,
- \`client_info\` text NOT NULL,
- \`status\` varchar(255) NOT NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`sticker_packs\` (
- \`id\` varchar(255) NOT NULL,
- \`name\` varchar(255) NOT NULL,
- \`description\` varchar(255) NULL,
- \`banner_asset_id\` varchar(255) NULL,
- \`cover_sticker_id\` varchar(255) NULL,
- \`coverStickerId\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`client_release\` (
- \`id\` varchar(255) NOT NULL,
- \`name\` varchar(255) NOT NULL,
- \`pub_date\` varchar(255) NOT NULL,
- \`url\` varchar(255) NOT NULL,
- \`deb_url\` varchar(255) NOT NULL,
- \`osx_url\` varchar(255) NOT NULL,
- \`win_url\` varchar(255) NOT NULL,
- \`notes\` varchar(255) NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`notes\` (
- \`id\` varchar(255) NOT NULL,
- \`content\` varchar(255) NOT NULL,
- \`owner_id\` varchar(255) NULL,
- \`target_id\` varchar(255) NULL,
- UNIQUE INDEX \`IDX_74e6689b9568cc965b8bfc9150\` (\`owner_id\`, \`target_id\`),
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`member_roles\` (
- \`index\` int NOT NULL,
- \`role_id\` varchar(255) NOT NULL,
- INDEX \`IDX_5d7ddc8a5f9c167f548625e772\` (\`index\`),
- INDEX \`IDX_e9080e7a7997a0170026d5139c\` (\`role_id\`),
- PRIMARY KEY (\`index\`, \`role_id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`message_user_mentions\` (
- \`messagesId\` varchar(255) NOT NULL,
- \`usersId\` varchar(255) NOT NULL,
- INDEX \`IDX_a343387fc560ef378760681c23\` (\`messagesId\`),
- INDEX \`IDX_b831eb18ceebd28976239b1e2f\` (\`usersId\`),
- PRIMARY KEY (\`messagesId\`, \`usersId\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`message_role_mentions\` (
- \`messagesId\` varchar(255) NOT NULL,
- \`rolesId\` varchar(255) NOT NULL,
- INDEX \`IDX_a8242cf535337a490b0feaea0b\` (\`messagesId\`),
- INDEX \`IDX_29d63eb1a458200851bc37d074\` (\`rolesId\`),
- PRIMARY KEY (\`messagesId\`, \`rolesId\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`message_channel_mentions\` (
- \`messagesId\` varchar(255) NOT NULL,
- \`channelsId\` varchar(255) NOT NULL,
- INDEX \`IDX_2a27102ecd1d81b4582a436092\` (\`messagesId\`),
- INDEX \`IDX_bdb8c09e1464cabf62105bf4b9\` (\`channelsId\`),
- PRIMARY KEY (\`messagesId\`, \`channelsId\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- CREATE TABLE \`message_stickers\` (
- \`messagesId\` varchar(255) NOT NULL,
- \`stickersId\` varchar(255) NOT NULL,
- INDEX \`IDX_40bb6f23e7cc133292e92829d2\` (\`messagesId\`),
- INDEX \`IDX_e22a70819d07659c7a71c112a1\` (\`stickersId\`),
- PRIMARY KEY (\`messagesId\`, \`stickersId\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- ALTER TABLE \`relationships\`
- ADD CONSTRAINT \`FK_9af4194bab1250b1c584ae4f1d7\` FOREIGN KEY (\`from_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`relationships\`
- ADD CONSTRAINT \`FK_9c7f6b98a9843b76dce1b0c878b\` FOREIGN KEY (\`to_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`connected_accounts\`
- ADD CONSTRAINT \`FK_f47244225a6a1eac04a3463dd90\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`backup_codes\`
- ADD CONSTRAINT \`FK_70066ea80d2f4b871beda32633b\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`bans\`
- ADD CONSTRAINT \`FK_5999e8e449f80a236ff72023559\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`bans\`
- ADD CONSTRAINT \`FK_9d3ab7dd180ebdd245cdb66ecad\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`bans\`
- ADD CONSTRAINT \`FK_07ad88c86d1f290d46748410d58\` FOREIGN KEY (\`executor_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`recipients\`
- ADD CONSTRAINT \`FK_2f18ee1ba667f233ae86c0ea60e\` FOREIGN KEY (\`channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`recipients\`
- ADD CONSTRAINT \`FK_6157e8b6ba4e6e3089616481fe2\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`roles\`
- ADD CONSTRAINT \`FK_c32c1ab1c4dc7dcb0278c4b1b8b\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`members\`
- ADD CONSTRAINT \`FK_28b53062261b996d9c99fa12404\` FOREIGN KEY (\`id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`members\`
- ADD CONSTRAINT \`FK_16aceddd5b89825b8ed6029ad1c\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`webhooks\`
- ADD CONSTRAINT \`FK_487a7af59d189f744fe394368fc\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`webhooks\`
- ADD CONSTRAINT \`FK_df528cf77e82f8032230e7e37d8\` FOREIGN KEY (\`channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`webhooks\`
- ADD CONSTRAINT \`FK_c3e5305461931763b56aa905f1c\` FOREIGN KEY (\`application_id\`) REFERENCES \`applications\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`webhooks\`
- ADD CONSTRAINT \`FK_0d523f6f997c86e052c49b1455f\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`webhooks\`
- ADD CONSTRAINT \`FK_3a285f4f49c40e0706d3018bc9f\` FOREIGN KEY (\`source_guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`stickers\`
- ADD CONSTRAINT \`FK_e7cfa5cefa6661b3fb8fda8ce69\` FOREIGN KEY (\`pack_id\`) REFERENCES \`sticker_packs\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`stickers\`
- ADD CONSTRAINT \`FK_193d551d852aca5347ef5c9f205\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`stickers\`
- ADD CONSTRAINT \`FK_8f4ee73f2bb2325ff980502e158\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`attachments\`
- ADD CONSTRAINT \`FK_623e10eec51ada466c5038979e3\` FOREIGN KEY (\`message_id\`) REFERENCES \`messages\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\`
- ADD CONSTRAINT \`FK_86b9109b155eb70c0a2ca3b4b6d\` FOREIGN KEY (\`channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\`
- ADD CONSTRAINT \`FK_b193588441b085352a4c0109423\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\`
- ADD CONSTRAINT \`FK_05535bc695e9f7ee104616459d3\` FOREIGN KEY (\`author_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\`
- ADD CONSTRAINT \`FK_b0525304f2262b7014245351c76\` FOREIGN KEY (\`member_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\`
- ADD CONSTRAINT \`FK_f83c04bcf1df4e5c0e7a52ed348\` FOREIGN KEY (\`webhook_id\`) REFERENCES \`webhooks\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\`
- ADD CONSTRAINT \`FK_5d3ec1cb962de6488637fd779d6\` FOREIGN KEY (\`application_id\`) REFERENCES \`applications\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\`
- ADD CONSTRAINT \`FK_61a92bb65b302a76d9c1fcd3174\` FOREIGN KEY (\`message_reference_id\`) REFERENCES \`messages\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`read_states\`
- ADD CONSTRAINT \`FK_40da2fca4e0eaf7a23b5bfc5d34\` FOREIGN KEY (\`channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`read_states\`
- ADD CONSTRAINT \`FK_195f92e4dd1254a4e348c043763\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`invites\`
- ADD CONSTRAINT \`FK_3f4939aa1461e8af57fea3fb05d\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`invites\`
- ADD CONSTRAINT \`FK_6a15b051fe5050aa00a4b9ff0f6\` FOREIGN KEY (\`channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`invites\`
- ADD CONSTRAINT \`FK_15c35422032e0b22b4ada95f48f\` FOREIGN KEY (\`inviter_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`invites\`
- ADD CONSTRAINT \`FK_11a0d394f8fc649c19ce5f16b59\` FOREIGN KEY (\`target_user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`voice_states\`
- ADD CONSTRAINT \`FK_03779ef216d4b0358470d9cb748\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`voice_states\`
- ADD CONSTRAINT \`FK_9f8d389866b40b6657edd026dd4\` FOREIGN KEY (\`channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`voice_states\`
- ADD CONSTRAINT \`FK_5fe1d5f931a67e85039c640001b\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\`
- ADD CONSTRAINT \`FK_c253dafe5f3a03ec00cd8fb4581\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\`
- ADD CONSTRAINT \`FK_3274522d14af40540b1a883fc80\` FOREIGN KEY (\`parent_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\`
- ADD CONSTRAINT \`FK_3873ed438575cce703ecff4fc7b\` FOREIGN KEY (\`owner_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`emojis\`
- ADD CONSTRAINT \`FK_4b988e0db89d94cebcf07f598cc\` FOREIGN KEY (\`guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`emojis\`
- ADD CONSTRAINT \`FK_fa7ddd5f9a214e28ce596548421\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`templates\`
- ADD CONSTRAINT \`FK_d7374b7f8f5fbfdececa4fb62e1\` FOREIGN KEY (\`creator_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`templates\`
- ADD CONSTRAINT \`FK_445d00eaaea0e60a017a5ed0c11\` FOREIGN KEY (\`source_guild_id\`) REFERENCES \`guilds\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\`
- ADD CONSTRAINT \`FK_f591a66b8019d87b0fe6c12dad6\` FOREIGN KEY (\`afk_channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\`
- ADD CONSTRAINT \`FK_e2a2f873a64a5cf62526de42325\` FOREIGN KEY (\`template_id\`) REFERENCES \`templates\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\`
- ADD CONSTRAINT \`FK_fc1a451727e3643ca572a3bb394\` FOREIGN KEY (\`owner_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\`
- ADD CONSTRAINT \`FK_8d450b016dc8bec35f36729e4b0\` FOREIGN KEY (\`public_updates_channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\`
- ADD CONSTRAINT \`FK_95828668aa333460582e0ca6396\` FOREIGN KEY (\`rules_channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\`
- ADD CONSTRAINT \`FK_cfc3d3ad260f8121c95b31a1fce\` FOREIGN KEY (\`system_channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\`
- ADD CONSTRAINT \`FK_9d1d665379eefde7876a17afa99\` FOREIGN KEY (\`widget_channel_id\`) REFERENCES \`channels\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`team_members\`
- ADD CONSTRAINT \`FK_fdad7d5768277e60c40e01cdcea\` FOREIGN KEY (\`team_id\`) REFERENCES \`teams\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`team_members\`
- ADD CONSTRAINT \`FK_c2bf4967c8c2a6b845dadfbf3d4\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`teams\`
- ADD CONSTRAINT \`FK_13f00abf7cb6096c43ecaf8c108\` FOREIGN KEY (\`owner_user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD CONSTRAINT \`FK_e57508958bf92b9d9d25231b5e8\` FOREIGN KEY (\`owner_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD CONSTRAINT \`FK_a36ed02953077f408d0f3ebc424\` FOREIGN KEY (\`team_id\`) REFERENCES \`teams\`(\`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
- `);
- await queryRunner.query(`
- ALTER TABLE \`audit_logs\`
- ADD CONSTRAINT \`FK_3cd01cd3ae7aab010310d96ac8e\` FOREIGN KEY (\`target_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`audit_logs\`
- ADD CONSTRAINT \`FK_bd2726fd31b35443f2245b93ba0\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`sessions\`
- ADD CONSTRAINT \`FK_085d540d9f418cfbdc7bd55bb19\` FOREIGN KEY (\`user_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`sticker_packs\`
- ADD CONSTRAINT \`FK_448fafba4355ee1c837bbc865f1\` FOREIGN KEY (\`coverStickerId\`) REFERENCES \`stickers\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`notes\`
- ADD CONSTRAINT \`FK_f9e103f8ae67cb1787063597925\` FOREIGN KEY (\`owner_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`notes\`
- ADD CONSTRAINT \`FK_23e08e5b4481711d573e1abecdc\` FOREIGN KEY (\`target_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE \`member_roles\`
- ADD CONSTRAINT \`FK_5d7ddc8a5f9c167f548625e772e\` FOREIGN KEY (\`index\`) REFERENCES \`members\`(\`index\`) ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE \`member_roles\`
- ADD CONSTRAINT \`FK_e9080e7a7997a0170026d5139c1\` FOREIGN KEY (\`role_id\`) REFERENCES \`roles\`(\`id\`) ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_user_mentions\`
- ADD CONSTRAINT \`FK_a343387fc560ef378760681c236\` FOREIGN KEY (\`messagesId\`) REFERENCES \`messages\`(\`id\`) ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_user_mentions\`
- ADD CONSTRAINT \`FK_b831eb18ceebd28976239b1e2f8\` FOREIGN KEY (\`usersId\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_role_mentions\`
- ADD CONSTRAINT \`FK_a8242cf535337a490b0feaea0b4\` FOREIGN KEY (\`messagesId\`) REFERENCES \`messages\`(\`id\`) ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_role_mentions\`
- ADD CONSTRAINT \`FK_29d63eb1a458200851bc37d074b\` FOREIGN KEY (\`rolesId\`) REFERENCES \`roles\`(\`id\`) ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_channel_mentions\`
- ADD CONSTRAINT \`FK_2a27102ecd1d81b4582a4360921\` FOREIGN KEY (\`messagesId\`) REFERENCES \`messages\`(\`id\`) ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_channel_mentions\`
- ADD CONSTRAINT \`FK_bdb8c09e1464cabf62105bf4b9d\` FOREIGN KEY (\`channelsId\`) REFERENCES \`channels\`(\`id\`) ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_stickers\`
- ADD CONSTRAINT \`FK_40bb6f23e7cc133292e92829d28\` FOREIGN KEY (\`messagesId\`) REFERENCES \`messages\`(\`id\`) ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_stickers\`
- ADD CONSTRAINT \`FK_e22a70819d07659c7a71c112a1f\` FOREIGN KEY (\`stickersId\`) REFERENCES \`stickers\`(\`id\`) ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- CREATE TABLE \`query-result-cache\` (
- \`id\` int NOT NULL AUTO_INCREMENT,
- \`identifier\` varchar(255) NULL,
- \`time\` bigint NOT NULL,
- \`duration\` int NOT NULL,
- \`query\` text NOT NULL,
- \`result\` text NOT NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- DROP TABLE \`query-result-cache\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_stickers\` DROP FOREIGN KEY \`FK_e22a70819d07659c7a71c112a1f\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_stickers\` DROP FOREIGN KEY \`FK_40bb6f23e7cc133292e92829d28\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_channel_mentions\` DROP FOREIGN KEY \`FK_bdb8c09e1464cabf62105bf4b9d\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_channel_mentions\` DROP FOREIGN KEY \`FK_2a27102ecd1d81b4582a4360921\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_role_mentions\` DROP FOREIGN KEY \`FK_29d63eb1a458200851bc37d074b\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_role_mentions\` DROP FOREIGN KEY \`FK_a8242cf535337a490b0feaea0b4\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_user_mentions\` DROP FOREIGN KEY \`FK_b831eb18ceebd28976239b1e2f8\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`message_user_mentions\` DROP FOREIGN KEY \`FK_a343387fc560ef378760681c236\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`member_roles\` DROP FOREIGN KEY \`FK_e9080e7a7997a0170026d5139c1\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`member_roles\` DROP FOREIGN KEY \`FK_5d7ddc8a5f9c167f548625e772e\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`notes\` DROP FOREIGN KEY \`FK_23e08e5b4481711d573e1abecdc\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`notes\` DROP FOREIGN KEY \`FK_f9e103f8ae67cb1787063597925\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`sticker_packs\` DROP FOREIGN KEY \`FK_448fafba4355ee1c837bbc865f1\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`sessions\` DROP FOREIGN KEY \`FK_085d540d9f418cfbdc7bd55bb19\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`audit_logs\` DROP FOREIGN KEY \`FK_bd2726fd31b35443f2245b93ba0\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`audit_logs\` DROP FOREIGN KEY \`FK_3cd01cd3ae7aab010310d96ac8e\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP FOREIGN KEY \`FK_e5bf78cdbbe9ba91062d74c5aba\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP FOREIGN KEY \`FK_a36ed02953077f408d0f3ebc424\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP FOREIGN KEY \`FK_e57508958bf92b9d9d25231b5e8\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`teams\` DROP FOREIGN KEY \`FK_13f00abf7cb6096c43ecaf8c108\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`team_members\` DROP FOREIGN KEY \`FK_c2bf4967c8c2a6b845dadfbf3d4\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`team_members\` DROP FOREIGN KEY \`FK_fdad7d5768277e60c40e01cdcea\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\` DROP FOREIGN KEY \`FK_9d1d665379eefde7876a17afa99\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\` DROP FOREIGN KEY \`FK_cfc3d3ad260f8121c95b31a1fce\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\` DROP FOREIGN KEY \`FK_95828668aa333460582e0ca6396\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\` DROP FOREIGN KEY \`FK_8d450b016dc8bec35f36729e4b0\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\` DROP FOREIGN KEY \`FK_fc1a451727e3643ca572a3bb394\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\` DROP FOREIGN KEY \`FK_e2a2f873a64a5cf62526de42325\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\` DROP FOREIGN KEY \`FK_f591a66b8019d87b0fe6c12dad6\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`templates\` DROP FOREIGN KEY \`FK_445d00eaaea0e60a017a5ed0c11\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`templates\` DROP FOREIGN KEY \`FK_d7374b7f8f5fbfdececa4fb62e1\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`emojis\` DROP FOREIGN KEY \`FK_fa7ddd5f9a214e28ce596548421\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`emojis\` DROP FOREIGN KEY \`FK_4b988e0db89d94cebcf07f598cc\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\` DROP FOREIGN KEY \`FK_3873ed438575cce703ecff4fc7b\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\` DROP FOREIGN KEY \`FK_3274522d14af40540b1a883fc80\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\` DROP FOREIGN KEY \`FK_c253dafe5f3a03ec00cd8fb4581\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`voice_states\` DROP FOREIGN KEY \`FK_5fe1d5f931a67e85039c640001b\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`voice_states\` DROP FOREIGN KEY \`FK_9f8d389866b40b6657edd026dd4\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`voice_states\` DROP FOREIGN KEY \`FK_03779ef216d4b0358470d9cb748\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`invites\` DROP FOREIGN KEY \`FK_11a0d394f8fc649c19ce5f16b59\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`invites\` DROP FOREIGN KEY \`FK_15c35422032e0b22b4ada95f48f\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`invites\` DROP FOREIGN KEY \`FK_6a15b051fe5050aa00a4b9ff0f6\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`invites\` DROP FOREIGN KEY \`FK_3f4939aa1461e8af57fea3fb05d\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`read_states\` DROP FOREIGN KEY \`FK_195f92e4dd1254a4e348c043763\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`read_states\` DROP FOREIGN KEY \`FK_40da2fca4e0eaf7a23b5bfc5d34\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\` DROP FOREIGN KEY \`FK_61a92bb65b302a76d9c1fcd3174\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\` DROP FOREIGN KEY \`FK_5d3ec1cb962de6488637fd779d6\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\` DROP FOREIGN KEY \`FK_f83c04bcf1df4e5c0e7a52ed348\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\` DROP FOREIGN KEY \`FK_b0525304f2262b7014245351c76\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\` DROP FOREIGN KEY \`FK_05535bc695e9f7ee104616459d3\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\` DROP FOREIGN KEY \`FK_b193588441b085352a4c0109423\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`messages\` DROP FOREIGN KEY \`FK_86b9109b155eb70c0a2ca3b4b6d\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`attachments\` DROP FOREIGN KEY \`FK_623e10eec51ada466c5038979e3\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`stickers\` DROP FOREIGN KEY \`FK_8f4ee73f2bb2325ff980502e158\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`stickers\` DROP FOREIGN KEY \`FK_193d551d852aca5347ef5c9f205\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`stickers\` DROP FOREIGN KEY \`FK_e7cfa5cefa6661b3fb8fda8ce69\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`webhooks\` DROP FOREIGN KEY \`FK_3a285f4f49c40e0706d3018bc9f\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`webhooks\` DROP FOREIGN KEY \`FK_0d523f6f997c86e052c49b1455f\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`webhooks\` DROP FOREIGN KEY \`FK_c3e5305461931763b56aa905f1c\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`webhooks\` DROP FOREIGN KEY \`FK_df528cf77e82f8032230e7e37d8\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`webhooks\` DROP FOREIGN KEY \`FK_487a7af59d189f744fe394368fc\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`members\` DROP FOREIGN KEY \`FK_16aceddd5b89825b8ed6029ad1c\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`members\` DROP FOREIGN KEY \`FK_28b53062261b996d9c99fa12404\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`roles\` DROP FOREIGN KEY \`FK_c32c1ab1c4dc7dcb0278c4b1b8b\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`recipients\` DROP FOREIGN KEY \`FK_6157e8b6ba4e6e3089616481fe2\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`recipients\` DROP FOREIGN KEY \`FK_2f18ee1ba667f233ae86c0ea60e\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`bans\` DROP FOREIGN KEY \`FK_07ad88c86d1f290d46748410d58\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`bans\` DROP FOREIGN KEY \`FK_9d3ab7dd180ebdd245cdb66ecad\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`bans\` DROP FOREIGN KEY \`FK_5999e8e449f80a236ff72023559\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`backup_codes\` DROP FOREIGN KEY \`FK_70066ea80d2f4b871beda32633b\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`connected_accounts\` DROP FOREIGN KEY \`FK_f47244225a6a1eac04a3463dd90\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`relationships\` DROP FOREIGN KEY \`FK_9c7f6b98a9843b76dce1b0c878b\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`relationships\` DROP FOREIGN KEY \`FK_9af4194bab1250b1c584ae4f1d7\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_e22a70819d07659c7a71c112a1\` ON \`message_stickers\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_40bb6f23e7cc133292e92829d2\` ON \`message_stickers\`
- `);
- await queryRunner.query(`
- DROP TABLE \`message_stickers\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_bdb8c09e1464cabf62105bf4b9\` ON \`message_channel_mentions\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_2a27102ecd1d81b4582a436092\` ON \`message_channel_mentions\`
- `);
- await queryRunner.query(`
- DROP TABLE \`message_channel_mentions\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_29d63eb1a458200851bc37d074\` ON \`message_role_mentions\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_a8242cf535337a490b0feaea0b\` ON \`message_role_mentions\`
- `);
- await queryRunner.query(`
- DROP TABLE \`message_role_mentions\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_b831eb18ceebd28976239b1e2f\` ON \`message_user_mentions\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_a343387fc560ef378760681c23\` ON \`message_user_mentions\`
- `);
- await queryRunner.query(`
- DROP TABLE \`message_user_mentions\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_e9080e7a7997a0170026d5139c\` ON \`member_roles\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_5d7ddc8a5f9c167f548625e772\` ON \`member_roles\`
- `);
- await queryRunner.query(`
- DROP TABLE \`member_roles\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_74e6689b9568cc965b8bfc9150\` ON \`notes\`
- `);
- await queryRunner.query(`
- DROP TABLE \`notes\`
- `);
- await queryRunner.query(`
- DROP TABLE \`client_release\`
- `);
- await queryRunner.query(`
- DROP TABLE \`sticker_packs\`
- `);
- await queryRunner.query(`
- DROP TABLE \`sessions\`
- `);
- await queryRunner.query(`
- DROP TABLE \`rate_limits\`
- `);
- await queryRunner.query(`
- DROP TABLE \`categories\`
- `);
- await queryRunner.query(`
- DROP TABLE \`audit_logs\`
- `);
- await queryRunner.query(`
- DROP TABLE \`applications\`
- `);
- await queryRunner.query(`
- DROP TABLE \`teams\`
- `);
- await queryRunner.query(`
- DROP TABLE \`team_members\`
- `);
- await queryRunner.query(`
- DROP TABLE \`guilds\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_be38737bf339baf63b1daeffb5\` ON \`templates\`
- `);
- await queryRunner.query(`
- DROP TABLE \`templates\`
- `);
- await queryRunner.query(`
- DROP TABLE \`emojis\`
- `);
- await queryRunner.query(`
- DROP TABLE \`channels\`
- `);
- await queryRunner.query(`
- DROP TABLE \`voice_states\`
- `);
- await queryRunner.query(`
- DROP TABLE \`invites\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_0abf8b443321bd3cf7f81ee17a\` ON \`read_states\`
- `);
- await queryRunner.query(`
- DROP TABLE \`read_states\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_3ed7a60fb7dbe04e1ba9332a8b\` ON \`messages\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_05535bc695e9f7ee104616459d\` ON \`messages\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_86b9109b155eb70c0a2ca3b4b6\` ON \`messages\`
- `);
- await queryRunner.query(`
- DROP TABLE \`messages\`
- `);
- await queryRunner.query(`
- DROP TABLE \`attachments\`
- `);
- await queryRunner.query(`
- DROP TABLE \`stickers\`
- `);
- await queryRunner.query(`
- DROP TABLE \`webhooks\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_bb2bf9386ac443afbbbf9f12d3\` ON \`members\`
- `);
- await queryRunner.query(`
- DROP TABLE \`members\`
- `);
- await queryRunner.query(`
- DROP TABLE \`roles\`
- `);
- await queryRunner.query(`
- DROP TABLE \`recipients\`
- `);
- await queryRunner.query(`
- DROP TABLE \`bans\`
- `);
- await queryRunner.query(`
- DROP TABLE \`backup_codes\`
- `);
- await queryRunner.query(`
- DROP TABLE \`users\`
- `);
- await queryRunner.query(`
- DROP TABLE \`connected_accounts\`
- `);
- await queryRunner.query(`
- DROP INDEX \`IDX_a0b2ff0a598df0b0d055934a17\` ON \`relationships\`
- `);
- await queryRunner.query(`
- DROP TABLE \`relationships\`
- `);
- await queryRunner.query(`
- DROP TABLE \`config\`
- `);
- }
-
-}
diff --git a/util/src/migrations/mariadb/1659921859145-premium_since_as_date.ts b/util/src/migrations/mariadb/1659921859145-premium_since_as_date.ts
deleted file mode 100644
index de173cfe..00000000
--- a/util/src/migrations/mariadb/1659921859145-premium_since_as_date.ts
+++ /dev/null
@@ -1,26 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class premiumSinceAsDate1659921859145 implements MigrationInterface {
- name = 'premiumSinceAsDate1659921859145'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`members\` DROP COLUMN \`premium_since\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`members\`
- ADD \`premium_since\` datetime NULL
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`members\` DROP COLUMN \`premium_since\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`members\`
- ADD \`premium_since\` bigint NULL
- `);
- }
-
-}
diff --git a/util/src/migrations/mariadb/1660258393551-CodeCleanup3.ts b/util/src/migrations/mariadb/1660258393551-CodeCleanup3.ts
deleted file mode 100644
index 87d075e4..00000000
--- a/util/src/migrations/mariadb/1660258393551-CodeCleanup3.ts
+++ /dev/null
@@ -1,232 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup31660258393551 implements MigrationInterface {
- name = 'CodeCleanup31660258393551'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP FOREIGN KEY \`FK_2ce5a55796fe4c2f77ece57a647\`
- `);
- await queryRunner.query(`
- DROP INDEX \`REL_2ce5a55796fe4c2f77ece57a64\` ON \`applications\`
- `);
- await queryRunner.query(`
- CREATE TABLE \`user_settings\` (
- \`id\` varchar(255) NOT NULL,
- \`afk_timeout\` int NULL,
- \`allow_accessibility_detection\` tinyint NULL,
- \`animate_emoji\` tinyint NULL,
- \`animate_stickers\` int NULL,
- \`contact_sync_enabled\` tinyint NULL,
- \`convert_emoticons\` tinyint NULL,
- \`custom_status\` text NULL,
- \`default_guilds_restricted\` tinyint NULL,
- \`detect_platform_accounts\` tinyint NULL,
- \`developer_mode\` tinyint NULL,
- \`disable_games_tab\` tinyint NULL,
- \`enable_tts_command\` tinyint NULL,
- \`explicit_content_filter\` int NULL,
- \`friend_source_flags\` text NULL,
- \`gateway_connected\` tinyint NULL,
- \`gif_auto_play\` tinyint NULL,
- \`guild_folders\` text NULL,
- \`guild_positions\` text NULL,
- \`inline_attachment_media\` tinyint NULL,
- \`inline_embed_media\` tinyint NULL,
- \`locale\` varchar(255) NULL,
- \`message_display_compact\` tinyint NULL,
- \`native_phone_integration_enabled\` tinyint NULL,
- \`render_embeds\` tinyint NULL,
- \`render_reactions\` tinyint NULL,
- \`restricted_guilds\` text NULL,
- \`show_current_game\` tinyint NULL,
- \`status\` varchar(255) NULL,
- \`stream_notifications_enabled\` tinyint NULL,
- \`theme\` varchar(255) NULL,
- \`timezone_offset\` int NULL,
- PRIMARY KEY (\`id\`)
- ) ENGINE = InnoDB
- `);
- await queryRunner.query(`
- ALTER TABLE \`users\` DROP COLUMN \`settings\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`type\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`hook\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`redirect_uris\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`rpc_application_state\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`store_application_state\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`verification_state\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`interactions_endpoint_url\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`integration_public\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`integration_require_code_grant\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`discoverability_state\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`discovery_eligibility_flags\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`tags\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`install_params\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`bot_user_id\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\`
- ADD \`premium_progress_bar_enabled\` tinyint NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`rpc_origins\` text NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`primary_sku_id\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`slug\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`guild_id\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` CHANGE \`description\` \`description\` varchar(255) NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`flags\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`flags\` varchar(255) NOT NULL
- `);
- 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 FOREIGN KEY \`FK_e5bf78cdbbe9ba91062d74c5aba\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`flags\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`flags\` int NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` CHANGE \`description\` \`description\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`guild_id\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`slug\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`primary_sku_id\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\` DROP COLUMN \`rpc_origins\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`guilds\` DROP COLUMN \`premium_progress_bar_enabled\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`bot_user_id\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`install_params\` text NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`tags\` text NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`discovery_eligibility_flags\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`discoverability_state\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`integration_require_code_grant\` tinyint NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`integration_public\` tinyint NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`interactions_endpoint_url\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`verification_state\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`store_application_state\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`rpc_application_state\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`redirect_uris\` text NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`hook\` tinyint NOT NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`applications\`
- ADD \`type\` text NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`users\`
- ADD \`settings\` text NOT NULL
- `);
- await queryRunner.query(`
- DROP TABLE \`user_settings\`
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX \`REL_2ce5a55796fe4c2f77ece57a64\` ON \`applications\` (\`bot_user_id\`)
- `);
- 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
- `);
- }
-
-}
diff --git a/util/src/migrations/mariadb/1660260587556-CodeCleanup4.ts b/util/src/migrations/mariadb/1660260587556-CodeCleanup4.ts
deleted file mode 100644
index 98da67db..00000000
--- a/util/src/migrations/mariadb/1660260587556-CodeCleanup4.ts
+++ /dev/null
@@ -1,39 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup41660260587556 implements MigrationInterface {
- name = 'CodeCleanup41660260587556'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`users\`
- ADD \`settingsId\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`users\`
- ADD UNIQUE INDEX \`IDX_76ba283779c8441fd5ff819c8c\` (\`settingsId\`)
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX \`REL_76ba283779c8441fd5ff819c8c\` ON \`users\` (\`settingsId\`)
- `);
- await queryRunner.query(`
- ALTER TABLE \`users\`
- ADD CONSTRAINT \`FK_76ba283779c8441fd5ff819c8cf\` FOREIGN KEY (\`settingsId\`) REFERENCES \`user_settings\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`users\` DROP FOREIGN KEY \`FK_76ba283779c8441fd5ff819c8cf\`
- `);
- await queryRunner.query(`
- DROP INDEX \`REL_76ba283779c8441fd5ff819c8c\` ON \`users\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`users\` DROP INDEX \`IDX_76ba283779c8441fd5ff819c8c\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`users\` DROP COLUMN \`settingsId\`
- `);
- }
-
-}
diff --git a/util/src/migrations/mariadb/1660265930624-CodeCleanup5.ts b/util/src/migrations/mariadb/1660265930624-CodeCleanup5.ts
deleted file mode 100644
index 04f8e6af..00000000
--- a/util/src/migrations/mariadb/1660265930624-CodeCleanup5.ts
+++ /dev/null
@@ -1,53 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup51660265930624 implements MigrationInterface {
- name = 'CodeCleanup51660265930624'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`users\`
- ADD \`settingsId\` varchar(255) NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`users\`
- ADD UNIQUE INDEX \`IDX_76ba283779c8441fd5ff819c8c\` (\`settingsId\`)
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\`
- ADD \`flags\` int NULL
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\`
- ADD \`default_thread_rate_limit_per_user\` int NULL
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX \`REL_76ba283779c8441fd5ff819c8c\` ON \`users\` (\`settingsId\`)
- `);
- await queryRunner.query(`
- ALTER TABLE \`users\`
- ADD CONSTRAINT \`FK_76ba283779c8441fd5ff819c8cf\` FOREIGN KEY (\`settingsId\`) REFERENCES \`user_settings\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE \`users\` DROP FOREIGN KEY \`FK_76ba283779c8441fd5ff819c8cf\`
- `);
- await queryRunner.query(`
- DROP INDEX \`REL_76ba283779c8441fd5ff819c8c\` ON \`users\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\` DROP COLUMN \`default_thread_rate_limit_per_user\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`channels\` DROP COLUMN \`flags\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`users\` DROP INDEX \`IDX_76ba283779c8441fd5ff819c8c\`
- `);
- await queryRunner.query(`
- ALTER TABLE \`users\` DROP COLUMN \`settingsId\`
- `);
- }
-
-}
diff --git a/util/src/migrations/postgres/1659899687168-initial.ts b/util/src/migrations/postgres/1659899687168-initial.ts
deleted file mode 100644
index 4ffb897d..00000000
--- a/util/src/migrations/postgres/1659899687168-initial.ts
+++ /dev/null
@@ -1,1245 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class initial1659899687168 implements MigrationInterface {
- name = 'initial1659899687168'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- CREATE TABLE "config" (
- "key" character varying NOT NULL,
- "value" text,
- CONSTRAINT "PK_26489c99ddbb4c91631ef5cc791" PRIMARY KEY ("key")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "relationships" (
- "id" character varying NOT NULL,
- "from_id" character varying NOT NULL,
- "to_id" character varying NOT NULL,
- "nickname" character varying,
- "type" integer NOT NULL,
- CONSTRAINT "PK_ba20e2f5cf487408e08e4dcecaf" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_a0b2ff0a598df0b0d055934a17" ON "relationships" ("from_id", "to_id")
- `);
- await queryRunner.query(`
- CREATE TABLE "connected_accounts" (
- "id" character varying NOT NULL,
- "user_id" character varying,
- "access_token" character varying NOT NULL,
- "friend_sync" boolean NOT NULL,
- "name" character varying NOT NULL,
- "revoked" boolean NOT NULL,
- "show_activity" boolean NOT NULL,
- "type" character varying NOT NULL,
- "verified" boolean NOT NULL,
- "visibility" integer NOT NULL,
- CONSTRAINT "PK_70416f1da0be645bb31da01c774" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "users" (
- "id" character varying NOT NULL,
- "username" character varying NOT NULL,
- "discriminator" character varying NOT NULL,
- "avatar" character varying,
- "accent_color" integer,
- "banner" character varying,
- "phone" character varying,
- "desktop" boolean NOT NULL,
- "mobile" boolean NOT NULL,
- "premium" boolean NOT NULL,
- "premium_type" integer NOT NULL,
- "bot" boolean NOT NULL,
- "bio" character varying NOT NULL,
- "system" boolean NOT NULL,
- "nsfw_allowed" boolean NOT NULL,
- "mfa_enabled" boolean NOT NULL,
- "totp_secret" character varying,
- "totp_last_ticket" character varying,
- "created_at" TIMESTAMP NOT NULL,
- "premium_since" TIMESTAMP,
- "verified" boolean NOT NULL,
- "disabled" boolean NOT NULL,
- "deleted" boolean NOT NULL,
- "email" character varying,
- "flags" character varying NOT NULL,
- "public_flags" integer NOT NULL,
- "rights" bigint NOT NULL,
- "data" text NOT NULL,
- "fingerprints" text NOT NULL,
- "settings" text NOT NULL,
- "extended_settings" text NOT NULL,
- "notes" text NOT NULL,
- CONSTRAINT "PK_a3ffb1c0c8416b9fc6f907b7433" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "backup_codes" (
- "id" character varying NOT NULL,
- "code" character varying NOT NULL,
- "consumed" boolean NOT NULL,
- "expired" boolean NOT NULL,
- "user_id" character varying,
- CONSTRAINT "PK_34ab957382dbc57e8fb53f1638f" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "bans" (
- "id" character varying NOT NULL,
- "user_id" character varying,
- "guild_id" character varying,
- "executor_id" character varying,
- "ip" character varying NOT NULL,
- "reason" character varying,
- CONSTRAINT "PK_a4d6f261bffa4615c62d756566a" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "recipients" (
- "id" character varying NOT NULL,
- "channel_id" character varying NOT NULL,
- "user_id" character varying NOT NULL,
- "closed" boolean NOT NULL DEFAULT false,
- CONSTRAINT "PK_de8fc5a9c364568f294798fe1e9" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "roles" (
- "id" character varying NOT NULL,
- "guild_id" character varying,
- "color" integer NOT NULL,
- "hoist" boolean NOT NULL,
- "managed" boolean NOT NULL,
- "mentionable" boolean NOT NULL,
- "name" character varying NOT NULL,
- "permissions" character varying NOT NULL,
- "position" integer NOT NULL,
- "icon" character varying,
- "unicode_emoji" character varying,
- "tags" text,
- CONSTRAINT "PK_c1433d71a4838793a49dcad46ab" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "members" (
- "index" SERIAL NOT NULL,
- "id" character varying NOT NULL,
- "guild_id" character varying NOT NULL,
- "nick" character varying,
- "joined_at" TIMESTAMP NOT NULL,
- "premium_since" bigint,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "pending" boolean NOT NULL,
- "settings" text NOT NULL,
- "last_message_id" character varying,
- "joined_by" character varying,
- CONSTRAINT "PK_b4a6b8c2478e5df990909c6cf6a" PRIMARY KEY ("index")
- )
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id")
- `);
- await queryRunner.query(`
- CREATE TABLE "webhooks" (
- "id" character varying NOT NULL,
- "type" integer NOT NULL,
- "name" character varying,
- "avatar" character varying,
- "token" character varying,
- "guild_id" character varying,
- "channel_id" character varying,
- "application_id" character varying,
- "user_id" character varying,
- "source_guild_id" character varying,
- CONSTRAINT "PK_9e8795cfc899ab7bdaa831e8527" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "stickers" (
- "id" character varying NOT NULL,
- "name" character varying NOT NULL,
- "description" character varying,
- "available" boolean,
- "tags" character varying,
- "pack_id" character varying,
- "guild_id" character varying,
- "user_id" character varying,
- "type" integer NOT NULL,
- "format_type" integer NOT NULL,
- CONSTRAINT "PK_e1dafa4063a5532645cc2810374" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "attachments" (
- "id" character varying NOT NULL,
- "filename" character varying NOT NULL,
- "size" integer NOT NULL,
- "url" character varying NOT NULL,
- "proxy_url" character varying NOT NULL,
- "height" integer,
- "width" integer,
- "content_type" character varying,
- "message_id" character varying,
- CONSTRAINT "PK_5e1f050bcff31e3084a1d662412" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "messages" (
- "id" character varying NOT NULL,
- "channel_id" character varying,
- "guild_id" character varying,
- "author_id" character varying,
- "member_id" character varying,
- "webhook_id" character varying,
- "application_id" character varying,
- "content" character varying,
- "timestamp" TIMESTAMP NOT NULL DEFAULT now(),
- "edited_timestamp" TIMESTAMP,
- "tts" boolean,
- "mention_everyone" boolean,
- "embeds" text NOT NULL,
- "reactions" text NOT NULL,
- "nonce" text,
- "pinned" boolean,
- "type" integer NOT NULL,
- "activity" text,
- "flags" character varying,
- "message_reference" text,
- "interaction" text,
- "components" text,
- "message_reference_id" character varying,
- CONSTRAINT "PK_18325f38ae6de43878487eff986" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_86b9109b155eb70c0a2ca3b4b6" ON "messages" ("channel_id")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_05535bc695e9f7ee104616459d" ON "messages" ("author_id")
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_3ed7a60fb7dbe04e1ba9332a8b" ON "messages" ("channel_id", "id")
- `);
- await queryRunner.query(`
- CREATE TABLE "read_states" (
- "id" character varying NOT NULL,
- "channel_id" character varying NOT NULL,
- "user_id" character varying NOT NULL,
- "last_message_id" character varying,
- "public_ack" character varying,
- "notifications_cursor" character varying,
- "last_pin_timestamp" TIMESTAMP,
- "mention_count" integer,
- CONSTRAINT "PK_e6956a804978f01b713b1ed58e2" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_0abf8b443321bd3cf7f81ee17a" ON "read_states" ("channel_id", "user_id")
- `);
- await queryRunner.query(`
- CREATE TABLE "invites" (
- "code" character varying NOT NULL,
- "temporary" boolean NOT NULL,
- "uses" integer NOT NULL,
- "max_uses" integer NOT NULL,
- "max_age" integer NOT NULL,
- "created_at" TIMESTAMP NOT NULL,
- "expires_at" TIMESTAMP NOT NULL,
- "guild_id" character varying,
- "channel_id" character varying,
- "inviter_id" character varying,
- "target_user_id" character varying,
- "target_user_type" integer,
- "vanity_url" boolean,
- CONSTRAINT "PK_33fd8a248db1cd832baa8aa25bf" PRIMARY KEY ("code")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "voice_states" (
- "id" character varying NOT NULL,
- "guild_id" character varying,
- "channel_id" character varying,
- "user_id" character varying,
- "session_id" character varying NOT NULL,
- "token" character varying,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "self_deaf" boolean NOT NULL,
- "self_mute" boolean NOT NULL,
- "self_stream" boolean,
- "self_video" boolean NOT NULL,
- "suppress" boolean NOT NULL,
- "request_to_speak_timestamp" TIMESTAMP,
- CONSTRAINT "PK_ada09a50c134fad1369b510e3ce" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "channels" (
- "id" character varying NOT NULL,
- "created_at" TIMESTAMP NOT NULL,
- "name" character varying,
- "icon" text,
- "type" integer NOT NULL,
- "last_message_id" character varying,
- "guild_id" character varying,
- "parent_id" character varying,
- "owner_id" character varying,
- "last_pin_timestamp" integer,
- "default_auto_archive_duration" integer,
- "position" integer,
- "permission_overwrites" text,
- "video_quality_mode" integer,
- "bitrate" integer,
- "user_limit" integer,
- "nsfw" boolean,
- "rate_limit_per_user" integer,
- "topic" character varying,
- "retention_policy_id" character varying,
- CONSTRAINT "PK_bc603823f3f741359c2339389f9" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "emojis" (
- "id" character varying NOT NULL,
- "animated" boolean NOT NULL,
- "available" boolean NOT NULL,
- "guild_id" character varying NOT NULL,
- "user_id" character varying,
- "managed" boolean NOT NULL,
- "name" character varying NOT NULL,
- "require_colons" boolean NOT NULL,
- "roles" text NOT NULL,
- "groups" text,
- CONSTRAINT "PK_9adb96a675f555c6169bad7ba62" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "templates" (
- "id" character varying NOT NULL,
- "code" character varying NOT NULL,
- "name" character varying NOT NULL,
- "description" character varying,
- "usage_count" integer,
- "creator_id" character varying,
- "created_at" TIMESTAMP NOT NULL,
- "updated_at" TIMESTAMP NOT NULL,
- "source_guild_id" character varying,
- "serialized_source_guild" text NOT NULL,
- CONSTRAINT "UQ_be38737bf339baf63b1daeffb55" UNIQUE ("code"),
- CONSTRAINT "PK_515948649ce0bbbe391de702ae5" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "guilds" (
- "id" character varying NOT NULL,
- "afk_channel_id" character varying,
- "afk_timeout" integer,
- "banner" character varying,
- "default_message_notifications" integer,
- "description" character varying,
- "discovery_splash" character varying,
- "explicit_content_filter" integer,
- "features" text NOT NULL,
- "primary_category_id" integer,
- "icon" character varying,
- "large" boolean,
- "max_members" integer,
- "max_presences" integer,
- "max_video_channel_users" integer,
- "member_count" integer,
- "presence_count" integer,
- "template_id" character varying,
- "mfa_level" integer,
- "name" character varying NOT NULL,
- "owner_id" character varying,
- "preferred_locale" character varying,
- "premium_subscription_count" integer,
- "premium_tier" integer,
- "public_updates_channel_id" character varying,
- "rules_channel_id" character varying,
- "region" character varying,
- "splash" character varying,
- "system_channel_id" character varying,
- "system_channel_flags" integer,
- "unavailable" boolean,
- "verification_level" integer,
- "welcome_screen" text NOT NULL,
- "widget_channel_id" character varying,
- "widget_enabled" boolean,
- "nsfw_level" integer,
- "nsfw" boolean,
- "parent" character varying,
- CONSTRAINT "PK_e7e7f2a51bd6d96a9ac2aa560f9" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "team_members" (
- "id" character varying NOT NULL,
- "membership_state" integer NOT NULL,
- "permissions" text NOT NULL,
- "team_id" character varying,
- "user_id" character varying,
- CONSTRAINT "PK_ca3eae89dcf20c9fd95bf7460aa" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "teams" (
- "id" character varying NOT NULL,
- "icon" character varying,
- "name" character varying NOT NULL,
- "owner_user_id" character varying,
- CONSTRAINT "PK_7e5523774a38b08a6236d322403" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "applications" (
- "id" character varying NOT NULL,
- "name" character varying NOT NULL,
- "icon" character varying,
- "description" character varying NOT NULL,
- "rpc_origins" text,
- "bot_public" boolean NOT NULL,
- "bot_require_code_grant" boolean NOT NULL,
- "terms_of_service_url" character varying,
- "privacy_policy_url" character varying,
- "summary" character varying,
- "verify_key" character varying NOT NULL,
- "primary_sku_id" character varying,
- "slug" character varying,
- "cover_image" character varying,
- "flags" character varying NOT NULL,
- "owner_id" character varying,
- "team_id" character varying,
- "guild_id" character varying,
- CONSTRAINT "PK_938c0a27255637bde919591888f" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "audit_logs" (
- "id" character varying NOT NULL,
- "user_id" character varying,
- "action_type" integer NOT NULL,
- "options" text,
- "changes" text NOT NULL,
- "reason" character varying,
- "target_id" character varying,
- CONSTRAINT "PK_1bb179d048bbc581caa3b013439" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "categories" (
- "id" integer NOT NULL,
- "name" character varying,
- "localizations" text NOT NULL,
- "is_primary" boolean,
- CONSTRAINT "PK_24dbc6126a28ff948da33e97d3b" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "rate_limits" (
- "id" character varying NOT NULL,
- "executor_id" character varying NOT NULL,
- "hits" integer NOT NULL,
- "blocked" boolean NOT NULL,
- "expires_at" TIMESTAMP NOT NULL,
- CONSTRAINT "PK_3b4449f1f5fc167d921ee619f65" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "sessions" (
- "id" character varying NOT NULL,
- "user_id" character varying,
- "session_id" character varying NOT NULL,
- "activities" text,
- "client_info" text NOT NULL,
- "status" character varying NOT NULL,
- CONSTRAINT "PK_3238ef96f18b355b671619111bc" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "sticker_packs" (
- "id" character varying NOT NULL,
- "name" character varying NOT NULL,
- "description" character varying,
- "banner_asset_id" character varying,
- "cover_sticker_id" character varying,
- "coverStickerId" character varying,
- CONSTRAINT "PK_a27381efea0f876f5d3233af655" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "client_release" (
- "id" character varying NOT NULL,
- "name" character varying NOT NULL,
- "pub_date" character varying NOT NULL,
- "url" character varying NOT NULL,
- "deb_url" character varying NOT NULL,
- "osx_url" character varying NOT NULL,
- "win_url" character varying NOT NULL,
- "notes" character varying,
- CONSTRAINT "PK_4c4ea258342d2d6ba1be0a71a43" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "notes" (
- "id" character varying NOT NULL,
- "content" character varying NOT NULL,
- "owner_id" character varying,
- "target_id" character varying,
- CONSTRAINT "UQ_74e6689b9568cc965b8bfc9150b" UNIQUE ("owner_id", "target_id"),
- CONSTRAINT "PK_af6206538ea96c4e77e9f400c3d" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "member_roles" (
- "index" integer NOT NULL,
- "role_id" character varying NOT NULL,
- CONSTRAINT "PK_951c1d72a0fd1da8760b4a1fd66" PRIMARY KEY ("index", "role_id")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_5d7ddc8a5f9c167f548625e772" ON "member_roles" ("index")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_e9080e7a7997a0170026d5139c" ON "member_roles" ("role_id")
- `);
- await queryRunner.query(`
- CREATE TABLE "message_user_mentions" (
- "messagesId" character varying NOT NULL,
- "usersId" character varying NOT NULL,
- CONSTRAINT "PK_9b9b6e245ad47a48dbd7605d4fb" PRIMARY KEY ("messagesId", "usersId")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_a343387fc560ef378760681c23" ON "message_user_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_b831eb18ceebd28976239b1e2f" ON "message_user_mentions" ("usersId")
- `);
- await queryRunner.query(`
- CREATE TABLE "message_role_mentions" (
- "messagesId" character varying NOT NULL,
- "rolesId" character varying NOT NULL,
- CONSTRAINT "PK_74dba92cc300452a6e14b83ed44" PRIMARY KEY ("messagesId", "rolesId")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_a8242cf535337a490b0feaea0b" ON "message_role_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_29d63eb1a458200851bc37d074" ON "message_role_mentions" ("rolesId")
- `);
- await queryRunner.query(`
- CREATE TABLE "message_channel_mentions" (
- "messagesId" character varying NOT NULL,
- "channelsId" character varying NOT NULL,
- CONSTRAINT "PK_85cb45351497cd9d06a79ced65e" PRIMARY KEY ("messagesId", "channelsId")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_2a27102ecd1d81b4582a436092" ON "message_channel_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_bdb8c09e1464cabf62105bf4b9" ON "message_channel_mentions" ("channelsId")
- `);
- await queryRunner.query(`
- CREATE TABLE "message_stickers" (
- "messagesId" character varying NOT NULL,
- "stickersId" character varying NOT NULL,
- CONSTRAINT "PK_ed820c4093d0b8cd1d2bcf66087" PRIMARY KEY ("messagesId", "stickersId")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_40bb6f23e7cc133292e92829d2" ON "message_stickers" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_e22a70819d07659c7a71c112a1" ON "message_stickers" ("stickersId")
- `);
- await queryRunner.query(`
- ALTER TABLE "relationships"
- ADD CONSTRAINT "FK_9af4194bab1250b1c584ae4f1d7" FOREIGN KEY ("from_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "relationships"
- ADD CONSTRAINT "FK_9c7f6b98a9843b76dce1b0c878b" FOREIGN KEY ("to_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "connected_accounts"
- ADD CONSTRAINT "FK_f47244225a6a1eac04a3463dd90" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "backup_codes"
- ADD CONSTRAINT "FK_70066ea80d2f4b871beda32633b" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "bans"
- ADD CONSTRAINT "FK_5999e8e449f80a236ff72023559" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "bans"
- ADD CONSTRAINT "FK_9d3ab7dd180ebdd245cdb66ecad" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "bans"
- ADD CONSTRAINT "FK_07ad88c86d1f290d46748410d58" FOREIGN KEY ("executor_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "recipients"
- ADD CONSTRAINT "FK_2f18ee1ba667f233ae86c0ea60e" FOREIGN KEY ("channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "recipients"
- ADD CONSTRAINT "FK_6157e8b6ba4e6e3089616481fe2" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "roles"
- ADD CONSTRAINT "FK_c32c1ab1c4dc7dcb0278c4b1b8b" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "members"
- ADD CONSTRAINT "FK_28b53062261b996d9c99fa12404" FOREIGN KEY ("id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "members"
- ADD CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks"
- ADD CONSTRAINT "FK_487a7af59d189f744fe394368fc" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks"
- ADD CONSTRAINT "FK_df528cf77e82f8032230e7e37d8" FOREIGN KEY ("channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks"
- ADD CONSTRAINT "FK_c3e5305461931763b56aa905f1c" FOREIGN KEY ("application_id") REFERENCES "applications"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks"
- ADD CONSTRAINT "FK_0d523f6f997c86e052c49b1455f" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks"
- ADD CONSTRAINT "FK_3a285f4f49c40e0706d3018bc9f" FOREIGN KEY ("source_guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "stickers"
- ADD CONSTRAINT "FK_e7cfa5cefa6661b3fb8fda8ce69" FOREIGN KEY ("pack_id") REFERENCES "sticker_packs"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "stickers"
- ADD CONSTRAINT "FK_193d551d852aca5347ef5c9f205" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "stickers"
- ADD CONSTRAINT "FK_8f4ee73f2bb2325ff980502e158" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "attachments"
- ADD CONSTRAINT "FK_623e10eec51ada466c5038979e3" FOREIGN KEY ("message_id") REFERENCES "messages"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "messages"
- ADD CONSTRAINT "FK_86b9109b155eb70c0a2ca3b4b6d" FOREIGN KEY ("channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "messages"
- ADD CONSTRAINT "FK_b193588441b085352a4c0109423" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "messages"
- ADD CONSTRAINT "FK_05535bc695e9f7ee104616459d3" FOREIGN KEY ("author_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "messages"
- ADD CONSTRAINT "FK_b0525304f2262b7014245351c76" FOREIGN KEY ("member_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "messages"
- ADD CONSTRAINT "FK_f83c04bcf1df4e5c0e7a52ed348" FOREIGN KEY ("webhook_id") REFERENCES "webhooks"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "messages"
- ADD CONSTRAINT "FK_5d3ec1cb962de6488637fd779d6" FOREIGN KEY ("application_id") REFERENCES "applications"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "messages"
- ADD CONSTRAINT "FK_61a92bb65b302a76d9c1fcd3174" FOREIGN KEY ("message_reference_id") REFERENCES "messages"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "read_states"
- ADD CONSTRAINT "FK_40da2fca4e0eaf7a23b5bfc5d34" FOREIGN KEY ("channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "read_states"
- ADD CONSTRAINT "FK_195f92e4dd1254a4e348c043763" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "invites"
- ADD CONSTRAINT "FK_3f4939aa1461e8af57fea3fb05d" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "invites"
- ADD CONSTRAINT "FK_6a15b051fe5050aa00a4b9ff0f6" FOREIGN KEY ("channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "invites"
- ADD CONSTRAINT "FK_15c35422032e0b22b4ada95f48f" FOREIGN KEY ("inviter_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "invites"
- ADD CONSTRAINT "FK_11a0d394f8fc649c19ce5f16b59" FOREIGN KEY ("target_user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "voice_states"
- ADD CONSTRAINT "FK_03779ef216d4b0358470d9cb748" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "voice_states"
- ADD CONSTRAINT "FK_9f8d389866b40b6657edd026dd4" FOREIGN KEY ("channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "voice_states"
- ADD CONSTRAINT "FK_5fe1d5f931a67e85039c640001b" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "channels"
- ADD CONSTRAINT "FK_c253dafe5f3a03ec00cd8fb4581" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "channels"
- ADD CONSTRAINT "FK_3274522d14af40540b1a883fc80" FOREIGN KEY ("parent_id") REFERENCES "channels"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "channels"
- ADD CONSTRAINT "FK_3873ed438575cce703ecff4fc7b" FOREIGN KEY ("owner_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "emojis"
- ADD CONSTRAINT "FK_4b988e0db89d94cebcf07f598cc" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "emojis"
- ADD CONSTRAINT "FK_fa7ddd5f9a214e28ce596548421" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "templates"
- ADD CONSTRAINT "FK_d7374b7f8f5fbfdececa4fb62e1" FOREIGN KEY ("creator_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "templates"
- ADD CONSTRAINT "FK_445d00eaaea0e60a017a5ed0c11" FOREIGN KEY ("source_guild_id") REFERENCES "guilds"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds"
- ADD CONSTRAINT "FK_f591a66b8019d87b0fe6c12dad6" FOREIGN KEY ("afk_channel_id") REFERENCES "channels"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds"
- ADD CONSTRAINT "FK_e2a2f873a64a5cf62526de42325" FOREIGN KEY ("template_id") REFERENCES "templates"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds"
- ADD CONSTRAINT "FK_fc1a451727e3643ca572a3bb394" FOREIGN KEY ("owner_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds"
- ADD CONSTRAINT "FK_8d450b016dc8bec35f36729e4b0" FOREIGN KEY ("public_updates_channel_id") REFERENCES "channels"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds"
- ADD CONSTRAINT "FK_95828668aa333460582e0ca6396" FOREIGN KEY ("rules_channel_id") REFERENCES "channels"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds"
- ADD CONSTRAINT "FK_cfc3d3ad260f8121c95b31a1fce" FOREIGN KEY ("system_channel_id") REFERENCES "channels"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds"
- ADD CONSTRAINT "FK_9d1d665379eefde7876a17afa99" FOREIGN KEY ("widget_channel_id") REFERENCES "channels"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "team_members"
- ADD CONSTRAINT "FK_fdad7d5768277e60c40e01cdcea" FOREIGN KEY ("team_id") REFERENCES "teams"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "team_members"
- ADD CONSTRAINT "FK_c2bf4967c8c2a6b845dadfbf3d4" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "teams"
- ADD CONSTRAINT "FK_13f00abf7cb6096c43ecaf8c108" FOREIGN KEY ("owner_user_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "applications"
- ADD CONSTRAINT "FK_a36ed02953077f408d0f3ebc424" FOREIGN KEY ("team_id") REFERENCES "teams"("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
- `);
- await queryRunner.query(`
- ALTER TABLE "audit_logs"
- ADD CONSTRAINT "FK_3cd01cd3ae7aab010310d96ac8e" FOREIGN KEY ("target_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "audit_logs"
- ADD CONSTRAINT "FK_bd2726fd31b35443f2245b93ba0" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "sessions"
- ADD CONSTRAINT "FK_085d540d9f418cfbdc7bd55bb19" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "sticker_packs"
- ADD CONSTRAINT "FK_448fafba4355ee1c837bbc865f1" FOREIGN KEY ("coverStickerId") REFERENCES "stickers"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "notes"
- ADD CONSTRAINT "FK_f9e103f8ae67cb1787063597925" FOREIGN KEY ("owner_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "notes"
- ADD CONSTRAINT "FK_23e08e5b4481711d573e1abecdc" FOREIGN KEY ("target_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION
- `);
- await queryRunner.query(`
- ALTER TABLE "member_roles"
- ADD CONSTRAINT "FK_5d7ddc8a5f9c167f548625e772e" FOREIGN KEY ("index") REFERENCES "members"("index") ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE "member_roles"
- ADD CONSTRAINT "FK_e9080e7a7997a0170026d5139c1" FOREIGN KEY ("role_id") REFERENCES "roles"("id") ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE "message_user_mentions"
- ADD CONSTRAINT "FK_a343387fc560ef378760681c236" FOREIGN KEY ("messagesId") REFERENCES "messages"("id") ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE "message_user_mentions"
- ADD CONSTRAINT "FK_b831eb18ceebd28976239b1e2f8" FOREIGN KEY ("usersId") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE "message_role_mentions"
- ADD CONSTRAINT "FK_a8242cf535337a490b0feaea0b4" FOREIGN KEY ("messagesId") REFERENCES "messages"("id") ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE "message_role_mentions"
- ADD CONSTRAINT "FK_29d63eb1a458200851bc37d074b" FOREIGN KEY ("rolesId") REFERENCES "roles"("id") ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE "message_channel_mentions"
- ADD CONSTRAINT "FK_2a27102ecd1d81b4582a4360921" FOREIGN KEY ("messagesId") REFERENCES "messages"("id") ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE "message_channel_mentions"
- ADD CONSTRAINT "FK_bdb8c09e1464cabf62105bf4b9d" FOREIGN KEY ("channelsId") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE "message_stickers"
- ADD CONSTRAINT "FK_40bb6f23e7cc133292e92829d28" FOREIGN KEY ("messagesId") REFERENCES "messages"("id") ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- ALTER TABLE "message_stickers"
- ADD CONSTRAINT "FK_e22a70819d07659c7a71c112a1f" FOREIGN KEY ("stickersId") REFERENCES "stickers"("id") ON DELETE CASCADE ON UPDATE CASCADE
- `);
- await queryRunner.query(`
- CREATE TABLE "query-result-cache" (
- "id" SERIAL NOT NULL,
- "identifier" character varying,
- "time" bigint NOT NULL,
- "duration" integer NOT NULL,
- "query" text NOT NULL,
- "result" text NOT NULL,
- CONSTRAINT "PK_6a98f758d8bfd010e7e10ffd3d3" PRIMARY KEY ("id")
- )
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- DROP TABLE "query-result-cache"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_stickers" DROP CONSTRAINT "FK_e22a70819d07659c7a71c112a1f"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_stickers" DROP CONSTRAINT "FK_40bb6f23e7cc133292e92829d28"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_channel_mentions" DROP CONSTRAINT "FK_bdb8c09e1464cabf62105bf4b9d"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_channel_mentions" DROP CONSTRAINT "FK_2a27102ecd1d81b4582a4360921"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_role_mentions" DROP CONSTRAINT "FK_29d63eb1a458200851bc37d074b"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_role_mentions" DROP CONSTRAINT "FK_a8242cf535337a490b0feaea0b4"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_user_mentions" DROP CONSTRAINT "FK_b831eb18ceebd28976239b1e2f8"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_user_mentions" DROP CONSTRAINT "FK_a343387fc560ef378760681c236"
- `);
- await queryRunner.query(`
- ALTER TABLE "member_roles" DROP CONSTRAINT "FK_e9080e7a7997a0170026d5139c1"
- `);
- await queryRunner.query(`
- ALTER TABLE "member_roles" DROP CONSTRAINT "FK_5d7ddc8a5f9c167f548625e772e"
- `);
- await queryRunner.query(`
- ALTER TABLE "notes" DROP CONSTRAINT "FK_23e08e5b4481711d573e1abecdc"
- `);
- await queryRunner.query(`
- ALTER TABLE "notes" DROP CONSTRAINT "FK_f9e103f8ae67cb1787063597925"
- `);
- await queryRunner.query(`
- ALTER TABLE "sticker_packs" DROP CONSTRAINT "FK_448fafba4355ee1c837bbc865f1"
- `);
- await queryRunner.query(`
- ALTER TABLE "sessions" DROP CONSTRAINT "FK_085d540d9f418cfbdc7bd55bb19"
- `);
- await queryRunner.query(`
- ALTER TABLE "audit_logs" DROP CONSTRAINT "FK_bd2726fd31b35443f2245b93ba0"
- `);
- await queryRunner.query(`
- ALTER TABLE "audit_logs" DROP CONSTRAINT "FK_3cd01cd3ae7aab010310d96ac8e"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP CONSTRAINT "FK_a36ed02953077f408d0f3ebc424"
- `);
- await queryRunner.query(`
- ALTER TABLE "applications" DROP CONSTRAINT "FK_e57508958bf92b9d9d25231b5e8"
- `);
- await queryRunner.query(`
- ALTER TABLE "teams" DROP CONSTRAINT "FK_13f00abf7cb6096c43ecaf8c108"
- `);
- await queryRunner.query(`
- ALTER TABLE "team_members" DROP CONSTRAINT "FK_c2bf4967c8c2a6b845dadfbf3d4"
- `);
- await queryRunner.query(`
- ALTER TABLE "team_members" DROP CONSTRAINT "FK_fdad7d5768277e60c40e01cdcea"
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds" DROP CONSTRAINT "FK_9d1d665379eefde7876a17afa99"
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds" DROP CONSTRAINT "FK_cfc3d3ad260f8121c95b31a1fce"
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds" DROP CONSTRAINT "FK_95828668aa333460582e0ca6396"
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds" DROP CONSTRAINT "FK_8d450b016dc8bec35f36729e4b0"
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds" DROP CONSTRAINT "FK_fc1a451727e3643ca572a3bb394"
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds" DROP CONSTRAINT "FK_e2a2f873a64a5cf62526de42325"
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds" DROP CONSTRAINT "FK_f591a66b8019d87b0fe6c12dad6"
- `);
- await queryRunner.query(`
- ALTER TABLE "templates" DROP CONSTRAINT "FK_445d00eaaea0e60a017a5ed0c11"
- `);
- await queryRunner.query(`
- ALTER TABLE "templates" DROP CONSTRAINT "FK_d7374b7f8f5fbfdececa4fb62e1"
- `);
- await queryRunner.query(`
- ALTER TABLE "emojis" DROP CONSTRAINT "FK_fa7ddd5f9a214e28ce596548421"
- `);
- await queryRunner.query(`
- ALTER TABLE "emojis" DROP CONSTRAINT "FK_4b988e0db89d94cebcf07f598cc"
- `);
- await queryRunner.query(`
- ALTER TABLE "channels" DROP CONSTRAINT "FK_3873ed438575cce703ecff4fc7b"
- `);
- await queryRunner.query(`
- ALTER TABLE "channels" DROP CONSTRAINT "FK_3274522d14af40540b1a883fc80"
- `);
- await queryRunner.query(`
- ALTER TABLE "channels" DROP CONSTRAINT "FK_c253dafe5f3a03ec00cd8fb4581"
- `);
- await queryRunner.query(`
- ALTER TABLE "voice_states" DROP CONSTRAINT "FK_5fe1d5f931a67e85039c640001b"
- `);
- await queryRunner.query(`
- ALTER TABLE "voice_states" DROP CONSTRAINT "FK_9f8d389866b40b6657edd026dd4"
- `);
- await queryRunner.query(`
- ALTER TABLE "voice_states" DROP CONSTRAINT "FK_03779ef216d4b0358470d9cb748"
- `);
- await queryRunner.query(`
- ALTER TABLE "invites" DROP CONSTRAINT "FK_11a0d394f8fc649c19ce5f16b59"
- `);
- await queryRunner.query(`
- ALTER TABLE "invites" DROP CONSTRAINT "FK_15c35422032e0b22b4ada95f48f"
- `);
- await queryRunner.query(`
- ALTER TABLE "invites" DROP CONSTRAINT "FK_6a15b051fe5050aa00a4b9ff0f6"
- `);
- await queryRunner.query(`
- ALTER TABLE "invites" DROP CONSTRAINT "FK_3f4939aa1461e8af57fea3fb05d"
- `);
- await queryRunner.query(`
- ALTER TABLE "read_states" DROP CONSTRAINT "FK_195f92e4dd1254a4e348c043763"
- `);
- await queryRunner.query(`
- ALTER TABLE "read_states" DROP CONSTRAINT "FK_40da2fca4e0eaf7a23b5bfc5d34"
- `);
- await queryRunner.query(`
- ALTER TABLE "messages" DROP CONSTRAINT "FK_61a92bb65b302a76d9c1fcd3174"
- `);
- await queryRunner.query(`
- ALTER TABLE "messages" DROP CONSTRAINT "FK_5d3ec1cb962de6488637fd779d6"
- `);
- await queryRunner.query(`
- ALTER TABLE "messages" DROP CONSTRAINT "FK_f83c04bcf1df4e5c0e7a52ed348"
- `);
- await queryRunner.query(`
- ALTER TABLE "messages" DROP CONSTRAINT "FK_b0525304f2262b7014245351c76"
- `);
- await queryRunner.query(`
- ALTER TABLE "messages" DROP CONSTRAINT "FK_05535bc695e9f7ee104616459d3"
- `);
- await queryRunner.query(`
- ALTER TABLE "messages" DROP CONSTRAINT "FK_b193588441b085352a4c0109423"
- `);
- await queryRunner.query(`
- ALTER TABLE "messages" DROP CONSTRAINT "FK_86b9109b155eb70c0a2ca3b4b6d"
- `);
- await queryRunner.query(`
- ALTER TABLE "attachments" DROP CONSTRAINT "FK_623e10eec51ada466c5038979e3"
- `);
- await queryRunner.query(`
- ALTER TABLE "stickers" DROP CONSTRAINT "FK_8f4ee73f2bb2325ff980502e158"
- `);
- await queryRunner.query(`
- ALTER TABLE "stickers" DROP CONSTRAINT "FK_193d551d852aca5347ef5c9f205"
- `);
- await queryRunner.query(`
- ALTER TABLE "stickers" DROP CONSTRAINT "FK_e7cfa5cefa6661b3fb8fda8ce69"
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks" DROP CONSTRAINT "FK_3a285f4f49c40e0706d3018bc9f"
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks" DROP CONSTRAINT "FK_0d523f6f997c86e052c49b1455f"
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks" DROP CONSTRAINT "FK_c3e5305461931763b56aa905f1c"
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks" DROP CONSTRAINT "FK_df528cf77e82f8032230e7e37d8"
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks" DROP CONSTRAINT "FK_487a7af59d189f744fe394368fc"
- `);
- await queryRunner.query(`
- ALTER TABLE "members" DROP CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c"
- `);
- await queryRunner.query(`
- ALTER TABLE "members" DROP CONSTRAINT "FK_28b53062261b996d9c99fa12404"
- `);
- await queryRunner.query(`
- ALTER TABLE "roles" DROP CONSTRAINT "FK_c32c1ab1c4dc7dcb0278c4b1b8b"
- `);
- await queryRunner.query(`
- ALTER TABLE "recipients" DROP CONSTRAINT "FK_6157e8b6ba4e6e3089616481fe2"
- `);
- await queryRunner.query(`
- ALTER TABLE "recipients" DROP CONSTRAINT "FK_2f18ee1ba667f233ae86c0ea60e"
- `);
- await queryRunner.query(`
- ALTER TABLE "bans" DROP CONSTRAINT "FK_07ad88c86d1f290d46748410d58"
- `);
- await queryRunner.query(`
- ALTER TABLE "bans" DROP CONSTRAINT "FK_9d3ab7dd180ebdd245cdb66ecad"
- `);
- await queryRunner.query(`
- ALTER TABLE "bans" DROP CONSTRAINT "FK_5999e8e449f80a236ff72023559"
- `);
- await queryRunner.query(`
- ALTER TABLE "backup_codes" DROP CONSTRAINT "FK_70066ea80d2f4b871beda32633b"
- `);
- await queryRunner.query(`
- ALTER TABLE "connected_accounts" DROP CONSTRAINT "FK_f47244225a6a1eac04a3463dd90"
- `);
- await queryRunner.query(`
- ALTER TABLE "relationships" DROP CONSTRAINT "FK_9c7f6b98a9843b76dce1b0c878b"
- `);
- await queryRunner.query(`
- ALTER TABLE "relationships" DROP CONSTRAINT "FK_9af4194bab1250b1c584ae4f1d7"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_e22a70819d07659c7a71c112a1"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_40bb6f23e7cc133292e92829d2"
- `);
- await queryRunner.query(`
- DROP TABLE "message_stickers"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_bdb8c09e1464cabf62105bf4b9"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_2a27102ecd1d81b4582a436092"
- `);
- await queryRunner.query(`
- DROP TABLE "message_channel_mentions"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_29d63eb1a458200851bc37d074"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_a8242cf535337a490b0feaea0b"
- `);
- await queryRunner.query(`
- DROP TABLE "message_role_mentions"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_b831eb18ceebd28976239b1e2f"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_a343387fc560ef378760681c23"
- `);
- await queryRunner.query(`
- DROP TABLE "message_user_mentions"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_e9080e7a7997a0170026d5139c"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_5d7ddc8a5f9c167f548625e772"
- `);
- await queryRunner.query(`
- DROP TABLE "member_roles"
- `);
- await queryRunner.query(`
- DROP TABLE "notes"
- `);
- await queryRunner.query(`
- DROP TABLE "client_release"
- `);
- await queryRunner.query(`
- DROP TABLE "sticker_packs"
- `);
- await queryRunner.query(`
- DROP TABLE "sessions"
- `);
- await queryRunner.query(`
- DROP TABLE "rate_limits"
- `);
- await queryRunner.query(`
- DROP TABLE "categories"
- `);
- await queryRunner.query(`
- DROP TABLE "audit_logs"
- `);
- await queryRunner.query(`
- DROP TABLE "applications"
- `);
- await queryRunner.query(`
- DROP TABLE "teams"
- `);
- await queryRunner.query(`
- DROP TABLE "team_members"
- `);
- await queryRunner.query(`
- DROP TABLE "guilds"
- `);
- await queryRunner.query(`
- DROP TABLE "templates"
- `);
- await queryRunner.query(`
- DROP TABLE "emojis"
- `);
- await queryRunner.query(`
- DROP TABLE "channels"
- `);
- await queryRunner.query(`
- DROP TABLE "voice_states"
- `);
- await queryRunner.query(`
- DROP TABLE "invites"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_0abf8b443321bd3cf7f81ee17a"
- `);
- await queryRunner.query(`
- DROP TABLE "read_states"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_3ed7a60fb7dbe04e1ba9332a8b"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_05535bc695e9f7ee104616459d"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_86b9109b155eb70c0a2ca3b4b6"
- `);
- await queryRunner.query(`
- DROP TABLE "messages"
- `);
- await queryRunner.query(`
- DROP TABLE "attachments"
- `);
- await queryRunner.query(`
- DROP TABLE "stickers"
- `);
- await queryRunner.query(`
- DROP TABLE "webhooks"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_bb2bf9386ac443afbbbf9f12d3"
- `);
- await queryRunner.query(`
- DROP TABLE "members"
- `);
- await queryRunner.query(`
- DROP TABLE "roles"
- `);
- await queryRunner.query(`
- DROP TABLE "recipients"
- `);
- await queryRunner.query(`
- DROP TABLE "bans"
- `);
- await queryRunner.query(`
- DROP TABLE "backup_codes"
- `);
- await queryRunner.query(`
- DROP TABLE "users"
- `);
- await queryRunner.query(`
- DROP TABLE "connected_accounts"
- `);
- await queryRunner.query(`
- DROP INDEX "public"."IDX_a0b2ff0a598df0b0d055934a17"
- `);
- await queryRunner.query(`
- DROP TABLE "relationships"
- `);
- await queryRunner.query(`
- DROP TABLE "config"
- `);
- }
-
-}
diff --git a/util/src/migrations/postgres/1659921826567-premium_since_as_date.ts b/util/src/migrations/postgres/1659921826567-premium_since_as_date.ts
deleted file mode 100644
index ac1e2edb..00000000
--- a/util/src/migrations/postgres/1659921826567-premium_since_as_date.ts
+++ /dev/null
@@ -1,26 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class premiumSinceAsDate1659921826567 implements MigrationInterface {
- name = 'premiumSinceAsDate1659921826567'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "members" DROP COLUMN "premium_since"
- `);
- await queryRunner.query(`
- ALTER TABLE "members"
- ADD "premium_since" TIMESTAMP
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "members" DROP COLUMN "premium_since"
- `);
- await queryRunner.query(`
- ALTER TABLE "members"
- ADD "premium_since" bigint
- `);
- }
-
-}
diff --git a/util/src/migrations/postgres/1660257815436-CodeCleanup2.ts b/util/src/migrations/postgres/1660257815436-CodeCleanup2.ts
deleted file mode 100644
index 511c2f5a..00000000
--- a/util/src/migrations/postgres/1660257815436-CodeCleanup2.ts
+++ /dev/null
@@ -1,59 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup21660257815436 implements MigrationInterface {
- name = 'CodeCleanup21660257815436'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- CREATE TABLE "user_settings" (
- "id" character varying NOT NULL,
- "afk_timeout" integer,
- "allow_accessibility_detection" boolean,
- "animate_emoji" boolean,
- "animate_stickers" integer,
- "contact_sync_enabled" boolean,
- "convert_emoticons" boolean,
- "custom_status" text,
- "default_guilds_restricted" boolean,
- "detect_platform_accounts" boolean,
- "developer_mode" boolean,
- "disable_games_tab" boolean,
- "enable_tts_command" boolean,
- "explicit_content_filter" integer,
- "friend_source_flags" text,
- "gateway_connected" boolean,
- "gif_auto_play" boolean,
- "guild_folders" text,
- "guild_positions" text,
- "inline_attachment_media" boolean,
- "inline_embed_media" boolean,
- "locale" character varying,
- "message_display_compact" boolean,
- "native_phone_integration_enabled" boolean,
- "render_embeds" boolean,
- "render_reactions" boolean,
- "restricted_guilds" text,
- "show_current_game" boolean,
- "status" character varying,
- "stream_notifications_enabled" boolean,
- "theme" character varying,
- "timezone_offset" integer,
- CONSTRAINT "PK_00f004f5922a0744d174530d639" PRIMARY KEY ("id")
- )
- `);
- await queryRunner.query(`
- ALTER TABLE "guilds"
- ADD "premium_progress_bar_enabled" boolean
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "guilds" DROP COLUMN "premium_progress_bar_enabled"
- `);
- await queryRunner.query(`
- DROP TABLE "user_settings"
- `);
- }
-
-}
diff --git a/util/src/migrations/postgres/1660258372154-CodeCleanup3.ts b/util/src/migrations/postgres/1660258372154-CodeCleanup3.ts
deleted file mode 100644
index e2823a54..00000000
--- a/util/src/migrations/postgres/1660258372154-CodeCleanup3.ts
+++ /dev/null
@@ -1,19 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup31660258372154 implements MigrationInterface {
- name = 'CodeCleanup31660258372154'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "users" DROP COLUMN "settings"
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "users"
- ADD "settings" text NOT NULL
- `);
- }
-
-}
diff --git a/util/src/migrations/postgres/1660260565996-CodeCleanup4.ts b/util/src/migrations/postgres/1660260565996-CodeCleanup4.ts
deleted file mode 100644
index 0aaf7197..00000000
--- a/util/src/migrations/postgres/1660260565996-CodeCleanup4.ts
+++ /dev/null
@@ -1,33 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup41660260565996 implements MigrationInterface {
- name = 'CodeCleanup41660260565996'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "users"
- ADD "settingsId" character varying
- `);
- await queryRunner.query(`
- ALTER TABLE "users"
- ADD CONSTRAINT "UQ_76ba283779c8441fd5ff819c8cf" UNIQUE ("settingsId")
- `);
- await queryRunner.query(`
- ALTER TABLE "users"
- ADD CONSTRAINT "FK_76ba283779c8441fd5ff819c8cf" FOREIGN KEY ("settingsId") REFERENCES "user_settings"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "users" DROP CONSTRAINT "FK_76ba283779c8441fd5ff819c8cf"
- `);
- await queryRunner.query(`
- ALTER TABLE "users" DROP CONSTRAINT "UQ_76ba283779c8441fd5ff819c8cf"
- `);
- await queryRunner.query(`
- ALTER TABLE "users" DROP COLUMN "settingsId"
- `);
- }
-
-}
diff --git a/util/src/migrations/postgres/1660265907544-CodeCleanup5.ts b/util/src/migrations/postgres/1660265907544-CodeCleanup5.ts
deleted file mode 100644
index 157d686a..00000000
--- a/util/src/migrations/postgres/1660265907544-CodeCleanup5.ts
+++ /dev/null
@@ -1,26 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup51660265907544 implements MigrationInterface {
- name = 'CodeCleanup51660265907544'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "channels"
- ADD "flags" integer
- `);
- await queryRunner.query(`
- ALTER TABLE "channels"
- ADD "default_thread_rate_limit_per_user" integer
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "channels" DROP COLUMN "default_thread_rate_limit_per_user"
- `);
- await queryRunner.query(`
- ALTER TABLE "channels" DROP COLUMN "flags"
- `);
- }
-
-}
diff --git a/util/src/migrations/sqlite/1659899662635-initial.ts b/util/src/migrations/sqlite/1659899662635-initial.ts
deleted file mode 100644
index f82e7b0d..00000000
--- a/util/src/migrations/sqlite/1659899662635-initial.ts
+++ /dev/null
@@ -1,3529 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class initial1659899662635 implements MigrationInterface {
- name = 'initial1659899662635'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- CREATE TABLE "config" ("key" varchar PRIMARY KEY NOT NULL, "value" text)
- `);
- await queryRunner.query(`
- CREATE TABLE "relationships" (
- "id" varchar PRIMARY KEY NOT NULL,
- "from_id" varchar NOT NULL,
- "to_id" varchar NOT NULL,
- "nickname" varchar,
- "type" integer NOT NULL
- )
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_a0b2ff0a598df0b0d055934a17" ON "relationships" ("from_id", "to_id")
- `);
- await queryRunner.query(`
- CREATE TABLE "connected_accounts" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "access_token" varchar NOT NULL,
- "friend_sync" boolean NOT NULL,
- "name" varchar NOT NULL,
- "revoked" boolean NOT NULL,
- "show_activity" boolean NOT NULL,
- "type" varchar NOT NULL,
- "verified" boolean NOT NULL,
- "visibility" integer NOT NULL
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "users" (
- "id" varchar PRIMARY KEY NOT NULL,
- "username" varchar NOT NULL,
- "discriminator" varchar NOT NULL,
- "avatar" varchar,
- "accent_color" integer,
- "banner" varchar,
- "phone" varchar,
- "desktop" boolean NOT NULL,
- "mobile" boolean NOT NULL,
- "premium" boolean NOT NULL,
- "premium_type" integer NOT NULL,
- "bot" boolean NOT NULL,
- "bio" varchar NOT NULL,
- "system" boolean NOT NULL,
- "nsfw_allowed" boolean NOT NULL,
- "mfa_enabled" boolean NOT NULL,
- "totp_secret" varchar,
- "totp_last_ticket" varchar,
- "created_at" datetime NOT NULL,
- "premium_since" datetime,
- "verified" boolean NOT NULL,
- "disabled" boolean NOT NULL,
- "deleted" boolean NOT NULL,
- "email" varchar,
- "flags" varchar NOT NULL,
- "public_flags" integer NOT NULL,
- "rights" bigint NOT NULL,
- "data" text NOT NULL,
- "fingerprints" text NOT NULL,
- "settings" text NOT NULL,
- "extended_settings" text NOT NULL,
- "notes" text NOT NULL
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "backup_codes" (
- "id" varchar PRIMARY KEY NOT NULL,
- "code" varchar NOT NULL,
- "consumed" boolean NOT NULL,
- "expired" boolean NOT NULL,
- "user_id" varchar
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "bans" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "guild_id" varchar,
- "executor_id" varchar,
- "ip" varchar NOT NULL,
- "reason" varchar
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "recipients" (
- "id" varchar PRIMARY KEY NOT NULL,
- "channel_id" varchar NOT NULL,
- "user_id" varchar NOT NULL,
- "closed" boolean NOT NULL DEFAULT (0)
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "roles" (
- "id" varchar PRIMARY KEY NOT NULL,
- "guild_id" varchar,
- "color" integer NOT NULL,
- "hoist" boolean NOT NULL,
- "managed" boolean NOT NULL,
- "mentionable" boolean NOT NULL,
- "name" varchar NOT NULL,
- "permissions" varchar NOT NULL,
- "position" integer NOT NULL,
- "icon" varchar,
- "unicode_emoji" varchar,
- "tags" text
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "members" (
- "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- "id" varchar NOT NULL,
- "guild_id" varchar NOT NULL,
- "nick" varchar,
- "joined_at" datetime NOT NULL,
- "premium_since" bigint,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "pending" boolean NOT NULL,
- "settings" text NOT NULL,
- "last_message_id" varchar,
- "joined_by" varchar
- )
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id")
- `);
- await queryRunner.query(`
- CREATE TABLE "webhooks" (
- "id" varchar PRIMARY KEY NOT NULL,
- "type" integer NOT NULL,
- "name" varchar,
- "avatar" varchar,
- "token" varchar,
- "guild_id" varchar,
- "channel_id" varchar,
- "application_id" varchar,
- "user_id" varchar,
- "source_guild_id" varchar
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "stickers" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "description" varchar,
- "available" boolean,
- "tags" varchar,
- "pack_id" varchar,
- "guild_id" varchar,
- "user_id" varchar,
- "type" integer NOT NULL,
- "format_type" integer NOT NULL
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "attachments" (
- "id" varchar PRIMARY KEY NOT NULL,
- "filename" varchar NOT NULL,
- "size" integer NOT NULL,
- "url" varchar NOT NULL,
- "proxy_url" varchar NOT NULL,
- "height" integer,
- "width" integer,
- "content_type" varchar,
- "message_id" varchar
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "messages" (
- "id" varchar PRIMARY KEY NOT NULL,
- "channel_id" varchar,
- "guild_id" varchar,
- "author_id" varchar,
- "member_id" varchar,
- "webhook_id" varchar,
- "application_id" varchar,
- "content" varchar,
- "timestamp" datetime NOT NULL DEFAULT (datetime('now')),
- "edited_timestamp" datetime,
- "tts" boolean,
- "mention_everyone" boolean,
- "embeds" text NOT NULL,
- "reactions" text NOT NULL,
- "nonce" text,
- "pinned" boolean,
- "type" integer NOT NULL,
- "activity" text,
- "flags" varchar,
- "message_reference" text,
- "interaction" text,
- "components" text,
- "message_reference_id" varchar
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_86b9109b155eb70c0a2ca3b4b6" ON "messages" ("channel_id")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_05535bc695e9f7ee104616459d" ON "messages" ("author_id")
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_3ed7a60fb7dbe04e1ba9332a8b" ON "messages" ("channel_id", "id")
- `);
- await queryRunner.query(`
- CREATE TABLE "read_states" (
- "id" varchar PRIMARY KEY NOT NULL,
- "channel_id" varchar NOT NULL,
- "user_id" varchar NOT NULL,
- "last_message_id" varchar,
- "public_ack" varchar,
- "notifications_cursor" varchar,
- "last_pin_timestamp" datetime,
- "mention_count" integer
- )
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_0abf8b443321bd3cf7f81ee17a" ON "read_states" ("channel_id", "user_id")
- `);
- 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
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "voice_states" (
- "id" varchar PRIMARY KEY NOT NULL,
- "guild_id" varchar,
- "channel_id" varchar,
- "user_id" varchar,
- "session_id" varchar NOT NULL,
- "token" varchar,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "self_deaf" boolean NOT NULL,
- "self_mute" boolean NOT NULL,
- "self_stream" boolean,
- "self_video" boolean NOT NULL,
- "suppress" boolean NOT NULL,
- "request_to_speak_timestamp" datetime
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "channels" (
- "id" varchar PRIMARY KEY NOT NULL,
- "created_at" datetime NOT NULL,
- "name" varchar,
- "icon" text,
- "type" integer NOT NULL,
- "last_message_id" varchar,
- "guild_id" varchar,
- "parent_id" varchar,
- "owner_id" varchar,
- "last_pin_timestamp" integer,
- "default_auto_archive_duration" integer,
- "position" integer,
- "permission_overwrites" text,
- "video_quality_mode" integer,
- "bitrate" integer,
- "user_limit" integer,
- "nsfw" boolean,
- "rate_limit_per_user" integer,
- "topic" varchar,
- "retention_policy_id" varchar
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "emojis" (
- "id" varchar PRIMARY KEY NOT NULL,
- "animated" boolean NOT NULL,
- "available" boolean NOT NULL,
- "guild_id" varchar NOT NULL,
- "user_id" varchar,
- "managed" boolean NOT NULL,
- "name" varchar NOT NULL,
- "require_colons" boolean NOT NULL,
- "roles" text NOT NULL,
- "groups" text
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "templates" (
- "id" varchar PRIMARY KEY NOT NULL,
- "code" varchar NOT NULL,
- "name" varchar NOT NULL,
- "description" varchar,
- "usage_count" integer,
- "creator_id" varchar,
- "created_at" datetime NOT NULL,
- "updated_at" datetime NOT NULL,
- "source_guild_id" varchar,
- "serialized_source_guild" text NOT NULL,
- CONSTRAINT "UQ_be38737bf339baf63b1daeffb55" UNIQUE ("code")
- )
- `);
- 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
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "team_members" (
- "id" varchar PRIMARY KEY NOT NULL,
- "membership_state" integer NOT NULL,
- "permissions" text NOT NULL,
- "team_id" varchar,
- "user_id" varchar
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "teams" (
- "id" varchar PRIMARY KEY NOT NULL,
- "icon" varchar,
- "name" varchar NOT NULL,
- "owner_user_id" varchar
- )
- `);
- 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
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "audit_logs" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "action_type" integer NOT NULL,
- "options" text,
- "changes" text NOT NULL,
- "reason" varchar,
- "target_id" varchar
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "categories" (
- "id" integer PRIMARY KEY NOT NULL,
- "name" varchar,
- "localizations" text NOT NULL,
- "is_primary" boolean
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "rate_limits" (
- "id" varchar PRIMARY KEY NOT NULL,
- "executor_id" varchar NOT NULL,
- "hits" integer NOT NULL,
- "blocked" boolean NOT NULL,
- "expires_at" datetime NOT NULL
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "sessions" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "session_id" varchar NOT NULL,
- "activities" text,
- "client_info" text NOT NULL,
- "status" varchar NOT NULL
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "sticker_packs" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "description" varchar,
- "banner_asset_id" varchar,
- "cover_sticker_id" varchar,
- "coverStickerId" varchar
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "client_release" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "pub_date" varchar NOT NULL,
- "url" varchar NOT NULL,
- "deb_url" varchar NOT NULL,
- "osx_url" varchar NOT NULL,
- "win_url" varchar NOT NULL,
- "notes" varchar
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "notes" (
- "id" varchar PRIMARY KEY NOT NULL,
- "content" varchar NOT NULL,
- "owner_id" varchar,
- "target_id" varchar,
- CONSTRAINT "UQ_74e6689b9568cc965b8bfc9150b" UNIQUE ("owner_id", "target_id")
- )
- `);
- await queryRunner.query(`
- CREATE TABLE "member_roles" (
- "index" integer NOT NULL,
- "role_id" varchar NOT NULL,
- PRIMARY KEY ("index", "role_id")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_5d7ddc8a5f9c167f548625e772" ON "member_roles" ("index")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_e9080e7a7997a0170026d5139c" ON "member_roles" ("role_id")
- `);
- await queryRunner.query(`
- CREATE TABLE "message_user_mentions" (
- "messagesId" varchar NOT NULL,
- "usersId" varchar NOT NULL,
- PRIMARY KEY ("messagesId", "usersId")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_a343387fc560ef378760681c23" ON "message_user_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_b831eb18ceebd28976239b1e2f" ON "message_user_mentions" ("usersId")
- `);
- await queryRunner.query(`
- CREATE TABLE "message_role_mentions" (
- "messagesId" varchar NOT NULL,
- "rolesId" varchar NOT NULL,
- PRIMARY KEY ("messagesId", "rolesId")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_a8242cf535337a490b0feaea0b" ON "message_role_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_29d63eb1a458200851bc37d074" ON "message_role_mentions" ("rolesId")
- `);
- await queryRunner.query(`
- CREATE TABLE "message_channel_mentions" (
- "messagesId" varchar NOT NULL,
- "channelsId" varchar NOT NULL,
- PRIMARY KEY ("messagesId", "channelsId")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_2a27102ecd1d81b4582a436092" ON "message_channel_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_bdb8c09e1464cabf62105bf4b9" ON "message_channel_mentions" ("channelsId")
- `);
- await queryRunner.query(`
- CREATE TABLE "message_stickers" (
- "messagesId" varchar NOT NULL,
- "stickersId" varchar NOT NULL,
- PRIMARY KEY ("messagesId", "stickersId")
- )
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_40bb6f23e7cc133292e92829d2" ON "message_stickers" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_e22a70819d07659c7a71c112a1" ON "message_stickers" ("stickersId")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_a0b2ff0a598df0b0d055934a17"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_relationships" (
- "id" varchar PRIMARY KEY NOT NULL,
- "from_id" varchar NOT NULL,
- "to_id" varchar NOT NULL,
- "nickname" varchar,
- "type" integer NOT NULL,
- CONSTRAINT "FK_9af4194bab1250b1c584ae4f1d7" FOREIGN KEY ("from_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_9c7f6b98a9843b76dce1b0c878b" FOREIGN KEY ("to_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_relationships"("id", "from_id", "to_id", "nickname", "type")
- SELECT "id",
- "from_id",
- "to_id",
- "nickname",
- "type"
- FROM "relationships"
- `);
- await queryRunner.query(`
- DROP TABLE "relationships"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_relationships"
- RENAME TO "relationships"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_a0b2ff0a598df0b0d055934a17" ON "relationships" ("from_id", "to_id")
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_connected_accounts" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "access_token" varchar NOT NULL,
- "friend_sync" boolean NOT NULL,
- "name" varchar NOT NULL,
- "revoked" boolean NOT NULL,
- "show_activity" boolean NOT NULL,
- "type" varchar NOT NULL,
- "verified" boolean NOT NULL,
- "visibility" integer NOT NULL,
- CONSTRAINT "FK_f47244225a6a1eac04a3463dd90" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_connected_accounts"(
- "id",
- "user_id",
- "access_token",
- "friend_sync",
- "name",
- "revoked",
- "show_activity",
- "type",
- "verified",
- "visibility"
- )
- SELECT "id",
- "user_id",
- "access_token",
- "friend_sync",
- "name",
- "revoked",
- "show_activity",
- "type",
- "verified",
- "visibility"
- FROM "connected_accounts"
- `);
- await queryRunner.query(`
- DROP TABLE "connected_accounts"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_connected_accounts"
- RENAME TO "connected_accounts"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_backup_codes" (
- "id" varchar PRIMARY KEY NOT NULL,
- "code" varchar NOT NULL,
- "consumed" boolean NOT NULL,
- "expired" boolean NOT NULL,
- "user_id" varchar,
- CONSTRAINT "FK_70066ea80d2f4b871beda32633b" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_backup_codes"("id", "code", "consumed", "expired", "user_id")
- SELECT "id",
- "code",
- "consumed",
- "expired",
- "user_id"
- FROM "backup_codes"
- `);
- await queryRunner.query(`
- DROP TABLE "backup_codes"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_backup_codes"
- RENAME TO "backup_codes"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_bans" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "guild_id" varchar,
- "executor_id" varchar,
- "ip" varchar NOT NULL,
- "reason" varchar,
- CONSTRAINT "FK_5999e8e449f80a236ff72023559" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_9d3ab7dd180ebdd245cdb66ecad" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_07ad88c86d1f290d46748410d58" FOREIGN KEY ("executor_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_bans"(
- "id",
- "user_id",
- "guild_id",
- "executor_id",
- "ip",
- "reason"
- )
- SELECT "id",
- "user_id",
- "guild_id",
- "executor_id",
- "ip",
- "reason"
- FROM "bans"
- `);
- await queryRunner.query(`
- DROP TABLE "bans"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_bans"
- RENAME TO "bans"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_recipients" (
- "id" varchar PRIMARY KEY NOT NULL,
- "channel_id" varchar NOT NULL,
- "user_id" varchar NOT NULL,
- "closed" boolean NOT NULL DEFAULT (0),
- CONSTRAINT "FK_2f18ee1ba667f233ae86c0ea60e" FOREIGN KEY ("channel_id") REFERENCES "channels" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_6157e8b6ba4e6e3089616481fe2" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_recipients"("id", "channel_id", "user_id", "closed")
- SELECT "id",
- "channel_id",
- "user_id",
- "closed"
- FROM "recipients"
- `);
- await queryRunner.query(`
- DROP TABLE "recipients"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_recipients"
- RENAME TO "recipients"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_roles" (
- "id" varchar PRIMARY KEY NOT NULL,
- "guild_id" varchar,
- "color" integer NOT NULL,
- "hoist" boolean NOT NULL,
- "managed" boolean NOT NULL,
- "mentionable" boolean NOT NULL,
- "name" varchar NOT NULL,
- "permissions" varchar NOT NULL,
- "position" integer NOT NULL,
- "icon" varchar,
- "unicode_emoji" varchar,
- "tags" text,
- CONSTRAINT "FK_c32c1ab1c4dc7dcb0278c4b1b8b" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_roles"(
- "id",
- "guild_id",
- "color",
- "hoist",
- "managed",
- "mentionable",
- "name",
- "permissions",
- "position",
- "icon",
- "unicode_emoji",
- "tags"
- )
- SELECT "id",
- "guild_id",
- "color",
- "hoist",
- "managed",
- "mentionable",
- "name",
- "permissions",
- "position",
- "icon",
- "unicode_emoji",
- "tags"
- FROM "roles"
- `);
- await queryRunner.query(`
- DROP TABLE "roles"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_roles"
- RENAME TO "roles"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_members" (
- "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- "id" varchar NOT NULL,
- "guild_id" varchar NOT NULL,
- "nick" varchar,
- "joined_at" datetime NOT NULL,
- "premium_since" bigint,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "pending" boolean NOT NULL,
- "settings" text NOT NULL,
- "last_message_id" varchar,
- "joined_by" varchar,
- CONSTRAINT "FK_28b53062261b996d9c99fa12404" FOREIGN KEY ("id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_members"(
- "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- )
- SELECT "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- FROM "members"
- `);
- await queryRunner.query(`
- DROP TABLE "members"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_members"
- RENAME TO "members"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id")
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_webhooks" (
- "id" varchar PRIMARY KEY NOT NULL,
- "type" integer NOT NULL,
- "name" varchar,
- "avatar" varchar,
- "token" varchar,
- "guild_id" varchar,
- "channel_id" varchar,
- "application_id" varchar,
- "user_id" varchar,
- "source_guild_id" varchar,
- CONSTRAINT "FK_487a7af59d189f744fe394368fc" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_df528cf77e82f8032230e7e37d8" FOREIGN KEY ("channel_id") REFERENCES "channels" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_c3e5305461931763b56aa905f1c" FOREIGN KEY ("application_id") REFERENCES "applications" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_0d523f6f997c86e052c49b1455f" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_3a285f4f49c40e0706d3018bc9f" FOREIGN KEY ("source_guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_webhooks"(
- "id",
- "type",
- "name",
- "avatar",
- "token",
- "guild_id",
- "channel_id",
- "application_id",
- "user_id",
- "source_guild_id"
- )
- SELECT "id",
- "type",
- "name",
- "avatar",
- "token",
- "guild_id",
- "channel_id",
- "application_id",
- "user_id",
- "source_guild_id"
- FROM "webhooks"
- `);
- await queryRunner.query(`
- DROP TABLE "webhooks"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_webhooks"
- RENAME TO "webhooks"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_stickers" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "description" varchar,
- "available" boolean,
- "tags" varchar,
- "pack_id" varchar,
- "guild_id" varchar,
- "user_id" varchar,
- "type" integer NOT NULL,
- "format_type" integer NOT NULL,
- CONSTRAINT "FK_e7cfa5cefa6661b3fb8fda8ce69" FOREIGN KEY ("pack_id") REFERENCES "sticker_packs" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_193d551d852aca5347ef5c9f205" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_8f4ee73f2bb2325ff980502e158" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_stickers"(
- "id",
- "name",
- "description",
- "available",
- "tags",
- "pack_id",
- "guild_id",
- "user_id",
- "type",
- "format_type"
- )
- SELECT "id",
- "name",
- "description",
- "available",
- "tags",
- "pack_id",
- "guild_id",
- "user_id",
- "type",
- "format_type"
- FROM "stickers"
- `);
- await queryRunner.query(`
- DROP TABLE "stickers"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_stickers"
- RENAME TO "stickers"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_attachments" (
- "id" varchar PRIMARY KEY NOT NULL,
- "filename" varchar NOT NULL,
- "size" integer NOT NULL,
- "url" varchar NOT NULL,
- "proxy_url" varchar NOT NULL,
- "height" integer,
- "width" integer,
- "content_type" varchar,
- "message_id" varchar,
- CONSTRAINT "FK_623e10eec51ada466c5038979e3" FOREIGN KEY ("message_id") REFERENCES "messages" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_attachments"(
- "id",
- "filename",
- "size",
- "url",
- "proxy_url",
- "height",
- "width",
- "content_type",
- "message_id"
- )
- SELECT "id",
- "filename",
- "size",
- "url",
- "proxy_url",
- "height",
- "width",
- "content_type",
- "message_id"
- FROM "attachments"
- `);
- await queryRunner.query(`
- DROP TABLE "attachments"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_attachments"
- RENAME TO "attachments"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_86b9109b155eb70c0a2ca3b4b6"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_05535bc695e9f7ee104616459d"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_3ed7a60fb7dbe04e1ba9332a8b"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_messages" (
- "id" varchar PRIMARY KEY NOT NULL,
- "channel_id" varchar,
- "guild_id" varchar,
- "author_id" varchar,
- "member_id" varchar,
- "webhook_id" varchar,
- "application_id" varchar,
- "content" varchar,
- "timestamp" datetime NOT NULL DEFAULT (datetime('now')),
- "edited_timestamp" datetime,
- "tts" boolean,
- "mention_everyone" boolean,
- "embeds" text NOT NULL,
- "reactions" text NOT NULL,
- "nonce" text,
- "pinned" boolean,
- "type" integer NOT NULL,
- "activity" text,
- "flags" varchar,
- "message_reference" text,
- "interaction" text,
- "components" text,
- "message_reference_id" varchar,
- CONSTRAINT "FK_86b9109b155eb70c0a2ca3b4b6d" FOREIGN KEY ("channel_id") REFERENCES "channels" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_b193588441b085352a4c0109423" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_05535bc695e9f7ee104616459d3" FOREIGN KEY ("author_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_b0525304f2262b7014245351c76" FOREIGN KEY ("member_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_f83c04bcf1df4e5c0e7a52ed348" FOREIGN KEY ("webhook_id") REFERENCES "webhooks" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT "FK_5d3ec1cb962de6488637fd779d6" FOREIGN KEY ("application_id") REFERENCES "applications" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT "FK_61a92bb65b302a76d9c1fcd3174" FOREIGN KEY ("message_reference_id") REFERENCES "messages" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_messages"(
- "id",
- "channel_id",
- "guild_id",
- "author_id",
- "member_id",
- "webhook_id",
- "application_id",
- "content",
- "timestamp",
- "edited_timestamp",
- "tts",
- "mention_everyone",
- "embeds",
- "reactions",
- "nonce",
- "pinned",
- "type",
- "activity",
- "flags",
- "message_reference",
- "interaction",
- "components",
- "message_reference_id"
- )
- SELECT "id",
- "channel_id",
- "guild_id",
- "author_id",
- "member_id",
- "webhook_id",
- "application_id",
- "content",
- "timestamp",
- "edited_timestamp",
- "tts",
- "mention_everyone",
- "embeds",
- "reactions",
- "nonce",
- "pinned",
- "type",
- "activity",
- "flags",
- "message_reference",
- "interaction",
- "components",
- "message_reference_id"
- FROM "messages"
- `);
- await queryRunner.query(`
- DROP TABLE "messages"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_messages"
- RENAME TO "messages"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_86b9109b155eb70c0a2ca3b4b6" ON "messages" ("channel_id")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_05535bc695e9f7ee104616459d" ON "messages" ("author_id")
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_3ed7a60fb7dbe04e1ba9332a8b" ON "messages" ("channel_id", "id")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_0abf8b443321bd3cf7f81ee17a"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_read_states" (
- "id" varchar PRIMARY KEY NOT NULL,
- "channel_id" varchar NOT NULL,
- "user_id" varchar NOT NULL,
- "last_message_id" varchar,
- "public_ack" varchar,
- "notifications_cursor" varchar,
- "last_pin_timestamp" datetime,
- "mention_count" integer,
- CONSTRAINT "FK_40da2fca4e0eaf7a23b5bfc5d34" FOREIGN KEY ("channel_id") REFERENCES "channels" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_195f92e4dd1254a4e348c043763" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_read_states"(
- "id",
- "channel_id",
- "user_id",
- "last_message_id",
- "public_ack",
- "notifications_cursor",
- "last_pin_timestamp",
- "mention_count"
- )
- SELECT "id",
- "channel_id",
- "user_id",
- "last_message_id",
- "public_ack",
- "notifications_cursor",
- "last_pin_timestamp",
- "mention_count"
- FROM "read_states"
- `);
- await queryRunner.query(`
- DROP TABLE "read_states"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_read_states"
- RENAME TO "read_states"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_0abf8b443321bd3cf7f81ee17a" ON "read_states" ("channel_id", "user_id")
- `);
- 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_3f4939aa1461e8af57fea3fb05d" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("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_15c35422032e0b22b4ada95f48f" FOREIGN KEY ("inviter_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT "FK_11a0d394f8fc649c19ce5f16b59" FOREIGN KEY ("target_user_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"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_voice_states" (
- "id" varchar PRIMARY KEY NOT NULL,
- "guild_id" varchar,
- "channel_id" varchar,
- "user_id" varchar,
- "session_id" varchar NOT NULL,
- "token" varchar,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "self_deaf" boolean NOT NULL,
- "self_mute" boolean NOT NULL,
- "self_stream" boolean,
- "self_video" boolean NOT NULL,
- "suppress" boolean NOT NULL,
- "request_to_speak_timestamp" datetime,
- CONSTRAINT "FK_03779ef216d4b0358470d9cb748" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_9f8d389866b40b6657edd026dd4" FOREIGN KEY ("channel_id") REFERENCES "channels" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_5fe1d5f931a67e85039c640001b" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_voice_states"(
- "id",
- "guild_id",
- "channel_id",
- "user_id",
- "session_id",
- "token",
- "deaf",
- "mute",
- "self_deaf",
- "self_mute",
- "self_stream",
- "self_video",
- "suppress",
- "request_to_speak_timestamp"
- )
- SELECT "id",
- "guild_id",
- "channel_id",
- "user_id",
- "session_id",
- "token",
- "deaf",
- "mute",
- "self_deaf",
- "self_mute",
- "self_stream",
- "self_video",
- "suppress",
- "request_to_speak_timestamp"
- FROM "voice_states"
- `);
- await queryRunner.query(`
- DROP TABLE "voice_states"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_voice_states"
- RENAME TO "voice_states"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_channels" (
- "id" varchar PRIMARY KEY NOT NULL,
- "created_at" datetime NOT NULL,
- "name" varchar,
- "icon" text,
- "type" integer NOT NULL,
- "last_message_id" varchar,
- "guild_id" varchar,
- "parent_id" varchar,
- "owner_id" varchar,
- "last_pin_timestamp" integer,
- "default_auto_archive_duration" integer,
- "position" integer,
- "permission_overwrites" text,
- "video_quality_mode" integer,
- "bitrate" integer,
- "user_limit" integer,
- "nsfw" boolean,
- "rate_limit_per_user" integer,
- "topic" varchar,
- "retention_policy_id" varchar,
- CONSTRAINT "FK_c253dafe5f3a03ec00cd8fb4581" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_3274522d14af40540b1a883fc80" FOREIGN KEY ("parent_id") REFERENCES "channels" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT "FK_3873ed438575cce703ecff4fc7b" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_channels"(
- "id",
- "created_at",
- "name",
- "icon",
- "type",
- "last_message_id",
- "guild_id",
- "parent_id",
- "owner_id",
- "last_pin_timestamp",
- "default_auto_archive_duration",
- "position",
- "permission_overwrites",
- "video_quality_mode",
- "bitrate",
- "user_limit",
- "nsfw",
- "rate_limit_per_user",
- "topic",
- "retention_policy_id"
- )
- SELECT "id",
- "created_at",
- "name",
- "icon",
- "type",
- "last_message_id",
- "guild_id",
- "parent_id",
- "owner_id",
- "last_pin_timestamp",
- "default_auto_archive_duration",
- "position",
- "permission_overwrites",
- "video_quality_mode",
- "bitrate",
- "user_limit",
- "nsfw",
- "rate_limit_per_user",
- "topic",
- "retention_policy_id"
- FROM "channels"
- `);
- await queryRunner.query(`
- DROP TABLE "channels"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_channels"
- RENAME TO "channels"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_emojis" (
- "id" varchar PRIMARY KEY NOT NULL,
- "animated" boolean NOT NULL,
- "available" boolean NOT NULL,
- "guild_id" varchar NOT NULL,
- "user_id" varchar,
- "managed" boolean NOT NULL,
- "name" varchar NOT NULL,
- "require_colons" boolean NOT NULL,
- "roles" text NOT NULL,
- "groups" text,
- CONSTRAINT "FK_4b988e0db89d94cebcf07f598cc" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_fa7ddd5f9a214e28ce596548421" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_emojis"(
- "id",
- "animated",
- "available",
- "guild_id",
- "user_id",
- "managed",
- "name",
- "require_colons",
- "roles",
- "groups"
- )
- SELECT "id",
- "animated",
- "available",
- "guild_id",
- "user_id",
- "managed",
- "name",
- "require_colons",
- "roles",
- "groups"
- FROM "emojis"
- `);
- await queryRunner.query(`
- DROP TABLE "emojis"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_emojis"
- RENAME TO "emojis"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_templates" (
- "id" varchar PRIMARY KEY NOT NULL,
- "code" varchar NOT NULL,
- "name" varchar NOT NULL,
- "description" varchar,
- "usage_count" integer,
- "creator_id" varchar,
- "created_at" datetime NOT NULL,
- "updated_at" datetime NOT NULL,
- "source_guild_id" varchar,
- "serialized_source_guild" text NOT NULL,
- CONSTRAINT "UQ_be38737bf339baf63b1daeffb55" UNIQUE ("code"),
- CONSTRAINT "FK_d7374b7f8f5fbfdececa4fb62e1" FOREIGN KEY ("creator_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT "FK_445d00eaaea0e60a017a5ed0c11" FOREIGN KEY ("source_guild_id") REFERENCES "guilds" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_templates"(
- "id",
- "code",
- "name",
- "description",
- "usage_count",
- "creator_id",
- "created_at",
- "updated_at",
- "source_guild_id",
- "serialized_source_guild"
- )
- SELECT "id",
- "code",
- "name",
- "description",
- "usage_count",
- "creator_id",
- "created_at",
- "updated_at",
- "source_guild_id",
- "serialized_source_guild"
- FROM "templates"
- `);
- await queryRunner.query(`
- DROP TABLE "templates"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_templates"
- RENAME TO "templates"
- `);
- 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,
- 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"
- )
- 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"
- FROM "guilds"
- `);
- await queryRunner.query(`
- DROP TABLE "guilds"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_guilds"
- RENAME TO "guilds"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_team_members" (
- "id" varchar PRIMARY KEY NOT NULL,
- "membership_state" integer NOT NULL,
- "permissions" text NOT NULL,
- "team_id" varchar,
- "user_id" varchar,
- CONSTRAINT "FK_fdad7d5768277e60c40e01cdcea" FOREIGN KEY ("team_id") REFERENCES "teams" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_c2bf4967c8c2a6b845dadfbf3d4" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_team_members"(
- "id",
- "membership_state",
- "permissions",
- "team_id",
- "user_id"
- )
- SELECT "id",
- "membership_state",
- "permissions",
- "team_id",
- "user_id"
- FROM "team_members"
- `);
- await queryRunner.query(`
- DROP TABLE "team_members"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_team_members"
- RENAME TO "team_members"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_teams" (
- "id" varchar PRIMARY KEY NOT NULL,
- "icon" varchar,
- "name" varchar NOT NULL,
- "owner_user_id" varchar,
- CONSTRAINT "FK_13f00abf7cb6096c43ecaf8c108" FOREIGN KEY ("owner_user_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_teams"("id", "icon", "name", "owner_user_id")
- SELECT "id",
- "icon",
- "name",
- "owner_user_id"
- FROM "teams"
- `);
- await queryRunner.query(`
- DROP TABLE "teams"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_teams"
- RENAME TO "teams"
- `);
- 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_e57508958bf92b9d9d25231b5e8" FOREIGN KEY ("owner_id") REFERENCES "users" ("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_e5bf78cdbbe9ba91062d74c5aba" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("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_audit_logs" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "action_type" integer NOT NULL,
- "options" text,
- "changes" text NOT NULL,
- "reason" varchar,
- "target_id" varchar,
- CONSTRAINT "FK_3cd01cd3ae7aab010310d96ac8e" FOREIGN KEY ("target_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT "FK_bd2726fd31b35443f2245b93ba0" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_audit_logs"(
- "id",
- "user_id",
- "action_type",
- "options",
- "changes",
- "reason",
- "target_id"
- )
- SELECT "id",
- "user_id",
- "action_type",
- "options",
- "changes",
- "reason",
- "target_id"
- FROM "audit_logs"
- `);
- await queryRunner.query(`
- DROP TABLE "audit_logs"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_audit_logs"
- RENAME TO "audit_logs"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_sessions" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "session_id" varchar NOT NULL,
- "activities" text,
- "client_info" text NOT NULL,
- "status" varchar NOT NULL,
- CONSTRAINT "FK_085d540d9f418cfbdc7bd55bb19" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_sessions"(
- "id",
- "user_id",
- "session_id",
- "activities",
- "client_info",
- "status"
- )
- SELECT "id",
- "user_id",
- "session_id",
- "activities",
- "client_info",
- "status"
- FROM "sessions"
- `);
- await queryRunner.query(`
- DROP TABLE "sessions"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_sessions"
- RENAME TO "sessions"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_sticker_packs" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "description" varchar,
- "banner_asset_id" varchar,
- "cover_sticker_id" varchar,
- "coverStickerId" varchar,
- CONSTRAINT "FK_448fafba4355ee1c837bbc865f1" FOREIGN KEY ("coverStickerId") REFERENCES "stickers" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_sticker_packs"(
- "id",
- "name",
- "description",
- "banner_asset_id",
- "cover_sticker_id",
- "coverStickerId"
- )
- SELECT "id",
- "name",
- "description",
- "banner_asset_id",
- "cover_sticker_id",
- "coverStickerId"
- FROM "sticker_packs"
- `);
- await queryRunner.query(`
- DROP TABLE "sticker_packs"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_sticker_packs"
- RENAME TO "sticker_packs"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_notes" (
- "id" varchar PRIMARY KEY NOT NULL,
- "content" varchar NOT NULL,
- "owner_id" varchar,
- "target_id" varchar,
- CONSTRAINT "UQ_74e6689b9568cc965b8bfc9150b" UNIQUE ("owner_id", "target_id"),
- CONSTRAINT "FK_f9e103f8ae67cb1787063597925" FOREIGN KEY ("owner_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_23e08e5b4481711d573e1abecdc" FOREIGN KEY ("target_id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_notes"("id", "content", "owner_id", "target_id")
- SELECT "id",
- "content",
- "owner_id",
- "target_id"
- FROM "notes"
- `);
- await queryRunner.query(`
- DROP TABLE "notes"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_notes"
- RENAME TO "notes"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_5d7ddc8a5f9c167f548625e772"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_e9080e7a7997a0170026d5139c"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_member_roles" (
- "index" integer NOT NULL,
- "role_id" varchar NOT NULL,
- CONSTRAINT "FK_5d7ddc8a5f9c167f548625e772e" FOREIGN KEY ("index") REFERENCES "members" ("index") ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT "FK_e9080e7a7997a0170026d5139c1" FOREIGN KEY ("role_id") REFERENCES "roles" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
- PRIMARY KEY ("index", "role_id")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_member_roles"("index", "role_id")
- SELECT "index",
- "role_id"
- FROM "member_roles"
- `);
- await queryRunner.query(`
- DROP TABLE "member_roles"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_member_roles"
- RENAME TO "member_roles"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_5d7ddc8a5f9c167f548625e772" ON "member_roles" ("index")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_e9080e7a7997a0170026d5139c" ON "member_roles" ("role_id")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_a343387fc560ef378760681c23"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_b831eb18ceebd28976239b1e2f"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_message_user_mentions" (
- "messagesId" varchar NOT NULL,
- "usersId" varchar NOT NULL,
- CONSTRAINT "FK_a343387fc560ef378760681c236" FOREIGN KEY ("messagesId") REFERENCES "messages" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT "FK_b831eb18ceebd28976239b1e2f8" FOREIGN KEY ("usersId") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
- PRIMARY KEY ("messagesId", "usersId")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_message_user_mentions"("messagesId", "usersId")
- SELECT "messagesId",
- "usersId"
- FROM "message_user_mentions"
- `);
- await queryRunner.query(`
- DROP TABLE "message_user_mentions"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_message_user_mentions"
- RENAME TO "message_user_mentions"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_a343387fc560ef378760681c23" ON "message_user_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_b831eb18ceebd28976239b1e2f" ON "message_user_mentions" ("usersId")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_a8242cf535337a490b0feaea0b"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_29d63eb1a458200851bc37d074"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_message_role_mentions" (
- "messagesId" varchar NOT NULL,
- "rolesId" varchar NOT NULL,
- CONSTRAINT "FK_a8242cf535337a490b0feaea0b4" FOREIGN KEY ("messagesId") REFERENCES "messages" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT "FK_29d63eb1a458200851bc37d074b" FOREIGN KEY ("rolesId") REFERENCES "roles" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
- PRIMARY KEY ("messagesId", "rolesId")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_message_role_mentions"("messagesId", "rolesId")
- SELECT "messagesId",
- "rolesId"
- FROM "message_role_mentions"
- `);
- await queryRunner.query(`
- DROP TABLE "message_role_mentions"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_message_role_mentions"
- RENAME TO "message_role_mentions"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_a8242cf535337a490b0feaea0b" ON "message_role_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_29d63eb1a458200851bc37d074" ON "message_role_mentions" ("rolesId")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_2a27102ecd1d81b4582a436092"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_bdb8c09e1464cabf62105bf4b9"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_message_channel_mentions" (
- "messagesId" varchar NOT NULL,
- "channelsId" varchar NOT NULL,
- CONSTRAINT "FK_2a27102ecd1d81b4582a4360921" FOREIGN KEY ("messagesId") REFERENCES "messages" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT "FK_bdb8c09e1464cabf62105bf4b9d" FOREIGN KEY ("channelsId") REFERENCES "channels" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
- PRIMARY KEY ("messagesId", "channelsId")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_message_channel_mentions"("messagesId", "channelsId")
- SELECT "messagesId",
- "channelsId"
- FROM "message_channel_mentions"
- `);
- await queryRunner.query(`
- DROP TABLE "message_channel_mentions"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_message_channel_mentions"
- RENAME TO "message_channel_mentions"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_2a27102ecd1d81b4582a436092" ON "message_channel_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_bdb8c09e1464cabf62105bf4b9" ON "message_channel_mentions" ("channelsId")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_40bb6f23e7cc133292e92829d2"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_e22a70819d07659c7a71c112a1"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_message_stickers" (
- "messagesId" varchar NOT NULL,
- "stickersId" varchar NOT NULL,
- CONSTRAINT "FK_40bb6f23e7cc133292e92829d28" FOREIGN KEY ("messagesId") REFERENCES "messages" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT "FK_e22a70819d07659c7a71c112a1f" FOREIGN KEY ("stickersId") REFERENCES "stickers" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
- PRIMARY KEY ("messagesId", "stickersId")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_message_stickers"("messagesId", "stickersId")
- SELECT "messagesId",
- "stickersId"
- FROM "message_stickers"
- `);
- await queryRunner.query(`
- DROP TABLE "message_stickers"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_message_stickers"
- RENAME TO "message_stickers"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_40bb6f23e7cc133292e92829d2" ON "message_stickers" ("messagesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_e22a70819d07659c7a71c112a1" ON "message_stickers" ("stickersId")
- `);
- await queryRunner.query(`
- CREATE TABLE "query-result-cache" (
- "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- "identifier" varchar,
- "time" bigint NOT NULL,
- "duration" integer NOT NULL,
- "query" text NOT NULL,
- "result" text NOT NULL
- )
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- DROP TABLE "query-result-cache"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_e22a70819d07659c7a71c112a1"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_40bb6f23e7cc133292e92829d2"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_stickers"
- RENAME TO "temporary_message_stickers"
- `);
- await queryRunner.query(`
- CREATE TABLE "message_stickers" (
- "messagesId" varchar NOT NULL,
- "stickersId" varchar NOT NULL,
- PRIMARY KEY ("messagesId", "stickersId")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "message_stickers"("messagesId", "stickersId")
- SELECT "messagesId",
- "stickersId"
- FROM "temporary_message_stickers"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_message_stickers"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_e22a70819d07659c7a71c112a1" ON "message_stickers" ("stickersId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_40bb6f23e7cc133292e92829d2" ON "message_stickers" ("messagesId")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_bdb8c09e1464cabf62105bf4b9"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_2a27102ecd1d81b4582a436092"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_channel_mentions"
- RENAME TO "temporary_message_channel_mentions"
- `);
- await queryRunner.query(`
- CREATE TABLE "message_channel_mentions" (
- "messagesId" varchar NOT NULL,
- "channelsId" varchar NOT NULL,
- PRIMARY KEY ("messagesId", "channelsId")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "message_channel_mentions"("messagesId", "channelsId")
- SELECT "messagesId",
- "channelsId"
- FROM "temporary_message_channel_mentions"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_message_channel_mentions"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_bdb8c09e1464cabf62105bf4b9" ON "message_channel_mentions" ("channelsId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_2a27102ecd1d81b4582a436092" ON "message_channel_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_29d63eb1a458200851bc37d074"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_a8242cf535337a490b0feaea0b"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_role_mentions"
- RENAME TO "temporary_message_role_mentions"
- `);
- await queryRunner.query(`
- CREATE TABLE "message_role_mentions" (
- "messagesId" varchar NOT NULL,
- "rolesId" varchar NOT NULL,
- PRIMARY KEY ("messagesId", "rolesId")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "message_role_mentions"("messagesId", "rolesId")
- SELECT "messagesId",
- "rolesId"
- FROM "temporary_message_role_mentions"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_message_role_mentions"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_29d63eb1a458200851bc37d074" ON "message_role_mentions" ("rolesId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_a8242cf535337a490b0feaea0b" ON "message_role_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_b831eb18ceebd28976239b1e2f"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_a343387fc560ef378760681c23"
- `);
- await queryRunner.query(`
- ALTER TABLE "message_user_mentions"
- RENAME TO "temporary_message_user_mentions"
- `);
- await queryRunner.query(`
- CREATE TABLE "message_user_mentions" (
- "messagesId" varchar NOT NULL,
- "usersId" varchar NOT NULL,
- PRIMARY KEY ("messagesId", "usersId")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "message_user_mentions"("messagesId", "usersId")
- SELECT "messagesId",
- "usersId"
- FROM "temporary_message_user_mentions"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_message_user_mentions"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_b831eb18ceebd28976239b1e2f" ON "message_user_mentions" ("usersId")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_a343387fc560ef378760681c23" ON "message_user_mentions" ("messagesId")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_e9080e7a7997a0170026d5139c"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_5d7ddc8a5f9c167f548625e772"
- `);
- await queryRunner.query(`
- ALTER TABLE "member_roles"
- RENAME TO "temporary_member_roles"
- `);
- await queryRunner.query(`
- CREATE TABLE "member_roles" (
- "index" integer NOT NULL,
- "role_id" varchar NOT NULL,
- PRIMARY KEY ("index", "role_id")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "member_roles"("index", "role_id")
- SELECT "index",
- "role_id"
- FROM "temporary_member_roles"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_member_roles"
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_e9080e7a7997a0170026d5139c" ON "member_roles" ("role_id")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_5d7ddc8a5f9c167f548625e772" ON "member_roles" ("index")
- `);
- await queryRunner.query(`
- ALTER TABLE "notes"
- RENAME TO "temporary_notes"
- `);
- await queryRunner.query(`
- CREATE TABLE "notes" (
- "id" varchar PRIMARY KEY NOT NULL,
- "content" varchar NOT NULL,
- "owner_id" varchar,
- "target_id" varchar,
- CONSTRAINT "UQ_74e6689b9568cc965b8bfc9150b" UNIQUE ("owner_id", "target_id")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "notes"("id", "content", "owner_id", "target_id")
- SELECT "id",
- "content",
- "owner_id",
- "target_id"
- FROM "temporary_notes"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_notes"
- `);
- await queryRunner.query(`
- ALTER TABLE "sticker_packs"
- RENAME TO "temporary_sticker_packs"
- `);
- await queryRunner.query(`
- CREATE TABLE "sticker_packs" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "description" varchar,
- "banner_asset_id" varchar,
- "cover_sticker_id" varchar,
- "coverStickerId" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "sticker_packs"(
- "id",
- "name",
- "description",
- "banner_asset_id",
- "cover_sticker_id",
- "coverStickerId"
- )
- SELECT "id",
- "name",
- "description",
- "banner_asset_id",
- "cover_sticker_id",
- "coverStickerId"
- FROM "temporary_sticker_packs"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_sticker_packs"
- `);
- await queryRunner.query(`
- ALTER TABLE "sessions"
- RENAME TO "temporary_sessions"
- `);
- await queryRunner.query(`
- CREATE TABLE "sessions" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "session_id" varchar NOT NULL,
- "activities" text,
- "client_info" text NOT NULL,
- "status" varchar NOT NULL
- )
- `);
- await queryRunner.query(`
- INSERT INTO "sessions"(
- "id",
- "user_id",
- "session_id",
- "activities",
- "client_info",
- "status"
- )
- SELECT "id",
- "user_id",
- "session_id",
- "activities",
- "client_info",
- "status"
- FROM "temporary_sessions"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_sessions"
- `);
- await queryRunner.query(`
- ALTER TABLE "audit_logs"
- RENAME TO "temporary_audit_logs"
- `);
- await queryRunner.query(`
- CREATE TABLE "audit_logs" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "action_type" integer NOT NULL,
- "options" text,
- "changes" text NOT NULL,
- "reason" varchar,
- "target_id" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "audit_logs"(
- "id",
- "user_id",
- "action_type",
- "options",
- "changes",
- "reason",
- "target_id"
- )
- SELECT "id",
- "user_id",
- "action_type",
- "options",
- "changes",
- "reason",
- "target_id"
- FROM "temporary_audit_logs"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_audit_logs"
- `);
- 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
- )
- `);
- 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"
- `);
- await queryRunner.query(`
- ALTER TABLE "teams"
- RENAME TO "temporary_teams"
- `);
- await queryRunner.query(`
- CREATE TABLE "teams" (
- "id" varchar PRIMARY KEY NOT NULL,
- "icon" varchar,
- "name" varchar NOT NULL,
- "owner_user_id" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "teams"("id", "icon", "name", "owner_user_id")
- SELECT "id",
- "icon",
- "name",
- "owner_user_id"
- FROM "temporary_teams"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_teams"
- `);
- await queryRunner.query(`
- ALTER TABLE "team_members"
- RENAME TO "temporary_team_members"
- `);
- await queryRunner.query(`
- CREATE TABLE "team_members" (
- "id" varchar PRIMARY KEY NOT NULL,
- "membership_state" integer NOT NULL,
- "permissions" text NOT NULL,
- "team_id" varchar,
- "user_id" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "team_members"(
- "id",
- "membership_state",
- "permissions",
- "team_id",
- "user_id"
- )
- SELECT "id",
- "membership_state",
- "permissions",
- "team_id",
- "user_id"
- FROM "temporary_team_members"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_team_members"
- `);
- 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
- )
- `);
- 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"
- )
- 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"
- FROM "temporary_guilds"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_guilds"
- `);
- await queryRunner.query(`
- ALTER TABLE "templates"
- RENAME TO "temporary_templates"
- `);
- await queryRunner.query(`
- CREATE TABLE "templates" (
- "id" varchar PRIMARY KEY NOT NULL,
- "code" varchar NOT NULL,
- "name" varchar NOT NULL,
- "description" varchar,
- "usage_count" integer,
- "creator_id" varchar,
- "created_at" datetime NOT NULL,
- "updated_at" datetime NOT NULL,
- "source_guild_id" varchar,
- "serialized_source_guild" text NOT NULL,
- CONSTRAINT "UQ_be38737bf339baf63b1daeffb55" UNIQUE ("code")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "templates"(
- "id",
- "code",
- "name",
- "description",
- "usage_count",
- "creator_id",
- "created_at",
- "updated_at",
- "source_guild_id",
- "serialized_source_guild"
- )
- SELECT "id",
- "code",
- "name",
- "description",
- "usage_count",
- "creator_id",
- "created_at",
- "updated_at",
- "source_guild_id",
- "serialized_source_guild"
- FROM "temporary_templates"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_templates"
- `);
- await queryRunner.query(`
- ALTER TABLE "emojis"
- RENAME TO "temporary_emojis"
- `);
- await queryRunner.query(`
- CREATE TABLE "emojis" (
- "id" varchar PRIMARY KEY NOT NULL,
- "animated" boolean NOT NULL,
- "available" boolean NOT NULL,
- "guild_id" varchar NOT NULL,
- "user_id" varchar,
- "managed" boolean NOT NULL,
- "name" varchar NOT NULL,
- "require_colons" boolean NOT NULL,
- "roles" text NOT NULL,
- "groups" text
- )
- `);
- await queryRunner.query(`
- INSERT INTO "emojis"(
- "id",
- "animated",
- "available",
- "guild_id",
- "user_id",
- "managed",
- "name",
- "require_colons",
- "roles",
- "groups"
- )
- SELECT "id",
- "animated",
- "available",
- "guild_id",
- "user_id",
- "managed",
- "name",
- "require_colons",
- "roles",
- "groups"
- FROM "temporary_emojis"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_emojis"
- `);
- await queryRunner.query(`
- ALTER TABLE "channels"
- RENAME TO "temporary_channels"
- `);
- await queryRunner.query(`
- CREATE TABLE "channels" (
- "id" varchar PRIMARY KEY NOT NULL,
- "created_at" datetime NOT NULL,
- "name" varchar,
- "icon" text,
- "type" integer NOT NULL,
- "last_message_id" varchar,
- "guild_id" varchar,
- "parent_id" varchar,
- "owner_id" varchar,
- "last_pin_timestamp" integer,
- "default_auto_archive_duration" integer,
- "position" integer,
- "permission_overwrites" text,
- "video_quality_mode" integer,
- "bitrate" integer,
- "user_limit" integer,
- "nsfw" boolean,
- "rate_limit_per_user" integer,
- "topic" varchar,
- "retention_policy_id" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "channels"(
- "id",
- "created_at",
- "name",
- "icon",
- "type",
- "last_message_id",
- "guild_id",
- "parent_id",
- "owner_id",
- "last_pin_timestamp",
- "default_auto_archive_duration",
- "position",
- "permission_overwrites",
- "video_quality_mode",
- "bitrate",
- "user_limit",
- "nsfw",
- "rate_limit_per_user",
- "topic",
- "retention_policy_id"
- )
- SELECT "id",
- "created_at",
- "name",
- "icon",
- "type",
- "last_message_id",
- "guild_id",
- "parent_id",
- "owner_id",
- "last_pin_timestamp",
- "default_auto_archive_duration",
- "position",
- "permission_overwrites",
- "video_quality_mode",
- "bitrate",
- "user_limit",
- "nsfw",
- "rate_limit_per_user",
- "topic",
- "retention_policy_id"
- FROM "temporary_channels"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_channels"
- `);
- await queryRunner.query(`
- ALTER TABLE "voice_states"
- RENAME TO "temporary_voice_states"
- `);
- await queryRunner.query(`
- CREATE TABLE "voice_states" (
- "id" varchar PRIMARY KEY NOT NULL,
- "guild_id" varchar,
- "channel_id" varchar,
- "user_id" varchar,
- "session_id" varchar NOT NULL,
- "token" varchar,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "self_deaf" boolean NOT NULL,
- "self_mute" boolean NOT NULL,
- "self_stream" boolean,
- "self_video" boolean NOT NULL,
- "suppress" boolean NOT NULL,
- "request_to_speak_timestamp" datetime
- )
- `);
- await queryRunner.query(`
- INSERT INTO "voice_states"(
- "id",
- "guild_id",
- "channel_id",
- "user_id",
- "session_id",
- "token",
- "deaf",
- "mute",
- "self_deaf",
- "self_mute",
- "self_stream",
- "self_video",
- "suppress",
- "request_to_speak_timestamp"
- )
- SELECT "id",
- "guild_id",
- "channel_id",
- "user_id",
- "session_id",
- "token",
- "deaf",
- "mute",
- "self_deaf",
- "self_mute",
- "self_stream",
- "self_video",
- "suppress",
- "request_to_speak_timestamp"
- FROM "temporary_voice_states"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_voice_states"
- `);
- 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
- )
- `);
- 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(`
- DROP INDEX "IDX_0abf8b443321bd3cf7f81ee17a"
- `);
- await queryRunner.query(`
- ALTER TABLE "read_states"
- RENAME TO "temporary_read_states"
- `);
- await queryRunner.query(`
- CREATE TABLE "read_states" (
- "id" varchar PRIMARY KEY NOT NULL,
- "channel_id" varchar NOT NULL,
- "user_id" varchar NOT NULL,
- "last_message_id" varchar,
- "public_ack" varchar,
- "notifications_cursor" varchar,
- "last_pin_timestamp" datetime,
- "mention_count" integer
- )
- `);
- await queryRunner.query(`
- INSERT INTO "read_states"(
- "id",
- "channel_id",
- "user_id",
- "last_message_id",
- "public_ack",
- "notifications_cursor",
- "last_pin_timestamp",
- "mention_count"
- )
- SELECT "id",
- "channel_id",
- "user_id",
- "last_message_id",
- "public_ack",
- "notifications_cursor",
- "last_pin_timestamp",
- "mention_count"
- FROM "temporary_read_states"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_read_states"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_0abf8b443321bd3cf7f81ee17a" ON "read_states" ("channel_id", "user_id")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_3ed7a60fb7dbe04e1ba9332a8b"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_05535bc695e9f7ee104616459d"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_86b9109b155eb70c0a2ca3b4b6"
- `);
- await queryRunner.query(`
- ALTER TABLE "messages"
- RENAME TO "temporary_messages"
- `);
- await queryRunner.query(`
- CREATE TABLE "messages" (
- "id" varchar PRIMARY KEY NOT NULL,
- "channel_id" varchar,
- "guild_id" varchar,
- "author_id" varchar,
- "member_id" varchar,
- "webhook_id" varchar,
- "application_id" varchar,
- "content" varchar,
- "timestamp" datetime NOT NULL DEFAULT (datetime('now')),
- "edited_timestamp" datetime,
- "tts" boolean,
- "mention_everyone" boolean,
- "embeds" text NOT NULL,
- "reactions" text NOT NULL,
- "nonce" text,
- "pinned" boolean,
- "type" integer NOT NULL,
- "activity" text,
- "flags" varchar,
- "message_reference" text,
- "interaction" text,
- "components" text,
- "message_reference_id" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "messages"(
- "id",
- "channel_id",
- "guild_id",
- "author_id",
- "member_id",
- "webhook_id",
- "application_id",
- "content",
- "timestamp",
- "edited_timestamp",
- "tts",
- "mention_everyone",
- "embeds",
- "reactions",
- "nonce",
- "pinned",
- "type",
- "activity",
- "flags",
- "message_reference",
- "interaction",
- "components",
- "message_reference_id"
- )
- SELECT "id",
- "channel_id",
- "guild_id",
- "author_id",
- "member_id",
- "webhook_id",
- "application_id",
- "content",
- "timestamp",
- "edited_timestamp",
- "tts",
- "mention_everyone",
- "embeds",
- "reactions",
- "nonce",
- "pinned",
- "type",
- "activity",
- "flags",
- "message_reference",
- "interaction",
- "components",
- "message_reference_id"
- FROM "temporary_messages"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_messages"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_3ed7a60fb7dbe04e1ba9332a8b" ON "messages" ("channel_id", "id")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_05535bc695e9f7ee104616459d" ON "messages" ("author_id")
- `);
- await queryRunner.query(`
- CREATE INDEX "IDX_86b9109b155eb70c0a2ca3b4b6" ON "messages" ("channel_id")
- `);
- await queryRunner.query(`
- ALTER TABLE "attachments"
- RENAME TO "temporary_attachments"
- `);
- await queryRunner.query(`
- CREATE TABLE "attachments" (
- "id" varchar PRIMARY KEY NOT NULL,
- "filename" varchar NOT NULL,
- "size" integer NOT NULL,
- "url" varchar NOT NULL,
- "proxy_url" varchar NOT NULL,
- "height" integer,
- "width" integer,
- "content_type" varchar,
- "message_id" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "attachments"(
- "id",
- "filename",
- "size",
- "url",
- "proxy_url",
- "height",
- "width",
- "content_type",
- "message_id"
- )
- SELECT "id",
- "filename",
- "size",
- "url",
- "proxy_url",
- "height",
- "width",
- "content_type",
- "message_id"
- FROM "temporary_attachments"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_attachments"
- `);
- await queryRunner.query(`
- ALTER TABLE "stickers"
- RENAME TO "temporary_stickers"
- `);
- await queryRunner.query(`
- CREATE TABLE "stickers" (
- "id" varchar PRIMARY KEY NOT NULL,
- "name" varchar NOT NULL,
- "description" varchar,
- "available" boolean,
- "tags" varchar,
- "pack_id" varchar,
- "guild_id" varchar,
- "user_id" varchar,
- "type" integer NOT NULL,
- "format_type" integer NOT NULL
- )
- `);
- await queryRunner.query(`
- INSERT INTO "stickers"(
- "id",
- "name",
- "description",
- "available",
- "tags",
- "pack_id",
- "guild_id",
- "user_id",
- "type",
- "format_type"
- )
- SELECT "id",
- "name",
- "description",
- "available",
- "tags",
- "pack_id",
- "guild_id",
- "user_id",
- "type",
- "format_type"
- FROM "temporary_stickers"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_stickers"
- `);
- await queryRunner.query(`
- ALTER TABLE "webhooks"
- RENAME TO "temporary_webhooks"
- `);
- await queryRunner.query(`
- CREATE TABLE "webhooks" (
- "id" varchar PRIMARY KEY NOT NULL,
- "type" integer NOT NULL,
- "name" varchar,
- "avatar" varchar,
- "token" varchar,
- "guild_id" varchar,
- "channel_id" varchar,
- "application_id" varchar,
- "user_id" varchar,
- "source_guild_id" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "webhooks"(
- "id",
- "type",
- "name",
- "avatar",
- "token",
- "guild_id",
- "channel_id",
- "application_id",
- "user_id",
- "source_guild_id"
- )
- SELECT "id",
- "type",
- "name",
- "avatar",
- "token",
- "guild_id",
- "channel_id",
- "application_id",
- "user_id",
- "source_guild_id"
- FROM "temporary_webhooks"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_webhooks"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3"
- `);
- await queryRunner.query(`
- ALTER TABLE "members"
- RENAME TO "temporary_members"
- `);
- await queryRunner.query(`
- CREATE TABLE "members" (
- "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- "id" varchar NOT NULL,
- "guild_id" varchar NOT NULL,
- "nick" varchar,
- "joined_at" datetime NOT NULL,
- "premium_since" bigint,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "pending" boolean NOT NULL,
- "settings" text NOT NULL,
- "last_message_id" varchar,
- "joined_by" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "members"(
- "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- )
- SELECT "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- FROM "temporary_members"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_members"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id")
- `);
- await queryRunner.query(`
- ALTER TABLE "roles"
- RENAME TO "temporary_roles"
- `);
- await queryRunner.query(`
- CREATE TABLE "roles" (
- "id" varchar PRIMARY KEY NOT NULL,
- "guild_id" varchar,
- "color" integer NOT NULL,
- "hoist" boolean NOT NULL,
- "managed" boolean NOT NULL,
- "mentionable" boolean NOT NULL,
- "name" varchar NOT NULL,
- "permissions" varchar NOT NULL,
- "position" integer NOT NULL,
- "icon" varchar,
- "unicode_emoji" varchar,
- "tags" text
- )
- `);
- await queryRunner.query(`
- INSERT INTO "roles"(
- "id",
- "guild_id",
- "color",
- "hoist",
- "managed",
- "mentionable",
- "name",
- "permissions",
- "position",
- "icon",
- "unicode_emoji",
- "tags"
- )
- SELECT "id",
- "guild_id",
- "color",
- "hoist",
- "managed",
- "mentionable",
- "name",
- "permissions",
- "position",
- "icon",
- "unicode_emoji",
- "tags"
- FROM "temporary_roles"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_roles"
- `);
- await queryRunner.query(`
- ALTER TABLE "recipients"
- RENAME TO "temporary_recipients"
- `);
- await queryRunner.query(`
- CREATE TABLE "recipients" (
- "id" varchar PRIMARY KEY NOT NULL,
- "channel_id" varchar NOT NULL,
- "user_id" varchar NOT NULL,
- "closed" boolean NOT NULL DEFAULT (0)
- )
- `);
- await queryRunner.query(`
- INSERT INTO "recipients"("id", "channel_id", "user_id", "closed")
- SELECT "id",
- "channel_id",
- "user_id",
- "closed"
- FROM "temporary_recipients"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_recipients"
- `);
- await queryRunner.query(`
- ALTER TABLE "bans"
- RENAME TO "temporary_bans"
- `);
- await queryRunner.query(`
- CREATE TABLE "bans" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "guild_id" varchar,
- "executor_id" varchar,
- "ip" varchar NOT NULL,
- "reason" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "bans"(
- "id",
- "user_id",
- "guild_id",
- "executor_id",
- "ip",
- "reason"
- )
- SELECT "id",
- "user_id",
- "guild_id",
- "executor_id",
- "ip",
- "reason"
- FROM "temporary_bans"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_bans"
- `);
- await queryRunner.query(`
- ALTER TABLE "backup_codes"
- RENAME TO "temporary_backup_codes"
- `);
- await queryRunner.query(`
- CREATE TABLE "backup_codes" (
- "id" varchar PRIMARY KEY NOT NULL,
- "code" varchar NOT NULL,
- "consumed" boolean NOT NULL,
- "expired" boolean NOT NULL,
- "user_id" varchar
- )
- `);
- await queryRunner.query(`
- INSERT INTO "backup_codes"("id", "code", "consumed", "expired", "user_id")
- SELECT "id",
- "code",
- "consumed",
- "expired",
- "user_id"
- FROM "temporary_backup_codes"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_backup_codes"
- `);
- await queryRunner.query(`
- ALTER TABLE "connected_accounts"
- RENAME TO "temporary_connected_accounts"
- `);
- await queryRunner.query(`
- CREATE TABLE "connected_accounts" (
- "id" varchar PRIMARY KEY NOT NULL,
- "user_id" varchar,
- "access_token" varchar NOT NULL,
- "friend_sync" boolean NOT NULL,
- "name" varchar NOT NULL,
- "revoked" boolean NOT NULL,
- "show_activity" boolean NOT NULL,
- "type" varchar NOT NULL,
- "verified" boolean NOT NULL,
- "visibility" integer NOT NULL
- )
- `);
- await queryRunner.query(`
- INSERT INTO "connected_accounts"(
- "id",
- "user_id",
- "access_token",
- "friend_sync",
- "name",
- "revoked",
- "show_activity",
- "type",
- "verified",
- "visibility"
- )
- SELECT "id",
- "user_id",
- "access_token",
- "friend_sync",
- "name",
- "revoked",
- "show_activity",
- "type",
- "verified",
- "visibility"
- FROM "temporary_connected_accounts"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_connected_accounts"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_a0b2ff0a598df0b0d055934a17"
- `);
- await queryRunner.query(`
- ALTER TABLE "relationships"
- RENAME TO "temporary_relationships"
- `);
- await queryRunner.query(`
- CREATE TABLE "relationships" (
- "id" varchar PRIMARY KEY NOT NULL,
- "from_id" varchar NOT NULL,
- "to_id" varchar NOT NULL,
- "nickname" varchar,
- "type" integer NOT NULL
- )
- `);
- await queryRunner.query(`
- INSERT INTO "relationships"("id", "from_id", "to_id", "nickname", "type")
- SELECT "id",
- "from_id",
- "to_id",
- "nickname",
- "type"
- FROM "temporary_relationships"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_relationships"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_a0b2ff0a598df0b0d055934a17" ON "relationships" ("from_id", "to_id")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_e22a70819d07659c7a71c112a1"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_40bb6f23e7cc133292e92829d2"
- `);
- await queryRunner.query(`
- DROP TABLE "message_stickers"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_bdb8c09e1464cabf62105bf4b9"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_2a27102ecd1d81b4582a436092"
- `);
- await queryRunner.query(`
- DROP TABLE "message_channel_mentions"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_29d63eb1a458200851bc37d074"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_a8242cf535337a490b0feaea0b"
- `);
- await queryRunner.query(`
- DROP TABLE "message_role_mentions"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_b831eb18ceebd28976239b1e2f"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_a343387fc560ef378760681c23"
- `);
- await queryRunner.query(`
- DROP TABLE "message_user_mentions"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_e9080e7a7997a0170026d5139c"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_5d7ddc8a5f9c167f548625e772"
- `);
- await queryRunner.query(`
- DROP TABLE "member_roles"
- `);
- await queryRunner.query(`
- DROP TABLE "notes"
- `);
- await queryRunner.query(`
- DROP TABLE "client_release"
- `);
- await queryRunner.query(`
- DROP TABLE "sticker_packs"
- `);
- await queryRunner.query(`
- DROP TABLE "sessions"
- `);
- await queryRunner.query(`
- DROP TABLE "rate_limits"
- `);
- await queryRunner.query(`
- DROP TABLE "categories"
- `);
- await queryRunner.query(`
- DROP TABLE "audit_logs"
- `);
- await queryRunner.query(`
- DROP TABLE "applications"
- `);
- await queryRunner.query(`
- DROP TABLE "teams"
- `);
- await queryRunner.query(`
- DROP TABLE "team_members"
- `);
- await queryRunner.query(`
- DROP TABLE "guilds"
- `);
- await queryRunner.query(`
- DROP TABLE "templates"
- `);
- await queryRunner.query(`
- DROP TABLE "emojis"
- `);
- await queryRunner.query(`
- DROP TABLE "channels"
- `);
- await queryRunner.query(`
- DROP TABLE "voice_states"
- `);
- await queryRunner.query(`
- DROP TABLE "invites"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_0abf8b443321bd3cf7f81ee17a"
- `);
- await queryRunner.query(`
- DROP TABLE "read_states"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_3ed7a60fb7dbe04e1ba9332a8b"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_05535bc695e9f7ee104616459d"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_86b9109b155eb70c0a2ca3b4b6"
- `);
- await queryRunner.query(`
- DROP TABLE "messages"
- `);
- await queryRunner.query(`
- DROP TABLE "attachments"
- `);
- await queryRunner.query(`
- DROP TABLE "stickers"
- `);
- await queryRunner.query(`
- DROP TABLE "webhooks"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3"
- `);
- await queryRunner.query(`
- DROP TABLE "members"
- `);
- await queryRunner.query(`
- DROP TABLE "roles"
- `);
- await queryRunner.query(`
- DROP TABLE "recipients"
- `);
- await queryRunner.query(`
- DROP TABLE "bans"
- `);
- await queryRunner.query(`
- DROP TABLE "backup_codes"
- `);
- await queryRunner.query(`
- DROP TABLE "users"
- `);
- await queryRunner.query(`
- DROP TABLE "connected_accounts"
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_a0b2ff0a598df0b0d055934a17"
- `);
- await queryRunner.query(`
- DROP TABLE "relationships"
- `);
- await queryRunner.query(`
- DROP TABLE "config"
- `);
- }
-
-}
diff --git a/util/src/migrations/sqlite/1659921722863-premium_since_as_date.ts b/util/src/migrations/sqlite/1659921722863-premium_since_as_date.ts
deleted file mode 100644
index 788be625..00000000
--- a/util/src/migrations/sqlite/1659921722863-premium_since_as_date.ts
+++ /dev/null
@@ -1,252 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class premiumSinceAsDate1659921722863 implements MigrationInterface {
- name = 'premiumSinceAsDate1659921722863'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_members" (
- "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- "id" varchar NOT NULL,
- "guild_id" varchar NOT NULL,
- "nick" varchar,
- "joined_at" datetime NOT NULL,
- "premium_since" bigint,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "pending" boolean NOT NULL,
- "settings" text NOT NULL,
- "last_message_id" varchar,
- "joined_by" varchar,
- CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_28b53062261b996d9c99fa12404" FOREIGN KEY ("id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_members"(
- "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- )
- SELECT "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- FROM "members"
- `);
- await queryRunner.query(`
- DROP TABLE "members"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_members"
- RENAME TO "members"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_members" (
- "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- "id" varchar NOT NULL,
- "guild_id" varchar NOT NULL,
- "nick" varchar,
- "joined_at" datetime NOT NULL,
- "premium_since" datetime,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "pending" boolean NOT NULL,
- "settings" text NOT NULL,
- "last_message_id" varchar,
- "joined_by" varchar,
- CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_28b53062261b996d9c99fa12404" FOREIGN KEY ("id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_members"(
- "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- )
- SELECT "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- FROM "members"
- `);
- await queryRunner.query(`
- DROP TABLE "members"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_members"
- RENAME TO "members"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id")
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3"
- `);
- await queryRunner.query(`
- ALTER TABLE "members"
- RENAME TO "temporary_members"
- `);
- await queryRunner.query(`
- CREATE TABLE "members" (
- "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- "id" varchar NOT NULL,
- "guild_id" varchar NOT NULL,
- "nick" varchar,
- "joined_at" datetime NOT NULL,
- "premium_since" bigint,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "pending" boolean NOT NULL,
- "settings" text NOT NULL,
- "last_message_id" varchar,
- "joined_by" varchar,
- CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_28b53062261b996d9c99fa12404" FOREIGN KEY ("id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "members"(
- "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- )
- SELECT "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- FROM "temporary_members"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_members"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id")
- `);
- await queryRunner.query(`
- DROP INDEX "IDX_bb2bf9386ac443afbbbf9f12d3"
- `);
- await queryRunner.query(`
- ALTER TABLE "members"
- RENAME TO "temporary_members"
- `);
- await queryRunner.query(`
- CREATE TABLE "members" (
- "index" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- "id" varchar NOT NULL,
- "guild_id" varchar NOT NULL,
- "nick" varchar,
- "joined_at" datetime NOT NULL,
- "premium_since" bigint,
- "deaf" boolean NOT NULL,
- "mute" boolean NOT NULL,
- "pending" boolean NOT NULL,
- "settings" text NOT NULL,
- "last_message_id" varchar,
- "joined_by" varchar,
- CONSTRAINT "FK_16aceddd5b89825b8ed6029ad1c" FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
- CONSTRAINT "FK_28b53062261b996d9c99fa12404" FOREIGN KEY ("id") REFERENCES "users" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "members"(
- "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- )
- SELECT "index",
- "id",
- "guild_id",
- "nick",
- "joined_at",
- "premium_since",
- "deaf",
- "mute",
- "pending",
- "settings",
- "last_message_id",
- "joined_by"
- FROM "temporary_members"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_members"
- `);
- await queryRunner.query(`
- CREATE UNIQUE INDEX "IDX_bb2bf9386ac443afbbbf9f12d3" ON "members" ("id", "guild_id")
- `);
- }
-
-}
diff --git a/util/src/migrations/sqlite/1660257576211-CodeCleanup1.ts b/util/src/migrations/sqlite/1660257576211-CodeCleanup1.ts
deleted file mode 100644
index 5a61db0d..00000000
--- a/util/src/migrations/sqlite/1660257576211-CodeCleanup1.ts
+++ /dev/null
@@ -1,326 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup11660257576211 implements MigrationInterface {
- name = 'CodeCleanup11660257576211'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- CREATE TABLE "user_settings" (
- "id" varchar PRIMARY KEY NOT NULL,
- "afk_timeout" integer,
- "allow_accessibility_detection" boolean,
- "animate_emoji" boolean,
- "animate_stickers" integer,
- "contact_sync_enabled" boolean,
- "convert_emoticons" boolean,
- "custom_status" text,
- "default_guilds_restricted" boolean,
- "detect_platform_accounts" boolean,
- "developer_mode" boolean,
- "disable_games_tab" boolean,
- "enable_tts_command" boolean,
- "explicit_content_filter" integer,
- "friend_source_flags" text,
- "gateway_connected" boolean,
- "gif_auto_play" boolean,
- "guild_folders" text,
- "guild_positions" text,
- "inline_attachment_media" boolean,
- "inline_embed_media" boolean,
- "locale" varchar,
- "message_display_compact" boolean,
- "native_phone_integration_enabled" boolean,
- "render_embeds" boolean,
- "render_reactions" boolean,
- "restricted_guilds" text,
- "show_current_game" boolean,
- "status" varchar,
- "stream_notifications_enabled" boolean,
- "theme" varchar,
- "timezone_offset" integer
- )
- `);
- 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_9d1d665379eefde7876a17afa99" FOREIGN KEY ("widget_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_95828668aa333460582e0ca6396" FOREIGN KEY ("rules_channel_id") REFERENCES "channels" ("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_fc1a451727e3643ca572a3bb394" FOREIGN KEY ("owner_id") REFERENCES "users" ("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_f591a66b8019d87b0fe6c12dad6" FOREIGN KEY ("afk_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"
- )
- 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"
- 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,
- CONSTRAINT "FK_9d1d665379eefde7876a17afa99" FOREIGN KEY ("widget_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_95828668aa333460582e0ca6396" FOREIGN KEY ("rules_channel_id") REFERENCES "channels" ("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_fc1a451727e3643ca572a3bb394" FOREIGN KEY ("owner_id") REFERENCES "users" ("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_f591a66b8019d87b0fe6c12dad6" FOREIGN KEY ("afk_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"
- )
- 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"
- FROM "temporary_guilds"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_guilds"
- `);
- await queryRunner.query(`
- DROP TABLE "user_settings"
- `);
- }
-
-}
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"
- `);
- }
-
-}
diff --git a/util/src/migrations/sqlite/1660258351379-CodeCleanup3.ts b/util/src/migrations/sqlite/1660258351379-CodeCleanup3.ts
deleted file mode 100644
index 13fba6dd..00000000
--- a/util/src/migrations/sqlite/1660258351379-CodeCleanup3.ts
+++ /dev/null
@@ -1,231 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup31660258351379 implements MigrationInterface {
- name = 'CodeCleanup31660258351379'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- CREATE TABLE "temporary_users" (
- "id" varchar PRIMARY KEY NOT NULL,
- "username" varchar NOT NULL,
- "discriminator" varchar NOT NULL,
- "avatar" varchar,
- "accent_color" integer,
- "banner" varchar,
- "phone" varchar,
- "desktop" boolean NOT NULL,
- "mobile" boolean NOT NULL,
- "premium" boolean NOT NULL,
- "premium_type" integer NOT NULL,
- "bot" boolean NOT NULL,
- "bio" varchar NOT NULL,
- "system" boolean NOT NULL,
- "nsfw_allowed" boolean NOT NULL,
- "mfa_enabled" boolean NOT NULL,
- "totp_secret" varchar,
- "totp_last_ticket" varchar,
- "created_at" datetime NOT NULL,
- "premium_since" datetime,
- "verified" boolean NOT NULL,
- "disabled" boolean NOT NULL,
- "deleted" boolean NOT NULL,
- "email" varchar,
- "flags" varchar NOT NULL,
- "public_flags" integer NOT NULL,
- "rights" bigint NOT NULL,
- "data" text NOT NULL,
- "fingerprints" text NOT NULL,
- "extended_settings" text NOT NULL,
- "notes" text NOT NULL
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_users"(
- "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes"
- )
- SELECT "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes"
- FROM "users"
- `);
- await queryRunner.query(`
- DROP TABLE "users"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_users"
- RENAME TO "users"
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "users"
- RENAME TO "temporary_users"
- `);
- await queryRunner.query(`
- CREATE TABLE "users" (
- "id" varchar PRIMARY KEY NOT NULL,
- "username" varchar NOT NULL,
- "discriminator" varchar NOT NULL,
- "avatar" varchar,
- "accent_color" integer,
- "banner" varchar,
- "phone" varchar,
- "desktop" boolean NOT NULL,
- "mobile" boolean NOT NULL,
- "premium" boolean NOT NULL,
- "premium_type" integer NOT NULL,
- "bot" boolean NOT NULL,
- "bio" varchar NOT NULL,
- "system" boolean NOT NULL,
- "nsfw_allowed" boolean NOT NULL,
- "mfa_enabled" boolean NOT NULL,
- "totp_secret" varchar,
- "totp_last_ticket" varchar,
- "created_at" datetime NOT NULL,
- "premium_since" datetime,
- "verified" boolean NOT NULL,
- "disabled" boolean NOT NULL,
- "deleted" boolean NOT NULL,
- "email" varchar,
- "flags" varchar NOT NULL,
- "public_flags" integer NOT NULL,
- "rights" bigint NOT NULL,
- "data" text NOT NULL,
- "fingerprints" text NOT NULL,
- "settings" text NOT NULL,
- "extended_settings" text NOT NULL,
- "notes" text NOT NULL
- )
- `);
- await queryRunner.query(`
- INSERT INTO "users"(
- "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes"
- )
- SELECT "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes"
- FROM "temporary_users"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_users"
- `);
- }
-
-}
diff --git a/util/src/migrations/sqlite/1660260672914-CodeCleanup4.ts b/util/src/migrations/sqlite/1660260672914-CodeCleanup4.ts
deleted file mode 100644
index 33f4df03..00000000
--- a/util/src/migrations/sqlite/1660260672914-CodeCleanup4.ts
+++ /dev/null
@@ -1,459 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup41660260672914 implements MigrationInterface {
- name = 'CodeCleanup41660260672914'
-
- public async up(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- CREATE TABLE "temporary_users" (
- "id" varchar PRIMARY KEY NOT NULL,
- "username" varchar NOT NULL,
- "discriminator" varchar NOT NULL,
- "avatar" varchar,
- "accent_color" integer,
- "banner" varchar,
- "phone" varchar,
- "desktop" boolean NOT NULL,
- "mobile" boolean NOT NULL,
- "premium" boolean NOT NULL,
- "premium_type" integer NOT NULL,
- "bot" boolean NOT NULL,
- "bio" varchar NOT NULL,
- "system" boolean NOT NULL,
- "nsfw_allowed" boolean NOT NULL,
- "mfa_enabled" boolean NOT NULL,
- "totp_secret" varchar,
- "totp_last_ticket" varchar,
- "created_at" datetime NOT NULL,
- "premium_since" datetime,
- "verified" boolean NOT NULL,
- "disabled" boolean NOT NULL,
- "deleted" boolean NOT NULL,
- "email" varchar,
- "flags" varchar NOT NULL,
- "public_flags" integer NOT NULL,
- "rights" bigint NOT NULL,
- "data" text NOT NULL,
- "fingerprints" text NOT NULL,
- "extended_settings" text NOT NULL,
- "notes" text NOT NULL,
- "settingsId" varchar,
- CONSTRAINT "UQ_b1dd13b6ed980004a795ca184a6" UNIQUE ("settingsId")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_users"(
- "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes"
- )
- SELECT "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes"
- FROM "users"
- `);
- await queryRunner.query(`
- DROP TABLE "users"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_users"
- RENAME TO "users"
- `);
- await queryRunner.query(`
- CREATE TABLE "temporary_users" (
- "id" varchar PRIMARY KEY NOT NULL,
- "username" varchar NOT NULL,
- "discriminator" varchar NOT NULL,
- "avatar" varchar,
- "accent_color" integer,
- "banner" varchar,
- "phone" varchar,
- "desktop" boolean NOT NULL,
- "mobile" boolean NOT NULL,
- "premium" boolean NOT NULL,
- "premium_type" integer NOT NULL,
- "bot" boolean NOT NULL,
- "bio" varchar NOT NULL,
- "system" boolean NOT NULL,
- "nsfw_allowed" boolean NOT NULL,
- "mfa_enabled" boolean NOT NULL,
- "totp_secret" varchar,
- "totp_last_ticket" varchar,
- "created_at" datetime NOT NULL,
- "premium_since" datetime,
- "verified" boolean NOT NULL,
- "disabled" boolean NOT NULL,
- "deleted" boolean NOT NULL,
- "email" varchar,
- "flags" varchar NOT NULL,
- "public_flags" integer NOT NULL,
- "rights" bigint NOT NULL,
- "data" text NOT NULL,
- "fingerprints" text NOT NULL,
- "extended_settings" text NOT NULL,
- "notes" text NOT NULL,
- "settingsId" varchar,
- CONSTRAINT "UQ_b1dd13b6ed980004a795ca184a6" UNIQUE ("settingsId"),
- CONSTRAINT "FK_76ba283779c8441fd5ff819c8cf" FOREIGN KEY ("settingsId") REFERENCES "user_settings" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
- )
- `);
- await queryRunner.query(`
- INSERT INTO "temporary_users"(
- "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes",
- "settingsId"
- )
- SELECT "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes",
- "settingsId"
- FROM "users"
- `);
- await queryRunner.query(`
- DROP TABLE "users"
- `);
- await queryRunner.query(`
- ALTER TABLE "temporary_users"
- RENAME TO "users"
- `);
- }
-
- public async down(queryRunner: QueryRunner): Promise<void> {
- await queryRunner.query(`
- ALTER TABLE "users"
- RENAME TO "temporary_users"
- `);
- await queryRunner.query(`
- CREATE TABLE "users" (
- "id" varchar PRIMARY KEY NOT NULL,
- "username" varchar NOT NULL,
- "discriminator" varchar NOT NULL,
- "avatar" varchar,
- "accent_color" integer,
- "banner" varchar,
- "phone" varchar,
- "desktop" boolean NOT NULL,
- "mobile" boolean NOT NULL,
- "premium" boolean NOT NULL,
- "premium_type" integer NOT NULL,
- "bot" boolean NOT NULL,
- "bio" varchar NOT NULL,
- "system" boolean NOT NULL,
- "nsfw_allowed" boolean NOT NULL,
- "mfa_enabled" boolean NOT NULL,
- "totp_secret" varchar,
- "totp_last_ticket" varchar,
- "created_at" datetime NOT NULL,
- "premium_since" datetime,
- "verified" boolean NOT NULL,
- "disabled" boolean NOT NULL,
- "deleted" boolean NOT NULL,
- "email" varchar,
- "flags" varchar NOT NULL,
- "public_flags" integer NOT NULL,
- "rights" bigint NOT NULL,
- "data" text NOT NULL,
- "fingerprints" text NOT NULL,
- "extended_settings" text NOT NULL,
- "notes" text NOT NULL,
- "settingsId" varchar,
- CONSTRAINT "UQ_b1dd13b6ed980004a795ca184a6" UNIQUE ("settingsId")
- )
- `);
- await queryRunner.query(`
- INSERT INTO "users"(
- "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes",
- "settingsId"
- )
- SELECT "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes",
- "settingsId"
- FROM "temporary_users"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_users"
- `);
- await queryRunner.query(`
- ALTER TABLE "users"
- RENAME TO "temporary_users"
- `);
- await queryRunner.query(`
- CREATE TABLE "users" (
- "id" varchar PRIMARY KEY NOT NULL,
- "username" varchar NOT NULL,
- "discriminator" varchar NOT NULL,
- "avatar" varchar,
- "accent_color" integer,
- "banner" varchar,
- "phone" varchar,
- "desktop" boolean NOT NULL,
- "mobile" boolean NOT NULL,
- "premium" boolean NOT NULL,
- "premium_type" integer NOT NULL,
- "bot" boolean NOT NULL,
- "bio" varchar NOT NULL,
- "system" boolean NOT NULL,
- "nsfw_allowed" boolean NOT NULL,
- "mfa_enabled" boolean NOT NULL,
- "totp_secret" varchar,
- "totp_last_ticket" varchar,
- "created_at" datetime NOT NULL,
- "premium_since" datetime,
- "verified" boolean NOT NULL,
- "disabled" boolean NOT NULL,
- "deleted" boolean NOT NULL,
- "email" varchar,
- "flags" varchar NOT NULL,
- "public_flags" integer NOT NULL,
- "rights" bigint NOT NULL,
- "data" text NOT NULL,
- "fingerprints" text NOT NULL,
- "extended_settings" text NOT NULL,
- "notes" text NOT NULL
- )
- `);
- await queryRunner.query(`
- INSERT INTO "users"(
- "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes"
- )
- SELECT "id",
- "username",
- "discriminator",
- "avatar",
- "accent_color",
- "banner",
- "phone",
- "desktop",
- "mobile",
- "premium",
- "premium_type",
- "bot",
- "bio",
- "system",
- "nsfw_allowed",
- "mfa_enabled",
- "totp_secret",
- "totp_last_ticket",
- "created_at",
- "premium_since",
- "verified",
- "disabled",
- "deleted",
- "email",
- "flags",
- "public_flags",
- "rights",
- "data",
- "fingerprints",
- "extended_settings",
- "notes"
- FROM "temporary_users"
- `);
- await queryRunner.query(`
- DROP TABLE "temporary_users"
- `);
- }
-
-}
|
