CREATE TABLE [dbo].[ipRequest]
(
[RequestId] [dbo].[IDENTIFIER_TYPE] NOT NULL,
[CalcServerId] [dbo].[IDENTIFIER_TYPE] NULL,
[RequestScript] [dbo].[DES_TEXT_TYPE] NULL,
[CompileStatus] [dbo].[COMPILE_STATUS_TYPE] NOT NULL,
[LastUpdateTime] [dbo].[DATETIME_TYPE] NULL,
[CalcType] [dbo].[CALCULATION_TYPE] NOT NULL,
[CalcMinute] [dbo].[MINUTE_TYPE] NULL,
[CalcHour] [dbo].[HOUR_TYPE] NULL,
[CalcDOW] [dbo].[DOW_TYPE] NULL,
[CalcDay] [dbo].[DAY_TYPE] NULL,
[CalcMonth] [dbo].[MONTH_TYPE] NULL,
[CalcCount] [smallint] NULL,
[CalcStartTime] [dbo].[DATETIME_TYPE] NULL,
[CalcEndTime] [dbo].[DATETIME_TYPE] NULL
) 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