The script below can be run to add tables to the WEBPREFSDB database.
USE [WEBPREFSDB]
GO
/****** Object: Table [dbo].[Entity] Script Date: 4/1/2019 10:41:11 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Entity](
[EntityID] [int] NOT NULL,
[ContType] [int] NOT NULL,
[SerialNo] [int] NOT NULL,
[EntityName] [nvarchar](50) NOT NULL,
[EntityLogo] [image] NULL,
[LogoWidth] [int] NOT NULL DEFAULT ((0)),
[LogoHeight] [int] NOT NULL DEFAULT ((0)),
CONSTRAINT [PK_Entity_1] PRIMARY KEY CLUSTERED
(
[EntityID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [IX_Entity] UNIQUE NONCLUSTERED
(
[ContType] ASC,
[SerialNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[HelpText] Script Date: 4/1/2019 10:41:11 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HelpText](
[HelpId] [varchar](30) NOT NULL,
[Locale] [varchar](10) NOT NULL,
[ExternalResource] [varchar](1024) NULL,
[HelpText] [ntext] NULL,
CONSTRAINT [PK_HelpText] PRIMARY KEY CLUSTERED
(
[HelpId] ASC,
[Locale] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Message] Script Date: 4/1/2019 10:41:11 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Message](
[MessageId] [int] IDENTITY(1,1) NOT NULL,
[MessageType] [int] NOT NULL,
[AddedDate] [datetime] NOT NULL,
[StartDate] [datetime] NOT NULL,
[EndDate] [datetime] NOT NULL,
[MessageOwnerContType] [int] NOT NULL,
[MessageOwnerSerialNumber] [int] NOT NULL,
[FilterToContType] [int] NULL,
[FilterToSerialNumber] [int] NULL,
[MessageText] [ntext] NOT NULL,
CONSTRAINT [PK_Message] PRIMARY KEY CLUSTERED
(
[MessageId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Pages] Script Date: 4/1/2019 10:41:11 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Pages](
[EntityID] [int] NOT NULL,
[PageID] [int] NOT NULL,
[UserData] [image] NULL,
CONSTRAINT [PK_Pages] PRIMARY KEY CLUSTERED
(
[EntityID] ASC,
[PageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[RecentCustomers] Script Date: 4/1/2019 10:41:11 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RecentCustomers](
[Username] [nvarchar](256) NOT NULL,
[LastAccess] [datetime] NOT NULL,
[SerialNo] [int] NOT NULL,
[ContId] [nvarchar](12) NOT NULL,
[FullName] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_RecentCustomers] PRIMARY KEY CLUSTERED
(
[Username] ASC,
[SerialNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[SchemaVersion] Script Date: 4/1/2019 10:41:11 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SchemaVersion](
[Feature] [int] NOT NULL,
[Version] [int] NOT NULL,
CONSTRAINT [PK_SchemaVersion] PRIMARY KEY CLUSTERED
(
[Feature] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[SiteMap] Script Date: 4/1/2019 10:41:11 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SiteMap](
[EntityID] [int] NOT NULL,
[PageID] [int] NOT NULL,
[ParentID] [int] NULL,
[DispSeq] [int] NOT NULL,
[Caption] [nvarchar](50) NOT NULL,
[Description] [nvarchar](255) NOT NULL,
[Params] [varchar](255) NULL,
[PermissionPath] [varchar](255) NULL,
[URLOverride] [bit] NOT NULL,
[ParentOnly] [bit] NOT NULL,
CONSTRAINT [PK_SiteMap] PRIMARY KEY CLUSTERED
(
[EntityID] ASC,
[PageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Skins] Script Date: 4/1/2019 10:41:11 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Skins](
[EntityID] [int] NOT NULL,
[SkinsContType] [int] NOT NULL,
[SkinID] [varchar](50) NULL,
[InitialPage] [int] NULL,
CONSTRAINT [PK_Skins] PRIMARY KEY CLUSTERED
(
[EntityID] ASC,
[SkinsContType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[SiteMap] ADD CONSTRAINT [DF_SiteMap_URLOverride] DEFAULT ((0)) FOR [URLOverride]
GO
ALTER TABLE [dbo].[SiteMap] ADD DEFAULT ((0)) FOR [ParentOnly]
GO
