special_skill_trees.sql 664 B

12345678910111213141516
  1. DROP TABLE IF EXISTS `special_skill_trees`;
  2. CREATE TABLE IF NOT EXISTS `special_skill_trees` (
  3. `skill_id` int(10) NOT NULL default '0',
  4. `level` int(10) NOT NULL default '0',
  5. `name` varchar(25) NOT NULL default '',
  6. `costid` int(10) NOT NULL default '0',
  7. `cost` int(10) NOT NULL default '0',
  8. `learned_by_npc` enum('true','false') DEFAULT 'true' NOT NULL,
  9. `learned_by_fs` enum('true','false') DEFAULT 'false' NOT NULL,
  10. PRIMARY KEY (`skill_id`,`level`)
  11. );
  12. INSERT INTO `special_skill_trees` VALUES
  13. (932,1,'Star Stone',13728,1,'false','true'),
  14. (932,2,'Star Stone',57,400000,'true','false'),
  15. (932,3,'Star Stone',57,1200000,'true','false');