cidb/migrations/00003_create_claction_table.sql

CREATE TABLE clActionTable (
  id INT NOT NULL AUTO_INCREMENT,
  build_id INT NOT NULL,
  change_number INT NOT NULL,
  patch_number INT NOT NULL,
  change_source ENUM('internal', 'external') NOT NULL,
  -- The following ENUM values should match constants.py:CL_ACTIONS
  action ENUM('picked_up', 'submitted', 'kicked_out', 'submit_failed') NOT NULL,
  reason VARCHAR(80),
  timestamp TIMESTAMP NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY(build_id)
    REFERENCES buildTable(id),
  INDEX (change_number, change_source),
  INDEX (change_number, patch_number, change_source)
);

INSERT INTO schemaVersionTable (schemaVersion, scriptName) VALUES
  (3, '00003_create_claction_table.sql');