Hotels SQL Database Dump for MySQL, Microsoft Access and Oracle

Preview
# MySQL dump
#
# Database is ported from MS Access
#--------------------------------------------------------
# Program Version 2.0.46

CREATE DATABASE IF NOT EXISTS `movedb`;
USE `movedb`;

#
# Table structure for table 'BIZ_HOTELS_MOTELS'
#

DROP TABLE IF EXISTS `BIZ_HOTELS_MOTELS`;

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');
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (4, 'Hotels & Motels', 'Hotels', 'Hampton Inn Mobile North-Saraland', '1320 Industrial Parkway', 'Saraland', 'AL', '36571', '(251)679-7953', NULL, NULL, 'www.hamptoninn.com', '251', '01097', 'CST', 'Y', '30.8789', '-88.1101', '5160', NULL, 'Mobile');
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (5, 'Hotels & Motels', 'Motels', 'Best Western Amador Inn', '200 South Highway 49', 'Jackson', 'CA', '95642', '(209)223-0211', NULL, NULL, 'www.bestwestern.com', '209', '06005', 'PST', 'Y', '38.3424', '-120.7516', NULL, NULL, 'Amador');
INSERT INTO `BIZ_HOTELS_MOTELS` VALUES (6, 'Hotels & Motels', 'Hotels', 'Jetmore Motel & RV Park', '209 Main Street', 'Jetmore', 'KS',
To view the full dump, please login
SQL database dumps

Hotels

Navigation

Popular databases
