From 59b08db5fcebd6e3d94f5353602fc685dbf9e3f5 Mon Sep 17 00:00:00 2001 From: zephyrus Date: Sat, 23 Aug 2008 12:14:13 +0000 Subject: - Database structure for Mercenary. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13115 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/main.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'sql-files/main.sql') diff --git a/sql-files/main.sql b/sql-files/main.sql index c06b8dac6..a79eee0e1 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -481,6 +481,21 @@ CREATE TABLE IF NOT EXISTS `memo` ( KEY `char_id` (`char_id`) ) ENGINE=MyISAM; +-- +-- 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; + -- -- Table structure for table `party` -- -- cgit v1.2.3-60-g2f50