CREATE TABLE `pcdata_factions` (
  `character_id` int(10) unsigned NOT NULL,
  `pc_faction` tinyint(3) unsigned NOT NULL,
  `faction_pts` tinyint(3) DEFAULT '0',
  `wealth` tinyint(3) DEFAULT '0',
  `faction1` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `faction2` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `faction3` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `faction4` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `faction5` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `faction6` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `faction7` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `faction8` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `faction9` tinyint(3) unsigned NOT NULL DEFAULT '50',
  PRIMARY KEY (`character_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1