1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
| 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;
| """
|
|
