CREATE TABLE `lb_pools` ( `pool_id` int(11) NOT NULL AUTO_INCREMENT, `device_id` int(11) NOT NULL, `pool_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `pool_lb` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `num_members` int(11) NOT NULL, `active_members` int(11) NOT NULL, `pool_conns` int(11) NOT NULL, `pool_bps_in` int(11) NOT NULL, `pool_bps_out` int(11) NOT NULL, PRIMARY KEY (`pool_id`,`pool_name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;