From baa8667a38a5cc79571da15844d525c665234edc Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Sat, 7 Mar 2026 15:27:51 +0100 Subject: =?UTF-8?q?schema:=20Add=20NOT=20NULL=20constraints=20on=20some=20?= =?UTF-8?q?of=20Lantm=C3=A4teriet's=20columns.?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- config.yml | 4 ++++ schema.sql | 8 ++++---- 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 ); -- cgit v1.2.3