homunculus.sql 775 B

123456789101112131415161718192021
  1. -- Table for the Homunculus.
  2. -- [blackhole89]
  3. CREATE TABLE `homunculus` (
  4. `id` int(11) NOT NULL auto_increment,
  5. `char_id` int(11) unsigned NOT NULL default '0',
  6. `class` mediumint(9) unsigned NOT NULL default '0',
  7. `name` varchar(24) NOT NULL default '',
  8. `level` smallint(4) NOT NULL default '0',
  9. `exp` int(12) NOT NULL default '0',
  10. `hunger` tinyint(10) NOT NULL default '0',
  11. `hp` int(12) NOT NULL default '1',
  12. `sp` int(12) NOT NULL default '1',
  13. `skill1lv` smallint(4) NOT NULL default '0',
  14. `skill2lv` smallint(4) NOT NULL default '0',
  15. `skill3lv` smallint(4) NOT NULL default '0',
  16. `skill4lv` smallint(4) NOT NULL default '0',
  17. `skillpts` int(11) unsigned NOT NULL default '0',
  18. PRIMARY KEY (`id`),
  19. KEY `char_id` (`char_id`)
  20. )