Database Table: user

From Dreamwidth Notes
Revision as of 22:15, 30 March 2009 by Dreamnestia (Talk | contribs)

Jump to: navigation, search

This table stores some of the permanent, account-specific data for personal accounts, communities and feeds.

Definition

CREATE TABLE USER (
:userid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
:USER CHAR(25) 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

See Journal types for possible values of journaltype.

Location

Global database