Noms des tables et des champs dans la base des données TNG
Modifications avec TNG V7.1.2
Les tables suivantes ont été modifiées par
TNG 7.1.2
ALTER TABLE tng_events ADD INDEX eventplace (gedcom, eventplace(20)) ... done
ALTER TABLE tng_media MODIFY gedcom VARCHAR(20) NOT NULL ... done
ALTER TABLE tng_sources ADD FULLTEXT sourcetext (actualtext) ... done
ALTER TABLE tng_timelineevents ADD endday TINYINT(4) NOT NULL after evyear ...
done
ALTER TABLE tng_timelineevents ADD endmonth TINYINT(4) NOT NULL after endday ...
done
ALTER TABLE tng_timelineevents ADD endyear VARCHAR(10) NOT NULL after endmonth
... done
Cette liste est
obtenue avec une exportation SQL de la structure de la base de données sur le
serveur. Ceci indique les noms de table et de champs à utiliser dans nos
requêtes SQL.
Les Tables :
phpMyAdmin SQL Dump
. version 2.9.1.1 . http://www.phpmyadmin.net
Serveur: 10.8.11.144. Généré le : Dimanche 04 Novembre 2007 à 17:57.
Version du serveur: 4.1.22. Version de PHP: 4.4.4
Base de données: XXXXX
--------------------------------------------------------
CREATE DATABASE `XXXXX DEFAULT CHARACTER SET utf8 COLLATE
utf8_general_ci;
USE `XXXXX`;
--------------------------------------------------------
Structure de la table `tng_addresses`
CREATE TABLE `tng_addresses
addressID int(11) NOT NULL auto_increment
address1 varchar(64) NOT NULL default
address2 varchar(64) NOT NULL default
city varchar(64) NOT NULL default
state varchar(64) NOT NULL default
zip varchar(10) NOT NULL default
country varchar(64) NOT NULL default
gedcom varchar(20) NOT NULL default
PRIMARY KEY (`addressID`)
KEY `address (`gedcom`,`country`,`state`,`city`,`address1`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
--------------------------------------------------------
Structure de la table `tng_albumlinks`
CREATE TABLE `tng_albumlinks
albumlinkID int(11) NOT NULL auto_increment
albumID int(11) NOT NULL default '0'
mediaID int(11) NOT NULL default '0'
ordernum int(11) default NULL
PRIMARY KEY (`albumlinkID`)
KEY `albumID (`albumID`,`ordernum`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
--------------------------------------------------------
Structure de la table `tng_albums`
CREATE TABLE `tng_albums
albumID int(11) NOT NULL auto_increment
albumname varchar(50) NOT NULL default
description text
keywords text
PRIMARY KEY (`albumID`)
KEY `albumname (`albumname`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--------------------------------------------------------
Structure de la table `tng_associations`
CREATE TABLE `tng_associations
assocID int(11) NOT NULL auto_increment
gedcom varchar(20) NOT NULL default
personID varchar(22) NOT NULL default
passocID varchar(22) NOT NULL default
relationship varchar(25) NOT NULL default
PRIMARY KEY (`assocID`)
KEY `assoc (`gedcom`,`personID`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--------------------------------------------------------
Structure de la table `tng_branches`
CREATE TABLE `tng_branches
branch varchar(20) NOT NULL default
gedcom varchar(20) NOT NULL default
description varchar(128) NOT NULL default
PRIMARY KEY (`branch`)
KEY `description (`gedcom`,`description`)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--------------------------------------------------------
Structure de la table `tng_branchlinks`
CREATE TABLE `tng_branchlinks
ID int(11) NOT NULL auto_increment
branch varchar(20) NOT NULL default
gedcom varchar(20) NOT NULL default
persfamID varchar(22) NOT NULL default
PRIMARY KEY (`ID`)
UNIQUE KEY `branch (`gedcom`,`branch`,`persfamID`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--------------------------------------------------------
Structure de la table `tng_cemeteries`
CREATE TABLE `tng_cemeteries
cemeteryID int(11) NOT NULL auto_increment
cemname varchar(64) NOT NULL default
maplink varchar(64) default NULL
city varchar(64) default NULL
county varchar(64) default NULL
state varchar(64) default NULL
country varchar(64) default NULL
longitude varchar(10) default NULL
latitude varchar(10) default NULL
zoom tinyint(4) default NULL
notes text
PRIMARY KEY (`cemeteryID`)
KEY `cemname (`cemname`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--------------------------------------------------------
Structure de la table `tng_children`
CREATE TABLE `tng_children
ID int(11) NOT NULL auto_increment
gedcom varchar(20) NOT NULL default
familyID varchar(22) NOT NULL default
personID varchar(22) NOT NULL default
relationship varchar(20) NOT NULL default
sealdate varchar(50) NOT NULL default
sealdatetr date NOT NULL default '0000-00-00'
sealplace text NOT NULL
haskids tinyint(4) NOT NULL default '0'
ordernum smallint(6) NOT NULL default '0'
parentorder tinyint(4) NOT NULL default '0'
PRIMARY KEY (`ID`)
UNIQUE KEY `familyID (`gedcom`,`familyID`,`personID`)
KEY `personID (`gedcom`,`personID`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25460 ;
--------------------------------------------------------
Structure de la table `tng_citations`
CREATE TABLE `tng_citations
citationID int(11) NOT NULL auto_increment
gedcom varchar(20) NOT NULL default
persfamID varchar(22) NOT NULL default
eventID varchar(10) NOT NULL default
sourceID varchar(22) NOT NULL default
description varchar(128) NOT NULL default
citedate varchar(50) NOT NULL default
citedatetr date NOT NULL default '0000-00-00'
citetext text NOT NULL
page text NOT NULL
quay varchar(2) NOT NULL default
note text NOT NULL
PRIMARY KEY (`citationID`)
KEY `citation (`gedcom`,`persfamID`,`eventID`,`sourceID`,`description`)
KEY `citations_fk3 (`gedcom`,`sourceID`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25093 ;
--------------------------------------------------------
Structure de la table `tng_countries`
CREATE TABLE `tng_countries
country varchar(64) NOT NULL default
PRIMARY KEY (`country`)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--------------------------------------------------------
Structure de la table `tng_events`
CREATE TABLE `tng_events
eventID int(11) NOT NULL auto_increment
gedcom varchar(20) NOT NULL default
persfamID varchar(22) NOT NULL default
eventtypeID int(11) NOT NULL default '0'
eventdate varchar(50) NOT NULL default
eventdatetr date NOT NULL default '0000-00-00'
eventplace text NOT NULL
age varchar(12) NOT NULL default
agency varchar(120) NOT NULL default
cause varchar(90) NOT NULL default
addressID varchar(10) NOT NULL default
parenttag varchar(10) NOT NULL default
info text NOT NULL
PRIMARY KEY (`eventID`)
KEY `persfamID (`gedcom`,`persfamID`)
KEY `events_fk4 (`eventtypeID`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=70973 ;
--------------------------------------------------------
Structure de la table `tng_eventtypes`
CREATE TABLE `tng_eventtypes
eventtypeID int(11) NOT NULL auto_increment
tag varchar(10) NOT NULL default
description varchar(90) NOT NULL default
display text NOT NULL
keep tinyint(4) NOT NULL default '0'
ordernum smallint(6) NOT NULL default '0'
type char(1) NOT NULL default
PRIMARY KEY (`eventtypeID`)
UNIQUE KEY `typetagdesc (`type`,`tag`,`description`)
KEY `ordernum (`ordernum`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
--------------------------------------------------------
Structure de la table `tng_families`
CREATE TABLE `tng_families
ID int(11) NOT NULL auto_increment
gedcom varchar(20) NOT NULL default
familyID varchar(22) NOT NULL default
husband varchar(22) NOT NULL default
wife varchar(22) NOT NULL default
marrdate varchar(50) NOT NULL default
marrdatetr date NOT NULL default '0000-00-00'
marrplace text NOT NULL
marrtype varchar(50) NOT NULL default
divdate varchar(50) NOT NULL default
divdatetr date NOT NULL default '0000-00-00'
divplace text NOT NULL
status varchar(20) NOT NULL default
sealdate varchar(50) NOT NULL default
sealdatetr date NOT NULL default '0000-00-00'
sealplace text NOT NULL
husborder tinyint(4) NOT NULL default '0'
wifeorder tinyint(4) NOT NULL default '0'
changedate datetime NOT NULL default '0000-00-00 00:00:00'
living tinyint(4) NOT NULL default '0'
branch varchar(100) NOT NULL default
changedby varchar(20) NOT NULL default
PRIMARY KEY (`ID`)
UNIQUE KEY `familyID (`gedcom`,`familyID`)
KEY `husband (`gedcom`,`husband`)
KEY `wife (`gedcom`,`wife`)
KEY `changedate (`changedate`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21897 ;
--------------------------------------------------------
Structure de la table `tng_languages`
CREATE TABLE `tng_languages
languageID smallint(6) NOT NULL auto_increment
display varchar(100) NOT NULL default
folder varchar(50) NOT NULL default
charset varchar(30) NOT NULL default
PRIMARY KEY (`languageID`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--------------------------------------------------------
Structure de la table `tng_media`
CREATE TABLE `tng_media
mediaID int(11) NOT NULL auto_increment
mediatypeID varchar(20) NOT NULL default
mediakey varchar(127) NOT NULL default
gedcom varchar(20) default NULL
form varchar(10) NOT NULL default
path varchar(127) default NULL
description text
datetaken varchar(50) default NULL
placetaken text
notes text
owner text
thumbpath varchar(127) default NULL
alwayson tinyint(4) default NULL
map text
abspath tinyint(4) default NULL
status varchar(40) default NULL
showmap smallint(6) default NULL
cemeteryID int(11) default NULL
linktocem tinyint(4) default NULL
longitude varchar(10) default NULL
latitude varchar(10) default NULL
zoom tinyint(4) default NULL
width smallint(6) default NULL
height smallint(6) default NULL
bodytext text
usenl tinyint(4) default NULL
newwindow tinyint(4) default NULL
usecollfolder tinyint(4) default NULL
changedate datetime default 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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;
--------------------------------------------------------
Structure de la table `tng_medialinks`
CREATE TABLE `tng_medialinks
medialinkID int(11) NOT NULL auto_increment
gedcom varchar(20) NOT NULL default
linktype char(1) NOT NULL default
personID varchar(100) NOT NULL default
eventID varchar(10) NOT NULL default
mediaID int(11) NOT NULL default '0'
altdescription text NOT NULL
altnotes text NOT NULL
ordernum float NOT NULL default '0'
defphoto char(1) NOT NULL default
PRIMARY KEY (`medialinkID`)
UNIQUE KEY `mediaID (`gedcom`,`personID`,`mediaID`,`eventID`)
KEY `personID (`gedcom`,`personID`,`ordernum`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;
--------------------------------------------------------
Structure de la table `tng_notelinks`
CREATE TABLE `tng_notelinks
ID int(11) NOT NULL auto_increment
persfamID varchar(22) NOT NULL default
gedcom varchar(20) NOT NULL default
xnoteID int(11) NOT NULL default '0'
eventID varchar(10) NOT NULL default
secret tinyint(4) NOT NULL default '0'
PRIMARY KEY (`ID`)
KEY `notelinks (`gedcom`,`persfamID`,`eventID`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6286 ;
--------------------------------------------------------
Structure de la table `tng_people`
CREATE TABLE `tng_people
ID int(11) NOT NULL auto_increment
gedcom varchar(20) NOT NULL default
personID varchar(22) NOT NULL default
lnprefix varchar(25) NOT NULL default
lastname varchar(127) NOT NULL default
firstname varchar(127) NOT NULL default
birthdate varchar(50) NOT NULL default
birthdatetr date NOT NULL default '0000-00-00'
sex tinytext NOT NULL
birthplace text NOT NULL
deathdate varchar(50) NOT NULL default
deathdatetr date NOT NULL default '0000-00-00'
deathplace text NOT NULL
altbirthdate varchar(50) NOT NULL default (Baptême selon le
code Gedcom CHR)
altbirthdatetr date NOT NULL default '0000-00-00' (Baptême
selon le code Gedcom CHR)
altbirthplace text NOT NULL (Baptême selon le code Gedcom
CHR)
burialdate varchar(50) NOT NULL default
burialdatetr date NOT NULL default '0000-00-00'
burialplace text NOT NULL
baptdate varchar(50) NOT NULL default (Baptême selon le mode
LDS)
baptdatetr date NOT NULL default '0000-00-00' (Baptême selon
le mode LDS)
baptplace text NOT NULL (Baptême selon le mode LDS)
endldate varchar(50) NOT NULL default
endldatetr date NOT NULL default '0000-00-00'
endlplace text NOT NULL
changedate datetime NOT NULL default '0000-00-00 00:00:00'
nickname text NOT NULL
title tinytext NOT NULL
suffix tinytext NOT NULL
nameorder tinyint(4) NOT NULL default '0'
famc varchar(22) NOT NULL default
metaphone varchar(15) NOT NULL default
living tinyint(4) NOT NULL default '0'
branch varchar(100) NOT NULL default
changedby varchar(20) NOT NULL default
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 `changedate (`changedate`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=45876 ;
--------------------------------------------------------
Structure de la table `tng_places`
CREATE TABLE `tng_places
ID int(11) NOT NULL auto_increment
gedcom varchar(20) NOT NULL default
place varchar(248) NOT NULL default
longitude varchar(10) default NULL
latitude varchar(10) default NULL
zoom tinyint(4) default NULL
placelevel tinyint(4) default NULL
notes text
PRIMARY KEY (`ID`)
UNIQUE KEY `place (`gedcom`,`place`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2631 ;
--------------------------------------------------------
Structure de la table `tng_reports`
CREATE TABLE `tng_reports
reportID int(11) NOT NULL auto_increment
reportname varchar(80) NOT NULL default
reportdesc text NOT NULL
rank int(11) NOT NULL default '0'
display text NOT NULL
criteria text NOT NULL
orderby text NOT NULL
sqlselect text NOT NULL
active tinyint(4) NOT NULL default '0'
PRIMARY KEY (`reportID`)
KEY `reportname (`reportname`)
KEY `rank (`rank`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=143 ;
--------------------------------------------------------
Structure de la table `tng_repositories`
CREATE TABLE `tng_repositories
ID int(11) NOT NULL auto_increment
repoID varchar(22) NOT NULL default
reponame varchar(90) NOT NULL default
gedcom varchar(20) NOT NULL default
addressID int(11) NOT NULL default '0'
changedate datetime NOT NULL default '0000-00-00 00:00:00'
changedby varchar(20) NOT NULL default
PRIMARY KEY (`ID`)
UNIQUE KEY `repoID (`gedcom`,`repoID`)
KEY `reponame (`reponame`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
--------------------------------------------------------
Structure de la table `tng_saveimport`
CREATE TABLE `tng_saveimport
ID tinyint(4) NOT NULL auto_increment
filename varchar(100) default NULL
icount int(11) default NULL
ioffset int(11) default NULL
fcount int(11) default NULL
foffset int(11) default NULL
scount int(11) default NULL
soffset int(11) default NULL
offset int(11) default NULL
delvar varchar(10) default NULL
gedcom varchar(20) default NULL
ncount int(11) default NULL
noffset int(11) default NULL
rcount int(11) default NULL
roffset int(11) default NULL
mcount int(11) default NULL
ucaselast tinyint(4) default NULL
norecalc tinyint(4) default NULL
media tinyint(4) default NULL
neweronly tinyint(4) default NULL
lasttype tinyint(4) default NULL
lastid varchar(22) default NULL
PRIMARY KEY (`ID`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--------------------------------------------------------
Structure de la table `tng_sources`
CREATE TABLE `tng_sources
ID int(11) NOT NULL auto_increment
gedcom varchar(20) NOT NULL default
sourceID varchar(22) NOT NULL default
callnum varchar(50) NOT NULL default
type varchar(20) default NULL
title text NOT NULL
author text NOT NULL
publisher text NOT NULL
other text NOT NULL
shorttitle text NOT NULL
comments text
actualtext text NOT NULL
repoID varchar(22) NOT NULL default
changedate datetime NOT NULL default '0000-00-00 00:00:00'
changedby varchar(20) NOT NULL default
PRIMARY KEY (`ID`)
UNIQUE KEY `sourceID (`gedcom`,`sourceID`)
KEY `changedate (`changedate`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=382 ;
--------------------------------------------------------
Structure de la table `tng_states`
CREATE TABLE `tng_states
state varchar(64) NOT NULL default
PRIMARY KEY (`state`)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--------------------------------------------------------
Structure de la table `tng_temp_events`
CREATE TABLE `tng_temp_events
tempID int(11) NOT NULL auto_increment
type char(1) NOT NULL default
gedcom varchar(20) NOT NULL default
personID varchar(22) NOT NULL default
familyID varchar(22) NOT NULL default
eventID varchar(10) NOT NULL default
eventdate varchar(50) NOT NULL default
eventplace text NOT NULL
info text NOT NULL
note text NOT NULL
user varchar(20) NOT NULL default
postdate datetime default NULL
PRIMARY KEY (`tempID`)
KEY `gedtype (`gedcom`,`type`)
KEY `user (`user`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--------------------------------------------------------
Structure de la table `tng_timelineevents`
CREATE TABLE `tng_timelineevents
tleventID int(11) NOT NULL auto_increment
evday tinyint(4) default NULL
evmonth tinyint(4) default NULL
evyear varchar(10) NOT NULL default
evdetail text NOT NULL
PRIMARY KEY (`tleventID`)
KEY `evyear (`evyear`,`evmonth`,`evday`,`evdetail`(100))
KEY `evdetail (`evdetail`(100))
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--------------------------------------------------------
Structure de la table `tng_trees`
CREATE TABLE `tng_trees
gedcom varchar(20) NOT NULL default
treename varchar(100) NOT NULL default
description text NOT NULL
owner varchar(100) NOT NULL default
email varchar(100) NOT NULL default
address varchar(100) NOT NULL default
city varchar(40) NOT NULL default
state varchar(30) NOT NULL default
country varchar(30) NOT NULL default
zip varchar(20) NOT NULL default
phone varchar(30) NOT NULL default
secret tinyint(4) NOT NULL default '0'
disallowgedcreate tinyint(4) NOT NULL default '0'
lastimportdate datetime default NULL
PRIMARY KEY (`gedcom`)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
--------------------------------------------------------
Structure de la table `tng_users`
CREATE TABLE `tng_users
userID int(11) NOT NULL auto_increment
description varchar(50) NOT NULL default
username varchar(100) NOT NULL default
password varchar(100) NOT NULL default
gedcom varchar(20) default NULL
allow_edit tinyint(4) NOT NULL default '0'
allow_add tinyint(4) NOT NULL default '0'
tentative_edit tinyint(4) NOT NULL default '0'
allow_delete tinyint(4) NOT NULL default '0'
allow_lds tinyint(4) NOT NULL default '0'
allow_ged tinyint(4) NOT NULL default '0'
allow_living tinyint(4) NOT NULL default '0'
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
lastlogin datetime default NULL
dt_registered datetime default NULL
dt_activated datetime default NULL
no_email tinyint(4) default NULL
notes text
PRIMARY KEY (`userID`)
UNIQUE KEY `username (`username`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--------------------------------------------------------
Structure de la table `tng_xnotes`
CREATE TABLE `tng_xnotes
ID int(11) NOT NULL auto_increment
noteID varchar(22) NOT NULL default
gedcom varchar(20) NOT NULL default
note text NOT NULL
PRIMARY KEY (`ID`)
KEY `noteID (`gedcom`,`noteID`)
KEY `xnotes_fk1 (`gedcom`,`ID`)
FULLTEXT KEY `note (`note`)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6286 ;
mwl
Au besoin Cliques ici pour m'envoyer un courriel.
Dernière modification : 11 janvier 2017.