[dimke931]

CREATE TABLE `got_kievsky_even_sour` (
  `id_indi` mediumint(9) NOT NULL DEFAULT '0',
  `id_husb` mediumint(9) NOT NULL DEFAULT '0',
  `id_wife` mediumint(9) NOT NULL DEFAULT '0',
  `type_evene` varchar(4) NOT NULL,
  `date_evene` varchar(32) DEFAULT NULL,
  `lieu_evene` varchar(42) DEFAULT NULL,
  `dept_evene` varchar(42) DEFAULT NULL,
  `id_sour` mediumint(9) NOT NULL DEFAULT '0',
  `type_sourc` varchar(4) NOT NULL,
  `attr_sourc` varchar(255) DEFAULT NULL,
  KEY `FK1_INDI` (`id_indi`,`type_evene`),
  KEY `FK2_HUSB` (`id_husb`,`type_evene`),
  KEY `FK3_WIFE` (`id_wife`,`type_evene`),
  KEY `FK4_SOUR` (`id_sour`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8	;
#	TC`got_kievsky_evenement`utf8_general_ci	;
CREATE TABLE `got_kievsky_evenement` (
  `id_indi` mediumint(9) NOT NULL DEFAULT '0',
  `id_husb` mediumint(9) NOT NULL DEFAULT '0',
  `id_wife` mediumint(9) NOT NULL DEFAULT '0',
  `type_evene` varchar(4) NOT NULL,
  `date_evene` varchar(32) DEFAULT NULL,
  `lieu_evene` varchar(42) DEFAULT NULL,
  `dept_evene` varchar(42) DEFAULT NULL,
  `note_evene` mediumtext,
  `anne_evene` smallint(6) DEFAULT NULL,
  KEY `FK1_INDI` (`id_indi`),
  KEY `FK2_HUSB` (`id_husb`),
  KEY `FK3_WIFE` (`id_wife`),
  KEY `FK4_LIEU` (`lieu_evene`),
  KEY `FK5_TYPE` (`type_evene`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8	;
#	TC`got_kievsky_individu`utf8_general_ci	;
CREATE TABLE `got_kievsky_individu` (
  `id_indi` int(9) NOT NULL DEFAULT '0',
  `nom` varchar(32) DEFAULT NULL,
  `prenom1` varchar(32) DEFAULT NULL,
  `prenom2` varchar(32) DEFAULT NULL,
  `prenom3` varchar(32) DEFAULT NULL,
  `sexe` tinytext,
  `profession` varchar(42) DEFAULT NULL,
  `date_naiss` varchar(32) DEFAULT NULL,
  `lieu_naiss` varchar(42) DEFAULT NULL,
  `dept_naiss` varchar(42) DEFAULT NULL,
  `date_deces` varchar(32) DEFAULT NULL,
  `lieu_deces` varchar(42) DEFAULT NULL,
  `dept_deces` varchar(42) DEFAULT NULL,
  `note_indi` text,
  `id_pere` mediumint(9) DEFAULT NULL,
  `id_mere` mediumint(9) DEFAULT NULL,
  `tri` smallint(6) DEFAULT NULL,
  `sosa_dyn` bigint(20) DEFAULT NULL,
  `anne_deces` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`id_indi`),
  KEY `FK1_NOM` (`nom`),
  KEY `FK2_PREN` (`prenom1`),
  KEY `FK3_PERE` (`id_pere`),
  KEY `FK4_MERE` (`id_mere`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8	;
#	TC`got_kievsky_relation`utf8_general_ci	;
CREATE TABLE `got_kievsky_relation` (
  `id_parent` mediumint(9) NOT NULL DEFAULT '0',
  `id_enfant` mediumint(9) NOT NULL DEFAULT '0',
  `type_parent` char(1) DEFAULT NULL,
  PRIMARY KEY (`id_parent`,`id_enfant`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8	;
#	TC`got_kievsky_source`utf8_general_ci	;
CREATE TABLE `got_kievsky_source` (
  `id_sour` mediumint(9) NOT NULL DEFAULT '0',
  `note_source` mediumtext,
  PRIMARY KEY (`id_sour`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8	;

вот я сделал дамп таблиц