CREATE INDEX `aowow` ON `creature_loot_template`     (`mincountOrRef`);
CREATE INDEX `aowow` ON `disenchant_loot_template`   (`mincountOrRef`);
CREATE INDEX `aowow` ON `fishing_loot_template`      (`mincountOrRef`);
CREATE INDEX `aowow` ON `gameobject_loot_template`   (`mincountOrRef`);
CREATE INDEX `aowow` ON `item_loot_template`         (`mincountOrRef`);
CREATE INDEX `aowow` ON `pickpocketing_loot_template`(`mincountOrRef`);
CREATE INDEX `aowow` ON `prospecting_loot_template`  (`mincountOrRef`);
CREATE INDEX `aowow` ON `skinning_loot_template`     (`mincountOrRef`);

CREATE INDEX `aowow_lootid`         ON `creature_template` (`lootid`);
CREATE INDEX `aowow_skinloot`       ON `creature_template` (`skinloot`);
CREATE INDEX `aowow_pickpocketloot` ON `creature_template` (`pickpocketloot`);
CREATE INDEX `aowow_faction_A`      ON `creature_template` (`faction_A`);

CREATE INDEX `aowow_faction`        ON `item_template`     (`RequiredReputationFaction`);
