insert into productdims (product, version, branch, release) values ('Firefox','3.5.5', '1.9.1', 'major'); insert into productdims (product, version, branch, release) values ('Firefox','3.5.6pre', '1.9.1', 'development');

Need morgamic to approve any/all prod sql.

They are missing the product visibility table -- can you guys add the SQL for that?

It would be better if they provide the start and end dates that define the time window when materialized views should be collected. Or I could guess...

Start date is today. We don't have an end date yet.

In addition to the sql in the initial bug, do this, per the information at http://code.google.com/p/socorro/wiki/TrackNewProductVersion. I am assuming that 90 days is correct. Alterations can be made later, if needed INSERT INTO product_visibility (productdims_id,start_date,end_date) SELECT id, '2009-11-05' as start_date, '2010-02-03' as end_date FROM productdims WHERE product = 'Firefox' AND version = '3.5.5'; INSERT INTO product_visibility (productdims_id,start_date,end_date) SELECT id, '2009-11-05' as start_date, '2010-02-03' as end_date FROM productdims WHERE product = 'Firefox' AND version = '3.5.6pre';

Looks good. Thanks, Frank.

Anything holding this bug up ?

Nope, IT just needs to run it.

All done.