aboutsummaryrefslogtreecommitdiff
path: root/data/sql/proj_db_table_defs.sql
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2021-04-04 21:07:36 +0200
committerEven Rouault <even.rouault@spatialys.com>2021-04-04 21:07:36 +0200
commit5c9e2e9d4322271930385fe76195ef4d16cf5a40 (patch)
treef9b83cdb493243d6a2b803a768815051d4df9bb9 /data/sql/proj_db_table_defs.sql
parentb6210a0e25f9810c4af747de492920eb422fb259 (diff)
downloadPROJ-5c9e2e9d4322271930385fe76195ef4d16cf5a40.tar.gz
PROJ-5c9e2e9d4322271930385fe76195ef4d16cf5a40.zip
Database: add missing column type specifir for method_name in grid_transformation and other_transformation. No practical impact
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
-rw-r--r--data/sql/proj_db_table_defs.sql6
1 files changed, 3 insertions, 3 deletions
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,