From bb1a4e56b358c36a7996be8d34b84e7f118f63f5 Mon Sep 17 00:00:00 2001
From: zephyrus <zephyrus@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Mon, 1 Sep 2008 00:03:10 +0000
Subject: - Moved char server's mercenary code to a different file
 (int_mercenary.*) - New Sql Patch for create mercenary_owner DB. - Removed
 mer_id from char_db.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13166 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/main.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'sql-files/main.sql')

diff --git a/sql-files/main.sql b/sql-files/main.sql
index a5c23421a..346e19ca1 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -497,6 +497,22 @@ CREATE TABLE IF NOT EXISTS `mercenary` (
   PRIMARY KEY  (`mer_id`)
 ) ENGINE=MyISAM;
 
+--
+-- Table structure for table `mercenary_owner`
+--
+
+CREATE TABLE IF NOT EXISTS `mercenary_owner` (
+  `char_id` int(11) NOT NULL,
+  `merc_id` int(11) NOT NULL default '0',
+  `arch_calls` int(11) NOT NULL default '0',
+  `arch_faith` int(11) NOT NULL default '0',
+  `spear_calls` int(11) NOT NULL default '0',
+  `spear_faith` int(11) NOT NULL default '0',
+  `sword_calls` int(11) NOT NULL default '0',
+  `sword_faith` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`char_id`)
+) ENGINE=MyISAM;
+
 --
 -- Table structure for table `party`
 --
-- 
cgit v1.2.3-70-g09d2

