
--Migration_RCCP_20240423_181922.txt
CREATE TABLE [dbo].[CompanyFiles] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [CompanyId] [bigint] NOT NULL,
    [FileId] [nvarchar](max),
    CONSTRAINT [PK_dbo.CompanyFiles] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[FileSets] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [Name] [nvarchar](max),
    [Type] [nvarchar](max),
    [CreateUtcDateTime] [datetime] NOT NULL,
    [Active] [bit] NOT NULL,
    [TotalCount] [int] NOT NULL,
    CONSTRAINT [PK_dbo.FileSets] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[FileSetLinks] (
    [Id] [uniqueidentifier] NOT NULL DEFAULT newsequentialid(),
    [FileSetID] [uniqueidentifier] NOT NULL,
    [FileID] [uniqueidentifier] NOT NULL,
    CONSTRAINT [PK_dbo.FileSetLinks] PRIMARY KEY ([Id])
)
