From 23c44387d104b1d5c16c9f583d975ea4d895b534 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Tue, 28 Sep 2021 14:47:06 +0200 Subject: Database: add some hand made entries early --- data/sql/customizations.sql | 3 --- data/sql/customizations_early.sql | 6 ++++++ data/sql/proj_db_table_defs.sql | 2 -- 3 files changed, 6 insertions(+), 5 deletions(-) create mode 100644 data/sql/customizations_early.sql (limited to 'data/sql') diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index 74885a45..19b21b7d 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -1,8 +1,5 @@ -- This file is hand generated. -INSERT INTO "extent" VALUES('PROJ','EXTENT_UNKNOWN','Not specified','Not specified.',-90.0,90.0,-180.0,180.0,0); -INSERT INTO "scope" VALUES('PROJ','SCOPE_UNKNOWN','Not known.',0); - -- grid_alternatives entries created from existing ones INSERT INTO grid_alternatives(original_grid_name, diff --git a/data/sql/customizations_early.sql b/data/sql/customizations_early.sql new file mode 100644 index 00000000..7f9505df --- /dev/null +++ b/data/sql/customizations_early.sql @@ -0,0 +1,6 @@ +-- This file is hand generated. + +INSERT INTO "extent" VALUES('PROJ','EXTENT_UNKNOWN','Not specified','Not specified.',-90.0,90.0,-180.0,180.0,0); +INSERT INTO "scope" VALUES('PROJ','SCOPE_UNKNOWN','Not known.',0); + +INSERT INTO celestial_body VALUES('PROJ', 'EARTH', 'Earth', 6378137.0); diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index 9155fd8f..560cd59e 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -35,8 +35,6 @@ CREATE TABLE celestial_body ( CONSTRAINT pk_celestial_body PRIMARY KEY (auth_name, code) ) WITHOUT ROWID; -INSERT INTO celestial_body VALUES('PROJ', 'EARTH', 'Earth', 6378137.0); - CREATE TABLE ellipsoid ( auth_name TEXT NOT NULL CHECK (length(auth_name) >= 1), code INTEGER_OR_TEXT NOT NULL CHECK (length(code) >= 1), -- cgit v1.2.3