*[8469] Fix possible garbage in character_spell after [8416]

Removed in sql update spell not expected to be listed in character_spell
long before [8416] as dependent, but reported as partly listed. So do cleanup.
Author: The_Game_Master
*Also add missed update SQL from r5620/1063fcbcd5ce

--HG--
branch : trunk

2 files changed, 24 insertions, 0 deletions

diff --git a/sql/updates/5628_character_8433_01_characters_character_account_data.sql b/sql/updates/5628_character_8433_01_characters_character_account_data.sql
new file mode 100644
index 00000000000..73f5f6195fa
--- /dev/null
+++ b/sql/updates/5628_character_8433_01_characters_character_account_data.sql
@@ -0,0 +1,20 @@
+ALTER TABLE character_db_version CHANGE COLUMN required_8433_01_characters_character_account_data required_8469_01_characters_character_spell bit;
+
+DELETE FROM character_spell WHERE spell in (
+ 1178,  /* Bear Form (Passive) */
+ 3025,  /* Cat Form (Passive) */
+ 5419,  /* Travel Form (Passive) */
+ 5420,  /* Tree of Life _passive_ */
+ 5421,  /* Aquatic Form (Passive) */
+ 7376,  /* Defensive Stance Passive */
+ 7381,  /* Berserker Stance Passive */
+ 9635,  /* Dire Bear Form (Passive) */
+ 21156, /* Battle Stance Passive */
+ 21178, /* Bear Form (Passive2) */
+ 24905, /* Moonkin Form (Passive) */
+ 34123, /* Tree of Life _pasive_ */
+ 33948, /* Flight Form (Passive) */
+ 34764, /* Flight Form (Passive) */
+ 40121, /* Swift Flight Form (Passive) */
+ 40122  /* Swift Flight Form (Passive) */
+);
diff --git a/sql/updates/5628_world_8451_01_mangos_spell_proc_event.sql b/sql/updates/5628_world_8451_01_mangos_spell_proc_event.sql
new file mode 100644
index 00000000000..0559b422b32
--- /dev/null
+++ b/sql/updates/5628_world_8451_01_mangos_spell_proc_event.sql
@@ -0,0 +1,4 @@
+
+-- ALTER TABLE db_version CHANGE COLUMN required_8451_01_mangos_spell_proc_event required_8462_01_mangos_creature_ai_texts bit;
+
+ALTER TABLE creature_ai_texts CHANGE emote emote smallint(5) unsigned NOT NULL default '0';