mysql> describe ibf_posts;
+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| pid            | int(10)      | NO   | PRI | NULL    | auto_increment |
| append_edit    | tinyint(1)   | YES  |     | 0       |                |
| edit_time      | int(10)      | YES  |     | NULL    |                |
| author_id      | mediumint(8) | NO   | MUL | 0       |                |
| author_name    | varchar(32)  | YES  |     | NULL    |                |
| use_sig        | tinyint(1)   | NO   |     | 0       |                |
| use_emo        | tinyint(1)   | NO   |     | 0       |                |
| ip_address     | varchar(16)  | NO   | MUL | NULL    |                |
| post_date      | int(10)      | YES  | MUL | NULL    |                |
| icon_id        | smallint(3)  | YES  |     | NULL    |                |
| post           | text         | YES  | MUL | NULL    |                |
| queued         | tinyint(1)   | NO   |     | 0       |                |
| topic_id       | int(10)      | NO   | MUL | 0       |                |
| post_title     | varchar(255) | YES  |     | NULL    |                |
| new_topic      | tinyint(1)   | YES  |     | 0       |                |
| edit_name      | varchar(255) | YES  |     | NULL    |                |
| post_key       | varchar(32)  | NO   |     | 0       |                |
| post_parent    | int(10)      | NO   |     | 0       |                |
| post_htmlstate | smallint(1)  | NO   |     | 0       |                |
+----------------+--------------+------+-----+---------+----------------+
19 rows in set (0.02 sec)