shop.sql

网上购物系统 asp+sql server 2005

	[newprod_num] [smallint] ,
	[renmen_num] [smallint] ,
	[fenlei_num] [smallint] ,
	[mosi] [smallint] ,
	[pic_xiaogao] [nvarchar] (1) ,
	[quehuo] [nvarchar] (50) ,
	[wujiage] [nvarchar] (50) ,
	[huiyuanjia] [nvarchar] (50) ,
	[lar_color] [nvarchar] (10) ,
	[mid_color] [nvarchar] (10) ,
	[index_tishi] [nvarchar] (1) ,
	[tree_num] [smallint] ,
	[tree_view] [smallint] ,
	[tree_display] [smallint] ,
	[reg] [smallint] ,
	[bbs] [smallint] ,
	[menu] [smallint] ,
	[topmenu] [nvarchar] (200) ,
	[newsmove] [smallint] ,
	[news_skin] [nvarchar] (1) ,
	[kf_color] [nvarchar] (10) ,
	[pei1] [nvarchar] (50) ,
	[pei2] [nvarchar] (50) ,
	[pei3] [nvarchar] (50) ,
	[pei4] [nvarchar] (50) ,
	[pei5] [nvarchar] (50) ,
	[pei6] [nvarchar] (50) ,
	[fei1] [smallint] ,
	[fei2] [smallint] ,
	[fei3] [smallint] ,
	[fei4] [smallint] ,
	[fei5] [smallint] ,
	[fei6] [smallint] ,
	[mianyoufei] [smallint] ,
	[mianyoufei_msg] [nvarchar] (50) ,
	[newstitle1] [nvarchar] (50) ,
	[newstitle2] [nvarchar] (50) ,
	[newstitle3] [nvarchar] (50) ,
	[newstitle4] [nvarchar] (50) ,
	[newstitle5] [nvarchar] (50) ,
	[kaiguan] [smallint] ,
	[guanbi] [nvarchar] (200) ,
	[reg_xieyi] [nvarchar] (200) ,
	[lockip] [nvarchar] (1) ,
	[IP] [nvarchar] (200) ,
	[other1] [nvarchar] (100) ,
	[other2] [nvarchar] (50) 
)
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[s_key]') AND type in (N'U'))
DROP TABLE [dbo].[s_key]
GO
CREATE TABLE [dbo].[s_key] (
	[keywords] [nvarchar] (100) PRIMARY KEY,
	[num] [int] ,
	[keydate] [datetime] ,
	[other] [nvarchar] (50) 
)
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[s_manage]') AND type in (N'U'))
DROP TABLE [dbo].[s_manage]
GO
CREATE TABLE [dbo].[s_manage] (
	[id] [int]  PRIMARY KEY,
	[username] [nvarchar] (50) ,
	[password] [nvarchar] (50) 
)
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[s_page]') AND type in (N'U'))
DROP TABLE [dbo].[s_page]
GO
CREATE TABLE [dbo].[s_page] (
	[ID] [int]  PRIMARY KEY,
	[txttitle] [nvarchar] (50) ,
	[txturl] [nvarchar] (200) ,
	[txtbody] [ntext] ,
	[status] [char] (1) 
) TEXTIMAGE_ON [PRIMARY]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[s_setup]') AND type in (N'U'))
DROP TABLE [dbo].[s_setup]
GO
CREATE TABLE [dbo].[s_setup] (
	[ID] [int] IDENTITY (1, 1) PRIMARY KEY,
	[pages] [int] ,
	[pages1] [int] ,
	[mailyes] [nvarchar] (50) ,
	[mailyes1] [nvarchar] (50) ,
	[html] [nvarchar] (50) ,
	[view] [nvarchar] (50) ,
	[view1] [nvarchar] (50) ,
	[maxlength] [int] ,
	[book_jianju] [int] ,
	[bad] [ntext] ,
	[huifutishi] [nvarchar] (50) ,
	[huifucolor] [nvarchar] (50) ,
	[other] [nvarchar] (50) 
)
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[type]') AND type in (N'U'))
DROP TABLE [dbo].[type]
GO
CREATE TABLE [dbo].[type] (
	[Status] [nvarchar] (3) PRIMARY KEY ,
	[StatusDefine] [nvarchar] (50) 
)
GO

-----------------------------加入测试数据----------------------------------
delete from links
go
insert into links ([id],[num],[site],[logo],[url],[Online],[txt],[Addtime]) 
 select '2','2','青岛新闻网','','http://www.qingdaonews.com','1','1','2005-12-4 13:39:00'
go

delete from s_manage
go
insert into s_manage ([id],[username],[password]) 
 select '1','admin','25d55ad283aa400af464c76d713c07ad'
go

delete from pay
go
insert into pay ([ID],[pay],[payid],[paykey],[bank1],[bank2],[bank3],[bank4],[bank5],[bank6],[bank7],[bank8],[bank9],[bank10],[bank11],[bank12],[bank13],[bank14],[bank15]) 
 select '1','1','[e-mail]','6jyfaomf14l4barok5m1xbkll9oo6lg8','','','','','','','','','','','','','','',''
go

delete from type
go
insert into type ([Status],[StatusDefine]) 
 select '0','新订单'
insert into type ([Status],[StatusDefine]) 
 select '11','会员自行取消'
insert into type ([Status],[StatusDefine]) 
 select '12','无效单，已取消'
insert into type ([Status],[StatusDefine]) 
 select '2','已确认，待付款'
insert into type ([Status],[StatusDefine]) 
 select '3','已发货，待收货'
insert into type ([Status],[StatusDefine]) 
 select '88','在线支付成功'
insert into type ([Status],[StatusDefine]) 
 select '99','订单完成'
go

delete from s_gundong
go
insert into s_gundong ([title],[hrefurl],[picurl],[status]) 
 select '电控箱内部构件','index.asp','images/adv/g1.jpg',1
insert into s_gundong ([title],[hrefurl],[picurl],[status]) 
 select '室内电控箱','index.asp','images/adv/g2.jpg',1
insert into s_gundong ([title],[hrefurl],[picurl],[status]) 
 select '防爆电控箱使用现场','index.asp','images/adv/g3.jpg',1
insert into s_gundong ([title],[hrefurl],[picurl],[status]) 
 select '室内电控箱使用现场','index.asp','images/adv/g4.jpg',1
go

delete from s_class
go
insert into s_class ([LarSeq],[LarCode],[MidSeq],[MidCode]) 
 select '3','机电设备','3','电控阀'
insert into s_class ([LarSeq],[LarCode],[MidSeq],[MidCode]) 
 select '3','机电设备','2','电控箱'
insert into s_class ([LarSeq],[LarCode],[MidSeq],[MidCode]) 
 select '3','机电设备','4','多功能打印机'
insert into s_class ([LarSeq],[LarCode],[MidSeq],[MidCode]) 
 select '4','服饰用品','1','服装'
insert into s_class ([LarSeq],[LarCode],[MidSeq],[MidCode]) 
 select '1','标准件','2','各种钉子'
insert into s_class ([LarSeq],[LarCode],[MidSeq],[MidCode]) 
 select '1','标准件','3','各种螺母'
insert into s_class ([LarSeq],[LarCode],[MidSeq],[MidCode]) 
 select '1','标准件','4','其它东东'
insert into s_class ([LarSeq],[LarCode],[MidSeq],[MidCode]) 
 select '4','服饰用品','2','装饰'
go

delete from s_config
go
insert into s_config ([ID],[bodyfixed],[skin],[loginskin],[yzm_skin],[sitename],[sitekeywords],[sitedescription],[siteurl],[adm_address],[adm_post],[adm_name],[adm_mail],[adm_tel],[adm_qq],[adm_qq_name],[qqonline],[whereqq],[kefuskin],[qqskin],[qqmsg_off],[qqmsg_on],[adm_msn],[adm_comp],[adm_fax],[adm_mob],[adm_kf],[jsq],[help_hang],[usertype1],[kou1],[usertype2],[kou2],[usertype3],[kou3],[usertype4],[kou4],[usertype5],[kou5],[usertype6],[kou6],[prompt_num],[newprod_num],[renmen_num],[fenlei_num],[mosi],[pic_xiaogao],[quehuo],[wujiage],[huiyuanjia],[lar_color],[mid_color],[index_tishi],[tree_num],[tree_view],[tree_display],[reg],[bbs],[menu],[topmenu],[newsmove],[news_skin],[kf_color],[pei1],[pei2],[pei3],[pei4],[pei5],[pei6],[fei1],[fei2],[fei3],[fei4],[fei5],[fei6],[mianyoufei],[mianyoufei_msg],[newstitle1],[newstitle2],[newstitle3],[newstitle4],[newstitle5],[kaiguan],[guanbi],[reg_xieyi],[lockip],[IP],[other1],[other2]) 
 select '1','1','3','2','1','青岛科美-标准件,机电设备,服饰','科美,标准件,科美,机电,单片机,阀门,电动阀门,PLC','青岛科美-标准件,机电设备,服饰','http://www.qdkemei.com','山东省青岛市北区吴石支路7号','266000','朱先生','[e-mail]','0532-5693183','84789108','小小虫','0','0','4','5','您好，暂时离线。','请问有什么可以帮到您？','[e-mail]','青岛科美','0532-5693183','13001679685','TEL:[phone]<BR>FAX:[phone]<BR>联系人:朱光源','1','4','普通会员','10','高级会员','10','钻石会员','8','','10','','10','','10','12','4','8','10','1','1','货品准备中','价格请咨询','登陆可查看','77cc00','0066ff','1','1','1','0','1','1','1','测试asas','0','5','1fc9c39','1自费 （到付）','普通邮寄 (5元起)','主城区送货上门 (青岛市区8元起)','货运 (15元起，偏远地区酌情增加)','快递 (15元起,青岛5公斤10元)','特快专递 (EMS 20元起)','11','5','8','15','15','20','5000','购买满5000元','网站公告','','','','','1','网站正在维护，请稍后访问，给您带来的不便，请谅解。','　　欢迎您注册为本站会员，您在访问本站时，请您自觉遵守以下条款。<BR><BR>一、不得利用本站危害国家安全、泄露国家秘密，不得侵犯国家社会集体的和公民的合法权益，不得利用本站制作、复制和传播下列信息：&nbsp;<BR>　　（一）煽动抗拒、破坏宪法和法律、行政法规实施的；<BR>　　（二）煽动颠覆国家政权，推翻社会主义制度的；<BR>　　（三）煽动分裂国家、破坏国家统一的；<BR>　　（四）煽动','0','192.168.2.2','0',''
go

delete from admin
go
insert into admin ([username],[password]) 
 select 'admin','6eea9b7ef19179a06954edd0f6c05ceb'
go

delete from adv
go
insert into adv ([logo],[zimuspeed],[zimujianju],[zimu],[zimulink],[zimu2],[zimu2link],[zimu3],[zimu3link],[zimu4],[zimu4link],[zimu5],[zimu5link],[PIC1],[pic1_lnk],[tit1],[pic2],[pic2_lnk],[tit2],[pic3],[pic3_lnk],[tit3],[pic4],[pic4_lnk],[tit4],[hfpic],[hfurl],[hftit],[hf2pic],[hf2url],[hf2tit]) 
 select 'images/adv/logo.gif','1','9','第一条滚动文字内容','asdfasd','第二条滚动文字内容','','第三条滚动文字内容','','第四条滚动文字内容','','第五条滚动文字内容','','images/adv/g1.jpg','index.asp','电控箱内部构件','images/adv/g2.jpg','index.asp','室内电控箱','images/adv/g3.jpg','index.asp','防爆电控箱使用现场','images/adv/g4.jpg','index.asp','室内电控箱使用现场','images/adv/banner.jpg','index.asp','广告招租','images/adv/banner3.gif','index.asp','优质廉价,诚信经营。'
go

delete from s_hand
go
insert into s_hand ([fname],[name],[zuti],[neirong],[riqi],[isnew],[del]) 
 select 'tracy','admin','0','','2005-12-4 13:56:00',1,0
insert into s_hand ([fname],[name],[zuti],[neirong],[riqi],[isnew],[del]) 
 select '游客留言','tracy','0','','2006-2-27 11:17:00',0,0