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-1203403505:v:use_geshi-1:v:type-php

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

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

SleePy

mysql> show index from smf_attachments;
+-----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table           | Non_unique | Key_name  | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| smf_attachments |          0 | PRIMARY   |            1 | id_attach   | A         |           0 |     NULL | NULL   |      | BTREE      |         |
| smf_attachments |          0 | id_member |            1 | id_member   | A         |        NULL |     NULL | NULL   |      | BTREE      |         |
| smf_attachments |          0 | id_member |            2 | id_attach   | A         |           0 |     NULL | NULL   |      | BTREE      |         |
| smf_attachments |          1 | id_msg    |            1 | id_msg      | A         |        NULL |     NULL | NULL   |      | BTREE      |         |
+-----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
4 rows in set (0.00 sec)
No siggy! :D