Table: AuthDomain

Holds information about the friendly domain names.

ColumnName	DataType	Key	Not Null	Default Value	Comment
AuthDomainID	INTEGER IDENTITY (1,1)	PK	NN		Unique domain ID
SetupID	INTEGER		NN
Name	NVARCHAR(255)		NN
ServerList	NVARCHAR(255)		NN		Server, comma-separated server list or domain name
SearchBase	NVARCHAR(255)				Optional search base

IndexName	IndexType	Columns
PRIMARY	PRIMARY	HostListID

 

how to create

CREATE TABLE HostList(
AuthDomainID INTEGER IDENTITY (1,1) NOT NULL,
SetupID INTEGER NOT NULL,
Name NVARCHAR(255) NOT NULL,
ServerList NVARCHAR(255) NOT NULL,
SearchBase NVARCHAR(255),
CONSTRAINT PK_AuthDomain
PRIMARY KEY (AuthDomainID));

How to initialize

INSERT INTO AuthDomain (Name, ServerList, SearchBase, SetupID)
SELECT 'DefaultDomain', AuthServer, AuthBase, SetupID
FROM Setup
WHERE AuthType=1 OR AuthType=3 OR AuthType=5;