From 29fb7c98fa0f2fe3d25cce14f7f4eb9887e5e978 Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Mon, 23 Oct 2017 01:28:50 +0100 Subject: [PATCH] db: Enforce that a build is only in a repository once Signed-off-by: Michael Tremer --- src/database.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/src/database.sql b/src/database.sql index aef4344..fc950c7 100644 --- 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: -- -- 2.47.3