1 CREATE TABLE clActionTable (
2 id INT NOT NULL AUTO_INCREMENT,
4 change_number INT NOT NULL,
5 patch_number INT NOT NULL,
6 change_source ENUM('internal', 'external') NOT NULL,
7 -- The following ENUM values should match constants.py:CL_ACTIONS
8 action ENUM('picked_up', 'submitted', 'kicked_out', 'submit_failed') NOT NULL,
10 timestamp TIMESTAMP NOT NULL,
13 REFERENCES buildTable(id),
14 INDEX (change_number, change_source),
15 INDEX (change_number, patch_number, change_source)
18 INSERT INTO schemaVersionTable (schemaVersion, scriptName) VALUES
19 (3, '00003_create_claction_table.sql');