CREATE TABLE `faction_ranks` (
  `id` int(11) NOT NULL,
  `faction_id` int(11) DEFAULT NULL,
  `name` text,
  `permissions` text NOT NULL,
  `isDefault` int(11) NOT NULL DEFAULT '0',
  `isLeader` int(11) NOT NULL DEFAULT '0',
  `wage` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_20`, `wage_20` FROM `factions`;
UPDATE  `faction_ranks` SET  `permissions` =  '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18', `isLeader` =  '1'

ALTER TABLE `faction_ranks` CHANGE `isDefault` `isDefault` INT(11) NOT NULL DEFAULT '1';
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_1`, `wage_1` FROM `factions`;
ALTER TABLE `faction_ranks` CHANGE `isDefault` `isDefault` INT(11) NOT NULL DEFAULT '0';