frontend/migrations/036_add_special_tasks.py

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;
"""