Samples for Restaurants Database
Table Structure:
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;
Samples:
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;
Samples:



