![]() |
[HELP] - Problem With Table Indexes
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 :) |
All times are GMT. The time now is 08:14 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|