File: shoppingcart.sql

/*
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');