1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122
| -- phpMyAdmin SQL Dump
-- version 3.1.2
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mer 01 Avril 2009 à 15:24
-- Version du serveur: 5.0.67
-- Version de PHP: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de données: `restaurant`
--
-- --------------------------------------------------------
--
-- Structure de la table `clients`
--
CREATE TABLE IF NOT EXISTS `clients` (
`idclients` int(11) NOT NULL auto_increment,
`nom` varchar(50) collate utf8_unicode_ci NOT NULL,
`prenom` varchar(50) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`idclients`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Contenu de la table `clients`
--
INSERT INTO `clients` (`idclients`, `nom`, `prenom`) VALUES
(1, 'Leguoin', 'Paul'),
(2, 'Papou', 'Raymond');
-- --------------------------------------------------------
--
-- Structure de la table `dessert`
--
CREATE TABLE IF NOT EXISTS `dessert` (
`iddessert` int(11) NOT NULL auto_increment,
`dessert` varchar(50) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`iddessert`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Contenu de la table `dessert`
--
INSERT INTO `dessert` (`iddessert`, `dessert`) VALUES
(1, 'île flottante'),
(2, 'fruits');
-- --------------------------------------------------------
--
-- Structure de la table `entree`
--
CREATE TABLE IF NOT EXISTS `entree` (
`identree` int(11) NOT NULL auto_increment,
`entree` varchar(50) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`identree`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Contenu de la table `entree`
--
INSERT INTO `entree` (`identree`, `entree`) VALUES
(1, 'carottes rapées oeufs mimosa'),
(2, 'poireaux en vinaigrette');
-- --------------------------------------------------------
--
-- Structure de la table `platresistance`
--
CREATE TABLE IF NOT EXISTS `platresistance` (
`idplatresistance` int(11) NOT NULL auto_increment,
`platresistance` varchar(50) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`idplatresistance`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Contenu de la table `platresistance`
--
INSERT INTO `platresistance` (`idplatresistance`, `platresistance`) VALUES
(1, 'boeuf bourguignon'),
(2, 'endives au jambon');
-- --------------------------------------------------------
--
-- Structure de la table `reservations`
--
CREATE TABLE IF NOT EXISTS `reservations` (
`idreservations` int(11) NOT NULL auto_increment,
`date` date NOT NULL,
`nom` varchar(50) collate utf8_unicode_ci NOT NULL,
`prenom` varchar(50) collate utf8_unicode_ci NOT NULL,
`entree` varchar(50) collate utf8_unicode_ci NOT NULL,
`platresistance` varchar(50) collate utf8_unicode_ci NOT NULL,
`dessert` varchar(50) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`idreservations`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=28 ;
--
-- Contenu de la table `reservations`
--
INSERT INTO `reservations` (`idreservations`, `date`, `nom`, `prenom`, `entree`, `platresistance`, `dessert`) VALUES
(27, '0000-00-00', 'Papou', 'Raymond', 'poireaux en vinaigrette', '', ''),
(26, '0000-00-00', 'Leguoin', 'Paul', 'poireaux en vinaigrette', '', ''),
(25, '0000-00-00', 'Papou', 'Raymond', 'carottes rapées oeufs mimosa', '', ''),
(24, '0000-00-00', 'Leguoin', 'Paul', 'carottes rapées oeufs mimosa', '', ''); |
Partager