DELIMITER $$

CREATE PROCEDURE drop_index_if_exists(IN theTable VARCHAR(128), IN theIndexName VARCHAR(128) )
BEGIN
 IF((SELECT COUNT(*) AS index_exists FROM information_schema.statistics WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME =
theTable AND index_name = theIndexName) > 0) THEN
   SET @s = CONCAT('DROP INDEX ' , theIndexName , ' ON ' , theTable);
   PREPARE stmt FROM @s;
   EXECUTE stmt;
 END IF;
END $$

CALL drop_index_if_exists('ss_affiliate_transfers','code_used') $$
CALL drop_index_if_exists('ss_affiliate_transfers','user_referred_id') $$

CALL drop_index_if_exists('ss_bots_inventories','time_added') $$
CALL drop_index_if_exists('ss_bots_inventories','item_name') $$

CALL drop_index_if_exists('ss_csgo_prices','item_banned_time') $$

CALL drop_index_if_exists('ss_games','client_seed') $$
CALL drop_index_if_exists('ss_games','server_seed') $$
CALL drop_index_if_exists('ss_games','game_number') $$

CALL drop_index_if_exists('ss_trade_offers','trade_status') $$
CALL drop_index_if_exists('ss_trade_offers','trade_amount') $$
CALL drop_index_if_exists('ss_trade_offers','trade_started') $$
CALL drop_index_if_exists('ss_trade_offers','trade_ended') $$

CALL drop_index_if_exists('ss_users','name') $$
CALL drop_index_if_exists('ss_users','registered_ip') $$
CALL drop_index_if_exists('ss_users','last_login_ip') $$
CALL drop_index_if_exists('ss_users','refs_balance_tmp') $$
CALL drop_index_if_exists('ss_users','referred_by') $$

DROP PROCEDURE IF EXISTS drop_index_if_exists $$
ss_users
DELIMITER ;