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,
  `reset_pwd_code` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`userID`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
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
("1","Colin Jenner","colinjenner","f32ac2f77cd60bae858bfb3845353d2fd742b05e72869607d8ef340d88500efa","sha256","","","","admin","1","1","0","1","1","1","1","1","1","1","0","1","","Colin Jenner","07786194564","colin@jennerations.com","25 king Edward Avenue","Hastings","East Sussex","TN34 2NG","United Kingdom","https://www.jennerations.com","0","2025-08-04 12:11:15","0","0000-00-00 00:00:00","2024-03-21 21:35:59","0000-00-00 00:00:00","0","","");