character_skills_save.sql 559 B

123456789101112131415
  1. -- ---------------------------
  2. -- Table structure for character_skills
  3. -- ---------------------------
  4. CREATE TABLE IF NOT EXISTS character_skills_save (
  5. charId INT NOT NULL default 0,
  6. skill_id INT NOT NULL default 0,
  7. skill_level INT(3) NOT NULL default 1,
  8. effect_count INT NOT NULL default 0,
  9. effect_cur_time INT NOT NULL default 0,
  10. reuse_delay INT(8) NOT NULL DEFAULT 0,
  11. restore_type INT(1) NOT NULL DEFAULT 0,
  12. `class_index` INT(1) NOT NULL DEFAULT 0,
  13. buff_index INT(2) NOT NULL default 0,
  14. PRIMARY KEY (charId,skill_id,`class_index`)
  15. ) ;