summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn13166_mercenary_owner.sql
diff options
context:
space:
mode:
authorshennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-09-06 19:58:51 +0000
committershennetsind <shennetsind@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-09-06 19:58:51 +0000
commite3014f7b20b5df2843e3448c5327dda2641ddbdc (patch)
tree7b051a2217aeb27a77f35f2a632034df12477b87 /sql-files/upgrade_svn13166_mercenary_owner.sql
parentbd62cbc13d98a977008f42ea6583a33c99516c6b (diff)
downloadhercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.tar.gz
hercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.tar.bz2
hercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.tar.xz
hercules-e3014f7b20b5df2843e3448c5327dda2641ddbdc.zip
sql-files folder redesign as discussed with other developers, all upgrade files prior to rathena were removed (if you need them you can use the trac or download a earlier version of the folder).
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16750 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn13166_mercenary_owner.sql')
-rw-r--r--sql-files/upgrade_svn13166_mercenary_owner.sql21
1 files changed, 0 insertions, 21 deletions
diff --git a/sql-files/upgrade_svn13166_mercenary_owner.sql b/sql-files/upgrade_svn13166_mercenary_owner.sql
deleted file mode 100644
index 29ecf8bf2..000000000
--- a/sql-files/upgrade_svn13166_mercenary_owner.sql
+++ /dev/null
@@ -1,21 +0,0 @@
--- 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;