character_skills_save.sql 580 B

12345678910111213
  1. CREATE TABLE IF NOT EXISTS `character_skills_save` (
  2. `charId` INT NOT NULL default 0,
  3. `skill_id` INT NOT NULL default 0,
  4. `skill_level` INT(3) NOT NULL default 1,
  5. `effect_count` INT NOT NULL default 0,
  6. `effect_cur_time` INT NOT NULL default 0,
  7. `reuse_delay` INT(8) NOT NULL DEFAULT 0,
  8. `systime` bigint(13) unsigned NOT NULL DEFAULT '0',
  9. `restore_type` INT(1) NOT NULL DEFAULT 0,
  10. `class_index` INT(1) NOT NULL DEFAULT 0,
  11. `buff_index` INT(2) NOT NULL default 0,
  12. PRIMARY KEY (`charId`,`skill_id`,`skill_level`,`class_index`)
  13. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;