sql/updates/Makefile.am

   1 # Copyright (C) 2005-2009 MaNGOS <http://getmangos.com/>
   2 #
   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.
   7 #
   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.
  12 #
  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
  16
  17 ## Process this file with automake to produce Makefile.in
  18
  19 ## Sub-directories to parse
  20
  21 ## Change installation location
  22 #  datadir = mangos/sql/updates
  23 pkgdatadir = $(datadir)/mangos/sql/updates
  24
  25 ## Files to be installed
  26 #  Install basic SQL files to datadir
  27 pkgdata_DATA = \
  28         2008_10_18_01_characters_characters.sql \
  29         2008_10_18_02_mangos_spell_proc_event.sql \
  30         2008_10_19_01_mangos_spell_affect.sql \
  31         2008_10_19_02_mangos_spell_proc_event.sql \
  32         2008_10_21_01_mangos_mangos_string.sql \
  33         2008_10_21_02_mangos_command.sql \
  34         2008_10_21_03_mangos_command.sql \
  35         2008_10_22_01_mangos_quest_template.sql \
  36         2008_10_22_02_mangos_mangos_string.sql \
  37         2008_10_23_01_mangos_command.sql \
  38         2008_10_23_02_mangos_mangos_string.sql \
  39         2008_10_23_03_mangos_mangos_string.sql \
  40         2008_10_23_04_mangos_command.sql \
  41         2008_10_23_05_mangos_command.sql \
  42         2008_10_26_01_mangos_mangos_string.sql \
  43         2008_10_27_01_mangos_npc_option.sql \
  44         2008_10_27_02_mangos_locales_npc_option.sql \
  45         2008_10_28_01_mangos_mangos_string.sql \
  46         2008_10_28_02_mangos_mangos_string.sql \
  47         2008_10_28_03_mangos_command.sql \
  48         2008_10_28_04_mangos_command.sql \
  49         2008_10_29_01_mangos_mangos_string.sql \
  50         2008_10_29_02_mangos_command.sql \
  51         2008_10_29_03_mangos_db_version.sql \
  52         2008_10_29_04_mangos_mangos_string.sql \
  53         2008_10_29_05_mangos_command.sql \
  54         2008_10_31_01_mangos_creature_template.sql \
  55         2008_10_31_02_mangos_mangos_string.sql \
  56         2008_10_31_03_mangos_command.sql \
  57         2008_11_01_01_mangos_mangos_string.sql \
  58         2008_11_01_02_mangos_command.sql \
  59         2008_11_07_01_characters_character_db_version.sql \
  60         2008_11_07_02_realmd_realmd_db_version.sql \
  61         2008_11_07_03_characters_guild_bank_tab.sql \
  62         2008_11_07_04_realmd_account.sql \
  63         2008_11_09_01_mangos_command.sql \
  64         2008_11_09_02_mangos_command.sql \
  65         2008_11_09_03_mangos_mangos_string.sql \
  66         2008_11_11_01_mangos_db_script_string.sql \
  67         2008_11_11_02_mangos_scripts.sql \
  68         2008_11_12_01_character_character_aura.sql \
  69         2008_11_14_01_mangos_scripts.sql \
  70         2008_11_16_01_mangos_command.sql \
  71         2008_11_18_01_mangos_creature_movement.sql \
  72         2008_11_18_02_mangos_mangos_string.sql \
  73         2008_11_27_01_mangos_playercreateinfo_item.sql \
  74         2008_11_29_01_mangos_spell_proc_event.sql \
  75         2008_11_29_02_mangos_spell_elixir.sql \
  76         2008_12_03_01_character_guild_member.sql \
  77         2008_12_15_01_character_arenas.sql \
  78         2008_12_15_01_mangos_arenas.sql \
  79         2008_12_22_01_mangos_creature_equip_template.sql \
  80         2008_12_22_02_characters_character_pet.sql \
  81         2008_12_22_03_mangos_item_template.sql \
  82         2008_12_22_04_mangos_item_template.sql \
  83         2008_12_22_05_characters_account_data.sql \
  84         2008_12_22_06_characters_character_achievement.sql \
  85         2008_12_22_07_mangos_quest_template.sql \
  86         2008_12_22_08_mangos_milling_loot_template.sql \
  87         2008_12_22_09_mangos_spell_affect.sql \
  88         2008_12_22_10_mangos_string.sql \
  89         2008_12_22_11_mangos_player_classlevelstats.sql \
  90         2008_12_22_12_mangos_player_levelstats.sql \
  91         2008_12_22_13_mangos_item_template.sql \
  92         2008_12_22_14_mangos_playercreateinfo.sql \
  93         2008_12_22_15_mangos_playercreateinfo_action.sql \
  94         2008_12_22_16_mangos_playercreateinfo_spell.sql \
  95         2008_12_22_17_mangos_item_template.sql \
  96         2008_12_22_18_characters_characters.sql \
  97         2008_12_22_19_characters_item_instance.sql \
  98         6936_01_mangos_spell_chain.sql \
  99         6939_01_mangos_quest_template.sql \
 100         6940_01_mangos_spell_learn_spell.sql \
 101         6941_01_mangos_spell_learn_spell.sql \
 102         6944_01_mangos_mangos_string.sql \
 103         6958_01_mangos_spell_proc_event.sql \
 104         6960_01_mangos_command.sql \
 105         6960_02_mangos_string.sql \
 106         6961_01_mangos_command.sql \
 107         6970_01_mangos_playercreateinfo.sql \
 108         6976_01_realmd_realmd_db_version.sql \
 109         6976_02_characters_character_db_version.sql \
 110         7002_01_mangos_spell_chain.sql \
 111         7015_01_mangos_item_template.sql \
 112         7024_01_mangos_spell_chain.sql \
 113         7026_01_mangos_battleground_template.sql \
 114         7031_01_mangos_spell_proc_event.sql \
 115         7033_01_mangos_spell_proc_event.sql \
 116         7034_01_mangos_spell_proc_event.sql \
 117         7040_01_mangos_achievement_reward.sql \
 118         7044_01_mangos_spell_proc_event.sql \
 119         7047_01_characters_character_spell.sql \
 120         7047_02_mangos_playercreateinfo_action.sql \
 121         7047_03_mangos_playercreateinfo_spell.sql \
 122         7050_01_mangos_spell_proc_event.sql \
 123         7051_01_mangos_spell_proc_event.sql \
 124         7052_01_mangos_spell_proc_event.sql \
 125         7053_01_mangos_spell_proc_event.sql \
 126         7056_01_mangos_spell_proc_event.sql \
 127         7059_01_characters_character_spell.sql \
 128         7059_02_characters_pet_spell.sql \
 129         7060_01_mangos_spell_proc_event.sql \
 130         7061_01_mangos_spell_proc_event.sql \
 131         7063_01_mangos_spell_proc_event.sql \
 132         7067_01_mangos_playercreateinfo_spell.sql \
 133         7067_02_mangos_spell_learn_spell.sql \
 134         7067_03_characters_character_spell.sql \
 135         7074_01_mangos_playercreateinfo_spell.sql \
 136         7075_01_characters_character_spell.sql \
 137         7075_02_mangos_spell_learn_spell.sql \
 138         7077_01_characters_character_spell.sql \
 139         7078_01_mangos_spell_proc_event.sql \
 140         7092_01_mangos_player_xp_for_level.sql \
 141         7097_01_mangos_spell_proc_event.sql \
 142         7100_01_characters_character_spell.sql \
 143         7107_01_mangos_string.sql \
 144         7113_01_characters_character_achievement_progress.sql \
 145         7118_01_mangos_skill_discovery_template.sql \
 146         7133_01_mangos_skill_discovery_template.sql \
 147         7133_02_mangos_spell_loot_template.sql \
 148         7141_01_mangos_instance_template.sql \
 149         7147_01_mangos_creature_template.sql \
 150         7149_01_mangos_spell_proc_event.sql \
 151         7150_01_mangos_playercreateinfo_spell.sql \
 152         7156_01_mangos_spell_proc_event.sql \
 153         7168_01_mangos_command.sql \
 154         7175_01_mangos_spell_proc_event.sql \
 155         7193_01_mangos_mangos_string.sql \
 156         7196_01_mangos_spell_chain.sql \
 157         7196_02_mangos_spell_bonus_data.sql \
 158         7198_01_characters_characters.sql \
 159         7199_01_mangos_spell_bonus_data.sql \
 160         7199_02_mangos_spell_proc_event.sql \
 161         7205_01_mangos_spell_chain.sql \
 162         7207_01_mangos_creature.sql \
 163         7207_02_mangos_gameobject.sql \
 164         7207_03_characters_corpse.sql \
 165         7209_01_mangos_spell_bonus_data.sql \
 166         7214_01_mangos_command.sql \
 167         7214_02_mangos_mangos_string.sql \
 168         7230_01_mangos_spell_chain.sql \
 169         7230_02_mangos_spell_bonus_data.sql \
 170         7235_01_mangos_command.sql \
 171         7242_01_mangos_spell_bonus_data.sql \
 172         7249_01_mangos_spell_proc_event.sql \
 173         7251_01_mangos_spell_chain.sql \
 174         7251_02_characters_character_spell.sql \
 175         7252_01_mangos_command.sql \
 176         7252_02_mangos_mangos_string.sql \
 177         7255_01_characters_characters.sql \
 178         7267_01_characters_auctionhouse.sql \
 179         7290_01_mangos_command.sql \
 180         7292_01_mangos_points_of_interest.sql \
 181         7292_02_mangos_locales_points_of_interest.sql \
 182         7303_01_mangos_pools.sql \
 183         7307_01_characters_arena_team_member.sql \
 184         7312_01_mangos_mangos_string.sql \
 185         7314_01_characters_guild_rank.sql \
 186         7324_01_characters_character_spell.sql \
 187         7324_02_characters_character_aura.sql \
 188         7331_01_mangos_command.sql \
 189         7332_01_mangos_command.sql \
 190         7349_01_mangos_spell_area.sql \
 191         7369_01_mangos_quest_template.sql \
 192         7376_01_mangos_spell_area.sql \
 193         7382_01_mangos_creature_template.sql \
 194         7388_01_mangos_mangos_string.sql \
 195         7390_01_mangos_areatrigger_teleport.sql \
 196         7393_01_mangos_game_event.sql \
 197         7399_01_mangos_mangos_string.sql \
 198         7422_01_mangos_mangos_string.sql \
 199         7439_01_mangos_mangos_string.sql \
 200         7472_01_mangos_mangos_string.sql \
 201         7493_01_mangos_command.sql \
 202         7495_01_mangos_mangos_string.sql \
 203         7503_01_mangos_command.sql \
 204         7536_01_mangos_spell_chain.sql \
 205         7544_01_mangos_uptime.sql \
 206         7544_02_characters_uptime.sql \
 207         7546_01_characters_uptime.sql \
 208         7546_02_realmd_uptime.sql \
 209         7558_01_mangos_mangos_string.sql \
 210         7558_02_mangos_command.sql \
 211         7560_01_mangos_gameobject_template.sql \
 212         7565_01_mangos_mangos_string.sql \
 213         7568_01_mangos_spell_proc_event.sql \
 214         7615_01_mangos_command.sql \
 215         7616_01_mangos_mangos_string.sql \
 216         7616_02_mangos_command.sql \
 217         README
 218
 219 ## Additional files to include when running 'make dist'
 220 #  SQL update files, to upgrade database schema from older revisions
 221 EXTRA_DIST = \
 222         2008_10_18_01_characters_characters.sql \
 223         2008_10_18_02_mangos_spell_proc_event.sql \
 224         2008_10_19_01_mangos_spell_affect.sql \
 225         2008_10_19_02_mangos_spell_proc_event.sql \
 226         2008_10_21_01_mangos_mangos_string.sql \
 227         2008_10_21_02_mangos_command.sql \
 228         2008_10_21_03_mangos_command.sql \
 229         2008_10_22_01_mangos_quest_template.sql \
 230         2008_10_22_02_mangos_mangos_string.sql \
 231         2008_10_23_01_mangos_command.sql \
 232         2008_10_23_02_mangos_mangos_string.sql \
 233         2008_10_23_03_mangos_mangos_string.sql \
 234         2008_10_23_04_mangos_command.sql \
 235         2008_10_23_05_mangos_command.sql \
 236         2008_10_26_01_mangos_mangos_string.sql \
 237         2008_10_27_01_mangos_npc_option.sql \
 238         2008_10_27_02_mangos_locales_npc_option.sql \
 239         2008_10_28_01_mangos_mangos_string.sql \
 240         2008_10_28_02_mangos_mangos_string.sql \
 241         2008_10_28_03_mangos_command.sql \
 242         2008_10_28_04_mangos_command.sql \
 243         2008_10_29_01_mangos_mangos_string.sql \
 244         2008_10_29_02_mangos_command.sql \
 245         2008_10_29_03_mangos_db_version.sql \
 246         2008_10_29_04_mangos_mangos_string.sql \
 247         2008_10_29_05_mangos_command.sql \
 248         2008_10_31_01_mangos_creature_template.sql \
 249         2008_10_31_02_mangos_mangos_string.sql \
 250         2008_10_31_03_mangos_command.sql \
 251         2008_11_01_01_mangos_mangos_string.sql \
 252         2008_11_01_02_mangos_command.sql \
 253         2008_11_07_01_characters_character_db_version.sql \
 254         2008_11_07_02_realmd_realmd_db_version.sql \
 255         2008_11_07_03_characters_guild_bank_tab.sql \
 256         2008_11_07_04_realmd_account.sql \
 257         2008_11_09_01_mangos_command.sql \
 258         2008_11_09_02_mangos_command.sql \
 259         2008_11_09_03_mangos_mangos_string.sql \
 260         2008_11_11_01_mangos_db_script_string.sql \
 261         2008_11_11_02_mangos_scripts.sql \
 262         2008_11_12_01_character_character_aura.sql \
 263         2008_11_14_01_mangos_scripts.sql \
 264         2008_11_16_01_mangos_command.sql \
 265         2008_11_18_01_mangos_creature_movement.sql \
 266         2008_11_18_02_mangos_mangos_string.sql \
 267         2008_11_27_01_mangos_playercreateinfo_item.sql \
 268         2008_11_29_01_mangos_spell_proc_event.sql \
 269         2008_11_29_02_mangos_spell_elixir.sql \
 270         2008_12_03_01_character_guild_member.sql \
 271         2008_12_15_01_character_arenas.sql \
 272         2008_12_15_01_mangos_arenas.sql \
 273         2008_12_22_01_mangos_creature_equip_template.sql \
 274         2008_12_22_02_characters_character_pet.sql \
 275         2008_12_22_03_mangos_item_template.sql \
 276         2008_12_22_04_mangos_item_template.sql \
 277         2008_12_22_05_characters_account_data.sql \
 278         2008_12_22_06_characters_character_achievement.sql \
 279         2008_12_22_07_mangos_quest_template.sql \
 280         2008_12_22_08_mangos_milling_loot_template.sql \
 281         2008_12_22_09_mangos_spell_affect.sql \
 282         2008_12_22_10_mangos_string.sql \
 283         2008_12_22_11_mangos_player_classlevelstats.sql \
 284         2008_12_22_12_mangos_player_levelstats.sql \
 285         2008_12_22_13_mangos_item_template.sql \
 286         2008_12_22_14_mangos_playercreateinfo.sql \
 287         2008_12_22_15_mangos_playercreateinfo_action.sql \
 288         2008_12_22_16_mangos_playercreateinfo_spell.sql \
 289         2008_12_22_17_mangos_item_template.sql \
 290         2008_12_22_18_characters_characters.sql \
 291         2008_12_22_19_characters_item_instance.sql \
 292         6936_01_mangos_spell_chain.sql \
 293         6939_01_mangos_quest_template.sql \
 294         6940_01_mangos_spell_learn_spell.sql \
 295         6941_01_mangos_spell_learn_spell.sql \
 296         6944_01_mangos_mangos_string.sql \
 297         6958_01_mangos_spell_proc_event.sql \
 298         6960_01_mangos_command.sql \
 299         6960_02_mangos_string.sql \
 300         6961_01_mangos_command.sql \
 301         6970_01_mangos_playercreateinfo.sql \
 302         6976_01_realmd_realmd_db_version.sql \
 303         6976_02_characters_character_db_version.sql \
 304         7002_01_mangos_spell_chain.sql \
 305         7015_01_mangos_item_template.sql \
 306         7024_01_mangos_spell_chain.sql \
 307         7026_01_mangos_battleground_template.sql \
 308         7031_01_mangos_spell_proc_event.sql \
 309         7033_01_mangos_spell_proc_event.sql \
 310         7034_01_mangos_spell_proc_event.sql \
 311         7040_01_mangos_achievement_reward.sql \
 312         7044_01_mangos_spell_proc_event.sql \
 313         7047_01_characters_character_spell.sql \
 314         7047_02_mangos_playercreateinfo_action.sql \
 315         7047_03_mangos_playercreateinfo_spell.sql \
 316         7050_01_mangos_spell_proc_event.sql \
 317         7051_01_mangos_spell_proc_event.sql \
 318         7052_01_mangos_spell_proc_event.sql \
 319         7053_01_mangos_spell_proc_event.sql \
 320         7056_01_mangos_spell_proc_event.sql \
 321         7059_01_characters_character_spell.sql \
 322         7059_02_characters_pet_spell.sql \
 323         7060_01_mangos_spell_proc_event.sql \
 324         7061_01_mangos_spell_proc_event.sql \
 325         7063_01_mangos_spell_proc_event.sql \
 326         7067_01_mangos_playercreateinfo_spell.sql \
 327         7067_02_mangos_spell_learn_spell.sql \
 328         7067_03_characters_character_spell.sql \
 329         7074_01_mangos_playercreateinfo_spell.sql \
 330         7075_01_characters_character_spell.sql \
 331         7075_02_mangos_spell_learn_spell.sql \
 332         7077_01_characters_character_spell.sql \
 333         7078_01_mangos_spell_proc_event.sql \
 334         7092_01_mangos_player_xp_for_level.sql \
 335         7097_01_mangos_spell_proc_event.sql \
 336         7100_01_characters_character_spell.sql \
 337         7107_01_mangos_string.sql \
 338         7113_01_characters_character_achievement_progress.sql \
 339         7118_01_mangos_skill_discovery_template.sql \
 340         7133_01_mangos_skill_discovery_template.sql \
 341         7133_02_mangos_spell_loot_template.sql \
 342         7141_01_mangos_instance_template.sql \
 343         7147_01_mangos_creature_template.sql \
 344         7149_01_mangos_spell_proc_event.sql \
 345         7150_01_mangos_playercreateinfo_spell.sql \
 346         7156_01_mangos_spell_proc_event.sql \
 347         7168_01_mangos_command.sql \
 348         7175_01_mangos_spell_proc_event.sql \
 349         7193_01_mangos_mangos_string.sql \
 350         7196_01_mangos_spell_chain.sql \
 351         7196_02_mangos_spell_bonus_data.sql \
 352         7198_01_characters_characters.sql \
 353         7199_01_mangos_spell_bonus_data.sql \
 354         7199_02_mangos_spell_proc_event.sql \
 355         7205_01_mangos_spell_chain.sql \
 356         7207_01_mangos_creature.sql \
 357         7207_02_mangos_gameobject.sql \
 358         7207_03_characters_corpse.sql \
 359         7209_01_mangos_spell_bonus_data.sql \
 360         7214_01_mangos_command.sql \
 361         7214_02_mangos_mangos_string.sql \
 362         7230_01_mangos_spell_chain.sql \
 363         7230_02_mangos_spell_bonus_data.sql \
 364         7235_01_mangos_command.sql \
 365         7242_01_mangos_spell_bonus_data.sql \
 366         7249_01_mangos_spell_proc_event.sql \
 367         7251_01_mangos_spell_chain.sql \
 368         7251_02_characters_character_spell.sql \
 369         7252_01_mangos_command.sql \
 370         7252_02_mangos_mangos_string.sql \
 371         7255_01_characters_characters.sql \
 372         7267_01_characters_auctionhouse.sql \
 373         7290_01_mangos_command.sql \
 374         7292_01_mangos_points_of_interest.sql \
 375         7292_02_mangos_locales_points_of_interest.sql \
 376         7303_01_mangos_pools.sql \
 377         7307_01_characters_arena_team_member.sql \
 378         7312_01_mangos_mangos_string.sql \
 379         7314_01_characters_guild_rank.sql \
 380         7324_01_characters_character_spell.sql \
 381         7324_02_characters_character_aura.sql \
 382         7331_01_mangos_command.sql \
 383         7332_01_mangos_command.sql \
 384         7349_01_mangos_spell_area.sql \
 385         7369_01_mangos_quest_template.sql \
 386         7376_01_mangos_spell_area.sql \
 387         7382_01_mangos_creature_template.sql \
 388         7388_01_mangos_mangos_string.sql \
 389         7390_01_mangos_areatrigger_teleport.sql \
 390         7393_01_mangos_game_event.sql \
 391         7399_01_mangos_mangos_string.sql \
 392         7422_01_mangos_mangos_string.sql \
 393         7439_01_mangos_mangos_string.sql \
 394         7472_01_mangos_mangos_string.sql \
 395         7493_01_mangos_command.sql \
 396         7495_01_mangos_mangos_string.sql \
 397         7503_01_mangos_command.sql \
 398         7536_01_mangos_spell_chain.sql \
 399         7544_01_mangos_uptime.sql \
 400         7544_02_characters_uptime.sql \
 401         7546_01_characters_uptime.sql \
 402         7546_02_realmd_uptime.sql \
 403         7558_01_mangos_mangos_string.sql \
 404         7558_02_mangos_command.sql \
 405         7560_01_mangos_gameobject_template.sql \
 406         7565_01_mangos_mangos_string.sql \
 407         7568_01_mangos_spell_proc_event.sql \
 408         7615_01_mangos_command.sql \
 409         7616_01_mangos_mangos_string.sql \
 410         7616_02_mangos_command.sql \
 411         README