pets.sql 546 B

1234567891011121314
  1. CREATE TABLE IF NOT EXISTS `pets` (
  2. `item_obj_id` int(10) unsigned NOT NULL,
  3. `name` varchar(16),
  4. `level` smallint(2) unsigned NOT NULL,
  5. `curHp` int(9) unsigned DEFAULT '0',
  6. `curMp` int(9) unsigned DEFAULT '0',
  7. `exp` bigint(20) unsigned DEFAULT '0',
  8. `sp` int(10) unsigned DEFAULT '0',
  9. `fed` int(10) unsigned DEFAULT '0',
  10. `ownerId` int(10) NOT NULL DEFAULT '0',
  11. `restore` enum('true','false') NOT NULL DEFAULT 'false',
  12. PRIMARY KEY (`item_obj_id`),
  13. KEY `ownerId` (`ownerId`)
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;