Closed Bug 487326 Opened 15 years ago Closed 15 years ago

Update preview.amo database for QA

Categories

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

Product:
mozilla.org Graveyard
Component:
Server Operations
Platform:
All
Other
Type:
task
Priority:
Not set
Severity:
critical

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: clouserw, Assigned: reed)

References

Details

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
Does this conflict with bug 487321?
(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.
Assignee: server-ops → 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
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.