-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Jeu 27 Novembre 2014 à 22:31
-- 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,
  `note` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

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

INSERT INTO `avis` (`id`, `nom`, `prenom`, `email`, `sujet`, `message`, `date`, `heure`, `question`, `note`) VALUES
(1, 'delpy', 'patrice', 'patrice.delpy@free.fr', 'mon opinion', 'blabla', '03-11-2014', '19:42:25', 'non-non', '1'),
(2, 'delpylkljlk', 'patrice', 'patrice.delpy@free.fr', 'aasdkfkk', 'ddslfdslgfjl', '03-11-2014', '21:33:36', 'oui-oui', '2'),
(3, 'delpylkljlk', 'patrice', 'patrice.delpy@free.fr', 'aasdkfkk', 'ddslfdslgfjl', '03-11-2014', '21:41:26', 'non-oui', '3'),
(4, 'blase', 'vincent', 'patrice.delpy@free.fr', 'coucou', 'dlgglmdl', '04-11-2014', '19:12:20', 'oui-non', '4'),
(5, 'aqwzsx', 'aze', 'pat@free.fr', 'bien', 'kljkj', '20-11-2014', '21:29:13', 'oui-oui', '5'),
(6, 'balou', 'coco', 'pignouf@free.fr', 'pf', '77878798', '20-11-2014', '21:48:21', 'non-non', '5');

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

--
-- 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, 'toto', 'pipo', 'kjklkkk', '0563455132', 'patcohe@none.com', '0000-00-00', '00:00:00', '26-11-2014', '27-11-2014', 'Louer'),
(4, 'delpy', '0', '', '0625775256', 'pignouf', 'dd', '21:00', '12-11-2014', '29-11-2014', 'Paiement'),
(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', 'Louer');

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

--
-- Structure de la table `tarif`
--

CREATE TABLE IF NOT EXISTS `tarif` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(30) NOT NULL,
  `ts` varchar(30) NOT NULL,
  `tarif` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=157 ;

--
-- Contenu de la table `tarif`
--

INSERT INTO `tarif` (`id`, `date`, `ts`, `tarif`) VALUES
(118, ' 21-02-2015', '1424476800', '1'),
(119, ' 28-02-2015', '1425081600', '2'),
(120, ' 07-03-2015', '1425686400', '3'),
(121, ' 14-03-2015', '1426291200', '4'),
(122, ' 21-03-2015', '1426896000', '5'),
(123, ' 28-03-2015', '1427500800', '6'),
(124, ' 04-04-2015', '1428105600', '7'),
(125, ' 11-04-2015', '1428710400', '8'),
(126, ' 18-04-2015', '1429315200', '9'),
(127, ' 25-04-2015', '1429920000', '10'),
(128, ' 02-05-2015', '1430524800', '11'),
(129, ' 09-05-2015', '1431129600', '12'),
(130, ' 16-05-2015', '1431734400', '13'),
(131, ' 23-05-2015', '1432339200', '14'),
(132, ' 30-05-2015', '1432944000', '15'),
(133, ' 06-06-2015', '1433548800', '16'),
(134, ' 13-06-2015', '1434153600', '17'),
(135, ' 20-06-2015', '1434758400', '18'),
(136, ' 27-06-2015', '1435363200', '19'),
(137, ' 04-07-2015', '1435968000', '20'),
(138, ' 11-07-2015', '1436572800', '21'),
(139, ' 18-07-2015', '1437177600', '22'),
(140, ' 25-07-2015', '1437782400', '23'),
(141, ' 01-08-2015', '1438387200', '24'),
(142, ' 08-08-2015', '1438992000', '25'),
(143, ' 15-08-2015', '1439596800', '26'),
(144, ' 22-08-2015', '1440201600', '27'),
(145, ' 29-08-2015', '1440806400', '28'),
(146, ' 05-09-2015', '1441411200', '29'),
(147, ' 12-09-2015', '1442016000', '30'),
(148, ' 19-09-2015', '1442620800', '31'),
(149, ' 26-09-2015', '1443225600', '32'),
(150, ' 03-10-2015', '1443830400', '33'),
(151, ' 10-10-2015', '1444435200', '34'),
(152, ' 17-10-2015', '1445040000', '35'),
(153, ' 24-10-2015', '1445644800', '36'),
(154, ' 31-10-2015', '1446249600', '37'),
(155, ' 07-11-2015', '1446854400', '38'),
(156, ' 14-11-2015', '1447459200', '39');

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