423188 - AMO prod DB updates

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Fred Wenzel [:wenzel]]

Please run the following SQL for us on the Remora production database, at your earliest convenience:

1) some SQL from bug 411363:
 ALTER TABLE `addons` ADD `supporturl` INT( 11 ) UNSIGNED NULL DEFAULT NULL AFTER `homepage` ;
 ALTER TABLE `addons` ADD INDEX ( `supporturl` ) ;
 ALTER TABLE `addons` ADD  FOREIGN KEY  (`supporturl`) REFERENCES `translations` (`id`);
 ALTER TABLE `addons` ADD `supportemail` INT( 11 ) UNSIGNED NULL DEFAULT NULL AFTER `homepage` ;
 ALTER TABLE `addons` ADD INDEX ( `supportemail` ) ;
 ALTER TABLE `addons` ADD  FOREIGN KEY  (`supportemail`) REFERENCES `translations` (`id`);

2) two attached SQL files, order *is* important
- attachment 308894 [details] (from bug 416779)
- attachment 309392 [details] (from bug 422636)

Let me know if you have any questions.

Thanks!

Comment 1

[Aravind Gottipati [:aravind]]

Can this go at any time or does this need a downtime window?

morgamic: approval?

Comment 2

[Michael Morgan [:morgamic]]

This can go anytime.

Comment 3

[Aravind Gottipati [:aravind]]

Done.