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',
  `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`;