-- MySQL dump 10.13 Distrib 5.7.33, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: garderie -- ------------------------------------------------------ -- Server version 5.7.33 /*!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 utf8mb4 */; /*!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 */; -- -- Current Database: `garderie` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `garderie` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `garderie`; -- -- Table structure for table `absences` -- DROP TABLE IF EXISTS `absences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `absences` ( `deleted_at` timestamp NULL DEFAULT NULL, `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) unsigned NOT NULL, `from` datetime DEFAULT NULL, `to` datetime DEFAULT NULL, `nature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `absences` -- LOCK TABLES `absences` WRITE; /*!40000 ALTER TABLE `absences` DISABLE KEYS */; /*!40000 ALTER TABLE `absences` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accident_travails` -- DROP TABLE IF EXISTS `accident_travails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `accident_travails` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) unsigned NOT NULL, `from` datetime DEFAULT NULL, `to` datetime DEFAULT NULL, `nature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accident_travails` -- LOCK TABLES `accident_travails` WRITE; /*!40000 ALTER TABLE `accident_travails` DISABLE KEYS */; /*!40000 ALTER TABLE `accident_travails` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `activity_log` -- DROP TABLE IF EXISTS `activity_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `activity_log` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `log_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `event` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subject_id` bigint(20) unsigned DEFAULT NULL, `causer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `causer_id` bigint(20) unsigned DEFAULT NULL, `properties` json DEFAULT NULL, `batch_uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `subject` (`subject_type`,`subject_id`), KEY `causer` (`causer_type`,`causer_id`), KEY `activity_log_log_name_index` (`log_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity_log` -- LOCK TABLES `activity_log` WRITE; /*!40000 ALTER TABLE `activity_log` DISABLE KEYS */; /*!40000 ALTER TABLE `activity_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `affectations` -- DROP TABLE IF EXISTS `affectations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `affectations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) unsigned NOT NULL, `from` datetime DEFAULT NULL, `to` datetime DEFAULT NULL, `parametre_affectation_id` bigint(20) unsigned DEFAULT NULL, `parametre_installation_id` bigint(20) unsigned NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `affectations_affectation_index` (`parametre_affectation_id`), KEY `affectations_installation_index` (`parametre_installation_id`), CONSTRAINT `affectations_installation_foreign` FOREIGN KEY (`parametre_installation_id`) REFERENCES `parametres_installations` (`id`) ON DELETE CASCADE, CONSTRAINT `affectations_parametre_affectation_id_foreign` FOREIGN KEY (`parametre_affectation_id`) REFERENCES `parametres_affectations` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `affectations` -- LOCK TABLES `affectations` WRITE; /*!40000 ALTER TABLE `affectations` DISABLE KEYS */; /*!40000 ALTER TABLE `affectations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `destinataires_rappels` -- DROP TABLE IF EXISTS `destinataires_rappels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `destinataires_rappels` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `rappel_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `destinataires_rappels_rappel_id_foreign` (`rappel_id`), KEY `destinataires_rappels_user_id_foreign` (`user_id`), CONSTRAINT `destinataires_rappels_rappel_id_foreign` FOREIGN KEY (`rappel_id`) REFERENCES `rappels` (`id`), CONSTRAINT `destinataires_rappels_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `destinataires_rappels` -- LOCK TABLES `destinataires_rappels` WRITE; /*!40000 ALTER TABLE `destinataires_rappels` DISABLE KEYS */; /*!40000 ALTER TABLE `destinataires_rappels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_absence_dossiers` -- DROP TABLE IF EXISTS `documents_absence_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_absence_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_absence_dossiers` -- LOCK TABLES `documents_absence_dossiers` WRITE; /*!40000 ALTER TABLE `documents_absence_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_absence_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_absences` -- DROP TABLE IF EXISTS `documents_absences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_absences` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `absence_id` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `dossier_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_absences_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_absences_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_absence_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_absences` -- LOCK TABLES `documents_absences` WRITE; /*!40000 ALTER TABLE `documents_absences` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_absences` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_accident_travail_dossiers` -- DROP TABLE IF EXISTS `documents_accident_travail_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_accident_travail_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_accident_travail_dossiers` -- LOCK TABLES `documents_accident_travail_dossiers` WRITE; /*!40000 ALTER TABLE `documents_accident_travail_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_accident_travail_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_accident_travails` -- DROP TABLE IF EXISTS `documents_accident_travails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_accident_travails` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `accident_travail_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `dossier_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_accident_travails_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_accident_travails_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_accident_travail_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_accident_travails` -- LOCK TABLES `documents_accident_travails` WRITE; /*!40000 ALTER TABLE `documents_accident_travails` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_accident_travails` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_affectation_dossiers` -- DROP TABLE IF EXISTS `documents_affectation_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_affectation_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_affectation_dossiers` -- LOCK TABLES `documents_affectation_dossiers` WRITE; /*!40000 ALTER TABLE `documents_affectation_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_affectation_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_affectations` -- DROP TABLE IF EXISTS `documents_affectations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_affectations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `affectation_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `dossier_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_affectations_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_affectations_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_affectation_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_affectations` -- LOCK TABLES `documents_affectations` WRITE; /*!40000 ALTER TABLE `documents_affectations` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_affectations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_dossier_disciplinaire_dossiers` -- DROP TABLE IF EXISTS `documents_dossier_disciplinaire_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_dossier_disciplinaire_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_dossier_disciplinaire_dossiers` -- LOCK TABLES `documents_dossier_disciplinaire_dossiers` WRITE; /*!40000 ALTER TABLE `documents_dossier_disciplinaire_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_dossier_disciplinaire_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_dossier_disciplinaires` -- DROP TABLE IF EXISTS `documents_dossier_disciplinaires`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_dossier_disciplinaires` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `dossier_disciplinaire_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `dossier_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_dossier_disciplinaires_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_dossier_disciplinaires_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_dossier_disciplinaire_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_dossier_disciplinaires` -- LOCK TABLES `documents_dossier_disciplinaires` WRITE; /*!40000 ALTER TABLE `documents_dossier_disciplinaires` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_dossier_disciplinaires` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_employee_dossiers` -- DROP TABLE IF EXISTS `documents_employee_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_employee_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_employee_dossiers` -- LOCK TABLES `documents_employee_dossiers` WRITE; /*!40000 ALTER TABLE `documents_employee_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_employee_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_employees` -- DROP TABLE IF EXISTS `documents_employees`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_employees` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `dossier_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_employees_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_employees_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_employee_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_employees` -- LOCK TABLES `documents_employees` WRITE; /*!40000 ALTER TABLE `documents_employees` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_employees` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_evaluation_annuelle_dossiers` -- DROP TABLE IF EXISTS `documents_evaluation_annuelle_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_evaluation_annuelle_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_evaluation_annuelle_dossiers` -- LOCK TABLES `documents_evaluation_annuelle_dossiers` WRITE; /*!40000 ALTER TABLE `documents_evaluation_annuelle_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_evaluation_annuelle_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_evaluation_annuelles` -- DROP TABLE IF EXISTS `documents_evaluation_annuelles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_evaluation_annuelles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `evaluation_annuelle_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `dossier_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_evaluation_annuelles_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_evaluation_annuelles_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_evaluation_annuelle_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_evaluation_annuelles` -- LOCK TABLES `documents_evaluation_annuelles` WRITE; /*!40000 ALTER TABLE `documents_evaluation_annuelles` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_evaluation_annuelles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_formation_dossiers` -- DROP TABLE IF EXISTS `documents_formation_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_formation_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_formation_dossiers` -- LOCK TABLES `documents_formation_dossiers` WRITE; /*!40000 ALTER TABLE `documents_formation_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_formation_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_formations` -- DROP TABLE IF EXISTS `documents_formations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_formations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `formation_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `dossier_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_formations_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_formations_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_formation_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_formations` -- LOCK TABLES `documents_formations` WRITE; /*!40000 ALTER TABLE `documents_formations` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_formations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_invalidites` -- DROP TABLE IF EXISTS `documents_invalidites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_invalidites` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `invalidite_id` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci, `dossier_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_invalidites_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_invalidites_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_invalidites_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_invalidites` -- LOCK TABLES `documents_invalidites` WRITE; /*!40000 ALTER TABLE `documents_invalidites` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_invalidites` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_invalidites_dossiers` -- DROP TABLE IF EXISTS `documents_invalidites_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_invalidites_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_invalidites_dossiers` -- LOCK TABLES `documents_invalidites_dossiers` WRITE; /*!40000 ALTER TABLE `documents_invalidites_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_invalidites_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_reglementaires` -- DROP TABLE IF EXISTS `documents_reglementaires`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_reglementaires` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dossier_id` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_reglementaires_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_reglementaires_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_reglementaires_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_reglementaires` -- LOCK TABLES `documents_reglementaires` WRITE; /*!40000 ALTER TABLE `documents_reglementaires` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_reglementaires` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_reglementaires_dossiers` -- DROP TABLE IF EXISTS `documents_reglementaires_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_reglementaires_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_reglementaires_dossiers` -- LOCK TABLES `documents_reglementaires_dossiers` WRITE; /*!40000 ALTER TABLE `documents_reglementaires_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_reglementaires_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_soutien_pedagogique_dossiers` -- DROP TABLE IF EXISTS `documents_soutien_pedagogique_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_soutien_pedagogique_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_soutien_pedagogique_dossiers` -- LOCK TABLES `documents_soutien_pedagogique_dossiers` WRITE; /*!40000 ALTER TABLE `documents_soutien_pedagogique_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_soutien_pedagogique_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_soutien_pedagogiques` -- DROP TABLE IF EXISTS `documents_soutien_pedagogiques`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_soutien_pedagogiques` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `soutien_pedagogique_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `dossier_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_soutien_pedagogiques_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_soutien_pedagogiques_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_soutien_pedagogique_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_soutien_pedagogiques` -- LOCK TABLES `documents_soutien_pedagogiques` WRITE; /*!40000 ALTER TABLE `documents_soutien_pedagogiques` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_soutien_pedagogiques` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_suivi_evenement_incident_dossiers` -- DROP TABLE IF EXISTS `documents_suivi_evenement_incident_dossiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_suivi_evenement_incident_dossiers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_suivi_evenement_incident_dossiers` -- LOCK TABLES `documents_suivi_evenement_incident_dossiers` WRITE; /*!40000 ALTER TABLE `documents_suivi_evenement_incident_dossiers` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_suivi_evenement_incident_dossiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `documents_suivi_evenement_incidents` -- DROP TABLE IF EXISTS `documents_suivi_evenement_incidents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `documents_suivi_evenement_incidents` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `suivi_evenement_incident_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `dossier_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_suivi_evenement_incidents_dossier_id_foreign` (`dossier_id`), CONSTRAINT `documents_suivi_evenement_incidents_dossier_id_foreign` FOREIGN KEY (`dossier_id`) REFERENCES `documents_suivi_evenement_incident_dossiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `documents_suivi_evenement_incidents` -- LOCK TABLES `documents_suivi_evenement_incidents` WRITE; /*!40000 ALTER TABLE `documents_suivi_evenement_incidents` DISABLE KEYS */; /*!40000 ALTER TABLE `documents_suivi_evenement_incidents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dossier_disciplinaires` -- DROP TABLE IF EXISTS `dossier_disciplinaires`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dossier_disciplinaires` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) unsigned NOT NULL, `date` datetime DEFAULT NULL, `nature_du_manquement_id` bigint(20) unsigned DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `enquete` longtext COLLATE utf8mb4_unicode_ci, `sanction_id` bigint(20) unsigned DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dossier_disciplinaires` -- LOCK TABLES `dossier_disciplinaires` WRITE; /*!40000 ALTER TABLE `dossier_disciplinaires` DISABLE KEYS */; /*!40000 ALTER TABLE `dossier_disciplinaires` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employees` -- DROP TABLE IF EXISTS `employees`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `employees` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `firstName` longtext COLLATE utf8mb4_unicode_ci, `lastName` longtext COLLATE utf8mb4_unicode_ci, `job` longtext COLLATE utf8mb4_unicode_ci, `birthdate` date DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hiringDate` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `qualification` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `telephone` longtext COLLATE utf8mb4_unicode_ci, `email` longtext COLLATE utf8mb4_unicode_ci, `seniority` double DEFAULT NULL, `qualification_id` bigint(20) unsigned DEFAULT NULL, `status_id` bigint(20) unsigned DEFAULT NULL, `seniority_updated_at` date DEFAULT NULL, `address` longtext COLLATE utf8mb4_unicode_ci, `number` longtext COLLATE utf8mb4_unicode_ci, `street` longtext COLLATE utf8mb4_unicode_ci, `city` longtext COLLATE utf8mb4_unicode_ci, `province` longtext COLLATE utf8mb4_unicode_ci, `postal_code` longtext COLLATE utf8mb4_unicode_ci, `seniority_date` date DEFAULT NULL, `departure_date` date DEFAULT NULL, `is_archived` tinyint(1) NOT NULL DEFAULT '0', `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `employees_qualification_id_foreign` (`qualification_id`), KEY `employees_status_id_foreign` (`status_id`), CONSTRAINT `employees_qualification_id_foreign` FOREIGN KEY (`qualification_id`) REFERENCES `parametres_qualifications` (`id`), CONSTRAINT `employees_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `parametres_statuts` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `employees` -- LOCK TABLES `employees` WRITE; /*!40000 ALTER TABLE `employees` DISABLE KEYS */; /*!40000 ALTER TABLE `employees` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `evaluation_annuelles` -- DROP TABLE IF EXISTS `evaluation_annuelles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `evaluation_annuelles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) unsigned NOT NULL, `date` datetime DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `notes` longtext COLLATE utf8mb4_unicode_ci, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `evaluation_annuelles` -- LOCK TABLES `evaluation_annuelles` WRITE; /*!40000 ALTER TABLE `evaluation_annuelles` DISABLE KEYS */; /*!40000 ALTER TABLE `evaluation_annuelles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `factures` -- DROP TABLE IF EXISTS `factures`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `factures` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `data` json NOT NULL, `subscriptions_william_id` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `factures` -- LOCK TABLES `factures` WRITE; /*!40000 ALTER TABLE `factures` DISABLE KEYS */; /*!40000 ALTER TABLE `factures` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `formations` -- DROP TABLE IF EXISTS `formations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `formations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) unsigned NOT NULL, `date` datetime DEFAULT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `hours` double DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `formations` -- LOCK TABLES `formations` WRITE; /*!40000 ALTER TABLE `formations` DISABLE KEYS */; /*!40000 ALTER TABLE `formations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invalidites` -- DROP TABLE IF EXISTS `invalidites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invalidites` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) unsigned NOT NULL, `from` datetime DEFAULT NULL, `to` datetime DEFAULT NULL, `nature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invalidites` -- LOCK TABLES `invalidites` WRITE; /*!40000 ALTER TABLE `invalidites` DISABLE KEYS */; /*!40000 ALTER TABLE `invalidites` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=143 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2014_10_12_200000_add_two_factor_columns_to_users_table',1),(4,'2019_05_03_000001_add_spark_columns_to_users_table',1),(5,'2019_05_03_000002_create_subscriptions_table',1),(6,'2019_05_03_000003_create_subscription_items_table',1),(7,'2019_06_03_000003_create_receipts_table',1),(8,'2019_06_03_000003_create_tax_rates_table',1),(9,'2019_08_19_000000_create_failed_jobs_table',1),(10,'2019_12_14_000001_create_personal_access_tokens_table',1),(11,'2020_05_21_100000_create_teams_table',1),(12,'2020_05_21_200000_create_team_user_table',1),(13,'2020_05_21_300000_create_team_invitations_table',1),(14,'2021_05_03_000001_add_spark_columns_to_teams_table',1),(15,'2022_07_13_172931_create_sessions_table',1),(16,'2022_08_10_180949_create_employees_table',1),(17,'2022_08_17_172455_ajout_invalidite',1),(18,'2022_08_23_151235_add_soft_delete_on_invalidite',1),(19,'2022_08_23_203851_add_name_and_comment_on_document',1),(20,'2022_08_29_180144_create_affectations_table',1),(21,'2022_08_29_180232_create_documents_affectations_table',1),(22,'2022_08_29_184143_create_table_accident_travail',1),(23,'2022_08_29_184347_create_table_documents_accident_travails',1),(24,'2022_08_30_131718_create_suivi_evenement_incidents_table',1),(25,'2022_08_30_131806_create_documents_suivi_evenement_incidents_table',1),(26,'2022_08_30_134513_create_formations_table',1),(27,'2022_08_30_134542_create_documents_formations_table',1),(28,'2022_08_30_142153_create_soutien_pedagogiques_table',1),(29,'2022_08_30_142256_create_documents_soutien_pedagogiques_table',1),(30,'2022_08_30_145218_create_evaluation_annuelles_table',1),(31,'2022_08_30_145231_create_documents_evaluation_annuelles_table',1),(32,'2022_09_01_123035_create_nature_du_manquements_table',1),(33,'2022_09_01_123358_create_sanctions_table',1),(34,'2022_09_01_123817_create_dossier_disciplinaires_table',1),(35,'2022_09_01_123834_create_documents_dossier_disciplinaires_table',1),(36,'2022_09_01_190319_add_qualification_to_employee',1),(37,'2022_09_06_121303_create_documents_employee',1),(38,'2022_09_06_151106_update_notesto_long_text',1),(39,'2022_09_20_172039_add_team_id_to_subscriptions',1),(40,'2022_10_04_145730_create_parametres_table',1),(41,'2022_10_12_183233_subscription_expiring_mail_sent_at',1),(42,'2022_10_13_142412_add_column_subscription_ends_at_teams_table',1),(43,'2022_10_17_152357_create_parametres_affectations_table',1),(44,'2022_10_17_193515_add_foreign_keys_to_affectations_table',1),(45,'2022_10_17_200846_rename_column_affectation_to_affectations_table',1),(46,'2022_10_18_142315_create_parametres_installations_table',1),(47,'2022_10_18_142525_add_foreign_keys_installation_to_affectations_table',1),(48,'2022_10_18_142862_rename_column_installation_to_affectations_table',1),(49,'2022_10_27_150024_create_roles_table',1),(50,'2022_10_27_150030_create_permissions_table',1),(51,'2022_10_27_150036_create_role_permissions_table',1),(52,'2022_10_27_184822_add_team_id_to_roles_table',1),(53,'2022_11_07_210620_add_columns_to_employees_table',1),(54,'2022_11_08_184213_create_parametres_qualifications_table',1),(55,'2022_11_08_184237_create_parametres_statuts_table',1),(56,'2022_11_17_142632_add_seniority_to_employees_table',1),(57,'2022_12_19_171246_update_qualification_et_status_to_param',1),(58,'2023_01_16_155110_remove_slug_in_roles',1),(59,'2023_01_17_180637_add_title_to_permissions',1),(60,'2023_01_18_145442_change_description_in_role_to_nullable',1),(61,'2023_01_18_183226_add_seniority_updated_at_in_employees',1),(62,'2023_01_19_182931_dividing_adresse_in_five_in_employees',1),(63,'2023_01_30_142344_add_date_anciennete',1),(64,'2023_02_02_192827_nom_equipe_unique',1),(65,'2023_02_02_194254_employee_soft_delete',1),(66,'2023_02_02_194536_teams_soft_delete',1),(67,'2023_04_03_122735_add_team_id_in_receipt',1),(68,'2023_04_03_130859_remove_user_id_receipt',1),(69,'2023_04_11_162932_add_location_info_of_team',1),(70,'2023_05_09_165338_create_nature_absences_table',1),(71,'2023_05_09_170117_create_absences_table',1),(72,'2023_05_09_170129_create_documents_absences_table',1),(73,'2023_05_09_173404_add_parameter_absence_to_team_table',1),(74,'2023_05_10_151451_add_absence_permissions_to_permissions_table',1),(75,'2023_06_07_181014_update_affectations_table_make__f_k_on_delete_null',1),(76,'2023_10_20_173716_update_users_table',1),(77,'2023_12_18_134833_create_documents_invalidites_dossiers_table',1),(78,'2023_12_18_181827_update_documents_invalidites_table',1),(79,'2023_12_19_173627_create_all_dossiers_table',1),(80,'2023_12_19_174205_add_fk_to_documents_table',1),(81,'2024_01_09_141201_create_user_employees_table',1),(82,'2024_02_08_152639_set_reset_password_default_false',1),(83,'2024_03_21_111855_add_williams_on_teams',1),(84,'2024_04_08_113414_ajout_admin_plateforme',1),(85,'2024_04_17_125759_add_phone_on_teams',1),(86,'2024_04_17_131412_add_subscription_william_coop',1),(87,'2024_05_15_210018_create_factures_table',1),(88,'2024_08_30_125337_create_rappels_table',1),(89,'2024_09_04_123217_update_column_rappel',1),(90,'2024_09_04_123757_create_destinataires_rappels_table',1),(91,'2024_09_04_152711_add_team_id_to_rappel',1),(92,'2024_09_04_192654_add_notification_sent_to_rappel',1),(93,'2024_09_17_142720_add_permission_rappel',1),(94,'2024_09_19_145812_add_default_description_rappel_in_all_teams',1),(95,'2024_09_24_173804_ajout_c_q_s_e_p_e_in_user',1),(96,'2024_09_26_135525_update_rappel_table_make_note_long_text',1),(97,'2024_09_26_171428_add_permissions_rappel_par_default_dans_toute_teams',1),(98,'2025_01_20_203818_create_notifications_table',1),(99,'2025_01_20_204010_create_notifications_users_table',1),(100,'2025_01_24_170015_add_lien_to_notifications',1),(101,'2025_01_30_185841_add_sanctum_column',1),(102,'2025_01_31_143034_change_user_receipt_to_invoice',1),(103,'2025_01_31_143556_change_subscription_table',1),(104,'2025_01_31_144454_change_teams_receipt_to_invoice',1),(105,'2025_02_24_204604_add_soft_delete_on_subscription_william',1),(106,'2025_02_24_204702_add_soft_delete_on_rappels',1),(107,'2025_03_24_192534_update_evaluation_annuelles_table',1),(108,'2025_03_24_201044_add_parameter_evaluation_description_to_team_table',1),(109,'2025_04_02_141445_update_formations_table',1),(110,'2025_04_02_141517_add_parameter_formations_hours_to_team_table',1),(111,'2025_04_02_170518_update_employees_table',1),(112,'2025_04_25_125139_update_employees_table',1),(113,'2025_05_07_135504_add_last_connected_date_to_users',1),(114,'2025_05_26_185957_update_absences_table',1),(115,'2025_06_09_112218_add_is_cancelled_to_subscription_williams',1),(116,'2025_07_03_145203_create_activity_log_table',1),(117,'2025_07_03_145204_add_event_column_to_activity_log_table',1),(118,'2025_07_03_145205_add_batch_uuid_column_to_activity_log_table',1),(119,'2025_07_18_000001_add_is_archived_to_employees_table',1),(120,'2025_08_12_000001_create_documents_reglementaires_table',1),(121,'2025_08_12_000002_create_documents_reglementaires_dossiers_table',1),(122,'2025_08_12_000003_add_fk_to_documents_reglementaires_table',1),(123,'2025_10_17_134000_increase_encrypted_column_sizes',1),(124,'2025_10_17_134039_encrypt_employee_sensitive_data',1),(125,'2025_10_17_134100_encrypt_absences_notes',1),(126,'2025_10_17_134112_encrypt_accident_travails_notes',1),(127,'2025_10_17_134143_encrypt_dossier_disciplinaires_sensitive_data',1),(128,'2025_10_17_134157_encrypt_evaluation_annuelles_sensitive_data',1),(129,'2025_10_17_134211_encrypt_formations_notes',1),(130,'2025_10_17_134220_encrypt_invalidites_notes',1),(131,'2025_10_17_134232_encrypt_soutien_pedagogiques_sensitive_data',1),(132,'2025_10_17_150451_add_encryption_to_employee_name_fields',1),(133,'2025_10_17_150514_encrypt_employee_name_fields_data',1),(134,'2025_10_17_150659_add_encryption_to_user_fields',1),(135,'2025_10_17_150706_encrypt_user_fields_data',1),(136,'2025_10_22_171036_change_hours_to_float_in_formations_table',1),(137,'2025_12_08_000001_add_parent_slug_to_permissions_table',1),(138,'2026_01_09_000001_update_destinataires_rappels_user_fk_cascade',1),(139,'2026_01_16_000001_add_company_profile_to_teams_table',1),(140,'2026_02_03_000001_rename_view_admin_permission_title',1),(141,'2026_02_03_000001_update_download_employee_permission_title',1),(142,'2026_04_10_000001_add_gustave_consent_enabled_to_teams_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nature_absences` -- DROP TABLE IF EXISTS `nature_absences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nature_absences` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nature_absences` -- LOCK TABLES `nature_absences` WRITE; /*!40000 ALTER TABLE `nature_absences` DISABLE KEYS */; /*!40000 ALTER TABLE `nature_absences` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nature_du_manquements` -- DROP TABLE IF EXISTS `nature_du_manquements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nature_du_manquements` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nature_du_manquements` -- LOCK TABLES `nature_du_manquements` WRITE; /*!40000 ALTER TABLE `nature_du_manquements` DISABLE KEYS */; /*!40000 ALTER TABLE `nature_du_manquements` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `titre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `message` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `lien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lien_titre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications_users` -- DROP TABLE IF EXISTS `notifications_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications_users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `notification_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `is_read` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_users_notification_id_foreign` (`notification_id`), KEY `notifications_users_user_id_foreign` (`user_id`), CONSTRAINT `notifications_users_notification_id_foreign` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`id`) ON DELETE CASCADE, CONSTRAINT `notifications_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications_users` -- LOCK TABLES `notifications_users` WRITE; /*!40000 ALTER TABLE `notifications_users` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications_users` 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` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `categorie` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 `parametres_affectations` -- DROP TABLE IF EXISTS `parametres_affectations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parametres_affectations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `parametres_affectations` -- LOCK TABLES `parametres_affectations` WRITE; /*!40000 ALTER TABLE `parametres_affectations` DISABLE KEYS */; /*!40000 ALTER TABLE `parametres_affectations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `parametres_installations` -- DROP TABLE IF EXISTS `parametres_installations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parametres_installations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `parametres_installations` -- LOCK TABLES `parametres_installations` WRITE; /*!40000 ALTER TABLE `parametres_installations` DISABLE KEYS */; /*!40000 ALTER TABLE `parametres_installations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `parametres_qualifications` -- DROP TABLE IF EXISTS `parametres_qualifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parametres_qualifications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `parametres_qualifications` -- LOCK TABLES `parametres_qualifications` WRITE; /*!40000 ALTER TABLE `parametres_qualifications` DISABLE KEYS */; /*!40000 ALTER TABLE `parametres_qualifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `parametres_rappel_description` -- DROP TABLE IF EXISTS `parametres_rappel_description`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parametres_rappel_description` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `team_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `parametres_rappel_description_team_id_foreign` (`team_id`), CONSTRAINT `parametres_rappel_description_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `parametres_rappel_description` -- LOCK TABLES `parametres_rappel_description` WRITE; /*!40000 ALTER TABLE `parametres_rappel_description` DISABLE KEYS */; /*!40000 ALTER TABLE `parametres_rappel_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `parametres_statuts` -- DROP TABLE IF EXISTS `parametres_statuts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parametres_statuts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `parametres_statuts` -- LOCK TABLES `parametres_statuts` WRITE; /*!40000 ALTER TABLE `parametres_statuts` DISABLE KEYS */; /*!40000 ALTER TABLE `parametres_statuts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `parent_slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,'view_tableau_absence',NULL,'2026-05-19 18:40:35','2026-05-19 18:40:35','Section absence prolongée - consultation seulement'),(2,'update_tableau_absence',NULL,'2026-05-19 18:40:35','2026-05-19 18:40:35','Section absence prolongée - modification'),(3,'view_rappel',NULL,'2026-05-19 18:40:39','2026-05-19 18:40:39','Section Rappel - consultation seulement'),(4,'update_rappel',NULL,'2026-05-19 18:40:39','2026-05-19 18:40:39','Section Rappel - Modification'); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rappels` -- DROP TABLE IF EXISTS `rappels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rappels` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `employee_id` bigint(20) unsigned NOT NULL, `date` date NOT NULL, `notification_date` date NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `number_days_before_notification` int(11) NOT NULL, `note` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `team_id` bigint(20) unsigned DEFAULT NULL, `notification_is_sent` tinyint(1) NOT NULL DEFAULT '0', `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `rappels_employee_id_foreign` (`employee_id`), KEY `rappels_team_id_foreign` (`team_id`), CONSTRAINT `rappels_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`), CONSTRAINT `rappels_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rappels` -- LOCK TABLES `rappels` WRITE; /*!40000 ALTER TABLE `rappels` DISABLE KEYS */; /*!40000 ALTER TABLE `rappels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `receipts` -- DROP TABLE IF EXISTS `receipts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `receipts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `provider_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `paid_at` timestamp NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `team_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `receipts_provider_id_index` (`provider_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `receipts` -- LOCK TABLES `receipts` WRITE; /*!40000 ALTER TABLE `receipts` DISABLE KEYS */; /*!40000 ALTER TABLE `receipts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_permissions` -- DROP TABLE IF EXISTS `role_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `role_permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role_id` bigint(20) unsigned DEFAULT NULL, `permission_id` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `role_permissions_role_id_foreign` (`role_id`), KEY `role_permissions_permission_id_foreign` (`permission_id`), CONSTRAINT `role_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, CONSTRAINT `role_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_permissions` -- LOCK TABLES `role_permissions` WRITE; /*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `team_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sanctions` -- DROP TABLE IF EXISTS `sanctions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sanctions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sanctions` -- LOCK TABLES `sanctions` WRITE; /*!40000 ALTER TABLE `sanctions` DISABLE KEYS */; /*!40000 ALTER TABLE `sanctions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `soutien_pedagogiques` -- DROP TABLE IF EXISTS `soutien_pedagogiques`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `soutien_pedagogiques` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) unsigned NOT NULL, `date` datetime DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `notes` longtext COLLATE utf8mb4_unicode_ci, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `soutien_pedagogiques` -- LOCK TABLES `soutien_pedagogiques` WRITE; /*!40000 ALTER TABLE `soutien_pedagogiques` DISABLE KEYS */; /*!40000 ALTER TABLE `soutien_pedagogiques` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subscription_items` -- DROP TABLE IF EXISTS `subscription_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subscription_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `subscription_id` bigint(20) unsigned NOT NULL, `stripe_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_product` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `quantity` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `subscription_items_stripe_id_index` (`stripe_id`), KEY `subscription_items_subscription_id_stripe_price_index` (`subscription_id`,`stripe_price`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subscription_items` -- LOCK TABLES `subscription_items` WRITE; /*!40000 ALTER TABLE `subscription_items` DISABLE KEYS */; /*!40000 ALTER TABLE `subscription_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subscriptions` -- DROP TABLE IF EXISTS `subscriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subscriptions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `trial_ends_at` timestamp NULL DEFAULT NULL, `ends_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `team_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `subscriptions_user_id_stripe_status_index` (`stripe_status`), KEY `subscriptions_team_id_foreign` (`team_id`), CONSTRAINT `subscriptions_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subscriptions` -- LOCK TABLES `subscriptions` WRITE; /*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */; /*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subscriptions_william` -- DROP TABLE IF EXISTS `subscriptions_william`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subscriptions_william` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `forfait_id` bigint(20) unsigned NOT NULL, `renewal_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `is_cancelled` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `subscriptions_william_team_id_unique` (`team_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subscriptions_william` -- LOCK TABLES `subscriptions_william` WRITE; /*!40000 ALTER TABLE `subscriptions_william` DISABLE KEYS */; /*!40000 ALTER TABLE `subscriptions_william` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `suivi_evenement_incidents` -- DROP TABLE IF EXISTS `suivi_evenement_incidents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `suivi_evenement_incidents` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) unsigned NOT NULL, `date` datetime DEFAULT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `suivi_evenement_incidents` -- LOCK TABLES `suivi_evenement_incidents` WRITE; /*!40000 ALTER TABLE `suivi_evenement_incidents` DISABLE KEYS */; /*!40000 ALTER TABLE `suivi_evenement_incidents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tax_rates` -- DROP TABLE IF EXISTS `tax_rates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tax_rates` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `stripe_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `percentage` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `tax_rates_stripe_id_index` (`stripe_id`), KEY `tax_rates_percentage_index` (`percentage`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tax_rates` -- LOCK TABLES `tax_rates` WRITE; /*!40000 ALTER TABLE `tax_rates` DISABLE KEYS */; /*!40000 ALTER TABLE `tax_rates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `team_invitations` -- DROP TABLE IF EXISTS `team_invitations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `team_invitations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `team_invitations_team_id_email_unique` (`team_id`,`email`), CONSTRAINT `team_invitations_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `team_invitations` -- LOCK TABLES `team_invitations` WRITE; /*!40000 ALTER TABLE `team_invitations` DISABLE KEYS */; /*!40000 ALTER TABLE `team_invitations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `team_user` -- DROP TABLE IF EXISTS `team_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `team_user` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `team_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `team_user_team_id_user_id_unique` (`team_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `team_user` -- LOCK TABLES `team_user` WRITE; /*!40000 ALTER TABLE `team_user` DISABLE KEYS */; /*!40000 ALTER TABLE `team_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `teams` -- DROP TABLE IF EXISTS `teams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `teams` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `personal_team` tinyint(1) NOT NULL, `stripe_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pm_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pm_last_four` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pm_expiration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `extra_billing_information` text COLLATE utf8mb4_unicode_ci, `trial_ends_at` timestamp NULL DEFAULT NULL, `billing_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_address_line_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_postal_code` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `vat_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `invoice_emails` text COLLATE utf8mb4_unicode_ci, `billing_country` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `subscription_expiring_mail_sent_at` timestamp NULL DEFAULT NULL, `subscription_ends_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postal_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `williamsCoopNumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isWilliamsCoop` tinyint(1) NOT NULL DEFAULT '0', `isRegisterApproved` tinyint(1) NOT NULL DEFAULT '0', `williamsForfaitNameAsking` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_type_other` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isCQSEPE` tinyint(1) DEFAULT '0', `gustave_consent_enabled` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `teams_name_unique` (`name`), KEY `teams_user_id_index` (`user_id`), KEY `teams_stripe_id_index` (`stripe_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `teams` -- LOCK TABLES `teams` WRITE; /*!40000 ALTER TABLE `teams` DISABLE KEYS */; /*!40000 ALTER TABLE `teams` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_employees` -- DROP TABLE IF EXISTS `user_employees`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_employees` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `employee_id` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_employees_user_id_foreign` (`user_id`), KEY `user_employees_employee_id_foreign` (`employee_id`), CONSTRAINT `user_employees_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`), CONSTRAINT `user_employees_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_employees` -- LOCK TABLES `user_employees` WRITE; /*!40000 ALTER TABLE `user_employees` DISABLE KEYS */; /*!40000 ALTER TABLE `user_employees` 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` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` longtext COLLATE utf8mb4_unicode_ci, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `two_factor_secret` text COLLATE utf8mb4_unicode_ci, `two_factor_recovery_codes` text COLLATE utf8mb4_unicode_ci, `two_factor_confirmed_at` timestamp NULL DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `stripe_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pm_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pm_last_four` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pm_expiration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `extra_billing_information` text COLLATE utf8mb4_unicode_ci, `trial_ends_at` timestamp NULL DEFAULT NULL, `billing_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_address_line_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_postal_code` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `vat_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `invoice_emails` text COLLATE utf8mb4_unicode_ci, `billing_country` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `current_team_id` bigint(20) unsigned DEFAULT NULL, `profile_photo_path` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `reset_password` tinyint(1) NOT NULL DEFAULT '0', `IsAppAdmin` tinyint(1) NOT NULL DEFAULT '0', `lastConnectedDate` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), KEY `users_stripe_id_index` (`stripe_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 */; /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'garderie' -- -- -- Dumping routines for database 'garderie' -- /*!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 2026-08-28 14:17:41