-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : mer. 12 fév. 2025 à 17:22
-- Version du serveur : 8.4.3
-- Version de PHP : 8.3.16
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 */;
--
-- Base de données : `atirao`
--
-- --------------------------------------------------------
--
-- Structure de la table `categories`
--
CREATE TABLE `categories` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text 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;
--
-- Déchargement des données de la table `categories`
--
INSERT INTO `categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(7, 'Automation', 'Automatisez vos actions marketing', NULL, NULL),
(8, 'SEO', 'Améliorez votre positionnement', NULL, NULL);
-- --------------------------------------------------------
--
-- Structure de la table `data_rows`
--
CREATE TABLE `data_rows` (
`id` int UNSIGNED NOT NULL,
`data_type_id` int UNSIGNED NOT NULL,
`field` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`display_name` varchar(191) 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `data_rows`
--
INSERT INTO `data_rows` (`id`, `data_type_id`, `field`, `type`, `display_name`, `required`, `browse`, `read`, `edit`, `add`, `delete`, `details`, `order`) VALUES
(1, 1, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(2, 1, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(3, 1, 'email', 'text', 'Email', 1, 1, 1, 1, 1, 1, NULL, 3),
(4, 1, 'password', 'password', 'Password', 1, 0, 0, 1, 1, 0, NULL, 4),
(5, 1, 'remember_token', 'text', 'Remember Token', 0, 0, 0, 0, 0, 0, NULL, 5),
(6, 1, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 0, 0, 0, NULL, 6),
(7, 1, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 7),
(8, 1, 'avatar', 'image', 'Avatar', 0, 1, 1, 1, 1, 1, NULL, 8),
(9, 1, 'user_belongsto_role_relationship', 'relationship', 'Role', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsTo\",\"column\":\"role_id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"roles\",\"pivot\":0}', 10),
(10, 1, 'user_belongstomany_role_relationship', 'relationship', 'Roles', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"user_roles\",\"pivot\":\"1\",\"taggable\":\"0\"}', 11),
(11, 1, 'settings', 'hidden', 'Settings', 0, 0, 0, 0, 0, 0, NULL, 12),
(12, 2, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(13, 2, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(14, 2, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3),
(15, 2, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(16, 3, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(17, 3, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(18, 3, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3),
(19, 3, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(20, 3, 'display_name', 'text', 'Display Name', 1, 1, 1, 1, 1, 1, NULL, 5),
(21, 1, 'role_id', 'text', 'Role', 1, 1, 1, 1, 1, 1, NULL, 9),
(22, 5, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(23, 5, 'name', 'text', 'Name', 0, 1, 1, 1, 1, 1, '{}', 4),
(24, 5, 'slug', 'text', 'Slug', 0, 1, 1, 1, 1, 1, '{}', 5),
(25, 5, 'description', 'text', 'Description', 0, 1, 1, 1, 1, 1, '{}', 6),
(26, 5, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 7),
(27, 5, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 8),
(28, 5, 'category', 'text', 'Category', 0, 1, 1, 1, 1, 1, '{}', 2),
(29, 5, 'icon', 'text_area', 'Icon', 0, 0, 0, 1, 1, 1, '{}', 9),
(30, 5, 'order', 'text', 'Order', 0, 1, 1, 1, 1, 1, '{}', 10),
(31, 5, 'categ_description', 'text', 'Categ Description', 0, 1, 1, 1, 1, 1, '{}', 3);
-- --------------------------------------------------------
--
-- Structure de la table `data_types`
--
CREATE TABLE `data_types` (
`id` int UNSIGNED NOT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`display_name_singular` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`display_name_plural` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`model_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`policy_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`controller` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` varchar(191) 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `data_types`
--
INSERT INTO `data_types` (`id`, `name`, `slug`, `display_name_singular`, `display_name_plural`, `icon`, `model_name`, `policy_name`, `controller`, `description`, `generate_permissions`, `server_side`, `details`, `created_at`, `updated_at`) VALUES
(1, 'users', 'users', 'User', 'Users', 'voyager-person', 'TCG\\Voyager\\Models\\User', 'TCG\\Voyager\\Policies\\UserPolicy', 'TCG\\Voyager\\Http\\Controllers\\VoyagerUserController', '', 1, 0, NULL, '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(2, 'menus', 'menus', 'Menu', 'Menus', 'voyager-list', 'TCG\\Voyager\\Models\\Menu', NULL, '', '', 1, 0, NULL, '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(3, 'roles', 'roles', 'Role', 'Roles', 'voyager-lock', 'TCG\\Voyager\\Models\\Role', NULL, 'TCG\\Voyager\\Http\\Controllers\\VoyagerRoleController', '', 1, 0, NULL, '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(5, 'services', 'services', 'Service', 'Services', NULL, 'App\\Models\\Service', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2024-12-12 13:18:07', '2024-12-18 14:11:26');
-- --------------------------------------------------------
--
-- Structure de la table `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint UNSIGNED NOT NULL,
`uuid` varchar(191) 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Structure de la table `menus`
--
CREATE TABLE `menus` (
`id` int UNSIGNED NOT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `menus`
--
INSERT INTO `menus` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'admin', '2024-12-12 12:25:45', '2024-12-12 12:25:45');
-- --------------------------------------------------------
--
-- Structure de la table `menu_items`
--
CREATE TABLE `menu_items` (
`id` int UNSIGNED NOT NULL,
`menu_id` int UNSIGNED DEFAULT NULL,
`title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`target` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
`icon_class` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`color` varchar(191) 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(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`parameters` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `menu_items`
--
INSERT INTO `menu_items` (`id`, `menu_id`, `title`, `url`, `target`, `icon_class`, `color`, `parent_id`, `order`, `created_at`, `updated_at`, `route`, `parameters`) VALUES
(1, 1, 'Dashboard', '', '_self', 'voyager-boat', NULL, NULL, 1, '2024-12-12 12:25:45', '2024-12-12 12:25:45', 'voyager.dashboard', NULL),
(2, 1, 'Media', '', '_self', 'voyager-images', NULL, NULL, 5, '2024-12-12 12:25:45', '2024-12-12 12:25:45', 'voyager.media.index', NULL),
(3, 1, 'Users', '', '_self', 'voyager-person', NULL, NULL, 3, '2024-12-12 12:25:45', '2024-12-12 12:25:45', 'voyager.users.index', NULL),
(4, 1, 'Roles', '', '_self', 'voyager-lock', NULL, NULL, 2, '2024-12-12 12:25:45', '2024-12-12 12:25:45', 'voyager.roles.index', NULL),
(5, 1, 'Tools', '', '_self', 'voyager-tools', NULL, NULL, 9, '2024-12-12 12:25:45', '2024-12-12 12:25:45', NULL, NULL),
(6, 1, 'Menu Builder', '', '_self', 'voyager-list', NULL, 5, 10, '2024-12-12 12:25:45', '2024-12-12 12:25:45', 'voyager.menus.index', NULL),
(7, 1, 'Database', '', '_self', 'voyager-data', NULL, 5, 11, '2024-12-12 12:25:45', '2024-12-12 12:25:45', 'voyager.database.index', NULL),
(8, 1, 'Compass', '', '_self', 'voyager-compass', NULL, 5, 12, '2024-12-12 12:25:45', '2024-12-12 12:25:45', 'voyager.compass.index', NULL),
(9, 1, 'BREAD', '', '_self', 'voyager-bread', NULL, 5, 13, '2024-12-12 12:25:45', '2024-12-12 12:25:45', 'voyager.bread.index', NULL),
(10, 1, 'Settings', '', '_self', 'voyager-settings', NULL, NULL, 14, '2024-12-12 12:25:45', '2024-12-12 12:25:45', 'voyager.settings.index', NULL),
(11, 1, 'Services', '', '_self', NULL, NULL, NULL, 15, '2024-12-12 13:18:08', '2024-12-12 13:18:08', 'voyager.services.index', NULL);
-- --------------------------------------------------------
--
-- Structure de la table `migrations`
--
CREATE TABLE `migrations` (
`id` int UNSIGNED NOT NULL,
`migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `migrations`
--
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_01_01_000000_add_voyager_user_fields', 1),
(4, '2016_01_01_000000_create_data_types_table', 1),
(5, '2016_05_19_173453_create_menu_table', 1),
(6, '2016_10_21_190000_create_roles_table', 1),
(7, '2016_10_21_190000_create_settings_table', 1),
(8, '2016_11_30_135954_create_permission_table', 1),
(9, '2016_11_30_141208_create_permission_role_table', 1),
(10, '2016_12_26_201236_data_types__add__server_side', 1),
(11, '2017_01_13_000000_add_route_to_menu_items_table', 1),
(12, '2017_01_14_005015_create_translations_table', 1),
(13, '2017_01_15_000000_make_table_name_nullable_in_permissions_table', 1),
(14, '2017_03_06_000000_add_controller_to_data_types_table', 1),
(15, '2017_04_21_000000_add_order_to_data_rows_table', 1),
(16, '2017_07_05_210000_add_policyname_to_data_types_table', 1),
(17, '2017_08_05_000000_add_group_to_settings_table', 1),
(18, '2017_11_26_013050_add_user_role_relationship', 1),
(19, '2017_11_26_015000_create_user_roles_table', 1),
(20, '2018_03_11_000000_add_user_settings', 1),
(21, '2018_03_14_000000_add_details_to_data_types_table', 1),
(22, '2018_03_16_000000_make_settings_value_nullable', 1),
(23, '2019_08_19_000000_create_failed_jobs_table', 1),
(24, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(25, '2025_02_11_165836_create_categories_table', 2),
(26, '2025_02_11_165837_create_services_table', 2),
(27, '2025_02_12_075427_add_order_and_icon_to_services_table', 3);
-- --------------------------------------------------------
--
-- Structure de la table `password_resets`
--
CREATE TABLE `password_resets` (
`email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Structure de la table `permissions`
--
CREATE TABLE `permissions` (
`id` bigint UNSIGNED NOT NULL,
`key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`table_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `permissions`
--
INSERT INTO `permissions` (`id`, `key`, `table_name`, `created_at`, `updated_at`) VALUES
(1, 'browse_admin', NULL, '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(2, 'browse_bread', NULL, '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(3, 'browse_database', NULL, '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(4, 'browse_media', NULL, '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(5, 'browse_compass', NULL, '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(6, 'browse_menus', 'menus', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(7, 'read_menus', 'menus', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(8, 'edit_menus', 'menus', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(9, 'add_menus', 'menus', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(10, 'delete_menus', 'menus', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(11, 'browse_roles', 'roles', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(12, 'read_roles', 'roles', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(13, 'edit_roles', 'roles', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(14, 'add_roles', 'roles', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(15, 'delete_roles', 'roles', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(16, 'browse_users', 'users', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(17, 'read_users', 'users', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(18, 'edit_users', 'users', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(19, 'add_users', 'users', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(20, 'delete_users', 'users', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(21, 'browse_settings', 'settings', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(22, 'read_settings', 'settings', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(23, 'edit_settings', 'settings', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(24, 'add_settings', 'settings', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(25, 'delete_settings', 'settings', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(26, 'browse_services', 'services', '2024-12-12 13:18:08', '2024-12-12 13:18:08'),
(27, 'read_services', 'services', '2024-12-12 13:18:08', '2024-12-12 13:18:08'),
(28, 'edit_services', 'services', '2024-12-12 13:18:08', '2024-12-12 13:18:08'),
(29, 'add_services', 'services', '2024-12-12 13:18:08', '2024-12-12 13:18:08'),
(30, 'delete_services', 'services', '2024-12-12 13:18:08', '2024-12-12 13:18:08');
-- --------------------------------------------------------
--
-- Structure de la table `permission_role`
--
CREATE TABLE `permission_role` (
`permission_id` bigint UNSIGNED NOT NULL,
`role_id` bigint UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `permission_role`
--
INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1);
-- --------------------------------------------------------
--
-- Structure de la table `personal_access_tokens`
--
CREATE TABLE `personal_access_tokens` (
`id` bigint UNSIGNED NOT NULL,
`tokenable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint UNSIGNED NOT NULL,
`name` varchar(191) 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `personal_access_tokens`
--
INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `expires_at`, `created_at`, `updated_at`) VALUES
(65, 'App\\Models\\User', 2, 'auth_token', '97158f38a20ac4a9f37ace4c85da914a8aaa586edf69337c792de6c929da72d3', '[\"*\"]', '2025-02-12 13:35:01', NULL, '2025-02-12 13:03:28', '2025-02-12 13:35:01'),
(64, 'App\\Models\\User', 2, 'auth_token', '39cb4bbf7aa77ffc6a684c46169fefdc9f12b6531427f4d81e4dd157460718dd', '[\"*\"]', NULL, NULL, '2025-02-12 13:03:27', '2025-02-12 13:03:27'),
(63, 'App\\Models\\User', 2, 'auth_token', 'ec0940d99b83e93ed3ca550585699c205f4b0b852aec1f376c5c28903fb9dcfd', '[\"*\"]', '2025-02-12 13:03:22', NULL, '2025-02-12 12:35:20', '2025-02-12 13:03:22'),
(62, 'App\\Models\\User', 2, 'auth_token', '68af5b46852163e561ac0a7ad2d4ff65bbbdd1e44a790ab1c71990c01fcba537', '[\"*\"]', NULL, NULL, '2025-02-12 12:35:19', '2025-02-12 12:35:19'),
(61, 'App\\Models\\User', 2, 'auth_token', '45d9721408999dc86574f4332ae9ee5884cb02b68d04a00bab1b1f484db3a9da', '[\"*\"]', '2025-02-12 12:26:27', NULL, '2025-02-12 12:22:49', '2025-02-12 12:26:27'),
(60, 'App\\Models\\User', 2, 'auth_token', 'dd9a5fc6a663cf52b118b5153d16dec04cdb0a0fd8fb77b4d9aec28569526f6f', '[\"*\"]', '2025-02-12 12:22:36', NULL, '2025-02-12 11:56:11', '2025-02-12 12:22:36'),
(59, 'App\\Models\\User', 2, 'auth_token', '471bdf20168ba92431aacea4ae7ab7591642aa997896401c9d4a95a71aa8a08c', '[\"*\"]', NULL, NULL, '2025-02-12 11:56:10', '2025-02-12 11:56:10'),
(58, 'App\\Models\\User', 2, 'auth_token', '8dbee3b5b798a7529e606cc354d05ae4cebe77b67fd11137d4dc5ab9b2ae9543', '[\"*\"]', '2025-02-12 11:55:56', NULL, '2025-02-12 09:34:54', '2025-02-12 11:55:56'),
(57, 'App\\Models\\User', 2, 'auth_token', 'b392a3c1857f9b116ff1c74a454def491b70c1a2d1612fc1f348f5fbab1b4c7a', '[\"*\"]', '2025-02-12 09:34:27', NULL, '2025-02-12 09:25:20', '2025-02-12 09:34:27'),
(56, 'App\\Models\\User', 2, 'auth_token', 'e6ebf3e76f2ad8446e7167b1a4a1be374be56bfdc8f1c7a725182749293bc2cc', '[\"*\"]', NULL, NULL, '2025-02-12 09:25:14', '2025-02-12 09:25:14'),
(55, 'App\\Models\\User', 2, 'auth_token', '2e66a26ab682238c8ed8218e8b55a3c0285ff376e087481a0eaa66e7ae53a86b', '[\"*\"]', NULL, NULL, '2025-02-12 09:24:57', '2025-02-12 09:24:57'),
(54, 'App\\Models\\User', 2, 'auth_token', '0e038b880f61f1d16ce09de764fdf13b8b9c33063b2c379edfc3b42d8082b91c', '[\"*\"]', '2025-02-12 15:13:02', NULL, '2025-02-12 09:09:05', '2025-02-12 15:13:02'),
(53, 'App\\Models\\User', 2, 'auth_token', 'a791b1cf9f640a63c8a7ca107d90b8af5d243e265259766fe96d5b42cf25501d', '[\"*\"]', '2025-02-12 09:24:07', NULL, '2025-02-12 09:01:41', '2025-02-12 09:24:07'),
(52, 'App\\Models\\User', 2, 'auth_token', '278aa4d02888986c7f020cee5a4518513b88cc327d66a60ead3ad570d87fea08', '[\"*\"]', NULL, NULL, '2025-02-12 09:00:42', '2025-02-12 09:00:42'),
(66, 'App\\Models\\User', 2, 'auth_token', '4153af0c101a0009a41a46106c71b457cd05248786cc5e766c54229c6275c973', '[\"*\"]', '2025-02-12 14:19:01', NULL, '2025-02-12 13:35:17', '2025-02-12 14:19:01'),
(67, 'App\\Models\\User', 2, 'auth_token', 'efac3211002b08f8ca92b0ef7dc835cbcc0d47a7d086fb5995ad30dd54a537fd', '[\"*\"]', '2025-02-12 14:34:21', NULL, '2025-02-12 14:19:09', '2025-02-12 14:34:21'),
(68, 'App\\Models\\User', 2, 'auth_token', '2fa199eb3199ca2b392f4173c4028e57da1efc226b87a01be59faaacaf458dfe', '[\"*\"]', '2025-02-12 15:14:20', NULL, '2025-02-12 14:34:35', '2025-02-12 15:14:20'),
(69, 'App\\Models\\User', 2, 'auth_token', '4cc322b6997fc4af06c28bf004953a77bedc69523616158e6cc0f1d815c30284', '[\"*\"]', NULL, NULL, '2025-02-12 15:15:46', '2025-02-12 15:15:46'),
(70, 'App\\Models\\User', 2, 'auth_token', '73660cd6b3da036c1d6307e01da99ecc8964ce8ff6f7d69304dd66f0e605018b', '[\"*\"]', NULL, NULL, '2025-02-12 15:17:27', '2025-02-12 15:17:27'),
(71, 'App\\Models\\User', 2, 'auth_token', '0a1e77360960a268e2a51cfa4da6a13b850b5f213196131ba0f2a0a5e0e706b4', '[\"*\"]', NULL, NULL, '2025-02-12 15:17:37', '2025-02-12 15:17:37'),
(72, 'App\\Models\\User', 2, 'auth_token', '4ce3d66a6c7d8cee385e9823ce724313c45f0c5a9df2d63453a05a5eba4395ce', '[\"*\"]', NULL, NULL, '2025-02-12 15:21:10', '2025-02-12 15:21:10'),
(73, 'App\\Models\\User', 2, 'auth_token', '21e3118e7c0c08e10f08a3c432310f8d7012c2490351f6a4af76f079aa8521cc', '[\"*\"]', NULL, NULL, '2025-02-12 15:21:51', '2025-02-12 15:21:51'),
(74, 'App\\Models\\User', 2, 'auth_token', 'fba478c823bd41432ef953c49e6076ef97ea8ca70e500b7758660d3fec757bed', '[\"*\"]', NULL, NULL, '2025-02-12 15:22:29', '2025-02-12 15:22:29'),
(75, 'App\\Models\\User', 2, 'auth_token', 'cc1d6f5c55288f36812bb05d4f53abc0134e26422974d03883322f94248d86f5', '[\"*\"]', NULL, NULL, '2025-02-12 15:24:26', '2025-02-12 15:24:26'),
(76, 'App\\Models\\User', 2, 'auth_token', '01b24384951a7695e76d9bf1e1638e0f1356bb0cc9c22b8c14b472fc2d4071f0', '[\"*\"]', NULL, NULL, '2025-02-12 15:28:29', '2025-02-12 15:28:29'),
(77, 'App\\Models\\User', 2, 'auth_token', '2604be6bf35b0954b216ab874c83807b9b6d176a16fb25530ee7697119b667b6', '[\"*\"]', NULL, NULL, '2025-02-12 15:28:52', '2025-02-12 15:28:52'),
(78, 'App\\Models\\User', 2, 'auth_token', '1294a6e7f6a40e914725b5b825564ee135e38a45378774ce234b3cbb74ed01a9', '[\"*\"]', NULL, NULL, '2025-02-12 15:29:20', '2025-02-12 15:29:20'),
(79, 'App\\Models\\User', 2, 'auth_token', 'b4d3ec216b0ee56476c0da1c0e89cf4f94ffa1f2f2e4c3ce08c3f6c5cc6ee918', '[\"*\"]', NULL, NULL, '2025-02-12 15:31:16', '2025-02-12 15:31:16'),
(80, 'App\\Models\\User', 2, 'auth_token', 'ea4880a9654764b6b044eb8a429475a58066fe77c9ef41ee64b94d7dd1112e9c', '[\"*\"]', NULL, NULL, '2025-02-12 15:31:26', '2025-02-12 15:31:26'),
(81, 'App\\Models\\User', 2, 'auth_token', '9e4f4ff8fd878eef2b1c966ebcecb2ecddc88b997957c9b633baef0dabe83173', '[\"*\"]', NULL, NULL, '2025-02-12 15:31:55', '2025-02-12 15:31:55'),
(82, 'App\\Models\\User', 2, 'auth_token', '6d65e6e4cbcc262f1e66052990834552d1f09c56fc6bd660f8087b997a74cdcd', '[\"*\"]', '2025-02-12 15:33:10', NULL, '2025-02-12 15:32:10', '2025-02-12 15:33:10');
-- --------------------------------------------------------
--
-- Structure de la table `roles`
--
CREATE TABLE `roles` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`display_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `roles`
--
INSERT INTO `roles` (`id`, `name`, `display_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Administrator', '2024-12-12 12:25:45', '2024-12-12 12:25:45'),
(2, 'user', 'Normal User', '2024-12-12 12:25:45', '2024-12-12 12:25:45');
-- --------------------------------------------------------
--
-- Structure de la table `services`
--
CREATE TABLE `services` (
`id` int UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` int DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`icon` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`order` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`categ_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `services`
--
INSERT INTO `services` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`, `category`, `icon`, `order`, `categ_description`) VALUES
(1, 'Google Ads (SEA)', 'Google_Ads', NULL, '2024-12-12 13:20:00', '2024-12-18 14:43:01', 'Paid Ads', '', 'one', 'Attirez plus de trafic qualifié'),
(2, 'Social Ads', 'Social_Ads', NULL, '2024-12-12 13:20:00', '2024-12-18 14:43:03', 'Paid Ads', '', 'one', 'Meta, TikTok, LinkedIn…'),
(3, 'Amazon Ads', 'Amazon_Ads', NULL, '2024-12-12 13:20:00', '2024-12-18 14:43:08', 'Paid Ads', '', 'one', 'Améliorez votre ROI'),
(4, 'Programmatique et display', 'Programmatique_display', NULL, '2024-12-12 13:21:00', '2024-12-18 14:42:57', 'Paid Ads', '', 'one', 'Améliorez votre ROI'),
(5, 'Community Management', 'Community_Management', NULL, '2024-12-12 13:39:00', '2024-12-18 14:42:33', 'Content Marketing', '', 'two', 'Augmentez votre visibilité'),
(6, 'Social Media Content', 'Social_Media_Content', NULL, '2024-12-12 13:39:00', '2024-12-18 14:42:36', 'Content Marketing', '', 'two', 'Augmentez votre visibilité'),
(7, 'E-réputation', 'E-réputation', NULL, '2024-12-12 13:39:00', '2024-12-18 14:42:38', 'Content Marketing', '', 'two', 'Augmentez votre visibilité'),
(8, 'Identité de marque', 'Identité_marque', NULL, '2024-12-12 13:40:00', '2024-12-18 14:42:04', 'Content Marketing', '', 'three', 'Touchez votre public cible'),
(9, 'Charte graphique', 'Charte_graphique', NULL, '2024-12-12 13:40:00', '2024-12-18 14:42:07', 'Content Marketing', '', 'three', 'Touchez votre public cible'),
(10, 'Montage vidéo', 'Montage_vidéo', NULL, '2024-12-12 13:40:00', '2024-12-18 14:42:09', 'Content Marketing', '', 'three', 'Touchez votre public cible'),
(11, 'Rédaction web', 'Rédaction_web', NULL, '2024-12-12 13:40:00', '2024-12-18 14:42:12', 'Content Marketing', '', 'three', 'Touchez votre public cible'),
(12, 'Site web et landing page', 'Siteweb_landingpage', NULL, '2024-12-12 13:41:00', '2024-12-18 14:41:46', 'Développement Web', '', 'fore', 'Développez un site web optimisé'),
(13, 'Application', 'Application', NULL, '2024-12-12 13:42:00', '2024-12-18 14:41:40', 'Développement Web', '', 'fore', 'Développez un site web optimisé'),
(14, 'Reporting et datavisualisation', 'Reporting_datavisualisation', NULL, '2024-12-12 16:03:00', '2024-12-18 14:41:18', 'Analytics et data', '', 'five', 'Mesurez l\'efficacité de vos actions'),
(15, 'Tag management system', 'Tagmanagement_system', NULL, '2024-12-12 16:04:00', '2024-12-18 14:41:13', 'Analytics et data', '', 'five', 'Mesurez l\'efficacité de vos actions'),
(16, 'Solution de MMP', 'Solution_MMP', NULL, '2024-12-12 16:04:00', '2024-12-18 14:41:08', 'Analytics et data', '', 'five', 'Mesurez l\'efficacité de vos actions'),
(17, 'Accompagnement digital', 'Accompagnement_digital', NULL, '2024-12-12 16:05:00', '2024-12-18 14:40:29', 'Marketing Digital', '', 'six', 'Agence marketing digital à 360°C'),
(18, 'Audit digital', 'Audit_digital', NULL, '2024-12-12 16:05:00', '2024-12-18 14:40:26', 'Marketing Digital', '', 'six', 'Agence marketing digital à 360°C'),
(19, 'Formations', 'Formations', NULL, '2024-12-12 16:06:00', '2024-12-18 14:40:23', 'Marketing Digital', '', 'six', 'Agence marketing digital à 360°C'),
(20, 'Whatsapping', 'Whatsapping', NULL, '2024-12-12 16:07:00', '2024-12-18 14:39:58', 'Automation', '', 'seven', 'Automatisez vos actions marketing'),
(21, 'Smsing', 'Smsing', NULL, '2024-12-12 16:07:00', '2024-12-18 14:40:00', 'Automation', '', 'seven', 'Automatisez vos actions marketing'),
(22, 'Emailing', 'Emailing', NULL, '2024-12-12 16:08:00', '2024-12-18 14:39:55', 'Automation', '', 'seven', 'Automatisez vos actions marketing'),
(23, 'Stratégie de netlinking', 'Stratégie_netlinking', NULL, '2024-12-12 16:09:00', '2024-12-18 14:39:37', 'SEO', '', 'eat', 'Améliorez votre positionnement'),
(24, 'Monitoring et suivi', 'Monitoring_suivi', NULL, '2024-12-12 16:09:00', '2024-12-18 14:39:33', 'SEO', NULL, 'eat', 'Améliorez votre positionnement'),
(25, 'Référencement local', 'Référencement_local', NULL, '2024-12-12 16:10:00', '2024-12-18 14:39:30', 'SEO', NULL, 'eat', 'Améliorez votre positionnement'),
(26, 'Google Ads (SEA)', 'Google_Ads', NULL, '2024-12-12 12:20:00', '2024-12-18 13:43:01', NULL, '', 'one', NULL),
(27, 'Social Ads', 'Social_Ads', NULL, '2024-12-12 12:20:00', '2024-12-18 13:43:03', NULL, '', 'one', NULL),
(28, 'Amazon Ads', 'Amazon_Ads', NULL, '2024-12-12 12:20:00', '2024-12-18 13:43:08', NULL, '', 'one', NULL);
INSERT INTO `services` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`, `category`, `icon`, `order`, `categ_description`) VALUES
(29, 'Programmatique et display', 'Programmatique_display', NULL, '2024-12-12 12:21:00', '2024-12-18 13:42:57', NULL, '', 'one', NULL),
(30, 'Community Management', 'Community_Management', NULL, '2024-12-12 12:39:00', '2024-12-18 13:42:33', NULL, '', 'two', NULL),
(31, 'Social Media Content', 'Social_Media_Content', NULL, '2024-12-12 12:39:00', '2024-12-18 13:42:36', NULL, '', 'two', NULL),
(32, 'E-réputation', 'E-réputation', NULL, '2024-12-12 12:39:00', '2024-12-18 13:42:38', NULL, '', 'two', NULL),
(33, 'Identité de marque', 'Identité_marque', NULL, '2024-12-12 12:40:00', '2024-12-18 13:42:04', NULL, '', 'three', NULL),
(34, 'Charte graphique', 'Charte_graphique', NULL, '2024-12-12 12:40:00', '2024-12-18 13:42:07', NULL, '', 'three', NULL),
(35, 'Montage vidéo', 'Montage_vidéo', NULL, '2024-12-12 12:40:00', '2024-12-18 13:42:09', NULL, '', 'three', NULL),
(36, 'Rédaction web & storytelling', 'Rédaction_web', NULL, '2024-12-12 12:40:00', '2024-12-18 13:42:12', NULL, '', 'three', NULL),
(37, 'Site web et landing page', 'Siteweb_landingpage', NULL, '2024-12-12 12:41:00', '2024-12-18 13:41:46', NULL, '', 'fore', NULL),
(38, 'Application', 'Application', NULL, '2024-12-12 12:42:00', '2024-12-18 13:41:40', NULL, '', 'fore', NULL),
(39, 'Reporting et datavisualisation', 'Reporting_datavisualisation', NULL, '2024-12-12 15:03:00', '2024-12-18 13:41:18', NULL, '', 'five', NULL),
(40, 'Tag management system', 'Tagmanagement_system', NULL, '2024-12-12 15:04:00', '2024-12-18 13:41:13', NULL, '', 'five', NULL),
(41, 'Solution de MMP', 'Solution_MMP', NULL, '2024-12-12 15:04:00', '2024-12-18 13:41:08', NULL, '', 'five', NULL),
(42, 'Accompagnement digital', 'Accompagnement_digital', NULL, '2024-12-12 15:05:00', '2024-12-18 13:40:29', NULL, '', 'six', NULL),
(43, 'Audit digital', 'Audit_digital', NULL, '2024-12-12 15:05:00', '2024-12-18 13:40:26', NULL, '', 'six', NULL),
(44, 'Formations', 'Formations', NULL, '2024-12-12 15:06:00', '2024-12-18 13:40:23', NULL, '', 'six', NULL),
(45, 'Whatsapping', 'Whatsapping', NULL, '2024-12-12 15:07:00', '2024-12-18 13:39:58', NULL, '', 'seven', NULL),
(46, 'Smsing', 'Smsing', NULL, '2024-12-12 15:07:00', '2024-12-18 13:40:00', NULL, '', 'seven', NULL),
(47, 'Emailing', 'Emailing', NULL, '2024-12-12 15:08:00', '2024-12-18 13:39:55', NULL, '', 'seven', NULL),
(48, 'Stratégie de netlinking', 'Stratégie_netlinking', NULL, '2024-12-12 15:09:00', '2024-12-18 13:39:37', NULL, '', 'eat', NULL),
(49, 'Monitoring et suivi', 'Monitoring_suivi', NULL, '2024-12-12 15:09:00', '2024-12-18 13:39:33', NULL, NULL, 'eat', NULL),
(50, 'Référencement local', 'Référencement_local', NULL, '2024-12-12 15:10:00', '2024-12-18 13:39:30', NULL, NULL, 'eat', NULL);
-- --------------------------------------------------------
--
-- Structure de la table `services2`
--
CREATE TABLE `services2` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`categorie_id` bigint UNSIGNED DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`order` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`icon` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `services2`
--
INSERT INTO `services2` (`id`, `name`, `slug`, `description`, `categorie_id`, `created_at`, `updated_at`, `order`, `icon`) VALUES
(45, 'Whatsapping', 'Whatsapping', NULL, 7, '2024-12-12 15:07:00', '2024-12-18 13:39:58', 'seven', ''),
(46, 'Smsing', 'Smsing', NULL, 7, '2024-12-12 15:07:00', '2024-12-18 13:40:00', 'seven', ''),
(47, 'Emailing', 'Emailing', NULL, 7, '2024-12-12 15:08:00', '2024-12-18 13:39:55', 'seven', ''),
(48, 'Stratégie de netlinking', 'Stratégie_netlinking', NULL, 8, '2024-12-12 15:09:00', '2024-12-18 13:39:37', 'eat', ''),
(49, 'Monitoring et suivi', 'Monitoring_suivi', NULL, 8, '2024-12-12 15:09:00', '2024-12-18 13:39:33', 'eat', NULL),
(50, 'Référencement local', 'Référencement_local', NULL, 8, '2024-12-12 15:10:00', '2024-12-18 13:39:30', 'eat', NULL);
-- --------------------------------------------------------
--
-- Structure de la table `settings`
--
CREATE TABLE `settings` (
`id` int UNSIGNED NOT NULL,
`key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`display_name` varchar(191) 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(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`order` int NOT NULL DEFAULT '1',
`group` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `settings`
--
INSERT INTO `settings` (`id`, `key`, `display_name`, `value`, `details`, `type`, `order`, `group`) VALUES
(1, 'site.title', 'Site Title', 'Site Title', '', 'text', 1, 'Site'),
(2, 'site.description', 'Site Description', 'Site Description', '', 'text', 2, 'Site'),
(3, 'site.logo', 'Site Logo', '', '', 'image', 3, 'Site'),
(4, 'site.google_analytics_tracking_id', 'Google Analytics Tracking ID', '', '', 'text', 4, 'Site'),
(5, 'admin.bg_image', 'Admin Background Image', '', '', 'image', 5, 'Admin'),
(6, 'admin.title', 'Admin Title', 'Voyager', '', 'text', 1, 'Admin'),
(7, 'admin.description', 'Admin Description', 'Welcome to Voyager. The Missing Admin for Laravel', '', 'text', 2, 'Admin'),
(8, 'admin.loader', 'Admin Loader', '', '', 'image', 3, 'Admin'),
(9, 'admin.icon_image', 'Admin Icon Image', '', '', 'image', 4, 'Admin'),
(10, 'admin.google_analytics_client_id', 'Google Analytics Client ID (used for admin dashboard)', '', '', 'text', 1, 'Admin');
-- --------------------------------------------------------
--
-- Structure de la table `translations`
--
CREATE TABLE `translations` (
`id` int UNSIGNED NOT NULL,
`table_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`column_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`foreign_key` int UNSIGNED NOT NULL,
`locale` varchar(10) 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Structure de la table `users`
--
CREATE TABLE `users` (
`id` BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
`role_id` bigint UNSIGNED DEFAULT NULL,
`name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`avatar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'users/default.png',
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(191) 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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Déchargement des données de la table `users`
--
INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `settings`, `created_at`, `updated_at`) VALUES
(1, 1, 'aymane', 'aymaneatirao@gmail.com', 'users/default.png', NULL, '$2y$10$7JVNZaZk8n7fk3SjZzaKxOAUraifV5ENEdeOiHuDM4A2Wdd1Mbmf.', NULL, '{\"locale\":\"en\"}', '2024-12-12 12:30:04', '2024-12-18 12:35:23'),
(2, 1, 'Admin User', 'admin@example.com', 'users/default.png', NULL, '$2y$10$7JVNZaZk8n7fk3SjZzaKxOAUraifV5ENEdeOiHuDM4A2Wdd1Mbmf.', 'ZbbSKko3G2pE80DASgsEzFSGO4DODtldhIT1BaIGLOiDh2rWgZXxDtbGtAZc', NULL, '2025-02-11 10:42:19', '2025-02-11 10:42:44');
-- --------------------------------------------------------
--
-- Structure de la table `user_roles`
--
CREATE TABLE `user_roles` (
`user_id` bigint UNSIGNED NOT NULL,
`role_id` bigint UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Index pour les tables déchargées
--
--
-- Index pour la table `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`id`);
--
-- Index pour la table `data_rows`
--
ALTER TABLE `data_rows`
ADD PRIMARY KEY (`id`),
ADD KEY `data_rows_data_type_id_foreign` (`data_type_id`);
--
-- Index pour la 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`);
--
-- Index pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
--
-- Index pour la table `menus`
--
ALTER TABLE `menus`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `menus_name_unique` (`name`);
--
-- Index pour la table `menu_items`
--
ALTER TABLE `menu_items`
ADD PRIMARY KEY (`id`),
ADD KEY `menu_items_menu_id_foreign` (`menu_id`);
--
-- Index pour la table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Index pour la table `password_resets`
--
ALTER TABLE `password_resets`
ADD PRIMARY KEY (`email`);
--
-- Index pour la table `permissions`
--
ALTER TABLE `permissions`
ADD PRIMARY KEY (`id`),
ADD KEY `permissions_key_index` (`key`);
--
-- Index pour la 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`);
--
-- Index pour la 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`);
--
-- Index pour la table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `roles_name_unique` (`name`);
--
-- Index pour la table `services`
--
ALTER TABLE `services`
ADD PRIMARY KEY (`id`);
--
-- Index pour la table `services2`
--
ALTER TABLE `services2`
ADD PRIMARY KEY (`id`),
ADD KEY `services2_categorie_id_foreign` (`categorie_id`);
--
-- Index pour la table `settings`
--
ALTER TABLE `settings`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `settings_key_unique` (`key`);
--
-- Index pour la 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`);
--
-- Index pour la table `users`
--
ALTER TABLE `users`
ADD UNIQUE KEY `users_email_unique` (`email`),
ADD KEY `users_role_id_foreign` (`role_id`);
--
-- Index pour la 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 pour les tables déchargées
--
--
-- AUTO_INCREMENT pour la table `categories`
--
ALTER TABLE `categories`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT pour la table `data_rows`
--
ALTER TABLE `data_rows`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
--
-- AUTO_INCREMENT pour la table `data_types`
--
ALTER TABLE `data_types`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pour la table `menus`
--
ALTER TABLE `menus`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pour la table `menu_items`
--
ALTER TABLE `menu_items`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT pour la table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT pour la table `permissions`
--
ALTER TABLE `permissions`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT pour la table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;
--
-- AUTO_INCREMENT pour la table `roles`
--
ALTER TABLE `roles`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pour la table `services`
--
ALTER TABLE `services`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;
--
-- AUTO_INCREMENT pour la table `services2`
--
ALTER TABLE `services2`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;
--
-- AUTO_INCREMENT pour la table `settings`
--
ALTER TABLE `settings`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT pour la table `translations`
--
ALTER TABLE `translations`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- Contraintes pour les tables déchargées
--
--
-- Contraintes pour la table `services2`
--
ALTER TABLE `services2`
ADD CONSTRAINT `services2_categorie_id_foreign` FOREIGN KEY (`categorie_id`) REFERENCES `categories` (`id`);
--create posts
CREATE TABLE posts (
id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
user_id bigint UNSIGNED NOT NULL,
title VARCHAR(255) NOT NULL,
content TEXT NOT NULL,
image VARCHAR(255) NULL,
is_published BOOLEAN DEFAULT FALSE,
created_at TIMESTAMP NULL DEFAULT NULL,
updated_at TIMESTAMP NULL DEFAULT NULL,
deleted_at TIMESTAMP NULL DEFAULT NULL,
CONSTRAINT fk_posts_user FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
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 */;