Posts: 13
|
This database contains information about restaurants.
Records: 291123
Structure:
Code:
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;
Example records:
Code:
INSERT INTO `restaurants` VALUES ('54', '2932', 'Gino\'s Pizza', '1402 Lancaster Ave', null, 'WILMINGTON', 'DE', '19805', '3024286000', null, null, null, null, null, null);
INSERT INTO `restaurants` VALUES ('55', '2933', 'Giovanni\'s Place', '2066 New Castle Ave', null, 'NEW CASTLE', 'DE', '19720', '3026545333', null, null, null, null, null, null);
INSERT INTO `restaurants` VALUES ('56', '2934', 'Golden City Restaurant', '796 Old Baltimore Pike', null, 'NEWARK', 'DE', '19702', '3024550553', null, null, null, null, null, null);
INSERT INTO `restaurants` VALUES ('57', '2935', 'Golden Castle', '2722 Concord Pike', null, 'WILMINGTON', 'DE', '19803', '3024787701', null, null, null, null, null, null);
Price: 10$
Buy and download instant: http://it-essence.com/component/page...art/Itemid,26/
|