diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-05-15 11:58:05 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-05-15 11:58:05 +0200 |
| commit | 6c5164eb49bdb6fcc9bf976db33c1b0a4bf5d7ad (patch) | |
| tree | 30e995477bdeae2ccf9038dc6f2d0759c41f2447 /data/sql | |
| parent | 40bceca79f71d88fbc4953fa6c2bb6b6ed89c473 (diff) | |
| parent | 77a8a9e01c3cdfde0f8118fa9e72d899c51c154d (diff) | |
| download | PROJ-6c5164eb49bdb6fcc9bf976db33c1b0a4bf5d7ad.tar.gz PROJ-6c5164eb49bdb6fcc9bf976db33c1b0a4bf5d7ad.zip | |
Merge pull request #2223 from rouault/fix_2221
Avoid 2 warnings about missing database indices
Diffstat (limited to 'data/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 |