TNG Tables

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

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.11.11.3
-- http://www.phpmyadmin.net
-- Host: 10.8.11.7
-- Generation Time: Dec 20, 2011 at 07:40 PM
-- Server version: 4.0.30
-- PHP Version: 5.3.4

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES latin1 */;

-- Table structure for 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 '',
`www` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`phone` varchar(30) NOT NULL default '',
`gedcom` varchar(20) NOT NULL default '',
PRIMARY KEY (`addressID`),
KEY `address` (`gedcom`,`country`,`state`,`city`,`address1`)
) TYPE=MyISAM AUTO_INCREMENT=29 ;

-- --------------------------------------------------------

--
-- Table structure for 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,
`defphoto` char(1) NOT NULL default '',
PRIMARY KEY (`albumlinkID`),
KEY `albumID` (`albumID`,`ordernum`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tng_albumplinks`
--

CREATE TABLE `tng_albumplinks` (
`alinkID` int(11) NOT NULL auto_increment,
`gedcom` varchar(20) NOT NULL default '',
`linktype` char(1) NOT NULL default '',
`entityID` varchar(100) NOT NULL default '',
`eventID` varchar(10) NOT NULL default '',
`albumID` int(11) NOT NULL default '0',
`ordernum` float NOT NULL default '0',
PRIMARY KEY (`alinkID`),
UNIQUE KEY `alinkID` (`gedcom`,`entityID`,`albumID`),
KEY `entityID` (`gedcom`,`entityID`,`ordernum`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `tng_albums`
--

CREATE TABLE `tng_albums` (
`albumID` int(11) NOT NULL auto_increment,
`albumname` varchar(50) NOT NULL default '',
`description` text,
`keywords` text,
`active` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`albumID`),
KEY `albumname` (`albumname`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for 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 '',
`reltype` char(1) NOT NULL default '',
`relationship` varchar(25) NOT NULL default '',
PRIMARY KEY (`assocID`),
KEY `assoc` (`gedcom`,`personID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for 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`)
) TYPE=MyISAM;

-- --------------------------------------------------------

--
-- Table structure for 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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for 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(20) default NULL,
`latitude` varchar(20) default NULL,
`zoom` tinyint(4) default NULL,
`notes` text,
`place` varchar(248) NOT NULL default '',
PRIMARY KEY (`cemeteryID`),
KEY `cemname` (`cemname`),
KEY `place` (`place`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for 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 '',
`frel` varchar(20) NOT NULL default '',
`mrel` 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`)
) TYPE=MyISAM AUTO_INCREMENT=888354 ;

-- --------------------------------------------------------

--
-- Table structure for 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 '',
`ordernum` float NOT NULL default '0',
`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` char(2) NOT NULL default '',
`note` text NOT NULL,
PRIMARY KEY (`citationID`),
KEY `citation` (`gedcom`,`persfamID`,`eventID`,`sourceID`,`description`)
) TYPE=MyISAM AUTO_INCREMENT=1295548 ;

-- --------------------------------------------------------

--
-- Table structure for table `tng_countries`
--

CREATE TABLE `tng_countries` (
`country` varchar(64) NOT NULL default '',
PRIMARY KEY (`country`)
) TYPE=MyISAM;

-- --------------------------------------------------------

--
-- Table structure for 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 `eventplace` (`gedcom`,`eventplace`(20))
) TYPE=MyISAM AUTO_INCREMENT=1456159 ;

-- --------------------------------------------------------

--
-- Table structure for 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`)
) TYPE=MyISAM AUTO_INCREMENT=79 ;

-- --------------------------------------------------------

--
-- Table structure for 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',
`private` 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`)
) TYPE=MyISAM AUTO_INCREMENT=735332 ;

-- --------------------------------------------------------

--
-- Table structure for 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`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for 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) NOT NULL default '',
`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,
`plot` text,
`linktocem` tinyint(4) default NULL,
`longitude` varchar(20) default NULL,
`latitude` varchar(20) 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,
`changedby` varchar(20) NOT NULL default '',
PRIMARY KEY (`mediaID`),
UNIQUE KEY `mediakey` (`gedcom`,`mediakey`),
KEY `mediatypeID` (`mediatypeID`),
KEY `changedate` (`changedate`),
KEY `description` (`description`(20)),
KEY `headstones` (`cemeteryID`,`description`(20))
) TYPE=MyISAM AUTO_INCREMENT=1203 ;

-- --------------------------------------------------------

--
-- Table structure for 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',
`dontshow` tinyint(4) 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`)
) TYPE=MyISAM AUTO_INCREMENT=1265 ;

-- --------------------------------------------------------

--
-- Table structure for table `tng_mediatypes`
--

CREATE TABLE `tng_mediatypes` (
`mediatypeID` varchar(20) NOT NULL default '',
`display` varchar(40) NOT NULL default '',
`path` varchar(127) NOT NULL default '',
`liketype` varchar(20) NOT NULL default '',
`icon` varchar(50) NOT NULL default '',
`thumb` varchar(50) NOT NULL default '',
`ordernum` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`mediatypeID`),
KEY `ordernum` (`ordernum`,`display`)
) TYPE=MyISAM;

-- --------------------------------------------------------

--
-- Table structure for table `tng_mostwanted`
--

CREATE TABLE `tng_mostwanted` (
`ID` int(11) NOT NULL auto_increment,
`ordernum` float NOT NULL default '0',
`gedcom` varchar(20) NOT NULL default '',
`mwtype` varchar(10) NOT NULL default '',
`title` varchar(128) NOT NULL default '',
`description` text NOT NULL,
`personID` varchar(22) NOT NULL default '',
`mediaID` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `mwtype` (`mwtype`,`ordernum`,`title`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for 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 '',
`ordernum` float NOT NULL default '0',
`secret` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `notelinks` (`gedcom`,`persfamID`,`eventID`)
) TYPE=MyISAM AUTO_INCREMENT=204035 ;

-- --------------------------------------------------------

--
-- Table structure for 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 '',
`altbirthdatetr` date NOT NULL default '0000-00-00',
`altbirthplace` text NOT NULL,
`burialdate` varchar(50) NOT NULL default '',
`burialdatetr` date NOT NULL default '0000-00-00',
`burialplace` text NOT NULL,
`baptdate` varchar(50) NOT NULL default '',
`baptdatetr` date NOT NULL default '0000-00-00',
`baptplace` text NOT NULL,
`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,
`prefix` tinytext NOT NULL,
`suffix` tinytext NOT NULL,
`nameorder` tinyint(4) NOT NULL default '0',
`famc` varchar(22) default NULL,
`metaphone` varchar(15) NOT NULL default '',
`living` tinyint(4) NOT NULL default '0',
`private` 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 `changedate` (`changedate`),
KEY `birthplace` (`birthplace`(20)),
KEY `altbirthplace` (`altbirthplace`(20)),
KEY `deathplace` (`deathplace`(20)),
KEY `burialplace` (`burialplace`(20)),
KEY `famc` (`gedcom`,`famc`)
) TYPE=MyISAM AUTO_INCREMENT=1571255 ;

-- --------------------------------------------------------

--
-- Table structure for 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(20) default NULL,
`latitude` varchar(20) default NULL,
`zoom` tinyint(4) default NULL,
`placelevel` tinyint(4) default NULL,
`temple` tinyint(4) NOT NULL default '0',
`notes` text,
PRIMARY KEY (`ID`),
UNIQUE KEY `place` (`gedcom`,`place`),
KEY `temple` (`temple`,`gedcom`,`place`)
) TYPE=MyISAM AUTO_INCREMENT=61220 ;

-- --------------------------------------------------------

--
-- Table structure for 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`)
) TYPE=MyISAM AUTO_INCREMENT=200 ;

-- --------------------------------------------------------

--
-- Table structure for 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`)
) TYPE=MyISAM AUTO_INCREMENT=371 ;

-- --------------------------------------------------------

--
-- Table structure for 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,
`branch` 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`)
) TYPE=MyISAM AUTO_INCREMENT=45 ;

-- --------------------------------------------------------

--
-- Table structure for 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`),
FULLTEXT KEY `sourcetext` (`actualtext`)
) TYPE=MyISAM AUTO_INCREMENT=16302 ;

-- --------------------------------------------------------

--
-- Table structure for table `tng_states`
--

CREATE TABLE `tng_states` (
`state` varchar(64) NOT NULL default '',
PRIMARY KEY (`state`)
) TYPE=MyISAM;

-- --------------------------------------------------------

--
-- Table structure for 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`)
) TYPE=MyISAM AUTO_INCREMENT=54 ;

-- --------------------------------------------------------

--
-- Table structure for 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 '',
`endday` tinyint(4) NOT NULL default '0',
`endmonth` tinyint(4) NOT NULL default '0',
`endyear` varchar(10) NOT NULL default '',
`evdetail` text NOT NULL,
PRIMARY KEY (`tleventID`),
KEY `evyear` (`evyear`,`evmonth`,`evday`,`evdetail`(100)),
KEY `evdetail` (`evdetail`(100))
) TYPE=MyISAM AUTO_INCREMENT=313 ;

-- --------------------------------------------------------

--
-- Table structure for 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`)
) TYPE=MyISAM;

-- --------------------------------------------------------

--
-- Table structure for 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(128) NOT NULL default '',
`password_type` varchar(10) NOT NULL default '',
`gedcom` varchar(20) default NULL,
`mygedcom` varchar(20) NOT NULL default '',
`personID` varchar(22) NOT NULL default '',
`role` varchar(15) NOT NULL default '',
`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`)
) TYPE=MyISAM AUTO_INCREMENT=138 ;

-- --------------------------------------------------------

--
-- Table structure for 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`),
FULLTEXT KEY `note` (`note`)
) TYPE=MyISAM AUTO_INCREMENT=204036 ;

mwl

Au besoin Cliques ici pour m'envoyer un courriel.

Dernière modification : 11 janvier 2017.


tng_addresses tng_albumlinks tng_albums tng_associations tng_branches tng_branchlinks tng_cemeteries tng_children tng_citations tng_countries	tng_events tng_eventtypes tng_families tng_languages tng_media tng_medialinks tng_notelinks tng_people tng_places tng_reports	tng_repositories tng_saveimport tng_sources tng_states tng_temp_events tng_timelineevents tng_trees tng_users tng_xnotes