We should create a separate table for storing WikiProject names (with an autoincremented ID), and then reference that ID from the main page_assessments table. That will keep us from storing duplicate data in the page_assessments table and also allow us to have a much smaller index.
We will also need to update the API code and tests to accommodate this change.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | None | T120219 PageAssessments deployment to WMF wikis | |||
| Resolved | Niharika | T130844 Move WikiProject names to separate table for PageAssessments |
Change 283196 had a related patch set uploaded (by Niharika29):
Move wikiprojects to a separate table in PageAssessments extension
@Niharika: Please build this on top of https://gerrit.wikimedia.org/r/#/c/263575/ rather than as a new branch.
Change 283196 abandoned by Kaldari:
Move wikiprojects to a separate table in PageAssessments extension
Reason:
Squashed into https://gerrit.wikimedia.org/r/#/c/279130/
@Niharika: I did some testing and it looks like the database functions are already case insensitive, so we don't have to worry about it. Also, per Brad's advice, I went ahead and squashed the 3 patches into 1 patch. That should make things less confusing.