Difference between revisions of "Database Table: user"
From Dreamwidth Notes
(→Relationships) |
|||
| Line 1: | Line 1: | ||
| − | This table stores | + | This table stores some of the permanent, account-specific data for personal accounts, communities and feeds. |
=Definition= | =Definition= | ||
| Line 47: | Line 47: | ||
=Location= | =Location= | ||
| − | + | Global db | |
Revision as of 13:22, 20 March 2009
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
- Foreign key themeid to themelist.themeid
- Foreign key moodthemeid to moodthemes.moodthemeid
See Journal types for possible values of journaltype.
Location
Global db
