From 06adefab34f5a73fc3ae7f587c875dfb353eccfd Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Wed, 4 Jun 2025 16:06:43 +0200
Subject: MRR: Drop field export_date.

All features have the same export date value, so the date is arguably a
schema attribute not a feature attribute.  Since exports from the
mineral register happens daily nowdays the date should never be more
than a day off compared with the zip file's mtime.
---
 schema.sql | 13 -------------
 1 file changed, 13 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index c16eac0..f5715e1 100644
--- a/schema.sql
+++ b/schema.sql
@@ -442,7 +442,6 @@ CREATE TABLE postgis."mrr:bearbetningskoncessioner_ansokta" (
     appl_date date NOT NULL,
     mineral character varying(254) NOT NULL,
     owners character varying(254) NOT NULL,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -492,7 +491,6 @@ CREATE TABLE postgis."mrr:bearbetningskoncessioner_beviljade" (
     validto date NOT NULL,
     mineral character varying(254) NOT NULL,
     owners character varying(254) NOT NULL,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -539,7 +537,6 @@ CREATE TABLE postgis."mrr:bearbetningskoncessioner_forfallna" (
     appl_date date,
     mineral character varying(254) NOT NULL,
     owners character varying(254) NOT NULL,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -584,7 +581,6 @@ CREATE TABLE postgis."mrr:markanvisningar_bk_ansokta" (
     diarynr character varying(16) NOT NULL,
     conc_name character varying(254) NOT NULL,
     appl_date date NOT NULL,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -631,7 +627,6 @@ CREATE TABLE postgis."mrr:markanvisningar_bk_beviljade" (
     conc_name character varying(254) NOT NULL,
     appl_date date NOT NULL,
     dec_date date NOT NULL,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -677,7 +672,6 @@ CREATE TABLE postgis."mrr:ut_diamant_ansokta" (
     appl_date date NOT NULL,
     mineral character varying(254) NOT NULL,
     owners character varying(254) NOT NULL,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -727,7 +721,6 @@ CREATE TABLE postgis."mrr:ut_diamant_beviljade" (
     validto date NOT NULL,
     mineral character varying(254) NOT NULL,
     owners character varying(254) NOT NULL,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -777,7 +770,6 @@ CREATE TABLE postgis."mrr:ut_diamant_forbud" (
     owners character varying(254) NOT NULL,
     prospdata_url character varying(254),
     prospdata_filesize_mb real,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -823,7 +815,6 @@ CREATE TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" (
     appl_date date NOT NULL,
     mineral character varying(254) NOT NULL,
     owners character varying(254) NOT NULL,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -873,7 +864,6 @@ CREATE TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" (
     validto date NOT NULL,
     mineral character varying(254) NOT NULL,
     owners character varying(254) NOT NULL,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -923,7 +913,6 @@ CREATE TABLE postgis."mrr:ut_metaller_industrimineral_forbud" (
     owners character varying(254) NOT NULL,
     prospdata_url character varying(254),
     prospdata_filesize_mb real,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -973,7 +962,6 @@ CREATE TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" (
     owners character varying(510) NOT NULL,
     prospdata_url character varying(254),
     prospdata_filesize_mb real,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
@@ -1023,7 +1011,6 @@ CREATE TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" (
     owners character varying(510) NOT NULL,
     prospdata_url character varying(254),
     prospdata_filesize_mb real,
-    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
-- 
cgit v1.2.3

