aboutsummaryrefslogtreecommitdiff
path: root/data/sql
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2021-09-28 14:47:06 +0200
committerEven Rouault <even.rouault@spatialys.com>2021-09-28 14:47:06 +0200
commit23c44387d104b1d5c16c9f583d975ea4d895b534 (patch)
treeeee4d451bda6757bb4c72ba3446005a7fed31ff3 /data/sql
parent6cea38f649a6c74fe816d59d04a85b51198b4f2c (diff)
downloadPROJ-23c44387d104b1d5c16c9f583d975ea4d895b534.tar.gz
PROJ-23c44387d104b1d5c16c9f583d975ea4d895b534.zip
Database: add some hand made entries early
Diffstat (limited to 'data/sql')
-rw-r--r--data/sql/customizations.sql3
-rw-r--r--data/sql/customizations_early.sql6
-rw-r--r--data/sql/proj_db_table_defs.sql2
3 files changed, 6 insertions, 5 deletions
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),