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

2 files changed, 4 insertions, 18 deletions

diff --git a/config.yml b/config.yml
index db812c6..304eb99 100644
--- a/config.yml
+++ b/config.yml
@@ -3174,7 +3174,8 @@ layers:
           comment: När tillståndets giltighet slutar
         - name: DiaryNr
           type: String
-          unique: true
+          # XXX how come there is no UNIQUE constraint here?
+          #unique: true
           width: 16
         - name: LastUpdated
           type: Date
@@ -3221,7 +3222,8 @@ layers:
           comment: Beslutsdatum
         - name: DiaryNr
           type: String
-          unique: true
+          # XXX how come there is no UNIQUE constraint here?
+          #unique: true
           width: 16
         - name: LastUpdated
           type: Date
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
 --