1125919 - update graphs.m.o and graphs.a.o with sql statements for Yosemite machine names

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Kim Moir [:kmoir] ET]

In bug 1125853, we added sql statements to the sql file for graph server, we need to get these statements deployed to the live databases:

insert into os_list values (55, "MacOSX 10.10);
insert into machines values (NULL, 55, 0, "2.0", "t-yosemite-r5-0001", 1, unix_timestamp());
insert into machines values (NULL, 55, 0, "2.0", "t-yosemite-r5-0002", 1, unix_timestamp());
insert into machines values (NULL, 55, 0, "2.0", "t-yosemite-r5-0003", 1, unix_timestamp());
insert into machines values (NULL, 55, 0, "2.0", "t-yosemite-r5-0001.e", 1, unix_timestamp());
insert into machines values (NULL, 55, 0, "2.0", "t-yosemite-r5-0002.e", 1, unix_timestamp());
insert into machines values (NULL, 55, 0, "2.0", "t-yosemite-r5-0003.e", 1, unix_timestamp());

Comment 1

[Sheeri Cabral [:sheeri]]

I assume the first one is meant to be:
insert into os_list values (55, "MacOSX 10.10");
It's missing a trailing quote.

Though as it turns out, it was already on the stage and production graphs dbs, as were the first three machines. I have inserted the last 3 machines into stage and prod graph dbs.