Relax some UNIQUE constraint on the MRR layer's DiaryNR column.HEADmaster

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).

1 files changed, 0 insertions, 16 deletions

diff --git a/schema.sql b/schema.sql
index b32bc00..307acac 100644
--- a/schema.sql
+++ b/schema.sql
@@ -3223,14 +3223,6 @@ ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied"
 
 
 --
--- 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
 --
 
@@ -3247,14 +3239,6 @@ ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved"
 
 
 --
--- 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
 --