z.sql

网络图片收集软件

use pub
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[doneurl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[doneurl]
GO

CREATE TABLE [dbo].[doneurl] (
	[url] [varchar] (512) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[exclusive]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[exclusive]
GO

CREATE TABLE [dbo].[exclusive] (
	[sitename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[url] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[history]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[history]
GO

CREATE TABLE [dbo].[history] (
	[url] [varchar] (512) COLLATE Chinese_PRC_CI_AS NULL ,
	[filename] [char] (255) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[include]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[include]
GO

CREATE TABLE [dbo].[include] (
	[sitename] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[url] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[log]
GO

CREATE TABLE [dbo].[log] (
	[sitename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[url] [varchar] (512) COLLATE Chinese_PRC_CI_AS NULL ,
	[lasttime] [datetime] NULL ,
	[lastnum] [int] NULL ,
	[status] [bit] NULL ,
	[priority] [smallint] NULL ,
	[imagetype] [smallint] NULL ,
	[min_height] [smallint] NULL ,
	[max_height] [smallint] NULL ,
	[min_width] [smallint] NULL ,
	[max_width] [smallint] NULL ,
	[bdownload] [bit] NULL ,
	[max_level] [smallint] NULL ,
	[exclusive_level] [smallint] NULL 
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[save]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[save]
GO

CREATE TABLE [dbo].[save] (
	[sitename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[todownloadurl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[todownloadurl]
GO

CREATE TABLE [dbo].[todownloadurl] (
	[url] [varchar] (512) COLLATE Chinese_PRC_CI_AS NULL ,
	[level] [int] NULL ,
	[time] [datetime] NULL 
) ON [PRIMARY]
GO