File: shopcart.sql

CREATE DATABASE if not exists `shopcart`;

USE `shopcart`;

/*Table structure for table `products` */

DROP TABLE IF EXISTS `products`;

CREATE TABLE `products` (
  `productID` int(11) NOT NULL AUTO_INCREMENT,
  `productName` varchar(50) NOT NULL,
  `productCode` varchar(10) NOT NULL,
  `productPrice` double NOT NULL,
  PRIMARY KEY (`productID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `products` */

LOCK TABLES `products` WRITE;

insert  into `products`(`productID`,`productName`,`productCode`,`productPrice`) values (1,'Tshirt','SRTS',20),(2,'Trousers','SRTR',25.5),(3,'Track Suit','SRTSU',40);