aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7643_01_mangos_db_version.sql7
-rw-r--r--sql/updates/7643_02_mangos_mangos_string.sql5
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);