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 \
270 3344_playercreateinfo_spell.sql \
272 3348_playercreateinfo_spell.sql \
274 3351_character_pet.sql \
275 3397_creature_template.sql \
277 3402_creature_onkill_reputation.sql \
282 3474_creature_addon.sql \
284 3503_creature_movement.sql \
285 3512_character_spell_cooldown.sql \
287 3516_spell_learn_spell.sql \
289 3538_guild_charter_sign.sql \
290 3539_item_template.sql \
291 3545_creature_movement.sql \
292 3547_character_reputation.sql \
293 3553_creature_onkill_reputation.sql \
294 3562_player_levelstats.sql \
295 3605_creature_addon.sql \
297 3611_spell_learn_skill.sql \
299 3627_quest_template.sql \
300 3631_gameobject_template.sql \
301 3636_character_spell.sql \
302 3636_playercreateinfo_spell.sql \
303 3646_spell_chain.sql \
305 3649_spell_chain.sql \
307 3655_quest_template.sql \
309 3660_character_kill.sql \
311 3728_spell_proc_event.sql \
313 3732_spell_affect.sql \
314 3739_looking_for_group.sql \
315 3746_spell_proc_event.sql \
318 3753_battleground_template.sql \
319 3763_spell_affect.sql \
320 3766_spell_proc_event.sql \
321 3771_creature_template.sql \
323 3774_playercreateinfo_spell.sql \
326 3787_spell_proc_event.sql \
327 3801_banAccount.sql \
329 3802_arena_teams.sql \
331 3805_spell_proc_event.sql \
333 3833_quest_template.sql \
336 3859_spell_affect.sql \
337 3860_creature_template.sql \
338 3862_prospecting_loot_template.sql \
339 3874_spell_scripts.sql \
340 3875_item_template.sql \
341 3876_character_ticket.sql \
342 3884_quest_scripts.sql \
343 3891_quest_scripts.sql \
344 3906_areatrigger_template.sql \
345 3929_spell_affect.sql \
346 3932_item_enchantment_template.sql \
347 3932_item_template.sql \
348 3939_realmd_account.sql \
349 3948_realmd_account.sql \
350 3951_exploration_basexp.sql \
353 4010_spell_proc_event.sql \
354 4012_spell_proc_event.sql \
355 4018_spell_proc_event.sql \
356 4019_spell_chain.sql \
357 4019_spell_proc_event.sql \
358 4020_spell_chain.sql \
359 4020_spell_proc_event.sql \
360 4021_spell_chain.sql \
361 4021_spell_proc_event.sql \
362 4023_spell_proc_event.sql \
363 4026_spell_proc_event.sql \
364 4028_spell_chain.sql \
365 4028_spell_proc_event.sql \
366 4031_spell_chain.sql \
367 4031_spell_proc_event.sql \
368 4035_spell_proc_event.sql \
369 4036_spell_proc_event.sql \
370 4037_spell_proc_event.sql \
372 4059_spell_learn_skill.sql \
373 4059_spell_learn_spell.sql \
374 4076_character_spell.sql \
375 4076_playercreateinfo_spell.sql \
378 4116_creature_template.sql \
380 4133_spell_chain.sql \
382 4139_spell_proc_event.sql \
384 4145_character_reputation.sql \
385 4154_spell_proc_event.sql \
390 4205_creature_template.sql \
391 4224_character_aura.sql \
393 4235_spell_proc_event.sql \
394 4239_spell_chain.sql \
395 4239_spell_proc_event.sql \
396 4242_spell_proc_event.sql \
397 4243_spell_affect.sql \
398 4248_spell_chain.sql \
399 4248_spell_proc_event.sql \
400 4252_spell_threat.sql \
401 4255_spell_chain.sql \
403 4259_spell_chain.sql \
404 4259_spell_proc_event.sql \
405 4262_spell_proc_event.sql \
406 4266_spell_proc_event.sql \
408 4270_spell_proc_event.sql \
409 4272_spell_proc_event.sql \
410 4274_character_pet.sql \
411 4275_game_event.sql \
412 4288_spell_proc_event.sql \
413 4294_spell_proc_event.sql \
414 4296_spell_proc_event.sql \
415 4317_spell_affect.sql \
416 4320_spell_affect.sql \
417 4331_spell_chain.sql \
418 4331_spell_proc_event.sql \
419 4341_game_event.sql \
421 4369_battleground_template.sql \
422 4376_battleground_template.sql \
423 4392_battleground_template.sql \
424 4395_spell_chain.sql \
426 4401_spell_chain.sql \
427 4403_reserved_name.sql \
429 4407_character_kill.sql \
431 4414_spell_chain.sql \
432 4414_spell_proc_event.sql \
433 4417_quest_template.sql \
434 4420_spell_proc_event.sql \
438 4426_creature_template.sql \
439 4430_spell_proc_event.sql \
440 4432_item_template.sql \
441 4434_spell_proc_event.sql \
442 4432_spell_chain.sql \
443 4432_spell_proc_event.sql \
446 ## Additional files to include when running 'make dist'
447 # SQL update files, to upgrade database schema from older revisions
449 1150_character_aura.sql \
451 1155_npc_option.sql \
452 1158_character_inventory.sql \
453 1186_game_weather.sql \
454 1208_npc_trainer.sql \
455 1250_item_template.sql \
456 1262_areatrigger_tavern.sql \
457 1262_game_graveyard.sql \
458 1282_playercreateinfo_item.sql \
459 1282_playercreateinfo.sql \
460 1292_loot_template.sql \
461 1332_character_queststatus.sql \
462 1336_item_template.sql \
463 1339_areatrigger_city.sql \
464 1349_areatrigger_involvedrelation.sql \
465 1349_character_aura.sql \
466 1349_character_inventory.sql \
467 1349_creature_template.sql \
468 1349_gameobject_template.sql \
469 1356_item_template.sql \
470 1411_item_template.sql \
471 1447_quest_template.sql \
472 1465_build_realmd_db.sql \
473 1465_create_realmd_db.sql \
474 1465_populate_realmd_db.sql \
475 1475_character_aura.sql \
476 1511_object_involvedrelation.sql \
477 1511_object_questrelation.sql \
478 1526_npc_vendor.sql \
479 1562_creature_template.sql \
481 1595_area_graveyard.sql \
482 1601_game_addons.sql \
483 1615_areatrigger_graveyard.sql \
485 1669_character_spell.sql \
486 1676_game_graveyard.sql \
488 1687_loot_template.sql \
489 1704_item_template.sql \
490 1799_quest_template.sql \
491 1825_game_corpse.sql \
495 1883_quest_template.sql \
496 1915_loot_template.sql \
499 1953_playercreateinfo_skill.sql \
500 1953_playercreateinfo_spell.sql \
502 2017_quest_template.sql \
504 2041_auctionhouse_bid.sql \
505 2041_game_spell.sql \
506 2041_game_talent.sql \
507 2047_quest_template.sql \
510 2066_creature_template.sql \
511 2069_quest_template.sql \
513 2099_npc_trainer.sql \
516 2118_playercreateinfo_spell.sql \
518 2130_quest_template.sql \
522 2191_npc_trainer.sql \
523 2191_playercreateinfo.sql \
525 2297_character_stable.sql \
526 2302_player_levelupgains.sql \
527 2308_character_pet.sql \
529 2343_areatrigger_template.sql \
530 2352_quest_template.sql \
531 2357_playercreateinfo_action.sql \
533 2360_creature_template.sql \
534 2362_areatrigger_template.sql \
536 2369_creature_template.sql \
537 2370_character_queststatus.sql \
538 2372_creature_template.sql \
540 2383_auctionhouse_item.sql \
541 2418_quest_template.sql \
542 2421_quest_template.sql \
543 2424_gameobject_template.sql \
547 2448_game_graveyard.sql \
549 2467_quest_template.sql \
551 2469_skinning_loot_template.sql \
552 2479_loot_template.sql \
554 2495_item_loot_template.sql \
556 2513_guild_rank.sql \
557 2516_auctionhouse.sql \
558 2517_guild_charters.sql \
560 2530_loot_template.sql \
562 2571_quest_template.sql \
563 2572_creature_template.sql \
569 2597_playercreateinfo_action.sql \
570 2597_playercreateinfo_item.sql \
571 2597_playercreateinfo_reputation.sql \
572 2597_playercreateinfo_skill.sql \
573 2597_playercreateinfo_spell.sql \
574 2598_playercreateinfo.sql \
575 2605_realmd_account.sql \
577 2617_character_spell_cooldown.sql \
579 2622_gameobject.sql \
580 2622_transports.sql \
582 2633_character_spell_cooldown.sql \
583 2637_auctionhouse.sql \
586 2642_loot_template.sql \
591 2674_quest_template.sql \
593 2680_game_addons.sql \
594 2684_gameobject.sql \
595 2684_quest_template.sql \
597 2688_playercreateinfo.sql \
598 2688_player_levelstats.sql \
599 2689_player_levelstats.sql \
600 2691_player_levelupgains.sql \
601 2699_character_inventory.sql \
603 2713_quest_template.sql \
608 2765_auctionHouse.sql \
611 2787_item_instance.sql \
615 2812_character_pet.sql \
616 2812_pet_name_generation.sql \
617 2815_character_pet.sql \
618 2821_raidgroups.sql \
620 2838_corpse_grid.sql \
621 2838_creature_grid.sql \
622 2838_gameobject_grid.sql \
623 2842_character_pet.sql \
624 2843_character_pet.sql \
627 2875_npc_trainer.sql \
628 2875_spell_chain.sql \
629 2881_spell_chain.sql \
631 2912_areatrigger_template.sql \
633 2938_spell_scripts.sql \
634 2940_playercreateinfo_skill.sql \
637 2958_spell_scripts.sql \
641 3010_item_template.sql \
642 3017_auctionhouse.sql \
645 3044_gameobject_template.sql \
647 3059_pet_levelstats.sql \
650 3075_gameobject.sql \
652 3090_creature_template.sql \
653 3090_loot_template.sql \
654 3091_spell_proc_event.sql \
655 3092_quest_template.sql \
656 3096_spell_proc_event.sql \
658 3107_playercreateinfo_skill.sql \
659 3108_quest_template.sql \
660 3110_quest_template.sql \
661 3115_quest_template.sql \
662 3138_character_inventory.sql \
663 3138_disenchaning_loot_template.sql \
664 3138_item_template.sql \
665 3141_spell_threat.sql \
668 3162_character_queststatus.sql \
670 3162_quest_template.sql \
672 3179_quest_template.sql \
673 3180_spell_proc_event.sql \
676 3202_character_gifts.sql \
677 3205_character_inventory.sql \
678 3231_quest_template.sql \
682 3246_character_reputation.sql \
686 3296_playercreateinfo_skill.sql \
687 3296_spell_learn_skill.sql \
688 3310_spell_learn_spell.sql \
689 3316_playercreateinfo_reputation.sql \
691 3344_playercreateinfo_spell.sql \
693 3348_playercreateinfo_spell.sql \
695 3351_character_pet.sql \
696 3397_creature_template.sql \
698 3402_creature_onkill_reputation.sql \
703 3474_creature_addon.sql \
705 3503_creature_movement.sql \
706 3512_character_spell_cooldown.sql \
708 3516_spell_learn_spell.sql \
710 3538_guild_charter_sign.sql \
711 3539_item_template.sql \
712 3545_creature_movement.sql \
713 3547_character_reputation.sql \
714 3553_creature_onkill_reputation.sql \
715 3562_player_levelstats.sql \
716 3605_creature_addon.sql \
718 3611_spell_learn_skill.sql \
720 3627_quest_template.sql \
721 3631_gameobject_template.sql \
722 3636_character_spell.sql \
723 3636_playercreateinfo_spell.sql \
724 3646_spell_chain.sql \
726 3649_spell_chain.sql \
728 3655_quest_template.sql \
730 3660_character_kill.sql \
732 3728_spell_proc_event.sql \
734 3732_spell_affect.sql \
735 3739_looking_for_group.sql \
736 3746_spell_proc_event.sql \
739 3753_battleground_template.sql \
740 3763_spell_affect.sql \
741 3766_spell_proc_event.sql \
742 3771_creature_template.sql \
744 3774_playercreateinfo_spell.sql \
747 3787_spell_proc_event.sql \
748 3801_banAccount.sql \
750 3802_arena_teams.sql \
752 3805_spell_proc_event.sql \
754 3833_quest_template.sql \
757 3859_spell_affect.sql \
758 3860_creature_template.sql \
759 3862_prospecting_loot_template.sql \
760 3874_spell_scripts.sql \
761 3875_item_template.sql \
762 3876_character_ticket.sql \
763 3884_quest_scripts.sql \
764 3891_quest_scripts.sql \
765 3906_areatrigger_template.sql \
766 3929_spell_affect.sql \
767 3932_item_enchantment_template.sql \
768 3932_item_template.sql \
769 3939_realmd_account.sql \
770 3948_realmd_account.sql \
771 3951_exploration_basexp.sql \
774 4010_spell_proc_event.sql \
775 4012_spell_proc_event.sql \
776 4018_spell_proc_event.sql \
777 4019_spell_chain.sql \
778 4019_spell_proc_event.sql \
779 4020_spell_chain.sql \
780 4020_spell_proc_event.sql \
781 4021_spell_chain.sql \
782 4021_spell_proc_event.sql \
783 4023_spell_proc_event.sql \
784 4026_spell_proc_event.sql \
785 4028_spell_chain.sql \
786 4028_spell_proc_event.sql \
787 4031_spell_chain.sql \
788 4031_spell_proc_event.sql \
789 4035_spell_proc_event.sql \
790 4036_spell_proc_event.sql \
791 4037_spell_proc_event.sql \
793 4059_spell_learn_skill.sql \
794 4059_spell_learn_spell.sql \
795 4076_character_spell.sql \
796 4076_playercreateinfo_spell.sql \
799 4116_creature_template.sql \
801 4133_spell_chain.sql \
803 4139_spell_proc_event.sql \
805 4145_character_reputation.sql \
806 4154_spell_proc_event.sql \
811 4205_creature_template.sql \
812 4224_character_aura.sql \
814 4235_spell_proc_event.sql \
815 4239_spell_chain.sql \
816 4239_spell_proc_event.sql \
817 4242_spell_proc_event.sql \
818 4243_spell_affect.sql \
819 4248_spell_chain.sql \
820 4248_spell_proc_event.sql \
821 4252_spell_threat.sql \
822 4255_spell_chain.sql \
824 4259_spell_chain.sql \
825 4259_spell_proc_event.sql \
826 4262_spell_proc_event.sql \
827 4266_spell_proc_event.sql \
829 4270_spell_proc_event.sql \
830 4272_spell_proc_event.sql \
831 4274_character_pet.sql \
832 4275_game_event.sql \
833 4288_spell_proc_event.sql \
834 4294_spell_proc_event.sql \
835 4296_spell_proc_event.sql \
836 4317_spell_affect.sql \
837 4320_spell_affect.sql \
838 4331_spell_chain.sql \
839 4331_spell_proc_event.sql \
840 4341_game_event.sql \
842 4369_battleground_template.sql \
843 4376_battleground_template.sql \
844 4392_battleground_template.sql \
845 4395_spell_chain.sql \
847 4401_spell_chain.sql \
848 4403_reserved_name.sql \
850 4407_character_kill.sql \
852 4414_spell_chain.sql \
853 4414_spell_proc_event.sql \
854 4417_quest_template.sql \
855 4420_spell_proc_event.sql \
859 4426_creature_template.sql \
860 4430_spell_proc_event.sql \
861 4432_item_template.sql \
862 4434_spell_proc_event.sql \
863 4432_spell_chain.sql \
864 4432_spell_proc_event.sql \