CREATE TABLE [dbo].[ActionHandlerSettings]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[DealerID] [int] NOT NULL,
[ActionDefID] [int] NULL,
[ActionResultType] [smallint] NOT NULL,
[AlertFrequencyType] [smallint] NULL CONSTRAINT [DF_ActionHandlerSettings_AlertFrequencyType] DEFAULT ((0)),
[ActionContactType] [smallint] NULL,
[DealerPrimaryContactType] [smallint] NULL,
[AlternateDealerUserContactID] [int] NULL,
[AlternateDealerUserContactName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AlternateDealerUserContactEmail] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AlternateAccountContactID] [int] NULL,
[AlternateAccountContactName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AlternateAccountContactEmail] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomRecipient] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ERPSyncType] [smallint] NULL,
[ServiceUrl] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReqAuthentication] [bit] NULL,
[UserName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Password] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[XmlData] [xml] NULL,
[BaseSettingsID] [int] NULL,
[SMSServiceProvider] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SMSServiceAccount] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomEmailTemplateName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ActionHandlerSettings] ADD CONSTRAINT [PK_ActionHandlerSettings_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ActionHandlerSettings] ADD CONSTRAINT [FK_ActionHandlerSettings_ActionDefID_ActionDef_ID] FOREIGN KEY ([ActionDefID]) REFERENCES [dbo].[ActionDef] ([ID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ActionHandlerSettings] ADD CONSTRAINT [FK_ActionHandlerSettings_BaseSettingsID_ActionHandlerSettings_ID] FOREIGN KEY ([BaseSettingsID]) REFERENCES [dbo].[ActionHandlerSettings] ([ID])
GO
ALTER TABLE [dbo].[ActionHandlerSettings] ADD CONSTRAINT [FK_ActionHandlerSettings_DealerID_Account_AccountID] FOREIGN KEY ([DealerID]) REFERENCES [dbo].[Account] ([AccountID])
GO