character_skills.sql 397 B

1234567891011
  1. -- ---------------------------
  2. -- Table structure for character_skills
  3. -- ---------------------------
  4. CREATE TABLE IF NOT EXISTS `character_skills` (
  5. `charId` INT UNSIGNED NOT NULL default 0,
  6. `skill_id` INT NOT NULL default 0,
  7. `skill_level` INT(3) NOT NULL default 1,
  8. `skill_name` varchar(40),
  9. `class_index` INT(1) NOT NULL DEFAULT 0,
  10. PRIMARY KEY (`charId`,`skill_id`,`class_index`)
  11. );