File "test_21_11_2014.sql"
Full Path: /home/analogde/www/Divers/Location site/test_21_11_2014.sql
File size: 4.67 KB
MIME-type: text/plain
Charset: utf-8
-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Jeu 20 Novembre 2014 à 22:44
-- 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');
/*!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 */;