
--Migration_RCCP_20220425_185414.txt
CREATE TABLE [dbo].[DeviceBandwidths] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [Serial] [nvarchar](max),
    [DownloadSpeed] [float] NOT NULL,
    [UploadSpeed] [float] NOT NULL,
    [StartDateTime] [datetime] NOT NULL,
    [EndDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.DeviceBandwidths] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[DeviceConfigurationJobs] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [Serial] [nvarchar](max),
    [ConfigKey] [nvarchar](max),
    [ConfigValue] [nvarchar](max),
    [LatestStatus] [int] NOT NULL,
    [LastUpdatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.DeviceConfigurationJobs] PRIMARY KEY ([Id])
)
