l2j-server-datapack/L2J_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,
  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`)
) ;