CREATE TABLE [dbo].[Queues]
(
[queueID] [int] NOT NULL IDENTITY(-4, 1),
[divisionID] [int] NOT NULL,
[queueName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[isDefault] [int] NOT NULL CONSTRAINT [DF__Queues__isDefaul__145C0A3F] DEFAULT ((0)),
[isActive] [int] NOT NULL CONSTRAINT [DF__Queues__isActive__15502E78] DEFAULT ((1)),
[enableAutoMatching] [int] NOT NULL CONSTRAINT [DF__Queues__enableAu__164452B1] DEFAULT ((0)),
[enableAutoEscalation] [int] NOT NULL CONSTRAINT [DF__Queues__enableAu__173876EA] DEFAULT ((0)),
[escalationTimeout] [int] NULL,
[escalationTargetQueue] [int] NULL,
[customerDisplayName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[onDeckPriority] [int] NULL CONSTRAINT [DF__Queues__onDeckPr__182C9B23] DEFAULT ((0)),
[categoryID] [int] NULL CONSTRAINT [DF__Queues__category__1920BF5C] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Queues] ADD CONSTRAINT [pk_queues] PRIMARY KEY CLUSTERED ([queueID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Queues] ADD CONSTRAINT [fk_queues_divisions] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
ALTER TABLE [dbo].[Queues] ADD CONSTRAINT [fk_queues_target] FOREIGN KEY ([escalationTargetQueue]) REFERENCES [dbo].[Queues] ([queueID])
GO