
--Migration_RCCP_20240820_105534.txt
CREATE TABLE [dbo].[EntityLicences] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [EntityType] [nvarchar](max),
    [EntityName] [nvarchar](max),
    [CreatedDateTime] [datetime] NOT NULL,
    [Credit] [float] NOT NULL,
    [Version] [nvarchar](max),
    CONSTRAINT [PK_dbo.EntityLicences] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[EntityLicenceLinks] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [EntityLicenceId] [uniqueidentifier] NOT NULL,
    [EntityType] [nvarchar](max),
    [EntityId] [nvarchar](max),
    [CreatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.EntityLicenceLinks] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[ParamBackups] (
    [ID] [bigint] NOT NULL IDENTITY,
    [CompanySerial] [nvarchar](max),
    [CreatedUtcDateTime] [datetime] NOT NULL,
    [Param] [nvarchar](max),
    [Version] [nvarchar](max),
    [Type] [nvarchar](max),
    CONSTRAINT [PK_dbo.ParamBackups] PRIMARY KEY ([ID])
)
