1 ALTER TABLE artifact_group_list ADD CONSTRAINT artifactgroup_groupid_fk
2 FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL;
4 ALTER TABLE artifact_perm ADD CONSTRAINT artifactperm_userid_fk
5 FOREIGN KEY (user_id) REFERENCES users(user_id) MATCH FULL;
6 DELETE from artifact_perm
7 where not exists (select group_artifact_id
8 from artifact_group_list
9 where artifact_perm.group_artifact_id=artifact_group_list.group_artifact_id);
10 ALTER TABLE artifact_perm ADD CONSTRAINT artifactperm_groupartifactid_fk
11 FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) MATCH FULL;
13 ALTER TABLE artifact_category ADD CONSTRAINT artifactcategory_groupartifactid_fk
14 FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) MATCH FULL;
15 ALTER TABLE artifact_category ADD CONSTRAINT artifactcategory_autoassignto_fk
16 FOREIGN KEY (auto_assign_to) REFERENCES users(user_id) MATCH FULL;
18 ALTER TABLE artifact_group ADD CONSTRAINT artifactgroup_groupartifactid_fk
19 FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) MATCH FULL;
21 ALTER TABLE artifact ADD CONSTRAINT artifact_groupartifactid_fk
22 FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) MATCH FULL;
23 ALTER TABLE artifact ADD CONSTRAINT artifact_statusid_fk
24 FOREIGN KEY (status_id) REFERENCES artifact_status(id) MATCH FULL;
25 ALTER TABLE artifact ADD CONSTRAINT artifact_categoryid_fk
26 FOREIGN KEY (category_id) REFERENCES artifact_category(id) MATCH FULL;
27 ALTER TABLE artifact ADD CONSTRAINT artifact_artifactgroupid_fk
28 FOREIGN KEY (artifact_group_id) REFERENCES artifact_group(id) MATCH FULL;
29 ALTER TABLE artifact ADD CONSTRAINT artifact_submittedby_fk
30 FOREIGN KEY (submitted_by) REFERENCES users(user_id) MATCH FULL;
31 ALTER TABLE artifact ADD CONSTRAINT artifact_assignedto_fk
32 FOREIGN KEY (assigned_to) REFERENCES users(user_id) MATCH FULL;
33 ALTER TABLE artifact ADD CONSTRAINT artifact_resolutionid_fk
34 FOREIGN KEY (resolution_id) REFERENCES artifact_resolution(id) MATCH FULL;
36 DELETE FROM artifact_history WHERE NOT EXISTS
37 (SELECT artifact_id FROM artifact WHERE artifact.artifact_id=artifact_history.artifact_id);
38 ALTER TABLE artifact_history ADD CONSTRAINT artifacthistory_artifactid_fk
39 FOREIGN KEY (artifact_id) REFERENCES artifact(artifact_id) MATCH FULL;
40 ALTER TABLE artifact_history ADD CONSTRAINT artifacthistory_modby_fk
41 FOREIGN KEY (mod_by) REFERENCES users(user_id) MATCH FULL;
43 ALTER TABLE artifact_file ADD CONSTRAINT artifactfile_artifactid_fk
44 FOREIGN KEY (artifact_id) REFERENCES artifact(artifact_id) MATCH FULL;
45 ALTER TABLE artifact_file ADD CONSTRAINT artifactfile_submittedby_fk
46 FOREIGN KEY (submitted_by) REFERENCES users(user_id) MATCH FULL;
48 ALTER TABLE artifact_message ADD CONSTRAINT artifactmessage_artifactid_fk
49 FOREIGN KEY (artifact_id) REFERENCES artifact(artifact_id) MATCH FULL;
50 ALTER TABLE artifact_message ADD CONSTRAINT artifactmessage_submittedby_fk
51 FOREIGN KEY (submitted_by) REFERENCES users(user_id) MATCH FULL;
53 SELECT setval('artifact_group_list_group_artifact_id_seq',(SELECT max(group_artifact_id) FROM artifact_group_list));
54 --SELECT setval('artifact_perm_id_seq',(SELECT max(id) FROM artifact_perm));
55 SELECT setval('artifact_category_id_seq',(SELECT max(id) FROM artifact_category));
56 SELECT setval('artifact_group_id_seq',(SELECT max(id) FROM artifact_group));
57 --SELECT setval('artifact_status_id_seq',(SELECT max(id) FROM artifact_status));
58 SELECT setval('artifact_artifact_id_seq',(SELECT max(artifact_id) FROM artifact));
59 --SELECT setval('artifact_history_id_seq',(SELECT max(id) FROM artifact_history));
60 --SELECT setval('artifact_file_id_seq',(SELECT max(id) FROM artifact_file));
61 --SELECT setval('artifact_message_id_seq',(SELECT max(id) FROM artifact_message));
62 --SELECT setval('artifact_monitor_id_seq',(SELECT max(id) FROM artifact_monitor));