mysql> show columns from smf_attachments
-> ;
+-----------------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-----------------------+------+-----+---------+----------------+
| id_attach | int(10) unsigned | NO | PRI | NULL | auto_increment |
| id_thumb | int(10) unsigned | NO | | 0 | |
| id_msg | int(10) unsigned | NO | MUL | 0 | |
| id_member | mediumint(8) unsigned | NO | MUL | 0 | |
| id_folder | tinyint(3) | NO | | 1 | |
| attachment_type | tinyint(3) unsigned | NO | | 0 | |
| filename | tinytext | NO | | | |
| fileext | varchar(8) | NO | | | |
| size | int(10) unsigned | NO | | 0 | |
| downloads | mediumint(8) unsigned | NO | | 0 | |
| width | mediumint(8) unsigned | NO | | 0 | |
| height | mediumint(8) unsigned | NO | | 0 | |
| mime_type | varchar(20) | NO | | | |
| approved | tinyint(3) | NO | | 1 | |
+-----------------+-----------------------+------+-----+---------+----------------+
14 rows in set (0.00 sec)