l2j-server-datapack/L2J_DataPack_BETA/sql/server/fishing_skill_trees.sql

DROP TABLE IF EXISTS `fishing_skill_trees`;
CREATE TABLE IF NOT EXISTS `fishing_skill_trees` (
  `skill_id` int(10) NOT NULL default '0',
  `level` int(10) NOT NULL default '0',
  `name` varchar(25) NOT NULL default '',
  `sp` int(10) NOT NULL default '0',
  `min_level` int(10) NOT NULL default '0',
  `costid` int(10) NOT NULL default '0',
  `cost` int(10) NOT NULL default '0',
  `is_for_dwarf` enum('true','false') DEFAULT 'false' NOT NULL,
  `learned_by_npc` enum('true','false') DEFAULT 'true' NOT NULL,
  `learned_by_fs` enum('true','false') DEFAULT 'false' NOT NULL,
  PRIMARY KEY (`skill_id`,`level`)
);

INSERT INTO `fishing_skill_trees` VALUES
(1313,1,'Pumping',0,1,57,10,'false','true','false'),
(1313,2,'Pumping',0,4,57,50,'false','true','false'),
(1313,3,'Pumping',0,7,57,200,'false','true','false'),
(1313,4,'Pumping',0,10,57,300,'false','true','false'),
(1313,5,'Pumping',0,13,57,500,'false','true','false'),
(1313,6,'Pumping',0,16,57,800,'false','true','false'),
(1313,7,'Pumping',0,19,57,1600,'false','true','false'),
(1313,8,'Pumping',0,22,57,2600,'false','true','false'),
(1313,9,'Pumping',0,25,57,4000,'false','true','false'),
(1313,10,'Pumping',0,28,57,6700,'false','true','false'),
(1313,11,'Pumping',0,31,57,8000,'false','true','false'),
(1313,12,'Pumping',0,34,57,10000,'false','true','false'),
(1313,13,'Pumping',0,37,57,16000,'false','true','false'),
(1313,14,'Pumping',0,40,57,23000,'false','true','false'),
(1313,15,'Pumping',0,43,57,30000,'false','true','false'),
(1313,16,'Pumping',0,46,57,40000,'false','true','false'),
(1313,17,'Pumping',0,49,57,53000,'false','true','false'),
(1313,18,'Pumping',0,52,57,66000,'false','true','false'),
(1313,19,'Pumping',0,55,57,80000,'false','true','false'),
(1313,20,'Pumping',0,58,57,93000,'false','true','false'),
(1313,21,'Pumping',0,61,57,100000,'false','true','false'),
(1313,22,'Pumping',0,64,57,120000,'false','true','false'),
(1313,23,'Pumping',0,67,57,130000,'false','true','false'),
(1313,24,'Pumping',0,70,57,140000,'false','true','false'),
(1313,25,'Pumping',0,73,57,160000,'false','true','false'),
(1313,26,'Pumping',0,76,57,173000,'false','true','false'),
(1313,27,'Pumping',0,79,57,185000,'false','true','false'),
(1314,1,'Reeling',0,1,57,10,'false','true','false'),
(1314,2,'Reeling',0,4,57,50,'false','true','false'),
(1314,3,'Reeling',0,7,57,200,'false','true','false'),
(1314,4,'Reeling',0,10,57,300,'false','true','false'),
(1314,5,'Reeling',0,13,57,500,'false','true','false'),
(1314,6,'Reeling',0,16,57,800,'false','true','false'),
(1314,7,'Reeling',0,19,57,1600,'false','true','false'),
(1314,8,'Reeling',0,22,57,2600,'false','true','false'),
(1314,9,'Reeling',0,25,57,4000,'false','true','false'),
(1314,10,'Reeling',0,28,57,6700,'false','true','false'),
(1314,11,'Reeling',0,31,57,8000,'false','true','false'),
(1314,12,'Reeling',0,34,57,10000,'false','true','false'),
(1314,13,'Reeling',0,37,57,16000,'false','true','false'),
(1314,14,'Reeling',0,40,57,23000,'false','true','false'),
(1314,15,'Reeling',0,43,57,30000,'false','true','false'),
(1314,16,'Reeling',0,46,57,40000,'false','true','false'),
(1314,17,'Reeling',0,49,57,53000,'false','true','false'),
(1314,18,'Reeling',0,52,57,66000,'false','true','false'),
(1314,19,'Reeling',0,55,57,80000,'false','true','false'),
(1314,20,'Reeling',0,58,57,93000,'false','true','false'),
(1314,21,'Reeling',0,61,57,100000,'false','true','false'),
(1314,22,'Reeling',0,64,57,120000,'false','true','false'),
(1314,23,'Reeling',0,67,57,130000,'false','true','false'),
(1314,24,'Reeling',0,70,57,140000,'false','true','false'),
(1314,25,'Reeling',0,73,57,160000,'false','true','false'),
(1314,26,'Reeling',0,76,57,173000,'false','true','false'),
(1314,27,'Reeling',0,79,57,185000,'false','true','false'),
(1315,1,'Fishing Expertise',0,1,57,10,'false','true','false'),
(1315,2,'Fishing Expertise',0,4,57,50,'false','true','false'),
(1315,3,'Fishing Expertise',0,7,57,200,'false','true','false'),
(1315,4,'Fishing Expertise',0,10,57,300,'false','true','false'),
(1315,5,'Fishing Expertise',0,13,57,500,'false','true','false'),
(1315,6,'Fishing Expertise',0,16,57,800,'false','true','false'),
(1315,7,'Fishing Expertise',0,19,57,1600,'false','true','false'),
(1315,8,'Fishing Expertise',0,22,57,2600,'false','true','false'),
(1315,9,'Fishing Expertise',0,25,57,4000,'false','true','false'),
(1315,10,'Fishing Expertise',0,28,57,6700,'false','true','false'),
(1315,11,'Fishing Expertise',0,31,57,8000,'false','true','false'),
(1315,12,'Fishing Expertise',0,34,57,10000,'false','true','false'),
(1315,13,'Fishing Expertise',0,37,57,16000,'false','true','false'),
(1315,14,'Fishing Expertise',0,40,57,23000,'false','true','false'),
(1315,15,'Fishing Expertise',0,43,57,30000,'false','true','false'),
(1315,16,'Fishing Expertise',0,46,57,40000,'false','true','false'),
(1315,17,'Fishing Expertise',0,49,57,53000,'false','true','false'),
(1315,18,'Fishing Expertise',0,52,57,66000,'false','true','false'),
(1315,19,'Fishing Expertise',0,55,57,80000,'false','true','false'),
(1315,20,'Fishing Expertise',0,58,57,93000,'false','true','false'),
(1315,21,'Fishing Expertise',0,61,57,100000,'false','true','false'),
(1315,22,'Fishing Expertise',0,64,57,120000,'false','true','false'),
(1315,23,'Fishing Expertise',0,67,57,130000,'false','true','false'),
(1315,24,'Fishing Expertise',0,70,57,140000,'false','true','false'),
(1315,25,'Fishing Expertise',0,73,57,160000,'false','true','false'),
(1315,26,'Fishing Expertise',0,76,57,173000,'false','true','false'),
(1315,27,'Fishing Expertise',0,79,57,185000,'false','true','false'),
(1368,1,'Expand Dwarven Craft',0,5,7609,2000,'true','true','false'),
(1368,2,'Expand Dwarven Craft',0,20,7609,4000,'true','true','false'),
(1368,3,'Expand Dwarven Craft',0,28,7609,6000,'true','true','false'),
(1368,4,'Expand Dwarven Craft',0,36,7609,10000,'true','true','false'),
(1368,5,'Expand Dwarven Craft',0,43,7609,10000,'true','true','false'),
(1368,6,'Expand Dwarven Craft',0,49,7609,10000,'true','true','false'),
(1368,7,'Expand Dwarven Craft',0,55,7609,20000,'true','true','false'),
(1368,8,'Expand Dwarven Craft',0,62,7609,20000,'true','true','false'),
(1369,1,'Expand Common Craft',0,10,7609,2000,'false','true','false'),
(1369,2,'Expand Common Craft',0,20,7609,4000,'false','true','false'),
(1369,3,'Expand Common Craft',0,30,7609,6000,'false','true','false'),
(1369,4,'Expand Common Craft',0,40,7609,10000,'false','true','false'),
(1369,5,'Expand Common Craft',0,50,7609,10000,'false','true','false'),
(1369,6,'Expand Common Craft',0,60,7609,10000,'false','true','false'),
(1369,7,'Expand Common Craft',0,70,7609,20000,'false','true','false'),
(1369,8,'Expand Common Craft',0,80,7609,20000,'false','true','false'),
(1370,1,'Expand Trade',0,40,7609,10000,'false','true','false'),
(1370,2,'Expand Trade',0,55,7609,20000,'false','true','false'),
(1370,3,'Expand Trade',0,65,7609,40000,'false','true','false'),
(1371,1,'Expand Storage',0,10,7609,4000,'false','true','false'),
(1371,2,'Expand Storage',0,20,7609,8000,'false','true','false'),
(1371,3,'Expand Storage',0,30,7609,20000,'false','true','false'),
(1371,4,'Expand Storage',0,40,7609,20000,'false','true','false'),
(1371,5,'Expand Storage',0,50,7609,60000,'false','true','false'),
(1371,6,'Expand Storage',0,60,7609,60000,'false','true','false'),
(1371,7,'Expand Storage',0,70,7609,100000,'false','true','false'),
(1371,8,'Expand Storage',0,80,7609,100000,'false','true','false'),
(1372,1,'Expand Inventory',0,10,7609,4000,'false','true','false'),
(1372,2,'Expand Inventory',0,20,7609,8000,'false','true','false'),
(1372,3,'Expand Inventory',0,30,7609,20000,'false','true','false'),
(1372,4,'Expand Inventory',0,40,7609,20000,'false','true','false'),
(1372,5,'Expand Inventory',0,50,7609,60000,'false','true','false'),
(1372,6,'Expand Inventory',0,60,7609,60000,'false','true','false'),
(1372,7,'Expand Inventory',0,70,7609,100000,'false','true','false'),
(1372,8,'Expand Inventory',0,80,7609,100000,'false','true','false'),
(1312,1,'Fishing',0,1,57,1000,'false','true','false');