
--Migration_RCCP_20251203_135812.txt
ALTER TABLE [dbo].[RuleJobInstances] DROP CONSTRAINT [PK_dbo.RuleJobInstances]
CREATE TABLE [dbo].[DataIntegritySystemScans] (
    [Id] [bigint] NOT NULL IDENTITY,
    [DeviceSerial] [nvarchar](20),
    [DeviceReadiness] [nvarchar](20),
    [IngestionReadiness] [nvarchar](20),
    [DatabaseReadiness] [nvarchar](20),
    [Metric] [nvarchar](20),
    [Time] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.DataIntegritySystemScans] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[FFServers] ADD [IsFFCServer] [bit] NOT NULL DEFAULT 0
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.RuleJobInstances')
AND col_name(parent_object_id, parent_column_id) = 'Id';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[RuleJobInstances] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[RuleJobInstances] ALTER COLUMN [Id] [bigint] NOT NULL
ALTER TABLE [dbo].[RuleJobInstances] ADD CONSTRAINT [PK_dbo.RuleJobInstances] PRIMARY KEY ([Id])
