
--Migration_RCCP_20250702_074722.txt
CREATE TABLE [dbo].[AppConfigurations] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [Source] [nvarchar](max),
    [AppType] [int] NOT NULL,
    [Configuration] [nvarchar](max),
    [CompanyId] [bigint] NOT NULL,
    [LastUpdatedUtcDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.AppConfigurations] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[OccupancyAccuracyAudits] ADD [SeperatedFloorPlanLiveViewStitchImage] [nvarchar](max)
ALTER TABLE [dbo].[OccupancyAccuracyAudits] ADD [ImageFloorPlanEditedPoints] [nvarchar](max)
ALTER TABLE [dbo].[OccupancyAccuracyAudits] ADD [ThreeDimensionEditedPoints] [nvarchar](max)
ALTER TABLE [dbo].[OccupancyAccuracyAudits] ADD [MatchedDetection] [int] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[OccupancyAccuracyAudits] ADD [MissedDetection] [int] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[OccupancyAccuracyAudits] ADD [WrongDetection] [int] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[OccupancyAccuracyAudits] ADD [OverallAccuracy] [real] NOT NULL DEFAULT 0
