PHP Classes

File: shoppingcart.sql

Recommend this page to a friend!
  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: 18 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');