cidb/migrations/00035_create_failure_view.sql

CREATE VIEW failureView as
  SELECT f.*, bs.name as stage_name, bs.board, bs.status as stage_status,
         b.id as build_id, b.build_config, b.status as build_status,
         b.final as build_final, b.full_version, b.chrome_version,
         b.sdk_version, b.milestone_version, b.master_build_id
  FROM failureTable f JOIN buildStageTable bs on f.build_stage_id = bs.id
                      JOIN buildTable b on bs.build_id = b.id;

GRANT SHOW VIEW ON cidb.* to bot, readonly, annotator;

INSERT INTO schemaVersionTable (schemaVersion, scriptName) VALUES
  (35, '00035_create_failure_view.sql')