diff options
| author | Guilhem Moulin <guilhem@fripost.org> | 2025-06-04 16:06:43 +0200 |
|---|---|---|
| committer | Guilhem Moulin <guilhem@fripost.org> | 2025-06-04 16:16:08 +0200 |
| commit | 06adefab34f5a73fc3ae7f587c875dfb353eccfd (patch) | |
| tree | 9501462d5b30574b35bf24706c9525f148ae1890 /schema.sql | |
| parent | 59a0ebbb824eaa75dcf7b0e39c5b627fb5ace294 (diff) | |
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.
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 13 |
1 files changed, 0 insertions, 13 deletions
@@ -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 ); |