diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-04-08 19:29:54 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-04-08 19:29:54 +0200 |
| commit | fc6ff7a481d2bfe5765726f8c638581965896fb7 (patch) | |
| tree | 4cf8d1e2753720a56dc9e125decce8dea8bb63e0 /data/sql/commit.sql | |
| parent | 78e3768a71421508e9e7929e2e56920152ced9e3 (diff) | |
| parent | 950ce787b26b3b3afd0ff76151fdf72d1381b7a1 (diff) | |
| download | PROJ-fc6ff7a481d2bfe5765726f8c638581965896fb7.tar.gz PROJ-fc6ff7a481d2bfe5765726f8c638581965896fb7.zip | |
Merge pull request #2647 from rouault/integer_or_text
Database: decrease db size
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 9ea2935d..e5850211 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 |