123456789101112 |
- -- ---------------------------
- -- Table structure for character_subclasses
- -- ---------------------------
- CREATE TABLE IF NOT EXISTS `character_subclasses` (
- `charId` INT UNSIGNED NOT NULL default 0,
- `class_id` int(2) NOT NULL default 0,
- `exp` decimal(20,0) NOT NULL default 0,
- `sp` decimal(11,0) NOT NULL default 0,
- `level` int(2) NOT NULL default 40,
- `class_index` int(1) NOT NULL default 0,
- PRIMARY KEY (`charId`,`class_id`)
- );
|