Socorro:Rapid Betas:Database Work

Outline of tasks to be performed:

1. migrate productdims to product_versions
   1. select versions to migrate
      1. test migrating all versions after FF 3.0, first
      2. if that doesn't work, select versions
   2. copy versions into product_versions
   3. modify product_info, similar views
   4. modify update_products()
   5. modify update_reports_clean()
2. purge oldtcbs
   1. disable old cron jobs -- rhelmer
   2. drop oldtcbs tables
      • alexa_topsites
      • builds
      • frames
      • osdims
      • product_visibility
      • productdims
      • productdims_version_sort
      • release_build_type_map
      • signature_build
      • signature_first
      • signature_bugs_rollup
      • signature_productdims
      • top_crashes_by_signature
      • top_crashes_by_url
      • top_crashes_by_url_signature
      • urldims
3. create testable dump of database
   1. create per-object dump of above
   2. clean up per-object dump
   3. create automated load script for the database
   4. create test data for automated load script
   5. add test framework loader (pgtap).
4. overhaul tcbs, daily crash views
   1. create home_page_graph view
   2. combine/normalize product_adu + daily_crashes.
   3. add remaining TCBS data to tcbs view
      1. use set-returning function?
   4. modify cron jobs
5. Accomodate rapid beta versions
   1. add column to products
   2. modify update_products()
   3. modify update_reports_clean()
6. Create new by-build views
   1. create home_page_graph_build & SPs
   2. create daily_graph_build & SPs
   3. create tcbs_build & SPs