l2j-server-datapack/sql/character_skills_save.sql

-- ---------------------------
-- Table structure for character_skills
-- ---------------------------
CREATE TABLE IF NOT EXISTS `character_skills_save` (
  `charId` INT NOT NULL default 0,
  `skill_id` INT NOT NULL default 0,
  `skill_level` INT(3) NOT NULL default 1,
  `effect_count` INT NOT NULL default 0,
  `effect_cur_time` INT NOT NULL default 0,
  `reuse_delay` INT(8) NOT NULL DEFAULT 0,
  `systime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
  `restore_type` INT(1) NOT NULL DEFAULT 0,
  `class_index` INT(1) NOT NULL DEFAULT 0,
  `buff_index` INT(2) NOT NULL default 0,
  PRIMARY KEY (`charId`,`skill_id`,`class_index`)
);