CREATE TABLE [dbo].[AccountOnsiteInstance]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[AccountID] [int] NOT NULL,
[InstanceGUID] [uniqueidentifier] NOT NULL,
[UpdateDate] [datetime] NULL,
[LocalMACAddress] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocalIPAddress] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HostName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OSName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPAddress] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPCountry] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPRegion] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPCity] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPLatitude] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExternalIPLongitude] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NumberOfIPs] [bigint] NULL,
[IsDefault] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_IsDefault] DEFAULT ((0)),
[InstanceName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FallbackCentralUrl] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FallbackCentralUID] [uniqueidentifier] NULL,
[AutoUpdate] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_AutoUpdate] DEFAULT ((1)),
[ManageIPsLocally] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_ManageIPsLocally] DEFAULT ((0)),
[DetectRanges] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_DetectRanges] DEFAULT ((0)),
[IgnoreNotReporting] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_IgnoreNotReporting] DEFAULT ((0)),
[IsReadOnly] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_IsReadOnly] DEFAULT ((0)),
[IsDisabled] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_IsDisabled] DEFAULT ((0)),
[GlobalSettings] [xml] NULL,
[ProxySettings] [xml] NULL,
[Destinations] [xml] NULL,
[TroubleshootingRanges] [xml] NULL,
[TroubleshootingFound] [xml] NULL,
[TroubleshootingNotFound] [xml] NULL,
[EnableTroubleshooting] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_EnableTroubleshooting] DEFAULT ((0)),
[EventLoggingLevel] [tinyint] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_EventLoggingLevel] DEFAULT ((1)),
[Deleted] [bit] NOT NULL CONSTRAINT [DF_AccountOnsiteInstance_Deleted] DEFAULT ((0)),
[JAMCStatus] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JAMCStatusDetails] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JAMCLastOnline] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountOnsiteInstance] ADD CONSTRAINT [PK_AccountOnsiteInstance_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountOnsiteInstance] ADD CONSTRAINT [FK_AccountOnsiteInstance_AccountID_Account_AccountID] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE
GO