From c36edde5f028a7a64cb44eaf7260215a25ada75b Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Sun, 27 Oct 2024 23:17:38 +0100
Subject: nva:Skogsstyrelsen: Remove NOT NULL constraint on the DatAvtal
 column.

As of today SK 117-2024 has not contract date set, so the constraint
fails during import.
https://www.skogsstyrelsen.se/skogens-parlor/NVAvtal/?objektid=4020527
---
 config.yml | 1 -
 schema.sql | 2 +-
 2 files changed, 1 insertion(+), 2 deletions(-)

diff --git a/config.yml b/config.yml
index eee8e0f..224b439 100644
--- a/config.yml
+++ b/config.yml
@@ -2020,7 +2020,6 @@ layers:
           comment: Ståndortsindex
         - name: DatAvtal
           type: Date
-          nullable: false
         - name: Url
           type: String
           width: 254
diff --git a/schema.sql b/schema.sql
index 14260ca..7249816 100644
--- a/schema.sql
+++ b/schema.sql
@@ -706,7 +706,7 @@ CREATE TABLE postgis."nva:Skogsstyrelsen" (
     "AreaTot" double precision NOT NULL,
     "AreaProd" double precision NOT NULL,
     "Standort" character varying(254),
-    "DatAvtal" date NOT NULL,
+    "DatAvtal" date,
     "Url" character varying(254) NOT NULL,
     "Undertyp" character varying(64),
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
-- 
cgit v1.2.3