character_skills.sql 302 B

1234567
  1. CREATE TABLE IF NOT EXISTS `character_skills` (
  2. `charId` INT UNSIGNED NOT NULL DEFAULT 0,
  3. `skill_id` INT NOT NULL DEFAULT 0,
  4. `skill_level` INT(3) NOT NULL DEFAULT 1,
  5. `class_index` INT(1) NOT NULL DEFAULT 0,
  6. PRIMARY KEY (`charId`,`skill_id`,`class_index`)
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;