CREATE TABLE `BIZ_APARTMENTS` (
`bizID` INTEGER,
`bizCat` VARCHAR(255),
`bizCatSub` VARCHAR(255),
`bizName` VARCHAR(255),
`bizAddr` VARCHAR(255),
`bizCity` VARCHAR(255),
`bizState` VARCHAR(255),
`bizZip` VARCHAR(255),
`bizPhone` VARCHAR(255),
`bizFax` VARCHAR(255),
`bizEmail` VARCHAR(255),
`bizURL` VARCHAR(255),
`locAreaCode` VARCHAR(3),
`locFIPS` VARCHAR(5),
`locTimeZone` VARCHAR(6),
`locDST` VARCHAR(1),
`locLat` VARCHAR(10),
`locLong` VARCHAR(10),
`locMSA` VARCHAR(5),
`locPMSA` VARCHAR(5),
`locCounty` VARCHAR(30)
) TYPE=MyISAM;
#
# Dumping data for table 'BIZ_APARTMENTS'
#
INSERT INTO `BIZ_APARTMENTS` VALUES (1, 'Apartments', 'Apartment & Home Rental', 'Daleville Real Estate Inc', '433 North Daleville Avenue # A', 'Daleville', 'AL', '36322', '(334)598-4433', '(334)598-6257', 'dalere@snowhill.com', 'www.dalevillerealestate.com', '334', '01045', 'CST', 'Y', '31.2347', '-85.7586', '2180', NULL, 'Dale');
INSERT INTO `BIZ_APARTMENTS` VALUES (2, 'Apartments', 'Apartment Buildings', 'Brittany Place Apartments', '1890 Cathedral Mills Lane Ofc', 'Rock Hill', 'SC', '29732', '(803)328-2818', NULL, NULL, NULL, '803', '45091', 'EST', 'Y', '34.9662', '-81.0862', '1520', NULL, 'York');
INSERT INTO `BIZ_APARTMENTS` VALUES (3, 'Apartments', 'Retirement Apartments & Hotels', 'Cabot Manor Nursing Center', '200 Northport Drive', 'Cabot', 'AR', '72023', '(501)843-6181', NULL, NULL, NULL, '501', '05085', 'CST', 'Y', '34.9494', '-92.0505', '4400', NULL, 'Lonoke');
|