-- MySQL dump 10.10
--
-- Host: localhost    Database: myTest
-- ------------------------------------------------------
-- Server version	5.0.30-Debian_0.dotdeb.1-log

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `adhesion`
--

DROP TABLE IF EXISTS `adhesion`;
CREATE TABLE `adhesion` (
  `idadhesion` bigint(20) unsigned NOT NULL auto_increment,
  `idutilisateur` mediumint(8) unsigned NOT NULL default '0',
  `dateDeDebut` date NOT NULL default '0000-00-00',
  `dateDeFin` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`idadhesion`),
  KEY `debut` (`dateDeDebut`),
  KEY `fin` (`dateDeFin`),
  KEY `idutilisateur` (`idutilisateur`)
) ENGINE=MyISAM AUTO_INCREMENT=3110 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adhesion`
--

LOCK TABLES `adhesion` WRITE;
/*!40000 ALTER TABLE `adhesion` DISABLE KEYS */;
INSERT INTO `adhesion` VALUES (292,1059,'2005-01-01','2006-02-01'),(385,1012,'2005-01-01','2006-02-01'),(724,1061,'2005-01-01','2006-02-01'),(1175,1003,'2006-02-08','2007-02-08'),(1367,1003,'2006-02-08','2007-02-08'),(2244,1059,'2006-02-01','2007-02-01'),(2128,1061,'2006-02-01','2010-10-31');
/*!40000 ALTER TABLE `adhesion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comedien`
--

DROP TABLE IF EXISTS `comedien`;
CREATE TABLE `comedien` (
  `idutilisateur` mediumint(8) unsigned NOT NULL default '0',
  `idtrancheAge` tinyint(1) unsigned NOT NULL default '0',
  `idcouleurYeux` tinyint(2) unsigned NOT NULL default '0',
  `idcouleurCheveux` tinyint(2) unsigned NOT NULL default '0',
  `taille` tinyint(4) unsigned default NULL,
  `poids` tinyint(3) unsigned default NULL,
  `photographe` varchar(30) default NULL,
  `idagence` mediumint(8) unsigned default NULL,
  `idagent` mediumint(8) unsigned default NULL,
  `dateDeModification` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `sitePerso` varchar(255) default NULL,
  `idaffiliation` tinyint(4) NOT NULL default '1',
  `masquerTelPerso` enum('Y','N') NOT NULL default 'N' COMMENT 'Shall we mask the personal phone number for current users on the site',
  `masquerTelPortable` enum('Y','N') NOT NULL default 'N' COMMENT 'Shall we mask the cellular phone number for current users on the site',
  PRIMARY KEY  (`idutilisateur`),
  KEY `trancheAge` (`idtrancheAge`),
  KEY `couleurYeuxId` (`idcouleurYeux`),
  KEY `couleurCheveuxId` (`idcouleurCheveux`),
  KEY `agence` (`idagence`),
  KEY `agent` (`idagent`),
  KEY `idaffiliation` (`idaffiliation`),
  KEY `masquerTel` (`masquerTelPerso`),
  KEY `masquerTelPortable` (`masquerTelPortable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `comedien`
--

LOCK TABLES `comedien` WRITE;
/*!40000 ALTER TABLE `comedien` DISABLE KEYS */;
INSERT INTO `comedien` VALUES (1026,3,5,5,NULL,NULL,'Johannes von Saurma',10242,NULL,'2005-06-14 09:51:42',NULL,1,'N','N'),(1065,4,1,5,172,69,NULL,0,10330,'2005-11-15 12:12:20',NULL,1,'N','N'),(1058,3,8,3,156,50,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1059,3,7,5,172,62,NULL,0,10361,'2005-11-22 22:26:51',NULL,1,'N','N'),(1013,3,1,5,165,50,'Philippe Verms',NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1027,3,1,5,NULL,NULL,NULL,10403,10287,'2005-06-09 06:35:27',NULL,1,'N','N'),(1000,5,8,1,164,58,NULL,10242,NULL,'2005-06-14 09:51:42',NULL,1,'N','N'),(1001,3,1,5,NULL,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1016,5,1,8,NULL,NULL,'Wade H. Grimbly',0,10330,'2005-11-15 12:12:20',NULL,1,'N','N'),(1015,4,1,8,NULL,NULL,NULL,10400,NULL,'2005-11-15 12:11:43',NULL,1,'N','N'),(1014,2,1,8,NULL,NULL,NULL,10396,10290,'2005-06-09 06:35:27',NULL,1,'N','N'),(1012,1,8,5,NULL,NULL,NULL,NULL,NULL,'2005-11-22 22:26:51',NULL,1,'N','N'),(1011,5,1,8,NULL,NULL,'Yves Guibeaud',10415,10311,'2005-06-09 06:35:27',NULL,1,'N','N'),(1010,2,5,5,NULL,NULL,'Françoise Raybaud',10403,10288,'2005-06-09 06:35:27',NULL,1,'N','N'),(1009,2,5,4,181,75,NULL,10410,10299,'2005-06-09 06:35:27',NULL,1,'N','N'),(1008,1,1,5,NULL,NULL,NULL,NULL,10321,'2005-11-17 15:09:14',NULL,1,'N','N'),(1007,4,1,8,NULL,NULL,NULL,0,10365,'2005-11-15 12:12:20',NULL,1,'N','N'),(1006,2,5,4,180,75,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1025,2,8,4,178,NULL,NULL,10390,10373,'2005-06-09 06:35:27',NULL,1,'N','N'),(1005,0,1,8,NULL,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1075,0,1,8,NULL,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1031,3,6,3,NULL,NULL,'M. F Plissart',NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1055,2,1,5,166,NULL,NULL,10255,NULL,'2005-06-14 09:51:42',NULL,1,'N','N'),(1032,3,8,3,NULL,NULL,NULL,10403,10291,'2005-06-09 06:35:27',NULL,1,'N','N'),(1033,2,5,4,168,NULL,'Richard Baltauss',10393,10309,'2005-06-09 06:35:27',NULL,1,'N','N'),(1024,1,1,4,162,NULL,NULL,0,10338,'2005-11-15 12:12:20',NULL,1,'N','N'),(1020,1,1,5,NULL,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1078,3,1,3,NULL,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1054,4,5,4,175,70,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1035,5,5,4,NULL,NULL,'D.Peccoux',10242,NULL,'2005-06-14 09:51:42',NULL,1,'N','N'),(1017,1,5,5,169,49,'Françoise Raybaud',0,10338,'2005-11-15 12:12:20',NULL,1,'N','N'),(1034,2,5,8,NULL,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1061,4,5,8,NULL,NULL,'M. Peccoux',NULL,NULL,'2005-09-01 15:28:18',NULL,1,'N','N'),(1060,2,5,4,173,NULL,'D. Peccoux',10390,10373,'2005-06-09 06:35:27',NULL,1,'N','N'),(1074,0,1,8,NULL,NULL,NULL,10400,NULL,'2005-11-15 12:11:43',NULL,1,'N','N'),(1067,2,8,5,NULL,NULL,'Tadeusz Kokakowski',NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1022,2,7,5,NULL,NULL,'Dominique Mignon',0,10371,'2005-11-15 12:12:20',NULL,1,'N','N'),(1037,2,1,4,169,51,'Quenneville',10400,NULL,'2005-11-15 12:11:43',NULL,1,'N','N'),(1071,5,8,10,175,78,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1053,4,6,11,172,68,NULL,10403,10288,'2005-06-09 06:35:27',NULL,1,'N','N'),(1038,5,1,8,NULL,NULL,'André Rival',NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1070,2,1,5,168,64,'Delahaye',10413,10308,'2005-06-09 06:35:27',NULL,1,'N','N'),(1072,3,6,4,176,73,NULL,0,10330,'2005-11-15 12:12:20',NULL,1,'N','N'),(1030,0,5,4,192,85,'André Nisak',NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1052,4,1,3,NULL,NULL,NULL,0,10338,'2005-11-15 12:12:20',NULL,1,'N','N'),(1068,5,1,3,166,56,NULL,10401,NULL,'2005-06-14 09:51:42',NULL,1,'N','N'),(1003,3,5,5,184,75,NULL,NULL,NULL,'2006-10-19 14:12:32',NULL,1,'N','N'),(1056,4,1,5,NULL,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1050,1,7,5,162,NULL,NULL,10235,NULL,'2005-06-14 09:51:42',NULL,1,'N','N'),(1036,1,5,3,155,NULL,NULL,10242,NULL,'2005-06-14 09:51:42',NULL,1,'N','N'),(1063,2,8,5,182,70,'Bruno Vallet',NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1018,2,3,4,NULL,NULL,NULL,0,10333,'2005-11-15 12:12:20',NULL,1,'N','N'),(1062,3,8,5,187,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1076,3,8,5,183,NULL,'Marc Enguerand',0,10370,'2005-11-15 12:12:20',NULL,1,'N','N'),(1019,1,7,7,157,46,NULL,10413,10308,'2006-10-31 10:44:49',NULL,1,'N','N'),(1049,3,5,5,NULL,NULL,NULL,0,10371,'2005-11-15 12:12:20',NULL,1,'N','N'),(1064,3,5,5,184,80,'Dominique Mignon',NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1043,2,1,3,172,NULL,'Marc Enguerand',0,10361,'2005-11-15 12:12:20',NULL,1,'N','N'),(1044,4,8,1,169,NULL,NULL,0,10363,'2005-11-15 12:12:20',NULL,1,'N','N'),(1066,5,1,8,NULL,NULL,NULL,10255,NULL,'2005-06-14 09:51:42',NULL,1,'N','N'),(1069,5,1,2,184,95,'Gerard Gouery',10420,10306,'2005-06-09 06:35:27',NULL,1,'N','N'),(1042,5,1,7,165,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1046,2,8,8,170,NULL,NULL,0,10307,'2006-05-15 11:01:14',NULL,1,'N','N'),(1047,4,5,1,156,NULL,'Richard Baltauss',NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1073,4,5,7,190,80,NULL,0,10330,'2006-12-04 14:01:22',NULL,1,'N','N'),(1048,5,1,8,NULL,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1002,3,5,5,176,NULL,'D. Peccoux',10255,NULL,'2005-06-14 09:51:42',NULL,1,'N','N'),(1028,2,1,11,184,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1029,4,6,4,175,NULL,NULL,NULL,NULL,'2005-10-28 14:47:38',NULL,1,'N','N'),(1021,4,1,8,NULL,NULL,NULL,NULL,NULL,'2005-11-15 12:10:57',NULL,1,'N','N'),(1023,2,1,5,182,NULL,NULL,0,10338,'2005-11-15 12:12:20',NULL,1,'N','N'),(1040,1,1,11,NULL,NULL,NULL,0,10326,'2005-11-15 12:12:20',NULL,1,'N','N');
/*!40000 ALTER TABLE `comedien` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comedien_has_langue`
--

DROP TABLE IF EXISTS `comedien_has_langue`;
CREATE TABLE `comedien_has_langue` (
  `idlangue` tinyint(3) unsigned NOT NULL default '0',
  `idutilisateur` mediumint(8) unsigned NOT NULL default '0',
  `niveau` enum('1','2','3') NOT NULL default '1',
  PRIMARY KEY  (`idlangue`,`idutilisateur`),
  KEY `comedienId` (`idutilisateur`),
  KEY `niveau` (`niveau`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `comedien_has_langue`
--

LOCK TABLES `comedien_has_langue` WRITE;
/*!40000 ALTER TABLE `comedien_has_langue` DISABLE KEYS */;
INSERT INTO `comedien_has_langue` VALUES (2,1026,'3'),(20,1026,'2'),(14,1065,'2'),(2,1058,'2'),(14,1058,'1'),(20,1058,'1'),(2,1059,'2'),(14,1059,'1'),(14,1013,'2'),(2,1013,'2'),(20,1000,'1'),(2,1000,'2'),(20,1014,'2'),(1,1010,'1'),(2,1010,'1'),(2,1009,'3'),(1,1009,'3'),(20,1009,'1'),(2,1007,'2'),(14,1006,'2'),(2,1006,'2'),(2,1025,'2'),(3,1005,'1'),(14,1005,'1'),(20,1005,'1'),(2,1005,'1'),(2,1055,'2'),(20,1055,'2'),(32,1055,'2'),(2,1033,'3'),(2,1024,'3'),(1,1020,'1'),(2,1020,'1'),(2,1060,'3'),(2,1067,'2'),(2,1022,'1'),(2,1037,'2'),(2,1071,'1'),(20,1071,'1'),(1,1053,'1'),(2,1053,'3'),(14,1072,'1'),(2,1072,'2'),(2,1034,'2'),(2,1030,'3'),(2,1052,'3'),(14,1052,'1'),(20,1052,'1'),(2,1068,'2'),(20,1068,'1'),(2,1003,'2'),(1,1003,'1'),(20,1003,'1'),(2,1056,'2'),(14,1056,'1'),(2,1050,'2'),(2,1036,'2'),(1,1063,'1'),(2,1063,'2'),(1,1018,'1'),(2,1018,'2'),(2,1062,'2'),(2,1076,'2'),(2,1019,'1'),(2,1064,'3'),(14,1064,'2'),(2,1043,'1'),(20,1044,'1'),(2,1044,'2'),(2,1042,'1'),(20,1034,'3'),(2,1046,'3'),(1,1046,'3'),(29,1046,'2'),(20,1046,'2'),(14,1046,'2'),(2,1047,'2'),(14,1047,'2'),(2,1073,'2'),(1,1073,'1'),(2,1002,'2'),(1,1028,'1'),(2,1028,'2'),(3,1029,'3'),(2,1029,'1'),(2,1023,'3'),(1,1040,'3'),(2,1040,'2'),(24,1040,'2'),(32,1040,'1'),(2,1012,'2'),(14,1012,'1');
/*!40000 ALTER TABLE `comedien_has_langue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `couleurCheveux`
--

DROP TABLE IF EXISTS `couleurCheveux`;
CREATE TABLE `couleurCheveux` (
  `idcouleurCheveux` tinyint(2) unsigned NOT NULL default '0',
  `libeleFR` varchar(20) NOT NULL default '',
  `libeleEN` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`idcouleurCheveux`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `couleurCheveux`
--

LOCK TABLES `couleurCheveux` WRITE;
/*!40000 ALTER TABLE `couleurCheveux` DISABLE KEYS */;
INSERT INTO `couleurCheveux` VALUES (1,'auburn','auburn'),(2,'blanc','blanc'),(3,'blond','blond'),(4,'brun','dark'),(5,'châtain','chestnust'),(6,'chauve','bald-head'),(7,'gris','grey'),(8,'noir','black'),(9,'poivre & sel','pepper & salt'),(10,'rasé','shaven'),(11,'roux','red'),(12,'blond gris','grey'),(13,'blond vénitien','venitian blond'),(0,'inconnu','unknown');
/*!40000 ALTER TABLE `couleurCheveux` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `couleurYeux`
--

DROP TABLE IF EXISTS `couleurYeux`;
CREATE TABLE `couleurYeux` (
  `idcouleurYeux` tinyint(2) unsigned NOT NULL default '0',
  `libeleFR` varchar(20) NOT NULL default '',
  `libeleEN` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`idcouleurYeux`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `couleurYeux`
--

LOCK TABLES `couleurYeux` WRITE;
/*!40000 ALTER TABLE `couleurYeux` DISABLE KEYS */;
INSERT INTO `couleurYeux` VALUES (1,'bleu','blue'),(2,'gris bleu','grey blue'),(3,'gris vert','green grey'),(4,'gris','grey'),(5,'marron','chestnut'),(6,'noir','black'),(7,'noisette','Hazel'),(8,'vert','green'),(9,'vairons','wall-eyed'),(10,'pers','sea-green'),(11,'marron vert','chestnut green'),(0,'inconnu','unknown');
/*!40000 ALTER TABLE `couleurYeux` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `langue`
--

DROP TABLE IF EXISTS `langue`;
CREATE TABLE `langue` (
  `idlangue` tinyint(3) unsigned NOT NULL auto_increment,
  `nom_fr` varchar(50) NOT NULL default '',
  `nom_en` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`idlangue`),
  KEY `nomFR` (`nom_fr`),
  KEY `nomEN` (`nom_en`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `langue`
--

LOCK TABLES `langue` WRITE;
/*!40000 ALTER TABLE `langue` DISABLE KEYS */;
INSERT INTO `langue` VALUES (1,'Allemand','German'),(2,'Anglais','English'),(3,'Arabe','Arab'),(4,'Arménien','Armenian'),(5,'Brésilien','Brasilian'),(6,'Breton','Britton'),(7,'Bulgare','Bulgarian'),(8,'Cambodgien','Cambodgian'),(9,'Catalan','catalanou'),(10,'Chinois','Chinese'),(11,'Corse','Corsican'),(12,'Creole',''),(13,'Danois','Danish'),(14,'Espagnol','Spanish'),(15,'Flamand','Flemish'),(16,'Georgien','Georgian'),(17,'Grec','Greek'),(18,'Hébreu','Hebraic'),(19,'Hongrois','Hungarian'),(20,'Italien','Italian'),(21,'Japonais','Japanese'),(22,'Langue Signes','Sign la'),(23,'Marocain','Morocan'),(24,'Néerlandais','Dutch'),(25,'Norvégien','Norvegian'),(26,'Occitan','occiten'),(27,'Persan','Persic'),(28,'Polonais','Polish'),(29,'Portugais','Portuguese'),(30,'Provençal',''),(31,'Roumain','Rouman'),(32,'Russe','Russian'),(33,'Serbe','Serbian'),(34,'Serbo-croate','Serbo-cr'),(35,'Sicilien','Sicilian'),(36,'Suédois','Swedish'),(37,'Tchèque','Czech'),(38,'Thailandais','Thai'),(39,'Tunisien','Tunisian'),(40,'Turc','Turkish'),(41,'Croate','Cratian'),(42,'Vietnamien','Vietnamian'),(43,'Wallon','Walloon'),(44,'Yiddish',''),(45,'Dioula',''),(46,'Reunionnais',''),(47,'Malgache','Malagasy'),(48,'Slovène','Slovenian'),(49,'Indonesien','Indonesian'),(50,'Ukrainien','Ukrenian'),(51,'Hindi',''),(52,'Finnois','Finlandian'),(53,'Accent québéquois','French canadian'),(54,'Slovaque','Slovak'),(55,'Swahili','Swahili'),(56,'Alsacien','Alsacien dialect'),(57,'Islandais','Icelandian'),(58,'Accent belge','Belgium accent'),(59,'Patois wallon',''),(60,'Gypsy','Gypsy'),(61,'Estonien','Estonian'),(62,'Mandarin',''),(63,'Irlandais','Irish'),(64,'Wolof',''),(65,'Berbère',''),(66,'Afrikaans','Afrikaans'),(67,'Coréen','Korean'),(68,'Bambara','Bambara'),(69,'kabyle','kabyl'),(70,'Luxembourgeois','Luxembourgeois'),(71,'Ethiopien','Ethiopian'),(72,'Esperanto','Esperanto');
/*!40000 ALTER TABLE `langue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pays`
--

DROP TABLE IF EXISTS `pays`;
CREATE TABLE `pays` (
  `idpays` tinyint(3) unsigned NOT NULL auto_increment,
  `nom` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`idpays`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pays`
--

LOCK TABLES `pays` WRITE;
/*!40000 ALTER TABLE `pays` DISABLE KEYS */;
INSERT INTO `pays` VALUES (1,'France'),(4,'Belgique'),(3,'Suisse'),(2,'Allemagne'),(5,'Espagne'),(6,'GB'),(7,'Autriche'),(8,'Suède'),(9,'Italie'),(10,'Canada'),(11,'USA'),(12,'Luxembourg');
/*!40000 ALTER TABLE `pays` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trancheAge`
--

DROP TABLE IF EXISTS `trancheAge`;
CREATE TABLE `trancheAge` (
  `idtrancheAge` tinyint(1) unsigned NOT NULL default '0',
  `libeleFR` varchar(7) NOT NULL default '',
  `libeleEN` varchar(7) NOT NULL default '',
  PRIMARY KEY  (`idtrancheAge`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `trancheAge`
--

LOCK TABLES `trancheAge` WRITE;
/*!40000 ALTER TABLE `trancheAge` DISABLE KEYS */;
INSERT INTO `trancheAge` VALUES (1,'18/25','18/25'),(2,'25/35','25/35'),(3,'35/45','35/45'),(4,'45/55','45/55'),(5,'+ de 55','over 55'),(0,'inconnu','unknown');
/*!40000 ALTER TABLE `trancheAge` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `utilisateur`
--

DROP TABLE IF EXISTS `utilisateur`;
CREATE TABLE `utilisateur` (
  `idutilisateur` mediumint(8) unsigned NOT NULL auto_increment,
  `titre` enum('Monsieur','Madame','Mademoiselle') NOT NULL default 'Monsieur',
  `sexe` enum('M','F') NOT NULL default 'M',
  `nom` varchar(30) NOT NULL default '',
  `prenom` varchar(30) NOT NULL default '',
  `adresse1` varchar(80) default NULL,
  `adresse2` varchar(80) default NULL,
  `codePostal` varchar(10) default NULL,
  `idpays` tinyint(3) unsigned NOT NULL default '1',
  `ville` varchar(50) default NULL,
  `prefixeTel` varchar(4) default NULL,
  `telPerso` varchar(14) default NULL,
  `telPro` varchar(14) default NULL,
  `telPortable` varchar(14) default NULL,
  `fax` varchar(14) default NULL,
  `email` varchar(50) default NULL,
  `login` varchar(20) default NULL,
  `motDePasse` varchar(41) default NULL,
  `dateDeModification` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `dateDeCreation` timestamp NOT NULL default '0000-00-00 00:00:00',
  `idtypeUtilisateur` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`idutilisateur`),
  UNIQUE KEY `login` (`login`),
  KEY `email` (`email`),
  KEY `prenom` (`prenom`),
  KEY `nomPrenom` (`nom`,`prenom`),
  KEY `pays` (`idpays`),
  KEY `motDePasse` (`motDePasse`),
  KEY `typeId` (`idtypeUtilisateur`),
  FULLTEXT KEY `fullNomPrenom` (`nom`,`prenom`)
) ENGINE=MyISAM AUTO_INCREMENT=11183 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `utilisateur`
--

LOCK TABLES `utilisateur` WRITE;
/*!40000 ALTER TABLE `utilisateur` DISABLE KEYS */;
INSERT INTO `utilisateur` VALUES (1026,'Mademoiselle','F','Groves','Marianne',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1065,'Monsieur','M','Mons','Maurice',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1058,'Mademoiselle','F','Muche','Mona',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1059,'Monsieur','M','Schmitt','Vincent',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1013,'Mademoiselle','F','Viala-Laudiere','Claude',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1027,'Monsieur','M','Malet','Laurent',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1000,'Mademoiselle','F','Hamon','Lucienne',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1001,'Mademoiselle','F','Grinda','Lena',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1016,'Monsieur','M','Dore','Louis',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1015,'Monsieur','M','Dauphin','Jean-Claude',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1014,'Monsieur','M','Cosso','Pierre',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1012,'Madame','F','Bie','Alice',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1011,'Monsieur','M','Cancelier','Urbain',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1010,'Monsieur','M','Boucher','Eric',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1009,'Monsieur','M','Bonnet','Stephane',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1008,'Monsieur','M','Berger','Eric',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1007,'Monsieur','M','Beller','Georges',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1006,'Monsieur','M','Parquier','Jean-Christophe',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1025,'Monsieur','M','Baer','Edouard',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1005,'Monsieur','M','Allaoui','Karim',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1075,'Monsieur','M','Weinstadt','Michel',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1031,'Mademoiselle','F','Wauthion','Claire',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1055,'Mademoiselle','F','Vitali','Elisabeth',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1032,'Mademoiselle','F','Vincent','Helene',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1033,'Mademoiselle','F','Vinatier','Catherine',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1024,'Mademoiselle','F','Ulrich','Paula-Jane',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1020,'Mademoiselle','F','Esteban','Fanny',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1078,'Monsieur','M','Till','Olivier',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1054,'Monsieur','M','Martineau','Joel',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1035,'Mademoiselle','F','Silver','Veronique',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1017,'Mademoiselle','F','Serda','Romane',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1034,'Madame','F','Ella Meke','Beatrice',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1061,'Monsieur','M','Renucci','Robin',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1060,'Monsieur','M','Pierrot','Frederic',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1074,'Monsieur','M','Darmon','Gerard',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1067,'Monsieur','M','Pesenti','Bruno',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1022,'Monsieur','M','Veniger','Alain',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1037,'Mademoiselle','F','Meyssignac','Emmanuelle',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1071,'Monsieur','M','Mermet','Jean',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1053,'Mademoiselle','F','Mercier','Annie',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1038,'Mademoiselle','F','Medeiros','Ines',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1070,'Monsieur','M','Mazzuchini','Christian',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1072,'Monsieur','M','Mansouri','Pierre-Mourad',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1030,'Monsieur','M','Lesne','Franck',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1052,'Monsieur','M','Erickson','Christian',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1068,'Mademoiselle','F','Leiris','Noelle',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1003,'Monsieur','M','Laudiere','Herve',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1056,'Monsieur','M','Laudenbach','Philippe',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1050,'Mademoiselle','F','Larrivaz','Estelle',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1036,'Mademoiselle','F','de la Rochefoucauld','Sophie',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1063,'Monsieur','M','Hamel','Patrick',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1018,'Monsieur','M','Jaouen','Stephane',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1062,'Monsieur','M','Guillebon','Xavier',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1076,'Monsieur','M','Gonon','Christian',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1019,'Mademoiselle','F','Giachino','Garance',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1049,'Mademoiselle','F','Balestra','Anie',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1064,'Monsieur','M','Fouilland','Dominique',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1043,'Mademoiselle','F','Dreville','Valerie',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1044,'Mademoiselle','F','Derenne','Josephine',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1066,'Monsieur','M','Lecoeur','Vincent',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1069,'Monsieur','M','Corbeau','Johann',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1042,'Mademoiselle','F','Cleve','Jenny',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1046,'Mademoiselle','F','Chaniolleau','Caroline',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1047,'Mademoiselle','F','Cantrel','Frederique',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1073,'Monsieur','M','Boyer','Henri',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1048,'Mademoiselle','F','Borsch','Marie',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1002,'Monsieur','M','Bezace','Didier',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1028,'Monsieur','M','Benedetti','Christian',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1029,'Monsieur','M','Beghoura','Djelloul',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1021,'Monsieur','M','Dagnaud','Max',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1023,'Monsieur','M','Apps','Barnaby',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1),(1040,'Mademoiselle','F','Brafman','Sophie',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2007-01-03 15:44:18','2005-01-20 05:18:25',1);
/*!40000 ALTER TABLE `utilisateur` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2007-01-03 16:15:54