2 -- purpose: Referential integrity constraints for FRS schema
6 INSERT INTO frs_filetype VALUES (100,'None');
7 INSERT INTO frs_processor VALUES (100,'None');
9 -- if file is not attched to a release, it can't be seen anyway
14 WHERE frs_file.release_id=frs_release.release_id
23 WHERE frs_file.type_id=frs_filetype.type_id
32 WHERE frs_file.processor_id=frs_processor.processor_id
38 ALTER TABLE frs_file ADD CONSTRAINT frsfile_releaseid_fk
39 FOREIGN KEY (release_id) REFERENCES frs_release(release_id) MATCH FULL;
40 ALTER TABLE frs_file ADD CONSTRAINT frsfile_typeid_fk
41 FOREIGN KEY (type_id) REFERENCES frs_filetype(type_id) MATCH FULL;
42 ALTER TABLE frs_file ADD CONSTRAINT frsfile_processorid_fk
43 FOREIGN KEY (processor_id) REFERENCES frs_processor(processor_id) MATCH FULL;
45 ALTER TABLE frs_package ADD CONSTRAINT frspackage_groupid_fk
46 FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL;
47 ALTER TABLE frs_package ADD CONSTRAINT frspackage_statusid_fk
48 FOREIGN KEY (status_id) REFERENCES frs_status(status_id) MATCH FULL;
50 ALTER TABLE frs_release ADD CONSTRAINT frsrelease_packageid_fk
51 FOREIGN KEY (package_id) REFERENCES frs_package(package_id) MATCH FULL;
52 ALTER TABLE frs_release ADD CONSTRAINT frsrelease_statusid_fk
53 FOREIGN KEY (status_id) REFERENCES frs_status(status_id) MATCH FULL;
54 ALTER TABLE frs_release ADD CONSTRAINT frsrelease_releasedby_fk
55 FOREIGN KEY (released_by) REFERENCES users(user_id) MATCH FULL;
57 -- Tracker 'Pending' patch sql changes
59 ALTER TABLE artifact_group_list ADD COLUMN status_timeout integer;
60 UPDATE artifact_group_list SET status_timeout='1209600' WHERE status_timeout=NULL;
61 INSERT INTO artifact_status VALUES('4','Pending');