CREATE TABLE [dbo].[SessionData]
(
[SessionID] [varchar] (32) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[CompiledDefinition] [uniqueidentifier] NULL,
[SnapshotDataID] [uniqueidentifier] NULL,
[IsPermanentSnapshot] [bit] NULL,
[ReportPath] [nvarchar] (424) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Timeout] [int] NOT NULL,
[AutoRefreshSeconds] [int] NULL,
[Expiration] [datetime] NOT NULL,
[ShowHideInfo] [image] NULL,
[DataSourceInfo] [image] NULL,
[OwnerID] [uniqueidentifier] NOT NULL,
[EffectiveParams] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[CreationTime] [datetime] NOT NULL,
[HasInteractivity] [bit] NULL,
[SnapshotExpirationDate] [datetime] NULL,
[HistoryDate] [datetime] NULL,
[PageHeight] [float] NULL,
[PageWidth] [float] NULL,
[TopMargin] [float] NULL,
[BottomMargin] [float] NULL,
[LeftMargin] [float] NULL,
[RightMargin] [float] NULL,
[AwaitingFirstExecution] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SessionCleanup] ON [dbo].[SessionData] ([Expiration]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IDX_SessionData] ON [dbo].[SessionData] ([SessionID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SessionSnapshotID] ON [dbo].[SessionData] ([SnapshotDataID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[SessionData] TO [RSExecRole]
GRANT SELECT ON  [dbo].[SessionData] TO [RSExecRole]
GRANT INSERT ON  [dbo].[SessionData] TO [RSExecRole]
GRANT DELETE ON  [dbo].[SessionData] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[SessionData] TO [RSExecRole]
GO