diff options
author | Yorhel <git@yorhel.nl> | 2022-06-20 10:39:15 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-06-20 10:39:15 +0200 |
commit | 06d92426933e363fb0fb023d502821dc214d16a9 (patch) | |
tree | 0e69d84180ae1f56f1fbdd9a4233e77436d4ad5d /sql | |
parent | 43ef1a26d68f2b5dbc8b5ac3cc30e27b7bf89ca3 (diff) |
Add changes patrolling mod feature
Diffstat (limited to 'sql')
-rw-r--r-- | sql/perms.sql | 1 | ||||
-rw-r--r-- | sql/schema.sql | 7 | ||||
-rw-r--r-- | sql/tableattrs.sql | 2 |
3 files changed, 10 insertions, 0 deletions
diff --git a/sql/perms.sql b/sql/perms.sql index fc5c628b..ed76fabf 100644 --- a/sql/perms.sql +++ b/sql/perms.sql @@ -8,6 +8,7 @@ GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO vndb_site; GRANT SELECT, INSERT ON anime TO vndb_site; GRANT INSERT ON audit_log TO vndb_site; GRANT SELECT, INSERT ON changes TO vndb_site; +GRANT SELECT, INSERT ON changes_patrolled TO vndb_site; GRANT SELECT, INSERT, UPDATE ON chars TO vndb_site; GRANT SELECT, INSERT ON chars_hist TO vndb_site; GRANT SELECT, INSERT, DELETE ON chars_traits TO vndb_site; diff --git a/sql/schema.sql b/sql/schema.sql index 40b35603..817e70b6 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -144,6 +144,13 @@ CREATE TABLE changes ( comments text NOT NULL DEFAULT '' ); +-- changes_patrolled +CREATE TABLE changes_patrolled ( + id integer NOT NULL, + uid vndbid NOT NULL, + PRIMARY KEY(id,uid) +); + -- chars CREATE TABLE chars ( -- dbentry_type=c id vndbid NOT NULL PRIMARY KEY DEFAULT vndbid('c', nextval('chars_id_seq')::int) CONSTRAINT chars_id_check CHECK(vndbid_type(id) = 'c'), -- [pub] diff --git a/sql/tableattrs.sql b/sql/tableattrs.sql index a0c43e3d..f4220808 100644 --- a/sql/tableattrs.sql +++ b/sql/tableattrs.sql @@ -49,6 +49,8 @@ CREATE INDEX users_ign_votes ON users (id) WHERE ign_votes; -- Constraints ALTER TABLE changes ADD CONSTRAINT changes_requester_fkey FOREIGN KEY (requester) REFERENCES users (id) ON DELETE SET DEFAULT; +ALTER TABLE changes_patrolled ADD CONSTRAINT changes_patrolled_id_fkey FOREIGN KEY (id) REFERENCES changes (id) ON DELETE CASCADE; +ALTER TABLE changes_patrolled ADD CONSTRAINT changes_patrolled_uid_fkey FOREIGN KEY (uid) REFERENCES users (id) ON DELETE CASCADE; ALTER TABLE chars ADD CONSTRAINT chars_main_fkey FOREIGN KEY (main) REFERENCES chars (id); ALTER TABLE chars ADD CONSTRAINT chars_image_fkey FOREIGN KEY (image) REFERENCES images (id); ALTER TABLE chars_hist ADD CONSTRAINT chars_hist_chid_fkey FOREIGN KEY (chid) REFERENCES changes (id) ON DELETE CASCADE; |