
--Migration_RCCP_20230420_114946.txt
CREATE TABLE [dbo].[PublicHolidays] (
    [ID] [bigint] NOT NULL IDENTITY,
    [Country] [nvarchar](max),
    [CountryAbbr] [nvarchar](max),
    [PublicHolidayName] [nvarchar](max),
    [DateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.PublicHolidays] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[PublicHolidaysByStates] (
    [ID] [bigint] NOT NULL IDENTITY,
    [Country] [nvarchar](max),
    [CountryAbbr] [nvarchar](max),
    [State] [nvarchar](max),
    [PublicHolidayName] [nvarchar](max),
    [DateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.PublicHolidaysByStates] PRIMARY KEY ([ID])
)
