SET autocommit = 0;
START TRANSACTION;
ALTER TABLE creature ADD COLUMN new_guid INTEGER FIRST;

SET @i = 0;
UPDATE creature SET new_guid=(@i:=@i+1);

UPDATE creature_addon ca, creature c SET ca.guid = c.new_guid WHERE ca.guid = c.guid;
UPDATE creature_ai_scripts cas, creature c SET cas.entryOrGUID = -(c.new_guid) WHERE cas.entryOrGUID < 0 AND cas.entryOrGUID = -(c.guid);
UPDATE creature_formations cf, creature c SET cf.leaderGUID = c.new_guid WHERE cf.leaderGUID = c.guid;
UPDATE creature_formations cf, creature c SET cf.memberGUID = c.new_guid WHERE cf.memberGUID = c.guid;
UPDATE creature_linked_respawn clr, creature c SET clr.guid = c.new_guid WHERE clr.guid = c.guid;
UPDATE creature_linked_respawn clr, creature c SET clr.linkedGUID = c.new_guid WHERE clr.linkedGUID = c.guid;
UPDATE creature_respawn cr, creature c SET cr.guid = c.new_guid WHERE cr.guid = c.guid;
UPDATE game_event_creature g, creature c SET g.guid = c.new_guid WHERE g.guid = c.guid;
UPDATE game_event_creature_data g, creature c SET g.guid = c.new_guid WHERE g.guid = c.guid;
UPDATE game_event_model_equip g, creature c SET g.guid = c.new_guid WHERE g.guid = c.guid;
UPDATE game_event_npc_gossip g, creature c SET g.guid = c.new_guid WHERE g.guid = c.guid;
UPDATE game_event_npc_vendor g, creature c SET g.guid = c.new_guid WHERE g.guid = c.guid;
UPDATE game_event_npcflag g, creature c SET g.guid = c.new_guid WHERE g.guid = c.guid;
UPDATE npc_gossip g, creature c SET g.npc_guid = c.new_guid WHERE g.npc_guid = c.guid;
UPDATE pool_creature g, creature c SET g.guid = c.new_guid WHERE g.guid = c.guid;
UPDATE creature SET guid = new_guid;
ALTER TABLE creature DROP COLUMN new_guid;

COMMIT;