Login   Register  
PHP Classes
elePHPant
Icontem

File: shopcart.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of RAZA  >  shopcart  >  shopcart.sql  >  Download  
File: shopcart.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL Script
Class: shopcart
Manage a shopping cart stored in a MySQL database
Author: By
Last change:
Date: 5 years ago
Size: 658 bytes
 

Contents

Class file image Download
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);