Remonter

Noms des tables et des champs dans la base des données TNG version 13.1

Cette liste est obtenue à partir du fichier tng_tablestructure.bak qui est le fichier de sauvegarde de la structure des tablesCREATE TABLE `tng_users` (. Ceci indique les noms de table et de champs à utiliser dans nos requêtes SQL.

DROP TABLE IF EXISTS tng_addresses;

CREATE TABLE `tng_addresses` (
`addressID` int(11) NOT NULL AUTO_INCREMENT,
`address1` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
`address2` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
`city` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
`state` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
`zip` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`country` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
`www` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`email` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`phone` varchar(30) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`addressID`),
KEY `address` (`gedcom`,`country`,`state`,`city`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_albums;

CREATE TABLE `tng_albums` (
`albumID` int(11) NOT NULL AUTO_INCREMENT,
`albumname` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`description` text COLLATE utf8_swedish_ci,
`alwayson` tinyint(4) DEFAULT NULL,
`keywords` text COLLATE utf8_swedish_ci,
`active` tinyint(4) NOT NULL,
PRIMARY KEY (`albumID`),
KEY `albumname` (`albumname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_albumlinks;

CREATE TABLE `tng_albumlinks` (
`albumlinkID` int(11) NOT NULL AUTO_INCREMENT,
`albumID` int(11) NOT NULL,
`mediaID` int(11) NOT NULL,
`ordernum` int(11) DEFAULT NULL,
`defphoto` varchar(1) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`albumlinkID`),
KEY `albumID` (`albumID`,`ordernum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_albumplinks;

CREATE TABLE `tng_albumplinks` (
`alinkID` int(11) NOT NULL AUTO_INCREMENT,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`linktype` char(1) COLLATE utf8_swedish_ci NOT NULL,
`entityID` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`eventID` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`albumID` int(11) NOT NULL,
`ordernum` float NOT NULL,
PRIMARY KEY (`alinkID`),
UNIQUE KEY `alinkID` (`gedcom`,`entityID`,`albumID`),
KEY `entityID` (`gedcom`,`entityID`,`ordernum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_associations;

CREATE TABLE `tng_associations` (
`assocID` int(11) NOT NULL AUTO_INCREMENT,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`personID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`passocID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`reltype` varchar(1) COLLATE utf8_swedish_ci NOT NULL,
`relationship` varchar(75) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`assocID`),
KEY `assoc` (`gedcom`,`personID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_branches;

CREATE TABLE `tng_branches` (
`branch` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`description` varchar(128) COLLATE utf8_swedish_ci NOT NULL,
`personID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`agens` int(11) NOT NULL,
`dgens` int(11) NOT NULL,
`dagens` int(11) NOT NULL,
`inclspouses` tinyint(4) NOT NULL,
`action` tinyint(4) NOT NULL,
PRIMARY KEY (`gedcom`,`branch`),
KEY `description` (`gedcom`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_branchlinks;

CREATE TABLE `tng_branchlinks` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`branch` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`persfamID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `branch` (`gedcom`,`branch`,`persfamID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_cemeteries;

CREATE TABLE `tng_cemeteries` (
`cemeteryID` int(11) NOT NULL AUTO_INCREMENT,
`cemname` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
`maplink` varchar(255) COLLATE utf8_swedish_ci NOT NULL,
`city` varchar(64) COLLATE utf8_swedish_ci DEFAULT NULL,
`county` varchar(64) COLLATE utf8_swedish_ci DEFAULT NULL,
`state` varchar(64) COLLATE utf8_swedish_ci DEFAULT NULL,
`country` varchar(64) COLLATE utf8_swedish_ci DEFAULT NULL,
`longitude` varchar(22) COLLATE utf8_swedish_ci DEFAULT NULL,
`latitude` varchar(22) COLLATE utf8_swedish_ci DEFAULT NULL,
`zoom` tinyint(4) DEFAULT NULL,
`notes` text COLLATE utf8_swedish_ci,
`place` varchar(248) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`cemeteryID`),
KEY `cemname` (`cemname`),
KEY `place` (`place`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_people;

CREATE TABLE `tng_people` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`personID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`lnprefix` varchar(25) COLLATE utf8_swedish_ci NOT NULL,
`lastname` varchar(127) COLLATE utf8_swedish_ci NOT NULL,
`firstname` varchar(127) COLLATE utf8_swedish_ci NOT NULL,
`birthdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`birthdatetr` date NOT NULL,
`sex` tinytext COLLATE utf8_swedish_ci NOT NULL,
`birthplace` text COLLATE utf8_swedish_ci NOT NULL,
`deathdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`deathdatetr` date NOT NULL,
`deathplace` text COLLATE utf8_swedish_ci NOT NULL,
`altbirthdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`altbirthdatetr` date NOT NULL,
`altbirthplace` text COLLATE utf8_swedish_ci NOT NULL,
`burialdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`burialdatetr` date NOT NULL,
`burialplace` text COLLATE utf8_swedish_ci NOT NULL,
`burialtype` tinyint(4) NOT NULL,
`baptdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`baptdatetr` date NOT NULL,
`baptplace` text COLLATE utf8_swedish_ci NOT NULL,
`confdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`confdatetr` date NOT NULL,
`confplace` text COLLATE utf8_swedish_ci NOT NULL,
`initdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`initdatetr` date NOT NULL,
`initplace` text COLLATE utf8_swedish_ci NOT NULL,
`endldate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`endldatetr` date NOT NULL,
`endlplace` text COLLATE utf8_swedish_ci NOT NULL,
`changedate` datetime NOT NULL,
`nickname` text COLLATE utf8_swedish_ci NOT NULL,
`title` tinytext COLLATE utf8_swedish_ci NOT NULL,
`prefix` tinytext COLLATE utf8_swedish_ci NOT NULL,
`suffix` tinytext COLLATE utf8_swedish_ci NOT NULL,
`nameorder` tinyint(4) NOT NULL,
`famc` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`metaphone` varchar(15) COLLATE utf8_swedish_ci NOT NULL,
`living` tinyint(4) NOT NULL,
`private` tinyint(4) NOT NULL,
`branch` varchar(512) COLLATE utf8_swedish_ci NOT NULL,
`changedby` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`edituser` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`edittime` int(11) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `gedpers` (`gedcom`,`personID`),
KEY `lastname` (`lastname`,`firstname`),
KEY `firstname` (`firstname`),
KEY `gedlast` (`gedcom`,`lastname`,`firstname`),
KEY `gedfirst` (`gedcom`,`firstname`),
KEY `birthplace` (`birthplace`(20)),
KEY `altbirthplace` (`altbirthplace`(20)),
KEY `deathplace` (`deathplace`(20)),
KEY `burialplace` (`burialplace`(20)),
KEY `baptplace` (`baptplace`(20)),
KEY `confplace` (`confplace`(20)),
KEY `initplace` (`initplace`(20)),
KEY `endlplace` (`endlplace`(20)),
KEY `changedate` (`changedate`)
) ENGINE=MyISAM AUTO_INCREMENT=263338 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_families;

CREATE TABLE `tng_families` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`familyID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`husband` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`wife` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`marrdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`marrdatetr` date NOT NULL,
`marrplace` text COLLATE utf8_swedish_ci NOT NULL,
`marrtype` varchar(90) COLLATE utf8_swedish_ci NOT NULL,
`divdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`divdatetr` date NOT NULL,
`divplace` text COLLATE utf8_swedish_ci NOT NULL,
`status` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`sealdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`sealdatetr` date NOT NULL,
`sealplace` text COLLATE utf8_swedish_ci NOT NULL,
`husborder` tinyint(4) NOT NULL,
`wifeorder` tinyint(4) NOT NULL,
`changedate` datetime NOT NULL,
`living` tinyint(4) NOT NULL,
`private` tinyint(4) NOT NULL,
`branch` varchar(512) COLLATE utf8_swedish_ci NOT NULL,
`changedby` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`edituser` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`edittime` int(11) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `familyID` (`gedcom`,`familyID`),
KEY `husband` (`gedcom`,`husband`),
KEY `wife` (`gedcom`,`wife`),
KEY `marrplace` (`marrplace`(20)),
KEY `divplace` (`divplace`(20)),
KEY `changedate` (`changedate`)
) ENGINE=MyISAM AUTO_INCREMENT=110975 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_children;

CREATE TABLE `tng_children` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`familyID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`personID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`frel` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`mrel` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`sealdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`sealdatetr` date NOT NULL,
`sealplace` text COLLATE utf8_swedish_ci NOT NULL,
`haskids` tinyint(4) NOT NULL,
`ordernum` smallint(6) NOT NULL,
`parentorder` tinyint(4) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `familyID` (`gedcom`,`familyID`,`personID`),
KEY `personID` (`gedcom`,`personID`)
) ENGINE=MyISAM AUTO_INCREMENT=145577 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_image_tags;

CREATE TABLE `tng_image_tags` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`mediaID` int(11) NOT NULL,
`rtop` int(11) NOT NULL,
`rleft` int(11) NOT NULL,
`rheight` int(11) NOT NULL,
`rwidth` int(11) NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`persfamID` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `mediaID` (`mediaID`,`gedcom`,`persfamID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_languages;

CREATE TABLE `tng_languages` (
`languageID` smallint(6) NOT NULL AUTO_INCREMENT,
`display` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`folder` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`charset` varchar(30) COLLATE utf8_swedish_ci NOT NULL,
`norels` varchar(1) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`languageID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_places;

CREATE TABLE `tng_places` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`place` varchar(248) COLLATE utf8_swedish_ci NOT NULL,
`longitude` varchar(22) COLLATE utf8_swedish_ci DEFAULT NULL,
`latitude` varchar(22) COLLATE utf8_swedish_ci DEFAULT NULL,
`zoom` tinyint(4) DEFAULT NULL,
`placelevel` tinyint(4) DEFAULT NULL,
`temple` tinyint(4) NOT NULL,
`geoignore` tinyint(4) NOT NULL,
`notes` text COLLATE utf8_swedish_ci,
`changedate` datetime NOT NULL,
`changedby` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `place` (`gedcom`,`place`),
KEY `temple` (`temple`,`gedcom`,`place`)
) ENGINE=MyISAM AUTO_INCREMENT=11642 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_states;

CREATE TABLE `tng_states` (
`state` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_countries;

CREATE TABLE `tng_countries` (
`country` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`country`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_sources;

CREATE TABLE `tng_sources` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`sourceID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`callnum` varchar(120) COLLATE utf8_swedish_ci NOT NULL,
`type` varchar(20) COLLATE utf8_swedish_ci DEFAULT NULL,
`title` text COLLATE utf8_swedish_ci NOT NULL,
`author` text COLLATE utf8_swedish_ci NOT NULL,
`publisher` text COLLATE utf8_swedish_ci NOT NULL,
`other` text COLLATE utf8_swedish_ci NOT NULL,
`shorttitle` text COLLATE utf8_swedish_ci NOT NULL,
`comments` text COLLATE utf8_swedish_ci,
`actualtext` text COLLATE utf8_swedish_ci NOT NULL,
`repoID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`changedate` datetime NOT NULL,
`changedby` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `sourceID` (`gedcom`,`sourceID`),
KEY `changedate` (`changedate`),
FULLTEXT KEY `sourcetext` (`actualtext`)
) ENGINE=MyISAM AUTO_INCREMENT=2396 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_repositories;

CREATE TABLE `tng_repositories` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`repoID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`reponame` varchar(90) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`addressID` int(11) NOT NULL,
`changedate` datetime NOT NULL,
`changedby` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `repoID` (`gedcom`,`repoID`),
KEY `reponame` (`reponame`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_citations;

CREATE TABLE `tng_citations` (
`citationID` int(11) NOT NULL AUTO_INCREMENT,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`persfamID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`eventID` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`sourceID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`ordernum` float NOT NULL,
`description` text COLLATE utf8_swedish_ci NOT NULL,
`citedate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`citedatetr` date NOT NULL,
`citetext` text COLLATE utf8_swedish_ci NOT NULL,
`page` text COLLATE utf8_swedish_ci NOT NULL,
`quay` varchar(2) COLLATE utf8_swedish_ci NOT NULL,
`note` text COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`citationID`),
KEY `citation` (`gedcom`,`persfamID`,`eventID`,`sourceID`,`description`(20))
) ENGINE=MyISAM AUTO_INCREMENT=222566 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_reports;

CREATE TABLE `tng_reports` (
`reportID` int(11) NOT NULL AUTO_INCREMENT,
`reportname` varchar(80) COLLATE utf8_swedish_ci NOT NULL,
`reportdesc` text COLLATE utf8_swedish_ci NOT NULL,
`ranking` int(11) NOT NULL,
`display` text COLLATE utf8_swedish_ci NOT NULL,
`criteria` text COLLATE utf8_swedish_ci NOT NULL,
`orderby` text COLLATE utf8_swedish_ci NOT NULL,
`sqlselect` text COLLATE utf8_swedish_ci NOT NULL,
`active` tinyint(4) NOT NULL,
PRIMARY KEY (`reportID`),
KEY `reportname` (`reportname`),
KEY `ranking` (`ranking`)
) ENGINE=MyISAM AUTO_INCREMENT=291 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_events;

CREATE TABLE `tng_events` (
`eventID` int(11) NOT NULL AUTO_INCREMENT,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`persfamID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`eventtypeID` int(11) NOT NULL,
`eventdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`eventdatetr` date NOT NULL,
`eventplace` text COLLATE utf8_swedish_ci NOT NULL,
`age` varchar(12) COLLATE utf8_swedish_ci NOT NULL,
`agency` varchar(120) COLLATE utf8_swedish_ci NOT NULL,
`cause` varchar(90) COLLATE utf8_swedish_ci NOT NULL,
`addressID` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`parenttag` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`info` text COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`eventID`),
KEY `persfamID` (`gedcom`,`persfamID`),
KEY `eventplace` (`gedcom`,`eventplace`(20))
) ENGINE=MyISAM AUTO_INCREMENT=368318 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_eventtypes;

CREATE TABLE `tng_eventtypes` (
`eventtypeID` int(11) NOT NULL AUTO_INCREMENT,
`tag` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`description` varchar(90) COLLATE utf8_swedish_ci NOT NULL,
`display` text COLLATE utf8_swedish_ci NOT NULL,
`keep` tinyint(4) NOT NULL,
`collapse` tinyint(4) NOT NULL,
`ordernum` smallint(6) NOT NULL,
`ldsevent` tinyint(4) NOT NULL,
`type` char(1) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`eventtypeID`),
UNIQUE KEY `typetagdesc` (`type`,`tag`,`description`),
KEY `ordernum` (`ordernum`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_trees;

CREATE TABLE `tng_trees` (
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`treename` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`description` text COLLATE utf8_swedish_ci NOT NULL,
`owner` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`email` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`address` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`city` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
`state` varchar(30) COLLATE utf8_swedish_ci NOT NULL,
`country` varchar(30) COLLATE utf8_swedish_ci NOT NULL,
`zip` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`phone` varchar(30) COLLATE utf8_swedish_ci NOT NULL,
`secret` tinyint(4) NOT NULL,
`disallowgedcreate` tinyint(4) NOT NULL,
`disallowpdf` tinyint(4) NOT NULL,
`lastimportdate` datetime NOT NULL,
`importfilename` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`gedcom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_notelinks;

CREATE TABLE `tng_notelinks` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`persfamID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`xnoteID` int(11) NOT NULL,
`eventID` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`ordernum` float NOT NULL,
`secret` tinyint(4) NOT NULL,
PRIMARY KEY (`ID`),
KEY `notelinks` (`gedcom`,`persfamID`,`eventID`)
) ENGINE=MyISAM AUTO_INCREMENT=53993 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_xnotes;

CREATE TABLE `tng_xnotes` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`noteID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`note` text COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`ID`),
KEY `noteID` (`gedcom`,`noteID`),
FULLTEXT KEY `note` (`note`)
) ENGINE=MyISAM AUTO_INCREMENT=53993 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_users;

CREATE TABLE `tng_users` (
`userID` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`username` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`password` varchar(128) COLLATE utf8_swedish_ci NOT NULL,
`password_type` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(128) COLLATE utf8_swedish_ci DEFAULT NULL,
`mygedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`personID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`role` varchar(15) COLLATE utf8_swedish_ci 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_profile` tinyint(4) NOT NULL,
`branch` varchar(20) COLLATE utf8_swedish_ci DEFAULT NULL,
`realname` varchar(50) COLLATE utf8_swedish_ci DEFAULT NULL,
`phone` varchar(30) COLLATE utf8_swedish_ci DEFAULT NULL,
`email` varchar(50) COLLATE utf8_swedish_ci DEFAULT NULL,
`address` varchar(100) COLLATE utf8_swedish_ci DEFAULT NULL,
`city` varchar(64) COLLATE utf8_swedish_ci DEFAULT NULL,
`state` varchar(64) COLLATE utf8_swedish_ci DEFAULT NULL,
`zip` varchar(10) COLLATE utf8_swedish_ci DEFAULT NULL,
`country` varchar(64) COLLATE utf8_swedish_ci DEFAULT NULL,
`website` varchar(128) COLLATE utf8_swedish_ci 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 COLLATE utf8_swedish_ci,
PRIMARY KEY (`userID`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=1544 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_timelineevents;

CREATE TABLE `tng_timelineevents` (
`tleventID` int(11) NOT NULL AUTO_INCREMENT,
`evday` tinyint(4) NOT NULL,
`evmonth` tinyint(4) NOT NULL,
`evyear` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`endday` tinyint(4) NOT NULL,
`endmonth` tinyint(4) NOT NULL,
`endyear` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`evtitle` varchar(128) COLLATE utf8_swedish_ci NOT NULL,
`evdetail` text COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`tleventID`),
KEY `evyear` (`evyear`,`evmonth`,`evday`,`evdetail`(100)),
KEY `evdetail` (`evdetail`(100))
) ENGINE=MyISAM AUTO_INCREMENT=313 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_temp_events;

CREATE TABLE `tng_temp_events` (
`tempID` int(11) NOT NULL AUTO_INCREMENT,
`type` char(1) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`personID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`familyID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`eventID` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`eventdate` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`eventplace` text COLLATE utf8_swedish_ci NOT NULL,
`info` text COLLATE utf8_swedish_ci NOT NULL,
`note` text COLLATE utf8_swedish_ci NOT NULL,
`user` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`postdate` datetime NOT NULL,
PRIMARY KEY (`tempID`),
KEY `gedtype` (`gedcom`,`type`),
KEY `user` (`user`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_templates;

CREATE TABLE `tng_templates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`template` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
`ordernum` int(11) NOT NULL,
`keyname` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
`language` varchar(64) COLLATE utf8_swedish_ci NOT NULL,
`value` text COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `template` (`template`,`keyname`,`language`),
KEY `var_order` (`template`,`ordernum`)
) ENGINE=MyISAM AUTO_INCREMENT=8114 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_media;

CREATE TABLE `tng_media` (
`mediaID` int(11) NOT NULL AUTO_INCREMENT,
`mediatypeID` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`mediakey` varchar(255) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`form` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`path` varchar(255) COLLATE utf8_swedish_ci DEFAULT NULL,
`description` text COLLATE utf8_swedish_ci,
`datetaken` varchar(50) COLLATE utf8_swedish_ci DEFAULT NULL,
`placetaken` text COLLATE utf8_swedish_ci,
`notes` text COLLATE utf8_swedish_ci,
`owner` text COLLATE utf8_swedish_ci,
`thumbpath` varchar(255) COLLATE utf8_swedish_ci DEFAULT NULL,
`alwayson` tinyint(4) DEFAULT NULL,
`map` text COLLATE utf8_swedish_ci,
`abspath` tinyint(4) DEFAULT NULL,
`status` varchar(40) COLLATE utf8_swedish_ci DEFAULT NULL,
`showmap` smallint(6) DEFAULT NULL,
`cemeteryID` int(11) DEFAULT NULL,
`plot` text COLLATE utf8_swedish_ci,
`linktocem` tinyint(4) DEFAULT NULL,
`longitude` varchar(22) COLLATE utf8_swedish_ci DEFAULT NULL,
`latitude` varchar(22) COLLATE utf8_swedish_ci DEFAULT NULL,
`zoom` tinyint(4) DEFAULT NULL,
`width` smallint(6) DEFAULT NULL,
`height` smallint(6) DEFAULT NULL,
`bodytext` text COLLATE utf8_swedish_ci,
`usenl` tinyint(4) DEFAULT NULL,
`newwindow` tinyint(4) DEFAULT NULL,
`usecollfolder` tinyint(4) DEFAULT NULL,
`private` tinyint(4) DEFAULT NULL,
`changedate` datetime NOT NULL,
`changedby` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`mediaID`),
UNIQUE KEY `mediakey` (`gedcom`,`mediakey`),
KEY `mediatypeID` (`mediatypeID`),
KEY `changedate` (`changedate`),
KEY `description` (`description`(20)),
KEY `headstones` (`cemeteryID`,`description`(20))
) ENGINE=MyISAM AUTO_INCREMENT=5745 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_medialinks;

CREATE TABLE `tng_medialinks` (
`medialinkID` int(11) NOT NULL AUTO_INCREMENT,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`linktype` char(1) COLLATE utf8_swedish_ci NOT NULL,
`personID` varchar(248) COLLATE utf8_swedish_ci NOT NULL,
`eventID` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`mediaID` int(11) NOT NULL,
`altdescription` text COLLATE utf8_swedish_ci NOT NULL,
`altnotes` text COLLATE utf8_swedish_ci NOT NULL,
`ordernum` float NOT NULL,
`dontshow` tinyint(4) NOT NULL,
`defphoto` varchar(1) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`medialinkID`),
UNIQUE KEY `mediaID` (`gedcom`,`personID`,`mediaID`,`eventID`),
KEY `personID` (`gedcom`,`personID`,`ordernum`)
) ENGINE=MyISAM AUTO_INCREMENT=5956 DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_mediatypes;

CREATE TABLE `tng_mediatypes` (
`mediatypeID` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`display` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
`path` varchar(127) COLLATE utf8_swedish_ci NOT NULL,
`liketype` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`icon` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`thumb` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`exportas` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`disabled` tinyint(4) NOT NULL,
`ordernum` tinyint(4) NOT NULL,
`localpath` varchar(250) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`mediatypeID`),
KEY `ordernum` (`ordernum`,`display`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_mostwanted;

CREATE TABLE `tng_mostwanted` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`ordernum` float NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`mwtype` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`title` varchar(128) COLLATE utf8_swedish_ci NOT NULL,
`description` text COLLATE utf8_swedish_ci NOT NULL,
`personID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`mediaID` int(11) NOT NULL,
PRIMARY KEY (`ID`),
KEY `mwtype` (`mwtype`,`ordernum`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_dna_groups;

CREATE TABLE `tng_dna_groups` (
`dna_group` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`test_type` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`description` varchar(128) COLLATE utf8_swedish_ci NOT NULL,
`action` tinyint(4) NOT NULL,
PRIMARY KEY (`dna_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_dna_links;

CREATE TABLE `tng_dna_links` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`testID` int(11) NOT NULL,
`personID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`dna_group` varchar(128) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
DROP TABLE IF EXISTS tng_dna_tests;

CREATE TABLE `tng_dna_tests` (
`testID` int(11) NOT NULL AUTO_INCREMENT,
`test_type` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
`test_number` varchar(50) COLLATE utf8_swedish_ci NOT NULL,
`notes` text COLLATE utf8_swedish_ci NOT NULL,
`vendor` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`test_date` date NOT NULL,
`match_date` date NOT NULL,
`personID` varchar(22) COLLATE utf8_swedish_ci NOT NULL,
`gedcom` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`person_name` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`urls` text COLLATE utf8_swedish_ci NOT NULL,
`mtdna_haplogroup` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
`ydna_haplogroup` varchar(30) COLLATE utf8_swedish_ci NOT NULL,
`significant_snp` varchar(255) COLLATE utf8_swedish_ci NOT NULL,
`terminal_snp` varchar(80) COLLATE utf8_swedish_ci NOT NULL,
`markers` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
`y_results` varchar(512) COLLATE utf8_swedish_ci NOT NULL,
`hvr1_results` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`hvr2_results` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
`mtdna_confirmed` varchar(2) COLLATE utf8_swedish_ci NOT NULL,
`ydna_confirmed` varchar(2) COLLATE utf8_swedish_ci NOT NULL,
`markeropt` varchar(2) COLLATE utf8_swedish_ci NOT NULL,
`notesopt` varchar(2) COLLATE utf8_swedish_ci NOT NULL,
`linksopt` varchar(2) COLLATE utf8_swedish_ci NOT NULL,
`surnamesopt` tinyint(4) NOT NULL,
`private_dna` varchar(2) COLLATE utf8_swedish_ci NOT NULL,
`private_test` varchar(2) COLLATE utf8_swedish_ci NOT NULL,
`dna_group` varchar(128) COLLATE utf8_swedish_ci NOT NULL,
`dna_group_desc` varchar(128) COLLATE utf8_swedish_ci NOT NULL,
`surnames` text COLLATE utf8_swedish_ci NOT NULL,
`MD_ancestorID` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`MRC_ancestorID` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
`admin_notes` text COLLATE utf8_swedish_ci NOT NULL,
`medialinks` text COLLATE utf8_swedish_ci NOT NULL,
`ref_seq` text COLLATE utf8_swedish_ci NOT NULL,
`xtra_mut` text COLLATE utf8_swedish_ci NOT NULL,
`coding_reg` text COLLATE utf8_swedish_ci NOT NULL,
`GEDmatchID` varchar(30) COLLATE utf8_swedish_ci NOT NULL,
`relationship_range` varchar(80) COLLATE utf8_swedish_ci NOT NULL,
`suggested_relationship` varchar(80) COLLATE utf8_swedish_ci NOT NULL,
`actual_relationship` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
`related_side` varchar(120) COLLATE utf8_swedish_ci NOT NULL,
`shared_cMs` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`shared_segments` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`chromosome` varchar(4) COLLATE utf8_swedish_ci NOT NULL,
`segment_start` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
`segment_end` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
`centiMorgans` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
`matching_SNPs` varchar(10) COLLATE utf8_swedish_ci NOT NULL,
`x_match` varchar(2) COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`testID`),
KEY `test_date` (`test_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;


 

Au besoin Cliques ici pour m'envoyer un courriel.

Dernière modification : 20 mai 2025.