
--Migration_RCCP_20220808_093909.txt
CREATE TABLE [dbo].[RuleEngineActions] (
    [ID] [bigint] NOT NULL IDENTITY,
    [Gateway] [int] NOT NULL,
    [Payload] [nvarchar](max),
    [RuleId] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.RuleEngineActions] PRIMARY KEY ([ID])
)
CREATE INDEX [IX_RuleId] ON [dbo].[RuleEngineActions]([RuleId])
ALTER TABLE [dbo].[RuleEngineActions] ADD CONSTRAINT [FK_dbo.RuleEngineActions_dbo.Rules_RuleId] FOREIGN KEY ([RuleId]) REFERENCES [dbo].[Rules] ([ID]) ON DELETE CASCADE
