diff options
author | Yorhel <git@yorhel.nl> | 2022-03-17 11:09:36 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-04-01 06:50:11 +0200 |
commit | c6a60fc12a7540ca1b4c8fb39dc62c16e7c05af5 (patch) | |
tree | 74fabfa02f62424105569af3010c1d9957d73660 /sql | |
parent | e5ee22d027c0b303f961ef3de5f0800a2170da7d (diff) |
Add user traits 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 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); |