class_list.sql 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112
  1. DROP TABLE IF EXISTS `class_list`;
  2. CREATE TABLE `class_list` (
  3. `class_name` varchar(20) NOT NULL DEFAULT '',
  4. `id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  5. `parent_id` smallint(3) NOT NULL DEFAULT '0',
  6. PRIMARY KEY (`id`)
  7. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  8. INSERT INTO `class_list` VALUES
  9. ('H_Fighter', 0, -1),
  10. ('H_Warrior', 1, 0),
  11. ('H_Gladiator', 2, 1),
  12. ('H_Duelist', 88, 2),
  13. ('H_Warlord', 3, 1),
  14. ('H_Dreadnought', 89, 3),
  15. ('H_Knight', 4, 0),
  16. ('H_Paladin', 5, 4),
  17. ('H_PhoenixKnight', 90, 5),
  18. ('H_DarkAvenger', 6, 4),
  19. ('H_HellKnight', 91, 6),
  20. ('H_Rogue', 7, 0),
  21. ('H_TreasureHunter', 8, 7),
  22. ('H_Adventurer', 93, 8),
  23. ('H_Hawkeye', 9, 7),
  24. ('H_Sagittarius', 92, 9),
  25. ('H_Mage', 10, -1),
  26. ('H_Wizard', 11, 10),
  27. ('H_Sorceror', 12, 11),
  28. ('H_Archmage', 94, 12),
  29. ('H_Necromancer', 13, 11),
  30. ('H_Soultaker', 95, 13),
  31. ('H_Warlock', 14, 11),
  32. ('H_ArcanaLord', 96, 14),
  33. ('H_Cleric', 15, 10),
  34. ('H_Bishop', 16, 15),
  35. ('H_Cardinal', 97, 16),
  36. ('H_Prophet', 17, 15),
  37. ('H_Hierophant', 98, 17),
  38. ('E_Fighter', 18, -1),
  39. ('E_Knight', 19, 18),
  40. ('E_TempleKnight', 20, 19),
  41. ('E_EvaTemplar', 99, 20),
  42. ('E_SwordSinger', 21, 19),
  43. ('E_SwordMuse', 100, 21),
  44. ('E_Scout', 22, 18),
  45. ('E_PlainsWalker', 23, 22),
  46. ('E_WindRider', 101, 23),
  47. ('E_SilverRanger', 24, 22),
  48. ('E_MoonlightSentinel', 102, 24),
  49. ('E_Mage', 25, -1),
  50. ('E_Wizard', 26, 25),
  51. ('E_SpellSinger', 27, 26),
  52. ('E_MysticMuse', 103, 27),
  53. ('E_ElementalSummoner', 28, 26),
  54. ('E_ElementalMaster', 104, 28),
  55. ('E_Oracle', 29, 25),
  56. ('E_Elder', 30, 29),
  57. ('E_EvaSaint', 105, 30),
  58. ('DE_Fighter', 31, -1),
  59. ('DE_PaulusKnight', 32, 31),
  60. ('DE_ShillienKnight', 33, 32),
  61. ('DE_ShillienTemplar', 106, 33),
  62. ('DE_BladeDancer', 34, 32),
  63. ('DE_SpectralDancer', 107, 34),
  64. ('DE_Assassin', 35, 31),
  65. ('DE_AbyssWalker', 36, 35),
  66. ('DE_GhostHunter', 108, 36),
  67. ('DE_PhantomRanger', 37, 35),
  68. ('DE_GhostSentinel', 109, 37),
  69. ('DE_Mage', 38, -1),
  70. ('DE_DarkWizard', 39, 38),
  71. ('DE_Spellhowler', 40, 39),
  72. ('DE_StormScreamer', 110, 40),
  73. ('DE_PhantomSummoner', 41, 39),
  74. ('DE_SpectralMaster', 111, 41),
  75. ('DE_ShillienOracle', 42, 38),
  76. ('DE_ShillienElder', 43, 42),
  77. ('DE_ShillienSaint', 112, 43),
  78. ('O_Fighter', 44, -1),
  79. ('O_Raider', 45, 44),
  80. ('O_Destroyer', 46, 45),
  81. ('O_Titan', 113, 46),
  82. ('O_Monk', 47, 44),
  83. ('O_Tyrant', 48, 47),
  84. ('O_GrandKhavatari', 114, 48),
  85. ('O_Mage', 49, -1),
  86. ('O_Shaman', 50, 49),
  87. ('O_Overlord', 51, 50),
  88. ('O_Dominator', 115, 51),
  89. ('O_Warcryer', 52, 50),
  90. ('O_Doomcryer', 116, 52),
  91. ('D_Fighter', 53, -1),
  92. ('D_Scavenger', 54, 53),
  93. ('D_BountyHunter', 55, 54),
  94. ('D_FortuneSeeker', 117, 55),
  95. ('D_Artisan', 56, 53),
  96. ('D_Warsmith', 57, 56),
  97. ('D_Maestro', 118, 57),
  98. ('K_Male_Soldier', 123, -1),
  99. ('K_Male_Trooper', 125, 123),
  100. ('K_Male_Berserker', 127, 125),
  101. ('K_Male_Doombringer', 131, 127),
  102. ('K_Male_Soulbreaker', 128, 125),
  103. ('K_Male_Soulhound', 132, 128),
  104. ('K_Female_Soldier', 124, -1),
  105. ('K_Female_Warder', 126, 124),
  106. ('K_Female_Soulbreaker', 129, 126),
  107. ('K_Female_Soulhound', 133, 129),
  108. ('K_Female_Arbalester', 130, 126),
  109. ('K_Female_Trickster', 134, 130),
  110. ('K_Inspector', 135, 126),
  111. ('K_Judicator', 136, 135);