Difference between revisions of "Database Table: user"
From Dreamwidth Notes
(Created page with '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 nam...') |
(→Definition) |
||
| Line 5: | Line 5: | ||
CREATE TABLE user ( | CREATE TABLE user ( | ||
:userid int(10) unsigned NOT NULL auto_increment, | :userid int(10) unsigned NOT NULL auto_increment, | ||
| − | :user char( | + | :user char(25) default NULL, |
:caps SMALLINT UNSIGNED NOT NULL DEFAULT 0, | :caps SMALLINT UNSIGNED NOT NULL DEFAULT 0, | ||
:email char(50) default NULL, | :email char(50) default NULL, | ||
| Line 39: | Line 39: | ||
) PACK_KEYS=1 | ) PACK_KEYS=1 | ||
</source> | </source> | ||
| − | |||
=Relationships= | =Relationships= | ||
Revision as of 04:36, 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
Location
Clustered db(?)
