CREATE TABLE `businessLocations` (
  `bus_id` int(8) NOT NULL,
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `zip` char(10) NOT NULL,
  `city` varchar(128) NOT NULL,
  `state` varchar(8) NOT NULL,
  `city_id` int(8) NOT NULL,
  `add1` varchar(100) NOT NULL,
  `add2` varchar(100) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `fax` varchar(10) NOT NULL,
  `lat` varchar(12) DEFAULT NULL,
  `lon` varchar(12) DEFAULT NULL,
  `primary` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'The businesses primary location',
  PRIMARY KEY (`id`)
) ENGINE=ndbcluster AUTO_INCREMENT=60978 DEFAULT CHARSET=latin1