/****** Object:  Database HrINetDB    Script Date: 2008-3-3 11:35:42 ******/
use master
go
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'HrINetDB')
	DROP DATABASE [HrINetDB]
GO

CREATE DATABASE [HrINetDB]
 COLLATE Chinese_PRC_CI_AS
GO

exec sp_dboption N'HrINetDB', N'autoclose', N'false'
GO

exec sp_dboption N'HrINetDB', N'bulkcopy', N'false'
GO

exec sp_dboption N'HrINetDB', N'trunc. log', N'true'
GO

exec sp_dboption N'HrINetDB', N'torn page detection', N'true'
GO

exec sp_dboption N'HrINetDB', N'read only', N'false'
GO

exec sp_dboption N'HrINetDB', N'dbo use', N'false'
GO

exec sp_dboption N'HrINetDB', N'single', N'false'
GO

exec sp_dboption N'HrINetDB', N'autoshrink', N'true'
GO

exec sp_dboption N'HrINetDB', N'ANSI null default', N'false'
GO

exec sp_dboption N'HrINetDB', N'recursive triggers', N'false'
GO

exec sp_dboption N'HrINetDB', N'ANSI nulls', N'false'
GO

exec sp_dboption N'HrINetDB', N'concat null yields null', N'false'
GO

exec sp_dboption N'HrINetDB', N'cursor close on commit', N'false'
GO

exec sp_dboption N'HrINetDB', N'default to local cursor', N'false'
GO

exec sp_dboption N'HrINetDB', N'quoted identifier', N'false'
GO

exec sp_dboption N'HrINetDB', N'ANSI warnings', N'false'
GO

exec sp_dboption N'HrINetDB', N'auto create statistics', N'true'
GO

exec sp_dboption N'HrINetDB', N'auto update statistics', N'true'
GO

use [HrINetDB]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_USER_REF_FILE]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[T_NTM_FileToUser] DROP CONSTRAINT FK_USER_REF_FILE
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Notify_REF_Notify2User]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[T_SC_DistanceNotify2User] DROP CONSTRAINT FK_Notify_REF_Notify2User
GO

/****** Object:  Table [dbo].[T_NTM_FileToUser]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NTM_FileToUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NTM_FileToUser]
GO

/****** Object:  Table [dbo].[T_SC_DistanceNotify2User]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_DistanceNotify2User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_DistanceNotify2User]
GO

/****** Object:  Table [dbo].[T_ADD_Invade]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_ADD_Invade]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_ADD_Invade]
GO

/****** Object:  Table [dbo].[T_CM_Call]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_CM_Call]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_CM_Call]
GO

/****** Object:  Table [dbo].[T_CM_CallToUser]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_CM_CallToUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_CM_CallToUser]
GO

/****** Object:  Table [dbo].[T_CM_Set]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_CM_Set]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_CM_Set]
GO

/****** Object:  Table [dbo].[T_ClientAcount_Table]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_ClientAcount_Table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_ClientAcount_Table]
GO

/****** Object:  Table [dbo].[T_Del_List]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Del_List]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Del_List]
GO

/****** Object:  Table [dbo].[T_EMailAddr_Table]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_EMailAddr_Table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_EMailAddr_Table]
GO

/****** Object:  Table [dbo].[T_File_Policy]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_File_Policy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_File_Policy]
GO

/****** Object:  Table [dbo].[T_IEPlug]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_IEPlug]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_IEPlug]
GO

/****** Object:  Table [dbo].[T_IE_Black]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_IE_Black]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_IE_Black]
GO

/****** Object:  Table [dbo].[T_IE_SEL]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_IE_SEL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_IE_SEL]
GO

/****** Object:  Table [dbo].[T_IE_Task_B]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_IE_Task_B]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_IE_Task_B]
GO

/****** Object:  Table [dbo].[T_IE_Task_W]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_IE_Task_W]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_IE_Task_W]
GO

/****** Object:  Table [dbo].[T_IE_Time_B]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_IE_Time_B]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_IE_Time_B]
GO

/****** Object:  Table [dbo].[T_IE_Time_W]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_IE_Time_W]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_IE_Time_W]
GO

/****** Object:  Table [dbo].[T_IE_User_B]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_IE_User_B]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_IE_User_B]
GO

/****** Object:  Table [dbo].[T_IE_User_W]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_IE_User_W]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_IE_User_W]
GO

/****** Object:  Table [dbo].[T_IE_Whilt]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_IE_Whilt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_IE_Whilt]
GO

/****** Object:  Table [dbo].[T_INET_CON]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_INET_CON]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_INET_CON]
GO

/****** Object:  Table [dbo].[T_ITAM_HardwareInfor]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_ITAM_HardwareInfor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_ITAM_HardwareInfor]
GO

/****** Object:  Table [dbo].[T_ITAM_SoftwareInfor]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_ITAM_SoftwareInfor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_ITAM_SoftwareInfor]
GO

/****** Object:  Table [dbo].[T_Invade_Belife]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Invade_Belife]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Invade_Belife]
GO

/****** Object:  Table [dbo].[T_Invade_InBreak]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Invade_InBreak]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Invade_InBreak]
GO

/****** Object:  Table [dbo].[T_LOOK_FILE]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_LOOK_FILE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_LOOK_FILE]
GO

/****** Object:  Table [dbo].[T_Log]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Log]
GO

/****** Object:  Table [dbo].[T_Log_Table]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Log_Table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Log_Table]
GO

/****** Object:  Table [dbo].[T_NAM_ChatMonitor]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NAM_ChatMonitor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NAM_ChatMonitor]
GO

/****** Object:  Table [dbo].[T_NAM_KeyboardMouse]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NAM_KeyboardMouse]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NAM_KeyboardMouse]
GO

/****** Object:  Table [dbo].[T_NAM_MailMonitor]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NAM_MailMonitor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NAM_MailMonitor]
GO

/****** Object:  Table [dbo].[T_NAM_ProgramList]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NAM_ProgramList]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NAM_ProgramList]
GO

/****** Object:  Table [dbo].[T_NAM_ProgramReport]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NAM_ProgramReport]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NAM_ProgramReport]
GO

/****** Object:  Table [dbo].[T_NAM_RegeditProtect]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NAM_RegeditProtect]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NAM_RegeditProtect]
GO

/****** Object:  Table [dbo].[T_NAM_SiteList]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NAM_SiteList]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NAM_SiteList]
GO

/****** Object:  Table [dbo].[T_NCM_CliFlux]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NCM_CliFlux]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NCM_CliFlux]
GO

/****** Object:  Table [dbo].[T_NCM_FluxSet]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NCM_FluxSet]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NCM_FluxSet]
GO

/****** Object:  Table [dbo].[T_NCM_NetFlux]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NCM_NetFlux]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NCM_NetFlux]
GO

/****** Object:  Table [dbo].[T_NCM_ProtocolPort]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NCM_ProtocolPort]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NCM_ProtocolPort]
GO

/****** Object:  Table [dbo].[T_NMM_GetScreen]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NMM_GetScreen]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NMM_GetScreen]
GO

/****** Object:  Table [dbo].[T_NMM_IEConfigure]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NMM_IEConfigure]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NMM_IEConfigure]
GO

/****** Object:  Table [dbo].[T_NMM_NetAttribute]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NMM_NetAttribute]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NMM_NetAttribute]
GO

/****** Object:  Table [dbo].[T_NMM_NetConfigures]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NMM_NetConfigures]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NMM_NetConfigures]
GO

/****** Object:  Table [dbo].[T_NMM_NetDialUp]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NMM_NetDialUp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NMM_NetDialUp]
GO

/****** Object:  Table [dbo].[T_NSM_BrowseSiteAudit]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NSM_BrowseSiteAudit]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NSM_BrowseSiteAudit]
GO

/****** Object:  Table [dbo].[T_NSM_FileOperation]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NSM_FileOperation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NSM_FileOperation]
GO

/****** Object:  Table [dbo].[T_NSM_IpMac]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NSM_IpMac]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NSM_IpMac]
GO

/****** Object:  Table [dbo].[T_NSM_NewInstall]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NSM_NewInstall]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NSM_NewInstall]
GO

/****** Object:  Table [dbo].[T_NSM_Printer]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NSM_Printer]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NSM_Printer]
GO

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

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

/****** Object:  Table [dbo].[T_NTM_FileDispense]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_NTM_FileDispense]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_NTM_FileDispense]
GO

/****** Object:  Table [dbo].[T_PATCH_Inquiry]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_PATCH_Inquiry]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_PATCH_Inquiry]
GO

/****** Object:  Table [dbo].[T_PC_Process]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_PC_Process]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_PC_Process]
GO

/****** Object:  Table [dbo].[T_Patch_Userinfo]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Patch_Userinfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Patch_Userinfo]
GO

/****** Object:  Table [dbo].[T_Policy_Table]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Policy_Table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Policy_Table]
GO

/****** Object:  Table [dbo].[T_Pragram_TaskW]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Pragram_TaskW]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Pragram_TaskW]
GO

/****** Object:  Table [dbo].[T_Program_B_Time]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_B_Time]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_B_Time]
GO

/****** Object:  Table [dbo].[T_Program_B_User]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_B_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_B_User]
GO

/****** Object:  Table [dbo].[T_Program_Black]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_Black]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_Black]
GO

/****** Object:  Table [dbo].[T_Program_Protect_Program]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_Protect_Program]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_Protect_Program]
GO

/****** Object:  Table [dbo].[T_Program_Protect_Task]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_Protect_Task]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_Protect_Task]
GO

/****** Object:  Table [dbo].[T_Program_Protect_Time]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_Protect_Time]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_Protect_Time]
GO

/****** Object:  Table [dbo].[T_Program_Protect_User]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_Protect_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_Protect_User]
GO

/****** Object:  Table [dbo].[T_Program_SEL]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_SEL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_SEL]
GO

/****** Object:  Table [dbo].[T_Program_TaskB]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_TaskB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_TaskB]
GO

/****** Object:  Table [dbo].[T_Program_W_Time]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_W_Time]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_W_Time]
GO

/****** Object:  Table [dbo].[T_Program_W_User]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_W_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_W_User]
GO

/****** Object:  Table [dbo].[T_Program_White]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_Program_White]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_Program_White]
GO

/****** Object:  Table [dbo].[T_SCANIPLIST]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SCANIPLIST]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SCANIPLIST]
GO

/****** Object:  Table [dbo].[T_SC_ACOUNT]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_ACOUNT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_ACOUNT]
GO

/****** Object:  Table [dbo].[T_SC_ACOUNTUSER]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_ACOUNTUSER]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_ACOUNTUSER]
GO

/****** Object:  Table [dbo].[T_SC_Branchtment]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_Branchtment]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_Branchtment]
GO

/****** Object:  Table [dbo].[T_SC_Department]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_Department]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_Department]
GO

/****** Object:  Table [dbo].[T_SC_DistanceNotify]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_DistanceNotify]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_DistanceNotify]
GO

/****** Object:  Table [dbo].[T_SC_FuncManager]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_FuncManager]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_FuncManager]
GO

/****** Object:  Table [dbo].[T_SC_LogInfor]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_LogInfor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_LogInfor]
GO

/****** Object:  Table [dbo].[T_SC_OperateInfor]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_OperateInfor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_OperateInfor]
GO

/****** Object:  Table [dbo].[T_SC_Rest]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_Rest]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_Rest]
GO

/****** Object:  Table [dbo].[T_SC_RoseFunc]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_RoseFunc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_RoseFunc]
GO

/****** Object:  Table [dbo].[T_SC_RoseManager]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_RoseManager]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_RoseManager]
GO

/****** Object:  Table [dbo].[T_SC_RoseUser]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_RoseUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_RoseUser]
GO

/****** Object:  Table [dbo].[T_SC_Server_info]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_Server_info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_Server_info]
GO

/****** Object:  Table [dbo].[T_SC_UserManager]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SC_UserManager]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SC_UserManager]
GO

/****** Object:  Table [dbo].[T_SEC_AUTO]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SEC_AUTO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SEC_AUTO]
GO

/****** Object:  Table [dbo].[T_SEC_DDISK]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SEC_DDISK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SEC_DDISK]
GO

/****** Object:  Table [dbo].[T_SEC_DepFile]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SEC_DepFile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SEC_DepFile]
GO

/****** Object:  Table [dbo].[T_SEC_EDISK]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SEC_EDISK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SEC_EDISK]
GO

/****** Object:  Table [dbo].[T_SEC_KEYGROUP]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SEC_KEYGROUP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SEC_KEYGROUP]
GO

/****** Object:  Table [dbo].[T_SEC_STATE]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SEC_STATE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SEC_STATE]
GO

/****** Object:  Table [dbo].[T_SHUTDOWN_POLICY]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SHUTDOWN_POLICY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SHUTDOWN_POLICY]
GO

/****** Object:  Table [dbo].[T_SecFileType]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_SecFileType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_SecFileType]
GO

/****** Object:  Table [dbo].[T_ZCL_Func]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_ZCL_Func]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_ZCL_Func]
GO

/****** Object:  Table [dbo].[T_ZCL_List]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_ZCL_List]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_ZCL_List]
GO

/****** Object:  Table [dbo].[T_recordplay]    Script Date: 2008-3-3 11:35:43 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_recordplay]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_recordplay]
GO

/****** Object:  Login hrjd    Script Date: 2008-3-3 11:35:42 ******/
if not exists (select * from master.dbo.syslogins where loginname = N'hrjd')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'¼òÌåÖÐÎÄ'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'hrjd', N'hrjd123', @logindb, @loginlang
END
GO

/****** Object:  Login hrjd    Script Date: 2008-3-3 11:35:42 ******/
exec sp_addsrvrolemember N'hrjd', sysadmin
GO

/****** Object:  User dbo    Script Date: 2008-3-3 11:35:42 ******/
/****** Object:  User hrjd    Script Date: 2008-3-3 11:35:42 ******/
if not exists (select * from dbo.sysusers where name = N'hrjd' and uid < 16382)
	EXEC sp_grantdbaccess N'hrjd', N'hrjd123'

GO

/****** Object:  Table [dbo].[T_ADD_Invade]    Script Date: 2008-3-3 11:35:45 ******/
CREATE TABLE [dbo].[T_ADD_Invade] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[IP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[breakTime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_CM_Call]    Script Date: 2008-3-3 11:35:45 ******/
CREATE TABLE [dbo].[T_CM_Call] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[callType] [varchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
	[warnChange] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_CM_CallToUser]    Script Date: 2008-3-3 11:35:45 ******/
CREATE TABLE [dbo].[T_CM_CallToUser] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Idcall] [int] NULL ,
	[isDelete] [bit] NULL ,
	[isRead] [bit] NULL ,
	[toUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_CM_Set]    Script Date: 2008-3-3 11:35:45 ******/
CREATE TABLE [dbo].[T_CM_Set] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Type] [int] NULL ,
	[Dill] [int] NULL ,
	[Mess] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[iState] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_ClientAcount_Table]    Script Date: 2008-3-3 11:35:45 ******/
CREATE TABLE [dbo].[T_ClientAcount_Table] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Pc_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Client_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PassWord] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[iState] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Del_List]    Script Date: 2008-3-3 11:35:45 ******/
CREATE TABLE [dbo].[T_Del_List] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[VProgramName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[VPcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Flag] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_EMailAddr_Table]    Script Date: 2008-3-3 11:35:45 ******/
CREATE TABLE [dbo].[T_EMailAddr_Table] (
	[SMTP] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[User_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PassWord] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SendEMail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReceEMail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_File_Policy]    Script Date: 2008-3-3 11:35:46 ******/
CREATE TABLE [dbo].[T_File_Policy] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[taskName] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[filePath] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[pcName] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[IP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [int] NULL ,
	[type] [int] NULL ,
	[sendTime] [datetime] NULL ,
	[runType] [int] NULL ,
	[ifNotice] [int] NULL ,
	[noticeText] [char] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_IEPlug]    Script Date: 2008-3-3 11:35:46 ******/
CREATE TABLE [dbo].[T_IEPlug] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PlugName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Process] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_IE_Black]    Script Date: 2008-3-3 11:35:46 ******/
CREATE TABLE [dbo].[T_IE_Black] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vProgramName] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_IE_SEL]    Script Date: 2008-3-3 11:35:46 ******/
CREATE TABLE [dbo].[T_IE_SEL] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[AKey] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_IE_Task_B]    Script Date: 2008-3-3 11:35:46 ******/
CREATE TABLE [dbo].[T_IE_Task_B] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_IE_Task_W]    Script Date: 2008-3-3 11:35:46 ******/
CREATE TABLE [dbo].[T_IE_Task_W] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_IE_Time_B]    Script Date: 2008-3-3 11:35:46 ******/
CREATE TABLE [dbo].[T_IE_Time_B] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DStartTime] [datetime] NULL ,
	[DEndtime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_IE_Time_W]    Script Date: 2008-3-3 11:35:46 ******/
CREATE TABLE [dbo].[T_IE_Time_W] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DStartTime] [datetime] NULL ,
	[DEndTime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_IE_User_B]    Script Date: 2008-3-3 11:35:47 ******/
CREATE TABLE [dbo].[T_IE_User_B] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[vPCName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_IE_User_W]    Script Date: 2008-3-3 11:35:47 ******/
CREATE TABLE [dbo].[T_IE_User_W] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[vPCName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_IE_Whilt]    Script Date: 2008-3-3 11:35:47 ******/
CREATE TABLE [dbo].[T_IE_Whilt] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vProgramName] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_INET_CON]    Script Date: 2008-3-3 11:35:47 ******/
CREATE TABLE [dbo].[T_INET_CON] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vPcName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[StartTime] [datetime] NULL ,
	[EndTime] [datetime] NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_ITAM_HardwareInfor]    Script Date: 2008-3-3 11:35:47 ******/
CREATE TABLE [dbo].[T_ITAM_HardwareInfor] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[OS] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[cpuid] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[cpuck] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[hdid] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[mem] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[snd] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[dis] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[moni] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[ie] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[CD] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[floppy] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[netType] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[hdsp] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[HDID2] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_ITAM_SoftwareInfor]    Script Date: 2008-3-3 11:35:47 ******/
CREATE TABLE [dbo].[T_ITAM_SoftwareInfor] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[softName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[softInfor] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[edition] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[model] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[rest] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Invade_Belife]    Script Date: 2008-3-3 11:35:47 ******/
CREATE TABLE [dbo].[T_Invade_Belife] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Invade_InBreak]    Script Date: 2008-3-3 11:35:48 ******/
CREATE TABLE [dbo].[T_Invade_InBreak] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[IP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[breakTime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_LOOK_FILE]    Script Date: 2008-3-3 11:35:48 ******/
CREATE TABLE [dbo].[T_LOOK_FILE] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[FileName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[FileEX] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[AcountName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Log]    Script Date: 2008-3-3 11:35:48 ******/
CREATE TABLE [dbo].[T_Log] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ACOUNT] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[OP] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[OPDate] [datetime] NULL ,
	[UserName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Log_Table]    Script Date: 2008-3-3 11:35:48 ******/
CREATE TABLE [dbo].[T_Log_Table] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Acount] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[date] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NAM_ChatMonitor]    Script Date: 2008-3-3 11:35:48 ******/
CREATE TABLE [dbo].[T_NAM_ChatMonitor] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[chatType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[chatContext] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[formNumber] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[toNumber] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NAM_KeyboardMouse]    Script Date: 2008-3-3 11:35:48 ******/
CREATE TABLE [dbo].[T_NAM_KeyboardMouse] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[Type] [tinyint] NULL ,
	[isForbid] [bit] NULL ,
	[isSend] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NAM_MailMonitor]    Script Date: 2008-3-3 11:35:48 ******/
CREATE TABLE [dbo].[T_NAM_MailMonitor] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[mailTitle] [varchar] (160) COLLATE Chinese_PRC_CI_AS NULL ,
	[mailContext] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[formMail] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[toMail] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[mailAffix] [image] NULL ,
	[fujian] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NAM_ProgramList]    Script Date: 2008-3-3 11:35:49 ******/
CREATE TABLE [dbo].[T_NAM_ProgramList] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[processName] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[type] [bit] NULL ,
	[isSend] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NAM_ProgramReport]    Script Date: 2008-3-3 11:35:49 ******/
CREATE TABLE [dbo].[T_NAM_ProgramReport] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StartDateTime] [datetime] NULL ,
	[EndDateTime] [datetime] NULL ,
	[ProcessName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[datetime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NAM_RegeditProtect]    Script Date: 2008-3-3 11:35:49 ******/
CREATE TABLE [dbo].[T_NAM_RegeditProtect] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[Name] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[isProtect] [bit] NULL ,
	[isSend] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NAM_SiteList]    Script Date: 2008-3-3 11:35:49 ******/
CREATE TABLE [dbo].[T_NAM_SiteList] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[siteName] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[type] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NCM_CliFlux]    Script Date: 2008-3-3 11:35:49 ******/
CREATE TABLE [dbo].[T_NCM_CliFlux] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[fluxInRec] [float] NULL ,
	[fluxInSend] [float] NULL ,
	[fluxOutRec] [float] NULL ,
	[fluxOutSend] [float] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NCM_FluxSet]    Script Date: 2008-3-3 11:35:49 ******/
CREATE TABLE [dbo].[T_NCM_FluxSet] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[limitFlux] [int] NULL ,
	[isForbid] [bit] NULL ,
	[isCall] [bit] NULL ,
	[isSend] [bit] NULL ,
	[forbidType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NCM_NetFlux]    Script Date: 2008-3-3 11:35:49 ******/
CREATE TABLE [dbo].[T_NCM_NetFlux] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[flux] [int] NULL ,
	[state] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NCM_ProtocolPort]    Script Date: 2008-3-3 11:35:49 ******/
CREATE TABLE [dbo].[T_NCM_ProtocolPort] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[state] [int] NULL ,
	[port] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NMM_GetScreen]    Script Date: 2008-3-3 11:35:50 ******/
CREATE TABLE [dbo].[T_NMM_GetScreen] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[mender] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[context] [image] NULL ,
	[title] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NMM_IEConfigure]    Script Date: 2008-3-3 11:35:50 ******/
CREATE TABLE [dbo].[T_NMM_IEConfigure] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[IEPage] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Internet] [int] NULL ,
	[Intanet] [int] NULL ,
	[Bliave] [int] NULL ,
	[NoBliave] [int] NULL ,
	[iepageState] [int] NULL ,
	[clearstate] [int] NULL ,
	[secstate] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NMM_NetAttribute]    Script Date: 2008-3-3 11:35:50 ******/
CREATE TABLE [dbo].[T_NMM_NetAttribute] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[isForbid] [bit] NULL ,
	[isSend] [bit] NULL ,
	[mender] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NMM_NetConfigures]    Script Date: 2008-3-3 11:35:50 ******/
CREATE TABLE [dbo].[T_NMM_NetConfigures] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PCName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[AutoDNS] [int] NULL ,
	[AutoIP] [int] NULL ,
	[FirstDNS] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[OtherDNS] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[WinsServer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[OtherWinsServer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HttpProxy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FtpProxy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HttpPort] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FtpPort] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Flag] [int] NULL ,
	[NetCad] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mas] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[NewPcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[NoProx] [int] NULL ,
	[NewWorkGroup] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[History] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NMM_NetDialUp]    Script Date: 2008-3-3 11:35:50 ******/
CREATE TABLE [dbo].[T_NMM_NetDialUp] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[isForbid] [bit] NULL ,
	[isSend] [bit] NULL ,
	[mender] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NSM_BrowseSiteAudit]    Script Date: 2008-3-3 11:35:50 ******/
CREATE TABLE [dbo].[T_NSM_BrowseSiteAudit] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[siteAdress] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NSM_FileOperation]    Script Date: 2008-3-3 11:35:50 ******/
CREATE TABLE [dbo].[T_NSM_FileOperation] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[filePath] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[sortType] [varchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
	[cContent] [varchar] (1024) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NSM_IpMac]    Script Date: 2008-3-3 11:35:51 ******/
CREATE TABLE [dbo].[T_NSM_IpMac] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[userIP] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[userMac] [varbinary] (30) NULL ,
	[dateTime] [datetime] NULL ,
	[isBind] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NSM_NewInstall]    Script Date: 2008-3-3 11:35:51 ******/
CREATE TABLE [dbo].[T_NSM_NewInstall] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[forbidType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[isForbid] [bit] NULL ,
	[isSend] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NSM_Printer]    Script Date: 2008-3-3 11:35:51 ******/
CREATE TABLE [dbo].[T_NSM_Printer] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fileName] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[pageSum] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[filepath] [image] NULL ,
	[nfile] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[T_QQ_File] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PcName] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[FileName] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[FContent] [image] NULL ,
	[DateTime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[T_BBS_CONTENT] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[datetime] [datetime] NULL ,
	[content] [varchar] (6000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NTM_FileDispense]    Script Date: 2008-3-3 11:35:51 ******/
CREATE TABLE [dbo].[T_NTM_FileDispense] (
	[fileId] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[fileName] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[fileContext] [image] NULL ,
	[fromUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_PATCH_Inquiry]    Script Date: 2008-3-3 11:35:51 ******/
CREATE TABLE [dbo].[T_PATCH_Inquiry] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Down] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[OS] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[PatchName] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[PatchNum] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[FileSize] [int] NULL ,
	[Time] [datetime] NULL ,
	[Help] [char] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_PC_Process]    Script Date: 2008-3-3 11:35:51 ******/
CREATE TABLE [dbo].[T_PC_Process] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PCName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Process] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Patch_Userinfo]    Script Date: 2008-3-3 11:35:51 ******/
CREATE TABLE [dbo].[T_Patch_Userinfo] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PcName] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[OS] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[PatchFile] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[size] [bigint] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Policy_Table]    Script Date: 2008-3-3 11:35:51 ******/
CREATE TABLE [dbo].[T_Policy_Table] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[vType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[iState] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Pragram_TaskW]    Script Date: 2008-3-3 11:35:52 ******/
CREATE TABLE [dbo].[T_Pragram_TaskW] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_B_Time]    Script Date: 2008-3-3 11:35:52 ******/
CREATE TABLE [dbo].[T_Program_B_Time] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[VTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DStartTime] [datetime] NULL ,
	[DEndTime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_B_User]    Script Date: 2008-3-3 11:35:52 ******/
CREATE TABLE [dbo].[T_Program_B_User] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[VTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[VPcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_Black]    Script Date: 2008-3-3 11:35:52 ******/
CREATE TABLE [dbo].[T_Program_Black] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vProgramName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_Protect_Program]    Script Date: 2008-3-3 11:35:52 ******/
CREATE TABLE [dbo].[T_Program_Protect_Program] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vProgramName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_Protect_Task]    Script Date: 2008-3-3 11:35:52 ******/
CREATE TABLE [dbo].[T_Program_Protect_Task] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_Protect_Time]    Script Date: 2008-3-3 11:35:52 ******/
CREATE TABLE [dbo].[T_Program_Protect_Time] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DStartTime] [datetime] NULL ,
	[DEndTime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_Protect_User]    Script Date: 2008-3-3 11:35:52 ******/
CREATE TABLE [dbo].[T_Program_Protect_User] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[VPcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_SEL]    Script Date: 2008-3-3 11:35:53 ******/
CREATE TABLE [dbo].[T_Program_SEL] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[AKey] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_TaskB]    Script Date: 2008-3-3 11:35:53 ******/
CREATE TABLE [dbo].[T_Program_TaskB] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_W_Time]    Script Date: 2008-3-3 11:35:53 ******/
CREATE TABLE [dbo].[T_Program_W_Time] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[VTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DStartTime] [datetime] NULL ,
	[DEndTime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_W_User]    Script Date: 2008-3-3 11:35:53 ******/
CREATE TABLE [dbo].[T_Program_W_User] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[VTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[VPcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_Program_White]    Script Date: 2008-3-3 11:35:53 ******/
CREATE TABLE [dbo].[T_Program_White] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vProgramName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[vTaskName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SCANIPLIST]    Script Date: 2008-3-3 11:35:53 ******/
CREATE TABLE [dbo].[T_SCANIPLIST] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[StartIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[EndIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_ACOUNT]    Script Date: 2008-3-3 11:35:53 ******/
CREATE TABLE [dbo].[T_SC_ACOUNT] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[CoAcount] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PassWorld] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mess] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_ACOUNTUSER]    Script Date: 2008-3-3 11:35:53 ******/
CREATE TABLE [dbo].[T_SC_ACOUNTUSER] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Acount] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserPcName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_Branchtment]    Script Date: 2008-3-3 11:35:53 ******/
CREATE TABLE [dbo].[T_SC_Branchtment] (
	[branchId] [int] IDENTITY (1, 1) NOT NULL ,
	[branchName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[simpleCode] [varchar] (9) COLLATE Chinese_PRC_CI_AS NULL ,
	[BranchMan] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[telephone1] [varchar] (11) COLLATE Chinese_PRC_CI_AS NULL ,
	[telephone2] [varchar] (11) COLLATE Chinese_PRC_CI_AS NULL ,
	[delFlag] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_Department]    Script Date: 2008-3-3 11:35:54 ******/
CREATE TABLE [dbo].[T_SC_Department] (
	[depId] [int] IDENTITY (1, 1) NOT NULL ,
	[branchId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DepName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[simpleCode] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[depMan] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[telephone1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[telephone2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[handset] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[delFlag] [bit] NULL ,
	[row] [int] NULL ,
	[KeyCode] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_DistanceNotify]    Script Date: 2008-3-3 11:35:54 ******/
CREATE TABLE [dbo].[T_SC_DistanceNotify] (
	[notifyId] [int] IDENTITY (1, 1) NOT NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dateTime] [datetime] NULL ,
	[conText] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[title] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[fromUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_FuncManager]    Script Date: 2008-3-3 11:35:54 ******/
CREATE TABLE [dbo].[T_SC_FuncManager] (
	[FuncId] [int] IDENTITY (1, 1) NOT NULL ,
	[AcountName] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[funcName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[description] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[delFlag] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_LogInfor]    Script Date: 2008-3-3 11:35:54 ******/
CREATE TABLE [dbo].[T_SC_LogInfor] (
	[loginId] [int] IDENTITY (1, 1) NOT NULL ,
	[userId] [int] NULL ,
	[loginTime] [varchar] (26) COLLATE Chinese_PRC_CI_AS NULL ,
	[logoffTime] [varchar] (26) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_OperateInfor]    Script Date: 2008-3-3 11:35:54 ******/
CREATE TABLE [dbo].[T_SC_OperateInfor] (
	[pkId] [int] IDENTITY (1, 1) NOT NULL ,
	[userId] [int] NULL ,
	[operatorTime] [varchar] (26) COLLATE Chinese_PRC_CI_AS NULL ,
	[operatorName] [varchar] (26) COLLATE Chinese_PRC_CI_AS NULL ,
	[funcName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[operationDes] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_Rest]    Script Date: 2008-3-3 11:35:54 ******/
CREATE TABLE [dbo].[T_SC_Rest] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[userId] [int] NULL ,
	[forbidType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[isForbid] [bit] NULL ,
	[isSend] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_RoseFunc]    Script Date: 2008-3-3 11:35:54 ******/
CREATE TABLE [dbo].[T_SC_RoseFunc] (
	[pkId] [int] IDENTITY (1, 1) NOT NULL ,
	[roseId] [int] NULL ,
	[funcId] [int] NULL ,
	[rightFlag] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_RoseManager]    Script Date: 2008-3-3 11:35:54 ******/
CREATE TABLE [dbo].[T_SC_RoseManager] (
	[roseId] [int] IDENTITY (1, 1) NOT NULL ,
	[roseName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[description] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[delFlag] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_RoseUser]    Script Date: 2008-3-3 11:35:55 ******/
CREATE TABLE [dbo].[T_SC_RoseUser] (
	[pkId] [int] IDENTITY (1, 1) NOT NULL ,
	[roseId] [int] NULL ,
	[userId] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_Server_info]    Script Date: 2008-3-3 11:35:55 ******/
CREATE TABLE [dbo].[T_SC_Server_info] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[FileDir] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[PicSaveDir] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SerToCliSecond] [int] NULL ,
	[HomePage] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[smtp] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[userName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sendEmail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[recEmail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bDel] [int] NULL ,
	[bRec] [int] NULL ,
	[bWarning] [int] NULL ,
	[DayNum] [int] NULL ,
	[OutLineMinute] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_UserManager]    Script Date: 2008-3-3 11:35:55 ******/
CREATE TABLE [dbo].[T_SC_UserManager] (
	[userId] [int] IDENTITY (1, 1) NOT NULL ,
	[depId] [int] NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[empName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[userType] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[password] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[delFlag] [bit] NULL ,
	[HD_index] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[isRest] [bit] NULL ,
	[depName] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[OS] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[workGroup] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[MAC] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[telNUM] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[theWork] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[EMail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BackMess] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[iState] [int] NULL ,
	[SecState] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SEC_AUTO]    Script Date: 2008-3-3 11:35:55 ******/
CREATE TABLE [dbo].[T_SEC_AUTO] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SEC_DDISK]    Script Date: 2008-3-3 11:35:55 ******/
CREATE TABLE [dbo].[T_SEC_DDISK] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SEC_DepFile]    Script Date: 2008-3-3 11:35:55 ******/
CREATE TABLE [dbo].[T_SEC_DepFile] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[DepName] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[SecFileID] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SEC_EDISK]    Script Date: 2008-3-3 11:35:55 ******/
CREATE TABLE [dbo].[T_SEC_EDISK] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SEC_KEYGROUP]    Script Date: 2008-3-3 11:35:56 ******/
CREATE TABLE [dbo].[T_SEC_KEYGROUP] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PCNAME] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[GroupName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[KeyGroup] [varchar] (640) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SEC_STATE]    Script Date: 2008-3-3 11:35:56 ******/
CREATE TABLE [dbo].[T_SEC_STATE] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SHUTDOWN_POLICY]    Script Date: 2008-3-3 11:35:56 ******/
CREATE TABLE [dbo].[T_SHUTDOWN_POLICY] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[theTime] [datetime] NULL ,
	[state] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SecFileType]    Script Date: 2008-3-3 11:35:56 ******/
CREATE TABLE [dbo].[T_SecFileType] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[FileAttr] [varchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ,
	[FixType] [varchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[Process] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SoftName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_ZCL_Func]    Script Date: 2008-3-3 11:35:56 ******/
CREATE TABLE [dbo].[T_ZCL_Func] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[TaskName] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[FuncName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_ZCL_List]    Script Date: 2008-3-3 11:35:56 ******/
CREATE TABLE [dbo].[T_ZCL_List] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[TaskName] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_recordplay]    Script Date: 2008-3-3 11:35:56 ******/
CREATE TABLE [dbo].[T_recordplay] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ipAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[icontext] [image] NULL ,
	[cdatetime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_NTM_FileToUser]    Script Date: 2008-3-3 11:35:56 ******/
CREATE TABLE [dbo].[T_NTM_FileToUser] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[fileId] [int] NULL ,
	[pcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[toUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[isRead] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[T_SC_DistanceNotify2User]    Script Date: 2008-3-3 11:35:57 ******/
CREATE TABLE [dbo].[T_SC_DistanceNotify2User] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[notifyId] [int] NULL ,
	[toUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[isRead] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[T_ADD_Invade] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_ADD_Invade] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_CM_Call] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_CM_Call] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_CM_CallToUser] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_CM_CALLTOUSER] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_CM_Set] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_CM_Set] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_ClientAcount_Table] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_ClientAcount_Table] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Del_List] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Del_List] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_File_Policy] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_File_Policy] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_IEPlug] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_IEPlug] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_IE_Black] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_IE_Black] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_IE_SEL] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_IE_SEL] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_IE_Task_B] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_IE_TaskB] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_IE_Task_W] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_IE_Task_W] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_IE_Time_B] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_IE_Time_B] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_IE_Time_W] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_IE_Time_W] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_IE_User_B] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_IE_User_B] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_IE_User_W] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_IE_User_W] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_IE_Whilt] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_IE_Whilt] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_INET_CON] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_INET_CON] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_ITAM_HardwareInfor] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_ITAM_HARDWAREINFOR] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_ITAM_SoftwareInfor] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_ITAM_SOFTWAREINFOR] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Invade_Belife] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Invade_Belife] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Invade_InBreak] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Invade_InBreak] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_LOOK_FILE] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_LOOK_FILE] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Log] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Log] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Log_Table] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Log_Table] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NAM_ChatMonitor] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NAM_CHATMONITOR] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NAM_KeyboardMouse] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NAM_KEYBOARDMOUSE] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NAM_MailMonitor] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NAM_MAILMONITOR] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NAM_ProgramList] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NAM_PROGRAMLIST] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NAM_ProgramReport] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NAM_ProgramReport] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NAM_RegeditProtect] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NAM_REGEDITPROTECT] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NAM_SiteList] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NAM_SITELIST] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NCM_CliFlux] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NCM_CLIFLUX] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NCM_FluxSet] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NCM_FLUXSET] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NCM_NetFlux] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NCM_NETFLUX] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NCM_ProtocolPort] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NCM_PROTOCOLPORT] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NMM_GetScreen] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NMM_GETSCREEN] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NMM_IEConfigure] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NMM_IEConfigure] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NMM_NetAttribute] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NMM_NETATTRIBUTE] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NMM_NetConfigures] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NMM_NetConfigures] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NMM_NetDialUp] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NMM_NETDIALUP] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NSM_BrowseSiteAudit] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NSM_BROWSESITEAUDIT] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NSM_FileOperation] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NSM_FILEOPERATION] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NSM_IpMac] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NSM_IPMAC] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NSM_NewInstall] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NSM_NEWINSTALL] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NSM_Printer] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NSM_PRINTER] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_QQ_File] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_QQ_File] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_BBS_CONTENT] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_BBS_CONTENT] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NTM_FileDispense] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NTM_FILEDISPENSE] PRIMARY KEY  CLUSTERED 
	(
		[fileId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_PATCH_Inquiry] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_PATCH_Inquiry] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_PC_Process] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_PC_Process] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Patch_Userinfo] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Patch_Userinfo] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Policy_Table] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NSM_HARDWAREFORBID] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Pragram_TaskW] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Pragram_TaskW] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_B_Time] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_B_Time] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_B_User] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_B_User] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_Black] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_Black] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_Protect_Program] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_Protect_Program] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_Protect_Task] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_Protect_Task] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_Protect_Time] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_Protect_Time] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_Protect_User] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_Protect_User] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_SEL] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_SEL] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_TaskB] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_TaskB] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_W_Time] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_W_Time] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_W_User] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_W_User] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_Program_White] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_Program_White] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SCANIPLIST] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SCANIPLIST] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_ACOUNT] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_ACOUNT] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_ACOUNTUSER] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_ACOUNTUSER] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_Branchtment] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_BRANCHTMENT] PRIMARY KEY  CLUSTERED 
	(
		[branchId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_Department] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_DEPARTMENT] PRIMARY KEY  CLUSTERED 
	(
		[depId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_DistanceNotify] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_DISTANCENOTIFY] PRIMARY KEY  CLUSTERED 
	(
		[notifyId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_FuncManager] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_FUNCMANAGER] PRIMARY KEY  CLUSTERED 
	(
		[FuncId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_LogInfor] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_LOGINFOR] PRIMARY KEY  CLUSTERED 
	(
		[loginId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_OperateInfor] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_OPERATEINFOR] PRIMARY KEY  CLUSTERED 
	(
		[pkId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_Rest] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_REST] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_RoseFunc] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_ROSEFUNC] PRIMARY KEY  CLUSTERED 
	(
		[pkId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_RoseManager] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_ROSEMANAGER] PRIMARY KEY  CLUSTERED 
	(
		[roseId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_RoseUser] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_ROSEUSER] PRIMARY KEY  CLUSTERED 
	(
		[pkId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_Server_info] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_Server_info] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_UserManager] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_USERMANAGER] PRIMARY KEY  CLUSTERED 
	(
		[userId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SEC_AUTO] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SEC_AUTO] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SEC_DDISK] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SEC_DDISK] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SEC_DepFile] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SEC_DepFile] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SEC_EDISK] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SEC_] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SEC_KEYGROUP] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SEC_KEYGROUP] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SEC_STATE] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SEC_STATE] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SHUTDOWN_POLICY] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SHUTDOWN_POLICY] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SecFileType] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SecDepSetData] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_ZCL_Func] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_ZCL_Func] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_ZCL_List] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_ZCL_List] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_recordplay] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_recordplay] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_NTM_FileToUser] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_NTM_FILETOUSER] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_SC_DistanceNotify2User] WITH NOCHECK ADD 
	CONSTRAINT [PK_T_SC_DISTANCENOTIFY2USER] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[T_ADD_Invade] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_ADD_Invade_IP] DEFAULT ('0.0.0.0') FOR [IP],
	CONSTRAINT [DF_T_ADD_Invade_breakTime] DEFAULT (2007 - 8 - 25) FOR [breakTime]
GO

ALTER TABLE [dbo].[T_CM_Call] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_CM_Call_pcName] DEFAULT ('Î´Öª') FOR [pcName],
	CONSTRAINT [DF_T_CM_Call_dateTime] DEFAULT (2007 - 8 - 5) FOR [dateTime],
	CONSTRAINT [DF_T_CM_Call_callType] DEFAULT ('±¨¾¯') FOR [callType],
	CONSTRAINT [DF_T_CM_Call_warnChange] DEFAULT ('³öÏÖ±ä»¯') FOR [warnChange],
	CONSTRAINT [DF_T_CM_Call_state] DEFAULT (0) FOR [state]
GO

ALTER TABLE [dbo].[T_Del_List] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_Del_List_VProgramName] DEFAULT ('Î´Öª') FOR [VProgramName],
	CONSTRAINT [DF_T_Del_List_VPcName] DEFAULT ('Î´Öª') FOR [VPcName],
	CONSTRAINT [DF_T_Del_List_Flag] DEFAULT (0) FOR [Flag]
GO

ALTER TABLE [dbo].[T_IEPlug] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_IEPlug_PlugName] DEFAULT ('Î´Öª') FOR [PlugName],
	CONSTRAINT [DF_T_IEPlug_Process] DEFAULT ('Î´Öª') FOR [Process]
GO

ALTER TABLE [dbo].[T_ITAM_HardwareInfor] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_ITAM_HardwareInfor_pcName] DEFAULT ('¿Õ') FOR [pcName],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_OS] DEFAULT ('Windows') FOR [OS],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_cpuid] DEFAULT ('Î´Öª') FOR [cpuid],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_cpuck] DEFAULT ('Î´Öª') FOR [cpuck],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_hdid] DEFAULT ('Î´Öª') FOR [hdid],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_mem] DEFAULT ('Î´Öª') FOR [mem],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_snd] DEFAULT ('Î´Öª') FOR [snd],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_dis] DEFAULT ('Î´Öª') FOR [dis],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_moni] DEFAULT ('Î´Öª') FOR [moni],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_ie] DEFAULT ('Î´Öª') FOR [ie],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_CD] DEFAULT ('Î´Öª') FOR [CD],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_floppy] DEFAULT ('Î´Öª') FOR [floppy],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_netType] DEFAULT ('Î´Öª') FOR [netType],
	CONSTRAINT [DF_T_ITAM_HardwareInfor_hdsp] DEFAULT ('Î´Öª') FOR [hdsp]
GO

ALTER TABLE [dbo].[T_ITAM_SoftwareInfor] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_ITAM_SoftwareInfor_pcName] DEFAULT ('Î´Öª') FOR [pcName],
	CONSTRAINT [DF_T_ITAM_SoftwareInfor_dateTime] DEFAULT (0) FOR [dateTime],
	CONSTRAINT [DF_T_ITAM_SoftwareInfor_softName] DEFAULT ('Î´Öª') FOR [softName],
	CONSTRAINT [DF_T_ITAM_SoftwareInfor_softInfor] DEFAULT ('Î´Öª') FOR [softInfor],
	CONSTRAINT [DF_T_ITAM_SoftwareInfor_edition] DEFAULT ('Î´Öª') FOR [edition],
	CONSTRAINT [DF_T_ITAM_SoftwareInfor_model] DEFAULT ('Î´Öª') FOR [model],
	CONSTRAINT [DF_T_ITAM_SoftwareInfor_rest] DEFAULT ('Î´Öª') FOR [rest]
GO

ALTER TABLE [dbo].[T_Invade_InBreak] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_Invade_InBreak_IP] DEFAULT ('(0.0.0.0)') FOR [IP],
	CONSTRAINT [DF_T_Invade_InBreak_Date] DEFAULT (2007 - 8 - 25) FOR [breakTime]
GO

ALTER TABLE [dbo].[T_Log_Table] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_Log_Table_Acount] DEFAULT ('xxx') FOR [Acount],
	CONSTRAINT [DF_T_Log_Table_date] DEFAULT (2007 - 7 - 19) FOR [date]
GO

ALTER TABLE [dbo].[T_NCM_NetFlux] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_NCM_NetFlux_pcName] DEFAULT ('wu') FOR [pcName],
	CONSTRAINT [DF_T_NCM_NetFlux_dateTime] DEFAULT (0) FOR [dateTime],
	CONSTRAINT [DF_T_NCM_NetFlux_flux] DEFAULT (0) FOR [flux],
	CONSTRAINT [DF_T_NCM_NetFlux_state] DEFAULT (0) FOR [state]
GO

ALTER TABLE [dbo].[T_NMM_IEConfigure] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_NMM_IEConfigure_IEPage] DEFAULT ('http://neiwang.com') FOR [IEPage],
	CONSTRAINT [DF_T_NMM_IEConfigure_Internet] DEFAULT (0) FOR [Internet],
	CONSTRAINT [DF_T_NMM_IEConfigure_Intanet] DEFAULT (0) FOR [Intanet],
	CONSTRAINT [DF_T_NMM_IEConfigure_Bliave] DEFAULT (0) FOR [Bliave],
	CONSTRAINT [DF_T_NMM_IEConfigure_NoBliave] DEFAULT (0) FOR [NoBliave],
	CONSTRAINT [DF_T_NMM_IEConfigure_iepageState] DEFAULT (0) FOR [iepageState],
	CONSTRAINT [DF_T_NMM_IEConfigure_clearstate] DEFAULT (0) FOR [clearstate],
	CONSTRAINT [DF_T_NMM_IEConfigure_secstate] DEFAULT (0) FOR [secstate]
GO

ALTER TABLE [dbo].[T_NMM_NetConfigures] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_NMM_NetConfigures_AutoDNS] DEFAULT (1) FOR [AutoDNS],
	CONSTRAINT [DF_T_NMM_NetConfigures_AutoIP] DEFAULT (0) FOR [AutoIP],
	CONSTRAINT [DF_T_NMM_NetConfigures_FirstDNS] DEFAULT ('127.0.0.1') FOR [FirstDNS],
	CONSTRAINT [DF_T_NMM_NetConfigures_OtherDNS] DEFAULT ('127.0.0.1') FOR [OtherDNS],
	CONSTRAINT [DF_T_NMM_NetConfigures_Gate] DEFAULT ('0.0.0.0') FOR [Gate],
	CONSTRAINT [DF_T_NMM_NetConfigures_WinsServer] DEFAULT ('0.0.0.0') FOR [WinsServer],
	CONSTRAINT [DF_T_NMM_NetConfigures_OtherWinsServer] DEFAULT ('0.0.0.0') FOR [OtherWinsServer],
	CONSTRAINT [DF_T_NMM_NetConfigures_HttpProxy] DEFAULT ('0.0.0.0') FOR [HttpProxy],
	CONSTRAINT [DF_T_NMM_NetConfigures_FtpProxy] DEFAULT ('0.0.0.0') FOR [FtpProxy],
	CONSTRAINT [DF_T_NMM_NetConfigures_HttpPort] DEFAULT (8080) FOR [HttpPort],
	CONSTRAINT [DF_T_NMM_NetConfigures_FtpPort] DEFAULT (8080) FOR [FtpPort],
	CONSTRAINT [DF_T_NMM_NetConfigures_Flag] DEFAULT (0) FOR [Flag],
	CONSTRAINT [DF_T_NMM_NetConfigures_NetCad] DEFAULT (1) FOR [NetCad],
	CONSTRAINT [DF_T_NMM_NetConfigures_IP] DEFAULT ('192.168.0.2') FOR [IP],
	CONSTRAINT [DF_T_NMM_NetConfigures_Mas] DEFAULT ('255.255.255.0') FOR [Mas],
	CONSTRAINT [DF_T_NMM_NetConfigures_State] DEFAULT (1) FOR [State],
	CONSTRAINT [DF_T_NMM_NetConfigures_NewPcName] DEFAULT ('') FOR [NewPcName],
	CONSTRAINT [DF_T_NMM_NetConfigures_NoProx] DEFAULT (1) FOR [NoProx],
	CONSTRAINT [DF_T_NMM_NetConfigures_NewWorkGroup] DEFAULT ('workgroup') FOR [NewWorkGroup],
	CONSTRAINT [DF_T_NMM_NetConfigures_History] DEFAULT (0) FOR [History]
GO

ALTER TABLE [dbo].[T_Policy_Table] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_Policy_Table_iState] DEFAULT (0) FOR [iState]
GO

ALTER TABLE [dbo].[T_Program_Black] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_Program_Black_State] DEFAULT (0) FOR [State]
GO

ALTER TABLE [dbo].[T_Program_Protect_Program] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_Program_Protect_Program_State] DEFAULT (0) FOR [State]
GO

ALTER TABLE [dbo].[T_Program_White] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_Program_White_State] DEFAULT (0) FOR [State]
GO

ALTER TABLE [dbo].[T_SCANIPLIST] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_SCANIPLIST_StartIP] DEFAULT ('0.0.0.0') FOR [StartIP],
	CONSTRAINT [DF_T_SCANIPLIST_EndIP] DEFAULT ('0.0.0.0') FOR [EndIP]
GO

ALTER TABLE [dbo].[T_SC_Department] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_SC_Department_telephone1] DEFAULT (0) FOR [telephone1],
	CONSTRAINT [DF_T_SC_Department_telephone2] DEFAULT (0) FOR [telephone2]
GO

ALTER TABLE [dbo].[T_SC_Server_info] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_SC_Server_info_FileDir] DEFAULT ('C:\') FOR [FileDir],
	CONSTRAINT [DF_T_SC_Server_info_PicSaveDir] DEFAULT ('C:\hrjd') FOR [PicSaveDir],
	CONSTRAINT [DF_T_SC_Server_info_SerToCliSecond] DEFAULT (1) FOR [SerToCliSecond],
	CONSTRAINT [DF_T_SC_Server_info_HomePage] DEFAULT ('http://www.baidu.com.cn') FOR [HomePage],
	CONSTRAINT [DF_T_SC_Server_info_smtp] DEFAULT ('smtp') FOR [smtp],
	CONSTRAINT [DF_T_SC_Server_info_userName] DEFAULT ('hrjd') FOR [userName],
	CONSTRAINT [DF_T_SC_Server_info_password] DEFAULT (111) FOR [password],
	CONSTRAINT [DF_T_SC_Server_info_sendEmail] DEFAULT ('hrjd@hrjd.com') FOR [sendEmail],
	CONSTRAINT [DF_T_SC_Server_info_recEmail] DEFAULT ('hrjd@hrjd.com') FOR [recEmail],
	CONSTRAINT [DF_T_SC_Server_info_bDel] DEFAULT (0) FOR [bDel],
	CONSTRAINT [DF_T_SC_Server_info_bRec] DEFAULT (0) FOR [bRec],
	CONSTRAINT [DF_T_SC_Server_info_bWarning] DEFAULT (0) FOR [bWarning],
	CONSTRAINT [DF_T_SC_Server_info_DayNum] DEFAULT (60) FOR [DayNum],
	CONSTRAINT [DF_T_SC_Server_info_OutLineMinute] DEFAULT (120) FOR [OutLineMinute]
GO

ALTER TABLE [dbo].[T_SC_UserManager] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_SC_UserManager_depId] DEFAULT (0) FOR [depId],
	CONSTRAINT [DF_T_SC_UserManager_pcName] DEFAULT ('ÎÞ') FOR [pcName],
	CONSTRAINT [DF_T_SC_UserManager_empName] DEFAULT ('ÎÞ') FOR [empName],
	CONSTRAINT [DF_T_SC_UserManager_userType] DEFAULT (0) FOR [userType],
	CONSTRAINT [DF_T_SC_UserManager_password] DEFAULT (0) FOR [password],
	CONSTRAINT [DF_T_SC_UserManager_delFlag] DEFAULT (0) FOR [delFlag],
	CONSTRAINT [DF_T_SC_UserManager_HD_index] DEFAULT (0) FOR [HD_index],
	CONSTRAINT [DF_T_SC_UserManager_isRest] DEFAULT (0) FOR [isRest],
	CONSTRAINT [DF_T_SC_UserManager_depName] DEFAULT ('ÎÞ') FOR [depName],
	CONSTRAINT [DF_T_SC_UserManager_OS] DEFAULT ('windows') FOR [OS],
	CONSTRAINT [DF_T_SC_UserManager_workGroup] DEFAULT ('workgroup') FOR [workGroup],
	CONSTRAINT [DF_T_SC_UserManager_IP] DEFAULT ('0.0.0.0') FOR [IP],
	CONSTRAINT [DF_T_SC_UserManager_MAC] DEFAULT ('xxxxxxxxxxxx') FOR [MAC],
	CONSTRAINT [DF_T_SC_UserManager_telNUM] DEFAULT (0) FOR [telNUM],
	CONSTRAINT [DF_T_SC_UserManager_theWork] DEFAULT ('Ö°Ô±') FOR [theWork],
	CONSTRAINT [DF_T_SC_UserManager_EMail] DEFAULT ('hrjd@yahoo.com.cn') FOR [EMail],
	CONSTRAINT [DF_T_SC_UserManager_BackMess] DEFAULT ('ÎÞ') FOR [BackMess],
	CONSTRAINT [DF_T_SC_UserManager_iState] DEFAULT (0) FOR [iState],
	CONSTRAINT [DF_T_SC_UserManager_SecState] DEFAULT (0) FOR [SecState]
GO

ALTER TABLE [dbo].[T_SEC_EDISK] WITH NOCHECK ADD 
	CONSTRAINT [DF_T_SEC__UserIP] DEFAULT ('192.168.0.222') FOR [UserIP],
	CONSTRAINT [DF_T_SEC__State] DEFAULT (0) FOR [State]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_ADD_Invade]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_CM_Call]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_CM_CallToUser]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_ClientAcount_Table]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Del_List]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_EMailAddr_Table]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_File_Policy]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_IEPlug]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_IE_Black]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_IE_SEL]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_IE_Task_B]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_IE_Task_W]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_IE_Time_B]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_IE_Time_W]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_IE_User_B]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_IE_User_W]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_IE_Whilt]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_INET_CON]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_ITAM_HardwareInfor]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_ITAM_SoftwareInfor]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Invade_Belife]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Invade_InBreak]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Log_Table]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NAM_ChatMonitor]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NAM_KeyboardMouse]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NAM_MailMonitor]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NAM_ProgramList]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NAM_ProgramReport]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NAM_RegeditProtect]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NAM_SiteList]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NCM_CliFlux]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NCM_FluxSet]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NCM_NetFlux]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NCM_ProtocolPort]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NMM_GetScreen]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NMM_IEConfigure]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NMM_NetAttribute]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NMM_NetConfigures]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NMM_NetDialUp]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NSM_BrowseSiteAudit]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NSM_FileOperation]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NSM_IpMac]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NSM_NewInstall]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NSM_Printer]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NTM_FileDispense]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_PATCH_Inquiry]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_PC_Process]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Patch_Userinfo]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Policy_Table]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Pragram_TaskW]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_B_Time]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_B_User]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_Black]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_Protect_Program]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_Protect_Task]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_Protect_Time]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_Protect_User]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_SEL]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_TaskB]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_W_Time]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_W_User]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_Program_White]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SCANIPLIST]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_ACOUNT]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_ACOUNTUSER]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_Branchtment]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_Department]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_DistanceNotify]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_FuncManager]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_LogInfor]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_OperateInfor]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_Rest]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_RoseFunc]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_RoseManager]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_RoseUser]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_Server_info]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_UserManager]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SHUTDOWN_POLICY]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_recordplay]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_NTM_FileToUser]  TO [hrjd123]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[T_SC_DistanceNotify2User]  TO [hrjd123]
GO

ALTER TABLE [dbo].[T_NTM_FileToUser] ADD 
	CONSTRAINT [FK_USER_REF_FILE] FOREIGN KEY 
	(
		[fileId]
	) REFERENCES [dbo].[T_NTM_FileDispense] (
		[fileId]
	)
GO

ALTER TABLE [dbo].[T_SC_DistanceNotify2User] ADD 
	CONSTRAINT [FK_Notify_REF_Notify2User] FOREIGN KEY 
	(
		[notifyId]
	) REFERENCES [dbo].[T_SC_DistanceNotify] (
		[notifyId]
	)
GO


exec sp_addextendedproperty N'MS_Description', N'ÕÊºÅ', N'user', N'dbo', N'table', N'T_Log', N'column', N'ACOUNT'
GO
exec sp_addextendedproperty N'MS_Description', N'²Ù×÷ÄÚÈÝ', N'user', N'dbo', N'table', N'T_Log', N'column', N'OP'


GO


exec sp_addextendedproperty N'MS_Description', N'¿ØÖÆÌ¨µÄÕÊºÅ', N'user', N'dbo', N'table', N'T_SC_ACOUNTUSER', N'column', N'Acount'
GO
exec sp_addextendedproperty N'MS_Description', N'¸ÃÕÊºÅ¿ÉÒÔ¹ÜÀíµÄ¼ÆËã»úÃû³Æ', N'user', N'dbo', N'table', N'T_SC_ACOUNTUSER', N'column', N'UserPcName'


GO


exec sp_addextendedproperty N'MS_Description', N'ÃÜÔ¿', N'user', N'dbo', N'table', N'T_SC_Department', N'column', N'KeyCode'


GO


exec sp_addextendedproperty N'MS_Description', N'×î´ó¶ÏÍøÊ±¼ä·ÖÖÓ', N'user', N'dbo', N'table', N'T_SC_Server_info', N'column', N'OutLineMinute'


GO


exec sp_addextendedproperty N'MS_Description', N'²¿ÃÅµÄÃû³Æ', N'user', N'dbo', N'table', N'T_SEC_DepFile', N'column', N'DepName'
GO
exec sp_addextendedproperty N'MS_Description', N'¼ÓÃÜµÄÎÄ¼þÀàÐÍID', N'user', N'dbo', N'table', N'T_SEC_DepFile', N'column', N'SecFileID'


GO


exec sp_addextendedproperty N'MS_Description', N'¹ÜÀí×éÃû³Æ¶à¸öÒÔ;¸ô¿ª', N'user', N'dbo', N'table', N'T_SEC_KEYGROUP', N'column', N'GroupName'
GO
exec sp_addextendedproperty N'MS_Description', N'¹ÜÀí×éÃÜÔ¿¼¯ºÏ,Ö±½ÓºÏ²¢', N'user', N'dbo', N'table', N'T_SEC_KEYGROUP', N'column', N'KeyGroup'
GO
exec sp_addextendedproperty N'MS_Description', N'¼ÆËã»úÃû³Æ', N'user', N'dbo', N'table', N'T_SEC_KEYGROUP', N'column', N'PCNAME'


GO


exec sp_addextendedproperty N'MS_Description', null, N'user', N'dbo', N'table', N'T_SEC_STATE', N'column', N'State'


GO


exec sp_addextendedproperty N'MS_Description', N'ÎÄ¼þÀàÐÍ', N'user', N'dbo', N'table', N'T_SecFileType', N'column', N'FileAttr'
GO
exec sp_addextendedproperty N'MS_Description', N'ÎÄµµÀàÐÍ', N'user', N'dbo', N'table', N'T_SecFileType', N'column', N'FixType'
GO
exec sp_addextendedproperty N'MS_Description', N'½ø³ÌÃû³Æ', N'user', N'dbo', N'table', N'T_SecFileType', N'column', N'Process'
GO
exec sp_addextendedproperty N'MS_Description', N'Èí¼þÃû³Æ', N'user', N'dbo', N'table', N'T_SecFileType', N'column', N'SoftName'


GO
INSERT INTO [dbo].[T_SC_ACOUNT] (CoAcount,Mess) VALUES ('admin','¹ÜÀíÔ±')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¿ØÖÆÌ¨ÕÊºÅÉèÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','IE²å¼þ¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','IEÉèÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','IP.MACµØÖ·°ó¶¨¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','IP°ó¶¨±ä»¯±¨¾¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Modem¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','PCMCIA¹ÜÀí')
GO


INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','USB´æ´¢¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','USBÍâÉè¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','±¨¾¯ÅäÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÏµÍ³ÅäÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','½ÇÉ«²éÑ¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','³ÌÐò±£»¤')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','³ÌÐòºÚ°×Ãûµ¥')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','´òÓ¡»úÉó¼Æ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','µÇÂ¼ÈÕÖ¾')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¶àÆÁ¼àÊÓ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','·Ç·¨Éè±¸±¨¾¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','·Ç·¨Ö÷»úÈëÇÖ±¨¾¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¿ÌÂ¼»ú¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¹âÇý¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ºìÍâÏß½Ó¿Ú¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','»¥ÁªÍøÁ÷Á¿¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¼´Ê±Á÷Á¿¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¼´Ê±Í¨ÐÅ¼à¿Ø')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¿Í»§¶ËÐÅÏ¢¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÓÊ¼þ¼à¿Ø¹ÜÀí')
GO


INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¿Í»§¶ËÕÊºÅÉèÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¿ØÖÆÃæ°å¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¿ØÖÆÌ¨ÕÊºÅÉèÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÀúÊ·Á÷Á¿²éÑ¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ä¯ÀÀÍøÕ¾Éó¼Æ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ã¿ÈÕÓ¦ÓÃ³ÌÐò±¨¸æ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÅúÁ¿ÍøÂçÅäÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÆÁÄ»¿ìÕÕ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÆÁÄ»Â¼Ïó¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÆÁÄ»ÊôÐÔ¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÈÎÎñ¹ÜÀíÆ÷¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÈëÇÖ¼ì²â¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Èí¼þÐÅÏ¢±ä»¯±¨¾¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Èí¼þ×Ê²úÐÅÏ¢²éÑ¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Èí¼þ×Ê²úÐÅÏ¢¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÈíÇý¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','É¾³ý¿Í»§¶ËÐÅÏ¢')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','±¾µØ´òÓ¡»ú¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','²¦ºÅÁ¬½Ó¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','²¹¶¡ÐÅÏ¢·ÖÀà²éÑ¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','²¹¶¡×Ô¶¯·Ö·¢ÉèÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','²¿ÃÅÅäÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','²éÑ¯²¹¶¡°²×°ÐÅÏ¢')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','µçÄÔÃû³Æ±ä»¯±¨¾¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¶Ë¿ÚÉ¨Ãè')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÉÏ´«¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÊµÊ±½ø³Ì¼à¿Ø')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Êý¾Ý¿âÅäÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ëø¶¨¼üÅÌ/Êó±ê')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Í¨ÐÅÐ­ÒéºÍ¶Ë¿Ú¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÍøÂç´òÓ¡»ú¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÍøÂç¹²Ïí×ÊÔ´')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÍøÂçÍØÆËÍ¼')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÍøÂçÊôÐÔ¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÍøÕ¾ºÚ°×Ãûµ¥')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Î¥¹æÁªÍø±¨¾¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÎÄ¼þ²Ù×÷Éó¼Æ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÎÄ¼þ·Ö·¢')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÏµÍ³Ëø¶¨')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÏÂÔØ¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÐÂ°²×°Èí¼þ¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÐÂÔö¼ÓÉè±¸¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ó²¼þÐÅÏ¢±ä»¯±¨¾¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ó²¼þ×Ê²úÐÅÏ¢²éÑ¯')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ó²¼þ×Ê²úÐÅÏ¢¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ô¶³Ìµ÷ÊÔ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ô¶³ÌÍ¨Öª')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ô¶³ÌÍøÂçÅäÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ô¶³ÌÎÄ¼þ¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ô¶³ÌÐ¶ÔØ¿Í»§¶Ë')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ôö¼Ó´òÓ¡»ú¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','×¢²á±í±£»¤')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÉÏÍøÊ±¼ä¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','×¢Ïú/ÖØÆô/¹Ø»ú')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','×Ô¶¯²¹¶¡ÏÂÔØÉèÖÃ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','×è¶Ï¿Í»§¶Ë')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÆÁÄ»½ØÈ¡¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÆÁÄ»Â¼Ïñ¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÏµÍ³À¬»øÎÄ¼þÇåÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','IPMAC°ó¶¨¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','²Ù×÷ÈÕÖ¾')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','²ßÂÔÏÂ·¢')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','²ßÂÔ×é¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¼ÓÃÜ²ßÂÔ¶¨Òå')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¼ÓÃÜ½âÃÜ¹ÜÀí×é')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','¼ÓÃÜÍ¼µµ¸ñÊ½¶¨Òå')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ä¯ÀÀÍ¼µµ¸ñÊ½¶¨Òå')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÊµÊ±·þÎñ¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÊÖ¶¯¼ÓÃÜ½âÃÜ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÍâÍøÓÃ»§ÏµÍ³Éú³É')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ó²ÅÌÊý¾ÝÈ«¼ÓÃÜ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','Ó²ÅÌÊý¾ÝÈ«½âÃÜ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','×Ô¶¯¼Ó½âÃÜ')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÎÄ¼þÈ¨ÏÞ¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÔÖÄÑ¼ÓÃÜÍ¼µµ»Ö¸´')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÂÛÌ³ÄÚÈÝ¼à¿Ø')
GO

INSERT INTO [dbo].[T_SC_FuncManager] (AcountName,funcName) VALUES ('admin','ÂÛÌ³ÐÐÎª¹ÜÀí')
GO

INSERT INTO [dbo].[T_SC_Server_info] (FileDir,HomePage,SerToCliSecond) VALUES ('c:\chinasoft','127.0.0.1\wsusadmin','3')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('ÌÚÑ¶QQ','QQ')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('ÌÚÑ¶TM','TM')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('MSN','msn')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('Skype','Skype')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('ÐÂÀËuc','uc')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('ÑÅ»¢Í¨','yahoomessenger')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('ICQ','icq')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('ÌÔ±¦/°¢ÀïÍúÍú','wangwang')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('Ñ¸À×','thunder')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('webÑ¸À×','webthunder')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('Íø¼Ê¿ì³µ','flashget')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('µçÂ¿','emule')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('PPµãµãÍ¨','pp')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('Vagaa','vaga')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('BT·¢¶¯»ú','btengine')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('BTÎüÑª¹í','Bitvampire')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('±ÈÌØ¾«Áé','Bitspirit')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('ÍøÂçÂìÒÏ','netants')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('p2pÖÕ½áÕß','p2psvr')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('ÍøÂç¾«Áé','Netspy')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('QQÓÎÏ·','qqgame')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('ÁªÖÚÊÀ½ç','glworld')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('¿í´øÖÐÕ½ÍøÆ½Ì¨','bdgame')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('Í¬»¨Ë³','hexin')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('´óÖÇ»Û','hypmain')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('¹ÉÐÐÌìÏÂ','¹ÉÐÐÌìÏÂ2008')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('Áú¾í·ç»ù½ðÍ¶×Ê·ÖÎö','superfund')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('Ö¤È¯Ö®ÐÇ','ss')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('realplay','realplay')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('media player','wmplayer')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('±©·çÓ°Òô','mplayerc')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('Winamp','winamp')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('Ç§Ç§¾²Ìý','ttplay')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('¿áÈÈÓ°Òô','kuree')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('EastBox-ÒôÀÖÖ®Íõ','eb')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('PPliveÍøÂçµçÊÓ','pplive')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('PpstreamÍøÂçµçÊÓ','ppstream')
GO

INSERT INTO [dbo].[T_Program_SEL] (Name,AKey) VALUES ('·ÐµãÍøÂçµçÊÓ','p2pplayer')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ÍøÒ×','163')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ÐÂÀË','sina')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ÑÅ»¢','yahoo')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ËÑºü','sohu')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ÌÚÑ¶','qq')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ºÃ123','hao123')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ÌìÌì»ù½ðÍø','1234567')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ÖÐ¹ú»ù½ðÍø','cnfund')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('»ªÏÄ»ù½ð','chinaamc')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('²©Ê±»ù½ð','boshi')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ÄÏ·½»ù½ð','southernfund')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ËùÓÐWEBÓÊÏä','mail')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('Ð¡ËµÔÄ¶ÁÍø','readnovel')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('äìÏæÊéÔº','xxsy')
GO

INSERT INTO [dbo].[T_IE_SEL] (Name,AKey) VALUES ('ºìÐäÌíÏã','hongxiu')
GO
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('doc,rtf,','*.doc:*.rtf:','winword.exe,','WORDÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('xlw,xls,xlt,','*.xls:','excel.exe,','EXCELÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('ppt,pps,ppa,pot,','*.ppt:','powerpnt.exe,','PPTÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('txt,','*.txt:','notepad.exe,','TXTÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('PNG,PSD,jpg,bmp,PDF,PSB,','*.PNG:*.PSD:','PhotoShop.exe,ImageReady.exe,Bridge.exe,','PhotoShopÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('jpg,bmp,dib,gif,psd,png,','','ACDSee32.exe,PELite.exe,FotoCanvas2.exe,ACDSee9.exe,ACDSee8.exe,ACDSee7.exe,ACDSee6.exe,ACDSee5.exe,ACDSee4.exe,ACDSee.exe,ACDSee8Pro.exe,acdseeqv.exe,','ACDSEE')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('pdf,','*.pdf:','acrodist.exe,acrotray.exe,acrobat.exe,fppdis2a.exe,AcroRd32.exe,','PDFÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('dwg,','*.dwg:','ACAD.exe,ZwCAD.exe,Icad.exe,','AUTOCADÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('PRT,DRW,drw,mfg,dgm,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,','*.PRT:*.DRW:','proe.exe,xtop.exe,','PRO/EÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('prt,sldprt,igs,sldasm,stl,drw,slddrw,','*.prt:*.drw:','SLDWORKS.exe,solidworksexplorer.exe,','SLDWORKÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('PRT,dwg,stl,cgm,wrl,','*.PRT:','catiav5.exe,dxfdwg.exe,iges.exe,ugto2d.exe,','UGÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('exb,txp,tpl,','*.exb:','eb.exe,capp.exe,ExbShow.exe,TYPESET.exe,','CAXAÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('KMG,gxk,kmt,kmi,kmg,dwg,','*.KMG:','kmcad.exe,kmcapp.exe,km.exe,','¿ªÄ¿CAD')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('bdf,dft,dwg,','*.bdf:','ZwCAD.exe,','ÖÐÍûCAD')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('DWG,','*.DWG:','acad.exe,thcorver2000.exe,THDwgConvert.exe,','ÌìºÓCAD')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('rar,zip,','*.rar:*.zip:','winrar.exe,winzip.exe,','Ñ¹ËõRAR³ÌÐò')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('sav,xls,','*.sav:','spsswin.exe,','SPSSÍ³¼ÆÈí¼þ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('ddb,pcb,pld,','*.ddb:','Client99SE.exe,','PROTELÎÄµµ')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('FRM,BAS,CLS,','','VB6.exe,','±à³ÌVB6')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('VB,CS,ASPX.cs,ASPX.VB,ASPX,','','msdev.exe,','±à³ÌVS.NET')
go
INSERT INTO [dbo].[T_SecFileType] (FILEATTR,FIXTYPE,PROCESS,SOFTNAME) VALUES ('jpr,jpx,jsp,java,class,','','Java.exe,JBuilder.exe,eclipse.exe,javaw.exe,','±à³ÌJAVA')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('1','1','Äú½øÐÐÁËÈí¼þÎ¥¹æ²Ù×÷£¬¼ÆËã»ú½«ÖØÆô¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('1','2','Äú½øÐÐÁËÈí¼þÎ¥¹æ²Ù×÷£¬½«Ëø¶¨Êó±ê¼üÅÌ¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('1','3','Äú½øÐÐÁËÈí¼þÎ¥¹æ²Ù×÷¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('1','4','Äú½øÐÐÁËÈí¼þÎ¥¹æ²Ù×÷£¬¼ÆËã»ú½«±»×èÖ¹·ÃÎÊÍøÂç¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('1','5','ÎÞ²Ù×÷','1')
go

INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('2','1','Äú½øÐÐÁËÓ²¼þÎ¥¹æ²Ù×÷£¬¼ÆËã»ú½«ÖØÆô¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('2','2','Äú½øÐÐÁËÓ²¼þÎ¥¹æ²Ù×÷£¬½«Ëø¶¨Êó±ê¼üÅÌ¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('2','3','Äú½øÐÐÁËÓ²¼þÎ¥¹æ²Ù×÷¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('2','4','Äú½øÐÐÁËÓ²¼þÎ¥¹æ²Ù×÷£¬¼ÆËã»ú½«±»×èÖ¹·ÃÎÊÍøÂç¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('2','5','ÎÞ²Ù×÷','1')
go

INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('3','1','Äú½øÐÐÁËÎ¥¹æÁªÍø²Ù×÷£¬¼ÆËã»ú½«ÖØÆô¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('3','2','Äú½øÐÐÁËÎ¥¹æÁªÍø²Ù×÷£¬½«Ëø¶¨Êó±ê¼üÅÌ¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('3','3','Äú½øÐÐÁËÎ¥¹æÁªÍø²Ù×÷¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('3','4','Äú½øÐÐÁËÎ¥¹æÁªÍø²Ù×÷£¬¼ÆËã»ú½«±»×èÖ¹·ÃÎÊÍøÂç¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('3','5','ÎÞ²Ù×÷','1')
go

INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('4','1','Äú½ÓÈëÁË·Ç·¨Éè±¸£¬¼ÆËã»ú½«ÖØÆô¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('4','2','Äú½ÓÈëÁË·Ç·¨Éè±¸£¬½«Ëø¶¨Êó±ê¼üÅÌ¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('4','3','Äú½ÓÈëÁË·Ç·¨Éè±¸¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('4','4','Äú½ÓÈëÁË·Ç·¨Éè±¸£¬¼ÆËã»ú½«±»×èÖ¹·ÃÎÊÍøÂç¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('4','5','ÎÞ²Ù×÷','1')
go

INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('5','1','ÄúÎ¥¹æÐÞ¸ÄÁËIPµØÖ·£¬¼ÆËã»ú½«ÖØÆô¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('5','2','ÄúÎ¥¹æÐÞ¸ÄÁËIPµØÖ·£¬½«Ëø¶¨Êó±ê¼üÅÌ¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('5','3','ÄúÎ¥¹æÐÞ¸ÄÁËIPµØÖ·¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('5','4','ÄúÎ¥¹æÐÞ¸ÄÁËIPµØÖ·£¬¼ÆËã»ú½«±»×èÖ¹·ÃÎÊÍøÂç¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('5','5','ÎÞ²Ù×÷','1')
go

INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('6','1','ÄúÎ¥¹æÐÞ¸Ä¼ÆËã»úÃû³Æ£¬¼ÆËã»ú½«ÖØÆô¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('6','2','ÄúÎ¥¹æÐÞ¸Ä¼ÆËã»úÃû³Æ£¬½«Ëø¶¨Êó±ê¼üÅÌ¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('6','3','ÄúÎ¥¹æÐÞ¸Ä¼ÆËã»úÃû³Æ¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('6','4','ÄúÎ¥¹æÐÞ¸Ä¼ÆËã»úÃû³Æ£¬¼ÆËã»ú½«±»×èÖ¹·ÃÎÊÍøÂç¡£','0')
go
INSERT INTO [dbo].[T_CM_Set] (Type,Dill,Mess,iState) VALUES ('6','5','ÎÞ²Ù×÷','1')
go