-- phpMyAdmin SQL Dump
-- version 4.0.10.20
-- https://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Mar 05 Juin 2018 à 03:42
-- Version du serveur: 5.1.73
-- Version de PHP: 5.3.3

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: `ovh_etu57`
--

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

--
-- Structure de la table `reservation`
--

CREATE TABLE IF NOT EXISTS `reservation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL,
  `nom` varchar(250) NOT NULL,
  `gsm` int(12) DEFAULT NULL,
  `nbrpersonne` tinyint(4) NOT NULL,
  `date` date NOT NULL,
  `heure` varchar(5) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`,`date`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;

--
-- Contenu de la table `reservation`
--

INSERT INTO `reservation` (`id`, `email`, `nom`, `gsm`, `nbrpersonne`, `date`, `heure`) VALUES
(1, 'v@a', 'P', 3, 3, '2018-05-31', '00:00'),
(4, 'az@z', 'a', 2, 6, '2018-05-29', '00:00'),
(6, 'l@l', 'l', 0, 2, '2018-05-28', '00:00'),
(7, 'n@n', 'n', 5, 2, '2018-05-31', '11h30'),
(8, 'h@h', 'h', 3, 10, '2018-06-06', '11h30'),
(9, 'v@v', 'v', 6, 1, '2018-06-02', '11h30'),
(10, 'lp@l', 'lp', 9, 1, '2018-06-02', '11h30'),
(11, 'nh@nh', 'nh', 5, 11, '2018-06-21', '11h30'),
(13, 'nh@nha', 'nh', 5, 11, '2018-06-21', '11h30'),
(14, 'nh@nhaa', 'nh', 5, 11, '2018-06-21', '11h30'),
(15, 'az@za', 'aa', 3, 9, '2018-07-05', '11h30'),
(16, 'az@zaa', 'aa', 3, 9, '2018-07-05', '11h30'),
(17, 'az@zaaa', 'aa', 3, 9, '2018-07-05', '11h30'),
(18, 'az@zaaag', 'aa', 3, 9, '2018-07-05', '20h30'),
(20, 'aaa@a', 'na', 3, 11, '2018-06-28', '19h00'),
(21, 'z@za', 'az', 127, 8, '2018-06-23', '14h00'),
(22, 'a@zer', 'na', 127, 7, '2018-06-11', '13h30'),
(23, '', '', 0, 1, '0000-00-00', '11h30'),
(24, 'a@aaaaa', 'a', 127, 8, '2018-05-31', '20h00'),
(25, 'a@aaaaaaaa', 'a', 2147483647, 1, '2018-06-03', '19h30'),
(26, 'peee@epee', 'Peeee', 142354789, 4, '2018-06-28', '11h30'),
(27, 'mapap@mzm', 'mz', 2147483647, 5, '2018-06-21', '12H30'),
(28, 'azeroth@g', 'Azeroth ', 2147483647, 11, '2018-06-16', '20h30'),
(29, 'gui@gui', 'Gui', 123456789, 6, '2018-06-20', '12H00');

/*!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 */;
