| blob | f1886e1f312d1796d4518ae3c305558e9a5f86fa |
1 -- Loot indexes\r
2 CREATE INDEX `idx_item` ON `creature_loot_template` (`item`);\r
3 CREATE INDEX `idx_ref` ON `creature_loot_template` (`mincountOrRef`);\r
4 CREATE INDEX `idx_item` ON `disenchant_loot_template` (`item`);\r
5 CREATE INDEX `idx_ref` ON `disenchant_loot_template` (`mincountOrRef`);\r
6 CREATE INDEX `idx_item` ON `fishing_loot_template` (`item`);\r
7 CREATE INDEX `idx_ref` ON `fishing_loot_template` (`mincountOrRef`);\r
8 CREATE INDEX `idx_item` ON `gameobject_loot_template` (`item`);\r
9 CREATE INDEX `idx_ref` ON `gameobject_loot_template` (`mincountOrRef`);\r
10 CREATE INDEX `idx_item` ON `item_loot_template` (`item`);\r
11 CREATE INDEX `idx_ref` ON `item_loot_template` (`mincountOrRef`);\r
12 CREATE INDEX `idx_item` ON `pickpocketing_loot_template`(`item`);\r
13 CREATE INDEX `idx_ref` ON `pickpocketing_loot_template`(`mincountOrRef`);\r
14 CREATE INDEX `idx_item` ON `prospecting_loot_template` (`item`);\r
15 CREATE INDEX `idx_ref` ON `prospecting_loot_template` (`mincountOrRef`);\r
16 CREATE INDEX `idx_item` ON `skinning_loot_template` (`item`);\r
17 CREATE INDEX `idx_ref` ON `skinning_loot_template` (`mincountOrRef`);\r
18 CREATE INDEX `idx_item` ON `milling_loot_template` (`item`);\r
19 CREATE INDEX `idx_ref` ON `milling_loot_template` (`mincountOrRef`);\r
20 CREATE INDEX `idx_item` ON `mail_loot_template` (`item`);\r
21 CREATE INDEX `idx_ref` ON `mail_loot_template` (`mincountOrRef`);\r
22 CREATE INDEX `idx_item` ON `reference_loot_template` (`item`);\r
23 CREATE INDEX `idx_ref` ON `reference_loot_template` (`mincountOrRef`);\r
24 \r
25 -- Creature indexes\r
26 CREATE INDEX `idx_loot` ON `creature_template` (`lootid`);\r
27 CREATE INDEX `idx_skinloot` ON `creature_template` (`skinloot`);\r
28 CREATE INDEX `idx_pickpocketloot` ON `creature_template` (`pickpocketloot`);\r
29 CREATE INDEX `idx_factionA` ON `creature_template` (`faction_A`);\r
30 CREATE INDEX `idx_factionH` ON `creature_template` (`faction_H`);\r
31 CREATE INDEX `idx_spell1` ON `creature_template` (`spell1`);\r
32 CREATE INDEX `idx_spell2` ON `creature_template` (`spell2`);\r
33 CREATE INDEX `idx_spell3` ON `creature_template` (`spell3`);\r
34 \r
35 -- Trainer\r
36 CREATE INDEX `idx_spell` ON `npc_trainer` (`spell`);\r
37 \r
38 -- Vendor\r
39 CREATE INDEX `idx_sold` ON `npc_vendor` (`item`);\r
40 \r
41 -- Item indexes\r
42 CREATE INDEX `idx_quest` ON `item_template` (`startquest`);\r
43 CREATE INDEX `idx_reqFaction` ON `item_template` (`RequiredReputationFaction`);\r
44 CREATE INDEX `idx_spell1` ON `item_template` (`spellid_1`);\r
45 CREATE INDEX `idx_spell2` ON `item_template` (`spellid_2`);\r
46 CREATE INDEX `idx_spell3` ON `item_template` (`spellid_3`);\r
47 CREATE INDEX `idx_spell4` ON `item_template` (`spellid_4`);\r
48 CREATE INDEX `idx_spell5` ON `item_template` (`spellid_5`);\r
49 CREATE INDEX `idx_disenchant` ON `item_template` (`DisenchantID`);\r
50 \r
51 -- Quest indexes\r
52 CREATE INDEX `idx_rewSpell` ON `quest_template` (`RewSpell`);\r
53 CREATE INDEX `idx_castSpell` ON `quest_template` (`RewSpellCast`);\r
54 \r
55 CREATE INDEX `idx_quest` ON `creature_questrelation` (`quest`);\r
56 CREATE INDEX `idx_quest` ON `gameobject_questrelation` (`quest`);\r
57 \r
58 -- GO indexes\r
59 CREATE INDEX `idx_type` ON `gameobject_template` (`type`);\r
60 CREATE INDEX `idx_faction` ON `gameobject_template` (`faction`);\r
61 CREATE INDEX `idx_data0` ON `gameobject_template` (`data0`);\r
62 CREATE INDEX `idx_data1` ON `gameobject_template` (`data1`);\r
63 CREATE INDEX `idx_data2` ON `gameobject_template` (`data2`);\r
64 CREATE INDEX `idx_data3` ON `gameobject_template` (`data3`);\r
65 CREATE INDEX `idx_data10` ON `gameobject_template` (`data10`);\r