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 COLLATE=latin1_swedish_ci;
INSERT INTO tng_branches (branch,gedcom,description,personID,agens,dgens,dagens,inclspouses,action) VALUES
("001","1","Pat","I1","100","8","0","0","2"),
("002","1","Arthur","I47","5","10","0","0","2"),
("003","1","Bangs","I8735","15","8","1","0","2"),
("004","1","Beaufort","I19065","10","25","0","0","2"),
("005","1","Birdsall","I8715","15","8","0","0","2"),
("008","1","Byrd","I132","15","8","1","0","2"),
("009","1","Campbell","I58","15","8","0","0","2"),
("010","1","Carroll","I28476","15","8","0","0","2"),
("011","1","Child","I33695","15","8","0","0","2"),
("012","1","Enoch","I60","15","8","1","0","2"),
("013","1","Magana","I5","15","8","2","0","2"),
("015","1","Harrison","I33","15","8","1","0","2"),
("016","1","Hayne","I46","15","8","0","0","2"),
("017","1","John Baptist","I83","15","25","0","0","2"),
("26","1","Mayflower-FC","I124","2","20","0","0","2"),
("20","1","Mayflower-PB","I6991","5","20","0","0","2"),
("21","1","Mayflower-SH","I113","5","20","0","0","2"),
("22","1","Mayflower-JA","I37598","5","20","0","0","2"),
("23","1","Mayflower-WM","I27651","5","20","0","0","2"),
("24","1","Mayflower-WB","I135","5","20","0","0","2"),
("019","1","Bruce","I7858","0","30","0","0","2"),
("34","1","Pierceall","I66","5","15","0","0","2"),
("27","1","Mayflower-JT","I9352","2","20","0","0","2"),
("25","1","Mayflower-JC","I3306","5","20","0","0","2"),
("31","1","Smith","I59","15","10","0","0","2"),
("32","1","Stewart","I63","15","10","0","0","2"),
("33","1","Van Loan","I67","15","10","0","0","2"),
("35","1","Young","I41","15","15","0","0","2"),
("36","1","Godiva","I7195","0","40","0","0","2"),
("37","1","Charlamagne","I7306","0","40","0","0","2"),
("38","1","Conqueor","I9408","2","40","0","0","2"),
("39","1","Capet","I1614","0","25","0","0","2"),
("40","1","Christian I","I7071","0","30","0","0","2"),
("41","1","William Wallace","I1629","0","30","0","0","2"),
("28","1","Mayflower-TR","I27233","2","20","0","0","2"),
("006","1","Brewton","I345","5","12","0","0","2"),
("007","1","Ott","I96","15","10","0","0","2"),
("018","1","MacCallum","I95","5","10","0","0","2"),
("1002","1","GuyBuckman","I2","20","5","0","0","2"),
("1008","1","DonCampbell","I8","20","5","0","0","2"),
("1006","1","LucyHarrison","i6","20","5","0","0","2"),
("1003","1","BettyOtt","i3","20","5","0","0","2"),
("014","1","Bunker","I23684","15","5","0","0","2"),
("020","1","Hayden","I33749","10","5","0","0","2"),
("29","1","Mayflower-EF","I4531","2","15","0","0","2"),
("042","1","Pinckney","I44022","3","12","0","0","2"),
("043","1","Newcomb","I70","5","10","0","0","2"),
("044","1","Rollo","I9693","1","25","0","0","2"),
("30","1","Mayflower-JH","I22370","2","15","0","0","2"),
("045","1","Blackwell","I45128","3","15","0","0","2"),
("046","1","Brunt","I45127","3","20","0","0","2"),
("047","1","Bennett","I45129","3","15","0","0","2");