1 UP_SQL = """ 2 CREATE 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 13 DOWN_SQL = """ 14 DROP TABLE IF EXISTS afe_static_host_attributes; 15 """ 16
