From 5e629decfc5aaa58fb5c584fa15e76fd5b44c23f Mon Sep 17 00:00:00 2001
From: TheArcaneBrony <myrainbowdash949@gmail.com>
Date: Sat, 13 Aug 2022 20:43:35 +0200
Subject: Do the funny thing (make user->invite cascade delet)

---
 .../mariadb/1660265930624-CodeCleanup5.ts          | 53 --------------------
 .../mariadb/1660416072362-InvitersAreDeletable.ts  | 56 ++++++++++++++++++++++
 2 files changed, 56 insertions(+), 53 deletions(-)
 delete mode 100644 src/util/migrations/mariadb/1660265930624-CodeCleanup5.ts
 create mode 100644 src/util/migrations/mariadb/1660416072362-InvitersAreDeletable.ts

(limited to 'src/util/migrations/mariadb')

diff --git a/src/util/migrations/mariadb/1660265930624-CodeCleanup5.ts b/src/util/migrations/mariadb/1660265930624-CodeCleanup5.ts
deleted file mode 100644
index 04f8e6af..00000000
--- a/src/util/migrations/mariadb/1660265930624-CodeCleanup5.ts
+++ /dev/null
@@ -1,53 +0,0 @@
-import { MigrationInterface, QueryRunner } from "typeorm";
-
-export class CodeCleanup51660265930624 implements MigrationInterface {
-    name = 'CodeCleanup51660265930624'
-
-    public async up(queryRunner: QueryRunner): Promise<void> {
-        await queryRunner.query(`
-            ALTER TABLE \`users\`
-            ADD \`settingsId\` varchar(255) NULL
-        `);
-        await queryRunner.query(`
-            ALTER TABLE \`users\`
-            ADD UNIQUE INDEX \`IDX_76ba283779c8441fd5ff819c8c\` (\`settingsId\`)
-        `);
-        await queryRunner.query(`
-            ALTER TABLE \`channels\`
-            ADD \`flags\` int NULL
-        `);
-        await queryRunner.query(`
-            ALTER TABLE \`channels\`
-            ADD \`default_thread_rate_limit_per_user\` int NULL
-        `);
-        await queryRunner.query(`
-            CREATE UNIQUE INDEX \`REL_76ba283779c8441fd5ff819c8c\` ON \`users\` (\`settingsId\`)
-        `);
-        await queryRunner.query(`
-            ALTER TABLE \`users\`
-            ADD CONSTRAINT \`FK_76ba283779c8441fd5ff819c8cf\` FOREIGN KEY (\`settingsId\`) REFERENCES \`user_settings\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
-        `);
-    }
-
-    public async down(queryRunner: QueryRunner): Promise<void> {
-        await queryRunner.query(`
-            ALTER TABLE \`users\` DROP FOREIGN KEY \`FK_76ba283779c8441fd5ff819c8cf\`
-        `);
-        await queryRunner.query(`
-            DROP INDEX \`REL_76ba283779c8441fd5ff819c8c\` ON \`users\`
-        `);
-        await queryRunner.query(`
-            ALTER TABLE \`channels\` DROP COLUMN \`default_thread_rate_limit_per_user\`
-        `);
-        await queryRunner.query(`
-            ALTER TABLE \`channels\` DROP COLUMN \`flags\`
-        `);
-        await queryRunner.query(`
-            ALTER TABLE \`users\` DROP INDEX \`IDX_76ba283779c8441fd5ff819c8c\`
-        `);
-        await queryRunner.query(`
-            ALTER TABLE \`users\` DROP COLUMN \`settingsId\`
-        `);
-    }
-
-}
diff --git a/src/util/migrations/mariadb/1660416072362-InvitersAreDeletable.ts b/src/util/migrations/mariadb/1660416072362-InvitersAreDeletable.ts
new file mode 100644
index 00000000..8374eafb
--- /dev/null
+++ b/src/util/migrations/mariadb/1660416072362-InvitersAreDeletable.ts
@@ -0,0 +1,56 @@
+import { MigrationInterface, QueryRunner } from "typeorm";
+
+export class InvitersAreDeletable1660416072362 implements MigrationInterface {
+    name = 'InvitersAreDeletable1660416072362'
+
+    public async up(queryRunner: QueryRunner): Promise<void> {
+        await queryRunner.query(`
+            ALTER TABLE \`invites\` DROP FOREIGN KEY \`FK_15c35422032e0b22b4ada95f48f\`
+        `);
+        await queryRunner.query(`
+            DROP INDEX \`IDX_76ba283779c8441fd5ff819c8c\` ON \`users\`
+        `);
+        await queryRunner.query(`
+            CREATE TABLE \`plugin_config\` (
+                \`key\` varchar(255) NOT NULL,
+                \`value\` text NULL,
+                PRIMARY KEY (\`key\`)
+            ) ENGINE = InnoDB
+        `);
+        await queryRunner.query(`
+            ALTER TABLE \`channels\`
+            ADD \`flags\` int NULL
+        `);
+        await queryRunner.query(`
+            ALTER TABLE \`channels\`
+            ADD \`default_thread_rate_limit_per_user\` int NULL
+        `);
+        await queryRunner.query(`
+            ALTER TABLE \`invites\`
+            ADD CONSTRAINT \`FK_15c35422032e0b22b4ada95f48f\` FOREIGN KEY (\`inviter_id\`) REFERENCES \`users\`(\`id\`) ON DELETE CASCADE ON UPDATE NO ACTION
+        `);
+    }
+
+    public async down(queryRunner: QueryRunner): Promise<void> {
+        await queryRunner.query(`
+            ALTER TABLE \`invites\` DROP FOREIGN KEY \`FK_15c35422032e0b22b4ada95f48f\`
+        `);
+        await queryRunner.query(`
+            ALTER TABLE \`channels\` DROP COLUMN \`default_thread_rate_limit_per_user\`
+        `);
+        await queryRunner.query(`
+            ALTER TABLE \`channels\` DROP COLUMN \`flags\`
+        `);
+        await queryRunner.query(`
+            DROP TABLE \`plugin_config\`
+        `);
+        await queryRunner.query(`
+            CREATE UNIQUE INDEX \`IDX_76ba283779c8441fd5ff819c8c\` ON \`users\` (\`settingsId\`)
+        `);
+        await queryRunner.query(`
+            ALTER TABLE \`invites\`
+            ADD CONSTRAINT \`FK_15c35422032e0b22b4ada95f48f\` FOREIGN KEY (\`inviter_id\`) REFERENCES \`users\`(\`id\`) ON DELETE NO ACTION ON UPDATE NO ACTION
+        `);
+    }
+
+}
-- 
cgit 1.5.1