diff options
Diffstat (limited to 'sql-files/upgrade_svn13166_mercenary_owner.sql')
| -rw-r--r-- | sql-files/upgrade_svn13166_mercenary_owner.sql | 21 |
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; |