--
-- Host: localhost    Database: jcrossley
-- ------------------------------------------------------


--
-- Table structure for table `Products`
--

CREATE TABLE `Products` (
  `prod_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `prod_name` varchar(127) DEFAULT NULL,
  `prod_img` varchar(127) DEFAULT NULL,
  `prod_description` varchar(511) DEFAULT NULL,
  `prod_price` decimal(10,2) DEFAULT NULL,
  `prod_rating` tinyint(3) unsigned DEFAULT NULL,
  `prod_sku` char(32) DEFAULT NULL,
  `prod_stock` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`prod_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Products`
--

INSERT INTO `Products` VALUES (1,'Toy','./img/toy.png','The Murbles Outdoor Game 4 Player Set',4.45,4,'123450',3),(2,'Stereo','./img/stereo.png','music player',122.95,5,'123451',4),(3,'Wheel','./img/wheel.png','Toyota Wheel and Tire combo',285.50,3,'123452',0),(4,'Ram','./img/ram.png','laptop Ram',68.95,2,'123453',2),(5,'AndroidCharger','./img/AndroidCharger.png','Android Charger',49.98,1,'123454',7),(6,'Shoes','./img/vans.png','Vans Shoes',49.17,4,'123455',0),(7,'Laptop','./img/laptop.png','ASUS Laptop',1279.37,4,'123456',12),(8,'Clock','./img/clock.png','Atomic Clock',16.87,5,'123457',3);


