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

(limited to 'schema.sql')

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

