Difference between revisions of "Database Table: user"
From Dreamwidth Notes
m |
Dreamnestia (Talk | contribs) |
||
| Line 1: | Line 1: | ||
This table stores some of the permanent, account-specific data for personal accounts, communities and feeds. | This table stores some of the permanent, account-specific data for personal accounts, communities and feeds. | ||
| − | =Definition= | + | = Definition = |
| + | |||
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE user ( | CREATE TABLE user ( | ||
| Line 40: | Line 41: | ||
</source> | </source> | ||
| − | =Relationships= | + | = Relationships = |
| − | *Foreign key | + | |
| − | *Foreign key moodthemeid to [[Database | + | *Foreign key themeid to [[Database Tables: themelist|themelist]].themeid |
| + | *Foreign key moodthemeid to [[Database Tables: moodthemes|moodthemes]].moodthemeid | ||
See [[Journal types]] for possible values of journaltype. | See [[Journal types]] for possible values of journaltype. | ||
| − | =Location= | + | = Location = |
| − | Global | + | |
| − | [[Category: Database | + | [[Global database]] |
| + | |||
| + | [[Category: Database Tables|user]] | ||
Revision as of 22:15, 30 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.
