https://bugzilla.wikimedia.org/show_bug.cgi?id=71924
Bug ID: 71924
Summary: Add users_to_rename table to centralauth database
Product: Wikimedia
Version: unspecified
Hardware: All
OS: All
Status: ASSIGNED
Keywords: schema-change
Severity: normal
Priority: Unprioritized
Component: General/Unknown
Assignee: [email protected]
Reporter: [email protected]
Blocks: 35707, 49188
Web browser: ---
Mobile Platform: ---
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);
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
