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