aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/444_world.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/444_world.sql')
-rw-r--r--sql/updates/444_world.sql36
1 files changed, 36 insertions, 0 deletions
diff --git a/sql/updates/444_world.sql b/sql/updates/444_world.sql
new file mode 100644
index 00000000000..004cf626f88
--- /dev/null
+++ b/sql/updates/444_world.sql
@@ -0,0 +1,36 @@
+DROP TABLE IF EXISTS `waypoint_data`;
+
+CREATE TABLE `waypoint_data` (
+ `id` int(10) unsigned NOT NULL default '0' COMMENT 'Creature GUID',
+ `point` mediumint(8) unsigned NOT NULL default '0',
+ `position_x` float NOT NULL default '0',
+ `position_y` float NOT NULL default '0',
+ `position_z` float NOT NULL default '0',
+ `delay` int(10) unsigned NOT NULL default '0',
+ `move_flag` tinyint(1) NOT NULL default '0',
+ `action` int(11) NOT NULL default '0',
+ `action_chance` smallint(3) NOT NULL default '100',
+ `wpguid` int(11) NOT NULL default '0'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `waypoint_scripts`;
+
+CREATE TABLE `waypoint_scripts` (
+ `id` int(11) unsigned NOT NULL default '0',
+ `delay` int(11) unsigned NOT NULL default '0',
+ `command` int(11) unsigned NOT NULL default '0',
+ `datalong` int(11) unsigned NOT NULL default '0',
+ `datalong2` int(11) unsigned NOT NULL default '0',
+ `dataint` int(11) unsigned NOT NULL default '0',
+ `x` float NOT NULL default '0',
+ `y` float NOT NULL default '0',
+ `z` float NOT NULL default '0',
+ `o` float NOT NULL default '0',
+ `guid` int(11) NOT NULL default '0',
+ PRIMARY KEY (`guid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+ALTER TABLE `creature_addon`
+ ADD `path_id` int(11) unsigned NOT NULL default '0' AFTER `guid`;
+ALTER TABLE `creature_template_addon`
+ ADD `path_id` int(11) unsigned NOT NULL default '0' AFTER `entry`;