CREATE TABLE [dbo].[PlasticWebProvider]
(
[WebProviderID] [int] NOT NULL IDENTITY(1, 1),
[ProviderFID] [int] NOT NULL,
[AllowWebPayments] [bit] NOT NULL CONSTRAINT [DF_PlasticWebProvider_AllowWebPayments] DEFAULT ((0)),
[WebCompanyCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebProviderName] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebAddressInfo1] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebAddressInfo2] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebAddressInfo3] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebAddressInfo4] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebSiteUrl] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebServiceMark] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DaysWebItemsStayOpen] [int] NOT NULL CONSTRAINT [DF_PlasticWebProvider_DaysWebItemsStayOpen] DEFAULT ((30)),
[MaxTransactionsPerItem] [int] NOT NULL CONSTRAINT [DF_PlasticWebProvider_MaxTransactionsPerItem] DEFAULT ((5)),
[MinimumAmount] [money] NOT NULL CONSTRAINT [DF_PlasticWebProvider_MinimumAmount] DEFAULT ((0)),
[TransactionIdentifier] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebLogo] [varbinary] (max) NULL,
[ImageType] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebHtml] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebSynchronized] [datetime] NULL,
[ForceRecordSave] [bit] NOT NULL CONSTRAINT [DF_PlasticWebProvider_ForceRecordSave] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticWebProvider] ADD CONSTRAINT [PK_PlasticWebProvider] PRIMARY KEY CLUSTERED  ([WebProviderID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticWebProvider] ADD CONSTRAINT [IX_PlasticWebProvider_Provider] UNIQUE NONCLUSTERED  ([ProviderFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticWebProvider] ADD CONSTRAINT [FK_PlasticWebProvider_ProviderFID] FOREIGN KEY ([ProviderFID]) REFERENCES [dbo].[PlasticProvider] ([ProviderID])
GO
GRANT SELECT ON  [dbo].[PlasticWebProvider] TO [MssExec]
GRANT INSERT ON  [dbo].[PlasticWebProvider] TO [MssExec]
GRANT DELETE ON  [dbo].[PlasticWebProvider] TO [MssExec]
GRANT UPDATE ON  [dbo].[PlasticWebProvider] TO [MssExec]
GO