DROP TABLE IF EXISTS tng_trees;
CREATE TABLE `tng_trees` (
  `gedcom` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `treename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `zip` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` tinyint NOT NULL,
  `disallowgedcreate` tinyint NOT NULL,
  `disallowpdf` tinyint NOT NULL,
  `lastimportdate` datetime NOT NULL,
  `importfilename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`gedcom`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
INSERT INTO tng_trees (gedcom,treename,description,owner,email,address,city,state,country,zip,phone,secret,disallowgedcreate,disallowpdf,lastimportdate,importfilename) VALUES
("1","My Genealogy","","","","","","","","","","1","1","1","0000-00-00 00:00:00","");