sportdb数据库1.sql

一个自行开发的网上商店一个自行开发的网上商店一个自行开发的网上商店

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','NS-9000','纳米科技',1690,1180,10,10,'images/productimg/na9000.jpg','有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','NS-7700','纳米科技',1570,1120,10,'images/productimg/racket_ns7700.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','NS-7000(新款)','纳米科技',1500,1070,10,'images/productimg/racket_ns7000new_bbe.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','NS-5000','纳米科技',1150,840,10,'images/productimg/？.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-SB（限量版纪念拍）','钛装甲合金',2380,1780,10,'images/productimg/at_sb.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-900-P','钛装甲合金',1680,1180,10,'images/productimg/at-900P.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-900-T','钛装甲合金',1980,1180,10,'images/productimg/at-900.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-800-OF(进攻型)','钛装甲合金',1590,1080,10,'images/productimg/at800df_bbe.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-800-DE(防守型)','钛装甲合金',1680,1180,10,'images/productimg/at800of_bbe.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-700(新款)','钛装甲合金',1450,980,10,'images/productimg/racket_at700new.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-700(旧款)','钛装甲合金',1540,1080,10,'images/productimg/at700_bbe.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-500','钛装甲合金',1150,780,10,'images/productimg/racket_at500_grey.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-300','钛装甲合金',1540,1080,10,'images/productimg/at300.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-250','钛装甲合金',1540,1080,10,'images/productimg/racket_at250.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','AT-150','装甲合金',1540,1080,10,'images/productimg/racket_at150.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-100','高碳/超钛',1500,950,10,'images/productimg/ra_mp100.jpg',10,'有现货，（送线）')



--
insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-99','高碳/超钛',1450,950,10,'images/productimg/mp99_bbe.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-88','高碳/超钛',1150,780,10,'images/productimg/mp88_blue.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-66','高强碳素',970,680,10,'images/productimg/mp66.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-44','高强碳素',950,660,10,'images/productimg/mp-44.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-33','高强碳素',680,540,10,'images/productimg/mp33.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-29','全碳/钛',630,460,10,'images/productimg/racket_mp29_bbe.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-28','全碳/钛',630,460,10,'images/productimg/mp28control.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-25','全碳/钛',590,420,10,'images/productimg/mp25power.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-23','全碳素',540,410,10,'images/productimg/mp23power.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-22','全碳素',540,410,10,'images/productimg/ra_mp22.jpg',10,'有现货，（送线）')

insert into product_Tab (psortid,pbrandid,productname,producttype,
marketprice,memberprice,amout,image1,productpoint,remark)
 values ('5001','2001','MP-21','全碳素',520,370,10,'images/productimg/racket_mp21_bbe.jpg',10,'有现货，（送线）')