shop.sql

网上购物系统 asp+sql server 2005

DROP TABLE [s_pinglun]
GO
CREATE TABLE [s_pinglun](
	[id] [int] IDENTITY(1,1) PRIMARY KEY,
	[prodid] [nvarchar](50) ,
	[IP] [nvarchar](20) ,
	[mail] [nvarchar](50) ,
	[name] [nvarchar](50) ,
	[adddate] [datetime]  DEFAULT (getdate()),
	[nr] [ntext] ,
	[jibie] [int] DEFAULT ((0)),
	[status] [nvarchar](1) 
)
GO
-----------------------------产品评论s_pinglun----------------------------------
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[s_hand]') AND type in (N'U'))
DROP TABLE [s_hand]
GO
CREATE TABLE [s_hand](
	[ID] [int] IDENTITY(1,1) PRIMARY KEY,
	[fname] [nvarchar](50) ,
	[name] [nvarchar](50) ,
	[zuti] [nvarchar](10) ,
	[neirong] [ntext] ,
	[riqi] [datetime] DEFAULT (getdate()),
	[isnew] [bit] DEFAULT ((1)),
	[del] [bit] DEFAULT ((0))
)
GO

-----------------------------创建各主表之间的关系----------------------------------
ALTER TABLE [s_order]  WITH NOCHECK ADD  CONSTRAINT [FK_s_order_s_orderList] FOREIGN KEY([OrderNum])
REFERENCES [s_orderList] ([OrderNum])
NOT FOR REPLICATION 
GO

ALTER TABLE [s_order]  WITH NOCHECK ADD  CONSTRAINT [FK_s_order_s_produc] FOREIGN KEY([ProdId])
REFERENCES [s_produc] ([ProdId])
NOT FOR REPLICATION 
GO

ALTER TABLE [s_orderList]  WITH NOCHECK ADD  CONSTRAINT [FK_s_orderList_s_buser] FOREIGN KEY([UserId])
REFERENCES [s_buser] ([UserId])
NOT FOR REPLICATION 
GO

-----------------------------创建其它副表----------------------------------
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[admin]') AND type in (N'U'))
DROP TABLE [dbo].[admin]
GO
CREATE TABLE [dbo].[admin] (
	[id] [int] IDENTITY (1, 1) PRIMARY KEY,
	[username] [nvarchar] (50),
	[password] [nvarchar] (50) 
)
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[adv]') AND type in (N'U'))
DROP TABLE [dbo].[adv]
GO
CREATE TABLE [dbo].[adv] (
	[ID] [int] IDENTITY (1, 1) PRIMARY KEY,
	[logo] [nvarchar] (100) ,
	[zimuspeed] [int] ,
	[zimujianju] [int] ,
	[zimu] [nvarchar] (100) ,
	[zimulink] [nvarchar] (100) ,
	[zimu2] [nvarchar] (100) ,
	[zimu2link] [nvarchar] (100) ,
	[zimu3] [nvarchar] (100) ,
	[zimu3link] [nvarchar] (100) ,
	[zimu4] [nvarchar] (100) ,
	[zimu4link] [nvarchar] (100) ,
	[zimu5] [nvarchar] (100) ,
	[zimu5link] [nvarchar] (100) ,
	[PIC1] [nvarchar] (100) ,
	[pic1_lnk] [nvarchar] (100) ,
	[tit1] [nvarchar] (100) ,
	[pic2] [nvarchar] (100) ,
	[pic2_lnk] [nvarchar] (100) ,
	[tit2] [nvarchar] (100) ,
	[pic3] [nvarchar] (100) ,
	[pic3_lnk] [nvarchar] (100) ,
	[tit3] [nvarchar] (100) ,
	[pic4] [nvarchar] (100) ,
	[pic4_lnk] [nvarchar] (100) ,
	[tit4] [nvarchar] (100) ,
	[hfpic] [nvarchar] (100) ,
	[hfurl] [nvarchar] (100) ,
	[hftit] [nvarchar] (100) ,
	[hf2pic] [nvarchar] (100) ,
	[hf2url] [nvarchar] (100) ,
	[hf2tit] [nvarchar] (100) 
)
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[links]') AND type in (N'U'))
DROP TABLE [dbo].[links]
GO
CREATE TABLE [dbo].[links] (
	[id] [int]  PRIMARY KEY,
	[num] [int],
	[site] [nvarchar] (50) ,
	[logo] [nvarchar] (100) ,
	[url] [nvarchar] (100) ,
	[Online] [nvarchar] (1) ,
	[txt] [nvarchar] (1) ,
	[Addtime] [smalldatetime]
)
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pay]') AND type in (N'U'))
DROP TABLE [dbo].[pay]
GO
CREATE TABLE [dbo].[pay] (
	[ID] [int]  PRIMARY KEY,
	[pay] [nvarchar] (2) ,
	[payid] [nvarchar] (50) ,
	[paykey] [nvarchar] (50) ,
	[bank1] [ntext] ,
	[bank2] [ntext] ,
	[bank3] [ntext] ,
	[bank4] [ntext] ,
	[bank5] [ntext] ,
	[bank6] [ntext] ,
	[bank7] [ntext] ,
	[bank8] [ntext] ,
	[bank9] [ntext] ,
	[bank10] [ntext] ,
	[bank11] [ntext] ,
	[bank12] [ntext] ,
	[bank13] [ntext] ,
	[bank14] [ntext] ,
	[bank15] [ntext] 
)
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[s_about]') AND type in (N'U'))
DROP TABLE [dbo].[s_about]
GO
CREATE TABLE [dbo].[s_about] (
	[title] [varchar] (20) PRIMARY KEY,
	[url] [varchar] (50) ,
	[body] [text] ,
	[indexnum] [int] ,
	[status] [bit] 
)
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[s_adv]') AND type in (N'U'))
DROP TABLE [dbo].[s_adv]
GO
CREATE TABLE [dbo].[s_adv] (
	[ID] [int]  PRIMARY KEY ,
	[indexnum] [int] ,
	[title] [nvarchar] (100) ,
	[link] [nvarchar] (100) 
)
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[s_config]') AND type in (N'U'))
DROP TABLE [dbo].[s_config]
GO
CREATE TABLE [dbo].[s_config] (
	[ID] [int]  PRIMARY KEY ,
	[bodyfixed] [nvarchar] (1) ,
	[skin] [nvarchar] (2) ,
	[loginskin] [nvarchar] (2) ,
	[yzm_skin] [nvarchar] (2) ,
	[sitename] [nvarchar] (50) ,
	[sitekeywords] [nvarchar] (200) ,
	[sitedescription] [nvarchar] (200) ,
	[siteurl] [nvarchar] (50) ,
	[adm_address] [nvarchar] (50) ,
	[adm_post] [nvarchar] (20) ,
	[adm_name] [nvarchar] (20) ,
	[adm_mail] [nvarchar] (50) ,
	[adm_tel] [nvarchar] (50) ,
	[adm_qq] [nvarchar] (50) ,
	[adm_qq_name] [nvarchar] (50) ,
	[qqonline] [int] ,
	[whereqq] [int] ,
	[kefuskin] [nvarchar] (1) ,
	[qqskin] [nvarchar] (1) ,
	[qqmsg_off] [nvarchar] (100) ,
	[qqmsg_on] [nvarchar] (100) ,
	[adm_msn] [nvarchar] (255) ,
	[adm_comp] [nvarchar] (50) ,
	[adm_fax] [nvarchar] (50) ,
	[adm_mob] [nvarchar] (50) ,
	[adm_kf] [nvarchar] (200),
	[jsq] [int] ,
	[help_hang] [smallint]  ,
	[usertype1] [nvarchar] (50) ,
	[kou1] [real] ,
	[usertype2] [nvarchar] (50) ,
	[kou2] [real] ,
	[usertype3] [nvarchar] (50) ,
	[kou3] [real] ,
	[usertype4] [nvarchar] (50) ,
	[kou4] [real] ,
	[usertype5] [nvarchar] (50) ,
	[kou5] [real] ,
	[usertype6] [nvarchar] (50) ,
	[kou6] [real] ,
	[prompt_num] [smallint] ,