CREATE TABLE [dbo].[CreditWarningSetting]
(
[CreditWarningSettingID] [int] NOT NULL IDENTITY(1, 1),
[Description] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShowDialog] [bit] NOT NULL CONSTRAINT [DF_CreditWarningSetting_ShowDialog] DEFAULT ((0)),
[AllowSelection] [bit] NOT NULL CONSTRAINT [DF_CreditWarningSetting_AllowSelection] DEFAULT ((0)),
[EmailCollector] [bit] NOT NULL CONSTRAINT [DF_CreditWarningSetting_EmailCollector] DEFAULT ((0)),
[EmailCustom] [bit] NOT NULL CONSTRAINT [DF_CreditWarningSetting_EmailCustom] DEFAULT ((0)),
[CustomEmailAddresses] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AddNote] [bit] NOT NULL CONSTRAINT [DF_CreditWarningSetting_AddNote] DEFAULT ((0)),
[Value] [decimal] (10, 2) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CreditWarningSetting] ADD CONSTRAINT [CK_CreditWarningSetting_Valid_Setting] CHECK ((NOT ([ShowDialog]=(0) AND [AllowSelection]=(0))))
GO
ALTER TABLE [dbo].[CreditWarningSetting] ADD CONSTRAINT [PK_CreditWarningSetting] PRIMARY KEY NONCLUSTERED  ([CreditWarningSettingID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[CreditWarningSetting] TO [MssExec]
GRANT INSERT ON  [dbo].[CreditWarningSetting] TO [MssExec]
GRANT DELETE ON  [dbo].[CreditWarningSetting] TO [MssExec]
GRANT UPDATE ON  [dbo].[CreditWarningSetting] TO [MssExec]
GO