/*
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, ' [email protected]', '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');
|
Download
