CREATE TABLE [dbo].[sa_login_session]
(
[id] [int] NOT NULL,
[last_mod_by] [binary] (16) NULL,
[last_mod_dt] [int] NULL,
[userID] [binary] (16) NULL,
[startEpoch] [int] NULL,
[endEpoch] [int] NULL,
[waitTime] [int] NULL,
[supportLength] [int] NULL,
[CanDownloadScriptApplets] [int] NULL,
[CanDownloadDlls] [int] NULL,
[CanRunAppletComms] [int] NULL,
[CanDownloadExes] [int] NULL,
[jvm] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NoPrompt] [int] NULL,
[ClientIsEXE] [int] NULL,
[Timezone] [int] NULL,
[availableTime] [int] NULL,
[unavailableTime] [int] NULL,
[browser] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DirectSessionCode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Question] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[initialQueueID] [int] NULL,
[QueuedEpoch] [int] NULL,
[QueuedTime] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OnHoldEpoch] [int] NULL,
[OnHoldTime] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HandledEpoch] [int] NULL,
[HandledTime] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GroupID] [int] NULL,
[AbandonFlag] [int] NULL,
[IsCurrent] [int] NULL,
[SelfServe] [int] NULL,
[localizationID] [int] NULL,
[profileOverride] [int] NULL,
[AccessibilityExtEnabled] [int] NULL,
[IsWebClient] [int] NULL,
[CategoryID] [int] NULL,
[tenant] [binary] (16) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[sa_login_session] ADD CONSTRAINT [PK__sa_login_session__33008CF0] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sa_login_session_X1] ON [dbo].[sa_login_session] ([endEpoch]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sa_login_session_X2] ON [dbo].[sa_login_session] ([GroupID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sa_login_session_X3] ON [dbo].[sa_login_session] ([id], [userID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sa_login_session_X0] ON [dbo].[sa_login_session] ([startEpoch]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[sa_login_session] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[sa_login_session] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[sa_login_session] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[sa_login_session] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[sa_login_session] TO [service_desk_ro_group]
GO
EXEC sp_addextendedproperty N'Comment', N'Added r12.5', 'SCHEMA', N'dbo', 'TABLE', N'sa_login_session', NULL, NULL
GO