From c7767e5fa4f392cb06502fd928a977b10e404918 Mon Sep 17 00:00:00 2001
From: Madeline <46743919+MaddyUnderStars@users.noreply.github.com>
Date: Sun, 21 Aug 2022 20:00:35 +1000
Subject: Fix /users/@me/settings get and migrarion

---
 util/src/migrations/1660689892073-mobileFixes2.ts | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'util/src/migrations')

diff --git a/util/src/migrations/1660689892073-mobileFixes2.ts b/util/src/migrations/1660689892073-mobileFixes2.ts
index 34328966..bd28694e 100644
--- a/util/src/migrations/1660689892073-mobileFixes2.ts
+++ b/util/src/migrations/1660689892073-mobileFixes2.ts
@@ -8,9 +8,15 @@ export class mobileFixes21660689892073 implements MigrationInterface {
             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
         `);
-- 
cgit 1.5.1