From ae01b2aae08033a4183b7c601dbf0381362f346b Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Wed, 19 Jun 2024 03:09:37 +0200
Subject: sks:UtfordAvverk: Add NOT NULL constraint on AnmaldHa column.
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

There are a couple (15) of NULL AnmaldHa's, all from Sep 1, 2005 in
Borås, so we don't care about these.
---
 config.yml | 2 +-
 schema.sql | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/config.yml b/config.yml
index 450cc5f..183599c 100644
--- a/config.yml
+++ b/config.yml
@@ -556,7 +556,7 @@ layers:
         - name: AnmaldHa
           type: Real
           subtype: Float32
-          #nullable: false
+          nullable: false
           #comment: areal anmält (ha)
         - name: SkogsodlHa
           type: Real
diff --git a/schema.sql b/schema.sql
index 07bda74..6fbef97 100644
--- a/schema.sql
+++ b/schema.sql
@@ -595,7 +595,7 @@ CREATE TABLE postgis."sks:UtfordAvverk" (
     "ArendeAr" smallint NOT NULL,
     "Avverktyp" character varying(254) NOT NULL,
     "Skogstyp" character varying(254) NOT NULL,
-    "AnmaldHa" real,
+    "AnmaldHa" real NOT NULL,
     "SkogsodlHa" real NOT NULL,
     "NatforHa" real NOT NULL,
     "Avvdatum" date NOT NULL,
-- 
cgit v1.2.3