From 4c992038ea01ead56df12f468f29325f7ca9e43d Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
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

