schema: Add NOT NULL constraints on some of Lantmäteriet's columns.

2 files changed, 8 insertions, 4 deletions

diff --git a/config.yml b/config.yml
index 058fde1..4271b41 100644
--- a/config.yml
+++ b/config.yml
@@ -769,10 +769,12 @@ layers:
           subtype: UUID
           unique: true
           #width: 36
+          nullable: false
           comment: Globalt unik identitet för generaliserat objekt
         - name: skapad
           type: DateTime
           tz: local
+          nullable: false
           comment: Tidpunkt när objektet ändrades
         - name: lanskod
           type: Integer
@@ -807,10 +809,12 @@ layers:
           subtype: UUID
           unique: true
           #width: 36
+          nullable: false
           comment: Globalt unik identitet för generaliserat objekt
         - name: skapad
           type: DateTime
           tz: local
+          nullable: false
           comment: Tidpunkt när objektet ändrades
         - name: kommunkod
           type: Integer
diff --git a/schema.sql b/schema.sql
index 46dd2be..768f50b 100644
--- a/schema.sql
+++ b/schema.sql
@@ -368,8 +368,8 @@ SET default_table_access_method = heap;
 
 CREATE TABLE lm_topo250.kommunyta (
     ogc_fid bigint NOT NULL,
-    objektidentitet uuid,
-    skapad timestamp without time zone,
+    objektidentitet uuid NOT NULL,
+    skapad timestamp without time zone NOT NULL,
     kommunkod smallint NOT NULL,
     wkb_geometry public.geometry(MultiPolygon,3006) NOT NULL
 );
@@ -466,8 +466,8 @@ ALTER SEQUENCE lm_topo250.kommunyta_sub_ogc_fid_seq OWNED BY lm_topo250.kommunyt
 
 CREATE TABLE lm_topo250.lansyta (
     ogc_fid bigint NOT NULL,
-    objektidentitet uuid,
-    skapad timestamp without time zone,
+    objektidentitet uuid NOT NULL,
+    skapad timestamp without time zone NOT NULL,
     lanskod smallint NOT NULL,
     wkb_geometry public.geometry(MultiPolygon,3006) NOT NULL
 );