Guest User

Untitled

a guest
Feb 5th, 2018
753
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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.  
  22. DROP TABLE IF EXISTS `categorie`;
  23. /*!40101 SET @saved_cs_client = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE 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.  
  43. LOCK TABLES `categorie` WRITE;
  44. /*!40000 ALTER TABLE `categorie` DISABLE KEYS */;
  45. /*!40000 ALTER TABLE `categorie` ENABLE KEYS */;
  46. UNLOCK TABLES;
  47.  
  48. --
  49. -- Table structure for table `categorie_image`
  50. --
  51.  
  52. DROP TABLE IF EXISTS `categorie_image`;
  53. /*!40101 SET @saved_cs_client = @@character_set_client */;
  54. /*!40101 SET character_set_client = utf8 */;
  55. CREATE 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.  
  70. LOCK TABLES `categorie_image` WRITE;
  71. /*!40000 ALTER TABLE `categorie_image` DISABLE KEYS */;
  72. /*!40000 ALTER TABLE `categorie_image` ENABLE KEYS */;
  73. UNLOCK TABLES;
  74.  
  75. --
  76. -- Table structure for table `client`
  77. --
  78.  
  79. DROP TABLE IF EXISTS `client`;
  80. /*!40101 SET @saved_cs_client = @@character_set_client */;
  81. /*!40101 SET character_set_client = utf8 */;
  82. CREATE 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.  
  99. LOCK TABLES `client` WRITE;
  100. /*!40000 ALTER TABLE `client` DISABLE KEYS */;
  101. /*!40000 ALTER TABLE `client` ENABLE KEYS */;
  102. UNLOCK TABLES;
  103.  
  104. --
  105. -- Table structure for table `commande`
  106. --
  107.  
  108. DROP TABLE IF EXISTS `commande`;
  109. /*!40101 SET @saved_cs_client = @@character_set_client */;
  110. /*!40101 SET character_set_client = utf8 */;
  111. CREATE 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.  
  140. LOCK TABLES `commande` WRITE;
  141. /*!40000 ALTER TABLE `commande` DISABLE KEYS */;
  142. /*!40000 ALTER TABLE `commande` ENABLE KEYS */;
  143. UNLOCK TABLES;
  144.  
  145. --
  146. -- Table structure for table `commande_produit`
  147. --
  148.  
  149. DROP TABLE IF EXISTS `commande_produit`;
  150. /*!40101 SET @saved_cs_client = @@character_set_client */;
  151. /*!40101 SET character_set_client = utf8 */;
  152. CREATE 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.  
  173. LOCK TABLES `commande_produit` WRITE;
  174. /*!40000 ALTER TABLE `commande_produit` DISABLE KEYS */;
  175. /*!40000 ALTER TABLE `commande_produit` ENABLE KEYS */;
  176. UNLOCK TABLES;
  177.  
  178. --
  179. -- Table structure for table `commerce`
  180. --
  181.  
  182. DROP TABLE IF EXISTS `commerce`;
  183. /*!40101 SET @saved_cs_client = @@character_set_client */;
  184. /*!40101 SET character_set_client = utf8 */;
  185. CREATE 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.  
  209. LOCK TABLES `commerce` WRITE;
  210. /*!40000 ALTER TABLE `commerce` DISABLE KEYS */;
  211. /*!40000 ALTER TABLE `commerce` ENABLE KEYS */;
  212. UNLOCK TABLES;
  213.  
  214. --
  215. -- Table structure for table `fos_group`
  216. --
  217.  
  218. DROP TABLE IF EXISTS `fos_group`;
  219. /*!40101 SET @saved_cs_client = @@character_set_client */;
  220. /*!40101 SET character_set_client = utf8 */;
  221. CREATE 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.  
  236. LOCK TABLES `fos_group` WRITE;
  237. /*!40000 ALTER TABLE `fos_group` DISABLE KEYS */;
  238. INSERT 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 */;
  240. UNLOCK TABLES;
  241.  
  242. --
  243. -- Table structure for table `fos_user_group`
  244. --
  245.  
  246. DROP TABLE IF EXISTS `fos_user_group`;
  247. /*!40101 SET @saved_cs_client = @@character_set_client */;
  248. /*!40101 SET character_set_client = utf8 */;
  249. CREATE 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.  
  264. LOCK TABLES `fos_user_group` WRITE;
  265. /*!40000 ALTER TABLE `fos_user_group` DISABLE KEYS */;
  266. INSERT INTO `fos_user_group` VALUES (1,1),(1,2),(2,3),(3,5),(4,4);
  267. /*!40000 ALTER TABLE `fos_user_group` ENABLE KEYS */;
  268. UNLOCK TABLES;
  269.  
  270. --
  271. -- Table structure for table `ingredient`
  272. --
  273.  
  274. DROP TABLE IF EXISTS `ingredient`;
  275. /*!40101 SET @saved_cs_client = @@character_set_client */;
  276. /*!40101 SET character_set_client = utf8 */;
  277. CREATE 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.  
  296. LOCK TABLES `ingredient` WRITE;
  297. /*!40000 ALTER TABLE `ingredient` DISABLE KEYS */;
  298. /*!40000 ALTER TABLE `ingredient` ENABLE KEYS */;
  299. UNLOCK TABLES;
  300.  
  301. --
  302. -- Table structure for table `lieu_livraison`
  303. --
  304.  
  305. DROP TABLE IF EXISTS `lieu_livraison`;
  306. /*!40101 SET @saved_cs_client = @@character_set_client */;
  307. /*!40101 SET character_set_client = utf8 */;
  308. CREATE 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.  
  327. LOCK TABLES `lieu_livraison` WRITE;
  328. /*!40000 ALTER TABLE `lieu_livraison` DISABLE KEYS */;
  329. /*!40000 ALTER TABLE `lieu_livraison` ENABLE KEYS */;
  330. UNLOCK TABLES;
  331.  
  332. --
  333. -- Table structure for table `parametres`
  334. --
  335.  
  336. DROP TABLE IF EXISTS `parametres`;
  337. /*!40101 SET @saved_cs_client = @@character_set_client */;
  338. /*!40101 SET character_set_client = utf8 */;
  339. CREATE 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.  
  352. LOCK TABLES `parametres` WRITE;
  353. /*!40000 ALTER TABLE `parametres` DISABLE KEYS */;
  354. /*!40000 ALTER TABLE `parametres` ENABLE KEYS */;
  355. UNLOCK TABLES;
  356.  
  357. --
  358. -- Table structure for table `produit`
  359. --
  360.  
  361. DROP TABLE IF EXISTS `produit`;
  362. /*!40101 SET @saved_cs_client = @@character_set_client */;
  363. /*!40101 SET character_set_client = utf8 */;
  364. CREATE 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.  
  391. LOCK TABLES `produit` WRITE;
  392. /*!40000 ALTER TABLE `produit` DISABLE KEYS */;
  393. /*!40000 ALTER TABLE `produit` ENABLE KEYS */;
  394. UNLOCK TABLES;
  395.  
  396. --
  397. -- Table structure for table `produit_dimension`
  398. --
  399.  
  400. DROP TABLE IF EXISTS `produit_dimension`;
  401. /*!40101 SET @saved_cs_client = @@character_set_client */;
  402. /*!40101 SET character_set_client = utf8 */;
  403. CREATE 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.  
  422. LOCK TABLES `produit_dimension` WRITE;
  423. /*!40000 ALTER TABLE `produit_dimension` DISABLE KEYS */;
  424. /*!40000 ALTER TABLE `produit_dimension` ENABLE KEYS */;
  425. UNLOCK TABLES;
  426.  
  427. --
  428. -- Table structure for table `produit_image`
  429. --
  430.  
  431. DROP TABLE IF EXISTS `produit_image`;
  432. /*!40101 SET @saved_cs_client = @@character_set_client */;
  433. /*!40101 SET character_set_client = utf8 */;
  434. CREATE 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.  
  449. LOCK TABLES `produit_image` WRITE;
  450. /*!40000 ALTER TABLE `produit_image` DISABLE KEYS */;
  451. /*!40000 ALTER TABLE `produit_image` ENABLE KEYS */;
  452. UNLOCK TABLES;
  453.  
  454. --
  455. -- Table structure for table `produit_ingredient`
  456. --
  457.  
  458. DROP TABLE IF EXISTS `produit_ingredient`;
  459. /*!40101 SET @saved_cs_client = @@character_set_client */;
  460. /*!40101 SET character_set_client = utf8 */;
  461. CREATE 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.  
  476. LOCK TABLES `produit_ingredient` WRITE;
  477. /*!40000 ALTER TABLE `produit_ingredient` DISABLE KEYS */;
  478. /*!40000 ALTER TABLE `produit_ingredient` ENABLE KEYS */;
  479. UNLOCK TABLES;
  480.  
  481. --
  482. -- Table structure for table `produit_supplement`
  483. --
  484.  
  485. DROP TABLE IF EXISTS `produit_supplement`;
  486. /*!40101 SET @saved_cs_client = @@character_set_client */;
  487. /*!40101 SET character_set_client = utf8 */;
  488. CREATE 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.  
  503. LOCK TABLES `produit_supplement` WRITE;
  504. /*!40000 ALTER TABLE `produit_supplement` DISABLE KEYS */;
  505. /*!40000 ALTER TABLE `produit_supplement` ENABLE KEYS */;
  506. UNLOCK TABLES;
  507.  
  508. --
  509. -- Table structure for table `stripe_charge`
  510. --
  511.  
  512. DROP TABLE IF EXISTS `stripe_charge`;
  513. /*!40101 SET @saved_cs_client = @@character_set_client */;
  514. /*!40101 SET character_set_client = utf8 */;
  515. CREATE 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.  
  544. LOCK TABLES `stripe_charge` WRITE;
  545. /*!40000 ALTER TABLE `stripe_charge` DISABLE KEYS */;
  546. /*!40000 ALTER TABLE `stripe_charge` ENABLE KEYS */;
  547. UNLOCK TABLES;
  548.  
  549. --
  550. -- Table structure for table `supplement`
  551. --
  552.  
  553. DROP TABLE IF EXISTS `supplement`;
  554. /*!40101 SET @saved_cs_client = @@character_set_client */;
  555. /*!40101 SET character_set_client = utf8 */;
  556. CREATE 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.  
  575. LOCK TABLES `supplement` WRITE;
  576. /*!40000 ALTER TABLE `supplement` DISABLE KEYS */;
  577. /*!40000 ALTER TABLE `supplement` ENABLE KEYS */;
  578. UNLOCK TABLES;
  579.  
  580. --
  581. -- Table structure for table `users`
  582. --
  583.  
  584. DROP TABLE IF EXISTS `users`;
  585. /*!40101 SET @saved_cs_client = @@character_set_client */;
  586. /*!40101 SET character_set_client = utf8 */;
  587. CREATE 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.  
  618. LOCK TABLES `users` WRITE;
  619. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  620. INSERT 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 */;
  622. UNLOCK 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
RAW Paste Data