Page MenuHomePhabricator

Add users_to_rename table to centralauth database
Closed, ResolvedPublic

Description

Short description: The users_to_rename table will contain a list of users who we plan to rename in the SUL finalisation, and their "status": notified on-wiki, notified by email, and finally renamed.

Which wikis are affected: "centralauth" database.

Which tables: users_to_rename

What is the change to those tables: Creation.

Links to gerrit changes and/or other related bug reports.

https://gerrit.wikimedia.org/r/#/c/159266

Schema:

  • Table to store a list of users
  • who will be renamed in the
  • glorious finalization.

CREATE TABLE /*_*/users_to_rename (

  • id utr_id int primary key auto_increment,
  • username utr_name varchar(255) binary not null,
  • wiki the user is on utr_wiki varchar(255) binary not null,
  • bitfield of a user's status
  • could be: notified via email, talk page, and finally: renamed utr_status int default 0

) /*$wgDBTableOptions*/;

CREATE UNIQUE INDEX /*i*/utr_user ON /*_*/users_to_rename (utr_name, utr_wiki);
CREATE INDEX /*i*/utr_notif ON /*_*/users_to_rename (utr_status);


Version: unspecified
Severity: normal

Details

Reference
bz71924

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 3:46 AM
bzimport set Reference to bz71924.
Legoktm created this task.Oct 11 2014, 12:21 AM