maintenance/archives/patch-pl-tl-il-nonunique.sql

   1 -- Make reorderings of UNIQUE indices non-UNIQUE
   2 -- Since 1.24, these indices have been non-UNIQUE in tables.sql.
   3 -- However, an earlier update from 1.15 that made the indices
   4 -- UNIQUE was not removed until 1.28 (T78513).
   5
   6 DROP INDEX /*i*/pl_namespace ON /*_*/pagelinks;
   7 CREATE INDEX /*i*/pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from);
   8 DROP INDEX /*i*/tl_namespace ON /*_*/templatelinks;
   9 CREATE INDEX /*i*/tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from);
  10 DROP INDEX /*i*/il_to ON /*_*/imagelinks;
  11 CREATE INDEX /*i*/il_to ON /*_*/imagelinks (il_to, il_from);