1 # Copyright (C) 2005-2010 MaNGOS <http://getmangos.com/>
3 # This program is free software; you can redistribute it and/or modify
4 # it under the terms of the GNU General Public License as published by
5 # the Free Software Foundation; either version 2 of the License, or
6 # (at your option) any later version.
8 # This program is distributed in the hope that it will be useful,
9 # but WITHOUT ANY WARRANTY; without even the implied warranty of
10 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11 # GNU General Public License for more details.
13 # You should have received a copy of the GNU General Public License
14 # along with this program; if not, write to the Free Software
15 # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
17 ## Process this file with automake to produce Makefile.in
19 ## Sub-directories to parse
21 ## Change installation location
22 # datadir = mangos/sql/updates
23 pkgdatadir = $(datadir)/mangos/sql/updates
25 ## Files to be installed
26 # Install basic SQL files to datadir
28 7988_01_mangos_item_template.sql \
29 7988_02_characters_character_equipmentsets.sql \
30 7988_03_mangos_spell_chain.sql \
31 7988_04_mangos_creature_template.sql \
32 7988_05_mangos_item_template.sql \
33 7988_06_mangos_gameobject_template.sql \
34 7988_07_characters_characters.sql \
35 7988_08_mangos_spell_bonus_data.sql \
36 7988_09_mangos_spell_proc_event.sql \
37 8016_01_mangos_npc_spellclick_spells.sql \
38 8021_01_mangos_spell_proc_event.sql \
39 8030_01_characters_character_spell.sql \
40 8030_02_characters_character_action.sql \
41 8030_03_mangos_npc_trainer.sql \
42 8050_01_mangos_spell_proc_event.sql \
43 8050_02_mangos_spell_bonus_data.sql \
44 8053_01_mangos_command.sql \
45 8060_01_mangos_spell_pet_auras.sql \
46 8064_01_mangos_spell_chain.sql \
47 8065_01_mangos_spell_proc_event.sql \
48 8071_01_mangos_command.sql \
49 8072_01_characters_characters.sql \
50 8072_02_characters_characters.sql \
51 8098_01_characters_character_action.sql \
52 8098_02_mangos_playercreateinfo_action.sql \
53 8098_03_characters_character_pet.sql \
54 8098_04_characters_pet_spell.sql \
55 8104_01_characters.sql \
56 8112_01_mangos_spell_proc_event.sql \
57 8115_01_mangos_playercreateinfo_action.sql \
58 8140_01_mangos_spell_proc_event.sql \
59 8158_01_mangos_playercreateinfo_action.sql \
60 8190_01_mangos_creature_template.sql \
61 8191_01_mangos_spell_affect.sql \
62 8211_01_mangos_spell_proc_event.sql \
63 8212_01_mangos_spell_proc_event.sql \
64 8213_01_mangos_spell_bonus_data.sql \
65 8227_01_mangos_spell_proc_event.sql \
66 8237_01_mangos_creature_template.sql \
67 8247_01_mangos_spell_bonus_data.sql \
68 8249_01_mangos_spell_proc_item_enchant.sql \
69 8249_02_mangos_spell_chain.sql \
70 8250_01_mangos_spell_threat.sql \
71 8251_01_mangos_spell_chain.sql \
72 8251_02_mangos_spell_bonus_data.sql \
73 8251_03_mangos_spell_proc_event.sql \
74 8253_01_mangos_spell_chain.sql \
75 8253_02_mangos_spell_proc_event.sql \
76 8254_01_mangos_spell_proc_event.sql \
77 8294_01_mangos_playercreateinfo_action.sql \
78 8310_01_mangos_spell_proc_event.sql \
79 8332_01_realmd_realmcharacters.sql \
80 8339_01_characters_characters.sql \
81 8339_02_characters_character_battleground_data.sql \
82 8342_01_mangos_spell_proc_event.sql \
83 8361_01_mangos_spell_bonus_data.sql \
84 8364_01_mangos_db_version.sql \
85 8377_01_mangos_spell_area.sql \
86 8392_01_mangos_spell_proc_event.sql \
87 8392_02_mangos_spell_chain.sql \
88 8394_01_mangos_spell_proc_event.sql \
89 8397_01_mangos_spell_chain.sql \
90 8397_02_mangos_spell_threat.sql \
91 8397_03_characters_character_spell.sql \
92 8399_01_mangos_spell_elixir.sql \
93 8402_01_characters_guild_eventlog.sql \
94 8402_02_characters_guild_bank_eventlog.sql \
95 8409_01_characters_guild.sql \
96 8412_01_mangos_mangos_string.sql \
97 8416_01_mangos_spell_learn_spell.sql \
98 8433_01_characters_character_account_data.sql \
99 8444_01_mangos_mangos_string.sql \
100 8451_01_mangos_spell_proc_event.sql \
101 8462_01_mangos_creature_ai_texts.sql \
102 8469_01_characters_character_spell.sql \
103 8482_01_mangos_spell_elixir.sql \
104 8487_01_mangos_spell_bonus_data.sql \
105 8487_02_mangos_spell_proc_event.sql \
106 8488_01_mangos_spell_chain.sql \
107 8488_02_mangos_spell_bonus_data.sql \
108 8498_01_mangos_spell_proc_event.sql \
109 8499_01_mangos_spell_elixir.sql \
110 8504_01_mangos_playercreateinfo_spell.sql \
111 8504_02_mangos_playercreateinfo_action.sql \
112 8505_01_characters_character_spell.sql \
113 8511_01_mangos_spell_proc_event.sql \
114 8514_01_mangos_spell_bonus_data.sql \
115 8521_01_mangos_spell_proc_event.sql \
116 8548_01_mangos_creature_battleground.sql \
117 8548_02_mangos_gameobject_battleground.sql \
118 8549_03_mangos_battleground_events.sql \
119 8573_01_mangos_mangos_string.sql \
120 8589_01_mangos_creature_template.sql \
121 8589_02_mangos_gameobject_template.sql \
122 8589_03_mangos_item_template.sql \
123 8589_04_characters_groups.sql \
124 8589_05_mangos_battleground_template.sql \
125 8589_06_characters_bugreport.sql \
126 8589_07_mangos_spell_elixir.sql \
127 8589_08_mangos_item_template.sql \
128 8589_09_mangos_spell_chain.sql \
129 8589_10_mangos_spell_proc_event.sql \
130 8589_11_characters_characters.sql \
131 8596_01_characters_bugreport.sql \
132 8600_01_mangos_command.sql \
133 8607_01_mangos_string.sql \
134 8607_02_mangos_command.sql \
135 8608_01_mangos_mangos_string.sql \
136 8608_02_mangos_battleground_events.sql \
137 8618_01_mangos_spell_proc_event.sql \
138 8676_01_mangos_creature_template.sql \
139 8688_01_mangos_creature_template.sql \
140 8693_01_mangos_spell_proc_event.sql \
141 8702_01_characters_character_reputation.sql \
142 8720_01_mangos_quest_template.sql \
143 8721_01_characters_guild.sql \
144 8723_01_mangos_achievement_criteria_requirement.sql \
145 8726_01_mangos_spell_proc_event.sql \
146 8728_01_realmd_account.sql \
147 8731_01_mangos_creature_template.sql \
148 8749_01_mangos_mail_loot_template.sql \
149 8769_01_mangos_mail_level_reward.sql \
150 8770_01_mangos_quest_template.sql \
151 8775_01_mangos_creature_template.sql \
152 8775_02_mangos_creature.sql \
153 8775_03_mangos_gameobject.sql \
154 8777_01_mangos_creature.sql \
155 8777_02_mangos_gameobject.sql \
156 8800_01_mangos_spell_elixir.sql \
157 8803_01_mangos_playercreateinfo_spell.sql \
158 8803_02_mangos_playercreateinfo_action.sql \
159 8815_01_mangos_mangos_string.sql \
160 8818_01_mangos_mangos_string.sql \
161 8828_01_characters_instance_reset.sql \
162 8828_02_mangos_instance_template.sql \
163 8833_01_mangos_mangos_string.sql \
164 8833_02_mangos_command.sql \
165 8835_01_mangos_command.sql \
166 8840_01_mangos_spell_proc_event.sql \
167 8841_01_mangos_spell_proc_event.sql \
168 8841_02_mangos_spell_chain.sql \
169 8843_01_characters.sql \
170 8847_01_mangos_spell_proc_event.sql \
171 8847_02_mangos_spell_chain.sql \
172 8851_01_mangos_spell_proc_event.sql \
173 8856_01_mangos_spell_proc_event.sql \
174 8863_01_mangos_spell_proc_event.sql \
175 8873_01_mangos_spell_proc_event.sql \
176 8873_02_mangos_spell_learn_spell.sql \
177 8874_01_characters_character_skills.sql \
178 8882_01_mangos_spell_proc_event.sql \
179 8882_02_mangos_spell_chain.sql \
180 8882_03_mangos_spell_bonus_data.sql \
181 8883_01_mangos_spell_proc_event.sql \
182 8883_02_mangos_spell_bonus_data.sql \
183 8886_01_mangos_string.sql \
184 8889_01_mangos_spell_pet_auras.sql \
185 8891_01_mangos_spell_proc_event.sql \
186 8893_01_mangos_mangos_string.sql \
187 8899_01_mangos_spell_proc_event.sql \
188 8908_01_mangos_spell_chain.sql \
189 8909_01_mangos_spell_proc_event.sql \
190 8912_01_mangos_spell_proc_event.sql \
191 8917_01_mangos_spell_proc_event.sql \
192 8923_01_mangos_gossip.sql \
193 8929_01_mangos_gossip_scripts.sql \
194 8930_01_mangos_spell_proc_event.sql \
195 8931_01_mangos_spell_bonus_data.sql \
196 8932_01_mangos_spell_chain.sql \
197 8938_01_mangos_spell_proc_event.sql \
198 8943_01_mangos_spell_chain.sql \
199 8946_01_mangos_spell_proc_event.sql \
200 8950_01_mangos_spell_proc_event.sql \
201 8965_01_mangos_mangos_string.sql \
202 8965_02_mangos_command.sql \
203 8980_01_mangos_spell_bonus_data.sql \
204 8981_01_mangos_spell_proc_event.sql \
205 8988_01_mangos_spell_proc_event.sql \
206 8992_01_mangos_spell_proc_event.sql \
207 8992_02_mangos_spell_chain.sql \
208 8993_01_mangos_spell_proc_event.sql \
209 8995_01_mangos_spell_proc_event.sql \
210 8996_01_mangos_spell_proc_event.sql \
211 9001_01_mangos_spell_proc_event.sql \
212 9005_01_mangos_spell_proc_event.sql \
213 9007_01_mangos_spell_proc_event.sql \
214 9010_01_realmd_realmlist.sql \
215 9015_01_mangos_spell_bonus_data.sql \
216 9018_01_mangos_spell_bonus_data.sql \
217 9019_01_mangos_spell_threat.sql \
218 9025_01_mangos_spell_proc_event.sql \
219 9034_01_mangos_spell_proc_event.sql \
220 9045_01_mangos_spell_proc_event.sql \
221 9045_02_mangos_spell_chain.sql \
222 9064_01_mangos_spell_proc_event.sql \
223 9068_01_mangos_spell_proc_event.sql \
224 9068_02_mangos_spell_chain.sql \
225 9070_01_mangos_spell_proc_event.sql \
226 9074_01_mangos_command.sql \
227 9095_01_mangos_command.sql \
228 9121_01_mangos_npc_spellclick_spells.sql \
229 9125_01_mangos_npc_spellclick_spells.sql \
230 9133_01_mangos_spell_proc_event.sql \
231 9136_01_characters_account_data.sql \
232 9136_02_mangos_quest_poi.sql \
233 9136_03_characters_character_ticket.sql \
234 9136_04_mangos_spell_chain.sql \
235 9136_05_mangos_spell_bonus_data.sql \
236 9136_06_mangos_spell_proc_event.sql \
237 9136_07_characters_characters.sql \
238 9148_01_mangos_spell_bonus_data.sql \
239 9149_01_mangos_spell_bonus_data.sql \
242 ## Additional files to include when running 'make dist'
243 # SQL update files, to upgrade database schema from older revisions
245 7988_01_mangos_item_template.sql \
246 7988_02_characters_character_equipmentsets.sql \
247 7988_03_mangos_spell_chain.sql \
248 7988_04_mangos_creature_template.sql \
249 7988_05_mangos_item_template.sql \
250 7988_06_mangos_gameobject_template.sql \
251 7988_07_characters_characters.sql \
252 7988_08_mangos_spell_bonus_data.sql \
253 7988_09_mangos_spell_proc_event.sql \
254 8016_01_mangos_npc_spellclick_spells.sql \
255 8021_01_mangos_spell_proc_event.sql \
256 8030_01_characters_character_spell.sql \
257 8030_02_characters_character_action.sql \
258 8030_03_mangos_npc_trainer.sql \
259 8050_01_mangos_spell_proc_event.sql \
260 8050_02_mangos_spell_bonus_data.sql \
261 8053_01_mangos_command.sql \
262 8060_01_mangos_spell_pet_auras.sql \
263 8064_01_mangos_spell_chain.sql \
264 8065_01_mangos_spell_proc_event.sql \
265 8071_01_mangos_command.sql \
266 8072_01_characters_characters.sql \
267 8072_02_characters_characters.sql \
268 8098_01_characters_character_action.sql \
269 8098_02_mangos_playercreateinfo_action.sql \
270 8098_03_characters_character_pet.sql \
271 8098_04_characters_pet_spell.sql \
272 8104_01_characters.sql \
273 8112_01_mangos_spell_proc_event.sql \
274 8115_01_mangos_playercreateinfo_action.sql \
275 8140_01_mangos_spell_proc_event.sql \
276 8158_01_mangos_playercreateinfo_action.sql \
277 8190_01_mangos_creature_template.sql \
278 8191_01_mangos_spell_affect.sql \
279 8211_01_mangos_spell_proc_event.sql \
280 8212_01_mangos_spell_proc_event.sql \
281 8213_01_mangos_spell_bonus_data.sql \
282 8227_01_mangos_spell_proc_event.sql \
283 8237_01_mangos_creature_template.sql \
284 8247_01_mangos_spell_bonus_data.sql \
285 8249_01_mangos_spell_proc_item_enchant.sql \
286 8249_02_mangos_spell_chain.sql \
287 8250_01_mangos_spell_threat.sql \
288 8251_01_mangos_spell_chain.sql \
289 8251_02_mangos_spell_bonus_data.sql \
290 8251_03_mangos_spell_proc_event.sql \
291 8253_01_mangos_spell_chain.sql \
292 8253_02_mangos_spell_proc_event.sql \
293 8254_01_mangos_spell_proc_event.sql \
294 8294_01_mangos_playercreateinfo_action.sql \
295 8310_01_mangos_spell_proc_event.sql \
296 8332_01_realmd_realmcharacters.sql \
297 8339_01_characters_characters.sql \
298 8339_02_characters_character_battleground_data.sql \
299 8342_01_mangos_spell_proc_event.sql \
300 8361_01_mangos_spell_bonus_data.sql \
301 8364_01_mangos_db_version.sql \
302 8377_01_mangos_spell_area.sql \
303 8392_01_mangos_spell_proc_event.sql \
304 8392_02_mangos_spell_chain.sql \
305 8394_01_mangos_spell_proc_event.sql \
306 8397_01_mangos_spell_chain.sql \
307 8397_02_mangos_spell_threat.sql \
308 8397_03_characters_character_spell.sql \
309 8399_01_mangos_spell_elixir.sql \
310 8402_01_characters_guild_eventlog.sql \
311 8402_02_characters_guild_bank_eventlog.sql \
312 8409_01_characters_guild.sql \
313 8412_01_mangos_mangos_string.sql \
314 8416_01_mangos_spell_learn_spell.sql \
315 8433_01_characters_character_account_data.sql \
316 8444_01_mangos_mangos_string.sql \
317 8451_01_mangos_spell_proc_event.sql \
318 8462_01_mangos_creature_ai_texts.sql \
319 8469_01_characters_character_spell.sql \
320 8482_01_mangos_spell_elixir.sql \
321 8487_01_mangos_spell_bonus_data.sql \
322 8487_02_mangos_spell_proc_event.sql \
323 8488_01_mangos_spell_chain.sql \
324 8488_02_mangos_spell_bonus_data.sql \
325 8498_01_mangos_spell_proc_event.sql \
326 8499_01_mangos_spell_elixir.sql \
327 8504_01_mangos_playercreateinfo_spell.sql \
328 8504_02_mangos_playercreateinfo_action.sql \
329 8505_01_characters_character_spell.sql \
330 8511_01_mangos_spell_proc_event.sql \
331 8514_01_mangos_spell_bonus_data.sql \
332 8521_01_mangos_spell_proc_event.sql \
333 8548_01_mangos_creature_battleground.sql \
334 8548_02_mangos_gameobject_battleground.sql \
335 8549_03_mangos_battleground_events.sql \
336 8573_01_mangos_mangos_string.sql \
337 8589_01_mangos_creature_template.sql \
338 8589_02_mangos_gameobject_template.sql \
339 8589_03_mangos_item_template.sql \
340 8589_04_characters_groups.sql \
341 8589_05_mangos_battleground_template.sql \
342 8589_06_characters_bugreport.sql \
343 8589_07_mangos_spell_elixir.sql \
344 8589_08_mangos_item_template.sql \
345 8589_09_mangos_spell_chain.sql \
346 8589_10_mangos_spell_proc_event.sql \
347 8589_11_characters_characters.sql \
348 8596_01_characters_bugreport.sql \
349 8600_01_mangos_command.sql \
350 8607_01_mangos_string.sql \
351 8607_02_mangos_command.sql \
352 8608_01_mangos_mangos_string.sql \
353 8608_02_mangos_battleground_events.sql \
354 8618_01_mangos_spell_proc_event.sql \
355 8676_01_mangos_creature_template.sql \
356 8688_01_mangos_creature_template.sql \
357 8693_01_mangos_spell_proc_event.sql \
358 8702_01_characters_character_reputation.sql \
359 8720_01_mangos_quest_template.sql \
360 8721_01_characters_guild.sql \
361 8723_01_mangos_achievement_criteria_requirement.sql \
362 8726_01_mangos_spell_proc_event.sql \
363 8728_01_realmd_account.sql \
364 8731_01_mangos_creature_template.sql \
365 8749_01_mangos_mail_loot_template.sql \
366 8769_01_mangos_mail_level_reward.sql \
367 8770_01_mangos_quest_template.sql \
368 8775_01_mangos_creature_template.sql \
369 8775_02_mangos_creature.sql \
370 8775_03_mangos_gameobject.sql \
371 8777_01_mangos_creature.sql \
372 8777_02_mangos_gameobject.sql \
373 8800_01_mangos_spell_elixir.sql \
374 8803_01_mangos_playercreateinfo_spell.sql \
375 8803_02_mangos_playercreateinfo_action.sql \
376 8815_01_mangos_mangos_string.sql \
377 8818_01_mangos_mangos_string.sql \
378 8828_01_characters_instance_reset.sql \
379 8828_02_mangos_instance_template.sql \
380 8833_01_mangos_mangos_string.sql \
381 8833_02_mangos_command.sql \
382 8835_01_mangos_command.sql \
383 8840_01_mangos_spell_proc_event.sql \
384 8841_01_mangos_spell_proc_event.sql \
385 8841_02_mangos_spell_chain.sql \
386 8843_01_characters.sql \
387 8847_01_mangos_spell_proc_event.sql \
388 8847_02_mangos_spell_chain.sql \
389 8851_01_mangos_spell_proc_event.sql \
390 8856_01_mangos_spell_proc_event.sql \
391 8863_01_mangos_spell_proc_event.sql \
392 8873_01_mangos_spell_proc_event.sql \
393 8873_02_mangos_spell_learn_spell.sql \
394 8874_01_characters_character_skills.sql \
395 8882_01_mangos_spell_proc_event.sql \
396 8882_02_mangos_spell_chain.sql \
397 8882_03_mangos_spell_bonus_data.sql \
398 8883_01_mangos_spell_proc_event.sql \
399 8883_02_mangos_spell_bonus_data.sql \
400 8886_01_mangos_string.sql \
401 8889_01_mangos_spell_pet_auras.sql \
402 8891_01_mangos_spell_proc_event.sql \
403 8893_01_mangos_mangos_string.sql \
404 8899_01_mangos_spell_proc_event.sql \
405 8908_01_mangos_spell_chain.sql \
406 8909_01_mangos_spell_proc_event.sql \
407 8912_01_mangos_spell_proc_event.sql \
408 8917_01_mangos_spell_proc_event.sql \
409 8923_01_mangos_gossip.sql \
410 8929_01_mangos_gossip_scripts.sql \
411 8930_01_mangos_spell_proc_event.sql \
412 8931_01_mangos_spell_bonus_data.sql \
413 8932_01_mangos_spell_chain.sql \
414 8938_01_mangos_spell_proc_event.sql \
415 8943_01_mangos_spell_chain.sql \
416 8946_01_mangos_spell_proc_event.sql \
417 8950_01_mangos_spell_proc_event.sql \
418 8965_01_mangos_mangos_string.sql \
419 8965_02_mangos_command.sql \
420 8980_01_mangos_spell_bonus_data.sql \
421 8981_01_mangos_spell_proc_event.sql \
422 8988_01_mangos_spell_proc_event.sql \
423 8992_01_mangos_spell_proc_event.sql \
424 8992_02_mangos_spell_chain.sql \
425 8993_01_mangos_spell_proc_event.sql \
426 8995_01_mangos_spell_proc_event.sql \
427 8996_01_mangos_spell_proc_event.sql \
428 9001_01_mangos_spell_proc_event.sql \
429 9005_01_mangos_spell_proc_event.sql \
430 9007_01_mangos_spell_proc_event.sql \
431 9010_01_realmd_realmlist.sql \
432 9015_01_mangos_spell_bonus_data.sql \
433 9018_01_mangos_spell_bonus_data.sql \
434 9019_01_mangos_spell_threat.sql \
435 9025_01_mangos_spell_proc_event.sql \
436 9034_01_mangos_spell_proc_event.sql \
437 9045_01_mangos_spell_proc_event.sql \
438 9045_02_mangos_spell_chain.sql \
439 9064_01_mangos_spell_proc_event.sql \
440 9068_01_mangos_spell_proc_event.sql \
441 9068_02_mangos_spell_chain.sql \
442 9070_01_mangos_spell_proc_event.sql \
443 9074_01_mangos_command.sql \
444 9095_01_mangos_command.sql \
445 9121_01_mangos_npc_spellclick_spells.sql \
446 9125_01_mangos_npc_spellclick_spells.sql \
447 9133_01_mangos_spell_proc_event.sql \
448 9136_01_characters_account_data.sql \
449 9136_02_mangos_quest_poi.sql \
450 9136_03_characters_character_ticket.sql \
451 9136_04_mangos_spell_chain.sql \
452 9136_05_mangos_spell_bonus_data.sql \
453 9136_06_mangos_spell_proc_event.sql \
454 9136_07_characters_characters.sql \
455 9148_01_mangos_spell_bonus_data.sql \
456 9149_01_mangos_spell_bonus_data.sql \