SQL change for preview.AMO

VERIFIED FIXED

Status

mozilla.org Graveyard
Server Operations
--
minor
VERIFIED FIXED
9 years ago
3 years ago

People

(Reporter: wenzel, Assigned: oremj)

Tracking

Details

(Reporter)

Description

9 years ago
Please run the SQL from attachment 341269 [details] (from bug 432614) on preview.AMO's DB.

It enables the "delete user account" feature, so it can be QAed. (Note: This will have to be run on production also at push time).

Thanks!
(Reporter)

Updated

9 years ago
Depends on: 432614
(Assignee)

Updated

9 years ago
Assignee: server-ops → oremj
(Assignee)

Comment 1

9 years ago
 ALTER TABLE `users` CHANGE `email` `email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
Query OK, 1635209 rows affected (1 min 27.01 sec)
Records: 1635209  Duplicates: 0  Warnings: 0
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
Verified FIXED, as I successfully deleted a user account using https://preview.addons.mozilla.org/en-US/firefox/users/delete, which means this worked.
Status: RESOLVED → VERIFIED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.