diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/2020-08-07-threads.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/util/updates/2020-08-07-threads.sql b/util/updates/2020-08-07-threads.sql index d036ee81..ede9621b 100644 --- a/util/updates/2020-08-07-threads.sql +++ b/util/updates/2020-08-07-threads.sql @@ -34,10 +34,13 @@ ALTER TABLE threads ADD COLUMN c_lastnum smallint NOT NULL DEFAULT 1; -- 'num' o ALTER TABLE threads_posts ALTER COLUMN num DROP DEFAULT; ALTER TABLE threads_posts ALTER COLUMN uid DROP DEFAULT; +ALTER TABLE threads_posts ALTER COLUMN uid DROP NOT NULL; ALTER TABLE threads_posts ADD CONSTRAINT threads_posts_first_nonhidden CHECK(num > 1 OR NOT hidden); UPDATE threads SET c_count = (SELECT COUNT(*) FROM threads_posts WHERE NOT hidden AND tid = threads.id) , c_lastnum = (SELECT MAX(num) FROM threads_posts WHERE NOT hidden AND tid = threads.id); +UPDATE threads_posts SET uid = NULL WHERE uid = 0; + \i sql/triggers.sql |