summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-03-17 11:09:36 +0100
committerYorhel <git@yorhel.nl>2022-04-01 06:50:11 +0200
commitc6a60fc12a7540ca1b4c8fb39dc62c16e7c05af5 (patch)
tree74fabfa02f62424105569af3010c1d9957d73660 /sql
parente5ee22d027c0b303f961ef3de5f0800a2170da7d (diff)
Add user traits 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 d01023f5..93c1611e 100644
--- a/sql/perms.sql
+++ b/sql/perms.sql
@@ -79,6 +79,7 @@ GRANT SELECT, INSERT, UPDATE, DELETE ON ulist_vns_labels TO vndb_site;
GRANT SELECT, INSERT, UPDATE ON users TO vndb_site;
GRANT SELECT (id, perm_usermod), INSERT (id, mail) ON users_shadow TO vndb_site;
GRANT SELECT, INSERT ON users_username_hist TO vndb_site;
+GRANT SELECT, INSERT, UPDATE, DELETE ON users_traits TO vndb_site;
GRANT SELECT, INSERT, UPDATE ON vn TO vndb_site;
GRANT SELECT, INSERT, DELETE ON vn_anime TO vndb_site;
GRANT SELECT, INSERT ON vn_anime_hist TO vndb_site;
diff --git a/sql/schema.sql b/sql/schema.sql
index 7d1a4792..2e6e851a 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -1071,6 +1071,13 @@ CREATE TABLE users_shadow (
passwd bytea NOT NULL DEFAULT ''
);
+-- users_traits
+CREATE TABLE users_traits (
+ id vndbid NOT NULL,
+ tid vndbid NOT NULL,
+ PRIMARY KEY(id, tid)
+);
+
-- users_username_hist
CREATE TABLE users_username_hist (
id vndbid NOT NULL,
diff --git a/sql/tableattrs.sql b/sql/tableattrs.sql
index 83a12264..b33b029e 100644
--- a/sql/tableattrs.sql
+++ b/sql/tableattrs.sql
@@ -135,6 +135,8 @@ ALTER TABLE ulist_vns_labels ADD CONSTRAINT ulist_vns_labels_vid_fkey
ALTER TABLE ulist_vns_labels ADD CONSTRAINT ulist_vns_labels_uid_lbl_fkey FOREIGN KEY (uid,lbl) REFERENCES ulist_labels (uid,id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE ulist_vns_labels ADD CONSTRAINT ulist_vns_labels_uid_vid_fkey FOREIGN KEY (uid,vid) REFERENCES ulist_vns (uid,vid) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE users_shadow ADD CONSTRAINT users_shadow_id_fkey FOREIGN KEY (id) REFERENCES users (id) ON DELETE CASCADE;
+ALTER TABLE users_traits ADD CONSTRAINT users_traits_id_fkey FOREIGN KEY (id) REFERENCES users (id) ON DELETE CASCADE;
+ALTER TABLE users_traits ADD CONSTRAINT users_traits_tid_fkey FOREIGN KEY (tid) REFERENCES traits (id);
ALTER TABLE users_username_hist ADD CONSTRAINT users_username_hist_id_fkey FOREIGN KEY (id) REFERENCES users (id) ON DELETE CASCADE;
ALTER TABLE vn ADD CONSTRAINT vn_image_fkey FOREIGN KEY (image) REFERENCES images (id);
ALTER TABLE vn ADD CONSTRAINT vn_l_wikidata_fkey FOREIGN KEY (l_wikidata)REFERENCES wikidata (id);