-- --------------------------------------------------------
-- Hôte:                         127.0.0.1
-- Version du serveur:           5.7.33 - MySQL Community Server (GPL)
-- SE du serveur:                Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------



-- Listage de la structure de la base pour afrobase_api
CREATE DATABASE IF NOT EXISTS `afrobase_api` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `afrobase_api`;

-- Listage de la structure de la table afrobase_api. annonces
CREATE TABLE IF NOT EXISTS `annonces` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titre` varchar(50) DEFAULT NULL,
  `contenue` text,
  `auteur` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `User_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `SecteurActivites_id` int(11) DEFAULT NULL,
  `prix` float DEFAULT NULL,
  `devise` varchar(50) DEFAULT NULL,
  `Pays_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Annonce_User1_idx` (`User_id`),
  KEY `fk_Annonces_SecteurActiviter1_idx` (`SecteurActivites_id`),
  KEY `Pays_id` (`Pays_id`),
  CONSTRAINT `Pays_id` FOREIGN KEY (`Pays_id`) REFERENCES `pays` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Annonce_User1` FOREIGN KEY (`User_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Annonces_SecteurActiviter1` FOREIGN KEY (`SecteurActivites_id`) REFERENCES `secteuractivites` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.annonces : ~22 rows (environ)
INSERT INTO `annonces` (`id`, `titre`, `contenue`, `auteur`, `createdAt`, `updatedAt`, `User_id`, `status`, `SecteurActivites_id`, `prix`, `devise`, `Pays_id`) VALUES
	(54, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 14:38:53', '2022-05-17 16:26:31', 1, 1, 1, NULL, NULL, NULL),
	(96, 'été', 'uiggkb', 'ubiibbjikb', '2022-05-17 20:40:38', '2022-05-18 10:17:50', 1, 1, 1, 0, '', 2),
	(97, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:01:23', '2022-05-17 21:01:23', 1, 1, 1, NULL, NULL, NULL),
	(98, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:13:26', '2022-05-17 21:13:26', 1, 1, 1, NULL, NULL, 2),
	(99, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:13:31', '2022-05-18 20:20:45', 1, 0, 1, NULL, NULL, NULL),
	(100, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:47:08', '2022-05-17 21:47:08', 1, 1, 1, 1258, NULL, NULL),
	(101, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:53:53', '2022-05-17 21:53:53', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(102, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:54:41', '2022-05-17 21:54:41', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(103, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:55:00', '2022-05-17 21:55:00', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(104, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:55:23', '2022-05-17 21:55:23', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(105, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:56:29', '2022-05-17 21:56:29', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(106, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:57:22', '2022-05-17 21:57:22', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(107, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:57:25', '2022-05-17 21:57:25', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(108, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:57:33', '2022-05-17 21:57:33', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(109, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 21:57:38', '2022-05-17 21:57:38', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(110, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 22:38:54', '2022-05-17 22:38:54', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(111, 'bqbf', 'uiggkb', 'ubiibbjikb', '2022-05-17 22:39:38', '2022-05-17 22:39:38', 1, 1, 1, 1258, 'Francs CFA', NULL),
	(112, 'KOFInnvn', 'brhtdbrt y hggh btvn   s  s bgbxfbfxx', 'KOERDN', '2022-05-18 09:54:37', '2022-05-18 09:54:37', 1, 1, 1, 2500, 'Euro', 1),
	(114, 'KOFInnvn', '', 'KODJO', '2022-05-18 10:04:34', '2022-05-18 10:04:34', 1, 1, 1, 0, 'Euro', 1),
	(115, 'été', 'uiggkb', 'ubiibbjikb', '2022-05-18 10:14:13', '2022-05-18 10:14:13', 1, 1, 1, 1258, '', 3),
	(116, 'été', 'uiggkb', 'ubiibbjikb', '2022-05-18 10:14:39', '2022-05-18 10:14:39', 1, 1, 1, 1258, '', 3),
	(117, 'été', 'uiggkb', 'ubiibbjikb', '2022-05-18 10:15:04', '2022-05-18 10:15:04', 1, 1, 1, 1258, '', 3);

-- Listage de la structure de la table afrobase_api. continents
CREATE TABLE IF NOT EXISTS `continents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.continents : ~2 rows (environ)
INSERT INTO `continents` (`id`, `libelle`, `createdAt`, `updatedAt`, `status`) VALUES
	(1, 'Afrique', '2022-04-21 12:00:40', '2022-04-21 12:00:40', 1),
	(2, 'Asie', '2022-04-21 12:00:57', '2022-04-21 12:00:57', 1),
	(3, 'All', '2022-05-18 10:08:41', '2022-05-18 10:08:41', 1);

-- Listage de la structure de la table afrobase_api. filiales
CREATE TABLE IF NOT EXISTS `filiales` (
  `id` int(11) NOT NULL,
  `libelle` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `BP` varchar(50) DEFAULT NULL,
  `Dirigeant` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `Societe_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `Villes_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Filiale_Societe1_idx` (`Societe_id`),
  KEY `fk_Filiales_Villes1_idx` (`Villes_id`),
  CONSTRAINT `fk_Filiale_Societe1` FOREIGN KEY (`Societe_id`) REFERENCES `societes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Filiales_Villes1` FOREIGN KEY (`Villes_id`) REFERENCES `villes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.filiales : ~0 rows (environ)

-- Listage de la structure de la table afrobase_api. horaires
CREATE TABLE IF NOT EXISTS `horaires` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `HeurOuverture` time DEFAULT NULL,
  `HeurFermeture` time DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `jour` enum('Lundi','Mardi','Mecredi','Jeudi','Vendredi','Samedi','Dimanche') DEFAULT NULL,
  `Societe_id` int(11) DEFAULT NULL,
  `Filiale_id` int(11) DEFAULT NULL,
  `Horairescol` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Horaire_Societe1_idx` (`Societe_id`),
  KEY `fk_Horaire_Filiale1_idx` (`Filiale_id`),
  CONSTRAINT `fk_Horaire_Filiale1` FOREIGN KEY (`Filiale_id`) REFERENCES `filiales` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Horaire_Societe1` FOREIGN KEY (`Societe_id`) REFERENCES `societes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.horaires : ~0 rows (environ)

-- Listage de la structure de la table afrobase_api. images
CREATE TABLE IF NOT EXISTS `images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `libelle` varchar(255) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `Annonce_id` int(11) DEFAULT NULL,
  `TypeImage_id` int(11) NOT NULL,
  `Societe_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `Produit_id` int(11) DEFAULT NULL,
  `Professionel_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Image_Annonce1_idx` (`Annonce_id`),
  KEY `fk_Image_TypeImage1_idx` (`TypeImage_id`),
  KEY `fk_Image_Societe1_idx` (`Societe_id`),
  KEY `fk_Image_Produit1_idx` (`Produit_id`),
  KEY `fk_Image_Professionel1` (`Professionel_id`),
  CONSTRAINT `fk_Image_Annonce1` FOREIGN KEY (`Annonce_id`) REFERENCES `annonces` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Image_Produit1` FOREIGN KEY (`Produit_id`) REFERENCES `produits` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Image_Professionel1` FOREIGN KEY (`Professionel_id`) REFERENCES `professionels` (`id`),
  CONSTRAINT `fk_Image_Societe1` FOREIGN KEY (`Societe_id`) REFERENCES `societes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Image_TypeImage1` FOREIGN KEY (`TypeImage_id`) REFERENCES `typeimages` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=415 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.images : ~111 rows (environ)
INSERT INTO `images` (`id`, `url`, `libelle`, `createdAt`, `updatedAt`, `Annonce_id`, `TypeImage_id`, `Societe_id`, `status`, `Produit_id`, `Professionel_id`) VALUES
	(9, '/images/uploads/images/societe/23/logo/AFROBASE1223.jpg1652716630684.jpg', 'AFROBASE1223.jpg1652716630684.jpg', '2022-05-04 12:02:20', '2022-05-16 15:57:11', 54, 2, 23, 1, NULL, NULL),
	(27, '/images / uploads / imagesProfessionnel / 15 / Image_Profile / pharmacie.jpeg1652378249964.jpg', 'pharmacie.jpeg1652378249964.jpg', '2022-05-12 17:57:30', '2022-05-12 17:57:30', 54, 3, NULL, 1, NULL, 15),
	(29, '/images /uploads/images/Professionnel 15 / ImageProfile / 2.jpeg1652455395927.jpg', '2.jpeg1652455395927.jpg', '2022-05-12 19:05:50', '2022-05-13 15:23:16', 54, 4, NULL, 1, NULL, 15),
	(37, '/images/uploads/images/Professionnel/15/galerie/COMMUNIQUE_B.jpg1652455560903.jpg', 'COMMUNIQUE_B.jpg1652455560903.jpg', '2022-05-13 15:26:01', '2022-05-13 15:26:01', 54, 5, NULL, 1, NULL, 15),
	(203, '/images/uploads/images/Annonces/1/97/LOFGO.jpg1652821282452.jpg', 'img_principale', '2022-05-17 21:01:23', '2022-05-17 21:01:23', 97, 6, NULL, 1, NULL, NULL),
	(204, '/images/uploads/images/Annonces/1/97/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652821282454.jpg', 'img_secondaire1', '2022-05-17 21:01:23', '2022-05-17 21:01:23', 97, 6, NULL, 1, NULL, NULL),
	(205, '/images/uploads/images/Annonces/1/97/LOFGO.jpg1652821282456.jpg', 'img_secondaire2', '2022-05-17 21:01:23', '2022-05-17 21:01:23', 97, 6, NULL, 1, NULL, NULL),
	(206, '/images/uploads/images/Annonces/1/97/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652821282458.jpg', 'img_secondaire3', '2022-05-17 21:01:23', '2022-05-17 21:01:23', 97, 6, NULL, 1, NULL, NULL),
	(207, '/images/uploads/images/Annonces/1/97/LOFGO.jpg1652821282459.jpg', 'img_secondaire4', '2022-05-17 21:01:23', '2022-05-17 21:01:23', 97, 6, NULL, 1, NULL, NULL),
	(208, '/images/uploads/images/Annonces/1/97/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652821282462.jpg', 'img_secondaire5', '2022-05-17 21:01:23', '2022-05-17 21:01:23', 97, 6, NULL, 1, NULL, NULL),
	(262, '/images/uploads/images/Annonces/1/98/LOFGO.jpg1652822006157.jpg', 'img_principale', '2022-05-17 21:13:26', '2022-05-17 21:13:26', 98, 6, NULL, 1, NULL, NULL),
	(263, '/images/uploads/images/Annonces/1/98/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652822006161.jpg', 'img_secondaire1', '2022-05-17 21:13:26', '2022-05-17 21:13:26', 98, 6, NULL, 1, NULL, NULL),
	(264, '/images/uploads/images/Annonces/1/98/LOFGO.jpg1652822006165.jpg', 'img_secondaire2', '2022-05-17 21:13:26', '2022-05-17 21:13:26', 98, 6, NULL, 1, NULL, NULL),
	(265, '/images/uploads/images/Annonces/1/98/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652822006167.jpg', 'img_secondaire3', '2022-05-17 21:13:26', '2022-05-17 21:13:26', 98, 6, NULL, 1, NULL, NULL),
	(266, '/images/uploads/images/Annonces/1/98/LOFGO.jpg1652822006170.jpg', 'img_secondaire4', '2022-05-17 21:13:26', '2022-05-17 21:13:26', 98, 6, NULL, 1, NULL, NULL),
	(267, '/images/uploads/images/Annonces/1/98/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652822006174.jpg', 'img_secondaire5', '2022-05-17 21:13:26', '2022-05-17 21:13:26', 98, 6, NULL, 1, NULL, NULL),
	(268, '/images/uploads/images/Annonces/1/99/LOFGO.jpg1652822010626.jpg', 'img_principale', '2022-05-17 21:13:31', '2022-05-17 21:13:31', 99, 6, NULL, 1, NULL, NULL),
	(269, '/images/uploads/images/Annonces/1/99/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652822010628.jpg', 'img_secondaire1', '2022-05-17 21:13:31', '2022-05-17 21:13:31', 99, 6, NULL, 1, NULL, NULL),
	(270, '/images/uploads/images/Annonces/1/99/LOFGO.jpg1652822010631.jpg', 'img_secondaire2', '2022-05-17 21:13:31', '2022-05-17 21:13:31', 99, 6, NULL, 1, NULL, NULL),
	(271, '/images/uploads/images/Annonces/1/99/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652822010633.jpg', 'img_secondaire3', '2022-05-17 21:13:31', '2022-05-17 21:13:31', 99, 6, NULL, 1, NULL, NULL),
	(272, '/images/uploads/images/Annonces/1/99/LOFGO.jpg1652822010634.jpg', 'img_secondaire4', '2022-05-17 21:13:31', '2022-05-17 21:13:31', 99, 6, NULL, 1, NULL, NULL),
	(273, '/images/uploads/images/Annonces/1/99/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652822010636.jpg', 'img_secondaire5', '2022-05-17 21:13:31', '2022-05-17 21:13:31', 99, 6, NULL, 1, NULL, NULL),
	(274, '/images/uploads/images/Annonces/1/100/LOFGO.jpg1652824028096.jpg', 'img_principale', '2022-05-17 21:47:08', '2022-05-17 21:47:08', 100, 6, NULL, 1, NULL, NULL),
	(275, '/images/uploads/images/Annonces/1/100/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652824028099.jpg', 'img_secondaire1', '2022-05-17 21:47:08', '2022-05-17 21:47:08', 100, 6, NULL, 1, NULL, NULL),
	(276, '/images/uploads/images/Annonces/1/100/LOFGO.jpg1652824028103.jpg', 'img_secondaire2', '2022-05-17 21:47:08', '2022-05-17 21:47:08', 100, 6, NULL, 1, NULL, NULL),
	(277, '/images/uploads/images/Annonces/1/100/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824028106.jpg', 'img_secondaire3', '2022-05-17 21:47:08', '2022-05-17 21:47:08', 100, 6, NULL, 1, NULL, NULL),
	(278, '/images/uploads/images/Annonces/1/100/LOFGO.jpg1652824028106.jpg', 'img_secondaire4', '2022-05-17 21:47:08', '2022-05-17 21:47:08', 100, 6, NULL, 1, NULL, NULL),
	(279, '/images/uploads/images/Annonces/1/100/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824028113.jpg', 'img_secondaire5', '2022-05-17 21:47:08', '2022-05-17 21:47:08', 100, 6, NULL, 1, NULL, NULL),
	(280, '/images/uploads/images/Annonces/1/101/LOFGO.jpg1652824432530.jpg', 'img_principale', '2022-05-17 21:53:53', '2022-05-17 21:53:53', 101, 6, NULL, 1, NULL, NULL),
	(281, '/images/uploads/images/Annonces/1/101/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652824432533.jpg', 'img_secondaire1', '2022-05-17 21:53:53', '2022-05-17 21:53:53', 101, 6, NULL, 1, NULL, NULL),
	(282, '/images/uploads/images/Annonces/1/101/LOFGO.jpg1652824432538.jpg', 'img_secondaire2', '2022-05-17 21:53:53', '2022-05-17 21:53:53', 101, 6, NULL, 1, NULL, NULL),
	(283, '/images/uploads/images/Annonces/1/101/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824432540.jpg', 'img_secondaire3', '2022-05-17 21:53:53', '2022-05-17 21:53:53', 101, 6, NULL, 1, NULL, NULL),
	(284, '/images/uploads/images/Annonces/1/101/LOFGO.jpg1652824432542.jpg', 'img_secondaire4', '2022-05-17 21:53:53', '2022-05-17 21:53:53', 101, 6, NULL, 1, NULL, NULL),
	(285, '/images/uploads/images/Annonces/1/101/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824432547.jpg', 'img_secondaire5', '2022-05-17 21:53:53', '2022-05-17 21:53:53', 101, 6, NULL, 1, NULL, NULL),
	(286, '/images/uploads/images/Annonces/1/102/LOFGO.jpg1652824480775.jpg', 'img_principale', '2022-05-17 21:54:41', '2022-05-17 21:54:41', 102, 6, NULL, 1, NULL, NULL),
	(287, '/images/uploads/images/Annonces/1/102/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652824480776.jpg', 'img_secondaire1', '2022-05-17 21:54:41', '2022-05-17 21:54:41', 102, 6, NULL, 1, NULL, NULL),
	(288, '/images/uploads/images/Annonces/1/102/LOFGO.jpg1652824480778.jpg', 'img_secondaire2', '2022-05-17 21:54:41', '2022-05-17 21:54:41', 102, 6, NULL, 1, NULL, NULL),
	(289, '/images/uploads/images/Annonces/1/102/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824480780.jpg', 'img_secondaire3', '2022-05-17 21:54:41', '2022-05-17 21:54:41', 102, 6, NULL, 1, NULL, NULL),
	(290, '/images/uploads/images/Annonces/1/102/LOFGO.jpg1652824480781.jpg', 'img_secondaire4', '2022-05-17 21:54:41', '2022-05-17 21:54:41', 102, 6, NULL, 1, NULL, NULL),
	(291, '/images/uploads/images/Annonces/1/102/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824480784.jpg', 'img_secondaire5', '2022-05-17 21:54:41', '2022-05-17 21:54:41', 102, 6, NULL, 1, NULL, NULL),
	(292, '/images/uploads/images/Annonces/1/103/LOFGO.jpg1652824499928.jpg', 'img_principale', '2022-05-17 21:55:00', '2022-05-17 21:55:00', 103, 6, NULL, 1, NULL, NULL),
	(293, '/images/uploads/images/Annonces/1/103/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652824499930.jpg', 'img_secondaire1', '2022-05-17 21:55:00', '2022-05-17 21:55:00', 103, 6, NULL, 1, NULL, NULL),
	(294, '/images/uploads/images/Annonces/1/103/LOFGO.jpg1652824499934.jpg', 'img_secondaire2', '2022-05-17 21:55:00', '2022-05-17 21:55:00', 103, 6, NULL, 1, NULL, NULL),
	(295, '/images/uploads/images/Annonces/1/103/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824499936.jpg', 'img_secondaire3', '2022-05-17 21:55:00', '2022-05-17 21:55:00', 103, 6, NULL, 1, NULL, NULL),
	(296, '/images/uploads/images/Annonces/1/103/LOFGO.jpg1652824499937.jpg', 'img_secondaire4', '2022-05-17 21:55:00', '2022-05-17 21:55:00', 103, 6, NULL, 1, NULL, NULL),
	(297, '/images/uploads/images/Annonces/1/103/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824499940.jpg', 'img_secondaire5', '2022-05-17 21:55:00', '2022-05-17 21:55:00', 103, 6, NULL, 1, NULL, NULL),
	(298, '/images/uploads/images/Annonces/1/104/LOFGO.jpg1652824522738.jpg', 'img_principale', '2022-05-17 21:55:23', '2022-05-17 21:55:23', 104, 6, NULL, 1, NULL, NULL),
	(299, '/images/uploads/images/Annonces/1/104/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652824522741.jpg', 'img_secondaire1', '2022-05-17 21:55:23', '2022-05-17 21:55:23', 104, 6, NULL, 1, NULL, NULL),
	(300, '/images/uploads/images/Annonces/1/104/LOFGO.jpg1652824522742.jpg', 'img_secondaire2', '2022-05-17 21:55:23', '2022-05-17 21:55:23', 104, 6, NULL, 1, NULL, NULL),
	(301, '/images/uploads/images/Annonces/1/104/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824522745.jpg', 'img_secondaire3', '2022-05-17 21:55:23', '2022-05-17 21:55:23', 104, 6, NULL, 1, NULL, NULL),
	(302, '/images/uploads/images/Annonces/1/104/LOFGO.jpg1652824522746.jpg', 'img_secondaire4', '2022-05-17 21:55:23', '2022-05-17 21:55:23', 104, 6, NULL, 1, NULL, NULL),
	(303, '/images/uploads/images/Annonces/1/104/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824522749.jpg', 'img_secondaire5', '2022-05-17 21:55:23', '2022-05-17 21:55:23', 104, 6, NULL, 1, NULL, NULL),
	(304, '/images/uploads/images/Annonces/1/105/LOFGO.jpg1652824588767.jpg', 'img_principale', '2022-05-17 21:56:29', '2022-05-17 21:56:29', 105, 6, NULL, 1, NULL, NULL),
	(305, '/images/uploads/images/Annonces/1/106/LOFGO.jpg1652824641633.jpg', 'img_principale', '2022-05-17 21:57:22', '2022-05-17 21:57:22', 106, 6, NULL, 1, NULL, NULL),
	(306, '/images/uploads/images/Annonces/1/106/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652824641636.jpg', 'img_secondaire1', '2022-05-17 21:57:22', '2022-05-17 21:57:22', 106, 6, NULL, 1, NULL, NULL),
	(307, '/images/uploads/images/Annonces/1/106/LOFGO.jpg1652824641640.jpg', 'img_secondaire2', '2022-05-17 21:57:22', '2022-05-17 21:57:22', 106, 6, NULL, 1, NULL, NULL),
	(308, '/images/uploads/images/Annonces/1/106/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824641642.jpg', 'img_secondaire3', '2022-05-17 21:57:22', '2022-05-17 21:57:22', 106, 6, NULL, 1, NULL, NULL),
	(309, '/images/uploads/images/Annonces/1/106/LOFGO.jpg1652824641644.jpg', 'img_secondaire4', '2022-05-17 21:57:22', '2022-05-17 21:57:22', 106, 6, NULL, 1, NULL, NULL),
	(310, '/images/uploads/images/Annonces/1/106/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824641647.jpg', 'img_secondaire5', '2022-05-17 21:57:22', '2022-05-17 21:57:22', 106, 6, NULL, 1, NULL, NULL),
	(311, '/images/uploads/images/Annonces/1/107/LOFGO.jpg1652824645046.jpg', 'img_principale', '2022-05-17 21:57:25', '2022-05-17 21:57:25', 107, 6, NULL, 1, NULL, NULL),
	(312, '/images/uploads/images/Annonces/1/107/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652824645048.jpg', 'img_secondaire1', '2022-05-17 21:57:25', '2022-05-17 21:57:25', 107, 6, NULL, 1, NULL, NULL),
	(313, '/images/uploads/images/Annonces/1/107/LOFGO.jpg1652824645052.jpg', 'img_secondaire2', '2022-05-17 21:57:25', '2022-05-17 21:57:25', 107, 6, NULL, 1, NULL, NULL),
	(314, '/images/uploads/images/Annonces/1/107/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824645054.jpg', 'img_secondaire3', '2022-05-17 21:57:25', '2022-05-17 21:57:25', 107, 6, NULL, 1, NULL, NULL),
	(315, '/images/uploads/images/Annonces/1/107/LOFGO.jpg1652824645055.jpg', 'img_secondaire4', '2022-05-17 21:57:25', '2022-05-17 21:57:25', 107, 6, NULL, 1, NULL, NULL),
	(316, '/images/uploads/images/Annonces/1/107/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824645057.jpg', 'img_secondaire5', '2022-05-17 21:57:25', '2022-05-17 21:57:25', 107, 6, NULL, 1, NULL, NULL),
	(317, '/images/uploads/images/Annonces/1/108/LOFGO.jpg1652824653024.jpg', 'img_principale', '2022-05-17 21:57:33', '2022-05-17 21:57:33', 108, 6, NULL, 1, NULL, NULL),
	(318, '/images/uploads/images/Annonces/1/108/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652824653026.jpg', 'img_secondaire1', '2022-05-17 21:57:33', '2022-05-17 21:57:33', 108, 6, NULL, 1, NULL, NULL),
	(319, '/images/uploads/images/Annonces/1/108/LOFGO.jpg1652824653027.jpg', 'img_secondaire2', '2022-05-17 21:57:33', '2022-05-17 21:57:33', 108, 6, NULL, 1, NULL, NULL),
	(320, '/images/uploads/images/Annonces/1/108/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824653029.jpg', 'img_secondaire3', '2022-05-17 21:57:33', '2022-05-17 21:57:33', 108, 6, NULL, 1, NULL, NULL),
	(321, '/images/uploads/images/Annonces/1/108/LOFGO.jpg1652824653030.jpg', 'img_secondaire4', '2022-05-17 21:57:33', '2022-05-17 21:57:33', 108, 6, NULL, 1, NULL, NULL),
	(322, '/images/uploads/images/Annonces/1/108/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824653034.jpg', 'img_secondaire5', '2022-05-17 21:57:33', '2022-05-17 21:57:33', 108, 6, NULL, 1, NULL, NULL),
	(323, '/images/uploads/images/Annonces/1/109/LOFGO.jpg1652824657787.jpg', 'img_principale', '2022-05-17 21:57:38', '2022-05-17 21:57:38', 109, 6, NULL, 1, NULL, NULL),
	(324, '/images/uploads/images/Annonces/1/109/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652824657789.jpg', 'img_secondaire1', '2022-05-17 21:57:38', '2022-05-17 21:57:38', 109, 6, NULL, 1, NULL, NULL),
	(325, '/images/uploads/images/Annonces/1/109/LOFGO.jpg1652824657791.jpg', 'img_secondaire2', '2022-05-17 21:57:38', '2022-05-17 21:57:38', 109, 6, NULL, 1, NULL, NULL),
	(326, '/images/uploads/images/Annonces/1/109/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824657793.jpg', 'img_secondaire3', '2022-05-17 21:57:38', '2022-05-17 21:57:38', 109, 6, NULL, 1, NULL, NULL),
	(327, '/images/uploads/images/Annonces/1/109/LOFGO.jpg1652824657795.jpg', 'img_secondaire4', '2022-05-17 21:57:38', '2022-05-17 21:57:38', 109, 6, NULL, 1, NULL, NULL),
	(328, '/images/uploads/images/Annonces/1/109/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652824657797.jpg', 'img_secondaire5', '2022-05-17 21:57:38', '2022-05-17 21:57:38', 109, 6, NULL, 1, NULL, NULL),
	(329, '/images/uploads/images/Annonces/1/110/LOFGO.jpg1652827134422.jpg', 'img_principale', '2022-05-17 22:38:55', '2022-05-17 22:38:55', 110, 6, NULL, 1, NULL, NULL),
	(330, '/images/uploads/images/Annonces/1/110/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652827134424.jpg', 'img_secondaire1', '2022-05-17 22:38:55', '2022-05-17 22:38:55', 110, 6, NULL, 1, NULL, NULL),
	(331, '/images/uploads/images/Annonces/1/110/LOFGO.jpg1652827134426.jpg', 'img_secondaire2', '2022-05-17 22:38:55', '2022-05-17 22:38:55', 110, 6, NULL, 1, NULL, NULL),
	(332, '/images/uploads/images/Annonces/1/110/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652827134429.jpg', 'img_secondaire3', '2022-05-17 22:38:55', '2022-05-17 22:38:55', 110, 6, NULL, 1, NULL, NULL),
	(333, '/images/uploads/images/Annonces/1/110/LOFGO.jpg1652827134434.jpg', 'img_secondaire4', '2022-05-17 22:38:55', '2022-05-17 22:38:55', 110, 6, NULL, 1, NULL, NULL),
	(334, '/images/uploads/images/Annonces/1/110/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652827134437.jpg', 'img_secondaire5', '2022-05-17 22:38:55', '2022-05-17 22:38:55', 110, 6, NULL, 1, NULL, NULL),
	(335, '/images/uploads/images/Annonces/1/111/LOFGO.jpg1652827178468.jpg', 'img_principale', '2022-05-17 22:39:38', '2022-05-17 22:39:38', 111, 6, NULL, 1, NULL, NULL),
	(336, '/images/uploads/images/Annonces/1/111/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652827178471.jpg', 'img_secondaire1', '2022-05-17 22:39:39', '2022-05-17 22:39:39', 111, 6, NULL, 1, NULL, NULL),
	(337, '/images/uploads/images/Annonces/1/111/LOFGO.jpg1652827178472.jpg', 'img_secondaire2', '2022-05-17 22:39:39', '2022-05-17 22:39:39', 111, 6, NULL, 1, NULL, NULL),
	(338, '/images/uploads/images/Annonces/1/111/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652827178473.jpg', 'img_secondaire3', '2022-05-17 22:39:39', '2022-05-17 22:39:39', 111, 6, NULL, 1, NULL, NULL),
	(339, '/images/uploads/images/Annonces/1/111/LOFGO.jpg1652827178474.jpg', 'img_secondaire4', '2022-05-17 22:39:39', '2022-05-17 22:39:39', 111, 6, NULL, 1, NULL, NULL),
	(340, '/images/uploads/images/Annonces/1/111/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652827178477.jpg', 'img_secondaire5', '2022-05-17 22:39:39', '2022-05-17 22:39:39', 111, 6, NULL, 1, NULL, NULL),
	(377, '/images/uploads/images/Annonces/1/112/pub1.jpeg1652867676575.jpg', 'img_principale', '2022-05-18 09:54:37', '2022-05-18 09:54:37', 112, 6, NULL, 1, NULL, NULL),
	(378, '/images/uploads/images/Annonces/1/115/LOFGO.jpg1652868853398.jpg', 'img_principale', '2022-05-18 10:14:13', '2022-05-18 10:14:13', 115, 6, NULL, 1, NULL, NULL),
	(379, '/images/uploads/images/Annonces/1/115/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652868853400.jpg', 'img_secondaire1', '2022-05-18 10:14:14', '2022-05-18 10:14:14', 115, 6, NULL, 1, NULL, NULL),
	(380, '/images/uploads/images/Annonces/1/115/LOFGO.jpg1652868853404.jpg', 'img_secondaire2', '2022-05-18 10:14:14', '2022-05-18 10:14:14', 115, 6, NULL, 1, NULL, NULL),
	(381, '/images/uploads/images/Annonces/1/115/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652868853406.jpg', 'img_secondaire3', '2022-05-18 10:14:14', '2022-05-18 10:14:14', 115, 6, NULL, 1, NULL, NULL),
	(382, '/images/uploads/images/Annonces/1/115/LOFGO.jpg1652868853407.jpg', 'img_secondaire4', '2022-05-18 10:14:14', '2022-05-18 10:14:14', 115, 6, NULL, 1, NULL, NULL),
	(383, '/images/uploads/images/Annonces/1/115/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652868853409.jpg', 'img_secondaire5', '2022-05-18 10:14:14', '2022-05-18 10:14:14', 115, 6, NULL, 1, NULL, NULL),
	(384, '/images/uploads/images/Annonces/1/116/LOFGO.jpg1652868878527.jpg', 'img_principale', '2022-05-18 10:14:39', '2022-05-18 10:14:39', 116, 6, NULL, 1, NULL, NULL),
	(385, '/images/uploads/images/Annonces/1/116/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652868878529.jpg', 'img_secondaire1', '2022-05-18 10:14:39', '2022-05-18 10:14:39', 116, 6, NULL, 1, NULL, NULL),
	(386, '/images/uploads/images/Annonces/1/116/LOFGO.jpg1652868878530.jpg', 'img_secondaire2', '2022-05-18 10:14:39', '2022-05-18 10:14:39', 116, 6, NULL, 1, NULL, NULL),
	(387, '/images/uploads/images/Annonces/1/116/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652868878533.jpg', 'img_secondaire3', '2022-05-18 10:14:39', '2022-05-18 10:14:39', 116, 6, NULL, 1, NULL, NULL),
	(388, '/images/uploads/images/Annonces/1/116/LOFGO.jpg1652868878534.jpg', 'img_secondaire4', '2022-05-18 10:14:39', '2022-05-18 10:14:39', 116, 6, NULL, 1, NULL, NULL),
	(389, '/images/uploads/images/Annonces/1/116/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652868878537.jpg', 'img_secondaire5', '2022-05-18 10:14:39', '2022-05-18 10:14:39', 116, 6, NULL, 1, NULL, NULL),
	(390, '/images/uploads/images/Annonces/1/117/LOFGO.jpg1652868903746.jpg', 'img_principale', '2022-05-18 10:15:04', '2022-05-18 10:15:04', 117, 6, NULL, 1, NULL, NULL),
	(391, '/images/uploads/images/Annonces/1/117/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652868903747.jpg', 'img_secondaire1', '2022-05-18 10:15:04', '2022-05-18 10:15:04', 117, 6, NULL, 1, NULL, NULL),
	(392, '/images/uploads/images/Annonces/1/117/LOFGO.jpg1652868903750.jpg', 'img_secondaire2', '2022-05-18 10:15:04', '2022-05-18 10:15:04', 117, 6, NULL, 1, NULL, NULL),
	(393, '/images/uploads/images/Annonces/1/117/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652868903752.jpg', 'img_secondaire3', '2022-05-18 10:15:04', '2022-05-18 10:15:04', 117, 6, NULL, 1, NULL, NULL),
	(394, '/images/uploads/images/Annonces/1/117/LOFGO.jpg1652868903753.jpg', 'img_secondaire4', '2022-05-18 10:15:04', '2022-05-18 10:15:04', 117, 6, NULL, 1, NULL, NULL),
	(395, '/images/uploads/images/Annonces/1/117/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652868903755.jpg', 'img_secondaire5', '2022-05-18 10:15:04', '2022-05-18 10:15:04', 117, 6, NULL, 1, NULL, NULL),
	(407, '/images/uploads/images/Annonces/1/96/LOFGO.jpg1652869070061.jpg', 'img_principale', '2022-05-18 10:17:50', '2022-05-18 10:17:50', 96, 6, NULL, 1, NULL, NULL),
	(408, '/images/uploads/images/Annonces/1/96/WhatsApp_Image_2022-05-03_at_07.46.08.jpeg1652869070063.jpg', 'img_secondaire1', '2022-05-18 10:17:50', '2022-05-18 10:17:50', 96, 6, NULL, 1, NULL, NULL),
	(409, '/images/uploads/images/Annonces/1/96/LOFGO.jpg1652869070067.jpg', 'img_secondaire2', '2022-05-18 10:17:50', '2022-05-18 10:17:50', 96, 6, NULL, 1, NULL, NULL),
	(410, '/images/uploads/images/Annonces/1/96/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652869070069.jpg', 'img_secondaire3', '2022-05-18 10:17:50', '2022-05-18 10:17:50', 96, 6, NULL, 1, NULL, NULL),
	(411, '/images/uploads/images/Annonces/1/96/LOFGO.jpg1652869070070.jpg', 'img_secondaire4', '2022-05-18 10:17:50', '2022-05-18 10:17:50', 96, 6, NULL, 1, NULL, NULL),
	(412, '/images/uploads/images/Annonces/96/96/WhatsApp_Image_2022-05-03_at_07.46.07.jpeg1652869070074.jpg', 'img_secondaire5', '2022-05-18 10:17:50', '2022-05-18 10:17:50', 96, 6, NULL, 1, NULL, NULL),
	(413, '/images/uploads/images/societe/23/galerie/1.jpeg1652969452336.jpg', '1.jpeg1652969452336.jpg', '2022-05-19 14:10:52', '2022-05-19 14:10:52', NULL, 3, 23, 1, NULL, NULL),
	(414, '/images/uploads/images/societe/23/galerie/1.jpeg1652969510840.jpg', '1.jpeg1652969510840.jpg', '2022-05-19 14:11:51', '2022-05-19 14:11:51', NULL, 3, 23, 1, NULL, NULL);

-- Listage de la structure de la table afrobase_api. packs
CREATE TABLE IF NOT EXISTS `packs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `TypePack_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Pack_TypePack1_idx` (`TypePack_id`),
  CONSTRAINT `fk_Pack_TypePack1` FOREIGN KEY (`TypePack_id`) REFERENCES `typepacks` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.packs : ~3 rows (environ)
INSERT INTO `packs` (`id`, `libelle`, `createdAt`, `updatedAt`, `TypePack_id`, `status`) VALUES
	(1, 'Normal', NULL, NULL, 2, NULL),
	(2, 'PackPro', '2022-05-09 15:41:53', '2022-05-09 15:41:53', 2, 1),
	(3, 'Normal', '2022-05-10 09:43:15', '2022-05-10 09:43:15', 3, 1);

-- Listage de la structure de la table afrobase_api. pays
CREATE TABLE IF NOT EXISTS `pays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `Continent_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Pays_Continent1_idx` (`Continent_id`),
  CONSTRAINT `fk_Pays_Continent1` FOREIGN KEY (`Continent_id`) REFERENCES `continents` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.pays : ~61 rows (environ)
INSERT INTO `pays` (`id`, `libelle`, `createdAt`, `updatedAt`, `Continent_id`, `status`) VALUES
	(1, 'Togo', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(2, 'Ghana', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(3, 'All', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 3, 1),
	(20, 'Algeria', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(21, 'Angola', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(22, 'Bénin', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(23, 'Botswana', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(24, 'Burkina', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(25, 'Burundi', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(26, 'Cameroon', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(27, 'Cape Verde', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(28, 'Canary Islands', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(29, 'Central African Republic', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(30, 'Chad', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(31, 'Comoros', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(32, 'Congo', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(33, 'Côte d\'Ivoire', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(34, 'Democratic Republic of the Congo', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(35, 'Djibouti', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(36, 'Egypt', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(37, 'Equatorial Guinea', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(38, 'Eritrea', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(39, 'Ethiopia', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(40, 'Gabon', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(41, 'Gambia', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(42, 'Guinea', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(43, 'Guinea-Bisaau', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(44, 'Kenya', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(45, 'Lesotho', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(46, 'Liberia', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(47, 'Libya', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(48, 'Madagascar', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(49, 'Madeira', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(50, 'Malawi', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(51, 'Mali', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(52, 'Mauritania', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(53, 'Mauritius', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(54, 'Mayotte', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(55, 'Morocco', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(56, 'Mozambique', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(57, 'Namibia', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(58, 'Niger', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(59, 'Nigeria', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(60, 'Réunion', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(61, 'Rwanda', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(62, 'Sahrawi Arab Democratic Republic', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(63, 'São Tomé and Príncipe', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(64, 'Senegal', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(65, 'Seychelles', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(66, 'Sierra Leone', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(67, 'Somalia', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(68, 'Somaliland', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(69, 'South Africa', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(70, 'South Sudan', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(71, 'Sudan', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(72, 'Swaziland', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(73, 'Tunisia', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(74, 'Uganda', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(75, 'United Republic of Tanzania', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(76, 'Zambia', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1),
	(77, 'Zimbabwe', '2022-05-19 16:17:12', '2022-05-19 16:17:12', 1, 1);

-- Listage de la structure de la table afrobase_api. permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.permissions : ~0 rows (environ)

-- Listage de la structure de la table afrobase_api. permission_has_role
CREATE TABLE IF NOT EXISTS `permission_has_role` (
  `Permission_id` int(11) NOT NULL,
  `Role_id` int(11) NOT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`Permission_id`,`Role_id`),
  KEY `fk_Permission_has_Role_Role1_idx` (`Role_id`),
  KEY `fk_Permission_has_Role_Permission_idx` (`Permission_id`),
  CONSTRAINT `fk_Permission_has_Role_Permission` FOREIGN KEY (`Permission_id`) REFERENCES `permissions` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Permission_has_Role_Role1` FOREIGN KEY (`Role_id`) REFERENCES `roles` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.permission_has_role : ~0 rows (environ)

-- Listage de la structure de la table afrobase_api. produits
CREATE TABLE IF NOT EXISTS `produits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `Professionel_id` int(11) DEFAULT NULL,
  `Societe_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Produit_Professionel1_idx` (`Professionel_id`),
  KEY `fk_Produit_Societe1_idx` (`Societe_id`),
  CONSTRAINT `fk_Produit_Professionel1` FOREIGN KEY (`Professionel_id`) REFERENCES `professionels` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Produit_Societe1` FOREIGN KEY (`Societe_id`) REFERENCES `societes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.produits : ~0 rows (environ)

-- Listage de la structure de la table afrobase_api. professionels
CREATE TABLE IF NOT EXISTS `professionels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) DEFAULT NULL,
  `prenom` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `description` text,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `User_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `Adresse` varchar(50) DEFAULT NULL,
  `Packs_id` int(11) DEFAULT NULL,
  `Villes_id` int(11) DEFAULT NULL,
  `site_web` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_UNIQUE` (`email`),
  KEY `fk_Professionel_User1_idx` (`User_id`),
  KEY `fk_Professionels_Packs1_idx` (`Packs_id`),
  KEY `fk_Professionels_Villes1_idx` (`Villes_id`),
  CONSTRAINT `fk_Professionel_User1` FOREIGN KEY (`User_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Professionels_Packs1` FOREIGN KEY (`Packs_id`) REFERENCES `packs` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Professionels_Villes1` FOREIGN KEY (`Villes_id`) REFERENCES `villes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.professionels : ~5 rows (environ)
INSERT INTO `professionels` (`id`, `nom`, `prenom`, `email`, `description`, `createdAt`, `updatedAt`, `User_id`, `status`, `Adresse`, `Packs_id`, `Villes_id`, `site_web`, `facebook`, `linkedin`, `instagram`, `twitter`) VALUES
	(14, 'AGBEM', 'Credo', 'r@gmail', 'Info', '2022-05-10 11:12:16', '2022-05-10 11:12:16', 1, 1, 'AGBAVI', 3, 1, NULL, NULL, NULL, NULL, NULL),
	(15, 'AGBEM', 'Credo', 'roi@gmail', 'Info', '2022-05-11 07:04:29', '2022-05-13 10:41:17', 1, 1, 'AGBAVI', 3, 1, 'hddvbd', 'hcdghvkshf', 'kjbsdbjkazbfaz', 'kjbcjgqkjgfkq', 'twitter'),
	(16, 'AGBEM', 'Credo', 're@gmail', 'Info', '2022-05-13 10:26:31', '2022-05-13 10:26:31', 1, 1, 'AGBAVI', 3, 1, '1', 'hcdghvkshf', NULL, 'kjbcjgqkjgfkq', NULL),
	(18, 'AGBEM', 'Credo', 'rooo@gmail', 'Info', '2022-05-13 10:29:05', '2022-05-13 10:29:05', 1, 1, 'AGBAVI', 3, 1, '1', 'hcdghvkshf', NULL, 'kjbcjgqkjgfkq', 'twitter'),
	(20, 'AGBEM', 'Credo', 'roo@gmail', 'Info', '2022-05-13 10:31:27', '2022-05-13 10:31:27', 1, 1, 'AGBAVI', 3, 1, '1', 'hcdghvkshf', 'kjbsdbjkazbfaz', 'kjbcjgqkjgfkq', 'twitter');

-- Listage de la structure de la table afrobase_api. professionel_has_profession
CREATE TABLE IF NOT EXISTS `professionel_has_profession` (
  `Professionel_id` int(11) NOT NULL,
  `Profession_id` int(11) NOT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`Professionel_id`,`Profession_id`),
  KEY `fk_Professionel_has_Profession_Profession1_idx` (`Profession_id`),
  KEY `fk_Professionel_has_Profession_Professionel1_idx` (`Professionel_id`),
  CONSTRAINT `fk_Professionel_has_Profession_Profession1` FOREIGN KEY (`Profession_id`) REFERENCES `professions` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Professionel_has_Profession_Professionel1` FOREIGN KEY (`Professionel_id`) REFERENCES `professionels` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.professionel_has_profession : ~4 rows (environ)
INSERT INTO `professionel_has_profession` (`Professionel_id`, `Profession_id`, `createdAt`, `updatedAt`, `status`) VALUES
	(14, 1, '2022-05-10 11:12:16', '2022-05-10 11:12:16', 1),
	(15, 2, '2022-05-13 15:23:25', '2022-05-13 15:23:25', 1),
	(16, 1, '2022-05-13 10:26:31', '2022-05-13 10:26:31', 1),
	(18, 1, '2022-05-13 10:29:05', '2022-05-13 10:29:05', 1),
	(20, 1, '2022-05-13 10:31:27', '2022-05-13 10:31:27', 1);

-- Listage de la structure de la table afrobase_api. professions
CREATE TABLE IF NOT EXISTS `professions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.professions : ~2 rows (environ)
INSERT INTO `professions` (`id`, `libelle`, `createdAt`, `updatedAt`, `status`) VALUES
	(1, 'Peintre', '2022-05-09 21:59:32', '2022-05-09 21:59:32', 1),
	(2, 'MÃ©nusier', '2022-05-11 15:32:55', '2022-05-11 15:32:55', 1);

-- Listage de la structure de la table afrobase_api. publireportages
CREATE TABLE IF NOT EXISTS `publireportages` (
  `id` int(11) NOT NULL,
  `titre` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contenu` text COLLATE utf8_unicode_ci,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `Status` int(11) DEFAULT NULL,
  `Pays_id` int(11) DEFAULT NULL,
  `User_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK1_Pays_id1` (`Pays_id`),
  KEY `FK1_User_id1` (`User_id`),
  CONSTRAINT `FK1_Pays_id1` FOREIGN KEY (`Pays_id`) REFERENCES `pays` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK1_User_id1` FOREIGN KEY (`User_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Listage des données de la table afrobase_api.publireportages : ~0 rows (environ)

-- Listage de la structure de la table afrobase_api. regions
CREATE TABLE IF NOT EXISTS `regions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `Pays_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Regions_Pays1_idx` (`Pays_id`),
  CONSTRAINT `fk_Regions_Pays1` FOREIGN KEY (`Pays_id`) REFERENCES `pays` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.regions : ~0 rows (environ)
INSERT INTO `regions` (`id`, `libelle`, `createdAt`, `updatedAt`, `status`, `Pays_id`) VALUES
	(1, 'Maritime', NULL, NULL, NULL, 1);

-- Listage de la structure de la table afrobase_api. roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.roles : ~0 rows (environ)
INSERT INTO `roles` (`id`, `libelle`, `createdAt`, `updatedAt`, `status`) VALUES
	(1, 'SimpleUser', '2022-05-15 17:59:13', '2022-05-15 17:59:14', 1),
	(2, 'SuperAdmin', '2022-05-15 18:46:27', '2022-05-15 18:46:28', 1);

-- Listage de la structure de la table afrobase_api. secteuractivites
CREATE TABLE IF NOT EXISTS `secteuractivites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.secteuractivites : ~0 rows (environ)
INSERT INTO `secteuractivites` (`id`, `libelle`, `createdAt`, `updatedAt`, `status`) VALUES
	(1, 'Informatique', NULL, NULL, 1),
	(2, 'ONG', '2022-05-18 21:48:15', '2022-05-18 21:48:16', 1);

-- Listage de la structure de la table afrobase_api. secteuractivite_has_societe
CREATE TABLE IF NOT EXISTS `secteuractivite_has_societe` (
  `Societe_id` int(11) NOT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `SecteurActiviter_id` int(11) NOT NULL,
  PRIMARY KEY (`Societe_id`,`SecteurActiviter_id`),
  KEY `fk_Categorie_has_Societe_Societe1_idx` (`Societe_id`),
  KEY `fk_SecteurActiviter_has_Societe_SecteurActiviter1_idx` (`SecteurActiviter_id`),
  CONSTRAINT `fk_Categorie_has_Societe_Societe1` FOREIGN KEY (`Societe_id`) REFERENCES `societes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_SecteurActiviter_has_Societe_SecteurActiviter1` FOREIGN KEY (`SecteurActiviter_id`) REFERENCES `secteuractivites` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.secteuractivite_has_societe : ~2 rows (environ)
INSERT INTO `secteuractivite_has_societe` (`Societe_id`, `createdAt`, `updatedAt`, `status`, `SecteurActiviter_id`) VALUES
	(21, '2022-04-22 12:24:34', '2022-04-22 12:24:34', NULL, 1),
	(23, '2022-04-22 16:35:17', '2022-04-22 16:35:17', NULL, 1);

-- Listage de la structure de la table afrobase_api. services
CREATE TABLE IF NOT EXISTS `services` (
  `id` int(11) NOT NULL,
  `libelle` varchar(200) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `Societe_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Service_Societe1_idx` (`Societe_id`),
  CONSTRAINT `fk_Service_Societe1` FOREIGN KEY (`Societe_id`) REFERENCES `societes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.services : ~0 rows (environ)

-- Listage de la structure de la table afrobase_api. societes
CREATE TABLE IF NOT EXISTS `societes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) NOT NULL,
  `description` text,
  `email` varchar(50) NOT NULL,
  `site_web` varchar(255) DEFAULT NULL,
  `BP` varchar(50) DEFAULT NULL,
  `Dirigeant` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `Vue` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `Adresse` varchar(50) DEFAULT NULL,
  `NIF` varchar(50) DEFAULT NULL,
  `RCCM` varchar(50) DEFAULT NULL,
  `Users_id` int(11) DEFAULT NULL,
  `Packs_id` int(11) DEFAULT NULL,
  `Villes_id` int(11) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `longitude` float DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `libelle_UNIQUE` (`libelle`),
  UNIQUE KEY `email_UNIQUE` (`email`),
  KEY `fk_Societes_Users1_idx` (`Users_id`),
  KEY `fk_Societes_Packs1_idx` (`Packs_id`),
  KEY `fk_Societes_Villes1_idx` (`Villes_id`),
  CONSTRAINT `fk_Societes_Packs1` FOREIGN KEY (`Packs_id`) REFERENCES `packs` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Societes_Users1` FOREIGN KEY (`Users_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Societes_Villes1` FOREIGN KEY (`Villes_id`) REFERENCES `villes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.societes : ~2 rows (environ)
INSERT INTO `societes` (`id`, `libelle`, `description`, `email`, `site_web`, `BP`, `Dirigeant`, `createdAt`, `updatedAt`, `Vue`, `status`, `Adresse`, `NIF`, `RCCM`, `Users_id`, `Packs_id`, `Villes_id`, `facebook`, `twitter`, `instagram`, `longitude`, `latitude`) VALUES
	(21, 'fdfdfvvv', NULL, 'kodjovk@gmail.com', NULL, 'BP4125', 'kokokaka', '2022-04-22 12:24:34', '2022-05-16 16:18:40', 16, 1, 'Zanguera', 'dshbfghvrj bvd', 'dvvs s ', 1, 1, 2, NULL, NULL, NULL, NULL, NULL),
	(23, 'ALTECH', NULL, 'altech@gmail.com', NULL, 'BP4125', 'kpokpoa', '2022-04-22 16:35:17', '2022-05-19 17:20:39', 32, 1, 'AVEDJI', 'dshbfghvrj bvd', 'iskhcb sb', 1, 2, 1, NULL, NULL, NULL, NULL, NULL);

-- Listage de la structure de la table afrobase_api. soussecteuractivites
CREATE TABLE IF NOT EXISTS `soussecteuractivites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `SecteurActivites_id` int(11) NOT NULL,
  PRIMARY KEY (`id`,`SecteurActivites_id`),
  KEY `fk_SousSecteurActivites_SecteurActivites1_idx` (`SecteurActivites_id`),
  CONSTRAINT `fk_SousSecteurActivites_SecteurActivites1` FOREIGN KEY (`SecteurActivites_id`) REFERENCES `secteuractivites` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.soussecteuractivites : ~3 rows (environ)
INSERT INTO `soussecteuractivites` (`id`, `libelle`, `createdAt`, `updatedAt`, `status`, `SecteurActivites_id`) VALUES
	(1, 'Hébergement', NULL, NULL, NULL, 1),
	(2, 'DA', '2022-05-01 20:08:23', '2022-05-01 20:08:23', 1, 1),
	(3, 'Réseaux', '2022-05-01 20:08:23', '2022-05-01 20:08:23', 1, 1);

-- Listage de la structure de la table afrobase_api. soussecteuractivites_has_societes
CREATE TABLE IF NOT EXISTS `soussecteuractivites_has_societes` (
  `SousSecteurActivites_id` int(11) NOT NULL,
  `Societes_id` int(11) NOT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`SousSecteurActivites_id`,`Societes_id`),
  KEY `fk_SousSecteurActiviters_has_Societes_Societes1_idx` (`Societes_id`),
  KEY `fk_SousSecteurActiviters_has_Societes_SousSecteurActiviters_idx` (`SousSecteurActivites_id`),
  CONSTRAINT `fk_SousSecteurActiviters_has_Societes_Societes1` FOREIGN KEY (`Societes_id`) REFERENCES `societes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_SousSecteurActiviters_has_Societes_SousSecteurActiviters1` FOREIGN KEY (`SousSecteurActivites_id`) REFERENCES `soussecteuractivites` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.soussecteuractivites_has_societes : ~2 rows (environ)
INSERT INTO `soussecteuractivites_has_societes` (`SousSecteurActivites_id`, `Societes_id`, `createdAt`, `updatedAt`) VALUES
	(1, 21, '2022-04-22 12:24:34', '2022-04-22 12:24:34'),
	(2, 23, '2022-04-22 16:35:17', '2022-04-22 16:35:17');

-- Listage de la structure de la table afrobase_api. telephones
CREATE TABLE IF NOT EXISTS `telephones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `numero1` int(11) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `Societe_id` int(11) DEFAULT NULL,
  `Professionel_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `whatsapp` int(11) DEFAULT NULL,
  `numero2` int(11) DEFAULT NULL,
  `numero3` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Telephone_Societe1_idx` (`Societe_id`),
  KEY `fk_Telephone_Professionel1_idx` (`Professionel_id`),
  CONSTRAINT `fk_Telephone_Professionel1` FOREIGN KEY (`Professionel_id`) REFERENCES `professionels` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_Telephone_Societe1` FOREIGN KEY (`Societe_id`) REFERENCES `societes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.telephones : ~6 rows (environ)
INSERT INTO `telephones` (`id`, `numero1`, `createdAt`, `updatedAt`, `Societe_id`, `Professionel_id`, `status`, `whatsapp`, `numero2`, `numero3`) VALUES
	(12, 98612148, '2022-04-22 12:24:34', '2022-04-22 12:24:34', 21, NULL, 1, NULL, 0, 0),
	(13, 98564123, '2022-04-22 16:35:17', '2022-05-19 17:20:40', 23, NULL, 1, 98564123, 87452135, 98564126),
	(28, 93651449, '2022-05-10 11:12:16', '2022-05-10 11:12:16', NULL, 14, 1, 93651449, 93651449, 98400819),
	(29, 93651445, '2022-05-11 07:04:29', '2022-05-12 11:57:11', NULL, 15, 1, 93651442, 93651444, 98400811),
	(30, 93651449, '2022-05-13 10:26:31', '2022-05-13 10:26:31', NULL, 16, 1, 93651449, 93651449, 98400819),
	(31, 93651449, '2022-05-13 10:29:05', '2022-05-13 10:29:05', NULL, 18, 1, 93651449, 93651449, 98400819),
	(32, 93651449, '2022-05-13 10:31:27', '2022-05-13 10:31:27', NULL, 20, 1, 93651449, 93651449, 98400819);

-- Listage de la structure de la table afrobase_api. typeimages
CREATE TABLE IF NOT EXISTS `typeimages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.typeimages : ~5 rows (environ)
INSERT INTO `typeimages` (`id`, `libelle`, `createdAt`, `updatedAt`, `status`) VALUES
	(2, 'Logo', '2022-04-24 19:42:54', '2022-04-24 19:42:54', 1),
	(3, 'galerie', '2022-05-04 15:39:50', '2022-05-04 15:39:50', 1),
	(4, 'Photo_Profil_Professionnel', '2022-05-11 10:26:48', '2022-05-11 10:26:48', 1),
	(5, 'Galerie_Professionnel', '2022-05-12 11:19:23', '2022-05-13 11:19:24', 1),
	(6, 'ImageAnnonce', '2022-05-13 15:36:13', '2022-05-13 15:36:15', 1);

-- Listage de la structure de la table afrobase_api. typepacks
CREATE TABLE IF NOT EXISTS `typepacks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.typepacks : ~2 rows (environ)
INSERT INTO `typepacks` (`id`, `libelle`, `createdAt`, `updatedAt`, `status`) VALUES
	(2, 'PackSociÃ©tÃ©', '2022-04-21 12:30:11', '2022-04-21 12:30:11', 1),
	(3, 'PackProfessionnel', '2022-05-10 09:42:37', '2022-05-10 09:42:37', 1);

-- Listage de la structure de la table afrobase_api. user_has_role
CREATE TABLE IF NOT EXISTS `user_has_role` (
  `User_id` int(11) NOT NULL,
  `Role_id` int(11) NOT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`User_id`,`Role_id`),
  KEY `fk_User_has_Role_Role1_idx` (`Role_id`),
  KEY `fk_User_has_Role_User1_idx` (`User_id`),
  CONSTRAINT `fk_User_has_Role_Role1` FOREIGN KEY (`Role_id`) REFERENCES `roles` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_User_has_Role_User1` FOREIGN KEY (`User_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.user_has_role : ~0 rows (environ)
INSERT INTO `user_has_role` (`User_id`, `Role_id`, `createdAt`, `updatedAt`, `status`) VALUES
	(6, 2, '2022-05-15 19:41:03', '2022-05-15 19:41:03', 1),
	(7, 2, '2022-05-19 16:37:10', '2022-05-19 16:37:10', 1);

-- Listage de la structure de la table afrobase_api. villes
CREATE TABLE IF NOT EXISTS `villes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `CP` int(11) DEFAULT NULL,
  `Regions_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_Villes_Regions1_idx` (`Regions_id`),
  CONSTRAINT `fk_Villes_Regions1` FOREIGN KEY (`Regions_id`) REFERENCES `regions` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- Listage des données de la table afrobase_api.villes : ~2 rows (environ)
INSERT INTO `villes` (`id`, `libelle`, `createdAt`, `updatedAt`, `status`, `CP`, `Regions_id`) VALUES
	(1, 'Lome', '2022-05-12 09:50:16', '2022-05-12 09:50:22', 1, NULL, 1),
	(2, 'Aneho', '2022-05-01 21:48:16', '2022-05-01 21:48:16', 1, NULL, 1);

