Inhalt
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