From 054d02760db6fc2c33889d577cd671baa8807909 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Mon, 25 Mar 2019 17:00:04 +0100 Subject: Database: add operation_version column to coordinate operation tables --- data/sql/proj_db_table_defs.sql | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'data/sql/proj_db_table_defs.sql') 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), -- cgit v1.2.3