diff options
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 16 |
1 files changed, 8 insertions, 8 deletions
@@ -170,7 +170,7 @@ CREATE TABLE postgis."mrr:bearbetningskoncessioner_applied" ( "Applicant" character varying(254) NOT NULL, "ApplicationDate" date NOT NULL, "DiaryNr" character(16) NOT NULL, - "LastUpdated" character(10) NOT NULL, + "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); @@ -217,7 +217,7 @@ CREATE TABLE postgis."mrr:bearbetningskoncessioner_approved" ( "ValidFrom" date NOT NULL, "ValidTo" date NOT NULL, "DiaryNr" character(16), - "LastUpdated" character(10) NOT NULL, + "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); @@ -261,7 +261,7 @@ CREATE TABLE postgis."mrr:markanvisningar" ( "Name" character varying(254) NOT NULL, "DecisionDate" date, "DiaryNr" character(16), - "LastUpdated" character(10) NOT NULL, + "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); @@ -307,7 +307,7 @@ CREATE TABLE postgis."mrr:mineral_applied" ( "Applicant" character varying(254) NOT NULL, "ApplicationDate" date NOT NULL, "DiaryNr" character(16) NOT NULL, - "LastUpdated" character(10) NOT NULL, + "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); @@ -355,7 +355,7 @@ CREATE TABLE postgis."mrr:mineral_approved" ( "ValidFrom" date NOT NULL, "ValidTo" date NOT NULL, "DiaryNr" character(16), - "LastUpdated" character(10) NOT NULL, + "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); @@ -401,7 +401,7 @@ CREATE TABLE postgis."mrr:olja_gas_diamant_applied" ( "Applicant" character varying(254) NOT NULL, "ApplicationDate" date NOT NULL, "DiaryNr" character(16) NOT NULL, - "LastUpdated" character(10) NOT NULL, + "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); @@ -449,7 +449,7 @@ CREATE TABLE postgis."mrr:olja_gas_diamant_approved" ( "ValidFrom" date NOT NULL, "ValidTo" date NOT NULL, "DiaryNr" character(16), - "LastUpdated" character(10) NOT NULL, + "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); @@ -496,7 +496,7 @@ CREATE TABLE postgis."mrr:torvkoncessioner" ( "ValidFrom" date NOT NULL, "ValidTo" date NOT NULL, "DiaryNr" character(16), - "LastUpdated" character(10) NOT NULL, + "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); |