ALTER TABLE override ADD CONSTRAINT override_section FOREIGN KEY (section) REFERENCES section(id) MATCH FULL;
ALTER TABLE override ADD CONSTRAINT override_type FOREIGN KEY (type) REFERENCES override_type(id) MATCH FULL;
-ALTER TABLE accepted_autobuild ADD CONSTRAINT accepted_autobuild_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
+ALTER TABLE queue_build ADD CONSTRAINT queue_build_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
+ALTER TABLE queue_build ADD CONSTRAINT queue_build_queue FOREIGN KEY (queue) REFERENCES queue(id) MATCH FULL;
-- Then correct all the id SERIAL PRIMARY KEY columns...
CREATE FUNCTION override_type_id_max() RETURNS INT4
AS 'SELECT max(id) FROM override_type'
LANGUAGE 'sql';
+CREATE FUNCTION maintainer_id_max() RETURNS INT4
+ AS 'SELECT max(id) FROM maintainer'
+ LANGUAGE 'sql';
SELECT setval('files_id_seq', files_id_max());
SELECT setval('source_id_seq', source_id_max());
SELECT setval('section_id_seq', section_id_max());
SELECT setval('priority_id_seq', priority_id_max());
SELECT setval('override_type_id_seq', override_type_id_max());
+SELECT setval('maintainer_id_seq', maintainer_id_max());
-- Vacuum the tables for efficency
maintainer_id_seq, override, override_type, override_type_id_seq,
priority, priority_id_seq, section, section_id_seq, source,
source_id_seq, src_associations, src_associations_id_seq, suite,
- suite_architectures, suite_id_seq, accepted_autobuild, uid,
+ suite_architectures, suite_id_seq, queue_build, uid,
uid_id_seq TO GROUP ftpmaster;
-- Read only access to user 'nobody'
maintainer_id_seq, override, override_type, override_type_id_seq,
priority, priority_id_seq, section, section_id_seq, source,
source_id_seq, src_associations, src_associations_id_seq, suite,
- suite_architectures, suite_id_seq, accepted_autobuild, uid,
+ suite_architectures, suite_id_seq, queue_build, uid,
uid_id_seq TO PUBLIC;