From 054d02760db6fc2c33889d577cd671baa8807909 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
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

