From 06adefab34f5a73fc3ae7f587c875dfb353eccfd Mon Sep 17 00:00:00 2001 From: Guilhem Moulin 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