Run SQL in AMO production

RESOLVED FIXED

Status

RESOLVED FIXED
11 years ago
4 years ago

People

(Reporter: fligtar, Assigned: oremj)

Tracking

Details

(URL)

(Reporter)

Description

11 years ago
Please run the SQL for AMO 3.5 below as the code that needs this is now on trunk and we'd like the database backups to start having these new fields.

http://wiki.mozilla.org/index.php?title=Update:Developers/Database_Changes&oldid=91521#3.5_Changes
(Assignee)

Updated

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

Comment 1

11 years ago
mysql>  ALTER TABLE `addons_users` ADD `role` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT '5',
    ->  ADD `listed` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1',
    ->  ADD `position` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
Query OK, 6356 rows affected (0.22 sec)
Records: 6356  Duplicates: 0  Warnings: 0

mysql>  ALTER TABLE `addons` ADD `binary` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `externalsoftware` ;
Query OK, 6189 rows affected (0.84 sec)
Records: 6189  Duplicates: 0  Warnings: 0
Status: NEW → RESOLVED
Last Resolved: 11 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.