summary refs log tree commit diff
diff options
context:
space:
mode:
authorMadeline <46743919+MaddyUnderStars@users.noreply.github.com>2022-12-17 17:25:31 +1100
committerMadeline <46743919+MaddyUnderStars@users.noreply.github.com>2022-12-17 17:25:31 +1100
commitd49acb55463103f1a01f248038fb6e4cd25c773d (patch)
tree1ae9fbebe040b4bd45806fbdfa78769bd813bd81
parentFirst pass of removing Slowcord mentions (diff)
downloadserver-d49acb55463103f1a01f248038fb6e4cd25c773d.tar.xz
murder migrations
-rw-r--r--src/util/migrations/1633864260873-EmojiRoles.ts17
-rw-r--r--src/util/migrations/1633864669243-EmojiUser.ts27
-rw-r--r--src/util/migrations/1633881705509-VanityInvite.ts25
-rw-r--r--src/util/migrations/1634308884591-Stickers.ts111
-rw-r--r--src/util/migrations/1634424361103-Presence.ts14
-rw-r--r--src/util/migrations/1634426540271-MigrationTimestamp.ts19
-rw-r--r--src/util/migrations/1648643945733-ReleaseTypo.ts16
-rw-r--r--src/util/migrations/1660678870706-opencordFixes.ts52
-rw-r--r--src/util/migrations/1660689892073-mobileFixes2.ts36
9 files changed, 0 insertions, 317 deletions
diff --git a/src/util/migrations/1633864260873-EmojiRoles.ts b/src/util/migrations/1633864260873-EmojiRoles.ts
deleted file mode 100644
index 31ced96b..00000000
--- a/src/util/migrations/1633864260873-EmojiRoles.ts
+++ /dev/null
@@ -1,17 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class EmojiRoles1633864260873 implements MigrationInterface {
-	name = "EmojiRoles1633864260873";
-
-	public async up(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.query(
-			`ALTER TABLE "emojis" ADD "roles" text NOT NULL DEFAULT ''`,
-		);
-	}
-
-	public async down(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.query(
-			`ALTER TABLE "emojis" DROP COLUMN column_name "roles"`,
-		);
-	}
-}
diff --git a/src/util/migrations/1633864669243-EmojiUser.ts b/src/util/migrations/1633864669243-EmojiUser.ts
deleted file mode 100644
index 9610216b..00000000
--- a/src/util/migrations/1633864669243-EmojiUser.ts
+++ /dev/null
@@ -1,27 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class EmojiUser1633864669243 implements MigrationInterface {
-	name = "EmojiUser1633864669243";
-
-	public async up(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.query(`ALTER TABLE "emojis" ADD "user_id" varchar`);
-		try {
-			await queryRunner.query(
-				`ALTER TABLE "emojis" ADD CONSTRAINT FK_fa7ddd5f9a214e28ce596548421 FOREIGN KEY (user_id) REFERENCES users(id)`,
-			);
-		} catch (error) {
-			console.error(
-				"sqlite doesn't support altering foreign keys: https://stackoverflow.com/questions/1884818/how-do-i-add-a-foreign-key-to-an-existing-sqlite-table",
-			);
-		}
-	}
-
-	public async down(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.query(
-			`ALTER TABLE "emojis" DROP COLUMN column_name "user_id"`,
-		);
-		await queryRunner.query(
-			`ALTER TABLE "emojis" DROP CONSTRAINT FK_fa7ddd5f9a214e28ce596548421`,
-		);
-	}
-}
diff --git a/src/util/migrations/1633881705509-VanityInvite.ts b/src/util/migrations/1633881705509-VanityInvite.ts
deleted file mode 100644
index 16072473..00000000
--- a/src/util/migrations/1633881705509-VanityInvite.ts
+++ /dev/null
@@ -1,25 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class VanityInvite1633881705509 implements MigrationInterface {
-	name = "VanityInvite1633881705509";
-
-	public async up(queryRunner: QueryRunner): Promise<void> {
-		try {
-			await queryRunner.query(
-				`ALTER TABLE "emojis" DROP COLUMN vanity_url_code`,
-			);
-			await queryRunner.query(
-				`ALTER TABLE "emojis" DROP CONSTRAINT FK_c2c1809d79eb120ea0cb8d342ad`,
-			);
-		} catch (error) {}
-	}
-
-	public async down(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.query(
-			`ALTER TABLE "emojis" ADD vanity_url_code varchar`,
-		);
-		await queryRunner.query(
-			`ALTER TABLE "emojis" ADD CONSTRAINT FK_c2c1809d79eb120ea0cb8d342ad FOREIGN KEY ("vanity_url_code") REFERENCES "invites"("code") ON DELETE NO ACTION ON UPDATE NO ACTION`,
-		);
-	}
-}
diff --git a/src/util/migrations/1634308884591-Stickers.ts b/src/util/migrations/1634308884591-Stickers.ts
deleted file mode 100644
index f7b83242..00000000
--- a/src/util/migrations/1634308884591-Stickers.ts
+++ /dev/null
@@ -1,111 +0,0 @@
-import {
-	MigrationInterface,
-	QueryRunner,
-	Table,
-	TableColumn,
-	TableForeignKey,
-} from "typeorm";
-
-export class Stickers1634308884591 implements MigrationInterface {
-	name = "Stickers1634308884591";
-
-	public async up(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.dropForeignKey(
-			"read_states",
-			"FK_6f255d873cfbfd7a93849b7ff74",
-		);
-		await queryRunner.changeColumn(
-			"stickers",
-			"tags",
-			new TableColumn({
-				name: "tags",
-				type: "varchar",
-				isNullable: true,
-			}),
-		);
-		await queryRunner.changeColumn(
-			"stickers",
-			"pack_id",
-			new TableColumn({
-				name: "pack_id",
-				type: "varchar",
-				isNullable: true,
-			}),
-		);
-		await queryRunner.changeColumn(
-			"stickers",
-			"type",
-			new TableColumn({ name: "type", type: "integer" }),
-		);
-		await queryRunner.changeColumn(
-			"stickers",
-			"format_type",
-			new TableColumn({ name: "format_type", type: "integer" }),
-		);
-		await queryRunner.changeColumn(
-			"stickers",
-			"available",
-			new TableColumn({
-				name: "available",
-				type: "boolean",
-				isNullable: true,
-			}),
-		);
-		await queryRunner.changeColumn(
-			"stickers",
-			"user_id",
-			new TableColumn({
-				name: "user_id",
-				type: "boolean",
-				isNullable: true,
-			}),
-		);
-		await queryRunner.createForeignKey(
-			"stickers",
-			new TableForeignKey({
-				name: "FK_8f4ee73f2bb2325ff980502e158",
-				columnNames: ["user_id"],
-				referencedColumnNames: ["id"],
-				referencedTableName: "users",
-				onDelete: "CASCADE",
-			}),
-		);
-		await queryRunner.createTable(
-			new Table({
-				name: "sticker_packs",
-				columns: [
-					new TableColumn({
-						name: "id",
-						type: "varchar",
-						isPrimary: true,
-					}),
-					new TableColumn({ name: "name", type: "varchar" }),
-					new TableColumn({
-						name: "description",
-						type: "varchar",
-						isNullable: true,
-					}),
-					new TableColumn({
-						name: "banner_asset_id",
-						type: "varchar",
-						isNullable: true,
-					}),
-					new TableColumn({
-						name: "cover_sticker_id",
-						type: "varchar",
-						isNullable: true,
-					}),
-				],
-				foreignKeys: [
-					new TableForeignKey({
-						columnNames: ["cover_sticker_id"],
-						referencedColumnNames: ["id"],
-						referencedTableName: "stickers",
-					}),
-				],
-			}),
-		);
-	}
-
-	public async down(queryRunner: QueryRunner): Promise<void> {}
-}
diff --git a/src/util/migrations/1634424361103-Presence.ts b/src/util/migrations/1634424361103-Presence.ts
deleted file mode 100644
index a71cb253..00000000
--- a/src/util/migrations/1634424361103-Presence.ts
+++ /dev/null
@@ -1,14 +0,0 @@
-import { MigrationInterface, QueryRunner, TableColumn } from "typeorm";
-
-export class Presence1634424361103 implements MigrationInterface {
-	name = "Presence1634424361103";
-
-	public async up(queryRunner: QueryRunner): Promise<void> {
-		queryRunner.addColumn(
-			"sessions",
-			new TableColumn({ name: "activites", type: "text" }),
-		);
-	}
-
-	public async down(queryRunner: QueryRunner): Promise<void> {}
-}
diff --git a/src/util/migrations/1634426540271-MigrationTimestamp.ts b/src/util/migrations/1634426540271-MigrationTimestamp.ts
deleted file mode 100644
index fb596906..00000000
--- a/src/util/migrations/1634426540271-MigrationTimestamp.ts
+++ /dev/null
@@ -1,19 +0,0 @@
-import { MigrationInterface, QueryRunner, TableColumn } from "typeorm";
-
-export class MigrationTimestamp1634426540271 implements MigrationInterface {
-	name = "MigrationTimestamp1634426540271";
-
-	public async up(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.changeColumn(
-			"migrations",
-			"timestamp",
-			new TableColumn({
-				name: "timestampe",
-				type: "bigint",
-				isNullable: false,
-			}),
-		);
-	}
-
-	public async down(queryRunner: QueryRunner): Promise<void> {}
-}
diff --git a/src/util/migrations/1648643945733-ReleaseTypo.ts b/src/util/migrations/1648643945733-ReleaseTypo.ts
deleted file mode 100644
index 944b9dd9..00000000
--- a/src/util/migrations/1648643945733-ReleaseTypo.ts
+++ /dev/null
@@ -1,16 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class ReleaseTypo1648643945733 implements MigrationInterface {
-	name = "ReleaseTypo1648643945733";
-
-	public async up(queryRunner: QueryRunner): Promise<void> {
-		//drop table first because typeorm creates it before migrations run
-		await queryRunner.dropTable("client_release", true);
-		await queryRunner.renameTable("client_relase", "client_release");
-	}
-
-	public async down(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.dropTable("client_relase", true);
-		await queryRunner.renameTable("client_release", "client_relase");
-	}
-}
diff --git a/src/util/migrations/1660678870706-opencordFixes.ts b/src/util/migrations/1660678870706-opencordFixes.ts
deleted file mode 100644
index 53c561ce..00000000
--- a/src/util/migrations/1660678870706-opencordFixes.ts
+++ /dev/null
@@ -1,52 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class opencordFixes1660678870706 implements MigrationInterface {
-	name = "opencordFixes1660678870706";
-
-	public async up(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.query(`
-            ALTER TABLE \`users\`
-            ADD \`purchased_flags\` int NOT NULL
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`users\`
-            ADD \`premium_usage_flags\` int NOT NULL
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`user_settings\`
-            ADD \`friend_discovery_flags\` int NOT NULL
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`user_settings\`
-            ADD \`view_nsfw_guilds\` tinyint NOT NULL
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`user_settings\`
-            ADD \`passwordless\` tinyint NOT NULL
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`users\` CHANGE \`mfa_enabled\` \`mfa_enabled\` tinyint NOT NULL
-        `);
-	}
-
-	public async down(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.query(`
-            ALTER TABLE \`users\` CHANGE \`mfa_enabled\` \`mfa_enabled\` tinyint NULL
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`user_settings\` DROP COLUMN \`passwordless\`
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`user_settings\` DROP COLUMN \`view_nsfw_guilds\`
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`user_settings\` DROP COLUMN \`friend_discovery_flags\`
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`users\` DROP COLUMN \`premium_usage_flags\`
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`users\` DROP COLUMN \`purchased_flags\`
-        `);
-	}
-}
diff --git a/src/util/migrations/1660689892073-mobileFixes2.ts b/src/util/migrations/1660689892073-mobileFixes2.ts
deleted file mode 100644
index 63e7e032..00000000
--- a/src/util/migrations/1660689892073-mobileFixes2.ts
+++ /dev/null
@@ -1,36 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class mobileFixes21660689892073 implements MigrationInterface {
-	name = "mobileFixes21660689892073";
-
-	public async up(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.query(`
-            ALTER TABLE \`user_settings\`
-            ADD \`banner_color\` varchar(255) NULL
-        `);
-		await queryRunner.query(`
-			UPDATE \`channels\` SET \`nsfw\` = 0 WHERE \`nsfw\` = NULL
-		`);
-		await queryRunner.query(`
-            ALTER TABLE \`channels\` CHANGE \`nsfw\` \`nsfw\` tinyint NOT NULL
-        `);
-		await queryRunner.query(`
-			UPDATE \`guilds\` SET \`nsfw\` = 0 WHERE \`nsfw\` = NULL
-		`);
-		await queryRunner.query(`
-            ALTER TABLE \`guilds\` CHANGE \`nsfw\` \`nsfw\` tinyint NOT NULL
-        `);
-	}
-
-	public async down(queryRunner: QueryRunner): Promise<void> {
-		await queryRunner.query(`
-            ALTER TABLE \`guilds\` CHANGE \`nsfw\` \`nsfw\` tinyint NULL
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`channels\` CHANGE \`nsfw\` \`nsfw\` tinyint NULL
-        `);
-		await queryRunner.query(`
-            ALTER TABLE \`user_settings\` DROP COLUMN \`banner_color\`
-        `);
-	}
-}