
--Migration_RCCP_20241001_173216.txt
CREATE TABLE [dbo].[CounterFirmwareUpdates] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [CompanySerial] [nvarchar](max),
    [FirmwareJobId] [nvarchar](max),
    [CreateDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.CounterFirmwareUpdates] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[CounterFirmwareUpdatePolicies] (
    [Id] [bigint] NOT NULL IDENTITY,
    [Firmware] [nvarchar](max),
    [Type] [nvarchar](max),
    [Count] [int] NOT NULL,
    [CreateDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.CounterFirmwareUpdatePolicies] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[CounterUpdateFirmwareJobs] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [CompanySerialList] [nvarchar](max),
    [Type] [nvarchar](max),
    [Firmware] [nvarchar](max),
    [Status] [nvarchar](max),
    [CreateDateTime] [datetime] NOT NULL,
    [UserId] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.CounterUpdateFirmwareJobs] PRIMARY KEY ([Id])
)
