网站多个栏目的广告系统

CREATE TABLE [Admin] ( [aid] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [admin] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [passwd] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Power] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [Person] [ntext] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [Advertisement] ( [ADid] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [ADname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [ADintro] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [ADact] [int] NULL , [ADclass] [int] NULL , [Pids] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [Picid] [int] NULL , [ADurl] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [ADwindow] [int] NULL , [ADshow] [int] NULL , [ADshows] [int] NULL , [ADclick] [int] NULL , [ADclicks] [int] NULL , [ADtime] [smalldatetime] NULL , [ADstoptime] [smalldatetime] NULL , [ADstarttime] [smalldatetime] NULL , [ADxslei] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [ADcss] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [Picurl] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [ADipkg] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [Class] ( [Cid] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [Cname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [IP1] ( [IPid] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [ADid] [int] NULL , [IPtime] [smalldatetime] NULL , [IPaddress] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [IP2] ( [IPid] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [ADid] [int] NULL , [IPtime] [smalldatetime] NULL , [IPaddress] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [Pictrue] ( [PicId] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [PicUrl] [ntext] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [Place] ( [Pid] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [Pname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Plei] [int] NULL , [Pcss] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [Cid] [int] NULL , [ADids] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [Pename] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [Admin] WITH NOCHECK ADD CONSTRAINT [PK_Admin] PRIMARY KEY CLUSTERED ( [aid] ) ON [PRIMARY] GO ALTER TABLE [Advertisement] WITH NOCHECK ADD CONSTRAINT [PK_Advertisement] PRIMARY KEY CLUSTERED ( [ADid] ) ON [PRIMARY] GO ALTER TABLE [Class] WITH NOCHECK ADD CONSTRAINT [PK_Class] PRIMARY KEY CLUSTERED ( [Cid] ) ON [PRIMARY] GO ALTER TABLE [IP1] WITH NOCHECK ADD CONSTRAINT [PK_IP1] PRIMARY KEY CLUSTERED ( [IPid] ) ON [PRIMARY] GO ALTER TABLE [IP2] WITH NOCHECK ADD CONSTRAINT [PK_IP2] PRIMARY KEY CLUSTERED ( [IPid] ) ON [PRIMARY] GO ALTER TABLE [Pictrue] WITH NOCHECK ADD CONSTRAINT [PK_Pictrue] PRIMARY KEY CLUSTERED ( [PicId] ) ON [PRIMARY] GO ALTER TABLE [Place] WITH NOCHECK ADD CONSTRAINT [PK_Place] PRIMARY KEY CLUSTERED ( [Pid] ) ON [PRIMARY] GO ALTER TABLE [Admin] WITH NOCHECK ADD CONSTRAINT [DF_Admin_admin] DEFAULT ('') FOR [admin], CONSTRAINT [DF_Admin_passwd] DEFAULT ('') FOR [passwd], CONSTRAINT [DF_Admin_Power] DEFAULT ('') FOR [Power], CONSTRAINT [DF_Admin_Person] DEFAULT ('') FOR [Person] GO ALTER TABLE [Advertisement] WITH NOCHECK ADD CONSTRAINT [DF_Advertisement_ADname] DEFAULT ('') FOR [ADname], CONSTRAINT [DF_Advertisement_ADintro] DEFAULT ('') FOR [ADintro], CONSTRAINT [DF_Advertisement_ADact] DEFAULT (0) FOR [ADact], CONSTRAINT [DF_Advertisement_ADclass] DEFAULT (0) FOR [ADclass], CONSTRAINT [DF_Advertisement_Pids] DEFAULT ('') FOR [Pids], CONSTRAINT [DF_Advertisement_Picid] DEFAULT (0) FOR [Pi�