Dennis Jeffrey | 2c72396 | 2013-07-12 11:30:56 -0700 | [diff] [blame] | 1 | UP_SQL = """ |
| 2 | CREATE 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 | |
| 18 | DOWN_SQL = """ |
| 19 | DROP TABLE tko_iteration_perf_value; |
| 20 | """ |