1 -- Add a table to count diary votes.
3 CREATE TABLE diarynotes_votes (
4 diary_id integer NOT NULL,
5 user_id integer NOT NULL,
6 CONSTRAINT diarynotes_votes_fk_did
7 FOREIGN KEY (diary_id) REFERENCES user_diary (id) ON DELETE CASCADE,
8 CONSTRAINT diarynotes_votes_fk_uid
9 FOREIGN KEY (user_id) REFERENCES users (user_id),
10 CONSTRAINT diarynotes_votes_pk
11 PRIMARY KEY (diary_id, user_id)
14 -- Add a table to count project votes.
16 CREATE TABLE groups_votes (
17 group_id integer NOT NULL,
18 user_id integer NOT NULL,
19 CONSTRAINT groups_votes_fk_gid
20 FOREIGN KEY (group_id) REFERENCES groups (group_id) ON DELETE CASCADE,
21 CONSTRAINT groups_votes_fk_uid
22 FOREIGN KEY (user_id) REFERENCES users (user_id),
23 CONSTRAINT groups_votes_pk
24 PRIMARY KEY (group_id, user_id)
27 -- Add a table to count frs release votes.
29 CREATE TABLE frsrelease_votes (
30 release_id integer NOT NULL,
31 user_id integer NOT NULL,
32 CONSTRAINT frsrelease_votes_fk_fid
33 FOREIGN KEY (release_id) REFERENCES frs_release (release_id) ON DELETE CASCADE,
34 CONSTRAINT frsrelease_votes_fk_uid
35 FOREIGN KEY (user_id) REFERENCES users (user_id),
36 CONSTRAINT frsrelease_votes_pk
37 PRIMARY KEY (release_id, user_id)