CREATE TABLE [dbo].[kpi_targets]
(
[kpi_id] [int] NOT NULL,
[lower_warn] [float] NULL,
[upper_warn] [float] NULL,
[lower_alarm] [float] NULL,
[upper_alarm] [float] NULL,
[duration] [float] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[kpi_targets] ADD CONSTRAINT [XPKkpi_targets] PRIMARY KEY CLUSTERED ([kpi_id]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[kpi_targets] TO [aionadmin_group]
GRANT INSERT ON [dbo].[kpi_targets] TO [aionadmin_group]
GRANT DELETE ON [dbo].[kpi_targets] TO [aionadmin_group]
GRANT UPDATE ON [dbo].[kpi_targets] TO [aionadmin_group]
GO
[dbo].[kpi_targets]
