Wikimedia Bugzilla is closed!

Short description:

Rename two indexes in the Echo extension.  These were renamed for the benefit of SQLite on the foundations Continuous Integration environment which requires index names to be unique not just to a table, but to the entire database.

My review of mariadb's 'ALTER TABLE' statement suggests there is no rename index option(incl in mysql 5.7), so the indexes would need to be dropped and recreated.  We are not sure if its actually worthwhile to rename these indexes in prod, up to you.

Which wikis are affected:

testwiki: maindb & extension1db - maindb is not used but it's good to make it either up to date or just remove all echo tables
test2wiki: maindb
mediawikiwiki: maindb
enwiki: extension1db

Which tables:

echo_event and echo_notification

What is the change to those tables:

CREATE INDEX /*i*/echo_event_type ON /*_*/echo_event (event_type);
DROP INDEX /*i*/event_type ON /*_*/echo_event;

CREATE INDEX /*i*/echo_user_timestamp ON /*_*/echo_notification (notification_user, notification_timestamp);
DROP INDEX /*i*/user_timestamp ON /*_*/echo_notification;


Links to gerrit changes and/or other related bug reports.

https://gerrit.wikimedia.org/r/#/c/64594/
https://gerrit.wikimedia.org/r/#/c/68728/