UP_SQL = """
CREATE TABLE tko_iteration_perf_value (
  test_idx INT(10) UNSIGNED NOT NULL,
  iteration INT(11) DEFAULT NULL,
  description VARCHAR(256) DEFAULT NULL,
  value FLOAT DEFAULT NULL,
  stddev FLOAT DEFAULT NULL,
  units VARCHAR(32) DEFAULT NULL,
  higher_is_better BOOLEAN NOT NULL DEFAULT TRUE,
  KEY test_idx (test_idx),
  KEY description (description),
  KEY value (value),
  CONSTRAINT tko_iteration_perf_value_ibfk FOREIGN KEY (test_idx)
      REFERENCES tko_tests (test_idx) ON DELETE CASCADE
) ENGINE = InnoDB;
"""

DOWN_SQL = """
DROP TABLE tko_iteration_perf_value;
"""