File "db_test.sql"
Full Path: /home/analogde/www/download/Location site/db_test.sql
File size: 8.27 KB
MIME-type: text/plain
Charset: utf-8
-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Client : 127.0.0.1
-- Généré le : Dim 16 Novembre 2014 à 19:15
-- Version du serveur : 5.6.17
-- Version de PHP : 5.5.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`
--
-- --------------------------------------------------------
--
-- 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 `ouverture_fermeture_2015`
--
CREATE TABLE IF NOT EXISTS `ouverture_fermeture_2015` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ouverture` varchar(10) DEFAULT NULL,
`fermeture` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Contenu de la table `ouverture_fermeture_2015`
--
INSERT INTO `ouverture_fermeture_2015` (`id`, `ouverture`, `fermeture`) VALUES
(1, '15-03-2015', '15-11-2015');
-- --------------------------------------------------------
--
-- 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,
`telephone` varchar(15) NOT NULL,
`email` varchar(30) NOT NULL,
`message` text 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=12 ;
--
-- Contenu de la table `reservation`
--
INSERT INTO `reservation` (`id`, `nom`, `prenom`, `telephone`, `email`, `message`, `date`, `heure`, `debut`, `depart`, `statut`) VALUES
(10, 'delpy', 'patrice', '0563455132', 'patrice.delpy@free.fr', '', '2014-11-15', '23:08', '14-07-2015', '31-07-2015', 'reserver'),
(11, 'blase', 'vincent', '0563455132', 'patrice.delpy@free.fr', '', '2014-11-16', '17:55', '06-06-2015', '13-06-2015', 'reserver');
-- --------------------------------------------------------
--
-- Structure de la table `reservation_2015`
--
CREATE TABLE IF NOT EXISTS `reservation_2015` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`debut` varchar(20) DEFAULT NULL,
`depart` varchar(20) DEFAULT NULL,
`semaine` varchar(20) DEFAULT NULL,
`nom` varchar(255) DEFAULT NULL,
`prenom` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`telephone` varchar(255) DEFAULT NULL,
`message` text,
`date_reservation` varchar(20) DEFAULT NULL,
`heure` varchar(20) DEFAULT NULL,
`statut` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=204 ;
--
-- Contenu de la table `reservation_2015`
--
INSERT INTO `reservation_2015` (`id`, `debut`, `depart`, `semaine`, `nom`, `prenom`, `email`, `telephone`, `message`, `date_reservation`, `heure`, `statut`) VALUES
(164, '07-02-2015', '14-02-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(165, '14-02-2015', '21-02-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(166, '21-02-2015', '28-02-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(167, '28-02-2015', '07-03-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(168, '07-03-2015', '14-03-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(169, '14-03-2015', '21-03-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(170, '21-03-2015', '28-03-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(171, '28-03-2015', '04-04-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(172, '04-04-2015', '11-04-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(173, '11-04-2015', '18-04-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(174, '18-04-2015', '25-04-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(175, '25-04-2015', '02-05-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(176, '02-05-2015', '09-05-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(177, '09-05-2015', '16-05-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(178, '16-05-2015', '23-05-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(179, '23-05-2015', '30-05-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(180, '30-05-2015', '06-06-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(181, '06-06-2015', '13-06-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(182, '13-06-2015', '20-06-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(183, '20-06-2015', '27-06-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(184, '27-06-2015', '04-07-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(185, '04-07-2015', '11-07-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(186, '11-07-2015', '18-07-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'reserver'),
(187, '18-07-2015', '25-07-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'reserver'),
(188, '25-07-2015', '01-08-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(189, '01-08-2015', '08-08-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(190, '08-08-2015', '15-08-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(191, '15-08-2015', '22-08-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(192, '22-08-2015', '29-08-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(193, '29-08-2015', '05-09-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(194, '05-09-2015', '12-09-2015 \r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(195, '12-09-2015', '19-09-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(196, '19-09-2015', '26-09-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(197, '26-09-2015', '03-10-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(198, '03-10-2015', '10-10-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(199, '10-10-2015', '17-10-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(200, '17-10-2015', '24-10-2015 \r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(201, '24-10-2015', '31-10-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(202, '31-10-2015', '07-11-2015\r\n', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible'),
(203, '07-10-2015', '14-11-2015', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'disponible');
/*!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 */;