diff options
| -rw-r--r-- | config.yml | 6 | ||||
| -rw-r--r-- | schema.sql | 8 |
2 files changed, 9 insertions, 5 deletions
@@ -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 @@ -2632,7 +2636,7 @@ layers: # 1900-01-01 innebär att datum ej identifierats - replace: '19000101' with: null - - replace: '([0-9]{4})([0-9]{2})([0-9]{2})' + - replace: '([0-9]{4})([0-9]{2})([0-9]{2})(?:[0-9]{6})?' with: '{0}-{1}-{2}' type: regex publish: pagaende_naturreservatsbildning @@ -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 ); |