UK Takeaways 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:
CREATE TABLE `takeaways` (
`id` bigint(20) NOT NULL auto_increment,
`cat` varchar(50) NOT NULL default '',
`name` varchar(255) character set utf8 collate utf8 NOT NULL default '',
`address1` text character set utf8 collate utf8 NOT NULL,
`address2extra` text character set utf8 collate utf8,
`address3extra` text character set utf8 collate utf8,
`town` text character set utf8 collate utf8,
`country` text character set utf8 collate utf8,
`postcode` text character set utf8 collate utf8,
`telephone` text character set utf8 collate utf8,
PRIMARY KEY (`id`),
KEY `cat_index` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12167 ;
Records: 12.166
Price: 49$
Regards
|
