-- ---------------------------------------
-- Table structure for pledge_skill_trees
-- ---------------------------------------
DROP TABLE IF EXISTS `pledge_skill_trees`;
CREATE TABLE IF NOT EXISTS `pledge_skill_trees` (
  `skill_id` int(11) default NULL,
  `level` int(11) default NULL,
  `name` varchar(25) default NULL,
  `clan_lvl` int(11) default NULL,
  `Description` varchar(255) default NULL,
  `repCost` int(11) default NULL,
  `itemId` int(11) default NULL,
  `itemCount` int(11) DEFAULT NULL
) ENGINE = MYISAM DEFAULT CHARSET=utf8;

INSERT INTO `pledge_skill_trees` VALUES
-- Clan Level 5
(370,1,'Clan Body',5,'Increases clan members Max HP. It only effects those who are of an Heir class or higher',1500,9816,10),
(373,1,'Clan Regeneration',5,'Increases the clan members HP regeneration. Only affects Heir class and above',1500,9816,10),
(379,1,'Clan Magic Resistance',5,'Increases clan members M. Def. It only effects those who are of an Heir class or higher',1500,9818,10),
(391,1,'Clan Imperium',5,'Grants the privilege of Command Channel formation. It only effects Sage / Elder class and above',0,8176,1),
-- Clan Level 6
(371,1,'Clan Spirituality',6,'Increases clan members Max CP. It only effects those who are of a Baron class or higher',2100,9817,10),
(374,1,'Clan Morale',6,'Increases the clan members CP regeneration. Only affects Elder class and above',2600,9817,10),
(376,1,'Clan Might',6,'Increases the clan members P. Atk. Only affects Knight class and above',3000,9815,10),
(377,1,'Clan Shield',6,'Increases clan members P. Def. It only effects those who are of a Knight class or higher',3000,9816,10),
(383,1,'Clan Shield Block',6,'Increases clan members Shield P. Def. It only effects those who are of a Baron class or higher',2100,9815,10),
-- Clan Level 7
(370,2,'Clan Body',7,'Increases clan members Max HP. It only effects those who are of an Heir class or higher',6900,9816,10),
(371,2,'Clan Spirituality',7,'Increases clan members Max CP. It only effects those who are of a Baron class or higher',5600,9817,10),
(373,2,'Clan Regeneration',7,'Increases the clan members HP regeneration. Only affects Heir class and above',6900,9816,10),
(376,2,'Clan Might',7,'Increases the clan members P. Atk. Only affects Knight class and above',6500,9815,10),
(377,2,'Clan Shield',7,'Increases clan members P. Def. It only effects those who are of a Knight class or higher',6500,9816,10),
(379,2,'Clan Magic Resistance',7,'Increases clan members M. Def. It only effects those who are of an Heir class or higher',6900,9818,10),
(380,1,'Clan Guidance',7,'Increases the clan members Accuracy. Only affects Baron class and above',5600,9814,10),
(382,1,'Clan Shield Defense',7,'Increases clan members Shield defense probability. It only effects those who are of a Viscount class or higher',5100,9814,10),
(384,1,'Clan Cyclonic Resistance',7,'Increases clan members resistance to water and wind attacks. It only effects those who are of a Viscount class or higher',5100,8176,1),
(385,1,'Clan Magmatic Resistance',7,'Increase clan members resistance to fire/earth attacks. It only effects those who are of a Viscount class or higher',5100,8176,1),
(386,1,'Clan Resist Shock',7,'Increases the clan members resistance to shock attacks. Only affects Viscount class and above',5100,8176,1),
(387,1,'Clan Resist Hold',7,'Increases the clan members resistance to hold attacks. Only affects Viscount class and above',5100,8176,1),
(388,1,'Clan Resist Sleep',7,'Increases the clan members resistance to sleep attacks. Only affects Viscount class and above',5100,8176,1),
(390,1,'Clan Luck',7,'Decreases Exp. loss and the chance of other death penalties when killed by a monster or player. It only effects those who are of an Heir class or higher',6900,8175,1),
-- Clan Level 8
(371,3,'Clan Spirituality',8,'Increases clan members Max CP. It only effects those who are of a Baron class or higher',12000,9817,10),
(372,1,'Clan Soul',8,'Increases clan members Max MP. It only effects those who are of a Viscount class or higher',12000,9818,10),
(374,2,'Clan Morale',8,'Increases the clan members CP regeneration. Only affects Elder class and above',13000,9817,10),
(375,1,'Clan Clarity',8,'Increases the clan members MP regeneration. Only affects Viscount class and above',12000,9818,10),
(376,3,'Clan Might',8,'Increases the clan members P. Atk. Only affects Knight class and above',13000,9815,10),
(377,3,'Clan Shield',8,'Increases clan members P. Def. It only effects those who are of a Knight class or higher',13000,9816,10),
(378,1,'Clan Empower',8,'Increases clan members M. Atk. It only effects those who are of a Viscount class or higher',12000,9818,10),
(380,2,'Clan Guidance',8,'Increases the clan members Accuracy. Only affects Baron class and above',12000,9814,10),
(381,1,'Clan Agility',8,'Increases the clan members Evasion. Only affects Baron class and above',12000,9814,10),
(382,2,'Clan Shield Defense',8,'Increases clan members Shield defense probability. It only effects those who are of a Viscount class or higher',12000,9814,10),
(383,2,'Clan Shield Block',8,'Increases clan members Shield P. Def. It only effects those who are of a Baron class or higher',12000,9815,10),
(384,2,'Clan Cyclonic Resistance',8,'Increases clan members resistance to water and wind attacks. It only effects those who are of a Viscount class or higher',12000,8176,1),
(385,2,'Clan Magmatic Resistance',8,'Increase clan members resistance to fire/earth attacks. It only effects those who are of a Viscount class or higher',12000,8176,1),
(386,2,'Clan Resist Shock',8,'Increases the clan members resistance to shock attacks. Only affects Viscount class and above',12000,8176,1),
(387,2,'Clan Resist Hold',8,'Increases the clan members resistance to hold attacks. Only affects Viscount class and above',12000,8176,1),
(388,2,'Clan Resist Sleep',8,'Increases the clan members resistance to sleep attacks. Only affects Viscount class and above',12000,8176,1),
(389,1,'Clan Wind Walk',8,'Increases clan members Speed. It only effects those who are of a Count class or higher',11000,8175,1),
(390,2,'Clan Luck',8,'Decreases Exp. loss and the chance of other death penalties when killed by a monster or player. It only effects those who are of an Heir class or higher',14000,8175,1),
-- Clan Level 11
(370,3,'Clan Body',11,'A clan member\'s Max HP increases by 6%. Effect applies after member level.',13200,9816,10),
(373,3,'Clan Regeneration',11,'A clan member\'s HP recovery bonus increases by 6%. Effect applies after member level.',13200,9816,10),
(379,3,'Clan Magic Resistance',11,'A clan member\'s M. Def. increases by 12%. Effect applies after member level.',13200,9818,10);
