1UP_SQL = """ 2CREATE TABLE `afe_static_host_attributes` ( 3 `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, 4 `host_id` integer NOT NULL, 5 `attribute` varchar(90) NOT NULL, 6 `value` varchar(300) NOT NULL, 7 FOREIGN KEY (host_id) 8 REFERENCES afe_hosts (id) ON DELETE CASCADE, 9 KEY (attribute) 10) ENGINE=InnoDB; 11""" 12 13DOWN_SQL = """ 14DROP TABLE IF EXISTS afe_static_host_attributes; 15""" 16