CREATE TABLE [dbo].[AccountLocation]
(
[LocationID] [int] NOT NULL IDENTITY(1, 1),
[OnsiteInstanceID] [int] NOT NULL,
[IPv4UAddrList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IPv4MAddrList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_AccountLocation_IPv4MAddrList] DEFAULT ('255.255.255.255'),
[IPv6UAddrList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IPv6MAddrList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_AccountLocation_IPv6MAddrList] DEFAULT ('FF02::1'),
[FilterList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SnmpCommunity] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AccountLocation_SnmpCommunity] DEFAULT ('public'),
[RequestTimeout] [smallint] NOT NULL CONSTRAINT [DF_AccountLocation_RequestTimeout] DEFAULT ((1000)),
[SnmpTimeout] [int] NOT NULL CONSTRAINT [DF_AccountLocation_SnmpTimeout] DEFAULT ((1000)),
[HttpTimeout] [int] NOT NULL CONSTRAINT [DF_AccountLocation_HttpTimeout] DEFAULT ((4000)),
[FmaAgentTimeout] [int] NOT NULL CONSTRAINT [DF_AccountLocation_FmaAgentTimeout] DEFAULT ((4000)),
[HostNameList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ModifiedDate] [datetime] NULL,
[ScheduleData] [xml] NULL,
[LocationUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_AccountLocation_LocationUID] DEFAULT (newid()),
[LocationName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AccountLocation_LocationName] DEFAULT (N'Default'),
[IsDefault] [bit] NOT NULL CONSTRAINT [DF_AccountLocation_IsDefault] DEFAULT ((0)),
[DoNotScan] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IncludeOnly] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Exclude] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Protocols] [xml] NULL,
[ScheduleInfo] [xml] NULL,
[DeviceRetention] [int] NULL,
[ScanRate] [tinyint] NULL,
[UserDataServerList] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserDataHourly] [bit] NOT NULL CONSTRAINT [DF_AccountLocation_UserDataHourly] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountLocation] ADD CONSTRAINT [PK_AccountLocation_LocationID] PRIMARY KEY CLUSTERED ([LocationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountLocation] ADD CONSTRAINT [FK_AccountLocation_OnsiteInstanceID_AccountOnsiteInstance_ID] FOREIGN KEY ([OnsiteInstanceID]) REFERENCES [dbo].[AccountOnsiteInstance] ([ID])
GO