CREATE TABLE [dbo].[usm_system_alert]
(
[system_alert_id] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[host_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[message] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[tenant_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[message_type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[other_info1] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[other_info2] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[other_info3] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[severity] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[source_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[time_stamp] [datetime] NOT NULL CONSTRAINT [DF__usm_syste__time___200E7F64] DEFAULT ('today'),
[user_name] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [int] NOT NULL CONSTRAINT [DF__usm_syste__statu__63A0C8B9] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_system_alert] ADD CONSTRAINT [XPKusm_system_alert] PRIMARY KEY CLUSTERED ([system_alert_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_system_alert_idx_01] ON [dbo].[usm_system_alert] ([message_type]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_system_alert] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_system_alert] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_system_alert] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_system_alert] TO [usmgroup]
GO