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
---
 schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'schema.sql')

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

