path: root/sql-files/upgrade_svn13166_mercenary_owner.sql

-- 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;