CREATE TABLE [dbo].[PlasticProviderHppOptions]
(
[ProviderHppOptionsID] [int] NOT NULL IDENTITY(1, 1),
[ProviderFID] [int] NOT NULL,
[LandscapeOrientation] [bit] NOT NULL,
[PageFontName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PageFontSize] [int] NULL,
[PageTextColorFID] [int] NULL,
[PageBackColorFID] [int] NULL,
[TitleText] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TitleColorFID] [int] NULL,
[ButtonTextColorFID] [int] NULL,
[ButtonBackColorFID] [int] NULL,
[AcceptSalesButtonText] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AcceptTokenButtonText] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CancelSalesButtonText] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CancelTokenButtonText] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShowBillingAddressBlock] [bit] NOT NULL,
[ShowCountry] [bit] NOT NULL,
[HaveRoundedCorners] [bit] NOT NULL,
[HaveZipPrompt] [bit] NOT NULL,
[UseHostFrame] [bit] NOT NULL,
[HostPageFontName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HostPageFontSize] [int] NULL,
[HideHostPageWarning] [bit] NOT NULL,
[HostPageWarningBackColorFID] [int] NULL,
[HostPageWarningTextColorFID] [int] NULL,
[HostPageWarningPadding] [int] NULL,
[HostPageWarningMessage] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HostPageHeaderPadding] [int] NULL,
[HostPageHeaderBackColorFID] [int] NULL,
[HostPageHeaderTextColorFID] [int] NULL,
[HostPageLeftSidebarLogoWidth] [int] NULL,
[HostPageLeftSidebarFlexPct] [tinyint] NULL,
[HostPageLeftSidebarBackColorFID] [int] NULL,
[HostPageLeftSidebarTextColorFID] [int] NULL,
[HostPageLeftSidebarPadding] [int] NULL,
[HostPageMainSectionBackColorFID] [int] NULL,
[HostPageMainSectionTextColorFID] [int] NULL,
[HostPageMainSectionPadding] [int] NULL,
[HostPageFooterBackColorFID] [int] NULL,
[HostPageFooterTextColorFID] [int] NULL,
[HostPageFooterPadding] [int] NULL,
[HostPageFooterAlignCenter] [bit] NOT NULL,
[HostPageMinWidthToHaveTwoColumns] [int] NULL,
[HppFrameHeight] [int] NULL,
[HppFrameWidth] [int] NULL,
[WebPageHtml] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebPageVersion] [int] NOT NULL CONSTRAINT [DF_PlasticProviderHppOptions_WebPageVersion] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [CK_PlasticProviderHppOptions_HostPageLeftSidebarFlexPct] CHECK (([HostPageLeftSidebarFlexPct] IS NULL OR [HostPageLeftSidebarFlexPct]>=(0) AND [HostPageLeftSidebarFlexPct]<=(100)))
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [PK_PlasticProviderHppOptions] PRIMARY KEY CLUSTERED  ([ProviderHppOptionsID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [IX_PlasticProviderHppOptions_ProviderFID] UNIQUE NONCLUSTERED  ([ProviderFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_ButtonBackColorFID] FOREIGN KEY ([ButtonBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_ButtonTextColorFID] FOREIGN KEY ([ButtonTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageFooterBackColorFID] FOREIGN KEY ([HostPageFooterBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageFooterTextColorFID] FOREIGN KEY ([HostPageFooterTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageHeaderBackColorFID] FOREIGN KEY ([HostPageHeaderBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageHeaderTextColorFID] FOREIGN KEY ([HostPageHeaderTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageLeftSidebarBackColorFID] FOREIGN KEY ([HostPageLeftSidebarBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageLeftSidebarTextColorFID] FOREIGN KEY ([HostPageLeftSidebarTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageMainSectionBackColorFID] FOREIGN KEY ([HostPageMainSectionBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageMainSectionTextColorFID] FOREIGN KEY ([HostPageMainSectionTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageWarningBackColorFID] FOREIGN KEY ([HostPageWarningBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageWarningTextColorFID] FOREIGN KEY ([HostPageWarningTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_PageBackColorFID] FOREIGN KEY ([PageBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_PageTextColorFID] FOREIGN KEY ([PageTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_ProviderFID] FOREIGN KEY ([ProviderFID]) REFERENCES [dbo].[PlasticProvider] ([ProviderID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_TitleColorFID] FOREIGN KEY ([TitleColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
GRANT SELECT ON  [dbo].[PlasticProviderHppOptions] TO [MssExec]
GRANT INSERT ON  [dbo].[PlasticProviderHppOptions] TO [MssExec]
GRANT DELETE ON  [dbo].[PlasticProviderHppOptions] TO [MssExec]
GRANT UPDATE ON  [dbo].[PlasticProviderHppOptions] TO [MssExec]
GO