ftSFqmyy

1DROP TABLE IF EXISTS `waypoint_data_temp`;
2CREATE TABLE IF NOT EXISTS `waypoint_data_temp` (
3  `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature GUID',
4  `point` mediumint(8) unsigned NOT NULL DEFAULT '0',
5  `position_x` float NOT NULL DEFAULT '0',
6  `position_y` float NOT NULL DEFAULT '0',
7  `position_z` float NOT NULL DEFAULT '0',
8  `orientation` float NOT NULL DEFAULT '0',
9  `delay` int(10) unsigned NOT NULL DEFAULT '0',
10  `move_flag` tinyint(1) NOT NULL DEFAULT '0',
11  `action` int(11) NOT NULL DEFAULT '0',
12  `action_chance` smallint(3) NOT NULL DEFAULT '100',
13  `wpguid` int(11) NOT NULL DEFAULT '0'
14) ENGINE=MyISAM DEFAULT CHARSET=utf8;
15
16
17INSERT INTO `waypoint_data_temp` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_flag`, `action`, `action_chance`, `wpguid`) SELECT
18`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_flag`, `action`, `action_chance`, `wpguid`
19FROM `waypoint_data` WHERE `point`;
20
21
22DROP TABLE `waypoint_data`;
23UPDATE `waypoint_data_temp` SET `point`=(`point` - 1);
24RENAME TABLE `waypoint_data_temp` TO `waypoint_data`;