-- https://www.phpmyadmin.net/
--
-- Hôte : jafrchesedipal.mysql.db
-- Généré le : jeu. 21 mai 2026 à 00:02
-- Version du serveur : 8.0.45-36
-- Version de PHP : 8.1.33

START TRANSACTION;



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

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

--
-- Structure de la table `categories`
--

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `nom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` 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;

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

INSERT INTO `categories` (`id`, `nom`, `image`, `created_at`, `updated_at`) VALUES
(1, 'Batiment', '1716223811.jpg', '2024-05-20 16:50:11', '2024-05-20 16:50:11'),
(7, 'Création et Couture', '1716491761.jpg', '2024-05-23 19:16:01', '2025-01-02 11:01:21'),
(8, 'Entretiien et Nettoyage', '1735813595.jpeg', '2025-01-02 09:26:35', '2025-01-02 09:26:35'),
(9, 'Assistance medicale', '1735819615.png', '2025-01-02 11:06:55', '2025-01-02 11:06:55'),
(10, 'Agriculture /Agrobusiness', '1735820032.jpeg', '2025-01-02 11:13:52', '2025-01-02 11:13:52');

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

--
-- Structure de la table `clients`
--

CREATE TABLE `clients` (
  `id` bigint UNSIGNED NOT NULL,
  `nom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prenom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `adresse` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` 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 `clients`
--

INSERT INTO `clients` (`id`, `nom`, `prenom`, `tel`, `adresse`, `photo`, `created_at`, `updated_at`, `password`, `code`) VALUES
(1, 'lkrzerjn', 'zklet,tr', '778745257', 'lsfnsf', NULL, '2024-05-23 14:00:25', '2024-05-23 14:00:25', 'passer', NULL),
(2, 'Ndiaye', 'Ibra', '777777777', 'km pa U5 301', NULL, '2024-07-07 18:02:51', '2024-07-07 18:02:51', 'passer', NULL),
(3, 'Ndaw', 'Modou', '779999999', 'km pa U5 301', NULL, '2024-07-07 18:53:46', '2024-07-07 18:53:46', 'passer', NULL),
(4, 'Ndiaye', 'Ibra', '773361230', 'km', NULL, '2024-09-29 15:31:37', '2024-09-29 15:31:37', 'passer', '4047'),
(5, 'ndiaye', 'ibra', '773361230', 'km', NULL, '2024-09-29 15:56:45', '2024-09-29 15:56:45', 'passer', '6155'),
(6, 'hhhhh', 'gghgg', '774444444', 'gghgh', NULL, '2024-09-29 16:45:34', '2024-09-29 16:45:34', 'passer', '7323'),
(7, 'Ndiayd', 'Ibra', '774874628', 'kn', NULL, '2024-10-03 19:52:14', '2024-10-03 19:52:14', 'passer', '9719'),
(8, 'Ndiaye', 'Ibra', '774874628', 'km', NULL, '2025-12-16 21:54:17', '2025-12-16 21:54:17', 'passer123', '1726'),
(9, 'Ndiaye', 'ibra', '775555555', 'km', NULL, '2025-12-20 10:56:15', '2025-12-20 10:56:15', 'passer', '3212'),
(10, 'Drame', 'Aissatou', '771848073', 'Dalifort', NULL, '2026-01-27 19:53:41', '2026-01-27 19:53:41', 'adrame', '9273'),
(11, 'DRAME', 'Aissatou', '771848073', 'Dalifort', NULL, '2026-01-28 12:26:41', '2026-01-28 12:26:41', 'adrame', '2750'),
(12, 'la', 'aminata', '774552125', 'km', NULL, '2026-01-28 12:35:59', '2026-01-28 12:35:59', 'passee', '7541'),
(13, 'ndiaye', 'ibra', '776545454', 'km', NULL, '2026-05-01 16:08:17', '2026-05-01 16:08:17', 'passer', '5685'),
(14, 'Ndiaye', 'Ibra', '771111111', 'Km', NULL, '2026-05-05 10:24:56', '2026-05-05 10:24:56', 'passer', '1516'),
(15, 'Ndiaye', 'Ibra', '771111112', 'km', NULL, '2026-05-05 10:32:44', '2026-05-05 10:32:44', 'passer', '6670'),
(16, 'aida', 'diop', '771048780', 'rufusque', NULL, '2026-05-14 16:55:52', '2026-05-14 16:55:52', 'passer22', '3850');

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

--
-- Structure de la 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;

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

--
-- Structure de la 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;

--
-- 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_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_05_12_215901_create_categories_table', 1),
(6, '2024_05_19_201337_create_sous_categories_table', 1),
(7, '2024_05_19_201357_create_ouvriers_table', 1),
(8, '2024_05_19_201420_create_clients_table', 1),
(9, '2024_05_19_201439_create_reservations_table', 1),
(11, '2024_05_19_201513_create_notations_table', 2),
(12, '2024_05_28_120840_update_table_add_column_to_ouvriers_table', 3),
(13, '2024_05_28_120903_update_table_add_column_to_clients_table', 3),
(14, '2024_06_05_221826_add_column_etat_to_ouvriers_table', 4),
(15, '2024_06_06_155207_add_column_noter_to_reservations_table', 5),
(16, '2024_07_07_133210_add_column_note_to_reservations_table', 6);

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

--
-- Structure de la table `notations`
--

CREATE TABLE `notations` (
  `id` bigint UNSIGNED NOT NULL,
  `note` double NOT NULL,
  `reservation_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;

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

INSERT INTO `notations` (`id`, `note`, `reservation_id`, `created_at`, `updated_at`) VALUES
(1, 4, 1, '2024-05-27 16:50:25', '2024-05-27 16:50:25'),
(3, 3, 2, '2024-06-06 15:56:13', '2024-06-06 15:56:13'),
(4, 4, 1, '2024-06-06 17:48:43', '2024-06-06 17:48:43'),
(5, 4, 3, '2024-06-07 16:13:58', '2024-06-07 16:13:58'),
(6, 4, 4, '2024-06-10 17:10:21', '2024-06-10 17:10:21'),
(7, 4, 4, '2024-07-06 22:59:56', '2024-07-06 22:59:56'),
(8, 4, 4, '2024-07-07 13:40:24', '2024-07-07 13:40:24');

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

--
-- Structure de la table `ouvriers`
--

CREATE TABLE `ouvriers` (
  `id` bigint UNSIGNED NOT NULL,
  `nom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prenom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `adresse` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sous_categorie_id` bigint UNSIGNED NOT NULL,
  `photo` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `note` double NOT NULL DEFAULT '0',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `etat` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ouvriers` (`id`, `nom`, `prenom`, `tel`, `adresse`, `sous_categorie_id`, `photo`, `created_at`, `updated_at`, `password`, `note`, `code`, `etat`) VALUES
(1, 'sfjnsejfnjk', 'slflrngf', '774874521', 'kjfnskfn', 1, '6689bccca0bba.jpeg', '2024-05-23 08:55:36', '2024-06-07 16:13:58', 'passer', 4, '4444', 1),
(2, 'Fall', 'Demba', '772354565', 'KM', 1, NULL, '2024-07-07 18:04:14', '2024-07-07 18:04:14', 'passer', 0, NULL, 0),
(3, 'Ndiaye', 'Modou', '772222222', 'km pa U5 301', 1, NULL, '2024-07-07 18:49:13', '2024-07-07 18:49:13', 'passer', 0, NULL, 0),
(4, 'ykwdyu', 'pailcx', 'jfriib', 'aaqhlx', 1, NULL, '2024-09-29 13:21:45', '2024-12-30 09:23:03', 'passer', 0, '1732', 1),
(5, 'business consulting', 'sab', '771048780', 'vdn cite comico', 16, NULL, '2025-01-03 19:12:23', '2025-01-03 19:13:21', 'passer2207', 0, '8025', 0),
(6, 'business', 'sab', '784807234', 'comico vdn', 16, NULL, '2025-01-03 19:15:49', '2025-01-03 19:18:16', 'passer2207', 0, '1166', 0),
(7, 'Ndiaye', 'Ibra', '774874628', 'km pa U5 301', 2, NULL, '2025-12-20 10:57:33', '2025-12-20 10:57:33', 'passer', 0, '2541', 0),
(8, 'ndiaye', 'moustapha', '776535355', 'arafat', 2, NULL, '2026-04-16 17:22:56', '2026-04-16 17:22:56', 'moutoupha', 0, '3500', 0),
(9, 'thiam', 'Mamadou Yande', '779094847', 'hlm Rufisque', 1, NULL, '2026-04-16 17:24:55', '2026-04-16 17:24:55', '4444', 0, '9015', 0),
(10, 'ndiaye', 'moustapha', '770607129', 'arafat4 rufisque', 2, NULL, '2026-04-16 17:30:00', '2026-04-16 17:30:00', 'moutoufeu', 0, '7362', 0),
(11, 'Drame', 'karamo', '775188485', 'rufisque', 14, NULL, '2026-04-20 19:21:46', '2026-04-20 19:21:46', 'karamodrame', 0, '7361', 0),
(12, 'Diagne', 'Diop', '774349923', 'thiokho Rufisque', 15, NULL, '2026-05-01 14:49:04', '2026-05-01 14:49:04', 'diopdiagne', 0, '3846', 0),
(13, 'DiopDiagne', 'guorgoui', '774349923', 'Rufisque thioxo', 15, NULL, '2026-05-01 15:00:27', '2026-05-01 15:00:27', 'diop', 0, '8447', 0),
(14, 'ndoye', 'ousseynou soudeur', '779365373', 'rufisque', 18, NULL, '2026-05-01 15:04:55', '2026-05-01 15:04:55', '1494', 0, '1898', 0),
(15, 'Diagne', 'gorgui Diagne', '774349923', 'Rufisque', 15, NULL, '2026-05-01 15:30:54', '2026-05-01 15:30:54', 'Diop', 0, '7469', 0),
(16, 'barry', 'mamadou', '707273290', 'keur massar', 15, NULL, '2026-05-03 17:08:31', '2026-05-03 17:08:31', 'pass123', 0, '2008', 0),
(19, 'Niang', 'Papa Babacar', '770707881', 'Rufisque keury souf', 22, NULL, '2026-05-05 12:57:34', '2026-05-05 12:57:34', '0357', 0, '3855', 0),
(20, 'Doumbia', 'Boua', '786093738', 'Rufisque Gabon', 14, NULL, '2026-05-10 10:32:24', '2026-05-10 10:32:24', 'Boua', 0, '5913', 0),
(21, 'diop', 'aissatou', '784807234', 'kounoune', 23, NULL, '2026-05-14 16:40:24', '2026-05-14 16:40:24', 'passer2207', 0, '1124', 0),
(22, 'massaba', 'aissadattr', '784807234', 'kounoune', 20, NULL, '2026-05-19 10:37:08', '2026-05-19 10:37:08', 'passer22', 0, '6938', 0);

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

--
-- Structure de la table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `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;

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

--
-- Structure de la 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;

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

--
-- Structure de la table `reservations`
--

CREATE TABLE `reservations` (
  `id` bigint UNSIGNED NOT NULL,
  `etat` tinyint(1) NOT NULL DEFAULT '0',
  `dater` date DEFAULT NULL,
  `client_id` bigint UNSIGNED NOT NULL,
  `ouvrier_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `noter` tinyint(1) NOT NULL DEFAULT '0',
  `note` double DEFAULT NULL,
  `validation` tinyint(1) NOT NULL DEFAULT '0',
  `modification` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `reservations` (`id`, `etat`, `dater`, `client_id`, `ouvrier_id`, `created_at`, `updated_at`, `noter`, `note`, `validation`, `modification`) VALUES
(1, 1, '2024-05-30', 1, 1, '2024-05-26 21:13:31', '2025-12-16 22:56:06', 1, 5, 1, 0),
(2, 1, '2024-05-23', 1, 1, '2024-05-31 21:12:02', '2025-12-16 22:56:04', 1, 4, 1, 0),
(3, 1, '2024-06-13', 1, 1, '2024-06-06 22:36:24', '2025-12-16 22:56:01', 1, 3, 1, 0),
(4, 1, '2024-06-11', 1, 1, '2024-06-10 17:06:55', '2025-12-16 22:56:00', 0, 0, 1, 0),
(5, 1, '2024-07-16', 1, 1, '2024-07-07 15:36:38', '2025-12-16 22:55:58', 0, 0, 1, 0),
(6, 1, '2024-07-26', 1, 1, '2024-07-07 19:22:58', '2025-12-16 22:55:47', 0, 0, 1, 1),
(7, 1, '2025-12-16', 8, 1, '2025-12-16 22:05:50', '2025-12-16 23:01:40', 0, 0, 1, 0),
(8, 1, '2025-12-22', 8, 1, '2025-12-19 16:06:12', '2025-12-19 23:17:31', 0, 0, 1, 0),
(9, 0, '2026-01-30', 10, 1, '2026-01-27 19:53:57', '2026-01-27 19:53:57', 0, 0, 0, 0),
(10, 1, '2026-01-31', 10, 7, '2026-01-27 19:54:08', '2026-05-12 12:15:53', 0, 0, 1, 0),
(11, 1, '2026-01-28', 11, 1, '2026-01-28 12:27:20', '2026-02-27 02:13:33', 0, 0, 1, 0),
(12, 1, '2026-01-30', 12, 1, '2026-01-28 12:36:34', '2026-02-27 02:16:09', 0, 0, 1, 0),
(13, 0, '2026-05-04', 13, 1, '2026-05-01 16:08:36', '2026-05-01 16:08:36', 0, 0, 0, 0),
(14, 0, '2026-05-07', 15, 1, '2026-05-05 10:33:05', '2026-05-05 10:33:05', 0, 0, 0, 0),
(15, 0, '2026-05-20', 13, 1, '2026-05-12 12:15:05', '2026-05-12 12:15:05', 0, 0, 0, 0),
(16, 0, '2026-05-15', 16, 2, '2026-05-14 16:56:09', '2026-05-14 16:56:09', 0, 0, 0, 0),
(17, 0, '2026-05-30', 16, 21, '2026-05-14 16:56:48', '2026-05-14 16:56:48', 0, 0, 0, 0);

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

--
-- Structure de la table `sous_categories`
--

CREATE TABLE `sous_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `nom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `categorie_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;

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

INSERT INTO `sous_categories` (`id`, `nom`, `image`, `categorie_id`, `created_at`, `updated_at`) VALUES
(1, 'Maconneries', '1716227574.jpg', 1, '2024-05-20 17:52:54', '2024-05-20 17:56:24'),
(2, 'Plomberie', '1716491464.jpg', 1, '2024-05-23 19:11:04', '2024-05-23 19:11:04'),
(14, 'Peintre', '1735817890.jpeg', 1, '2025-01-02 10:38:10', '2025-01-02 10:38:10'),
(15, 'Installation Electrique', '1735818015.jpeg', 1, '2025-01-02 10:40:15', '2025-01-02 10:40:15'),
(16, 'Architecture et Plan', '1735818309.jpeg', 1, '2025-01-02 10:45:09', '2025-01-02 10:45:09'),
(17, 'Carrelage et Marbre', '1735818396.jpeg', 1, '2025-01-02 10:46:36', '2025-01-02 10:46:36'),
(18, 'Charpenterie', '1735819136.jpeg', 1, '2025-01-02 10:58:56', '2025-01-02 10:58:56'),
(20, 'Ambulancier', '1735819786.jpeg', 9, '2025-01-02 11:09:46', '2025-01-02 11:09:46'),
(21, 'Infirmiére / Infirmier', '1735819868.jpeg', 9, '2025-01-02 11:11:08', '2025-01-02 11:11:08'),
(22, 'Maitre Tailleur', '1735821474.jpeg', 7, '2025-01-02 11:37:54', '2025-01-02 11:37:54'),
(23, 'Styliste', '1735822828.jpeg', 7, '2025-01-02 12:00:28', '2025-01-02 12:00:28');

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT 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,
  `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,
  `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 `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Ibra Ndiaye', 'ibra789ndiaye@gmail.com', NULL, '$2y$12$oLwq6Tlk10f3jLKeeiaJR.DdeK8F3FxNr.AG6RXw03mbqz50FaiJm', NULL, '2024-05-20 16:00:48', '2024-05-20 16:00:48'),
(2, 'Aissatou', 'consultingsabbusiness@gmail.com', NULL, '$2y$12$4tskbqvKeGuUXIau4J2Of.Vac0SHBIu5Dc7bouEUsuojtXQLe7ZPe', NULL, '2026-03-26 13:44:27', '2026-03-26 13:44:27');

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

--
-- Index pour la table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`id`);

--
-- 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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `notations`
--
ALTER TABLE `notations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notations_reservation_id_foreign` (`reservation_id`);

--
-- Index pour la table `ouvriers`
--
ALTER TABLE `ouvriers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ouvriers_sous_categorie_id_foreign` (`sous_categorie_id`);

--
-- Index pour la table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- 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 `reservations`
--
ALTER TABLE `reservations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reservations_client_id_foreign` (`client_id`),
  ADD KEY `reservations_ouvrier_id_foreign` (`ouvrier_id`);

--
-- Index pour la table `sous_categories`
--
ALTER TABLE `sous_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sous_categories_categorie_id_foreign` (`categorie_id`);

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- 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=11;

--
-- AUTO_INCREMENT pour la table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

--
-- AUTO_INCREMENT pour la table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT pour la table `notations`
--
ALTER TABLE `notations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `ouvriers`
--
ALTER TABLE `ouvriers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

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

--
-- AUTO_INCREMENT pour la table `reservations`
--
ALTER TABLE `reservations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT pour la table `sous_categories`
--
ALTER TABLE `sous_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- 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 `notations`
--
ALTER TABLE `notations`
  ADD CONSTRAINT `notations_reservation_id_foreign` FOREIGN KEY (`reservation_id`) REFERENCES `reservations` (`id`);

--
-- Contraintes pour la table `ouvriers`
--
ALTER TABLE `ouvriers`
  ADD CONSTRAINT `ouvriers_sous_categorie_id_foreign` FOREIGN KEY (`sous_categorie_id`) REFERENCES `sous_categories` (`id`);

--
-- Contraintes pour la table `reservations`
--
ALTER TABLE `reservations`
  ADD CONSTRAINT `reservations_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  ADD CONSTRAINT `reservations_ouvrier_id_foreign` FOREIGN KEY (`ouvrier_id`) REFERENCES `ouvriers` (`id`);

--
-- Contraintes pour la table `sous_categories`
--
ALTER TABLE `sous_categories`
  ADD CONSTRAINT `sous_categories_categorie_id_foreign` FOREIGN KEY (`categorie_id`) REFERENCES `categories` (`id`);
COMMIT;

