1 # Copyright (C) 2005-2009 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 \
229 ## Additional files to include when running 'make dist'
230 # SQL update files, to upgrade database schema from older revisions
232 7988_01_mangos_item_template.sql \
233 7988_02_characters_character_equipmentsets.sql \
234 7988_03_mangos_spell_chain.sql \
235 7988_04_mangos_creature_template.sql \
236 7988_05_mangos_item_template.sql \
237 7988_06_mangos_gameobject_template.sql \
238 7988_07_characters_characters.sql \
239 7988_08_mangos_spell_bonus_data.sql \
240 7988_09_mangos_spell_proc_event.sql \
241 8016_01_mangos_npc_spellclick_spells.sql \
242 8021_01_mangos_spell_proc_event.sql \
243 8030_01_characters_character_spell.sql \
244 8030_02_characters_character_action.sql \
245 8030_03_mangos_npc_trainer.sql \
246 8050_01_mangos_spell_proc_event.sql \
247 8050_02_mangos_spell_bonus_data.sql \
248 8053_01_mangos_command.sql \
249 8060_01_mangos_spell_pet_auras.sql \
250 8064_01_mangos_spell_chain.sql \
251 8065_01_mangos_spell_proc_event.sql \
252 8071_01_mangos_command.sql \
253 8072_01_characters_characters.sql \
254 8072_02_characters_characters.sql \
255 8098_01_characters_character_action.sql \
256 8098_02_mangos_playercreateinfo_action.sql \
257 8098_03_characters_character_pet.sql \
258 8098_04_characters_pet_spell.sql \
259 8104_01_characters.sql \
260 8112_01_mangos_spell_proc_event.sql \
261 8115_01_mangos_playercreateinfo_action.sql \
262 8140_01_mangos_spell_proc_event.sql \
263 8158_01_mangos_playercreateinfo_action.sql \
264 8190_01_mangos_creature_template.sql \
265 8191_01_mangos_spell_affect.sql \
266 8211_01_mangos_spell_proc_event.sql \
267 8212_01_mangos_spell_proc_event.sql \
268 8213_01_mangos_spell_bonus_data.sql \
269 8227_01_mangos_spell_proc_event.sql \
270 8237_01_mangos_creature_template.sql \
271 8247_01_mangos_spell_bonus_data.sql \
272 8249_01_mangos_spell_proc_item_enchant.sql \
273 8249_02_mangos_spell_chain.sql \
274 8250_01_mangos_spell_threat.sql \
275 8251_01_mangos_spell_chain.sql \
276 8251_02_mangos_spell_bonus_data.sql \
277 8251_03_mangos_spell_proc_event.sql \
278 8253_01_mangos_spell_chain.sql \
279 8253_02_mangos_spell_proc_event.sql \
280 8254_01_mangos_spell_proc_event.sql \
281 8294_01_mangos_playercreateinfo_action.sql \
282 8310_01_mangos_spell_proc_event.sql \
283 8332_01_realmd_realmcharacters.sql \
284 8339_01_characters_characters.sql \
285 8339_02_characters_character_battleground_data.sql \
286 8342_01_mangos_spell_proc_event.sql \
287 8361_01_mangos_spell_bonus_data.sql \
288 8364_01_mangos_db_version.sql \
289 8377_01_mangos_spell_area.sql \
290 8392_01_mangos_spell_proc_event.sql \
291 8392_02_mangos_spell_chain.sql \
292 8394_01_mangos_spell_proc_event.sql \
293 8397_01_mangos_spell_chain.sql \
294 8397_02_mangos_spell_threat.sql \
295 8397_03_characters_character_spell.sql \
296 8399_01_mangos_spell_elixir.sql \
297 8402_01_characters_guild_eventlog.sql \
298 8402_02_characters_guild_bank_eventlog.sql \
299 8409_01_characters_guild.sql \
300 8412_01_mangos_mangos_string.sql \
301 8416_01_mangos_spell_learn_spell.sql \
302 8433_01_characters_character_account_data.sql \
303 8444_01_mangos_mangos_string.sql \
304 8451_01_mangos_spell_proc_event.sql \
305 8462_01_mangos_creature_ai_texts.sql \
306 8469_01_characters_character_spell.sql \
307 8482_01_mangos_spell_elixir.sql \
308 8487_01_mangos_spell_bonus_data.sql \
309 8487_02_mangos_spell_proc_event.sql \
310 8488_01_mangos_spell_chain.sql \
311 8488_02_mangos_spell_bonus_data.sql \
312 8498_01_mangos_spell_proc_event.sql \
313 8499_01_mangos_spell_elixir.sql \
314 8504_01_mangos_playercreateinfo_spell.sql \
315 8504_02_mangos_playercreateinfo_action.sql \
316 8505_01_characters_character_spell.sql \
317 8511_01_mangos_spell_proc_event.sql \
318 8514_01_mangos_spell_bonus_data.sql \
319 8521_01_mangos_spell_proc_event.sql \
320 8548_01_mangos_creature_battleground.sql \
321 8548_02_mangos_gameobject_battleground.sql \
322 8549_03_mangos_battleground_events.sql \
323 8573_01_mangos_mangos_string.sql \
324 8589_01_mangos_creature_template.sql \
325 8589_02_mangos_gameobject_template.sql \
326 8589_03_mangos_item_template.sql \
327 8589_04_characters_groups.sql \
328 8589_05_mangos_battleground_template.sql \
329 8589_06_characters_bugreport.sql \
330 8589_07_mangos_spell_elixir.sql \
331 8589_08_mangos_item_template.sql \
332 8589_09_mangos_spell_chain.sql \
333 8589_10_mangos_spell_proc_event.sql \
334 8589_11_characters_characters.sql \
335 8596_01_characters_bugreport.sql \
336 8600_01_mangos_command.sql \
337 8607_01_mangos_string.sql \
338 8607_02_mangos_command.sql \
339 8608_01_mangos_mangos_string.sql \
340 8608_02_mangos_battleground_events.sql \
341 8618_01_mangos_spell_proc_event.sql \
342 8676_01_mangos_creature_template.sql \
343 8688_01_mangos_creature_template.sql \
344 8693_01_mangos_spell_proc_event.sql \
345 8702_01_characters_character_reputation.sql \
346 8720_01_mangos_quest_template.sql \
347 8721_01_characters_guild.sql \
348 8723_01_mangos_achievement_criteria_requirement.sql \
349 8726_01_mangos_spell_proc_event.sql \
350 8728_01_realmd_account.sql \
351 8731_01_mangos_creature_template.sql \
352 8749_01_mangos_mail_loot_template.sql \
353 8769_01_mangos_mail_level_reward.sql \
354 8770_01_mangos_quest_template.sql \
355 8775_01_mangos_creature_template.sql \
356 8775_02_mangos_creature.sql \
357 8775_03_mangos_gameobject.sql \
358 8777_01_mangos_creature.sql \
359 8777_02_mangos_gameobject.sql \
360 8800_01_mangos_spell_elixir.sql \
361 8803_01_mangos_playercreateinfo_spell.sql \
362 8803_02_mangos_playercreateinfo_action.sql \
363 8815_01_mangos_mangos_string.sql \
364 8818_01_mangos_mangos_string.sql \
365 8828_01_characters_instance_reset.sql \
366 8828_02_mangos_instance_template.sql \
367 8833_01_mangos_mangos_string.sql \
368 8833_02_mangos_command.sql \
369 8835_01_mangos_command.sql \
370 8840_01_mangos_spell_proc_event.sql \
371 8841_01_mangos_spell_proc_event.sql \
372 8841_02_mangos_spell_chain.sql \
373 8843_01_characters.sql \
374 8847_01_mangos_spell_proc_event.sql \
375 8847_02_mangos_spell_chain.sql \
376 8851_01_mangos_spell_proc_event.sql \
377 8856_01_mangos_spell_proc_event.sql \
378 8863_01_mangos_spell_proc_event.sql \
379 8873_01_mangos_spell_proc_event.sql \
380 8873_02_mangos_spell_learn_spell.sql \
381 8874_01_characters_character_skills.sql \
382 8882_01_mangos_spell_proc_event.sql \
383 8882_02_mangos_spell_chain.sql \
384 8882_03_mangos_spell_bonus_data.sql \
385 8883_01_mangos_spell_proc_event.sql \
386 8883_02_mangos_spell_bonus_data.sql \
387 8886_01_mangos_string.sql \
388 8889_01_mangos_spell_pet_auras.sql \
389 8891_01_mangos_spell_proc_event.sql \
390 8893_01_mangos_mangos_string.sql \
391 8899_01_mangos_spell_proc_event.sql \
392 8908_01_mangos_spell_chain.sql \
393 8909_01_mangos_spell_proc_event.sql \
394 8912_01_mangos_spell_proc_event.sql \
395 8917_01_mangos_spell_proc_event.sql \
396 8923_01_mangos_gossip.sql \
397 8929_01_mangos_gossip_scripts.sql \
398 8930_01_mangos_spell_proc_event.sql \
399 8931_01_mangos_spell_bonus_data.sql \
400 8932_01_mangos_spell_chain.sql \
401 8938_01_mangos_spell_proc_event.sql \
402 8943_01_mangos_spell_chain.sql \
403 8946_01_mangos_spell_proc_event.sql \
404 8950_01_mangos_spell_proc_event.sql \
405 8965_01_mangos_mangos_string.sql \
406 8965_02_mangos_command.sql \
407 8980_01_mangos_spell_bonus_data.sql \
408 8981_01_mangos_spell_proc_event.sql \
409 8988_01_mangos_spell_proc_event.sql \
410 8992_01_mangos_spell_proc_event.sql \
411 8992_02_mangos_spell_chain.sql \
412 8993_01_mangos_spell_proc_event.sql \
413 8995_01_mangos_spell_proc_event.sql \
414 8996_01_mangos_spell_proc_event.sql \
415 9001_01_mangos_spell_proc_event.sql \
416 9005_01_mangos_spell_proc_event.sql \
417 9007_01_mangos_spell_proc_event.sql \
418 9010_01_realmd_realmlist.sql \
419 9015_01_mangos_spell_bonus_data.sql \
420 9018_01_mangos_spell_bonus_data.sql \
421 9019_01_mangos_spell_threat.sql \
422 9025_01_mangos_spell_proc_event.sql \
423 9034_01_mangos_spell_proc_event.sql \
424 9045_01_mangos_spell_proc_event.sql \
425 9045_02_mangos_spell_chain.sql \
426 9064_01_mangos_spell_proc_event.sql \
427 9068_01_mangos_spell_proc_event.sql \
428 9068_02_mangos_spell_chain.sql \
429 9070_01_mangos_spell_proc_event.sql \
430 9074_01_mangos_command.sql \