-- phpMyAdmin SQL Dump
-- version 4.0.10
-- http://www.phpmyadmin.net
--
-- Client: cl1-sql22
-- Généré le: Dim 02 Octobre 2016 à 20:57
-- Version du serveur: 10.0.27-MariaDB-1~jessie
-- Version de PHP: 5.6.24-0+deb8u1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


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

--
-- Base de données: `llg12041`
--

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

--
-- Structure de la table `news_letter`
--

CREATE TABLE IF NOT EXISTS `news_letter` (
  `Id_news` int(11) NOT NULL AUTO_INCREMENT,
  `Date_Inscrit_news` varchar(50) NOT NULL,
  `Civilite_news` varchar(25) NOT NULL,
  `Nom_news` varchar(50) NOT NULL,
  `Prenom_news` varchar(50) NOT NULL,
  `Ville_news` varchar(50) NOT NULL,
  `Pays_news` varchar(50) NOT NULL,
  `Email_news` varchar(250) NOT NULL,
  `Recevoir_news` varchar(5) NOT NULL,
  `Confirme_news` varchar(3) NOT NULL,
  `Hash_mail_news` varchar(50) NOT NULL,
  PRIMARY KEY (`Id_news`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Table recevant les données des personnes souhaitant recevoir les news du CBAT-MP' AUTO_INCREMENT=4 ;

--
-- Contenu de la table `news_letter`
--

INSERT INTO `news_letter` (`Id_news`, `Date_Inscrit_news`, `Civilite_news`, `Nom_news`, `Prenom_news`, `Ville_news`, `Pays_news`, `Email_news`, `Recevoir_news`, `Confirme_news`, `Hash_mail_news`) VALUES
(2, 'Samedi-01-Octobre-2016', 'Monsieur', 'Ndima', 'Pierre Olivier', 'Yaoundé', 'Cameroun', 'pierre.ozima@free.fr', 'OUI', 'NON', '584c7bededec3e845fd333443c4b0491'),
(3, 'Dimanche-02-Octobre-2016', 'Monsieur', 'OPANGO', 'Pierre', 'Toulouse', 'France', 'pbolanega@yahoo.fr', 'OUI', 'NON', '2a35de2ef7fb5b4f78c27a25c7a7388f');

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