diff options
| author | Even Rouault <even.rouault@mines-paris.org> | 2019-03-26 15:30:44 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-03-26 15:30:44 +0100 |
| commit | 4c5476f1581d2760030a4b24478fa885a3d4d7b6 (patch) | |
| tree | 0ff7adce3574c971912a561c05360e0efe4dbf70 /data/sql/proj_db_table_defs.sql | |
| parent | 5f8354b32384d62ebc36a5912091fd71c0925b8d (diff) | |
| parent | 6f180b388bc646c9d661b26c3f13268e520508e8 (diff) | |
| download | PROJ-4c5476f1581d2760030a4b24478fa885a3d4d7b6.tar.gz PROJ-4c5476f1581d2760030a4b24478fa885a3d4d7b6.zip | |
Merge pull request #1372 from OSGeo/backport-1368-on-6.0
Backport #1368 on 6.0: Database: update to EPSG v9.6.1, IGNF v3.0.3, ESRI 10.7.0 and add operation_version column
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index d403f0eb..b7dcad89 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -558,6 +558,8 @@ CREATE TABLE helmert_transformation( pivot_uom_auth_name TEXT, pivot_uom_code TEXT, + operation_version TEXT, -- normally mandatory in OGC Topic 2 but optional here + deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_helmert_transformation PRIMARY KEY (auth_name, code), @@ -634,6 +636,8 @@ CREATE TABLE grid_transformation( interpolation_crs_auth_name TEXT, interpolation_crs_code TEXT, + operation_version TEXT, -- normally mandatory in OGC Topic 2 but optional here + deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_grid_transformation PRIMARY KEY (auth_name, code), @@ -790,6 +794,8 @@ CREATE TABLE other_transformation( param7_uom_auth_name TEXT, param7_uom_code TEXT, + operation_version TEXT, -- normally mandatory in OGC Topic 2 but optional here + deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_other_transformation PRIMARY KEY (auth_name, code), @@ -852,6 +858,8 @@ CREATE TABLE concatenated_operation( step3_auth_name TEXT, step3_code TEXT, + operation_version TEXT, -- normally mandatory in OGC Topic 2 but optional here + deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_concatenated_operation PRIMARY KEY (auth_name, code), |