diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-10-05 14:36:33 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-10-06 23:48:52 +0200 |
| commit | 4c992038ea01ead56df12f468f29325f7ca9e43d (patch) | |
| tree | b84fb649231ce14e7a319347488b05c4d840b45f /data/sql/proj_db_table_defs.sql | |
| parent | a9b6f39494e6dab0ea02af9d82e7b3d570f5422f (diff) | |
| download | PROJ-4c992038ea01ead56df12f468f29325f7ca9e43d.tar.gz PROJ-4c992038ea01ead56df12f468f29325f7ca9e43d.zip | |
Database: add a reference_frame_epoch column to the geodetic_datum for dynamic datums, but not yet used
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 1 |
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 d5e8a25c..7e182e11 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -145,6 +145,7 @@ CREATE TABLE geodetic_datum ( prime_meridian_auth_name TEXT NOT NULL, prime_meridian_code TEXT NOT NULL, publication_date TEXT, --- YYYY-MM-DD format + frame_reference_epoch FLOAT, --- only set for dynamic datum, and should be set when it is a dynamic datum deprecated BOOLEAN NOT NULL CHECK (deprecated IN (0, 1)), CONSTRAINT pk_geodetic_datum PRIMARY KEY (auth_name, code), CONSTRAINT fk_geodetic_datum_ellipsoid FOREIGN KEY (ellipsoid_auth_name, ellipsoid_code) REFERENCES ellipsoid(auth_name, code), |