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;
+
-- Then correct all the id SERIAL PRIMARY KEY columns...
CREATE FUNCTION files_id_max() RETURNS INT4
VACUUM override;
-- FIXME: has to be a better way to do this
-GRANT ALL ON
- architecture, architecture_id_seq, archive, archive_id_seq,
- bin_associations, bin_associations_id_seq, binaries,
+GRANT ALL ON architecture, architecture_id_seq, archive,
+ archive_id_seq, bin_associations, bin_associations_id_seq, binaries,
binaries_id_seq, component, component_id_seq, dsc_files,
- dsc_files_id_seq, files, files_id_seq, location, location_id_seq,
- maintainer, 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
- TO GROUP ftpmaster;
+ dsc_files_id_seq, files, files_id_seq, fingerprint,
+ fingerprint_id_seq, location, location_id_seq, maintainer,
+ 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,
+ uid_id_seq TO GROUP ftpmaster;
-- Read only access to user 'nobody'
-GRANT SELECT ON
- architecture, architecture_id_seq, archive, archive_id_seq,
- bin_associations, bin_associations_id_seq, binaries,
+GRANT SELECT ON architecture, architecture_id_seq, archive,
+ archive_id_seq, bin_associations, bin_associations_id_seq, binaries,
binaries_id_seq, component, component_id_seq, dsc_files,
- dsc_files_id_seq, files, files_id_seq, location, location_id_seq,
- maintainer, 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
- TO PUBLIC;
+ dsc_files_id_seq, files, files_id_seq, fingerprint,
+ fingerprint_id_seq, location, location_id_seq, maintainer,
+ 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,
+ uid_id_seq TO PUBLIC;