Last modified: 2014-06-11 05:31:30 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 T68446, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 66446 - Add centralauth.renameuser_status table
Add centralauth.renameuser_status table
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: Unprioritized normal with 1 vote (vote)
: ---
Assigned To: Sean Pringle
: schema-change
Depends on:
Blocks: 49188 14862
  Show dependency tree / graph
 
Reported: 2014-06-10 19:31 UTC by Kunal Mehta (Legoktm)
Modified: 2014-06-11 05:31 UTC (History)
3 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Kunal Mehta (Legoktm) 2014-06-10 19:31:51 UTC 
Short description: Add centralauth.renameuser_status table

Which wikis are affected: centralauth db

Which tables: renameuser

What is the change to those tables: Creating it

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

Schema:

-- Table for global rename status
CREATE TABLE renameuser_status (
  -- Old name being renamed from
  ru_oldname varchar(255) binary not null,
  -- New name being renamed to
  ru_newname varchar(255) binary not null,
  -- WikiID
  ru_wiki varchar(255) binary not null,
  -- current state of the renaming
  ru_status enum ('queued', 'inprogress', 'failed'),

  KEY (ru_oldname, ru_wiki)
) /*$wgDBTableOptions*/;


Gerrit change #92468
Comment 1 Sean Pringle 2014-06-11 02:33:04 UTC 
On hold pending more info. The change set patch file has UNIQUE KEY (ru_oldname, ru_wiki).
Comment 2 Sean Pringle 2014-06-11 05:26:40 UTC 
Correct definition:

CREATE TABLE renameuser_status (
  -- Old name being renamed from
  ru_oldname varchar(255) binary not null,
  -- New name being renamed to
  ru_newname varchar(255) binary not null,
  -- WikiID
  ru_wiki varchar(255) binary not null,
  -- current state of the renaming
  ru_status enum ('queued', 'inprogress', 'failed'),
  
  UNIQUE KEY `ru_oldname` (`ru_oldname`, `ru_wiki`)
) /*$wgDBTableOptions*/;
Comment 3 Sean Pringle 2014-06-11 05:31:30 UTC 
Done.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links