# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Serveur: localhost
# Généré le : Vendredi 17 Octobre 2003 à 16:38
# Version du serveur: 4.0.15
# Version de PHP: 4.3.3
# 
# Base de données: `ganesha20`
# 

# --------------------------------------------------------

#
# Structure de la table `bno`
#

DROP TABLE IF EXISTS `bno`;
CREATE TABLE `bno` (
  `type_outil` tinyint(3) unsigned NOT NULL default '0',
  `id_membre` tinyint(11) unsigned NOT NULL default '0',
  `id_groupe` tinyint(3) unsigned NOT NULL default '0',
  `date_maj` timestamp(14) NOT NULL,
  `contenu` longtext,
  PRIMARY KEY  (`type_outil`,`id_membre`,`id_groupe`)
) TYPE=MyISAM;

#
# Contenu de la table `bno`
#

INSERT INTO `bno` (`type_outil`, `id_membre`, `id_groupe`, `date_maj`, `contenu`) VALUES (2, 19, 1, 20031001112312, '\r\ndffsdfsdf\r\nsdqf\r\nsd\r\nf\r\nsdq\r\nf\r\nqsdf\r\n');

# --------------------------------------------------------

#
# Structure de la table `chat`
#

DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat` (
  `msg` text NOT NULL,
  `ping` int(14) NOT NULL default '0'
) TYPE=MyISAM;

#
# Contenu de la table `chat`
#

INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">11:58:40....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064483920);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">11:59:02....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064483942);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">11:59:34....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064483974);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">11:59:43....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064483983);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:01:28....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064484088);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:01:35....TUTEUR1 TUTEUR1 : </font><font color=#000000>sqdqsdqsdqsdqsd</font>', 1064484095);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:01:38....TUTEUR1 TUTEUR1 : </font><font color=#000000>dsfsdfdsfsdf</font>', 1064484098);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:01:43....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064484103);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:01:49....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064484109);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:01:53....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064484113);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:02:11....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064484131);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:02:47....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064484167);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:13....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064484193);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:18....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064484198);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:30....TUTEUR1 TUTEUR1 : </font><font color=#000000>dsfsdfsdfsdf</font>', 1064484210);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:32....TUTEUR1 TUTEUR1 : </font><font color=#000000>dsfsdfsdfdsf</font>', 1064484212);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:43....TUTEUR1 TUTEUR1 : </font><font color=#000000>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</font>', 1064484223);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:48....TUTEUR1 TUTEUR1 : </font><font color=#000000>fdgfdgdfgfdgfdgfdgfdgfdgdfgfdg</font>', 1064484228);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:50....TUTEUR1 TUTEUR1 : </font><font color=#000000>fdgfdgfdgfdg</font>', 1064484230);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:51....TUTEUR1 TUTEUR1 : </font><font color=#000000>fdgfgfdgfdgfd</font>', 1064484231);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:53....TUTEUR1 TUTEUR1 : </font><font color=#000000>fdgdfgfdgfdgfd</font>', 1064484233);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:55....TUTEUR1 TUTEUR1 : </font><font color=#000000>dgfdgfdgfdgfdgfd</font>', 1064484235);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:57....TUTEUR1 TUTEUR1 : </font><font color=#000000>fdgfdgfdgfdgfdgfdg</font>', 1064484237);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:03:59....TUTEUR1 TUTEUR1 : </font><font color=#000000>gdfgfdgfdgfdgfdg</font>', 1064484239);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:04:01....TUTEUR1 TUTEUR1 : </font><font color=#000000>fdgfdgfdgfdgdfgfd</font>', 1064484241);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:04:02....TUTEUR1 TUTEUR1 : </font><font color=#000000>fdgfdgfdgfdgfdg</font>', 1064484242);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:04:10....TUTEUR1 TUTEUR1 : </font><font color=#CC3333><b><i><u>fdgdfgfdg</u></i></b></font>', 1064484250);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:04:13....TUTEUR1 TUTEUR1 : </font><font color=#CC3333><b><i><u>fdgfdgfdg</u></i></b></font>', 1064484253);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:04:14....TUTEUR1 TUTEUR1 : </font><font color=#CC3333><b><i><u>fdgdfgfdgfdg</u></i></b></font>', 1064484254);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:04:16....TUTEUR1 TUTEUR1 : </font><font color=#CC3333><b><i><u>fdgfdgfdgfdg</u></i></b></font>', 1064484256);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:04:21....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064484261);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:06:17....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR2 TUTEUR2</font>', 1064484377);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:06:41....TUTEUR2 TUTEUR2 : </font><font color=#000000>erfsdafsdfsdfsdf</font>', 1064484401);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:06:53....TUTEUR1 TUTEUR1 : </font><font color=#000000>dsfdsfsdfsdfdsf</font>', 1064484413);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:06:58....TUTEUR1 TUTEUR1 : </font><font color=#000000>dsfdsfsdfsdf</font>', 1064484418);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:15:36....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064484936);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:18:25....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064485105);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:18:38....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064485118);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:18:44....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064485124);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">12:20:33....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR1 TUTEUR1</font>', 1064485233);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">10:07:45....GANESHA : </font><font color="#CC0000">Arrivée de STAGIAIRE1 STAGIAIRE1</font>', 1064563665);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">10:08:23....GANESHA : </font><font color="#CC0000">Arrivée de STAGIAIRE1 STAGIAIRE1</font>', 1064563703);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">17:07:22....GANESHA : </font><font color="#CC0000">Arrivée de STAGIAIRE1 STAGIAIRE1</font>', 1064848042);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">17:07:40....GANESHA : </font><font color="#CC0000">Arrivée de STAGIAIRE1 STAGIAIRE1</font>', 1064848060);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">13:04:49....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR2 TUTEUR2</font>', 1065006289);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">13:04:59....TUTEUR2 TUTEUR2 : </font><font color=#000000>1213232132132</font>', 1065006299);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">13:05:03....TUTEUR2 TUTEUR2 : </font><font color=#000000>88788787879</font>', 1065006303);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">13:05:46....TUTEUR2 TUTEUR2 : </font><font color=#CC3333><b><i><u>78979889798798789798798798</u></i></b></font>', 1065006346);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">13:06:22....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR2 TUTEUR2</font>', 1065006382);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">13:06:48....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR2 TUTEUR2</font>', 1065006408);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">13:07:17....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR2 TUTEUR2</font>', 1065006437);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">13:07:32....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR2 TUTEUR2</font>', 1065006452);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">13:08:25....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR2 TUTEUR2</font>', 1065006505);
INSERT INTO `chat` (`msg`, `ping`) VALUES ('<font color="#999999">13:09:03....GANESHA : </font><font color="#CC0000">Arrivée de TUTEUR2 TUTEUR2</font>', 1065006543);

# --------------------------------------------------------

#
# Structure de la table `connectes`
#

DROP TABLE IF EXISTS `connectes`;
CREATE TABLE `connectes` (
  `idSession` varchar(4) NOT NULL default '',
  `nick` varchar(30) NOT NULL default '',
  `arrive` int(14) NOT NULL default '0',
  `ping` int(14) NOT NULL default '0',
  `lignes` tinyint(4) NOT NULL default '0',
  `bip` tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

#
# Contenu de la table `connectes`
#

INSERT INTO `connectes` (`idSession`, `nick`, `arrive`, `ping`, `lignes`, `bip`) VALUES ('2009', 'TUTEUR2 TUTEUR2', 1065006542, 1065006554, 25, 0);

# --------------------------------------------------------

#
# Structure de la table `connexion`
#

DROP TABLE IF EXISTS `connexion`;
CREATE TABLE `connexion` (
  `id_connexion` varchar(10) NOT NULL default '',
  `id_user` int(11) NOT NULL default '0',
  `date_connexion` varchar(15) NOT NULL default ''
) TYPE=MyISAM;

#
# Contenu de la table `connexion`
#


# --------------------------------------------------------

#
# Structure de la table `document`
#

DROP TABLE IF EXISTS `document`;
CREATE TABLE `document` (
  `id` int(11) NOT NULL auto_increment,
  `titre` varchar(100) NOT NULL default '',
  `comment` text NOT NULL,
  `fichier` varchar(100) NOT NULL default '',
  `prop` int(11) NOT NULL default '0',
  `groupe` int(11) NOT NULL default '0',
  `type` tinyint(4) NOT NULL default '0',
  `priv` tinyint(4) NOT NULL default '0',
  `date` varchar(20) NOT NULL default '',
  `taille` varchar(20) NOT NULL default '',
  `nbcomment` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) TYPE=MyISAM;

#
# Contenu de la table `document`
#

INSERT INTO `document` (`id`, `titre`, `comment`, `fichier`, `prop`, `groupe`, `type`, `priv`, `date`, `taille`, `nbcomment`) VALUES (4, 'fdgfd', '<DEB>STAGIAIRE1 STAGIAIRE1 a écrit le 29/09/03 17:20:36<MID>fdsfdsfsdfsdqfdqsfsdqf<FIN><DEB>STAGIAIRE1 STAGIAIRE1 a écrit le 29/09/03 17:20:28<MID>dfsfdsfqsdfsdf<FIN><DEB>STAGIAIRE1 STAGIAIRE1 a écrit le 29/09/03 17:20:25<MID>fdsfsdfqsdfsdqf<FIN><DEB>STAGIAIRE1 STAGIAIRE1 a écrit le 29/09/03 17:17:38<MID>gfdgfdg<FIN>', '09-29-17-17-38-stagiaire1.Icon7EFDA3AC3.txt.txt', 3, 1, 0, 0, '29/09/03 17:17:38', '27 Ko', 4);

# --------------------------------------------------------

#
# Structure de la table `evalannexes`
#

DROP TABLE IF EXISTS `evalannexes`;
CREATE TABLE `evalannexes` (
  `id` int(11) NOT NULL auto_increment,
  `id_stagiaire` int(11) NOT NULL default '0',
  `id_evaluation` int(11) NOT NULL default '0',
  `id_evaluateur` int(11) NOT NULL default '0',
  `date` varchar(15) NOT NULL default '',
  `statut` int(11) NOT NULL default '0',
  `temps` int(11) NOT NULL default '0',
  `commentaire` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Contenu de la table `evalannexes`
#

INSERT INTO `evalannexes` (`id`, `id_stagiaire`, `id_evaluation`, `id_evaluateur`, `date`, `statut`, `temps`, `commentaire`) VALUES (1, 28, 1, 15, '946681200', 0, 978339600, '');

# --------------------------------------------------------

#
# Structure de la table `evalanxdesc`
#

DROP TABLE IF EXISTS `evalanxdesc`;
CREATE TABLE `evalanxdesc` (
  `id` int(11) NOT NULL auto_increment,
  `nom` varchar(100) NOT NULL default '',
  `contexte` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Contenu de la table `evalanxdesc`
#

INSERT INTO `evalanxdesc` (`id`, `nom`, `contexte`) VALUES (1, 'nouvelle', 'ds\\\\\r\n\r\nfgsdgsdfg\r\ndf\r\ng\r\ndfg\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nfdgfdgfdgfdgfd');
INSERT INTO `evalanxdesc` (`id`, `nom`, `contexte`) VALUES (3, 'gfdgfd', 'gfdgfdgdfgdfgdfgdfgfdgdfg&é\\\'(-è_çà)=&é\\\'(-è_çà)=1');

# --------------------------------------------------------

#
# Structure de la table `formation`
#

DROP TABLE IF EXISTS `formation`;
CREATE TABLE `formation` (
  `user_id` int(11) NOT NULL default '0',
  `module_id` int(11) NOT NULL default '0',
  `avancement` int(11) NOT NULL default '0',
  `note` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  `ordre` tinyint(4) NOT NULL default '0',
  `groupe_id` tinyint(4) NOT NULL default '0',
  KEY `id` (`id`),
  KEY `user_id` (`user_id`),
  KEY `module_id` (`module_id`)
) TYPE=MyISAM;

#
# Contenu de la table `formation`
#

INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (24, 8, 0, 0, 80, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (3, 1, 0, 0, 2, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (12, 1, 0, 0, 3, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (24, 1, 0, 0, 78, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (24, 6, 0, 0, 77, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (6, 1, 0, 0, 76, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (12, 1, 0, 0, 73, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (8, 1, 0, 0, 9, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (9, 1, 0, 0, 10, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (10, 1, 0, 0, 11, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (11, 1, 0, 0, 12, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (19, 1, 0, 0, 71, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (18, 1, 0, 0, 14, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (24, 1, 0, 0, 81, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (19, 1, 0, 0, 16, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (24, 7, 0, 0, 79, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (25, 6, 0, 0, 82, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (3, 1, 0, 0, 72, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (4, 1, 0, 0, 74, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (18, 1, 0, 0, 70, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (5, 1, 0, 0, 75, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (25, 1, 0, 0, 83, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (25, 7, 0, 0, 84, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (25, 8, 0, 0, 85, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (25, 1, 0, 0, 86, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (26, 6, 0, 0, 87, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (26, 1, 0, 0, 88, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (26, 7, 0, 0, 89, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (26, 8, 0, 0, 90, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (26, 1, 0, 0, 91, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (27, 6, 0, 0, 92, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (27, 1, 0, 0, 93, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (27, 7, 0, 0, 94, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (27, 8, 0, 0, 95, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (27, 1, 0, 0, 96, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (28, 6, 0, 0, 97, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (28, 1, 0, 0, 98, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (28, 7, 0, 0, 99, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (28, 8, 0, 0, 100, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (28, 1, 0, 0, 101, 0, 2);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (18, 7, 0, 0, 141, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (18, 1, 0, 0, 139, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (24, 6, 0, 0, 106, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (24, 1, 0, 0, 107, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (24, 8, 0, 0, 108, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (24, 7, 0, 0, 109, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (25, 6, 0, 0, 110, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (25, 1, 0, 0, 111, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (25, 8, 0, 0, 112, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (25, 7, 0, 0, 113, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (26, 6, 0, 0, 114, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (26, 1, 0, 0, 115, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (26, 8, 0, 0, 116, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (26, 7, 0, 0, 117, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (27, 6, 0, 0, 118, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (27, 1, 0, 0, 119, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (27, 8, 0, 0, 120, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (27, 7, 0, 0, 121, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (3, 6, 0, 0, 122, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (3, 1, 0, 0, 123, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (3, 8, 0, 0, 124, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (3, 7, 0, 0, 125, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (12, 6, 0, 0, 126, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (12, 1, 0, 0, 127, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (12, 8, 0, 0, 128, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (12, 7, 0, 0, 129, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (4, 6, 0, 0, 130, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (4, 1, 0, 0, 131, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (4, 8, 0, 0, 132, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (4, 7, 0, 0, 133, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (29, 1, 0, 0, 159, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (29, 6, 0, 0, 158, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (18, 8, 0, 0, 140, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (18, 6, 0, 0, 138, 0, 3);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (29, 8, 0, 0, 161, 0, 1);
INSERT INTO `formation` (`user_id`, `module_id`, `avancement`, `note`, `id`, `ordre`, `groupe_id`) VALUES (29, 7, 0, 0, 160, 0, 1);

# --------------------------------------------------------

#
# Structure de la table `g1`
#

DROP TABLE IF EXISTS `g1`;
CREATE TABLE `g1` (
  `id` bigint(20) unsigned NOT NULL default '0',
  `datestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `thread` int(11) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  `author` char(37) NOT NULL default '',
  `subject` char(255) NOT NULL default '',
  `email` char(200) NOT NULL default '',
  `attachment` char(64) NOT NULL default '',
  `host` char(50) NOT NULL default '',
  `email_reply` char(1) NOT NULL default 'N',
  `approved` char(1) NOT NULL default 'N',
  `msgid` char(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `author` (`author`),
  KEY `datestamp` (`datestamp`),
  KEY `subject` (`subject`),
  KEY `thread` (`thread`),
  KEY `parent` (`parent`),
  KEY `approved` (`approved`),
  KEY `msgid` (`msgid`)
) TYPE=MyISAM;

#
# Contenu de la table `g1`
#


# --------------------------------------------------------

#
# Structure de la table `g1_bodies`
#

DROP TABLE IF EXISTS `g1_bodies`;
CREATE TABLE `g1_bodies` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `body` text NOT NULL,
  `thread` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `thread` (`thread`)
) TYPE=MyISAM;

#
# Contenu de la table `g1_bodies`
#


# --------------------------------------------------------

#
# Structure de la table `g2`
#

DROP TABLE IF EXISTS `g2`;
CREATE TABLE `g2` (
  `id` bigint(20) unsigned NOT NULL default '0',
  `datestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `thread` int(11) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  `author` char(37) NOT NULL default '',
  `subject` char(255) NOT NULL default '',
  `email` char(200) NOT NULL default '',
  `attachment` char(64) NOT NULL default '',
  `host` char(50) NOT NULL default '',
  `email_reply` char(1) NOT NULL default 'N',
  `approved` char(1) NOT NULL default 'N',
  `msgid` char(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `author` (`author`),
  KEY `datestamp` (`datestamp`),
  KEY `subject` (`subject`),
  KEY `thread` (`thread`),
  KEY `parent` (`parent`),
  KEY `approved` (`approved`),
  KEY `msgid` (`msgid`)
) TYPE=MyISAM;

#
# Contenu de la table `g2`
#


# --------------------------------------------------------

#
# Structure de la table `g2_bodies`
#

DROP TABLE IF EXISTS `g2_bodies`;
CREATE TABLE `g2_bodies` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `body` text NOT NULL,
  `thread` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `thread` (`thread`)
) TYPE=MyISAM;

#
# Contenu de la table `g2_bodies`
#


# --------------------------------------------------------

#
# Structure de la table `g3`
#

DROP TABLE IF EXISTS `g3`;
CREATE TABLE `g3` (
  `id` bigint(20) unsigned NOT NULL default '0',
  `datestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `thread` int(11) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  `author` char(37) NOT NULL default '',
  `subject` char(255) NOT NULL default '',
  `email` char(200) NOT NULL default '',
  `attachment` char(64) NOT NULL default '',
  `host` char(50) NOT NULL default '',
  `email_reply` char(1) NOT NULL default 'N',
  `approved` char(1) NOT NULL default 'N',
  `msgid` char(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `author` (`author`),
  KEY `datestamp` (`datestamp`),
  KEY `subject` (`subject`),
  KEY `thread` (`thread`),
  KEY `parent` (`parent`),
  KEY `approved` (`approved`),
  KEY `msgid` (`msgid`)
) TYPE=MyISAM;

#
# Contenu de la table `g3`
#


# --------------------------------------------------------

#
# Structure de la table `g3_bodies`
#

DROP TABLE IF EXISTS `g3_bodies`;
CREATE TABLE `g3_bodies` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `body` text NOT NULL,
  `thread` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `thread` (`thread`)
) TYPE=MyISAM;

#
# Contenu de la table `g3_bodies`
#


# --------------------------------------------------------

#
# Structure de la table `ga_forums`
#

DROP TABLE IF EXISTS `ga_forums`;
CREATE TABLE `ga_forums` (
  `id` int(11) NOT NULL auto_increment,
  `name` char(50) NOT NULL default '',
  `active` smallint(6) NOT NULL default '0',
  `description` char(255) NOT NULL default '',
  `config_suffix` char(50) NOT NULL default '',
  `folder` char(1) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  `display` int(11) NOT NULL default '0',
  `table_name` char(50) NOT NULL default '',
  `moderation` char(1) NOT NULL default 'n',
  `mod_email` char(50) NOT NULL default '',
  `mod_pass` char(50) NOT NULL default '',
  `email_list` char(50) NOT NULL default '',
  `email_return` char(50) NOT NULL default '',
  `email_tag` char(50) NOT NULL default '',
  `check_dup` smallint(6) NOT NULL default '0',
  `multi_level` smallint(6) NOT NULL default '0',
  `collapse` smallint(6) NOT NULL default '0',
  `flat` smallint(6) NOT NULL default '0',
  `staff_host` char(50) NOT NULL default '',
  `lang` char(50) NOT NULL default '',
  `html` char(40) NOT NULL default 'N',
  `table_width` char(4) NOT NULL default '',
  `table_header_color` char(7) NOT NULL default '',
  `table_header_font_color` char(7) NOT NULL default '',
  `table_body_color_1` char(7) NOT NULL default '',
  `table_body_color_2` char(7) NOT NULL default '',
  `table_body_font_color_1` char(7) NOT NULL default '',
  `table_body_font_color_2` char(7) NOT NULL default '',
  `nav_color` char(7) NOT NULL default '',
  `nav_font_color` char(7) NOT NULL default '',
  `allow_uploads` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`),
  KEY `active` (`active`),
  KEY `parent` (`parent`)
) TYPE=MyISAM;

#
# Contenu de la table `ga_forums`
#

INSERT INTO `ga_forums` (`id`, `name`, `active`, `description`, `config_suffix`, `folder`, `parent`, `display`, `table_name`, `moderation`, `mod_email`, `mod_pass`, `email_list`, `email_return`, `email_tag`, `check_dup`, `multi_level`, `collapse`, `flat`, `staff_host`, `lang`, `html`, `table_width`, `table_header_color`, `table_header_font_color`, `table_body_color_1`, `table_body_color_2`, `table_body_font_color_1`, `table_body_font_color_2`, `nav_color`, `nav_font_color`, `allow_uploads`) VALUES (1, 'Groupe A', 1, 'Forum du groupe Groupe A', '1', '0', 0, 30, 'g1', 'n', '', '', '', '', '', 0, 1, 1, 1, '', 'lang/french.inc.php', 'N', '80%', '#999999', '#FFFFFF', '#FFFFFF', '#F2F2F2', '#000000', '#000000', '#F2F2F2', '#000000', 'N');
INSERT INTO `ga_forums` (`id`, `name`, `active`, `description`, `config_suffix`, `folder`, `parent`, `display`, `table_name`, `moderation`, `mod_email`, `mod_pass`, `email_list`, `email_return`, `email_tag`, `check_dup`, `multi_level`, `collapse`, `flat`, `staff_host`, `lang`, `html`, `table_width`, `table_header_color`, `table_header_font_color`, `table_body_color_1`, `table_body_color_2`, `table_body_font_color_1`, `table_body_font_color_2`, `nav_color`, `nav_font_color`, `allow_uploads`) VALUES (2, 'Groupe B', 1, 'Forum du groupe Groupe B', '1', '0', 0, 30, 'g2', 'n', '', '', '', '', '', 0, 1, 1, 1, '', 'lang/french.inc.php', 'N', '80%', '#999999', '#FFFFFF', '#FFFFFF', '#F2F2F2', '#000000', '#000000', '#F2F2F2', '#000000', 'N');
INSERT INTO `ga_forums` (`id`, `name`, `active`, `description`, `config_suffix`, `folder`, `parent`, `display`, `table_name`, `moderation`, `mod_email`, `mod_pass`, `email_list`, `email_return`, `email_tag`, `check_dup`, `multi_level`, `collapse`, `flat`, `staff_host`, `lang`, `html`, `table_width`, `table_header_color`, `table_header_font_color`, `table_body_color_1`, `table_body_color_2`, `table_body_font_color_1`, `table_body_font_color_2`, `nav_color`, `nav_font_color`, `allow_uploads`) VALUES (3, 'groupe3', 1, 'Forum du groupe groupe3', '1', '0', 0, 30, 'g3', 'n', '', '', '', '', '', 0, 1, 1, 1, '', 'lang/french.inc.php', 'N', '80%', '#999999', '#FFFFFF', '#FFFFFF', '#F2F2F2', '#000000', '#000000', '#F2F2F2', '#000000', 'N');

# --------------------------------------------------------

#
# Structure de la table `groupe`
#

DROP TABLE IF EXISTS `groupe`;
CREATE TABLE `groupe` (
  `id_groupe` int(11) NOT NULL default '0',
  `id_membres` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Contenu de la table `groupe`
#

INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 25);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 18);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 4);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 24);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 25);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 8);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 9);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 10);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 11);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 12);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 3);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 3);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 18);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 24);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 19);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 5);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 26);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 6);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 19);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 12);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 26);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 27);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 27);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 28);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (2, 28);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (3, 18);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (3, 24);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (3, 25);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (3, 26);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (3, 27);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (3, 3);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (3, 12);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (3, 4);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (0, 30);
INSERT INTO `groupe` (`id_groupe`, `id_membres`) VALUES (1, 29);

# --------------------------------------------------------

#
# Structure de la table `gtracking`
#

DROP TABLE IF EXISTS `gtracking`;
CREATE TABLE `gtracking` (
  `cnx` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `groupe_id` int(11) NOT NULL default '0',
  `module_id` int(11) NOT NULL default '0',
  `chapitre_id` int(11) NOT NULL default '0',
  `date` varchar(10) NOT NULL default '',
  `score` int(11) NOT NULL default '0',
  `max_score` int(11) NOT NULL default '0',
  `time` varchar(8) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  KEY `cnx` (`cnx`)
) TYPE=MyISAM;

#
# Contenu de la table `gtracking`
#


# --------------------------------------------------------

#
# Structure de la table `inscription`
#

DROP TABLE IF EXISTS `inscription`;
CREATE TABLE `inscription` (
  `code` varchar(20) NOT NULL default '',
  `id_groupe` int(11) NOT NULL default '0',
  `etat` char(1) NOT NULL default '',
  `nb` int(11) NOT NULL default '0',
  `date` varchar(15) NOT NULL default '',
  KEY `code` (`code`)
) TYPE=MyISAM;

#
# Contenu de la table `inscription`
#

INSERT INTO `inscription` (`code`, `id_groupe`, `etat`, `nb`, `date`) VALUES ('0000', 2, '1', 6, '1064323327');
INSERT INTO `inscription` (`code`, `id_groupe`, `etat`, `nb`, `date`) VALUES ('0000', 1, '1', 6, '1064323327');

# --------------------------------------------------------

#
# Structure de la table `list_groupe`
#

DROP TABLE IF EXISTS `list_groupe`;
CREATE TABLE `list_groupe` (
  `id_groupe` int(11) NOT NULL default '0',
  `id_tuteur` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `public` tinyint(4) NOT NULL default '0',
  `date_debut` varchar(20) NOT NULL default '',
  `date_fin` varchar(20) NOT NULL default '',
  `date_presentiel` varchar(20) NOT NULL default '',
  `id_forum` int(11) NOT NULL default '0',
  `repertoire` varchar(100) NOT NULL default '',
  `planning` varchar(100) NOT NULL default '',
  `code` varchar(20) NOT NULL default '',
  KEY `id_tuteur` (`id_tuteur`)
) TYPE=MyISAM;

#
# Contenu de la table `list_groupe`
#

INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (0, 0, '', 0, '', '', '', 0, '', '', 'G00');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (1, 0, 'Groupe A', 0, '', '', '', 1, 'GRP1', '', 'G01');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (2, 0, 'Groupe B', 0, '', '', '', 2, 'GRP2', '', 'G02');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (3, 13, 'groupe3', 0, '', '', '', 3, '3', '', 'G03');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (3, 23, 'groupe3', 0, '', '', '', 3, '3', '', 'G03');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (1, 15, 'Groupe A', 0, '', '', '', 1, 'GRP1', '', 'G01');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (2, 15, 'Groupe B', 0, '', '', '', 2, 'GRP2', '', 'G02');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (2, 16, 'Groupe B', 0, '', '', '', 2, 'GRP2', '', 'G02');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (2, 17, 'Groupe B', 0, '', '', '', 2, 'GRP2', '', 'G02');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (1, 14, 'Groupe A', 0, '', '', '', 1, 'GRP1', '', 'G01');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (1, 13, 'Groupe A', 0, '', '', '', 1, 'GRP1', '', 'G01');
INSERT INTO `list_groupe` (`id_groupe`, `id_tuteur`, `name`, `public`, `date_debut`, `date_fin`, `date_presentiel`, `id_forum`, `repertoire`, `planning`, `code`) VALUES (3, 0, 'groupe3', 0, '', '', '', 3, '3', '', 'G03');

# --------------------------------------------------------

#
# Structure de la table `list_module`
#

DROP TABLE IF EXISTS `list_module`;
CREATE TABLE `list_module` (
  `module_id` int(11) NOT NULL auto_increment,
  `module_titre` varchar(100) NOT NULL default '',
  `repertoire` varchar(50) NOT NULL default '',
  `auteur_id` int(11) NOT NULL default '0',
  `code` varchar(20) NOT NULL default '',
  KEY `module_id` (`module_id`)
) TYPE=MyISAM;

#
# Contenu de la table `list_module`
#

INSERT INTO `list_module` (`module_id`, `module_titre`, `repertoire`, `auteur_id`, `code`) VALUES (1, 'Exemple AICC & SCORM', '', -1, 'M01');
INSERT INTO `list_module` (`module_id`, `module_titre`, `repertoire`, `auteur_id`, `code`) VALUES (7, 'bbbbbbbbbbbbb', '', -1, 'M07');
INSERT INTO `list_module` (`module_id`, `module_titre`, `repertoire`, `auteur_id`, `code`) VALUES (6, 'cccccccccccccccc', '', -1, 'M06');
INSERT INTO `list_module` (`module_id`, `module_titre`, `repertoire`, `auteur_id`, `code`) VALUES (8, 'aaaaaaaaaaaaaaa', '', -1, 'M08');
INSERT INTO `list_module` (`module_id`, `module_titre`, `repertoire`, `auteur_id`, `code`) VALUES (9, 'xxxxx', '', -1, 'M09');

# --------------------------------------------------------

#
# Structure de la table `list_societe`
#

DROP TABLE IF EXISTS `list_societe`;
CREATE TABLE `list_societe` (
  `id_societe` int(11) NOT NULL auto_increment,
  `description` varchar(50) NOT NULL default '',
  `adresse` varchar(100) NOT NULL default '',
  `adresse_presentiel` varchar(100) NOT NULL default '',
  `adresse_facturation` varchar(100) NOT NULL default '',
  UNIQUE KEY `ID_SOCIETE` (`id_societe`)
) TYPE=MyISAM COMMENT='Liste des societes';

#
# Contenu de la table `list_societe`
#

INSERT INTO `list_societe` (`id_societe`, `description`, `adresse`, `adresse_presentiel`, `adresse_facturation`) VALUES (1, 'erzr', 'zerze', '', 'g');

# --------------------------------------------------------

#
# Structure de la table `membres`
#

DROP TABLE IF EXISTS `membres`;
CREATE TABLE `membres` (
  `id` int(11) NOT NULL auto_increment,
  `prenom` varchar(100) NOT NULL default '',
  `nom` varchar(100) NOT NULL default '',
  `login` varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `id_societe` int(11) NOT NULL default '0',
  `cv` varchar(100) NOT NULL default '',
  `date_creation` varchar(20) NOT NULL default '',
  `date_connexion` varchar(20) NOT NULL default '',
  `type` tinyint(4) NOT NULL default '0',
  `email` varchar(100) NOT NULL default '',
  `id_groupe` int(11) NOT NULL default '0',
  `nbconnexion` int(11) NOT NULL default '0',
  `skin` varchar(20) NOT NULL default 'anema',
  `adresse` varchar(250) NOT NULL default '',
  `cp` varchar(15) NOT NULL default '',
  `ville` varchar(100) NOT NULL default '',
  `mode_auth` tinyint(4) NOT NULL default '1',
  UNIQUE KEY `id` (`id`),
  KEY `type` (`type`),
  KEY `id_societe` (`id_societe`)
) TYPE=MyISAM;

#
# Contenu de la table `membres`
#

INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (2, 'Administration', 'GANESHA', 'admin', 'ganesha', 0, '', '1000195517', '1065522696', 2, 'gcaldeira@anemalab.org', 0, 33, 'install', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (3, 'STAGIAIRE1', 'STAGIAIRE1', 'stagiaire1', 'stagiaire1', -1, '', '1063974074', '1065025979', 0, '', 1, 11, 'install', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (4, 'STAGIAIRE2', 'STAGIAIRE2', 'stagiaire2', 'stagiaire2', -1, '', '1063974095', '1065002397', 0, '', 1, 2, 'install', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (5, 'STAGIAIRE3', 'STAGIAIRE3', 'stagiaire3', 'stagiaire3', -1, '', '1063974113', '1064320971', 0, '', 1, 1, 'install', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (6, 'STAGIAIRE4', 'STAGIAIRE4', 'stagiaire4', 'stagiaire4', -1, '', '1063974131', '', 0, '', 1, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (7, 'STAGIAIRE5', 'STAGIAIRE5', 'stagiaire5', 'stagiaire5', -1, '', '1063974145', '', 0, '', 1, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (8, 'STAGIAIRE6', 'STAGIAIRE6', 'stagiaire6', 'stagiaire6', -1, '', '1063974160', '', 0, '', 2, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (9, 'STAGIAIRE7', 'STAGIAIRE7', 'stagiaire7', 'stagiaire7', -1, '', '1063974173', '', 0, '', 2, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (10, 'STAGIAIRE8', 'STAGIAIRE8', 'stagiaire8', 'stagiaire8', -1, '', '1063974187', '', 0, '', 2, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (11, 'STAGIAIRE9', 'STAGIAIRE9', 'stagiaire9', 'stagiaire9', -1, '', '1063974208', '', 0, '', 2, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (12, 'STAGIAIRE10', 'STAGIAIRE10', 'stagiaire10', 'stagiaire10', -1, '', '1063974232', '', 0, '', 2, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (13, 'TUTEUR1', 'TUTEUR1', 'tuteur1', 'tuteur1', -1, '', '1063974411', '1065026151', 3, '', 0, 82, 'menthe', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (14, 'TUTEUR2', 'TUTEUR2', 'tuteur2', 'tuteur2', -1, '', '1063974639', '1065005710', 3, '', 0, 7, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (15, 'TUTEUR3', 'TUTEUR3', 'tuteur3', 'tuteur3', -1, '', '1063974651', '1064852808', 3, '', 0, 1, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (16, 'TUTEUR4', 'TUTEUR4', 'tuteur4', 'tuteur4', -1, '', '1063974662', '', 3, '', 0, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (17, 'TUTEUR5', 'TUTEUR5', 'tuteur5', 'tuteur5', -1, '', '1063974674', '', 3, '', 0, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (18, 'aa', 'aa', 'aa', 'aa', -1, '', '1064311737', '1065522886', 0, '', 1, 16, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (19, 'fsd', 'sddf', 'sddf', 'Nsfedwre', -1, '', '1064323382', '', 0, 'sd@dfsgfsd.fr', 1, 0, 'anema', 'sdfsd', 'sdf', 'sdfdsf', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (23, 'fgh', 'dg', 'gg', 'gjg', -1, '', '1064396723', '', 3, '', 0, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (24, 'fdgfd', 'fdg', 'fdg', '2OFK6QNM', -1, '', '1064488406', '', 0, 'fdg@fgd.fr', 1, 0, 'anema', 'fdg@fgd.fr', 'dsf', 'sfsdf', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (25, 'fdgfd', 'fdg', 'fdg', '7LoNEHa8', -1, '', '1064488427', '', 0, 'fdg@fgd.fr', 1, 0, 'anema', 'fdg@fgd.fr', 'dsf', 'sfsdf', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (26, 'fdgfd', 'fdg', 'fdg', 'FExuHWvS', -1, '', '1064488480', '', 0, 'fdg@fgd.fr', 1, 0, 'anema', 'fdg@fgd.fr', 'dsf', 'sfsdf', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (27, 'fdgfd', 'fdg', 'fdg', 'jgrqzkJw', -1, '', '1064488538', '', 0, 'fdg@fgd.fr', 1, 0, 'anema', 'gcaldeira@anemalab.org', 'dsf', 'sfsdf', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (28, 'gcaldeira@anemalab.org', 'gcaldeira@anemalab.org', 'gcaldeira@anemalab.org', 'bWJG4eNa', -1, '', '1064489796', '', 0, 'caldeira@anemalab.org', 1, 0, 'anema', 'gcaldeira@anemalab.org', 'gcaldeira@anema', 'gcaldeira@anemalab.org', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (29, 'b', 'b', 'b', 'b', -1, '', '1064567594', '', 0, '', 1, 0, 'anema', '', '', '', 1);
INSERT INTO `membres` (`id`, `prenom`, `nom`, `login`, `password`, `id_societe`, `cv`, `date_creation`, `date_connexion`, `type`, `email`, `id_groupe`, `nbconnexion`, `skin`, `adresse`, `cp`, `ville`, `mode_auth`) VALUES (30, 'toto', 'toto', 'toto', 'toto', -1, '', '1064846881', '', 0, '', 0, 0, 'anema', '', '', '', 1);

# --------------------------------------------------------

#
# Structure de la table `mes_doc`
#

DROP TABLE IF EXISTS `mes_doc`;
CREATE TABLE `mes_doc` (
  `id` int(11) NOT NULL auto_increment,
  `fichier` varchar(100) NOT NULL default '',
  `compteur` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) TYPE=MyISAM;

#
# Contenu de la table `mes_doc`
#


# --------------------------------------------------------

#
# Structure de la table `mes_rec`
#

DROP TABLE IF EXISTS `mes_rec`;
CREATE TABLE `mes_rec` (
  `id` int(11) NOT NULL auto_increment,
  `source` int(11) NOT NULL default '0',
  `dest` int(11) NOT NULL default '0',
  `groupe` int(11) NOT NULL default '0',
  `fichier` varchar(100) NOT NULL default '',
  `ar` tinyint(4) NOT NULL default '0',
  `type` tinyint(4) NOT NULL default '0',
  `lu` tinyint(4) NOT NULL default '0',
  `objet` varchar(100) NOT NULL default '',
  `text` text NOT NULL,
  `date` varchar(20) NOT NULL default '',
  KEY `id` (`id`)
) TYPE=MyISAM;

#
# Contenu de la table `mes_rec`
#

INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (1, 13, 18, 1, '', 0, 1, 1, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (2, 13, 24, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (3, 13, 25, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (4, 13, 26, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (5, 13, 27, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (6, 13, 19, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (7, 13, 28, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (8, 13, 3, 1, '', 0, 1, 1, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (9, 13, 4, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (10, 13, 5, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (11, 13, 6, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (12, 13, 7, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (13, 13, 14, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (14, 13, 15, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (15, 2, 13, 1, '', 0, 0, 1, 'Réponse accusé de réception', 'aa aa', '25/09/03 17:06:46');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (16, 13, 18, 1, '', 0, 0, 1, 'sqdsqdsqd', 'sqdsqdsqd', '26/09/03 10:50:32');
INSERT INTO `mes_rec` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (17, 2, 13, 1, '', 0, 0, 1, 'Réponse accusé de réception', 'Le message : \n sqdsqdsqd \n\nA été lu par aa aa', '26/09/03 10:50:51');

# --------------------------------------------------------

#
# Structure de la table `mes_send`
#

DROP TABLE IF EXISTS `mes_send`;
CREATE TABLE `mes_send` (
  `id` int(11) NOT NULL auto_increment,
  `source` int(11) NOT NULL default '0',
  `dest` int(11) NOT NULL default '0',
  `groupe` int(11) NOT NULL default '0',
  `fichier` varchar(100) NOT NULL default '',
  `ar` tinyint(4) NOT NULL default '0',
  `type` tinyint(4) NOT NULL default '0',
  `lu` tinyint(4) NOT NULL default '0',
  `objet` varchar(100) NOT NULL default '',
  `text` text NOT NULL,
  `date` varchar(20) NOT NULL default '',
  KEY `id` (`id`)
) TYPE=MyISAM;

#
# Contenu de la table `mes_send`
#

INSERT INTO `mes_send` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (1, 13, -1, 1, '', 1, 1, 0, 'fdsfdqs', 'fdsfsdf', '25/09/03 17:06:14');
INSERT INTO `mes_send` (`id`, `source`, `dest`, `groupe`, `fichier`, `ar`, `type`, `lu`, `objet`, `text`, `date`) VALUES (2, 13, 18, 1, '', 1, 0, 0, 'sqdsqdsqd', 'sqdsqdsqd', '26/09/03 10:50:32');

# --------------------------------------------------------

#
# Structure de la table `mode_auth`
#

DROP TABLE IF EXISTS `mode_auth`;
CREATE TABLE `mode_auth` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM;

#
# Contenu de la table `mode_auth`
#

INSERT INTO `mode_auth` (`id`, `type`) VALUES (1, 'cleartext');

# --------------------------------------------------------

#
# Structure de la table `module`
#

DROP TABLE IF EXISTS `module`;
CREATE TABLE `module` (
  `id_module` int(11) NOT NULL default '0',
  `titre` varchar(80) NOT NULL default '',
  `numero` int(11) NOT NULL default '0',
  `link` varchar(80) NOT NULL default '',
  `norme` int(11) NOT NULL default '0',
  `type` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Contenu de la table `module`
#

INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (1, 'Support', 0, '', 0, 2);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (1, 'Exemple AICC', 1, '', 0, 2);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (1, 'Quizz AICC', 2, '/exemple/aicc_cb_multipages/index.htm', 1, 1);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (1, 'Exemple SCORM', 3, '', 0, 2);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (1, 'Quizz', 4, '/exemple/scorm_cb_drag_drop/dragscorm.htm', 2, 1);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (8, 'dfssdfsdfsdqf', 12, '', 0, 2);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (8, 'Support', 0, '', 0, 2);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (6, 'Support', 0, '', 0, 2);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (7, 'Support', 0, '', 0, 2);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (8, 'sdqsdqsd', 4, '', 0, 2);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (7, 'dsfsdfsdfsdfdsfsdf', 1, '', 0, 2);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (9, 'Support##', 0, '', 0, 2);
INSERT INTO `module` (`id_module`, `titre`, `numero`, `link`, `norme`, `type`) VALUES (9, 'yyyyyyyy', 1, '/tst_scorm/Course01/Lesson01/sco01.htm', 2, 1);

# --------------------------------------------------------

#
# Structure de la table `news`
#

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `titre` varchar(30) NOT NULL default '',
  `msg` text NOT NULL,
  `date` varchar(20) NOT NULL default '',
  `id_groupe` mediumint(9) NOT NULL default '0',
  `id_user` int(11) NOT NULL default '0',
  `status` char(1) NOT NULL default '',
  KEY `id` (`id`)
) TYPE=MyISAM;

#
# Contenu de la table `news`
#

INSERT INTO `news` (`id`, `titre`, `msg`, `date`, `id_groupe`, `id_user`, `status`) VALUES (1, 'Ganesha', 'Ganesha est distribué par la société <br><a href="http://www.anema-formation.fr" target="_blanck" class="student">Anema Formation</a>', '', 0, 0, '');
INSERT INTO `news` (`id`, `titre`, `msg`, `date`, `id_groupe`, `id_user`, `status`) VALUES (2, 'Ganesha', 'Ganesha est distribué par la société <br><a href="http://www.anema-formation.fr" target="_blanck" class="student">Anema Formation</a>\r\n\r\nHello world......', '1065000717', 1, 13, '1');
INSERT INTO `news` (`id`, `titre`, `msg`, `date`, `id_groupe`, `id_user`, `status`) VALUES (3, 'Ganesha', 'Ganesha est distribué par la société <br><a href="http://www.anema-formation.fr" target="_blanck" class="student">Anema Formation</a>', '1064564090', 3, 2, '1');
INSERT INTO `news` (`id`, `titre`, `msg`, `date`, `id_groupe`, `id_user`, `status`) VALUES (4, 'Ganesha', 'Ganesha est distribué par la société <br><a href="http://www.anema-formation.fr" target="_blanck" class="student">Anema Formation</a>', '1064852824', 2, 2, '1');

# --------------------------------------------------------

#
# Structure de la table `options`
#

DROP TABLE IF EXISTS `options`;
CREATE TABLE `options` (
  `name` varchar(30) NOT NULL default '',
  `value` char(1) NOT NULL default ''
) TYPE=MyISAM;

#
# Contenu de la table `options`
#

INSERT INTO `options` (`name`, `value`) VALUES ('OPT_MENU_GRAPH_ACTIVE', '0');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_BNO_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_EVALANX_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_MAIL_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_UPLOAD_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_STUDENT_UPLOAD_DOC_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_FICHE_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_SKIN_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_CALENDAR_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_NEWS_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_STUDENT_SHOW_GROUPE_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_STUDENT_SHOW_RESULT_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_STUDENT_SHOW_DETAIL_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_AUTORIZ_TUTOR_ADMIN', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_MENU_ADMIN_LEFT_ACTIVE', '0');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_ONLY_OBJECT_WM_ACTIVE', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('OPT_WINDOW_CHAT', '1');
INSERT INTO `options` (`name`, `value`) VALUES ('CREATE_DIR_GRP', '1');

# --------------------------------------------------------

#
# Structure de la table `options2`
#

DROP TABLE IF EXISTS `options2`;
CREATE TABLE `options2` (
  `name` varchar(30) NOT NULL default '',
  `value` varchar(10) NOT NULL default ''
) TYPE=MyISAM;

#
# Contenu de la table `options2`
#

INSERT INTO `options2` (`name`, `value`) VALUES ('DIR_GRP', 'GRP');
INSERT INTO `options2` (`name`, `value`) VALUES ('GRP_CODE', 'G');
INSERT INTO `options2` (`name`, `value`) VALUES ('MOD_CODE', 'M');
INSERT INTO `options2` (`name`, `value`) VALUES ('TRACE', '1');
INSERT INTO `options2` (`name`, `value`) VALUES ('DEBUG', '1');
INSERT INTO `options2` (`name`, `value`) VALUES ('DEBUG_AICC', '1');
INSERT INTO `options2` (`name`, `value`) VALUES ('MAX_FILE_SIZE', '400000');
INSERT INTO `options2` (`name`, `value`) VALUES ('MAX_CAR_MSG_WM', '0');
INSERT INTO `options2` (`name`, `value`) VALUES ('TIME_OUT_CNX', '1800');

# --------------------------------------------------------

#
# Structure de la table `session_evalanx`
#

DROP TABLE IF EXISTS `session_evalanx`;
CREATE TABLE `session_evalanx` (
  `id_groupe` int(11) NOT NULL default '0',
  `id_stagiaire` int(11) NOT NULL default '0',
  `id_evaluation` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Contenu de la table `session_evalanx`
#

INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 18, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 24, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 25, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 26, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 27, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 19, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 28, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 3, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 12, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 4, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 5, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 6, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 7, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 8, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 9, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 10, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (0, 11, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (3, 18, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (3, 25, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (3, 24, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (3, 27, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (3, 26, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (3, 3, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (3, 12, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (3, 4, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 6, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 5, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 4, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 12, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 3, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 28, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 19, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 24, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 25, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 26, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 27, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 29, 1);
INSERT INTO `session_evalanx` (`id_groupe`, `id_stagiaire`, `id_evaluation`) VALUES (1, 18, 1);

# --------------------------------------------------------

#
# Structure de la table `session_groupe`
#

DROP TABLE IF EXISTS `session_groupe`;
CREATE TABLE `session_groupe` (
  `id_groupe` int(11) NOT NULL default '0',
  `id_module` int(11) NOT NULL default '0',
  `ordre` tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

#
# Contenu de la table `session_groupe`
#

INSERT INTO `session_groupe` (`id_groupe`, `id_module`, `ordre`) VALUES (1, 1, 2);
INSERT INTO `session_groupe` (`id_groupe`, `id_module`, `ordre`) VALUES (2, 1, 0);
INSERT INTO `session_groupe` (`id_groupe`, `id_module`, `ordre`) VALUES (1, 8, -1);
INSERT INTO `session_groupe` (`id_groupe`, `id_module`, `ordre`) VALUES (1, 7, 0);
INSERT INTO `session_groupe` (`id_groupe`, `id_module`, `ordre`) VALUES (1, 6, 1);
INSERT INTO `session_groupe` (`id_groupe`, `id_module`, `ordre`) VALUES (3, 8, 0);
INSERT INTO `session_groupe` (`id_groupe`, `id_module`, `ordre`) VALUES (3, 7, 0);
INSERT INTO `session_groupe` (`id_groupe`, `id_module`, `ordre`) VALUES (3, 6, 0);
INSERT INTO `session_groupe` (`id_groupe`, `id_module`, `ordre`) VALUES (3, 1, 0);
INSERT INTO `session_groupe` (`id_groupe`, `id_module`, `ordre`) VALUES (1, 9, -2);

# --------------------------------------------------------

#
# Structure de la table `stat_connexion`
#

DROP TABLE IF EXISTS `stat_connexion`;
CREATE TABLE `stat_connexion` (
  `cnx` int(11) NOT NULL default '0',
  `id_membres` int(11) NOT NULL default '0',
  `date_cnx` int(11) NOT NULL default '0',
  `time_cnx` int(11) NOT NULL default '0',
  `id_groupe` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cnx`)
) TYPE=MyISAM;

#
# Contenu de la table `stat_connexion`
#

INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (65492927, 18, 1064315780, 1160, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (58963676, 5, 1064320971, 149, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (38347836, 3, 1064322471, 481, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (38525616, 4, 1064336119, 23, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (18927270, 18, 1064390279, 960, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (58387256, 18, 1064396983, 88, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (14723490, 18, 1064410565, 1069, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (41858367, 18, 1064413054, 2331, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (61874989, 18, 1064415482, 0, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (81476789, 18, 1064415582, 96, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (32169436, 3, 1064415653, 177, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (54109298, 18, 1064416469, 1527, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (27678187, 18, 1064419012, 28, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (25498149, 18, 1064419046, 76, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (83636969, 18, 1064419668, 2, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (63476923, 18, 1064479902, 2, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (96309836, 3, 1064480605, 450, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (9654907, 3, 1064481258, 1049, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (36905616, 18, 1064502393, 53, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (21872349, 3, 1064502552, 553, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (90761874, 3, 1064563125, 742, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (38567294, 18, 1064566239, 13, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (38321834, 3, 1064848027, 844, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (63638509, 3, 1064849276, 38, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (78581692, 3, 1065002353, 33, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (90103298, 4, 1065002397, 15, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (9450543, 3, 1065023640, 2309, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (94187856, 3, 1065025979, 695, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (36769270, 18, 1065522845, 20, 0);
INSERT INTO `stat_connexion` (`cnx`, `id_membres`, `date_cnx`, `time_cnx`, `id_groupe`) VALUES (5878145, 18, 1065522886, 1953, 0);

# --------------------------------------------------------

#
# Structure de la table `tracking`
#

DROP TABLE IF EXISTS `tracking`;
CREATE TABLE `tracking` (
  `user_id` int(11) NOT NULL default '0',
  `groupe_id` int(11) NOT NULL default '0',
  `module_id` int(11) NOT NULL default '0',
  `chapitre_id` int(11) NOT NULL default '0',
  `date` varchar(20) NOT NULL default '',
  `score` int(11) NOT NULL default '0',
  `max_score` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Contenu de la table `tracking`
#

INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 4, '1064413337', 0, 100, 2, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 4, '1064413280', 0, 100, 2, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 2, '1064413269', 25, 0, 3, 3);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 2, '1064413350', 25, 0, 3, 3);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 4, '1064413356', 0, 100, 2, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 4, '1064413436', 100, 100, 9, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 2, '1064413452', 25, 0, 3, 3);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524124', 0, 0, 1, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524156', 0, 0, 2, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524166', 0, 0, 6, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524171', 0, 0, 1, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524179', 0, 0, 1, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524184', 0, 0, 2, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524189', 0, 0, 1, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524194', 0, 0, 3, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524196', 0, 0, 1, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524199', 0, 0, 1, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524215', 0, 0, 1, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524218', 0, 0, 1, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524221', 0, 0, 1, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524231', 0, 0, 8, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524237', 0, 0, 1, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524268', 0, 0, 1, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524272', 0, 0, 1, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524275', 0, 0, 1, 4);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524279', 0, 0, 1, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524281', 0, 0, 1, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524284', 0, 0, 1, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524286', 0, 0, 1, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524294', 0, 0, 1, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524306', 0, 0, 1, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524316', 0, 0, 8, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524341', 0, 0, 22, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 9, 1, '1065524732', 0, 0, 2, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 2, '1065524756', 50, 0, 3, 1);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 2, '1065524767', 50, 0, 3, 1);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 2, '1065524777', 50, 0, 3, 1);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 2, '1065524787', 50, 0, 2, 1);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 4, '1065524823', 0, 100, 5, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 4, '1065524830', 0, 100, 4, 2);
INSERT INTO `tracking` (`user_id`, `groupe_id`, `module_id`, `chapitre_id`, `date`, `score`, `max_score`, `time`, `status`) VALUES (18, 1, 1, 4, '1065524839', 100, 100, 5, 2);

# --------------------------------------------------------

#
# Structure de la table `type_membres`
#

DROP TABLE IF EXISTS `type_membres`;
CREATE TABLE `type_membres` (
  `type` tinyint(4) NOT NULL default '0',
  `description` varchar(50) NOT NULL default '',
  KEY `type` (`type`)
) TYPE=MyISAM;

#
# Contenu de la table `type_membres`
#

INSERT INTO `type_membres` (`type`, `description`) VALUES (0, 'Stagiaire');
INSERT INTO `type_membres` (`type`, `description`) VALUES (1, 'Auteur');
INSERT INTO `type_membres` (`type`, `description`) VALUES (2, 'Administration');
INSERT INTO `type_membres` (`type`, `description`) VALUES (-1, ' Sélectionner le type');
INSERT INTO `type_membres` (`type`, `description`) VALUES (3, 'Tuteur');

# --------------------------------------------------------

#
# Structure de la table `v20_archives`
#

DROP TABLE IF EXISTS `v20_archives`;
CREATE TABLE `v20_archives` (
  `code` int(11) NOT NULL auto_increment,
  `annee` int(11) NOT NULL default '0',
  `mois` int(11) NOT NULL default '0',
  `vpm` int(11) NOT NULL default '0',
  `topVis` blob NOT NULL,
  `topNavOS` blob NOT NULL,
  `topOS` blob NOT NULL,
  `topNav` blob NOT NULL,
  `vph` blob NOT NULL,
  `topRef` blob NOT NULL,
  `topDom` blob NOT NULL,
  `vpj` blob NOT NULL,
  PRIMARY KEY  (`code`),
  KEY `annee` (`annee`),
  KEY `mois` (`mois`)
) TYPE=MyISAM;

#
# Contenu de la table `v20_archives`
#


# --------------------------------------------------------

#
# Structure de la table `v20_domaines`
#

DROP TABLE IF EXISTS `v20_domaines`;
CREATE TABLE `v20_domaines` (
  `code` int(11) NOT NULL auto_increment,
  `domaine` char(20) NOT NULL default '',
  `description` char(50) NOT NULL default '',
  PRIMARY KEY  (`code`)
) TYPE=MyISAM;

#
# Contenu de la table `v20_domaines`
#


# --------------------------------------------------------

#
# Structure de la table `v20_visiteurs`
#

DROP TABLE IF EXISTS `v20_visiteurs`;
CREATE TABLE `v20_visiteurs` (
  `AGENT` char(100) default NULL,
  `REFERER` char(200) default NULL,
  `ADDR` char(50) NOT NULL default '',
  `DATE` char(20) default NULL,
  `HOST` char(100) default NULL,
  `CODE` int(11) NOT NULL auto_increment,
  `REF_HOST` char(100) default NULL,
  PRIMARY KEY  (`CODE`),
  KEY `ADDR` (`ADDR`)
) TYPE=MyISAM;

#
# Contenu de la table `v20_visiteurs`
#

INSERT INTO `v20_visiteurs` (`AGENT`, `REFERER`, `ADDR`, `DATE`, `HOST`, `CODE`, `REF_HOST`) VALUES ('IE;4.0;WinNT', 'http://georges/dev_ganesha/ganesha20rc7/install/step4.php', '192.168.1.2', '2003/09/23 11:56', 'GEORGES', 1, 'http://georges/');
INSERT INTO `v20_visiteurs` (`AGENT`, `REFERER`, `ADDR`, `DATE`, `HOST`, `CODE`, `REF_HOST`) VALUES ('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US ...', 'http://georges/dev_ganesha/', '192.168.1.7', '2003/09/24 16:57', 'GRAZIELLA', 2, 'http://georges/');
