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 | |
| userid | INDEX |