File Manager

Editing File: /htdocs/site_data_2024/admin_jmk_siteV5.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 25, 2024 at 04:15 PM
-- Server version: 8.0.30
-- PHP Version: 8.1.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 */;

--
-- Database: `admin_jmk_site`
--

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

--
-- Table structure for table `actualites`
--

CREATE TABLE `actualites` (
  `id` int UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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', 'Onverra le contenu !', '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', 'Hello', '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', 'Hello', 'M Brou', '2024-10-22 17:07:10', '2024-10-25 12:36:04');

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

--
-- Table structure for table `actualite_categorieactu`
--

CREATE TABLE `actualite_categorieactu` (
  `actualite_id` int UNSIGNED NOT NULL,
  `categorieactu_id` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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);

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

--
-- Table structure for table `categorieactus`
--

CREATE TABLE `categorieactus` (
  `id` int UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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);

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

--
-- Table structure for table `data_rows`
--

CREATE TABLE `data_rows` (
  `id` int UNSIGNED NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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);

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

--
-- Table structure for table `data_types`
--

CREATE TABLE `data_types` (
  `id` int UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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');

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

--
-- Table structure for table `equipes`
--

CREATE TABLE `equipes` (
  `id` int UNSIGNED NOT NULL,
  `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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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', 'Pas de mot', '2024-10-23 17:10:00', '2024-10-25 16:13:22', NULL),
(2, 'Brou Albert', 'Responsable des Projets d\'Innovation', 'Pas de mot', '2024-10-23 17:10:00', '2024-10-25 16:13:34', NULL),
(3, 'Coulibaly Gema', 'Comptable', 'Pas de mot', '2024-10-23 17:11:00', '2024-10-25 16:13:44', NULL),
(4, 'Mr Konan', 'Comptable', 'Pas de mot', '2024-10-23 17:11:00', '2024-10-25 16:13:55', NULL),
(5, 'Achi Jathniel', 'Developper Web', 'Pas de mot', '2024-10-23 17:12:00', '2024-10-25 16:14:05', NULL),
(6, 'Tchimou Junior', 'Dev.ops Mobile', 'Pas de mot', '2024-10-23 17:13:00', '2024-10-25 16:14:14', NULL);

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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');

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

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` int UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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);

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

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

CREATE TABLE `partenaires` (
  `id` int UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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');

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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);

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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', 'settings\\October2024\\L8gOxs3uFl7vJVj7clYt.jpg', '', 'image', 3, 'Admin'),
(9, 'admin.icon_image', 'Admin Icon Image', 'settings\\October2024\\3VQTzYjonWph7933bdJx.jpg', '', 'image', 4, 'Admin'),
(10, 'admin.google_analytics_client_id', 'Google Analytics Client ID (used for admin dashboard)', NULL, '', 'text', 1, 'Admin');

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

--
-- Table structure for table `translations`
--

CREATE TABLE `translations` (
  `id` int UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for 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');

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

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `user_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `actualites`
--
ALTER TABLE `actualites`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `actualite_categorieactu`
--
ALTER TABLE `actualite_categorieactu`
  ADD KEY `actualite_categorieactu_actualite_id_index` (`actualite_id`),
  ADD KEY `actualite_categorieactu_categorieactu_id_index` (`categorieactu_id`);

--
-- Indexes for table `categorieactus`
--
ALTER TABLE `categorieactus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_rows`
--
ALTER TABLE `data_rows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `data_rows_data_type_id_foreign` (`data_type_id`);

--
-- Indexes for table `data_types`
--
ALTER TABLE `data_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `data_types_name_unique` (`name`),
  ADD UNIQUE KEY `data_types_slug_unique` (`slug`);

--
-- Indexes for table `equipes`
--
ALTER TABLE `equipes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `menus_name_unique` (`name`);

--
-- Indexes for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_items_menu_id_foreign` (`menu_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `partenaires`
--
ALTER TABLE `partenaires`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permissions_key_index` (`key`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `permission_role_permission_id_index` (`permission_id`),
  ADD KEY `permission_role_role_id_index` (`role_id`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_key_unique` (`key`);

--
-- Indexes for table `translations`
--
ALTER TABLE `translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD KEY `users_role_id_foreign` (`role_id`);

--
-- Indexes for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `user_roles_user_id_index` (`user_id`),
  ADD KEY `user_roles_role_id_index` (`role_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `actualites`
--
ALTER TABLE `actualites`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `categorieactus`
--
ALTER TABLE `categorieactus`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `data_rows`
--
ALTER TABLE `data_rows`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `data_types`
--
ALTER TABLE `data_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `equipes`
--
ALTER TABLE `equipes`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `partenaires`
--
ALTER TABLE `partenaires`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `translations`
--
ALTER TABLE `translations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for 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;

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

--
-- Constraints for 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;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Constraints for 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 */;

Back to Directory File Manager