Difference between revisions of "Database Table: user"
From Dreamwidth Notes
m |
|||
| Line 41: | Line 41: | ||
=Relationships= | =Relationships= | ||
| − | *Foreign key themeid to [[themelist]].themeid | + | *Foreign key themeid to [[Database Table: themelist|themelist]].themeid |
| − | *Foreign key moodthemeid to [[moodthemes]].moodthemeid | + | *Foreign key moodthemeid to [[Database Table: moodthemes|moodthemes]].moodthemeid |
See [[Journal types]] for possible values of journaltype. | See [[Journal types]] for possible values of journaltype. | ||
| Line 48: | Line 48: | ||
=Location= | =Location= | ||
Global db | Global db | ||
| + | [[Category: Database Table|user]] | ||
Revision as of 00:41, 21 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
