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)
|
