/*Table structure for table `dealers` */

CREATE TABLE `dealers` (
  `ID` double default NULL,
  `Name` varchar(255) default NULL,
  `Address` varchar(255) default NULL,
  `City` varchar(255) default NULL,
  `State` varchar(255) default NULL,
  `ZIP` int(11) default NULL,
  `Phone` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `dealers` */

insert  into `dealers`(`ID`,`Name`,`Address`,`City`,`State`,`ZIP`,`Phone`) values (1,'Sarat Ford Sales','245 Springfield Street','Agawam','MA',1001,'(413) 786-0430'),(2,'Classic Chevrolet','40 Dickinson St','Amherst','MA',1002,'(413) 253-3444'),(3,'Curry Honda Subaru','767 Memorial Drive','Chicopee','MA',1020,'(888) 670-6449'),(4,'Bob Pion Buick Pontiac GMC','333 Memorial Drive','Chicopee','MA',1020,'(413) 598-8377'),(5,'Family Ford','60 Fuller Road','Chicopee','MA',1020,'(413) 592-1600'),(6,'Topor Dodge','650 Memorial Drive','Chicopee','MA',1020,'(877) 593-3541'),(7,'Orr Chevrolet','505 Memorial Drive','Chicopee','MA',1020,'(413) 592-4641'),(8,'Cernak Buick','102 Northampton St','Easthampton','MA',1027,'(413) 527-1134'),(9,'Fedor Pontiac','228 Northampton Street','Easthampton','MA',1027,'(413) 527-4461'),(10,'Marcotte Ford','1025 Main Street','Holyoke','MA',1040,'(800) 923-9810'),(11,'Gary Rome Hyundai','1000 Main Street','Holyoke','MA',1040,'(888) 637-4279'),(12,'Dana Automotive','968 Bridge Rd','Northampton','MA',1060,'(413) 586-7250'),(13,'Lia Toyota of Northampton','280 King St','Northampton','MA',1060,'(413) 586-8922'),(14,'Steve Lewis Subaru','48 Damon Road','Northampton','MA',1060,'(413) 584-3292'),(15,'Lia Kia','244 King Street','Northampton','MA',1060,'(413) 587-9540'),(16,'Burke-Whitaker Pontiac Cadillac GMC','200 N King St','Northampton','MA',1060,'(413) 584-3883'),(17,'Lia Honda','293 King Street','Northampton','MA',1060,'(413) 586-8626'),(18,'Northampton Ford','55 Damon Road','Northampton','MA',1060,'(413) 584-2400'),(19,'Northampton Dodge','375 South St','Northampton','MA',1060,'(413) 584-3792');