* vars: external-overrides variable added* cron.daily: Update testing/unstable Task...

[dak.git] / add_constraints.sql

diff --git a/add_constraints.sql b/add_constraints.sql
index 2d1d6ab2d7bff2011e9742264c978abf0bdd4b03..65625eb6747e54b3c079ad1e86732beb2ac4f2ab 100644 (file)
--- a/add_constraints.sql
+++ b/add_constraints.sql
@@ -32,6 +32,8 @@ ALTER TABLE override ADD CONSTRAINT override_priority FOREIGN KEY (priority) REF
 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
@@ -101,7 +103,8 @@ GRANT ALL ON architecture, architecture_id_seq, archive,
   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;
+  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,
@@ -112,4 +115,5 @@ GRANT SELECT ON architecture, architecture_id_seq, archive,
   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;
+  suite_architectures, suite_id_seq, accepted_autobuild, uid,
+  uid_id_seq TO PUBLIC;