summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn13115_mercenary.sql
blob: bcb7cff311e10c318221c5ce5bdd18df5ab448be (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
--
-- Table structure for table `mercenary`
--

CREATE TABLE IF NOT EXISTS `mercenary` (
  `mer_id` int(11) unsigned NOT NULL auto_increment,
  `char_id` int(11) NOT NULL,
  `class` mediumint(9) unsigned NOT NULL default '0',
  `hp` int(12) NOT NULL default '1',
  `sp` int(12) NOT NULL default '1',
  `kill_counter` int(11) NOT NULL,
  `life_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`mer_id`)
) ENGINE=MyISAM;