?? 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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -