diff options
| -rw-r--r-- | sql/updates/2565_world.sql (renamed from sql/updates/2560_world.sql) | 16 | ||||
| -rw-r--r-- | sql/updates/7643_01_mangos_db_version.sql | 7 | ||||
| -rw-r--r-- | sql/updates/7643_02_mangos_mangos_string.sql | 5 | ||||
| -rw-r--r-- | sql/world_scripts_structure.sql | 16 |
4 files changed, 30 insertions, 14 deletions
diff --git a/sql/updates/2560_world.sql b/sql/updates/2565_world.sql index 9d08752d5b1..2b744ba549b 100644 --- a/sql/updates/2560_world.sql +++ b/sql/updates/2565_world.sql @@ -1,3 +1,15 @@ +DROP TABLE IF EXISTS script_waypoint; +CREATE TABLE script_waypoint ( + entry mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry', + pointid mediumint(8) unsigned NOT NULL DEFAULT '0', + location_x float NOT NULL DEFAULT '0', + location_y float NOT NULL DEFAULT '0', + location_z float NOT NULL DEFAULT '0', + waittime int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs', + point_comment text, + PRIMARY KEY (entry, pointid) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; + -- script waypoint DELETE FROM script_waypoint WHERE entry=467; INSERT INTO script_waypoint VALUES @@ -325,3 +337,7 @@ INSERT INTO script_waypoint VALUES -- Henry Stern UPDATE `creature_template` SET `ScriptName`='npc_henry_stern' WHERE `entry`=8696; + +DELETE FROM `trinity_string` WHERE `entry` IN (59); +INSERT INTO `trinity_string` VALUES +(59,'Using creature EventAI: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file diff --git a/sql/updates/7643_01_mangos_db_version.sql b/sql/updates/7643_01_mangos_db_version.sql deleted file mode 100644 index efdd0e22e0d..00000000000 --- a/sql/updates/7643_01_mangos_db_version.sql +++ /dev/null @@ -1,7 +0,0 @@ -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 deleted file mode 100644 index 2ce9573b3f7..00000000000 --- a/sql/updates/7643_02_mangos_mangos_string.sql +++ /dev/null @@ -1,5 +0,0 @@ -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); diff --git a/sql/world_scripts_structure.sql b/sql/world_scripts_structure.sql index 57556ff5910..7ac482bb493 100644 --- a/sql/world_scripts_structure.sql +++ b/sql/world_scripts_structure.sql @@ -98,9 +98,21 @@ CREATE TABLE IF NOT EXISTS `script_texts` ( PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'; +DROP TABLE IF EXISTS script_waypoint; +CREATE TABLE script_waypoint ( + entry mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry', + pointid mediumint(8) unsigned NOT NULL DEFAULT '0', + location_x float NOT NULL DEFAULT '0', + location_y float NOT NULL DEFAULT '0', + location_z float NOT NULL DEFAULT '0', + waittime int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs', + point_comment text, + PRIMARY KEY (entry, pointid) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; + + DROP TABLE IF EXISTS `sd2_db_version`; DROP TABLE IF EXISTS `script_db_version`; CREATE TABLE `script_db_version` ( `version` varchar(255) NOT NULL default '' COMMENT 'Database version string' -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - +) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\ No newline at end of file |