CREATE TABLE [dbo].[ChunkData]
(
[ChunkID] [uniqueidentifier] NOT NULL,
[SnapshotDataID] [uniqueidentifier] NOT NULL,
[ChunkFlags] [tinyint] NULL,
[ChunkName] [nvarchar] (260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ChunkType] [int] NULL,
[Version] [smallint] NULL,
[MimeType] [nvarchar] (260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Content] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[ChunkData] ADD CONSTRAINT [PK_ChunkData] PRIMARY KEY NONCLUSTERED ([ChunkID]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_ChunkData] ON [dbo].[ChunkData] ([SnapshotDataID], [ChunkType], [ChunkName]) ON [PRIMARY]
GO
GRANT REFERENCES ON [dbo].[ChunkData] TO [RSExecRole]
GRANT SELECT ON [dbo].[ChunkData] TO [RSExecRole]
GRANT INSERT ON [dbo].[ChunkData] TO [RSExecRole]
GRANT DELETE ON [dbo].[ChunkData] TO [RSExecRole]
GRANT UPDATE ON [dbo].[ChunkData] TO [RSExecRole]
GO
[dbo].[ChunkData]
