DROP TABLE IF EXISTS `char_templates`;
CREATE TABLE `char_templates` (
  `ClassId` int(11) NOT NULL DEFAULT '0',
  `ClassName` varchar(25) NOT NULL DEFAULT '',
  `RaceId` int(1) NOT NULL DEFAULT '0',
  `STR` int(2) NOT NULL DEFAULT '0',
  `CON` int(2) NOT NULL DEFAULT '0',
  `DEX` int(2) NOT NULL DEFAULT '0',
  `_INT` int(2) NOT NULL DEFAULT '0',
  `WIT` int(2) NOT NULL DEFAULT '0',
  `MEN` int(2) NOT NULL DEFAULT '0',
  `P_ATK` int(3) NOT NULL DEFAULT '0',
  `P_DEF` int(3) NOT NULL DEFAULT '0',
  `M_ATK` int(3) NOT NULL DEFAULT '0',
  `M_DEF` int(2) NOT NULL DEFAULT '0',
  `MOVE_SPD` int(3) NOT NULL DEFAULT '0',
  `x` int(9) NOT NULL DEFAULT '0',
  `y` int(9) NOT NULL DEFAULT '0',
  `z` int(9) NOT NULL DEFAULT '0',
  `M_COL_R` decimal(3,1) NOT NULL DEFAULT '0.0',
  `M_COL_H` decimal(4,1) NOT NULL DEFAULT '0.0',
  `F_COL_R` decimal(3,1) NOT NULL DEFAULT '0.0',
  `F_COL_H` decimal(4,1) NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`ClassId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `char_templates` VALUES
(0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(1, 'Warrior', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(2, 'Gladiator', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(3, 'Warlord', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(4, 'Human Knight', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(5, 'Paladin', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(6, 'Dark Avenger', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(7, 'Rogue', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(8, 'Treasure Hunter', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(9, 'Hawkeye', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(10, 'Human Mystic', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(11, 'Human Wizard', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(12, 'Sorcerer', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(13, 'Necromancer', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(14, 'Warlock', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(15, 'Cleric', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(16, 'Bishop', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(17, 'Prophet', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(18, 'Elven Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(19, 'Elven Knight', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(20, 'Temple Knight', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(21, 'Sword Singer', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(22, 'Elven Scout', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(23, 'Plains Walker', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(24, 'Silver Ranger', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(25, 'Elven Mystic', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 122, 46182, 41198, -3440, 7.5, 24.0, 7.5, 23.0),
(26, 'Elven Wizard', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 122, 46182, 41198, -3440, 7.5, 24.0, 7.5, 23.0),
(27, 'Spellsinger', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 122, 46182, 41198, -3440, 7.5, 24.0, 7.5, 23.0),
(28, 'Elemental Summoner', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 122, 46182, 41198, -3440, 7.5, 24.0, 7.5, 23.0),
(29, 'Elven Oracle', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 122, 46182, 41198, -3440, 7.5, 24.0, 7.5, 23.0),
(30, 'Elven Elder', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 122, 46182, 41198, -3440, 7.5, 24.0, 7.5, 23.0),
(31, 'Dark Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(32, 'Palus Knight', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(33, 'Shillien Knight', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(34, 'Bladedancer', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(35, 'Assassin', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(36, 'Abyss Walker', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(37, 'Phantom Ranger', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(38, 'Dark Mystic', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 122, 28295, 11063, -4224, 7.5, 24.0, 7.0, 23.5),
(39, 'Dark Wizard', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 122, 28295, 11063, -4224, 7.5, 24.0, 7.0, 23.5),
(40, 'Spellhowler', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 122, 28295, 11063, -4224, 7.5, 24.0, 7.0, 23.5),
(41, 'Phantom Summoner', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 122, 28295, 11063, -4224, 7.5, 24.0, 7.0, 23.5),
(42, 'Shillien Oracle', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 122, 28295, 11063, -4224, 7.5, 24.0, 7.0, 23.5),
(43, 'Shillien Elder', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 122, 28295, 11063, -4224, 7.5, 24.0, 7.0, 23.5),
(44, 'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 117, -56693, -113610, -690, 11.0, 28.0, 7.0, 27.0),
(45, 'Orc Raider', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 117, -56693, -113610, -690, 11.0, 28.0, 7.0, 27.0),
(46, 'Destroyer', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 117, -56693, -113610, -690, 11.0, 28.0, 7.0, 27.0),
(47, 'Monk', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 117, -56682, -113610, -690, 11.0, 28.0, 7.0, 27.0),
(48, 'Tyrant', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 117, -56693, -113610, -690, 11.0, 28.0, 7.0, 27.0),
(49, 'Orc Mystic', 3, 27, 31, 24, 31, 15, 42, 3, 54, 6, 41, 121, -56682, -113730, -690, 7.0, 27.5, 8.0, 25.5),
(50, 'Orc Shaman', 3, 27, 31, 24, 31, 15, 42, 3, 54, 6, 41, 121, -56682, -113730, -690, 7.0, 27.5, 8.0, 25.5),
(51, 'Overlord', 3, 27, 31, 24, 31, 15, 42, 3, 54, 6, 41, 121, -56682, -113730, -690, 7.0, 27.5, 8.0, 25.5),
(52, 'Warcryer', 3, 27, 31, 24, 31, 15, 42, 3, 54, 6, 41, 121, -56682, -113730, -690, 7.0, 27.5, 8.0, 25.5),
(53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 115, 108512, -174026, -400, 9.0, 18.0, 5.0, 19.0),
(54, 'Scavenger', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 115, 108512, -174026, -400, 9.0, 18.0, 5.0, 19.0),
(55, 'Bounty Hunter', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 115, 108512, -174026, -400, 9.0, 18.0, 5.0, 19.0),
(56, 'Artisan', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 115, 108512, -174026, -400, 9.0, 18.0, 5.0, 19.0),
(57, 'Warsmith', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 115, 108512, -174026, -400, 9.0, 18.0, 5.0, 19.0),
(88, 'Duelist', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(89, 'Dreadnought', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(90, 'Phoenix Knight', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(91, 'Hell Knight', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(92, 'Sagittarius', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(93, 'Adventurer', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 115, -71338, 258271, -3104, 9.0, 23.0, 8.0, 23.5),
(94, 'Archmage', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(95, 'Soultaker', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(96, 'Arcana Lord', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(97, 'Cardinal', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(98, 'Hierophant', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 120, -90890, 248027, -3570, 7.5, 22.8, 6.5, 22.5),
(99, 'Eva\'s Templar', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(100, 'Sword Muse', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(101, 'Wind Rider', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(102, 'Moonlight Sentinel', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 125, 45978, 41196, -3440, 7.5, 24.0, 7.5, 23.0),
(103, 'Mystic Muse', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 122, 46182, 41198, -3440, 7.5, 24.0, 7.5, 23.0),
(104, 'Elemental Master', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 122, 46182, 41198, -3440, 7.5, 24.0, 7.5, 23.0),
(105, 'Eva\'s Saint', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 122, 46182, 41198, -3440, 7.5, 24.0, 7.5, 23.0),
(106, 'Shillien Templar', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(107, 'Spectral Dancer', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(108, 'Ghost Hunter', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(109, 'Ghost Sentinel', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 122, 28377, 10916, -4224, 7.5, 24.0, 7.0, 23.5),
(110, 'Storm Screamer', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 122, 28295, 11063, -4224, 7.5, 24.0, 7.0, 23.5),
(111, 'Spectral Master', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 122, 28295, 11063, -4224, 7.5, 24.0, 7.0, 23.5),
(112, 'Shillien Saint', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 122, 28295, 11063, -4224, 7.5, 24.0, 7.0, 23.5),
(113, 'Titan', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 117, -56693, -113610, -690, 11.0, 28.0, 7.0, 27.0),
(114, 'Grand Khavatari', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 117, -56693, -113610, -690, 11.0, 28.0, 7.0, 27.0),
(115, 'Dominator', 3, 27, 31, 24, 31, 15, 42, 3, 54, 6, 41, 121, -56682, -113730, -690, 7.0, 27.5, 8.0, 25.5),
(116, 'Doom Cryer', 3, 27, 31, 24, 31, 15, 42, 3, 54, 6, 41, 121, -56682, -113730, -690, 7.0, 27.5, 8.0, 25.5),
(117, 'Fortune Seeker', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 115, 108512, -174026, -400, 9.0, 18.0, 5.0, 19.0),
(118, 'Maestro', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 115, 108512, -174026, -400, 9.0, 18.0, 5.0, 19.0),
(123, 'Male Kamael Soldier', 5, 41, 31, 33, 29, 11, 25, 4, 80, 6, 41, 122, -125464, 37776, 1176, 8.0, 25.2, 7.0, 22.6),
(124, 'Female Kamael Soldier', 5, 39, 30, 35, 28, 11, 27, 4, 80, 6, 41, 122, -125517, 38267, 1176, 8.0, 22.6, 7.0, 22.6),
(125, 'Trooper', 5, 41, 31, 33, 29, 11, 25, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 25.2, 7.0, 22.6),
(126, 'Warder', 5, 39, 30, 35, 28, 11, 27, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 22.6, 7.0, 22.6),
(127, 'Berserker', 5, 41, 31, 33, 29, 11, 25, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 25.2, 7.0, 22.6),
(128, 'Male Soul Breaker', 5, 41, 31, 33, 29, 11, 25, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 25.2, 7.0, 22.6),
(129, 'Female Soul Breaker', 5, 39, 30, 35, 28, 11, 27, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 22.6, 7.0, 22.6),
(130, 'Arbalester', 5, 39, 30, 35, 28, 11, 27, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 22.6, 7.0, 22.6),
(131, 'Doombringer', 5, 41, 31, 33, 29, 11, 25, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 25.2, 7.0, 22.6),
(132, 'Male Soul Hound', 5, 41, 31, 33, 29, 11, 25, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 25.2, 7.0, 22.6),
(133, 'Female Soul Hound', 5, 39, 30, 35, 28, 11, 27, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 22.6, 7.0, 22.6),
(134, 'Trickster', 5, 39, 30, 35, 28, 11, 27, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 22.6, 7.0, 22.6),
(135, 'Inspector', 5, 39, 30, 35, 28, 11, 27, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 25.2, 7.0, 22.6),
(136, 'Judicator', 5, 39, 30, 35, 28, 11, 27, 4, 80, 6, 41, 122, -125533, 38114, 1142, 8.0, 25.2, 7.0, 22.6);