diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-09-28 14:47:06 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2021-09-28 14:47:06 +0200 |
| commit | 23c44387d104b1d5c16c9f583d975ea4d895b534 (patch) | |
| tree | eee4d451bda6757bb4c72ba3446005a7fed31ff3 /data | |
| parent | 6cea38f649a6c74fe816d59d04a85b51198b4f2c (diff) | |
| download | PROJ-23c44387d104b1d5c16c9f583d975ea4d895b534.tar.gz PROJ-23c44387d104b1d5c16c9f583d975ea4d895b534.zip | |
Database: add some hand made entries early
Diffstat (limited to 'data')
| -rw-r--r-- | data/Makefile.am | 1 | ||||
| -rw-r--r-- | data/sql/customizations.sql | 3 | ||||
| -rw-r--r-- | data/sql/customizations_early.sql | 6 | ||||
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 2 | ||||
| -rw-r--r-- | data/sql_filelist.cmake | 1 |
5 files changed, 8 insertions, 5 deletions
diff --git a/data/Makefile.am b/data/Makefile.am index b4ebf3d2..b25b6115 100644 --- a/data/Makefile.am +++ b/data/Makefile.am @@ -10,6 +10,7 @@ pkgdata_DATA = proj.ini GL27 nad.lst nad27 nad83 world other.extra \ SQL_ORDERED_LIST = sql/begin.sql \ sql/proj_db_table_defs.sql \ sql/conversion_triggers.sql \ + sql/customizations_early.sql \ sql/metadata.sql \ sql/unit_of_measure.sql \ sql/extent.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), diff --git a/data/sql_filelist.cmake b/data/sql_filelist.cmake index 2103e19e..9fa94a29 100644 --- a/data/sql_filelist.cmake +++ b/data/sql_filelist.cmake @@ -3,6 +3,7 @@ set(SQL_FILES "${SQL_DIR}/begin.sql" "${SQL_DIR}/proj_db_table_defs.sql" "${SQL_DIR}/conversion_triggers.sql" + "${SQL_DIR}/customizations_early.sql" "${SQL_DIR}/metadata.sql" "${SQL_DIR}/unit_of_measure.sql" "${SQL_DIR}/extent.sql" |