1 CREATE TABLE buildTable (
2 id INT NOT NULL AUTO_INCREMENT,
4 buildbot_generation INT NOT NULL,
5 builder_name VARCHAR(80) NOT NULL,
6 waterfall ENUM('chromeos', 'chromiumos', 'chromiumos.tryserver') NOT NULL,
7 build_number INT NOT NULL,
8 build_config VARCHAR(80) NOT NULL,
9 bot_hostname VARCHAR(80) NOT NULL,
10 -- Specifying a DEFAULT value without an ON UPDATE clause allows
11 -- UPDATE queries to other columns that do not automatically update
12 -- start_time to CURRENT_TIMESTAMP
13 start_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
14 finish_time TIMESTAMP,
15 -- The following ENUM values should match
16 -- manifest_version.BuilderStatus.All_STATUSES
17 status ENUM('fail', 'pass', 'inflight', 'missing', 'aborted')
18 DEFAULT 'inflight' NOT NULL,
20 build_type VARCHAR(80),
21 chrome_version VARCHAR(80),
22 milestone_version VARCHAR(80),
23 platform_version VARCHAR(80),
24 full_version VARCHAR(80),
25 sdk_version VARCHAR(80),
26 toolchain_url VARCHAR(240),
28 final BOOL NOT NULL DEFAULT false,
30 FOREIGN KEY (master_build_id)
31 REFERENCES buildTable(id),
32 UNIQUE INDEX (buildbot_generation, builder_name, waterfall, build_number),
33 INDEX (master_build_id)
36 INSERT INTO schemaVersionTable (schemaVersion, scriptName) VALUES
37 (2, '00002_create_build_table.sql');