CREATE TABLE [dbo].[QueuedUsers]
(
[queueID] [int] NOT NULL,
[userID] [int] NOT NULL,
[entryEpoch] [decimal] (18, 0) NULL,
[status] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueuedUsers] ADD CONSTRAINT [pk_queuedUser] PRIMARY KEY CLUSTERED ([userID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_QueuedUsers_queueID] ON [dbo].[QueuedUsers] ([queueID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_QueuedUsers_userID] ON [dbo].[QueuedUsers] ([userID]) ON [PRIMARY]
GO
CREATE STATISTICS [QueuedUsersStats1] ON [dbo].[QueuedUsers] ([queueID], [userID])
GO
ALTER TABLE [dbo].[QueuedUsers] ADD CONSTRAINT [fk_queuedusers_queue] FOREIGN KEY ([queueID]) REFERENCES [dbo].[Queues] ([queueID])
GO
ALTER TABLE [dbo].[QueuedUsers] ADD CONSTRAINT [fk_queuedusers_user] FOREIGN KEY ([userID]) REFERENCES [dbo].[Users] ([userID])
GO
[dbo].[QueuedUsers]![Foreign Keys fk_queuedusers_queue: [dbo].[Queues].queueID](../../Images/fk.gif)
