public static void CreateSchemas(DocumentListDbContext dbContext)
{
dbContext.Database.ExecuteSqlCommand(@"
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'plugin')
BEGIN
EXEC('CREATE SCHEMA plugin')
END
");
}
public static void CreateTables(DocumentListDbContext dbContext)
{
if (!dbContext.Database.TableExists("plugin.DocumentListWidget"))
{
dbContext.Database.ExecuteSqlCommand(@"
CREATE TABLE [plugin].[DocumentListWidget](
[Id] [nvarchar](50) NOT NULL,
[SiteId] [nvarchar](50) NOT NULL,
[Title] [nvarchar](500) NULL,
CONSTRAINT [PK_DocumentListWidget] PRIMARY KEY CLUSTERED ([Id] ASC)
)
");
}
if (!dbContext.Database.TableExists("plugin.DocumentListDocument"))
{
dbContext.Database.ExecuteSqlCommand(@"
CREATE TABLE [plugin].[DocumentListDocument](
[Id] [nvarchar](50) NOT NULL,
[WidgetId] [nvarchar](50) NOT NULL,
[DocumentId] [nvarchar](50) NULL,
[Title] [nvarchar](500) NULL,
[Url] [nvarchar](2048) NULL,
[ThumbnailUrl] [nvarchar](2048) NULL,
[FolderId] [nvarchar](50) NULL,
[Sort] [int] NULL,
CONSTRAINT [PK_DocumentListDocument] PRIMARY KEY CLUSTERED ([Id] ASC)
)
");
}
if (!dbContext.Database.TableExists("plugin.DocumentListFolder"))
{
dbContext.Database.ExecuteSqlCommand(@"
CREATE TABLE [plugin].[DocumentListFolder](
[Id] [nvarchar](50) NOT NULL,
[WidgetId] [nvarchar](50) NULL,
[Title] [nvarchar](500) NULL,
[Sort] [int] NULL,
CONSTRAINT [PK_DocumentListFolder] PRIMARY KEY CLUSTERED ([Id] ASC)
)
");
}
}
public static void InsertSeedData(DocumentListDbContext dbContext)
{
}