summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn13166_mercenary_owner.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/upgrade_svn13166_mercenary_owner.sql')
-rw-r--r--sql-files/upgrade_svn13166_mercenary_owner.sql42
1 files changed, 21 insertions, 21 deletions
diff --git a/sql-files/upgrade_svn13166_mercenary_owner.sql b/sql-files/upgrade_svn13166_mercenary_owner.sql
index da7728cbe..29ecf8bf2 100644
--- a/sql-files/upgrade_svn13166_mercenary_owner.sql
+++ b/sql-files/upgrade_svn13166_mercenary_owner.sql
@@ -1,21 +1,21 @@
--- Removes mer_id from Char DB
-
-ALTER TABLE `char` DROP COLUMN `mer_id`;
-
--- Clean mercenary DB
-
-TRUNCATE TABLE `mercenary`;
-
--- 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;
+-- Removes mer_id from Char DB
+
+ALTER TABLE `char` DROP COLUMN `mer_id`;
+
+-- Clean mercenary DB
+
+TRUNCATE TABLE `mercenary`;
+
+-- 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;