text: 
  CREATE TABLE failureTable (
    id INT NOT NULL AUTO_INCREMENT,
    build_stage_id INT NOT NULL,
    outer_failure_id INT,
    exception_type VARCHAR(240),
    exception_message VARCHAR(240),
    -- This should match constants.EXCEPTION_CATEGORY_ALL_CATEGORIES
    exception_category ENUM('unknown', 'build', 'test', 'infra', 'lab') NOT NULL
      DEFAULT 'unknown',
    extra_info VARCHAR(240),
    timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (id),
    FOREIGN KEY (build_stage_id)
      REFERENCES buildStageTable(id),
    FOREIGN KEY (outer_failure_id)
      REFERENCES failureTable(id)
  );
  
  INSERT INTO schemaVersionTable (schemaVersion, scriptName) VALUES
    (29, '00029_create_failure_table.sql');
  