| blob | b86897c1484c91969896ae5545b25bafc9dc41da |
1 # Loot indexes\r
2 # ALTER TABLE `creature_loot_template` DROP INDEX `idx_item`;\r
3 # ALTER TABLE `creature_loot_template` DROP INDEX `idx_ref`;\r
4 CREATE INDEX `idx_item` ON `creature_loot_template` (`item`);\r
5 CREATE INDEX `idx_ref` ON `creature_loot_template` (`mincountOrRef`);\r
6 # ALTER TABLE `disenchant_loot_template` DROP INDEX `idx_item`;\r
7 # ALTER TABLE `disenchant_loot_template` DROP INDEX `idx_ref`;\r
8 CREATE INDEX `idx_item` ON `disenchant_loot_template` (`item`);\r
9 CREATE INDEX `idx_ref` ON `disenchant_loot_template` (`mincountOrRef`);\r
10 # ALTER TABLE `fishing_loot_template` DROP INDEX `idx_item`;\r
11 # ALTER TABLE `fishing_loot_template` DROP INDEX `idx_ref`;\r
12 CREATE INDEX `idx_item` ON `fishing_loot_template` (`item`);\r
13 CREATE INDEX `idx_ref` ON `fishing_loot_template` (`mincountOrRef`);\r
14 # ALTER TABLE `gameobject_loot_template` DROP INDEX `idx_item`;\r
15 # ALTER TABLE `gameobject_loot_template` DROP INDEX `idx_ref`;\r
16 CREATE INDEX `idx_item` ON `gameobject_loot_template` (`item`);\r
17 CREATE INDEX `idx_ref` ON `gameobject_loot_template` (`mincountOrRef`);\r
18 # ALTER TABLE `item_loot_template` DROP INDEX `idx_item`;\r
19 # ALTER TABLE `item_loot_template` DROP INDEX `idx_ref`;\r
20 CREATE INDEX `idx_item` ON `item_loot_template` (`item`);\r
21 CREATE INDEX `idx_ref` ON `item_loot_template` (`mincountOrRef`);\r
22 # ALTER TABLE `pickpocketing_loot_template` DROP INDEX `idx_item`;\r
23 # ALTER TABLE `pickpocketing_loot_template` DROP INDEX `idx_ref`;\r
24 CREATE INDEX `idx_item` ON `pickpocketing_loot_template`(`item`);\r
25 CREATE INDEX `idx_ref` ON `pickpocketing_loot_template`(`mincountOrRef`);\r
26 # ALTER TABLE `prospecting_loot_template` DROP INDEX `idx_item`;\r
27 # ALTER TABLE `prospecting_loot_template` DROP INDEX `idx_ref`;\r
28 CREATE INDEX `idx_item` ON `prospecting_loot_template` (`item`);\r
29 CREATE INDEX `idx_ref` ON `prospecting_loot_template` (`mincountOrRef`);\r
30 # ALTER TABLE `skinning_loot_template` DROP INDEX `idx_item`;\r
31 # ALTER TABLE `skinning_loot_template` DROP INDEX `idx_ref`;\r
32 CREATE INDEX `idx_item` ON `skinning_loot_template` (`item`);\r
33 CREATE INDEX `idx_ref` ON `skinning_loot_template` (`mincountOrRef`);\r
34 # ALTER TABLE `milling_loot_template` DROP INDEX `idx_item`;\r
35 # ALTER TABLE `milling_loot_template` DROP INDEX `idx_ref`;\r
36 CREATE INDEX `idx_item` ON `milling_loot_template` (`item`);\r
37 CREATE INDEX `idx_ref` ON `milling_loot_template` (`mincountOrRef`);\r
38 # ALTER TABLE `mail_loot_template` DROP INDEX `idx_item`;\r
39 # ALTER TABLE `mail_loot_template` DROP INDEX `idx_ref`;\r
40 CREATE INDEX `idx_item` ON `mail_loot_template` (`item`);\r
41 CREATE INDEX `idx_ref` ON `mail_loot_template` (`mincountOrRef`);\r
42 # ALTER TABLE `reference_loot_template` DROP INDEX `idx_item`;\r
43 # ALTER TABLE `reference_loot_template` DROP INDEX `idx_ref`;\r
44 CREATE INDEX `idx_item` ON `reference_loot_template` (`item`);\r
45 CREATE INDEX `idx_ref` ON `reference_loot_template` (`mincountOrRef`);\r
46 # Creature indexes\r
47 # ALTER TABLE `creature_template` DROP INDEX `idx_loot`;\r
48 # ALTER TABLE `creature_template` DROP INDEX `idx_skinloot`;\r
49 # ALTER TABLE `creature_template` DROP INDEX `idx_pickpocketloot`;\r
50 # ALTER TABLE `creature_template` DROP INDEX `idx_factionA`;\r
51 # ALTER TABLE `creature_template` DROP INDEX `idx_factionH`;\r
52 CREATE INDEX `idx_loot` ON `creature_template` (`LootId`);\r
53 CREATE INDEX `idx_skinloot` ON `creature_template` (`SkinningLootId`);\r
54 CREATE INDEX `idx_pickpocketloot` ON `creature_template` (`PickpocketLootId`);\r
55 CREATE INDEX `idx_factionA` ON `creature_template` (`FactionAlliance`);\r
56 CREATE INDEX `idx_factionH` ON `creature_template` (`FactionHorde`);\r
57 # Creature spell indexes\r
58 # ALTER TABLE `creature_template_spells` DROP INDEX `idx_spell1`;\r
59 # ALTER TABLE `creature_template_spells` DROP INDEX `idx_spell2`;\r
60 # ALTER TABLE `creature_template_spells` DROP INDEX `idx_spell3`;\r
61 # ALTER TABLE `creature_template_spells` DROP INDEX `idx_spell4`;\r
62 # ALTER TABLE `creature_template_spells` DROP INDEX `idx_spell5`;\r
63 # ALTER TABLE `creature_template_spells` DROP INDEX `idx_spell6`;\r
64 # ALTER TABLE `creature_template_spells` DROP INDEX `idx_spell7`;\r
65 # ALTER TABLE `creature_template_spells` DROP INDEX `idx_spell8`;\r
66 CREATE INDEX `idx_spell1` ON `creature_template_spells` (`spell1`);\r
67 CREATE INDEX `idx_spell2` ON `creature_template_spells` (`spell2`);\r
68 CREATE INDEX `idx_spell3` ON `creature_template_spells` (`spell3`);\r
69 CREATE INDEX `idx_spell4` ON `creature_template_spells` (`spell4`);\r
70 CREATE INDEX `idx_spell5` ON `creature_template_spells` (`spell5`);\r
71 CREATE INDEX `idx_spell6` ON `creature_template_spells` (`spell6`);\r
72 CREATE INDEX `idx_spell7` ON `creature_template_spells` (`spell7`);\r
73 CREATE INDEX `idx_spell8` ON `creature_template_spells` (`spell8`);\r
74 # Trainer\r
75 # ALTER TABLE `npc_trainer` DROP INDEX `idx_spell`;\r
76 CREATE INDEX `idx_spell` ON `npc_trainer` (`spell`);\r
77 # ALTER TABLE `npc_trainer_template` DROP INDEX `idx_spell`;\r
78 CREATE INDEX `idx_spell` ON `npc_trainer_template` (`spell`);\r
79 # Vendor\r
80 # ALTER TABLE `npc_vendor` DROP INDEX `idx_sold`;\r
81 CREATE INDEX `idx_sold` ON `npc_vendor` (`item`);\r
82 # ALTER TABLE `npc_vendor_template` DROP INDEX `idx_sold`;\r
83 CREATE INDEX `idx_sold` ON `npc_vendor_template` (`item`);\r
84 # Item indexes\r
85 # ALTER TABLE `item_template` DROP INDEX `idx_quest`;\r
86 # ALTER TABLE `item_template` DROP INDEX `idx_reqFaction`;\r
87 # ALTER TABLE `item_template` DROP INDEX `idx_spell1`;\r
88 # ALTER TABLE `item_template` DROP INDEX `idx_spell2`;\r
89 # ALTER TABLE `item_template` DROP INDEX `idx_spell3`;\r
90 # ALTER TABLE `item_template` DROP INDEX `idx_spell4`;\r
91 # ALTER TABLE `item_template` DROP INDEX `idx_spell5`;\r
92 # ALTER TABLE `item_template` DROP INDEX `idx_disenchant`;\r
93 CREATE INDEX `idx_quest` ON `item_template` (`startquest`);\r
94 CREATE INDEX `idx_reqFaction` ON `item_template` (`RequiredReputationFaction`);\r
95 CREATE INDEX `idx_spell1` ON `item_template` (`spellid_1`);\r
96 CREATE INDEX `idx_spell2` ON `item_template` (`spellid_2`);\r
97 CREATE INDEX `idx_spell3` ON `item_template` (`spellid_3`);\r
98 CREATE INDEX `idx_spell4` ON `item_template` (`spellid_4`);\r
99 CREATE INDEX `idx_spell5` ON `item_template` (`spellid_5`);\r
100 CREATE INDEX `idx_disenchant` ON `item_template` (`DisenchantID`);\r
101 # Quest indexes\r
102 # ALTER TABLE `quest_template` DROP INDEX `idx_rewSpell`;\r
103 # ALTER TABLE `quest_template` DROP INDEX `idx_castSpell`;\r
104 CREATE INDEX `idx_rewSpell` ON `quest_template` (`RewSpell`);\r
105 CREATE INDEX `idx_castSpell` ON `quest_template` (`RewSpellCast`);\r
106 #\r
107 # ALTER TABLE `creature_questrelation` DROP INDEX `idx_quest`;\r
108 # ALTER TABLE `gameobject_questrelation` DROP INDEX `idx_quest`;\r
109 # ALTER TABLE `creature_involvedrelation` DROP INDEX `idx_quest`;\r
110 # ALTER TABLE `gameobject_involvedrelation` DROP INDEX `idx_quest`;\r
111 CREATE INDEX `idx_quest` ON `creature_questrelation` (`quest`);\r
112 CREATE INDEX `idx_quest` ON `gameobject_questrelation` (`quest`);\r
113 CREATE INDEX `idx_quest` ON `creature_involvedrelation` (`quest`);\r
114 CREATE INDEX `idx_quest` ON `gameobject_involvedrelation` (`quest`);\r
115 # GO indexes\r
116 # ALTER TABLE `gameobject_template` DROP INDEX `idx_type`;\r
117 # ALTER TABLE `gameobject_template` DROP INDEX `idx_faction`;\r
118 # ALTER TABLE `gameobject_template` DROP INDEX `idx_data0`;\r
119 # ALTER TABLE `gameobject_template` DROP INDEX `idx_data1`;\r
120 # ALTER TABLE `gameobject_template` DROP INDEX `idx_data2`;\r
121 # ALTER TABLE `gameobject_template` DROP INDEX `idx_data3`;\r
122 # ALTER TABLE `gameobject_template` DROP INDEX `idx_data10`;\r
123 CREATE INDEX `idx_type` ON `gameobject_template` (`type`);\r
124 CREATE INDEX `idx_faction` ON `gameobject_template` (`faction`);\r
125 CREATE INDEX `idx_data0` ON `gameobject_template` (`data0`);\r
126 CREATE INDEX `idx_data1` ON `gameobject_template` (`data1`);\r
127 CREATE INDEX `idx_data2` ON `gameobject_template` (`data2`);\r
128 CREATE INDEX `idx_data3` ON `gameobject_template` (`data3`);\r
129 CREATE INDEX `idx_data10` ON `gameobject_template` (`data10`);