rendered paste bodyDROP 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',
`datatext` text NOT NULL,
`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;
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',
`event_id` int(11) NOT NULL default '0',
`event_chance` smallint(3) NOT NULL default '100',
`wpguid` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `waypoint_event`;
CREATE TABLE `waypoint_event` (
`guid` int(10) unsigned NOT NULL,
`event` smallint(6) NOT NULL,
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `creature_formations`;
CREATE TABLE `creature_formations` (
`follower` int(10) unsigned NOT NULL default '0',
`leader` int(10) unsigned NOT NULL default '0',
`offset_angle` float unsigned NOT NULL default '0',
`offset_dist` float unsigned NOT NULL default '0',
PRIMARY KEY (`follower`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `creature_addon` ADD `path_id` INT(11) NOT NULL DEFAULT 0 AFTER `guid`;
ALTER TABLE `creature_template_addon` ADD `path_id` INT(11) NOT NULL DEFAULT 0 AFTER `entry`;