summary refs log tree commit diff
path: root/util/src/migrations/1634308884591-Stickers.ts
diff options
context:
space:
mode:
Diffstat (limited to 'util/src/migrations/1634308884591-Stickers.ts')
-rw-r--r--util/src/migrations/1634308884591-Stickers.ts66
1 files changed, 0 insertions, 66 deletions
diff --git a/util/src/migrations/1634308884591-Stickers.ts b/util/src/migrations/1634308884591-Stickers.ts
deleted file mode 100644
index fbc4649f..00000000
--- a/util/src/migrations/1634308884591-Stickers.ts
+++ /dev/null
@@ -1,66 +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> {}
-}