[dbo].[QueueHourSettings]

(local) > SupportBridge > Tables > dbo.QueueHourSettings

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	12:44:46 PM Thursday, October 04, 2007
Last Modified	12:44:46 PM Thursday, October 04, 2007

Columns

Name	Data Type	Max Length (Bytes)
queueID	int	4
url	nvarchar(2048)	4096
isExternal	int	4
useHours	int	4

Indexes

	Name	Columns	Unique
	pk_QueueHourSettings	queueID

SQL Script

CREATE TABLE [dbo].[QueueHourSettings]
(
[queueID] [int] NOT NULL,
[url] [nvarchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[isExternal] [int] NULL,
[useHours] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueHourSettings] ADD CONSTRAINT [pk_QueueHourSettings] PRIMARY KEY CLUSTERED ([queueID]) ON [PRIMARY]
GO

Uses