user

user

user

Column name Type Null Default Description
userid int unsigned auto_increment    
user char(15) YES  
caps int YES  
clusterid tinyint unsigned   0  
dversion tinyint unsigned   0  
email 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
email INDEX
idxcluster INDEX
idxversion INDEX
status INDEX
statusvis INDEX
user UNIQUE