Database Table: user

This table stores most of the permanent, user-specific data determined during account setup. Note that the name field is the setting from the 'basic info' screen, not the name of the account.

Definition

CREATE TABLE USER (
:userid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
:USER CHAR(15) DEFAULT NULL,
:caps SMALLINT UNSIGNED NOT NULL DEFAULT 0,
:email CHAR(50) DEFAULT NULL,
:password CHAR(30) DEFAULT NULL,
:STATUS CHAR(1) NOT NULL DEFAULT 'N',
:statusvis CHAR(1) NOT NULL DEFAULT 'V',
:statusvisdate datetime DEFAULT NULL,
:name CHAR(50) DEFAULT NULL,
:bdate DATE DEFAULT NULL,
:themeid INT(11) NOT NULL DEFAULT '1',
:moodthemeid INT(10) UNSIGNED NOT NULL DEFAULT '1',
:opt_forcemoodtheme enum('Y','N') NOT NULL DEFAULT 'N',
:allow_infoshow CHAR(1) NOT NULL DEFAULT 'Y',
:allow_contactshow CHAR(1) NOT NULL DEFAULT 'Y',
:allow_getljnews CHAR(1) NOT NULL DEFAULT 'N',
:opt_showtalklinks CHAR(1) NOT NULL DEFAULT 'Y',
:opt_whocanreply enum('all','reg','friends') NOT NULL DEFAULT 'all',
:opt_gettalkemail CHAR(1) NOT NULL DEFAULT 'Y',
:opt_htmlemail enum('Y','N') NOT NULL DEFAULT 'Y',
:opt_mangleemail CHAR(1) NOT NULL DEFAULT 'N',
:useoverrides CHAR(1) NOT NULL DEFAULT 'N',
:defaultpicid INT(10) UNSIGNED DEFAULT NULL,
:has_bio enum('Y','N') NOT NULL DEFAULT 'N',
:txtmsg_status enum('none','on','off') NOT NULL DEFAULT 'none',
:is_system enum('Y','N') NOT NULL DEFAULT 'N',
:journaltype CHAR(1) NOT NULL DEFAULT 'P',
:lang CHAR(2) NOT NULL DEFAULT 'EN',
:PRIMARY KEY:(userid),
:UNIQUE KEY USER (USER),
:KEY (email),
:KEY (STATUS),
:KEY (statusvis)
)  PACK_KEYS=1

Relationships

• Foreign key themeid to themelist.themeid
• Foreign key moodthemeid to moodthemes.moodthemeid

Location

Clustered db(?)