source: aowow/tools/sql/indexes.sql

Last change on this file was 170, checked in by maron, 16 years ago
File size: 980 bytes
Line 
1CREATE INDEX `aowow` ON `creature_loot_template` (`mincountOrRef`);
2CREATE INDEX `aowow` ON `disenchant_loot_template` (`mincountOrRef`);
3CREATE INDEX `aowow` ON `fishing_loot_template` (`mincountOrRef`);
4CREATE INDEX `aowow` ON `gameobject_loot_template` (`mincountOrRef`);
5CREATE INDEX `aowow` ON `item_loot_template` (`mincountOrRef`);
6CREATE INDEX `aowow` ON `pickpocketing_loot_template`(`mincountOrRef`);
7CREATE INDEX `aowow` ON `prospecting_loot_template` (`mincountOrRef`);
8CREATE INDEX `aowow` ON `skinning_loot_template` (`mincountOrRef`);
9
10CREATE INDEX `aowow_lootid` ON `creature_template` (`lootid`);
11CREATE INDEX `aowow_skinloot` ON `creature_template` (`skinloot`);
12CREATE INDEX `aowow_pickpocketloot` ON `creature_template` (`pickpocketloot`);
13CREATE INDEX `aowow_faction_A` ON `creature_template` (`faction_A`);
14
15CREATE INDEX `aowow_faction` ON `item_template` (`RequiredReputationFaction`);
Note: See TracBrowser for help on using the repository browser.