
--Migration_RCCP_20260123_155837.txt
CREATE TABLE [dbo].[ActualImages] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [FileLocation] [nvarchar](max),
    [Title] [nvarchar](max),
    [Tags] [nvarchar](max),
    [Description] [nvarchar](max),
    [CompanyId] [bigint] NOT NULL,
    [CreatedUtcDateTime] [datetime],
    [UserId] [bigint],
    [Name] [nvarchar](max),
    CONSTRAINT [PK_dbo.ActualImages] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[ActualImagePlots] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [FloorplanId] [bigint] NOT NULL,
    [ImageSourcePath] [nvarchar](max),
    [PlotName] [nvarchar](max),
    [PlotCode] [nvarchar](max),
    [PlotPoints] [nvarchar](max),
    [CreatedUtcDateTime] [datetime],
    [LastUpdateUtcDateTime] [datetime],
    [Remark] [nvarchar](max),
    CONSTRAINT [PK_dbo.ActualImagePlots] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[ActualImagePlotLinks] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [PlotId] [uniqueidentifier] NOT NULL,
    [ActualImageId] [uniqueidentifier] NOT NULL,
    [CreatedUtcDateTime] [datetime],
    [UserId] [bigint],
    [Name] [nvarchar](max),
    CONSTRAINT [PK_dbo.ActualImagePlotLinks] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[OrderSessionItems] ADD [CompareResult] [int] NOT NULL DEFAULT 0
