Difference between revisions of "Database Table: user"

From Dreamwidth Notes
Jump to: navigation, search
(Definition)
(Relationships)
Line 43: Line 43:
 
*Foreign key  themeid to [[themelist]].themeid
 
*Foreign key  themeid to [[themelist]].themeid
 
*Foreign key moodthemeid to [[moodthemes]].moodthemeid
 
*Foreign key moodthemeid to [[moodthemes]].moodthemeid
 +
 +
See [[Journal types]] for possible values of journaltype.
  
 
=Location=
 
=Location=
 
Clustered db(?)
 
Clustered db(?)

Revision as of 04:58, 20 March 2009

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(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

Clustered db(?)