gistfile1.txt

| load_balancer_nodes | CREATE TABLE `load_balancer_nodes` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `load_balancer_id` int(11) DEFAULT NULL,
  `parent_load_balancer_id` int(11) NOT NULL,
  `port` int(11) NOT NULL,
  `instance_uuid` char(36) DEFAULT NULL,
  `datastore_type` char(16) DEFAULT NULL,
  `private_ip` char(15) DEFAULT NULL,
  `state` char(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `parent_load_balancer_id` (`parent_load_balancer_id`,`port`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 |