10 lines
416 B
SQL
Executable File
10 lines
416 B
SQL
Executable File
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'; |