
--Migration_RCCP_20231017_114119.txt
CREATE TABLE [dbo].[QuerySchedulerEntities] (
    [ID] [bigint] NOT NULL IDENTITY,
    [QueryName] [nvarchar](max),
    [QueryString] [nvarchar](max),
    [AccessToken] [nvarchar](max),
    CONSTRAINT [PK_dbo.QuerySchedulerEntities] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[ReportSchedulerEntities] (
    [ID] [bigint] NOT NULL IDENTITY,
    [ReportId] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.ReportSchedulerEntities] PRIMARY KEY ([ID])
)
ALTER TABLE [dbo].[ReportSchedulerSettings] ADD [SchedulerEntityType] [int] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[ReportSchedulerSettings] ADD [SchedulerEntityId] [bigint] NOT NULL DEFAULT 0
