user

user —

user

Column nameTypeNullDefaultDescription
useridint unsigned auto_increment
userchar(15)YES
capssmallint unsigned0
clusteridtinyint unsigned0
dversiontinyint unsigned0
emailchar(50)YES
passwordchar(30)YES
statuschar(1)N
statusvischar(1)V
statusvisdatedatetimeYES
namechar(80)
bdatedateYES
themeidint1
moodthemeidint unsigned1
opt_forcemoodthemeenum('Y','N')N
allow_infoshowchar(1)Y
allow_contactshowchar(1)Y
allow_getljnewschar(1)N
opt_showtalklinkschar(1)Y
opt_whocanreplyenum('all','reg','friends')all
opt_gettalkemailchar(1)Y
opt_htmlemailenum('Y','N')Y
opt_mangleemailchar(1)N
useoverrideschar(1)N
defaultpicidint unsignedYES
has_bioenum('Y','N')N
txtmsg_statusenum('none','on','off')none
is_systemenum('Y','N')N
journaltypechar(1)P
langchar(2)EN
oldenctinyint0
Key nameTypeColumn(s)
PRIMARYPRIMARY
emailINDEX
idxclusterINDEX
idxversionINDEX
statusINDEX
statusvisINDEX
userUNIQUE