UK Pubs Bars Inns Database is for sale now
Here the fields list which it includes:
1) ID
2) CAT
3) NAME
4) ADDRESS1
5) ADDRESS2EXTRA
6) ADDRESS3EXTRA
7) TOWN
8) COUNTRY
9) POSTCODE
10) TELEPHONE
Address2 and Address3 are extra fields for you.
Structure:
PHP Code:
REATE TABLE `UKpubsbars` ( `id` bigint(20) NOT NULL auto_increment, `cat` varchar(50) NOT NULL default '', `name` varchar(255) NOT NULL default '', `address1` text NOT NULL, `address2extra` text, `address3extra` text, `town` text, `country` text, `postcode` text, `telephone` text, PRIMARY KEY (`id`), KEY `cat_index` (`cat`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=40480 ;
Records: 40.479
Price: 49$
Regards
|