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

   1 --
   2 -- patch-pl-tl-il-unique-index.sql
   3 --
   4 -- Make reorderings of UNIQUE indices UNIQUE as well
   5
   6 DROP INDEX /*i*/pl_namespace ON /*_*/pagelinks;
   7 CREATE UNIQUE INDEX /*i*/pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from);
   8 DROP INDEX /*i*/tl_namespace ON /*_*/templatelinks;
   9 CREATE UNIQUE INDEX /*i*/tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from);
  10 DROP INDEX /*i*/il_to ON /*_*/imagelinks;
  11 CREATE UNIQUE INDEX /*i*/il_to ON /*_*/imagelinks (il_to, il_from);