Table LS_DOMAIN

The domain table. Each domain contains it's own pool of resources, such as web sites, content, users, groups, etc. No data can be shared across domains, making it useful to provide hosting for several organizations with a single installation. If a domain is removed, care must be taken to also remove all referencing rows in other tables.

Column Detail

NAME

NAME VARCHAR(30) NOT NULL

The unique domain name. The domain name is the primary key, and is used to identify the domain in most other tables. The domain name SHOULD NOT be modified after creation, unless all referencing tables also are updated. If a domain is removed, care must be taken to also remove all rows in referencing tables.

Referenced By:

LS_USER.DOMAIN
LS_PREFERENCE.DOMAIN
LS_GROUP.DOMAIN
LS_USER_GROUP.DOMAIN
LS_HOST.DOMAIN
LS_CONTENT.DOMAIN
LS_ATTRIBUTE.DOMAIN
LS_PERMISSION.DOMAIN
LS_LOCK.DOMAIN

DESCRIPTION

DESCRIPTION VARCHAR(100) NOT NULL

The domain description. The domain description normally contains the owner or organization name, complete with correct spacing and case. The domain description is used by users to identify the domain. It is normally the domain name with correct casing, spacing and punctuation.

OPTIONS

OPTIONS VARCHAR(200) NOT NULL

The domain options. The domain options is a short list of name-value pairs. Each entry is separated by a ':' character, and the values are placed after a '=' character. An example option string could be "secure:transfer=255".

Index Detail

PRIMARY KEY

PRIMARY KEY (NAME)

The domains are indexed by the unique name.