summary refs log tree commit diff
path: root/src/util/migration/postgres
diff options
context:
space:
mode:
authorRory& <root@rory.gay>2025-12-17 11:00:51 +0100
committerRory& <root@rory.gay>2025-12-17 11:01:27 +0100
commit491c0de845a886954262e3ddb24959ba37a014b6 (patch)
treec0251f3779a5cd2842320e1278232b48fbea0390 /src/util/migration/postgres
parentPre-commit: use spaces for formatting, regenerate schemas if changed (diff)
downloadserver-ts-491c0de845a886954262e3ddb24959ba37a014b6.tar.xz
lintstagedrc: regenerate schemas/openapi if schemas changed
Diffstat (limited to 'src/util/migration/postgres')
-rw-r--r--src/util/migration/postgres/1673609867556-templateDeleteCascade.ts26
-rw-r--r--src/util/migration/postgres/1675044825710-webauthn.ts30
-rw-r--r--src/util/migration/postgres/1696420827239-guildChannelOrdering.ts46
-rw-r--r--src/util/migration/postgres/1713116476900-messageFlagsNotNull.ts26
-rw-r--r--src/util/migration/postgres/1719776735000-newUserSettings.ts18
-rw-r--r--src/util/migration/postgres/1720157926878-messagePollObject.ts14
-rw-r--r--src/util/migration/postgres/1720628601997-badges.ts22
-rw-r--r--src/util/migration/postgres/1721298824927-webhookMessageProperties.ts18
-rw-r--r--src/util/migration/postgres/1723347738541-client_status.ts14
-rw-r--r--src/util/migration/postgres/1723577874393-discoveryCategoryIcon.ts14
-rw-r--r--src/util/migration/postgres/1723644478176-webhookSourceChannel.ts22
-rw-r--r--src/util/migration/postgres/1724477620293-teamMemberRole.ts14
-rw-r--r--src/util/migration/postgres/1725090962922-applicationProperties.ts18
-rw-r--r--src/util/migration/postgres/1745625724865-voice.ts58
-rw-r--r--src/util/migration/postgres/1752157979333-UserSettingsProtos.ts28
-rw-r--r--src/util/migration/postgres/1752321571508-RoleColors.ts18
-rw-r--r--src/util/migration/postgres/1752383879533-message_pinned_at.ts22
-rw-r--r--src/util/migration/postgres/1753639700904-Automod.ts26
-rw-r--r--src/util/migration/postgres/1758654246197-CloudAttachments.ts34
-rw-r--r--src/util/migration/postgres/1758654621365-CloudAttachmentsFixIdRefs.ts50
-rw-r--r--src/util/migration/postgres/1760622755598-ApplicationCommands.ts18
-rw-r--r--src/util/migration/postgres/1760622755599-ReconcileMigrationAttempts.ts102
-rw-r--r--src/util/migration/postgres/1760694225225-message_interaction_metadata.ts14
-rw-r--r--src/util/migration/postgres/1760961911873-message_reference_fix.ts26
-rw-r--r--src/util/migration/postgres/1761113394664-delete-bot-users-without-an-application.ts10
-rw-r--r--src/util/migration/postgres/1761209437070-application-commands-options-default.ts20
-rw-r--r--src/util/migration/postgres/1762611552514-fix-gif-stickers-format_type.ts14
-rw-r--r--src/util/migration/postgres/1763630755675-default-activities-to-empty-array.ts18
-rw-r--r--src/util/migration/postgres/1765143034407-DontIpBanBanner.ts18
-rw-r--r--src/util/migration/postgres/1765578570423-InstanceBanTable.ts26
-rw-r--r--src/util/migration/postgres/1765587835846-InstanceBanAllowlist.ts14
-rw-r--r--src/util/migration/postgres/1765665440000-DropDefaultIPDataKey.ts22
-rw-r--r--src/util/migration/postgres/1765863159930-ExtendedSessionInfo.ts70
-rw-r--r--src/util/migration/postgres/1765932247127-UpdateSessionInfo.ts34
34 files changed, 462 insertions, 462 deletions
diff --git a/src/util/migration/postgres/1673609867556-templateDeleteCascade.ts b/src/util/migration/postgres/1673609867556-templateDeleteCascade.ts

index ba0025d3..dbeef998 100644 --- a/src/util/migration/postgres/1673609867556-templateDeleteCascade.ts +++ b/src/util/migration/postgres/1673609867556-templateDeleteCascade.ts
@@ -19,19 +19,19 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class templateDeleteCascade1673609867556 implements MigrationInterface { - name = "templateDeleteCascade1673609867556"; + name = "templateDeleteCascade1673609867556"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "templates" DROP CONSTRAINT "FK_445d00eaaea0e60a017a5ed0c11"`); - await queryRunner.query( - `ALTER TABLE "templates" ADD CONSTRAINT "FK_445d00eaaea0e60a017a5ed0c11" FOREIGN KEY ("source_guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "templates" DROP CONSTRAINT "FK_445d00eaaea0e60a017a5ed0c11"`); + await queryRunner.query( + `ALTER TABLE "templates" ADD CONSTRAINT "FK_445d00eaaea0e60a017a5ed0c11" FOREIGN KEY ("source_guild_id") REFERENCES "guilds"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "templates" DROP CONSTRAINT "FK_445d00eaaea0e60a017a5ed0c11"`); - 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`, - ); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "templates" DROP CONSTRAINT "FK_445d00eaaea0e60a017a5ed0c11"`); + 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`, + ); + } } diff --git a/src/util/migration/postgres/1675044825710-webauthn.ts b/src/util/migration/postgres/1675044825710-webauthn.ts
index 19a96b4d..5c052ccf 100644 --- a/src/util/migration/postgres/1675044825710-webauthn.ts +++ b/src/util/migration/postgres/1675044825710-webauthn.ts
@@ -19,21 +19,21 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class webauthn1675044825710 implements MigrationInterface { - name = "webauthn1675044825710"; + name = "webauthn1675044825710"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query( - `CREATE TABLE "security_keys" ("id" character varying NOT NULL, "user_id" character varying, "key_id" character varying NOT NULL, "public_key" character varying NOT NULL, "counter" integer NOT NULL, "name" character varying NOT NULL, CONSTRAINT "PK_6e95cdd91779e7cca06d1fff89c" PRIMARY KEY ("id"))`, - ); - await queryRunner.query(`ALTER TABLE "users" ADD "webauthn_enabled" boolean NOT NULL DEFAULT false`); - await queryRunner.query( - `ALTER TABLE "security_keys" ADD CONSTRAINT "FK_24c97d0771cafedce6d7163eaad" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + `CREATE TABLE "security_keys" ("id" character varying NOT NULL, "user_id" character varying, "key_id" character varying NOT NULL, "public_key" character varying NOT NULL, "counter" integer NOT NULL, "name" character varying NOT NULL, CONSTRAINT "PK_6e95cdd91779e7cca06d1fff89c" PRIMARY KEY ("id"))`, + ); + await queryRunner.query(`ALTER TABLE "users" ADD "webauthn_enabled" boolean NOT NULL DEFAULT false`); + await queryRunner.query( + `ALTER TABLE "security_keys" ADD CONSTRAINT "FK_24c97d0771cafedce6d7163eaad" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "security_keys" DROP CONSTRAINT "FK_24c97d0771cafedce6d7163eaad"`); - await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "webauthn_enabled"`); - await queryRunner.query(`DROP TABLE "security_keys"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "security_keys" DROP CONSTRAINT "FK_24c97d0771cafedce6d7163eaad"`); + await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "webauthn_enabled"`); + await queryRunner.query(`DROP TABLE "security_keys"`); + } } diff --git a/src/util/migration/postgres/1696420827239-guildChannelOrdering.ts b/src/util/migration/postgres/1696420827239-guildChannelOrdering.ts
index 4848ffd0..2323ae6a 100644 --- a/src/util/migration/postgres/1696420827239-guildChannelOrdering.ts +++ b/src/util/migration/postgres/1696420827239-guildChannelOrdering.ts
@@ -1,38 +1,38 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class guildChannelOrdering1696420827239 implements MigrationInterface { - name = "guildChannelOrdering1696420827239"; + name = "guildChannelOrdering1696420827239"; - public async up(queryRunner: QueryRunner): Promise<void> { - const guilds = await queryRunner.query(`SELECT id FROM guilds`, undefined, true); + public async up(queryRunner: QueryRunner): Promise<void> { + const guilds = await queryRunner.query(`SELECT id FROM guilds`, undefined, true); - await queryRunner.query(`ALTER TABLE guilds ADD channel_ordering text NOT NULL DEFAULT '[]'`); + await queryRunner.query(`ALTER TABLE guilds ADD channel_ordering text NOT NULL DEFAULT '[]'`); - for (const guild_id of guilds.records.map((x) => x.id)) { - const channels: Array<{ position: number; id: string }> = (await queryRunner.query(`SELECT id, position FROM channels WHERE guild_id = $1`, [guild_id], true)).records; + for (const guild_id of guilds.records.map((x) => x.id)) { + const channels: Array<{ position: number; id: string }> = (await queryRunner.query(`SELECT id, position FROM channels WHERE guild_id = $1`, [guild_id], true)).records; - channels.sort((a, b) => a.position - b.position); + channels.sort((a, b) => a.position - b.position); - await queryRunner.query(`UPDATE guilds SET channel_ordering = $1 WHERE id = $2`, [JSON.stringify(channels.map((x) => x.id)), guild_id]); - } + await queryRunner.query(`UPDATE guilds SET channel_ordering = $1 WHERE id = $2`, [JSON.stringify(channels.map((x) => x.id)), guild_id]); + } - await queryRunner.query(`ALTER TABLE channels DROP COLUMN position`); - } + await queryRunner.query(`ALTER TABLE channels DROP COLUMN position`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE channels ADD position integer NOT NULL DEFAULT 0`); + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE channels ADD position integer NOT NULL DEFAULT 0`); - const guilds = await queryRunner.query(`SELECT id, channel_ordering FROM guilds`, undefined, true); + const guilds = await queryRunner.query(`SELECT id, channel_ordering FROM guilds`, undefined, true); - for (const guild of guilds.records) { - const channel_ordering: string[] = JSON.parse(guild.channel_ordering); + for (const guild of guilds.records) { + const channel_ordering: string[] = JSON.parse(guild.channel_ordering); - for (let i = 0; i < channel_ordering.length; i++) { - const channel_id = channel_ordering[i]; - await queryRunner.query(`UPDATE channels SET position = $1 WHERE id = $2`, [i, channel_id]); - } - } + for (let i = 0; i < channel_ordering.length; i++) { + const channel_id = channel_ordering[i]; + await queryRunner.query(`UPDATE channels SET position = $1 WHERE id = $2`, [i, channel_id]); + } + } - await queryRunner.query(`ALTER TABLE guilds DROP COLUMN channel_ordering`); - } + await queryRunner.query(`ALTER TABLE guilds DROP COLUMN channel_ordering`); + } } diff --git a/src/util/migration/postgres/1713116476900-messageFlagsNotNull.ts b/src/util/migration/postgres/1713116476900-messageFlagsNotNull.ts
index afec6854..57948bc3 100644 --- a/src/util/migration/postgres/1713116476900-messageFlagsNotNull.ts +++ b/src/util/migration/postgres/1713116476900-messageFlagsNotNull.ts
@@ -1,19 +1,19 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class MessageFlagsNotNull1713116476900 implements MigrationInterface { - name = "MessageFlagsNotNull1713116476900"; + name = "MessageFlagsNotNull1713116476900"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE messages RENAME COLUMN flags TO flags_old;"); - await queryRunner.query("ALTER TABLE messages ADD COLUMN flags integer NOT NULL DEFAULT 0;"); - await queryRunner.query("UPDATE messages SET flags = COALESCE(flags_old, 0);"); - await queryRunner.query("ALTER TABLE messages DROP COLUMN flags_old;"); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE messages RENAME COLUMN flags TO flags_old;"); + await queryRunner.query("ALTER TABLE messages ADD COLUMN flags integer NOT NULL DEFAULT 0;"); + await queryRunner.query("UPDATE messages SET flags = COALESCE(flags_old, 0);"); + await queryRunner.query("ALTER TABLE messages DROP COLUMN flags_old;"); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE messages RENAME COLUMN flags TO flags_new;"); - await queryRunner.query("ALTER TABLE messages ADD COLUMN flags integer;"); - await queryRunner.query("UPDATE messages SET flags = flags_new;"); - await queryRunner.query("ALTER TABLE messages DROP COLUMN flags_new;"); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE messages RENAME COLUMN flags TO flags_new;"); + await queryRunner.query("ALTER TABLE messages ADD COLUMN flags integer;"); + await queryRunner.query("UPDATE messages SET flags = flags_new;"); + await queryRunner.query("ALTER TABLE messages DROP COLUMN flags_new;"); + } } diff --git a/src/util/migration/postgres/1719776735000-newUserSettings.ts b/src/util/migration/postgres/1719776735000-newUserSettings.ts
index d4142d27..cd73037c 100644 --- a/src/util/migration/postgres/1719776735000-newUserSettings.ts +++ b/src/util/migration/postgres/1719776735000-newUserSettings.ts
@@ -1,15 +1,15 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class NewUserSettings1719776735000 implements MigrationInterface { - name = "NewUserSettings1719776735000"; + name = "NewUserSettings1719776735000"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE user_settings ADD COLUMN friend_discovery_flags integer DEFAULT 0;"); - await queryRunner.query("ALTER TABLE user_settings ADD COLUMN view_nsfw_guilds boolean DEFAULT true;"); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE user_settings ADD COLUMN friend_discovery_flags integer DEFAULT 0;"); + await queryRunner.query("ALTER TABLE user_settings ADD COLUMN view_nsfw_guilds boolean DEFAULT true;"); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE user_settings DROP COLUMN friend_discovery_flags;"); - await queryRunner.query("ALTER TABLE user_settings DROP COLUMN view_nsfw_guilds;"); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE user_settings DROP COLUMN friend_discovery_flags;"); + await queryRunner.query("ALTER TABLE user_settings DROP COLUMN view_nsfw_guilds;"); + } } diff --git a/src/util/migration/postgres/1720157926878-messagePollObject.ts b/src/util/migration/postgres/1720157926878-messagePollObject.ts
index 7c3c95a0..bd21c6e5 100644 --- a/src/util/migration/postgres/1720157926878-messagePollObject.ts +++ b/src/util/migration/postgres/1720157926878-messagePollObject.ts
@@ -1,13 +1,13 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class MessagePollObject1720157926878 implements MigrationInterface { - name = "MessagePollObject1720157926878"; + name = "MessagePollObject1720157926878"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE messages ADD poll text NULL"); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE messages ADD poll text NULL"); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE messages DROP COLUMN poll"); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE messages DROP COLUMN poll"); + } } diff --git a/src/util/migration/postgres/1720628601997-badges.ts b/src/util/migration/postgres/1720628601997-badges.ts
index 0cecb6ea..7fe1e19f 100644 --- a/src/util/migration/postgres/1720628601997-badges.ts +++ b/src/util/migration/postgres/1720628601997-badges.ts
@@ -1,17 +1,17 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class Badges1720628601997 implements MigrationInterface { - name = "Badges1720628601997"; + name = "Badges1720628601997"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query( - `CREATE TABLE "badges" ("id" character varying NOT NULL, "description" character varying NOT NULL, "icon" character varying NOT NULL, "link" character varying, CONSTRAINT "PK_8a651318b8de577e8e217676466" PRIMARY KEY ("id"))`, - ); - await queryRunner.query(`ALTER TABLE "users" ADD "badge_ids" text`); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + `CREATE TABLE "badges" ("id" character varying NOT NULL, "description" character varying NOT NULL, "icon" character varying NOT NULL, "link" character varying, CONSTRAINT "PK_8a651318b8de577e8e217676466" PRIMARY KEY ("id"))`, + ); + await queryRunner.query(`ALTER TABLE "users" ADD "badge_ids" text`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "badge_ids"`); - await queryRunner.query(`DROP TABLE "badges"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "badge_ids"`); + await queryRunner.query(`DROP TABLE "badges"`); + } } diff --git a/src/util/migration/postgres/1721298824927-webhookMessageProperties.ts b/src/util/migration/postgres/1721298824927-webhookMessageProperties.ts
index 46c507d4..3576e4ac 100644 --- a/src/util/migration/postgres/1721298824927-webhookMessageProperties.ts +++ b/src/util/migration/postgres/1721298824927-webhookMessageProperties.ts
@@ -1,15 +1,15 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class WebhookMessageProperties1721298824927 implements MigrationInterface { - name = "WebhookMessageProperties1721298824927"; + name = "WebhookMessageProperties1721298824927"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE messages ADD username text NULL"); - await queryRunner.query("ALTER TABLE messages ADD avatar text NULL"); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE messages ADD username text NULL"); + await queryRunner.query("ALTER TABLE messages ADD avatar text NULL"); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE messages DROP COLUMN username"); - await queryRunner.query("ALTER TABLE messages DROP COLUMN avatar"); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE messages DROP COLUMN username"); + await queryRunner.query("ALTER TABLE messages DROP COLUMN avatar"); + } } diff --git a/src/util/migration/postgres/1723347738541-client_status.ts b/src/util/migration/postgres/1723347738541-client_status.ts
index c16e0490..941e6d76 100644 --- a/src/util/migration/postgres/1723347738541-client_status.ts +++ b/src/util/migration/postgres/1723347738541-client_status.ts
@@ -1,13 +1,13 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class client_status1723347738541 implements MigrationInterface { - name = "client_status1723347738541"; + name = "client_status1723347738541"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE sessions ADD client_status text NULL"); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE sessions ADD client_status text NULL"); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE sessions DROP COLUMN client_status"); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE sessions DROP COLUMN client_status"); + } } diff --git a/src/util/migration/postgres/1723577874393-discoveryCategoryIcon.ts b/src/util/migration/postgres/1723577874393-discoveryCategoryIcon.ts
index 29b4138a..8dfde3cb 100644 --- a/src/util/migration/postgres/1723577874393-discoveryCategoryIcon.ts +++ b/src/util/migration/postgres/1723577874393-discoveryCategoryIcon.ts
@@ -1,13 +1,13 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class DiscoveryCategoryIcon1723577874393 implements MigrationInterface { - name = "DiscoveryCategoryIcon1723577874393"; + name = "DiscoveryCategoryIcon1723577874393"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE categories ADD icon text NULL"); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE categories ADD icon text NULL"); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE categories DROP COLUMN icon"); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE categories DROP COLUMN icon"); + } } diff --git a/src/util/migration/postgres/1723644478176-webhookSourceChannel.ts b/src/util/migration/postgres/1723644478176-webhookSourceChannel.ts
index 12a726ff..00fe413f 100644 --- a/src/util/migration/postgres/1723644478176-webhookSourceChannel.ts +++ b/src/util/migration/postgres/1723644478176-webhookSourceChannel.ts
@@ -1,17 +1,17 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class WebhookSourceChannel1723644478176 implements MigrationInterface { - name = "WebhookSourceChannel1723644478176"; + name = "WebhookSourceChannel1723644478176"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE webhooks ADD COLUMN source_channel_id VARCHAR(255) NULL DEFAULT NULL"); - await queryRunner.query( - "ALTER TABLE webhooks ADD CONSTRAINT FK_d64f38834fa676f6caa4786ddd6 FOREIGN KEY (source_channel_id) REFERENCES channels (id) ON UPDATE NO ACTION ON DELETE CASCADE", - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE webhooks ADD COLUMN source_channel_id VARCHAR(255) NULL DEFAULT NULL"); + await queryRunner.query( + "ALTER TABLE webhooks ADD CONSTRAINT FK_d64f38834fa676f6caa4786ddd6 FOREIGN KEY (source_channel_id) REFERENCES channels (id) ON UPDATE NO ACTION ON DELETE CASCADE", + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE webhooks DROP CONSTRAINT FK_d64f38834fa676f6caa4786ddd6"); - await queryRunner.query("ALTER TABLE webhooks DROP COLUMN source_channel_id"); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE webhooks DROP CONSTRAINT FK_d64f38834fa676f6caa4786ddd6"); + await queryRunner.query("ALTER TABLE webhooks DROP COLUMN source_channel_id"); + } } diff --git a/src/util/migration/postgres/1724477620293-teamMemberRole.ts b/src/util/migration/postgres/1724477620293-teamMemberRole.ts
index 9bc92cb7..043a1ddc 100644 --- a/src/util/migration/postgres/1724477620293-teamMemberRole.ts +++ b/src/util/migration/postgres/1724477620293-teamMemberRole.ts
@@ -1,13 +1,13 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class TeamMemberRole1724477620293 implements MigrationInterface { - name = "TeamMemberRole1724477620293"; + name = "TeamMemberRole1724477620293"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE team_members ADD COLUMN role text NOT NULL"); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE team_members ADD COLUMN role text NOT NULL"); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE team_members DROP COLUMN role"); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE team_members DROP COLUMN role"); + } } diff --git a/src/util/migration/postgres/1725090962922-applicationProperties.ts b/src/util/migration/postgres/1725090962922-applicationProperties.ts
index e3960148..03fb172f 100644 --- a/src/util/migration/postgres/1725090962922-applicationProperties.ts +++ b/src/util/migration/postgres/1725090962922-applicationProperties.ts
@@ -1,15 +1,15 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class ApplicationProperties1725090962922 implements MigrationInterface { - name = "ApplicationProperties1725090962922"; + name = "ApplicationProperties1725090962922"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE applications ADD COLUMN guild_id TEXT NULL DEFAULT NULL"); - await queryRunner.query("ALTER TABLE applications ADD COLUMN custom_install_url TEXT NULL DEFAULT NULL"); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE applications ADD COLUMN guild_id TEXT NULL DEFAULT NULL"); + await queryRunner.query("ALTER TABLE applications ADD COLUMN custom_install_url TEXT NULL DEFAULT NULL"); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query("ALTER TABLE applications DROP COLUMN guild_id"); - await queryRunner.query("ALTER TABLE applications DROP COLUMN custom_install_url"); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE applications DROP COLUMN guild_id"); + await queryRunner.query("ALTER TABLE applications DROP COLUMN custom_install_url"); + } } diff --git a/src/util/migration/postgres/1745625724865-voice.ts b/src/util/migration/postgres/1745625724865-voice.ts
index 2310ec20..0e110dda 100644 --- a/src/util/migration/postgres/1745625724865-voice.ts +++ b/src/util/migration/postgres/1745625724865-voice.ts
@@ -1,35 +1,35 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class Voice1745625724865 implements MigrationInterface { - name = "Voice1745625724865"; + name = "Voice1745625724865"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query( - `CREATE TABLE "streams" ("id" character varying NOT NULL, "owner_id" character varying NOT NULL, "channel_id" character varying NOT NULL, "endpoint" character varying NOT NULL, CONSTRAINT "PK_40440b6f569ebc02bc71c25c499" PRIMARY KEY ("id"))`, - ); - await queryRunner.query( - `CREATE TABLE "stream_sessions" ("id" character varying NOT NULL, "stream_id" character varying NOT NULL, "user_id" character varying NOT NULL, "token" character varying, "session_id" character varying NOT NULL, "used" boolean NOT NULL DEFAULT false, CONSTRAINT "PK_49bdc3f66394c12478f8371c546" PRIMARY KEY ("id"))`, - ); - await queryRunner.query( - `ALTER TABLE "streams" ADD CONSTRAINT "FK_1b566f9b54d1cda271da53ac82f" FOREIGN KEY ("owner_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, - ); - await queryRunner.query( - `ALTER TABLE "streams" ADD CONSTRAINT "FK_5101f0cded27ff0aae78fc4eed7" FOREIGN KEY ("channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, - ); - await queryRunner.query( - `ALTER TABLE "stream_sessions" ADD CONSTRAINT "FK_8b5a028a34dae9ee54af37c9c32" FOREIGN KEY ("stream_id") REFERENCES "streams"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, - ); - await queryRunner.query( - `ALTER TABLE "stream_sessions" ADD CONSTRAINT "FK_13ae5c29aff4d0890c54179511a" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + `CREATE TABLE "streams" ("id" character varying NOT NULL, "owner_id" character varying NOT NULL, "channel_id" character varying NOT NULL, "endpoint" character varying NOT NULL, CONSTRAINT "PK_40440b6f569ebc02bc71c25c499" PRIMARY KEY ("id"))`, + ); + await queryRunner.query( + `CREATE TABLE "stream_sessions" ("id" character varying NOT NULL, "stream_id" character varying NOT NULL, "user_id" character varying NOT NULL, "token" character varying, "session_id" character varying NOT NULL, "used" boolean NOT NULL DEFAULT false, CONSTRAINT "PK_49bdc3f66394c12478f8371c546" PRIMARY KEY ("id"))`, + ); + await queryRunner.query( + `ALTER TABLE "streams" ADD CONSTRAINT "FK_1b566f9b54d1cda271da53ac82f" FOREIGN KEY ("owner_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, + ); + await queryRunner.query( + `ALTER TABLE "streams" ADD CONSTRAINT "FK_5101f0cded27ff0aae78fc4eed7" FOREIGN KEY ("channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, + ); + await queryRunner.query( + `ALTER TABLE "stream_sessions" ADD CONSTRAINT "FK_8b5a028a34dae9ee54af37c9c32" FOREIGN KEY ("stream_id") REFERENCES "streams"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, + ); + await queryRunner.query( + `ALTER TABLE "stream_sessions" ADD CONSTRAINT "FK_13ae5c29aff4d0890c54179511a" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "stream_sessions" DROP CONSTRAINT "FK_13ae5c29aff4d0890c54179511a"`); - await queryRunner.query(`ALTER TABLE "stream_sessions" DROP CONSTRAINT "FK_8b5a028a34dae9ee54af37c9c32"`); - await queryRunner.query(`ALTER TABLE "streams" DROP CONSTRAINT "FK_5101f0cded27ff0aae78fc4eed7"`); - await queryRunner.query(`ALTER TABLE "streams" DROP CONSTRAINT "FK_1b566f9b54d1cda271da53ac82f"`); - await queryRunner.query(`DROP TABLE "stream_sessions"`); - await queryRunner.query(`DROP TABLE "streams"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "stream_sessions" DROP CONSTRAINT "FK_13ae5c29aff4d0890c54179511a"`); + await queryRunner.query(`ALTER TABLE "stream_sessions" DROP CONSTRAINT "FK_8b5a028a34dae9ee54af37c9c32"`); + await queryRunner.query(`ALTER TABLE "streams" DROP CONSTRAINT "FK_5101f0cded27ff0aae78fc4eed7"`); + await queryRunner.query(`ALTER TABLE "streams" DROP CONSTRAINT "FK_1b566f9b54d1cda271da53ac82f"`); + await queryRunner.query(`DROP TABLE "stream_sessions"`); + await queryRunner.query(`DROP TABLE "streams"`); + } } diff --git a/src/util/migration/postgres/1752157979333-UserSettingsProtos.ts b/src/util/migration/postgres/1752157979333-UserSettingsProtos.ts
index d7cf546d..7a243818 100644 --- a/src/util/migration/postgres/1752157979333-UserSettingsProtos.ts +++ b/src/util/migration/postgres/1752157979333-UserSettingsProtos.ts
@@ -1,20 +1,20 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class UserSettingsProtos1752157979333 implements MigrationInterface { - name = "UserSettingsProtos1752157979333"; + name = "UserSettingsProtos1752157979333"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`DROP TABLE IF EXISTS "user_settings_protos"`); - await queryRunner.query( - `CREATE TABLE "user_settings_protos" ("user_id" character varying NOT NULL, "userSettings" text, "frecencySettings" text, CONSTRAINT "PK_8ff3d1961a48b693810c9f99853" PRIMARY KEY ("user_id"))`, - ); - await queryRunner.query( - `ALTER TABLE "user_settings_protos" ADD CONSTRAINT "FK_8ff3d1961a48b693810c9f99853" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`DROP TABLE IF EXISTS "user_settings_protos"`); + await queryRunner.query( + `CREATE TABLE "user_settings_protos" ("user_id" character varying NOT NULL, "userSettings" text, "frecencySettings" text, CONSTRAINT "PK_8ff3d1961a48b693810c9f99853" PRIMARY KEY ("user_id"))`, + ); + await queryRunner.query( + `ALTER TABLE "user_settings_protos" ADD CONSTRAINT "FK_8ff3d1961a48b693810c9f99853" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "user_settings_protos" DROP CONSTRAINT "FK_8ff3d1961a48b693810c9f99853"`); - await queryRunner.query(`DROP TABLE "user_settings_protos"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "user_settings_protos" DROP CONSTRAINT "FK_8ff3d1961a48b693810c9f99853"`); + await queryRunner.query(`DROP TABLE "user_settings_protos"`); + } } diff --git a/src/util/migration/postgres/1752321571508-RoleColors.ts b/src/util/migration/postgres/1752321571508-RoleColors.ts
index c88476ea..0a1cbc9b 100644 --- a/src/util/migration/postgres/1752321571508-RoleColors.ts +++ b/src/util/migration/postgres/1752321571508-RoleColors.ts
@@ -1,15 +1,15 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class RoleColors1752321571508 implements MigrationInterface { - name = "RoleColors1752321571508"; + name = "RoleColors1752321571508"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "roles" ADD "colors" text`); - await queryRunner.query(`UPDATE "roles" SET "colors" = jsonb_build_object('primary_color', "color") WHERE "colors" IS NULL`); - await queryRunner.query(`ALTER TABLE "roles" ALTER COLUMN "colors" SET NOT NULL`); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "roles" ADD "colors" text`); + await queryRunner.query(`UPDATE "roles" SET "colors" = jsonb_build_object('primary_color', "color") WHERE "colors" IS NULL`); + await queryRunner.query(`ALTER TABLE "roles" ALTER COLUMN "colors" SET NOT NULL`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "roles" DROP COLUMN "colors"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "roles" DROP COLUMN "colors"`); + } } diff --git a/src/util/migration/postgres/1752383879533-message_pinned_at.ts b/src/util/migration/postgres/1752383879533-message_pinned_at.ts
index b5174776..f80b0a0b 100644 --- a/src/util/migration/postgres/1752383879533-message_pinned_at.ts +++ b/src/util/migration/postgres/1752383879533-message_pinned_at.ts
@@ -1,17 +1,17 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class MessagePinnedAt1752383879533 implements MigrationInterface { - name = "MessagePinnedAt1752383879533"; + name = "MessagePinnedAt1752383879533"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "messages" ADD "pinned_at" TIMESTAMP`); - await queryRunner.query(`UPDATE "messages" SET "pinned_at" = NOW() WHERE "pinned" = true`); - await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "pinned"`); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "messages" ADD "pinned_at" TIMESTAMP`); + await queryRunner.query(`UPDATE "messages" SET "pinned_at" = NOW() WHERE "pinned" = true`); + await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "pinned"`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "messages" ADD "pinned" boolean`); - await queryRunner.query(`UPDATE "messages" SET "pinned" = true WHERE "pinned_at" IS NOT NULL`); - await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "pinned_at"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "messages" ADD "pinned" boolean`); + await queryRunner.query(`UPDATE "messages" SET "pinned" = true WHERE "pinned_at" IS NOT NULL`); + await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "pinned_at"`); + } } diff --git a/src/util/migration/postgres/1753639700904-Automod.ts b/src/util/migration/postgres/1753639700904-Automod.ts
index 2df78ccd..083edd3a 100644 --- a/src/util/migration/postgres/1753639700904-Automod.ts +++ b/src/util/migration/postgres/1753639700904-Automod.ts
@@ -1,19 +1,19 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class Automod1753639700904 implements MigrationInterface { - name = "Automod1753639700904"; + name = "Automod1753639700904"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query( - `CREATE TABLE "automod_rules" ("id" character varying NOT NULL, "enabled" boolean NOT NULL, "event_type" integer NOT NULL, "exempt_channels" text NOT NULL, "exempt_roles" text NOT NULL, "guild_id" character varying NOT NULL, "name" character varying NOT NULL, "position" integer NOT NULL, "trigger_type" integer NOT NULL, "trigger_metadata" text, "actions" text NOT NULL, "creator_id" character varying, CONSTRAINT "PK_99789ae863507f5aed9e58d7866" PRIMARY KEY ("id"))`, - ); - await queryRunner.query( - `ALTER TABLE "automod_rules" ADD CONSTRAINT "FK_12d3d60b961393d310429c062b7" FOREIGN KEY ("creator_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + `CREATE TABLE "automod_rules" ("id" character varying NOT NULL, "enabled" boolean NOT NULL, "event_type" integer NOT NULL, "exempt_channels" text NOT NULL, "exempt_roles" text NOT NULL, "guild_id" character varying NOT NULL, "name" character varying NOT NULL, "position" integer NOT NULL, "trigger_type" integer NOT NULL, "trigger_metadata" text, "actions" text NOT NULL, "creator_id" character varying, CONSTRAINT "PK_99789ae863507f5aed9e58d7866" PRIMARY KEY ("id"))`, + ); + await queryRunner.query( + `ALTER TABLE "automod_rules" ADD CONSTRAINT "FK_12d3d60b961393d310429c062b7" FOREIGN KEY ("creator_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "automod_rules" DROP CONSTRAINT "FK_12d3d60b961393d310429c062b7"`); - await queryRunner.query(`DROP TABLE "automod_rules"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "automod_rules" DROP CONSTRAINT "FK_12d3d60b961393d310429c062b7"`); + await queryRunner.query(`DROP TABLE "automod_rules"`); + } } diff --git a/src/util/migration/postgres/1758654246197-CloudAttachments.ts b/src/util/migration/postgres/1758654246197-CloudAttachments.ts
index 6e462e0b..86894f1d 100644 --- a/src/util/migration/postgres/1758654246197-CloudAttachments.ts +++ b/src/util/migration/postgres/1758654246197-CloudAttachments.ts
@@ -1,23 +1,23 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class CloudAttachments1758654246197 implements MigrationInterface { - name = "CloudAttachments1758654246197"; + name = "CloudAttachments1758654246197"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query( - `CREATE TABLE "cloud_attachments" ("id" character varying NOT NULL, "user_id" character varying, "channel_id" character varying, "upload_filename" character varying NOT NULL, "user_attachment_id" character varying, "user_filename" character varying NOT NULL, "user_file_size" integer, "user_original_content_type" character varying, "user_is_clip" boolean, "size" integer, "height" integer, "width" integer, "content_type" character varying, "userId" character varying, "channelId" character varying, CONSTRAINT "PK_5794827a3ee7c9318612dcb70c8" PRIMARY KEY ("id"))`, - ); - await queryRunner.query( - `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_e6b32df2004e8ad0f488b4a2019" FOREIGN KEY ("userId") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, - ); - await queryRunner.query( - `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_cab965a18f8ca30293bff3d50a8" FOREIGN KEY ("channelId") REFERENCES "channels"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + `CREATE TABLE "cloud_attachments" ("id" character varying NOT NULL, "user_id" character varying, "channel_id" character varying, "upload_filename" character varying NOT NULL, "user_attachment_id" character varying, "user_filename" character varying NOT NULL, "user_file_size" integer, "user_original_content_type" character varying, "user_is_clip" boolean, "size" integer, "height" integer, "width" integer, "content_type" character varying, "userId" character varying, "channelId" character varying, CONSTRAINT "PK_5794827a3ee7c9318612dcb70c8" PRIMARY KEY ("id"))`, + ); + await queryRunner.query( + `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_e6b32df2004e8ad0f488b4a2019" FOREIGN KEY ("userId") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, + ); + await queryRunner.query( + `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_cab965a18f8ca30293bff3d50a8" FOREIGN KEY ("channelId") REFERENCES "channels"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_cab965a18f8ca30293bff3d50a8"`); - await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_e6b32df2004e8ad0f488b4a2019"`); - await queryRunner.query(`DROP TABLE "cloud_attachments"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_cab965a18f8ca30293bff3d50a8"`); + await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_e6b32df2004e8ad0f488b4a2019"`); + await queryRunner.query(`DROP TABLE "cloud_attachments"`); + } } diff --git a/src/util/migration/postgres/1758654621365-CloudAttachmentsFixIdRefs.ts b/src/util/migration/postgres/1758654621365-CloudAttachmentsFixIdRefs.ts
index 6ad63000..dcd1b77c 100644 --- a/src/util/migration/postgres/1758654621365-CloudAttachmentsFixIdRefs.ts +++ b/src/util/migration/postgres/1758654621365-CloudAttachmentsFixIdRefs.ts
@@ -1,31 +1,31 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class CloudAttachmentsFixIdRefs1758654621365 implements MigrationInterface { - name = "CloudAttachmentsFixIdRefs1758654621365"; + name = "CloudAttachmentsFixIdRefs1758654621365"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_cab965a18f8ca30293bff3d50a8"`); - await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_e6b32df2004e8ad0f488b4a2019"`); - await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP COLUMN "channelId"`); - await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP COLUMN "userId"`); - await queryRunner.query( - `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_8bf8cc8767e48cb482ff644fce6" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, - ); - await queryRunner.query( - `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_998d5fe91008ba5b09e1322104c" FOREIGN KEY ("channel_id") REFERENCES "channels"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_cab965a18f8ca30293bff3d50a8"`); + await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_e6b32df2004e8ad0f488b4a2019"`); + await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP COLUMN "channelId"`); + await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP COLUMN "userId"`); + await queryRunner.query( + `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_8bf8cc8767e48cb482ff644fce6" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, + ); + await queryRunner.query( + `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_998d5fe91008ba5b09e1322104c" FOREIGN KEY ("channel_id") REFERENCES "channels"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_998d5fe91008ba5b09e1322104c"`); - await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_8bf8cc8767e48cb482ff644fce6"`); - await queryRunner.query(`ALTER TABLE "cloud_attachments" ADD "userId" character varying`); - await queryRunner.query(`ALTER TABLE "cloud_attachments" ADD "channelId" character varying`); - await queryRunner.query( - `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_e6b32df2004e8ad0f488b4a2019" FOREIGN KEY ("userId") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, - ); - await queryRunner.query( - `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_cab965a18f8ca30293bff3d50a8" FOREIGN KEY ("channelId") REFERENCES "channels"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, - ); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_998d5fe91008ba5b09e1322104c"`); + await queryRunner.query(`ALTER TABLE "cloud_attachments" DROP CONSTRAINT "FK_8bf8cc8767e48cb482ff644fce6"`); + await queryRunner.query(`ALTER TABLE "cloud_attachments" ADD "userId" character varying`); + await queryRunner.query(`ALTER TABLE "cloud_attachments" ADD "channelId" character varying`); + await queryRunner.query( + `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_e6b32df2004e8ad0f488b4a2019" FOREIGN KEY ("userId") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, + ); + await queryRunner.query( + `ALTER TABLE "cloud_attachments" ADD CONSTRAINT "FK_cab965a18f8ca30293bff3d50a8" FOREIGN KEY ("channelId") REFERENCES "channels"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, + ); + } } diff --git a/src/util/migration/postgres/1760622755598-ApplicationCommands.ts b/src/util/migration/postgres/1760622755598-ApplicationCommands.ts
index e40a3a1e..6d4aebc5 100644 --- a/src/util/migration/postgres/1760622755598-ApplicationCommands.ts +++ b/src/util/migration/postgres/1760622755598-ApplicationCommands.ts
@@ -1,15 +1,15 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class ApplicationCommands1760622755598 implements MigrationInterface { - name = "ApplicationCommands1760622755598"; + name = "ApplicationCommands1760622755598"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query( - `CREATE TABLE "application_commands" ("id" character varying NOT NULL, "type" integer NOT NULL DEFAULT '1', "application_id" character varying NOT NULL, "guild_id" character varying, "name" character varying NOT NULL, "name_localizations" text, "description" character varying NOT NULL, "description_localizations" text, "options" text, "default_member_permissions" character varying, "dm_permission" boolean NOT NULL DEFAULT true, "permissions" text, "nsfw" boolean NOT NULL DEFAULT false, "integration_types" text, "global_popularity_rank" integer NOT NULL DEFAULT '0', "contexts" text, "version" character varying NOT NULL DEFAULT '0', "handler" integer NOT NULL DEFAULT '0', CONSTRAINT "PK_0f73c2f025989c407947e1f75fe" PRIMARY KEY ("id"))`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + `CREATE TABLE "application_commands" ("id" character varying NOT NULL, "type" integer NOT NULL DEFAULT '1', "application_id" character varying NOT NULL, "guild_id" character varying, "name" character varying NOT NULL, "name_localizations" text, "description" character varying NOT NULL, "description_localizations" text, "options" text, "default_member_permissions" character varying, "dm_permission" boolean NOT NULL DEFAULT true, "permissions" text, "nsfw" boolean NOT NULL DEFAULT false, "integration_types" text, "global_popularity_rank" integer NOT NULL DEFAULT '0', "contexts" text, "version" character varying NOT NULL DEFAULT '0', "handler" integer NOT NULL DEFAULT '0', CONSTRAINT "PK_0f73c2f025989c407947e1f75fe" PRIMARY KEY ("id"))`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`DROP TABLE "application_commands"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`DROP TABLE "application_commands"`); + } } diff --git a/src/util/migration/postgres/1760622755599-ReconcileMigrationAttempts.ts b/src/util/migration/postgres/1760622755599-ReconcileMigrationAttempts.ts
index 27a20278..fefd5473 100644 --- a/src/util/migration/postgres/1760622755599-ReconcileMigrationAttempts.ts +++ b/src/util/migration/postgres/1760622755599-ReconcileMigrationAttempts.ts
@@ -1,57 +1,57 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class ReconcileMigrationAttempts1760622755598 implements MigrationInterface { - name = "ReconcileMigrationAttempts1760622755598"; + name = "ReconcileMigrationAttempts1760622755598"; - public async up(queryRunner: QueryRunner): Promise<void> { - // doesnt work because initial setup is syncDb() - //await queryRunner.query(`ALTER TABLE "webhooks" DROP CONSTRAINT "fk_d64f38834fa676f6caa4786ddd6"`); - await queryRunner.query(`ALTER TABLE "webhooks" ALTER COLUMN "source_channel_id" TYPE character varying`); - await queryRunner.query(`ALTER TABLE "messages" ALTER COLUMN "username" TYPE character varying`); - await queryRunner.query(`ALTER TABLE "messages" ALTER COLUMN "avatar" TYPE character varying`); - await queryRunner.query(`ALTER TABLE "channels" ALTER COLUMN "default_thread_rate_limit_per_user" DROP NOT NULL`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "client_status" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "friend_discovery_flags" DROP DEFAULT`); - await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "view_nsfw_guilds" DROP DEFAULT`); - await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "flags" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "public_flags" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "purchased_flags" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "team_members" ALTER COLUMN "role" TYPE character varying`); - await queryRunner.query(`ALTER TABLE "team_members" ALTER COLUMN "role" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "applications" ALTER COLUMN "guild_id" TYPE character varying`); - await queryRunner.query(`ALTER TABLE "applications" ALTER COLUMN "custom_install_url" TYPE character varying`); - await queryRunner.query(`ALTER TABLE "categories" ALTER COLUMN "icon" TYPE character varying`); - await queryRunner.query(`ALTER TABLE "user_settings_protos" ALTER COLUMN "userSettings" TYPE character varying`); - await queryRunner.query(`ALTER TABLE "user_settings_protos" ALTER COLUMN "frecencySettings" TYPE character varying`); - await queryRunner.query( - `ALTER TABLE "webhooks" ADD CONSTRAINT "FK_4495b7032a33c6b8b605d030398" FOREIGN KEY ("source_channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, - ); - await queryRunner.query( - `ALTER TABLE "applications" ADD CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + // doesnt work because initial setup is syncDb() + //await queryRunner.query(`ALTER TABLE "webhooks" DROP CONSTRAINT "fk_d64f38834fa676f6caa4786ddd6"`); + await queryRunner.query(`ALTER TABLE "webhooks" ALTER COLUMN "source_channel_id" TYPE character varying`); + await queryRunner.query(`ALTER TABLE "messages" ALTER COLUMN "username" TYPE character varying`); + await queryRunner.query(`ALTER TABLE "messages" ALTER COLUMN "avatar" TYPE character varying`); + await queryRunner.query(`ALTER TABLE "channels" ALTER COLUMN "default_thread_rate_limit_per_user" DROP NOT NULL`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "client_status" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "friend_discovery_flags" DROP DEFAULT`); + await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "view_nsfw_guilds" DROP DEFAULT`); + await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "flags" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "public_flags" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "purchased_flags" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "team_members" ALTER COLUMN "role" TYPE character varying`); + await queryRunner.query(`ALTER TABLE "team_members" ALTER COLUMN "role" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "applications" ALTER COLUMN "guild_id" TYPE character varying`); + await queryRunner.query(`ALTER TABLE "applications" ALTER COLUMN "custom_install_url" TYPE character varying`); + await queryRunner.query(`ALTER TABLE "categories" ALTER COLUMN "icon" TYPE character varying`); + await queryRunner.query(`ALTER TABLE "user_settings_protos" ALTER COLUMN "userSettings" TYPE character varying`); + await queryRunner.query(`ALTER TABLE "user_settings_protos" ALTER COLUMN "frecencySettings" TYPE character varying`); + await queryRunner.query( + `ALTER TABLE "webhooks" ADD CONSTRAINT "FK_4495b7032a33c6b8b605d030398" FOREIGN KEY ("source_channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, + ); + await queryRunner.query( + `ALTER TABLE "applications" ADD CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba" FOREIGN KEY ("guild_id") REFERENCES "guilds"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "applications" DROP CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba"`); - await queryRunner.query(`ALTER TABLE "webhooks" DROP CONSTRAINT "FK_4495b7032a33c6b8b605d030398"`); - await queryRunner.query(`ALTER TABLE "user_settings_protos" ALTER COLUMN "frecencySettings" TYPE text`); - await queryRunner.query(`ALTER TABLE "user_settings_protos" ALTER COLUMN "userSettings" TYPE text`); - await queryRunner.query(`ALTER TABLE "categories" ALTER COLUMN "icon" TYPE text`); - await queryRunner.query(`ALTER TABLE "applications" ALTER COLUMN "custom_install_url" TYPE text`); - await queryRunner.query(`ALTER TABLE "applications" ALTER COLUMN "guild_id" TYPE text`); - await queryRunner.query(`ALTER TABLE "team_members" ALTER COLUMN "role" TYPE text`); - await queryRunner.query(`ALTER TABLE "team_members" ALTER COLUMN "role" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "purchased_flags" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "public_flags" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "flags" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "view_nsfw_guilds" SET DEFAULT true`); - await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "friend_discovery_flags" SET DEFAULT '0'`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "client_status" DROP NOT NULL`); - await queryRunner.query(`ALTER TABLE "channels" ALTER COLUMN "default_thread_rate_limit_per_user" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "messages" ALTER COLUMN "avatar" TYPE text`); - await queryRunner.query(`ALTER TABLE "messages" ALTER COLUMN "username" TYPE text`); - await queryRunner.query(`ALTER TABLE "webhooks" ALTER COLUMN "source_channel_id" TYPE character varying(255)`); - await queryRunner.query(`ALTER TABLE "webhooks" ALTER COLUMN "source_channel_id" SET DEFAULT NULL`); - // await queryRunner.query(`ALTER TABLE "webhooks" ADD CONSTRAINT "fk_d64f38834fa676f6caa4786ddd6" FOREIGN KEY ("source_channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "applications" DROP CONSTRAINT "FK_e5bf78cdbbe9ba91062d74c5aba"`); + await queryRunner.query(`ALTER TABLE "webhooks" DROP CONSTRAINT "FK_4495b7032a33c6b8b605d030398"`); + await queryRunner.query(`ALTER TABLE "user_settings_protos" ALTER COLUMN "frecencySettings" TYPE text`); + await queryRunner.query(`ALTER TABLE "user_settings_protos" ALTER COLUMN "userSettings" TYPE text`); + await queryRunner.query(`ALTER TABLE "categories" ALTER COLUMN "icon" TYPE text`); + await queryRunner.query(`ALTER TABLE "applications" ALTER COLUMN "custom_install_url" TYPE text`); + await queryRunner.query(`ALTER TABLE "applications" ALTER COLUMN "guild_id" TYPE text`); + await queryRunner.query(`ALTER TABLE "team_members" ALTER COLUMN "role" TYPE text`); + await queryRunner.query(`ALTER TABLE "team_members" ALTER COLUMN "role" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "purchased_flags" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "public_flags" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "users" ALTER COLUMN "flags" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "view_nsfw_guilds" SET DEFAULT true`); + await queryRunner.query(`ALTER TABLE "user_settings" ALTER COLUMN "friend_discovery_flags" SET DEFAULT '0'`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "client_status" DROP NOT NULL`); + await queryRunner.query(`ALTER TABLE "channels" ALTER COLUMN "default_thread_rate_limit_per_user" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "messages" ALTER COLUMN "avatar" TYPE text`); + await queryRunner.query(`ALTER TABLE "messages" ALTER COLUMN "username" TYPE text`); + await queryRunner.query(`ALTER TABLE "webhooks" ALTER COLUMN "source_channel_id" TYPE character varying(255)`); + await queryRunner.query(`ALTER TABLE "webhooks" ALTER COLUMN "source_channel_id" SET DEFAULT NULL`); + // await queryRunner.query(`ALTER TABLE "webhooks" ADD CONSTRAINT "fk_d64f38834fa676f6caa4786ddd6" FOREIGN KEY ("source_channel_id") REFERENCES "channels"("id") ON DELETE CASCADE ON UPDATE NO ACTION`); + } } diff --git a/src/util/migration/postgres/1760694225225-message_interaction_metadata.ts b/src/util/migration/postgres/1760694225225-message_interaction_metadata.ts
index 317361da..2b4afed7 100644 --- a/src/util/migration/postgres/1760694225225-message_interaction_metadata.ts +++ b/src/util/migration/postgres/1760694225225-message_interaction_metadata.ts
@@ -1,13 +1,13 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class MessageInteractionMetadata1760694225225 implements MigrationInterface { - name = "MessageInteractionMetadata1760694225225"; + name = "MessageInteractionMetadata1760694225225"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "messages" ADD "interaction_metadata" text`); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "messages" ADD "interaction_metadata" text`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "interaction_metadata"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "messages" DROP COLUMN "interaction_metadata"`); + } } diff --git a/src/util/migration/postgres/1760961911873-message_reference_fix.ts b/src/util/migration/postgres/1760961911873-message_reference_fix.ts
index 1f61ab17..6a295981 100644 --- a/src/util/migration/postgres/1760961911873-message_reference_fix.ts +++ b/src/util/migration/postgres/1760961911873-message_reference_fix.ts
@@ -1,19 +1,19 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class MessageReferenceFix1760961911873 implements MigrationInterface { - name = "MessageReferenceFix1760961911873"; + name = "MessageReferenceFix1760961911873"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "messages" DROP CONSTRAINT "FK_61a92bb65b302a76d9c1fcd3174"`); - await queryRunner.query( - `ALTER TABLE "messages" ADD CONSTRAINT "FK_61a92bb65b302a76d9c1fcd3174" FOREIGN KEY ("message_reference_id") REFERENCES "messages"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "messages" DROP CONSTRAINT "FK_61a92bb65b302a76d9c1fcd3174"`); + await queryRunner.query( + `ALTER TABLE "messages" ADD CONSTRAINT "FK_61a92bb65b302a76d9c1fcd3174" FOREIGN KEY ("message_reference_id") REFERENCES "messages"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "messages" DROP CONSTRAINT "FK_61a92bb65b302a76d9c1fcd3174"`); - 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`, - ); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "messages" DROP CONSTRAINT "FK_61a92bb65b302a76d9c1fcd3174"`); + 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`, + ); + } } diff --git a/src/util/migration/postgres/1761113394664-delete-bot-users-without-an-application.ts b/src/util/migration/postgres/1761113394664-delete-bot-users-without-an-application.ts
index e3209927..cf770afc 100644 --- a/src/util/migration/postgres/1761113394664-delete-bot-users-without-an-application.ts +++ b/src/util/migration/postgres/1761113394664-delete-bot-users-without-an-application.ts
@@ -1,10 +1,10 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class DeleteBotUsersWithoutAnApplication1761113394664 implements MigrationInterface { - name = "DeleteBotUsersWithoutAnApplication1761113394664"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`DELETE FROM users WHERE bot = true AND id NOT IN (SELECT bot_user_id FROM applications);`); - } + name = "DeleteBotUsersWithoutAnApplication1761113394664"; + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`DELETE FROM users WHERE bot = true AND id NOT IN (SELECT bot_user_id FROM applications);`); + } - public async down(queryRunner: QueryRunner): Promise<void> {} + public async down(queryRunner: QueryRunner): Promise<void> {} } diff --git a/src/util/migration/postgres/1761209437070-application-commands-options-default.ts b/src/util/migration/postgres/1761209437070-application-commands-options-default.ts
index 1a1a4918..7eba1ee2 100644 --- a/src/util/migration/postgres/1761209437070-application-commands-options-default.ts +++ b/src/util/migration/postgres/1761209437070-application-commands-options-default.ts
@@ -1,16 +1,16 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class ApplicationCommandsOptionsDefault1761209437070 implements MigrationInterface { - name = "ApplicationCommandsOptionsDefault1761209437070"; + name = "ApplicationCommandsOptionsDefault1761209437070"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`UPDATE "application_commands" SET "options" = '[]' WHERE "options" IS NULL`); - await queryRunner.query(`ALTER TABLE "application_commands" ALTER COLUMN "options" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "application_commands" ALTER COLUMN "options" SET DEFAULT '[]'`); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`UPDATE "application_commands" SET "options" = '[]' WHERE "options" IS NULL`); + await queryRunner.query(`ALTER TABLE "application_commands" ALTER COLUMN "options" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "application_commands" ALTER COLUMN "options" SET DEFAULT '[]'`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "application_commands" ALTER COLUMN "options" DROP DEFAULT`); - await queryRunner.query(`ALTER TABLE "application_commands" ALTER COLUMN "options" DROP NOT NULL`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "application_commands" ALTER COLUMN "options" DROP DEFAULT`); + await queryRunner.query(`ALTER TABLE "application_commands" ALTER COLUMN "options" DROP NOT NULL`); + } } diff --git a/src/util/migration/postgres/1762611552514-fix-gif-stickers-format_type.ts b/src/util/migration/postgres/1762611552514-fix-gif-stickers-format_type.ts
index 0e17bf81..c459cb5b 100644 --- a/src/util/migration/postgres/1762611552514-fix-gif-stickers-format_type.ts +++ b/src/util/migration/postgres/1762611552514-fix-gif-stickers-format_type.ts
@@ -1,12 +1,12 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class FixGifStickersFormatType1762611552514 implements MigrationInterface { - name = "FixGifStickersFormatType1762611552514"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`UPDATE "stickers" SET "format_type" = 4 WHERE "format_type" = 0;`); - } + name = "FixGifStickersFormatType1762611552514"; + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`UPDATE "stickers" SET "format_type" = 4 WHERE "format_type" = 0;`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`UPDATE "stickers" SET "format_type" = 0 WHERE "format_type" = 4;`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`UPDATE "stickers" SET "format_type" = 0 WHERE "format_type" = 4;`); + } } diff --git a/src/util/migration/postgres/1763630755675-default-activities-to-empty-array.ts b/src/util/migration/postgres/1763630755675-default-activities-to-empty-array.ts
index cc4b5337..ecb9d1ec 100644 --- a/src/util/migration/postgres/1763630755675-default-activities-to-empty-array.ts +++ b/src/util/migration/postgres/1763630755675-default-activities-to-empty-array.ts
@@ -1,15 +1,15 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class DefaultActivitiesToEmptyArray1763630755675 implements MigrationInterface { - name = "DefaultActivitiesToEmptyArray1763630755675"; + name = "DefaultActivitiesToEmptyArray1763630755675"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "activities" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "activities" SET DEFAULT '[]'`); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "activities" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "activities" SET DEFAULT '[]'`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "activities" DROP DEFAULT`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "activities" DROP NOT NULL`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "activities" DROP DEFAULT`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "activities" DROP NOT NULL`); + } } diff --git a/src/util/migration/postgres/1765143034407-DontIpBanBanner.ts b/src/util/migration/postgres/1765143034407-DontIpBanBanner.ts
index 2207e9c0..249c6478 100644 --- a/src/util/migration/postgres/1765143034407-DontIpBanBanner.ts +++ b/src/util/migration/postgres/1765143034407-DontIpBanBanner.ts
@@ -1,15 +1,15 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class DontIpBanBanner1765143034407 implements MigrationInterface { - name = "DontIpBanBanner1765143034407"; + name = "DontIpBanBanner1765143034407"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "bans" ALTER COLUMN "ip" DROP NOT NULL`); - await queryRunner.query(`UPDATE "bans" SET "ip" = NULL`); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "bans" ALTER COLUMN "ip" DROP NOT NULL`); + await queryRunner.query(`UPDATE "bans" SET "ip" = NULL`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`UPDATE "bans" SET "ip" = '0.0.0.0' WHERE "ip" IS NULL`); - await queryRunner.query(`ALTER TABLE "bans" ALTER COLUMN "ip" SET NOT NULL`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`UPDATE "bans" SET "ip" = '0.0.0.0' WHERE "ip" IS NULL`); + await queryRunner.query(`ALTER TABLE "bans" ALTER COLUMN "ip" SET NOT NULL`); + } } diff --git a/src/util/migration/postgres/1765578570423-InstanceBanTable.ts b/src/util/migration/postgres/1765578570423-InstanceBanTable.ts
index be8cb9cc..205e150d 100644 --- a/src/util/migration/postgres/1765578570423-InstanceBanTable.ts +++ b/src/util/migration/postgres/1765578570423-InstanceBanTable.ts
@@ -1,19 +1,19 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class InstanceBanTable1765578570423 implements MigrationInterface { - name = "InstanceBanTable1765578570423"; + name = "InstanceBanTable1765578570423"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query( - `CREATE TABLE "instance_bans" ("id" character varying NOT NULL, "created_at" TIMESTAMP NOT NULL DEFAULT now(), "reason" character varying NOT NULL, "user_id" character varying, "fingerprint" character varying, "ip_address" character varying, "is_from_other_instance_ban" boolean NOT NULL DEFAULT false, "origin_instance_ban_id" character varying, CONSTRAINT "REL_0b02d18d0d830f160c921192a3" UNIQUE ("origin_instance_ban_id"), CONSTRAINT "PK_3aa6e80a6d325601054892b1340" PRIMARY KEY ("id"))`, - ); - await queryRunner.query( - `ALTER TABLE "instance_bans" ADD CONSTRAINT "FK_0b02d18d0d830f160c921192a30" FOREIGN KEY ("origin_instance_ban_id") REFERENCES "instance_bans"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + `CREATE TABLE "instance_bans" ("id" character varying NOT NULL, "created_at" TIMESTAMP NOT NULL DEFAULT now(), "reason" character varying NOT NULL, "user_id" character varying, "fingerprint" character varying, "ip_address" character varying, "is_from_other_instance_ban" boolean NOT NULL DEFAULT false, "origin_instance_ban_id" character varying, CONSTRAINT "REL_0b02d18d0d830f160c921192a3" UNIQUE ("origin_instance_ban_id"), CONSTRAINT "PK_3aa6e80a6d325601054892b1340" PRIMARY KEY ("id"))`, + ); + await queryRunner.query( + `ALTER TABLE "instance_bans" ADD CONSTRAINT "FK_0b02d18d0d830f160c921192a30" FOREIGN KEY ("origin_instance_ban_id") REFERENCES "instance_bans"("id") ON DELETE SET NULL ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "instance_bans" DROP CONSTRAINT "FK_0b02d18d0d830f160c921192a30"`); - await queryRunner.query(`DROP TABLE "instance_bans"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "instance_bans" DROP CONSTRAINT "FK_0b02d18d0d830f160c921192a30"`); + await queryRunner.query(`DROP TABLE "instance_bans"`); + } } diff --git a/src/util/migration/postgres/1765587835846-InstanceBanAllowlist.ts b/src/util/migration/postgres/1765587835846-InstanceBanAllowlist.ts
index 8c907aa9..9eefea48 100644 --- a/src/util/migration/postgres/1765587835846-InstanceBanAllowlist.ts +++ b/src/util/migration/postgres/1765587835846-InstanceBanAllowlist.ts
@@ -1,13 +1,13 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class InstanceBanAllowlist1765587835846 implements MigrationInterface { - name = "InstanceBanAllowlist1765587835846"; + name = "InstanceBanAllowlist1765587835846"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "instance_bans" ADD "is_allowlisted" boolean NOT NULL DEFAULT false`); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "instance_bans" ADD "is_allowlisted" boolean NOT NULL DEFAULT false`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "instance_bans" DROP COLUMN "is_allowlisted"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "instance_bans" DROP COLUMN "is_allowlisted"`); + } } diff --git a/src/util/migration/postgres/1765665440000-DropDefaultIPDataKey.ts b/src/util/migration/postgres/1765665440000-DropDefaultIPDataKey.ts
index ea887b1b..2e58ff7d 100644 --- a/src/util/migration/postgres/1765665440000-DropDefaultIPDataKey.ts +++ b/src/util/migration/postgres/1765665440000-DropDefaultIPDataKey.ts
@@ -1,17 +1,17 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class DropDefaultIPDataKey1765665440000 implements MigrationInterface { - name = "DropDefaultIPDataKey1765665440000"; + name = "DropDefaultIPDataKey1765665440000"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query( - `UPDATE "config" SET "value" = NULL WHERE "key" = 'security_ipdataApiKey' AND "value" = '"eca677b284b3bac29eb72f5e496aa9047f26543605efe99ff2ce35c9"'`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + `UPDATE "config" SET "value" = NULL WHERE "key" = 'security_ipdataApiKey' AND "value" = '"eca677b284b3bac29eb72f5e496aa9047f26543605efe99ff2ce35c9"'`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query( - `UPDATE "config" SET "value" = '"eca677b284b3bac29eb72f5e496aa9047f26543605efe99ff2ce35c9"' WHERE "key" = 'security_ipdataApiKey' AND "value" IS NULL`, - ); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + `UPDATE "config" SET "value" = '"eca677b284b3bac29eb72f5e496aa9047f26543605efe99ff2ce35c9"' WHERE "key" = 'security_ipdataApiKey' AND "value" IS NULL`, + ); + } } diff --git a/src/util/migration/postgres/1765863159930-ExtendedSessionInfo.ts b/src/util/migration/postgres/1765863159930-ExtendedSessionInfo.ts
index c320ed7b..d6271cfe 100644 --- a/src/util/migration/postgres/1765863159930-ExtendedSessionInfo.ts +++ b/src/util/migration/postgres/1765863159930-ExtendedSessionInfo.ts
@@ -1,41 +1,41 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class ExtendedSessionInfo1765863159930 implements MigrationInterface { - name = "ExtendedSessionInfo1765863159930"; + name = "ExtendedSessionInfo1765863159930"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "sessions" DROP CONSTRAINT "PK_3238ef96f18b355b671619111bc"`); - await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "id"`); - await queryRunner.query(`ALTER TABLE "sessions" ADD "is_admin_session" boolean NOT NULL DEFAULT false`); - await queryRunner.query(`ALTER TABLE "sessions" ADD "created_at" TIMESTAMP NOT NULL DEFAULT now()`); - await queryRunner.query(`ALTER TABLE "sessions" ADD "last_seen" TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:00'`); - await queryRunner.query(`ALTER TABLE "sessions" ADD "last_seen_ip" character varying NOT NULL DEFAULT '127.0.0.1'`); - await queryRunner.query(`ALTER TABLE "sessions" ADD "last_seen_location" character varying`); - await queryRunner.query(`ALTER TABLE "webhooks" ALTER COLUMN "source_channel_id" DROP DEFAULT`); - await queryRunner.query(`ALTER TABLE "sessions" DROP CONSTRAINT "FK_085d540d9f418cfbdc7bd55bb19"`); - await queryRunner.query(`ALTER TABLE "sessions" ADD CONSTRAINT "PK_9340188c93349808f10d1db74a8" PRIMARY KEY ("session_id")`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "user_id" SET NOT NULL`); - await queryRunner.query(`CREATE INDEX "IDX_085d540d9f418cfbdc7bd55bb1" ON "sessions" ("user_id") `); - await queryRunner.query( - `ALTER TABLE "sessions" ADD CONSTRAINT "FK_085d540d9f418cfbdc7bd55bb19" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, - ); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "sessions" DROP CONSTRAINT "PK_3238ef96f18b355b671619111bc"`); + await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "id"`); + await queryRunner.query(`ALTER TABLE "sessions" ADD "is_admin_session" boolean NOT NULL DEFAULT false`); + await queryRunner.query(`ALTER TABLE "sessions" ADD "created_at" TIMESTAMP NOT NULL DEFAULT now()`); + await queryRunner.query(`ALTER TABLE "sessions" ADD "last_seen" TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:00'`); + await queryRunner.query(`ALTER TABLE "sessions" ADD "last_seen_ip" character varying NOT NULL DEFAULT '127.0.0.1'`); + await queryRunner.query(`ALTER TABLE "sessions" ADD "last_seen_location" character varying`); + await queryRunner.query(`ALTER TABLE "webhooks" ALTER COLUMN "source_channel_id" DROP DEFAULT`); + await queryRunner.query(`ALTER TABLE "sessions" DROP CONSTRAINT "FK_085d540d9f418cfbdc7bd55bb19"`); + await queryRunner.query(`ALTER TABLE "sessions" ADD CONSTRAINT "PK_9340188c93349808f10d1db74a8" PRIMARY KEY ("session_id")`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "user_id" SET NOT NULL`); + await queryRunner.query(`CREATE INDEX "IDX_085d540d9f418cfbdc7bd55bb1" ON "sessions" ("user_id") `); + await queryRunner.query( + `ALTER TABLE "sessions" ADD CONSTRAINT "FK_085d540d9f418cfbdc7bd55bb19" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE ON UPDATE NO ACTION`, + ); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "sessions" DROP CONSTRAINT "FK_085d540d9f418cfbdc7bd55bb19"`); - await queryRunner.query(`ALTER TABLE "webhooks" DROP CONSTRAINT "FK_4495b7032a33c6b8b605d030398"`); - await queryRunner.query(`DROP INDEX "public"."IDX_085d540d9f418cfbdc7bd55bb1"`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "user_id" DROP NOT NULL`); - await queryRunner.query(`ALTER TABLE "sessions" DROP CONSTRAINT "PK_9340188c93349808f10d1db74a8"`); - 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 "sessions" DROP COLUMN "last_seen_location"`); - await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "last_seen_ip"`); - await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "last_seen"`); - await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "created_at"`); - await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "is_admin_session"`); - await queryRunner.query(`ALTER TABLE "sessions" ADD "id" character varying NOT NULL`); - await queryRunner.query(`ALTER TABLE "sessions" ADD CONSTRAINT "PK_3238ef96f18b355b671619111bc" PRIMARY KEY ("id")`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "sessions" DROP CONSTRAINT "FK_085d540d9f418cfbdc7bd55bb19"`); + await queryRunner.query(`ALTER TABLE "webhooks" DROP CONSTRAINT "FK_4495b7032a33c6b8b605d030398"`); + await queryRunner.query(`DROP INDEX "public"."IDX_085d540d9f418cfbdc7bd55bb1"`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "user_id" DROP NOT NULL`); + await queryRunner.query(`ALTER TABLE "sessions" DROP CONSTRAINT "PK_9340188c93349808f10d1db74a8"`); + 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 "sessions" DROP COLUMN "last_seen_location"`); + await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "last_seen_ip"`); + await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "last_seen"`); + await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "created_at"`); + await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "is_admin_session"`); + await queryRunner.query(`ALTER TABLE "sessions" ADD "id" character varying NOT NULL`); + await queryRunner.query(`ALTER TABLE "sessions" ADD CONSTRAINT "PK_3238ef96f18b355b671619111bc" PRIMARY KEY ("id")`); + } } diff --git a/src/util/migration/postgres/1765932247127-UpdateSessionInfo.ts b/src/util/migration/postgres/1765932247127-UpdateSessionInfo.ts
index 3da3498a..fb8a7e56 100644 --- a/src/util/migration/postgres/1765932247127-UpdateSessionInfo.ts +++ b/src/util/migration/postgres/1765932247127-UpdateSessionInfo.ts
@@ -1,23 +1,23 @@ import { MigrationInterface, QueryRunner } from "typeorm"; export class UpdateSessionInfo1765932247127 implements MigrationInterface { - name = "UpdateSessionInfo1765932247127"; + name = "UpdateSessionInfo1765932247127"; - public async up(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "sessions" ADD "last_seen_location_info" text`); - await queryRunner.query(`ALTER TABLE "sessions" ADD "session_nickname" character varying`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen" DROP NOT NULL`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen" DROP DEFAULT`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen_ip" DROP NOT NULL`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen_ip" DROP DEFAULT`); - } + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "sessions" ADD "last_seen_location_info" text`); + await queryRunner.query(`ALTER TABLE "sessions" ADD "session_nickname" character varying`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen" DROP NOT NULL`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen" DROP DEFAULT`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen_ip" DROP NOT NULL`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen_ip" DROP DEFAULT`); + } - public async down(queryRunner: QueryRunner): Promise<void> { - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen_ip" SET DEFAULT '127.0.0.1'`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen_ip" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen" SET DEFAULT '1970-01-01 00:00:00'`); - await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen" SET NOT NULL`); - await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "session_nickname"`); - await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "last_seen_location_info"`); - } + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen_ip" SET DEFAULT '127.0.0.1'`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen_ip" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen" SET DEFAULT '1970-01-01 00:00:00'`); + await queryRunner.query(`ALTER TABLE "sessions" ALTER COLUMN "last_seen" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "session_nickname"`); + await queryRunner.query(`ALTER TABLE "sessions" DROP COLUMN "last_seen_location_info"`); + } }