summaryrefslogtreecommitdiff
path: root/UPGRADE_NOTES.md
diff options
context:
space:
mode:
Diffstat (limited to 'UPGRADE_NOTES.md')
-rw-r--r--UPGRADE_NOTES.md12
1 files changed, 6 insertions, 6 deletions
diff --git a/UPGRADE_NOTES.md b/UPGRADE_NOTES.md
index fb81a611b7..c941de6643 100644
--- a/UPGRADE_NOTES.md
+++ b/UPGRADE_NOTES.md
@@ -11,23 +11,23 @@ The following script will correct any local or remote hellspawns in the database
```postgresql
/* Remove "instance is marked as NSFW" hellspawns */
-UPDATE note
-SET cw = null
+UPDATE "note"
+SET "cw" = null
WHERE
"renoteId" IS NOT NULL
AND "text" IS NULL
- AND cw = 'Instance is marked as NSFW'
+ AND "cw" = 'Instance is marked as NSFW'
AND "replyId" IS NULL
AND "hasPoll" = false
AND "fileIds" = '{}';
/* Fix legacy / user-created hellspawns */
-UPDATE note
-SET text = '.'
+UPDATE "note"
+SET "text" = '.'
WHERE
"renoteId" IS NOT NULL
AND "text" IS NULL
- AND cw IS NOT NULL
+ AND "cw" IS NOT NULL
AND "replyId" IS NULL
AND "hasPoll" = false
AND "fileIds" = '{}';