Merge remote-tracking branch 'rouault/gdalbarn'

1 files changed, 9 insertions, 0 deletions

diff --git a/data/sql/commit.sql b/data/sql/commit.sql
index 346c5b76..7aa91e8e 100644
--- a/data/sql/commit.sql
+++ b/data/sql/commit.sql
@@ -1,5 +1,14 @@
 COMMIT;
 
+CREATE INDEX geodetic_crs_datum_idx ON geodetic_crs(datum_auth_name, datum_code);
+CREATE INDEX geodetic_datum_ellipsoid_idx ON geodetic_datum(ellipsoid_auth_name, ellipsoid_code);
+CREATE INDEX supersession_idx ON supersession(superseded_table_name, superseded_auth_name, superseded_code);
+CREATE INDEX deprecation_idx ON deprecation(table_name, deprecated_auth_name, deprecated_code);
+CREATE INDEX helmert_transformation_idx ON helmert_transformation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code);
+CREATE INDEX grid_transformation_idx ON grid_transformation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code);
+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);
+
 -- Do an explicit foreign_key_check as foreign key checking is a no-op within
 -- a transaction. Unfortunately we can't ask for this to be an error, so this
 -- is just for verbose output. In Makefile, we check this separately