# phpMyAdmin MySQL-Dump
# version 2.2.6
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Serveur: localhost
# Généré le : Samedi 06 Septembre 2003 à 00:07
# Version du serveur: 3.23.49
# Version de PHP: 4.2.0
# Base de données: `dbPizza`
# --------------------------------------------------------

#
# Structure de la table `client`
#

CREATE TABLE client (
  numClient smallint(6) NOT NULL default '0',
  adrClient varchar(30) default NULL,
  cpClient varchar(5) default NULL,
  nomClient varchar(20) default NULL,
  prenomClient varchar(20) default NULL,
  telClient varchar(10) default NULL,
  villeClient varchar(25) default NULL,
  PRIMARY KEY  (numClient)
) TYPE=MyISAM;

#
# Contenu de la table `client`
#

INSERT INTO client VALUES (1, '25, rue Danton', '93100', 'Gamin', 'Gilles', '0148457831', 'Montreuil');
INSERT INTO client VALUES (2, '10, allee des Palmiers', '93100', 'Varitas', 'Alain', '0148124545', 'Montreuil');
INSERT INTO client VALUES (3, '7, avenue Faidherbe', '93100', 'Chahed', 'Hamed', '0148989870', 'Montreuil');
INSERT INTO client VALUES (4, '45, avenue de la Gare', '93110', 'Bonard', 'Martine', '0147785656', 'Rosny');
INSERT INTO client VALUES (5, '41, rue Parat', '93230', 'Muller', 'Jean', '0149897878', 'Romainville');
INSERT INTO client VALUES (6, '1, rue Blanche', '93110', 'Bison', 'Jacques', '0147554747', 'Rosny');
INSERT INTO client VALUES (7, '11, rue Rochebrune', '93100', 'Dainsire', 'Aimable', '0148552233', 'Montreuil');
INSERT INTO client VALUES (8, '3, avenue Leclerc', '93100', 'Muller', 'Irma', '0148453212', 'Montreuil');
# --------------------------------------------------------

#
# Structure de la table `commande`
#

CREATE TABLE commande (
  numCommande int(11) NOT NULL default '0',
  numClient smallint(11) NOT NULL default '0',
  codeLivreur char(2) NOT NULL default '',
  dateLivraison date default NULL,
  heureLivraison tinyint(4) default NULL,
  PRIMARY KEY  (numCommande)
) TYPE=MyISAM;

#
# Contenu de la table `commande`
#

INSERT INTO commande VALUES (10, 4, 'JP', '02-12-19',18);
INSERT INTO commande VALUES (9, 1, 'KH', '02-12-19',21);
INSERT INTO commande VALUES (8, 1, 'YH', '02-12-19',19);
INSERT INTO commande VALUES (7, 8, 'FG', '02-12-20',19);
INSERT INTO commande VALUES (6, 6, 'JP', '02-12-20',22);
INSERT INTO commande VALUES (5, 5, 'YH', '02-12-21',21);
INSERT INTO commande VALUES (4, 3, 'JP', '02-12-22',19);
INSERT INTO commande VALUES (3, 6, 'KH', '02-12-22',20);
INSERT INTO commande VALUES (2, 5, 'FG', '02-12-22',20);
# --------------------------------------------------------

#
# Structure de la table `commander`
#

CREATE TABLE commander (
  codePizza varchar(4) NOT NULL default '',
  numCommande int(6) NOT NULL default '0',
  qte tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (codePizza,numCommande)
) TYPE=MyISAM;

#
# Contenu de la table `commander`
#

INSERT INTO commander VALUES ('CLA2', 1, 1);
INSERT INTO commander VALUES ('REI4', 1, 2);
INSERT INTO commander VALUES ('TEX2', 2, 1);
INSERT INTO commander VALUES ('REI4', 2, 2);
INSERT INTO commander VALUES ('REI6', 3, 1);
INSERT INTO commander VALUES ('ROY4', 3, 2);
INSERT INTO commander VALUES ('TEX2', 3, 1);
INSERT INTO commander VALUES ('CLA4', 4, 2);
INSERT INTO commander VALUES ('ROY6', 5, 1);
INSERT INTO commander VALUES ('REI2', 5, 2);
INSERT INTO commander VALUES ('TEX2', 6, 1);
INSERT INTO commander VALUES ('ROY2', 6, 1);
INSERT INTO commander VALUES ('ROY4', 6, 1);
INSERT INTO commander VALUES ('CLA4', 7, 1);
INSERT INTO commander VALUES ('REI6', 7, 2);
INSERT INTO commander VALUES ('TEX4', 8, 1);
INSERT INTO commander VALUES ('REI4', 8, 2);
INSERT INTO commander VALUES ('TEX4', 9, 1);
INSERT INTO commander VALUES ('REI4', 9, 2);
INSERT INTO commander VALUES ('TEX4', 10, 2);
INSERT INTO commander VALUES ('REI2', 10, 1);
# --------------------------------------------------------

#
# Structure de la table `livreur`
#

CREATE TABLE livreur (
  codeLivreur char(2) NOT NULL default '',
  cpLivreur varchar(5) default NULL,
  nomLivreur varchar(20) default NULL,
  prenomLivreur varchar(20) default NULL,
  villeLivreur varchar(20) default NULL,
  adrLivreur varchar(30) default NULL,
  PRIMARY KEY  (codeLivreur)
) TYPE=MyISAM;

#
# Contenu de la table `livreur`
#

INSERT INTO livreur VALUES ('JP', '93110', 'Parole', 'Jacques', 'Rosny', '12, allee des Noyers');
INSERT INTO livreur VALUES ('YH', '93100', 'Hamid', 'Youssef', 'Montreuil', '45, rue des Sentiers');
INSERT INTO livreur VALUES ('KH', '93100', 'Hamid', 'Kalhed', 'Montreuil', '45, rue des Sentiers');
INSERT INTO livreur VALUES ('FG', '93110', 'Galien', 'Franc', 'Rosny', '123, allee Blanche');
# --------------------------------------------------------

#
# Structure de la table `pizza`
#

CREATE TABLE pizza (
  codePizza varchar(4) NOT NULL default '',
  libPizza varchar(30) default NULL,
  nbPersonnes tinyint(4) default NULL,
  prix tinyint(4) default NULL,
  PRIMARY KEY  (codePizza)
) TYPE=MyISAM;

#
# Contenu de la table `pizza`
#

INSERT INTO pizza VALUES ('CLA2', 'La classic', 2, 5);
INSERT INTO pizza VALUES ('CLA4', 'La classic', 4, 9);
INSERT INTO pizza VALUES ('CLA6', 'La classic', 6, 12);
INSERT INTO pizza VALUES ('REI2', 'La reine', 2, 6);
INSERT INTO pizza VALUES ('REI4', 'La reine', 4, 11);
INSERT INTO pizza VALUES ('REI6', 'La reine', 6, 16);
INSERT INTO pizza VALUES ('TEX2', 'La texane', 2, 5);
INSERT INTO pizza VALUES ('TEX4', 'La texane', 4, 9);
INSERT INTO pizza VALUES ('ROY2', 'La royale', 2, 7);
INSERT INTO pizza VALUES ('ROY4', 'La royale', 4, 13);
INSERT INTO pizza VALUES ('ROY6', 'La royale', 6, 19);