summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-06-20 10:39:15 +0200
committerYorhel <git@yorhel.nl>2022-06-20 10:39:15 +0200
commit06d92426933e363fb0fb023d502821dc214d16a9 (patch)
tree0e69d84180ae1f56f1fbdd9a4233e77436d4ad5d /sql
parent43ef1a26d68f2b5dbc8b5ac3cc30e27b7bf89ca3 (diff)
Add changes patrolling mod feature
Diffstat (limited to 'sql')
-rw-r--r--sql/perms.sql1
-rw-r--r--sql/schema.sql7
-rw-r--r--sql/tableattrs.sql2
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;