user
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| userid | int unsigned auto_increment |
|
||
| user | char(15) | YES |
|
|
| caps | smallint unsigned |
0
|
||
| clusterid | tinyint unsigned |
|
||
| dversion | tinyint unsigned |
|
||
| char(50) | YES |
|
||
| password | char(30) | YES |
|
|
| status | char(1) |
N
|
||
| statusvis | char(1) |
V
|
||
| statusvisdate | datetime | YES |
|
|
| name | char(80) |
|
||
| bdate | date | YES |
|
|
| themeid | int |
1
|
||
| moodthemeid | int unsigned |
1
|
||
| opt_forcemoodtheme | enum('Y','N') |
N
|
||
| allow_infoshow | char(1) |
Y
|
||
| allow_contactshow | char(1) |
Y
|
||
| allow_getljnews | char(1) |
N
|
||
| opt_showtalklinks | char(1) |
Y
|
||
| opt_whocanreply | enum('all','reg','friends') |
all
|
||
| opt_gettalkemail | char(1) |
Y
|
||
| opt_htmlemail | enum('Y','N') |
Y
|
||
| opt_mangleemail | char(1) |
N
|
||
| useoverrides | char(1) |
N
|
||
| defaultpicid | int unsigned | YES |
|
|
| has_bio | enum('Y','N') |
N
|
||
| txtmsg_status | enum('none','on','off') |
none
|
||
| is_system | enum('Y','N') |
N
|
||
| journaltype | char(1) |
P
|
||
| lang | char(2) |
EN
|
||
| oldenc | tinyint |
0
|
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| INDEX | ||
| idxcluster | INDEX | |
| idxversion | INDEX | |
| status | INDEX | |
| statusvis | INDEX | |
| user | UNIQUE |