-- MySQL dump 10.13  Distrib 8.0.26, for Linux (x86_64)
--
-- Host: gehmysb2402u.mysql.database.azure.com    Database: jimmy
-- ------------------------------------------------------
-- Server version	5.6.47.0

/*!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 */;
/*!50503 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 `abstractuser`
--

DROP TABLE IF EXISTS `abstractuser`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `abstractuser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `enabled` tinyint(1) NOT NULL,
  `firstname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `locale` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accept_cgu` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49207 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `actualite`
--

DROP TABLE IF EXISTS `actualite`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `actualite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_web_id` int(11) DEFAULT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hidden` tinyint(1) DEFAULT NULL,
  `image_app_id` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `affichage_email` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D663033451051985` (`image_web_id`),
  KEY `IDX_D6630334D69A7FE5` (`image_app_id`),
  CONSTRAINT `FK_D663033451051985` FOREIGN KEY (`image_web_id`) REFERENCES `file` (`id`),
  CONSTRAINT `FK_D6630334D69A7FE5` FOREIGN KEY (`image_app_id`) REFERENCES `file` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `article`
--

DROP TABLE IF EXISTS `article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `commande_id` int(11) DEFAULT NULL,
  `produit_id` int(11) DEFAULT NULL,
  `casier_id` int(11) DEFAULT NULL,
  `clefs` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `livre` tinyint(1) NOT NULL,
  `consigne` tinyint(1) NOT NULL,
  `prix` double NOT NULL,
  `recouvre_charge` tinyint(1) NOT NULL,
  `recouvre_consigne` tinyint(1) NOT NULL,
  `prix_charge` double NOT NULL,
  `prix_consigne` double NOT NULL,
  `retour_consigne` tinyint(1) DEFAULT NULL,
  `contrat_consignation_id` int(11) DEFAULT NULL,
  `casierNumero` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_CD8737FA29CAE0D5` (`contrat_consignation_id`),
  KEY `IDX_CD8737FA82EA2E54` (`commande_id`),
  KEY `IDX_CD8737FA643911C6` (`casier_id`),
  KEY `IDX_CD8737FAF347EFB` (`produit_id`),
  CONSTRAINT `FK_CD8737FA29CAE0D5` FOREIGN KEY (`contrat_consignation_id`) REFERENCES `contratconsignation` (`id`),
  CONSTRAINT `FK_CD8737FA643911C6` FOREIGN KEY (`casier_id`) REFERENCES `casier` (`id`),
  CONSTRAINT `FK_CD8737FA82EA2E54` FOREIGN KEY (`commande_id`) REFERENCES `commande` (`id`),
  CONSTRAINT `FK_CD8737FAF347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=663163 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `articlereassignation`
--

DROP TABLE IF EXISTS `articlereassignation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `articlereassignation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `casier_id_ancien` int(11) NOT NULL,
  `casier_id_nouveau` int(11) NOT NULL,
  `erreur_id` int(11) DEFAULT NULL,
  `date` datetime NOT NULL,
  `donne` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `automatiquement` tinyint(1) NOT NULL,
  `erreurTexte` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FC9F179F7294869C` (`article_id`),
  KEY `IDX_FC9F179FA76ED395` (`user_id`),
  KEY `IDX_FC9F179FE7CE920` (`casier_id_ancien`),
  KEY `IDX_FC9F179F945BAC77` (`casier_id_nouveau`),
  KEY `IDX_FC9F179F544202C9` (`erreur_id`),
  CONSTRAINT `FK_FC9F179F544202C9` FOREIGN KEY (`erreur_id`) REFERENCES `articlereassignationerreur` (`id`),
  CONSTRAINT `FK_FC9F179F7294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_FC9F179F945BAC77` FOREIGN KEY (`casier_id_nouveau`) REFERENCES `casier` (`id`),
  CONSTRAINT `FK_FC9F179FA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_FC9F179FE7CE920` FOREIGN KEY (`casier_id_ancien`) REFERENCES `casier` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10805 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `articlereassignationerreur`
--

DROP TABLE IF EXISTS `articlereassignationerreur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `articlereassignationerreur` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `provenance` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `borne`
--

DROP TABLE IF EXISTS `borne`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `borne` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `numSam` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `version_gateway_actuelle` int(11) DEFAULT NULL,
  `version_gateway_cible` int(11) DEFAULT NULL,
  `version_locker_cible` int(11) DEFAULT NULL,
  `version` decimal(4,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_168774A15A5D5802` (`numSam`)
) ENGINE=InnoDB AUTO_INCREMENT=308 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `casier`
--

DROP TABLE IF EXISTS `casier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `casier` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `presentoir_id` int(11) DEFAULT NULL,
  `code` int(11) DEFAULT NULL,
  `numero` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position_x` int(11) NOT NULL,
  `position_y` int(11) NOT NULL,
  `position_z` int(11) NOT NULL,
  `type_bouteille` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batterie` int(11) DEFAULT NULL,
  `stock` tinyint(1) NOT NULL,
  `anomalie` tinyint(1) NOT NULL,
  `reserve` tinyint(1) NOT NULL,
  `date_derniere_reservation` datetime NOT NULL,
  `clefs` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `valide` tinyint(1) NOT NULL,
  `id_atex` int(11) DEFAULT NULL,
  `date_maj_batterie` datetime NOT NULL,
  `porte_ouverte` tinyint(1) NOT NULL,
  `bouteille_vide` tinyint(1) NOT NULL,
  `bouteille_absente` tinyint(1) NOT NULL,
  `version` int(11) NOT NULL,
  `desynchro` tinyint(1) NOT NULL,
  `capteur_bouteille_HS` tinyint(1) NOT NULL,
  `capteur_porte_HS` tinyint(1) NOT NULL,
  `serrure_HS` tinyint(1) NOT NULL,
  `remplacer` tinyint(1) NOT NULL,
  `cause` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rssi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `surveillance` tinyint(1) NOT NULL,
  `unopened_locker` int(11) DEFAULT NULL,
  `pending` tinyint(1) NOT NULL,
  `versionHardware` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_451F7B377153098` (`code`),
  KEY `IDX_451F7B3BF087F50` (`presentoir_id`),
  CONSTRAINT `FK_451F7B3BF087F50` FOREIGN KEY (`presentoir_id`) REFERENCES `presentoir` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22419 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `choiceversionlockerlist`
--

DROP TABLE IF EXISTS `choiceversionlockerlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `choiceversionlockerlist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lockerValue` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `coderemboursement`
--

DROP TABLE IF EXISTS `coderemboursement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `coderemboursement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `valide` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20001 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `codespecial`
--

DROP TABLE IF EXISTS `codespecial`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `codespecial` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `point_de_vente_id` int(11) NOT NULL,
  `date_debut_validite` datetime NOT NULL,
  `date_fin_validite` datetime NOT NULL,
  `actif` tinyint(1) NOT NULL,
  `action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  `used_at` datetime DEFAULT NULL,
  `count_code` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_83FF36893F95E273` (`point_de_vente_id`),
  CONSTRAINT `FK_83FF36893F95E273` FOREIGN KEY (`point_de_vente_id`) REFERENCES `pointdevente` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=452101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `commande`
--

DROP TABLE IF EXISTS `commande`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `commande` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `point_de_vente_id` int(11) DEFAULT NULL,
  `paye` tinyint(1) NOT NULL,
  `livre` tinyint(1) NOT NULL,
  `annule` tinyint(1) NOT NULL,
  `quantite` int(11) NOT NULL,
  `montant_ht` double NOT NULL,
  `montant_tva` double NOT NULL,
  `montant_ttc` double NOT NULL,
  `montant_du` double NOT NULL,
  `texte` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `cb_etat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cb_date` datetime NOT NULL,
  `recouvre` tinyint(1) NOT NULL,
  `alerte1` tinyint(1) NOT NULL,
  `alerte2` tinyint(1) NOT NULL,
  `code_borne` longtext COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `prenom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `relance` tinyint(1) DEFAULT NULL,
  `date_validite` datetime DEFAULT NULL,
  `etat_transaction` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reassigned` datetime DEFAULT NULL,
  `nb_checkcode` int(11) DEFAULT NULL,
  `casiers_used` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `messageStatus` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateReassigned` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `consignation_borne` tinyint(1) DEFAULT NULL,
  `email_erreur` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_979CC42BA76ED395` (`user_id`),
  KEY `IDX_979CC42B3F95E273` (`point_de_vente_id`),
  CONSTRAINT `FK_979CC42B3F95E273` FOREIGN KEY (`point_de_vente_id`) REFERENCES `pointdevente` (`id`),
  CONSTRAINT `FK_979CC42BA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=656617 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `config`
--

DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=451 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contratconsignation`
--

DROP TABLE IF EXISTS `contratconsignation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contratconsignation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23081 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `enseigne`
--

DROP TABLE IF EXISTS `enseigne`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enseigne` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `enseigne_account`
--

DROP TABLE IF EXISTS `enseigne_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enseigne_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `societe` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_mag` tinyint(1) NOT NULL,
  `magasin_enseigne_id` int(11) DEFAULT NULL,
  `mag_zcc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin` tinyint(1) DEFAULT NULL,
  `a2fToken` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a2fTokenValidity` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FCAEF43BD60322AC` (`role_id`),
  CONSTRAINT `FK_FCAEF43BD60322AC` FOREIGN KEY (`role_id`) REFERENCES `enseigne_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=373 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `enseigne_role`
--

DROP TABLE IF EXISTS `enseigne_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enseigne_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `envoi`
--

DROP TABLE IF EXISTS `envoi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `envoi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `recipient` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `titre` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `texte` longtext COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13280 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ext_log_entries`
--

DROP TABLE IF EXISTS `ext_log_entries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ext_log_entries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `logged_at` datetime NOT NULL,
  `object_id` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `object_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `version` int(11) NOT NULL,
  `data` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:array)',
  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `log_class_lookup_idx` (`object_class`),
  KEY `log_date_lookup_idx` (`logged_at`),
  KEY `log_user_lookup_idx` (`username`),
  KEY `log_version_lookup_idx` (`object_id`,`object_class`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ext_translations`
--

DROP TABLE IF EXISTS `ext_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ext_translations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `locale` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `object_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `field` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `foreign_key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lookup_unique_idx` (`locale`,`object_class`,`field`,`foreign_key`),
  KEY `translations_lookup_idx` (`locale`,`object_class`,`foreign_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `file`
--

DROP TABLE IF EXISTS `file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `extension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `preview_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_web_image` tinyint(1) DEFAULT NULL,
  `is_file_changed` tinyint(1) DEFAULT NULL,
  `mask_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_web_video` tinyint(1) DEFAULT NULL,
  `video_duration` double NOT NULL,
  `video_preview_second` int(11) NOT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `firmware`
--

DROP TABLE IF EXISTS `firmware`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `firmware` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL,
  `version` int(11) NOT NULL,
  `data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `signature` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `firmwarelog`
--

DROP TABLE IF EXISTS `firmwarelog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `firmwarelog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `casier_id` int(11) DEFAULT NULL,
  `data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C08D6230643911C6` (`casier_id`),
  CONSTRAINT `FK_C08D6230643911C6` FOREIGN KEY (`casier_id`) REFERENCES `casier` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fournisseur`
--

DROP TABLE IF EXISTS `fournisseur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fournisseur` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `estInterne` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `import`
--

DROP TABLE IF EXISTS `import`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `import` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9AE2CB2B93CB796C` (`file_id`),
  CONSTRAINT `FK_9AE2CB2B93CB796C` FOREIGN KEY (`file_id`) REFERENCES `file` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention`
--

DROP TABLE IF EXISTS `intervention`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `origine` int(11) DEFAULT NULL,
  `intervenant` int(11) DEFAULT NULL,
  `point_de_vente_id` int(11) DEFAULT NULL,
  `action` tinytext COLLATE utf8_unicode_ci,
  `incident_autre` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date_demande` datetime NOT NULL,
  `date_intervention` datetime DEFAULT NULL,
  `provenance` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `secure_id` int(11) DEFAULT NULL,
  `secure_date` datetime DEFAULT NULL,
  `sinistre` tinyint(1) NOT NULL,
  `vol` tinyint(1) NOT NULL,
  `incident_id_resolu` int(11) DEFAULT NULL,
  `casier_id` int(11) DEFAULT NULL,
  `incident_id` int(11) DEFAULT NULL,
  `date_cloture` datetime DEFAULT NULL,
  `resoluAuto` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C929CF53150BB66F` (`origine`),
  KEY `IDX_C929CF5373D0145C` (`intervenant`),
  KEY `IDX_C929CF533F95E273` (`point_de_vente_id`),
  KEY `IDX_C929CF539A1F872C` (`incident_id_resolu`),
  KEY `IDX_C929CF53643911C6` (`casier_id`),
  KEY `IDX_C929CF5359E53FB9` (`incident_id`),
  CONSTRAINT `FK_C929CF53150BB66F` FOREIGN KEY (`origine`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_C929CF533F95E273` FOREIGN KEY (`point_de_vente_id`) REFERENCES `pointdevente` (`id`),
  CONSTRAINT `FK_C929CF5359E53FB9` FOREIGN KEY (`incident_id`) REFERENCES `interventionincident` (`id`),
  CONSTRAINT `FK_C929CF53643911C6` FOREIGN KEY (`casier_id`) REFERENCES `casier` (`id`),
  CONSTRAINT `FK_C929CF5373D0145C` FOREIGN KEY (`intervenant`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_C929CF539A1F872C` FOREIGN KEY (`incident_id_resolu`) REFERENCES `interventionincident` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11832 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention_logstatut_commande`
--

DROP TABLE IF EXISTS `intervention_logstatut_commande`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention_logstatut_commande` (
  `log_id` int(11) NOT NULL,
  `commande_id` int(11) NOT NULL,
  PRIMARY KEY (`log_id`,`commande_id`),
  KEY `IDX_73EBED5FEA675D86` (`log_id`),
  KEY `IDX_73EBED5F82EA2E54` (`commande_id`),
  CONSTRAINT `FK_73EBED5F82EA2E54` FOREIGN KEY (`commande_id`) REFERENCES `interventioncommande` (`id`),
  CONSTRAINT `FK_73EBED5FEA675D86` FOREIGN KEY (`log_id`) REFERENCES `interventionlogstatut` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `interventioncommande`
--

DROP TABLE IF EXISTS `interventioncommande`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `interventioncommande` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fournisseur_id` int(11) NOT NULL,
  `intervention_id` int(11) NOT NULL,
  `piece` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mail_fournisseur_envoye` tinyint(1) NOT NULL,
  `expedie` tinyint(1) NOT NULL,
  `recu` tinyint(1) NOT NULL,
  `dateExpedition` datetime DEFAULT NULL,
  `dateReception` datetime DEFAULT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B2C60138670C757F` (`fournisseur_id`),
  KEY `IDX_B2C601388EAE3863` (`intervention_id`),
  CONSTRAINT `FK_B2C60138670C757F` FOREIGN KEY (`fournisseur_id`) REFERENCES `fournisseur` (`id`),
  CONSTRAINT `FK_B2C601388EAE3863` FOREIGN KEY (`intervention_id`) REFERENCES `intervention` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=384 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `interventionincident`
--

DROP TABLE IF EXISTS `interventionincident`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `interventionincident` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `bloquant` tinyint(1) NOT NULL,
  `etreIncident` tinyint(1) NOT NULL,
  `etreModifResolution` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `interventionlogstatut`
--

DROP TABLE IF EXISTS `interventionlogstatut`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `interventionlogstatut` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `intervenant` int(11) DEFAULT NULL,
  `statut_id` int(11) NOT NULL,
  `intervention_id` int(11) NOT NULL,
  `dateCreation` datetime NOT NULL,
  `action` longtext COLLATE utf8_unicode_ci,
  `date_intervention` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4EE46BF073D0145C` (`intervenant`),
  KEY `IDX_4EE46BF0F6203804` (`statut_id`),
  KEY `IDX_4EE46BF08EAE3863` (`intervention_id`),
  CONSTRAINT `FK_4EE46BF073D0145C` FOREIGN KEY (`intervenant`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_4EE46BF08EAE3863` FOREIGN KEY (`intervention_id`) REFERENCES `intervention` (`id`),
  CONSTRAINT `FK_4EE46BF0F6203804` FOREIGN KEY (`statut_id`) REFERENCES `interventionstatut` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17054 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `interventionstatut`
--

DROP TABLE IF EXISTS `interventionstatut`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `interventionstatut` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `interventiontemporiser`
--

DROP TABLE IF EXISTS `interventiontemporiser`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `interventiontemporiser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `incident_id` int(11) DEFAULT NULL,
  `point_de_vente_id` int(11) DEFAULT NULL,
  `date` datetime NOT NULL,
  `provenance` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `incident_autre` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A44E524B59E53FB9` (`incident_id`),
  KEY `IDX_A44E524B3F95E273` (`point_de_vente_id`),
  CONSTRAINT `FK_A44E524B3F95E273` FOREIGN KEY (`point_de_vente_id`) REFERENCES `pointdevente` (`id`),
  CONSTRAINT `FK_A44E524B59E53FB9` FOREIGN KEY (`incident_id`) REFERENCES `interventionincident` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `interventionvol`
--

DROP TABLE IF EXISTS `interventionvol`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `interventionvol` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `intervention_id` int(11) NOT NULL,
  `produitCode` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `nb` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_513B12C68EAE3863` (`intervention_id`),
  CONSTRAINT `FK_513B12C68EAE3863` FOREIGN KEY (`intervention_id`) REFERENCES `intervention` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ipclient`
--

DROP TABLE IF EXISTS `ipclient`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ipclient` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `log`
--

DROP TABLE IF EXISTS `log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `casier_id` int(11) DEFAULT NULL,
  `presentoir_id` int(11) DEFAULT NULL,
  `point_de_vente_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `commande_id` int(11) DEFAULT NULL,
  `article_id` int(11) DEFAULT NULL,
  `qui` longtext COLLATE utf8_unicode_ci,
  `quoi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:array)',
  `isWS` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B7722E25643911C6` (`casier_id`),
  KEY `IDX_B7722E25BF087F50` (`presentoir_id`),
  KEY `IDX_B7722E253F95E273` (`point_de_vente_id`),
  KEY `IDX_B7722E25A76ED395` (`user_id`),
  KEY `IDX_B7722E257294869C` (`article_id`),
  KEY `quoi` (`quoi`),
  KEY `IDX_B7722E2582EA2E54` (`commande_id`),
  CONSTRAINT `FK_B7722E253F95E273` FOREIGN KEY (`point_de_vente_id`) REFERENCES `pointdevente` (`id`),
  CONSTRAINT `FK_B7722E25643911C6` FOREIGN KEY (`casier_id`) REFERENCES `casier` (`id`),
  CONSTRAINT `FK_B7722E257294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_B7722E2582EA2E54` FOREIGN KEY (`commande_id`) REFERENCES `commande` (`id`),
  CONSTRAINT `FK_B7722E25A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_B7722E25BF087F50` FOREIGN KEY (`presentoir_id`) REFERENCES `presentoir` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `log_logphoto`
--

DROP TABLE IF EXISTS `log_logphoto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log_logphoto` (
  `log_id` int(11) NOT NULL,
  `logphoto_id` int(11) NOT NULL,
  PRIMARY KEY (`log_id`,`logphoto_id`),
  KEY `IDX_36AFD1A9EA675D86` (`log_id`),
  KEY `IDX_36AFD1A9321B9566` (`logphoto_id`),
  CONSTRAINT `FK_36AFD1A9321B9566` FOREIGN KEY (`logphoto_id`) REFERENCES `logphoto` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_36AFD1A9EA675D86` FOREIGN KEY (`log_id`) REFERENCES `log` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `logphoto`
--

DROP TABLE IF EXISTS `logphoto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `logphoto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2471 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `loguseropt`
--

DROP TABLE IF EXISTS `loguseropt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `loguseropt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id_editeur` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `date_creation` datetime NOT NULL,
  `opt_in_email` tinyint(1) NOT NULL,
  `opt_in_sms` tinyint(1) NOT NULL,
  `opt_in_letter` tinyint(1) NOT NULL,
  `source` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `action` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_51D647F47C5D2873` (`user_id_editeur`),
  KEY `IDX_51D647F4A76ED395` (`user_id`),
  CONSTRAINT `FK_51D647F47C5D2873` FOREIGN KEY (`user_id_editeur`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_51D647F4A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4744 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `loradownlink`
--

DROP TABLE IF EXISTS `loradownlink`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `loradownlink` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `data` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sent` tinyint(1) NOT NULL,
  `deveui` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `response_code` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=538 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `loradownlinkcasier`
--

DROP TABLE IF EXISTS `loradownlinkcasier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `loradownlinkcasier` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=915 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lorauplink`
--

DROP TABLE IF EXISTS `lorauplink`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lorauplink` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `params` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5543 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mandataire`
--

DROP TABLE IF EXISTS `mandataire`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mandataire` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `offre`
--

DROP TABLE IF EXISTS `offre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `offre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) DEFAULT NULL,
  `titre` longtext COLLATE utf8_unicode_ci NOT NULL,
  `lien` longtext COLLATE utf8_unicode_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `showInMail` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6E47A96B3DA5256D` (`image_id`),
  CONSTRAINT `FK_6E47A96B3DA5256D` FOREIGN KEY (`image_id`) REFERENCES `file` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `paiement`
--

DROP TABLE IF EXISTS `paiement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `paiement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `commande_id` int(11) DEFAULT NULL,
  `montant` double NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `reference` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `autorisation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `success` tinyint(1) NOT NULL,
  `log` longtext COLLATE utf8_unicode_ci,
  `montant_recouvre` double NOT NULL,
  `montant_recredit` double NOT NULL,
  `transactionDate` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_48AA184882EA2E54` (`commande_id`),
  CONSTRAINT `FK_48AA184882EA2E54` FOREIGN KEY (`commande_id`) REFERENCES `commande` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=397743 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `planchargement`
--

DROP TABLE IF EXISTS `planchargement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `planchargement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `format` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_4949A0586C6E55B5` (`nom`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pointdevente`
--

DROP TABLE IF EXISTS `pointdevente`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pointdevente` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `equipe` tinyint(1) NOT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `adresse` longtext COLLATE utf8_unicode_ci NOT NULL,
  `ville` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `code_postal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `telephone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `horaires` longtext COLLATE utf8_unicode_ci,
  `livraison` tinyint(1) NOT NULL,
  `offre_id` int(11) DEFAULT NULL,
  `last_letter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVAProduit` double NOT NULL,
  `TVAConsigne` double NOT NULL,
  `date_offre_debut` date DEFAULT NULL,
  `date_offre_fin` date DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL,
  `hidden` tinyint(1) NOT NULL,
  `contrat_tpe_contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contrat_tpe_sans_contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `timeAlert` int(11) DEFAULT NULL,
  `lastAlert` date DEFAULT NULL,
  `iemDateDernierContact` datetime DEFAULT NULL,
  `enseigne_id` int(11) DEFAULT NULL,
  `mandataire_id` int(11) DEFAULT NULL,
  `type_surface_id` int(11) DEFAULT NULL,
  `use_code_chauffeur` tinyint(1) NOT NULL,
  `animationIsActive` tinyint(1) DEFAULT NULL,
  `animationStartDate` datetime DEFAULT NULL,
  `animationEndDate` datetime DEFAULT NULL,
  `afficherOffreVignette` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_72DF29AD4CC8505A` (`offre_id`),
  KEY `IDX_72DF29AD6C2A0A71` (`enseigne_id`),
  KEY `IDX_72DF29AD58207E03` (`mandataire_id`),
  KEY `IDX_72DF29ADD7122311` (`type_surface_id`),
  CONSTRAINT `FK_72DF29AD4CC8505A` FOREIGN KEY (`offre_id`) REFERENCES `offre` (`id`),
  CONSTRAINT `FK_72DF29AD58207E03` FOREIGN KEY (`mandataire_id`) REFERENCES `mandataire` (`id`),
  CONSTRAINT `FK_72DF29AD6C2A0A71` FOREIGN KEY (`enseigne_id`) REFERENCES `enseigne` (`id`),
  CONSTRAINT `FK_72DF29ADD7122311` FOREIGN KEY (`type_surface_id`) REFERENCES `typesurface` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=400 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pointdevente_user`
--

DROP TABLE IF EXISTS `pointdevente_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pointdevente_user` (
  `pointdevente_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`pointdevente_id`,`user_id`),
  KEY `IDX_67289E6ADB2504C7` (`pointdevente_id`),
  KEY `IDX_67289E6AA76ED395` (`user_id`),
  CONSTRAINT `FK_67289E6AA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_67289E6ADB2504C7` FOREIGN KEY (`pointdevente_id`) REFERENCES `pointdevente` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `presentoir`
--

DROP TABLE IF EXISTS `presentoir`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `presentoir` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `point_de_vente_id` int(11) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `format` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `id_lora` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `plan_chargement_id` int(11) DEFAULT NULL,
  `borne_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent_production` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_assemblage` datetime DEFAULT NULL,
  `id_lot_verrou` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_lot_panneau` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_lot_moteur` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_lot_plastique` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_lot_circuit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_lot_switch` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remarques` longtext COLLATE utf8_unicode_ci,
  `date_livraison` datetime DEFAULT NULL,
  `bon_livraison_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_12994DE9D8D16068` (`bon_livraison_id`),
  KEY `IDX_12994DE93F95E273` (`point_de_vente_id`),
  KEY `IDX_12994DE9B6FAF931` (`plan_chargement_id`),
  KEY `IDX_12994DE97F023A56` (`borne_id`),
  CONSTRAINT `FK_12994DE93F95E273` FOREIGN KEY (`point_de_vente_id`) REFERENCES `pointdevente` (`id`),
  CONSTRAINT `FK_12994DE97F023A56` FOREIGN KEY (`borne_id`) REFERENCES `borne` (`id`),
  CONSTRAINT `FK_12994DE9B6FAF931` FOREIGN KEY (`plan_chargement_id`) REFERENCES `planchargement` (`id`),
  CONSTRAINT `FK_12994DE9D8D16068` FOREIGN KEY (`bon_livraison_id`) REFERENCES `statuslog` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1098 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `produit`
--

DROP TABLE IF EXISTS `produit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `produit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `position` int(11) NOT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `poids` double NOT NULL,
  `prix` double NOT NULL,
  `consigne` double NOT NULL,
  `lien` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `codeSAP` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `prixPromo` double NOT NULL,
  `consignePromo` double NOT NULL,
  `lienProduitAssocie` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8_unicode_ci,
  `type2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `qrcode_id` int(11) DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `produitAssocie_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_E618D5BB9AAF4D20` (`qrcode_id`),
  KEY `IDX_E618D5BB424CDDAD` (`produitAssocie_id`),
  KEY `IDX_E618D5BB3DA5256D` (`image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `produitpointdevente`
--

DROP TABLE IF EXISTS `produitpointdevente`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `produitpointdevente` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `produit_id` int(11) DEFAULT NULL,
  `prix` double DEFAULT NULL,
  `prix_promo` double DEFAULT NULL,
  `consigne` double DEFAULT NULL,
  `consigne_promo` double DEFAULT NULL,
  `pointDeVente_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_74FEA9C3F347EFB` (`produit_id`),
  KEY `IDX_74FEA9C36D0E6541` (`pointDeVente_id`),
  CONSTRAINT `FK_74FEA9C36D0E6541` FOREIGN KEY (`pointDeVente_id`) REFERENCES `pointdevente` (`id`),
  CONSTRAINT `FK_74FEA9C3F347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5485 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `produitpointdeventehistorique`
--

DROP TABLE IF EXISTS `produitpointdeventehistorique`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `produitpointdeventehistorique` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `produit_id` int(11) DEFAULT NULL,
  `import_id` int(11) DEFAULT NULL,
  `prix` double DEFAULT NULL,
  `prix_promo` double DEFAULT NULL,
  `consigne` double DEFAULT NULL,
  `consigne_promo` double DEFAULT NULL,
  `jour_activation` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `pointDeVente_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8BABA569F347EFB` (`produit_id`),
  KEY `IDX_8BABA5696D0E6541` (`pointDeVente_id`),
  KEY `IDX_8BABA569B6A263D9` (`import_id`),
  CONSTRAINT `FK_8BABA5696D0E6541` FOREIGN KEY (`pointDeVente_id`) REFERENCES `pointdevente` (`id`),
  CONSTRAINT `FK_8BABA569B6A263D9` FOREIGN KEY (`import_id`) REFERENCES `import` (`id`),
  CONSTRAINT `FK_8BABA569F347EFB` FOREIGN KEY (`produit_id`) REFERENCES `produit` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16630 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `promotion`
--

DROP TABLE IF EXISTS `promotion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `promotion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) DEFAULT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `online` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_43ECFF723DA5256D` (`image_id`),
  CONSTRAINT `FK_43ECFF723DA5256D` FOREIGN KEY (`image_id`) REFERENCES `file` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rapportcodi`
--

DROP TABLE IF EXISTS `rapportcodi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rapportcodi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `annee` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `mois` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `nbReclamationServiceClient` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `reclamationcompteur`
--

DROP TABLE IF EXISTS `reclamationcompteur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reclamationcompteur` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `annee` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `mois` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `nbProblemeTechnique` int(11) DEFAULT NULL,
  `nbCaseVide` int(11) DEFAULT NULL,
  `nbErreurLivraisonOuBouteilleVide` int(11) DEFAULT NULL,
  `nbErreurClient` int(11) DEFAULT NULL,
  `nbAutreProbleme` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `reclamationtype`
--

DROP TABLE IF EXISTS `reclamationtype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reclamationtype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `recouvrement`
--

DROP TABLE IF EXISTS `recouvrement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `recouvrement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `paiement_id` int(11) DEFAULT NULL,
  `success` tinyint(1) NOT NULL,
  `montant` double NOT NULL,
  `reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `log` longtext COLLATE utf8_unicode_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `autorisation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recredit` tinyint(1) NOT NULL,
  `recredit_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_646A328B2A4C4478` (`paiement_id`)
) ENGINE=InnoDB AUTO_INCREMENT=401682 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `statuslog`
--

DROP TABLE IF EXISTS `statuslog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `statuslog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `presentoir_id` int(11) DEFAULT NULL,
  `data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_3835690BBF087F50` (`presentoir_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5443 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `stock`
--

DROP TABLE IF EXISTS `stock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `casier_id` int(11) DEFAULT NULL,
  `stock` tinyint(1) DEFAULT NULL,
  `source` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8AF77964643911C6` (`casier_id`)
) ENGINE=InnoDB AUTO_INCREMENT=859369 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `typesurface`
--

DROP TABLE IF EXISTS `typesurface`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `typesurface` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `company` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `favorite_pdv` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `token_app` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sourceInscription` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `opt_in_email` tinyint(1) NOT NULL,
  `opt_in_sms` tinyint(1) NOT NULL,
  `opt_in_letter` tinyint(1) NOT NULL,
  `inviterRenouvellementOptin` tinyint(1) NOT NULL,
  `archive` tinyint(1) NOT NULL,
  `dateOuvertureDernierMail` datetime DEFAULT NULL,
  `dateDerniereConnexionCc` datetime DEFAULT NULL,
  `dateDerniereSaisieOptinBorne` datetime DEFAULT NULL,
  `a2fToken` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a2fTokenValidity` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2021-09-20  8:52:01
