1UP_SQL = """ 2CREATE TABLE tko_iteration_perf_value ( 3 test_idx INT(10) UNSIGNED NOT NULL, 4 iteration INT(11) DEFAULT NULL, 5 description VARCHAR(256) DEFAULT NULL, 6 value FLOAT DEFAULT NULL, 7 stddev FLOAT DEFAULT NULL, 8 units VARCHAR(32) DEFAULT NULL, 9 higher_is_better BOOLEAN NOT NULL DEFAULT TRUE, 10 KEY test_idx (test_idx), 11 KEY description (description), 12 KEY value (value), 13 CONSTRAINT tko_iteration_perf_value_ibfk FOREIGN KEY (test_idx) 14 REFERENCES tko_tests (test_idx) ON DELETE CASCADE 15) ENGINE = InnoDB; 16""" 17 18DOWN_SQL = """ 19DROP TABLE tko_iteration_perf_value; 20""" 21