| blob | 6003a3014fa569ce5607a087e705f22404f2bdee |
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 \r
47 -- Creature indexes\r
48 ALTER TABLE `creature_template` DROP INDEX `idx_loot`;\r
49 ALTER TABLE `creature_template` DROP INDEX `idx_skinloot`;\r
50 ALTER TABLE `creature_template` DROP INDEX `idx_pickpocketloot`;\r
51 ALTER TABLE `creature_template` DROP INDEX `idx_factionA`;\r
52 ALTER TABLE `creature_template` DROP INDEX `idx_factionH`;\r
53 ALTER TABLE `creature_template` DROP INDEX `idx_spell1`;\r
54 ALTER TABLE `creature_template` DROP INDEX `idx_spell2`;\r
55 ALTER TABLE `creature_template` DROP INDEX `idx_spell3`;\r
56 ALTER TABLE `creature_template` DROP INDEX `idx_spell4`;\r
57 CREATE INDEX `idx_loot` ON `creature_template` (`lootid`);\r
58 CREATE INDEX `idx_skinloot` ON `creature_template` (`skinloot`);\r
59 CREATE INDEX `idx_pickpocketloot` ON `creature_template` (`pickpocketloot`);\r
60 CREATE INDEX `idx_factionA` ON `creature_template` (`faction_A`);\r
61 CREATE INDEX `idx_factionH` ON `creature_template` (`faction_H`);\r
62 CREATE INDEX `idx_spell1` ON `creature_template` (`spell1`);\r
63 CREATE INDEX `idx_spell2` ON `creature_template` (`spell2`);\r
64 CREATE INDEX `idx_spell3` ON `creature_template` (`spell3`);\r
65 CREATE INDEX `idx_spell4` ON `creature_template` (`spell4`);\r
66 \r
67 -- Trainer\r
68 ALTER TABLE `npc_trainer` DROP INDEX `idx_spell`;\r
69 CREATE INDEX `idx_spell` ON `npc_trainer` (`spell`);\r
70 \r
71 -- Vendor\r
72 ALTER TABLE `npc_vendor` DROP INDEX `idx_sold`;\r
73 CREATE INDEX `idx_sold` ON `npc_vendor` (`item`);\r
74 \r
75 -- Item indexes\r
76 ALTER TABLE `item_template` DROP INDEX `idx_quest`;\r
77 ALTER TABLE `item_template` DROP INDEX `idx_reqFaction`;\r
78 ALTER TABLE `item_template` DROP INDEX `idx_spell1`;\r
79 ALTER TABLE `item_template` DROP INDEX `idx_spell2`;\r
80 ALTER TABLE `item_template` DROP INDEX `idx_spell3`;\r
81 ALTER TABLE `item_template` DROP INDEX `idx_spell4`;\r
82 ALTER TABLE `item_template` DROP INDEX `idx_spell5`;\r
83 ALTER TABLE `item_template` DROP INDEX `idx_disenchant`;\r
84 CREATE INDEX `idx_quest` ON `item_template` (`startquest`);\r
85 CREATE INDEX `idx_reqFaction` ON `item_template` (`RequiredReputationFaction`);\r
86 CREATE INDEX `idx_spell1` ON `item_template` (`spellid_1`);\r
87 CREATE INDEX `idx_spell2` ON `item_template` (`spellid_2`);\r
88 CREATE INDEX `idx_spell3` ON `item_template` (`spellid_3`);\r
89 CREATE INDEX `idx_spell4` ON `item_template` (`spellid_4`);\r
90 CREATE INDEX `idx_spell5` ON `item_template` (`spellid_5`);\r
91 CREATE INDEX `idx_disenchant` ON `item_template` (`DisenchantID`);\r
92 \r
93 -- Quest indexes\r
94 ALTER TABLE `quest_template` DROP INDEX `idx_rewSpell`;\r
95 ALTER TABLE `quest_template` DROP INDEX `idx_castSpell`;\r
96 CREATE INDEX `idx_rewSpell` ON `quest_template` (`RewSpell`);\r
97 CREATE INDEX `idx_castSpell` ON `quest_template` (`RewSpellCast`);\r
98 \r
99 ALTER TABLE `creature_questrelation` DROP INDEX `idx_quest`;\r
100 ALTER TABLE `gameobject_questrelation` DROP INDEX `idx_quest`;\r
101 CREATE INDEX `idx_quest` ON `creature_questrelation` (`quest`);\r
102 CREATE INDEX `idx_quest` ON `gameobject_questrelation` (`quest`);\r
103 \r
104 -- GO indexes\r
105 ALTER TABLE `gameobject_template` DROP INDEX `idx_type`;\r
106 ALTER TABLE `gameobject_template` DROP INDEX `idx_faction`;\r
107 ALTER TABLE `gameobject_template` DROP INDEX `idx_data0`;\r
108 ALTER TABLE `gameobject_template` DROP INDEX `idx_data1`;\r
109 ALTER TABLE `gameobject_template` DROP INDEX `idx_data2`;\r
110 ALTER TABLE `gameobject_template` DROP INDEX `idx_data3`;\r
111 ALTER TABLE `gameobject_template` DROP INDEX `idx_data10`;\r
112 CREATE INDEX `idx_type` ON `gameobject_template` (`type`);\r
113 CREATE INDEX `idx_faction` ON `gameobject_template` (`faction`);\r
114 CREATE INDEX `idx_data0` ON `gameobject_template` (`data0`);\r
115 CREATE INDEX `idx_data1` ON `gameobject_template` (`data1`);\r
116 CREATE INDEX `idx_data2` ON `gameobject_template` (`data2`);\r
117 CREATE INDEX `idx_data3` ON `gameobject_template` (`data3`);\r
118 CREATE INDEX `idx_data10` ON `gameobject_template` (`data10`);