UK Hotels Database is for sale
Fields:
1) ID
2) CAT
3) HOTEL NAME
4) HOTEL GROUP
5) ADDRESS1
6) ADDRESS2
7) ADDRESS3
8) TOWN / CITY
9) POSTCODE
10) TELEPHONE
11) FAX
12) EMAIL
13) WEBSITE
14) MINIMUM SINGLE ROOM PRICE
15) MAX SINGLE ROOM PRICE
16) MINIMUM DOUBLE ROOM PRICE
17) MAX DOUBLE ROOM PRICE
18) TOTAL ROOMS
19) FAMILY ROOMS
20) ENSUITE ROOMS
21) ANNEX ENSUITE ROOMS
22) LAST DINNER TIME
23) CUISINE
24) LUNCH PRICE
25) DINNER PRICE
26) PARKING SPACES
27) THEATRE
28) CLASSROOM
29) BOARDROOM
30) DELEGATE ROOM PRICE
There're some extra fields(bonus fields), these are:
HOTEL GROUP, ADDRESS2, ADDRESS3, BOARDROOM, DELEGATE ROOM PRICE
Structure:
PHP Code:
CREATE TABLE `UKhotels` (
`id` bigint(20) NOT NULL auto_increment,
`cat` varchar(50) NOT NULL default '',
`hotelname` varchar(255) character set utf8 collate utf8 NOT NULL default '',
`hotelgroup` text character set utf8 collate utf8 NOT NULL,
`address1` text character set utf8 collate utf8,
`address2` text character set utf8 collate utf8,
`address3` text character set utf8 collate utf8,
`town` text character set utf8 collate utf8,
`postcode` text character set utf8 collate utf8,
`telephone` text character set utf8 collate utf8,
`fax` text character set utf8 collate utf8,
`email` text character set utf8 collate utf8,
`website` text character set utf8 collate utf8,
`minsingleroom` text character set utf8 collate utf8,
`maxsingleroom` text character set utf8 collate utf8,
`mindoubleroom` text character set utf8 collate utf8,
`maxdoubleroom` text character set utf8 collate utf8,
`totalrooms` text character set utf8 collate utf8,
`familyrooms` text character set utf8 collate utf8,
`ensuiterooms` text character set utf8 collate utf8,
`annexensuiterooms` text character set utf8 collate utf8,
`lastdinnertime` text character set utf8 collate utf8,
`cuisine` text character set utf8 collate utf8,
`lunchprice` text character set utf8 collate utf8,
`dinnerprice` text character set utf8 collate utf8,
`parkingspaces` text character set utf8 collate utf8,
`theatre` text character set utf8 collate utf8,
`classroom` text character set utf8 collate utf8,
`boardroom` text character set utf8 collate utf8,
`delegateroomrate` text character set utf8 collate utf8,
PRIMARY KEY (`id`),
KEY `cat_index` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7067 ;
Sample:
PHP Code:
INSERT INTO `UKhotels` VALUES (160, 'B', 'Best Western - Reading Moat House', 'Best Western', 'Mill Lane', 'Sindlesham', 'Wokingham', 'Reading', 'RG41 5DF', '+44 (0)118 949 9988', '+44 (0)118 935 1646', 'reading@qmh-hotels.com', 'www.bestwestern.co.uk/readingmoathouse', '144', '170', '144', '170', '100', '9', '100', '0', '10.30pm', 'International', '25', '25', '350', '80', '50', '40', 'N/A');
Records: 7.066
Price: 39$
Regards
