diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-04-04 22:44:07 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2021-04-06 23:30:19 +0200 |
| commit | 950ce787b26b3b3afd0ff76151fdf72d1381b7a1 (patch) | |
| tree | b2d70e6c7151361c6cf9e99592ada7386c4a1d95 /data/sql/commit.sql | |
| parent | f85b0723136eed9891569b988607f07ef185d504 (diff) | |
| download | PROJ-950ce787b26b3b3afd0ff76151fdf72d1381b7a1.tar.gz PROJ-950ce787b26b3b3afd0ff76151fdf72d1381b7a1.zip | |
Database: nullify auth_name, code of usage table
We never select by those columns, so don't set them. Reduce from 8.4 to
7.9 MB.
Upgrade the minor version of the database layout. (that database can
still be read by PROJ 8.0)
Diffstat (limited to 'data/sql/commit.sql')
| -rw-r--r-- | data/sql/commit.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/data/sql/commit.sql b/data/sql/commit.sql index 7a4b74ad..3cdb0861 100644 --- a/data/sql/commit.sql +++ b/data/sql/commit.sql @@ -9,6 +9,9 @@ CREATE INDEX grid_transformation_idx ON grid_transformation(source_crs_auth_name CREATE INDEX other_transformation_idx ON other_transformation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code); CREATE INDEX concatenated_operation_idx ON concatenated_operation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code); +-- We don't need to select by auth_name, code so nullify them to save space +UPDATE usage SET auth_name = NULL, code = NULL; + -- Final consistency checks CREATE TABLE dummy(foo); CREATE TRIGGER final_checks |