487326 - Update preview.amo database for QA

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Wil Clouser [:clouserw]]

QA needs to verify bugs.  Please make sure all of the 5.0.4 database updates are run on preview.amo:

https://wiki.mozilla.org/Update:Developers/Database_Changes#5.0.4

Comment 1

[Reed Loden [:reed]]

Does this conflict with bug 487321?

Comment 2

[Wil Clouser [:clouserw]]

(In reply to comment #1)
> Does this conflict with bug 487321?

Yep, I wasn't CC'd on that bug.  This one is a superset so let's go with this one.

Comment 4

[Reed Loden [:reed]]

mysql> ALTER TABLE addons ADD COLUMN nominationdate DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
Query OK, 8234 rows affected (1.87 sec)
Records: 8234  Duplicates: 0  Warnings: 0

mysql> UPDATE addons SET nominationdate = modified;
Query OK, 6706 rows affected (0.29 sec)
Rows matched: 8234  Changed: 6706  Warnings: 0

mysql> ALTER TABLE users 
    ->  ADD COLUMN 
    ->    `resetcode` VARCHAR(255) NOT NULL DEFAULT "" AFTER `confirmationcode`,
    ->  ADD COLUMN 
    ->    `resetcode_expires` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `resetcode`;
Query OK, 3271698 rows affected (4 min 24.94 sec)
Records: 3271698  Duplicates: 0  Warnings: 0