
--Migration_RCCP_20240313_181637.txt
CREATE TABLE [dbo].[DefaultPageLinks] (
    [Id] [bigint] NOT NULL IDENTITY,
    [PageId] [nvarchar](max),
    [EntityType] [nvarchar](max),
    [EntityId] [nvarchar](max),
    CONSTRAINT [PK_dbo.DefaultPageLinks] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[DemoActualDeviceLinks] (
    [Id] [bigint] NOT NULL IDENTITY,
    [DemoDeviceSerial] [nvarchar](max),
    [ActualDeviceSerial] [nvarchar](max),
    [CreatedUtcDateTime] [datetime] NOT NULL,
    [UpdatedUtcDateTime] [datetime] NOT NULL,
    [IsDeleted] [bit] NOT NULL,
    CONSTRAINT [PK_dbo.DemoActualDeviceLinks] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[DemoDevices] (
    [Id] [bigint] NOT NULL IDENTITY,
    [DeviceSerial] [nvarchar](max),
    [Serial] [nvarchar](max),
    [CreatedUtcDateTime] [datetime] NOT NULL,
    [UpdatedUtcDateTime] [datetime] NOT NULL,
    [Status] [nvarchar](max),
    [IsDeleted] [bit] NOT NULL,
    CONSTRAINT [PK_dbo.DemoDevices] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[SiteGroups] ADD [SiteGroupCode] [nvarchar](max)
