character_subclasses.sql 448 B

123456789101112
  1. -- ---------------------------
  2. -- Table structure for character_subclasses
  3. -- ---------------------------
  4. CREATE TABLE IF NOT EXISTS `character_subclasses` (
  5. `charId` INT UNSIGNED NOT NULL default 0,
  6. `class_id` int(2) NOT NULL default 0,
  7. `exp` decimal(20,0) NOT NULL default 0,
  8. `sp` decimal(11,0) NOT NULL default 0,
  9. `level` int(2) NOT NULL default 40,
  10. `class_index` int(1) NOT NULL default 0,
  11. PRIMARY KEY (`charId`,`class_id`)
  12. );