blob: 87cd56bf4721a83f10ba5bd178b0421f46f821f3 [file] [log] [blame]
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;
"""