delete from `world-ascent`.creature_spawns;
insert into `world-ascent`.creature_spawns (
`position_x`,
`position_y`,
`position_z`,
orientation,
map,
entry,
movetype,
displayid)
select
`position_x`,
`position_y`,
`position_z`,
`orientation`,
`map`,
`id`,
`MovementType`,
modelid
from `mangos`.`creature`;

update `world-ascent`.creature_spawns set faction = (select faction from `world-ascent`.`creature_proto` where `entry`=`world-ascent`.creature_spawns.entry);
update `world-ascent`.creature_spawns set flags = (select npcflags from `world-ascent`.`creature_proto` where `entry`=`world-ascent`.creature_spawns.entry);