aboutsummaryrefslogtreecommitdiff
path: root/data/sql/proj_db_table_defs.sql
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2020-03-16 17:55:36 +0100
committerGitHub <noreply@github.com>2020-03-16 17:55:36 +0100
commit175cbad0a7ca202cefff33f240100b01752f8f73 (patch)
tree3969a91e8499312c698d928f262d219d91aaea3b /data/sql/proj_db_table_defs.sql
parent78eaa34a4816fd9a36e902adae4663f13bc39fab (diff)
parent2247841879faebe007ccade45d04027361d5d26c (diff)
downloadPROJ-175cbad0a7ca202cefff33f240100b01752f8f73.tar.gz
PROJ-175cbad0a7ca202cefff33f240100b01752f8f73.zip
Merge pull request #2065 from rouault/add_proj_get_units_from_database
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)
);