pets.sql 431 B

1234567891011121314151617
  1. -- ---------------------------
  2. -- Table structure for pets
  3. -- ---------------------------
  4. CREATE TABLE IF NOT EXISTS `pets` (
  5. `item_obj_id` decimal(11) NOT NULL default 0,
  6. `name` varchar(16) ,
  7. `level` decimal(11) ,
  8. `curHp` decimal(18,0) ,
  9. `curMp` decimal(18,0) ,
  10. `exp` decimal(20, 0) ,
  11. `sp` decimal(11) ,
  12. `fed` decimal(11) ,
  13. `weapon` int(5) ,
  14. `armor` int(5) ,
  15. `jewel` int(5) ,
  16. PRIMARY KEY (`item_obj_id`)
  17. );