db: Enforce that a build is only in a repository once

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

diff --git a/src/database.sql b/src/database.sql
index aef434499c85949969f45202da4479da156535ec..fc950c70ea7544daa78cfffb34fec5d7a809b49c 100644 (file)
--- a/src/database.sql
+++ b/src/database.sql
@@ -2533,6 +2533,14 @@ ALTER TABLE ONLY mirrors_checks
     ADD CONSTRAINT mirrors_checks_pkey PRIMARY KEY (id);
 
 
+--
+-- Name: repositories_builds_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace: 
+--
+
+ALTER TABLE ONLY repositories_builds
+    ADD CONSTRAINT repositories_builds_unique UNIQUE (repo_id, build_id);
+
+
 --
 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace: 
 --