CREATE TABLE [dbo].[ams_lv1_escalation]
(
[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_es__name__6DCC4D03] DEFAULT (''),
[description] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__descr__6EC0713C] DEFAULT (''),
[sequence] [int] NULL,
[matchall] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__match__6FB49575] DEFAULT (' '),
[testalertage] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__testa__70A8B9AE] DEFAULT (' '),
[alertage] [int] NULL CONSTRAINT [DF__ams_lv1_e__alert__719CDDE7] DEFAULT ((0)),
[testqueueage] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__testq__72910220] DEFAULT (' '),
[queueage] [int] NULL CONSTRAINT [DF__ams_lv1_e__queue__73852659] DEFAULT ((0)),
[testurgency] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__testu__74794A92] DEFAULT (' '),
[urgency] [int] NULL CONSTRAINT [DF__ams_lv1_e__urgen__756D6ECB] DEFAULT ((0)),
[testgroupcount] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__testg__76619304] DEFAULT (' '),
[groupcount] [int] NULL CONSTRAINT [DF__ams_lv1_e__group__7755B73D] DEFAULT ((0)),
[testacknowledgedage] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__testa__7849DB76] DEFAULT (' '),
[acknowledgedage] [int] NULL CONSTRAINT [DF__ams_lv1_e__ackno__793DFFAF] DEFAULT ((0)),
[testnotacknowledged] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__testn__7A3223E8] DEFAULT (' '),
[testalarmed] [int] NULL CONSTRAINT [DF__ams_lv1_e__testa__7B264821] DEFAULT ((0)),
[calendar] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__calen__7C1A6C5A] DEFAULT (''),
[setalarm] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__setal__7D0E9093] DEFAULT (' '),
[createticket] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__creat__7E02B4CC] DEFAULT ('N'),
[useraction] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__usera__7EF6D905] DEFAULT (''),
[display] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__displ__7FEAFD3E] DEFAULT (''),
[queue] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__queue__00DF2177] DEFAULT (''),
[seturgency] [int] NULL CONSTRAINT [DF__ams_lv1_e__setur__01D345B0] DEFAULT ((0)),
[incurgency] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__incur__02C769E9] DEFAULT (' '),
[recipient] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__recip__03BB8E22] DEFAULT (''),
[message] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__messa__04AFB25B] DEFAULT (''),
[created] [int] NULL,
[createdby] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__creat__05A3D694] DEFAULT (''),
[modified] [int] NULL,
[modifiedby] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_e__modif__0697FACD] DEFAULT ('')
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_ams_lv1_escalation] ON [dbo].[ams_lv1_escalation] ([id], [sequence]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ams_lv1_escalation] TO [emadmin]
GRANT INSERT ON  [dbo].[ams_lv1_escalation] TO [emadmin]
GRANT DELETE ON  [dbo].[ams_lv1_escalation] TO [emadmin]
GRANT UPDATE ON  [dbo].[ams_lv1_escalation] TO [emadmin]
GRANT SELECT ON  [dbo].[ams_lv1_escalation] TO [emuser]
GRANT SELECT ON  [dbo].[ams_lv1_escalation] TO [uniadmin]
GRANT INSERT ON  [dbo].[ams_lv1_escalation] TO [uniadmin]
GRANT DELETE ON  [dbo].[ams_lv1_escalation] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ams_lv1_escalation] TO [uniadmin]
GRANT SELECT ON  [dbo].[ams_lv1_escalation] TO [uniuser]
GO