-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `laravel`
--

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `device_tokens`
--

CREATE TABLE `device_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `device_tokens`
--

INSERT INTO `device_tokens` (`id`, `user_id`, `token`, `created_at`, `updated_at`) VALUES
(12, 5, 'ctUvcSk-Tr6Eh2H5PdnmkU:APA91bH-_m4nLEZs0KvHOY7GGVxxfISLDXCLAfNH1N7xkiL4s464_hkmUoqsghBqPyul5jZVP89j2_wic6EVKK5ssWOKXCvig4wro307kOdXC-KfwAL6rCU', '2025-05-12 10:35:26', '2025-05-12 10:35:26');

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

--
-- Table structure for table `emploi_du_temps`
--

CREATE TABLE `emploi_du_temps` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `titre` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `matiere` varchar(255) NOT NULL,
  `groupe_id` bigint(20) UNSIGNED NOT NULL,
  `salle_id` bigint(20) UNSIGNED DEFAULT NULL,
  `debut` datetime NOT NULL,
  `fin` datetime NOT NULL,
  `jour_semaine` enum('lundi','mardi','mercredi','jeudi','vendredi','samedi','dimanche') NOT NULL,
  `est_recurrent` tinyint(1) NOT NULL DEFAULT 1,
  `est_annule` tinyint(1) NOT NULL DEFAULT 0,
  `couleur` varchar(7) NOT NULL DEFAULT '#3788d8',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emploi_du_temps`
--

INSERT INTO `emploi_du_temps` (`id`, `titre`, `description`, `matiere`, `groupe_id`, `salle_id`, `debut`, `fin`, `jour_semaine`, `est_recurrent`, `est_annule`, `couleur`, `created_at`, `updated_at`) VALUES
(8, 'prog web', 'Cours magistral d\'analyse mathématique', 'prog', 1, 105, '2025-05-02 10:00:00', '2025-05-02 12:00:00', 'lundi', 1, 0, '#FF5733', '2025-05-02 15:47:29', '2025-05-05 13:31:00'),
(9, 'TP Communication', 'Travaux pratiques en expression orale', 'Expression orale', 1, 102, '2025-05-02 08:00:00', '2025-05-02 10:00:00', 'mardi', 1, 0, '#33C1FF', '2025-05-02 15:47:29', '2025-05-02 15:47:29'),
(10, 'Lab Prog I', 'Séance de laboratoire sur l\'électricité', 'Physique I', 1, 101, '2025-05-02 08:00:00', '2025-05-02 10:00:00', 'jeudi', 1, 0, '#3788d8', '2025-05-02 15:47:29', '2025-05-06 08:28:25'),
(11, 'Mathématiques II', 'Cours fondamental de maths pour ingénieurs', 'Math II', 3, 104, '2025-05-02 09:00:00', '2025-05-02 12:00:00', 'mardi', 1, 0, '#FFC300', '2025-05-02 15:47:29', '2025-05-02 15:47:29'),
(12, 'Calculus II', 'Exercices en salle', 'Calculus II', 1, 105, '2025-05-02 09:00:00', '2025-05-02 13:00:00', 'mercredi', 1, 0, '#DAF7A6', '2025-05-02 15:47:29', '2025-05-02 15:47:29'),
(13, 'Algo & Structures', 'Cours sur les algorithmes et structures de données', 'Structures de données', 1, 106, '2025-05-02 08:00:00', '2025-05-02 10:00:00', 'vendredi', 1, 0, '#C70039', '2025-05-02 15:47:29', '2025-05-02 15:47:29'),
(14, 'Développement Web', 'Introduction au web moderne', 'Web', 6, 107, '2025-05-02 15:00:00', '2025-05-02 18:00:00', 'jeudi', 1, 0, '#900C3F', '2025-05-02 15:47:29', '2025-05-02 15:47:29'),
(15, 'base de donees', 'tp2', 'base de donnees', 1, 107, '2025-05-02 12:00:00', '2025-05-02 14:00:00', 'vendredi', 1, 0, '#F44336', '2025-05-02 13:09:56', '2025-05-02 13:17:08'),
(17, 'tp', 'web', 'programmation web', 1, 105, '2025-05-02 12:15:00', '2025-05-02 14:15:00', 'jeudi', 1, 0, '#3788d8', '2025-05-02 14:23:30', '2025-05-02 14:23:30'),
(19, 'management', NULL, 'management', 1, 106, '2025-05-06 14:57:50', '2025-05-06 16:57:50', 'mercredi', 1, 0, '#3788d8', '2025-05-06 08:58:31', '2025-05-06 08:58:31');

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

--
-- Table structure for table `faculte`
--

CREATE TABLE `faculte` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `nombre_de_sallee` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faculte`
--

INSERT INTO `faculte` (`id`, `name`, `nombre_de_sallee`, `created_at`, `updated_at`) VALUES
(1, 'Faculté d\'Ingénierie en Langues Étrangères', NULL, '2025-04-26 21:00:00', '2025-04-26 21:00:00');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `groupes`
--

CREATE TABLE `groupes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `major_id` bigint(20) UNSIGNED NOT NULL,
  `noms` varchar(255) NOT NULL,
  `nombre` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `groupes`
--

INSERT INTO `groupes` (`id`, `major_id`, `noms`, `nombre`, `created_at`, `updated_at`) VALUES
(1, 1, '1230Fa', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00'),
(2, 2, '1231Fr', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00'),
(3, 3, '1232De', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00'),
(4, 4, '1233En', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00'),
(5, 5, '1234En', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00'),
(6, 6, '1235En', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `majors`
--

CREATE TABLE `majors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `nomber` varchar(255) NOT NULL,
  `faculty_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `majors`
--

INSERT INTO `majors` (`id`, `name`, `nomber`, `faculty_id`, `created_at`, `updated_at`) VALUES
(1, 'Informatique en anglais', '1', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00'),
(2, 'Informatique en français', '2', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00'),
(3, 'Informatique en allemand', '3', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00'),
(4, 'Génie électrique en anglais', '4', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00'),
(5, 'Génie mécanique en anglais', '5', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00'),
(6, 'Robotique en anglais', '6', 1, '2025-04-26 21:00:00', '2025-04-26 21:00:00');

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

--
-- Table structure for table `major_salle`
--

CREATE TABLE `major_salle` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `major_id` bigint(20) UNSIGNED NOT NULL,
  `salle_id` bigint(20) 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 `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` varchar(255) NOT NULL,
  `receiver_id` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `is_read` 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 `migrations`
--

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

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_04_23_125208_create_faculte_table', 1),
(5, '2025_04_23_125536_create_salle_table', 1),
(6, '2025_04_23_125926_create_majors_table', 1),
(7, '2025_04_23_130101_create_major_salle_table', 1),
(8, '2025_04_23_130237_create_groupes_table', 1),
(9, '2025_04_23_130402_create_roles_table', 1),
(10, '2025_04_23_130533_add_role_id_to_users_table', 1),
(11, '2025_04_23_140147_create_oauth_auth_codes_table', 1),
(12, '2025_04_23_140148_create_oauth_access_tokens_table', 1),
(13, '2025_04_23_140149_create_oauth_refresh_tokens_table', 1),
(14, '2025_04_23_140150_create_oauth_clients_table', 1),
(15, '2025_04_23_140151_create_oauth_personal_access_clients_table', 1),
(16, '2025_04_27_182438_add_major_id_to_groupes_table', 1),
(17, '2025_04_27_182817_add_groupe_id_to_users_table', 1),
(18, '2025_04_29_000000_create_emploi_du_temps_table', 1),
(19, '2025_05_02_152204_remove_professeur_id_from_emploi_du_temps', 2),
(20, '2025_04_30_000000_remove_professeur_id_from_emploi_du_temps', 3),
(21, '2025_05_01_000000_create_professeur_cours_table', 4),
(22, '2025_05_02_000000_create_notifications_table', 5),
(23, '2025_05_02_165536_add_major_id_to_notifications_table', 6),
(24, '2025_05_02_000000_create_occupations_bureaux_table', 7),
(25, '2025_05_04_100920_add_profile_fields_to_users_table', 8),
(26, '2025_05_04_105941_create_notification_documents_table', 9),
(27, '2025_05_04_110316_remove_notification_documents_table', 10),
(28, '2025_05_04_110931_add_coordinates_to_salle_table', 11),
(29, '2025_05_04_130152_add_openstreetmap_url_to_salle_table', 12),
(30, '2023_05_06_000000_add_preferred_language_to_users_table', 13),
(31, '2024_03_21_create_messages_table', 14),
(32, '2025_05_10_114200_create_device_tokens_table', 15);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `titre` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `groupe_id` bigint(20) UNSIGNED DEFAULT NULL,
  `major_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('info','important','urgent') NOT NULL DEFAULT 'info',
  `est_lue` tinyint(1) NOT NULL DEFAULT 0,
  `date_expiration` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `titre`, `message`, `groupe_id`, `major_id`, `user_id`, `type`, `est_lue`, `date_expiration`, `created_at`, `updated_at`) VALUES
(1, 'Test Notification', 'Ceci est un test de notification.', NULL, NULL, 2, 'info', 0, '2025-12-31 00:00:00', '2025-05-12 10:15:05', '2025-05-12 10:15:05'),
(8, 'examen bd', 'le 22 juin a 10h dans la salle cb 105', 1, NULL, 3, 'info', 0, NULL, '2025-05-12 11:27:33', '2025-05-12 11:27:33');

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

--
-- Table structure for table `notification_documents`
--

CREATE TABLE `notification_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `notification_id` bigint(20) UNSIGNED NOT NULL,
  `nom_fichier` varchar(255) NOT NULL,
  `type_fichier` varchar(255) NOT NULL,
  `chemin_fichier` varchar(255) NOT NULL,
  `taille` int(11) NOT NULL COMMENT 'Taille en Ko',
  `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 `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('01b7ad8247305fd77e8b890391d21ae780fbbc4cd996f60c17f508a0d9e00a385add13bd419490f6', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-03 07:23:38', '2025-05-03 07:23:38', '2026-05-03 10:23:38'),
('02259334912ffc6928b0ebdc9a5e27c1c8c37a994336dd52fe4443beffdb6a1cb5d00c82b57d4ae7', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-03 07:43:20', '2025-05-03 07:43:20', '2026-05-03 10:43:20'),
('04a1fed4b1217e81280247a0e59fedec660df0d74dd651aee2cb3d11f2d52dd40271a9d6b4eed5ba', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-05 12:59:19', '2025-05-05 12:59:19', '2026-05-05 15:59:19'),
('05229ba6bcffd085e939c5b8bf12eb6f59d5f4187fd84f8a9c079dca5c4cab8a19760f3bd8b7916b', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 07:26:12', '2025-05-04 07:26:12', '2026-05-04 10:26:12'),
('0530fce1db3277cd65ebe0d784a7153106751903dfc9b9987a6f780e663ce1be582e75590a716e2a', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-09 06:06:58', '2025-05-09 06:06:58', '2026-05-09 09:06:58'),
('057661fdab4bee0ca912506442a7947a901e22922d9f67ea258e1da6ca32f1851adcfdbaae699ecf', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 06:26:35', '2025-05-11 06:26:35', '2026-05-11 09:26:35'),
('05d547131fb4dc0c9ece9ad5c5dc5948dcee9f67785f147a9c51a78c85c210614523bce7d6fde04c', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:04:14', '2025-05-12 07:04:14', '2026-05-12 10:04:14'),
('088f0da45276707f04565d7c94d832e557726d45928de28ff8787b38bdd51346c244b406d4f66eda', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 10:47:11', '2025-05-06 10:47:11', '2026-05-06 13:47:11'),
('08f4a3f0f8d8a7919f00853d74c56b1a8d095a0eec937ffabdad3b275b0918bfb11a45e369e43e1a', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 12:26:49', '2025-05-02 12:26:49', '2026-05-02 15:26:49'),
('0b4e81fdf2677c24e9bdc1f3380135ee888caa18202fc310d14829b29e797ae0f0717716cc003d23', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 15:16:47', '2025-05-11 15:16:47', '2026-05-11 18:16:47'),
('0da27e5d3f0fa5ea27412d1cf16dea198568ad5be7cc975a928bd2b63e70377768efc4fc5d1a3366', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 08:05:49', '2025-05-04 08:05:49', '2026-05-04 11:05:49'),
('0fce53fd981e4d784e8c80fcd54262132686a33e869c48a79b8a485c6cfd5ba226e366292fafecb2', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 15:10:37', '2025-05-11 15:10:37', '2026-05-11 18:10:37'),
('131c4abca8acb07ac0cac2577c0e9c429c4ff134369b7b15357b855398af98b61d23dc2fb0d492a3', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 15:09:36', '2025-05-11 15:09:36', '2026-05-11 18:09:36'),
('1402a40a5f0415626bbc3e6455248920e543fc8207ff9b3b5448bbf3d56090f6f213c5f9d28840a2', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 15:20:22', '2025-05-11 15:20:22', '2026-05-11 18:20:22'),
('1409807ef2a40e1452fdd6335884a1cea1bcc1b5ec2a2ec266ca423224936a2a5a5619b3c9943821', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:41:18', '2025-05-12 07:41:18', '2026-05-12 10:41:18'),
('165c513ad93ceadd20d6834b070ae9b90c8743c6c44a98b94c182f95662bd88c4a93680090b99c57', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-05 13:12:59', '2025-05-05 13:12:59', '2026-05-05 16:12:59'),
('1671621268cbb3a6d36f62c078388fcd2a93df20869692ea6f1a75b21fb216b3723cbcab0a4353ce', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 15:27:47', '2025-05-04 15:27:47', '2026-05-04 18:27:47'),
('16de291e98a82f1a85edddda0429e352fc8f9dae03a57657596d68c4d8a5b8cffc658d5ee0699426', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-10 08:12:13', '2025-05-10 08:12:13', '2026-05-10 11:12:13'),
('19257961f368e92933286df527e9c990efb46018f414f9c857d61cc146558e0823400d71e34e2d4a', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 10:51:05', '2025-05-06 10:51:05', '2026-05-06 13:51:05'),
('19789df981d96cad6b5ae389a32a59f10054656accedefc2ed31afa701f3a27e195c9cdf954e055b', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-09 06:34:35', '2025-05-09 06:34:35', '2026-05-09 09:34:35'),
('19fd08f6cb6b684acaf6b9dc618f12f1bf461b5e19d53e9042ffcad0ea3469f04dd8a7b85ed151cc', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 11:17:05', '2025-05-06 11:17:05', '2026-05-06 14:17:05'),
('1b815b263a603f2bc1be949933d304a50bdb8b04be42824dd338edba3504d2ec7421073f04a19ed6', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 09:12:42', '2025-05-04 09:12:42', '2026-05-04 12:12:42'),
('1d7e5fbd5a2e84a28d0b9a991a93c3906dea852cc604392e2ef3b957460dda56e1f3b75f4790bf05', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 11:32:27', '2025-05-12 11:32:27', '2026-05-12 14:32:27'),
('1e7c640278ba9fade117a9c4b1b30ece80f41ad5263fdb3d3dda16506255fb55b33308567ec96b77', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 11:31:58', '2025-05-12 11:31:58', '2026-05-12 14:31:58'),
('2173cd258dc980ec36e1bec1255685465d32a941dd7d8159576717d253ab6d40a5cf89184603068d', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 12:32:52', '2025-05-02 12:32:52', '2026-05-02 15:32:52'),
('2261ccd7b198031539c665641518f516c18ebf282f64336abce0213eb01336f90589eec23f65d2c8', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 11:15:29', '2025-05-06 11:15:29', '2026-05-06 14:15:29'),
('234be5f3b5f4bbd4a7b52f68defe6b7061c97e42839e1bdbe13e2157deb0ff381f179b7037ed583e', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-07 04:49:40', '2025-05-07 04:49:40', '2026-05-07 07:49:40'),
('271842f813ea7f0026cc9491231389e627cb00365cf24bead11b08574f084d048c4d6a5f24c01daa', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 15:27:27', '2025-05-11 15:27:27', '2026-05-11 18:27:27'),
('287d66b264cb9cb3d8caf434c1d1c65860a77e4adc527da8a27072d62341e520fd63f52b2be8de56', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 05:42:25', '2025-05-11 05:42:25', '2026-05-11 08:42:25'),
('2e12d1615177358174dbc086ab14d193f1b0fd71ae73e941452daee8f7c34ffbdbdfd23c7c3c7254', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 16:42:30', '2025-05-11 16:42:30', '2026-05-11 19:42:30'),
('2f65fc79a0a4051d7530deb9eac6bf42829649798ba586ce1d950a4bd9ecd39366d5aaf490d0dcbf', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 05:44:03', '2025-05-11 05:44:03', '2026-05-11 08:44:03'),
('30d9f38ea72e01c4bd9efb2b059454a88257b5100bd6bb7397a4a86b11da3232fbf7a9e71dc60d9b', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 15:11:13', '2025-05-11 15:11:13', '2026-05-11 18:11:13'),
('3163d4cec3008b3e521588f20e2c96b5a04e049e3ca0e1945fe48453099b4f6cd66d4deee8144dfc', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-09 06:26:42', '2025-05-09 06:26:42', '2026-05-09 09:26:42'),
('3315cc380e0d6c194ed68ad7f2eb0cfdc69b39ac37eb58de024d23fe084e538e1f0e3253a4204693', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 06:23:44', '2025-05-12 06:23:44', '2026-05-12 09:23:44'),
('333f2a311605fbc852487255f88bc5cbd167b233a36898039ca397d0669bb2dbb3a197fc4bd698a1', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 12:36:49', '2025-05-06 12:36:49', '2026-05-06 15:36:49'),
('345586c7c8393bbe88028ec8aa7c0f63fbc2568ad42a4a94a4d27b2521b1478761885528b57bf240', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 14:12:49', '2025-05-11 14:12:50', '2026-05-11 17:12:49'),
('354930d49ad4e0c2fa3008e47855c94116fdf831019d56b78e2c391c08b8a0c71caa76c1e43e7ef8', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 12:20:48', '2025-05-02 12:20:48', '2026-05-02 15:20:48'),
('372e4619f83d1146aec22ec72236a0210e6a287958aaa23296a0638f5b49bdb1a1ada7ef76031222', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-09 06:52:54', '2025-05-09 06:52:54', '2026-05-09 09:52:54'),
('372f4497514886e74e9e7742a58a59a41453dfe9ed851a8fa00c946ae0a9821dbe114e2ff858641d', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-05 13:18:09', '2025-05-05 13:18:09', '2026-05-05 16:18:09'),
('379c4eabeb4799dec44cb162c9466b6baac9b4de354472d795da0a6b602878b85d6320a6e3f0d08e', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 12:52:17', '2025-05-02 12:52:17', '2026-05-02 15:52:17'),
('3a01ce02baa09f2769a48e8fd56dac445a252199d79438098321b2306b2f2d58f629a0c0dd7bfeda', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 08:04:53', '2025-05-06 08:04:53', '2026-05-06 11:04:53'),
('3a158de5725decbd31c1ae03605e8635b38ba6683445b2e98892fdd0ecdae014dc5da55aa0fb882d', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 05:06:56', '2025-05-11 05:06:57', '2026-05-11 08:06:56'),
('3caef0f795a6938ef70f3cd3bcc4eacce0c24e805e55e68c74154409291bef006d1b292fc0f489b6', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 05:33:38', '2025-05-11 05:33:38', '2026-05-11 08:33:38'),
('3cdc457adc70cf165d0f080de9ef8164af4bccb55faf1184eeb0c5742f82ebcd219843b6a52cf537', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 06:55:20', '2025-05-12 06:55:20', '2026-05-12 09:55:20'),
('3e36b5c8ac8e374b1b633c8f4e7c8e9231e03eab38b884d7c13b61f023b50821b8140d78fd9e8c84', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-05 13:17:49', '2025-05-05 13:17:49', '2026-05-05 16:17:49'),
('41022cd90e226401283009e0697546cd927367807e4f0570877ce86b7ab0170a3705c951154a2b53', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 15:36:35', '2025-05-04 15:36:35', '2026-05-04 18:36:35'),
('42d1dedbf85db384e38be179f5998efb304ff663b0add36be1f1c7ed6bf38f84900919ad65054c91', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:33:33', '2025-05-12 07:33:33', '2026-05-12 10:33:33'),
('44df805ab2aa174d980fc4c6587b13a2e31cc4a423a736cf9c86975789d36fed97ab8133fbbba8d3', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 10:26:47', '2025-05-06 10:26:47', '2026-05-06 13:26:47'),
('455c8234c22633af3199a196b632e950511c32b36b8c678105eefd0f0f6f4e1fc31181de44569098', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 15:16:18', '2025-05-11 15:16:18', '2026-05-11 18:16:18'),
('4b80b7b434575c5fe143dcf6d10f5ad1d58c9e764d584ab8fb315fff000aa8c3726da4314ebb4644', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 11:03:59', '2025-05-04 11:03:59', '2026-05-04 14:03:59'),
('4b8c9e2188eb9419e0d9b874e3387518824a9cf113f04c04f397c1293cb5fbf2d88b655237c7f773', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 10:21:58', '2025-05-04 10:21:58', '2026-05-04 13:21:58'),
('4c954ede4f7c3c70e29b8adba6c5921c769650bfeb071de8f758ae20f623e3975e2eebdda1a1598d', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:07:32', '2025-05-12 07:07:32', '2026-05-12 10:07:32'),
('4da0191d793e3ed72dbe559acb8936d5d4399ab2405eab304eb3f2058a93c0708e1b72ec86dbb7af', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 13:42:01', '2025-05-02 13:42:01', '2026-05-02 16:42:01'),
('4f1b08ebf19900947d78da167d76faf3cc1f67f29a4bce7b6ecf9a3db2fbb07e68ad547c668d5d92', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 14:30:44', '2025-05-11 14:30:44', '2026-05-11 17:30:44'),
('4f487cb19d84b5f8b892a578a088ed0b4130d6fc445d96939520bc3f35363583c13787d8365a889a', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 16:41:55', '2025-05-11 16:41:55', '2026-05-11 19:41:55'),
('4fbe3285a202475d04326bc99595f6739459bc65cc613da895aa4d0b46b6e8d738e69bd72493ce60', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 11:54:56', '2025-05-06 11:54:56', '2026-05-06 14:54:56'),
('4fe108eea5a6984b5ce59153c59b4e123cb8564ce59d66156ab299734608fb1cb3eac42eb67c24eb', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 14:32:32', '2025-05-11 14:32:32', '2026-05-11 17:32:32'),
('521ad236e8df8f1ce85db501c431cb9bc46680b8d57634a723418a80fca74718ebd3ab32b7a783cc', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 09:18:11', '2025-05-04 09:18:11', '2026-05-04 12:18:11'),
('5ba9c1b76c29002ad4b6f78691cd138028344ec8553e3061a497000bf488e326be58a532fefabec3', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 10:25:46', '2025-05-06 10:25:46', '2026-05-06 13:25:46'),
('5d0b86ffab4dfa643b9394c679e89656062f543239ba52e9c1948d862f07642a1d8525bb2eba7adf', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 12:17:01', '2025-05-02 12:17:01', '2026-05-02 15:17:01'),
('5dd30712fdd7e22ef20fc64d6e5008fcb3c89aa74d779836d818899896a301f7d5451256b24cac34', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 14:19:33', '2025-05-11 14:19:33', '2026-05-11 17:19:33'),
('5fbaff0e4ee1605fffd85a898561724a19d10f317b661098b2827d0f795029c762c1449290a223d3', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:16:10', '2025-05-12 07:16:10', '2026-05-12 10:16:10'),
('6032590b140a778cb8baaef4d242585f91279ba6361ec27c6c3e4f4ef40d9f016e283457882f2ce2', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:26:29', '2025-05-12 07:26:29', '2026-05-12 10:26:29'),
('61df2280f01915879c0a67a148cea283fcc273f27c8bc8a8c06ef37b460530234057399c6057d723', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 07:51:20', '2025-05-04 07:51:20', '2026-05-04 10:51:20'),
('639708d3552e6d74d2ce06561af6ef00621485fcb22cd1d4b1222806eb2d27e9c3b5a0fa53bd2ef2', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 10:26:12', '2025-05-06 10:26:12', '2026-05-06 13:26:12'),
('6450d24d60f5b02aaa808d2e7edf805849793fbc69469cacbd76369530f4a88cb71ad3bfb3e328ed', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 15:32:45', '2025-05-04 15:32:45', '2026-05-04 18:32:45'),
('64b7a1c6a1a7a12582640cec0cc0b42b0a2c32386ad53a0f0012eb4b48aa250dc8795f44d63da964', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 09:11:46', '2025-05-04 09:11:46', '2026-05-04 12:11:46'),
('64ccd900b8b1f3dd88aba4dfa85f3ff965ff5fb7ac316be893638eca5613c3c1d75d175d5e118518', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-10 12:33:04', '2025-05-10 12:33:04', '2026-05-10 15:33:04'),
('664b1c32a06bab3b3c21e1f08b1c04a31a7a2b274911dc1ce9c8c087120d184021d33761c6e12014', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 14:10:50', '2025-05-04 14:10:50', '2026-05-04 17:10:50'),
('6794518ca882f127077ce4e5728762fad25b314b8adaae4fec660290c060a4f70c4b1ef2dc65ec37', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:12:05', '2025-05-12 07:12:05', '2026-05-12 10:12:05'),
('6a8be0ecd3494a54d28828d955ccd03ff99cc82b56bc2dfb5d369e5bbc157fbff52b8e89db23a4fb', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 10:48:09', '2025-05-06 10:48:09', '2026-05-06 13:48:09'),
('6ce78f2ffe22d15cf734dc59dfe6916901e0a88af167652dcf281abe2c56d97979405bbaede6a508', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 14:24:37', '2025-05-02 14:24:37', '2026-05-02 17:24:37'),
('6d5c56c17fa69eb2ad634cba942e405314ff254b5ab942094f56b1bfad59cc85c76c5a8d4c6496de', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 11:18:39', '2025-05-06 11:18:39', '2026-05-06 14:18:39'),
('6f65fb57bcc95e91bd6c788a5102a185b62359ad873ef775c3ea507aaa3273eccb3d065b5c1bca34', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 09:18:28', '2025-05-04 09:18:28', '2026-05-04 12:18:28'),
('6fb4f22586e6a4653f20eeca944530e1d2eb74d4e75a4768f1517f7391ea3ca74598ae5b65c36606', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 14:33:43', '2025-05-02 14:33:43', '2026-05-02 17:33:43'),
('70da78f9eeb576dce2376809db3f0c79a3de471af1c841c20b247adaf23e9cfdfc87a901cd9e75c6', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 10:10:51', '2025-05-04 10:10:51', '2026-05-04 13:10:51'),
('70f3b42c6989f64232b7b7ba8de680f9e9e8169edda061973874e2543094b6cc74488432153eecc4', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 13:48:04', '2025-05-11 13:48:04', '2026-05-11 16:48:04'),
('70ff46dfeb779cdb94fde0df4b745611fde25afb4ffd22cf727fef32878507f99a7d0f4c3679e52d', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 12:53:39', '2025-05-02 12:53:39', '2026-05-02 15:53:39'),
('72709afa5b38098f83c6918bf3ba20c30951101477c5176cebefff4e65ef2f3b66d46b0c9c72ede5', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 12:15:25', '2025-05-02 12:15:25', '2026-05-02 15:15:25'),
('73f3cf02823e7ff80f6b774f44979444650f2d41f32834b48149d92a9844b6ee9b989c5c633c51cc', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 11:52:58', '2025-05-06 11:52:58', '2026-05-06 14:52:58'),
('749185af5bea7adaa8a25d9c97d7b7de754effa5f2f2b36671435542af3a64db73aa3fc161e20a9c', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 12:27:32', '2025-05-06 12:27:32', '2026-05-06 15:27:32'),
('768ac3f20c3a6f39d4f46a4ec4100109c28030e1c784a74cc32b9a97101e64a3f8cc2d2811635a6e', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-05 13:05:17', '2025-05-05 13:05:17', '2026-05-05 16:05:17'),
('76dc949f07cefcd477922258af325484fa7c4538f63d39ffc86a57c566daad3819591f82bf09b7ff', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 15:36:10', '2025-05-04 15:36:10', '2026-05-04 18:36:10'),
('7d2aaf5413ec2d80ecd16521c2bb2365282b374b78f3178589afb3044f4af3d6af861fab459f1c97', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 14:11:29', '2025-05-04 14:11:29', '2026-05-04 17:11:29'),
('7ef32c576a9eebf63ed8d3914ce2d468cd83192eba7dfd827ae47768cccb730fbd369e8cdbcca7a0', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-05 13:09:01', '2025-05-05 13:09:01', '2026-05-05 16:09:01'),
('8931a91a003c3f6313d550dcd062aa74902ad72fa7564ab02d78cd1e7e57fb85ddc45f68cb31d413', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 15:28:46', '2025-05-04 15:28:46', '2026-05-04 18:28:46'),
('8932f55b9a3bf4d89c2de3610279c5d39dc214d264832e1cceabf6b9f7d4a45d3bb36ea7d304b637', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 15:30:00', '2025-05-04 15:30:00', '2026-05-04 18:30:00'),
('8963ed1ae9c5714731174657ccbca2061991621183d13178b36a2f99a64b4d42faba859492768020', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 11:38:15', '2025-05-12 11:38:15', '2026-05-12 14:38:15'),
('89aa9e45d4733d0d2fd13e3832d396e7e2880aeaa0478292a7497b6be6ef860f6c31a240fdca04dc', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 09:56:53', '2025-05-12 09:56:53', '2026-05-12 12:56:53'),
('89cd4bce4b6a43f6cefc1adfaa28221f9af5f1697a7148657b3c35b1ab64c93d2ae5b21d37089fa6', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 05:41:06', '2025-05-11 05:41:06', '2026-05-11 08:41:06'),
('8cd8f7cef224680512451d26345beb416316faa19a09b46264880f4a93affd06fe9145d8e1681ef4', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 14:45:43', '2025-05-11 14:45:43', '2026-05-11 17:45:43'),
('8e8d58b836334f99c7f86f36ce63c08d84431b86197af54342f052db982481a20d1af9dbd3e24d91', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 16:09:01', '2025-05-11 16:09:01', '2026-05-11 19:09:01'),
('90b8cd021da79b31c1838506e795f9d4821190ee8daa618848edace935617072086a960805e43947', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-10 12:05:39', '2025-05-10 12:05:39', '2026-05-10 15:05:39'),
('9108e5f72fa700f22040a9535e9c99db235474433a388ef4bd6abda071184fa128d154d4541578b3', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 10:35:25', '2025-05-12 10:35:25', '2026-05-12 13:35:25'),
('918638833afe13bcf4b33303ed100de71884628fe4b28456a506c2d1aedc8ec03ef0bd2723a4f0ba', 6, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 10:56:42', '2025-05-06 10:56:42', '2026-05-06 13:56:42'),
('919573b9c3c03017814514df835bf7de859c54612381fc948fe5df677eccf4b0992012590d41ad40', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 10:11:35', '2025-05-06 10:11:35', '2026-05-06 13:11:35'),
('926dad3399e3f3a913c59d5f1174077bb4ac4d1530bb5d76d46fb6392ca8b32a344abdd6a85b6dca', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 06:33:43', '2025-05-12 06:33:43', '2026-05-12 09:33:43'),
('933ad84032ed2ce1ad89dc9748f581af60d8aa65c97b925a60c0081b2281d9ba64fbaa8258b31c07', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-08 09:14:52', '2025-05-08 09:14:53', '2026-05-08 12:14:52'),
('94896887de05add63df714ca37183d75811ff4379038137b6673cde53bce35ce4d3687c99596f983', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 09:25:49', '2025-05-04 09:25:49', '2026-05-04 12:25:49'),
('95100653d6d1d3c1b880aa8bd450ed34048c19fdcb25795087e4c8602cc9471e4d1230a2e1c585d4', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-09 06:05:20', '2025-05-09 06:05:20', '2026-05-09 09:05:20'),
('95a8dc96fe2fa1b155a52aa7e828a165b9596acafbb7aa8d0319695d6e7a393e30c20bba5e531eb1', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 06:17:05', '2025-05-12 06:17:05', '2026-05-12 09:17:05'),
('95b39c472cb5be0c864d9c5f2a0801d39143cbd01afde5a9e5ee2675ce750e96afef8888f08a788c', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 05:41:30', '2025-05-11 05:41:30', '2026-05-11 08:41:30'),
('9700d56da0af8ffb1c9a12f1b71fde8d32025e1cd3c2d9c6d21c22d0688f6b1c2246a2ffc5dafc11', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 12:37:10', '2025-05-06 12:37:10', '2026-05-06 15:37:10'),
('99ae0532acf9e3f5858d4dfeb8dba64fa6efb158a1bcc721ae90f97d20787bd5ed026607eb36be43', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 09:26:56', '2025-05-04 09:26:56', '2026-05-04 12:26:56'),
('9e9f4f73fe7c7969b9d287ad870bb8bc29428693915d363d233950502cf1c662745404cebc75b59c', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 13:27:07', '2025-05-02 13:27:07', '2026-05-02 16:27:07'),
('9f7e62219e4121b470821d797a4ff60954588a96836e22daa5cd01069812becd91a461316b98cf09', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-10 08:47:25', '2025-05-10 08:47:25', '2026-05-10 11:47:25'),
('9f9c6a22587214c99eda7e4514553ace55a44ed91f871a9eec7285b154c7c23e6f907e650f1332ed', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 14:01:18', '2025-05-02 14:01:18', '2026-05-02 17:01:18'),
('a215231fc32cf3d63b46a427fd2eb1828288d357e42b59865cb08fdc80a65d3dd08a41666d058248', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-03 06:56:02', '2025-05-03 06:56:02', '2026-05-03 09:56:02'),
('a2e8c5692cd09562d80af7a0a85a0b7d5e1c49d78026f6a930888a1cde69d2e320e997e5cb879637', 7, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:24:24', '2025-05-12 07:24:24', '2026-05-12 10:24:24'),
('a3269efcbb0988304225dfd0abf64f8991fbd293d063db799a5c389a93cd6b82a3e486e2e0bd5def', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-08 07:01:33', '2025-05-08 07:01:33', '2026-05-08 10:01:33'),
('a7c887fb540478a7e3930522a97b8e651a8cdd5a8a8e782b3f78e67a1b46d9f45d7d32eaffcb0406', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 09:13:49', '2025-05-04 09:13:49', '2026-05-04 12:13:49'),
('a84907af84fcd31d8fdef251fe5f8ffffb03b178eef69ce0c7fc089f3cd1d7cae39d7a5d2d5c4b12', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 11:24:31', '2025-05-06 11:24:31', '2026-05-06 14:24:31'),
('aabc741b98b3a10cac87059f89a73fd33158f6b14968d1d7ea723b571d7ca8a9dccbfb24cacb175e', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-05 14:56:29', '2025-05-05 14:56:29', '2026-05-05 17:56:29'),
('ab65c1c6888af4cadec11f6fe848b47174c740d9aa636b9cda51e6bdf8cef3a62e88c193b2cddc5e', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 09:13:00', '2025-05-11 09:13:00', '2026-05-11 12:13:00'),
('abbe3ba04b49364e021ff861a84ef7aca8ea9c7014ae3c825c171422ac44d42e95a2c562e16a3537', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 11:29:48', '2025-05-12 11:29:48', '2026-05-12 14:29:48'),
('aede3279a1f65f8b8637ddd895d73d8af9331e28ac80583d97868257712024a39d7c4f01ac52bde3', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-10 08:04:52', '2025-05-10 08:04:52', '2026-05-10 11:04:52'),
('b0604ce8200fd962bc661d3eb35f9e6bbe2a8c72a1aa3024ad05a46fc4f6c95d4d035bb63432a5cf', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-03 07:23:40', '2025-05-03 07:23:40', '2026-05-03 10:23:40'),
('b0784ed1d5393b3451ce7f569b2b7c4bf2a2f5a5a62392c9e7d754a1f2b9e7103a6c83d2bd495ce7', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 09:24:54', '2025-05-04 09:24:54', '2026-05-04 12:24:54'),
('b13ca9f3456489889c0345c65f17c901dece8a49280268707a3442a470a20636eac0bfc67f57747e', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 07:54:32', '2025-05-04 07:54:32', '2026-05-04 10:54:32'),
('b24fe2078839e506ab470a82934896e3c971a7c34db06492a3d1dab29c6d1f316e779946f9d198e3', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 08:21:54', '2025-05-04 08:21:54', '2026-05-04 11:21:54'),
('b29567f740d3ef51aa06a0986a88033175a97f9c02862dea540d4c4d7ad9c7575b5a9c35d7b0ca49', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 14:43:53', '2025-05-04 14:43:53', '2026-05-04 17:43:53'),
('b4608fd1c3ddf7af3611579a9bc15a134501bf1dca96696b29143320cb301ececab319c647ca7318', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 12:16:18', '2025-05-02 12:16:18', '2026-05-02 15:16:18'),
('b769d1f9cc5def4d5b4e08eed72b1c166b03f43c588ab4503f1f62c1d4425bc11f751f204904ca72', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 07:29:40', '2025-05-04 07:29:40', '2026-05-04 10:29:40'),
('b8fbcfc89b9bc2822d85c8a672961b7ede28fa7b680ea54acadff67f467aafa7a0e0cafad2f663f3', 7, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 08:57:53', '2025-05-11 08:57:53', '2026-05-11 11:57:53'),
('b94b875312242bc7f4580d0f1dc7ffa282546377ce57b546a414f591c1760f7b83264bba8042c317', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 07:58:32', '2025-05-04 07:58:32', '2026-05-04 10:58:32'),
('ba082dcb23c521c729a296e5040275288bc9bfe94a9d6f5eadd42826c48eab5a5d3f5e028f06c926', 7, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 08:58:26', '2025-05-11 08:58:26', '2026-05-11 11:58:26'),
('ba36e5b8131162aa85c81249e81675490c45aea8fa0499f6dea52ddba372ffe5eb9e62a35109fe57', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 06:23:00', '2025-05-12 06:23:00', '2026-05-12 09:23:00'),
('bcbd821e51a405ecf0f033dd4826930531a19689474990e9ef9e51a7364f5a5037903cf59b0eb7bc', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 12:31:10', '2025-05-02 12:31:10', '2026-05-02 15:31:10'),
('bdfe1c99d6df937adaf962883c64e6546973386e3ea365c663cac673a9789eec5f5ff7ac5d7e6e6f', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 13:52:42', '2025-05-02 13:52:42', '2026-05-02 16:52:42'),
('c1b2994a809e2efef66feca9ef7ed412fcaa51eb433f5fa666d008df0e52b811b5db7ffdc91cbb75', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:04:57', '2025-05-12 07:04:57', '2026-05-12 10:04:57'),
('c44860779775de828d4ff5b4fec4b32f9df4c77cc00cd838be698cfc7bcb7c32ce0057f430684f23', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 16:08:38', '2025-05-11 16:08:38', '2026-05-11 19:08:38'),
('c4dbbf7a83be5162234acc21568b03f6159b1b08fe72b11f93466fda4e1037473f8b580eb914dbe4', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:37:22', '2025-05-12 07:37:22', '2026-05-12 10:37:22'),
('c54ecec672cefc59b8269fe7866ddf126f9179b0b8bbf5d1589bcdd717ecd71e85ad9ea019842261', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-10 08:01:16', '2025-05-10 08:01:16', '2026-05-10 11:01:16'),
('c858e5a6f4ce19c4c89cd37fe7f32a3f5356e44d68240111e2bae8890546003c32b3b8604bcc3b27', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-10 08:12:40', '2025-05-10 08:12:40', '2026-05-10 11:12:40'),
('c8f1fb88dfbfa4610cc919b3a38c74f0d3409d4a824d65f979d8217c49278e1ff27f431a13a88bef', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 15:38:06', '2025-05-04 15:38:06', '2026-05-04 18:38:06'),
('c9309976c3854bc0bc4ea0c865e05c33e68fd93a97c2815e42c4445aa9ba5ad7055a0e6c745930c0', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-10 12:30:29', '2025-05-10 12:30:29', '2026-05-10 15:30:29'),
('c9b0cb116367793d175e613d5decd149fbc8c793bbc25991946bd7663e1db69d0344ffa8befff290', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-05 14:55:45', '2025-05-05 14:55:45', '2026-05-05 17:55:45'),
('caab76e80e9f828f3625097811aa6a654ac023bd39557910ab47d3f4d27409e6d0387d1f72f72565', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 07:09:26', '2025-05-12 07:09:26', '2026-05-12 10:09:26'),
('d29ea46e3e3eb9ef896194a0bc659bc8969d1302ae219a9a0091e7bb82f019ac59588ef8b1e0787f', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 06:23:54', '2025-05-11 06:23:54', '2026-05-11 09:23:54'),
('d300ed54a22a8c4e64230c6becff20e834652c4f8cfd852dc8f862c9e13884ebb120c6773a15b2d2', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 11:16:47', '2025-05-06 11:16:47', '2026-05-06 14:16:47'),
('d691c94ef2b2afdf6ad3f9c30e5ab736042268cb8d823c5cbca498da92168d8a23024de16b60534d', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 09:54:08', '2025-05-12 09:54:09', '2026-05-12 12:54:08'),
('d6c4bb9df18fa00fd6bdae1f8aae533fcb2af45b9c8de36182d006e00716e54161b658b9a6db7dfc', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-10 12:04:31', '2025-05-10 12:04:31', '2026-05-10 15:04:31'),
('d77a4c589662cda33e20f5cf8dab2acca965e5467cdefc1e37a8b715258511724604263d269e65ed', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 08:28:30', '2025-05-04 08:28:30', '2026-05-04 11:28:30'),
('dd222091f5064e8af06b4b0d1bf4ca51971ad443b16e2dc4eb682750f7f1f5e1b35f81b4163feea8', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 11:52:26', '2025-05-06 11:52:26', '2026-05-06 14:52:26'),
('dd40ae84652c67ff9e060470fd92ed88ddd56da9c66fb2ecd5baf923064edca557fc04265e41a8f6', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 06:33:16', '2025-05-12 06:33:16', '2026-05-12 09:33:16'),
('def64a5031a9bd90367eab70a8b285e2de5b3b1e38d3bad2dd7b558f7eb84397064093671af1911b', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 10:08:55', '2025-05-04 10:08:55', '2026-05-04 13:08:55'),
('e195d97b3071f54c8e8a1cba73ce8d462bbb94a006678e99a5bbea8925964a6dce66705fccbc7fe1', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 10:59:52', '2025-05-04 10:59:52', '2026-05-04 13:59:52'),
('e3e3bfbb39b1345ebb5111be4d8224b3fd1e252a0b03b8d13764d5197c00a53864b472b5fb687bdd', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 16:34:00', '2025-05-11 16:34:00', '2026-05-11 19:34:00'),
('e479edab72f6fcae96b9f07a86c1550cdf8ac6bf0b60b0e5d337ab0bc3fff1fbc6e3a6ea7e4415d0', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 09:26:35', '2025-05-04 09:26:35', '2026-05-04 12:26:35'),
('e5e6348e8c77fe3cbf95e3d040063e79343d5768f29b32bcf73ea2d5daf860747c7419ae83fa29ee', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 16:09:44', '2025-05-11 16:09:44', '2026-05-11 19:09:44'),
('e658cf4fdca6433ee64a76db96776d5ea591c8608959cc635fffeb0a0a232d8eddfe5dcf4c51c5bb', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-03 07:23:02', '2025-05-03 07:23:02', '2026-05-03 10:23:02'),
('e6597d2220f26d42d10c2bc79569ad1d435c4b81f26f6a2850061d23fd2bd699d31bf070e5f77167', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 14:07:57', '2025-05-04 14:07:57', '2026-05-04 17:07:57'),
('e6717b0b4a2bcfc8b879f3b3f03a266297881cbf16b13c020baccfcb2be8ca309322f5b35fe11930', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 14:47:09', '2025-05-11 14:47:09', '2026-05-11 17:47:09'),
('e74982f45127e591ae78d5d17a98185b10ee811aaa633062f3002f01ad1d934b54d390ed1066cd0e', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-03 07:37:53', '2025-05-03 07:37:53', '2026-05-03 10:37:53'),
('e7c981943e29d2d9f2941a959e41f8400a4043c4cb1532c4823c99158efa73b31cca4f7ae2c570ae', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 13:26:37', '2025-05-02 13:26:37', '2026-05-02 16:26:37'),
('e9145ef0a14be0cce227ae021ae1aae5aa8859c5da85013d6898c1b2eaa9c7f4ca3142e8adfe96d0', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-03 07:13:44', '2025-05-03 07:13:44', '2026-05-03 10:13:44'),
('ea6ef2c1e8111bdb1709cae7b0a5e8d9ee19fb1f2f12b132b78806570f81d4143dd266cc0b6d7b83', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 10:59:27', '2025-05-06 10:59:27', '2026-05-06 13:59:27'),
('ed1ec6a1e80c7d7d3e8f4a06e3d90881d3725987b997c3db942f796c0b7a92bd27b5353541b3761a', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 08:59:01', '2025-05-11 08:59:01', '2026-05-11 11:59:01'),
('ef3513dab779cbc8cf7520dc879091fb73f2c83f6a95c12be5c00bbfbd1202171a7e23bee32140d8', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 06:35:23', '2025-05-11 06:35:23', '2026-05-11 09:35:23'),
('f460861a7bfba248e7f211b485e26b54b7468dac1a20de29f7fda94e0895ca2e8151e794a64b9272', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 14:38:23', '2025-05-11 14:38:23', '2026-05-11 17:38:23'),
('f71b6a3098d91d8a27cdac13760189d6101fce4d1a248a7d6286f102b31429203db2fe6ba5a387fe', 2, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 15:12:52', '2025-05-04 15:12:52', '2026-05-04 18:12:52'),
('f7bd2f7a3fbd6f99ccf680e656fbda070f4cb6f83d07dcb4431b99253a040f1723e1ff9f800ba9b9', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 15:24:03', '2025-05-11 15:24:03', '2026-05-11 18:24:03'),
('f7dbf46534b914b54f428e14b542dc2d438254812afd581be881317128753271a0b5449c715cc1ce', 6, 1, 'LaravelPassportToken', '[]', 0, '2025-05-06 10:57:22', '2025-05-06 10:57:22', '2026-05-06 13:57:22'),
('f96d2634031caf973b56f9484aa1021baa08329f10ae7622e93ac3195cd046652fcac09c907e773a', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-04 15:35:36', '2025-05-04 15:35:36', '2026-05-04 18:35:36'),
('fd141ffb3ceea0fe67a110ecc9aa7cf045cb68829141755adc7c3bcbc206e25736643b1d8d9e6c75', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-12 06:34:06', '2025-05-12 06:34:06', '2026-05-12 09:34:06'),
('fd30664708ccc5db114f1b35a592b9569eb4e9d1d2fbf5d49a2d0d104357a3e36ae3c4d7727ecef5', 3, 1, 'LaravelPassportToken', '[]', 0, '2025-05-02 13:45:09', '2025-05-02 13:45:09', '2026-05-02 16:45:09'),
('fe0aa61a4c01666b5205eccd50378e139e76320b8be394ce5758787f6649f06028db16e725ffc666', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-10 10:10:31', '2025-05-10 10:10:31', '2026-05-10 13:10:31'),
('fe8e489fb34f9c7e242f6f60c37ed1220cdc93ce020eeabecc5c6b8c3fc0539def21cfa82ddde5fc', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-05 13:12:15', '2025-05-05 13:12:15', '2026-05-05 16:12:15'),
('fef0dcbcec3c1b9a23f9620d200eaef1a7fbaaa4eccb68fb9007d0bf53722e681ee7f6bd3e6a434b', 5, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 13:39:59', '2025-05-11 13:39:59', '2026-05-11 16:39:59'),
('ff8611ae41de14c891a6e41569f4325d9237524fe40762b72b9ea066828b0293a76fb3dd52d3af9c', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-11 05:48:21', '2025-05-11 05:48:21', '2026-05-11 08:48:21'),
('ff9214effc93ade05ca22a9719a4e6387d824135e64a2e7e7387f97e3e7670ca985f6207df0498e4', 4, 1, 'LaravelPassportToken', '[]', 0, '2025-05-07 03:29:09', '2025-05-07 03:29:10', '2026-05-07 06:29:09');

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `secret` varchar(100) DEFAULT NULL,
  `provider` varchar(255) DEFAULT NULL,
  `redirect` text NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Laravel Personal Access Client', 'igw1BePgbdbERtn5WLzoBroCBcWSLUzfFnRVP30V', NULL, 'http://localhost', 1, 0, 0, '2025-05-02 12:07:31', '2025-05-02 12:07:31');

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2025-05-02 12:07:31', '2025-05-02 12:07:31');

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

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) NOT NULL,
  `access_token_id` varchar(100) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `occupations_bureaux`
--

CREATE TABLE `occupations_bureaux` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `titre` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `activite` varchar(255) NOT NULL,
  `nombre_personnes` int(11) NOT NULL DEFAULT 1,
  `debut` datetime NOT NULL,
  `fin` datetime NOT NULL,
  `bureau` varchar(255) NOT NULL,
  `jour_semaine` enum('lundi','mardi','mercredi','jeudi','vendredi','samedi','dimanche') NOT NULL,
  `est_recurrent` tinyint(1) NOT NULL DEFAULT 0,
  `est_annule` tinyint(1) NOT NULL DEFAULT 0,
  `couleur` varchar(7) NOT NULL DEFAULT '#4CAF50',
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `occupations_bureaux`
--

INSERT INTO `occupations_bureaux` (`id`, `titre`, `description`, `activite`, `nombre_personnes`, `debut`, `fin`, `bureau`, `jour_semaine`, `est_recurrent`, `est_annule`, `couleur`, `user_id`, `created_at`, `updated_at`) VALUES
(2, 'Session de travail personnel', 'Préparation rapport final', 'Travail personnel', 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Bureau 101', 'mercredi', 0, 0, '#33FFAA', 2, '2025-05-03 10:33:11', '2025-05-03 10:33:11'),
(4, 'Session de travail personnel', 'Préparation rapport final', 'Travail personnel', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Bureau 101', 'mercredi', 0, 0, '#33FFAA', 2, '2025-05-03 10:33:11', '2025-05-03 10:33:11');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_reset_tokens`
--

INSERT INTO `password_reset_tokens` (`email`, `token`, `created_at`) VALUES
('samali@soso.com', 'ggDWDXuE4JZ2hSDCiwFsq4N8l2Z2WW6JAGOZRJvxXLa0VljM1vnKkli4joOX', '2025-05-11 14:33:55');

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

--
-- Table structure for table `professeur_cours`
--

CREATE TABLE `professeur_cours` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `emploi_du_temps_id` bigint(20) UNSIGNED NOT NULL,
  `est_principal` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `professeur_cours`
--

INSERT INTO `professeur_cours` (`id`, `user_id`, `emploi_du_temps_id`, `est_principal`, `created_at`, `updated_at`) VALUES
(1, 3, 8, 1, '2025-05-02 15:59:03', '2025-05-02 15:59:03'),
(2, 6, 9, 0, '2025-05-02 15:59:03', '2025-05-02 15:59:03'),
(3, 3, 10, 1, '2025-05-02 15:59:03', '2025-05-02 15:59:03'),
(4, 6, 15, 1, '2025-05-02 13:09:56', '2025-05-02 13:09:56'),
(6, 3, 17, 1, '2025-05-02 14:23:30', '2025-05-02 14:23:30'),
(8, 6, 19, 1, '2025-05-06 08:58:31', '2025-05-06 08:58:31');

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nom` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `nom`, `created_at`, `updated_at`) VALUES
(4, 'student', '2025-05-02 12:14:07', '2025-05-02 12:14:07'),
(5, 'prof', '2025-05-02 12:14:07', '2025-05-02 12:14:07'),
(6, 'admin', '2025-05-02 12:14:07', '2025-05-02 12:14:07');

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

--
-- Table structure for table `salle`
--

CREATE TABLE `salle` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nom` varchar(255) NOT NULL,
  `faculte_id` bigint(20) UNSIGNED NOT NULL,
  `nombre_d_etudiant` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `google_maps_url` varchar(255) DEFAULT NULL,
  `openstreetmap_url` varchar(255) DEFAULT NULL,
  `frequentation` int(11) NOT NULL DEFAULT 0,
  `code_batiment` varchar(255) DEFAULT NULL,
  `etage` int(11) NOT NULL DEFAULT 0,
  `points_repere` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salle`
--

INSERT INTO `salle` (`id`, `nom`, `faculte_id`, `nombre_d_etudiant`, `created_at`, `updated_at`, `latitude`, `longitude`, `google_maps_url`, `openstreetmap_url`, `frequentation`, `code_batiment`, `etage`, `points_repere`) VALUES
(101, 'AN204', 1, 30, '2025-05-02 15:02:23', '2025-05-02 15:02:23', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL),
(102, 'CB020', 1, 28, '2025-05-02 15:02:23', '2025-05-02 15:02:23', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL),
(103, 'B028b', 1, 25, '2025-05-02 15:02:23', '2025-05-02 15:02:23', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL),
(104, 'CJ103', 1, 32, '2025-05-02 15:02:23', '2025-05-02 15:02:23', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL),
(105, 'CJ101', 1, 30, '2025-05-02 15:02:23', '2025-05-02 15:02:23', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL),
(106, 'CJ104', 1, 26, '2025-05-02 15:02:23', '2025-05-02 15:02:23', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL),
(107, 'CJ201', 1, 35, '2025-05-02 15:02:23', '2025-05-02 15:02:23', NULL, NULL, NULL, NULL, 0, NULL, 0, NULL);

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `groupe_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `preferred_language` varchar(2) NOT NULL DEFAULT 'fr',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `adresse` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `photo_profil` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `role_id`, `groupe_id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `preferred_language`, `created_at`, `updated_at`, `adresse`, `age`, `telephone`, `bio`, `photo_profil`) VALUES
(2, 4, 2, 'samali', 'samali@soso.com', NULL, '$2y$12$g15OVj58GNJXWuQ8hvkj1u5RfT3kxEK5EheoEEZMhA0XfiiHvipli', NULL, 'fr', '2025-05-02 12:15:25', '2025-05-04 14:11:54', 'bld Constructorilor 22', 23, '0728068393', NULL, 'uploads/profiles/1746355664.jpg'),
(3, 5, NULL, 'Malek', 'malek@samali.com', NULL, '$2y$12$qSQpxCKrmneFI5XGZ1nHPeQKb/3AS8YpYC7tMnuFt2FspiaLOFdIS', NULL, 'fr', '2025-05-02 12:20:47', '2025-05-06 08:05:05', NULL, NULL, NULL, NULL, NULL),
(4, 6, NULL, 'Florin', 'florin@gmail.com', NULL, '$2y$12$ZMlTQRrXrSUrUiuLPCkEq.o/RgNzL/3Mjr7EmiS5fREwJ5ZNng4le', NULL, 'fr', '2025-05-03 07:23:02', '2025-05-11 07:44:42', 'Secretariat Fils', NULL, '+40 214 029 889', 'Heures de travaille de 12h a 14h', NULL),
(5, 4, 1, 'Mohamed', 'mohamed@samali.com', NULL, '$2y$12$ISvBVnH3tqfsP23P1KbeS.uhFiT8qoohp6smGaMvfEyLz5v7h6W/i', NULL, 'fr', '2025-05-04 15:35:36', '2025-05-04 15:35:36', NULL, NULL, NULL, NULL, NULL),
(6, 5, NULL, 'dascalu', 'dascalu@gmail.com', NULL, '$2y$12$uy6f6Ur83nKMC0LXbJnOnOu3n72mzts91cW.e5PXkTkT2iCNiMDa6', NULL, 'fr', '2025-05-06 10:56:42', '2025-05-06 10:56:42', NULL, NULL, NULL, NULL, NULL),
(7, 4, 2, 'Tachet', 'Tachet@gmail.com', NULL, '$2y$12$CesnlkRtbLOYVLdxJLzX0.IRrl8LAgBKLdJJ0h2D3FzmXjX1vQP2q', NULL, 'fr', '2025-05-11 08:57:52', '2025-05-11 08:57:52', NULL, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `device_tokens`
--
ALTER TABLE `device_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `device_tokens_token_unique` (`token`),
  ADD KEY `device_tokens_user_id_foreign` (`user_id`);

--
-- Indexes for table `emploi_du_temps`
--
ALTER TABLE `emploi_du_temps`
  ADD PRIMARY KEY (`id`),
  ADD KEY `emploi_du_temps_groupe_id_foreign` (`groupe_id`),
  ADD KEY `emploi_du_temps_salle_id_foreign` (`salle_id`);

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

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

--
-- Indexes for table `groupes`
--
ALTER TABLE `groupes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `groupes_major_id_foreign` (`major_id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `majors`
--
ALTER TABLE `majors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `majors_faculty_id_foreign` (`faculty_id`);

--
-- Indexes for table `major_salle`
--
ALTER TABLE `major_salle`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `major_salle_major_id_salle_id_unique` (`major_id`,`salle_id`),
  ADD KEY `major_salle_salle_id_foreign` (`salle_id`);

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

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_groupe_id_foreign` (`groupe_id`),
  ADD KEY `notifications_user_id_foreign` (`user_id`),
  ADD KEY `notifications_major_id_foreign` (`major_id`);

--
-- Indexes for table `notification_documents`
--
ALTER TABLE `notification_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notification_documents_notification_id_foreign` (`notification_id`);

--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

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

--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indexes for table `occupations_bureaux`
--
ALTER TABLE `occupations_bureaux`
  ADD PRIMARY KEY (`id`),
  ADD KEY `occupations_bureaux_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `professeur_cours`
--
ALTER TABLE `professeur_cours`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `professeur_cours_user_id_emploi_du_temps_id_unique` (`user_id`,`emploi_du_temps_id`),
  ADD KEY `professeur_cours_emploi_du_temps_id_foreign` (`emploi_du_temps_id`);

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

--
-- Indexes for table `salle`
--
ALTER TABLE `salle`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salle_faculte_id_foreign` (`faculte_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `device_tokens`
--
ALTER TABLE `device_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `emploi_du_temps`
--
ALTER TABLE `emploi_du_temps`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `faculte`
--
ALTER TABLE `faculte`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `groupes`
--
ALTER TABLE `groupes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `majors`
--
ALTER TABLE `majors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `major_salle`
--
ALTER TABLE `major_salle`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `notification_documents`
--
ALTER TABLE `notification_documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `occupations_bureaux`
--
ALTER TABLE `occupations_bureaux`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `professeur_cours`
--
ALTER TABLE `professeur_cours`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `salle`
--
ALTER TABLE `salle`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=108;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `device_tokens`
--
ALTER TABLE `device_tokens`
  ADD CONSTRAINT `device_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `emploi_du_temps`
--
ALTER TABLE `emploi_du_temps`
  ADD CONSTRAINT `emploi_du_temps_groupe_id_foreign` FOREIGN KEY (`groupe_id`) REFERENCES `groupes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `emploi_du_temps_salle_id_foreign` FOREIGN KEY (`salle_id`) REFERENCES `salle` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `groupes`
--
ALTER TABLE `groupes`
  ADD CONSTRAINT `groupes_major_id_foreign` FOREIGN KEY (`major_id`) REFERENCES `majors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `majors`
--
ALTER TABLE `majors`
  ADD CONSTRAINT `majors_faculty_id_foreign` FOREIGN KEY (`faculty_id`) REFERENCES `faculte` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `major_salle`
--
ALTER TABLE `major_salle`
  ADD CONSTRAINT `major_salle_major_id_foreign` FOREIGN KEY (`major_id`) REFERENCES `majors` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `major_salle_salle_id_foreign` FOREIGN KEY (`salle_id`) REFERENCES `salle` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `notifications_groupe_id_foreign` FOREIGN KEY (`groupe_id`) REFERENCES `groupes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `notifications_major_id_foreign` FOREIGN KEY (`major_id`) REFERENCES `majors` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `notification_documents`
--
ALTER TABLE `notification_documents`
  ADD CONSTRAINT `notification_documents_notification_id_foreign` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `occupations_bureaux`
--
ALTER TABLE `occupations_bureaux`
  ADD CONSTRAINT `occupations_bureaux_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `professeur_cours`
--
ALTER TABLE `professeur_cours`
  ADD CONSTRAINT `professeur_cours_emploi_du_temps_id_foreign` FOREIGN KEY (`emploi_du_temps_id`) REFERENCES `emploi_du_temps` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `professeur_cours_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `salle`
--
ALTER TABLE `salle`
  ADD CONSTRAINT `salle_faculte_id_foreign` FOREIGN KEY (`faculte_id`) REFERENCES `faculte` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_groupe_id_foreign` FOREIGN KEY (`groupe_id`) REFERENCES `groupes` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

