CREATE TABLE [dbo].[Batch]
(
[BatchID] [uniqueidentifier] NOT NULL,
[AddedOn] [datetime] NOT NULL,
[Action] [varchar] (32) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[Item] [nvarchar] (425) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Parent] [nvarchar] (425) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Param] [nvarchar] (425) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[BoolParam] [bit] NULL,
[Content] [image] NULL,
[Properties] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Batch_1] ON [dbo].[Batch] ([AddedOn]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IX_Batch] ON [dbo].[Batch] ([BatchID], [AddedOn]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Batch] TO [RSExecRole]
GRANT SELECT ON  [dbo].[Batch] TO [RSExecRole]
GRANT INSERT ON  [dbo].[Batch] TO [RSExecRole]
GRANT DELETE ON  [dbo].[Batch] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[Batch] TO [RSExecRole]
GO