-- phpMyAdmin SQL Dump
-- version 4.6.5.1
-- https://www.phpmyadmin.net/
--
-- Client :  localhost
-- Généré le :  Lun 03 Avril 2017 à 14:50
-- Version du serveur :  5.6.34
-- Version de PHP :  7.1.0

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

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

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

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `gender` char(1) NOT NULL,
  `name` varchar(50) NOT NULL,
  `surname` varchar(50) NOT NULL,
  `birthday` date NOT NULL,
  `email` varchar(100) NOT NULL,
  `pwd` varchar(60) NOT NULL,
  `country` char(2) NOT NULL,
  `phone` char(10) DEFAULT NULL,
  `job` varchar(50) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_inserted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `token` char(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `users`
--

INSERT INTO `users` (`id`, `gender`, `name`, `surname`, `birthday`, `email`, `pwd`, `country`, `phone`, `job`, `is_deleted`, `date_inserted`, `date_updated`, `token`) VALUES
(3, 'm', 'benitah', 'samuel', '1997-03-08', 'sambenitah@gmail.com', '$2y$10$8qUHfmDs28ZYlKcolrUU9OQLrjp6J4As4XVEhZBfJjFhDTQ5Hk5mi', 'fr', '0622575874', 'élève', 0, '2017-03-27 12:58:08', '0000-00-00 00:00:00', ''),
(4, 'm', 'benitah', 'samuel', '1997-03-08', 'slbbenitah@gmail.com', '$2y$10$W8ixqkPr0Mo2aRUaHiYYGOzPaw5AKy5TX8/2rgDt4Zi3K6S7Lpqcq', 'fr', '0622575874', 'élève', 0, '2017-03-27 13:01:14', '0000-00-00 00:00:00', 'e9b448c627ba2afc9ebf8cf9995c9033'),
(5, 'm', 'benitah', 'samuel', '1997-03-08', 'samsambenitah@gmail.com', '$2y$10$Ltsr4YLDSOMe2YXePFO.9Ohjkfq9EYvGc7PbNk04nVLf/XVoPW9EK', 'fr', '0622575874', 'élève', 0, '2017-03-27 13:06:02', '0000-00-00 00:00:00', ''),
(6, '', '', '', '0000-00-00', '', '', '', NULL, NULL, 0, '2017-04-03 12:17:29', '0000-00-00 00:00:00', '');

--
-- Index pour les tables exportées
--

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pour les tables exportées
--

--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;