diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2019-03-25 17:00:04 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2019-03-25 17:00:04 +0100 |
| commit | 054d02760db6fc2c33889d577cd671baa8807909 (patch) | |
| tree | 8825c3d281f6acae86c8c94cb902e8576c9638e3 /data/sql/proj_db_table_defs.sql | |
| parent | c0312858f7621bde4568d98e6ea43fd45bd57a83 (diff) | |
| download | PROJ-054d02760db6fc2c33889d577cd671baa8807909.tar.gz PROJ-054d02760db6fc2c33889d577cd671baa8807909.zip | |
Database: add operation_version column to coordinate operation tables
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), |