CREATE TABLE [dbo].[ams_lv1_alerts]
(
[id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_al__name__29221CFB] DEFAULT (''),
[description] [varchar] (4096) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__descr__2A164134] DEFAULT (''),
[class] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__class__2B0A656D] DEFAULT (''),
[queue] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__queue__2BFE89A6] DEFAULT (''),
[display] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__displ__2CF2ADDF] DEFAULT (''),
[escalation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__escal__2DE6D218] DEFAULT (''),
[groupid] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__group__2EDAF651] DEFAULT (''),
[groupcount] [int] NULL CONSTRAINT [DF__ams_lv1_a__group__2FCF1A8A] DEFAULT ((0)),
[urgency] [int] NULL,
[retention] [int] NULL,
[acknowledged] [int] NULL CONSTRAINT [DF__ams_lv1_a__ackno__30C33EC3] DEFAULT ((0)),
[active] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__activ__31B762FC] DEFAULT ('Y'),
[alarmed] [int] NULL CONSTRAINT [DF__ams_lv1_a__alarm__32AB8735] DEFAULT ((0)),
[facility] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__facil__339FAB6E] DEFAULT (''),
[node] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_al__node__3493CFA7] DEFAULT (''),
[routenode] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__route__3587F3E0] DEFAULT (''),
[source] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__sourc__367C1819] DEFAULT (''),
[workstation] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__works__37703C52] DEFAULT (''),
[url] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_ale__url__3864608B] DEFAULT (''),
[occurred] [int] NULL CONSTRAINT [DF__ams_lv1_a__occur__395884C4] DEFAULT ((0)),
[appversion] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__appve__3A4CA8FD] DEFAULT (''),
[appdata1] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__appda__3B40CD36] DEFAULT (''),
[appdata2] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__appda__3C34F16F] DEFAULT (''),
[appdata3] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__appda__3D2915A8] DEFAULT (''),
[appdata4] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__appda__3E1D39E1] DEFAULT (''),
[appdata5] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__appda__3F115E1A] DEFAULT (''),
[udata] [varchar] (1060) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__udata__40058253] DEFAULT (''),
[ticket] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_a__ticke__40F9A68C] DEFAULT (''),
[transferred] [int] NULL CONSTRAINT [DF__ams_lv1_a__trans__41EDCAC5] DEFAULT ((0)),
[escalated] [int] NULL CONSTRAINT [DF__ams_lv1_a__escal__42E1EEFE] DEFAULT ((0)),
[annotated] [int] NULL CONSTRAINT [DF__ams_lv1_a__annot__43D61337] DEFAULT ((0)),
[created] [int] NULL CONSTRAINT [DF__ams_lv1_a__creat__44CA3770] DEFAULT ((0)),
[modified] [int] NULL CONSTRAINT [DF__ams_lv1_a__modif__45BE5BA9] DEFAULT ((0)),
[closed] [int] NULL CONSTRAINT [DF__ams_lv1_a__close__46B27FE2] DEFAULT ((0)),
[escalating] [int] NOT NULL CONSTRAINT [DF__ams_lv1_a__escal__47A6A41B] DEFAULT ((0)),
[assoccount] [int] NOT NULL CONSTRAINT [DF__ams_lv1_a__assoc__489AC854] DEFAULT ((-1))
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ams_lv1_alerts_index3] ON [dbo].[ams_lv1_alerts] ([active]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ams_lv1_alerts_index1] ON [dbo].[ams_lv1_alerts] ([escalating], [active], [groupid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ams_lv1_alerts_index5] ON [dbo].[ams_lv1_alerts] ([groupcount]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ams_lv1_alerts_index4] ON [dbo].[ams_lv1_alerts] ([groupid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_ams_lv1_alerts] ON [dbo].[ams_lv1_alerts] ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ams_lv1_alerts_index2] ON [dbo].[ams_lv1_alerts] ([queue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ams_lv1_alerts_index0] ON [dbo].[ams_lv1_alerts] ([queue], [active], [groupid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ams_lv1_alerts] TO [emadmin]
GRANT INSERT ON  [dbo].[ams_lv1_alerts] TO [emadmin]
GRANT DELETE ON  [dbo].[ams_lv1_alerts] TO [emadmin]
GRANT UPDATE ON  [dbo].[ams_lv1_alerts] TO [emadmin]
GRANT SELECT ON  [dbo].[ams_lv1_alerts] TO [emuser]
GRANT SELECT ON  [dbo].[ams_lv1_alerts] TO [uniadmin]
GRANT INSERT ON  [dbo].[ams_lv1_alerts] TO [uniadmin]
GRANT DELETE ON  [dbo].[ams_lv1_alerts] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ams_lv1_alerts] TO [uniadmin]
GRANT SELECT ON  [dbo].[ams_lv1_alerts] TO [uniuser]
GO