DROP TABLE IF EXISTS `enchant_skill_groups`;
CREATE TABLE `enchant_skill_groups` (
  `group_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `level` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `adena` mediumint(6) unsigned NOT NULL DEFAULT '0',
  `exp` mediumint(7) unsigned DEFAULT NULL,
  `sp` mediumint(7) unsigned DEFAULT NULL,
  `success_rate76` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `success_rate77` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `success_rate78` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `success_rate79` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `success_rate80` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `success_rate81` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `success_rate82` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `success_rate83` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `success_rate84` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `success_rate85` tinyint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`group_id`,`level`)
);

INSERT INTO `enchant_skill_groups` VALUES
-- 2nd Class Buffs Debuffs Toogle and Summons
-- group_id level adena  exp sp       success_rate76 77 78 79 80 81 82 83 84 85
  (1,       1,    74250, 0,  575980,              82,92,97,97,97,97,97,97,97,97),
  (1,       2,    74250, 0,  575980,              80,90,95,95,95,95,95,95,95,95),
  (1,       3,    74250, 0,  575980,              78,88,93,93,93,93,93,93,93,93),
  (1,       4,    112050,0,  604535,              52,76,86,91,91,91,91,91,91,91),
  (1,       5,    112050,0,  604535,              50,74,84,89,89,89,89,89,89,89),
  (1,       6,    112050,0,  604535,              48,72,82,87,87,87,87,87,87,87),
  (1,       7,    150300,0,  634020,              22,46,70,80,85,85,85,85,85,85),
  (1,       8,    150300,0,  634020,              20,44,68,78,83,83,83,83,83,83),
  (1,       9,    150300,0,  634020,              18,42,66,76,81,81,81,81,81,81),
  (1,       10,   189000,0,  680020,              6, 16,40,64,74,79,79,79,79,79),
  (1,       11,   189000,0,  680020,              4, 14,38,62,72,77,77,77,77,77),
  (1,       12,   189000,0,  680020,              2, 12,36,60,70,75,75,75,75,75),
  (1,       13,   228150,0,  711890,              1, 4, 10,34,58,68,73,73,73,73),
  (1,       14,   228150,0,  711890,              1, 3, 8, 32,56,66,71,71,71,71),
  (1,       15,   228150,0,  711890,              1, 2, 6, 30,54,64,69,69,69,69),
  (1,       16,   267750,0,  761540,              1, 1, 2, 4, 28,52,62,67,67,67),
  (1,       17,   267750,0,  761540,              1, 1, 2, 2, 26,50,60,65,65,65),
  (1,       18,   267750,0,  761540,              1, 1, 2, 1, 24,48,58,63,63,63),
  (1,       19,   307800,0,  795890,              1, 1, 1, 1, 4, 22,46,56,61,61),
  (1,       20,   307800,0,  795890,              1, 1, 1, 1, 3, 20,44,54,59,59),
  (1,       21,   307800,0,  795890,              1, 1, 1, 1, 2, 18,42,52,57,57),
  (1,       22,   348300,0,  849330,              1, 1, 1, 1, 2, 6, 16,40,50,55),
  (1,       23,   348300,0,  849330,              1, 1, 1, 1, 1, 4, 14,38,48,53),
  (1,       24,   348300,0,  849330,              0, 1, 1, 1, 1, 2, 12,36,46,51),
  (1,       25,   389250,0,  886255,              0, 1, 1, 1, 1, 1, 4, 10,34,44),
  (1,       26,   389250,0,  886255,              0, 1, 1, 1, 1, 1, 2, 8, 32,42),
  (1,       27,   389250,0,  886255,              0, 0, 1, 1, 1, 1, 1, 6, 30,40),
  (1,       28,   430650,0,  943620,              0, 0, 1, 1, 1, 1, 1, 1, 4, 28),
  (1,       29,   430650,0,  943620,              0, 0, 1, 1, 1, 1, 1, 1, 2, 26),
  (1,       30,   430650,0,  943620,              0, 0, 0, 0, 1, 1, 1, 1, 1, 24),

-- 2nd Class Cubic and Attack Type Skills
-- group_id level adena  exp sp       success_rate76 77 78 79 80 81 82 83 84 85
  (2,       1,    133650,0,  1036764,              82,92,97,97,97,97,97,97,97,97),
  (2,       2,    133650,0,  1036764,              80,90,95,95,95,95,95,95,95,95),
  (2,       3,    133650,0,  1036764,              78,88,93,93,93,93,93,93,93,93),
  (2,       4,    201690,0,  1088163,              52,76,86,91,91,91,91,91,91,91),
  (2,       5,    201690,0,  1088163,              50,74,84,89,89,89,89,89,89,89),
  (2,       6,    201690,0,  1088163,              48,72,82,87,87,87,87,87,87,87),
  (2,       7,    270540,0,  1141236,              22,46,70,80,85,85,85,85,85,85),
  (2,       8,    270540,0,  1141236,              20,44,68,78,83,83,83,83,83,83),
  (2,       9,    270540,0,  1141236,              18,42,66,76,81,81,81,81,81,81),
  (2,       10,   340200,0,  1224036,             6, 16,40,64,74,79,79,79,79,79),
  (2,       11,   340200,0,  1224036,             4, 14,38,62,72,77,77,77,77,77),
  (2,       12,   340200,0,  1224036,             2, 12,36,60,70,75,75,75,75,75),
  (2,       13,   410670,0,  1281402,             1, 4, 10,34,58,68,73,73,73,73),
  (2,       14,   410670,0,  1281402,             1, 3, 8, 32,56,66,71,71,71,71),
  (2,       15,   410670,0,  1281402,             1, 2, 6, 30,54,64,69,69,69,69),
  (2,       16,   481950,0,  1370772,             1, 1, 2, 4, 28,52,62,67,67,67),
  (2,       17,   481950,0,  1370772,             1, 1, 2, 2, 26,50,60,65,65,65),
  (2,       18,   481950,0,  1370772,             1, 1, 2, 1, 24,48,58,63,63,63),
  (2,       19,   554040,0,  1432602,             1, 1, 1, 1, 4, 22,46,56,61,61),
  (2,       20,   554040,0,  1432602,             1, 1, 1, 1, 3, 20,44,54,59,59),
  (2,       21,   554040,0,  1432602,             1, 1, 1, 1, 2, 18,42,52,57,57),
  (2,       22,   626940,0,  1528794,             1, 1, 1, 1, 2, 6, 16,40,50,55),
  (2,       23,   626940,0,  1528794,             1, 1, 1, 1, 1, 4, 14,38,48,53),
  (2,       24,   626940,0,  1528794,             0, 1, 1, 1, 1, 2, 12,36,46,51),
  (2,       25,   700650,0,  1595259,             0, 1, 1, 1, 1, 1, 4, 10,34,44),
  (2,       26,   700650,0,  1595259,             0, 1, 1, 1, 1, 1, 2, 8, 32,42),
  (2,       27,   700650,0,  1595259,             0, 0, 1, 1, 1, 1, 1, 6, 30,40),
  (2,       28,   775170,0,  1698516,             0, 0, 1, 1, 1, 1, 1, 1, 4, 28),
  (2,       29,   775170,0,  1698516,             0, 0, 1, 1, 1, 1, 1, 1, 2, 26),
  (2,       30,   775170,0,  1698516,             0, 0, 0, 0, 1, 1, 1, 1, 1, 24),

-- 3rd Class Buffs, Debuffs, Toggles
-- group_id level adena  exp sp       success_rate76 77 78 79 80 81 82 83 84 85
  (5,       1,    481950,0,  1370772,             18,28,38,48,58,82,92,97,97,97),
  (5,       2,    481950,0,  1370772,             2, 1, 1, 46,56,80,90,95,95,95),
  (5,       3,    481950,0,  1370772,             2, 1, 1, 1, 54,78,88,93,93,93),
  (5,       4,    554040,0,  1432602,             2, 1, 1, 1, 42,52,76,86,91,91),
  (5,       5,    554040,0,  1432602,             1, 1, 1, 1, 1, 50,74,84,89,89),
  (5,       6,    554040,0,  1432602,             1, 1, 1, 1, 1, 48,72,82,87,87),
  (5,       7,    626940,0,  1528794,             0, 1, 1, 1, 1, 1, 46,70,80,85),
  (5,       8,    626940,0,  1528794,             0, 1, 1, 1, 1, 1, 44,68,78,83),
  (5,       9,    626940,0,  1528794,             0, 1, 1, 1, 1, 1, 42,66,76,81),
  (5,       10,   700650,0,  1595259,             0, 0, 1, 1, 1, 1, 1, 40,64,74),
  (5,       11,   700650,0,  1595259,             0, 0, 1, 1, 1, 1, 1, 38,62,72),
  (5,       12,   700650,0,  1595259,             0, 0, 1, 1, 1, 1, 1, 36,60,70),
  (5,       13,   775170,0,  1698516,             0, 0, 0, 1, 1, 1, 1, 1, 34,58),
  (5,       14,   775170,0,  1698516,             0, 0, 0, 1, 1, 1, 1, 1, 32,56),
  (5,       15,   775170,0,  1698516,             0, 0, 0, 1, 1, 1, 1, 1, 30,54),

-- 3rd Class Attack Type skills
-- group_id level adena  exp sp       success_rate76 77 78 79 80 81 82 83 84 85
  (6,       1,    481950,0,  1370772,             18,28,38,48,58,82,92,97,97,97),
  (6,       2,    481950,0,  1370772,             2, 1, 1, 46,56,80,90,95,95,95),
  (6,       3,    481950,0,  1370772,             2, 1, 1, 1, 54,78,88,93,93,93),
  (6,       4,    554040,0,  1432602,             2, 1, 1, 1, 42,52,76,86,91,91),
  (6,       5,    554040,0,  1432602,             1, 1, 1, 1, 1, 50,74,84,89,89),
  (6,       6,    554040,0,  1432602,             1, 1, 1, 1, 1, 48,72,82,87,87),
  (6,       7,    626940,0,  1528794,             0, 1, 1, 1, 1, 1, 46,70,80,85),
  (6,       8,    626940,0,  1528794,             0, 1, 1, 1, 1, 1 ,44,68,78,83),
  (6,       9,    626940,0,  1528794,             0, 1, 1, 1, 1, 1, 42,66,76,81),
  (6,       10,   700650,0,  1595259,             0, 0, 1, 1, 1, 1, 1, 40,64,74),
  (6,       11,   700650,0,  1595259,             0, 0, 1, 1, 1, 1, 1, 38,62,72),
  (6,       12,   700650,0,  1595259,             0, 0, 1, 1, 1, 1, 1, 36,60,70),
  (6,       13,   775170,0,  1698516,             0, 0, 0, 1, 1, 1, 1, 1, 34,58),
  (6,       14,   775170,0,  1698516,             0, 0, 0, 1, 1, 1, 1, 1, 32,56),
  (6,       15,   775170,0,  1698516,             0, 0, 0, 1, 1, 1, 1, 1, 30,54),

-- old L2J Group
-- group_id level adena  exp sp       success_rate76 77 78 79 80 81 82 83 84 85
  (30,      1,    102000,0,  306000,              82,92,97,97,97,97,97,97,97,97),
  (30,      2,    105000,0,  315000,              80,90,95,95,95,95,95,95,95,95),
  (30,      3,    108333,0,  325000,              78,88,93,93,93,93,93,93,93,93),
  (30,      4,    115333,0,  346000,              38,82,91,91,91,91,91,91,91,91),
  (30,      5,    119000,0,  357000,              30,80,89,89,89,89,89,89,89,89),
  (30,      6,    122667,0,  368000,              20,78,78,78,87,87,87,87,87,87),
  (30,      7,    130000,0,  390000,              14,38,70,70,85,85,85,85,85,85),
  (30,      8,    134000,0,  402000,              10,30,68,68,83,83,83,83,83,83),
  (30,      9,    138000,0,  414000,              6, 20,66,66,81,81,81,81,81,81),
  (30,      10,   169000,0,  507000,              6, 14,38,38,74,74,74,74,74,74),
  (30,      11,   174333,0,  523000,              2, 10,30,30,72,72,72,72,72,72),
  (30,      12,   179333,0,  538000,              2, 6, 20,20,70,70,70,70,70,70),
  (30,      13,   219667,0,  659000,              2, 2, 14,14,58,58,58,58,58,58),
  (30,      14,   226667,0,  680000,              1, 2, 10,10,56,56,56,56,56,56),
  (30,      15,   233000,0,  699000,              1, 2, 6, 6, 54,54,54,54,54,54),
  (30,      16,   285667,0,  857000,              1, 1, 2, 2, 28,28,28,28,28,28),
  (30,      17,   294667,0,  884000,              1, 1, 2, 2, 20,20,20,20,20,20),
  (30,      18,   303000,0,  909000,              1, 1, 2, 2, 14,14,14,14,14,14),
  (30,      19,   371333,0,  1114000,             1, 1, 1, 1, 6, 6, 6, 6, 6, 6),
  (30,      20,   383000,0,  1149000,             1, 1, 1, 1, 2, 2, 2, 2, 2, 2),
  (30,      21,   394000,0,  1182000,             1, 1, 1, 1, 2, 2, 2, 2, 2, 2),
  (30,      22,   483667,0,  1448000,             1, 1, 1, 1, 2, 2, 2, 2, 2, 2),
  (30,      23,   498000,0,  1494000,             1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
  (30,      24,   512333,0,  1537000,             0, 1, 1, 1, 1, 1, 1, 1, 1, 1),
  (30,      25,   627333,0,  1882000,             0, 1, 1, 1, 1, 1, 1, 1, 1, 1),
  (30,      26,   647333,0,  1942000,             0, 1, 1, 1, 1, 1, 1, 1, 1, 1),
  (30,      27,   666000,0,  1998000,             0, 0, 1, 1, 1, 1, 1, 1, 1, 1),
  (30,      28,   815667,0,  2447000,             0, 0, 1, 1, 1, 1, 1, 1, 1, 1),
  (30,      29,   841667,0,  2525000,             0, 0, 1, 1, 1, 1, 1, 1, 1, 1),
  (30,      30,   865667,0,  2597000,             0, 0, 0, 0, 1, 1, 1, 1, 1, 1);