· 8 years ago · Feb 05, 2018, 01:14 PM
1-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost Database: lunch
4-- ------------------------------------------------------
5-- Server version 5.7.21-0ubuntu0.16.04.1
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 `categorie`
20--
21
22DROP TABLE IF EXISTS `categorie`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `categorie` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `parent` int(11) DEFAULT NULL,
28 `system` tinyint(1) NOT NULL DEFAULT '0',
29 `description` longtext COLLATE utf8_unicode_ci,
30 `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
31 `created_at` datetime NOT NULL,
32 `updated_at` datetime NOT NULL,
33 PRIMARY KEY (`id`),
34 KEY `IDX_497DD6343D8E604F` (`parent`),
35 CONSTRAINT `FK_497DD6343D8E604F` FOREIGN KEY (`parent`) REFERENCES `categorie` (`id`) ON DELETE SET NULL
36) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `categorie`
41--
42
43LOCK TABLES `categorie` WRITE;
44/*!40000 ALTER TABLE `categorie` DISABLE KEYS */;
45/*!40000 ALTER TABLE `categorie` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `categorie_image`
50--
51
52DROP TABLE IF EXISTS `categorie_image`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `categorie_image` (
56 `id` int(11) NOT NULL AUTO_INCREMENT,
57 `categorie_id` int(11) NOT NULL,
58 `image_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
59 `position` int(11) NOT NULL DEFAULT '0',
60 PRIMARY KEY (`id`),
61 KEY `IDX_3045E98FBCF5E72D` (`categorie_id`),
62 CONSTRAINT `FK_3045E98FBCF5E72D` FOREIGN KEY (`categorie_id`) REFERENCES `categorie` (`id`)
63) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
64/*!40101 SET character_set_client = @saved_cs_client */;
65
66--
67-- Dumping data for table `categorie_image`
68--
69
70LOCK TABLES `categorie_image` WRITE;
71/*!40000 ALTER TABLE `categorie_image` DISABLE KEYS */;
72/*!40000 ALTER TABLE `categorie_image` ENABLE KEYS */;
73UNLOCK TABLES;
74
75--
76-- Table structure for table `client`
77--
78
79DROP TABLE IF EXISTS `client`;
80/*!40101 SET @saved_cs_client = @@character_set_client */;
81/*!40101 SET character_set_client = utf8 */;
82CREATE TABLE `client` (
83 `id` int(11) NOT NULL AUTO_INCREMENT,
84 `nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
85 `source` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
86 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
87 `stripe_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
88 `user` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
89 `created_at` datetime NOT NULL,
90 `updated_at` datetime NOT NULL,
91 PRIMARY KEY (`id`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `client`
97--
98
99LOCK TABLES `client` WRITE;
100/*!40000 ALTER TABLE `client` DISABLE KEYS */;
101/*!40000 ALTER TABLE `client` ENABLE KEYS */;
102UNLOCK TABLES;
103
104--
105-- Table structure for table `commande`
106--
107
108DROP TABLE IF EXISTS `commande`;
109/*!40101 SET @saved_cs_client = @@character_set_client */;
110/*!40101 SET character_set_client = utf8 */;
111CREATE TABLE `commande` (
112 `id` int(11) NOT NULL AUTO_INCREMENT,
113 `commerce_id` int(11) NOT NULL,
114 `lieu_livraison_id` int(11) DEFAULT NULL,
115 `user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
116 `commerce_nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
117 `valide` tinyint(1) NOT NULL DEFAULT '0',
118 `cloture` tinyint(1) NOT NULL DEFAULT '0',
119 `paye` tinyint(1) NOT NULL DEFAULT '0',
120 `livre` tinyint(1) NOT NULL DEFAULT '0',
121 `date_livraison` datetime DEFAULT NULL,
122 `livraison_remarque` longtext COLLATE utf8_unicode_ci,
123 `valide_remarque` longtext COLLATE utf8_unicode_ci,
124 `created` datetime NOT NULL,
125 `updated` datetime NOT NULL,
126 `created_at` datetime NOT NULL,
127 `updated_at` datetime NOT NULL,
128 PRIMARY KEY (`id`),
129 KEY `IDX_6EEAA67DB09114B7` (`commerce_id`),
130 KEY `IDX_6EEAA67DF26B4F5` (`lieu_livraison_id`),
131 CONSTRAINT `FK_6EEAA67DB09114B7` FOREIGN KEY (`commerce_id`) REFERENCES `commerce` (`id`),
132 CONSTRAINT `FK_6EEAA67DF26B4F5` FOREIGN KEY (`lieu_livraison_id`) REFERENCES `lieu_livraison` (`id`) ON DELETE SET NULL
133) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
134/*!40101 SET character_set_client = @saved_cs_client */;
135
136--
137-- Dumping data for table `commande`
138--
139
140LOCK TABLES `commande` WRITE;
141/*!40000 ALTER TABLE `commande` DISABLE KEYS */;
142/*!40000 ALTER TABLE `commande` ENABLE KEYS */;
143UNLOCK TABLES;
144
145--
146-- Table structure for table `commande_produit`
147--
148
149DROP TABLE IF EXISTS `commande_produit`;
150/*!40101 SET @saved_cs_client = @@character_set_client */;
151/*!40101 SET character_set_client = utf8 */;
152CREATE TABLE `commande_produit` (
153 `id` int(11) NOT NULL AUTO_INCREMENT,
154 `produit_id` int(11) DEFAULT NULL,
155 `commande_id` int(11) NOT NULL,
156 `remarque` longtext COLLATE utf8_unicode_ci,
157 `produit_nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
158 `quantite` int(11) NOT NULL,
159 `prix_htva` decimal(10,2) DEFAULT NULL,
160 `tva_applique` decimal(10,2) DEFAULT NULL,
161 PRIMARY KEY (`id`),
162 KEY `IDX_DF1E9E87F347EFB` (`produit_id`),
163 KEY `IDX_DF1E9E8782EA2E54` (`commande_id`),
164 CONSTRAINT `FK_DF1E9E8782EA2E54` FOREIGN KEY (`commande_id`) REFERENCES `commande` (`id`),
165 CONSTRAINT `FK_DF1E9E87F347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`)
166) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
167/*!40101 SET character_set_client = @saved_cs_client */;
168
169--
170-- Dumping data for table `commande_produit`
171--
172
173LOCK TABLES `commande_produit` WRITE;
174/*!40000 ALTER TABLE `commande_produit` DISABLE KEYS */;
175/*!40000 ALTER TABLE `commande_produit` ENABLE KEYS */;
176UNLOCK TABLES;
177
178--
179-- Table structure for table `commerce`
180--
181
182DROP TABLE IF EXISTS `commerce`;
183/*!40101 SET @saved_cs_client = @@character_set_client */;
184/*!40101 SET character_set_client = utf8 */;
185CREATE TABLE `commerce` (
186 `id` int(11) NOT NULL AUTO_INCREMENT,
187 `bottin_id` int(11) DEFAULT NULL,
188 `indisponible` tinyint(1) NOT NULL DEFAULT '0',
189 `tva_applicable` decimal(10,2) DEFAULT NULL,
190 `numero_tva` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
191 `sms_numero` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
192 `email_commande` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
193 `iban` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
194 `livrasion_cout` decimal(10,2) DEFAULT NULL,
195 `user` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
196 `image_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
197 `image_size` int(11) DEFAULT NULL,
198 `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
199 `created_at` datetime NOT NULL,
200 `updated_at` datetime NOT NULL,
201 PRIMARY KEY (`id`)
202) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
203/*!40101 SET character_set_client = @saved_cs_client */;
204
205--
206-- Dumping data for table `commerce`
207--
208
209LOCK TABLES `commerce` WRITE;
210/*!40000 ALTER TABLE `commerce` DISABLE KEYS */;
211/*!40000 ALTER TABLE `commerce` ENABLE KEYS */;
212UNLOCK TABLES;
213
214--
215-- Table structure for table `fos_group`
216--
217
218DROP TABLE IF EXISTS `fos_group`;
219/*!40101 SET @saved_cs_client = @@character_set_client */;
220/*!40101 SET character_set_client = utf8 */;
221CREATE TABLE `fos_group` (
222 `id` int(11) NOT NULL AUTO_INCREMENT,
223 `name` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
224 `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
225 `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
226 `description` longtext COLLATE utf8_unicode_ci,
227 PRIMARY KEY (`id`),
228 UNIQUE KEY `UNIQ_4B019DDB5E237E06` (`name`)
229) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
230/*!40101 SET character_set_client = @saved_cs_client */;
231
232--
233-- Dumping data for table `fos_group`
234--
235
236LOCK TABLES `fos_group` WRITE;
237/*!40000 ALTER TABLE `fos_group` DISABLE KEYS */;
238INSERT INTO `fos_group` VALUES (1,'ACMARCHE_ADMIN','a:1:{i:0;s:19:\"ROLE_ACMARCHE_ADMIN\";}','Administrateur des utilisateurs','Peut gérer les utilisateurs des applications'),(2,'LUNCH_ADMIN','a:5:{i:0;s:16:\"ROLE_LUNCH_ADMIN\";i:1;s:10:\"ROLE_LUNCH\";i:2;s:19:\"ROLE_LUNCH_COMMERCE\";i:3;s:22:\"ROLE_LUNCH_LOGISTICIEN\";i:4;s:17:\"ROLE_LUNCH_CLIENT\";}','Administrateur de l\'applis lunch','Dispose de tous les droits'),(3,'LUNCH_COMMERCE','a:3:{i:0;s:19:\"ROLE_LUNCH_COMMERCE\";i:1;s:17:\"ROLE_LUNCH_CLIENT\";i:2;s:10:\"ROLE_LUNCH\";}','Accès commerçant lunch','Dispose de tous les droits sur son commerce'),(4,'LUNCH_CLIENT','a:2:{i:0;s:17:\"ROLE_LUNCH_CLIENT\";i:1;s:10:\"ROLE_LUNCH\";}','Accès commerçant lunch','Peut commander des paniers'),(5,'LUNCH_LOGISTICIEN','a:3:{i:0;s:22:\"ROLE_LUNCH_LOGISTICIEN\";i:1;s:17:\"ROLE_LUNCH_CLIENT\";i:2;s:10:\"ROLE_LUNCH\";}','Accès logisticien lunch','Consulte les commandes finalisées');
239/*!40000 ALTER TABLE `fos_group` ENABLE KEYS */;
240UNLOCK TABLES;
241
242--
243-- Table structure for table `fos_user_group`
244--
245
246DROP TABLE IF EXISTS `fos_user_group`;
247/*!40101 SET @saved_cs_client = @@character_set_client */;
248/*!40101 SET character_set_client = utf8 */;
249CREATE TABLE `fos_user_group` (
250 `user_id` int(11) NOT NULL,
251 `group_id` int(11) NOT NULL,
252 PRIMARY KEY (`user_id`,`group_id`),
253 KEY `IDX_583D1F3EA76ED395` (`user_id`),
254 KEY `IDX_583D1F3EFE54D947` (`group_id`),
255 CONSTRAINT `FK_583D1F3EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
256 CONSTRAINT `FK_583D1F3EFE54D947` FOREIGN KEY (`group_id`) REFERENCES `fos_group` (`id`) ON DELETE CASCADE
257) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
258/*!40101 SET character_set_client = @saved_cs_client */;
259
260--
261-- Dumping data for table `fos_user_group`
262--
263
264LOCK TABLES `fos_user_group` WRITE;
265/*!40000 ALTER TABLE `fos_user_group` DISABLE KEYS */;
266INSERT INTO `fos_user_group` VALUES (1,1),(1,2),(2,3),(3,5),(4,4);
267/*!40000 ALTER TABLE `fos_user_group` ENABLE KEYS */;
268UNLOCK TABLES;
269
270--
271-- Table structure for table `ingredient`
272--
273
274DROP TABLE IF EXISTS `ingredient`;
275/*!40101 SET @saved_cs_client = @@character_set_client */;
276/*!40101 SET character_set_client = utf8 */;
277CREATE TABLE `ingredient` (
278 `id` int(11) NOT NULL AUTO_INCREMENT,
279 `commerce_id` int(11) NOT NULL,
280 `indisponible` tinyint(1) NOT NULL DEFAULT '0',
281 `rupture_stock` tinyint(1) NOT NULL DEFAULT '0',
282 `quantite_stock` int(11) NOT NULL,
283 `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
284 `created_at` datetime NOT NULL,
285 `updated_at` datetime NOT NULL,
286 PRIMARY KEY (`id`),
287 KEY `IDX_6BAF7870B09114B7` (`commerce_id`),
288 CONSTRAINT `FK_6BAF7870B09114B7` FOREIGN KEY (`commerce_id`) REFERENCES `commerce` (`id`)
289) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
290/*!40101 SET character_set_client = @saved_cs_client */;
291
292--
293-- Dumping data for table `ingredient`
294--
295
296LOCK TABLES `ingredient` WRITE;
297/*!40000 ALTER TABLE `ingredient` DISABLE KEYS */;
298/*!40000 ALTER TABLE `ingredient` ENABLE KEYS */;
299UNLOCK TABLES;
300
301--
302-- Table structure for table `lieu_livraison`
303--
304
305DROP TABLE IF EXISTS `lieu_livraison`;
306/*!40101 SET @saved_cs_client = @@character_set_client */;
307/*!40101 SET character_set_client = utf8 */;
308CREATE TABLE `lieu_livraison` (
309 `id` int(11) NOT NULL AUTO_INCREMENT,
310 `commerce_id` int(11) DEFAULT NULL,
311 `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
312 `rue` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
313 `numero` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
314 `code_postal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
315 `localite` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
316 `description` longtext COLLATE utf8_unicode_ci,
317 PRIMARY KEY (`id`),
318 KEY `IDX_C96B04A8B09114B7` (`commerce_id`),
319 CONSTRAINT `FK_C96B04A8B09114B7` FOREIGN KEY (`commerce_id`) REFERENCES `commerce` (`id`)
320) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
321/*!40101 SET character_set_client = @saved_cs_client */;
322
323--
324-- Dumping data for table `lieu_livraison`
325--
326
327LOCK TABLES `lieu_livraison` WRITE;
328/*!40000 ALTER TABLE `lieu_livraison` DISABLE KEYS */;
329/*!40000 ALTER TABLE `lieu_livraison` ENABLE KEYS */;
330UNLOCK TABLES;
331
332--
333-- Table structure for table `parametres`
334--
335
336DROP TABLE IF EXISTS `parametres`;
337/*!40101 SET @saved_cs_client = @@character_set_client */;
338/*!40101 SET character_set_client = utf8 */;
339CREATE TABLE `parametres` (
340 `id` int(11) NOT NULL AUTO_INCREMENT,
341 `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
342 `valeur` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
343 PRIMARY KEY (`id`),
344 UNIQUE KEY `UNIQ_1A79799D6C6E55B5` (`nom`)
345) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
346/*!40101 SET character_set_client = @saved_cs_client */;
347
348--
349-- Dumping data for table `parametres`
350--
351
352LOCK TABLES `parametres` WRITE;
353/*!40000 ALTER TABLE `parametres` DISABLE KEYS */;
354/*!40000 ALTER TABLE `parametres` ENABLE KEYS */;
355UNLOCK TABLES;
356
357--
358-- Table structure for table `produit`
359--
360
361DROP TABLE IF EXISTS `produit`;
362/*!40101 SET @saved_cs_client = @@character_set_client */;
363/*!40101 SET character_set_client = utf8 */;
364CREATE TABLE `produit` (
365 `id` int(11) NOT NULL AUTO_INCREMENT,
366 `categorie_id` int(11) DEFAULT NULL,
367 `commerce_id` int(11) NOT NULL,
368 `reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
369 `description` longtext COLLATE utf8_unicode_ci,
370 `indisponible` tinyint(1) NOT NULL DEFAULT '0',
371 `is_food` tinyint(1) NOT NULL DEFAULT '0',
372 `quantite_stock` int(11) NOT NULL,
373 `prix_htva` decimal(10,2) NOT NULL,
374 `prix_promo_htva` decimal(10,2) DEFAULT NULL,
375 `tva_applicable` decimal(10,2) DEFAULT NULL,
376 `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
377 `created_at` datetime NOT NULL,
378 `updated_at` datetime NOT NULL,
379 PRIMARY KEY (`id`),
380 KEY `IDX_29A5EC27BCF5E72D` (`categorie_id`),
381 KEY `IDX_29A5EC27B09114B7` (`commerce_id`),
382 CONSTRAINT `FK_29A5EC27B09114B7` FOREIGN KEY (`commerce_id`) REFERENCES `commerce` (`id`),
383 CONSTRAINT `FK_29A5EC27BCF5E72D` FOREIGN KEY (`categorie_id`) REFERENCES `categorie` (`id`) ON DELETE SET NULL
384) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
385/*!40101 SET character_set_client = @saved_cs_client */;
386
387--
388-- Dumping data for table `produit`
389--
390
391LOCK TABLES `produit` WRITE;
392/*!40000 ALTER TABLE `produit` DISABLE KEYS */;
393/*!40000 ALTER TABLE `produit` ENABLE KEYS */;
394UNLOCK TABLES;
395
396--
397-- Table structure for table `produit_dimension`
398--
399
400DROP TABLE IF EXISTS `produit_dimension`;
401/*!40101 SET @saved_cs_client = @@character_set_client */;
402/*!40101 SET character_set_client = utf8 */;
403CREATE TABLE `produit_dimension` (
404 `id` int(11) NOT NULL AUTO_INCREMENT,
405 `produit_id` int(11) NOT NULL,
406 `hauteur` int(11) DEFAULT NULL,
407 `largeur` int(11) DEFAULT NULL,
408 `longueur` int(11) DEFAULT NULL,
409 `poids` int(11) DEFAULT NULL,
410 `poids_unite` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
411 `remarque` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
412 PRIMARY KEY (`id`),
413 UNIQUE KEY `UNIQ_4E0C9F70F347EFB` (`produit_id`),
414 CONSTRAINT `FK_4E0C9F70F347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`)
415) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
416/*!40101 SET character_set_client = @saved_cs_client */;
417
418--
419-- Dumping data for table `produit_dimension`
420--
421
422LOCK TABLES `produit_dimension` WRITE;
423/*!40000 ALTER TABLE `produit_dimension` DISABLE KEYS */;
424/*!40000 ALTER TABLE `produit_dimension` ENABLE KEYS */;
425UNLOCK TABLES;
426
427--
428-- Table structure for table `produit_image`
429--
430
431DROP TABLE IF EXISTS `produit_image`;
432/*!40101 SET @saved_cs_client = @@character_set_client */;
433/*!40101 SET character_set_client = utf8 */;
434CREATE TABLE `produit_image` (
435 `id` int(11) NOT NULL AUTO_INCREMENT,
436 `produit_id` int(11) NOT NULL,
437 `image_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
438 `position` int(11) NOT NULL DEFAULT '0',
439 PRIMARY KEY (`id`),
440 KEY `IDX_F5A163CBF347EFB` (`produit_id`),
441 CONSTRAINT `FK_F5A163CBF347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`)
442) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
443/*!40101 SET character_set_client = @saved_cs_client */;
444
445--
446-- Dumping data for table `produit_image`
447--
448
449LOCK TABLES `produit_image` WRITE;
450/*!40000 ALTER TABLE `produit_image` DISABLE KEYS */;
451/*!40000 ALTER TABLE `produit_image` ENABLE KEYS */;
452UNLOCK TABLES;
453
454--
455-- Table structure for table `produit_ingredient`
456--
457
458DROP TABLE IF EXISTS `produit_ingredient`;
459/*!40101 SET @saved_cs_client = @@character_set_client */;
460/*!40101 SET character_set_client = utf8 */;
461CREATE TABLE `produit_ingredient` (
462 `produit_id` int(11) NOT NULL,
463 `ingredient_id` int(11) NOT NULL,
464 PRIMARY KEY (`produit_id`,`ingredient_id`),
465 KEY `IDX_C297417DF347EFB` (`produit_id`),
466 KEY `IDX_C297417D933FE08C` (`ingredient_id`),
467 CONSTRAINT `FK_C297417D933FE08C` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredient` (`id`) ON DELETE CASCADE,
468 CONSTRAINT `FK_C297417DF347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`) ON DELETE CASCADE
469) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
470/*!40101 SET character_set_client = @saved_cs_client */;
471
472--
473-- Dumping data for table `produit_ingredient`
474--
475
476LOCK TABLES `produit_ingredient` WRITE;
477/*!40000 ALTER TABLE `produit_ingredient` DISABLE KEYS */;
478/*!40000 ALTER TABLE `produit_ingredient` ENABLE KEYS */;
479UNLOCK TABLES;
480
481--
482-- Table structure for table `produit_supplement`
483--
484
485DROP TABLE IF EXISTS `produit_supplement`;
486/*!40101 SET @saved_cs_client = @@character_set_client */;
487/*!40101 SET character_set_client = utf8 */;
488CREATE TABLE `produit_supplement` (
489 `produit_id` int(11) NOT NULL,
490 `supplement_id` int(11) NOT NULL,
491 PRIMARY KEY (`produit_id`,`supplement_id`),
492 KEY `IDX_A8624AC4F347EFB` (`produit_id`),
493 KEY `IDX_A8624AC47793FA21` (`supplement_id`),
494 CONSTRAINT `FK_A8624AC47793FA21` FOREIGN KEY (`supplement_id`) REFERENCES `supplement` (`id`) ON DELETE CASCADE,
495 CONSTRAINT `FK_A8624AC4F347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`) ON DELETE CASCADE
496) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
497/*!40101 SET character_set_client = @saved_cs_client */;
498
499--
500-- Dumping data for table `produit_supplement`
501--
502
503LOCK TABLES `produit_supplement` WRITE;
504/*!40000 ALTER TABLE `produit_supplement` DISABLE KEYS */;
505/*!40000 ALTER TABLE `produit_supplement` ENABLE KEYS */;
506UNLOCK TABLES;
507
508--
509-- Table structure for table `stripe_charge`
510--
511
512DROP TABLE IF EXISTS `stripe_charge`;
513/*!40101 SET @saved_cs_client = @@character_set_client */;
514/*!40101 SET character_set_client = utf8 */;
515CREATE TABLE `stripe_charge` (
516 `id` int(11) NOT NULL AUTO_INCREMENT,
517 `commande_id` int(11) NOT NULL,
518 `id_charge` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
519 `object` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
520 `amount` int(11) NOT NULL,
521 `amount_refunded` int(11) NOT NULL,
522 `balance_transaction` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
523 `currency` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
524 `created_stripe` int(11) NOT NULL,
525 `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
526 `failure_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
527 `failure_message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
528 `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
529 `paid` tinyint(1) NOT NULL DEFAULT '0',
530 `refunded` tinyint(1) NOT NULL DEFAULT '0',
531 `user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
532 `created_at` datetime NOT NULL,
533 `updated_at` datetime NOT NULL,
534 PRIMARY KEY (`id`),
535 UNIQUE KEY `UNIQ_FD26D90882EA2E54` (`commande_id`),
536 CONSTRAINT `FK_FD26D90882EA2E54` FOREIGN KEY (`commande_id`) REFERENCES `commande` (`id`)
537) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
538/*!40101 SET character_set_client = @saved_cs_client */;
539
540--
541-- Dumping data for table `stripe_charge`
542--
543
544LOCK TABLES `stripe_charge` WRITE;
545/*!40000 ALTER TABLE `stripe_charge` DISABLE KEYS */;
546/*!40000 ALTER TABLE `stripe_charge` ENABLE KEYS */;
547UNLOCK TABLES;
548
549--
550-- Table structure for table `supplement`
551--
552
553DROP TABLE IF EXISTS `supplement`;
554/*!40101 SET @saved_cs_client = @@character_set_client */;
555/*!40101 SET character_set_client = utf8 */;
556CREATE TABLE `supplement` (
557 `id` int(11) NOT NULL AUTO_INCREMENT,
558 `commerce_id` int(11) NOT NULL,
559 `prix` decimal(10,2) NOT NULL,
560 `indisponible` tinyint(1) NOT NULL DEFAULT '0',
561 `rupture_stock` tinyint(1) NOT NULL DEFAULT '0',
562 `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
563 `created_at` datetime NOT NULL,
564 `updated_at` datetime NOT NULL,
565 PRIMARY KEY (`id`),
566 KEY `IDX_15A73C9B09114B7` (`commerce_id`),
567 CONSTRAINT `FK_15A73C9B09114B7` FOREIGN KEY (`commerce_id`) REFERENCES `commerce` (`id`)
568) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
569/*!40101 SET character_set_client = @saved_cs_client */;
570
571--
572-- Dumping data for table `supplement`
573--
574
575LOCK TABLES `supplement` WRITE;
576/*!40000 ALTER TABLE `supplement` DISABLE KEYS */;
577/*!40000 ALTER TABLE `supplement` ENABLE KEYS */;
578UNLOCK TABLES;
579
580--
581-- Table structure for table `users`
582--
583
584DROP TABLE IF EXISTS `users`;
585/*!40101 SET @saved_cs_client = @@character_set_client */;
586/*!40101 SET character_set_client = utf8 */;
587CREATE TABLE `users` (
588 `id` int(11) NOT NULL AUTO_INCREMENT,
589 `username` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
590 `username_canonical` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
591 `email` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
592 `email_canonical` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
593 `enabled` tinyint(1) NOT NULL,
594 `salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
595 `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
596 `last_login` datetime DEFAULT NULL,
597 `confirmation_token` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
598 `password_requested_at` datetime DEFAULT NULL,
599 `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
600 `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
601 `prenom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
602 `rue` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
603 `code_postal` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
604 `localite` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
605 `telephone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
606 `sms_numero` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
607 PRIMARY KEY (`id`),
608 UNIQUE KEY `UNIQ_1483A5E992FC23A8` (`username_canonical`),
609 UNIQUE KEY `UNIQ_1483A5E9A0D96FBF` (`email_canonical`),
610 UNIQUE KEY `UNIQ_1483A5E9C05FB297` (`confirmation_token`)
611) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
612/*!40101 SET character_set_client = @saved_cs_client */;
613
614--
615-- Dumping data for table `users`
616--
617
618LOCK TABLES `users` WRITE;
619/*!40000 ALTER TABLE `users` DISABLE KEYS */;
620INSERT INTO `users` VALUES (1,'admin','admin','admin@domain.be','admin@domain.be',1,NULL,'$2y$13$Hs18vZIO4V9Mg9kRYKuIneI9.eEHeHbBd/z413qyUMj9q/d1GuBtq',NULL,NULL,NULL,'a:0:{}','admin','admin',NULL,NULL,NULL,NULL,NULL),(2,'porte','porte','porte@domain.be','porte@domain.be',1,NULL,'$2y$13$Tic06I8ZLrEeAnyIbI3gfeMYQKzAlcWfPvAWiRWtGnc.QlHIgYGXi',NULL,NULL,NULL,'a:0:{}','Bonne','Porte',NULL,NULL,NULL,NULL,'32476662615'),(3,'logisticien','logisticien','logisticien@domain.be','logisticien@domain.be',1,NULL,'$2y$13$3zOrUkUqaauColxWU7tH5.3KomhqQBi3Kq0en2pizneg0y56d1dV2',NULL,NULL,NULL,'a:0:{}','Criquielion','Claude',NULL,NULL,NULL,NULL,'32476662615'),(4,'homer','homer','homer@domain.be','homer@domain.be',1,NULL,'$2y$13$hlGUz6BxFNFzvm8y6PHs1Oiel9aWiRpr/t5IvuogS.ldepgeYZA4G',NULL,NULL,NULL,'a:0:{}','Simpson','Homer',NULL,NULL,NULL,NULL,'32476662615');
621/*!40000 ALTER TABLE `users` ENABLE KEYS */;
622UNLOCK TABLES;
623/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
624
625/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
626/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
627/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
628/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
629/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
630/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
631/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
632
633-- Dump completed on 2018-02-05 9:50:20