From 57173df80f29d796a6de56b877fceff7abe181bc Mon Sep 17 00:00:00 2001
From: Machiavelli <machiavelli.trinity@gmail.com>
Date: Sat, 8 Jan 2011 22:49:44 +0100
Subject: Core/SQL: Move spell_script_names from world_database.sql to
 world_scripts_full.sql (they're called scripts for a reason)

---
 sql/base/world_database.sql | 269 --------------------------------------------
 1 file changed, 269 deletions(-)

(limited to 'sql/base/world_database.sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 270b8ae0262..e845959fc68 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -26733,275 +26733,6 @@ CREATE TABLE `spell_script_names` (
 
 LOCK TABLES `spell_script_names` WRITE;
 /*!40000 ALTER TABLE `spell_script_names` DISABLE KEYS */;
-INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
--- generic
-( 39228, 'spell_gen_absorb0_hitlimit1'),
-( 60218, 'spell_gen_absorb0_hitlimit1'),
-(  6962, 'spell_gen_pet_summoned'),
-( 10848, 'spell_gen_shroud_of_death'),
-( 24750, 'spell_gen_trick'),
-( 24751, 'spell_gen_trick_or_treat'),
-( 29266, 'spell_creature_permanent_feign_death'),
-( 31261, 'spell_creature_permanent_feign_death'),
-( 41337, 'spell_gen_aura_of_anger'),
-( 45472, 'spell_gen_parachute'),
-( 46394, 'spell_gen_burn_brutallus'),
-( 57685, 'spell_creature_permanent_feign_death'),
-( 58601, 'spell_gen_remove_flight_auras'),
-( 66118, 'spell_gen_leeching_swarm'),
-( 58951, 'spell_creature_permanent_feign_death'),
-( 70592, 'spell_creature_permanent_feign_death'),
-( 70628, 'spell_creature_permanent_feign_death'),
-( 74490, 'spell_creature_permanent_feign_death'),
-( 72752, 'spell_pvp_trinket_wotf_shared_cd'),
-( 72757, 'spell_pvp_trinket_wotf_shared_cd'),
-( 46221, 'spell_gen_animal_blood'),
-( 70769, 'spell_gen_divine_storm_cd_reset'),
--- instances
--- Black Temple
-( 41475, 'spell_boss_lady_malande_shield'),
--- Forge of Souls
-( 68793, 'spell_bronjahm_magic_bane'),
-( 69050, 'spell_bronjahm_magic_bane'),
-( 68861, 'spell_bronjahm_consume_soul'),
-( 69008, 'spell_bronjahm_soulstorm_channel'),
-( 68870, 'spell_bronjahm_soulstorm_visual'),
--- Pit of Saron
-( 68786, 'spell_garfrost_permafrost'),
-( 70336, 'spell_garfrost_permafrost'),
-( 69012, 'spell_krick_explosive_barrage'),
-( 69263, 'spell_ick_explosive_barrage'),
-( 44851, 'spell_exploding_orb_hasty_grow'),
-( 68987, 'spell_krick_pursuit'),
-( 69029, 'spell_krick_pursuit_confusion'),
-( 70850, 'spell_krick_pursuit_confusion'),
-( 69275, 'spell_tyrannus_mark_of_rimefang'),
-( 69172, 'spell_tyrannus_overlord_brand'),
--- Icecrown Citadel
-( 69057, 'spell_marrowgar_bone_spike_graveyard'),
-( 70826, 'spell_marrowgar_bone_spike_graveyard'),
-( 72088, 'spell_marrowgar_bone_spike_graveyard'),
-( 72089, 'spell_marrowgar_bone_spike_graveyard'),
-( 69140, 'spell_marrowgar_coldflame'),
-( 72705, 'spell_marrowgar_coldflame'),
-( 69147, 'spell_marrowgar_coldflame_trigger'),
-( 69075, 'spell_marrowgar_bone_storm'),
-( 70834, 'spell_marrowgar_bone_storm'),
-( 70835, 'spell_marrowgar_bone_storm'),
-( 70836, 'spell_marrowgar_bone_storm'),
-( 70842, 'spell_deathwhisper_mana_barrier'),
-( 70903, 'spell_cultist_dark_martyrdom'),
-( 72498, 'spell_cultist_dark_martyrdom'),
-( 72499, 'spell_cultist_dark_martyrdom'),
-( 72500, 'spell_cultist_dark_martyrdom'),
-( 71236, 'spell_cultist_dark_martyrdom'),
-( 72495, 'spell_cultist_dark_martyrdom'),
-( 72496, 'spell_cultist_dark_martyrdom'),
-( 72497, 'spell_cultist_dark_martyrdom'),
-( 72202, 'spell_deathbringer_blood_link'),
-( 72178, 'spell_deathbringer_blood_link_aura'),
-( 72371, 'spell_deathbringer_blood_power'),
-( 72409, 'spell_deathbringer_rune_of_blood'),
-( 72447, 'spell_deathbringer_rune_of_blood'),
-( 72448, 'spell_deathbringer_rune_of_blood'),
-( 72449, 'spell_deathbringer_rune_of_blood'),
-( 72380, 'spell_deathbringer_blood_nova'),
-( 72438, 'spell_deathbringer_blood_nova'),
-( 72439, 'spell_deathbringer_blood_nova'),
-( 72440, 'spell_deathbringer_blood_nova'),
-( 71123, 'spell_stinky_precious_decimate'),
-( 73032, 'spell_festergut_pungent_blight'),
-( 73031, 'spell_festergut_pungent_blight'),
-( 71219, 'spell_festergut_pungent_blight'),
-( 69195, 'spell_festergut_pungent_blight'),
-( 72219, 'spell_festergut_gastric_bloat'),
-( 72551, 'spell_festergut_gastric_bloat'),
-( 72552, 'spell_festergut_gastric_bloat'),
-( 72553, 'spell_festergut_gastric_bloat'),
-( 69290, 'spell_festergut_blighted_spores'),
-( 71222, 'spell_festergut_blighted_spores'),
-( 73033, 'spell_festergut_blighted_spores'),
-( 73034, 'spell_festergut_blighted_spores'),
-( 69782, 'spell_rotface_ooze_flood'),
-( 69796, 'spell_rotface_ooze_flood'),
-( 69798, 'spell_rotface_ooze_flood'),
-( 69801, 'spell_rotface_ooze_flood'),
-( 69538, 'spell_rotface_little_ooze_combine'),
-( 69553, 'spell_rotface_large_ooze_combine'),
-( 69610, 'spell_rotface_large_ooze_buff_combine'),
-( 69839, 'spell_rotface_unstable_ooze_explosion_init'),
-( 69832, 'spell_rotface_unstable_ooze_explosion'),
-( 71441, 'spell_rotface_unstable_ooze_explosion_suicide'),
-( 70701, 'spell_putricide_expunged_gas'),
-( 70343, 'spell_putricide_slime_puddle'),
-( 70351, 'spell_putricide_unstable_experiment'),
-( 71966, 'spell_putricide_unstable_experiment'),
-( 71967, 'spell_putricide_unstable_experiment'),
-( 71968, 'spell_putricide_unstable_experiment'),
-( 71412, 'spell_putricide_ooze_summon'),
-( 71415, 'spell_putricide_ooze_summon'),
-( 70672, 'spell_putricide_gaseous_bloat'),
-( 72455, 'spell_putricide_gaseous_bloat'),
-( 72832, 'spell_putricide_gaseous_bloat'),
-( 72833, 'spell_putricide_gaseous_bloat'),
-( 70459, 'spell_putricide_ooze_eruption_searcher'),
-( 71255, 'spell_putricide_choking_gas_bomb'),
-( 70920, 'spell_putricide_unbound_plague'),
-( 70360, 'spell_putricide_eat_ooze'),
-( 72527, 'spell_putricide_eat_ooze'),
-( 72451, 'spell_putricide_mutated_plague'),
-( 72463, 'spell_putricide_mutated_plague'),
-( 72671, 'spell_putricide_mutated_plague'),
-( 72672, 'spell_putricide_mutated_plague'),
-( 70308, 'spell_putricide_mutation_init'),
-( 70311, 'spell_putricide_mutated_transformation'),
-( 71503, 'spell_putricide_mutated_transformation'),
-( 70405, 'spell_putricide_mutated_transformation_dismiss'),
-( 72508, 'spell_putricide_mutated_transformation_dismiss'),
-( 72509, 'spell_putricide_mutated_transformation_dismiss'),
-( 72510, 'spell_putricide_mutated_transformation_dismiss'),
-( 70539, 'spell_putricide_regurgitated_ooze'),
-( 72457, 'spell_putricide_regurgitated_ooze'),
-( 72875, 'spell_putricide_regurgitated_ooze'),
-( 72876, 'spell_putricide_regurgitated_ooze'),
-( 71598, 'spell_creature_permanent_feign_death'),
-( 71806, 'spell_taldaram_glittering_sparks'),
-( 71718, 'spell_taldaram_summon_flame_ball'),
-( 72040, 'spell_taldaram_summon_flame_ball'),
-( 55891, 'spell_taldaram_flame_ball_visual'),
-( 55947, 'spell_taldaram_flame_ball_visual'),
-( 71756, 'spell_taldaram_ball_of_inferno_flame'),
-( 72782, 'spell_taldaram_ball_of_inferno_flame'),
-( 72783, 'spell_taldaram_ball_of_inferno_flame'),
-( 72784, 'spell_taldaram_ball_of_inferno_flame'),
-( 72080, 'spell_valanar_kinetic_bomb'),
-( 72087, 'spell_valanar_kinetic_bomb_knockback'),
-( 73001, 'spell_blood_council_shadow_prison'),
-( 72999, 'spell_blood_council_shadow_prison_damage'),
-( 70877, 'spell_blood_queen_frenzied_bloodthirst'),
-( 71474, 'spell_blood_queen_frenzied_bloodthirst'),
-( 70946, 'spell_blood_queen_vampiric_bite'),
-( 71475, 'spell_blood_queen_vampiric_bite'),
-( 71476, 'spell_blood_queen_vampiric_bite'),
-( 71477, 'spell_blood_queen_vampiric_bite'),
-( 71899, 'spell_blood_queen_bloodbolt'),
-( 71900, 'spell_blood_queen_bloodbolt'),
-( 71901, 'spell_blood_queen_bloodbolt'),
-( 71902, 'spell_blood_queen_bloodbolt'),
--- Trial of Crusader
-( 66118, 'spell_gen_leeching_swarm'),
-( 67630, 'spell_gen_leeching_swarm'),
-( 68646, 'spell_gen_leeching_swarm'),
-( 68647, 'spell_gen_leeching_swarm'),
--- Ulduar
-( 62717, 'spell_ignis_slag_pot'),
-( 63477, 'spell_ignis_slag_pot'),
-( 62521, 'spell_attuned_to_nature_dose_reduction'),
-( 62524, 'spell_attuned_to_nature_dose_reduction'),
-( 62525, 'spell_attuned_to_nature_dose_reduction'),
--- quest
-(  8913, 'spell_q55_sacred_cleansing'),
-( 17271, 'spell_q5206_test_fetid_skull'),
-( 19512, 'spell_q6124_6129_apply_salve'),
-( 34665, 'spell_q10255_administer_antidote'),
-( 43874, 'spell_q11396_11399_force_shield_arcane_purple_x3'),
-( 43882, 'spell_q11396_11399_scourging_crystal_controller_dummy'),
-( 50133, 'spell_q11396_11399_scourging_crystal_controller'),
-( 44936, 'spell_q11515_fel_siphon_dummy'),
-( 45449, 'spell_q11587_arcane_prisoner_rescue'),
-( 46023, 'spell_q11730_ultrasonic_screwdriver'),
-( 49587, 'spell_q12459_seeds_of_natures_wrath'),
-( 51840, 'spell_q12634_despawn_fruit_tosser'),
-( 52308, 'spell_q12683_take_sputum_sample'),
-( 55804, 'spell_q12937_relief_for_the_fallen'),
--- item
-( 23074, 'spell_item_arcanite_dragonling'),
-(  8063, 'spell_item_deviate_fish'),
-( 67019, 'spell_item_flask_of_the_north'),
-( 23133, 'spell_item_gnomish_battle_chicken'),
-( 13280, 'spell_item_gnomish_death_ray'),
-( 33060, 'spell_item_make_a_wish'),
-( 23076, 'spell_item_mechanical_dragonling'),
-( 40802, 'spell_item_mingos_fortune_generator'),
-( 23075, 'spell_item_mithril_mechanical_dragonling'),
-( 13120, 'spell_item_net_o_matic'),
-( 16589, 'spell_item_noggenfogger_elixir'),
-(  8213, 'spell_item_savory_deviate_delight'),
-( 14537, 'spell_item_six_demon_bag'),
-( 59640, 'spell_item_underbelly_elixir'),
-( 71905, 'spell_item_shadowmourne'),
-( 67533, 'spell_item_red_rider_air_rifle'),
--- warrior
-( 12975, 'spell_warr_last_stand'),
--- paladin
-(-31850, 'spell_pal_ardent_defender'),
-( 20425, 'spell_pal_judgement_of_command'),
-( 63521, 'spell_pal_guarded_by_the_light'),
-(-20473, 'spell_pal_holy_shock'),
-( 20911, 'spell_pal_blessing_of_sanctuary'),
-( 25899, 'spell_pal_blessing_of_sanctuary'),
-( 37877, 'spell_pal_blessing_of_faith'),
--- hunter
-( 53209, 'spell_hun_chimera_shot'),
-( 53412, 'spell_hun_invigoration'),
-( 53271, 'spell_hun_masters_call'),
-( 53478, 'spell_hun_last_stand_pet'),
-( 23989, 'spell_hun_readiness'),
-( 37506, 'spell_hun_scatter_shot'),
-(-53302, 'spell_hun_sniper_training'),
-( 55709, 'spell_hun_pet_heart_of_the_phoenix'),
-( 54044, 'spell_hun_pet_carrion_feeder'),
--- rogue
-(-31228, 'spell_rog_cheat_death'),
-(-31130, 'spell_rog_nerves_of_steel'),
-(  5938, 'spell_rog_shiv'),
-( 14185, 'spell_rog_preparation'),
-(-51685, 'spell_rog_prey_on_the_weak'),
--- priest
-(-47788, 'spell_pri_guardian_spirit'),
-( -8129, 'spell_pri_mana_burn'),
-( 47948, 'spell_pri_pain_and_suffering_proc'),
-(-47540, 'spell_pri_penance'),
-(   -17, 'spell_pri_reflective_shield_trigger'),
--- death knight
-( 50462, 'spell_dk_anti_magic_shell_raid'),
-( 48707, 'spell_dk_anti_magic_shell_self'),
-( 50461, 'spell_dk_anti_magic_zone'),
-(-49158, 'spell_dk_corpse_explosion'),
-( 50524, 'spell_dk_runic_power_feed'),
-(-55090, 'spell_dk_scourge_strike'),
-(-49145, 'spell_dk_spell_deflection'),
-(-52284, 'spell_dk_will_of_the_necropolis'),
--- shaman
-(-51474, 'spell_sha_astral_shift'),
-( 39610, 'spell_sha_mana_tide_totem'),
-( -1535, 'spell_sha_fire_nova'),
-(  6474, 'spell_sha_earthbind_totem'),
--- mage
-(-11113, 'spell_mage_blast_wave'),
-( 11958, 'spell_mage_cold_snap'),
-(  -543, 'spell_mage_frost_warding_trigger'),
-( -6143, 'spell_mage_frost_warding_trigger'),
-(  -543, 'spell_mage_incanters_absorbtion_absorb'),
-( -6143, 'spell_mage_incanters_absorbtion_absorb'),
-(-11426, 'spell_mage_incanters_absorbtion_absorb'),
-( -1463, 'spell_mage_incanters_absorbtion_manashield')
-( 31687, 'spell_mage_summon_water_elemental'),
-( 32826, 'spell_mage_polymorph_visual'),
--- warlock
-( -6201, 'spell_warl_create_healthstone'),
-( 47193, 'spell_warl_demonic_empowerment'),
-( 47422, 'spell_warl_everlasting_affliction'),
--- druid
-( 54846, 'spell_dru_glyph_of_starfire'),
-( 69366, 'spell_dru_moonkin_form_passive'),
-(-33851, 'spell_dru_primal_tenacity'),
-( 62606, 'spell_dru_savage_defense'),
--- example
-( 66244, 'spell_ex_66244'), 
-( 5581,  'spell_ex_5581'),
-( 47299, 'spell_ex_absorb_aura');
-
 /*!40000 ALTER TABLE `spell_script_names` ENABLE KEYS */;
 UNLOCK TABLES;
 
-- 
cgit v1.2.3

