UP_SQL = """
CREATE TABLE `afe_static_host_attributes` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `host_id` integer NOT NULL,
    `attribute` varchar(90) NOT NULL,
    `value` varchar(300) NOT NULL,
    FOREIGN KEY (host_id)
    REFERENCES afe_hosts (id) ON DELETE CASCADE,
    KEY (attribute)
) ENGINE=InnoDB;
"""

DOWN_SQL = """
DROP TABLE IF EXISTS afe_static_host_attributes;
"""