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