Closed Bug 436393 Opened 17 years ago Closed 17 years ago

Run SQL in AMO production

Categories

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

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

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: fligtar, Assigned: oremj)

References

(
URL
)

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: 17 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.