cidb/migrations/00059_create_buildRequest_table.sql

CREATE TABLE buildRequestTable (
  id INT NOT NULL AUTO_INCREMENT,
  -- build_id of the build which sends the request
  build_id INT NOT NULL,
  -- build_config of the requested build
  request_build_config VARCHAR(80) NOT NULL,
  -- build_args of the requested build
  request_build_args VARCHAR(240) DEFAULT NULL,
  -- buildbucket_id of the requested build
  request_buildbucket_id varchar(80) DEFAULT NULL,
  -- reason of the request
  request_reason ENUM('sanity-pre-cq') NOT NULL,
  -- timestamp of the request
  timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY(id),
  FOREIGN KEY(build_id) REFERENCES buildTable(id),
  INDEX (timestamp)
);

INSERT INTO schemaVersionTable (schemaVersion, scriptName) VALUES
  (59, '00059_create_buildRequest_table.sql');