USE [master]
GO
/****** Object:  Database [gogo_ipoms]    Script Date: 08/21/2017 00:55:23 ******/
CREATE DATABASE [gogo_ipoms] ON  PRIMARY 
( NAME = N'gogo_ipoms', FILENAME = N'D:\程序设计\互联网舆情监测系统\Data\gogo_ipoms.mdf' , SIZE = 4160KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'gogo_ipoms_log', FILENAME = N'D:\程序设计\互联网舆情监测系统\Data\gogo_ipoms.ldf' , SIZE = 6272KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [gogo_ipoms].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [gogo_ipoms] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [gogo_ipoms] SET ANSI_NULLS OFF
GO
ALTER DATABASE [gogo_ipoms] SET ANSI_PADDING OFF
GO
ALTER DATABASE [gogo_ipoms] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [gogo_ipoms] SET ARITHABORT OFF
GO
ALTER DATABASE [gogo_ipoms] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [gogo_ipoms] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [gogo_ipoms] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [gogo_ipoms] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [gogo_ipoms] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [gogo_ipoms] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [gogo_ipoms] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [gogo_ipoms] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [gogo_ipoms] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [gogo_ipoms] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [gogo_ipoms] SET  DISABLE_BROKER
GO
ALTER DATABASE [gogo_ipoms] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [gogo_ipoms] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [gogo_ipoms] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [gogo_ipoms] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [gogo_ipoms] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [gogo_ipoms] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [gogo_ipoms] SET  READ_WRITE
GO
ALTER DATABASE [gogo_ipoms] SET RECOVERY FULL
GO
ALTER DATABASE [gogo_ipoms] SET  MULTI_USER
GO
ALTER DATABASE [gogo_ipoms] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [gogo_ipoms] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'gogo_ipoms', N'ON'
GO
USE [gogo_ipoms]
GO
/****** Object:  Table [dbo].[gogo_Timeidentification]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_Timeidentification](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[mc] [nvarchar](50) NULL,
	[matchurl] [nvarchar](200) NULL,
	[str1] [nvarchar](200) NULL,
	[str2] [nvarchar](200) NULL,
	[Ltime] [datetime] NULL,
 CONSTRAINT [PK_gogo_Timeidentification] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_Timeidentification] ON
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (1, N'百度贴吧内容页', N'http://tieba.baidu.com/p/', N'date&quot;:&quot;', N'&quot;', CAST(0x0000A7B301673760 AS DateTime))
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (2, N'金碧社区内容页', N'http://www.jinbifun.com/thread-*.html', N'">发表于 ', N'</em>', CAST(0x0000A79E008C2170 AS DateTime))
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (4, N'天涯论坛内容页', N'http://bbs.tianya.cn/post-*.shtml', N'<span>时间：', N' </span>', CAST(0x0000A7B301673634 AS DateTime))
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (6, N'红河论坛内容页', N'http://bbs.hh.cn/forum.php?mod=viewthread&tid=', N'">发表于 ', N'</em>', CAST(0x0000A79E0036A4AC AS DateTime))
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (9, N'中华网社区内容页', N'http://club.china.com/data/thread/*.html', N'<li class="time"><span>发表于：', N'</span>', CAST(0x0000A79E005F751C AS DateTime))
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (11, N'微信公众号文章', N'mp.weixin.qq.com/s?src=', N'<em id="post-date" class="rich_media_meta rich_media_meta_text">', N'</em>', CAST(0x0000A79E00883524 AS DateTime))
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (14, N'军魂社区内容页', N'http://www.junhunw.cn/thread-*.html', N'">发表于 ', N'</em>', CAST(0x0000A79200C17370 AS DateTime))
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (15, N'新浪新闻', N'http://news.sina.com.cn/*/doc-*.shtml', N'article:create_at" content="', N'" />', CAST(0x0000A79E0056AEA0 AS DateTime))
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (18, N'新京报网', N'http://www.bjnews.com.cn/*/20*/*/*/*.html', N'<span class="date" id="pubtime_baidu">', N'</span>', CAST(0x0000A79E00407E8C AS DateTime))
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (20, N'栖兰小筑论坛正文页', N'http://www.qilanxiaozhu.net/thread-*.html', N'">发表于 ', N'</em>', CAST(0x0000A79E00A35354 AS DateTime))
INSERT [dbo].[gogo_Timeidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (24, N'新浪微博正文页', N'http://weibo.com/*?refer_flag=1001', N'weibotime" title="', N'"', CAST(0x0000A79E003C05A0 AS DateTime))
SET IDENTITY_INSERT [dbo].[gogo_Timeidentification] OFF
/****** Object:  Table [dbo].[gogo_webpage]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_webpage](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[url] [nvarchar](250) NULL,
	[contenttype] [nvarchar](50) NULL,
	[title] [nvarchar](100) NULL,
	[ip] [bigint] NULL,
	[host] [nvarchar](50) NULL,
	[html] [ntext] NULL,
	[purl] [nvarchar](250) NULL,
	[taskbs] [nvarchar](50) NULL,
	[addtime] [datetime] NULL,
 CONSTRAINT [PK_gogo_webpage] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [for_webpage_Analysis1] ON [dbo].[gogo_webpage] 
(
	[title] ASC,
	[host] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_host] ON [dbo].[gogo_webpage] 
(
	[host] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_title] ON [dbo].[gogo_webpage] 
(
	[title] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_url] ON [dbo].[gogo_webpage] 
(
	[url] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_system_info]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_system_info](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[webname] [nvarchar](100) NULL,
	[indexurl] [nvarchar](200) NULL,
	[gl] [ntext] NULL,
	[cysql] [ntext] NULL,
	[mailkg] [bit] NULL,
	[mailhtml] [bit] NULL,
	[mailsmtp] [nvarchar](50) NULL,
	[mailaddress] [nvarchar](50) NULL,
	[mailname] [nvarchar](50) NULL,
	[mailuser] [nvarchar](50) NULL,
	[mailpwd] [nvarchar](50) NULL,
	[txjg] [int] NULL,
	[txsjh] [nvarchar](2) NULL,
	[txsjm] [nvarchar](2) NULL,
	[message_kg] [bit] NULL,
	[zxwz] [int] NULL,
	[smsmode] [int] NULL,
	[smsjg] [int] NULL,
	[resmsjg] [int] NULL,
	[smssx] [int] NULL,
	[auto_service_time1] [datetime] NULL,
	[auto_service_time2] [datetime] NULL,
	[smsmodeport] [int] NULL,
	[smsmodemtype] [nvarchar](50) NULL,
	[smserrmax] [int] NULL,
	[smscd] [int] NULL,
	[bcts] [int] NULL,
	[reg] [bit] NULL,
	[Hardwareid] [nvarchar](50) NULL,
	[zzcd] [int] NULL,
	[zzsx] [int] NULL,
	[dlcsdz] [nvarchar](max) NULL,
	[dlcszf] [nvarchar](50) NULL,
	[dlcsbm] [nvarchar](50) NULL,
	[ltlcspl] [int] NULL,
	[ltltjzq] [int] NULL,
	[ltlcssj] [int] NULL,
	[ltlyq] [int] NULL,
	[errlog] [bit] NULL,
	[outtime] [int] NULL,
	[logsj] [int] NULL,
	[cqcs] [int] NULL,
	[smtpport] [int] NULL,
	[mailSSL] [bit] NULL,
	[mailDefaultCredentials] [bit] NULL,
	[webpath] [nvarchar](max) NULL,
	[cd] [nvarchar](50) NULL,
	[smshttp] [nvarchar](500) NULL,
	[smshttpstr] [nvarchar](200) NULL,
 CONSTRAINT [PK_gogo_system_info] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_system_info] ON
INSERT [dbo].[gogo_system_info] ([id], [webname], [indexurl], [gl], [cysql], [mailkg], [mailhtml], [mailsmtp], [mailaddress], [mailname], [mailuser], [mailpwd], [txjg], [txsjh], [txsjm], [message_kg], [zxwz], [smsmode], [smsjg], [resmsjg], [smssx], [auto_service_time1], [auto_service_time2], [smsmodeport], [smsmodemtype], [smserrmax], [smscd], [bcts], [reg], [Hardwareid], [zzcd], [zzsx], [dlcsdz], [dlcszf], [dlcsbm], [ltlcspl], [ltltjzq], [ltlcssj], [ltlyq], [errlog], [outtime], [logsj], [cqcs], [smtpport], [mailSSL], [mailDefaultCredentials], [webpath], [cd], [smshttp], [smshttpstr]) VALUES (1, N'探索者互联网舆情监测系统', N'http://127.0.0.1', N'''|<script|select |insert |delete from|count(|drop table|update |truncate |asc(|mid(|char(|xp_cmdshell|exec master|net localgroup administrators|and |net user| or', N'查询所有管理员电话|select tel from gogo_admin
查询所有管理员邮箱|select mailaddress from gogo_admin', 0, 1, N'smtp.qq.com', N'111111@qq.com', N'探索者互联网舆情监测系统', N'111111', N'111111', 120, N'08', N'00', 0, 3, 0, 5000, 30000, 720, CAST(0x0000A7C40004D7D8 AS DateTime), CAST(0x0000A7C40004E4BC AS DateTime), 0, N'未知', 3, 210, 180, 0, N'BFEBFBFF000306A9-2487083631', 60, 720, N'http://www.baidu.com', N'百度', N'UTF-8', 5, 60, 5000, 95, 0, 300, 0, 0, 587, 1, 0, N'D:\程序设计\互联网舆情监测系统\WEB2.0\gogo_mechanism', N'18A05D80E33A5EFBEE72A838D6950843', N'http://127.0.0.1/?tel={HM}&nr={NR}', N'')
SET IDENTITY_INSERT [dbo].[gogo_system_info] OFF
/****** Object:  Table [dbo].[gogo_smsplan]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_smsplan](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[type] [nvarchar](50) NULL,
	[tid] [int] NULL,
	[zq] [nvarchar](50) NULL,
	[rq] [nvarchar](50) NULL,
	[sj] [nvarchar](5) NULL,
	[nr] [nvarchar](max) NULL,
	[qy] [bit] NULL,
 CONSTRAINT [PK_gogo_smsplan] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_ProxyServer]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_ProxyServer](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dz] [nvarchar](max) NULL,
	[dk] [int] NULL,
	[yhm] [nvarchar](50) NULL,
	[mm] [nvarchar](50) NULL,
	[bz] [nvarchar](max) NULL,
	[ltl] [int] NULL,
 CONSTRAINT [PK_gogo_ProxyServer] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_ltl] ON [dbo].[gogo_ProxyServer] 
(
	[ltl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_order]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_order](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderinfo] [nvarchar](50) NULL,
	[p1] [nvarchar](50) NULL,
	[p2] [nvarchar](50) NULL,
	[p3] [nvarchar](50) NULL,
	[p4] [nvarchar](50) NULL,
	[p5] [nvarchar](50) NULL,
	[jg] [nvarchar](max) NULL,
	[t1] [datetime] NULL,
	[t2] [datetime] NULL,
 CONSTRAINT [PK_gogo_order] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_order] ON
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (176, N'更新自动服务程序日志保留时间', N'', N'', N'', N'', N'', N'自动服务程序日志保留时间已更新', CAST(0x0000A71A011A5940 AS DateTime), CAST(0x0000A7580171BB2C AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (177, N'更新错误任务重启次数', N'', N'', N'', N'', N'', N'错误任务重启次数已更新', CAST(0x0000A71A011A6AD4 AS DateTime), CAST(0x0000A7580171BB2C AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (178, N'更新自动服务程序日志保留时间', N'', N'', N'', N'', N'', N'自动服务程序日志保留时间已更新', CAST(0x0000A71A011A7308 AS DateTime), CAST(0x0000A7580171BB2C AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (179, N'更新自动服务程序日志保留时间', N'', N'', N'', N'', N'', N'自动服务程序日志保留时间已更新', CAST(0x0000A71A01207CBC AS DateTime), CAST(0x0000A7580171BB2C AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (180, N'更新自动服务程序日志保留时间', N'', N'', N'', N'', N'', N'自动服务程序日志保留时间已更新', CAST(0x0000A71A0122148C AS DateTime), CAST(0x0000A7580171BB2C AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (181, N'更新网页信息获取错误日志记录状态', N'', N'', N'', N'', N'', N'网页信息获取错误日志记录状态已更新', CAST(0x0000A79300041EB0 AS DateTime), CAST(0x0000A79300059358 AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (182, N'更新网页信息获取错误日志记录状态', N'', N'', N'', N'', N'', N'未能识别的指令', CAST(0x0000A7930019D3B8 AS DateTime), CAST(0x0000A7B300F305AC AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (183, N'更新内容识别数组', N'', N'', N'', N'', N'', N'内容识别数组已更新', CAST(0x0000A79400BF46CC AS DateTime), CAST(0x0000A7B300F305AC AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (184, N'更新内容识别数组', N'', N'', N'', N'', N'', N'内容识别数组已更新', CAST(0x0000A79400BFD6F0 AS DateTime), CAST(0x0000A7B300F305AC AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (185, N'更新内容识别数组', N'', N'', N'', N'', N'', N'内容识别数组已更新', CAST(0x0000A79400C00E04 AS DateTime), CAST(0x0000A7B300F305AC AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (186, N'更新内容识别数组', N'', N'', N'', N'', N'', N'内容识别数组已更新', CAST(0x0000A79400C15624 AS DateTime), CAST(0x0000A7B300F305AC AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (187, N'更新内容识别数组', N'', N'', N'', N'', N'', N'内容识别数组已更新', CAST(0x0000A79400C1BAEC AS DateTime), CAST(0x0000A7B300F305AC AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (188, N'更新内容识别数组', N'', N'', N'', N'', N'', N'内容识别数组已更新', CAST(0x0000A79400C31CD4 AS DateTime), CAST(0x0000A7B300F305AC AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (189, N'更新内容识别数组', N'', N'', N'', N'', N'', N'内容识别数组已更新', CAST(0x0000A79400C4836C AS DateTime), CAST(0x0000A7B300F306D8 AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (190, N'更新时间识别数组', N'', N'', N'', N'', N'', N'时间识别数组已更新', CAST(0x0000A79E00AE7428 AS DateTime), CAST(0x0000A7B300F306D8 AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (191, N'更新内容识别数组', N'', N'', N'', N'', N'', N'内容识别数组已更新', CAST(0x0000A79E00AE7B30 AS DateTime), CAST(0x0000A7B300F306D8 AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (192, N'更新内容识别数组', N'', N'', N'', N'', N'', N'内容识别数组已更新', CAST(0x0000A79E00B0061C AS DateTime), CAST(0x0000A7B300F306D8 AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (193, N'更新系统参数配置', N'', N'', N'', N'', N'', N'系统参数配置已更新', CAST(0x0000A7A9017AAE30 AS DateTime), CAST(0x0000A7B300F306D8 AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (194, N'更新系统参数配置', N'', N'', N'', N'', N'', N'系统参数配置已更新', CAST(0x0000A7B100068F4C AS DateTime), CAST(0x0000A7B300F306D8 AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (195, N'更新系统参数配置', N'', N'', N'', N'', N'', N'系统参数配置已更新', CAST(0x0000A7B300F1CF20 AS DateTime), CAST(0x0000A7B300F306D8 AS DateTime))
INSERT [dbo].[gogo_order] ([id], [orderinfo], [p1], [p2], [p3], [p4], [p5], [jg], [t1], [t2]) VALUES (196, N'更新系统参数配置', N'', N'', N'', N'', N'', NULL, CAST(0x0000A7D6000ED738 AS DateTime), NULL)
SET IDENTITY_INSERT [dbo].[gogo_order] OFF
/****** Object:  Table [dbo].[gogo_messagereceived]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_messagereceived](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[gsmid] [int] NULL,
	[unknowid] [nvarchar](50) NULL,
	[tel] [nvarchar](50) NULL,
	[nr] [nvarchar](max) NULL,
	[receivetime] [datetime] NULL,
 CONSTRAINT [PK_gogo_messagereceived] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_messagelog]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_messagelog](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[tel] [nvarchar](50) NULL,
	[info] [ntext] NULL,
	[infolen] [int] NULL,
	[sendtime] [datetime] NULL,
	[admin] [nvarchar](50) NULL,
	[zjtime] [datetime] NULL,
	[err] [int] NULL,
	[errinfo] [nvarchar](max) NULL,
	[yxj] [int] NULL,
 CONSTRAINT [PK_gogo_messagelog] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [for_sendmessagebydb] ON [dbo].[gogo_messagelog] 
(
	[zjtime] ASC,
	[err] ASC,
	[sendtime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_memorandum]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_memorandum](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[bt] [nvarchar](50) NULL,
	[nr] [ntext] NULL,
	[edittime] [datetime] NULL,
	[admin] [nvarchar](50) NULL,
 CONSTRAINT [PK_gogo_memorandum] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_jurisdiction]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_jurisdiction](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[mc] [nvarchar](50) NULL,
	[qz] [int] NULL,
	[sm] [nvarchar](max) NULL,
 CONSTRAINT [PK_gogo_jurisdiction] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_jurisdiction] ON
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (1, N'系统高级管理', 0, N'系统核心底层配置')
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (2, N'关键词策略管理', 70, N'对本部门或下属部门的关键词组和策略进行管理')
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (3, N'监测结果查询', 80, N'可以查看本部门或下属部门的策略预警和系统内所有网页记录')
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (5, N'短信群发', 15, N'短信群发')
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (6, N'监测任务管理', 85, N'对本部门或下属部门的监测任务、白名单进行管理')
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (11, N'邮件群发', 10, N'邮件群发')
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (19, N'发布信息', 25, N'可发布信息文章')
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (20, N'管理信息', 20, N'可删除、修改本部门或下属部门发布的信息')
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (21, N'查看通信录', 5, N'查看系统内所有用户的基本情况')
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (22, N'特征号配置', 65, N'可以管理需要采集的网络特征号参数')
INSERT [dbo].[gogo_jurisdiction] ([id], [mc], [qz], [sm]) VALUES (23, N'查看特征号采集结果', 60, N'可以查看采集到的网络特征号结果')
SET IDENTITY_INSERT [dbo].[gogo_jurisdiction] OFF
/****** Object:  Table [dbo].[gogo_department]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_department](
	[id] [int] NOT NULL,
	[mc] [nvarchar](50) NULL,
	[qz] [int] NULL,
	[fid] [int] NULL,
	[tasknum] [int] NULL,
	[yxq] [datetime] NULL,
	[sms] [bit] NULL,
	[mail] [bit] NULL,
	[depth] [int] NULL,
	[Recordmode] [bit] NULL,
 CONSTRAINT [PK_gogo_department] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_fid] ON [dbo].[gogo_department] 
(
	[fid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_mail] ON [dbo].[gogo_department] 
(
	[mail] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_sms] ON [dbo].[gogo_department] 
(
	[sms] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_yxq] ON [dbo].[gogo_department] 
(
	[yxq] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
INSERT [dbo].[gogo_department] ([id], [mc], [qz], [fid], [tasknum], [yxq], [sms], [mail], [depth], [Recordmode]) VALUES (100000000, N'探索者总部', 20, 0, 1000, CAST(0x0000D76F018B80D4 AS DateTime), 0, 0, 10, 1)
/****** Object:  Table [dbo].[gogo_Contentidentification]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_Contentidentification](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[mc] [nvarchar](50) NULL,
	[matchurl] [nvarchar](200) NULL,
	[str1] [nvarchar](200) NULL,
	[str2] [nvarchar](200) NULL,
	[Ltime] [datetime] NULL,
 CONSTRAINT [PK_gogo_Contentidentification] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_Contentidentification] ON
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (1, N'金碧论坛帖子页', N'http://www.jinbifun.com/thread-*.html', N'<h1 class="ts">', N'<div id="comment_', CAST(0x0000A79E004B93A8 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (2, N'澎湃新闻内容页', N'http://www.thepaper.cn/newsDetail_', N'class="news_title"', N'class="news_editor"', CAST(0x0000A79E00862A7C AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (3, N'天涯论坛内容页', N'http://bbs.tianya.cn/post-*.shtml', N'<div id="post_head" class="atl-head">', N'<div id="alt_action" class="clearfix">', CAST(0x0000A7B301673AE4 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (5, N'云南网内容页', N'http://*.yunnan.cn/html/*-*/*/content_*.htm', N'<!--enpproperty', N'<!--/enpcontent-->', CAST(0x0000A79E006D97DC AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (8, N'新浪社区内容页', N'http://club.news.sina.com.cn/thread-*.html', N'<div class="mainsub">', N'<div class="mybbs_rate">', CAST(0x0000A79E00641F40 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (10, N'中华网社区内容页', N'http://club.china.com/data/thread/*.html', N'<!--content start-->', N'<!-- content end-->', CAST(0x0000A79E005F751C AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (11, N'强国论坛内容页摘要', N'http://bbs1.people.com.cn/post/*.html', N'<title>', N'<meta name="keywords"', CAST(0x0000A79E00A88568 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (14, N'新浪博客内容页', N'http://blog.sina.com.cn/s/blog_', N'<!-- 正文开始 -->', N'<!-- 正文结束 -->', CAST(0x00008EAC00000000 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (15, N'腾讯网文章内容页', N'.qq.com/a/*/*.htm', N'id="main-article-qq">', N'正文已结束，您可以按alt+4进行评论', CAST(0x0000A79E00828228 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (16, N'新浪新闻', N'http://news.sina.com.cn/*/doc-*.shtml', N'<div class="page-header">', N'<p class="article-editor">', CAST(0x0000A79E005B0590 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (17, N'凤凰新闻文章内容页', N'http://news.ifeng.com/a/20*.shtml', N'<div id="artical">', N'<!--maincontent end-->', CAST(0x0000A79E00791FD0 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (18, N'网易新闻文章内容页', N'http://news.163.com/1*/*/*/*.html', N'<div class="post_content_main"', N'<div class="ep-source cdgray">', CAST(0x0000A79E0082C620 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (19, N'军魂社区内容页', N'http://www.junhunw.cn/thread-*.html', N'<span id="thread_subject">', N'<a class="fastre" ', CAST(0x0000A79E0080AC3C AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (20, N'中华网国内新闻文章页', N'http://news.china.com/*/*/20*/*.html', N'<h1 id="chan_newstitle">', N'ep_pagetop.shtml start -->', CAST(0x0000A79E00340E90 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (21, N'新华网论坛', N'http://forum.home.news.cn/detail/*/*.html', N'<!--正文-->', N'<!-- 点赞 -->', CAST(0x0000A79E009ACE78 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (22, N'中国新闻网', N'http://www.chinanews.com/*/20*/*-*/*.shtml', N'<div id="ad_title" >', N'<div class="left_name">', CAST(0x0000A79E00573564 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (23, N'新华网', N'http://news.xinhuanet.com/*/20*-*/*/*.htm', N'<div class="h-title">', N'class="advise">', CAST(0x0000A79E0061D1CC AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (24, N'新京报网', N'http://www.bjnews.com.cn/*/20*/*/*/*.html', N'<div class="nitit_span">', N'<span id="editor_baidu">', CAST(0x0000A79E00408210 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (25, N'凤凰博报正文页', N'http://blog.ifeng.com/article/*.html', N'<div class="blog_main_left_content">', N'<!--151211a begin-->', CAST(0x0000A79E00487DD0 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (27, N'栖兰小筑论坛正文页', N'http://www.qilanxiaozhu.net/thread-*.html', N'<h1 class="ts">', N'<div id="comment_', CAST(0x0000A79E00A36F74 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (31, N'新浪微博正文页', N'http://weibo.com/*?refer_flag=1001', N'action-type="login">举报</a>', N'<em>收藏</em>', CAST(0x0000A79E003C05A0 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (32, N'云南信息港新闻栏目', N'http://news.yninfo.com/*/t20*.html', N'-content">', N'<div class="page"', CAST(0x0000A79E0073C968 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (33, N'昆明信息港正文页', N'http://xw.kunming.cn/a/*/content_*.htm', N'<!--enpcontent-->', N'<!--/enpcontent-->', CAST(0x0000A79E00AB83D0 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (34, N'西部网正文页', N'http://news.cnwest.com/content/*/content_*.htm', N'<h1 id="sharetitle">', N'<p class="bianji">', CAST(0x0000A79E006D482C AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (35, N'中国青年网正文页', N'http://*.youth.cn/*/t*_*.htm', N'<div class=trs_editor>', N'</div>', CAST(0x0000A79E009E307C AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (36, N'环球网文章页', N'http://*.huanqiu.com/article/*/*.html', N'<!--startprint-->', N'<!--相关新闻 begain-->', CAST(0x0000A79E006C20DC AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (37, N'参考消息中国文章页', N'http://www.cankaoxiaoxi.com/china/20*/*.shtml', N'<h1 class="h2 fz', N'<!-- @end 文章内容 -->', CAST(0x0000A79D0189B6A0 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (38, N'凯迪社区正文页', N'http://club.kdnet.net/dispbbs.asp?id=*&boardid=', N'<div class="postspecific">', N'<!--转贴-->', CAST(0x0000A79E0092A504 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (39, N'华声论坛帖子页', N'http://bbs.voc.com.cn/topic-*-1-1.html', N'<div id="content-info" name="content-info">', N'<!--助威列表-->', CAST(0x0000A79E0080AD68 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (40, N'龙腾网论坛帖子页', N'http://www.ltaaa.com/bbs/thread-*-1-1.html', N'<span id="thread_subject">', N'人收藏''" title="收藏本帖">', CAST(0x0000A79E0097818C AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (41, N'大公资讯新闻页', N'http://news.takungpao.com/mainland/*/*-*/*.html', N'<!-- 文章内容-->', N'<!-- 分页-->', CAST(0x0000A79E003EB6B0 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (42, N'人民网地方领导留言板正文', N'http://liuyan.people.com.cn/thread.php?tid=', N'<div class="liuyan_box03 w1200 clearfix">', N'<a&nbsp;style="font-size:12px;"&nbsp;href="http://liuyan.people.com.cn">来源：人民网《地方领导留言板》</a>', CAST(0x0000A79E00694470 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (43, N'微赞论坛正文页', N'www.vzan.com/t/d-', N'<div class="infor_f">', N'<div class="rely_oppose">', CAST(0x0000A79E00A320F0 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (46, N'法制晚报正页', N'http://www.fawan.com/20*/*/*/*.html', N'<span>正文</span>', N'<!--articlebox end-->', CAST(0x0000A79D01718EA4 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (47, N'新广网正文页', N'http://*.flyxg.com/20*/*_*/*.html', N'headline">', N'<div class="mvp-org-wrap"', CAST(0x0000A79E001EED30 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (48, N'微信文章正文', N'mp.weixin.qq.com/s?src=', N'<div class="rich_media_content " id="js_content">', N'<div class="ct_mpda_wrp"', CAST(0x0000A79D014CE9C8 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (49, N'盐城响水论坛', N'www.224600.com/forum.php?mod=viewthread&tid=*&extra=page%3d2', N'<h1 class="ts">', N'<div id="comment_', CAST(0x0000A79E0041F58C AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (50, N'淮安网', N'www.huaian.com/read-htm-tid-*.html', N'<!--帖子楼层开始-->', N'<!--发帖回复-->', CAST(0x0000A79E008817D8 AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (51, N'宿迁论坛', N'www.sqee.cn/thread-*-1-1.html', N'<h1 class="ts">
', N'<div id="comment_', CAST(0x0000A79E0025362C AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (52, N'社区动力', N'http://www.zuohaiyizhan.net/thread-*-1-1.html', N'<h1 class="ts">
', N'<div id="comment_', CAST(0x0000A79E0073DFAC AS DateTime))
INSERT [dbo].[gogo_Contentidentification] ([id], [mc], [matchurl], [str1], [str2], [Ltime]) VALUES (57, N'百度贴吧正文页', N'http://tieba.baidu.com/p', N'<h1 class="core_title_txt  " title="', N'</cc>', CAST(0x0000A7B301674DA4 AS DateTime))
SET IDENTITY_INSERT [dbo].[gogo_Contentidentification] OFF
/****** Object:  Table [dbo].[gogo_character_number_config]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_character_number_config](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[mc] [nvarchar](20) NULL,
	[kg] [bit] NULL,
	[bds] [nvarchar](500) NULL,
	[s_not_letter] [bit] NULL,
	[s_not_number] [bit] NULL,
	[s_not_str] [nvarchar](100) NULL,
	[e_not_letter] [bit] NULL,
	[e_not_number] [bit] NULL,
	[e_not_str] [nvarchar](100) NULL,
	[s_str] [nvarchar](100) NULL,
	[s_str_jl] [int] NULL,
	[e_str] [nvarchar](100) NULL,
	[e_str_jl] [int] NULL,
	[cxms] [int] NULL,
	[fw] [int] NULL,
	[qz] [int] NULL,
	[killstr] [nvarchar](100) NULL,
 CONSTRAINT [PK_gogo_character_number_config] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_character_number_config] ON
INSERT [dbo].[gogo_character_number_config] ([id], [mc], [kg], [bds], [s_not_letter], [s_not_number], [s_not_str], [e_not_letter], [e_not_number], [e_not_str], [s_str], [s_str_jl], [e_str], [e_str_jl], [cxms], [fw], [qz], [killstr]) VALUES (1, N'电话号码', 1, N'(\+86)?(-)?((1(\d{10}))|(0(\d{10,11}))|(0(\d{2,3})-(\d{7,8})))', 0, 1, N'', 0, 1, N'', N'电话|手机|联系|致电|来电', 10, N'电话|手机|联系|致电|来电', 10, 1, 500, 100, N'-|+86')
INSERT [dbo].[gogo_character_number_config] ([id], [mc], [kg], [bds], [s_not_letter], [s_not_number], [s_not_str], [e_not_letter], [e_not_number], [e_not_str], [s_str], [s_str_jl], [e_str], [e_str_jl], [cxms], [fw], [qz], [killstr]) VALUES (4, N'电子邮箱', 1, N'[a-zA-Z0-9._%+-]+@(?!.*\.\..*)[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}', 0, 0, N'', 0, 0, N'', N'', 10, N'', 10, 1, 500, 90, N'')
SET IDENTITY_INSERT [dbo].[gogo_character_number_config] OFF
/****** Object:  Table [dbo].[gogo_browserusergent]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_browserusergent](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[mc] [nvarchar](50) NULL,
	[nr] [nvarchar](max) NULL,
	[qz] [int] NULL,
 CONSTRAINT [PK_gogo_browserusergent] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_browserusergent] ON
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (1, N'InternetExplorer10', N'Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.2; WOW64; Trident/6.0)', 1000)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (2, N'Firefox', N'Mozilla/5.0 (Windows; U; Windows NT 5.2) Gecko/2008070208 Firefox/3.0.1', 900)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (3, N'Safari', N'Mozilla/5.0 (Windows; U; Windows NT 5.2) AppleWebKit/525.13 (KHTML, like Gecko) Version/3.1 Safari/525.13', 800)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (4, N'Safari移动设备', N'Mozilla/5.0 (iPhone; U; CPU like Mac OS X) AppleWebKit/420.1 (KHTML, like Gecko) Version/3.0 Mobile/4A93 Safari/419.3', 700)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (5, N'Chrome', N'Mozilla/5.0 (Windows; U; Windows NT 5.2) AppleWebKit/525.13 (KHTML, like Gecko) Chrome/0.2.149.27 Safari/525.13', 600)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (6, N'安卓原生', N'Mozilla/5.0 (Linux; U; Android 4.0.3; zh-cn; M032 Build/IML74K) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30', 300)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (7, N'Navigator', N'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.12) Gecko/20080219 Firefox/2.0.0.12 Navigator/9.0.0.6', 500)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (8, N'Opera', N'Mozilla/5.0 (Macintosh; PPC Mac OS X; U; en) Opera 8.0', 400)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (9, N'微信（iphone）', N'Mozilla/5.0 (iPhone; CPU iPhone OS 5_1 like Mac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Mobile/9B176 MicroMessenger/4.3.2', 200)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (10, N'微信（安卓）', N'Mozilla/5.0 (Linux; U; Android 2.3.6; zh-cn; GT-S5660 Build/GINGERBREAD) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1 MicroMessenger/4.5.255', 100)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (11, N'百度爬虫', N'Baiduspider+(+http://www.baidu.com/search/spider.htm)', 90)
INSERT [dbo].[gogo_browserusergent] ([id], [mc], [nr], [qz]) VALUES (12, N'谷歌爬虫', N'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 80)
SET IDENTITY_INSERT [dbo].[gogo_browserusergent] OFF
/****** Object:  Table [dbo].[gogo_articleclass]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_articleclass](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[mc] [nvarchar](50) NULL,
	[qz] [int] NULL,
 CONSTRAINT [PK_gogo_articleclass] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_articleclass] ON
INSERT [dbo].[gogo_articleclass] ([id], [mc], [qz]) VALUES (1, N'文件通知', 100)
INSERT [dbo].[gogo_articleclass] ([id], [mc], [qz]) VALUES (2, N'规章制度', 90)
INSERT [dbo].[gogo_articleclass] ([id], [mc], [qz]) VALUES (3, N'经验交流', 80)
INSERT [dbo].[gogo_articleclass] ([id], [mc], [qz]) VALUES (4, N'系统服务', 70)
INSERT [dbo].[gogo_articleclass] ([id], [mc], [qz]) VALUES (5, N'其他', 60)
SET IDENTITY_INSERT [dbo].[gogo_articleclass] OFF
/****** Object:  Table [dbo].[gogo_adminlog]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_adminlog](
	[ac] [nvarchar](50) NULL,
	[t] [datetime] NULL,
	[ip] [nvarchar](50) NULL,
	[info] [nvarchar](max) NULL,
	[port] [nvarchar](10) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[gogo_adminlog] ([ac], [t], [ip], [info], [port]) VALUES (N'admin', CAST(0x0000A7D5016AE7E8 AS DateTime), N'127.0.0.1', N'删除用户日志，时间设置2017-08-20 23:59:59', N'28733')
INSERT [dbo].[gogo_adminlog] ([ac], [t], [ip], [info], [port]) VALUES (N'admin', CAST(0x0000A7D6000ED738 AS DateTime), N'127.0.0.1', N'修改系统基本配置', N'31077')
/****** Object:  Table [dbo].[gogo_admin]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_admin](
	[ac] [nvarchar](50) NOT NULL,
	[pwd] [nvarchar](50) NOT NULL,
	[jurisdictions] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[tel] [nvarchar](50) NULL,
	[mailaddress] [nvarchar](50) NULL,
	[about] [nvarchar](200) NULL,
	[dpmid] [int] NULL,
	[qz] [int] NULL,
	[zw] [nvarchar](50) NULL,
	[newksid] [nvarchar](max) NULL,
	[tjday] [int] NULL,
	[tjhs] [int] NULL,
	[tj1w] [int] NULL,
	[tj1h] [int] NULL,
	[tj2w] [int] NULL,
	[tj2h] [int] NULL,
	[hs] [int] NULL,
	[zs] [int] NULL,
 CONSTRAINT [PK_gogo_admin] PRIMARY KEY CLUSTERED 
(
	[ac] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_dpmid] ON [dbo].[gogo_admin] 
(
	[dpmid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_mailaddress] ON [dbo].[gogo_admin] 
(
	[mailaddress] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_tel] ON [dbo].[gogo_admin] 
(
	[tel] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
INSERT [dbo].[gogo_admin] ([ac], [pwd], [jurisdictions], [name], [tel], [mailaddress], [about], [dpmid], [qz], [zw], [newksid], [tjday], [tjhs], [tj1w], [tj1h], [tj2w], [tj2h], [hs], [zs]) VALUES (N'admin', N'7a57a5a743894a0e', N'6,3,2,22,23,19,20,5,11,21,1', N'系统管理员', N'', N'', N'', 100000000, 0, N'系统管理员', N'37', 10, 7, 740, 340, 740, 360, 15, 25)
/****** Object:  Table [dbo].[gogo_whitelist]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_whitelist](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dpmid] [int] NULL,
	[address] [nvarchar](max) NULL,
	[addressmode] [int] NULL,
	[csanmode] [int] NULL,
 CONSTRAINT [PK_gogo_whitelist] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_keys]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_keys](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[mc] [nvarchar](50) NULL,
	[nr] [nvarchar](max) NULL,
	[dpmid] [int] NULL,
 CONSTRAINT [PK_gogo_keys] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_dpmid] ON [dbo].[gogo_keys] 
(
	[dpmid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_keys] ON
INSERT [dbo].[gogo_keys] ([id], [mc], [nr], [dpmid]) VALUES (21, N'全国省级名称', N'北京
浙江
天津
安徽
上海
福建
重庆
江西
山东
河南
内蒙
湖北
新疆
湖南
宁夏
广东
西藏
海南
广西
四川
河北
贵州
山西
云南
辽宁
陕西
吉林
甘肃
黑龙江
青海
江苏
香港
台湾
澳门', 100000000)
INSERT [dbo].[gogo_keys] ([id], [mc], [nr], [dpmid]) VALUES (22, N'党政机关企事业单位名词', N'教育科学文化卫生委员会
教科卫
外事委员会
华侨委员会
政协
检察院
法院
组织部
宣传部
统战部
政法委
政策研究室
纪律检查委员会
纪委
机构编制委员会办公室
编办
外事办
对台办
直属机关工作委员会
直属机关工委
事务管理局
精神文明办公室
档案馆
档案局
保密办
党校
党史研究室
文献研究室
发改委
科技局
民族事务委员会
监察局
公安局
安全局
民政局
司法局
人事局
劳动和社会保障局
劳动局
人社局
财政局
审计局
中国人民银行
对外经济贸易合作局
农业局
水利局
建设局
国土局
信息产业局
铁道局
交通局
文化局
教育局
卫生局
计划生育委员会
计生委
统计局
工商行政管理总局
工商局
海关
气象局
民用航空总局
民航局
海洋局
地震局
旅游局
新闻出版总署
质量监督检验检疫总局
质监局
广播电影电视总局
广电局
宗教事务局
机关事务管理局
林业局
法制办公
外国专家局
经济体制改革办公室
供销合作总社
供销社
邮政局
税务局
国税局
地税局
粮食局
安全生产监督管理局
安监局
体育局
文物局
信访局
烟草专卖局
知识产权局
药品监督管理局
药监局
食药监局
测绘局
环境保护局
环保局
中医药管理局
标准化管理委员会
认证认可监督管理委员会
自然科学基金委员会
信息中心
工商银行
农业银行
中国银行
建设银行
人民保险公司
交通银行
电力公司
南方电网
电信公司
移动公司
联合公司
招商局
开发银行
进出口银行
农业发展银行
人寿保险
工会
中国共产主义青年团委员会
团委
妇女联合会
妇联
工商业联合会
工商联
职工思想政治工作研究会
关心下一代工作委员会
文学艺术界联合会
新闻工作者协会
作家协会
法学会
科学技术协会
科协
工程物理研究院
国际贸易促进委员会
人民对外友好协会
人民外交学会
红十字会总会
残疾人联合会
残联
归国华侨联合会
台湾同胞联谊会
欧美同学会
黄埔军校同学会
宋庆龄基金会
电子科技集团公司
生物制品总公司
钢铁工贸集团公司
煤炭科学研究总院
机械科学研究院
转制科研单位
总装备部
民主同盟委员会
民盟
国民党革命委员会委员会
民革
民主建国会委员会
民进
民主促进会委员会
民建
农工民主党
致工党
九三学社
台湾民主自治同盟委员会
民治
政府
党委
市委
县委
学校
医院
局长
书记
校长
院长', 100000000)
INSERT [dbo].[gogo_keys] ([id], [mc], [nr], [dpmid]) VALUES (23, N'党政机关负面词', N'不作为
贪污
腐败
打人
暴力执法
嫖娼
婚外情
小三
不正当关系
情妇
包养
警匪一家
拿回扣
行贿
受贿
公车私用
贪赃枉法
收黑钱
挪用公款
假公济私
不管事
渎职
官商勾结
伪造证据
黑幕
内幕
辱骂
殴打
追打
强奸
侮辱
残害
剥削
欺诈
侵占
腐化
以权谋私
敛财
违纪
操蛋
妈b
徇私枉法
人大于法
权色交易
金钱权利交易
草菅人命
不依法办案
强征
顶风违法
顶风违纪
顶风作案
玩忽职守
逼迫
保护伞
黑社会
黑恶势力', 100000000)
SET IDENTITY_INSERT [dbo].[gogo_keys] OFF
/****** Object:  Table [dbo].[gogo_article]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_article](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[lmid] [int] NULL,
	[ts] [nvarchar](50) NULL,
	[jdbt] [nvarchar](max) NULL,
	[ys] [nvarchar](50) NULL,
	[zx] [int] NULL,
	[wzbt] [nvarchar](max) NULL,
	[fbt] [nvarchar](max) NULL,
	[gjz] [nvarchar](50) NULL,
	[zz] [nvarchar](50) NULL,
	[wzly] [nvarchar](50) NULL,
	[djcs] [int] NULL,
	[zxlj] [nvarchar](max) NULL,
	[ltdz] [nvarchar](max) NULL,
	[wzjs] [ntext] NULL,
	[nr] [ntext] NULL,
	[tjsj] [datetime] NULL,
	[bjr] [nvarchar](50) NULL,
	[qz] [int] NULL,
	[dpmid] [int] NULL,
	[refresh] [int] NULL,
 CONSTRAINT [PK_gogo_article] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_character_number]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_character_number](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[cid] [int] NULL,
	[nu] [nvarchar](50) NULL,
	[bt] [nvarchar](100) NULL,
	[url] [nvarchar](250) NULL,
	[host] [nvarchar](50) NULL,
	[nr] [ntext] NULL,
	[cjsj] [datetime] NULL,
	[testnr] [nvarchar](80) NULL,
 CONSTRAINT [PK_gogo_character_number] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [for_insert_q] ON [dbo].[gogo_character_number] 
(
	[cid] ASC,
	[nu] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_host] ON [dbo].[gogo_character_number] 
(
	[host] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_nu] ON [dbo].[gogo_character_number] 
(
	[nu] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_testnr] ON [dbo].[gogo_character_number] 
(
	[testnr] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_url] ON [dbo].[gogo_character_number] 
(
	[url] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_keywordsstrategy]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_keywordsstrategy](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dpmid] [int] NULL,
	[mc] [nvarchar](50) NULL,
	[kg] [bit] NULL,
	[jb] [int] NULL,
	[msg] [bit] NULL,
	[keysmod] [int] NULL,
	[jg] [int] NULL,
	[ipc] [int] NULL,
	[ips] [nvarchar](max) NULL,
	[nokeys] [nvarchar](max) NULL,
	[qz] [int] NULL,
 CONSTRAINT [PK_gogo_keywordsstrategy] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [for_webpage] ON [dbo].[gogo_keywordsstrategy] 
(
	[kg] ASC,
	[dpmid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_dpmid] ON [dbo].[gogo_keywordsstrategy] 
(
	[dpmid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_kg] ON [dbo].[gogo_keywordsstrategy] 
(
	[kg] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_keywordsstrategy] ON
INSERT [dbo].[gogo_keywordsstrategy] ([id], [dpmid], [mc], [kg], [jb], [msg], [keysmod], [jg], [ipc], [ips], [nokeys], [qz]) VALUES (37, 100000000, N'全国党政机关负面舆情', 1, 1, 0, 4, 50, 0, N'', N'', 200)
SET IDENTITY_INSERT [dbo].[gogo_keywordsstrategy] OFF
/****** Object:  Table [dbo].[gogo_task]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_task](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dpmid] [int] NULL,
	[mc] [nvarchar](50) NULL,
	[urls] [nvarchar](max) NULL,
	[kg] [bit] NULL,
	[zq] [nvarchar](4) NULL,
	[fz] [int] NULL,
	[rq] [nvarchar](10) NULL,
	[xq] [int] NULL,
	[hs] [int] NULL,
	[h] [int] NULL,
	[m] [int] NULL,
	[ksmode] [int] NULL,
	[ddsj] [int] NULL,
	[depth] [int] NULL,
	[browserusergent] [int] NULL,
	[host] [nvarchar](50) NULL,
	[ip1] [nvarchar](50) NULL,
	[ip2] [nvarchar](50) NULL,
	[zt] [int] NULL,
	[zl] [nvarchar](50) NULL,
	[time1] [datetime] NULL,
	[time2] [datetime] NULL,
	[sml] [int] NULL,
	[smgjg] [int] NULL,
	[recordhtml] [int] NULL,
	[matchurl] [nvarchar](200) NULL,
	[matchurl1] [nvarchar](200) NULL,
	[urlAnalytical] [int] NULL,
	[sjxz] [int] NULL,
	[sjxz_jq] [bit] NULL,
	[nrsb] [bit] NULL,
	[Encodingmode] [nvarchar](50) NULL,
	[ipc] [int] NULL,
	[ips] [nvarchar](max) NULL,
	[samej] [int] NULL,
	[dlms] [int] NULL,
	[chtml] [bit] NULL,
	[maxsize] [bigint] NULL,
	[maxsj] [int] NULL,
	[nohtml] [nvarchar](200) NULL,
	[KeepAlive] [int] NULL,
 CONSTRAINT [PK_gogo_task] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [maxsj] ON [dbo].[gogo_task] 
(
	[maxsj] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_depth] ON [dbo].[gogo_task] 
(
	[depth] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_dpmid] ON [dbo].[gogo_task] 
(
	[dpmid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_fz] ON [dbo].[gogo_task] 
(
	[fz] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_h] ON [dbo].[gogo_task] 
(
	[h] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_kg] ON [dbo].[gogo_task] 
(
	[kg] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_m] ON [dbo].[gogo_task] 
(
	[m] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_sml] ON [dbo].[gogo_task] 
(
	[sml] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_time1] ON [dbo].[gogo_task] 
(
	[time1] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_time2] ON [dbo].[gogo_task] 
(
	[time2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_zl] ON [dbo].[gogo_task] 
(
	[zl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_zq] ON [dbo].[gogo_task] 
(
	[zq] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_zt] ON [dbo].[gogo_task] 
(
	[zt] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_task] ON
INSERT [dbo].[gogo_task] ([id], [dpmid], [mc], [urls], [kg], [zq], [fz], [rq], [xq], [hs], [h], [m], [ksmode], [ddsj], [depth], [browserusergent], [host], [ip1], [ip2], [zt], [zl], [time1], [time2], [sml], [smgjg], [recordhtml], [matchurl], [matchurl1], [urlAnalytical], [sjxz], [sjxz_jq], [nrsb], [Encodingmode], [ipc], [ips], [samej], [dlms], [chtml], [maxsize], [maxsj], [nohtml], [KeepAlive]) VALUES (61, 100000000, N'天涯论坛-百姓声音', N'http://bbs.tianya.cn/list-828-1.shtml', 1, N'间隔', 60, N'', 1, 1, 9, 0, 0, 10000, 1, 1, N'bbs.tianya.cn', N'', N'', 0, N'', CAST(0x0000A7B3016733DC AS DateTime), CAST(0x0000A7B301679AFC AS DateTime), 90, 1440, 2, N'http://bbs.tianya.cn/post-', N'http://bbs.tianya.cn/post-', 0, 3, 1, 1, N'', 0, N'', 1, 0, 0, 200, 4320, N'', 0)
INSERT [dbo].[gogo_task] ([id], [dpmid], [mc], [urls], [kg], [zq], [fz], [rq], [xq], [hs], [h], [m], [ksmode], [ddsj], [depth], [browserusergent], [host], [ip1], [ip2], [zt], [zl], [time1], [time2], [sml], [smgjg], [recordhtml], [matchurl], [matchurl1], [urlAnalytical], [sjxz], [sjxz_jq], [nrsb], [Encodingmode], [ipc], [ips], [samej], [dlms], [chtml], [maxsize], [maxsj], [nohtml], [KeepAlive]) VALUES (62, 100000000, N'百度贴吧指定板块', N'http://tieba.baidu.com/f?ie=utf-8&kw=%E4%BA%91%E5%8D%97', 1, N'间隔', 60, N'', 1, 1, 9, 0, 0, 5000, 1, 1, N'tieba.baidu.com', N'', N'', 0, N'', CAST(0x0000A7B3016733DC AS DateTime), CAST(0x0000A7B3016776A8 AS DateTime), 70, 14400, 2, N'http://tieba.baidu.com/p', N'http://tieba.baidu.com/p', 0, 3, 1, 1, N'', 0, N'', 1, 0, 1, 1024, 4320, N'', 0)
SET IDENTITY_INSERT [dbo].[gogo_task] OFF
/****** Object:  Table [dbo].[gogo_ProxyServerTest]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_ProxyServerTest](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[psid] [int] NULL,
	[testtime] [datetime] NULL,
	[zt] [int] NULL,
	[hs] [int] NULL,
 CONSTRAINT [PK_gogo_ProxyServerTest] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Index_gogo_ProxyServerTest] ON [dbo].[gogo_ProxyServerTest] 
(
	[psid] ASC,
	[testtime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_hs] ON [dbo].[gogo_ProxyServerTest] 
(
	[hs] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_psid] ON [dbo].[gogo_ProxyServerTest] 
(
	[psid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_testtime] ON [dbo].[gogo_ProxyServerTest] 
(
	[testtime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_zt] ON [dbo].[gogo_ProxyServerTest] 
(
	[zt] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_warning]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_warning](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ksid] [int] NULL,
	[wpid] [int] NULL,
	[dpmid] [int] NULL,
	[addtime] [datetime] NULL,
	[keys] [nvarchar](200) NULL,
 CONSTRAINT [PK_gogo_warning] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [for_webpage_Analysis1] ON [dbo].[gogo_warning] 
(
	[dpmid] ASC,
	[ksid] ASC,
	[addtime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_addtime] ON [dbo].[gogo_warning] 
(
	[addtime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_dpmid] ON [dbo].[gogo_warning] 
(
	[dpmid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_keys] ON [dbo].[gogo_warning] 
(
	[keys] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_ksid] ON [dbo].[gogo_warning] 
(
	[ksid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_wpid] ON [dbo].[gogo_warning] 
(
	[wpid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_tasklog]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_tasklog](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[tid] [int] NULL,
	[time1] [datetime] NULL,
	[time2] [datetime] NULL,
	[hs] [int] NULL,
	[sml] [int] NULL,
	[taskbs] [nvarchar](50) NULL,
	[qtsm] [nvarchar](max) NULL,
	[zql] [int] NULL,
	[zqsbl] [int] NULL,
 CONSTRAINT [PK_gogo_tasklog] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [o_taskbs] ON [dbo].[gogo_tasklog] 
(
	[taskbs] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[gogo_keyword_sstrategy_relational]    Script Date: 08/21/2017 00:55:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gogo_keyword_sstrategy_relational](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[kid] [int] NULL,
	[sid] [int] NULL,
	[mode] [int] NULL,
 CONSTRAINT [PK_gogo_keyword_sstrategy_relational] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[gogo_keyword_sstrategy_relational] ON
INSERT [dbo].[gogo_keyword_sstrategy_relational] ([id], [kid], [sid], [mode]) VALUES (234, 21, 37, 1)
INSERT [dbo].[gogo_keyword_sstrategy_relational] ([id], [kid], [sid], [mode]) VALUES (235, 22, 37, 1)
INSERT [dbo].[gogo_keyword_sstrategy_relational] ([id], [kid], [sid], [mode]) VALUES (236, 23, 37, 1)
SET IDENTITY_INSERT [dbo].[gogo_keyword_sstrategy_relational] OFF
/****** Object:  ForeignKey [FK_gogo_whitelist_gogo_department]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_whitelist]  WITH CHECK ADD  CONSTRAINT [FK_gogo_whitelist_gogo_department] FOREIGN KEY([dpmid])
REFERENCES [dbo].[gogo_department] ([id])
GO
ALTER TABLE [dbo].[gogo_whitelist] CHECK CONSTRAINT [FK_gogo_whitelist_gogo_department]
GO
/****** Object:  ForeignKey [FK_gogo_keys_gogo_department]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_keys]  WITH CHECK ADD  CONSTRAINT [FK_gogo_keys_gogo_department] FOREIGN KEY([dpmid])
REFERENCES [dbo].[gogo_department] ([id])
GO
ALTER TABLE [dbo].[gogo_keys] CHECK CONSTRAINT [FK_gogo_keys_gogo_department]
GO
/****** Object:  ForeignKey [FK_gogo_article_gogo_articleclass]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_article]  WITH CHECK ADD  CONSTRAINT [FK_gogo_article_gogo_articleclass] FOREIGN KEY([lmid])
REFERENCES [dbo].[gogo_articleclass] ([id])
GO
ALTER TABLE [dbo].[gogo_article] CHECK CONSTRAINT [FK_gogo_article_gogo_articleclass]
GO
/****** Object:  ForeignKey [FK_gogo_article_gogo_department]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_article]  WITH CHECK ADD  CONSTRAINT [FK_gogo_article_gogo_department] FOREIGN KEY([dpmid])
REFERENCES [dbo].[gogo_department] ([id])
GO
ALTER TABLE [dbo].[gogo_article] CHECK CONSTRAINT [FK_gogo_article_gogo_department]
GO
/****** Object:  ForeignKey [FK_gogo_character_number_gogo_character_number_config]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_character_number]  WITH CHECK ADD  CONSTRAINT [FK_gogo_character_number_gogo_character_number_config] FOREIGN KEY([cid])
REFERENCES [dbo].[gogo_character_number_config] ([id])
GO
ALTER TABLE [dbo].[gogo_character_number] CHECK CONSTRAINT [FK_gogo_character_number_gogo_character_number_config]
GO
/****** Object:  ForeignKey [FK_gogo_keywordsstrategy_gogo_department]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_keywordsstrategy]  WITH CHECK ADD  CONSTRAINT [FK_gogo_keywordsstrategy_gogo_department] FOREIGN KEY([dpmid])
REFERENCES [dbo].[gogo_department] ([id])
GO
ALTER TABLE [dbo].[gogo_keywordsstrategy] CHECK CONSTRAINT [FK_gogo_keywordsstrategy_gogo_department]
GO
/****** Object:  ForeignKey [FK_gogo_task_gogo_browserusergent]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_task]  WITH CHECK ADD  CONSTRAINT [FK_gogo_task_gogo_browserusergent] FOREIGN KEY([browserusergent])
REFERENCES [dbo].[gogo_browserusergent] ([id])
GO
ALTER TABLE [dbo].[gogo_task] CHECK CONSTRAINT [FK_gogo_task_gogo_browserusergent]
GO
/****** Object:  ForeignKey [FK_gogo_task_gogo_department]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_task]  WITH CHECK ADD  CONSTRAINT [FK_gogo_task_gogo_department] FOREIGN KEY([dpmid])
REFERENCES [dbo].[gogo_department] ([id])
GO
ALTER TABLE [dbo].[gogo_task] CHECK CONSTRAINT [FK_gogo_task_gogo_department]
GO
/****** Object:  ForeignKey [FK_gogo_ProxyServerTest_gogo_ProxyServer]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_ProxyServerTest]  WITH CHECK ADD  CONSTRAINT [FK_gogo_ProxyServerTest_gogo_ProxyServer] FOREIGN KEY([psid])
REFERENCES [dbo].[gogo_ProxyServer] ([id])
GO
ALTER TABLE [dbo].[gogo_ProxyServerTest] CHECK CONSTRAINT [FK_gogo_ProxyServerTest_gogo_ProxyServer]
GO
/****** Object:  ForeignKey [FK_gogo_warning_gogo_keywordsstrategy]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_warning]  WITH CHECK ADD  CONSTRAINT [FK_gogo_warning_gogo_keywordsstrategy] FOREIGN KEY([ksid])
REFERENCES [dbo].[gogo_keywordsstrategy] ([id])
GO
ALTER TABLE [dbo].[gogo_warning] CHECK CONSTRAINT [FK_gogo_warning_gogo_keywordsstrategy]
GO
/****** Object:  ForeignKey [FK_gogo_warning_gogo_webpage]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_warning]  WITH CHECK ADD  CONSTRAINT [FK_gogo_warning_gogo_webpage] FOREIGN KEY([wpid])
REFERENCES [dbo].[gogo_webpage] ([id])
GO
ALTER TABLE [dbo].[gogo_warning] CHECK CONSTRAINT [FK_gogo_warning_gogo_webpage]
GO
/****** Object:  ForeignKey [FK_gogo_tasklog_gogo_task]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_tasklog]  WITH CHECK ADD  CONSTRAINT [FK_gogo_tasklog_gogo_task] FOREIGN KEY([tid])
REFERENCES [dbo].[gogo_task] ([id])
GO
ALTER TABLE [dbo].[gogo_tasklog] CHECK CONSTRAINT [FK_gogo_tasklog_gogo_task]
GO
/****** Object:  ForeignKey [FK_gogo_keyword_sstrategy_relational_gogo_keys]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_keyword_sstrategy_relational]  WITH CHECK ADD  CONSTRAINT [FK_gogo_keyword_sstrategy_relational_gogo_keys] FOREIGN KEY([kid])
REFERENCES [dbo].[gogo_keys] ([id])
GO
ALTER TABLE [dbo].[gogo_keyword_sstrategy_relational] CHECK CONSTRAINT [FK_gogo_keyword_sstrategy_relational_gogo_keys]
GO
/****** Object:  ForeignKey [FK_gogo_keyword_sstrategy_relational_gogo_keywordsstrategy]    Script Date: 08/21/2017 00:55:24 ******/
ALTER TABLE [dbo].[gogo_keyword_sstrategy_relational]  WITH CHECK ADD  CONSTRAINT [FK_gogo_keyword_sstrategy_relational_gogo_keywordsstrategy] FOREIGN KEY([sid])
REFERENCES [dbo].[gogo_keywordsstrategy] ([id])
GO
ALTER TABLE [dbo].[gogo_keyword_sstrategy_relational] CHECK CONSTRAINT [FK_gogo_keyword_sstrategy_relational_gogo_keywordsstrategy]
GO
