userpic2

userpic2 — Clustered. Stores userpic metadata. The actual userpics are stored in either the database (userpicblob2) or on a blob server. From data version 7 userpics are clustered; the global userpic table is used prior to data version 7. Please see also userpicmap2/userkeywords.

userpic2

Column name Type Null Default Description
picid int unsigned   0  
userid int unsigned   0  
fmt char(1) YES Format of the uploaded image file. One of 'G', 'J', or 'P', for GIF, JPEG, or PNG formats respectively.
width smallint   0 Horizontal width of image in pixels.
height smallint   0 Height of image in pixels.
state char(1)   N  
picdate datetime YES  
md5base64 varchar(22)    
comment varchar(255)   Stores userpic comments. Users can define a 120 character, or 255 byte, comment for each userpic.
flags tinyint unsigned   0  
location enum('blob','disk','mogile') YES  
url varchar(255) YES  
Key name Type Column(s)
PRIMARY PRIMARY