| UP_SQL = """ | |
| CREATE TABLE `host_attributes` ( | |
| `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, | |
| `host_id` integer NOT NULL, | |
| `attribute` varchar(90) NOT NULL, | |
| `value` varchar(300) NOT NULL, | |
| FOREIGN KEY (host_id) REFERENCES hosts (id), | |
| KEY (attribute) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
| """ | |
| DOWN_SQL = """ | |
| DROP TABLE IF EXISTS host_attributes; | |
| """ | |
| def migrate_up(manager): | |
| manager.execute_script(UP_SQL) | |
| def migrate_down(manager): | |
| manager.execute_script(DOWN_SQL) |