ALTERTABLE`waypoint_data`ADDCOLUMN`id_old`int(10)unsignedNOTNULLdefault'0'COMMENT'CreatureGUID'AFTER`wpguid`;
UPDATE`waypoint_data`SET`id_old`=`id`*0.1;
REPLACEINTO`creature_addon`(`guid`)SELECT`id_old`FROM`waypoint_data`;
UPDATE`creature_addon``waypoint_data`SET`creature_addon`.`path_id`=`waypoint_data`.`id`WHERE`creature_addon`.`guid`=`waypoint_data`.`id_old`;
UPDATE`waypoint_data`SET`id_old`=`id`*0.1;
REPLACEINTO`creature_addon`(`guid`)SELECT`id_old`FROM`waypoint_data`;
UPDATE`creature_addon``waypoint_data`SET`creature_addon`.`path_id`=`waypoint_data`.`id`WHERE`creature_addon`.`guid`=`waypoint_data`.`id_old`;

