
--Migration_RCCP_20240404_204406.txt
CREATE TABLE [dbo].[DeviceConfigurationRequests] (
    [Id] [bigint] NOT NULL IDENTITY,
    [CameraId] [bigint] NOT NULL,
    [CreatedUtcDateTime] [datetime] NOT NULL,
    [LastUpdatedDateTime] [datetime],
    [TypeId] [bigint] NOT NULL,
    [Status] [nvarchar](max),
    [Payload] [nvarchar](max),
    CONSTRAINT [PK_dbo.DeviceConfigurationRequests] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[DeviceConfigurationRequestTypes] (
    [Id] [bigint] NOT NULL IDENTITY,
    [Name] [nvarchar](max),
    [ApplicableCameraType] [nvarchar](max),
    [CommandNumber] [bigint] NOT NULL,
    [ReadWrite] [nvarchar](max),
    CONSTRAINT [PK_dbo.DeviceConfigurationRequestTypes] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[ReportSchedulerSettings] ADD [CreatedUtcDateTime] [datetime] NOT NULL DEFAULT '1900-01-01T00:00:00.000'
