blob: f8572b2267481db4241b20aee401a61a2dc317b6 [file] [log] [blame]
UP_SQL = """
CREATE TABLE special_tasks (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
host_id INT NOT NULL REFERENCES hosts(id),
task VARCHAR(64) NOT NULL,
time_requested DATETIME NOT NULL,
is_active TINYINT(1) NOT NULL DEFAULT FALSE,
is_complete TINYINT(1) NOT NULL DEFAULT FALSE,
INDEX special_tasks_host_id (host_id)
) ENGINE=innodb;
"""
DOWN_SQL = """
DROP TABLE special_tasks;
"""