USE [yQueue_Archive]
GO
/****** Object:  Table [dbo].[yConnections]    Script Date: 08/14/2012 11:18:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[yConnections](
	[ConnectionID] [varchar](30) NOT NULL,
	[GUID] [uniqueidentifier] NULL,
	[IP] [varchar](50) NULL,
	[Interface] [varchar](20) NULL,
	[Carrier] [varchar](20) NULL,
	[Connects] [int] NULL,
	[Disconnects] [int] NULL,
	[KeepAlives] [int] NULL,
	[TrxIn] [int] NULL,
	[TrxOut] [int] NULL,
	[TrxOutSMS] [int] NULL,
	[TrxErrors] [int] NULL,
	[TrxExceptions] [int] NULL,
	[BytesIn] [bigint] NULL,
	[BytesOut] [bigint] NULL,
	[StampStart] [smalldatetime] NULL,
	[StampLast] [smalldatetime] NULL,
	[Serial] [varchar](20) NULL,
	[LastStatus] [varchar](20) NULL,
	[MaxQueueTime] [smallint] NULL,
	[AvgQueueTime] [smallint] NULL,
	[HealthIndex] [smallint] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF