PDA

View Full Version : [HELP] - Problem With Table Indexes


Mixibiza
17 Jan 2008, 03:48
Well I was just doing a database check through phpmyadmin and came across these problems with the table indexes :

Problems with indexes of table `games_cats`
More than one INDEX key was created for column `active`

Problems with indexes of table `games_champs`
More than one INDEX key was created for column `champ_gid`

Problems with indexes of table `games_league`
More than one INDEX key was created for column `gid`
More than one INDEX key was created for column `mid`

Problems with indexes of table `games_list`
More than one INDEX key was created for column `gtitle`
More than one INDEX key was created for column `gcat`
More than one INDEX key was created for column `added`
More than one INDEX key was created for column `gcount`

Problems with indexes of table `games_scores`
More than one INDEX key was created for column `mid`
More than one INDEX key was created for column `gid`
More than one INDEX key was created for column `score`
More than one INDEX key was created for column `timespent`

Problems with indexes of table `games_session`
More than one INDEX key was created for column `mid`
More than one INDEX key was created for column `gameid`

Problems with indexes of table `tournaments`
More than one INDEX key was created for column `gid`

Problems with indexes of table `tournament_players`
More than one INDEX key was created for column `mid`
More than one INDEX key was created for column `tid`
More than one INDEX key was created for column `rung`

Problems with indexes of table `tournament_players_statut`
More than one INDEX key was created for column `tid`
More than one INDEX key was created for column `mid`

This is how the indexes of `tournament_players_statut`look like:
Keyname Type Cardinality Action Field
tid INDEX None Edit Drop tid
mid INDEX None Edit Drop mid
tid_2 INDEX None Edit Drop tid
mid_2 INDEX None Edit Drop mid

Any idea what I should do? Thanks :)