-- http://www.phpmyadmin.net
--
-- Serveur: 127.0.0.1
-- Généré le : Lun 07 Mai 2012 à 10:45
-- Version du serveur: 5.1.54
-- Version de PHP: 5.3.4




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

--
-- Structure de la table `peuple_bavard_customers_info`
--

CREATE TABLE IF NOT EXISTS `peuple_bavard_customers_info` (
  `c_info_id` int(11) NOT NULL DEFAULT '0',
  `c_info_date_of_last_logon` datetime DEFAULT NULL,
  `c_info_number_of_logons` int(5) DEFAULT NULL,
  `c_info_date_account_created` datetime DEFAULT NULL,
  `c_info_date_account_last_modified` datetime DEFAULT NULL,
  `c_global_product_notifications` int(1) DEFAULT '0',
  `c_dob` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `c_dod` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `peuple_bavard_customers_info`
--

INSERT INTO `peuple_bavard_customers_info` (`c_info_id`, `c_info_date_of_last_logon`, `c_info_number_of_logons`, `c_info_date_account_created`, `c_info_date_account_last_modified`, `c_global_product_notifications`, `c_dob`, `c_dod`) VALUES
(1, '2012-03-08 07:54:09', 216, '2012-03-08 07:54:09', '2012-03-08 07:54:09', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, '2012-02-25 00:00:00', 1, '2012-02-25 00:00:00', '2012-02-25 00:00:00', 0, '2012-02-25 22:23:39', '0000-00-00 00:00:00'),
(14, '2012-02-26 00:00:00', 1, '2012-02-26 00:00:00', '2012-02-26 00:00:00', 0, '2012-02-26 07:52:49', '0000-00-00 00:00:00'),
(15, '2012-02-27 00:00:00', 2, '2012-02-27 00:00:00', '2012-02-27 00:00:00', 0, '2012-02-27 18:00:47', '0000-00-00 00:00:00'),
(0, '2012-04-25 23:03:13', 47, '2012-03-08 15:51:31', '2012-03-08 15:51:31', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(27, '2012-02-29 15:09:33', 0, '2012-02-29 15:09:33', '2012-02-29 15:09:33', 0, '2012-02-29 15:09:33', '2012-02-29 15:09:33'),
(28, '2012-02-29 15:12:25', 0, '2012-02-29 21:46:11', '2012-02-29 15:12:25', 0, '2012-02-29 15:12:25', '2012-02-29 15:12:25'),
(29, '2012-03-04 15:50:10', 0, '2012-03-04 15:50:10', '2012-03-04 15:50:10', 0, '2012-03-04 15:50:10', '2012-03-04 15:50:10'),
(30, '2012-03-04 15:55:28', 0, '2012-03-04 15:55:28', '2012-03-04 15:55:28', 0, '2012-03-04 15:55:28', '2012-03-04 15:55:28'),
(31, '2012-03-10 05:27:00', 304, '2012-03-08 13:08:41', '2012-03-08 13:08:41', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(32, '2012-05-07 10:41:30', 306, '2012-03-10 05:41:50', '2012-03-10 05:41:50', 0, '2012-03-10 05:41:50', '2012-03-10 05:41:50'),
(33, '2012-03-11 05:46:28', 19, '2012-03-10 16:32:19', '2012-03-10 16:32:19', 0, '2012-03-10 16:32:19', '2012-03-10 16:32:19');

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

--
-- Structure de la table `peuple_bavard_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 `peuple_bavard_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 `peuple_bavard_forum_question`
--

CREATE TABLE IF NOT EXISTS `peuple_bavard_forum_question` (
  `id` int(4) NOT NULL AUTO_INCREMENT COMMENT 'identifiant article inutilisé',
  `short_title` varchar(96) NOT NULL COMMENT 'titre court de l''article',
  `id_content` varchar(14) NOT NULL COMMENT 'identifiant de l''article',
  `id_author` int(4) NOT NULL COMMENT 'identifiant de l''auteur',
  `view` int(4) NOT NULL DEFAULT '0' COMMENT 'nombre de passages',
  `reply` int(4) NOT NULL DEFAULT '0' COMMENT 'nombre  d''interventions',
  `notation` int(1) NOT NULL DEFAULT '100' COMMENT 'notation de 0 à 100 de l''article',
  `date_created` datetime NOT NULL COMMENT 'date de création du billet',
  `date_updated` datetime NOT NULL COMMENT 'date de modification',
  `status` int(1) NOT NULL DEFAULT '2' COMMENT '0=supprimé, 1=invisible, 2=en modif, 3=publié',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Contenu de la table `peuple_bavard_forum_question`
--

INSERT INTO `peuple_bavard_forum_question` (`id`, `short_title`, `id_content`, `id_author`, `view`, `reply`, `notation`, `date_created`, `date_updated`, `status`) VALUES
(1, 'personne', '20120412112005', 34, 3, 0, 100, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2),
(6, 'georges jean sans peur', '20120409093212', 32, 0, 0, 100, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2),
(17, 'c`est_`DEBUG`', '20001212121212', 4, 1000, 100, 65, '2012-04-08 16:44:08', '2012-04-13 18:26:56', 2),
(16, 'j`ai_encore_rêvé_d`elle', '20120408114000', 32, 1, 0, 65, '2012-04-08 15:26:02', '0000-00-00 00:00:00', 2),
(18, 'tout_un_programme', '20120408114000', 34, 1, 0, 65, '2012-04-10 18:41:30', '0000-00-00 00:00:00', 2);

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

--
-- Structure de la table `peuple_bavard_identity_net`
--

CREATE TABLE IF NOT EXISTS `peuple_bavard_identity_net` (
  `identity_net_id` int(11) NOT NULL AUTO_INCREMENT,
  `c_id` int(11) NOT NULL DEFAULT '0',
  `entry_gender` char(1) NOT NULL DEFAULT '',
  `entry_civ` varchar(6) NOT NULL DEFAULT '',
  `entry_firstname` varchar(32) NOT NULL DEFAULT '',
  `entry_lastname` varchar(32) NOT NULL DEFAULT '',
  `entry_mail` varchar(32) NOT NULL DEFAULT '',
  `entry_www` varchar(64) NOT NULL DEFAULT '',
  `entry_ip_address` varchar(32) NOT NULL COMMENT 'contient l''adresse ip de creation au format  iduser::ip_address',
  PRIMARY KEY (`identity_net_id`),
  KEY `idx_address_book_customers_id` (`c_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Contenu de la table `peuple_bavard_identity_net`
--

INSERT INTO `peuple_bavard_identity_net` (`identity_net_id`, `c_id`, `entry_gender`, `entry_civ`, `entry_firstname`, `entry_lastname`, `entry_mail`, `entry_www`, `entry_ip_address`) VALUES
(1, 13, 'f', '', '', '', 'bertrand@free.fr', '', ''),
(2, 14, 'f', '', '', '', 'michelb@free.fr', '', ''),
(3, 15, 'f', '', '', '', 'olivier@sfr.fr', '', ''),
(4, 16, 'G', '', '', '', 'n', '', ''),
(5, 22, 'f', 'Miss', 'name', 'surname', 'poupou@toto.com', '', ''),
(6, 23, 'f', 'Miss', 'poupou', 'surname', 'poupou@toto.com', '', ''),
(7, 24, 'f', 'Miss', 'poupou', 'surname', 'poupou@toto.com', '', ''),
(8, 25, 'f', 'Miss', 'poupou', 'surname', 'poupou@toto.com', '', ''),
(9, 26, 'f', 'Miss', 'poupou', 'surname', 'poupou@toto.com', '', ''),
(10, 27, 'f', 'Miss', 'poupou', 'surname', 'poupou@toto.com', '', ''),
(11, 28, 'f', 'Miss', 'poupou', 'surname', 'poupou@toto.com', '', '28::127.0.0.1'),
(12, 29, 'f', 'Miss', 'michel', 'surname', 'michel0@michel0.com', '', '29::127.0.0.1'),
(13, 30, 'f', 'Miss', 'michel', 'surname', 'michel0@michel0.com', '', '30::127.0.0.1'),
(14, 31, 'f', 'Miss', 'michel', 'surname', 'michel0@michel0.com', '', '31::127.0.0.1'),
(15, 32, 'f', 'Miss', 'simon', 'surname', 'simon0@free.fr', '', '32::127.0.0.1'),
(16, 33, 'f', 'Miss', 'annie', 'surname', 'annie0@online.net', '', '33::127.0.0.1');
