-- MySQL dump 10.13 Distrib 5.7.35, for Linux (x86_64) -- -- Host: localhost Database: deenalor -- ------------------------------------------------------ -- Server version 5.7.35-0ubuntu0.18.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `ad_partenaire` -- DROP TABLE IF EXISTS `ad_partenaire`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ad_partenaire` ( `id` int(11) NOT NULL AUTO_INCREMENT, `partenaire_id` int(11) DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CD76F0C998DE13AC` (`partenaire_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ad_partenaire` -- LOCK TABLES `ad_partenaire` WRITE; /*!40000 ALTER TABLE `ad_partenaire` DISABLE KEYS */; INSERT INTO `ad_partenaire` VALUES (1,1,'clinique@gmail.com','2021-10-04 20:02:24','2021-10-04 20:02:24'),(2,2,'sen-contact@gmail.com','2021-10-06 15:58:04','2021-10-06 15:58:04'); /*!40000 ALTER TABLE `ad_partenaire` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cas` -- DROP TABLE IF EXISTS `cas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cas` ( `id` int(11) NOT NULL AUTO_INCREMENT, `victime_id` int(11) DEFAULT NULL, `region_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `type_violence_id` int(11) DEFAULT NULL, `forme_violence_id` int(11) DEFAULT NULL, `statut` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `observation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_3AD60BFDBA9414` (`forme_violence_id`), KEY `IDX_3AD60BA76ED395` (`user_id`), KEY `IDX_3AD60B75FF0F4B` (`victime_id`), KEY `IDX_3AD60BBF7F3110` (`type_violence_id`), KEY `IDX_3AD60B98260155` (`region_id`), CONSTRAINT `FK_3AD60B75FF0F4B` FOREIGN KEY (`victime_id`) REFERENCES `victime` (`id`), CONSTRAINT `FK_3AD60B98260155` FOREIGN KEY (`region_id`) REFERENCES `region` (`id`), CONSTRAINT `FK_3AD60BA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`), CONSTRAINT `FK_3AD60BBF7F3110` FOREIGN KEY (`type_violence_id`) REFERENCES `type_violence` (`id`), CONSTRAINT `FK_3AD60BFDBA9414` FOREIGN KEY (`forme_violence_id`) REFERENCES `forme_violence` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cas` -- LOCK TABLES `cas` WRITE; /*!40000 ALTER TABLE `cas` DISABLE KEYS */; /*!40000 ALTER TABLE `cas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cron_job` -- DROP TABLE IF EXISTS `cron_job`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cron_job` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `command` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL, `schedule` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `enabled` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `un_name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cron_job` -- LOCK TABLES `cron_job` WRITE; /*!40000 ALTER TABLE `cron_job` DISABLE KEYS */; INSERT INTO `cron_job` VALUES (1,'mailRappel','app:cron-mail','*/5 * * * *','Job pour le mail automatique de rappel',1); /*!40000 ALTER TABLE `cron_job` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cron_report` -- DROP TABLE IF EXISTS `cron_report`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cron_report` ( `id` int(11) NOT NULL AUTO_INCREMENT, `job_id` int(11) DEFAULT NULL, `run_at` datetime NOT NULL, `run_time` double NOT NULL, `exit_code` int(11) NOT NULL, `output` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `IDX_B6C6A7F5BE04EA9` (`job_id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cron_report` -- LOCK TABLES `cron_report` WRITE; /*!40000 ALTER TABLE `cron_report` DISABLE KEYS */; INSERT INTO `cron_report` VALUES (1,1,'2021-09-27 11:05:00',4.0876019001007,0,'User Creator\r\n============\r\n\r\n\nWhoa!\r\nYou are about to \ncreate a user.'),(2,1,'2021-09-27 11:30:00',3.8165731430054,0,'User Creator\r\n============\r\n\r\n\nWhoa!\r\nYou are about to create a user.'),(3,1,'2021-09-27 11:35:00',0.42580199241638,0,'User Creator\r\n============\r\n\r\n\nWhoa!\r\nYou are about to create a user.'),(4,1,'2021-09-27 11:40:00',0.3467710018158,0,'User Creator\r\n============\r\n\r\n\nWhoa!\r\nYou are about to create a user.'),(5,1,'2021-09-27 11:45:00',0.33942103385925,0,'User Creator\r\n============\r\n\r\n\nWhoa!\r\nYou are about to create a user.'),(6,1,'2021-09-27 11:50:00',3.099044084549,0,'User Creator\r\n============\r\n\r\n\nWhoa!\r\nYou are about to create a user.'),(7,1,'2021-09-27 11:55:00',7.8330800533295,0,'User Creator\r\n============\r\n\n\r\n\nWhoa!\r\nYou are about to create a user.'),(8,1,'2021-09-28 20:10:00',0.5085620880127,1,''),(9,1,'2021-09-28 20:15:00',0.41996693611145,1,''),(10,1,'2021-09-29 16:00:00',13.564006090164,0,'User Creator\r\n============\r\n\r\n\n3\r\n\nSignalDaouda Zella\r\n\nUserSome\r\n\nUserOuedraogo\r\n\nSignalPotter Son\r\n\nUserSome\r\n\nUserOuedraogo\r\n\nSignalHenri ZOngo\r\nUserSome\r\n\nUserOuedraogo\r\n\nWhoa!\r\nYou are about to create a user.'),(11,1,'2021-09-29 16:05:00',9.3270578384399,0,'User Creator\r\n============\r\n\r\n\n3\r\n\nSignalDaouda Zella\r\n\nUserSome\r\n\nUserOuedraogo\r\n\nSignalPotter Son\r\nUserSome\r\n\nUserOuedraogo\r\n\nSignalHenri ZOngo\r\nUserSome\r\n\nUserOuedraogo\r\n\nWhoa!\r\nYou are about to \ncreate a user.'),(12,1,'2021-09-29 16:10:00',8.9799699783325,0,'User Creator\r\n============\r\n\r\n\n3\r\n\nSignalDaouda Zella\r\n\nUserSome\r\n\nUserOuedraogo\r\n\nSignalPotter Son\r\nUserSome\r\n\nUserOuedraogo\r\n\nSignalHenri ZOngo\r\nUserSome\r\n\nUserOuedraogo\r\n\nWhoa!\r\nYou are about to \ncreate a user.'),(13,1,'2021-09-29 16:15:00',9.305233001709,0,'User Creator\r\n============\r\n\r\n\n3\r\n\nSignalDaouda Zella\r\n\nUserSome\r\n\nUserOuedraogo\r\n\nSignalPotter Son\r\nUserSome\r\n\nUserOuedraogo\r\n\nSignalHenri ZOngo\r\nUserSome\r\n\nUserOuedraogo\r\n\nWhoa!\r\nYou are about to \ncreate a user.'),(14,1,'2021-09-29 16:20:00',9.5921249389648,0,'User Creator\r\n============\r\n\r\n\n3\r\n\nSignalDaouda Zella\r\n\nUserSome\r\n\nUserOuedraogo\r\n\nSignalPotter Son\r\n\nUserSome\r\n\nUserOuedraogo\r\n\nSignalHenri ZOngo\r\n\nUserSome\r\n\nUserOuedraogo\r\n\nWhoa!\r\n\nYou are about to create a user.'); /*!40000 ALTER TABLE `cron_report` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `doctrine_migration_versions` -- DROP TABLE IF EXISTS `doctrine_migration_versions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `doctrine_migration_versions` ( `version` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `executed_at` datetime DEFAULT NULL, `execution_time` int(11) DEFAULT NULL, PRIMARY KEY (`version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `doctrine_migration_versions` -- LOCK TABLES `doctrine_migration_versions` WRITE; /*!40000 ALTER TABLE `doctrine_migration_versions` DISABLE KEYS */; INSERT INTO `doctrine_migration_versions` VALUES ('DoctrineMigrations\\Version20210823201325','2021-08-23 20:13:31',39474); /*!40000 ALTER TABLE `doctrine_migration_versions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `etat` -- DROP TABLE IF EXISTS `etat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `etat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `libelle` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT 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 `etat` -- LOCK TABLES `etat` WRITE; /*!40000 ALTER TABLE `etat` DISABLE KEYS */; INSERT INTO `etat` VALUES (1,'non_prise','Non pris en charge','2021-09-01 13:18:15','2021-09-01 13:18:15'),(2,'en_cours','En cours','2021-09-01 13:18:47','2021-09-01 13:18:47'),(3,'termines','Terminé','2021-09-01 13:19:19','2021-09-01 13:19:19'),(4,'reference','Reférencé','2021-09-01 13:19:45','2021-09-01 13:19:45'); /*!40000 ALTER TABLE `etat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `etat_cas` -- DROP TABLE IF EXISTS `etat_cas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `etat_cas` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cas_id` int(11) DEFAULT NULL, `etat_id` int(11) DEFAULT NULL, `date` datetime DEFAULT NULL, `user1` varchar(50) DEFAULT NULL, `user2` varchar(50) DEFAULT NULL, `sharable` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_46E10F937B7A91FA` (`cas_id`), KEY `IDX_46E10F93D5E86FF` (`etat_id`) ) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `etat_cas` -- LOCK TABLES `etat_cas` WRITE; /*!40000 ALTER TABLE `etat_cas` DISABLE KEYS */; INSERT INTO `etat_cas` VALUES (1,14,1,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,1,NULL,NULL,NULL,NULL,NULL,NULL),(3,2,1,NULL,NULL,NULL,NULL,NULL,NULL),(4,3,1,NULL,NULL,NULL,NULL,NULL,NULL),(5,4,1,NULL,NULL,NULL,NULL,NULL,NULL),(6,5,1,NULL,NULL,NULL,NULL,NULL,NULL),(7,6,1,NULL,NULL,NULL,NULL,NULL,NULL),(8,7,1,NULL,NULL,NULL,NULL,NULL,NULL),(9,8,1,NULL,NULL,NULL,NULL,NULL,NULL),(10,9,1,NULL,NULL,NULL,NULL,NULL,NULL),(11,10,1,NULL,NULL,NULL,NULL,NULL,NULL),(12,11,1,NULL,NULL,NULL,NULL,NULL,NULL),(13,12,1,NULL,NULL,NULL,NULL,NULL,NULL),(14,3,2,NULL,'henri',NULL,NULL,NULL,NULL),(15,1,2,NULL,'henri',NULL,NULL,NULL,NULL),(16,2,2,NULL,'henri',NULL,NULL,NULL,NULL),(17,12,2,NULL,'henri',NULL,NULL,NULL,NULL),(18,8,2,NULL,'henri',NULL,NULL,NULL,NULL),(19,15,1,NULL,NULL,NULL,NULL,NULL,NULL),(20,4,2,NULL,'henri',NULL,NULL,'2021-09-09 10:48:18','2021-09-09 10:48:18'),(21,7,2,NULL,'henri',NULL,NULL,'2021-09-13 16:21:44','2021-09-13 16:21:44'),(22,16,1,NULL,NULL,NULL,NULL,'2021-09-16 07:17:22','2021-09-16 07:17:22'),(23,17,1,NULL,NULL,NULL,NULL,'2021-09-21 18:16:51','2021-09-21 18:16:51'),(24,18,1,NULL,NULL,NULL,NULL,'2021-09-21 18:50:51','2021-09-21 18:50:51'),(25,18,2,NULL,'henri',NULL,NULL,'2021-09-21 18:59:15','2021-09-21 18:59:15'),(26,14,2,NULL,'test3',NULL,NULL,'2021-09-23 09:34:17','2021-09-23 09:34:17'),(27,15,2,NULL,'test3',NULL,NULL,'2021-09-23 10:01:06','2021-09-23 10:01:06'),(28,10,4,NULL,'2',NULL,NULL,'2021-09-25 11:53:28','2021-09-25 11:53:28'),(29,9,4,NULL,'2',NULL,NULL,'2021-09-25 12:05:55','2021-09-25 12:05:55'),(30,19,1,NULL,NULL,NULL,NULL,'2021-09-27 15:52:05','2021-09-27 15:52:05'),(31,19,2,NULL,'test4',NULL,NULL,'2021-09-27 15:52:45','2021-09-27 15:52:45'),(32,5,2,NULL,'test10',NULL,NULL,'2021-09-29 11:05:00','2021-09-29 11:05:00'),(33,11,2,NULL,'test10',NULL,NULL,'2021-09-29 12:01:47','2021-09-29 12:01:47'),(34,6,2,NULL,'test10',NULL,NULL,'2021-09-29 15:10:40','2021-09-29 15:10:40'),(35,20,1,NULL,NULL,NULL,NULL,'2021-10-01 14:52:41','2021-10-01 14:52:41'),(36,14,3,NULL,'test3',NULL,NULL,'2021-10-06 10:35:25','2021-10-06 10:35:25'),(37,14,4,NULL,'test3',NULL,NULL,'2021-10-06 16:18:49','2021-10-06 16:18:49'),(38,2,3,NULL,'test3',NULL,NULL,'2021-10-06 09:50:13','2021-10-06 09:50:13'),(39,9,2,NULL,'test2',NULL,NULL,'2021-10-09 13:35:33','2021-10-09 13:35:33'); /*!40000 ALTER TABLE `etat_cas` ENABLE KEYS */; UNLOCK TABLES; ALTER DATABASE `deenalor` CHARACTER SET latin1 COLLATE latin1_swedish_ci ; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `update_etat` AFTER INSERT ON etat_cas FOR EACH ROW BEGIN DECLARE etat_code VARCHAR(50); select `code` into etat_code from etat e where e.id=new.etat_id; update `signal` set dernetat=etat_code, ddernetat=now(), userc=new.user1 where id=NEW.cas_id; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; ALTER DATABASE `deenalor` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ; -- -- Table structure for table `forme_violence` -- DROP TABLE IF EXISTS `forme_violence`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `forme_violence` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type_violence_id` int(11) DEFAULT NULL, `forme` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_A9FBCDBEBF7F3110` (`type_violence_id`), CONSTRAINT `FK_A9FBCDBEBF7F3110` FOREIGN KEY (`type_violence_id`) REFERENCES `type_violence` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `forme_violence` -- LOCK TABLES `forme_violence` WRITE; /*!40000 ALTER TABLE `forme_violence` DISABLE KEYS */; INSERT INTO `forme_violence` VALUES (1,3,'Tentative de viol',NULL,NULL),(2,3,'Viol',NULL,NULL),(3,3,'Agression sexuelle',NULL,NULL),(4,3,'Exploitation sexuelle',NULL,NULL),(5,3,'Prostitution forcé',NULL,NULL),(6,3,'Trafic à but d\'exploitation sexuelle',NULL,NULL),(7,4,'Coup et blessures',NULL,NULL),(8,4,'Séquestration',NULL,NULL),(9,4,'Assassinat ou meurtre',NULL,NULL),(10,6,'Injure',NULL,NULL),(11,6,'Intimidation',NULL,NULL),(12,6,'Dénigrement',NULL,NULL),(13,6,'Chantage',NULL,NULL),(14,6,'Harcèlement',NULL,NULL),(15,6,'Manipulation ',NULL,NULL),(16,6,'Discrimination',NULL,NULL),(17,6,'Polygamie',NULL,NULL),(18,7,'Mariage précoce',NULL,NULL),(19,7,'Mutilations génitales féminines',NULL,NULL),(20,7,'Mariage forcé',NULL,NULL),(21,5,'Déni de ressources ou d\'opportunités ou de services',NULL,NULL),(22,5,'Abandon de famille ou de domicile conjugal',NULL,NULL),(23,5,'Proxénétisme',NULL,NULL),(24,5,'Travail des enfants',NULL,NULL),(25,5,'Exploitation par la mendicité',NULL,NULL),(26,8,'Autre',NULL,NULL); /*!40000 ALTER TABLE `forme_violence` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `forme_violence_translation` -- DROP TABLE IF EXISTS `forme_violence_translation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `forme_violence_translation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `source_id` int(11) DEFAULT NULL, `locale` varchar(5) DEFAULT NULL, `forme` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_BD9D5FC5953C1C61` (`source_id`) ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `forme_violence_translation` -- LOCK TABLES `forme_violence_translation` WRITE; /*!40000 ALTER TABLE `forme_violence_translation` DISABLE KEYS */; INSERT INTO `forme_violence_translation` VALUES (1,1,'ar','مبدئي دي فيول','2021-10-25 20:22:07','2021-10-25 20:22:07'),(2,2,'ar','اغتصاب','2021-10-25 20:22:07','2021-10-25 20:22:07'),(3,3,'ar','اعتداء جنسي','2021-10-25 20:22:07','2021-10-25 20:22:07'),(4,4,'ar','الاستغلال الجنسي','2021-10-25 20:22:07','2021-10-25 20:22:07'),(5,5,'ar','الدعارة القسرية','2021-10-25 20:22:07','2021-10-25 20:22:07'),(6,6,'ar','الاتجار لأغراض الاستغلال الجنسي','2021-10-25 20:22:07','2021-10-25 20:22:07'),(7,7,'ar','ضربة وجروح','2021-10-25 20:22:07','2021-10-25 20:22:07'),(8,8,'ar','المصادرة','2021-10-25 20:22:07','2021-10-25 20:22:07'),(9,9,'ar','- الاغتيال أو القتل','2021-10-25 20:22:07','2021-10-25 20:22:07'),(10,10,'ar','يسب','2021-10-25 20:22:07','2021-10-25 20:22:07'),(11,11,'ar','التخويف','2021-10-25 20:22:07','2021-10-25 20:22:07'),(12,12,'ar','تشويه','2021-10-25 20:22:07','2021-10-25 20:22:07'),(13,13,'ar','ابتزاز','2021-10-25 20:22:07','2021-10-25 20:22:07'),(14,14,'ar','تنمر','2021-10-25 20:22:07','2021-10-25 20:22:07'),(15,15,'ar','معالجة','2021-10-25 20:22:07','2021-10-25 20:22:07'),(16,16,'ar','التمييز','2021-10-25 20:22:07','2021-10-25 20:22:07'),(17,17,'ar','تعدد الزوجات','2021-10-25 20:22:07','2021-10-25 20:22:07'),(18,18,'ar','الزواج المبكر','2021-10-25 20:22:07','2021-10-25 20:22:07'),(19,19,'ar','تشويه الأعضاء التناسلية للإناث','2021-10-25 20:22:07','2021-10-25 20:22:07'),(20,20,'ar','الزواج القسري','2021-10-25 20:22:07','2021-10-25 20:22:07'),(21,21,'ar','الحرمان من الموارد أو الفرص أو الخدمات','2021-10-25 20:22:07','2021-10-25 20:22:07'),(22,22,'ar','هجر الأسرة أو بيت الزوجية','2021-10-25 20:22:07','2021-10-25 20:22:07'),(23,23,'ar','القوادة','2021-10-25 20:22:07','2021-10-25 20:22:07'),(24,24,'ar','عمالة الأطفال','2021-10-25 20:22:07','2021-10-25 20:22:07'),(25,25,'ar','الاستغلال من خلال التسول','2021-10-25 20:22:07','2021-10-25 20:22:07'),(26,26,'ar','آخر','2021-10-25 20:22:07','2021-10-25 20:22:07'),(27,1,'en','Tentative de viol','2021-10-25 20:22:32','2021-10-25 20:22:32'),(28,2,'en','Rape','2021-10-25 20:22:32','2021-10-25 20:22:32'),(29,3,'en','Sexual assault','2021-10-25 20:22:32','2021-10-25 20:22:32'),(30,4,'en','Sexual exploitation','2021-10-25 20:22:32','2021-10-25 20:22:32'),(31,5,'en','Forced prostitution','2021-10-25 20:22:32','2021-10-25 20:22:32'),(32,6,'en','Trafficking for sexual exploitation','2021-10-25 20:22:32','2021-10-25 20:22:32'),(33,7,'en','Blow and wounds','2021-10-25 20:22:32','2021-10-25 20:22:32'),(34,8,'en','Sequestration','2021-10-25 20:22:32','2021-10-25 20:22:32'),(35,9,'en','Assassination or murder','2021-10-25 20:22:32','2021-10-25 20:22:32'),(36,10,'en','Insult','2021-10-25 20:22:32','2021-10-25 20:22:32'),(37,11,'en','Intimidation','2021-10-25 20:22:32','2021-10-25 20:22:32'),(38,12,'en','Denigration','2021-10-25 20:22:32','2021-10-25 20:22:32'),(39,13,'en','Blackmail','2021-10-25 20:22:32','2021-10-25 20:22:32'),(40,14,'en','Bullying','2021-10-25 20:22:32','2021-10-25 20:22:32'),(41,15,'en','Handling','2021-10-25 20:22:32','2021-10-25 20:22:32'),(42,16,'en','Discrimination','2021-10-25 20:22:32','2021-10-25 20:22:32'),(43,17,'en','Polygamy','2021-10-25 20:22:32','2021-10-25 20:22:32'),(44,18,'en','Early marriage','2021-10-25 20:22:32','2021-10-25 20:22:32'),(45,19,'en','Female genital mutilation','2021-10-25 20:22:32','2021-10-25 20:22:32'),(46,20,'en','Forced marriage','2021-10-25 20:22:32','2021-10-25 20:22:32'),(47,21,'en','Denial of resources or opportunities or services','2021-10-25 20:22:32','2021-10-25 20:22:32'),(48,22,'en','Abandonment of family or marital home','2021-10-25 20:22:32','2021-10-25 20:22:32'),(49,23,'en','Procuring','2021-10-25 20:22:32','2021-10-25 20:22:32'),(50,24,'en','Child labor','2021-10-25 20:22:32','2021-10-25 20:22:32'),(51,25,'en','Exploitation through begging','2021-10-25 20:22:32','2021-10-25 20:22:32'),(52,26,'en','Other','2021-10-25 20:22:32','2021-10-25 20:22:32'); /*!40000 ALTER TABLE `forme_violence_translation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `params` -- DROP TABLE IF EXISTS `params`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `params` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cle` varchar(50) DEFAULT NULL, `lib` varchar(255) DEFAULT NULL, `ctab` varchar(10) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `params` -- LOCK TABLES `params` WRITE; /*!40000 ALTER TABLE `params` DISABLE KEYS */; INSERT INTO `params` VALUES (1,'ref_inc','Référence de l\'incident','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(2,'code_surv','Code du survivant','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(3,'code_user','Code travailleur social','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(4,'date_ent','Date de l’entretien','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(5,'date_inc','Date de l’incident','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(6,'dec_inc','Declarant de l\'incident','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(7,'surv','Déclaré par le/la survivant(e) ou la personne qui accompagne le/la survivant(e) en présence du/de la survivant(e)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(8,'autr_per','Déclaré par une personne autre que le/la survivant(e), en l’absence du/de la survivant(e)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(9,'date_nais','Date de naissance','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(10,'sexe','Sexe','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(11,'ethnie','Clan ou appartenance ethnique','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(12,'pays_org','Pays d\'origine','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(13,'nation','Nationalité','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(14,'religion','Religion','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(15,'etat_civ','Etat civil / situation familiale actuel(le)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(16,'celibat','Celibataire','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(17,'marie','Marié(e) / en concubinage','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(18,'divorce','Divorcé(e) / Séparé(e)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(19,'veuf','Veuf / veuve','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(20,'nbre_enf','Nombre et âge des enfants et autres personnes à charge','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(21,'prof','Profession','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(22,'stat_depl','Statut de déplacement au moment de la déclaration des faits','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(23,'resident','Resident(e)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(24,'pdip','PDIP','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(25,'refugie','Réfugié(e)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(26,'apatride','Apatride','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(27,'rapatrie','Rapatrié(e)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(28,'res_entr','Ressortissant(e) étranger/ère','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(29,'dem_asil','Demandeur/se d’asile','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(30,'neant','Neant','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(31,'est_hand','Le/la bénéficiaire est-il/elle une personne handicapée','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(32,'oui','Oui','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(33,'non','Non','R001','2021-09-10 13:00:52','2021-10-09 17:31:26'),(34,'precise','Precisez','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(35,'hand_ment','Handicap mental','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(36,'hand_phys','Handicap physique','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(37,'les_deux','Les deux','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(38,'est_min','Le/la bénéficiaire est-il/elle un mineur non accompagné, un enfant séparé ou un autre enfant vulnérable','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(39,'min_nacc','Mineur(e) non accompagné(e)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(40,'enf_sep','Enfant séparé(e)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(41,'autr_enf','Autre enfant vulnérable','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(42,'surv_viseul','Si le/la survivant(e) est un/une enfant (moins de 18 ans), vit-il/elle seul(e)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(43,'lien_parent','Si le/la survivant(e) vit avec quelqu’un d’autre, quel est le lien de parenté entre lui/elle et la personne qui s’occupe de lui/d’elle','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(44,'parent_tut','Parent / tuteur','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(45,'mbre_fmlle','Membre de la famille','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(46,'conjoint','Conjoint / concubin','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(47,'autre','Autres','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(48,'sit_fmlle','Quelle est la situation familiale actuelle de la personne qui s’occupe du/de la survivant(e)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(49,'inconue','Inconnue / sans objet','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(50,'activ_princ','Quelle est l’activité professionnelle principale de la personne qui s’occupe du/de la survivant(e)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(51,'desc_inc','Récit de l’incident / description de l’incident (résumez les détails de l’incident dans les termes employés par le/la bénéficiaire)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(52,'phase_depl','Phase de déplacement au moment des faits','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(53,'non_depl','Non déplacé(e) / communauté d\'origine','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(54,'enc_fuite','En cours de fuite','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(55,'enc_raptrmt','En cours de rapatriement / en transit','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(56,'pre_depl','Pré-déplacement','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(57,'post_depl','Post-déplacement','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(58,'period_refug','En période de refuge','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(59,'heure_inc','Heure de l’incident','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(60,'matin','Matin (entre le lever du soleil et midi)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(61,'ap_midi','Après-midi (entre midi et le coucher du soleil)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(62,'soir','Soir/nuit (entre le coucher du soleil et le lever du soleil)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(63,'lieu_inc','Lieu de l’incident','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(64,'brousse','Brousse / forêt','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(65,'jard_champ','Jardin / champ cultivé','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(66,'ecole','Ecole','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(67,'route','Route','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(68,'dom_ben','Domicile du/de la bénéficiaire','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(69,'dom_agres','Domicile de l’agresseur','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(70,'aut_lieu','Autres lieu','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(71,'typ_viol','Type de violence survenue au cours de l’incident','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(72,'viol','Viol','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(73,'agres_sex','Agression sexuelle','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(74,'agres_phys','Agression physique','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(75,'mar_forc','Mariage forcé','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(76,'den_res','Déni de ressources, d’opportunités ou de services','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(77,'viol_psych','Violences psychologiques / émotionnelles','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(78,'hors_vbg','Hors VBG Note','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(79,'prec_typv','Autre type violence','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(80,'inc_prej','Cet incident constituait-il une Pratique traditionnelle préjudiciable','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(81,'mgf_e','MGF/E','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(82,'exig_dot','Exigences dotales','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(83,'pref_fils','Préférence pour les fils','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(84,'echange','De l’argent, des biens, des avantages et/ou des services ont-ils été échangés en rapport avec cet incident','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(85,'typ_enlev','Type d’enlèvement au moment des faits','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(86,'aucun','Aucun','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(87,'cons_force','Conscription forcée','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(88,'trafic','Trafic','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(89,'autr_kidnap','Autre enlèvement/kidnapping','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(90,'inc_decl','Le/la bénéficiaire a-t-il/elle déclaré cet incident ailleurs','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(91,'serv_sant','Services de santé/médicaux','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(92,'serv_psych','Services de suivi psychologique/soutien psychosocial','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(93,'police_sec','Police/autre acteur du secteur de la sécurité','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(94,'ass_jurd','Services d’assistance juridique','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(95,'pgme_sout','Programme de soutien aux moyens de subsistance','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(96,'lieu_sur','Lieu sûr/refuge','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(97,'aut_aidhum','Autre acteur de l’aide humanitaire/au développement','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(98,'autr_servp','Autres services publics','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(99,'vict_prec','Le/la bénéficiaire a-t-il/elle précédemment été victime d’autres incidents de VBG?','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(100,'desc_cons','Si oui, ajoutez une description concise','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(101,'nbre_prsum','Nombre d’agresseurs présumés','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(102,'sex_agress','Sexe du ou des agresseur(s) présumé(s)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(103,'fm','Agresseurs à la fois de sexe féminin et de sexe masculin','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(104,'nat_agress','Nationalité de l’agresseur présumé','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(105,'ethn_agress','Clan ou appartenance ethnique de l’agresseur présumé','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(106,'trch_ageagres','Tranche d’âge de l’agresseur présumé','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(107,'0-11','0 – 11 ans','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(108,'12-17','12 – 17 ans','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(109,'18-25','18 – 25 ans','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(110,'26-40','26 – 40 ans','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(111,'41-60','41-60 ans','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(112,'61-','61 ans et plus','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(113,'inconnu','Inconnue','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(114,'lienp_agress','Lien entre l’agresseur présumé et le/la survivant(e)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(115,'part_intim','Partenaire intime / ex-partenaire','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(116,'poccup_surv','Principale personne s’occupant du/de la survivant(e)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(117,'fmlle_ou_p','Membre de la famille (hors conjoint ou personne s’occupant du/de la survivant(e))','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(118,'superv_emp','Superviseur / employeur','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(119,'cam_class','Camarade de classe','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(120,'enseign','Enseignant / responsable scolaire','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(121,'prest_serv','Prestataire de services','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(122,'colocataire','Colocataire','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(123,'ami_vois','Ami de la famille / voisin','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(124,'ref_rapat','Autre réfugié / PDIP / rapatrié','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(125,'mbre_comm','Autre membre de la communauté résidente','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(126,'autr_mbre','Autres membre','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(127,'san_lien','Sans lien','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(128,'activ_agress','Principale activité professionnelle de l’agresseur présumé','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(129,'fermier','Fermier','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(130,'etudiant','Etudiant','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(131,'fonctionnaire','Fonctionnaire','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(132,'policier','Policier','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(133,'sold_arm','Soldat de l’armée','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(134,'comm_prop','Commerçant / propriétaire d’entreprise','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(135,'acteur_netat','Acteur armé non-étatique','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(136,'forc_sec','Représentant des forces de sécurité','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(137,'lead_reli','Leader du camp ou de la communauté','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(138,'dign_reli','Dignitaire religieux','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(139,'emp_nuni','Employé des Nations unies','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(140,'emp_ong','Employé d’une ONG','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(141,'ben_comm','Bénévole communautaire','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(142,'trav_sant','Travailleur de la santé','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(143,'san_emp','Sans emploi','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(144,'autr_actagres','Autres','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(145,'addres_benef','Qui vous a adressé ce/cette bénéficiaire','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(146,'auto_renv','Auto-renvoi/premier point de contact','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(147,'ens_resps','Enseignant/responsable scolaire','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(148,'lead_comm','Leader de la communauté ou du camp','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(149,'autr_act','Autre acteur de l’aide humanitaire ou de l’aide au développement','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(150,'prec_addben','Precisez','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(151,'renv_refg','Avez-vous renvoyé le/la bénéficiaire vers un lieu sûr/un refuge','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(152,'pourq_refg','Si non, pourquoi','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(153,'serv_assur','Service assuré par votre organisme','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(154,'serv_dejassur','Services déjà assurés par un autre organisme','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(155,'serv_unit','Service inutile','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(156,'rev_dec','Renvoi décliné par le/la survivant(e)','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(157,'serv_disp','Service non disponible','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(158,'date_rdvrfg','Date rapportée ou date et heure du rendez-vous à venir (jour/mois/année)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(159,'nlieu_rfg','Nom et lieu (lieu de refuge)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(160,'note_lieurfg','Notes (notamment concernant les mesures prises ou recommandées)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(161,'renv_servsant','Avez-vous renvoyé le/la bénéficiaire vers des services de santé / médicaux','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(162,'renv_servpsych','Avez-vous renvoyé le/la bénéficiaire vers des services de soutien psychosocial','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(163,'eng_just','Le/la bénéficiaire souhaite-t-il/elle engager des poursuites en justice','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(164,'pas_dcid','N’a pas encore décidé au moment de la déclaration des faits','R001','2021-09-10 13:00:52','2021-09-10 13:00:52'),(165,'renv_servjurd','Avez-vous renvoyé le/la bénéficiaire vers des services d’assistance juridique','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(166,'renv_police','Avez-vous renvoyé le/la bénéficiaire vers la police ou un autre type d’acteur du secteur de la sécurité','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(167,'renv_prgsout','Avez-vous renvoyé le/la bénéficiaire vers un programme de soutien aux moyens de subsistance','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(168,'etatem_debent','Décrivez l’état émotionnel du/de la bénéficiaire au début de l’entretien','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(169,'ben_ensec','Le/la bénéficiaire sera-t-il/elle en sécurité lorsqu’il/elle partira','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(170,'pq_passec','Si non, expliquez pourquoi pas en securité','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(171,'mes_prise','Quelles mesures ont été prises pour assurer la sécurité du/de la bénéficiaire','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(172,'etatem_finent','Décrivez l’état émotionnel du/de la bénéficiaire à la fin de l’entretien','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(173,'qsoutem_ben','Qui apportera un soutien émotionnel au/à la bénéficiaire','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(174,'info_pert','Autres informations pertinentes','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(175,'exp_consviolb','Si le/la bénéficiaire a été violé(e), lui avez-vous expliqué les conséquences possibles du viol (s’il ou elle a plus de 14 ans)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'),(176,'exp_consviolp','Avez-vous expliqué les conséquences possibles du viol à la personne qui s’occupe du/de la bénéficiaire (si le/la bénéficiaire a moins de 14 ans)','Q002','2021-09-10 13:00:52','2021-09-10 13:00:52'); /*!40000 ALTER TABLE `params` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `partenaires` -- DROP TABLE IF EXISTS `partenaires`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `partenaires` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pays_id` int(11) DEFAULT NULL, `type_id` int(11) DEFAULT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `addresse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tel1` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tel2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_D230102EA6E44244` (`pays_id`), KEY `IDX_D230102EC54C8C93` (`type_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `partenaires` -- LOCK TABLES `partenaires` WRITE; /*!40000 ALTER TABLE `partenaires` DISABLE KEYS */; INSERT INTO `partenaires` VALUES (1,3,2,'Para clinique aide','Test','BP 503','5678390','456789','2021-10-04 20:02:24','2021-10-04 20:02:24'),(2,1,1,'Medecine moderne','Test','Senegal','65113529','08563472','2021-10-06 15:58:04','2021-10-06 15:58:04'); /*!40000 ALTER TABLE `partenaires` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pays` -- DROP TABLE IF EXISTS `pays`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pays` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `indicatif` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `imgname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `telephone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `numvert` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pays` -- LOCK TABLES `pays` WRITE; /*!40000 ALTER TABLE `pays` DISABLE KEYS */; INSERT INTO `pays` VALUES (1,'Senegal','+221','sn','senegal',NULL,NULL,NULL,NULL,NULL),(2,'Mali','+223','ml','mali',NULL,NULL,NULL,NULL,NULL),(3,'Burkina Faso','+226','bf','burkina',NULL,NULL,NULL,NULL,NULL),(4,'Niger','+227','ne','niger',NULL,NULL,NULL,NULL,NULL),(5,'Mauritanie','+222','mr','mauritanie',NULL,NULL,NULL,NULL,NULL),(6,'Tchad','+235','td','tchad',NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `pays` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pays_monde` -- DROP TABLE IF EXISTS `pays_monde`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pays_monde` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `code` int(3) NOT NULL, `alpha2` varchar(2) NOT NULL, `alpha3` varchar(3) NOT NULL, `nom_en_gb` varchar(45) NOT NULL, `nom_fr_fr` varchar(45) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `alpha2` (`alpha2`), UNIQUE KEY `alpha3` (`alpha3`), UNIQUE KEY `code_unique` (`code`) ) ENGINE=MyISAM AUTO_INCREMENT=242 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pays_monde` -- LOCK TABLES `pays_monde` WRITE; /*!40000 ALTER TABLE `pays_monde` DISABLE KEYS */; INSERT INTO `pays_monde` VALUES (1,4,'AF','AFG','Afghanistan','Afghanistan'),(2,8,'AL','ALB','Albania','Albanie'),(3,10,'AQ','ATA','Antarctica','Antarctique'),(4,12,'DZ','DZA','Algeria','Algérie'),(5,16,'AS','ASM','American Samoa','Samoa Américaines'),(6,20,'AD','AND','Andorra','Andorre'),(7,24,'AO','AGO','Angola','Angola'),(8,28,'AG','ATG','Antigua and Barbuda','Antigua-et-Barbuda'),(9,31,'AZ','AZE','Azerbaijan','Azerbaïdjan'),(10,32,'AR','ARG','Argentina','Argentine'),(11,36,'AU','AUS','Australia','Australie'),(12,40,'AT','AUT','Austria','Autriche'),(13,44,'BS','BHS','Bahamas','Bahamas'),(14,48,'BH','BHR','Bahrain','Bahreïn'),(15,50,'BD','BGD','Bangladesh','Bangladesh'),(16,51,'AM','ARM','Armenia','Arménie'),(17,52,'BB','BRB','Barbados','Barbade'),(18,56,'BE','BEL','Belgium','Belgique'),(19,60,'BM','BMU','Bermuda','Bermudes'),(20,64,'BT','BTN','Bhutan','Bhoutan'),(21,68,'BO','BOL','Bolivia','Bolivie'),(22,70,'BA','BIH','Bosnia and Herzegovina','Bosnie-Herzégovine'),(23,72,'BW','BWA','Botswana','Botswana'),(24,74,'BV','BVT','Bouvet Island','Île Bouvet'),(25,76,'BR','BRA','Brazil','Brésil'),(26,84,'BZ','BLZ','Belize','Belize'),(27,86,'IO','IOT','British Indian Ocean Territory','Territoire Britannique de l\'Océan Indien'),(28,90,'SB','SLB','Solomon Islands','Îles Salomon'),(29,92,'VG','VGB','British Virgin Islands','Îles Vierges Britanniques'),(30,96,'BN','BRN','Brunei Darussalam','Brunéi Darussalam'),(31,100,'BG','BGR','Bulgaria','Bulgarie'),(32,104,'MM','MMR','Myanmar','Myanmar'),(33,108,'BI','BDI','Burundi','Burundi'),(34,112,'BY','BLR','Belarus','Bélarus'),(35,116,'KH','KHM','Cambodia','Cambodge'),(36,120,'CM','CMR','Cameroon','Cameroun'),(37,124,'CA','CAN','Canada','Canada'),(38,132,'CV','CPV','Cape Verde','Cap-vert'),(39,136,'KY','CYM','Cayman Islands','Îles Caïmanes'),(40,140,'CF','CAF','Central African','République Centrafricaine'),(41,144,'LK','LKA','Sri Lanka','Sri Lanka'),(42,148,'TD','TCD','Chad','Tchad'),(43,152,'CL','CHL','Chile','Chili'),(44,156,'CN','CHN','China','Chine'),(45,158,'TW','TWN','Taiwan','Taïwan'),(46,162,'CX','CXR','Christmas Island','Île Christmas'),(47,166,'CC','CCK','Cocos (Keeling) Islands','Îles Cocos (Keeling)'),(48,170,'CO','COL','Colombia','Colombie'),(49,174,'KM','COM','Comoros','Comores'),(50,175,'YT','MYT','Mayotte','Mayotte'),(51,178,'CG','COG','Republic of the Congo','République du Congo'),(52,180,'CD','COD','The Democratic Republic Of The Congo','République Démocratique du Congo'),(53,184,'CK','COK','Cook Islands','Îles Cook'),(54,188,'CR','CRI','Costa Rica','Costa Rica'),(55,191,'HR','HRV','Croatia','Croatie'),(56,192,'CU','CUB','Cuba','Cuba'),(57,196,'CY','CYP','Cyprus','Chypre'),(58,203,'CZ','CZE','Czech Republic','République Tchèque'),(59,204,'BJ','BEN','Benin','Bénin'),(60,208,'DK','DNK','Denmark','Danemark'),(61,212,'DM','DMA','Dominica','Dominique'),(62,214,'DO','DOM','Dominican Republic','République Dominicaine'),(63,218,'EC','ECU','Ecuador','Équateur'),(64,222,'SV','SLV','El Salvador','El Salvador'),(65,226,'GQ','GNQ','Equatorial Guinea','Guinée Équatoriale'),(66,231,'ET','ETH','Ethiopia','Éthiopie'),(67,232,'ER','ERI','Eritrea','Érythrée'),(68,233,'EE','EST','Estonia','Estonie'),(69,234,'FO','FRO','Faroe Islands','Îles Féroé'),(70,238,'FK','FLK','Falkland Islands','Îles (malvinas) Falkland'),(71,239,'GS','SGS','South Georgia and the South Sandwich Islands','Géorgie du Sud et les Îles Sandwich du Sud'),(72,242,'FJ','FJI','Fiji','Fidji'),(73,246,'FI','FIN','Finland','Finlande'),(74,248,'AX','ALA','Åland Islands','Îles Åland'),(75,250,'FR','FRA','France','France'),(76,254,'GF','GUF','French Guiana','Guyane Française'),(77,258,'PF','PYF','French Polynesia','Polynésie Française'),(78,260,'TF','ATF','French Southern Territories','Terres Australes Françaises'),(79,262,'DJ','DJI','Djibouti','Djibouti'),(80,266,'GA','GAB','Gabon','Gabon'),(81,268,'GE','GEO','Georgia','Géorgie'),(82,270,'GM','GMB','Gambia','Gambie'),(83,275,'PS','PSE','Occupied Palestinian Territory','Territoire Palestinien Occupé'),(84,276,'DE','DEU','Germany','Allemagne'),(85,288,'GH','GHA','Ghana','Ghana'),(86,292,'GI','GIB','Gibraltar','Gibraltar'),(87,296,'KI','KIR','Kiribati','Kiribati'),(88,300,'GR','GRC','Greece','Grèce'),(89,304,'GL','GRL','Greenland','Groenland'),(90,308,'GD','GRD','Grenada','Grenade'),(91,312,'GP','GLP','Guadeloupe','Guadeloupe'),(92,316,'GU','GUM','Guam','Guam'),(93,320,'GT','GTM','Guatemala','Guatemala'),(94,324,'GN','GIN','Guinea','Guinée'),(95,328,'GY','GUY','Guyana','Guyana'),(96,332,'HT','HTI','Haiti','Haïti'),(97,334,'HM','HMD','Heard Island and McDonald Islands','Îles Heard et Mcdonald'),(98,336,'VA','VAT','Vatican City State','Saint-Siège (état de la Cité du Vatican)'),(99,340,'HN','HND','Honduras','Honduras'),(100,344,'HK','HKG','Hong Kong','Hong-Kong'),(101,348,'HU','HUN','Hungary','Hongrie'),(102,352,'IS','ISL','Iceland','Islande'),(103,356,'IN','IND','India','Inde'),(104,360,'ID','IDN','Indonesia','Indonésie'),(105,364,'IR','IRN','Islamic Republic of Iran','République Islamique d\'Iran'),(106,368,'IQ','IRQ','Iraq','Iraq'),(107,372,'IE','IRL','Ireland','Irlande'),(108,376,'IL','ISR','Israel','Israël'),(109,380,'IT','ITA','Italy','Italie'),(110,384,'CI','CIV','Côte d\'Ivoire','Côte d\'Ivoire'),(111,388,'JM','JAM','Jamaica','Jamaïque'),(112,392,'JP','JPN','Japan','Japon'),(113,398,'KZ','KAZ','Kazakhstan','Kazakhstan'),(114,400,'JO','JOR','Jordan','Jordanie'),(115,404,'KE','KEN','Kenya','Kenya'),(116,408,'KP','PRK','Democratic People\'s Republic of Korea','République Populaire Démocratique de Corée'),(117,410,'KR','KOR','Republic of Korea','République de Corée'),(118,414,'KW','KWT','Kuwait','Koweït'),(119,417,'KG','KGZ','Kyrgyzstan','Kirghizistan'),(120,418,'LA','LAO','Lao People\'s Democratic Republic','République Démocratique Populaire Lao'),(121,422,'LB','LBN','Lebanon','Liban'),(122,426,'LS','LSO','Lesotho','Lesotho'),(123,428,'LV','LVA','Latvia','Lettonie'),(124,430,'LR','LBR','Liberia','Libéria'),(125,434,'LY','LBY','Libyan Arab Jamahiriya','Jamahiriya Arabe Libyenne'),(126,438,'LI','LIE','Liechtenstein','Liechtenstein'),(127,440,'LT','LTU','Lithuania','Lituanie'),(128,442,'LU','LUX','Luxembourg','Luxembourg'),(129,446,'MO','MAC','Macao','Macao'),(130,450,'MG','MDG','Madagascar','Madagascar'),(131,454,'MW','MWI','Malawi','Malawi'),(132,458,'MY','MYS','Malaysia','Malaisie'),(133,462,'MV','MDV','Maldives','Maldives'),(134,466,'ML','MLI','Mali','Mali'),(135,470,'MT','MLT','Malta','Malte'),(136,474,'MQ','MTQ','Martinique','Martinique'),(137,478,'MR','MRT','Mauritania','Mauritanie'),(138,480,'MU','MUS','Mauritius','Maurice'),(139,484,'MX','MEX','Mexico','Mexique'),(140,492,'MC','MCO','Monaco','Monaco'),(141,496,'MN','MNG','Mongolia','Mongolie'),(142,498,'MD','MDA','Republic of Moldova','République de Moldova'),(143,500,'MS','MSR','Montserrat','Montserrat'),(144,504,'MA','MAR','Morocco','Maroc'),(145,508,'MZ','MOZ','Mozambique','Mozambique'),(146,512,'OM','OMN','Oman','Oman'),(147,516,'NA','NAM','Namibia','Namibie'),(148,520,'NR','NRU','Nauru','Nauru'),(149,524,'NP','NPL','Nepal','Népal'),(150,528,'NL','NLD','Netherlands','Pays-Bas'),(151,530,'AN','ANT','Netherlands Antilles','Antilles Néerlandaises'),(152,533,'AW','ABW','Aruba','Aruba'),(153,540,'NC','NCL','New Caledonia','Nouvelle-Calédonie'),(154,548,'VU','VUT','Vanuatu','Vanuatu'),(155,554,'NZ','NZL','New Zealand','Nouvelle-Zélande'),(156,558,'NI','NIC','Nicaragua','Nicaragua'),(157,562,'NE','NER','Niger','Niger'),(158,566,'NG','NGA','Nigeria','Nigéria'),(159,570,'NU','NIU','Niue','Niué'),(160,574,'NF','NFK','Norfolk Island','Île Norfolk'),(161,578,'NO','NOR','Norway','Norvège'),(162,580,'MP','MNP','Northern Mariana Islands','Îles Mariannes du Nord'),(163,581,'UM','UMI','United States Minor Outlying Islands','Îles Mineures Éloignées des États-Unis'),(164,583,'FM','FSM','Federated States of Micronesia','États Fédérés de Micronésie'),(165,584,'MH','MHL','Marshall Islands','Îles Marshall'),(166,585,'PW','PLW','Palau','Palaos'),(167,586,'PK','PAK','Pakistan','Pakistan'),(168,591,'PA','PAN','Panama','Panama'),(169,598,'PG','PNG','Papua New Guinea','Papouasie-Nouvelle-Guinée'),(170,600,'PY','PRY','Paraguay','Paraguay'),(171,604,'PE','PER','Peru','Pérou'),(172,608,'PH','PHL','Philippines','Philippines'),(173,612,'PN','PCN','Pitcairn','Pitcairn'),(174,616,'PL','POL','Poland','Pologne'),(175,620,'PT','PRT','Portugal','Portugal'),(176,624,'GW','GNB','Guinea-Bissau','Guinée-Bissau'),(177,626,'TL','TLS','Timor-Leste','Timor-Leste'),(178,630,'PR','PRI','Puerto Rico','Porto Rico'),(179,634,'QA','QAT','Qatar','Qatar'),(180,638,'RE','REU','Réunion','Réunion'),(181,642,'RO','ROU','Romania','Roumanie'),(182,643,'RU','RUS','Russian Federation','Fédération de Russie'),(183,646,'RW','RWA','Rwanda','Rwanda'),(184,654,'SH','SHN','Saint Helena','Sainte-Hélène'),(185,659,'KN','KNA','Saint Kitts and Nevis','Saint-Kitts-et-Nevis'),(186,660,'AI','AIA','Anguilla','Anguilla'),(187,662,'LC','LCA','Saint Lucia','Sainte-Lucie'),(188,666,'PM','SPM','Saint-Pierre and Miquelon','Saint-Pierre-et-Miquelon'),(189,670,'VC','VCT','Saint Vincent and the Grenadines','Saint-Vincent-et-les Grenadines'),(190,674,'SM','SMR','San Marino','Saint-Marin'),(191,678,'ST','STP','Sao Tome and Principe','Sao Tomé-et-Principe'),(192,682,'SA','SAU','Saudi Arabia','Arabie Saoudite'),(193,686,'SN','SEN','Senegal','Sénégal'),(194,690,'SC','SYC','Seychelles','Seychelles'),(195,694,'SL','SLE','Sierra Leone','Sierra Leone'),(196,702,'SG','SGP','Singapore','Singapour'),(197,703,'SK','SVK','Slovakia','Slovaquie'),(198,704,'VN','VNM','Vietnam','Viet Nam'),(199,705,'SI','SVN','Slovenia','Slovénie'),(200,706,'SO','SOM','Somalia','Somalie'),(201,710,'ZA','ZAF','South Africa','Afrique du Sud'),(202,716,'ZW','ZWE','Zimbabwe','Zimbabwe'),(203,724,'ES','ESP','Spain','Espagne'),(204,732,'EH','ESH','Western Sahara','Sahara Occidental'),(205,736,'SD','SDN','Sudan','Soudan'),(206,740,'SR','SUR','Suriname','Suriname'),(207,744,'SJ','SJM','Svalbard and Jan Mayen','Svalbard etÎle Jan Mayen'),(208,748,'SZ','SWZ','Swaziland','Swaziland'),(209,752,'SE','SWE','Sweden','Suède'),(210,756,'CH','CHE','Switzerland','Suisse'),(211,760,'SY','SYR','Syrian Arab Republic','République Arabe Syrienne'),(212,762,'TJ','TJK','Tajikistan','Tadjikistan'),(213,764,'TH','THA','Thailand','Thaïlande'),(214,768,'TG','TGO','Togo','Togo'),(215,772,'TK','TKL','Tokelau','Tokelau'),(216,776,'TO','TON','Tonga','Tonga'),(217,780,'TT','TTO','Trinidad and Tobago','Trinité-et-Tobago'),(218,784,'AE','ARE','United Arab Emirates','Émirats Arabes Unis'),(219,788,'TN','TUN','Tunisia','Tunisie'),(220,792,'TR','TUR','Turkey','Turquie'),(221,795,'TM','TKM','Turkmenistan','Turkménistan'),(222,796,'TC','TCA','Turks and Caicos Islands','Îles Turks et Caïques'),(223,798,'TV','TUV','Tuvalu','Tuvalu'),(224,800,'UG','UGA','Uganda','Ouganda'),(225,804,'UA','UKR','Ukraine','Ukraine'),(226,807,'MK','MKD','The Former Yugoslav Republic of Macedonia','L\'ex-République Yougoslave de Macédoine'),(227,818,'EG','EGY','Egypt','Égypte'),(228,826,'GB','GBR','United Kingdom','Royaume-Uni'),(229,833,'IM','IMN','Isle of Man','Île de Man'),(230,834,'TZ','TZA','United Republic Of Tanzania','République-Unie de Tanzanie'),(231,840,'US','USA','United States','États-Unis'),(232,850,'VI','VIR','U.S. Virgin Islands','Îles Vierges des États-Unis'),(233,854,'BF','BFA','Burkina Faso','Burkina Faso'),(234,858,'UY','URY','Uruguay','Uruguay'),(235,860,'UZ','UZB','Uzbekistan','Ouzbékistan'),(236,862,'VE','VEN','Venezuela','Venezuela'),(237,876,'WF','WLF','Wallis and Futuna','Wallis et Futuna'),(238,882,'WS','WSM','Samoa','Samoa'),(239,887,'YE','YEM','Yemen','Yémen'),(240,891,'CS','SCG','Serbia and Montenegro','Serbie-et-Monténégro'),(241,894,'ZM','ZMB','Zambia','Zambie'); /*!40000 ALTER TABLE `pays_monde` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `profile` -- DROP TABLE IF EXISTS `profile`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `profile` ( `id` int(11) NOT NULL AUTO_INCREMENT, `libelle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `profile` -- LOCK TABLES `profile` WRITE; /*!40000 ALTER TABLE `profile` DISABLE KEYS */; INSERT INTO `profile` VALUES (1,'Administrateur','11',NULL,NULL),(2,'Gestionnaire','22',NULL,NULL); /*!40000 ALTER TABLE `profile` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `region` -- DROP TABLE IF EXISTS `region`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `region` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pays_id` int(11) DEFAULT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_F62F176A6E44244` (`pays_id`), CONSTRAINT `FK_F62F176A6E44244` FOREIGN KEY (`pays_id`) REFERENCES `pays` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=235 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `region` -- LOCK TABLES `region` WRITE; /*!40000 ALTER TABLE `region` DISABLE KEYS */; INSERT INTO `region` VALUES (7,1,'Dakar',NULL,NULL),(8,1,'Diourbel',NULL,NULL),(9,1,'Fatick',NULL,NULL),(10,1,'Kaffrine',NULL,NULL),(11,1,'Kaolack',NULL,NULL),(12,1,'Kédougou',NULL,NULL),(13,1,'Kolda',NULL,NULL),(14,1,'Louga',NULL,NULL),(15,1,'Matam',NULL,NULL),(16,1,'Saint',NULL,NULL),(17,1,'Sédhiou',NULL,NULL),(18,1,'Tambacounda',NULL,NULL),(19,1,'Thiès',NULL,NULL),(20,1,'Ziguinchor',NULL,NULL),(21,2,'Bamako',NULL,NULL),(22,2,'Sikasso',NULL,NULL),(23,2,'Ségou',NULL,NULL),(24,2,'Gao',NULL,NULL),(25,2,'Mopti',NULL,NULL),(26,2,'Koutiala',NULL,NULL),(27,2,'Kayes',NULL,NULL),(28,2,'Kati',NULL,NULL),(29,2,'Markala',NULL,NULL),(30,2,'Kita',NULL,NULL),(31,2,'San',NULL,NULL),(32,2,'Bougouni',NULL,NULL),(33,2,'Timbuktu',NULL,NULL),(34,2,'Djenné',NULL,NULL),(35,2,'Banamba',NULL,NULL),(36,2,'Bafoulabé',NULL,NULL),(37,2,'Koulikoro',NULL,NULL),(38,2,'Nara',NULL,NULL),(39,2,'Kangaba',NULL,NULL),(40,2,'Nioro',NULL,NULL),(41,2,'Ménaka',NULL,NULL),(42,2,'Goundam',NULL,NULL),(43,2,'Tessalit',NULL,NULL),(44,2,'Yélimané',NULL,NULL),(45,2,'Kidal',NULL,NULL),(46,2,'Bandiagara',NULL,NULL),(47,2,'Ténenkou',NULL,NULL),(48,2,'Douentza',NULL,NULL),(49,2,'Niono',NULL,NULL),(50,2,'Bla',NULL,NULL),(51,2,'Diré',NULL,NULL),(52,2,'Bankass',NULL,NULL),(53,2,'Kadiolo',NULL,NULL),(54,2,'Ansongo',NULL,NULL),(55,2,'Dioila',NULL,NULL),(56,2,'Barouéli',NULL,NULL),(57,2,'Yorosso',NULL,NULL),(58,2,'Tominian',NULL,NULL),(59,2,'Koro',NULL,NULL),(60,2,'Kolokani',NULL,NULL),(61,2,'Yanfolila',NULL,NULL),(62,2,'Kolondiéba',NULL,NULL),(63,2,'Kéniéba',NULL,NULL),(64,2,'Youwarou',NULL,NULL),(65,2,'Niafunké',NULL,NULL),(66,2,'Diéma',NULL,NULL),(67,2,'Bourem',NULL,NULL),(68,2,'Abeïbara',NULL,NULL),(69,2,'Ké-Macina',NULL,NULL),(70,2,'Gourma Rharous',NULL,NULL),(71,2,'Ti-n-Essako',NULL,NULL),(72,5,'Nouakchott',NULL,NULL),(73,5,'Néma',NULL,NULL),(74,5,'Nouadhibou',NULL,NULL),(75,5,'Kiffa',NULL,NULL),(76,5,'Zouerate',NULL,NULL),(77,5,'Rosso',NULL,NULL),(78,5,'Atar',NULL,NULL),(79,5,'Tidjikja',NULL,NULL),(80,5,'Boutilimit',NULL,NULL),(81,5,'Bogué',NULL,NULL),(82,5,'Aleg',NULL,NULL),(83,5,'Fdérik',NULL,NULL),(84,5,'Aioun',NULL,NULL),(85,5,'Sélibaby',NULL,NULL),(86,5,'Akjoujt',NULL,NULL),(87,5,'Arafat',NULL,NULL),(88,5,'Kaédi',NULL,NULL),(89,5,'Tevragh Zeina',NULL,NULL),(90,5,'Dar Naim',NULL,NULL),(91,6,'Sarh',NULL,NULL),(92,6,'Moundou',NULL,NULL),(93,6,'Kelo',NULL,NULL),(94,6,'Yao',NULL,NULL),(95,6,'Abéché',NULL,NULL),(96,6,'Fianga',NULL,NULL),(97,6,'Koumra',NULL,NULL),(98,6,'Doba',NULL,NULL),(99,6,'Bongor',NULL,NULL),(100,6,'Mongo',NULL,NULL),(101,6,'Ati',NULL,NULL),(102,6,'Laï',NULL,NULL),(103,6,'Mao',NULL,NULL),(104,6,'Moussoro',NULL,NULL),(105,6,'Faya',NULL,NULL),(106,6,'Bol',NULL,NULL),(107,6,'Biltine',NULL,NULL),(108,6,'Massenya',NULL,NULL),(109,6,'Fada',NULL,NULL),(110,6,'Pala',NULL,NULL),(111,6,'Massakory',NULL,NULL),(112,6,'Amdjarass',NULL,NULL),(113,6,'Bardaï',NULL,NULL),(114,6,'Pala Oua',NULL,NULL),(115,6,'Goz-Beida',NULL,NULL),(116,6,'Oum Hadjer',NULL,NULL),(117,6,'N’Djamena',NULL,NULL),(118,6,'Am-Timan',NULL,NULL),(119,4,'Niamey',NULL,NULL),(120,4,'Zinder',NULL,NULL),(121,4,'Maradi',NULL,NULL),(122,4,'Agadez',NULL,NULL),(123,4,'Tahoua',NULL,NULL),(124,4,'Arlit',NULL,NULL),(125,4,'Gaya',NULL,NULL),(126,4,'Dosso',NULL,NULL),(127,4,'Diffa',NULL,NULL),(128,4,'Ayorou',NULL,NULL),(129,4,'Madaoua',NULL,NULL),(130,4,'Tillabéri',NULL,NULL),(131,4,'Nguigmi',NULL,NULL),(132,4,'Gouré',NULL,NULL),(133,4,'Magaria',NULL,NULL),(134,4,'Kantché',NULL,NULL),(135,4,'Bouza',NULL,NULL),(136,4,'Aguié',NULL,NULL),(137,4,'Madarounfa',NULL,NULL),(138,4,'Mirriah',NULL,NULL),(139,4,'Tessaoua',NULL,NULL),(140,4,'Keïta',NULL,NULL),(141,4,'Illéla',NULL,NULL),(142,4,'Mayahi',NULL,NULL),(143,4,'Loga',NULL,NULL),(144,4,'Dakoro',NULL,NULL),(145,4,'Téra',NULL,NULL),(146,4,'Kollo',NULL,NULL),(147,4,'Dogondoutchi',NULL,NULL),(148,4,'Filingué',NULL,NULL),(149,4,'Say',NULL,NULL),(150,4,'Abalak',NULL,NULL),(151,4,'Ouallam',NULL,NULL),(152,4,'Tanout',NULL,NULL),(153,4,'Tchintabaraden',NULL,NULL),(154,4,'Tchirozérine',NULL,NULL),(155,4,'Bilma',NULL,NULL),(156,4,'Birnin Gaouré',NULL,NULL),(157,4,'Guidan Roumdji',NULL,NULL),(158,4,'Birnin Konni',NULL,NULL),(159,4,'Maïné Soroa',NULL,NULL),(160,3,'Ouagadougou',NULL,NULL),(161,3,'Koudougou',NULL,NULL),(162,3,'Ouahigouya',NULL,NULL),(163,3,'Banfora',NULL,NULL),(164,3,'Kaya',NULL,NULL),(165,3,'Dédougou',NULL,NULL),(166,3,'Tenkodogo',NULL,NULL),(167,3,'Dori',NULL,NULL),(168,3,'Réo',NULL,NULL),(169,3,'Koupéla',NULL,NULL),(170,3,'Kombissiri',NULL,NULL),(171,3,'Nouna',NULL,NULL),(172,3,'Gaoua',NULL,NULL),(173,3,'Léo',NULL,NULL),(174,3,'Diapaga',NULL,NULL),(175,3,'Zorgo',NULL,NULL),(176,3,'Yako',NULL,NULL),(177,3,'Djibo',NULL,NULL),(178,3,'Pô',NULL,NULL),(179,3,'Tougan',NULL,NULL),(180,3,'Boulsa',NULL,NULL),(181,3,'Manga',NULL,NULL),(182,3,'Diébougou',NULL,NULL),(183,3,'Ziniaré',NULL,NULL),(184,3,'Salanso',NULL,NULL),(185,3,'Bogandé',NULL,NULL),(186,3,'Sapouy',NULL,NULL),(187,3,'Sebba',NULL,NULL),(188,3,'Gaoua',NULL,NULL),(189,3,'Komsilga',NULL,NULL),(190,3,'Loumbila',NULL,NULL),(191,3,'Saaba',NULL,NULL),(192,3,'Kongoussi',NULL,NULL),(193,3,'Kokologo',NULL,NULL),(194,3,'Gourcy',NULL,NULL),(195,3,'Boussouma',NULL,NULL),(196,3,'Ouargaye',NULL,NULL),(197,3,'Boussé',NULL,NULL),(198,3,'Laye',NULL,NULL),(199,3,'Zitenga',NULL,NULL),(200,3,'Absouya',NULL,NULL),(201,3,'Siglé',NULL,NULL),(202,3,'Orodara',NULL,NULL),(203,3,'Toéghin',NULL,NULL),(204,3,'Sourgoubila',NULL,NULL),(205,3,'Dapélogo',NULL,NULL),(206,3,'Korsimoro',NULL,NULL),(207,3,'Houndé',NULL,NULL),(208,3,'Dano',NULL,NULL),(209,3,'Niou',NULL,NULL),(210,3,'Pabré',NULL,NULL),(211,3,'Koubri',NULL,NULL),(212,3,'Mané',NULL,NULL),(213,3,'Toma',NULL,NULL),(214,3,'Bingo',NULL,NULL),(215,3,'Saponé',NULL,NULL),(216,3,'Nagréongo',NULL,NULL),(217,3,'Kayao',NULL,NULL),(218,3,'Sindou',NULL,NULL),(219,3,'Gaongo',NULL,NULL),(220,3,'Titao',NULL,NULL),(221,3,'Aribinda',NULL,NULL),(222,3,'Oursi',NULL,NULL),(223,3,'Batié',NULL,NULL),(224,3,'Boromo',NULL,NULL),(225,3,'Gayéri',NULL,NULL),(226,3,'Déou',NULL,NULL),(227,3,'Pama',NULL,NULL),(228,3,'Tin-Akoff',NULL,NULL),(229,3,'Bobo-Dioulasso',NULL,NULL),(230,3,'Ourgou-Manéga',NULL,NULL),(231,3,'Komki-Ipala',NULL,NULL),(232,3,'Tanghin-Dassouri',NULL,NULL),(233,3,'Gorom-Gorom',NULL,NULL),(234,3,'Fada Ngourma',NULL,NULL); /*!40000 ALTER TABLE `region` 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` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `ipaddress` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `state` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `signal_id` int(11) DEFAULT NULL, `datesignal` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_9A609D13A76ED395` (`user_id`), CONSTRAINT `FK_9A609D13A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 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 */; INSERT INTO `sessions` VALUES (1,NULL,'127.0.0.1','on','henri',NULL,NULL,'2021-08-23 21:42:58','2021-08-23 21:42:58'),(2,NULL,'::1','on','henri',NULL,NULL,'2021-08-31 16:39:12','2021-08-31 16:39:12'),(3,NULL,'127.0.0.1','on','test4',NULL,NULL,'2021-09-15 18:12:32','2021-09-15 18:12:32'),(4,NULL,'127.0.0.1','on','test2',NULL,NULL,'2021-09-15 18:13:12','2021-09-15 18:13:12'),(5,NULL,'127.0.0.1','on','test5',NULL,NULL,'2021-09-15 18:15:15','2021-09-15 18:15:15'),(6,NULL,'::1','on','test3',NULL,NULL,'2021-09-16 07:19:57','2021-09-16 07:19:57'),(7,NULL,'127.0.0.1','on','test3',NULL,NULL,'2021-09-17 19:11:03','2021-09-17 19:11:03'),(8,NULL,'::1','on','test4',NULL,NULL,'2021-09-23 10:41:29','2021-09-23 10:41:29'),(9,NULL,'::1','on','test5',NULL,NULL,'2021-09-23 10:43:27','2021-09-23 10:43:27'),(10,NULL,'::1','on','test2',NULL,NULL,'2021-09-23 10:56:37','2021-09-23 10:56:37'),(11,NULL,'::1','on','test1',NULL,NULL,'2021-09-29 09:48:18','2021-09-29 09:48:18'),(12,NULL,'127.0.0.1','on','test10',NULL,NULL,'2021-09-29 10:49:50','2021-09-29 10:49:50'),(13,NULL,'127.0.0.1','on','test1',NULL,NULL,'2021-09-30 11:42:13','2021-09-30 11:42:13'),(14,NULL,'127.0.0.1','on','paulin',NULL,NULL,'2021-10-12 16:53:24','2021-10-12 16:53:24'); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `signal` -- DROP TABLE IF EXISTS `signal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `signal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `region_id` int(11) NOT NULL, `forme_id` int(11) NOT NULL, `nom` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `prenom` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `indicatif` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `numero` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `urgence` tinyint(1) DEFAULT NULL, `anonyme` tinyint(1) DEFAULT NULL, `dernetat` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ddernetat` datetime DEFAULT NULL, `code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `userc` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_740C95F598260155` (`region_id`), KEY `IDX_740C95F5BCE84E7C` (`forme_id`), CONSTRAINT `FK_740C95F598260155` FOREIGN KEY (`region_id`) REFERENCES `region` (`id`), CONSTRAINT `FK_740C95F5BCE84E7C` FOREIGN KEY (`forme_id`) REFERENCES `forme_violence` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `signal` -- LOCK TABLES `signal` WRITE; /*!40000 ALTER TABLE `signal` DISABLE KEYS */; INSERT INTO `signal` VALUES (1,160,8,'Henri','Kabore',NULL,'651147883','andi@gmail.com','Tets',0,0,'en_cours','2021-09-01 18:12:32',NULL,'2021-08-15 00:00:00','2021-08-15 00:00:00','test1'),(2,8,7,'Carine','zongo',NULL,'66554783','carine@gmail.com','Mon 2 test',1,0,'termines','2021-10-06 09:50:13',NULL,'2021-08-15 00:00:00','2021-08-15 00:00:00','test3'),(3,163,14,NULL,NULL,NULL,'6544332','text@gmail.com','Text 3',0,1,'en_cours','2021-09-01 15:42:53',NULL,'2021-08-15 00:00:00','2021-08-15 00:00:00','test1'),(4,144,20,NULL,NULL,NULL,'76543390','andi@gmail.com','Tetx',1,1,'en_cours','2021-09-09 10:48:18',NULL,'2021-08-15 00:00:00','2021-08-15 00:00:00','test10'),(5,174,23,'Daouda','Zella',NULL,'678934772','daouda@gmail.com','Test Toujours',1,0,'en_cours','2021-09-29 11:05:00',NULL,'2021-08-15 00:00:00','2021-08-15 00:00:00','test1'),(6,177,7,'Potter','Son',NULL,'78465257','potter@gmail.com','Test 5',0,0,'en_cours','2021-09-29 15:10:40',NULL,'2021-08-15 00:00:00','2021-08-15 00:00:00','test10'),(7,182,25,'Henri','ZOngo',NULL,'78465322','henri@gmail.com','Test 3',1,0,'en_cours','2021-09-13 16:21:44',NULL,'2021-08-15 00:00:00','2021-08-15 00:00:00','test10'),(8,21,7,NULL,NULL,NULL,'3456','andi@gmail.com','',0,1,'en_cours','2021-09-06 13:07:59',NULL,'2021-08-15 00:00:00','2021-08-15 00:00:00','test2'),(9,36,7,'Kabore Henri','Potter',NULL,'7766737','andi@gmail.com','ertyuio',0,0,'en_cours','2021-10-09 13:35:33',NULL,'2021-08-15 00:00:00','2021-08-15 00:00:00','test2'),(10,42,11,NULL,NULL,NULL,'456789','andi@gmail.com','23456789',0,1,'reference','2021-09-25 11:53:29',NULL,'2021-08-15 00:00:00','2021-08-15 00:00:00',NULL),(11,205,18,'DEME','Mina Prot',NULL,'6735624','andi@gmail.com','Primero est une plate-forme de gestion de l\'information facile à utiliser, développée à l\'origine par la communauté de la protection humanitaire. Il est maintenant largement utilisé par la main-d\'œuvre des services sociaux, les travailleurs humanitaires et les travailleurs du développement dans plus de 35 pays\r\nPrimero est un logiciel de gestion de l\'information qui aide les travailleurs sociaux, les agents de protection et les prestataires de services à gérer, stocker et analyser les données. Il a actuellement des fonctionnalités pour prendre en charge : 1) la gestion des cas 2) la surveillance des incidents et, 3) la recherche et la réunification des familles.\r\n',1,0,'en_cours','2021-09-29 12:01:47','ID130821020027','2021-08-15 00:00:00','2021-08-15 00:00:00','test10'),(12,70,16,'Gqndo','Zaki','+223','87546093','zakin@exple.com','Comme pour tout logiciel, Primero ne peut pas remplacer ou se substituer aux bonnes pratiques commerciales, qui dans ce cas font référence à une bonne programmation de protection. L\'application n\'ajoutera de la valeur qu\'aux programmes qui fonctionnent déjà. Primero représente une opportunité de renforcer les programmes avec l\'utilisation de la technologie de gestion de l\'information.',0,0,'en_cours','2021-09-03 08:58:06','ID130821072746','2021-08-15 00:00:00','2021-08-15 00:00:00','test2'),(13,195,23,'Koulidaty','Fulbert','+226','651124563','fulb@gmail.com','Il m\'a garant',1,0,'non_prise','2021-09-16 07:35:20','ID010921013502','2021-09-01 13:35:02','2021-09-01 13:35:02',NULL),(14,9,14,'Potter','ZOngo','+221','653894623','paul@gmail.com','Il ma menace de mort',1,0,'reference','2021-10-06 16:18:49','ID010921013658','2021-09-01 13:36:58','2021-09-01 13:36:58','test3'),(15,9,9,'KABORE','Henri','+221','65112436','kkoudaogo@gmail.com',' OK ',0,0,'en_cours','2021-09-23 10:01:06','UD080921110135','2021-09-08 11:01:35','2021-09-08 11:01:35','test3'),(16,103,11,NULL,NULL,'+235','9872562543','koudaogo@gmail.com','Ma violence concerne une agression',0,1,'non_prise','2021-09-16 07:17:22','ID160921071722','2021-09-16 07:17:22','2021-09-16 07:17:22',NULL),(17,205,5,'Jaques','Parés','+226','78467398','jaques@gmail.com','J \'ai été aggressé grave',0,0,'non_prise','2021-09-21 18:16:51','ID210921061651','2021-09-21 18:16:51','2021-09-21 18:16:51',NULL),(18,161,25,'Ali','Docoum','+226','764553876','alix@exemple.com','J\'ai été volé',0,0,'en_cours','2021-09-21 18:59:15','ID210921065051','2021-09-21 18:50:51','2021-09-21 18:50:51','test1'),(19,75,21,'Paulin','Bazongo','+222','1234567','andi@gmail.com',' Test de violence',0,0,'en_cours','2021-09-27 15:52:45','UD270921035203','2021-09-27 15:52:03','2021-09-27 15:52:03','test4'),(20,185,5,NULL,NULL,'+226','5636726','kkoudaogo@gmail.com','Mon cas est compliqué',1,1,'non_prise','2021-10-01 14:52:41','ID011021025240','2021-10-01 14:52:40','2021-10-01 14:52:40',NULL); /*!40000 ALTER TABLE `signal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tmp_formstep1` -- DROP TABLE IF EXISTS `tmp_formstep1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tmp_formstep1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sessions_id` int(11) DEFAULT NULL, `ref_inc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code_surv` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code_user` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_ent` datetime DEFAULT NULL, `date_inc` datetime DEFAULT NULL, `dec_inc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pays` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tmp_formstep1` -- LOCK TABLES `tmp_formstep1` WRITE; /*!40000 ALTER TABLE `tmp_formstep1` DISABLE KEYS */; INSERT INTO `tmp_formstep1` VALUES (1,NULL,'12','ID130821072746','test2','2021-08-11 15:40:10','2021-08-23 15:40:10','surv','Mali','2021-08-23 22:49:14','2021-10-12 15:40:10'),(3,NULL,'1','','test1','2021-08-25 22:44:58','2021-08-25 22:44:58','autr_per',NULL,'2021-08-25 14:44:54','2021-09-13 22:44:58'),(5,NULL,'3','','test1','2021-08-10 20:56:55','2021-08-25 20:56:55','surv','Burkina Faso','2021-08-25 15:04:59','2021-10-05 20:56:55'),(6,NULL,'5','','test1','2021-08-25 16:23:10','2021-08-25 16:23:10','autr_per','Burkina Faso','2021-08-25 16:46:26','2021-10-01 16:23:10'),(7,NULL,'4','','test10','2021-08-24 10:51:42','2021-08-25 10:51:42','autr_per',NULL,'2021-08-25 16:48:05','2021-09-09 10:51:42'),(8,NULL,'8','','test2','2021-08-02 13:33:28','2021-08-02 13:33:28','autr_per','Mali','2021-08-25 16:50:39','2021-10-09 13:33:28'),(9,NULL,'7','','test10','2021-08-26 14:37:10','2021-08-26 14:37:10','autr_per','Burkina Faso','2021-08-26 10:50:33','2021-09-29 14:37:10'),(10,NULL,'18','ID210921065051','test1','2021-09-21 16:12:17','2021-09-21 16:12:17','surv','Burkina Faso','2021-09-21 18:59:14','2021-10-12 16:12:17'),(12,NULL,'2','','test2','2021-09-22 09:20:48','2021-09-22 09:20:48','autr_per','Senegal','2021-09-22 18:50:11','2021-09-29 09:20:48'),(13,NULL,'14','ID010921013658','test3','2021-09-23 09:58:04','2021-09-23 09:58:04','surv','Senegal','2021-09-23 09:34:17','2021-10-06 09:58:04'),(14,NULL,'15','UD080921110135','test3','2021-09-23 11:13:00','2021-09-23 11:13:00','autr_per','Senegal','2021-09-23 10:01:06','2021-10-09 11:13:00'),(15,NULL,'19','UD270921035203','test4','2021-09-08 15:52:45','2021-09-27 15:52:45','surv',NULL,'2021-09-27 15:52:45','2021-09-27 15:52:45'),(17,NULL,'11','ID130821020027','test10','2021-09-07 16:32:22','2021-09-29 16:32:22','autr_per','Burkina Faso','2021-09-29 12:01:46','2021-10-12 16:32:22'),(18,NULL,'6','','test10','2021-09-22 23:05:44','2021-09-29 23:05:44','surv','Burkina Faso','2021-09-29 15:10:39','2021-09-29 23:05:44'),(19,NULL,'9','','test2','2021-10-07 13:35:32','2021-10-14 13:35:32','autr_per','Mali','2021-10-09 13:35:32','2021-10-09 13:35:32'); /*!40000 ALTER TABLE `tmp_formstep1` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tmp_formstep2` -- DROP TABLE IF EXISTS `tmp_formstep2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tmp_formstep2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sessions_id` int(11) DEFAULT NULL, `ref_inc` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code_user` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_nais` datetime DEFAULT NULL, `sexe` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ethnie` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pays_org` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nation` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `religion` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `etat_civ` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nbre_enf` int(11) DEFAULT NULL, `prof` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `stat_depl` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `est_hand` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `est_min` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `surv_viseul` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lien_parent` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `autre_lien` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `activ_princ` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tmp_formstep2` -- LOCK TABLES `tmp_formstep2` WRITE; /*!40000 ALTER TABLE `tmp_formstep2` DISABLE KEYS */; INSERT INTO `tmp_formstep2` VALUES (1,NULL,NULL,NULL,'1997-01-29 20:11:03','h','Bete','h','h','Chretien','marie',4,'Info','resident','hand_ment','autr_enf',NULL,NULL,NULL,NULL,'2021-08-24 13:13:48','2021-09-02 20:11:03',2),(2,NULL,NULL,NULL,'2002-02-13 15:40:15','h','Bete','Burkina Faso','Burkina Faso','Catholique','marie',4,'Cultivateur','dem_asil','hand_ment','min_nacc',NULL,NULL,NULL,NULL,'2021-08-24 15:27:32','2021-10-12 15:40:15',1),(3,NULL,NULL,NULL,'2021-08-26 22:16:55','h','','h','h','','celibat',1,'','pdip','hand_ment','min_nacc',NULL,NULL,NULL,NULL,'2021-08-25 14:44:54','2021-09-13 22:16:55',3),(4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-08-25 14:51:12','2021-08-25 14:51:12',4),(5,NULL,NULL,NULL,'2001-02-08 20:57:00','f','Mossi','France','France','Musulman','divorce',1,'Etudiante','dem_asil','hand_ment','autr_enf',NULL,NULL,NULL,NULL,'2021-08-25 15:04:59','2021-10-05 20:57:00',5),(6,NULL,NULL,NULL,'1997-05-22 16:23:20','f','Dioulassouba','Mali','Mali','Chretiene','marie',2,'Professionne','dem_asil','hand_ment','min_nacc',NULL,NULL,NULL,NULL,'2021-08-25 16:46:26','2021-10-01 16:23:20',6),(7,NULL,NULL,NULL,'2021-08-25 10:48:35','f','',NULL,NULL,'',NULL,3,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-08-25 16:48:05','2021-09-09 10:48:35',7),(8,NULL,NULL,NULL,'2021-08-10 13:33:44','h','Mossi','Bhoutan','Bahreïn','Protestant','marie',2,'Etudiant','dem_asil','hand_ment','min_nacc',NULL,NULL,NULL,NULL,'2021-08-25 16:50:39','2021-10-09 13:33:44',8),(9,NULL,NULL,NULL,'1992-05-13 13:51:34','h','Bete','h','h','Protestant','marie',4,'Professionne','resident','hand_phys','min_nacc',NULL,NULL,NULL,NULL,'2021-08-26 10:50:33','2021-09-29 13:51:34',9),(10,NULL,NULL,NULL,'2021-08-25 11:05:37','h','',NULL,NULL,'',NULL,4,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-01 11:05:37','2021-09-01 11:05:37',NULL),(11,NULL,NULL,NULL,'2007-05-08 16:12:27','h','Dioula','Afghanistan','Afghanistan','Musulman','divorce',4,'Etudiante','pdip','non','min_nacc',NULL,NULL,NULL,NULL,'2021-09-21 18:59:14','2021-10-12 16:12:27',10),(13,NULL,NULL,NULL,'2021-09-22 09:21:34','f','Dioula','Mali','Mali','Musulman','marie',2,'Etudiante','rapatrie','hand_ment','enf_sep',NULL,NULL,NULL,NULL,'2021-09-22 18:50:11','2021-09-29 09:21:34',12),(14,NULL,NULL,NULL,'2001-02-08 09:58:07','h','Dioula','Burkina Faso','Burkina Faso','Musulman','marie',2,'Etudiante','pdip','hand_ment','min_nacc',NULL,NULL,NULL,NULL,'2021-09-23 09:34:17','2021-10-06 09:58:07',13),(15,NULL,NULL,NULL,'2013-05-15 23:07:42','h','Dioula','Mali','Mali','Musulman','marie',3,'Etudiante','dem_asil','hand_ment','enf_sep',NULL,NULL,NULL,NULL,'2021-09-23 10:01:06','2021-10-07 23:07:42',14),(16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-27 15:52:45','2021-09-27 15:52:45',15),(18,NULL,NULL,NULL,'2010-10-12 16:33:11','h','Bete','Côte d\'Ivoire','Côte d\'Ivoire','Chretien','divorce',3,'Cultivateur','dem_asil','hand_ment','enf_sep',NULL,NULL,NULL,'Etudiante','2021-09-29 12:01:46','2021-10-12 16:33:11',17),(19,NULL,NULL,NULL,'1998-02-04 23:05:29','f','Bete','Albanie','Albanie','Catholique','celibat',3,'Professionne','dem_asil','hand_ment','enf_sep',NULL,NULL,NULL,NULL,'2021-09-29 15:10:39','2021-09-29 23:05:29',18),(20,NULL,NULL,NULL,'2005-05-09 13:36:44','f','Dioula','Burkina Faso','Burkina Faso','Musulman','celibat',4,'Etudiante','dem_asil','hand_ment','min_nacc',NULL,NULL,NULL,'Menagere','2021-10-09 13:35:32','2021-10-09 13:36:44',19); /*!40000 ALTER TABLE `tmp_formstep2` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tmp_formstep3` -- DROP TABLE IF EXISTS `tmp_formstep3`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tmp_formstep3` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sessions_id` int(11) DEFAULT NULL, `ref_inc` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code_user` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `desc_inc` longtext COLLATE utf8mb4_unicode_ci, `phase_depl` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `autre_phsdepl` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `heure_inc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lieu_inc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `autlieu_inc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `zone_inc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `autzone_inc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `souzon_inc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `autsouzon_inc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `camvil_inc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `autcamvil_inc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `typ_viol` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `inc_prej` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `echange` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `typ_enlev` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `inc_declaill` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type_prestdecl` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `vict_prec` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `desc_cons` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tmp_formstep3` -- LOCK TABLES `tmp_formstep3` WRITE; /*!40000 ALTER TABLE `tmp_formstep3` DISABLE KEYS */; INSERT INTO `tmp_formstep3` VALUES (1,NULL,NULL,NULL,'On m\'a braquer','enc_fuite',NULL,'matin','dom_agres',NULL,'ville',NULL,'utiro',NULL,'jardin',NULL,'agres_sex','mgf_e','oui','cons_force','oui','oui','oui','ggggggggg','2021-08-24 13:13:48','2021-09-02 19:43:11',2),(2,NULL,NULL,NULL,'Mon histoire a changé','enc_fuite',NULL,'matin','brousse',NULL,'village',NULL,'urati',NULL,'dom_agres',NULL,'mar_forc','exig_dot','oui','cons_force','non','oui','oui','Comme cela seulement','2021-08-24 15:27:32','2021-09-03 09:04:23',1),(3,NULL,NULL,NULL,'',NULL,NULL,NULL,'brousse',NULL,'ville',NULL,'urati',NULL,'brousse',NULL,'agres_phys','mgf_e','oui','trafic','oui','oui','oui',NULL,'2021-08-25 14:44:54','2021-09-13 22:44:47',3),(4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'village',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-08-25 14:51:12','2021-08-25 14:51:12',4),(5,NULL,NULL,NULL,'','enc_fuite',NULL,'matin','ecole',NULL,'ville',NULL,'utiro',NULL,'brousse',NULL,'den_res','exig_dot','oui','cons_force','oui','oui','non',NULL,'2021-08-25 15:04:59','2021-09-14 17:42:06',5),(6,NULL,NULL,NULL,'Toujours dans le cadre des tests','non_depl',NULL,'ap_midi','brousse',NULL,'village',NULL,'kakuto',NULL,'autre_camp','Village','agres_sex','mgf_e','oui','cons_force','oui','non','oui','Description concise en test','2021-08-25 16:46:26','2021-10-01 16:19:40',6),(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ville',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-08-25 16:48:05','2021-08-25 16:48:05',7),(8,NULL,NULL,NULL,'Recit incident','enc_raptrmt',NULL,'matin','jard_champ',NULL,'village',NULL,'kakuto',NULL,'dom_ben',NULL,'den_res','mgf_e','oui','cons_force','oui',NULL,'oui',NULL,'2021-08-25 16:50:39','2021-10-09 13:34:04',8),(9,NULL,NULL,NULL,'Okok','non_depl',NULL,'matin','jard_champ',NULL,'ville',NULL,'urati',NULL,'route',NULL,'den_res','mgf_e','oui','cons_force','oui','oui','non',NULL,'2021-08-26 10:50:33','2021-09-13 16:22:57',9),(10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'village',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-21 18:59:14','2021-09-21 18:59:14',10),(12,NULL,NULL,NULL,'Test 3','enc_fuite',NULL,'ap_midi','jard_champ',NULL,'village',NULL,'kakuto',NULL,'brousse',NULL,'agres_phys','exig_dot','oui','cons_force','oui','oui','non',NULL,'2021-09-22 18:50:11','2021-09-22 19:23:04',12),(13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ville',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-23 09:34:17','2021-09-23 09:34:17',13),(14,NULL,NULL,NULL,'Test Ok','enc_fuite',NULL,'ap_midi','jard_champ',NULL,'village',NULL,'Ouaga',NULL,'Ouagadougou',NULL,'den_res','exig_dot','non','cons_force','non',NULL,'non',NULL,'2021-09-23 10:01:06','2021-10-09 11:20:20',14),(15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ville',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-27 15:52:45','2021-09-27 15:52:45',15),(17,NULL,NULL,NULL,'Mes tests continue de marche','enc_raptrmt',NULL,'soir','jard_champ',NULL,'village',NULL,'Maranata',NULL,'Maranata',NULL,'viol_psych','exig_dot','oui','cons_force','oui','oui','oui','Ok pour le remplissage','2021-09-29 12:01:46','2021-10-12 16:17:30',17),(18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'village',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-29 15:10:39','2021-09-29 15:10:39',18),(19,NULL,NULL,NULL,'Test des malien','enc_fuite',NULL,'matin','ecole',NULL,'ville',NULL,'Ouaga',NULL,'Ouagadougou',NULL,'viol_psych','exig_dot','oui','trafic','oui','oui','non',NULL,'2021-10-09 13:35:32','2021-10-09 13:37:51',19); /*!40000 ALTER TABLE `tmp_formstep3` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tmp_formstep4` -- DROP TABLE IF EXISTS `tmp_formstep4`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tmp_formstep4` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sessions_id` int(11) DEFAULT NULL, `ref_inc` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code_user` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nbre_prsum` int(11) DEFAULT NULL, `sex_agress` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nat_agress` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ethn_agress` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `trch_ageagres` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lienp_agress` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `activ_agress` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tmp_formstep4` -- LOCK TABLES `tmp_formstep4` WRITE; /*!40000 ALTER TABLE `tmp_formstep4` DISABLE KEYS */; INSERT INTO `tmp_formstep4` VALUES (1,NULL,NULL,NULL,2,'m','Malien','Dioula','0-11','autr_mbre','ben_comm','2021-08-24 13:13:48','2021-09-02 19:43:53',2),(2,NULL,NULL,NULL,3,'m','Ivoirienne','Boule','41-60','mbre_comm','trav_sant','2021-08-24 15:27:32','2021-08-27 15:17:39',1),(3,NULL,NULL,NULL,3,'m','','','12-17','ref_rapat','trav_sant','2021-08-25 14:44:54','2021-08-26 22:34:36',3),(4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-08-25 14:51:12','2021-08-25 14:51:12',4),(5,NULL,NULL,NULL,3,'fm','Burkinabe','Peuhl','12-17','poccup_surv','lead_reli','2021-08-25 15:04:59','2021-09-14 17:42:53',5),(6,NULL,NULL,NULL,2,'m','Ivoirienne','Boule','12-17','mbre_comm','emp_ong','2021-08-25 16:46:26','2021-10-01 16:20:18',6),(7,NULL,NULL,NULL,NULL,'f','','','18-25',NULL,NULL,'2021-08-25 16:48:05','2021-09-09 10:49:47',7),(8,NULL,NULL,NULL,3,'m','Mali','Musulman','0-11','ami_vois','emp_cbo','2021-08-25 16:50:39','2021-08-25 23:08:32',8),(9,NULL,NULL,NULL,3,'f','Mali','Peuhl','0-11','ami_vois','emp_ong','2021-08-26 10:50:33','2021-09-13 16:23:08',9),(10,NULL,NULL,NULL,2,'m','Burkinabe','Peuhl','12-17','part_intim','fermier','2021-09-21 18:59:14','2021-09-21 19:14:33',10),(12,NULL,NULL,NULL,2,'f','Burkinabe','Peuhl','18-25','ref_rapat','ben_comm','2021-09-22 18:50:11','2021-09-22 19:25:18',12),(13,NULL,NULL,NULL,3,'f','Burkinabe','Peuhl','18-25','part_intim','trav_sant','2021-09-23 09:34:17','2021-09-27 22:23:57',13),(14,NULL,NULL,NULL,3,'f','Burkinabe','Peuhl','18-25','colocataire','dign_reli','2021-09-23 10:01:06','2021-10-09 11:10:13',14),(15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-27 15:52:45','2021-09-27 15:52:45',15),(17,NULL,NULL,NULL,3,'m','Malien','Boule','12-17','inconnu','autr_actagres','2021-09-29 12:01:46','2021-10-12 16:18:05',17),(18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-29 15:10:39','2021-09-29 15:10:39',18),(19,NULL,NULL,NULL,3,'f','Burkinabe','Peuhl','18-25','fmlle_ou_p','forc_sec','2021-10-09 13:35:32','2021-10-09 13:38:18',19); /*!40000 ALTER TABLE `tmp_formstep4` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tmp_formstep5` -- DROP TABLE IF EXISTS `tmp_formstep5`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tmp_formstep5` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sessions_id` int(11) DEFAULT NULL, `ref_inc` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code_user` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addres_benef` longtext COLLATE utf8mb4_unicode_ci, `prec_addben` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `renv_refg` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pourq_refg` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_rdvrfg` datetime DEFAULT NULL, `nlieu_rfg` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note_lieurfg` longtext COLLATE utf8mb4_unicode_ci, `renv_servsant` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pourq_servsant` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_rdvsant` datetime DEFAULT NULL, `nlieu_sant` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note_lieusant` longtext COLLATE utf8mb4_unicode_ci, `renv_servpsych` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pourq_soutpsych` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_rdvsoutpsych` datetime DEFAULT NULL, `lieu_rdvsoutpsych` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note_rdvsoutpsych` longtext COLLATE utf8mb4_unicode_ci, `eng_just` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `renv_servjurd` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pourq_servjurd` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_rdvservjurd` datetime DEFAULT NULL, `lieu_rdvservjurd` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note_rdvservjurd` longtext COLLATE utf8mb4_unicode_ci, `renv_police` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pourq_renvpol` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_rdvrenpol` datetime DEFAULT NULL, `lieu_rdvrenpol` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note_rdvrenpol` longtext COLLATE utf8mb4_unicode_ci, `renv_prgsout` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pourq_pgmsout` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_revpgmsout` datetime DEFAULT NULL, `lieu_revpgmsout` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note_revpgmsout` longtext COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tmp_formstep5` -- LOCK TABLES `tmp_formstep5` WRITE; /*!40000 ALTER TABLE `tmp_formstep5` DISABLE KEYS */; INSERT INTO `tmp_formstep5` VALUES (1,NULL,NULL,NULL,'serv_psych',NULL,'non','serv_dejassur',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,'non','non','serv_dejassur',NULL,NULL,NULL,'non','serv_unit',NULL,NULL,NULL,'non','serv_disp',NULL,NULL,NULL,'2021-08-24 13:13:48','2021-09-02 19:44:23',2),(2,NULL,NULL,NULL,'serv_psych',NULL,'oui',NULL,'2021-08-19 10:03:18','Boulsa','Pas mal','non','serv_dejassur',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,'non','non','serv_dejassur',NULL,NULL,NULL,'oui',NULL,'2021-08-28 10:03:18','Youle','Ca va','non','serv_dejassur',NULL,NULL,NULL,'2021-08-24 15:27:32','2021-09-10 10:03:18',1),(3,NULL,NULL,NULL,'police_sec',NULL,'non','serv_unit',NULL,NULL,NULL,'non','serv_assur',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,'non','non','serv_unit',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'2021-08-25 14:44:54','2021-08-26 22:36:21',3),(4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-08-25 14:51:12','2021-08-25 14:51:12',4),(5,NULL,NULL,NULL,'police_sec',NULL,'oui',NULL,'2021-09-14 17:44:07','Action social','Bon acceuil','non','serv_unit',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,'non','non','serv_assur',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'2021-08-25 15:04:59','2021-09-14 17:44:07',5),(6,NULL,NULL,NULL,'lead_comm',NULL,'non','serv_assur',NULL,NULL,NULL,'non','serv_assur',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,'pas_dcid','non','serv_unit',NULL,NULL,NULL,'non','serv_assur',NULL,NULL,NULL,'non','rev_dec',NULL,NULL,NULL,'2021-08-25 16:46:26','2021-10-01 16:20:57',6),(7,NULL,NULL,NULL,'ass_jurd',NULL,'non','serv_dejassur',NULL,NULL,NULL,'non','serv_unit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'non','rev_dec',NULL,NULL,NULL,'2021-08-25 16:48:05','2021-09-09 10:51:53',7),(8,NULL,NULL,NULL,'serv_sant',NULL,'oui',NULL,'2021-09-06 13:34:31','Ouaga','Pas mal','non','serv_dejassur',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'non','serv_unit',NULL,NULL,NULL,'non','serv_assur',NULL,NULL,NULL,'2021-08-25 16:50:39','2021-10-09 13:34:31',8),(9,NULL,NULL,NULL,'serv_sant',NULL,'non','serv_dejassur',NULL,NULL,NULL,'non','serv_assur',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,'non','non','serv_assur','1970-01-01 20:02:37','','','non','serv_dejassur','1970-01-01 18:54:00','','','non','serv_dejassur','1970-01-01 18:54:00','','','2021-08-26 10:50:33','2021-08-26 20:16:27',9),(10,NULL,NULL,NULL,'serv_sant',NULL,'non','serv_assur',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'oui',NULL,'2021-09-13 10:22:05','Test 3','Test 2','oui','oui',NULL,'2021-09-14 10:22:05','Test 4','Test 2','non','serv_dejassur',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'2021-09-21 18:59:14','2021-09-29 10:22:05',10),(12,NULL,NULL,NULL,'police_sec',NULL,'oui',NULL,'2021-09-08 19:28:00','Test 4','Bon acceuil','non','serv_assur',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,'oui','non','serv_dejassur',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'2021-09-22 18:50:11','2021-09-22 19:28:00',12),(13,NULL,NULL,NULL,'serv_psych',NULL,NULL,NULL,NULL,NULL,NULL,'non','serv_assur',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'non','non','serv_assur',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'non','rev_dec',NULL,NULL,NULL,'2021-09-23 09:34:17','2021-09-27 22:06:17',13),(14,NULL,NULL,NULL,'ass_jurd',NULL,'non','serv_unit',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,'pas_dcid','non','serv_unit',NULL,NULL,NULL,'non','serv_unit',NULL,NULL,NULL,'non','serv_unit',NULL,NULL,NULL,'2021-09-23 10:01:06','2021-10-09 11:11:28',14),(15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-27 15:52:45','2021-09-27 15:52:45',15),(17,NULL,NULL,NULL,'ens_resps',NULL,'non','rev_dec',NULL,NULL,NULL,'non','serv_assur',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,'pas_dcid','non','serv_disp',NULL,NULL,NULL,'non','serv_assur',NULL,NULL,NULL,'non','serv_assur',NULL,NULL,NULL,'2021-09-29 12:01:46','2021-10-12 16:34:00',17),(18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-29 15:10:39','2021-09-29 15:10:39',18),(19,NULL,NULL,NULL,'ens_resps',NULL,'non','serv_unit',NULL,NULL,NULL,'non','serv_disp',NULL,NULL,NULL,'non',NULL,NULL,NULL,NULL,'non','non','serv_assur',NULL,NULL,NULL,'non','rev_dec',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'2021-10-09 13:35:32','2021-10-09 13:38:47',19); /*!40000 ALTER TABLE `tmp_formstep5` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tmp_formstep6` -- DROP TABLE IF EXISTS `tmp_formstep6`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tmp_formstep6` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sessions_id` int(11) DEFAULT NULL, `ref_inc` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code_user` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `etatem_debent` longtext COLLATE utf8mb4_unicode_ci, `ben_ensec` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pq_passec` longtext COLLATE utf8mb4_unicode_ci, `mes_prise` longtext COLLATE utf8mb4_unicode_ci, `etatem_finent` longtext COLLATE utf8mb4_unicode_ci, `qsoutem_ben` longtext COLLATE utf8mb4_unicode_ci, `info_pert` longtext COLLATE utf8mb4_unicode_ci, `exp_consviolb` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `exp_consviolp` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tmp_formstep6` -- LOCK TABLES `tmp_formstep6` WRITE; /*!40000 ALTER TABLE `tmp_formstep6` DISABLE KEYS */; INSERT INTO `tmp_formstep6` VALUES (1,NULL,NULL,NULL,'TEst','oui','','TEst','TEst','TEst','TEst','oui','oui','2021-08-24 13:13:48','2021-09-02 19:45:55',2),(2,NULL,NULL,NULL,' text1','oui','Sans soucis',' Text 5',' text 2',' text 3','Text 4 ','oui','oui','2021-08-24 15:27:32','2021-08-27 18:15:30',1),(3,NULL,NULL,NULL,'',NULL,'','','','','',NULL,NULL,'2021-08-25 14:44:54','2021-09-13 22:18:25',3),(4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-08-25 14:51:12','2021-08-25 14:51:12',4),(5,NULL,NULL,NULL,'Deprimé','oui','','Encadrement','Soulager','Un psychologue','Ras','oui','oui','2021-08-25 15:04:59','2021-09-14 18:55:20',5),(6,NULL,NULL,NULL,'Test 5','oui','','Test 5','Test 5','Test 5','Test 5','oui','oui','2021-08-25 16:46:26','2021-10-01 16:21:25',6),(7,NULL,NULL,NULL,'',NULL,'','','','','',NULL,NULL,'2021-08-25 16:48:05','2021-09-09 10:50:10',7),(8,NULL,NULL,NULL,'Il partiquement devarté','oui','','Non enncore identifier','Il est soulagé','Le publique','PAs d\'autre infos','non','oui','2021-08-25 16:50:39','2021-09-06 15:26:41',8),(9,NULL,NULL,NULL,'','oui','','','','','','non','oui','2021-08-26 10:50:33','2021-09-13 16:23:32',9),(10,NULL,NULL,NULL,'Test 2','non','Test','Test','Test','Test','Test',NULL,NULL,'2021-09-21 18:59:14','2021-09-21 19:16:27',10),(12,NULL,NULL,NULL,'Test 3','oui','','Test 3','Test 3','Test 3','Test 3','oui','oui','2021-09-22 18:50:11','2021-09-22 19:30:00',12),(13,NULL,NULL,NULL,'Test 5','oui','','Test 5','Test 4','Test 3','Test 6','oui','oui','2021-09-23 09:34:17','2021-09-27 22:06:56',13),(14,NULL,NULL,NULL,'Test Ok','oui','','Test Ok','Test Ok','Test Ok','Test Ok','oui','oui','2021-09-23 10:01:06','2021-10-09 11:12:02',14),(15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-27 15:52:45','2021-09-27 15:52:45',15),(17,NULL,NULL,NULL,'Test test','non','Test test','Test test','Test test','Test test','Test test','oui','oui','2021-09-29 12:01:46','2021-10-12 16:34:30',17),(18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-09-29 15:10:39','2021-09-29 15:10:39',18),(19,NULL,NULL,NULL,'Test Malie','oui','','Test Malie','Test Malie','Test Malie','Test Malie','non','oui','2021-10-09 13:35:32','2021-10-09 13:39:08',19); /*!40000 ALTER TABLE `tmp_formstep6` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `typ_prest` -- DROP TABLE IF EXISTS `typ_prest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `typ_prest` ( `id` int(11) NOT NULL AUTO_INCREMENT, `form_id` int(11) DEFAULT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nomprest` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CC6B78C65FF69B7D` (`form_id`), CONSTRAINT `FK_CC6B78C65FF69B7D` FOREIGN KEY (`form_id`) REFERENCES `tmp_formstep3` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `typ_prest` -- LOCK TABLES `typ_prest` WRITE; /*!40000 ALTER TABLE `typ_prest` DISABLE KEYS */; INSERT INTO `typ_prest` VALUES (1,1,'serv_psych','Ooo','2021-09-01 12:12:16','2021-09-01 12:25:07'),(2,1,'police_sec','Lll','2021-09-01 12:12:16','2021-09-01 12:25:07'),(3,1,'ass_jurd','Ttt','2021-09-01 12:12:16','2021-09-01 12:25:07'),(4,1,'lieu_sur','Marco','2021-09-01 13:03:21','2021-09-01 13:03:21'),(5,9,'serv_sant','RAS','2021-09-13 16:22:57','2021-09-13 16:22:57'),(6,9,'ass_jurd','RAS 2','2021-09-13 16:22:57','2021-09-13 16:22:57'),(7,3,'serv_psych','Ecole','2021-09-13 22:44:47','2021-09-13 22:44:47'),(8,3,'lieu_sur','ONG','2021-09-13 22:44:47','2021-09-13 22:44:47'),(9,5,'ass_jurd','Action social','2021-09-14 17:42:07','2021-09-14 17:42:07'),(10,5,'lieu_sur','Hcr','2021-09-14 17:42:07','2021-09-14 17:42:07'),(11,12,'serv_psych','TEst','2021-09-22 19:23:05','2021-09-22 19:23:05'),(12,12,'pgme_sout','Test 2','2021-09-22 19:23:05','2021-09-22 19:23:05'),(13,12,'autr_servp','Test 5','2021-09-22 19:23:05','2021-09-22 19:23:05'),(14,19,'ass_jurd','Test mali','2021-10-09 13:37:51','2021-10-09 13:37:51'),(15,19,'lieu_sur','Test Malie','2021-10-09 13:37:51','2021-10-09 13:37:51'),(16,17,'serv_psych','Psycholohgue','2021-10-12 16:17:31','2021-10-12 16:17:31'); /*!40000 ALTER TABLE `typ_prest` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `type_partenaire` -- DROP TABLE IF EXISTS `type_partenaire`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `type_partenaire` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `type_partenaire` -- LOCK TABLES `type_partenaire` WRITE; /*!40000 ALTER TABLE `type_partenaire` DISABLE KEYS */; INSERT INTO `type_partenaire` VALUES (1,'Medicine','2021-10-04 16:36:23','2021-10-04 16:36:23','med'),(2,'Medicine','2021-10-04 16:40:30','2021-10-04 16:40:30','med'); /*!40000 ALTER TABLE `type_partenaire` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `type_violence` -- DROP TABLE IF EXISTS `type_violence`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `type_violence` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `type_violence` -- LOCK TABLES `type_violence` WRITE; /*!40000 ALTER TABLE `type_violence` DISABLE KEYS */; INSERT INTO `type_violence` VALUES (3,'Violence sexuelle','2021-03-19 13:54:19',NULL),(4,'Violence physique','2021-03-19 13:57:06',NULL),(5,'Violence socio-économique','2021-03-19 13:57:43',NULL),(6,'Violence psychologique ou affective','2021-03-19 13:59:00',NULL),(7,'Pratiques néfastes','2021-03-19 14:00:58',NULL),(8,'Autres types','2021-03-19 20:42:45',NULL); /*!40000 ALTER TABLE `type_violence` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `type_violence_translation` -- DROP TABLE IF EXISTS `type_violence_translation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `type_violence_translation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `source_id` int(11) DEFAULT NULL, `locale` varchar(5) DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_DE69FC6A953C1C61` (`source_id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `type_violence_translation` -- LOCK TABLES `type_violence_translation` WRITE; /*!40000 ALTER TABLE `type_violence_translation` DISABLE KEYS */; INSERT INTO `type_violence_translation` VALUES (1,3,'en','Sexual violence','2021-03-19 13:54:19','2021-10-25 19:46:57'),(2,4,'en','Physical violence','2021-03-19 13:57:06','2021-10-25 19:46:57'),(3,5,'en','Socio-economic violence','2021-03-19 13:57:43','2021-10-25 19:46:57'),(4,6,'en','Psychological or emotional violence','2021-03-19 13:59:00','2021-10-25 19:46:57'),(5,7,'en','Harmful practices','2021-03-19 14:00:58','2021-10-25 19:46:57'),(6,8,'en','Other types','2021-03-19 20:42:45','2021-10-25 19:46:57'),(7,3,'ar','العنف الجنسي','2021-03-19 13:54:19','2021-10-25 20:04:08'),(8,4,'ar','العنف الجسدي','2021-03-19 13:57:06','2021-10-25 20:04:08'),(9,5,'ar','العنف الاجتماعي والاقتصادي','2021-03-19 13:57:43','2021-10-25 20:04:08'),(10,6,'ar','العنف النفسي أو العاطفي','2021-03-19 13:59:00','2021-10-25 20:04:08'),(11,7,'ar','الممارسات الضارة','2021-03-19 14:00:58','2021-10-25 20:04:08'),(12,8,'ar','أنواع أخرى','2021-03-19 20:42:45','2021-10-25 20:04:08'); /*!40000 ALTER TABLE `type_violence_translation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile_id` int(11) DEFAULT NULL, `pays_id` int(11) DEFAULT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `prenom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) DEFAULT NULL, `is_verified` tinyint(1) DEFAULT NULL, `control_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_8D93D649CCFA12B8` (`profile_id`), KEY `IDX_8D93D649A6E44244` (`pays_id`), CONSTRAINT `FK_8D93D649A6E44244` FOREIGN KEY (`pays_id`) REFERENCES `pays` (`id`), CONSTRAINT `FK_8D93D649CCFA12B8` FOREIGN KEY (`profile_id`) REFERENCES `profile` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user` -- LOCK TABLES `user` WRITE; /*!40000 ALTER TABLE `user` DISABLE KEYS */; INSERT INTO `user` VALUES (1,1,3,'Potter','Son','henri','admin@example.com','$2y$12$cZNnMi.rTX3GRXVgmvGSauP2gtnQkKAe4uejkfQPk/EfSkgZhUtEC','',1,1,NULL,'2021-08-11 12:50:00','2021-08-11 12:50:00'),(2,2,2,'Potter','Son','test2','admin1@example.com','$2y$12$cZNnMi.rTX3GRXVgmvGSauP2gtnQkKAe4uejkfQPk/EfSkgZhUtEC','',1,1,NULL,'2021-08-11 12:50:00','2021-08-11 12:50:00'),(3,2,1,'Potter','Son','test3','admin3@example.com','$2y$12$cZNnMi.rTX3GRXVgmvGSauP2gtnQkKAe4uejkfQPk/EfSkgZhUtEC','',1,1,NULL,'2021-08-11 12:50:00','2021-08-11 12:50:00'),(4,2,5,'Potter','Son','test4','admin3@example.com','$2y$12$cZNnMi.rTX3GRXVgmvGSauP2gtnQkKAe4uejkfQPk/EfSkgZhUtEC','',1,1,NULL,'2021-08-11 12:50:00','2021-08-11 12:50:00'),(5,2,6,'Potter','Son','test5','admin5@example.com','$2y$12$cZNnMi.rTX3GRXVgmvGSauP2gtnQkKAe4uejkfQPk/EfSkgZhUtEC','',1,1,NULL,'2021-08-11 12:50:00','2021-08-11 12:50:00'),(6,2,3,'Henri','Potter','test1','koudaogo2@gmail.com','$2y$12$cZNnMi.rTX3GRXVgmvGSauP2gtnQkKAe4uejkfQPk/EfSkgZhUtEC','',1,1,'','2021-09-29 09:46:19','2021-09-29 09:46:19'),(7,2,3,'Henri','Potter','test10','koudaogo2@gmail.com','$2y$12$cZNnMi.rTX3GRXVgmvGSauP2gtnQkKAe4uejkfQPk/EfSkgZhUtEC','',1,1,'','2021-09-29 10:49:28','2021-09-29 10:49:28'),(8,2,5,'Zongo','Paul','paulin','paul@gmail.com','$2y$12$laMns1TVw/J7zXT7qGqFUu6dKdpfN0CW0FFDENbvM9Qk16Tz9jkq.',NULL,1,1,'','2021-10-12 16:51:00','2021-10-12 16:57:22'); /*!40000 ALTER TABLE `user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `victime` -- DROP TABLE IF EXISTS `victime`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `victime` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `prenom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `telephone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `anonyme` tinyint(1) NOT 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 `victime` -- LOCK TABLES `victime` WRITE; /*!40000 ALTER TABLE `victime` DISABLE KEYS */; /*!40000 ALTER TABLE `victime` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2021-10-26 15:22:36