Viewing 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', '<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');
-- --------------------------------------------------------
--
-- 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'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', '<p>Pas de mot</p>', '2024-10-23 17:10:00', '2024-10-25 16:13:22', NULL),
(2, 'Brou Albert', 'Responsable des Projets d\'Innovation', '<p>Pas de mot</p>', '2024-10-23 17:10:00', '2024-10-25 16:13:34', NULL),
(3, 'Coulibaly Gema', 'Comptable', '<p>Pas de mot</p>', '2024-10-23 17:11:00', '2024-10-25 16:13:44', NULL),
(4, 'Mr Konan', 'Comptable', '<p>Pas de mot</p>', '2024-10-23 17:11:00', '2024-10-25 16:13:55', NULL),
(5, 'Achi Jathniel', 'Developper Web', '<p>Pas de mot</p>', '2024-10-23 17:12:00', '2024-10-25 16:14:05', NULL),
(6, 'Tchimou Junior', 'Dev.ops Mobile', '<p>Pas de mot</p>', '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', '<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');
-- --------------------------------------------------------
--
-- 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', '<p>- Diagnostic des chaînes d\'approvisionnement<br>- Analyse des marchés et filières<br>- Développement stratégique de chaînes de valeurs<br>- Accompagnement dossiers d\'agrément<br>- Gestion des activités d\'export de matières premières<br>- Commerce international (prospection des opportunités) et mise en relation.<br>- Formation et accompagnement aux certifications agricoles (BIO, RainFo­rest,...) cacao trace, Agriculture climato-intelligence<br>- Commerce intérieur, commerce extérieur<br>- Formations techniques agricoles<br>- Développement de marché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éfinition des objectifs<br>- Élaboration de plans de mise en œuvre<br>- Définition et implé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-évaluation des projets<br>- É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évéler les axes de progrès qui soient mesurables.<br>- Accompagner nos clients dans leurs objectifs de construction, redéploiement, de consolidation des activités des départements d\'approvisionnement et transport.<br>- Favoriser les croisements d\'expériences d\'une entreprise à 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égie de communication<br>- Conseil stratégique en communication<br>- Marketing relationnel<br>- Coordination/supervision de mise en œuvre de plans et stratégies de communication<br>- Etudes de marchés<br>- Veille concurrentielle<br>- Relations médias<br>- Conception et réalisation de support de communication (spot tv & radio, flyers, insertions presse, kakemonos, etc.)<br>- Social media & community manage­ment permanent<br>- Gestion des campagne en ligne<br>- Conception et réalisation de site et application web<br>- Publicité<br>- Evè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évéler les axes de progrès qui soient mesurables.<br>- Accompagner nos clients dans leurs objectifs de construction, redéploie­ment, de consolidation des activités des départements d\'approvisionne­ment et transport.<br>- Favoriser les croisements d\'expé­rience d\'une entreprise à 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érons vos opérations de commerce à l\'international pour vous aider à importer du monde entier, en toute confiance et avec une garantie de bonne fin de chaque transaction.<br>- Importation de matériels agricoles et industriels<br>- lmport et Export de produits divers<br>- Inspection & Contrô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égies de lutte contre le changement climatique<br>- Inventaire de la biodiversité<br>- Cartographie écologique et forestière<br>- Reforestation individuelle et communautaire<br>- Reboisement - Aménagement forestier<br>- Diagnostics et audits environnementaux<br>- Elaboration de plans d\'aménagement<br>- Plan et mesure de conservation, de gestion des milieux naturels<br>- Etudes d\'Impact Environnemental et Social<br>- Renforcement des capacité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');
-- --------------------------------------------------------
--
-- 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