mozilla/datazilla — pull request #53 by jeads (2012-07-17 20:12:06+00:00)
Title: Perftest schema fixes

This branch fixes several problems with the perftest schema.

1.) Moved `build.machine_id` to `test_run.machine_id`

2.) Moved `build.operating_system_id` to `machine.operating_system_id`

3.) Made `build.test_build_id` a `UNIQUE KEY`

4.) Updated `set_build_data` SQL to use `INSERT SELECT FROM DUAL WHERE NOT EXISTS` strategy

I'm not sure it's worth migrating the existing development databases to have these changes. I'm thinking it would be easier to dump the data for talos, drop all existing perftest databases and recreate all of them using the new schema, then validate that the new incoming talos data looks as expected. None of the other projects are currently using the development instances, everyone is waiting for the production database to become available.