CREATE TABLE `tng_users` (
  `userID` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(50) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(128) NOT NULL,
  `password_type` varchar(10) NOT NULL,
  `gedcom` varchar(128) DEFAULT NULL,
  `mygedcom` varchar(20) NOT NULL,
  `personID` varchar(22) NOT NULL,
  `role` varchar(15) NOT NULL,
  `allow_edit` tinyint(4) NOT NULL,
  `allow_add` tinyint(4) NOT NULL,
  `tentative_edit` tinyint(4) NOT NULL,
  `allow_delete` tinyint(4) NOT NULL,
  `allow_lds` tinyint(4) NOT NULL,
  `allow_ged` tinyint(4) NOT NULL,
  `allow_pdf` tinyint(4) NOT NULL,
  `allow_living` tinyint(4) NOT NULL,
  `allow_private` tinyint(4) NOT NULL,
  `allow_private_notes` tinyint(4) NOT NULL,
  `allow_private_media` tinyint(4) NOT NULL,
  `allow_profile` tinyint(4) NOT NULL,
  `branch` varchar(20) DEFAULT NULL,
  `realname` varchar(50) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `city` varchar(64) DEFAULT NULL,
  `state` varchar(64) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `country` varchar(64) DEFAULT NULL,
  `website` varchar(128) DEFAULT NULL,
  `languageID` smallint(6) NOT NULL,
  `lastlogin` datetime NOT NULL,
  `disabled` tinyint(4) NOT NULL,
  `dt_registered` datetime NOT NULL,
  `dt_activated` datetime NOT NULL,
  `dt_consented` datetime NOT NULL,
  `no_email` tinyint(4) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `reset_pwd_code` varchar(30) NOT NULL,
  PRIMARY KEY (`userID`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO tng_users (userID,description,username,password,password_type,gedcom,mygedcom,personID,role,allow_edit,allow_add,tentative_edit,allow_delete,allow_lds,allow_ged,allow_pdf,allow_living,allow_private,allow_private_notes,allow_private_media,allow_profile,branch,realname,phone,email,address,city,state,zip,country,website,languageID,lastlogin,disabled,dt_registered,dt_activated,dt_consented,no_email,notes,reset_pwd_code) VALUES
("6","Patrick","pbuck00","e23f4eec87ef30279f21d03879df4e3d4ac26379c1157a373ec927a1fa6b79a6","sha256","","","","admin","1","1","0","1","1","1","1","1","1","0","0","1","","Patrick Buckman","17078002535","patbuckman@comcast.net","5290 El Camino Bella","Bodega Bay","CA","94923","United States","http://","0","2025-08-23 12:31:31","0","0000-00-00 00:00:00","2021-12-31 10:54:01","0000-00-00 00:00:00","0","",""),
("7","TNG Support","TNG","e8d3e685eed0df2532f18dd9cc5842bd3fee9c6e2074ba604e45f4313cc8bcde","sha256","","","","admin","1","1","0","1","1","1","1","1","1","1","0","1","","TNG Support","","patbuckman@live.com","","","","","","https://","0","2023-01-08 10:32:15","0","0000-00-00 00:00:00","2023-01-07 16:05:56","0000-00-00 00:00:00","0","",""),
("9","Duncan Campbell","Duncan","7e6046c9a27718b278cdfae39ab45bbd53980c06267516e31e1a4423a555b5bf","sha256","","1","I26119","contrib","0","1","0","0","1","1","1","1","1","1","0","1","","Duncan Campbell","","dhcampbell55@gmail.com","","","","","","https://","0","2024-09-28 20:26:47","0","2024-09-02 14:01:07","2024-09-02 14:03:33","0000-00-00 00:00:00","0","",""),
("10","Michael Buckman","MBuck00","89e9d8533941fd70783c028008346e483063b08c5193968318f7bf5b31f86ae8","sha256","","1","","admin","1","1","0","1","1","1","1","1","1","1","0","1","","Michael Buckman","8052357587","Michael@buckman.us","5005 Gancho Ave","Atascadero","ca","94322","United States","https://","0","2025-06-24 20:37:51","0","0000-00-00 00:00:00","2025-04-13 17:30:34","0000-00-00 00:00:00","0","",""),
("11","Kathie Newman","Kathie Newman","6177abbd35e36adf87602429c72204aad670dfe6b55c47bbfb1edc0deecc8972","sha256","1","","","editor","1","1","0","1","0","1","1","1","1","0","0","0","","Kathie Newman","","newman@nd.edu","","","","","","https://","0","0000-00-00 00:00:00","0","0000-00-00 00:00:00","2025-06-17 10:34:11","0000-00-00 00:00:00","0","",""),
("12","New User","New User","3d885d4fb5b98d511105c18db763f27b34c06e9839b38e71ad6b17881db2f784","sha256","002","1","","guest","0","0","0","0","0","0","0","0","0","0","0","0","","New User","","pat@patbuckman.com","","","","","","https://","0","2025-07-23 08:24:37","0","0000-00-00 00:00:00","2025-06-25 14:03:24","0000-00-00 00:00:00","0","","");