509517 - prod socorro db update execute SQL

Status: RESOLVED FIXED

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

Description

[Austin King [:ozten]]

Please execute the following on production:

INSERT INTO branches (product, version, branch) VALUES ('Firefox', '3.5.2',
'1.9.1');

INSERT INTO productdims (product, version, os_name, release) VALUES ('Firefox',
'3.5.2', 'ALL','major');
INSERT INTO productdims (product, version, os_name, release) VALUES ('Firefox',
'3.5.2', 'Win','major');
INSERT INTO productdims (product, version, os_name, release) VALUES ('Firefox',
'3.5.2', 'Mac','major');

INSERT INTO tcbyurlconfig (productdims_id, enabled) 
  SELECT id, 'Y' FROM productdims WHERE product = 'Firefox' AND version =
'3.5.2' AND os_name = 'ALL';

Comment 1

[Aravind Gottipati [:aravind]]

Done, all of those lines came back with "INSERT 0 1"