Viewing File: /htdocs/site_data_2024/admin_jmk_sitev4.sql

-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : ven. 25 oct. 2024 à 15:36
-- Version du serveur :  8.0.30
-- Version de PHP : 8.1.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données : `admin_jmk_site`
--

-- --------------------------------------------------------

--
-- Structure de la table `actualites`
--

DROP TABLE IF EXISTS `actualites`;
CREATE TABLE IF NOT EXISTS `actualites` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `titre_actu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `img_actu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_heur_actu` datetime DEFAULT NULL,
  `contenu_actu` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `auteur_actu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `actualites`
--

INSERT INTO `actualites` (`id`, `titre_actu`, `img_actu`, `date_heur_actu`, `contenu_actu`, `auteur_actu`, `created_at`, `updated_at`) VALUES
(2, 'Seminaire de formation sur l\'entrepreneuriat', '[\"actualites\\\\October2024\\\\0Cd4l1PHVqJNCAPAuViQ.jpg\"]', '2024-05-14 17:04:00', '<p>Onverra le contenu !</p>', 'M Brou', '2024-10-22 17:05:17', '2024-10-25 12:35:36'),
(3, 'Formation sur le processus de certification CacaoTrace...', '[\"actualites\\\\October2024\\\\Yjxt7oR8zgdDGZVFxwlA.jpg\"]', '2024-06-18 17:05:00', '<p>Hello</p>', 'M Brou', '2024-10-22 17:06:27', '2024-10-25 12:35:48'),
(4, 'Formation CacaoTrace des agents durabilité de ECOM', '[\"actualites\\\\October2024\\\\KLh0RWACGLKaNGgsbPSV.jpg\"]', '2024-05-14 17:06:00', '<p>Hello</p>', 'M Brou', '2024-10-22 17:07:10', '2024-10-25 12:36:04');

-- --------------------------------------------------------

--
-- Structure de la table `actualite_categorieactu`
--

DROP TABLE IF EXISTS `actualite_categorieactu`;
CREATE TABLE IF NOT EXISTS `actualite_categorieactu` (
  `actualite_id` int UNSIGNED NOT NULL,
  `categorieactu_id` int UNSIGNED NOT NULL,
  KEY `actualite_categorieactu_actualite_id_index` (`actualite_id`),
  KEY `actualite_categorieactu_categorieactu_id_index` (`categorieactu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `actualite_categorieactu`
--

INSERT INTO `actualite_categorieactu` (`actualite_id`, `categorieactu_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(1, 1),
(2, 1),
(3, 1),
(4, 1);

-- --------------------------------------------------------

--
-- Structure de la table `categorieactus`
--

DROP TABLE IF EXISTS `categorieactus`;
CREATE TABLE IF NOT EXISTS `categorieactus` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `titre_categactu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `descript_categactu` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `categorieactus`
--

INSERT INTO `categorieactus` (`id`, `titre_categactu`, `descript_categactu`, `created_at`, `updated_at`) VALUES
(1, 'Agroforestérie', NULL, '2024-10-11 14:10:53', '2024-10-11 14:10:53');

-- --------------------------------------------------------

--
-- Structure de la table `contacts`
--

DROP TABLE IF EXISTS `contacts`;
CREATE TABLE IF NOT EXISTS `contacts` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom_prenom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sujet` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `contacts`
--

INSERT INTO `contacts` (`id`, `nom_prenom`, `email`, `sujet`, `telephone`, `message`, `created_at`, `updated_at`) VALUES
(1, 'TCHIMOU', 'tchimouj99@gmail.com', 'AVEC', '+101040050052', 'Besoin d&#039;aide', NULL, NULL),
(2, 'Dankou', 'xididankourodrig@gmail.com', 'Negoce', '0787289593', 'coucou i need your help', NULL, NULL),
(3, 'Dankou', 'xididankourodrig@gmail.com', 'Negoce', '0787289593', 'Need your help', NULL, NULL),
(4, 'Dankou', 'xididankourodrig@gmail.com', 'Negoce', '0787289593', 'kldcnkcjc,c, ekedcjkae', NULL, NULL),
(5, 'Dankou', 'xididankourodrig@gmail.com', 'Negoce', '0787289593', 'klhfh jhedkjh', NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `data_rows`
--

DROP TABLE IF EXISTS `data_rows`;
CREATE TABLE IF NOT EXISTS `data_rows` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `data_type_id` int UNSIGNED NOT NULL,
  `field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `browse` tinyint(1) NOT NULL DEFAULT '1',
  `read` tinyint(1) NOT NULL DEFAULT '1',
  `edit` tinyint(1) NOT NULL DEFAULT '1',
  `add` tinyint(1) NOT NULL DEFAULT '1',
  `delete` tinyint(1) NOT NULL DEFAULT '1',
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `order` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `data_rows_data_type_id_foreign` (`data_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `data_rows`
--

INSERT INTO `data_rows` (`id`, `data_type_id`, `field`, `type`, `display_name`, `required`, `browse`, `read`, `edit`, `add`, `delete`, `details`, `order`) VALUES
(1, 1, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(2, 1, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(3, 1, 'email', 'text', 'Email', 1, 1, 1, 1, 1, 1, NULL, 3),
(4, 1, 'password', 'password', 'Password', 1, 0, 0, 1, 1, 0, NULL, 4),
(5, 1, 'remember_token', 'text', 'Remember Token', 0, 0, 0, 0, 0, 0, NULL, 5),
(6, 1, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 0, 0, 0, NULL, 6),
(7, 1, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 7),
(8, 1, 'avatar', 'image', 'Avatar', 0, 1, 1, 1, 1, 1, NULL, 8),
(9, 1, 'user_belongsto_role_relationship', 'relationship', 'Role', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsTo\",\"column\":\"role_id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"roles\",\"pivot\":0}', 10),
(10, 1, 'user_belongstomany_role_relationship', 'relationship', 'Roles', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"user_roles\",\"pivot\":\"1\",\"taggable\":\"0\"}', 11),
(11, 1, 'settings', 'hidden', 'Settings', 0, 0, 0, 0, 0, 0, NULL, 12),
(12, 2, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(13, 2, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(14, 2, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3),
(15, 2, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(16, 3, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(17, 3, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(18, 3, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3),
(19, 3, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(20, 3, 'display_name', 'text', 'Display Name', 1, 1, 1, 1, 1, 1, NULL, 5),
(21, 1, 'role_id', 'text', 'Role', 1, 1, 1, 1, 1, 1, NULL, 9),
(22, 4, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(23, 4, 'titre_actu', 'text', 'Titre Actualite', 1, 1, 1, 1, 1, 1, '{}', 2),
(24, 4, 'img_actu', 'multiple_images', 'Image Actualite', 1, 1, 1, 1, 1, 1, '{}', 3),
(25, 4, 'date_heur_actu', 'timestamp', 'Date Heure Actualite', 0, 1, 1, 1, 1, 1, '{}', 4),
(26, 4, 'contenu_actu', 'rich_text_box', 'Contenu Actualite', 0, 1, 1, 1, 1, 1, '{}', 5),
(27, 4, 'auteur_actu', 'text', 'Auteur Actualite', 0, 1, 1, 1, 1, 1, '{}', 6),
(28, 4, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, '{}', 7),
(29, 4, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 8),
(30, 4, 'actualite_belongstomany_actualite_categorieactu_relationship', 'relationship', 'Categorie d Actualites', 0, 1, 1, 1, 1, 1, '{\"model\":\"App\\\\Categorieactu\",\"table\":\"categorieactus\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"titre_categactu\",\"pivot_table\":\"actualite_categorieactu\",\"pivot\":\"1\",\"taggable\":\"0\"}', 9),
(31, 6, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(32, 6, 'titre_categactu', 'text', 'Titre Categorie d actu', 1, 1, 1, 1, 1, 1, '{}', 2),
(33, 6, 'descript_categactu', 'rich_text_box', 'Description Categorie d actu', 0, 1, 1, 1, 1, 1, '{}', 3),
(34, 6, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, '{}', 4),
(35, 6, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 5),
(36, 6, 'categorieactu_belongstomany_actualite_categorieactu_relationship', 'relationship', 'Actualites liees', 0, 1, 1, 1, 1, 1, '{\"model\":\"App\\\\Actualite\",\"table\":\"actualites\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"titre_actu\",\"pivot_table\":\"actualite_categorieactu\",\"pivot\":\"1\",\"taggable\":\"0\"}', 6),
(37, 7, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(38, 7, 'nommination', 'text', 'Nommination', 1, 1, 1, 1, 1, 1, '{}', 2),
(39, 7, 'description', 'rich_text_box', 'Description', 0, 1, 1, 1, 1, 1, '{}', 3),
(40, 7, 'logo', 'image', 'Logo', 1, 1, 1, 1, 1, 1, '{}', 4),
(41, 7, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, '{}', 5),
(42, 7, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 6),
(43, 8, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(44, 8, 'nom_prenom', 'text', 'Nom de prénom', 1, 1, 1, 1, 1, 1, '{}', 2),
(45, 8, 'poste', 'text', 'Poste', 1, 1, 1, 1, 1, 1, '{}', 3),
(46, 8, 'mot_de_lequipier', 'rich_text_box', 'Mot de l\' équipier', 0, 1, 1, 1, 1, 1, '{}', 4),
(47, 8, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 5),
(48, 8, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 6),
(49, 9, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(50, 9, 'titre', 'text', 'Titre', 1, 1, 1, 1, 1, 1, '{}', 2),
(51, 9, 'image', 'image', 'Image', 1, 1, 1, 1, 1, 1, '{}', 3),
(52, 9, 'description', 'rich_text_box', 'Description', 0, 1, 1, 1, 1, 1, '{}', 4),
(53, 9, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 5),
(54, 9, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 6),
(55, 11, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(56, 11, 'nom_prenom', 'text', 'Nom Prenom', 1, 1, 1, 1, 1, 1, '{}', 2),
(57, 11, 'email', 'text', 'Email', 1, 1, 1, 1, 1, 1, '{}', 3),
(58, 11, 'sujet', 'text', 'Sujet', 1, 1, 1, 1, 1, 1, '{}', 4),
(59, 11, 'telephone', 'text', 'Telephone', 0, 1, 1, 1, 1, 1, '{}', 5),
(60, 11, 'message', 'text_area', 'Message', 0, 1, 1, 1, 1, 1, '{}', 6),
(61, 11, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 7),
(62, 11, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 8),
(63, 8, 'photo', 'image', 'Photo', 0, 1, 1, 1, 1, 1, '{}', 7);

-- --------------------------------------------------------

--
-- Structure de la table `data_types`
--

DROP TABLE IF EXISTS `data_types`;
CREATE TABLE IF NOT EXISTS `data_types` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_singular` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_plural` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generate_permissions` tinyint(1) NOT NULL DEFAULT '0',
  `server_side` tinyint NOT NULL DEFAULT '0',
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `data_types_name_unique` (`name`),
  UNIQUE KEY `data_types_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `data_types`
--

INSERT INTO `data_types` (`id`, `name`, `slug`, `display_name_singular`, `display_name_plural`, `icon`, `model_name`, `policy_name`, `controller`, `description`, `generate_permissions`, `server_side`, `details`, `created_at`, `updated_at`) VALUES
(1, 'users', 'users', 'User', 'Users', 'voyager-person', 'TCG\\Voyager\\Models\\User', 'TCG\\Voyager\\Policies\\UserPolicy', 'TCG\\Voyager\\Http\\Controllers\\VoyagerUserController', '', 1, 0, NULL, '2024-10-09 13:57:46', '2024-10-09 13:57:46'),
(2, 'menus', 'menus', 'Menu', 'Menus', 'voyager-list', 'TCG\\Voyager\\Models\\Menu', NULL, '', '', 1, 0, NULL, '2024-10-09 13:57:46', '2024-10-09 13:57:46'),
(3, 'roles', 'roles', 'Role', 'Roles', 'voyager-lock', 'TCG\\Voyager\\Models\\Role', NULL, 'TCG\\Voyager\\Http\\Controllers\\VoyagerRoleController', '', 1, 0, NULL, '2024-10-09 13:57:47', '2024-10-09 13:57:47'),
(4, 'actualites', 'actualites', 'Actualite', 'Actualites', 'voyager-news', 'App\\Actualite', NULL, NULL, NULL, 1, 1, '{\"order_column\":\"id\",\"order_display_column\":\"id\",\"order_direction\":\"asc\",\"default_search_key\":\"titre_actu\",\"scope\":null}', '2024-10-11 10:02:55', '2024-10-16 09:50:55'),
(5, 'categorieactu', 'categorieactu', 'Categorie Actualite', 'Categorie Actualites', 'voyager-categories', 'App\\Categorieactu', NULL, NULL, NULL, 1, 1, '{\"order_column\":\"id\",\"order_display_column\":\"id\",\"order_direction\":\"asc\",\"default_search_key\":\"titre_categactu\"}', '2024-10-11 10:24:43', '2024-10-11 10:24:43'),
(6, 'categorieactus', 'categorieactus', 'Categorie Actualite', 'Categorie Actualites', 'voyager-categories', 'App\\Categorieactu', NULL, NULL, NULL, 1, 0, '{\"order_column\":\"id\",\"order_display_column\":\"titre_categactu\",\"order_direction\":\"asc\",\"default_search_key\":\"titre_categactu\",\"scope\":null}', '2024-10-11 14:13:56', '2024-10-16 09:49:31'),
(7, 'partenaires', 'partenaires', 'Partenaire', 'Partenaires', NULL, 'App\\Partenaire', NULL, NULL, NULL, 1, 1, '{\"order_column\":\"id\",\"order_display_column\":\"nommination\",\"order_direction\":\"asc\",\"default_search_key\":\"nommination\",\"scope\":null}', '2024-10-16 10:00:41', '2024-10-23 15:34:32'),
(8, 'equipes', 'equipes', 'Equipe', 'Equipes', 'voyager-people', 'App\\Equipe', NULL, NULL, NULL, 1, 1, '{\"order_column\":\"id\",\"order_display_column\":\"nom_prenom\",\"order_direction\":\"asc\",\"default_search_key\":\"nom_prenom\",\"scope\":null}', '2024-10-16 10:29:41', '2024-10-24 11:20:37'),
(9, 'services', 'services', 'Service', 'Services', 'voyager-documentation', 'App\\Service', NULL, NULL, NULL, 1, 1, '{\"order_column\":\"id\",\"order_display_column\":\"titre\",\"order_direction\":\"asc\",\"default_search_key\":\"titre\",\"scope\":null}', '2024-10-16 10:43:44', '2024-10-24 10:36:02'),
(11, 'contacts', 'contacts', 'Contact', 'Contacts', 'voyager-info-circled', 'App\\Contact', NULL, NULL, NULL, 1, 1, '{\"order_column\":\"id\",\"order_display_column\":\"nom_prenom\",\"order_direction\":\"asc\",\"default_search_key\":\"nom_prenom\",\"scope\":null}', '2024-10-16 11:20:42', '2024-10-16 11:31:07');

-- --------------------------------------------------------

--
-- Structure de la table `equipes`
--

DROP TABLE IF EXISTS `equipes`;
CREATE TABLE IF NOT EXISTS `equipes` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom_prenom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `poste` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mot_de_lequipier` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `equipes`
--

INSERT INTO `equipes` (`id`, `nom_prenom`, `poste`, `mot_de_lequipier`, `created_at`, `updated_at`, `photo`) VALUES
(1, 'Kra Pacôme', 'Chief Executive Officer', '<p>Pas de mot</p>', '2024-10-23 17:10:00', '2024-10-24 11:21:54', 'equipes\\October2024\\fEoNyesBBhFAbiWeg6iQ.jpg'),
(2, 'Brou Albert', 'Responsable des Projets d\'Innovation', '<p>Pas de mot</p>', '2024-10-23 17:10:00', '2024-10-24 13:26:09', 'equipes\\October2024\\z6Il2pvavCukAWClsuCm.png'),
(3, 'Coulibaly Gema', 'Comptable', '<p>Pas de mot</p>', '2024-10-23 17:11:00', '2024-10-24 13:26:52', 'equipes\\October2024\\XBzC7eusXpVdU8q0Lekd.png'),
(4, 'Mr Konan', 'Comptable', '<p>Pas de mot</p>', '2024-10-23 17:11:00', '2024-10-24 13:29:42', 'equipes\\October2024\\OFa056XTN4uRaZ3ZBC9f.png'),
(5, 'Achi Jathniel', 'Developper Web', '<p>Pas de mot</p>', '2024-10-23 17:12:00', '2024-10-24 13:30:19', 'equipes\\October2024\\258YeuZAZBHcNYp5jWiS.png'),
(6, 'Tchimou Junior', 'Dev.ops Mobile', '<p>Pas de mot</p>', '2024-10-23 17:13:00', '2024-10-24 13:30:46', 'equipes\\October2024\\NWoYjGQOe3Ihg5j8C1Q3.png');

-- --------------------------------------------------------

--
-- Structure de la table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `menus`
--

DROP TABLE IF EXISTS `menus`;
CREATE TABLE IF NOT EXISTS `menus` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `menus`
--

INSERT INTO `menus` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'admin', '2024-10-09 13:57:52', '2024-10-09 13:57:52'),
(2, 'Menu Nav', '2024-10-09 14:56:35', '2024-10-09 14:56:35');

-- --------------------------------------------------------

--
-- Structure de la table `menu_items`
--

DROP TABLE IF EXISTS `menu_items`;
CREATE TABLE IF NOT EXISTS `menu_items` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `menu_id` int UNSIGNED DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `icon_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int DEFAULT NULL,
  `order` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parameters` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `menu_items_menu_id_foreign` (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `menu_items`
--

INSERT INTO `menu_items` (`id`, `menu_id`, `title`, `url`, `target`, `icon_class`, `color`, `parent_id`, `order`, `created_at`, `updated_at`, `route`, `parameters`) VALUES
(1, 1, 'Accueil', '', '_self', 'voyager-boat', '#000000', NULL, 1, '2024-10-09 13:57:52', '2024-10-10 10:44:58', 'voyager.dashboard', 'null'),
(2, 1, 'Mediathèques', '', '_self', 'voyager-images', '#000000', NULL, 4, '2024-10-09 13:57:52', '2024-10-11 10:07:28', 'voyager.media.index', 'null'),
(3, 1, 'Utilisateurs', '', '_self', 'voyager-person', '#000000', NULL, 3, '2024-10-09 13:57:52', '2024-10-10 10:45:29', 'voyager.users.index', 'null'),
(4, 1, 'Roles', '', '_self', 'voyager-lock', '#000000', NULL, 2, '2024-10-09 13:57:53', '2024-10-10 10:45:17', 'voyager.roles.index', 'null'),
(5, 1, 'Options', '', '_self', 'voyager-tools', '#000000', NULL, 10, '2024-10-09 13:57:53', '2024-10-16 11:21:22', NULL, ''),
(6, 1, 'Créer Menu', '', '_self', 'voyager-list', '#000000', 5, 1, '2024-10-09 13:57:53', '2024-10-11 10:07:28', 'voyager.menus.index', 'null'),
(7, 1, 'Données', '', '_self', 'voyager-data', '#000000', 5, 2, '2024-10-09 13:57:53', '2024-10-11 10:07:28', 'voyager.database.index', 'null'),
(8, 1, 'Icones & Divers', '', '_self', 'voyager-compass', '#000000', 5, 3, '2024-10-09 13:57:53', '2024-10-11 10:07:28', 'voyager.compass.index', 'null'),
(9, 1, 'CRUD', '', '_self', 'voyager-bread', '#000000', 5, 4, '2024-10-09 13:57:53', '2024-10-11 10:07:28', 'voyager.bread.index', 'null'),
(10, 1, 'Paramètres', '', '_self', 'voyager-settings', '#000000', NULL, 11, '2024-10-09 13:57:53', '2024-10-16 11:21:22', 'voyager.settings.index', 'null'),
(11, 2, 'ACCUEIL', '/', '_self', NULL, '#050505', NULL, 1, '2024-10-09 15:00:45', '2024-10-09 15:04:16', NULL, ''),
(12, 2, 'A PROPOS', '', '_self', NULL, '#000000', NULL, 2, '2024-10-09 15:03:19', '2024-10-10 09:07:50', NULL, ''),
(13, 2, 'Présentation', '/presentation.html', '_self', NULL, '#000000', 12, 1, '2024-10-09 15:04:09', '2024-10-10 09:08:07', NULL, ''),
(14, 1, 'Actualites', '', '_self', 'voyager-news', NULL, 16, 1, '2024-10-11 10:02:55', '2024-10-11 14:31:58', 'voyager.actualites.index', NULL),
(15, 1, 'Categorie Actualites', '', '_self', 'voyager-categories', '#000000', 16, 2, '2024-10-11 10:24:43', '2024-10-11 14:32:07', 'voyager.categorieactus.index', 'null'),
(16, 1, 'Groupe d\'Actualités', '', '_self', 'voyager-categories', '#000000', NULL, 6, '2024-10-11 14:31:36', '2024-10-16 11:21:33', NULL, ''),
(17, 1, 'Parténaires', '', '_self', 'voyager-group', '#000000', NULL, 7, '2024-10-16 10:00:41', '2024-10-16 11:21:33', 'voyager.partenaires.index', 'null'),
(18, 1, 'Equipes', '', '_self', 'voyager-people', NULL, NULL, 8, '2024-10-16 10:29:41', '2024-10-16 11:21:33', 'voyager.equipes.index', NULL),
(19, 1, 'Services', '', '_self', 'voyager-documentation', NULL, NULL, 5, '2024-10-16 10:43:44', '2024-10-16 11:21:33', 'voyager.services.index', NULL),
(20, 1, 'Contacts', '', '_self', 'voyager-info-circled', NULL, NULL, 9, '2024-10-16 11:20:42', '2024-10-16 11:21:22', 'voyager.contacts.index', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_01_01_000000_add_voyager_user_fields', 1),
(4, '2016_01_01_000000_create_data_types_table', 1),
(5, '2016_05_19_173453_create_menu_table', 1),
(6, '2016_10_21_190000_create_roles_table', 1),
(7, '2016_10_21_190000_create_settings_table', 1),
(8, '2016_11_30_135954_create_permission_table', 1),
(9, '2016_11_30_141208_create_permission_role_table', 1),
(10, '2016_12_26_201236_data_types__add__server_side', 1),
(11, '2017_01_13_000000_add_route_to_menu_items_table', 1),
(12, '2017_01_14_005015_create_translations_table', 1),
(13, '2017_01_15_000000_make_table_name_nullable_in_permissions_table', 1),
(14, '2017_03_06_000000_add_controller_to_data_types_table', 1),
(15, '2017_04_21_000000_add_order_to_data_rows_table', 1),
(16, '2017_07_05_210000_add_policyname_to_data_types_table', 1),
(17, '2017_08_05_000000_add_group_to_settings_table', 1),
(18, '2017_11_26_013050_add_user_role_relationship', 1),
(19, '2017_11_26_015000_create_user_roles_table', 1),
(20, '2018_03_11_000000_add_user_settings', 1),
(21, '2018_03_14_000000_add_details_to_data_types_table', 1),
(22, '2018_03_16_000000_make_settings_value_nullable', 1),
(23, '2019_08_19_000000_create_failed_jobs_table', 1),
(24, '2019_12_14_000001_create_personal_access_tokens_table', 1);

-- --------------------------------------------------------

--
-- Structure de la table `partenaires`
--

DROP TABLE IF EXISTS `partenaires`;
CREATE TABLE IF NOT EXISTS `partenaires` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `nommination` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `logo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `partenaires`
--

INSERT INTO `partenaires` (`id`, `nommination`, `description`, `logo`, `created_at`, `updated_at`) VALUES
(1, 'Advans', '<p>Pas de description</p>', 'partenaires\\October2024\\v2WXnBXPNrhHW8dDDJMM.jpg', '2024-10-23 15:35:48', '2024-10-23 15:35:48'),
(2, 'Agriculture Biologique', '<p>Pas de description</p>', 'partenaires\\October2024\\96ZJOkiDItTaEb9q0F9t.jpg', '2024-10-23 15:43:13', '2024-10-23 15:43:13'),
(3, 'Cacao Trace', '<p>Pas de description</p>', 'partenaires\\October2024\\tXyacoFJWWmRZoSH9Pxw.jpg', '2024-10-23 15:44:22', '2024-10-23 15:44:22'),
(4, 'Cargill', '<p>Pas de description</p>', 'partenaires\\October2024\\MPTzs87NTHRTYYsqJadK.png', '2024-10-23 15:44:56', '2024-10-23 15:44:56'),
(6, 'Eaux et Foret', '<p>Pas de description</p>', 'partenaires\\October2024\\1KaT32ocjwxE3mj1Wt0b.png', '2024-10-23 15:45:36', '2024-10-23 15:45:36');

-- --------------------------------------------------------

--
-- Structure de la table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permissions_key_index` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `permissions`
--

INSERT INTO `permissions` (`id`, `key`, `table_name`, `created_at`, `updated_at`) VALUES
(1, 'browse_admin', NULL, '2024-10-09 13:57:53', '2024-10-09 13:57:53'),
(2, 'browse_bread', NULL, '2024-10-09 13:57:53', '2024-10-09 13:57:53'),
(3, 'browse_database', NULL, '2024-10-09 13:57:53', '2024-10-09 13:57:53'),
(4, 'browse_media', NULL, '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(5, 'browse_compass', NULL, '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(6, 'browse_menus', 'menus', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(7, 'read_menus', 'menus', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(8, 'edit_menus', 'menus', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(9, 'add_menus', 'menus', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(10, 'delete_menus', 'menus', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(11, 'browse_roles', 'roles', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(12, 'read_roles', 'roles', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(13, 'edit_roles', 'roles', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(14, 'add_roles', 'roles', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(15, 'delete_roles', 'roles', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(16, 'browse_users', 'users', '2024-10-09 13:57:54', '2024-10-09 13:57:54'),
(17, 'read_users', 'users', '2024-10-09 13:57:55', '2024-10-09 13:57:55'),
(18, 'edit_users', 'users', '2024-10-09 13:57:55', '2024-10-09 13:57:55'),
(19, 'add_users', 'users', '2024-10-09 13:57:55', '2024-10-09 13:57:55'),
(20, 'delete_users', 'users', '2024-10-09 13:57:55', '2024-10-09 13:57:55'),
(21, 'browse_settings', 'settings', '2024-10-09 13:57:55', '2024-10-09 13:57:55'),
(22, 'read_settings', 'settings', '2024-10-09 13:57:55', '2024-10-09 13:57:55'),
(23, 'edit_settings', 'settings', '2024-10-09 13:57:55', '2024-10-09 13:57:55'),
(24, 'add_settings', 'settings', '2024-10-09 13:57:55', '2024-10-09 13:57:55'),
(25, 'delete_settings', 'settings', '2024-10-09 13:57:55', '2024-10-09 13:57:55'),
(26, 'browse_actualites', 'actualites', '2024-10-11 10:02:55', '2024-10-11 10:02:55'),
(27, 'read_actualites', 'actualites', '2024-10-11 10:02:55', '2024-10-11 10:02:55'),
(28, 'edit_actualites', 'actualites', '2024-10-11 10:02:55', '2024-10-11 10:02:55'),
(29, 'add_actualites', 'actualites', '2024-10-11 10:02:55', '2024-10-11 10:02:55'),
(30, 'delete_actualites', 'actualites', '2024-10-11 10:02:55', '2024-10-11 10:02:55'),
(31, 'browse_categorieactu', 'categorieactu', '2024-10-11 10:24:43', '2024-10-11 10:24:43'),
(32, 'read_categorieactu', 'categorieactu', '2024-10-11 10:24:43', '2024-10-11 10:24:43'),
(33, 'edit_categorieactu', 'categorieactu', '2024-10-11 10:24:43', '2024-10-11 10:24:43'),
(34, 'add_categorieactu', 'categorieactu', '2024-10-11 10:24:43', '2024-10-11 10:24:43'),
(35, 'delete_categorieactu', 'categorieactu', '2024-10-11 10:24:43', '2024-10-11 10:24:43'),
(36, 'browse_categorieactus', 'categorieactus', '2024-10-11 14:13:56', '2024-10-11 14:13:56'),
(37, 'read_categorieactus', 'categorieactus', '2024-10-11 14:13:56', '2024-10-11 14:13:56'),
(38, 'edit_categorieactus', 'categorieactus', '2024-10-11 14:13:56', '2024-10-11 14:13:56'),
(39, 'add_categorieactus', 'categorieactus', '2024-10-11 14:13:56', '2024-10-11 14:13:56'),
(40, 'delete_categorieactus', 'categorieactus', '2024-10-11 14:13:56', '2024-10-11 14:13:56'),
(41, 'browse_partenaires', 'partenaires', '2024-10-16 10:00:41', '2024-10-16 10:00:41'),
(42, 'read_partenaires', 'partenaires', '2024-10-16 10:00:41', '2024-10-16 10:00:41'),
(43, 'edit_partenaires', 'partenaires', '2024-10-16 10:00:41', '2024-10-16 10:00:41'),
(44, 'add_partenaires', 'partenaires', '2024-10-16 10:00:41', '2024-10-16 10:00:41'),
(45, 'delete_partenaires', 'partenaires', '2024-10-16 10:00:41', '2024-10-16 10:00:41'),
(46, 'browse_equipes', 'equipes', '2024-10-16 10:29:41', '2024-10-16 10:29:41'),
(47, 'read_equipes', 'equipes', '2024-10-16 10:29:41', '2024-10-16 10:29:41'),
(48, 'edit_equipes', 'equipes', '2024-10-16 10:29:41', '2024-10-16 10:29:41'),
(49, 'add_equipes', 'equipes', '2024-10-16 10:29:41', '2024-10-16 10:29:41'),
(50, 'delete_equipes', 'equipes', '2024-10-16 10:29:41', '2024-10-16 10:29:41'),
(51, 'browse_services', 'services', '2024-10-16 10:43:44', '2024-10-16 10:43:44'),
(52, 'read_services', 'services', '2024-10-16 10:43:44', '2024-10-16 10:43:44'),
(53, 'edit_services', 'services', '2024-10-16 10:43:44', '2024-10-16 10:43:44'),
(54, 'add_services', 'services', '2024-10-16 10:43:44', '2024-10-16 10:43:44'),
(55, 'delete_services', 'services', '2024-10-16 10:43:44', '2024-10-16 10:43:44'),
(56, 'browse_contacts', 'contacts', '2024-10-16 11:20:42', '2024-10-16 11:20:42'),
(57, 'read_contacts', 'contacts', '2024-10-16 11:20:42', '2024-10-16 11:20:42'),
(58, 'edit_contacts', 'contacts', '2024-10-16 11:20:42', '2024-10-16 11:20:42'),
(59, 'add_contacts', 'contacts', '2024-10-16 11:20:42', '2024-10-16 11:20:42'),
(60, 'delete_contacts', 'contacts', '2024-10-16 11:20:42', '2024-10-16 11:20:42');

-- --------------------------------------------------------

--
-- Structure de la table `permission_role`
--

DROP TABLE IF EXISTS `permission_role`;
CREATE TABLE IF NOT EXISTS `permission_role` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_permission_id_index` (`permission_id`),
  KEY `permission_role_role_id_index` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(50, 1),
(51, 1),
(52, 1),
(53, 1),
(54, 1),
(55, 1),
(56, 1),
(57, 1),
(58, 1),
(59, 1),
(60, 1);

-- --------------------------------------------------------

--
-- Structure de la table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `roles`
--

DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `roles`
--

INSERT INTO `roles` (`id`, `name`, `display_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Administrator', '2024-10-09 13:57:53', '2024-10-09 13:57:53'),
(2, 'user', 'Normal User', '2024-10-09 13:57:53', '2024-10-09 13:57:53');

-- --------------------------------------------------------

--
-- Structure de la table `services`
--

DROP TABLE IF EXISTS `services`;
CREATE TABLE IF NOT EXISTS `services` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `services`
--

INSERT INTO `services` (`id`, `titre`, `image`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Conseil en négoce de matières premières', 'services\\October2024\\6nA1GaFed1qw6pbrFiTj.jpg', '<p>- Diagnostic des cha&icirc;nes d\'approvisionnement<br>- Analyse des march&eacute;s et fili&egrave;res<br>- D&eacute;veloppement strat&eacute;gique de cha&icirc;nes de valeurs<br>- Accompagnement dossiers d\'agr&eacute;ment<br>- Gestion des activit&eacute;s d\'export de mati&egrave;res premi&egrave;res<br>- Commerce international (prospection des opportunit&eacute;s) et mise en relation.<br>- Formation et accompagnement aux certifications agricoles (BIO, RainFo&shy;rest,...) cacao trace, Agriculture climato-intelligence<br>- Commerce int&eacute;rieur, commerce ext&eacute;rieur<br>- Formations techniques agricoles<br>- D&eacute;veloppement de march&eacute;s de niches (identification des besoins et approvisionnement) et mise en relation.</p>', '2024-10-24 10:39:05', '2024-10-24 10:39:05'),
(2, 'Etude et gestion de projets', 'services\\October2024\\EdgTLNF7wzEplbYg1dZh.jpg', '<p>- Analyse et d&eacute;finition des objectifs<br>- &Eacute;laboration de plans de mise en &oelig;uvre<br>- D&eacute;finition et impl&eacute;mentation<br>- Conduite du changement<br>- Montage de projets, formation en gestion de projets<br>- Montage de dossiers de financement<br>- Accompagnement aux partenariats decofounding<br>- Planification et suivi-&eacute;valuation des projets<br>- &Eacute;valuation Tierce partie</p>', '2024-10-24 10:40:06', '2024-10-24 10:40:06'),
(3, 'Conseil en développement des entreprises', 'services\\October2024\\uQWsuRrDAZMA6bKFsy8O.jpg', '<p>- Diagnostiquer les points de faiblesse.<br>- R&eacute;v&eacute;ler les axes de progr&egrave;s qui soient mesurables.<br>- Accompagner nos clients dans leurs objectifs de construction, red&eacute;ploiement, de consolidation des activit&eacute;s des d&eacute;partements d\'approvisionnement et transport.<br>- Favoriser les croisements d\'exp&eacute;riences d\'une entreprise &agrave; une autre.</p>', '2024-10-24 10:40:50', '2024-10-24 10:40:50'),
(4, 'Conseil en communication', 'services\\October2024\\uldw9LOqqjCvr05EHbyb.jpg', '<p>-Elaboration de votre strat&eacute;gie de communication<br>- Conseil strat&eacute;gique en communication<br>- Marketing relationnel<br>- Coordination/supervision de mise en &oelig;uvre de plans et strat&eacute;gies de communication<br>- Etudes de march&eacute;s<br>- Veille concurrentielle<br>- Relations m&eacute;dias<br>- Conception et r&eacute;alisation de support de communication (spot tv &amp; radio, flyers, insertions presse, kakemonos, etc.)<br>- Social media &amp; community manage&shy;ment permanent<br>- Gestion des campagne en ligne<br>- Conception et r&eacute;alisation de site et application web<br>- Publicit&eacute;<br>- Ev&egrave;nementiel</p>', '2024-10-24 10:41:32', '2024-10-24 10:41:32'),
(5, 'Conseil en logistique et transport', 'services\\October2024\\RtxFeu4N75oOARytkVFy.JPG', '<p>- Diagnostiquer les points de faiblesses.<br>- R&eacute;v&eacute;ler les axes de progr&egrave;s qui soient mesurables.<br>- Accompagner nos clients dans leurs objectifs de construction, red&eacute;ploie&shy;ment, de consolidation des activit&eacute;s des d&eacute;partements d\'approvisionne&shy;ment et transport.<br>- Favoriser les croisements d\'exp&eacute;&shy;rience d\'une entreprise &agrave; une autre.</p>', '2024-10-24 10:42:30', '2024-10-24 10:42:30'),
(6, 'Import et export', 'services\\October2024\\yyFIXMdjNZXt6TkpKqSm.jpg', '<p>Nous g&eacute;rons vos op&eacute;rations de commerce &agrave; l\'international pour vous aider &agrave; importer du monde entier, en toute confiance et avec une garantie de bonne fin de chaque transaction.<br>- Importation de mat&eacute;riels agricoles et industriels<br>- lmport et Export de produits divers<br>- Inspection &amp; Contr&ocirc;le des marchandises</p>', '2024-10-24 10:43:31', '2024-10-24 10:43:31'),
(7, 'Environnement & développement durable', 'services\\October2024\\Ad5tqiQzvftleonOEsqH.JPG', '<p>- Appui aux politiques et strat&eacute;gies de lutte contre le changement climatique<br>- Inventaire de la biodiversit&eacute;<br>- Cartographie &eacute;cologique et foresti&egrave;re<br>- Reforestation individuelle et communautaire<br>- Reboisement - Am&eacute;nagement forestier<br>- Diagnostics et audits environnementaux<br>- Elaboration de plans d\'am&eacute;nagement<br>- Plan et mesure de conservation, de gestion des milieux naturels<br>- Etudes d\'Impact Environnemental et Social<br>- Renforcement des capacit&eacute;s des acteurs agricoles et forestiers en agroforesterie<br>- Conception, planification et gestion des projets agroforestiers</p>', '2024-10-24 10:44:50', '2024-10-24 10:44:50');

-- --------------------------------------------------------

--
-- Structure de la table `settings`
--

DROP TABLE IF EXISTS `settings`;
CREATE TABLE IF NOT EXISTS `settings` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '1',
  `group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `settings`
--

INSERT INTO `settings` (`id`, `key`, `display_name`, `value`, `details`, `type`, `order`, `group`) VALUES
(1, 'site.title', 'Site Title', 'Site Title', '', 'text', 1, 'Site'),
(2, 'site.description', 'Site Description', 'Site Description', '', 'text', 2, 'Site'),
(3, 'site.logo', 'Site Logo', '', '', 'image', 3, 'Site'),
(4, 'site.google_analytics_tracking_id', 'Google Analytics Tracking ID', NULL, '', 'text', 4, 'Site'),
(5, 'admin.bg_image', 'Admin Background Image', 'settings\\October2024\\vN70wolGA99OMMy8i5O1.png', '', 'image', 5, 'Admin'),
(6, 'admin.title', 'Admin Title', 'PAGE ADMINISTRATIVE', '', 'text', 1, 'Admin'),
(7, 'admin.description', 'Admin Description', 'Controller les informations du site à travers la page administrative !', '', 'text', 2, 'Admin'),
(8, 'admin.loader', 'Admin Loader', '', '', 'image', 3, 'Admin'),
(9, 'admin.icon_image', 'Admin Icon Image', '', '', 'image', 4, 'Admin'),
(10, 'admin.google_analytics_client_id', 'Google Analytics Client ID (used for admin dashboard)', NULL, '', 'text', 1, 'Admin');

-- --------------------------------------------------------

--
-- Structure de la table `translations`
--

DROP TABLE IF EXISTS `translations`;
CREATE TABLE IF NOT EXISTS `translations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_key` int UNSIGNED NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'users/default.png',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `settings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_role_id_foreign` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `users`
--

INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `settings`, `created_at`, `updated_at`) VALUES
(1, 1, 'BROU ALBERT', 'admin@admin.com', 'users\\October2024\\sB2MrXTP7aKrFrqid1hY.png', NULL, '$2y$10$2fQOB5DERMl3PSR/klcoIe7qZ4Lpt1.cukCxcEnh8M9xwgTZQGuL2', 'ctPjCK1gWtpl2hF3WHb3sXwtE7X1P70n3Av3a15wc4Z3nAkOUQeV8u9MZERM', '{\"locale\":\"fr\"}', '2024-10-09 14:50:14', '2024-10-10 10:51:58');

-- --------------------------------------------------------

--
-- Structure de la table `user_roles`
--

DROP TABLE IF EXISTS `user_roles`;
CREATE TABLE IF NOT EXISTS `user_roles` (
  `user_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `user_roles_user_id_index` (`user_id`),
  KEY `user_roles_role_id_index` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `data_rows`
--
ALTER TABLE `data_rows`
  ADD CONSTRAINT `data_rows_data_type_id_foreign` FOREIGN KEY (`data_type_id`) REFERENCES `data_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `menu_items`
--
ALTER TABLE `menu_items`
  ADD CONSTRAINT `menu_items_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Contraintes pour la table `user_roles`
--
ALTER TABLE `user_roles`
  ADD CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;