db: Add foreign key constraint to jobs.superseeded_by

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

diff --git a/src/database.sql b/src/database.sql
index f0fadee1d3071823a9eb58372226808ec399e66f..b5063af7d053f3f1f4cd64dbbc7301d252deaa1b 100644 (file)
--- a/src/database.sql
+++ b/src/database.sql
@@ -2830,6 +2830,14 @@ ALTER TABLE ONLY jobs_repos
     ADD CONSTRAINT jobs_repos_repo_id FOREIGN KEY (repo_id) REFERENCES repositories(id);
 
 
+--
+-- Name: jobs_superseeded_by; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
+--
+
+ALTER TABLE ONLY jobs
+    ADD CONSTRAINT jobs_superseeded_by FOREIGN KEY (superseeded_by) REFERENCES jobs(id);
+
+
 --
 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
 --