Table LS_USER

The user table. Each user belongs to a single domain and zero or more groups in that domain. All users in the system and the hosted sites are present in this table. I.e. site administrator user names are present in the same table as the normal users registered for using the site. If a user is removed, care must be taken to also remove all referencing rows in other tables.

Column Detail

DOMAIN

DOMAIN VARCHAR(30) NOT NULL

The name of the domain that the user belongs to.

Reference To:

LS_DOMAIN.NAME

Referenced By:

LS_PREFERENCE.DOMAIN
LS_USER_GROUP.DOMAIN

NAME

NAME VARCHAR(30) NOT NULL

The unique user name. The user name is only unique within the domain, and may overlap with other users in other domains. The user name SHOULD NOT be modified after creation, unless all referencing tables also are updated.

Referenced By:

LS_PREFERENCE.USER
LS_USER_GROUP.USER
LS_CONTENT.AUTHOR
LS_PERMISSION.USER
LS_LOCK.USER

PASSWORD

PASSWORD VARCHAR(30) NOT NULL

The encoded user password. The password is not stored in plain text in this column, rather a base-64 encoded MD5 hash of the password is stored. This makes it impossible to recover a lost password, but also provides more security. The password MD5 hash is generated from both the user name and password, making it impossible to find identical passwords by checking the hashed values.

ENABLED

ENABLED SMALLINT NOT NULL

The enabled flag. This flag is set to one (1) if the user account is active and allows logins.

REAL_NAME

REAL_NAME VARCHAR(100) NOT NULL

The real name of the user.

EMAIL

EMAIL VARCHAR(100) NOT NULL

The user e-mail address. Users without a registered e-mail address may have this field left blank.

COMMENT

COMMENT VARCHAR(200) NOT NULL

The user comment. The user comment can be used to add additional information about a user.

Index Detail

PRIMARY KEY

PRIMARY KEY (DOMAIN, NAME)

The user is uniquely indexed by domain and name.