-- http://www.phpmyadmin.net
--
-- Serveur: 127.0.0.1
-- Généré le : Jeu 08 Mars 2012 à 07:06
-- Version du serveur: 5.1.54
-- Version de PHP: 5.3.4




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

--
-- Structure de la table `forum_answer`
--

CREATE TABLE IF NOT EXISTS `peuple_bavard_forum_answer` (
  `question_id` int(4) NOT NULL DEFAULT '0',
  `a_id` int(4) NOT NULL DEFAULT '0',
  `a_link` smallint(5) unsigned NOT NULL COMMENT 'id du commentaire lié',
  `a_group` smallint(5) unsigned NOT NULL COMMENT 'repère un groupe ou sous-arbre',
  `a_rang` tinyint(3) unsigned NOT NULL COMMENT 'fixe le rang d''un commentair',
  `a_etat` tinyint(4) NOT NULL COMMENT 'état du commentaire 0=del 1=standby',
  `a_name` varchar(65) NOT NULL DEFAULT '',
  `a_email` varchar(65) NOT NULL DEFAULT '',
  `a_answer` longtext NOT NULL,
  `a_datetime` varchar(25) NOT NULL DEFAULT '',
  KEY `a_id` (`a_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `forum_answer`
--

INSERT INTO `peuple_bavard_forum_answer` (`question_id`, `a_id`, `a_link`, `a_group`, `a_rang`, `a_etat`, `a_name`, `a_email`, `a_answer`, `a_datetime`) VALUES
(3, 1, 0, 1, 0, 0, 'michelb', 'michel.boussekeyt@univ-lille1.fr', 'c est ma réponse', '06/12/11 17:36:28'),
(3, 2, 1, 1, 1, 0, 'michelb', 'michel.boussekeyt@univ-lille1.fr', 'une deuxieme reponse', '06/12/11 17:37:46'),
(3, 3, 2, 1, 2, 0, '', '', 'michelb', '25/12/11 11:21:38'),
(3, 4, 2, 1, 3, 0, '', '', '', '25/12/11 11:33:43'),
(3, 5, 0, 2, 0, 0, '', '', '', '25/12/11 11:35:19'),
(3, 6, 5, 2, 1, 0, 'toto', 'toto@free.fr', 'un gros toto', '25/12/11 11:46:31'),
(3, 7, 6, 2, 2, 0, 'toto', 'toto@free.fr', 'un gros toto', '25/12/11 11:51:28'),
(3, 8, 6, 2, 2, 0, 'toto le plus grand', 'grand_toto@sfr.fr', 'grand sfr toto', '26/12/11 12:13:15'),
(3, 9, 2, 3, 2, 0, 'toto le plus grand', 'grand_toto@sfr.fr', 'grand sfr toto', '26/12/11 12:13:38'),
(3, 10, 2, 1, 2, 0, 'toto le plus grand', 'grand_toto@sfr.fr', 'grand sfr toto', '26/12/11 12:16:00'),
(3, 11, 1, 1, 1, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 12:40:51'),
(3, 12, 6, 3, 2, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 12:41:53'),
(3, 13, 5, 2, 1, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 12:42:52'),
(3, 14, 0, 1, 0, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 12:43:00'),
(3, 15, 0, 4, 3, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 01:02:12'),
(3, 16, 0, 3, 0, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 01:02:25'),
(3, 17, 0, 1, 3, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 01:03:33'),
(3, 18, 0, 2, 0, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 01:19:26'),
(3, 19, 0, 3, 3, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 01:19:37'),
(3, 20, 0, 3, 0, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 01:21:25'),
(3, 21, 0, 3, 3, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 01:26:30'),
(3, 22, 0, 4, 0, 0, 'emeline', 'emeline@sfr.fr', 'sfr', '26/12/11 01:26:44'),
(3, 23, 0, 2, 3, 0, 'recommence', 'recommence@meiux.fr', 'ok ok', '26/12/11 01:32:43'),
(3, 24, 0, 1, 3, 0, 'recommence', 'recommence@meiux.fr', 'ok ok', '26/12/11 01:43:09'),
(3, 25, 0, 2, 0, 0, 'recommence', 'recommence@meiux.fr', 'ok ok', '26/12/11 01:49:11'),
(3, 26, 0, 3, 0, 0, 'pascal', 'pascal@free.fr', 'c est à pascal', '26/12/11 01:55:34'),
(3, 27, 0, 4, 0, 0, 'dernier', 'dernier@yahoo.fr', 'dernier', '26/12/11 02:09:27');

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

--
-- Structure de la table `forum_question`
--

CREATE TABLE IF NOT EXISTS `peuple_bavard_forum_question` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `topic` varchar(255) NOT NULL DEFAULT '',
  `detail` longtext NOT NULL,
  `name` varchar(65) NOT NULL DEFAULT '',
  `email` varchar(65) NOT NULL DEFAULT '',
  `datetime` varchar(25) NOT NULL DEFAULT '',
  `view` int(4) NOT NULL DEFAULT '0',
  `reply` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Contenu de la table `forum_question`
--

INSERT INTO `peuple_bavard_forum_question` (`id`, `topic`, `detail`, `name`, `email`, `datetime`, `view`, `reply`) VALUES
(1, 'personne', 'this is mywife', 'michelb', 'michel.boussekeyt@univ-lille1.fr', '06/12/11 05:14:20', 3, 0),
(2, 'personne', 'this is mywife', 'michelb', 'michel.boussekeyt@univ-lille1.fr', '06/12/11 05:15:45', 2, 0),
(3, 'other', 'person', 'lou', 'lou@yahoo.fr', '06/12/11 05:16:38', 157, 26),
(4, 'georges', 'c est le détail de georges', 'michelb', 'michel.boussekeyt@univ-lille1.fr', '25/12/11 04:01:10', 0, 0),
(5, 'georges V', 'c est les détail de georges V', 'michelb', 'michel.boussekeyt@univ-lille1.fr', '25/12/11 04:09:56', 24, 0),
(6, 'georges jean sans peur', 'c est les détail de georges V', 'michelb', 'michel.boussekeyt@univ-lille1.fr', '25/12/11 04:10:55', 0, 0),
(7, 'georges jean sans peur', 'c est les détail de georges V', 'michelb', 'michel.boussekeyt@univ-lille1.fr', '25/12/11 04:30:47', 2, 0);
