summaryrefslogtreecommitdiff
path: root/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/sqlite/archives/patch-rename-iwl_prefix.sql')
-rw-r--r--maintenance/sqlite/archives/patch-rename-iwl_prefix.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql b/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql
index fd4c9ec7..6d5b1bfa 100644
--- a/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql
+++ b/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql
@@ -2,4 +2,4 @@
-- Recreates the iwl_prefix for the iwlinks table
--
DROP INDEX IF EXISTS /*i*/iwl_prefix;
-CREATE INDEX IF NOT EXISTS /*i*/iwl_prefix_from_title ON /*_*/iwlinks (iwl_prefix, iwl_from, iwl_title);
+CREATE INDEX IF NOT EXISTS /*i*/iwl_prefix_title_from ON /*_*/iwlinks (iwl_prefix, iwl_title, iwl_from);