blob: 134c57645774145ead9c00f9537cd55ed812e9e8 [file] [log] [blame]
CREATE_TABLES_SQL = """
CREATE TABLE `test_labels` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`name` varchar(80) NOT NULL,
`description` longtext NOT NULL
);
CREATE TABLE `test_labels_tests` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`testlabel_id` integer NOT NULL REFERENCES `test_labels` (`id`),
`test_id` integer NOT NULL REFERENCES `tests` (`test_idx`),
UNIQUE (`testlabel_id`, `test_id`)
);
"""
DROP_TABLES_SQL = """
DROP TABLE IF EXISTS `test_labels`;
DROP TABLE IF EXISTS `test_labels_tests`;
"""
def migrate_up(manager):
manager.execute_script(CREATE_TABLES_SQL)
def migrate_down(manager):
manager.execute_script(DROP_TABLES_SQL)