diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mangos.sql | 6 | ||||
| -rw-r--r-- | sql/updates/7643_01_mangos_db_version.sql | 7 | ||||
| -rw-r--r-- | sql/updates/7643_02_mangos_mangos_string.sql | 5 |
3 files changed, 16 insertions, 2 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index bf6fbcfcef7..4aa7b69c067 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -22,7 +22,8 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, - `required_7633_01_mangos_achievement_criteria_data` bit(1) default NULL + `creature_ai_version` varchar(120) default NULL, + `required_7643_02_mangos_mangos_string` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -32,7 +33,7 @@ CREATE TABLE `db_version` ( LOCK TABLES `db_version` WRITE; /*!40000 ALTER TABLE `db_version` DISABLE KEYS */; INSERT INTO `db_version` VALUES -('Mangos default database.',NULL); +('Mangos default database.','Creature EventAI not provided.',NULL); /*!40000 ALTER TABLE `db_version` ENABLE KEYS */; UNLOCK TABLES; @@ -2462,6 +2463,7 @@ INSERT INTO `mangos_string` VALUES (56,'Current Message of the day: \r\n%s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (57,'Using World DB: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (58,'Using script library: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(59,'Using creature EventAI: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (100,'Global notify: ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (101,'Map: %u (%s) Zone: %u (%s) Area: %u (%s) Phase: %u\nX: %f Y: %f Z: %f Orientation: %f\ngrid[%u,%u]cell[%u,%u] InstanceID: %u\n ZoneX: %f ZoneY: %f\nGroundZ: %f FloorZ: %f Have height data (Map: %u VMap: %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (102,'%s is already being teleported.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), 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); |