
--Migration_RCCP_20251104_130227.txt
CREATE TABLE [dbo].[DVRDetails] (
    [ID] [bigint] NOT NULL IDENTITY,
    [ParentSerial] [nvarchar](max),
    [Server] [nvarchar](max),
    [IP] [nvarchar](max),
    [Port] [nvarchar](max),
    [Username] [nvarchar](max),
    [Password] [nvarchar](max),
    [CloudId] [nvarchar](max),
    [CreatedDateTime] [datetime] NOT NULL,
    [UpdatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.DVRDetails] PRIMARY KEY ([ID])
)
ALTER TABLE [dbo].[PlannedAreas] ADD [AreaDisplay] [bit] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[PlannedDevicePlots] ADD [DeviceCoverageColor] [nvarchar](max)
ALTER TABLE [dbo].[PlannedDevicePlots] ADD [DeviceCoverageDisplay] [bit] NOT NULL DEFAULT 0
