cidb/migrations/00042_create_build_message_table.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

CREATE TABLE buildMessageTable (
  id INT NOT NULL AUTO_INCREMENT,
  build_id INT NOT NULL,
  message_type VARCHAR(240),
  message_subtype VARCHAR(240),
  message_value VARCHAR(480),
  timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY(id),
  FOREIGN KEY (build_id)
    REFERENCES buildTable(id)
);


INSERT INTO schemaVersionTable (schemaVersion, scriptName) VALUES
  (42, '00042_create_build_message_table.sql');