X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Fsqlite%2Farchives%2Fpatch-rename-iwl_prefix.sql;h=6d5b1bfad3929a6977685387216e7aa7bd96c097;hb=bd43f2abf608b189db0fe3c70f99c626d978d0b6;hp=fd4c9ec7e0aac8e9b74c9b8776aba498c8991293;hpb=06e63a5843a7989e0aff90edfa3d6be2e6dfb2fb;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql b/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql index fd4c9ec7e0..6d5b1bfad3 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);