CREATE TABLE `restaurants` (
`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
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `restaurants` VALUES ('1', '2863', 'Big Al's Place', '102 W Brown Street', null, 'BEAVERTON', 'MI', '48612', '5174352094', null, null, null, null, null, null);
INSERT INTO `restaurants` VALUES ('2', '2864', 'Coldwater Lake inn', '5434 w jordan road', null, 'WEIDMAN', 'MI', '48893', '5176443991', null, null, null, null, null, null);
INSERT INTO `restaurants` VALUES ('3', '2873', 'Grizzly's', '9773 olive blvd', null, 'ST LOUIS', 'MO', '63132', '3149776699', null, null, null, null, null, null);
|