upgrade_svn13115_mercenary.sql 422 B

1234567891011121314
  1. --
  2. -- Table structure for table `mercenary`
  3. --
  4. CREATE TABLE IF NOT EXISTS `mercenary` (
  5. `mer_id` int(11) unsigned NOT NULL auto_increment,
  6. `char_id` int(11) NOT NULL,
  7. `class` mediumint(9) unsigned NOT NULL default '0',
  8. `hp` int(12) NOT NULL default '1',
  9. `sp` int(12) NOT NULL default '1',
  10. `kill_counter` int(11) NOT NULL,
  11. `life_time` int(11) NOT NULL default '0',
  12. PRIMARY KEY (`mer_id`)
  13. ) ENGINE=MyISAM;