character_subclasses.sql 473 B

123456789101112
  1. -- ---------------------------
  2. -- Table structure for character_subclasses
  3. -- ---------------------------
  4. CREATE TABLE IF NOT EXISTS `character_subclasses` (
  5. `char_obj_id` decimal(11,0) 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 (`char_obj_id`,`class_id`)
  12. ) ;