def migrate_up(manager):
    manager.execute_script(CREATE_TABLE_SQL)

def migrate_down(manager):
    manager.execute_script(DROP_TABLE_SQL)


CREATE_TABLE_SQL = """
-- test iteration attributes (key value pairs at an iteration level)
CREATE TABLE iteration_attributes (
test_idx int(10) unsigned NOT NULL,     -- ref to test table
FOREIGN KEY (test_idx) REFERENCES tests(test_idx) ON DELETE CASCADE,
iteration INTEGER,                      -- integer
attribute VARCHAR(30),                  -- attribute name (e.g. 'run_id')
value VARCHAR(100),                     -- attribute value
KEY `test_idx` (`test_idx`)
) TYPE=InnoDB;
"""

DROP_TABLE_SQL = """
DROP TABLE iteration_attributes;
"""