[Summary view] [Print] [Text view]

   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);