USE [islsupport]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sessions](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[lhs_account_id] [int] NULL,
	[lhs_cpg_user_id] [int] NULL,
	[total_connection_time] [int] NULL,
	[total_transferred_bytes] [bigint] NULL,
	[last_transferred_packet_time] [int] NULL,
	[desk_ip] [varchar](50) NULL,
	[client_ip] [varchar](50) NULL,
	[desk_version] [varchar](50) NULL,
	[client_version] [varchar](50) NULL,
	[cpg_server_id] [int] NOT NULL,
	[cpg_session_db_id] [varchar](50) NULL,
	[cpg_user_domain_name] [nvarchar](100) NULL,
	[cpg_user_name] [nvarchar](50) NULL,
	[start_time] [varchar](50) NULL,
	[stop_time] [varchar](50) NULL,
	[ppu_time] [int] NULL,
	[cpg_session_ident] [varchar](50) NULL,
	[custom_01] [varchar](50) NULL,
	[custom_02] [varchar](50) NULL,
	[custom_03] [varchar](50) NULL,
	[status_code] [varchar](50) NOT NULL,
	[session_code] [varchar](50) NULL,
	[created_date] [varchar](50) NULL,
	[custom_04] [varchar](50) NULL,
	[max_last_transferred_packet_time] [int] NULL,
	[max_total_transferred_bytes] [bigint] NULL,
 CONSTRAINT [PK_sessions] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
