Combining two requests into one task (T245413: Prepare CentralAuth db for global groups expiration and T245921: Remove redundant global_user_groups.gug_user and global_group_permissions.ggp_group indexes)
ALTER TABLE /*_*/global_user_groups ADD COLUMN gug_expiry varbinary(14) NULL default NULL, ADD INDEX gug_expiry (gug_expiry);
ALTER TABLE global_user_groups DROP INDEX gug_user; ALTER TABLE global_group_permissions DROP INDEX ggp_group;
Combined SQL:
ALTER TABLE global_group_permissions DROP INDEX ggp_group; ALTER TABLE /*_*/global_user_groups ADD COLUMN gug_expiry varbinary(14) NULL default NULL, ADD INDEX gug_expiry (gug_expiry), DROP INDEX gug_user;
Where: centralauth database (s7)
When: At DBA leisure
Backwards compatible: Yes
Tested already: Index removals applied to beta