-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Jeu 13 Novembre 2014 à 22:37
-- Version du serveur: 5.6.12-log
-- Version de PHP: 5.4.12

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: `test`
--
CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `test`;

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

--
-- Structure de la table `avis`
--

CREATE TABLE IF NOT EXISTS `avis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(30) NOT NULL,
  `prenom` varchar(30) NOT NULL,
  `email` varchar(30) NOT NULL,
  `sujet` varchar(50) NOT NULL,
  `message` text NOT NULL,
  `date` varchar(20) NOT NULL,
  `heure` varchar(20) NOT NULL,
  `question` varchar(255) NOT NULL,
  `noter` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `avis`
--

INSERT INTO `avis` (`id`, `nom`, `prenom`, `email`, `sujet`, `message`, `date`, `heure`, `question`, `noter`) VALUES
(1, 'delpy', 'patrice', 'patrice.delpy@free.fr', 'mon opinion', 'blabla', '03-11-2014', '19:42:25', 'non-non', ''),
(2, 'delpylkljlk', 'patrice', 'patrice.delpy@free.fr', 'aasdkfkk', 'ddslfdslgfjl', '03-11-2014', '21:33:36', 'oui-oui', ''),
(3, 'delpylkljlk', 'patrice', 'patrice.delpy@free.fr', 'aasdkfkk', 'ddslfdslgfjl', '03-11-2014', '21:41:26', 'non-oui', ''),
(4, 'blase', 'vincent', 'patrice.delpy@free.fr', 'coucou', 'dlgglmdl', '04-11-2014', '19:12:20', 'oui-non', '');

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

--
-- Structure de la table `bookings`
--

CREATE TABLE IF NOT EXISTS `bookings` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `start` time NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `comments` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `dateformat`
--

CREATE TABLE IF NOT EXISTS `dateformat` (
  `idpick` int(11) NOT NULL AUTO_INCREMENT,
  `datef` date NOT NULL DEFAULT '0000-00-00',
  `datef2` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`idpick`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Contenu de la table `dateformat`
--

INSERT INTO `dateformat` (`idpick`, `datef`, `datef2`) VALUES
(1, '0000-00-00', '2010-12-05'),
(2, '2014-10-15', '0000-00-00');

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

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

CREATE TABLE IF NOT EXISTS `reservation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nom` varchar(30) NOT NULL,
  `prenom` varchar(30) NOT NULL,
  `adresse` text NOT NULL,
  `telephone` varchar(15) NOT NULL,
  `email` varchar(30) NOT NULL,
  `date` varchar(20) NOT NULL,
  `heure` varchar(20) NOT NULL,
  `debut` varchar(10) DEFAULT NULL,
  `depart` varchar(10) DEFAULT NULL,
  `statut` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

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

INSERT INTO `reservation` (`id`, `nom`, `prenom`, `adresse`, `telephone`, `email`, `date`, `heure`, `debut`, `depart`, `statut`) VALUES
(2, '', '0', '', '', '', '0000-00-00', '00:00:00', '09-08-2015', '25-08-2015', 'reserver'),
(3, '', '0', '', '', '', '0000-00-00', '00:00:00', '26-11-2014', '27-11-2014', 'reservation'),
(4, 'delpy', '0', '', '0625775256', 'dd', 'dd', '21:00', '12-11-2014', '29-11-2014', 'Annulation'),
(5, 'blase', 'moi', '', '0625775256', 'dd@free.fr', 'dd@free.fr', '21:01', '12-11-2014', '29-11-2014', 'louer'),
(6, 'delpy', 'aaPatrice', '', '0625775256', 'dd@free.fr', '2014-10-29 22:02:08', '21:02', '12-11-2014', '29-11-2014', 'Annulation'),
(7, 'delpy', 'Patrice', '', '0625775256', 'dd@free.fr', '29-10-2014', '21:04', '12-11-2014', '29-11-2014', 'Annulation');

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