Difference between revisions of "Database Table: user"
From Dreamwidth Notes
(→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
- Foreign key themeid to themelist.themeid
- Foreign key moodthemeid to moodthemes.moodthemeid
See Journal types for possible values of journaltype.
Location
Clustered db(?)
