GnYjZCs0

1-- MySQL dump 10.13  Distrib 5.7.28, for Linux (x86_64)
2--
3-- Host: localhost    Database: boutique
4-- ------------------------------------------------------
5-- Server version	5.7.28-0ubuntu0.19.04.2
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `catalog`
20--
21
22DROP TABLE IF EXISTS `catalog`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `catalog` (
26  `id_Catalog` int(11) NOT NULL AUTO_INCREMENT,
27  `label` varchar(50) DEFAULT NULL,
28  PRIMARY KEY (`id_Catalog`)
29) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
30/*!40101 SET character_set_client = @saved_cs_client */;
31
32--
33-- Dumping data for table `catalog`
34--
35
36LOCK TABLES `catalog` WRITE;
37/*!40000 ALTER TABLE `catalog` DISABLE KEYS */;
38INSERT INTO `catalog` VALUES (1,'Catalogue Jeux vidéo');
39/*!40000 ALTER TABLE `catalog` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `ligne_panier`
44--
45
46DROP TABLE IF EXISTS `ligne_panier`;
47/*!40101 SET @saved_cs_client     = @@character_set_client */;
48/*!40101 SET character_set_client = utf8 */;
49CREATE TABLE `ligne_panier` (
50  `id_Produit` int(11) NOT NULL AUTO_INCREMENT,
51  `id_Panier` int(11) NOT NULL,
52  `quantité_ajouter` int(5) DEFAULT NULL,
53  PRIMARY KEY (`id_Produit`,`id_Panier`),
54  KEY `FK_Ligne_Panier_id_Panier` (`id_Panier`),
55  CONSTRAINT `FK_Ligne_Panier_id_Panier` FOREIGN KEY (`id_Panier`) REFERENCES `panier` (`id_Panier`),
56  CONSTRAINT `FK_Ligne_Panier_id_Produit` FOREIGN KEY (`id_Produit`) REFERENCES `produit` (`id_Produit`)
57) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `ligne_panier`
62--
63
64LOCK TABLES `ligne_panier` WRITE;
65/*!40000 ALTER TABLE `ligne_panier` DISABLE KEYS */;
66/*!40000 ALTER TABLE `ligne_panier` ENABLE KEYS */;
67UNLOCK TABLES;
68
69--
70-- Table structure for table `panier`
71--
72
73DROP TABLE IF EXISTS `panier`;
74/*!40101 SET @saved_cs_client     = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `panier` (
77  `id_Panier` int(11) NOT NULL AUTO_INCREMENT,
78  `utilisateur_id_utilisateur` int(11) NOT NULL,
79  PRIMARY KEY (`id_Panier`),
80  KEY `FK_Panier_utilisateur_id_utilisateur` (`utilisateur_id_utilisateur`),
81  CONSTRAINT `FK_Panier_utilisateur_id_utilisateur` FOREIGN KEY (`utilisateur_id_utilisateur`) REFERENCES `utilisateur` (`id_Utilisateur`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1;
83/*!40101 SET character_set_client = @saved_cs_client */;
84
85--
86-- Dumping data for table `panier`
87--
88
89LOCK TABLES `panier` WRITE;
90/*!40000 ALTER TABLE `panier` DISABLE KEYS */;
91/*!40000 ALTER TABLE `panier` ENABLE KEYS */;
92UNLOCK TABLES;
93
94--
95-- Table structure for table `photo`
96--
97
98DROP TABLE IF EXISTS `photo`;
99/*!40101 SET @saved_cs_client     = @@character_set_client */;
100/*!40101 SET character_set_client = utf8 */;
101CREATE TABLE `photo` (
102  `id_Photo` int(11) NOT NULL AUTO_INCREMENT,
103  `url_Photo` varchar(500) DEFAULT NULL,
104  `id_Produit` int(11) NOT NULL,
105  PRIMARY KEY (`id_Photo`),
106  KEY `FK_Photo_id_Produit` (`id_Produit`),
107  CONSTRAINT `FK_Photo_id_Produit` FOREIGN KEY (`id_Produit`) REFERENCES `produit` (`id_Produit`)
108) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
109/*!40101 SET character_set_client = @saved_cs_client */;
110
111--
112-- Dumping data for table `photo`
113--
114
115LOCK TABLES `photo` WRITE;
116/*!40000 ALTER TABLE `photo` DISABLE KEYS */;
117INSERT INTO `photo` VALUES (1,'https://jolstatic.fr/www/captures/1895/6/141096.jpg',1);
118/*!40000 ALTER TABLE `photo` ENABLE KEYS */;
119UNLOCK TABLES;
120
121--
122-- Table structure for table `produit`
123--
124
125DROP TABLE IF EXISTS `produit`;
126/*!40101 SET @saved_cs_client     = @@character_set_client */;
127/*!40101 SET character_set_client = utf8 */;
128CREATE TABLE `produit` (
129  `id_Produit` int(11) NOT NULL AUTO_INCREMENT,
130  `nom_Produit` varchar(100) DEFAULT NULL,
131  `description_Produit` varchar(1000) DEFAULT NULL,
132  `prix_HT_Produit` int(10) DEFAULT NULL,
133  `stock_Produit` int(10) DEFAULT NULL,
134  `id_Catalog` int(11) NOT NULL,
135  `id_TVA` int(11) NOT NULL,
136  PRIMARY KEY (`id_Produit`),
137  KEY `FK_Produit_id_Catalog` (`id_Catalog`),
138  KEY `FK_Produit_id_TVA` (`id_TVA`),
139  CONSTRAINT `FK_Produit_id_Catalog` FOREIGN KEY (`id_Catalog`) REFERENCES `catalog` (`id_Catalog`),
140  CONSTRAINT `FK_Produit_id_TVA` FOREIGN KEY (`id_TVA`) REFERENCES `tva` (`id_TVA`)
141) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Dumping data for table `produit`
146--
147
148LOCK TABLES `produit` WRITE;
149/*!40000 ALTER TABLE `produit` DISABLE KEYS */;
150INSERT INTO `produit` VALUES (1,'Red Dead Redemption 2','Lorem ipsum ce jeu est trop cool',60,83,1,1),(2,'Star Citizen','Lorem ipsum ce jeu est trop cool',30,184,1,1),(3,'Halo Reach','Lorem ipsum ce jeu est trop cool',5,800,1,1),(4,'Minecraft','Lorem ipsum ce jeu est trop cool',30,83,1,1),(5,'Pokemon MMO 3D','Lorem ipsum ce jeu est trop cool',1,0,1,1);
151/*!40000 ALTER TABLE `produit` ENABLE KEYS */;
152UNLOCK TABLES;
153
154--
155-- Table structure for table `tva`
156--
157
158DROP TABLE IF EXISTS `tva`;
159/*!40101 SET @saved_cs_client     = @@character_set_client */;
160/*!40101 SET character_set_client = utf8 */;
161CREATE TABLE `tva` (
162  `id_TVA` int(11) NOT NULL AUTO_INCREMENT,
163  `pourcentage_TVA` int(3) DEFAULT NULL,
164  PRIMARY KEY (`id_TVA`)
165) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
166/*!40101 SET character_set_client = @saved_cs_client */;
167
168--
169-- Dumping data for table `tva`
170--
171
172LOCK TABLES `tva` WRITE;
173/*!40000 ALTER TABLE `tva` DISABLE KEYS */;
174INSERT INTO `tva` VALUES (1,20);
175/*!40000 ALTER TABLE `tva` ENABLE KEYS */;
176UNLOCK TABLES;
177
178--
179-- Table structure for table `utilisateur`
180--
181
182DROP TABLE IF EXISTS `utilisateur`;
183/*!40101 SET @saved_cs_client     = @@character_set_client */;
184/*!40101 SET character_set_client = utf8 */;
185CREATE TABLE `utilisateur` (
186  `id_Utilisateur` int(11) NOT NULL AUTO_INCREMENT,
187  `nom_Utilisateur` varchar(50) DEFAULT NULL,
188  `prenom_Utilisateur` varchar(50) DEFAULT NULL,
189  `age_Utilisateur` int(3) DEFAULT NULL,
190  `panier_id_panier` int(11) DEFAULT NULL,
191  PRIMARY KEY (`id_Utilisateur`),
192  KEY `FK_Utilisateur_panier_id_panier` (`panier_id_panier`),
193  CONSTRAINT `FK_Utilisateur_panier_id_panier` FOREIGN KEY (`panier_id_panier`) REFERENCES `panier` (`id_Panier`)
194) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
195/*!40101 SET character_set_client = @saved_cs_client */;
196
197--
198-- Dumping data for table `utilisateur`
199--
200
201LOCK TABLES `utilisateur` WRITE;
202/*!40000 ALTER TABLE `utilisateur` DISABLE KEYS */;
203INSERT INTO `utilisateur` VALUES (1,'Lepen','Jean Marie',666,NULL),(2,'Zoubi','Philipon',9,NULL);
204/*!40000 ALTER TABLE `utilisateur` ENABLE KEYS */;
205UNLOCK TABLES;
206/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
207
208/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
209/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
210/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
211/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
212/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
213/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
214/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
215
216-- Dump completed on 2019-11-28 15:11:11