DROP TABLE IF EXISTS tng_repositories;
CREATE TABLE `tng_repositories` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `repoID` varchar(22) NOT NULL,
  `reponame` varchar(90) NOT NULL,
  `gedcom` varchar(20) NOT NULL,
  `addressID` int(11) NOT NULL,
  `changedate` datetime NOT NULL,
  `changedby` varchar(100) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `repoID` (`gedcom`,`repoID`),
  KEY `reponame` (`reponame`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
INSERT INTO tng_repositories (ID,repoID,reponame,gedcom,addressID,changedate,changedby) VALUES
("1","R1","","1","0","2025-07-30 10:22:44","pbuck00");