Login   Register  
PHP Classes
elePHPant
Icontem

File: shoppingcart.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of DavidLanz  >  Hippo Shopping Cart  >  shoppingcart.sql  >  Download  
File: shoppingcart.sql
Role: Auxiliary data
Content type: text/plain
Description: sql schema and demo data
Class: Hippo Shopping Cart
Manage shopping cart of products stored in MySQL
Author: By
Last change:
Date: 9 years ago
Size: 1,342 bytes
 

Contents

Class file image Download
/*
MySQL Backup
Source Host:           192.168.11.254
Source Server Version: 4.0.20a-nt
Source Database:       shoppingcart
Date:                  2005/07/25 11:11:04
*/

use shoppingcart;
SET FOREIGN_KEY_CHECKS=0;
#----------------------------
# Table structure for customer_detail
#----------------------------
CREATE TABLE `customer_detail` (
  `f_customer_id` int(11) NOT NULL auto_increment,
  `f_email` varchar(200) NOT NULL default '',
  `f_nickname` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`f_customer_id`)
) TYPE=MyISAM;
#----------------------------
# Records for table customer_detail
#----------------------------


insert  into customer_detail values 
(1, 'davidlanz@mail.com', 'DavidLanz');
#----------------------------
# Table structure for products_detail
#----------------------------
CREATE TABLE `products_detail` (
  `f_products_audo_id` int(11) NOT NULL auto_increment,
  `f_products_id` varchar(100) NOT NULL default '',
  `f_products_name` varchar(100) NOT NULL default '',
  `f_products_price` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`f_products_audo_id`)
) TYPE=MyISAM;
#----------------------------
# Records for table products_detail
#----------------------------


insert  into products_detail values 
(1, 'a123', 'piano', '199'), 
(2, 'a456', 'car', '299');