diff options
Diffstat (limited to 'util/updates/2020-08-19-reviews-caches.sql')
-rw-r--r-- | util/updates/2020-08-19-reviews-caches.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/util/updates/2020-08-19-reviews-caches.sql b/util/updates/2020-08-19-reviews-caches.sql new file mode 100644 index 00000000..9c37808d --- /dev/null +++ b/util/updates/2020-08-19-reviews-caches.sql @@ -0,0 +1,14 @@ +CREATE UNIQUE INDEX reviews_posts_uid ON reviews_posts (uid); + +ALTER TABLE reviews ADD COLUMN c_up int NOT NULL DEFAULT 0; +ALTER TABLE reviews ADD COLUMN c_down int NOT NULL DEFAULT 0; +ALTER TABLE reviews ADD COLUMN c_count smallint NOT NULL DEFAULT 0; +ALTER TABLE reviews ADD COLUMN c_lastnum smallint; + +\i sql/func.sql +\i sql/triggers.sql + +SELECT update_reviews_votes_cache(NULL); +UPDATE reviews + SET c_count = COALESCE((SELECT COUNT(*) FROM reviews_posts WHERE NOT hidden AND id = reviews.id), 0) + , c_lastnum = (SELECT MAX(num) FROM reviews_posts WHERE NOT hidden AND id = reviews.id); |