Restaurants Database with 291,000 records

[labrocca]

Here is the table structure.

#
# Table structure for table `tblcrosscategories`
#

CREATE TABLE tblcrosscategories (
  RestaurantLocationID int(11) default NULL,
  CategoryID int(11) default NULL
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `tblrestaurantcategories`
#

CREATE TABLE tblrestaurantcategories (
  RestaurantCategoryID int(11) default NULL,
  Category varchar(35) default NULL,
  category_id int(11) default NULL
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `tblrestaurants`
#

CREATE TABLE tblrestaurants (
  RestaurantID int(11) default NULL,
  RestaurantLocationID int(11) default NULL,
  Name varchar(75) default NULL,
  Address1 varchar(30) default NULL,
  Address2 varchar(20) default NULL,
  City varchar(30) default NULL,
  State char(2) default NULL,
  Zip varchar(5) default NULL,
  PhoneMain varchar(10) default NULL,
  PhoneToll varchar(10) default NULL,
  Phone varchar(10) default NULL,
  Fax varchar(10) default NULL,
  Fax2 varchar(10) default NULL,
  URL varchar(60) default NULL,
  Email varchar(40) default NULL
) TYPE=MyISAM;

There are 291,123 restaurants listed.

http://img76.imageshack.us/img76/1023/restaurants6xh.gif

They are categorized too. This DB is all over the USA. It's an outstanding database and it's mine. I made it ...I did not purchase it. I am the only guy with this particular DB.

Here is an sample of the database. As you can see it's pretty much all over the place and with almost 300,000 records this is going to be a complete site with just a few dynamic sql query pages. Imagine with this DB and about 3 php pages you could have a site with 300,000 dynamic pages!

http://img187.imageshack.us/img187/7454/samplerestaurants0zc.gif


$50 is my asking price for a copy of it. I will also consider trades for video game names or single word .info and .us names. I have not setup a script for this buy any decent coder can do this. I may in the future make a script but I am very busy lately.

PM me and feel free to ask questions

 

[labrocca]

I am still selling this for $50. All PM's have been replied to.

 

[labrocca]

This is to show that I was the original seller of the restaurant DB.

I have this posted at DNF and Digitalpoint as well for some time now. It didn't get any real attention here so I didn't push it. At DP there is a big thread about it as well as my lyrics DB.