ASP源码—K风元搜索引擎系统 K-MetaSearch v3.1 SP3.zip

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[admin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[admin] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[commend]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[commend] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[engine]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[engine] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[exhibit]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[exhibit] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sort]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[sort] GO CREATE TABLE [dbo].[admin] ( [id] [int] IDENTITY (1, 1) NOT NULL , [username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [loginip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [logintime] [smalldatetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[commend] ( [id] [int] IDENTITY (1, 1) NOT NULL , [title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [content] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [url] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [keyword] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [price] [int] NULL , [commendday] [int] NULL , [timeout] [smalldatetime] NULL , [name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [contact] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [date] [smalldatetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[engine] ( [id] [int] IDENTITY (1, 1) NOT NULL , [state] [int] NULL , [sort] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [engine] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [charset] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [headername] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [headervalue] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [zerohtml] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [cycborder] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [urlstart] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [urlend] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [titlestart] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [titleend] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [contentstart] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [contentend] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [wordstart] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [wordend] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[exhibit] ( [id] [int] IDENTITY (1, 1) NOT NULL , [title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [content] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [url] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [keyword] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [price] [int] NULL , [exhibitday] [int] NULL , [timeout] [smalldatetime] NULL , [name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [contact] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [date] [smalldatetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[sort] ( [id] [int] IDENTITY (1, 1) NOT NULL , [sort] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [code] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [sequence] [int] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[admin] WITH NOCHECK ADD CONSTRAINT [PK_admin] PRIMARY KEY CLUSTERED ( [id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[commend] WITH NOCHECK ADD CONSTRAINT [PK_commend] PRIMARY KEY CLUSTERED ( [id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[engine] WITH NOCHECK ADD CONSTRAINT [PK_engine] PRIMARY KEY CLUSTERED ( [id] ) ON [PRIMARY] GO ALTER TABLE �