CREATE TABLE `BIZ_HOTELS_MOTELS` (
`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_HOTELS_MOTELS'
#
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (1, 'Hotels & Motels', 'Hotels', 'Holiday Inn Ft Collins', '3836 East Mulberry', 'Fort Collins', 'CO', '80524', '(970)484-4660', '(970)484-2326', NULL, NULL, '970', '08069', 'MST', 'Y', '40.6475', '-105.0476', '2670', NULL, 'Larimer');
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (2, 'Hotels & Motels', 'Motels', 'Americinn', '4520 Highway 29 South', 'Alexandria', 'MN', '56308', '(320)763-6808', NULL, NULL, NULL, '320', '27041', 'CST', 'Y', '45.8551', '-95.4333', NULL, NULL, 'Douglas');
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (3, 'Hotels & Motels', 'Hotels', 'Arbor Suites at the Mall', '1550 East Raynell Place', 'Springfield', 'MO', '65804', '(417)887-8383', NULL, NULL, 'www.arborsuitesmall.com', '417', '29077', 'CST', 'Y', '37.1524', '-93.2555', '7920', NULL, 'Greene');
|