CREATE TABLE [dbo].[ipRequest]
(
[RequestId] [int] NOT NULL,
[CalcServerId] [int] NULL,
[RequestScript] [image] NULL,
[CompileStatus] [tinyint] NOT NULL,
[LastUpdateTime] [datetime] NULL,
[CalcType] [tinyint] NOT NULL,
[CalcMinute] [tinyint] NULL,
[CalcHour] [tinyint] NULL,
[CalcDOW] [tinyint] NULL,
[CalcDay] [tinyint] NULL,
[CalcMonth] [tinyint] NULL,
[CalcCount] [smallint] NULL,
[CalcStartTime] [datetime] NULL,
[CalcEndTime] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE TRIGGER dbdel_Request ON ipRequest FOR DELETE AS BEGIN DELETE FROM Execution FROM deleted WHERE Execution.RequestId = deleted.RequestId DELETE FROM RequestProvider FROM deleted WHERE RequestProvider.RequestId = deleted.RequestId DELETE FROM RequestQueue FROM deleted WHERE RequestQueue.RequestId = deleted.RequestId DELETE FROM SimpleRequest FROM deleted WHERE SimpleRequest.RequestId = deleted.RequestId END
GO
ALTER TABLE [dbo].[ipRequest] ADD CONSTRAINT [pk_Request] PRIMARY KEY CLUSTERED ([RequestId]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ipRequest] TO [InfoPumpAdmin]
GRANT INSERT ON  [dbo].[ipRequest] TO [InfoPumpAdmin]
GRANT DELETE ON  [dbo].[ipRequest] TO [InfoPumpAdmin]
GRANT UPDATE ON  [dbo].[ipRequest] TO [InfoPumpAdmin]
GRANT SELECT ON  [dbo].[ipRequest] TO [InfoPumpUsers]
GRANT INSERT ON  [dbo].[ipRequest] TO [InfoPumpUsers]
GRANT DELETE ON  [dbo].[ipRequest] TO [InfoPumpUsers]
GRANT UPDATE ON  [dbo].[ipRequest] TO [InfoPumpUsers]
GO