/*
MySQL Backup
Source Host:           localhost
Source Server Version: 3.23.21-beta
Source Database:       party_shot
Date:                  2004/06/27 11:03:01
*/

use party_shot;
#----------------------------
# Table structure for buyer_info
#----------------------------
create table buyer_info (
   buyer_id int(20) not null default '0',
   name varchar(255) not null,
   address varchar(255),
   city varchar(100),
   state varchar(50),
   zip varchar(10),
   country varchar(50),
   product_cat varchar(255),
   prduct_id int(20),
   buy_date varchar(20),
   qty int(20),
   session_id varchar(255),
   cc_no varchar(50),
   exp_date varchar(20),
   cc_verify varchar(10),
   primary key (buyer_id))
   type=MyISAM;

#----------------------------
# No records for table buyer_info
#----------------------------

#----------------------------
# Table structure for product
#----------------------------
create table product (
   product_id int(11) not null default '0',
   product_name varchar(255),
   description blob,
   image_name varchar(255),
   price double(20,0) not null default '0',
   primary key (product_id))
   type=MyISAM;

#----------------------------
# Records for table product
#----------------------------


insert  into product values 
(1, 'party_shot', null, 'DSCN0544.jpg', '20');
#----------------------------
# Table structure for shipping_info
#----------------------------
create table shipping_info (
   buyer_id int(20) not null default '0',
   name varchar(100),
   address varchar(255),
   city varchar(100),
   state varchar(50),
   zip varchar(10),
   country varchar(100),
   session_id varchar(100),
   primary key (buyer_id))
   type=MyISAM;

#----------------------------
# No records for table shipping_info
#----------------------------

#----------------------------
# Table structure for tshirt
#----------------------------
create table tshirt (
   product_id int(20) not null default '0',
   product_name varchar(255),
   description blob,
   size varchar(50),
   male_female varchar(10),
   image_name varchar(255),
   price double(20,0) not null default '0',
   primary key (product_id))
   type=MyISAM;

#----------------------------
# No records for table tshirt
#----------------------------