--
-- Host: localhost    Database: deenal
-- ------------------------------------------------------


--
-- Table structure for table `ad_partenaire`
--

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`),
  CONSTRAINT `FK_CD76F0C998DE13AC` FOREIGN KEY (`partenaire_id`) REFERENCES `partenaires` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ad_partenaire`
--

INSERT INTO `ad_partenaire` VALUES (1,1,'andi@gmail.com','2021-10-30 19:22:15','2021-10-30 19:22:15'),(2,2,'andi@gmail.com','2021-11-03 21:32:09','2021-11-03 21:32:09');

--
-- Table structure for table `cas`
--

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;

--
-- Dumping data for table `cas`
--


--
-- Table structure for table `cron_job`
--

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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cron_job`
--


--
-- Table structure for table `cron_report`
--

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`),
  CONSTRAINT `FK_B6C6A7F5BE04EA9` FOREIGN KEY (`job_id`) REFERENCES `cron_job` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cron_report`
--


--
-- Table structure for table `doctrine_migration_versions`
--

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;

--
-- Dumping data for table `doctrine_migration_versions`
--

INSERT INTO `doctrine_migration_versions` VALUES ('DoctrineMigrations\\Version20211026151436','2021-10-26 15:15:12',83010);

--
-- Table structure for table `etat`
--

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;

--
-- Dumping data for table `etat`
--

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');

--
-- Table structure for table `etat_cas`
--

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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sharable` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `partenaires_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_46E10F937B7A91FA` (`cas_id`),
  KEY `IDX_46E10F93D5E86FF` (`etat_id`),
  KEY `FK_46E10F9338898CF5` (`partenaires_id`),
  CONSTRAINT `FK_46E10F9338898CF5` FOREIGN KEY (`partenaires_id`) REFERENCES `partenaires` (`id`),
  CONSTRAINT `FK_46E10F937B7A91FA` FOREIGN KEY (`cas_id`) REFERENCES `signal` (`id`),
  CONSTRAINT `FK_46E10F93D5E86FF` FOREIGN KEY (`etat_id`) REFERENCES `etat` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `etat_cas`
--

INSERT INTO `etat_cas` VALUES (1,1,1,NULL,NULL,NULL,NULL,'2021-10-27 18:46:07','2021-10-27 18:46:07',NULL),(2,1,2,NULL,'test10',NULL,NULL,'2021-10-27 18:53:07','2021-10-27 18:53:07',NULL),(3,2,1,NULL,NULL,NULL,NULL,'2021-10-28 20:58:19','2021-10-28 20:58:19',NULL),(4,2,4,NULL,'henri',NULL,NULL,'2021-11-01 21:03:51','2021-11-01 21:03:51',NULL),(5,3,1,NULL,NULL,NULL,NULL,'2021-11-01 21:05:56','2021-11-01 21:05:56',NULL),(6,4,1,NULL,NULL,NULL,NULL,'2021-11-01 21:08:51','2021-11-01 21:08:51',NULL),(7,4,4,NULL,'test1',NULL,NULL,'2021-11-02 11:42:46','2021-11-02 11:42:46',NULL),(8,5,1,NULL,NULL,NULL,NULL,'2021-11-02 14:12:31','2021-11-02 14:12:31',NULL),(9,5,2,NULL,'test1',NULL,NULL,'2021-11-02 14:41:56','2021-11-02 14:41:56',NULL),(10,6,1,NULL,NULL,NULL,NULL,'2021-11-02 14:52:24','2021-11-02 14:52:24',NULL),(11,6,2,NULL,'test10',NULL,NULL,'2021-11-02 14:53:31','2021-11-02 14:53:31',NULL),(12,7,1,NULL,NULL,NULL,NULL,'2021-11-02 14:56:24','2021-11-02 14:56:24',NULL),(13,7,2,NULL,'test10',NULL,NULL,'2021-11-02 14:59:15','2021-11-02 14:59:15',NULL),(14,5,3,NULL,'test1',NULL,NULL,'2021-11-02 18:21:23','2021-11-02 18:21:23',NULL),(15,8,1,NULL,NULL,NULL,NULL,'2021-11-03 20:41:45','2021-11-03 20:41:45',NULL),(16,9,1,NULL,NULL,NULL,NULL,'2021-11-03 20:46:53','2021-11-03 20:46:53',NULL),(17,10,1,NULL,NULL,NULL,NULL,'2021-11-03 20:47:35','2021-11-03 20:47:35',NULL),(18,10,2,NULL,'test1',NULL,NULL,'2021-11-03 20:48:42','2021-11-03 20:48:42',NULL),(19,9,2,NULL,'test1',NULL,NULL,'2021-11-06 13:18:24','2021-11-06 13:18:24',NULL),(20,11,1,NULL,NULL,NULL,NULL,'2021-11-11 15:59:16','2021-11-11 15:59:16',NULL),(21,5,4,NULL,'test1',NULL,NULL,'2021-11-11 17:01:38','2021-11-11 17:01:38',NULL),(22,1,4,NULL,'test1',NULL,NULL,'2021-11-19 15:34:21','2021-11-19 15:34:21',NULL);
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 ;

--
-- Table structure for table `forme_violence`
--

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;

--
-- Dumping data for table `forme_violence`
--

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);

--
-- Table structure for table `forme_violence_translation`
--

CREATE TABLE `forme_violence_translation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source_id` int(11) DEFAULT NULL,
  `locale` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forme` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_BD9D5FC5953C1C61` (`source_id`),
  CONSTRAINT `FK_BD9D5FC5953C1C61` FOREIGN KEY (`source_id`) REFERENCES `forme_violence` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `forme_violence_translation`
--

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');

--
-- Table structure for table `params`
--

CREATE TABLE `params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cle` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lib` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ctab` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `params`
--

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');

--
-- Table structure for table `partenaires`
--

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,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D230102EA6E44244` (`pays_id`),
  KEY `IDX_D230102EC54C8C93` (`type_id`),
  CONSTRAINT `FK_D230102EA6E44244` FOREIGN KEY (`pays_id`) REFERENCES `pays` (`id`),
  CONSTRAINT `FK_D230102EC54C8C93` FOREIGN KEY (`type_id`) REFERENCES `type_partenaire` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partenaires`
--

INSERT INTO `partenaires` VALUES (1,3,2,'Prestataire 1','Technicien','aero','1234567','1234567','2021-10-30 19:22:15','2021-10-30 19:22:15',NULL),(2,3,6,'Cacaoté','Technique','Hommage','1234567','1234567','2021-11-03 21:32:09','2021-11-11 16:07:42','koudaogo2@gmail.com');

--
-- Table structure for table `pays`
--

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,
  `numvert` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `imgname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pays`
--

INSERT INTO `pays` VALUES (1,'Senegal','+221','800-805-805','contact@deenalor.org','sn','senegal','2021-10-26 16:11:03','2021-10-28 14:55:06'),(2,'Mali','+223','777777','','ml','mali','2021-10-26 16:11:03','2021-10-26 16:11:03'),(3,'Burkina Faso','+226','777777','','bf','burkina','2021-10-26 16:11:03','2021-10-26 16:11:03'),(4,'Niger','+227','777777','','ne','niger','2021-10-26 16:11:03','2021-10-26 16:11:03'),(5,'Mauritanie','+222','777777','','mr','mauritanie','2021-10-26 16:11:03','2021-10-26 16:11:03'),(6,'Tchad','+235','777777','','td','tchad','2021-10-26 16:11:03','2021-10-26 16:11:03');

--
-- Table structure for table `pays_info`
--

CREATE TABLE `pays_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pays_id` int(11) DEFAULT NULL,
  `paragraphe1` longtext COLLATE utf8mb4_unicode_ci,
  `paragraphe2` longtext COLLATE utf8mb4_unicode_ci,
  `paragraphe3` longtext COLLATE utf8mb4_unicode_ci,
  `paragraphe4` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_AE232B98A6E44244` (`pays_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pays_info`
--

INSERT INTO `pays_info` VALUES (1,3,'Trois centres (03) centres d\'écoute sont ouverts à Ngalamia, Ngomirom Doumou et Selia (village dans les îles du canton Bol) pour assurer la prise en charge des survivantes des VBG.','Le centre d42coute de Bagasola est fonctionnel pour l\'aide jurique et l\'assistance des victimes des VBG avec une stratégie avancée devant couvrir les sous-prefectures de Liwa et Daboua.',NULL,NULL),(2,2,'Trois centres (03) centres d\'écoute sont ouverts à Ngalamia, Ngomirom Doumou et Selia (village dans les îles du canton Bol) pour assurer la prise en charge des survivantes des VBG','Le centre d\'écoute de Bagasola est fonctionnel pour l\'aide jurique et l\'assistance des victimes des VBG avec une stratégie avancée devant couvrir les sous-prefectures de Liwa et Daboua.',NULL,NULL),(3,1,'Trois centres (03) centres d\'écoute sont ouverts à Ngalamia, Ngomirom Doumou et Selia (village dans les îles du canton Bol) pour assurer la prise en charge des survivantes des VBG.','Le centre d42coute de Bagasola est fonctionnel pour l\'aide jurique et l\'assistance des victimes des VBG avec une stratégie avancée devant couvrir les sous-prefectures de Liwa et Daboua.',NULL,NULL);

--
-- Table structure for table `pays_monde`
--

CREATE TABLE `pays_monde` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` int(11) NOT NULL,
  `alpha2` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alpha3` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nom_en_gb` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nom_fr_fr` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pays_monde`
--

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');

--
-- Table structure for table `profile`
--

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;

--
-- Dumping data for table `profile`
--

INSERT INTO `profile` VALUES (1,'Administrateur','11',NULL,NULL),(2,'Gestionnaire','22',NULL,NULL);

--
-- Table structure for table `referencement`
--

CREATE TABLE `referencement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patenaire_id` int(11) DEFAULT NULL,
  `cas_id` int(11) DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_83A125FEF622EC9C` (`patenaire_id`),
  KEY `IDX_83A125FE7B7A91FA` (`cas_id`),
  CONSTRAINT `FK_83A125FE7B7A91FA` FOREIGN KEY (`cas_id`) REFERENCES `signal` (`id`),
  CONSTRAINT `FK_83A125FEF622EC9C` FOREIGN KEY (`patenaire_id`) REFERENCES `partenaires` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `referencement`
--

INSERT INTO `referencement` VALUES (1,2,1,'AZDEFRGTHN','2021-11-19 14:51:29','2021-11-19 14:51:29'),(2,2,1,'zertrfczads','2021-11-19 14:56:15','2021-11-19 14:56:15');

--
-- Table structure for table `region`
--

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;

--
-- Dumping data for table `region`
--

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);

--
-- Table structure for table `sessions`
--

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=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES (1,NULL,'127.0.0.1','on','henri',NULL,NULL,'2021-10-26 16:16:39','2021-10-26 16:16:39'),(2,NULL,'127.0.0.1','on','test3',NULL,NULL,'2021-10-26 16:17:56','2021-10-26 16:17:56'),(3,NULL,'127.0.0.1','on','test1',NULL,NULL,'2021-10-27 18:23:44','2021-10-27 18:23:44'),(4,NULL,'127.0.0.1','on','test10',NULL,NULL,'2021-10-27 18:52:16','2021-10-27 18:52:16'),(5,NULL,'127.0.0.1','on','test2',NULL,NULL,'2021-11-01 21:04:35','2021-11-01 21:04:35');

--
-- Table structure for table `signal`
--

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,
  `userc` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `prise` tinyint(1) DEFAULT '0',
  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=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `signal`
--

INSERT INTO `signal` VALUES (1,205,16,'Henri','Kabore','+226','1234567','andi@gmail.com','dfghj',0,0,'reference','2021-11-19 15:34:21','ID271021064607','test1','2021-10-27 18:46:07','2021-11-02 14:44:10',1),(2,185,25,'Henri','Kabore','+226','1234567','andi@gmail.com','rtgyhjk',0,0,'reference','2021-11-01 21:03:51','ID281021085819','henri','2021-10-28 20:58:19','2021-11-02 20:38:10',1),(3,48,7,NULL,NULL,'+223','56387649','outa@gmail.com','Ok OK',1,1,'non_prise','2021-11-01 21:05:56','ID011121090556',NULL,'2021-11-01 21:05:56','2021-11-01 21:05:56',0),(4,208,1,NULL,NULL,'+226','64298763','dano@gmail.com','Ok a',0,1,'reference','2021-11-02 11:42:46','ID011121090850','test1','2021-11-01 21:08:50','2021-11-02 20:38:37',1),(5,224,21,NULL,NULL,'+226','6736389','koudaogo2@gmail.com','Ok wep',0,1,'reference','2021-11-11 17:01:38','ID021121021231','test1','2021-11-02 14:12:31','2021-11-02 14:14:16',1),(6,185,7,NULL,NULL,'+226','7834648','uu@gmil.com','Test',0,1,'en_cours','2021-11-02 14:53:31','ID021121025224','test10','2021-11-02 14:52:24','2021-11-02 14:52:58',1),(7,174,6,NULL,NULL,'+226','67094843','gam@gmail.com','Test 2',0,1,'en_cours','2021-11-02 14:59:15','ID021121025624','test10','2021-11-02 14:56:24','2021-11-02 14:58:49',1),(8,185,7,'Jacob','Pilogo','+226','65229843','pil@gmail.com',' Mon cas de test',0,0,'non_prise','2021-11-03 20:41:45','UD031121084145',NULL,'2021-11-03 20:41:45','2021-11-03 20:41:45',NULL),(9,185,9,'Zelle','Yari','+226','67948829','zori@gmail.com',' Je dit ok',0,0,'en_cours','2021-11-06 13:18:24','UD031121084652','test1','2021-11-03 20:46:52','2021-11-06 13:18:05',1),(10,185,9,'Zelle','Yari','+226','67948829','zori@gmail.com',' Je dit ok',0,0,'en_cours','2021-11-03 20:48:42','UD031121084735','test1','2021-11-03 20:47:35','2021-11-03 20:48:12',1),(11,10,7,'Kabore','Henri','+221','6984773987','kkoudaogo@gmail.com','Test en core',1,0,'non_prise','2021-11-11 15:59:16','ID111121035916',NULL,'2021-11-11 15:59:16','2021-11-11 15:59:16',NULL);

--
-- Table structure for table `tmp_formstep1`
--

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`),
  UNIQUE KEY `UNIQ_F604F82C537D9BE8` (`ref_inc`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tmp_formstep1`
--

INSERT INTO `tmp_formstep1` VALUES (1,NULL,'1','ID271021064607','test10','2021-10-27 18:53:07','2021-10-27 18:53:07','surv','Burkina Faso','2021-10-27 18:53:07','2021-10-27 18:53:07'),(2,NULL,'5','ID021121021231','test1','2021-11-02 14:41:56','2021-11-02 14:41:56','surv','Burkina Faso','2021-11-02 14:41:56','2021-11-02 14:41:56'),(3,NULL,'6','ID021121025224','test10','2021-11-02 14:53:31','2021-11-02 14:53:31','autr_per','Burkina Faso','2021-11-02 14:53:31','2021-11-02 14:53:31'),(6,NULL,'7','ID021121025624','test10','2021-11-02 14:59:14','2021-11-02 14:59:14','autr_per','Burkina Faso','2021-11-02 14:59:14','2021-11-02 14:59:14'),(7,NULL,'10','UD031121084735','test1','2021-11-03 13:17:24','2021-11-08 13:17:24','autr_per','Burkina Faso','2021-11-03 20:48:42','2021-11-06 13:17:24'),(8,NULL,'9','UD031121084652','test1','2021-09-21 13:18:23','2021-11-05 13:18:23','autr_per','Burkina Faso','2021-11-06 13:18:23','2021-11-06 13:18:23');

--
-- Table structure for table `tmp_formstep2`
--

CREATE TABLE `tmp_formstep2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_6F0DA996727ACA70` (`parent_id`),
  CONSTRAINT `FK_6F0DA996727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `tmp_formstep1` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tmp_formstep2`
--

INSERT INTO `tmp_formstep2` VALUES (1,1,NULL,NULL,NULL,'1997-05-12 18:54:16','h','Bete','Burkina Faso','Côte d\'Ivoire','Catholique','marie',3,'Professionne','refugie','hand_phys','min_nacc',NULL,NULL,NULL,NULL,'2021-10-27 18:53:07','2021-10-27 18:54:16'),(2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:41:56','2021-11-02 14:41:56'),(3,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:53:31','2021-11-02 14:53:31'),(4,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:59:14','2021-11-02 14:59:14'),(5,7,NULL,NULL,NULL,'2016-04-23 20:50:30','f','Mossi','Burkina Faso','Burkina Faso','Catholique','marie',2,'Etudiant','res_entr','hand_ment','enf_sep',NULL,NULL,NULL,NULL,'2021-11-03 20:48:42','2021-11-03 20:50:30'),(6,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-06 13:18:23','2021-11-06 13:18:23');

--
-- Table structure for table `tmp_formstep3`
--

CREATE TABLE `tmp_formstep3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `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,
  `souzon_inc` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `camvil_inc` varchar(200) 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_180A9900727ACA70` (`parent_id`),
  CONSTRAINT `FK_180A9900727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `tmp_formstep1` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tmp_formstep3`
--

INSERT INTO `tmp_formstep3` VALUES (1,1,NULL,NULL,NULL,'Mon premier test en prod','enc_raptrmt',NULL,'ap_midi','dom_ben',NULL,'ville','Kologho','YAka','den_res','mgf_e','non','cons_force','oui','oui','oui','Ca cest passé comme cela','2021-10-27 18:53:07','2021-10-27 18:55:45'),(2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:41:56','2021-11-02 14:41:56'),(3,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:53:31','2021-11-02 14:53:31'),(4,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:59:14','2021-11-02 14:59:14'),(5,7,NULL,NULL,NULL,'Test','enc_raptrmt',NULL,'soir','route',NULL,'ville','Ouaga','Ouaga','den_res','exig_dot','non','cons_force','non',NULL,'non',NULL,'2021-11-03 20:48:42','2021-11-03 20:51:29'),(6,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-06 13:18:23','2021-11-06 13:18:23');

--
-- Table structure for table `tmp_formstep4`
--

CREATE TABLE `tmp_formstep4` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_866E0CA3727ACA70` (`parent_id`),
  CONSTRAINT `FK_866E0CA3727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `tmp_formstep1` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tmp_formstep4`
--

INSERT INTO `tmp_formstep4` VALUES (1,1,NULL,NULL,NULL,2,'f','Malien','Dioula','41-60','ref_rapat','emp_cbo','2021-10-27 18:53:07','2021-10-27 18:56:29'),(2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:41:56','2021-11-02 14:41:56'),(3,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:53:31','2021-11-02 14:53:31'),(4,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:59:14','2021-11-02 14:59:14'),(5,7,NULL,NULL,NULL,2,'f','Pora','Ouq','18-25','superv_emp','acteur_netat','2021-11-03 20:48:42','2021-11-03 20:52:08'),(6,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-06 13:18:23','2021-11-06 13:18:23');

--
-- Table structure for table `tmp_formstep5`
--

CREATE TABLE `tmp_formstep5` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_F1693C35727ACA70` (`parent_id`),
  CONSTRAINT `FK_F1693C35727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `tmp_formstep1` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tmp_formstep5`
--

INSERT INTO `tmp_formstep5` VALUES (1,1,NULL,NULL,NULL,'police_sec',NULL,'non','serv_dejassur',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'oui',NULL,'2021-10-28 18:57:17','Test','Bien ','non','non','serv_dejassur',NULL,NULL,NULL,'non','serv_unit',NULL,NULL,NULL,'oui',NULL,'2021-10-07 18:57:17','Test 2','Bien','2021-10-27 18:53:07','2021-10-27 18:57:17'),(2,2,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-11-02 14:41:56','2021-11-02 14:41:56'),(3,3,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-11-02 14:53:31','2021-11-02 14:53:31'),(4,6,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-11-02 14:59:14','2021-11-02 14:59:14'),(5,7,NULL,NULL,NULL,'ass_jurd',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_dejassur',NULL,NULL,NULL,'non','serv_dejassur',NULL,NULL,NULL,'2021-11-03 20:48:42','2021-11-03 20:52:48'),(6,8,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-11-06 13:18:23','2021-11-06 13:18:23');

--
-- Table structure for table `tmp_formstep6`
--

CREATE TABLE `tmp_formstep6` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_68606D8F727ACA70` (`parent_id`),
  CONSTRAINT `FK_68606D8F727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `tmp_formstep1` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tmp_formstep6`
--

INSERT INTO `tmp_formstep6` VALUES (1,1,NULL,NULL,NULL,'Test Ok','oui','','Test Ok','Test Ok','Test Ok','Test Ok','non','oui','2021-10-27 18:53:07','2021-10-27 18:57:39'),(2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:41:56','2021-11-02 14:41:56'),(3,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:53:31','2021-11-02 14:53:31'),(4,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-02 14:59:14','2021-11-02 14:59:14'),(5,7,NULL,NULL,NULL,'Test','oui','','TEst','Test','Test','Test','oui','oui','2021-11-03 20:48:42','2021-11-03 20:53:14'),(6,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-06 13:18:23','2021-11-06 13:18:23');

--
-- Table structure for table `typ_prest`
--

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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `typ_prest`
--

INSERT INTO `typ_prest` VALUES (1,1,'serv_sant','Medecine tag','2021-10-27 18:55:45','2021-10-27 18:55:45'),(2,1,'ass_jurd','Commisariat de police','2021-10-27 18:55:45','2021-10-27 18:55:45');

--
-- Table structure for table `type_partenaire`
--

CREATE TABLE `type_partenaire` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `type_partenaire`
--

INSERT INTO `type_partenaire` VALUES (1,'Medcine','CODE','2021-10-30 19:20:56','2021-10-30 19:20:56'),(2,'Medcine','CODE','2021-10-30 19:21:21','2021-10-30 19:21:21'),(3,'Medcine','CODE','2021-10-30 19:21:24','2021-10-30 19:21:24'),(4,'Juridique','Jurique','2021-11-03 21:28:19','2021-11-03 21:28:19'),(5,'Politique','01006','2021-11-03 21:29:28','2021-11-03 21:29:28'),(6,'Justiciable','03001','2021-11-03 21:31:16','2021-11-03 21:31:16');

--
-- Table structure for table `type_violence`
--

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;

--
-- Dumping data for table `type_violence`
--

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);

--
-- Table structure for table `type_violence_translation`
--

CREATE TABLE `type_violence_translation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source_id` int(11) DEFAULT NULL,
  `locale` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_DE69FC6A953C1C61` (`source_id`),
  CONSTRAINT `FK_DE69FC6A953C1C61` FOREIGN KEY (`source_id`) REFERENCES `type_violence` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `type_violence_translation`
--

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');

--
-- Table structure for table `victime`
--

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;

--
-- Dumping data for table `victime`
--



