blob: c5ee731234d2287d5cb7c9cb108eca550275608e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
CREATE TABLE users_prefs_tags (
id vndbid NOT NULL,
tid vndbid NOT NULL,
spoil smallint NOT NULL,
childs boolean NOT NULL,
PRIMARY KEY(id, tid)
);
ALTER TABLE users_prefs_tags ADD CONSTRAINT users_prefs_tags_id_fkey FOREIGN KEY (id) REFERENCES users (id) ON DELETE CASCADE;
ALTER TABLE users_prefs_tags ADD CONSTRAINT users_prefs_tags_tid_fkey FOREIGN KEY (tid) REFERENCES tags (id) ON DELETE CASCADE;
\i sql/perms.sql
|