1UP_SQL = """ 2CREATE TABLE special_tasks ( 3 id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 4 host_id INT NOT NULL REFERENCES hosts(id), 5 task VARCHAR(64) NOT NULL, 6 time_requested DATETIME NOT NULL, 7 is_active TINYINT(1) NOT NULL DEFAULT FALSE, 8 is_complete TINYINT(1) NOT NULL DEFAULT FALSE, 9 INDEX special_tasks_host_id (host_id) 10) ENGINE=innodb; 11""" 12 13DOWN_SQL = """ 14DROP TABLE special_tasks; 15""" 16