CREATE TABLE [dbo].[WebSessions]
(
[SessionID] [int] NOT NULL IDENTITY(1, 1),
[StringSessionID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IPAddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[SessionStartTime] [datetime] NULL,
[SessionLastAccessTime] [datetime] NULL,
[SessionAccessExpires] [datetime] NULL,
[SessionExpires] [datetime] NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_WebSessions_Active] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WebSessions] ADD CONSTRAINT [PK__WebSessi__C9F492701D263E8D] PRIMARY KEY CLUSTERED ([SessionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WebSessions] ADD CONSTRAINT [UQ__WebSessi__A92A626D171CC238] UNIQUE NONCLUSTERED ([StringSessionID]) ON [PRIMARY]
GO