diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-02-06 19:42:04 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-02-06 19:42:04 +0100 |
| commit | 20e9bdea538efea120e4aa48ba4847c28679dc99 (patch) | |
| tree | 9168a76717b3012b8a17c2d808eea0df6bd2fa97 /data/sql | |
| parent | 4d0b2e91c52e4ddae04741931dead86cc52492f5 (diff) | |
| parent | 7fb3ebbf3724050787653afd3f6010760c280a32 (diff) | |
| download | PROJ-20e9bdea538efea120e4aa48ba4847c28679dc99.tar.gz PROJ-20e9bdea538efea120e4aa48ba4847c28679dc99.zip | |
Merge pull request #1916 from rouault/backport_1884_1914_1915
[Backport 6.3] PR #1884 #1914 #1915
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 59cef3bc..2228c809 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1364,6 +1364,8 @@ CREATE TABLE supersession( source TEXT ); +CREATE INDEX idx_supersession ON supersession(superseded_table_name, superseded_auth_name, superseded_code); + CREATE TRIGGER supersession_insert_trigger BEFORE INSERT ON supersession FOR EACH ROW BEGIN |
