CREATE TABLE IF NOT EXISTS `worldcheck_a` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entityIdP` varchar(23) NOT NULL,
  `entityId` varchar(23) NOT NULL,
  `nameType` varchar(30) DEFAULT NULL,
  `fullName` varchar(30) DEFAULT NULL,
  `givenName` varchar(30) DEFAULT NULL,
  `lastName` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='worldcheck associates v1 2014-01-20';