| Field | Description | Type | Null | Key | Default |
|---|
| id | | int(10) unsigned | NO | PRI | NULL |
| aid | | int(10) unsigned | NO | MUL | 0 |
| uid | | int(10) unsigned | NO | MUL | 0 |
| xchan | | char(191) | NO | MUL | |
| resource_id | | char(191) | NO | MUL | |
| created | | datetime | NO | | 0001-01-01 00:00:00 |
| edited | | datetime | NO | | 0001-01-01 00:00:00 |
| expires | | datetime | NO | MUL | 0001-01-01 00:00:00 |
| title | | char(191) | NO | | |
| description | | text | NO | | |
| album | | char(191) | NO | MUL | |
| filename | | text | NO | | |
| mimetype | | char(128) | NO | MUL | image/jpeg |
| height | | smallint(6) | NO | | 0 |
| width | | smallint(6) | NO | | 0 |
| filesize | | int(10) unsigned | NO | MUL | 0 |
| content | | mediumblob | NO | | |
| imgscale | | tinyint(3) | NO | MUL | 0 |
| photo_usage | | smallint(6) | NO | MUL | 0 |
| profile | | tinyint(1) | NO | MUL | 0 |
| is_nsfw | | tinyint(1) | NO | MUL | 0 |
| os_storage | | tinyint(1) | NO | MUL | 0 |
| os_path | | mediumtext | NO | | |
| display_path | | mediumtext | NO | | |
| photo_flags | | int(10) unsigned | NO | MUL | 0 |
| allow_cid | | mediumtext | NO | | |
| allow_gid | | mediumtext | NO | | |
| deny_cid | | mediumtext | NO | | |
| deny_gid | | mediumtext | NO | | |
➔ Datenbank