Add changedby column to source table, and fill in information found in the

[dak.git] / setup / add_constraints.sql

diff --git a/setup/add_constraints.sql b/setup/add_constraints.sql
index 8d275502c313cfa9d19fc9e4fd7ff46fd6e71c11..1d2bad66f4e0684937856526932d7851794a954f 100644 (file)
--- 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;