Last modified: 2014-10-13 00:40:32 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T73924, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 71924 - Add users_to_rename table to centralauth database
Add users_to_rename table to centralauth database
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: High normal (vote)
: ---
Assigned To: Sean Pringle
: schema-change
Depends on:
Blocks: sulfinalization 49188
  Show dependency treegraph
 
Reported: 2014-10-11 00:21 UTC by Kunal Mehta (Legoktm)
Modified: 2014-10-13 00:40 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Kunal Mehta (Legoktm) 2014-10-11 00:21:17 UTC
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);
Comment 1 Sean Pringle 2014-10-13 00:40:32 UTC
Done.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links