Index comments on email

Description

The long-awaited sequel to AO3-5495.

Sometimes, a database admin has to look up comments by email for the Support committee. Comments aren't currently indexed on email. Doing so would make this a bit faster.

Because comments is a hefty table, the migration should use pt-online-schema-change in staging/production (see a recent example).

To test, run the migration on staging and make sure it's successful.

Assignee

Unassigned

Reporter

redsummernight

Roadmap

Comments

Priority

Medium

Affects versions

Fix versions

None

Components

BackEnd

Difficulty

Easy

Milestone

Internal 0.9
Configure