aboutsummaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
authorGuilhem Moulin <guilhem@fripost.org>2024-06-19 03:09:37 +0200
committerGuilhem Moulin <guilhem@fripost.org>2024-06-19 03:32:33 +0200
commitae01b2aae08033a4183b7c601dbf0381362f346b (patch)
tree3adbf5c18708d4344c7b3794eceac9ccee317644 /schema.sql
parentb7531ec5c353c616bcb905964339b06b5c8b6ed0 (diff)
sks:UtfordAvverk: Add NOT NULL constraint on AnmaldHa column.
There are a couple (15) of NULL AnmaldHa's, all from Sep 1, 2005 in BorĂ¥s, so we don't care about these.
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql2
1 files changed, 1 insertions, 1 deletions
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,