CREATE TABLE [dbo].[RequestQueue]
(
[RequestId] [int] NOT NULL,
[ServerId] [int] NOT NULL,
[NextExecutionTime] [datetime] NOT NULL,
[UserId] [int] NOT NULL,
[Reschedule] [tinyint] NOT NULL,
[LockTime] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[RequestQueue] ADD CONSTRAINT [pk_RequestQueue] PRIMARY KEY CLUSTERED ([RequestId]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[RequestQueue] TO [InfoPumpAdmin]
GRANT INSERT ON  [dbo].[RequestQueue] TO [InfoPumpAdmin]
GRANT DELETE ON  [dbo].[RequestQueue] TO [InfoPumpAdmin]
GRANT UPDATE ON  [dbo].[RequestQueue] TO [InfoPumpAdmin]
GRANT SELECT ON  [dbo].[RequestQueue] TO [InfoPumpUsers]
GRANT INSERT ON  [dbo].[RequestQueue] TO [InfoPumpUsers]
GRANT DELETE ON  [dbo].[RequestQueue] TO [InfoPumpUsers]
GRANT UPDATE ON  [dbo].[RequestQueue] TO [InfoPumpUsers]
GO