userpic2 —
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| picid | int unsigned | 0 | ||
| userid | int unsigned | 0 | ||
| fmt | char(1) | YES | ||
| width | smallint | 0 | ||
| height | smallint | 0 | ||
| state | char(1) | N | ||
| picdate | datetime | YES | ||
| md5base64 | varchar(22) | |||
| comment | varchar(255) binary | |||
| flags | tinyint unsigned | 0 | ||
| location | enum('blob','disk','mogile') | YES | ||
| url | varchar(255) | YES |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY |