Closed Bug 459513 Opened 16 years ago Closed 16 years ago

Execute SQL on AMO DB

Categories

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Product:
Infrastructure & Operations Graveyard
Component:
WebOps: Other
Platform:
All
Other
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: wenzel, Assigned: oremj)

Details

Please execute the SQL from attachment 341269 [details] on prod. AMO's database at your earliest convenience.

It makes the necessary schema changes that should have been executed before the code from bug 432614 was pushed live.

Currently, the out-of-date schema keeps the user deletion feature from working.

-- User impact: As it's a schema change (allow NULL in the email field), the user table will be write locked while that's running. On preview (bug 458380) it took about 1.5 minutes.

CCing morgamic for approval.
a=morgamic
Assignee: server-ops → oremj
mysql> ALTER TABLE `users` CHANGE `email` `email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
Query OK, 2927915 rows affected (2 min 58.77 sec)
Records: 2927915  Duplicates: 0  Warnings: 0
Status: NEW → RESOLVED
Closed: 16 years ago
Resolution: --- → FIXED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.