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.

Bug 66446 - Add centralauth.renameuser_status table


Summary:	Add centralauth.renameuser_status table

Status:	RESOLVED FIXED

Product:	Wikimedia
Classification:	Unclassified
Component:	General/Unknown (Other open bugs)
Version:	unspecified
Hardware:	All All

Importance:	Unprioritized normal with 1 vote (vote)
Target Milestone:	---
Assigned To:	Sean Pringle

URL:
Whiteboard:
Keywords:	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)
CC List:	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.

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links