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