
--Migration_RCCP_20260120_130135.txt
CREATE TABLE [dbo].[StaffProfileEnums] (
    [Id] [bigint] NOT NULL IDENTITY,
    [ClassName] [nvarchar](max),
    [EnumId] [bigint] NOT NULL,
    [EnumName] [nvarchar](max),
    CONSTRAINT [PK_dbo.StaffProfileEnums] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[StaffProfileSettings] (
    [Id] [bigint] NOT NULL IDENTITY,
    [BranchId] [bigint] NOT NULL,
    [StaffUniformProfile] [bigint] NOT NULL,
    [Description] [nvarchar](max),
    [TypicalBehavior] [bigint] NOT NULL,
    [PathBehavior] [bigint] NOT NULL,
    [MinCount] [bigint] NOT NULL,
    [MaxCount] [bigint] NOT NULL,
    [CameraCoverageArea] [float] NOT NULL,
    [CreateUtcDateTime] [datetime] NOT NULL,
    [LastUpdatedUtcDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.StaffProfileSettings] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[RuleJobInstances] ADD [NextRetryUtcDateTime] [datetime]
