https://bugzilla.wikimedia.org/show_bug.cgi?id=49593
Web browser: ---
Bug ID: 49593
Summary: Rename two indexes in the Echo extension
Product: Wikimedia
Version: unspecified
Hardware: All
OS: All
Status: NEW
Keywords: schema-change
Severity: normal
Priority: Unprioritized
Component: General/Unknown
Assignee: [email protected]
Reporter: [email protected]
Blocks: 49188
Classification: Unclassified
Mobile Platform: ---
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/
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
