From a8c1588d43fccdbc3b65448f2c7af6472fa6519b Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Sun, 17 Nov 2019 20:11:17 +0100 Subject: createOperations(): remove the concept of geodetic_datum_preferred_hub This was introduced in 63857c92b271bbcd10df0a032304982011acb2a9. Due to the fix done in the previous commit, we can mostly revert the above commit. We just keep the added tests and the custom WGS 84<-->WGS 84 (Gxxxx) null transformations. --- data/sql/proj_db_table_defs.sql | 13 ------------- 1 file changed, 13 deletions(-) (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 a97e75a8..ee91aa3d 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -126,19 +126,6 @@ FOR EACH ROW BEGIN WHERE EXISTS(SELECT 1 FROM area WHERE area.auth_name = NEW.area_of_use_auth_name AND area.code = NEW.area_of_use_code AND area.deprecated != 0) AND NEW.deprecated = 0; END; --- indicates that if there is no transformation from/into (src_auth_name, src_code), --- a research going through (hub_auth_name, hub_code) should be made -CREATE TABLE geodetic_datum_preferred_hub( - src_auth_name TEXT NOT NULL CHECK (length(src_auth_name) >= 1), - src_code TEXT NOT NULL CHECK (length(src_code) >= 1), - hub_auth_name TEXT NOT NULL CHECK (length(hub_auth_name) >= 1), - hub_code TEXT NOT NULL CHECK (length(hub_code) >= 1), - - CONSTRAINT unique_geodetic_datum_preferred_hub UNIQUE (src_auth_name, src_code, hub_auth_name, hub_code), - CONSTRAINT fk_geodetic_datum_preferred_hub_src FOREIGN KEY (src_auth_name, src_code) REFERENCES geodetic_datum(auth_name, code), - CONSTRAINT fk_geodetic_datum_preferred_hub_src FOREIGN KEY (hub_auth_name, hub_code) REFERENCES geodetic_datum(auth_name, code) -); - CREATE TABLE vertical_datum ( auth_name TEXT NOT NULL CHECK (length(auth_name) >= 1), code TEXT NOT NULL CHECK (length(code) >= 1), -- cgit v1.2.3