diff options
Diffstat (limited to 'sql/updates')
-rw-r--r-- | sql/updates/444_world.sql | 72 |
1 files changed, 36 insertions, 36 deletions
diff --git a/sql/updates/444_world.sql b/sql/updates/444_world.sql index ef9784e3666..004cf626f88 100644 --- a/sql/updates/444_world.sql +++ b/sql/updates/444_world.sql @@ -1,36 +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`;
+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`; |