aboutsummaryrefslogtreecommitdiff
path: root/data/sql/proj_db_table_defs.sql
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2020-03-12 18:36:39 +0100
committerEven Rouault <even.rouault@spatialys.com>2020-03-12 19:40:35 +0100
commit35425763e70b70f7efc9a5c9616695369609553f (patch)
tree57fb24d1983252490e8f01755c9fd3caf934643b /data/sql/proj_db_table_defs.sql
parentca3caf0e976e95a739963567057654cb8909bfb9 (diff)
downloadPROJ-35425763e70b70f7efc9a5c9616695369609553f.tar.gz
PROJ-35425763e70b70f7efc9a5c9616695369609553f.zip
Add proj_get_units_from_database() (fixes #2004)
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
-rw-r--r--data/sql/proj_db_table_defs.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql
index 166929af..df20de31 100644
--- a/data/sql/proj_db_table_defs.sql
+++ b/data/sql/proj_db_table_defs.sql
@@ -14,6 +14,7 @@ CREATE TABLE unit_of_measure(
name TEXT NOT NULL CHECK (length(name) >= 2),
type TEXT NOT NULL CHECK (type IN ('length', 'angle', 'scale', 'time')),
conv_factor FLOAT,
+ proj_short_name TEXT, -- PROJ string name, like 'm', 'ft'. Might be NULL
deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)),
CONSTRAINT pk_unit_of_measure PRIMARY KEY (auth_name, code)
);