From 4c992038ea01ead56df12f468f29325f7ca9e43d Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Mon, 5 Oct 2020 14:36:33 +0200 Subject: Database: add a reference_frame_epoch column to the geodetic_datum for dynamic datums, but not yet used --- data/sql/proj_db_table_defs.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'data/sql/proj_db_table_defs.sql') 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), -- cgit v1.2.3