DROP TABLE IF EXISTS tng_branches;
CREATE TABLE `tng_branches` (
  `branch` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gedcom` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `personID` varchar(22) COLLATE utf8mb4_unicode_ci NOT NULL,
  `agens` int NOT NULL,
  `dgens` int NOT NULL,
  `dagens` int NOT NULL,
  `inclspouses` tinyint NOT NULL,
  `action` tinyint NOT NULL,
  PRIMARY KEY (`gedcom`,`branch`),
  KEY `description` (`gedcom`,`description`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
