CREATE TABLE [dbo].[thresholddesc]
(
[fieldindex] [int] NOT NULL,
[mibidx] [int] NULL,
[thresholdorfilter] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[fieldname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fielddescshort] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fielddesclong] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[unit] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[weight] [float] NULL,
[lowerdefaultmode] [smallint] NULL,
[lowerdefaultvalue] [float] NULL,
[lowerboundmin] [float] NULL,
[lowerboundmax] [float] NULL,
[operationandoperandbufferl] [image] NULL,
[lengthofbufferl] [int] NULL,
[upperdefaultmode] [smallint] NULL,
[upperdefaultvalue] [float] NULL,
[upperboundmin] [float] NULL,
[upperboundmax] [float] NULL,
[operationandoperandbufferu] [image] NULL,
[lengthofbufferu] [int] NULL,
[criticalthreshold] [int] NOT NULL,
[displayscalefactor] [float] NOT NULL,
[watchalertflag] [int] NOT NULL,
[watchalertlowerthreshold] [float] NOT NULL,
[watchalertupperthreshold] [float] NOT NULL,
[watchalertstep] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[thresholddesc] ADD CONSTRAINT [$thres_u0000159600000000] PRIMARY KEY CLUSTERED ([fieldindex]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[thresholddesc] ADD CONSTRAINT [$thres_r0000163800000000] FOREIGN KEY ([mibidx]) REFERENCES [dbo].[mibdefinition] ([mibidx])
GO
GRANT SELECT ON  [dbo].[thresholddesc] TO [uniadmin]
GRANT INSERT ON  [dbo].[thresholddesc] TO [uniadmin]
GRANT DELETE ON  [dbo].[thresholddesc] TO [uniadmin]
GRANT UPDATE ON  [dbo].[thresholddesc] TO [uniadmin]
GRANT SELECT ON  [dbo].[thresholddesc] TO [uniuser]
GO