Difference between revisions of "Database Table: user"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Converting database table to use semantic mediawiki form.)
(Robot: Updating: Format)
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{#set:name=user|table type=global}}{{#set_internal:Key relationship
+
{{Database Table|name=user|table type=global|repo=dw-free}}
|From table=user
+
|To table=themelist
+
|From field=themeid
+
|To field=themeid
+
|Type=Foreign key
+
}}{{#set_internal:Key relationship
+
|From table=user
+
|To table=moodthemes
+
|From field=moodthemeid
+
|To field=moodthemeid
+
|Type=Foreign key
+
}}
+
 
[[description::This table stores some of the permanent, account-specific data for personal accounts, communities and feeds.]]
 
[[description::This table stores some of the permanent, account-specific data for personal accounts, communities and feeds.]]
  
 
See [[Journal types]] for possible values of journaltype.
 
See [[Journal types]] for possible values of journaltype.
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE user (
 
CREATE TABLE user (
Line 47: Line 34:
 
     journaltype char(1) NOT NULL default 'P',
 
     journaltype char(1) NOT NULL default 'P',
 
     lang char(2) NOT NULL default 'EN',
 
     lang char(2) NOT NULL default 'EN',
     PRIMARY KEY:(userid),
+
 
 +
     PRIMARY KEY (userid),
 
     UNIQUE KEY user (user),
 
     UNIQUE KEY user (user),
 
     KEY (email),
 
     KEY (email),
Line 54: Line 42:
 
)  PACK_KEYS=1
 
)  PACK_KEYS=1
 
</source>
 
</source>
 
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Latest revision as of 16:01, 22 July 2010

This is a global table. This table stores some of the permanent, account-specific data for personal accounts, communities and feeds.

See Journal types for possible values of journaltype.

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

Outgoing

Incoming