CREATE TABLE [dbo].[Event]
(
[EventID] [uniqueidentifier] NOT NULL,
[EventType] [nvarchar] (260) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[EventData] [nvarchar] (260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[TimeEntered] [datetime] NOT NULL,
[ProcessStart] [datetime] NULL,
[ProcessHeartbeat] [datetime] NULL,
[BatchID] [uniqueidentifier] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Event] ADD CONSTRAINT [PK_Event] PRIMARY KEY CLUSTERED ([EventID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Event2] ON [dbo].[Event] ([ProcessStart]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Event_TimeEntered] ON [dbo].[Event] ([TimeEntered]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Event3] ON [dbo].[Event] ([TimeEntered]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Event] TO [RSExecRole]
GRANT SELECT ON  [dbo].[Event] TO [RSExecRole]
GRANT INSERT ON  [dbo].[Event] TO [RSExecRole]
GRANT DELETE ON  [dbo].[Event] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[Event] TO [RSExecRole]
GO