X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=setup%2Fadd_constraints.sql;h=1d2bad66f4e0684937856526932d7851794a954f;hb=342c016d08d7ed329ae707ff6fcdb39ae560c438;hp=f25165c1b1dbaffd27977d9a188fe70464e7a5ee;hpb=59fd5aa2a8be3b76dbc968429c457f096adfa472;p=dak.git

diff --git a/setup/add_constraints.sql b/setup/add_constraints.sql
index f25165c1..1d2bad66 100644
--- a/setup/add_constraints.sql
+++ b/setup/add_constraints.sql
@@ -5,6 +5,7 @@
 ALTER TABLE files ADD CONSTRAINT files_location FOREIGN KEY (location) REFERENCES location(id) MATCH FULL;
 
 ALTER TABLE source ADD CONSTRAINT source_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) MATCH FULL;
+ALTER TABLE source ADD CONSTRAINT source_changedby FOREIGN KEY (changedby) REFERENCES maintainer(id) MATCH FULL;
 ALTER TABLE source ADD CONSTRAINT source_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
 ALTER TABLE source ADD CONSTRAINT source_sig_fpr FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id) MATCH FULL;
 
@@ -104,10 +105,12 @@ 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, fingerprint,
-  fingerprint_id_seq, location, location_id_seq, maintainer,
+  fingerprint_id_seq, keyrings, keyrings_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,
+  source_id_seq, src_uploaders, src_uploaders_id_seq,
+  src_associations, src_associations_id_seq, suite,
   suite_architectures, suite_id_seq, queue_build, uid,
   uid_id_seq TO GROUP ftpmaster;
 
@@ -116,9 +119,11 @@ 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, fingerprint,
-  fingerprint_id_seq, location, location_id_seq, maintainer,
+  fingerprint_id_seq, keyrings, keyrings_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,
+  source_id_seq, src_uploaders, src_uploaders_id_seq,
+  src_associations, src_associations_id_seq, suite,
   suite_architectures, suite_id_seq, queue_build, uid,
   uid_id_seq TO PUBLIC;