CREATE TABLE [dbo].[PlasticProviderType]
(
[ProviderTypeID] [int] NOT NULL IDENTITY(1, 1),
[TypeCode] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TypeName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Brand] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProdHppBaseUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TestHppBaseUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GatewaySubDir] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UsesSeparateNameFields] [bit] NOT NULL CONSTRAINT [DF_PlasticProviderType_UsesSeparateNameFields] DEFAULT ((0)),
[SupportsAuthCapture] [bit] NOT NULL CONSTRAINT [DF_PlasticProviderType_SupportsAuthCapture] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderType] ADD CONSTRAINT [PK_PlasticProviderType] PRIMARY KEY CLUSTERED  ([ProviderTypeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderType] ADD CONSTRAINT [IX_PlasticProviderType_TypeCode] UNIQUE NONCLUSTERED  ([TypeCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderType] ADD CONSTRAINT [IX_PlasticProviderType_TypeName] UNIQUE NONCLUSTERED  ([TypeName]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[PlasticProviderType] TO [MssExec]
GRANT INSERT ON  [dbo].[PlasticProviderType] TO [MssExec]
GRANT DELETE ON  [dbo].[PlasticProviderType] TO [MssExec]
GRANT UPDATE ON  [dbo].[PlasticProviderType] TO [MssExec]
GO