CREATE TABLE [dbo].[ams_lv1_classes]
(
[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_cl__name__531856C7] DEFAULT (''),
[description] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__descr__540C7B00] DEFAULT (''),
[active] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__activ__55009F39] DEFAULT ('Y'),
[alarmed] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__alarm__55F4C372] DEFAULT ('N'),
[consolidate] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__conso__56E8E7AB] DEFAULT ('N'),
[createticket] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__creat__57DD0BE4] DEFAULT ('N'),
[closeticket] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__close__58D1301D] DEFAULT ('N'),
[queue] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__queue__59C55456] DEFAULT (''),
[display] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__displ__5AB9788F] DEFAULT (''),
[escalation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__escal__5BAD9CC8] DEFAULT (''),
[impact] [int] NULL,
[expiration] [int] NULL CONSTRAINT [DF__ams_lv1_c__expir__5CA1C101] DEFAULT ((15)),
[retention] [int] NULL,
[calendar] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__calen__5D95E53A] DEFAULT (''),
[urgency] [int] NULL,
[hiurgency] [int] NULL,
[lourgency] [int] NULL,
[url] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_cla__url__5E8A0973] DEFAULT (''),
[created] [int] NULL CONSTRAINT [DF__ams_lv1_c__creat__5F7E2DAC] DEFAULT ((0)),
[createdby] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__creat__607251E5] DEFAULT (''),
[modified] [int] NULL CONSTRAINT [DF__ams_lv1_c__modif__6166761E] DEFAULT ((0)),
[modifiedby] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__ams_lv1_c__modif__625A9A57] DEFAULT ('')
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_ams_lv1_classes] ON [dbo].[ams_lv1_classes] ([id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ams_lv1_classes] TO [emadmin]
GRANT INSERT ON  [dbo].[ams_lv1_classes] TO [emadmin]
GRANT DELETE ON  [dbo].[ams_lv1_classes] TO [emadmin]
GRANT UPDATE ON  [dbo].[ams_lv1_classes] TO [emadmin]
GRANT SELECT ON  [dbo].[ams_lv1_classes] TO [emuser]
GRANT SELECT ON  [dbo].[ams_lv1_classes] TO [uniadmin]
GRANT INSERT ON  [dbo].[ams_lv1_classes] TO [uniadmin]
GRANT DELETE ON  [dbo].[ams_lv1_classes] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ams_lv1_classes] TO [uniadmin]
GRANT SELECT ON  [dbo].[ams_lv1_classes] TO [uniuser]
GO