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 \
179 ## Additional files to include when running 'make dist'
180 # SQL update files, to upgrade database schema from older revisions
182 7988_01_mangos_item_template.sql \
183 7988_02_characters_character_equipmentsets.sql \
184 7988_03_mangos_spell_chain.sql \
185 7988_04_mangos_creature_template.sql \
186 7988_05_mangos_item_template.sql \
187 7988_06_mangos_gameobject_template.sql \
188 7988_07_characters_characters.sql \
189 7988_08_mangos_spell_bonus_data.sql \
190 7988_09_mangos_spell_proc_event.sql \
191 8016_01_mangos_npc_spellclick_spells.sql \
192 8021_01_mangos_spell_proc_event.sql \
193 8030_01_characters_character_spell.sql \
194 8030_02_characters_character_action.sql \
195 8030_03_mangos_npc_trainer.sql \
196 8050_01_mangos_spell_proc_event.sql \
197 8050_02_mangos_spell_bonus_data.sql \
198 8053_01_mangos_command.sql \
199 8060_01_mangos_spell_pet_auras.sql \
200 8064_01_mangos_spell_chain.sql \
201 8065_01_mangos_spell_proc_event.sql \
202 8071_01_mangos_command.sql \
203 8072_01_characters_characters.sql \
204 8072_02_characters_characters.sql \
205 8098_01_characters_character_action.sql \
206 8098_02_mangos_playercreateinfo_action.sql \
207 8098_03_characters_character_pet.sql \
208 8098_04_characters_pet_spell.sql \
209 8104_01_characters.sql \
210 8112_01_mangos_spell_proc_event.sql \
211 8115_01_mangos_playercreateinfo_action.sql \
212 8140_01_mangos_spell_proc_event.sql \
213 8158_01_mangos_playercreateinfo_action.sql \
214 8190_01_mangos_creature_template.sql \
215 8191_01_mangos_spell_affect.sql \
216 8211_01_mangos_spell_proc_event.sql \
217 8212_01_mangos_spell_proc_event.sql \
218 8213_01_mangos_spell_bonus_data.sql \
219 8227_01_mangos_spell_proc_event.sql \
220 8237_01_mangos_creature_template.sql \
221 8247_01_mangos_spell_bonus_data.sql \
222 8249_01_mangos_spell_proc_item_enchant.sql \
223 8249_02_mangos_spell_chain.sql \
224 8250_01_mangos_spell_threat.sql \
225 8251_01_mangos_spell_chain.sql \
226 8251_02_mangos_spell_bonus_data.sql \
227 8251_03_mangos_spell_proc_event.sql \
228 8253_01_mangos_spell_chain.sql \
229 8253_02_mangos_spell_proc_event.sql \
230 8254_01_mangos_spell_proc_event.sql \
231 8294_01_mangos_playercreateinfo_action.sql \
232 8310_01_mangos_spell_proc_event.sql \
233 8332_01_realmd_realmcharacters.sql \
234 8339_01_characters_characters.sql \
235 8339_02_characters_character_battleground_data.sql \
236 8342_01_mangos_spell_proc_event.sql \
237 8361_01_mangos_spell_bonus_data.sql \
238 8364_01_mangos_db_version.sql \
239 8377_01_mangos_spell_area.sql \
240 8392_01_mangos_spell_proc_event.sql \
241 8392_02_mangos_spell_chain.sql \
242 8394_01_mangos_spell_proc_event.sql \
243 8397_01_mangos_spell_chain.sql \
244 8397_02_mangos_spell_threat.sql \
245 8397_03_characters_character_spell.sql \
246 8399_01_mangos_spell_elixir.sql \
247 8402_01_characters_guild_eventlog.sql \
248 8402_02_characters_guild_bank_eventlog.sql \
249 8409_01_characters_guild.sql \
250 8412_01_mangos_mangos_string.sql \
251 8416_01_mangos_spell_learn_spell.sql \
252 8433_01_characters_character_account_data.sql \
253 8444_01_mangos_mangos_string.sql \
254 8451_01_mangos_spell_proc_event.sql \
255 8462_01_mangos_creature_ai_texts.sql \
256 8469_01_characters_character_spell.sql \
257 8482_01_mangos_spell_elixir.sql \
258 8487_01_mangos_spell_bonus_data.sql \
259 8487_02_mangos_spell_proc_event.sql \
260 8488_01_mangos_spell_chain.sql \
261 8488_02_mangos_spell_bonus_data.sql \
262 8498_01_mangos_spell_proc_event.sql \
263 8499_01_mangos_spell_elixir.sql \
264 8504_01_mangos_playercreateinfo_spell.sql \
265 8504_02_mangos_playercreateinfo_action.sql \
266 8505_01_characters_character_spell.sql \
267 8511_01_mangos_spell_proc_event.sql \
268 8514_01_mangos_spell_bonus_data.sql \
269 8521_01_mangos_spell_proc_event.sql \
270 8548_01_mangos_creature_battleground.sql \
271 8548_02_mangos_gameobject_battleground.sql \
272 8549_03_mangos_battleground_events.sql \
273 8573_01_mangos_mangos_string.sql \
274 8589_01_mangos_creature_template.sql \
275 8589_02_mangos_gameobject_template.sql \
276 8589_03_mangos_item_template.sql \
277 8589_04_characters_groups.sql \
278 8589_05_mangos_battleground_template.sql \
279 8589_06_characters_bugreport.sql \
280 8589_07_mangos_spell_elixir.sql \
281 8589_08_mangos_item_template.sql \
282 8589_09_mangos_spell_chain.sql \
283 8589_10_mangos_spell_proc_event.sql \
284 8589_11_characters_characters.sql \
285 8596_01_characters_bugreport.sql \
286 8600_01_mangos_command.sql \
287 8607_01_mangos_string.sql \
288 8607_02_mangos_command.sql \
289 8608_01_mangos_mangos_string.sql \
290 8608_02_mangos_battleground_events.sql \
291 8618_01_mangos_spell_proc_event.sql \
292 8676_01_mangos_creature_template.sql \
293 8688_01_mangos_creature_template.sql \
294 8693_01_mangos_spell_proc_event.sql \
295 8702_01_characters_character_reputation.sql \
296 8720_01_mangos_quest_template.sql \
297 8721_01_characters_guild.sql \
298 8723_01_mangos_achievement_criteria_requirement.sql \
299 8726_01_mangos_spell_proc_event.sql \
300 8728_01_realmd_account.sql \
301 8731_01_mangos_creature_template.sql \
302 8749_01_mangos_mail_loot_template.sql \
303 8769_01_mangos_mail_level_reward.sql \
304 8770_01_mangos_quest_template.sql \
305 8775_01_mangos_creature_template.sql \
306 8775_02_mangos_creature.sql \
307 8775_03_mangos_gameobject.sql \
308 8777_01_mangos_creature.sql \
309 8777_02_mangos_gameobject.sql \
310 8800_01_mangos_spell_elixir.sql \
311 8803_01_mangos_playercreateinfo_spell.sql \
312 8803_02_mangos_playercreateinfo_action.sql \
313 8815_01_mangos_mangos_string.sql \
314 8818_01_mangos_mangos_string.sql \
315 8828_01_characters_instance_reset.sql \
316 8828_02_mangos_instance_template.sql \
317 8833_01_mangos_mangos_string.sql \
318 8833_02_mangos_command.sql \
319 8835_01_mangos_command.sql \
320 8840_01_mangos_spell_proc_event.sql \
321 8841_01_mangos_spell_proc_event.sql \
322 8841_02_mangos_spell_chain.sql \
323 8843_01_characters.sql \
324 8847_01_mangos_spell_proc_event.sql \
325 8847_02_mangos_spell_chain.sql \
326 8851_01_mangos_spell_proc_event.sql \
327 8856_01_mangos_spell_proc_event.sql \
328 8863_01_mangos_spell_proc_event.sql \
329 8873_01_mangos_spell_proc_event.sql \
330 8873_02_mangos_spell_learn_spell.sql \