From f9ef8f0635a3349d99419c70f1d11ee15c94c660 Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Tue, 29 Oct 2024 03:52:38 +0100
Subject: Relax some UNIQUE constraint on the MRR layer's DiaryNR column.

Apparently there are duplicates for dnr BS 22-28-2000
(bearbetningskoncessioner_beviljade) and BS 23-126-2007,
BS 23-116-2005, BS 23-226-1930, BS 23-149-1960, BS 23-7-2000,
and BS 23-105-2010 (markanvisningar_bk_beviljade).
---
 schema.sql | 16 ----------------
 1 file changed, 16 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index b32bc00..307acac 100644
--- a/schema.sql
+++ b/schema.sql
@@ -3222,14 +3222,6 @@ ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied"
     ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_pkey" PRIMARY KEY (ogc_fid);
 
 
---
--- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
---
-
-ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved"
-    ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_DiaryNr_key" UNIQUE ("DiaryNr");
-
-
 --
 -- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
@@ -3246,14 +3238,6 @@ ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved"
     ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_pkey" PRIMARY KEY (ogc_fid);
 
 
---
--- Name: mrr:markanvisningar mrr:markanvisningar_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
---
-
-ALTER TABLE ONLY postgis."mrr:markanvisningar"
-    ADD CONSTRAINT "mrr:markanvisningar_DiaryNr_key" UNIQUE ("DiaryNr");
-
-
 --
 -- Name: mrr:markanvisningar mrr:markanvisningar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
-- 
cgit v1.2.3

