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=43 DEFAULT CHARSET=latin1;
INSERT INTO tng_repositories (ID,repoID,reponame,gedcom,addressID,changedate,changedby) VALUES
("1","R1","Family History Library","jennerations","0","2024-03-13 13:15:49","colinjenner"),
("2","R2","Jessie Piper\'s Estate","jennerations","0","2008-03-30 15:25:52","colinjenner"),
("3","R3","FH document folders","jennerations","0","2023-04-06 15:15:05","colinjenner"),
("4","R4","Letters Folders","jennerations","0","2022-02-16 16:26:27","colinjenner"),
("5","R5","Christening cards","jennerations","0","2015-11-15 15:58:33","colinjenner"),
("6","R6","Mothering Sunday cards","jennerations","0","2015-11-15 15:58:02","colinjenner"),
("7","R7","New baby cards","jennerations","0","2015-11-15 15:57:35","colinjenner"),
("8","R8","Christmas cards","jennerations","0","2015-11-15 16:14:09","colinjenner"),
("9","R9","Wedding cards","jennerations","0","2015-11-15 16:34:00","colinjenner"),
("10","R24","Elizabeth Preni Collection","jennerations","0","2018-10-01 12:33:29","colinjenner"),
("11","R30","Kent County Archive","jennerations","23","2019-02-11 09:04:20","colinjenner"),
("12","R32","British Newspaper Archive","jennerations","0","2023-12-28 12:31:25","colinjenner"),
("13","R34","History of William Cato & Sons","jennerations","0","2020-09-14 07:30:51","colinjenner"),
("14","R35","Wales Ecclesiastical Wills","jennerations","24","2021-06-29 15:57:21","colinjenner"),
("15","R36","Powys Council website","jennerations","0","2021-05-20 14:27:05","colinjenner"),
("16","R37","Ancestry (UK)","jennerations","0","2021-08-30 12:12:54","colinjenner"),
("17","R38","Find My Past (UK)","jennerations","0","2022-01-20 12:13:34","colinjenner"),
("18","R39","East Sussex and Brighton and Hove Record Office","jennerations","0","2023-12-28 12:29:26","colinjenner"),
("19","R40","General Regster Office","jennerations","0","2021-10-07 12:22:53","colinjenner"),
("20","R41","National Archives","jennerations","0","2022-03-01 15:16:29","colinjenner"),
("21","R42","Army Personnel Centre","jennerations","25","2021-10-21 13:27:50","colinjenner"),
("22","R43","Hastings Library","jennerations","0","2021-10-28 14:33:56","colinjenner"),
("23","R44","Forest of Dean Family History Trust","jennerations","0","2022-01-07 14:49:54","colinjenner"),
("24","R45","Scotlands People","jennerations","0","2022-08-20 12:13:48","colinjenner"),
("25","R46","FamilySearch","jennerations","26","2022-09-08 09:34:08","colinjenner"),
("26","R47","Canterbury Cathedral Archives","jennerations","0","2022-11-06 11:19:33","colinjenner"),
("27","R48","Kent History & Library Centre","jennerations","0","2022-12-11 15:19:57","colinjenner"),
("28","R49","Falkirk Archives","jennerations","27","2022-12-28 15:37:20","colinjenner"),
("29","R50","National Library of Scotland","jennerations","0","2023-04-17 15:16:27","colinjenner"),
("30","R51","Gloucestershire Archives","jennerations","0","2023-02-22 13:24:19","colinjenner"),
("31","R52","The Heritage Centre, Paisley","jennerations","28","2023-03-13 10:19:57","colinjenner"),
("32","R53","The Mitchell Library","jennerations","0","2023-10-30 08:32:48","colinjenner"),
("33","R54","Jennerations assorted photo prints","jennerations","0","2023-05-17 16:49:08","colinjenner"),
("34","R55","The Geneologist","jennerations","0","2023-10-19 11:20:32","colinjenner"),
("35","R56","East Riding Archives & Local Studies Service","jennerations","0","2024-01-09 11:27:07","colinjenner"),
("36","R57","GENUKI","jennerations","0","2024-01-09 12:56:44","colinjenner"),
("37","R58","Borthwick Institute for Archives","jennerations","0","2024-01-09 14:10:10","colinjenner"),
("38","R59","Oxfordshire History Centre","jennerations","0","2024-01-15 11:07:57","colinjenner"),
("39","R60","Medway Council Heritage Services","jennerations","0","2024-02-01 09:04:06","colinjenner"),
("40","R61","Cambridgeshire Record office","jennerations","0","2024-03-13 10:40:12","colinjenner"),
("41","R62","Norfolk Records office","jennerations","0","2024-03-16 12:27:51","colinjenner"),
("42","R63","Greater Manchester County Record Office","jennerations","0","2024-03-16 16:42:00","colinjenner");