/****** 对象: 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]