
--Migration_RCCP_20251107_113438.txt
CREATE TABLE [dbo].[FFCModelRegistries] (
    [Id] [bigint] NOT NULL IDENTITY,
    [ModelUuid] [nvarchar](max),
    [ModelName] [nvarchar](max),
    [ModelType] [nvarchar](max),
    [Firmware] [nvarchar](max),
    [Version] [nvarchar](max),
    [Status] [nvarchar](max),
    [FilePath] [nvarchar](max),
    [CreatedDateTime] [datetime] NOT NULL,
    [MetaData] [nvarchar](max),
    CONSTRAINT [PK_dbo.FFCModelRegistries] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[FFCModelRegistryEntityLinkages] (
    [Id] [bigint] NOT NULL IDENTITY,
    [FFCModelRegistryId] [bigint] NOT NULL,
    [EntityType] [nvarchar](max),
    [EntityId] [nvarchar](max),
    [CreatedUtcDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.FFCModelRegistryEntityLinkages] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[PathLinkingParameters] (
    [Id] [bigint] NOT NULL IDENTITY,
    [ModelId] [nvarchar](max),
    [IsActive] [bit] NOT NULL,
    [ConfidenceThreshold] [float] NOT NULL,
    [Stickiness] [float] NOT NULL,
    [MaxTimeGap] [float] NOT NULL,
    [MaxPixelJump] [float] NOT NULL,
    [DirectionSimilarity] [float] NOT NULL,
    [VisualSimilarity] [float] NOT NULL,
    [CreatedUtcDateTime] [datetime] NOT NULL,
    [LastUpdatedUtcDateTime] [datetime] NOT NULL,
    [IsDeleted] [bit] NOT NULL,
    CONSTRAINT [PK_dbo.PathLinkingParameters] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[AreaPlots] ADD [AreaPlotType] [int] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[PlannedAreas] ADD [AreaPlotType] [int] NOT NULL DEFAULT 0
