CREATE TABLE `tng_trees` (
  `gedcom` varchar(20) NOT NULL,
  `treename` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `owner` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `city` varchar(40) NOT NULL,
  `state` varchar(30) NOT NULL,
  `country` varchar(30) NOT NULL,
  `zip` varchar(20) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `secret` tinyint(4) NOT NULL,
  `disallowgedcreate` tinyint(4) NOT NULL,
  `disallowpdf` tinyint(4) NOT NULL,
  `lastimportdate` datetime NOT NULL,
  `importfilename` varchar(100) NOT NULL,
  PRIMARY KEY (`gedcom`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO tng_trees (gedcom,treename,description,owner,email,address,city,state,country,zip,phone,secret,disallowgedcreate,disallowpdf,lastimportdate,importfilename) VALUES
("1","footsteps","","","","","","","","","","0","0","0","2025-07-30 10:22:44","PRIME 2025-07-30.ged"),
("002","Bunker","","","","","","","","","","0","0","0","2025-06-28 19:42:03","Bunker.ged");