userpic

userpic — Global. Stores userpic metadata. For sites using data version 7 or greater, the clustered userpic2 table is used. Please see also userpicmap and keywords.

userpic

Column name Type Null Default Description
picid int unsigned auto_increment    
userid int unsigned   0  
contenttype char(25) YES  
width smallint   0  
height smallint   0  
state char(1)   N  
picdate datetime YES  
md5base64 char(22)    
Key name Type Column(s)
PRIMARY PRIMARY
state INDEX
userid INDEX