 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 
 # Dumping structure for procedure galaxy.sp_CharacterCreate
+DROP PROCEDURE IF EXISTS `sp_CharacterCreate`;
 DELIMITER //
 CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_CharacterCreate`(IN `start_account_id` INT, IN `start_galaxy_id` INT, IN `start_firstname` char(32), IN `start_lastname` char(32), IN `start_custom_name` char(50), IN `start_profession` char(64), IN `start_city` char(32), IN `start_scale` FLOAT, IN `start_biography` text(2048), IN `start_appearance_customization` TINYBLOB, IN `start_hair_model` CHAR(64), IN `hair_customization` TEXT(200), IN `base_model_string` CHAR(64))
 charCreate:BEGIN
 
   DECLARE oX FLOAT;DECLARE oY FLOAT;DECLARE oZ FLOAT;DECLARE oW FLOAT;
   DECLARE race_id INT;
+  DECLARE iff_template_id INT;
   DECLARE object_id BIGINT(20);
   DECLARE player_id BIGINT(20);
   DECLARE character_id BIGINT(20);

  DECLARE profession_id INT;
  DECLARE start_scene INT;
  DECLARE start_x FLOAT;DECLARE start_y FLOAT;DECLARE start_z FLOAT;
  DECLARE shortSpecies CHAR(32);
  DECLARE shared_template_string CHAR(64);
  DECLARE model_position INT;
  DECLARE gender INT(3);

# --------------------------------------------------------
# Host:                         127.0.0.1
# Server version:               5.3.2-MariaDB
# Server OS:                    Win32
# HeidiSQL version:             6.0.0.3603
# Date/time:                    2011-10-16 13:54:25
# --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
