Machine: localhost
Database: me_spotweb
Genereertijd: 16 jul 2011 om 13:18
Gegenereerd door: phpMyAdmin 3.4.3.1 / MySQL 5.0.91
SQL-query: SHOW INDEXES FROM spots;
Rijen: 13
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
|---|---|---|---|---|---|---|---|---|---|---|---|
| spots | 0 | PRIMARY | 1 | id | A | 420121 | NULL | NULL | BTREE | ||
| spots | 0 | idx_spots_1 | 1 | messageid | A | 420121 | NULL | NULL | BTREE | ||
| spots | 1 | idx_spots_2 | 1 | stamp | A | 420121 | NULL | NULL | YES | BTREE | disabled |
| spots | 1 | idx_spots_3 | 1 | reversestamp | A | 420121 | NULL | NULL | YES | BTREE | disabled |
| spots | 1 | idx_spots_4 | 1 | category | A | 4 | NULL | NULL | YES | BTREE | disabled |
| spots | 1 | idx_spots_4 | 2 | subcata | A | 45 | NULL | NULL | YES | BTREE | disabled |
| spots | 1 | idx_spots_4 | 3 | subcatb | A | 2010 | NULL | NULL | YES | BTREE | disabled |
| spots | 1 | idx_spots_4 | 4 | subcatc | A | 8573 | NULL | NULL | YES | BTREE | disabled |
| spots | 1 | idx_spots_4 | 5 | subcatd | A | 42012 | NULL | NULL | YES | BTREE | disabled |
| spots | 1 | idx_spots_4 | 6 | subcatz | A | 42012 | NULL | NULL | YES | BTREE | disabled |
| spots | 1 | idx_fts_spots_1 | 1 | poster | NULL | 1 | NULL | NULL | YES | FULLTEXT | disabled |
| spots | 1 | idx_fts_spots_2 | 1 | title | NULL | 1 | NULL | NULL | YES | FULLTEXT | disabled |
| spots | 1 | idx_fts_spots_3 | 1 | tag | NULL | 1 | NULL | NULL | YES | FULLTEXT | disabled |