422035 - Run SQL for AMO databases

Status: RESOLVED FIXED

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

Description

[Michael Morgan [:morgamic]]

Need to run the following SQL for prod, preview.addons.mozilla.org and remora-reskin.stage.mozilla.com:

alter table tags add weight int(11) not null default 0 after application_id;

This simply adds a column to the tags table that will be used in the future for category ordering.

Comment 1

[Michael Morgan [:morgamic]]

Note: change is from bug 412645.

Comment 2

[Aravind Gottipati [:aravind]]

Does this need a downtime window?

Comment 3

[Michael Morgan [:morgamic]]

No it's an added column.

Comment 4

[Michael Morgan [:morgamic]]

Could we run this in the next few hours?

Comment 5

[Jeremy Orem [:oremj]]

mysql> alter table tags add weight int(11) not null default 0 after application_id;
Query OK, 63 rows affected (0.10 sec)
Records: 63  Duplicates: 0  Warnings: 0

Comment 6

[Michael Morgan [:morgamic]]

Did you run it on the other db's mentioned:
Need to run the following SQL for prod, preview.addons.mozilla.org and
remora-reskin.stage.mozilla.com

Comment 7

[Jeremy Orem [:oremj]]

Okay, done.

Comment 8

[Michael Morgan [:morgamic]]

Need some additional SQL from bug 416779:

 ALTER TABLE `addons` ADD `target_locale` VARCHAR( 255 ) NULL AFTER `nominationmessage` , ADD `locale_disambiguation` VARCHAR( 255 ) NULL AFTER `target_locale` ;
 ALTER TABLE `addons` ADD INDEX ( `target_locale` );
 UPDATE `addons` SET `target_locale` = SUBSTRING_INDEX(`guid`, '@', 1) WHERE addontype_id = 3;

Jeremy - could you run this on preview and remora-reskin?

Comment 9

[Jeremy Orem [:oremj]]

mysql>  ALTER TABLE `addons` ADD `target_locale` VARCHAR( 255 ) NULL AFTER
    -> `nominationmessage` , ADD `locale_disambiguation` VARCHAR( 255 ) NULL AFTER
    -> `target_locale` ;

Query OK, 5492 rows affected (1.37 sec)
Records: 5492  Duplicates: 0  Warnings: 0

mysql>  ALTER TABLE `addons` ADD INDEX ( `target_locale` );
Query OK, 5492 rows affected (2.61 sec)
Records: 5492  Duplicates: 0  Warnings: 0

mysql>  UPDATE `addons` SET `target_locale` = SUBSTRING_INDEX(`guid`, '@', 1) WHERE
    -> addontype_id = 3;
Query OK, 73 rows affected (0.26 sec)
Rows matched: 73  Changed: 73  Warnings: 0