
--Migration_RCCP_20230112_092910.txt
CREATE TABLE [dbo].[EventEntityLinks] (
    [Id] [bigint] NOT NULL IDENTITY,
    [EventId] [bigint] NOT NULL,
    [GranularityType] [int] NOT NULL,
    [GranularityId] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.EventEntityLinks] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[EventPeriodSettings] (
    [Id] [bigint] NOT NULL IDENTITY,
    [EventId] [bigint] NOT NULL,
    [EventStartDate] [datetime] NOT NULL,
    [EventEndDate] [datetime] NOT NULL,
    [IsSpecificTime] [bit] NOT NULL,
    [SpecificStartTime] [datetime] NOT NULL,
    [SpecificEndTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.EventPeriodSettings] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[EventSettings] (
    [Id] [bigint] NOT NULL IDENTITY,
    [CompanyId] [bigint] NOT NULL,
    [EventName] [nvarchar](max),
    [IsDeleted] [bit] NOT NULL,
    CONSTRAINT [PK_dbo.EventSettings] PRIMARY KEY ([Id])
)
