Closed Bug 436393 Opened 16 years ago Closed 16 years ago

Run SQL in AMO production

Categories

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

All
Other
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: fligtar, Assigned: oremj)

References

()

Details

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: server-ops → oremj
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
Closed: 16 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.