summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn13115_mercenary.sql
blob: 70356b36185112258c03c9ddb0b196797ac6ca0e (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;