From 5c9e2e9d4322271930385fe76195ef4d16cf5a40 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Sun, 4 Apr 2021 21:07:36 +0200 Subject: Database: add missing column type specifir for method_name in grid_transformation and other_transformation. No practical impact --- data/sql/proj_db_table_defs.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'data/sql') diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index 2969178b..d7d5a93b 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -777,7 +777,7 @@ CREATE TABLE helmert_transformation_table( method_auth_name TEXT NOT NULL CHECK (length(method_auth_name) >= 1), method_code TEXT NOT NULL CHECK (length(method_code) >= 1), - --method_name NOT NULL CHECK (length(method_name) >= 2), + --method_name TEXT NOT NULL CHECK (length(method_name) >= 2), source_crs_auth_name TEXT NOT NULL, source_crs_code TEXT NOT NULL, @@ -1009,7 +1009,7 @@ CREATE TABLE grid_transformation( method_auth_name TEXT NOT NULL CHECK (length(method_auth_name) >= 1), method_code TEXT NOT NULL CHECK (length(method_code) >= 1), - method_name NOT NULL CHECK (length(method_name) >= 2), + method_name TEXT NOT NULL CHECK (length(method_name) >= 2), source_crs_auth_name TEXT NOT NULL, source_crs_code TEXT NOT NULL, @@ -1132,7 +1132,7 @@ CREATE TABLE other_transformation( -- PROJ string and then method_name is a WKT string (CoordinateOperation) method_auth_name TEXT NOT NULL CHECK (length(method_auth_name) >= 1), method_code TEXT NOT NULL CHECK (length(method_code) >= 1), - method_name NOT NULL CHECK (length(method_name) >= 2), + method_name TEXT NOT NULL CHECK (length(method_name) >= 2), source_crs_auth_name TEXT NOT NULL, source_crs_code TEXT NOT NULL, -- cgit v1.2.3