1 # Copyright (C) 2005,2006,2007 MaNGOS <http://www.mangosproject.org/>
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 1150_character_aura.sql \
31 1158_character_inventory.sql \
32 1186_game_weather.sql \
33 1208_npc_trainer.sql \
34 1250_item_template.sql \
35 1262_areatrigger_tavern.sql \
36 1262_game_graveyard.sql \
37 1282_playercreateinfo_item.sql \
38 1282_playercreateinfo.sql \
39 1292_loot_template.sql \
40 1332_character_queststatus.sql \
41 1336_item_template.sql \
42 1339_areatrigger_city.sql \
43 1349_areatrigger_involvedrelation.sql \
44 1349_character_aura.sql \
45 1349_character_inventory.sql \
46 1349_creature_template.sql \
47 1349_gameobject_template.sql \
48 1356_item_template.sql \
49 1411_item_template.sql \
50 1447_quest_template.sql \
51 1465_build_realmd_db.sql \
52 1465_create_realmd_db.sql \
53 1465_populate_realmd_db.sql \
54 1475_character_aura.sql \
55 1511_object_involvedrelation.sql \
56 1511_object_questrelation.sql \
58 1562_creature_template.sql \
60 1595_area_graveyard.sql \
61 1601_game_addons.sql \
62 1615_areatrigger_graveyard.sql \
64 1669_character_spell.sql \
65 1676_game_graveyard.sql \
67 1687_loot_template.sql \
68 1704_item_template.sql \
69 1799_quest_template.sql \
70 1825_game_corpse.sql \
74 1883_quest_template.sql \
75 1915_loot_template.sql \
78 1953_playercreateinfo_skill.sql \
79 1953_playercreateinfo_spell.sql \
81 2017_quest_template.sql \
83 2041_auctionhouse_bid.sql \
85 2041_game_talent.sql \
86 2047_quest_template.sql \
89 2066_creature_template.sql \
90 2069_quest_template.sql \
92 2099_npc_trainer.sql \
95 2118_playercreateinfo_spell.sql \
97 2130_quest_template.sql \
101 2191_npc_trainer.sql \
102 2191_playercreateinfo.sql \
104 2297_character_stable.sql \
105 2302_player_levelupgains.sql \
106 2308_character_pet.sql \
108 2343_areatrigger_template.sql \
109 2352_quest_template.sql \
110 2357_playercreateinfo_action.sql \
112 2360_creature_template.sql \
113 2362_areatrigger_template.sql \
115 2369_creature_template.sql \
116 2370_character_queststatus.sql \
117 2372_creature_template.sql \
119 2383_auctionhouse_item.sql \
120 2418_quest_template.sql \
121 2421_quest_template.sql \
122 2424_gameobject_template.sql \
126 2448_game_graveyard.sql \
128 2467_quest_template.sql \
130 2469_skinning_loot_template.sql \
131 2479_loot_template.sql \
133 2495_item_loot_template.sql \
135 2513_guild_rank.sql \
136 2516_auctionhouse.sql \
137 2517_guild_charters.sql \
139 2530_loot_template.sql \
141 2571_quest_template.sql \
142 2572_creature_template.sql \
148 2597_playercreateinfo_action.sql \
149 2597_playercreateinfo_item.sql \
150 2597_playercreateinfo_reputation.sql \
151 2597_playercreateinfo_skill.sql \
152 2597_playercreateinfo_spell.sql \
153 2598_playercreateinfo.sql \
154 2605_realmd_account.sql \
156 2617_character_spell_cooldown.sql \
158 2622_gameobject.sql \
159 2622_transports.sql \
161 2633_character_spell_cooldown.sql \
162 2637_auctionhouse.sql \
165 2642_loot_template.sql \
170 2674_quest_template.sql \
172 2680_game_addons.sql \
173 2684_gameobject.sql \
174 2684_quest_template.sql \
176 2688_playercreateinfo.sql \
177 2688_player_levelstats.sql \
178 2689_player_levelstats.sql \
179 2691_player_levelupgains.sql \
180 2699_character_inventory.sql \
182 2713_quest_template.sql \
187 2765_auctionHouse.sql \
190 2787_item_instance.sql \
194 2812_character_pet.sql \
195 2812_pet_name_generation.sql \
196 2815_character_pet.sql \
197 2821_raidgroups.sql \
199 2838_corpse_grid.sql \
200 2838_creature_grid.sql \
201 2838_gameobject_grid.sql \
202 2842_character_pet.sql \
203 2843_character_pet.sql \
206 2875_npc_trainer.sql \
207 2875_spell_chain.sql \
208 2881_spell_chain.sql \
210 2912_areatrigger_template.sql \
212 2938_spell_scripts.sql \
213 2940_playercreateinfo_skill.sql \
216 2958_spell_scripts.sql \
220 3010_item_template.sql \
221 3017_auctionhouse.sql \
224 3044_gameobject_template.sql \
226 3059_pet_levelstats.sql \
229 3075_gameobject.sql \
231 3090_creature_template.sql \
232 3090_loot_template.sql \
233 3091_spell_proc_event.sql \
234 3092_quest_template.sql \
235 3096_spell_proc_event.sql \
237 3107_playercreateinfo_skill.sql \
238 3108_quest_template.sql \
239 3110_quest_template.sql \
240 3115_quest_template.sql \
241 3138_character_inventory.sql \
242 3138_disenchaning_loot_template.sql \
243 3138_item_template.sql \
244 3141_spell_threat.sql \
247 3162_character_queststatus.sql \
249 3162_quest_template.sql \
251 3179_quest_template.sql \
252 3180_spell_proc_event.sql \
255 3202_character_gifts.sql \
256 3205_character_inventory.sql \
257 3231_quest_template.sql \
261 3246_character_reputation.sql \
265 3296_playercreateinfo_skill.sql \
266 3296_spell_learn_skill.sql \
267 3310_spell_learn_spell.sql \
268 3316_playercreateinfo_reputation.sql \
272 ## Additional files to include when running 'make dist'
273 # SQL update files, to upgrade database schema from older revisions
275 1150_character_aura.sql \
277 1155_npc_option.sql \
278 1158_character_inventory.sql \
279 1186_game_weather.sql \
280 1208_npc_trainer.sql \
281 1250_item_template.sql \
282 1262_areatrigger_tavern.sql \
283 1262_game_graveyard.sql \
284 1282_playercreateinfo_item.sql \
285 1282_playercreateinfo.sql \
286 1292_loot_template.sql \
287 1332_character_queststatus.sql \
288 1336_item_template.sql \
289 1339_areatrigger_city.sql \
290 1349_areatrigger_involvedrelation.sql \
291 1349_character_aura.sql \
292 1349_character_inventory.sql \
293 1349_creature_template.sql \
294 1349_gameobject_template.sql \
295 1356_item_template.sql \
296 1411_item_template.sql \
297 1447_quest_template.sql \
298 1465_build_realmd_db.sql \
299 1465_create_realmd_db.sql \
300 1465_populate_realmd_db.sql \
301 1475_character_aura.sql \
302 1511_object_involvedrelation.sql \
303 1511_object_questrelation.sql \
304 1526_npc_vendor.sql \
305 1562_creature_template.sql \
307 1595_area_graveyard.sql \
308 1601_game_addons.sql \
309 1615_areatrigger_graveyard.sql \
311 1669_character_spell.sql \
312 1676_game_graveyard.sql \
314 1687_loot_template.sql \
315 1704_item_template.sql \
316 1799_quest_template.sql \
317 1825_game_corpse.sql \
321 1883_quest_template.sql \
322 1915_loot_template.sql \
325 1953_playercreateinfo_skill.sql \
326 1953_playercreateinfo_spell.sql \
328 2017_quest_template.sql \
330 2041_auctionhouse_bid.sql \
331 2041_game_spell.sql \
332 2041_game_talent.sql \
333 2047_quest_template.sql \
336 2066_creature_template.sql \
337 2069_quest_template.sql \
339 2099_npc_trainer.sql \
342 2118_playercreateinfo_spell.sql \
344 2130_quest_template.sql \
348 2191_npc_trainer.sql \
349 2191_playercreateinfo.sql \
351 2297_character_stable.sql \
352 2302_player_levelupgains.sql \
353 2308_character_pet.sql \
355 2343_areatrigger_template.sql \
356 2352_quest_template.sql \
357 2357_playercreateinfo_action.sql \
359 2360_creature_template.sql \
360 2362_areatrigger_template.sql \
362 2369_creature_template.sql \
363 2370_character_queststatus.sql \
364 2372_creature_template.sql \
366 2383_auctionhouse_item.sql \
367 2418_quest_template.sql \
368 2421_quest_template.sql \
369 2424_gameobject_template.sql \
373 2448_game_graveyard.sql \
375 2467_quest_template.sql \
377 2469_skinning_loot_template.sql \
378 2479_loot_template.sql \
380 2495_item_loot_template.sql \
382 2513_guild_rank.sql \
383 2516_auctionhouse.sql \
384 2517_guild_charters.sql \
386 2530_loot_template.sql \
388 2571_quest_template.sql \
389 2572_creature_template.sql \
395 2597_playercreateinfo_action.sql \
396 2597_playercreateinfo_item.sql \
397 2597_playercreateinfo_reputation.sql \
398 2597_playercreateinfo_skill.sql \
399 2597_playercreateinfo_spell.sql \
400 2598_playercreateinfo.sql \
401 2605_realmd_account.sql \
403 2617_character_spell_cooldown.sql \
405 2622_gameobject.sql \
406 2622_transports.sql \
408 2633_character_spell_cooldown.sql \
409 2637_auctionhouse.sql \
412 2642_loot_template.sql \
417 2674_quest_template.sql \
419 2680_game_addons.sql \
420 2684_gameobject.sql \
421 2684_quest_template.sql \
423 2688_playercreateinfo.sql \
424 2688_player_levelstats.sql \
425 2689_player_levelstats.sql \
426 2691_player_levelupgains.sql \
427 2699_character_inventory.sql \
429 2713_quest_template.sql \
434 2765_auctionHouse.sql \
437 2787_item_instance.sql \
441 2812_character_pet.sql \
442 2812_pet_name_generation.sql \
443 2815_character_pet.sql \
444 2821_raidgroups.sql \
446 2838_corpse_grid.sql \
447 2838_creature_grid.sql \
448 2838_gameobject_grid.sql \
449 2842_character_pet.sql \
450 2843_character_pet.sql \
453 2875_npc_trainer.sql \
454 2875_spell_chain.sql \
455 2881_spell_chain.sql \
457 2912_areatrigger_template.sql \
459 2938_spell_scripts.sql \
460 2940_playercreateinfo_skill.sql \
463 2958_spell_scripts.sql \
467 3010_item_template.sql \
468 3017_auctionhouse.sql \
471 3044_gameobject_template.sql \
473 3059_pet_levelstats.sql \
476 3075_gameobject.sql \
478 3090_creature_template.sql \
479 3090_loot_template.sql \
480 3091_spell_proc_event.sql \
481 3092_quest_template.sql \
482 3096_spell_proc_event.sql \
484 3107_playercreateinfo_skill.sql \
485 3108_quest_template.sql \
486 3110_quest_template.sql \
487 3115_quest_template.sql \
488 3138_character_inventory.sql \
489 3138_disenchaning_loot_template.sql \
490 3138_item_template.sql \
491 3141_spell_threat.sql \
494 3162_character_queststatus.sql \
496 3162_quest_template.sql \
498 3179_quest_template.sql \
499 3180_spell_proc_event.sql \
502 3202_character_gifts.sql \
503 3205_character_inventory.sql \
504 3231_quest_template.sql \
508 3246_character_reputation.sql \
512 3296_playercreateinfo_skill.sql \
513 3296_spell_learn_skill.sql \
514 3310_spell_learn_spell.sql \
515 3316_playercreateinfo_reputation.sql \