
--Migration_RCCP_20230524_161034.txt
CREATE TABLE [dbo].[AppInstances] (
    [ID] [bigint] NOT NULL IDENTITY,
    [CompanyId] [bigint] NOT NULL,
    [AppType] [int] NOT NULL,
    [Name] [nvarchar](max),
    [Logo] [nvarchar](max),
    [Url] [nvarchar](max),
    [AppTemplateId] [bigint] NOT NULL,
    [Version] [nvarchar](max),
    [Permission] [nvarchar](max),
    [MariaDBPort] [nvarchar](max),
    [YAMLFileLocation] [nvarchar](max),
    [CreatedUtcDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.AppInstances] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[AppTemplates] (
    [ID] [bigint] NOT NULL IDENTITY,
    [CompanyId] [bigint] NOT NULL,
    [AppType] [int] NOT NULL,
    [Logo] [nvarchar](max),
    [Version] [nvarchar](max),
    [Permission] [nvarchar](max),
    [YAMLFileLocation] [nvarchar](max),
    [CreatedUtcDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.AppTemplates] PRIMARY KEY ([ID])
)
