DROP INDEX `aowow` ON `creature_loot_template`;
DROP INDEX `aowow` ON `disenchant_loot_template`;
DROP INDEX `aowow` ON `fishing_loot_template`;
DROP INDEX `aowow` ON `gameobject_loot_template`;
DROP INDEX `aowow` ON `item_loot_template`;
DROP INDEX `aowow` ON `pickpocketing_loot_template`;
DROP INDEX `aowow` ON `prospecting_loot_template`;
DROP INDEX `aowow` ON `skinning_loot_template`;
DROP INDEX `aowow` ON `reference_loot_template`;

DROP INDEX `aowow_item` ON `creature_loot_template`;
DROP INDEX `aowow_item` ON `disenchant_loot_template`;
DROP INDEX `aowow_item` ON `fishing_loot_template`;
DROP INDEX `aowow_item` ON `gameobject_loot_template`;
DROP INDEX `aowow_item` ON `item_loot_template`;
DROP INDEX `aowow_item` ON `pickpocketing_loot_template`;
DROP INDEX `aowow_item` ON `prospecting_loot_template`;
DROP INDEX `aowow_item` ON `skinning_loot_template`;
DROP INDEX `aowow_item` ON `reference_loot_template`;

DROP INDEX `aowow_lootid`         ON `creature_template`;
DROP INDEX `aowow_skinloot`       ON `creature_template`;
DROP INDEX `aowow_pickpocketloot` ON `creature_template`;
DROP INDEX `aowow_faction_A`      ON `creature_template`;

DROP INDEX `aowow_faction` ON `item_template`;