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 2008_12_22_01_mangos_creature_equip_template.sql \
29 2008_12_22_02_characters_character_pet.sql \
30 2008_12_22_03_mangos_item_template.sql \
31 2008_12_22_04_mangos_item_template.sql \
32 2008_12_22_05_characters_account_data.sql \
33 2008_12_22_06_characters_character_achievement.sql \
34 2008_12_22_07_mangos_quest_template.sql \
35 2008_12_22_08_mangos_milling_loot_template.sql \
36 2008_12_22_09_mangos_spell_affect.sql \
37 2008_12_22_10_mangos_string.sql \
38 2008_12_22_11_mangos_player_classlevelstats.sql \
39 2008_12_22_12_mangos_player_levelstats.sql \
40 2008_12_22_13_mangos_item_template.sql \
41 2008_12_22_14_mangos_playercreateinfo.sql \
42 2008_12_22_15_mangos_playercreateinfo_action.sql \
43 2008_12_22_16_mangos_playercreateinfo_spell.sql \
44 2008_12_22_17_mangos_item_template.sql \
45 2008_12_22_18_characters_characters.sql \
46 2008_12_22_19_characters_item_instance.sql \
47 6936_01_mangos_spell_chain.sql \
48 6939_01_mangos_quest_template.sql \
49 6940_01_mangos_spell_learn_spell.sql \
50 6941_01_mangos_spell_learn_spell.sql \
51 6944_01_mangos_mangos_string.sql \
52 6958_01_mangos_spell_proc_event.sql \
53 6960_01_mangos_command.sql \
54 6960_02_mangos_string.sql \
55 6961_01_mangos_command.sql \
56 6970_01_mangos_playercreateinfo.sql \
57 6976_01_realmd_realmd_db_version.sql \
58 6976_02_characters_character_db_version.sql \
59 7002_01_mangos_spell_chain.sql \
60 7015_01_mangos_item_template.sql \
61 7024_01_mangos_spell_chain.sql \
62 7026_01_mangos_battleground_template.sql \
63 7031_01_mangos_spell_proc_event.sql \
64 7033_01_mangos_spell_proc_event.sql \
65 7034_01_mangos_spell_proc_event.sql \
66 7040_01_mangos_achievement_reward.sql \
67 7044_01_mangos_spell_proc_event.sql \
68 7047_01_characters_character_spell.sql \
69 7047_02_mangos_playercreateinfo_action.sql \
70 7047_03_mangos_playercreateinfo_spell.sql \
71 7050_01_mangos_spell_proc_event.sql \
72 7051_01_mangos_spell_proc_event.sql \
73 7052_01_mangos_spell_proc_event.sql \
74 7053_01_mangos_spell_proc_event.sql \
75 7056_01_mangos_spell_proc_event.sql \
76 7059_01_characters_character_spell.sql \
77 7059_02_characters_pet_spell.sql \
78 7060_01_mangos_spell_proc_event.sql \
79 7061_01_mangos_spell_proc_event.sql \
80 7063_01_mangos_spell_proc_event.sql \
81 7067_01_mangos_playercreateinfo_spell.sql \
82 7067_02_mangos_spell_learn_spell.sql \
83 7067_03_characters_character_spell.sql \
84 7074_01_mangos_playercreateinfo_spell.sql \
85 7075_01_characters_character_spell.sql \
86 7075_02_mangos_spell_learn_spell.sql \
87 7077_01_characters_character_spell.sql \
88 7078_01_mangos_spell_proc_event.sql \
89 7092_01_mangos_player_xp_for_level.sql \
90 7097_01_mangos_spell_proc_event.sql \
91 7100_01_characters_character_spell.sql \
92 7107_01_mangos_string.sql \
93 7113_01_characters_character_achievement_progress.sql \
94 7118_01_mangos_skill_discovery_template.sql \
95 7133_01_mangos_skill_discovery_template.sql \
96 7133_02_mangos_spell_loot_template.sql \
97 7141_01_mangos_instance_template.sql \
98 7147_01_mangos_creature_template.sql \
99 7149_01_mangos_spell_proc_event.sql \
100 7150_01_mangos_playercreateinfo_spell.sql \
101 7156_01_mangos_spell_proc_event.sql \
102 7168_01_mangos_command.sql \
103 7175_01_mangos_spell_proc_event.sql \
104 7193_01_mangos_mangos_string.sql \
105 7196_01_mangos_spell_chain.sql \
106 7196_02_mangos_spell_bonus_data.sql \
107 7198_01_characters_characters.sql \
108 7199_01_mangos_spell_bonus_data.sql \
109 7199_02_mangos_spell_proc_event.sql \
110 7205_01_mangos_spell_chain.sql \
111 7207_01_mangos_creature.sql \
112 7207_02_mangos_gameobject.sql \
113 7207_03_characters_corpse.sql \
114 7209_01_mangos_spell_bonus_data.sql \
115 7214_01_mangos_command.sql \
116 7214_02_mangos_mangos_string.sql \
117 7230_01_mangos_spell_chain.sql \
118 7230_02_mangos_spell_bonus_data.sql \
119 7235_01_mangos_command.sql \
120 7242_01_mangos_spell_bonus_data.sql \
121 7249_01_mangos_spell_proc_event.sql \
122 7251_01_mangos_spell_chain.sql \
123 7251_02_characters_character_spell.sql \
124 7252_01_mangos_command.sql \
125 7252_02_mangos_mangos_string.sql \
126 7255_01_characters_characters.sql \
127 7267_01_characters_auctionhouse.sql \
128 7290_01_mangos_command.sql \
129 7292_01_mangos_points_of_interest.sql \
130 7292_02_mangos_locales_points_of_interest.sql \
131 7303_01_mangos_pools.sql \
132 7307_01_characters_arena_team_member.sql \
133 7312_01_mangos_mangos_string.sql \
134 7314_01_characters_guild_rank.sql \
135 7324_01_characters_character_spell.sql \
136 7324_02_characters_character_aura.sql \
137 7331_01_mangos_command.sql \
138 7332_01_mangos_command.sql \
139 7349_01_mangos_spell_area.sql \
140 7369_01_mangos_quest_template.sql \
141 7376_01_mangos_spell_area.sql \
142 7382_01_mangos_creature_template.sql \
143 7388_01_mangos_mangos_string.sql \
144 7390_01_mangos_areatrigger_teleport.sql \
145 7393_01_mangos_game_event.sql \
146 7399_01_mangos_mangos_string.sql \
147 7422_01_mangos_mangos_string.sql \
148 7439_01_mangos_mangos_string.sql \
149 7472_01_mangos_mangos_string.sql \
150 7493_01_mangos_command.sql \
151 7495_01_mangos_mangos_string.sql \
152 7503_01_mangos_command.sql \
153 7536_01_mangos_spell_chain.sql \
154 7544_01_mangos_uptime.sql \
155 7544_02_characters_uptime.sql \
156 7546_01_characters_uptime.sql \
157 7546_02_realmd_uptime.sql \
158 7558_01_mangos_mangos_string.sql \
159 7558_02_mangos_command.sql \
160 7560_01_mangos_gameobject_template.sql \
161 7565_01_mangos_mangos_string.sql \
162 7568_01_mangos_spell_proc_event.sql \
163 7615_01_mangos_command.sql \
164 7616_01_mangos_mangos_string.sql \
165 7616_02_mangos_command.sql \
166 7622_01_mangos_creature_ai_scripts.sql \
167 7622_02_mangos_creature_ai_summons.sql \
168 7622_03_mangos_creature_ai_texts.sql \
169 7627_01_mangos_achievement_criteria_data.sql \
170 7633_01_mangos_achievement_criteria_data.sql \
171 7643_01_mangos_db_version.sql \
172 7643_02_mangos_mangos_string.sql \
173 7644_01_characters_character_pet.sql \
174 7662_01_mangos_spell_chain.sql \
175 7662_02_mangos_spell_bonus_data.sql \
176 7705_01_mangos_command.sql \
177 7706_01_mangos_command.sql \
178 7714_01_mangos_command.sql \
179 7720_01_mangos_mangos_string.sql \
180 7776_01_mangos_npc_spellclick_spells.sql \
181 7777_01_mangos_spell_proc_event.sql \
182 7782_01_mangos_spell_proc_event.sql \
183 7796_01_mangos_command.sql \
184 7796_02_mangos_mangos_string.sql \
185 7802_01_characters_character_achievement.sql \
186 7802_02_characters_character_achievement_progress.sql \
187 7823_01_mangos_item_template.sql \
188 7830_01_mangos_spell_chain.sql \
189 7839_01_mangos_mangos_string.sql \
190 7839_02_mangos_command.sql \
191 7850_01_mangos_command.sql \
192 7855_01_mangos_pools.sql \
193 7867_01_realmd_account.sql \
194 7879_01_mangos_spell_proc_event.sql \
195 7884_01_mangos_playercreateinfo_spell.sql \
196 7884_02_mangos_playercreateinfo_action.sql \
197 7884_03_characters_character_spell.sql \
198 7884_04_characters_character_aura.sql \
199 7884_05_characters_character_action.sql \
200 7886_01_mangos_petcreateinfo_spell.sql \
201 7887_01_characters_character_pet.sql \
202 7893_01_mangos_command.sql \
203 7896_01_mangos_creature_template.sql \
204 7902_01_mangos_pool_creature.sql \
205 7902_02_mangos_pool_gameobject.sql \
206 7903_01_characters_character_pet.sql \
207 7904_01_mangos_creature_template.sql \
208 7908_01_mangos_creature_template.sql \
209 7908_02_mangos_creature_addon.sql \
210 7908_03_mangos_creature_template_addon.sql \
211 7932_01_characters_character_pet.sql \
212 7938_01_realmd_account.sql \
215 ## Additional files to include when running 'make dist'
216 # SQL update files, to upgrade database schema from older revisions
218 2008_12_22_01_mangos_creature_equip_template.sql \
219 2008_12_22_02_characters_character_pet.sql \
220 2008_12_22_03_mangos_item_template.sql \
221 2008_12_22_04_mangos_item_template.sql \
222 2008_12_22_05_characters_account_data.sql \
223 2008_12_22_06_characters_character_achievement.sql \
224 2008_12_22_07_mangos_quest_template.sql \
225 2008_12_22_08_mangos_milling_loot_template.sql \
226 2008_12_22_09_mangos_spell_affect.sql \
227 2008_12_22_10_mangos_string.sql \
228 2008_12_22_11_mangos_player_classlevelstats.sql \
229 2008_12_22_12_mangos_player_levelstats.sql \
230 2008_12_22_13_mangos_item_template.sql \
231 2008_12_22_14_mangos_playercreateinfo.sql \
232 2008_12_22_15_mangos_playercreateinfo_action.sql \
233 2008_12_22_16_mangos_playercreateinfo_spell.sql \
234 2008_12_22_17_mangos_item_template.sql \
235 2008_12_22_18_characters_characters.sql \
236 2008_12_22_19_characters_item_instance.sql \
237 6936_01_mangos_spell_chain.sql \
238 6939_01_mangos_quest_template.sql \
239 6940_01_mangos_spell_learn_spell.sql \
240 6941_01_mangos_spell_learn_spell.sql \
241 6944_01_mangos_mangos_string.sql \
242 6958_01_mangos_spell_proc_event.sql \
243 6960_01_mangos_command.sql \
244 6960_02_mangos_string.sql \
245 6961_01_mangos_command.sql \
246 6970_01_mangos_playercreateinfo.sql \
247 6976_01_realmd_realmd_db_version.sql \
248 6976_02_characters_character_db_version.sql \
249 7002_01_mangos_spell_chain.sql \
250 7015_01_mangos_item_template.sql \
251 7024_01_mangos_spell_chain.sql \
252 7026_01_mangos_battleground_template.sql \
253 7031_01_mangos_spell_proc_event.sql \
254 7033_01_mangos_spell_proc_event.sql \
255 7034_01_mangos_spell_proc_event.sql \
256 7040_01_mangos_achievement_reward.sql \
257 7044_01_mangos_spell_proc_event.sql \
258 7047_01_characters_character_spell.sql \
259 7047_02_mangos_playercreateinfo_action.sql \
260 7047_03_mangos_playercreateinfo_spell.sql \
261 7050_01_mangos_spell_proc_event.sql \
262 7051_01_mangos_spell_proc_event.sql \
263 7052_01_mangos_spell_proc_event.sql \
264 7053_01_mangos_spell_proc_event.sql \
265 7056_01_mangos_spell_proc_event.sql \
266 7059_01_characters_character_spell.sql \
267 7059_02_characters_pet_spell.sql \
268 7060_01_mangos_spell_proc_event.sql \
269 7061_01_mangos_spell_proc_event.sql \
270 7063_01_mangos_spell_proc_event.sql \
271 7067_01_mangos_playercreateinfo_spell.sql \
272 7067_02_mangos_spell_learn_spell.sql \
273 7067_03_characters_character_spell.sql \
274 7074_01_mangos_playercreateinfo_spell.sql \
275 7075_01_characters_character_spell.sql \
276 7075_02_mangos_spell_learn_spell.sql \
277 7077_01_characters_character_spell.sql \
278 7078_01_mangos_spell_proc_event.sql \
279 7092_01_mangos_player_xp_for_level.sql \
280 7097_01_mangos_spell_proc_event.sql \
281 7100_01_characters_character_spell.sql \
282 7107_01_mangos_string.sql \
283 7113_01_characters_character_achievement_progress.sql \
284 7118_01_mangos_skill_discovery_template.sql \
285 7133_01_mangos_skill_discovery_template.sql \
286 7133_02_mangos_spell_loot_template.sql \
287 7141_01_mangos_instance_template.sql \
288 7147_01_mangos_creature_template.sql \
289 7149_01_mangos_spell_proc_event.sql \
290 7150_01_mangos_playercreateinfo_spell.sql \
291 7156_01_mangos_spell_proc_event.sql \
292 7168_01_mangos_command.sql \
293 7175_01_mangos_spell_proc_event.sql \
294 7193_01_mangos_mangos_string.sql \
295 7196_01_mangos_spell_chain.sql \
296 7196_02_mangos_spell_bonus_data.sql \
297 7198_01_characters_characters.sql \
298 7199_01_mangos_spell_bonus_data.sql \
299 7199_02_mangos_spell_proc_event.sql \
300 7205_01_mangos_spell_chain.sql \
301 7207_01_mangos_creature.sql \
302 7207_02_mangos_gameobject.sql \
303 7207_03_characters_corpse.sql \
304 7209_01_mangos_spell_bonus_data.sql \
305 7214_01_mangos_command.sql \
306 7214_02_mangos_mangos_string.sql \
307 7230_01_mangos_spell_chain.sql \
308 7230_02_mangos_spell_bonus_data.sql \
309 7235_01_mangos_command.sql \
310 7242_01_mangos_spell_bonus_data.sql \
311 7249_01_mangos_spell_proc_event.sql \
312 7251_01_mangos_spell_chain.sql \
313 7251_02_characters_character_spell.sql \
314 7252_01_mangos_command.sql \
315 7252_02_mangos_mangos_string.sql \
316 7255_01_characters_characters.sql \
317 7267_01_characters_auctionhouse.sql \
318 7290_01_mangos_command.sql \
319 7292_01_mangos_points_of_interest.sql \
320 7292_02_mangos_locales_points_of_interest.sql \
321 7303_01_mangos_pools.sql \
322 7307_01_characters_arena_team_member.sql \
323 7312_01_mangos_mangos_string.sql \
324 7314_01_characters_guild_rank.sql \
325 7324_01_characters_character_spell.sql \
326 7324_02_characters_character_aura.sql \
327 7331_01_mangos_command.sql \
328 7332_01_mangos_command.sql \
329 7349_01_mangos_spell_area.sql \
330 7369_01_mangos_quest_template.sql \
331 7376_01_mangos_spell_area.sql \
332 7382_01_mangos_creature_template.sql \
333 7388_01_mangos_mangos_string.sql \
334 7390_01_mangos_areatrigger_teleport.sql \
335 7393_01_mangos_game_event.sql \
336 7399_01_mangos_mangos_string.sql \
337 7422_01_mangos_mangos_string.sql \
338 7439_01_mangos_mangos_string.sql \
339 7472_01_mangos_mangos_string.sql \
340 7493_01_mangos_command.sql \
341 7495_01_mangos_mangos_string.sql \
342 7503_01_mangos_command.sql \
343 7536_01_mangos_spell_chain.sql \
344 7544_01_mangos_uptime.sql \
345 7544_02_characters_uptime.sql \
346 7546_01_characters_uptime.sql \
347 7546_02_realmd_uptime.sql \
348 7558_01_mangos_mangos_string.sql \
349 7558_02_mangos_command.sql \
350 7560_01_mangos_gameobject_template.sql \
351 7565_01_mangos_mangos_string.sql \
352 7568_01_mangos_spell_proc_event.sql \
353 7615_01_mangos_command.sql \
354 7616_01_mangos_mangos_string.sql \
355 7616_02_mangos_command.sql \
356 7622_01_mangos_creature_ai_scripts.sql \
357 7622_02_mangos_creature_ai_summons.sql \
358 7622_03_mangos_creature_ai_texts.sql \
359 7627_01_mangos_achievement_criteria_data.sql \
360 7633_01_mangos_achievement_criteria_data.sql \
361 7643_01_mangos_db_version.sql \
362 7643_02_mangos_mangos_string.sql \
363 7644_01_characters_character_pet.sql \
364 7662_01_mangos_spell_chain.sql \
365 7662_02_mangos_spell_bonus_data.sql \
366 7705_01_mangos_command.sql \
367 7706_01_mangos_command.sql \
368 7714_01_mangos_command.sql \
369 7720_01_mangos_mangos_string.sql \
370 7776_01_mangos_npc_spellclick_spells.sql \
371 7777_01_mangos_spell_proc_event.sql \
372 7782_01_mangos_spell_proc_event.sql \
373 7796_01_mangos_command.sql \
374 7796_02_mangos_mangos_string.sql \
375 7802_01_characters_character_achievement.sql \
376 7802_02_characters_character_achievement_progress.sql \
377 7823_01_mangos_item_template.sql \
378 7830_01_mangos_spell_chain.sql \
379 7839_01_mangos_mangos_string.sql \
380 7839_02_mangos_command.sql \
381 7850_01_mangos_command.sql \
382 7855_01_mangos_pools.sql \
383 7867_01_realmd_account.sql \
384 7879_01_mangos_spell_proc_event.sql \
385 7884_01_mangos_playercreateinfo_spell.sql \
386 7884_02_mangos_playercreateinfo_action.sql \
387 7884_03_characters_character_spell.sql \
388 7884_04_characters_character_aura.sql \
389 7884_05_characters_character_action.sql \
390 7886_01_mangos_petcreateinfo_spell.sql \
391 7887_01_characters_character_pet.sql \
392 7893_01_mangos_command.sql \
393 7896_01_mangos_creature_template.sql \
394 7902_01_mangos_pool_creature.sql \
395 7902_02_mangos_pool_gameobject.sql \
396 7903_01_characters_character_pet.sql \
397 7904_01_mangos_creature_template.sql \
398 7908_01_mangos_creature_template.sql \
399 7908_02_mangos_creature_addon.sql \
400 7908_03_mangos_creature_template_addon.sql \
401 7932_01_characters_character_pet.sql \
402 7938_01_realmd_account.sql \