Viewing File: /htdocs/jmknew.jmkconsulting-ci.com/fromgit/JMKFilamentDB/update_table_column.sql
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 25, 2024 at 04:25 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: `testfilamentjmk`
--
-- --------------------------------------------------------
--
-- Table structure for table `accueilabouts`
--
CREATE TABLE `accueilabouts` (
`id` bigint UNSIGNED NOT NULL,
`section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`subservice` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetextlist` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `accueilactus`
--
CREATE TABLE `accueilactus` (
`id` bigint UNSIGNED NOT NULL,
`section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetitle` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `accueilclientitems`
--
CREATE TABLE `accueilclientitems` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`accueilclient_id` bigint UNSIGNED 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 `accueilclients`
--
CREATE TABLE `accueilclients` (
`id` bigint UNSIGNED NOT NULL,
`section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `accueilformations`
--
CREATE TABLE `accueilformations` (
`id` bigint UNSIGNED NOT NULL,
`section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `accueilmanageritems`
--
CREATE TABLE `accueilmanageritems` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`accueilmanager_id` bigint UNSIGNED 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 `accueilmanagers`
--
CREATE TABLE `accueilmanagers` (
`id` bigint UNSIGNED NOT NULL,
`section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`textentreprise` text 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;
-- --------------------------------------------------------
--
-- Table structure for table `accueilprojetitems`
--
CREATE TABLE `accueilprojetitems` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`subservice` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `accueilserviceitems`
--
CREATE TABLE `accueilserviceitems` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`subservice` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`accueilservice_id` bigint UNSIGNED 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 `accueilservices`
--
CREATE TABLE `accueilservices` (
`id` bigint UNSIGNED NOT NULL,
`secton` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetitle` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `accueiltemoins`
--
CREATE TABLE `accueiltemoins` (
`id` bigint UNSIGNED NOT NULL,
`section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetitle` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `accueilvideos`
--
CREATE TABLE `accueilvideos` (
`id` bigint UNSIGNED NOT NULL,
`section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`videolien` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `actualites`
--
CREATE TABLE `actualites` (
`id` bigint UNSIGNED NOT NULL,
`section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`dateactu` timestamp NULL DEFAULT NULL,
`managernom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`typeformation_id` bigint UNSIGNED DEFAULT NULL,
`accueilactu_id` bigint UNSIGNED 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 `composite_views`
--
CREATE TABLE `composite_views` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`content` text COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`required` varchar(255) 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 `content_viewables`
--
CREATE TABLE `content_viewables` (
`content_view_id` bigint UNSIGNED NOT NULL,
`content_viewable_id` bigint UNSIGNED NOT NULL,
`content_viewable_type` varchar(255) 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 `content_views`
--
CREATE TABLE `content_views` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`content` text COLLATE utf8mb4_unicode_ci NOT NULL,
`priority` int NOT NULL DEFAULT '0',
`content_view_type_id` bigint UNSIGNED NOT NULL,
`composite_view_id` bigint UNSIGNED 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 `content_view_types`
--
CREATE TABLE `content_view_types` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) 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 `cultures`
--
CREATE TABLE `cultures` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `documents`
--
CREATE TABLE `documents` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`file` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `equipes`
--
CREATE TABLE `equipes` (
`id` bigint UNSIGNED NOT NULL,
`section` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`nom_prenom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fonction` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`accueiltemoin_id` bigint UNSIGNED 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 `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint UNSIGNED NOT NULL,
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext 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 `formations`
--
CREATE TABLE `formations` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imagetitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`typeformation_id` bigint UNSIGNED DEFAULT NULL,
`accueilformation_id` bigint UNSIGNED 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 `galleries`
--
CREATE TABLE `galleries` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `images`
--
CREATE TABLE `images` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`photo` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `impacts`
--
CREATE TABLE `impacts` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `lienfooters`
--
CREATE TABLE `lienfooters` (
`id` bigint UNSIGNED NOT NULL,
`titre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`lien_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`descript` text 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;
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` int UNSIGNED NOT NULL,
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `missions`
--
CREATE TABLE `missions` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `model_has_permissions`
--
CREATE TABLE `model_has_permissions` (
`permission_id` bigint UNSIGNED NOT NULL,
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `model_has_roles`
--
CREATE TABLE `model_has_roles` (
`role_id` bigint UNSIGNED NOT NULL,
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `opportunites`
--
CREATE TABLE `opportunites` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `partners`
--
CREATE TABLE `partners` (
`id` bigint UNSIGNED NOT NULL,
`imagetitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`descript` text 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;
-- --------------------------------------------------------
--
-- Table structure for table `password_resets`
--
CREATE TABLE `password_resets` (
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) 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,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`guard_name` varchar(255) 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 `personal_access_tokens`
--
CREATE TABLE `personal_access_tokens` (
`id` bigint UNSIGNED NOT NULL,
`tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`abilities` text COLLATE utf8mb4_unicode_ci,
`last_used_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 `produits`
--
CREATE TABLE `produits` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `publications`
--
CREATE TABLE `publications` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
CREATE TABLE `roles` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`guard_name` varchar(255) 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 `role_has_permissions`
--
CREATE TABLE `role_has_permissions` (
`permission_id` bigint UNSIGNED NOT NULL,
`role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`id` bigint UNSIGNED NOT NULL,
`nom_site` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`logo_site` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`contact_site` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_site` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`defaut_lang` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'fr',
`position_site` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`list_social` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lien_contact` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `slides`
--
CREATE TABLE `slides` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`soustitle` text COLLATE utf8mb4_unicode_ci,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`icone` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `typeformations`
--
CREATE TABLE `typeformations` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_admin` tinyint(1) NOT NULL DEFAULT '0',
`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 `valeurs`
--
CREATE TABLE `valeurs` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `videos`
--
CREATE TABLE `videos` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`videourl` varchar(255) 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;
-- --------------------------------------------------------
--
-- Table structure for table `visions`
--
CREATE TABLE `visions` (
`id` bigint UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`text` text COLLATE utf8mb4_unicode_ci,
`icone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutontitre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`boutonlien` varchar(255) 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;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `accueilabouts`
--
ALTER TABLE `accueilabouts`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `accueilactus`
--
ALTER TABLE `accueilactus`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `accueilclientitems`
--
ALTER TABLE `accueilclientitems`
ADD PRIMARY KEY (`id`),
ADD KEY `accueilclientitems_accueilclient_id_foreign` (`accueilclient_id`);
--
-- Indexes for table `accueilclients`
--
ALTER TABLE `accueilclients`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `accueilformations`
--
ALTER TABLE `accueilformations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `accueilmanageritems`
--
ALTER TABLE `accueilmanageritems`
ADD PRIMARY KEY (`id`),
ADD KEY `accueilmanageritems_accueilmanager_id_foreign` (`accueilmanager_id`);
--
-- Indexes for table `accueilmanagers`
--
ALTER TABLE `accueilmanagers`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `accueilprojetitems`
--
ALTER TABLE `accueilprojetitems`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `accueilserviceitems`
--
ALTER TABLE `accueilserviceitems`
ADD PRIMARY KEY (`id`),
ADD KEY `accueilserviceitems_accueilservice_id_foreign` (`accueilservice_id`);
--
-- Indexes for table `accueilservices`
--
ALTER TABLE `accueilservices`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `accueiltemoins`
--
ALTER TABLE `accueiltemoins`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `accueilvideos`
--
ALTER TABLE `accueilvideos`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `actualites`
--
ALTER TABLE `actualites`
ADD PRIMARY KEY (`id`),
ADD KEY `actualites_typeformation_id_foreign` (`typeformation_id`),
ADD KEY `actualites_accueilactu_id_foreign` (`accueilactu_id`);
--
-- Indexes for table `composite_views`
--
ALTER TABLE `composite_views`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `content_viewables`
--
ALTER TABLE `content_viewables`
ADD KEY `content_viewables_content_viewable_id_index` (`content_viewable_id`),
ADD KEY `content_viewables_content_viewable_type_index` (`content_viewable_type`),
ADD KEY `content_viewables_content_view_id_foreign` (`content_view_id`);
--
-- Indexes for table `content_views`
--
ALTER TABLE `content_views`
ADD PRIMARY KEY (`id`),
ADD KEY `content_views_content_view_type_id_foreign` (`content_view_type_id`),
ADD KEY `content_views_composite_view_id_foreign` (`composite_view_id`);
--
-- Indexes for table `content_view_types`
--
ALTER TABLE `content_view_types`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cultures`
--
ALTER TABLE `cultures`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `equipes`
--
ALTER TABLE `equipes`
ADD PRIMARY KEY (`id`),
ADD KEY `equipes_accueiltemoin_id_foreign` (`accueiltemoin_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 `formations`
--
ALTER TABLE `formations`
ADD PRIMARY KEY (`id`),
ADD KEY `formations_typeformation_id_foreign` (`typeformation_id`),
ADD KEY `formations_accueilformation_id_foreign` (`accueilformation_id`);
--
-- Indexes for table `galleries`
--
ALTER TABLE `galleries`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `images`
--
ALTER TABLE `images`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `impacts`
--
ALTER TABLE `impacts`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `lienfooters`
--
ALTER TABLE `lienfooters`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `missions`
--
ALTER TABLE `missions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);
--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);
--
-- Indexes for table `opportunites`
--
ALTER TABLE `opportunites`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `partners`
--
ALTER TABLE `partners`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
ADD KEY `password_resets_email_index` (`email`);
--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
ADD PRIMARY KEY (`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 `produits`
--
ALTER TABLE `produits`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `publications`
--
ALTER TABLE `publications`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
ADD PRIMARY KEY (`permission_id`,`role_id`),
ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);
--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `slides`
--
ALTER TABLE `slides`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `typeformations`
--
ALTER TABLE `typeformations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_email_unique` (`email`);
--
-- Indexes for table `valeurs`
--
ALTER TABLE `valeurs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `visions`
--
ALTER TABLE `visions`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `accueilabouts`
--
ALTER TABLE `accueilabouts`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueilactus`
--
ALTER TABLE `accueilactus`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueilclientitems`
--
ALTER TABLE `accueilclientitems`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueilclients`
--
ALTER TABLE `accueilclients`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueilformations`
--
ALTER TABLE `accueilformations`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueilmanageritems`
--
ALTER TABLE `accueilmanageritems`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueilmanagers`
--
ALTER TABLE `accueilmanagers`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueilprojetitems`
--
ALTER TABLE `accueilprojetitems`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueilserviceitems`
--
ALTER TABLE `accueilserviceitems`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueilservices`
--
ALTER TABLE `accueilservices`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueiltemoins`
--
ALTER TABLE `accueiltemoins`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `accueilvideos`
--
ALTER TABLE `accueilvideos`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `actualites`
--
ALTER TABLE `actualites`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `composite_views`
--
ALTER TABLE `composite_views`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `content_views`
--
ALTER TABLE `content_views`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `content_view_types`
--
ALTER TABLE `content_view_types`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cultures`
--
ALTER TABLE `cultures`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `equipes`
--
ALTER TABLE `equipes`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `formations`
--
ALTER TABLE `formations`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `impacts`
--
ALTER TABLE `impacts`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lienfooters`
--
ALTER TABLE `lienfooters`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `missions`
--
ALTER TABLE `missions`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `opportunites`
--
ALTER TABLE `opportunites`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `produits`
--
ALTER TABLE `produits`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `publications`
--
ALTER TABLE `publications`
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 for table `settings`
--
ALTER TABLE `settings`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `slides`
--
ALTER TABLE `slides`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `typeformations`
--
ALTER TABLE `typeformations`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `valeurs`
--
ALTER TABLE `valeurs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `videos`
--
ALTER TABLE `videos`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `visions`
--
ALTER TABLE `visions`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `accueilclientitems`
--
ALTER TABLE `accueilclientitems`
ADD CONSTRAINT `accueilclientitems_accueilclient_id_foreign` FOREIGN KEY (`accueilclient_id`) REFERENCES `accueilclients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `accueilmanageritems`
--
ALTER TABLE `accueilmanageritems`
ADD CONSTRAINT `accueilmanageritems_accueilmanager_id_foreign` FOREIGN KEY (`accueilmanager_id`) REFERENCES `accueilmanagers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `accueilserviceitems`
--
ALTER TABLE `accueilserviceitems`
ADD CONSTRAINT `accueilserviceitems_accueilservice_id_foreign` FOREIGN KEY (`accueilservice_id`) REFERENCES `accueilservices` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `actualites`
--
ALTER TABLE `actualites`
ADD CONSTRAINT `actualites_accueilactu_id_foreign` FOREIGN KEY (`accueilactu_id`) REFERENCES `accueilactus` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `actualites_typeformation_id_foreign` FOREIGN KEY (`typeformation_id`) REFERENCES `typeformations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `content_viewables`
--
ALTER TABLE `content_viewables`
ADD CONSTRAINT `content_viewables_content_view_id_foreign` FOREIGN KEY (`content_view_id`) REFERENCES `content_views` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `content_views`
--
ALTER TABLE `content_views`
ADD CONSTRAINT `content_views_composite_view_id_foreign` FOREIGN KEY (`composite_view_id`) REFERENCES `composite_views` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `content_views_content_view_type_id_foreign` FOREIGN KEY (`content_view_type_id`) REFERENCES `content_view_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `equipes`
--
ALTER TABLE `equipes`
ADD CONSTRAINT `equipes_accueiltemoin_id_foreign` FOREIGN KEY (`accueiltemoin_id`) REFERENCES `accueiltemoins` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `formations`
--
ALTER TABLE `formations`
ADD CONSTRAINT `formations_accueilformation_id_foreign` FOREIGN KEY (`accueilformation_id`) REFERENCES `accueilformations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `formations_typeformation_id_foreign` FOREIGN KEY (`typeformation_id`) REFERENCES `typeformations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`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