[7643] Allow set, store and output creture EventAI data version in addition to world DB and script library versions. Author: VladimirMangos

*This patch is disabled in TC2.

--HG--
branch : trunk

2 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/7643_01_mangos_db_version.sql b/sql/updates/7643_01_mangos_db_version.sql
new file mode 100644
index 00000000000..efdd0e22e0d
--- /dev/null
+++ b/sql/updates/7643_01_mangos_db_version.sql
@@ -0,0 +1,7 @@
+ALTER TABLE db_version CHANGE COLUMN required_7633_01_mangos_achievement_criteria_data required_7643_01_mangos_db_version bit;
+
+ALTER TABLE db_version
+   ADD COLUMN creature_ai_version varchar(120) default NULL AFTER version;
+
+UPDATE db_version
+  SET creature_ai_version = 'Mangos default creature EventAI data.';
diff --git a/sql/updates/7643_02_mangos_mangos_string.sql b/sql/updates/7643_02_mangos_mangos_string.sql
new file mode 100644
index 00000000000..2ce9573b3f7
--- /dev/null
+++ b/sql/updates/7643_02_mangos_mangos_string.sql
@@ -0,0 +1,5 @@
+ALTER TABLE db_version CHANGE COLUMN required_7643_01_mangos_db_version required_7643_02_mangos_mangos_string bit;
+
+DELETE FROM mangos_string WHERE entry IN(59);
+INSERT INTO mangos_string VALUES
+(59,'Using creature EventAI: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);