News:

Please note these forums are mostly a testing ground for my SMF work and I don't really use them otherwise.

Main Menu

Paste-1203403393:v:use_geshi-0:v:type-php

Started by SleePy, Feb 19, 2008, 06:43 AM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

SleePy

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)

No siggy! :D