DELIMITER ;;
CREATE DEFINER=`dayz`@`%` PROCEDURE `proc_insertSurvivor`(IN `p_uniqueId` varchar(128), IN `p_playerName` varchar(255))
begin
  insert into profile
    (unique_id, name)
  values
    (p_uniqueId, p_playerName)
  on duplicate key update name = p_playerName;
  insert into survivor
    (unique_id, start_time)
  values
    (p_uniqueId, now());
  select last_insert_id();
end;;
DELIMITER ;