Autobuild support take 3 (security).

[dak.git] / add_constraints.sql

diff --git a/add_constraints.sql b/add_constraints.sql
index 67ec71b1bae0dfc711d5849c34d1435c584a3814..f459835ff96b5ef3b9a65abcf2512c6f780f5103 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