2uheYLT1

1-- phpMyAdmin SQL Dump
2-- version 4.1.4
3-- http://www.phpmyadmin.net
4--
5-- Client :  127.0.0.1
6-- Généré le :  Ven 06 Janvier 2017 à 10:23
7-- Version du serveur :  5.6.15-log
8-- Version de PHP :  5.4.24
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de données :  `exovue`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Doublure de structure pour la vue `clicopro`
27--
28CREATE TABLE IF NOT EXISTS `clicopro` (
29`numCli` int(11)
30,`nom` varchar(25)
31,`prenom` varchar(20)
32,`numProd` int(11)
33,`designation` varchar(20)
34,`prixUnitaire` float
35);
36-- --------------------------------------------------------
37
38--
39-- Structure de la table `client`
40--
41
42CREATE TABLE IF NOT EXISTS `client` (
43  `numCli` int(11) NOT NULL,
44  `nom` varchar(25) DEFAULT NULL,
45  `prenom` varchar(20) DEFAULT NULL,
46  `dateNaiss` date DEFAULT NULL,
47  `CP` int(5) DEFAULT NULL,
48  `rue` varchar(40) DEFAULT NULL,
49  `ville` varchar(15) DEFAULT NULL,
50  PRIMARY KEY (`numCli`)
51) ENGINE=MyISAM DEFAULT CHARSET=latin1;
52
53--
54-- Contenu de la table `client`
55--
56
57INSERT INTO `client` (`numCli`, `nom`, `prenom`, `dateNaiss`, `CP`, `rue`, `ville`) VALUES
58(1, 'Durant', 'Sophie', '1970-12-01', 94230, 'rue des Saussaies', 'Cachan'),
59(2, 'Dupuit', 'Georges', '1969-12-01', 94230, 'rue des vignes', 'Cachan'),
60(3, 'Dupont', 'Jeannot', '1968-12-01', 94230, 'rue des sablons', 'Cachan'),
61(4, 'Dugenou', 'Paul', '1967-12-01', 94230, 'rue Wilson', 'Cachan');
62
63-- --------------------------------------------------------
64
65--
66-- Doublure de structure pour la vue `clipro`
67--
68CREATE TABLE IF NOT EXISTS `clipro` (
69`nom` varchar(25)
70,`prenom` varchar(20)
71,`designation` varchar(20)
72);
73-- --------------------------------------------------------
74
75--
76-- Structure de la table `commande`
77--
78
79CREATE TABLE IF NOT EXISTS `commande` (
80  `numCliC` int(11) NOT NULL DEFAULT '0',
81  `numProdC` int(11) NOT NULL DEFAULT '0',
82  PRIMARY KEY (`numCliC`,`numProdC`),
83  KEY `fk_commande_numProdc` (`numProdC`)
84) ENGINE=MyISAM DEFAULT CHARSET=latin1;
85
86--
87-- Contenu de la table `commande`
88--
89
90INSERT INTO `commande` (`numCliC`, `numProdC`) VALUES
91(1, 100),
92(1, 101),
93(1, 102),
94(1, 103),
95(1, 104),
96(2, 104),
97(3, 102);
98
99-- --------------------------------------------------------
100
101--
102-- Structure de la table `produit`
103--
104
105CREATE TABLE IF NOT EXISTS `produit` (
106  `numProd` int(11) NOT NULL,
107  `designation` varchar(20) DEFAULT NULL,
108  `prixUnitaire` float DEFAULT NULL,
109  PRIMARY KEY (`numProd`)
110) ENGINE=MyISAM DEFAULT CHARSET=latin1;
111
112--
113-- Contenu de la table `produit`
114--
115
116INSERT INTO `produit` (`numProd`, `designation`, `prixUnitaire`) VALUES
117(100, 'bougies parfumées', 15),
118(101, 'bougeoir', 150),
119(102, 'allumettes', 3),
120(103, 'cheminée', 1500),
121(104, 'chandelier', 600);
122
123-- --------------------------------------------------------
124
125--
126-- Structure de la vue `clicopro`
127--
128DROP TABLE IF EXISTS `clicopro`;
129
130CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `clicopro` AS select `client`.`numCli` AS `numCli`,`client`.`nom` AS `nom`,`client`.`prenom` AS `prenom`,`produit`.`numProd` AS `numProd`,`produit`.`designation` AS `designation`,`produit`.`prixUnitaire` AS `prixUnitaire` from ((`client` join `commande` on((`client`.`numCli` = `commande`.`numCliC`))) join `produit` on((`produit`.`numProd` = `commande`.`numProdC`)));
131
132-- --------------------------------------------------------
133
134--
135-- Structure de la vue `clipro`
136--
137DROP TABLE IF EXISTS `clipro`;
138
139CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `clipro` AS select `clicopro`.`nom` AS `nom`,`clicopro`.`prenom` AS `prenom`,`clicopro`.`designation` AS `designation` from `clicopro`;
140
141/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
142/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
143/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;