Page MenuHomePhabricator

Store page titles as IDs instead of titles
Closed, ResolvedPublic

Description

The MySQL database that associates WikiProjects with articles stores pages by title, rather than page ID. It should instead use the page ID of the WikiProject and the page ID of the page. This way, articles can be renamed and WikiProjects can be renamed and fewer things get broken.

There should also be a column for namespace; see T116668. The column for namespace will allow us to filter out pages by namespace where appropriate.

Event Timeline

Harej assigned this task to XZise.
Harej raised the priority of this task from to Medium.
Harej updated the task description. (Show Details)
Harej added a project: WikiProject-X.
Harej subscribed.
Harej removed XZise as the assignee of this task.Jun 9 2016, 8:33 PM
Harej added a subscriber: XZise.
Harej raised the priority of this task from Medium to High.Jun 9 2016, 8:37 PM
Earwig claimed this task.
Earwig moved this task from In Progress to Done on the Reports-bot board.
Earwig subscribed.

This is done in the schema, and will be deployed as soon as the new update_project_index script is finished.