diff options
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 |