diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-05-14 22:01:56 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-05-15 00:21:25 +0200 |
| commit | f167d3fa6e3922bbfe92315e8e8d7ec0bf0ffa2b (patch) | |
| tree | 19639fd720546b55f65cbc8752b2a617b0fc17d1 /data/sql/proj_db_table_defs.sql | |
| parent | e86ce263a9f5fdd7c09758f489d80c564dbb7fc5 (diff) | |
| download | PROJ-f167d3fa6e3922bbfe92315e8e8d7ec0bf0ffa2b.tar.gz PROJ-f167d3fa6e3922bbfe92315e8e8d7ec0bf0ffa2b.zip | |
Database: add index on alias_name(code)
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index df20de31..2d820d20 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1340,6 +1340,8 @@ CREATE TABLE alias_name( source TEXT ); +CREATE INDEX idx_alias_name_code ON alias_name(code); + CREATE TRIGGER alias_name_insert_trigger BEFORE INSERT ON alias_name FOR EACH ROW BEGIN |