X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=setup%2Fadd_constraints.sql;h=1d2bad66f4e0684937856526932d7851794a954f;hb=1e8dd7a1e4aa362cb5275a4db27251a77e5a9c34;hp=8d275502c313cfa9d19fc9e4fd7ff46fd6e71c11;hpb=ef8dcbe8251167f9c922959a67f626615b421c81;p=dak.git diff --git a/setup/add_constraints.sql b/setup/add_constraints.sql index 8d275502..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;