www.pudn.com > webinfo自动化搜索引擎(net).rar > build.sql

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'main') 
	DROP DATABASE [main] 
GO 
 
CREATE DATABASE [main]  ON (NAME = N'main_Data', FILENAME = N'c:\maindata' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'main_Log', FILENAME = N'c:\mainlog' , SIZE = 1, FILEGROWTH = 0%) 
 COLLATE Chinese_PRC_CI_AS 
GO 
 
exec sp_dboption N'main', N'autoclose', N'false' 
GO 
 
exec sp_dboption N'main', N'bulkcopy', N'false' 
GO 
 
exec sp_dboption N'main', N'trunc. log', N'false' 
GO 
 
exec sp_dboption N'main', N'torn page detection', N'true' 
GO 
 
exec sp_dboption N'main', N'read only', N'false' 
GO 
 
exec sp_dboption N'main', N'dbo use', N'false' 
GO 
 
exec sp_dboption N'main', N'single', N'false' 
GO 
 
exec sp_dboption N'main', N'autoshrink', N'false' 
GO 
 
exec sp_dboption N'main', N'ANSI null default', N'false' 
GO 
 
exec sp_dboption N'main', N'recursive triggers', N'false' 
GO 
 
exec sp_dboption N'main', N'ANSI nulls', N'false' 
GO 
 
exec sp_dboption N'main', N'concat null yields null', N'false' 
GO 
 
exec sp_dboption N'main', N'cursor close on commit', N'false' 
GO 
 
exec sp_dboption N'main', N'default to local cursor', N'false' 
GO 
 
exec sp_dboption N'main', N'quoted identifier', N'false' 
GO 
 
exec sp_dboption N'main', N'ANSI warnings', N'false' 
GO 
 
exec sp_dboption N'main', N'auto create statistics', N'true' 
GO 
 
exec sp_dboption N'main', N'auto update statistics', N'true' 
GO 
 
use [main] 
GO 
 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[datatable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
drop table [dbo].[datatable] 
GO 
 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
drop table [dbo].[list] 
GO 
 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tasktable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 
drop table [dbo].[tasktable] 
GO 
 
CREATE TABLE [dbo].[datatable] ( 
	[id] [int] IDENTITY (1, 1) NOT NULL , 
	[tablename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
	[host] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
	[db] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
	[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
	[pass] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
	[dt] [datetime] NULL , 
	[isa] [nchar] (1) COLLATE Chinese_PRC_CI_AS NULL , 
	[ord] [int] NULL , 
	[lastfill] [datetime] NULL , 
	[tot] [int] NULL , 
	[mode] [char] (4) COLLATE Chinese_PRC_CI_AS NULL , 
	[ltot] [int] NULL  
) ON [PRIMARY] 
GO 
 
CREATE TABLE [dbo].[list] ( 
	[id] [int] IDENTITY (1, 1) NOT NULL , 
	[url] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL , 
	[tid] [int] NULL , 
	[le] [int] NULL  
) ON [PRIMARY] 
GO 
 
CREATE TABLE [dbo].[tasktable] ( 
	[tid] [int] NOT NULL , 
	[host] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
	[db] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
	[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
	[pass] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
	[tb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 
	[comm] [char] (1) COLLATE Chinese_PRC_CI_AS NULL , 
	[ismain] [char] (4) COLLATE Chinese_PRC_CI_AS NULL  
) ON [PRIMARY] 
GO 
 
ALTER TABLE [dbo].[tasktable] WITH NOCHECK ADD  
	CONSTRAINT [PK_tasktable] PRIMARY KEY  CLUSTERED  
	( 
		[tid] 
	)  ON [PRIMARY]  
GO 
 
ALTER TABLE [dbo].[datatable] WITH NOCHECK ADD  
	CONSTRAINT [DF_datatable_dt] DEFAULT (getdate()) FOR [dt], 
	CONSTRAINT [DF_datatable_isable] DEFAULT ('u') FOR [isa], 
	CONSTRAINT [DF_datatable_ord] DEFAULT (0) FOR [ord], 
	CONSTRAINT [DF_datatable_tot] DEFAULT (0) FOR [tot], 
	CONSTRAINT [DF_datatable_mode] DEFAULT ('manu') FOR [mode], 
	CONSTRAINT [DF_datatable_ltot] DEFAULT (0) FOR [ltot] 
GO 
 
ALTER TABLE [dbo].[tasktable] WITH NOCHECK ADD  
	CONSTRAINT [DF_tasktable_dt] DEFAULT (getdate()) FOR [tb], 
	CONSTRAINT [DF_tasktable_comm] DEFAULT ('b') FOR [comm], 
	CONSTRAINT [DF_tasktable_ismain] DEFAULT ('norm') FOR [ismain] 
GO