maintenance/archives/patch-index-renames.sql

   1 --
   2 -- patch-index-renames.sql
   3 --
   4 -- Rename three indices because of naming conflicts
   5
   6 DROP INDEX user_id ON /*_*/user_newtalk;
   7 DROP INDEX user_ip ON /*_*/user_newtalk;
   8 DROP INDEX usertext_timestamp ON /*_*/archive;
   9 CREATE INDEX un_user_id ON /*_*/user_newtalk (user_id);
  10 CREATE INDEX un_user_ip ON /*_*/user_newtalk (user_ip);
  11 CREATE INDEX ar_usertext_timestamp ON /*_*/archive (ar_user_text,ar_timestamp);