user —
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| userid | int unsigned auto_increment | |||
| user | char(15) | YES | ||
| caps | smallint unsigned | 0 | ||
| clusterid | tinyint unsigned | 0 | ||
| dversion | tinyint unsigned | 0 | ||
| 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 |