maintenance/archives/patch-rename-mysql-user_newtalk-indexes.sql

   1 -- T233240: The indexes on `user_newtalk` may be named `un_user_id`/`un_user_ip`
   2 -- or `user_id`/`user_ip`. At least it won't be both or mixed. Rename them to
   3 -- the former.
   4
   5 -- Do not use the /*i*/ hack here!
   6 ALTER TABLE /*_*/user_newtalk
   7         DROP INDEX user_id,
   8         DROP INDEX user_ip,
   9         ADD INDEX un_user_id (user_id),
  10         ADD INDEX un_user_ip (user_ip);