CREATE TABLE [dbo].[UserSessions]
(
[sessionID] [int] NOT NULL IDENTITY(1, 1),
[userID] [int] NOT NULL,
[startEpoch] [decimal] (18, 0) NULL,
[endEpoch] [decimal] (18, 0) NULL,
[waitTime] [decimal] (18, 0) NULL,
[supportLength] [decimal] (18, 0) NULL,
[CanDownloadAndScriptApplets] [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] [decimal] (18, 0) NULL,
[unavailableTime] [decimal] (18, 0) NULL,
[browser] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DirectSessionCode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Question] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[initialQueueID] [int] NULL,
[QueuedEpoch] [decimal] (13, 0) NULL,
[QueuedTime] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OnHoldEpoch] [decimal] (13, 0) NULL,
[OnHoldTime] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HandledEpoch] [decimal] (13, 0) 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 CONSTRAINT [DF__UserSessi__local__04AFB25B] DEFAULT ((-1)),
[profileOverride] [int] NULL CONSTRAINT [DF__UserSessi__profi__05A3D694] DEFAULT ((0)),
[AccessibilityExtensionsEnabled] [int] NULL CONSTRAINT [DF__UserSessi__Acces__0697FACD] DEFAULT ((0)),
[IsWebClient] [int] NULL CONSTRAINT [DF__UserSessi__IsWeb__078C1F06] DEFAULT ((0)),
[CategoryID] [int] NULL CONSTRAINT [DF__UserSessi__Categ__0880433F] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserSessions] ADD CONSTRAINT [pk_session] PRIMARY KEY CLUSTERED ([sessionID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_UserSessions_endEpoch] ON [dbo].[UserSessions] ([endEpoch]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_UserSessions_groupID] ON [dbo].[UserSessions] ([GroupID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_UserSessions_sessionID_userID] ON [dbo].[UserSessions] ([sessionID], [userID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_UserSessions_startEpoch] ON [dbo].[UserSessions] ([startEpoch]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserSessions] ADD CONSTRAINT [fk_session_user] FOREIGN KEY ([userID]) REFERENCES [dbo].[Users] ([userID])
GO