aboutsummaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql16
1 files changed, 8 insertions, 8 deletions
diff --git a/schema.sql b/schema.sql
index 6fbef97..6b4e773 100644
--- a/schema.sql
+++ b/schema.sql
@@ -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)
);