shop.sql

网上购物系统 asp+sql server 2005

insert into s_hand ([fname],[name],[zuti],[neirong],[riqi],[isnew],[del]) 
 select 'tracy','ALL','asdfasd','','2006-1-20 11:12:00',0,0
insert into s_hand ([fname],[name],[zuti],[neirong],[riqi],[isnew],[del]) 
 select 'admin','tracy','','','2008-1-23 12:23:41',0,0
go

delete from s_page
go
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '11','关于我们','','','1'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '12','网站动态','allnews.asp?class=1','','1'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '13','常见问题','','','1'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '14','自定内容','','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '21','新手上路','newmember.asp','','1'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '22','定购方式','','','1'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '23','如何付款','fukuan.asp','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '24','自定内容','','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '31','隐私保护','','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '32','服务保证','','','1'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '33','售后服务','','','1'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '34','自定内容','','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '41','会员中心','my_info.asp','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '42','订单查询','youke_order.asp','','1'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '43','汇款确认','my_huikuan.asp','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '44','自定内容','','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '51','缺货登记','youkemsg.asp','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '52','投诉建议','youkemsg.asp','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '53','友情链接','','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '54','自定内容','','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '98','网站导航工具条','','','0'
insert into s_page ([ID],[txttitle],[txturl],[txtbody],[status]) 
 select '99','网页扩展','','','0'
go

delete from s_key
go
insert into s_key ([keywords],[num],[keydate],[other]) 
 select 'asdf','1','2008-1-23 10:25:13',''
go

delete from s_about
go
insert into s_about ([title],[url],[body],[indexnum],[status]) 
 select '帮助信息','1','','1',1
insert into s_about ([title],[url],[body],[indexnum],[status]) 
 select '帮助信息2','1','','2',1
insert into s_about ([title],[url],[body],[indexnum],[status]) 
 select '帮助信息3','1','','3',1
insert into s_about ([title],[url],[body],[indexnum],[status]) 
 select '帮助信息4','1','','4',1
insert into s_about ([title],[url],[body],[indexnum],[status]) 
 select '帮助信息5','1','','5',1
insert into s_about ([title],[url],[body],[indexnum],[status]) 
 select '帮助信息6','1','','6',1
insert into s_about ([title],[url],[body],[indexnum],[status]) 
 select '帮助信息7','1','','7',1
insert into s_about ([title],[url],[body],[indexnum],[status]) 
 select '帮助信息8','1','','8',1
insert into s_about ([title],[url],[body],[indexnum],[status]) 
 select '帮助信息9','1','','9',1
go

delete from s_buser
go
insert into s_buser ([UserId],[UserName],[UserPassword],[UserQuestion],[UserAnswer],[UserMail],[UserQQ],[UserICQ],[UserMSN],[Address],[City],[Province],[Country],[ZipCode],[Birthday],[TotalLogin],[Sex],[HomePhone],[CompPhone],[Memo],[memo2],[SignDate],[LastLogin],[UserType],[UserKou],[IP],[TJR],[FAV],[totalsum],[jifen],[Status]) 
 select 'echo','echo liu','e10adc3949ba59abbe56e057f20f883e','','','asdf#@.asdfd','2','3','4','asdfasdfasdf','6','5','中国','asdfasdf','asd','0','1','asdfasdfasdf','1','','','2007-12-19 17:33:53','2007-12-19 17:33:53','','','127.0.0.1','','','0','0','0'
insert into s_buser ([UserId],[UserName],[UserPassword],[UserQuestion],[UserAnswer],[UserMail],[UserQQ],[UserICQ],[UserMSN],[Address],[City],[Province],[Country],[ZipCode],[Birthday],[TotalLogin],[Sex],[HomePhone],[CompPhone],[Memo],[memo2],[SignDate],[LastLogin],[UserType],[UserKou],[IP],[TJR],[FAV],[totalsum],[jifen],[Status]) 
 select 'tracy','陈月','e10adc3949ba59abbe56e057f20f883e','找回密码的问','e10adc3949ba59abbe56e057f20f883e','[e-mail]','2','3','4','青岛福州南路8号301','6','55','中国','266000','7','13','0','13012345678','1','','','2008-1-17 16:41:33','2008-1-23 12:28:24','','','127.0.0.1','','''PF51128'', ''PF51114''','0','0','1'
go

delete from s_pinglun
go
insert into s_pinglun ([prodid],[IP],[mail],[name],[adddate],[nr],[jibie],[status]) 
 select 'PF51130','127.0.0.1','','tracy2','2007-10-10','','5','1'
insert into s_pinglun ([prodid],[IP],[mail],[name],[adddate],[nr],[jibie],[status]) 
 select 'PF51130','127.0.0.1','','tracy2','2007-12-17 13:51:34','','5','1'
insert into s_pinglun ([prodid],[IP],[mail],[name],[adddate],[nr],[jibie],[status]) 
 select 'PF51132','127.0.0.1','','tracy2','2007-12-17 14:47:55','','3','1'
insert into s_pinglun ([prodid],[IP],[mail],[name],[adddate],[nr],[jibie],[status]) 
 select 'PF51128','127.0.0.1','','aasdfasf','2007-12-17 16:51:35','','1','1'
go

delete from s_news
go
insert into s_news ([uup],[NewsTitle],[NewsContain],[NewsClass],[PubDate],[OffDate],[Source],[Author],[Publisher],[Online],[cktimes]) 
 select '1','本站的批发细则，和相关信息！','','1','2005-6-19 15:23:00','2010-10-20 15:23:00','精品女装,服装批发,饰品批发,精美首饰,个性定制。','','',1,'72'
insert into s_news ([uup],[NewsTitle],[NewsContain],[NewsClass],[PubDate],[OffDate],[Source],[Author],[Publisher],[Online],[cktimes]) 
 select '1','本站的退还货承诺！','','1','2005-6-19 15:31:00','2010-10-20 15:31:00','精品女装,服装批发,饰品批发,精美首饰,个性定制。','','',1,'25'
insert into s_news ([uup],[NewsTitle],[NewsContain],[NewsClass],[PubDate],[OffDate],[Source],[Author],[Publisher],[Online],[cktimes]) 
 select '0','秋季搭配小技巧：一点就出众！','','1','2005-10-19 15:48:00','2010-10-20 15:48:00','精品女装,服装批发,饰品批发,精美首饰,个性定制。','','',1,'5'
insert into s_news ([uup],[NewsTitle],[NewsContain],[NewsClass],[PubDate],[OffDate],[Source],[Author],[Publisher],[Online],[cktimes]) 
 select '0','衣着修饰体形小技巧 ！','','1','2005-10-19 15:51:00','2010-10-20 15:51:00','精品女装,服装批发,饰品批发,精美首饰,个性定制。','','',1,'52'
go

delete from s_setup
go
insert into s_setup ([pages],[pages1],[mailyes],[mailyes1],[html],[view],[view1],[maxlength],[book_jianju],[bad],[huifutishi],[huifucolor],[other]) 
 select '10','8','1','1','0','1','1','200','10','','客服回复','RED',''
go

delete from s_book
go
insert into s_book ([UserName],[QQ],[pic],[face],[URL],[UserMail],[Comments],[Postdate],[Replay],[Online],[IP],[top]) 
 select '晴空','','2','1','http://','','','2005-9-13 12:50:00','','1','60.176.75.135','0'
insert into s_book ([UserName],[QQ],[pic],[face],[URL],[UserMail],[Comments],[Postdate],[Replay],[Online],[IP],[top]) 
 select '大灰狼','','10','1','http://','','','2005-9-15 17:21:00','','1','219.134.100.187','0'
insert into s_book ([UserName],[QQ],[pic],[face],[URL],[UserMail],[Comments],[Postdate],[Replay],[Online],[IP],[top]) 
 select '无雨彩虹','','4','1','http://','','','2005-9-19 9:13:00','','1','218.90.152.5','0'
insert into s_book ([UserName],[QQ],[pic],[face],[URL],[UserMail],[Comments],[Postdate],[Replay],[Online],[IP],[top]) 
 select '小小卡哇依','','6','1','http://','','','2005-9-22 13:34:00','','1','222.68.39.16','0'
insert into s_book ([UserName],[QQ],[pic],[face],[URL],[UserMail],[Comments],[Postdate],[Replay],[Online],[IP],[top]) 
 select '只爱周杰伦','','8','2','http://','','','2005-9-27 15:55:00','','1','221.216.180.77','0'
insert into s_book ([UserName],[QQ],[pic],[face],[URL],[UserMail],[Comments],[Postdate],[Replay],[Online],[IP],[top]) 
 select 'dirkzhu','18223484','3','10','http://','[e-mail]','','2005-10-19 9:20:00','','1','210.77.128.22','0'
insert into s_book ([UserName],[QQ],[pic],[face],[URL],[UserMail],[Comments],[Postdate],[Replay],[Online],[IP],[top]) 
 select 'df','','7','16','http://','df@12.12','','2006-1-19 9:20:00','','1','127.0.0.1','0'
insert into s_book ([UserName],[QQ],[pic],[face],[URL],[UserMail],[Comments],[Postdate],[Replay],[Online],[IP],[top]) 
 select 'tracy2','','1','1','http://','[e-mail]','','2007-12-17 12:53:00','','1','127.0.0.1','0'
insert into s_book ([UserName],[QQ],[pic],[face],[URL],[UserMail],[Comments],[Postdate],[Replay],[Online],[IP],[top]) 
 select 'tracy2','','9','12','http://','','','2007-12-17 14:49:00','','1','127.0.0.1','0'
insert into s_book ([UserName],[QQ],[pic],[face],[URL],[UserMail],[Comments],[Postdate],[Replay],[Online],[IP],[top]) 
 select 'tracy','','7','13','http://','','','2007-12-17 17:03:29','','1','127.0.0.1','0'
go

delete from s_produc
go
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51110','商品名称','霏链','质    地','','颜    色','银色','尺    码','未分尺码','市场价',86,'会员价',38,'pic/digi/PF51110.jpg','0','商品简介','','商品介绍','','服饰用品','装饰',1,'2005-10-17 2:59:00','2005-10-17 2:54:00','67',1,1,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51111','商品名称','琥珀','质    地','','颜    色','','尺    码','未分尺码','市场价',75,'会员价',36,'pic/digi/PF51111.jpg','0','商品简介','','商品介绍','','服饰用品','装饰',1,'2005-10-17 3:22:00','2005-10-17 3:22:00','11',1,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51112','商品名称','雪孩子','质    地','纯棉','颜    色','白色','尺    码','S,M.','市场价',198,'会员价',45,'pic/digi/PF51112.jpg','0','商品简介','','商品介绍','','服饰用品','服装',1,'2005-10-18 13:35:00','2005-10-18 13:35:00','55',1,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51113','商品名称','VIENNOIS','质    地','金丝绒','颜    色','黑色，咖啡色','尺    码','均码','市场价',238,'会员价',56,'pic/digi/PF51113.jpg','0','商品简介','','商品介绍','','服饰用品','服装',1,'2005-10-18 13:54:00','2005-10-18 13:54:00','58',1,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51114','商品名称','油毡钉','质    地','钢','颜    色','图','尺    码','5cm','市场价',238,'会员价',56,'pic/digi/0005.jpg','0','商品简介','','商品介绍','','标准件','各种钉子',1,'2005-10-18 13:57:00','2005-10-18 13:57:00','61',1,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51115','商品名称','VIENNOIS','质    地','金丝绒','颜    色','金绿色','尺    码','均码','市场价',238,'会员价',56,'pic/digi/PF51115.jpg','0','商品简介','','商品介绍','','服饰用品','服装',1,'2005-10-18 14:02:00','2005-10-18 14:02:00','74',0,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51116','商品名称','化蝶','质    地','金丝绒','颜    色','图色','尺    码','均码','市场价',108,'会员价',32,'pic/digi/PF51116.jpg','0','商品简介','','商品介绍','','服饰用品','服装',1,'2005-10-18 14:09:00','2005-10-18 14:09:00','85',0,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51117','商品名称','雪色披肩','质    地','天鹅绒','颜    色','白色','尺    码','均码','市场价',285,'会员价',118,'pic/digi/0008.jpg','0','商品简介','','商品介绍','','服饰用品','服装',1,'2005-10-18 14:27:00','2005-10-18 14:27:00','161',0,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51118','商品名称','直排钉','质    地','钢','颜    色','图色','尺    码','均码','市场价',118,'会员价',58,'pic/digi/0009.jpg','0','商品简介','','商品介绍','','标准件','各种钉子',1,'2005-10-18 14:41:00','2005-10-18 14:41:00','94',1,1,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51119','商品名称','家俱钉','质    地','钢','颜    色','图','尺    码','全','市场价',169,'会员价',48,'pic/digi/0010.jpg','0','商品简介','','商品介绍','','标准件','各种钉子',1,'2005-10-18 14:50:00','2005-10-18 14:50:00','49',1,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51120','商品名称','家俱钉','质    地','钢','颜    色','图色','尺    码','不限','市场价',169,'会员价',48,'pic/digi/0011.jpg','0','商品简介','','商品介绍','','未归类','未归类',1,'2005-10-18 14:56:00','2005-10-18 14:56:00','76',1,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51121','商品名称','夏日阳光','质    地','棉','颜    色','图色','尺    码','S','市场价',178,'会员价',56,'pic/digi/PF51121.jpg','0','商品简介','','商品介绍','','服饰用品','服装',1,'2005-10-18 15:01:00','2005-10-18 15:01:00','91',0,1,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51126','商品名称','码钉','质    地','钢','颜    色','棕色 黑色','尺    码','不限','市场价',158,'会员价',35,'pic/digi/0016.jpg','0','商品简介','','商品介绍','','标准件','各种钉子',1,'2005-10-18 21:15:00','2005-10-18 21:15:00','95',0,1,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51127','商品名称','射钉','质    地',' ','颜    色','图色','尺    码','末分尺码','市场价',85,'会员价',20,'pic/digi/0017.jpg','0','商品简介','','商品介绍','','标准件','各种钉子',1,'2005-10-18 21:27:00','2005-10-18 21:27:00','112',0,1,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51128','商品名称','双帽钉','质    地','钢','颜    色','图色','尺    码','不限','市场价',158,'会员价',45,'pic/digi/0018.jpg','0','商品简介','','商品介绍','','标准件','各种钉子',1,'2005-10-18 21:43:00','2005-10-18 21:43:00','219',1,1,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51129','商品名称','普通圆钉','质    地','钢','颜    色','银色，黑色','尺    码','不限','市场价',98,'会员价',20,'pic/digi/0019.jpg','0','商品简介','','商品介绍','','标准件','各种钉子',1,'2005-10-18 21:51:00','2005-10-18 21:51:00','98',1,1,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51130','商品名称','秋季物语','质    地','棉绒','颜    色','浅卡琪色','尺    码','均码','市场价',198,'会员价',58,'pic/digi/0020.jpg','0','商品简介','','商品介绍','','服饰用品','服装',1,'2005-10-18 21:57:00','2005-10-18 21:57:00','104',0,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51131','商品名称','彩虹','质    地','仿琉璃','颜    色','图色','尺    码','末分尺码','市场价',78,'会员价',18,'pic/digi/0021.jpg','0','商品简介','','商品介绍','','服饰用品','装饰',1,'2005-10-18 22:01:00','2005-10-18 22:01:00','8',0,1,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51132','商品名称','果绿T恤','质    地','棉','颜    色','图色','尺    码','均码','市场价',96,'会员价',30,'pic/digi/PF51132.jpg','0','商品简介','','商品介绍','','服饰用品','服装',1,'2005-10-18 23:16:00','2005-10-18 23:16:00','103',0,1,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51133','商品名称','韩日流行新款外套','质    地','棉毛','颜    色','图色','尺    码','均码','市场价',258,'会员价',68,'pic/digi/0023.jpg','0','商品简介','','商品介绍','','服饰用品','服装',1,'2005-10-18 23:19:00','2007-12-25 15:52:58','102',1,0,1,''
insert into s_produc ([ProdIdtext],[ProdId],[ProdNametext],[ProdName],[Modeltext],[Model],[Prodtext1],[Prod1],[Prodtext2],[Prod2],[PriceListtext],[PriceList],[PriceOrigintext],[PriceOrigin],[ImgPrev],[more_pic],[ProdDisctext],[ProdDisc],[MemoSpectext],[MemoSpec],[LarCode],[MidCode],[Online],[AddDate],[TJDate],[ClickTimes],[Remark],[tejia],[Quantity],[other]) 
 select '商品编号','PF51134','商品名称','汽动钢排钉','质    地','钢','颜    色','图色','尺    码','10cm','市场价',100,'会员价',50,'pic/digi/PF51134_sml.jpg','0','商品简介','','商品介绍','','标准件','各种钉子',1,'2005-10-18 23:41:00','2005-10-18 23:41:00','19',1,0,1,''
go

delete from s_adv
go
insert into s_adv ([ID],[indexnum],[title],[link]) 
 select '1','1','滚动信息1','工'
insert into s_adv ([ID],[indexnum],[title],[link]) 
 select '2','2','滚动信息2',''
insert into s_adv ([ID],[indexnum],[title],[link]) 
 select '3','3','滚动信息3',''
go


delete from s_orderList
go
delete from s_order
go