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 pl_namespace ON /*_*/pagelinks;
   7 CREATE UNIQUE INDEX pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from);
   8 DROP INDEX tl_namespace ON /*_*/templatelinks;
   9 CREATE UNIQUE INDEX tl_namespace ON /*_*/templatelinks (tl_namespace, tl_title, tl_from);
  10 DROP INDEX il_to ON /*_*/imagelinks;
  11 CREATE UNIQUE INDEX il_to ON /*_*/imagelinks (il_to, il_from);