CREATE TABLE [dbo].[FMAInstallerSettings]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[Type] [smallint] NOT NULL,
[CreateContactID] [int] NULL,
[CreateAccountID] [int] NULL,
[CreateDate] [datetime] NOT NULL,
[TemplateName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AuthenticationGUID] [uniqueidentifier] NULL,
[EmailSettingsXML] [xml] NOT NULL,
[InstallType] [smallint] NOT NULL,
[WebAuditSettingsXML] [xml] NULL,
[GlobalProxyXML] [xml] NULL,
[GlobalBusinessHoursXML] [xml] NULL,
[GlobalSubnetsXML] [xml] NULL,
[GlobalExcludedIPsXML] [xml] NULL,
[IsDefault] [bit] NOT NULL,
[Timestamp] [bigint] NOT NULL,
[InstanceID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FMAInstallerSettings] ADD CONSTRAINT [PK_FMAInstallerSettings_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FMAInstallerSettings] ADD CONSTRAINT [FK_FMAInstallerSettings_InstanceID_AccountOnsiteInstance_ID] FOREIGN KEY ([InstanceID]) REFERENCES [dbo].[AccountOnsiteInstance] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO