Contents
| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| id | int(10) unsigned | NO | PRI | NULL | auto_increment | |
| aid | int(10) unsigned | NO | MUL | 0 | ||
| uid | int(10) unsigned | NO | MUL | NULL | ||
| xchan | char(255) | NO | MUL | |||
| resource_id | char(255) | NO | MUL | NULL | ||
| created | datetime | NO | NULL | |||
| edited | datetime | NO | NULL | |||
| title | char(255) | NO | NULL | |||
| description | text | NO | NULL | |||
| album | char(255) | NO | MUL | NULL | ||
| filename | char(255) | NO | NULL | |||
| mimetype | char(128) | NO | MUL | image/jpeg | ||
| height | smallint(6) | NO | NULL | |||
| width | smallint(6) | NO | NULL | |||
| filesize | int(10) unsigned | NO | MUL | 0 | ||
| content | mediumblob | NO | NULL | |||
| scale | tinyint(3) | NO | MUL | NULL | ||
| profile | tinyint(1) | NO | MUL | 0 | ||
| photo_flags | int(10) unsigned | NO | MUL | 0 | ||
| allow_cid | mediumtext | NO | NULL | |||
| allow_gid | mediumtext | NO | NULL | |||
| deny_cid | mediumtext | NO | NULL | |||
| deny_gid | mediumtext | NO | NULL |
Return to database documentation