diff options
| author | Yorhel <git@yorhel.nl> | 2020-08-17 13:42:37 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2020-08-17 13:42:52 +0200 |
| commit | cd78958d7eaded3c3d9969153335b982e21a21f6 (patch) | |
| tree | 4c711741133c2eec76f1c62005cd5e419e61cb84 /util | |
| parent | 34b93633eda046680c28bc1fb619d995c5acca14 (diff) | |
reviews: Make reviews mod-only for now to allow some beta testing
It's totally not finished yet, but it's useful to gather some feedback
before I start with integration with the rest of the site.
Diffstat (limited to 'util')
| -rw-r--r-- | util/updates/2020-08-17-reviews.sql (renamed from util/updates/wip-reviews.sql) | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/util/updates/wip-reviews.sql b/util/updates/2020-08-17-reviews.sql index 677eb7b6..87ded565 100644 --- a/util/updates/wip-reviews.sql +++ b/util/updates/2020-08-17-reviews.sql @@ -5,7 +5,6 @@ ALTER TABLE reports DROP COLUMN rtype; DROP TYPE report_type; --- WIP: The modifications in this file are not final and haven't been integrated in sql/ yet. CREATE SEQUENCE reviews_seq; @@ -51,8 +50,8 @@ ALTER TABLE reviews_posts ADD CONSTRAINT reviews_posts_uid_fkey FOREIGN KEY (uid ALTER TABLE reviews_votes ADD CONSTRAINT reviews_votes_id_fkey FOREIGN KEY (id) REFERENCES reviews (id) ON DELETE CASCADE; ALTER TABLE reviews_votes ADD CONSTRAINT reviews_votes_uid_fkey FOREIGN KEY (uid) REFERENCES users (id) ON DELETE CASCADE; -ALTER TABLE users ADD COLUMN perm_review boolean NOT NULL DEFAULT true; -UPDATE users SET perm_review = false WHERE not perm_board; +ALTER TABLE users ADD COLUMN perm_review boolean NOT NULL DEFAULT false; +UPDATE users SET perm_review = false WHERE not perm_dbmod; \i sql/perms.sql |