diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2024-11-17 09:32:13 -0500 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2024-11-20 22:03:17 -0500 |
| commit | cc394d9a4bd560097ddfa7c4d11f7abe9a993fa8 (patch) | |
| tree | 73005ae835269a56ae96d66e71b93740697eb909 | |
| parent | remove duplicate `isPureRenote` method (diff) | |
| download | sharkey-cc394d9a4bd560097ddfa7c4d11f7abe9a993fa8.tar.gz sharkey-cc394d9a4bd560097ddfa7c4d11f7abe9a993fa8.tar.bz2 sharkey-cc394d9a4bd560097ddfa7c4d11f7abe9a993fa8.zip | |
quote all symbols in hellspawn upgrade script
| -rw-r--r-- | UPGRADE_NOTES.md | 12 |
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" = '{}'; |