1 UP_SQL = """ 2 CREATE 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 13 DOWN_SQL = """ 14 DROP TABLE special_tasks; 15 """ 16
