
--Migration_RCCP_20250730_134954.txt
CREATE TABLE [dbo].[CCTVs] (
    [ID] [bigint] NOT NULL IDENTITY,
    [DeviceSerial] [nvarchar](max),
    [Name] [nvarchar](max),
    [CompanyId] [bigint] NOT NULL,
    CONSTRAINT [PK_dbo.CCTVs] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[MasterLinkedDevices] (
    [ID] [bigint] NOT NULL IDENTITY,
    [MasterDeviceSerial] [nvarchar](max),
    [LinkedDeviceType] [nvarchar](max),
    [LinkedDeviceSerial] [nvarchar](max),
    CONSTRAINT [PK_dbo.MasterLinkedDevices] PRIMARY KEY ([ID])
)
ALTER TABLE [dbo].[RuleConditions] ADD [Enabled] [bit] NOT NULL DEFAULT 0
