repos_ecs/源数据/PC环境监控/3.0.3.2/database/t_actionwithalarm.sql


/****** 对象:  Table [dbo].[t_actionwithalarm]    脚本日期: 06/01/2012 13:26:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_actionwithalarm](
	[id] [int] NOT NULL,
	[doset_varname] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[dostatus_varname] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname1] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname2] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname3] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname4] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname5] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname6] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname7] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname8] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname9] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname10] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname11] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname12] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname13] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname14] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname15] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname16] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname17] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname18] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname19] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname20] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname21] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname22] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname23] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname24] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname25] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname26] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname27] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname28] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname29] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[varname30] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[strreserved1] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[strreserved2] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[strreserved3] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[strreserved4] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[strreserved5] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[strreserved6] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[strreserved7] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[strreserved8] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[strreserved9] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[strreserved10] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL,
	[intreserved1] [int] NULL,
	[intreserved2] [int] NULL,
	[intreserved3] [int] NULL,
	[intreserved4] [int] NULL,
	[intreserved5] [int] NULL,
	[intreserved6] [int] NULL,
	[intreserved7] [int] NULL,
	[intreserved8] [int] NULL,
	[intreserved9] [int] NULL,
	[intreserved10] [int] NULL,
	[boolreserved1] [bit] NULL,
	[boolreserved2] [bit] NULL,
	[boolreserved3] [bit] NULL,
	[boolreserved4] [bit] NULL,
	[boolreserved5] [bit] NULL,
	[boolreserved6] [bit] NULL,
	[boolreserved7] [bit] NULL,
	[boolreserved8] [bit] NULL,
	[boolreserved9] [bit] NULL,
	[boolreserved10] [bit] NULL,
	[alarmdata] [int] NULL,
	[resumedata] [int] NULL,
 CONSTRAINT [PK_t_actionwithalarm] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]