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',
  `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', `isDefault` =  '1'

INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_1`, `wage_1` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_2`, `wage_2` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_3`, `wage_3` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_4`, `wage_4` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_5`, `wage_5` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_6`, `wage_6` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_7`, `wage_7` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_8`, `wage_8` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_9`, `wage_9` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_10`, `wage_10` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_11`, `wage_11` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_12`, `wage_12` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_13`, `wage_13` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_14`, `wage_14` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_15`, `wage_15` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_16`, `wage_16` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_17`, `wage_17` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_18`, `wage_18` FROM `factions`;
INSERT INTO `faction_ranks` (`faction_id`, `name`, `wage`) SELECT `id`, `rank_19`, `wage_19` FROM `factions`;



ALTER TABLE  `factions` ADD  `rank_order` TEXT NOT NULL AFTER  `type`
ALTER TABLE `factions` DROP `rank_1`, DROP `rank_2`, DROP `rank_3`, DROP `rank_4`, DROP `rank_5`, DROP `rank_6`, DROP `rank_7`, DROP `rank_8`, DROP `rank_9`, DROP `rank_10`, DROP `rank_11`, DROP `rank_12`, DROP `rank_13`, DROP `rank_14`, DROP `rank_15`, DROP `rank_16`, DROP `rank_17`, DROP `rank_18`, DROP `rank_19`, DROP `rank_20`, DROP `wage_1`, DROP `wage_2`, DROP `wage_3`, DROP `wage_4`, DROP `wage_5`, DROP `wage_6`, DROP `wage_7`, DROP `wage_8`, DROP `wage_9`, DROP `wage_10`, DROP `wage_11`, DROP `wage_12`, DROP `wage_13`, DROP `wage_14`, DROP `wage_15`, DROP `wage_16`, DROP `wage_17`, DROP `wage_18`, DROP `wage_19`, DROP `wage_20`;

UPDATE characters_faction as t, (SELECT id, faction_id FROM faction_ranks WHERE isDefault = '0' ) as temp SET t.faction_rank = temp.id WHERE NOT t.faction_leader = '0' AND temp.faction_id = t.faction_id
UPDATE characters_faction as t, (SELECT id, faction_id FROM faction_ranks WHERE isDefault = '1' ) as temp SET t.faction_rank = temp.id WHERE t.faction_leader = '1' AND temp.faction_id = t.faction_id