Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
- --
- -- Host: localhost Database: lunch
- -- ------------------------------------------------------
- -- Server version 5.7.21-0ubuntu0.16.04.1
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `categorie`
- --
- DROP TABLE IF EXISTS `categorie`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `categorie` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `parent` int(11) DEFAULT NULL,
- `system` tinyint(1) NOT NULL DEFAULT '0',
- `description` longtext COLLATE utf8_unicode_ci,
- `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `created_at` datetime NOT NULL,
- `updated_at` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `IDX_497DD6343D8E604F` (`parent`),
- CONSTRAINT `FK_497DD6343D8E604F` FOREIGN KEY (`parent`) REFERENCES `categorie` (`id`) ON DELETE SET NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `categorie`
- --
- LOCK TABLES `categorie` WRITE;
- /*!40000 ALTER TABLE `categorie` DISABLE KEYS */;
- /*!40000 ALTER TABLE `categorie` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `categorie_image`
- --
- DROP TABLE IF EXISTS `categorie_image`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `categorie_image` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `categorie_id` int(11) NOT NULL,
- `image_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `position` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `IDX_3045E98FBCF5E72D` (`categorie_id`),
- CONSTRAINT `FK_3045E98FBCF5E72D` FOREIGN KEY (`categorie_id`) REFERENCES `categorie` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `categorie_image`
- --
- LOCK TABLES `categorie_image` WRITE;
- /*!40000 ALTER TABLE `categorie_image` DISABLE KEYS */;
- /*!40000 ALTER TABLE `categorie_image` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `client`
- --
- DROP TABLE IF EXISTS `client`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `client` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `source` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `stripe_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `user` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `created_at` datetime NOT NULL,
- `updated_at` datetime NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `client`
- --
- LOCK TABLES `client` WRITE;
- /*!40000 ALTER TABLE `client` DISABLE KEYS */;
- /*!40000 ALTER TABLE `client` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `commande`
- --
- DROP TABLE IF EXISTS `commande`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `commande` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `commerce_id` int(11) NOT NULL,
- `lieu_livraison_id` int(11) DEFAULT NULL,
- `user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `commerce_nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `valide` tinyint(1) NOT NULL DEFAULT '0',
- `cloture` tinyint(1) NOT NULL DEFAULT '0',
- `paye` tinyint(1) NOT NULL DEFAULT '0',
- `livre` tinyint(1) NOT NULL DEFAULT '0',
- `date_livraison` datetime DEFAULT NULL,
- `livraison_remarque` longtext COLLATE utf8_unicode_ci,
- `valide_remarque` longtext COLLATE utf8_unicode_ci,
- `created` datetime NOT NULL,
- `updated` datetime NOT NULL,
- `created_at` datetime NOT NULL,
- `updated_at` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `IDX_6EEAA67DB09114B7` (`commerce_id`),
- KEY `IDX_6EEAA67DF26B4F5` (`lieu_livraison_id`),
- CONSTRAINT `FK_6EEAA67DB09114B7` FOREIGN KEY (`commerce_id`) REFERENCES `commerce` (`id`),
- CONSTRAINT `FK_6EEAA67DF26B4F5` FOREIGN KEY (`lieu_livraison_id`) REFERENCES `lieu_livraison` (`id`) ON DELETE SET NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `commande`
- --
- LOCK TABLES `commande` WRITE;
- /*!40000 ALTER TABLE `commande` DISABLE KEYS */;
- /*!40000 ALTER TABLE `commande` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `commande_produit`
- --
- DROP TABLE IF EXISTS `commande_produit`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `commande_produit` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `produit_id` int(11) DEFAULT NULL,
- `commande_id` int(11) NOT NULL,
- `remarque` longtext COLLATE utf8_unicode_ci,
- `produit_nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `quantite` int(11) NOT NULL,
- `prix_htva` decimal(10,2) DEFAULT NULL,
- `tva_applique` decimal(10,2) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `IDX_DF1E9E87F347EFB` (`produit_id`),
- KEY `IDX_DF1E9E8782EA2E54` (`commande_id`),
- CONSTRAINT `FK_DF1E9E8782EA2E54` FOREIGN KEY (`commande_id`) REFERENCES `commande` (`id`),
- CONSTRAINT `FK_DF1E9E87F347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `commande_produit`
- --
- LOCK TABLES `commande_produit` WRITE;
- /*!40000 ALTER TABLE `commande_produit` DISABLE KEYS */;
- /*!40000 ALTER TABLE `commande_produit` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `commerce`
- --
- DROP TABLE IF EXISTS `commerce`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `commerce` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `bottin_id` int(11) DEFAULT NULL,
- `indisponible` tinyint(1) NOT NULL DEFAULT '0',
- `tva_applicable` decimal(10,2) DEFAULT NULL,
- `numero_tva` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `sms_numero` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
- `email_commande` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
- `iban` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `livrasion_cout` decimal(10,2) DEFAULT NULL,
- `user` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `image_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `image_size` int(11) DEFAULT NULL,
- `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `created_at` datetime NOT NULL,
- `updated_at` datetime NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `commerce`
- --
- LOCK TABLES `commerce` WRITE;
- /*!40000 ALTER TABLE `commerce` DISABLE KEYS */;
- /*!40000 ALTER TABLE `commerce` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `fos_group`
- --
- DROP TABLE IF EXISTS `fos_group`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `fos_group` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
- `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
- `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `description` longtext COLLATE utf8_unicode_ci,
- PRIMARY KEY (`id`),
- UNIQUE KEY `UNIQ_4B019DDB5E237E06` (`name`)
- ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `fos_group`
- --
- LOCK TABLES `fos_group` WRITE;
- /*!40000 ALTER TABLE `fos_group` DISABLE KEYS */;
- 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');
- /*!40000 ALTER TABLE `fos_group` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `fos_user_group`
- --
- DROP TABLE IF EXISTS `fos_user_group`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `fos_user_group` (
- `user_id` int(11) NOT NULL,
- `group_id` int(11) NOT NULL,
- PRIMARY KEY (`user_id`,`group_id`),
- KEY `IDX_583D1F3EA76ED395` (`user_id`),
- KEY `IDX_583D1F3EFE54D947` (`group_id`),
- CONSTRAINT `FK_583D1F3EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
- CONSTRAINT `FK_583D1F3EFE54D947` FOREIGN KEY (`group_id`) REFERENCES `fos_group` (`id`) ON DELETE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `fos_user_group`
- --
- LOCK TABLES `fos_user_group` WRITE;
- /*!40000 ALTER TABLE `fos_user_group` DISABLE KEYS */;
- INSERT INTO `fos_user_group` VALUES (1,1),(1,2),(2,3),(3,5),(4,4);
- /*!40000 ALTER TABLE `fos_user_group` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `ingredient`
- --
- DROP TABLE IF EXISTS `ingredient`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `ingredient` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `commerce_id` int(11) NOT NULL,
- `indisponible` tinyint(1) NOT NULL DEFAULT '0',
- `rupture_stock` tinyint(1) NOT NULL DEFAULT '0',
- `quantite_stock` int(11) NOT NULL,
- `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `created_at` datetime NOT NULL,
- `updated_at` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `IDX_6BAF7870B09114B7` (`commerce_id`),
- CONSTRAINT `FK_6BAF7870B09114B7` FOREIGN KEY (`commerce_id`) REFERENCES `commerce` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `ingredient`
- --
- LOCK TABLES `ingredient` WRITE;
- /*!40000 ALTER TABLE `ingredient` DISABLE KEYS */;
- /*!40000 ALTER TABLE `ingredient` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `lieu_livraison`
- --
- DROP TABLE IF EXISTS `lieu_livraison`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `lieu_livraison` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `commerce_id` int(11) DEFAULT NULL,
- `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `rue` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `numero` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `code_postal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `localite` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `description` longtext COLLATE utf8_unicode_ci,
- PRIMARY KEY (`id`),
- KEY `IDX_C96B04A8B09114B7` (`commerce_id`),
- CONSTRAINT `FK_C96B04A8B09114B7` FOREIGN KEY (`commerce_id`) REFERENCES `commerce` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `lieu_livraison`
- --
- LOCK TABLES `lieu_livraison` WRITE;
- /*!40000 ALTER TABLE `lieu_livraison` DISABLE KEYS */;
- /*!40000 ALTER TABLE `lieu_livraison` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `parametres`
- --
- DROP TABLE IF EXISTS `parametres`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `parametres` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `valeur` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `UNIQ_1A79799D6C6E55B5` (`nom`)
- ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `parametres`
- --
- LOCK TABLES `parametres` WRITE;
- /*!40000 ALTER TABLE `parametres` DISABLE KEYS */;
- /*!40000 ALTER TABLE `parametres` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `produit`
- --
- DROP TABLE IF EXISTS `produit`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `produit` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `categorie_id` int(11) DEFAULT NULL,
- `commerce_id` int(11) NOT NULL,
- `reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `description` longtext COLLATE utf8_unicode_ci,
- `indisponible` tinyint(1) NOT NULL DEFAULT '0',
- `is_food` tinyint(1) NOT NULL DEFAULT '0',
- `quantite_stock` int(11) NOT NULL,
- `prix_htva` decimal(10,2) NOT NULL,
- `prix_promo_htva` decimal(10,2) DEFAULT NULL,
- `tva_applicable` decimal(10,2) DEFAULT NULL,
- `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `created_at` datetime NOT NULL,
- `updated_at` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `IDX_29A5EC27BCF5E72D` (`categorie_id`),
- KEY `IDX_29A5EC27B09114B7` (`commerce_id`),
- CONSTRAINT `FK_29A5EC27B09114B7` FOREIGN KEY (`commerce_id`) REFERENCES `commerce` (`id`),
- CONSTRAINT `FK_29A5EC27BCF5E72D` FOREIGN KEY (`categorie_id`) REFERENCES `categorie` (`id`) ON DELETE SET NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `produit`
- --
- LOCK TABLES `produit` WRITE;
- /*!40000 ALTER TABLE `produit` DISABLE KEYS */;
- /*!40000 ALTER TABLE `produit` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `produit_dimension`
- --
- DROP TABLE IF EXISTS `produit_dimension`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `produit_dimension` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `produit_id` int(11) NOT NULL,
- `hauteur` int(11) DEFAULT NULL,
- `largeur` int(11) DEFAULT NULL,
- `longueur` int(11) DEFAULT NULL,
- `poids` int(11) DEFAULT NULL,
- `poids_unite` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `remarque` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `UNIQ_4E0C9F70F347EFB` (`produit_id`),
- CONSTRAINT `FK_4E0C9F70F347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `produit_dimension`
- --
- LOCK TABLES `produit_dimension` WRITE;
- /*!40000 ALTER TABLE `produit_dimension` DISABLE KEYS */;
- /*!40000 ALTER TABLE `produit_dimension` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `produit_image`
- --
- DROP TABLE IF EXISTS `produit_image`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `produit_image` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `produit_id` int(11) NOT NULL,
- `image_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `position` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- KEY `IDX_F5A163CBF347EFB` (`produit_id`),
- CONSTRAINT `FK_F5A163CBF347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `produit_image`
- --
- LOCK TABLES `produit_image` WRITE;
- /*!40000 ALTER TABLE `produit_image` DISABLE KEYS */;
- /*!40000 ALTER TABLE `produit_image` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `produit_ingredient`
- --
- DROP TABLE IF EXISTS `produit_ingredient`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `produit_ingredient` (
- `produit_id` int(11) NOT NULL,
- `ingredient_id` int(11) NOT NULL,
- PRIMARY KEY (`produit_id`,`ingredient_id`),
- KEY `IDX_C297417DF347EFB` (`produit_id`),
- KEY `IDX_C297417D933FE08C` (`ingredient_id`),
- CONSTRAINT `FK_C297417D933FE08C` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredient` (`id`) ON DELETE CASCADE,
- CONSTRAINT `FK_C297417DF347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`) ON DELETE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `produit_ingredient`
- --
- LOCK TABLES `produit_ingredient` WRITE;
- /*!40000 ALTER TABLE `produit_ingredient` DISABLE KEYS */;
- /*!40000 ALTER TABLE `produit_ingredient` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `produit_supplement`
- --
- DROP TABLE IF EXISTS `produit_supplement`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `produit_supplement` (
- `produit_id` int(11) NOT NULL,
- `supplement_id` int(11) NOT NULL,
- PRIMARY KEY (`produit_id`,`supplement_id`),
- KEY `IDX_A8624AC4F347EFB` (`produit_id`),
- KEY `IDX_A8624AC47793FA21` (`supplement_id`),
- CONSTRAINT `FK_A8624AC47793FA21` FOREIGN KEY (`supplement_id`) REFERENCES `supplement` (`id`) ON DELETE CASCADE,
- CONSTRAINT `FK_A8624AC4F347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`) ON DELETE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `produit_supplement`
- --
- LOCK TABLES `produit_supplement` WRITE;
- /*!40000 ALTER TABLE `produit_supplement` DISABLE KEYS */;
- /*!40000 ALTER TABLE `produit_supplement` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `stripe_charge`
- --
- DROP TABLE IF EXISTS `stripe_charge`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `stripe_charge` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `commande_id` int(11) NOT NULL,
- `id_charge` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `object` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `amount` int(11) NOT NULL,
- `amount_refunded` int(11) NOT NULL,
- `balance_transaction` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `currency` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `created_stripe` int(11) NOT NULL,
- `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `failure_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `failure_message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `paid` tinyint(1) NOT NULL DEFAULT '0',
- `refunded` tinyint(1) NOT NULL DEFAULT '0',
- `user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `created_at` datetime NOT NULL,
- `updated_at` datetime NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `UNIQ_FD26D90882EA2E54` (`commande_id`),
- CONSTRAINT `FK_FD26D90882EA2E54` FOREIGN KEY (`commande_id`) REFERENCES `commande` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `stripe_charge`
- --
- LOCK TABLES `stripe_charge` WRITE;
- /*!40000 ALTER TABLE `stripe_charge` DISABLE KEYS */;
- /*!40000 ALTER TABLE `stripe_charge` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `supplement`
- --
- DROP TABLE IF EXISTS `supplement`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `supplement` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `commerce_id` int(11) NOT NULL,
- `prix` decimal(10,2) NOT NULL,
- `indisponible` tinyint(1) NOT NULL DEFAULT '0',
- `rupture_stock` tinyint(1) NOT NULL DEFAULT '0',
- `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `created_at` datetime NOT NULL,
- `updated_at` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `IDX_15A73C9B09114B7` (`commerce_id`),
- CONSTRAINT `FK_15A73C9B09114B7` FOREIGN KEY (`commerce_id`) REFERENCES `commerce` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `supplement`
- --
- LOCK TABLES `supplement` WRITE;
- /*!40000 ALTER TABLE `supplement` DISABLE KEYS */;
- /*!40000 ALTER TABLE `supplement` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `users`
- --
- DROP TABLE IF EXISTS `users`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `users` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `username` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
- `username_canonical` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
- `email` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
- `email_canonical` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
- `enabled` tinyint(1) NOT NULL,
- `salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `last_login` datetime DEFAULT NULL,
- `confirmation_token` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
- `password_requested_at` datetime DEFAULT NULL,
- `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
- `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `prenom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `rue` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `code_postal` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `localite` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `telephone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `sms_numero` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `UNIQ_1483A5E992FC23A8` (`username_canonical`),
- UNIQUE KEY `UNIQ_1483A5E9A0D96FBF` (`email_canonical`),
- UNIQUE KEY `UNIQ_1483A5E9C05FB297` (`confirmation_token`)
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `users`
- --
- LOCK TABLES `users` WRITE;
- /*!40000 ALTER TABLE `users` DISABLE KEYS */;
- 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');
- /*!40000 ALTER TABLE `users` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2018-02-05 9:50:20
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement