DROP TABLE IF EXISTS tng_branches;
CREATE TABLE `tng_branches` (
  `branch` varchar(20) NOT NULL,
  `gedcom` varchar(20) NOT NULL,
  `description` varchar(128) NOT NULL,
  `personID` varchar(22) NOT NULL,
  `agens` int(11) NOT NULL,
  `dgens` int(11) NOT NULL,
  `dagens` int(11) NOT NULL,
  `inclspouses` tinyint(4) NOT NULL,
  `action` tinyint(4) NOT NULL,
  PRIMARY KEY (`gedcom`,`branch`),
  KEY `description` (`gedcom`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
