
--Migration_RCCP_20250321_101428.txt
CREATE TABLE [dbo].[ComparisonEvents] (
    [Id] [bigint] NOT NULL IDENTITY,
    [MainEventId] [bigint] NOT NULL,
    [ComparisonEventName] [nvarchar](max),
    [ComparisonEventStartDate] [datetime] NOT NULL,
    [ComparisonEventEndDate] [datetime] NOT NULL,
    [EvaluationStartDate] [datetime] NOT NULL,
    [EvaluationEndDate] [datetime] NOT NULL,
    [EvaluationStartDate2] [datetime],
    [EvaluationEndDate2] [datetime],
    [EvaluationStartDate3] [datetime],
    [EvaluationEndDate3] [datetime],
    CONSTRAINT [PK_dbo.ComparisonEvents] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[Events] ADD [EvaluationStartDate2] [datetime]
ALTER TABLE [dbo].[Events] ADD [EvaluationEndDate2] [datetime]
ALTER TABLE [dbo].[Events] ADD [EvaluationStartDate3] [datetime]
ALTER TABLE [dbo].[Events] ADD [EvaluationEndDate3] [datetime]
ALTER TABLE [dbo].[Events] ADD [FootfallTarget] [bigint] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[Events] ADD [SalesTarget] [bigint] NOT NULL DEFAULT 0
