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

START TRANSACTION;



--
-- Database: `qky`
--

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

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` bigint UNSIGNED NOT NULL,
  `cat` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `record_id` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `nom` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `desc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `deleted` bigint NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint DEFAULT NULL,
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `documents`
--

INSERT INTO `documents` (`id`, `cat`, `record_id`, `nom`, `desc`, `file`, `deleted`, `deleted_at`, `deleted_by`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'patient1', '1', NULL, NULL, '1724858880.jpg', 0, NULL, NULL, NULL, NULL, '2024-08-28 15:28:00', '2024-08-28 15:28:00'),
(2, 'patient37763', '1', 'ikndin', NULL, '1752527825.jpg', 0, NULL, NULL, NULL, NULL, '2025-07-14 21:17:05', '2025-07-14 21:17:05');

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

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

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

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

--
-- Table structure for table `fonctionnalites`
--

CREATE TABLE `fonctionnalites` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `deleted` bigint NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint DEFAULT NULL,
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fonctionnalites`
--

INSERT INTO `fonctionnalites` (`id`, `name`, `desc`, `deleted`, `deleted_at`, `deleted_by`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Calendrier', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-28 16:09:14', '2023-06-28 16:09:14'),
(2, 'Tableaux de bord', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-28 18:39:54', '2023-06-28 18:39:54'),
(17, 'Gestion des imputation', NULL, 1, '2025-01-04 00:25:29', 1, NULL, NULL, '2024-05-15 12:33:57', '2025-01-04 00:25:29'),
(18, 'Mon espace', NULL, 0, NULL, NULL, NULL, NULL, '2024-05-22 14:41:39', '2025-01-03 23:07:34'),
(19, 'Menu:patient', NULL, 1, '2024-06-15 06:04:50', 1, NULL, NULL, '2024-06-13 09:28:58', '2024-06-15 06:04:50'),
(20, 'Gestion du contenu', NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 23:07:53', '2025-01-03 23:07:53'),
(21, 'Bulletin épidémiologique', NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 23:08:14', '2025-01-03 23:08:14'),
(22, 'Editeur d\'apparence', NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 23:08:39', '2025-01-03 23:08:39'),
(23, 'Actualités', NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 23:11:10', '2025-01-03 23:11:10'),
(24, 'Concours', NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 23:11:31', '2025-01-03 23:11:31'),
(25, 'Paramétrage', NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 23:11:49', '2025-01-03 23:11:49'),
(26, 'Guides et manuels', NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 23:12:06', '2025-01-03 23:12:06'),
(27, 'Gestion des patients', NULL, 0, NULL, NULL, NULL, NULL, '2025-12-02 17:44:15', '2025-12-02 17:44:15');

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

--
-- Table structure for table `fonctionnalites_ressources`
--

CREATE TABLE `fonctionnalites_ressources` (
  `fonctionnalite_id` int DEFAULT NULL,
  `ressource_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fonctionnalites_ressources`
--

INSERT INTO `fonctionnalites_ressources` (`fonctionnalite_id`, `ressource_id`) VALUES
(2, 2),
(19, 16),
(27, 18);

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

--
-- Table structure for table `fonctionnalites_routes`
--

CREATE TABLE `fonctionnalites_routes` (
  `fonctionnalite_id` int DEFAULT NULL,
  `route` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fonctionnalites_routes`
--

INSERT INTO `fonctionnalites_routes` (`fonctionnalite_id`, `route`) VALUES
(2, 'admin'),
(27, 'patient56_list'),
(27, 'patient56_create'),
(27, 'patient56_update'),
(27, 'patient56_delete'),
(27, 'patient56_export'),
(27, 'patient56_datatable_api'),
(27, 'patient56_fiche'),
(27, 'patient56_change_statut');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint UNSIGNED NOT NULL,
  `titre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_menu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ordre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ressource` int DEFAULT NULL,
  `statut` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `roles` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deleted` bigint NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint DEFAULT NULL,
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint 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 `menus`
--

INSERT INTO `menus` (`id`, `titre`, `page`, `parent_menu`, `ordre`, `ressource`, `statut`, `icon`, `roles`, `desc`, `deleted`, `deleted_at`, `deleted_by`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(58, 'Securité', NULL, NULL, '8.9', NULL, '1', 'verified_user', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2023-11-12 10:11:34', '2024-03-16 14:19:05'),
(59, 'Paramétrage', NULL, NULL, '9', NULL, '1', 'settings', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2023-11-12 10:12:11', '2023-11-12 10:12:11'),
(60, 'Utilisateurs', 'user_list', '58', '1', NULL, '1', 'people', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2023-11-12 10:13:29', '2024-03-14 00:14:30'),
(61, 'Rôles', 'role_list', '58', '2', NULL, '1', 'check_box', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2023-11-12 10:28:59', '2023-12-27 11:15:51'),
(62, 'Mon profil', 'user_profil', '59', '1', NULL, '1', 'person', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2023-11-12 10:38:36', '2023-11-12 10:38:36'),
(66, 'Tableaux de bord', 'home', NULL, '1', NULL, '1', 'pie_chart', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-03-14 00:14:54', '2025-10-04 14:00:05'),
(83, 'Administration', NULL, NULL, '99', NULL, '1', 'settings_applications', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-05 08:50:40', '2024-05-05 08:50:40'),
(84, 'Editeur d\'apparence', 'skineditor_list', '83', '2', NULL, '1', 'palette', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-05 08:52:37', '2024-05-05 08:52:37'),
(85, 'Gestion des Menus', 'menu_list', '83', '3', NULL, '1', 'menu', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-05 08:55:55', '2024-05-05 08:55:55'),
(86, 'Nouvelle application', 'quicky', '83', '1', NULL, '1', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-05 08:58:10', '2024-05-05 08:58:10'),
(89, 'Fonctionnalités', 'fonctionnalite_list', '83', '4', NULL, '1', 'border_all', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-06 09:32:20', '2024-05-06 09:32:20'),
(95, 'Ressources', 'ressource_list', '83', '5', NULL, '1', 'pages', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-10 10:24:45', '2024-05-10 10:24:45'),
(105, 'Type badge', 'typebadge_list', '59', '2', NULL, '1', 'menu', NULL, NULL, 1, '2024-08-23 09:54:17', 1, NULL, NULL, '2024-07-05 10:19:49', '2024-08-23 09:54:17'),
(106, 'Gestion des badges', 'badge_list', NULL, '2', NULL, '1', 'account_balance', NULL, NULL, 1, '2024-08-23 09:54:12', 1, NULL, NULL, '2024-07-05 10:23:34', '2024-08-23 09:54:12'),
(142, 'Situation famililale', 'situationf6383_list', '59', '1', NULL, '1', 'person_outline', NULL, NULL, 1, '2025-08-18 12:53:54', 1, NULL, NULL, '2025-07-14 21:06:19', '2025-08-18 12:53:54'),
(143, 'Type assur', 'typeassur6383_list', '59', '2', NULL, '1', 'music_video', NULL, NULL, 1, '2025-08-18 12:53:58', 1, NULL, NULL, '2025-07-14 21:08:15', '2025-08-18 12:53:58'),
(144, 'Gestion des patients', 'patient37763_list', NULL, '2', 17, '1', 'person_pin', NULL, NULL, 1, '2025-09-01 14:12:05', 1, NULL, NULL, '2025-07-14 21:14:59', '2025-09-01 14:12:05'),
(145, 'Type d\'assurance', 'typeassur72627_list', '59', '2', NULL, '1', 'menu', NULL, NULL, 1, '2025-09-01 14:11:40', 1, NULL, NULL, '2025-08-18 12:54:17', '2025-09-01 14:11:40'),
(150, 'Type assurance', 'typeasurance66_list', '59', '1', NULL, '1', 'multiline_chart', NULL, NULL, 1, '2025-10-13 14:49:07', 1, NULL, NULL, '2025-10-08 14:08:03', '2025-10-13 14:49:07'),
(151, 'Gestion des patients', 'patient66_list', NULL, '2', NULL, '1', 'person_pin', NULL, NULL, 1, '2025-10-13 14:48:58', 1, NULL, NULL, '2025-10-08 14:13:32', '2025-10-13 14:48:58'),
(152, 'Types d\'assurance', 'typeassur1310_list', '59', '2', NULL, '1', 'my_location', NULL, NULL, 1, '2025-12-02 17:19:51', 1, NULL, NULL, '2025-10-13 14:51:49', '2025-12-02 17:19:51'),
(153, 'Gestion des patients', 'patient1310_list', NULL, '2', NULL, '1', 'person_pin', NULL, NULL, 1, '2025-12-02 17:19:40', 1, NULL, NULL, '2025-10-13 14:57:44', '2025-12-02 17:19:40'),
(154, 'Type d\'assurances', 'typesassurance56_list', '59', '1', NULL, '1', 'menu', NULL, NULL, 1, '2025-12-03 14:34:24', 1, NULL, NULL, '2025-12-02 17:28:51', '2025-12-03 14:34:24'),
(155, 'Gestion patients', 'patient56_list', NULL, '2', 18, '1', 'person_pin', NULL, NULL, 1, '2025-12-03 14:34:19', 1, NULL, NULL, '2025-12-02 17:36:05', '2025-12-03 14:34:19'),
(156, 'Types d\'assurances', 'typeassura878_list', '59', '2', NULL, '1', 'music_note', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-12-03 14:36:52', '2025-12-03 14:36:52'),
(157, 'Group sang', 'groups878_list', '59', '3', NULL, '1', 'menu', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-12-03 14:37:18', '2025-12-03 14:37:18'),
(158, 'Situation Fam', 'situationfa878_list', '59', '4', NULL, '1', 'menu', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-12-03 14:37:41', '2025-12-03 14:37:41'),
(159, 'Gestion des patients', 'patient8397_list', NULL, '2', NULL, '1', 'person_pin', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-12-03 14:43:22', '2025-12-03 14:43:22');

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

--
-- Table structure for table `migrations`
--

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(93, '2024_05_04_140533_skineditor_table', 87),
(132, '2024_06_20_134952_testcrud_table', 88),
(133, '2024_06_20_140341_testttt_table', 89),
(134, '2024_06_21_055508_update_table', 90),
(135, '2024_06_21_060736_update_table_update_fields', 91),
(136, '2024_06_21_063514_update_table_update_fields', 92),
(137, '2024_06_21_064734_testupdate2_table', 93),
(138, '2024_06_21_064754_testupdate2_table_update_fields', 94),
(139, '2024_06_21_065758_testupdate2_table_update_fields', 95),
(140, '2024_06_21_065834_testupdate3_table', 96),
(141, '2024_06_21_065909_testupdate3_table_update_fields', 97),
(142, '2024_06_21_082713_testupdate4_table', 98),
(143, '2024_06_21_083051_testupdate5_table', 99),
(144, '2024_06_21_083431_testupdate27_table', 100),
(145, '2024_06_21_083507_testupdate27_table_update_fields', 101),
(146, '2024_06_21_084302_formation_table', 102),
(147, '2024_06_21_084339_formation_table_update_fields', 103),
(148, '2024_06_22_183356_testselect_table', 104),
(149, '2024_06_22_185132_testselect2_table', 105),
(150, '2024_06_22_185257_testselect3_table', 106),
(151, '2024_06_22_191008_testselect4_table', 107),
(152, '2024_06_22_202122_testselect5_table', 108),
(153, '2024_06_22_205040_testselect6_table', 109),
(154, '2024_06_22_205231_testselect7_table', 110),
(155, '2024_06_23_093532_testselect8_table', 111),
(156, '2024_06_23_095614_testselect9_table', 112),
(157, '2024_06_23_100922_testmult_table', 113),
(158, '2024_06_23_101439_testmultipl_table', 114),
(159, '2024_06_24_120029_testselectt_table', 115),
(160, '2024_06_26_194310_testfati_table', 116),
(161, '2024_06_26_194524_testfati_table_update_fields', 117),
(162, '2024_06_29_180343_ad1_table', 118),
(163, '2024_06_29_180505_ad1_table_update_fields', 119),
(164, '2024_06_29_182341_ad2_table', 120),
(165, '2024_06_29_182454_ad2_table_update_fields', 121),
(166, '2024_07_05_100351_test_table', 122),
(167, '2024_07_05_101859_typebadge_table', 123),
(168, '2024_07_05_102216_badge_table', 124),
(169, '2024_08_23_095854_dxcar_table', 125),
(170, '2024_08_28_093541_tata3_table', 126),
(171, '2024_08_28_152059_typeassurance1_table', 127),
(172, '2024_08_28_152238_groups1_table', 128),
(173, '2024_08_28_152716_patient1_table', 129),
(174, '2024_09_01_112942_inventaireperm_table', 130),
(175, '2024_09_01_213808_dxinv_table', 131),
(176, '2024_09_04_221004_grps_table', 132),
(177, '2024_09_04_221304_patient33_table', 133),
(178, '2024_09_04_221427_test422_table', 134),
(179, '2024_09_05_201044_typeassura_table', 135),
(180, '2024_09_05_201556_patient44_table', 136),
(181, '2024_09_11_094133_situationfam_table', 137),
(182, '2024_09_11_094239_typeass9_table', 138),
(183, '2024_09_11_094705_patient78_table', 139),
(184, '2024_09_12_191054_groups10_table', 140),
(185, '2024_09_12_191142_situationfam11_table', 141),
(186, '2024_09_12_191235_groups10_table_update_fields', 142),
(187, '2024_09_12_191848_patient683_table', 143),
(188, '2024_09_25_154850_typeassur8_table', 144),
(189, '2024_09_25_155451_patient98_table', 145),
(190, '2024_10_01_121215_typeassur77_table', 146),
(191, '2024_10_01_121634_patient77_table', 147),
(192, '2024_10_01_190924_tyepassurance88_table', 148),
(193, '2024_10_01_191301_patient88_table', 149),
(194, '2024_11_03_211847_site_table', 150),
(195, '2024_11_03_213347_ordremission_table', 151),
(196, '2024_11_04_051131_ordremission_table_update_fields', 152),
(197, '2024_11_12_132051_typassursa_table', 153),
(198, '2024_11_12_132543_patientsa_table', 154),
(199, '2024_11_13_170057_jihdzihdz_table', 155),
(200, '2024_11_21_060009_testphar_table', 156),
(201, '2024_11_21_194604_typeassur92_table', 157),
(202, '2024_11_21_195028_patient92_table', 158),
(203, '2024_12_06_125550_test_table', 159),
(204, '2024_12_06_125605_test2_table', 160),
(205, '2024_12_06_131556_typeassur33_table', 161),
(206, '2024_12_18_094724_ffgrgg_table', 162),
(207, '2025_01_03_120119_catnews_table', 163),
(208, '2025_01_03_122002_news_table', 164),
(209, '2025_02_15_200101_typeasur667_table', 165),
(210, '2025_02_15_200225_group667_table', 166),
(211, '2025_02_15_200612_patient667_table', 167),
(212, '2025_03_02_112842_dt1_table', 168),
(213, '2025_03_02_120710_dt2_table', 169),
(214, '2025_03_02_130241_dt3_table', 170),
(215, '2025_03_02_131024_dt4_table', 171),
(216, '2025_03_02_132109_dt5_table', 172),
(217, '2025_03_02_145117_dt6_table', 173),
(218, '2025_03_02_145359_df7_table', 174),
(219, '2025_03_02_151414_dt8_table', 175),
(220, '2025_03_02_151853_df9_table', 176),
(221, '2025_03_02_152610_df10_table', 177),
(222, '2025_03_02_153648_dt11_table', 178),
(223, '2025_03_02_153908_dt12_table', 179),
(224, '2025_03_02_154359_df13_table', 180),
(225, '2025_03_02_154810_df14_table', 181),
(226, '2025_03_02_154917_df15_table', 182),
(227, '2025_03_02_171205_dt13_table', 183),
(228, '2025_03_07_144816_hol_table', 184),
(229, '2025_03_07_151147_typeassur738_table', 185),
(230, '2025_03_07_152422_patient738_table', 186),
(231, '2025_04_17_074548_pat7483_table', 187),
(232, '2025_04_17_074721_pat6352_table', 188),
(233, '2025_05_22_165848_typeassur13748_table', 189),
(234, '2025_05_22_170410_patient6338_table', 190),
(235, '2025_06_16_063139_purchasetype_table', 191),
(236, '2025_06_16_063459_suppliertype_table', 192),
(237, '2025_06_16_071752_supplier_table', 193),
(238, '2025_06_16_082146_purchase_table', 194),
(239, '2025_06_16_084421_purchase_table_update_fields', 195),
(240, '2025_06_16_091810_purchasearticle_table', 196),
(241, '2025_06_20_212317_biographie_table', 197),
(242, '2025_07_03_183945_typeassur7383_table', 198),
(243, '2025_07_14_210546_situationf6383_table', 199),
(244, '2025_07_14_210744_typeassur6383_table', 200),
(245, '2025_07_14_211408_patient37763_table', 201),
(246, '2025_07_14_211833_situationf6383_table_update_fields', 202),
(247, '2025_08_18_125331_typeassur72627_table', 203),
(248, '2025_08_18_130106_patient72627_table', 204),
(249, '2025_08_18_130713_patient72627_table_update_fields', 205),
(250, '2025_09_01_141901_test_table', 206),
(251, '2025_09_01_144713_typeassurance99_table', 207),
(252, '2025_09_01_144831_groupesan_table', 208),
(253, '2025_09_01_145546_patient99_table', 209),
(254, '2025_09_01_145808_patient99_table_update_fields', 210),
(255, '2025_09_08_072203_supplier_table', 211),
(256, '2025_09_08_073851_starticletype_table', 212),
(257, '2025_09_08_074604_stkarticle_table', 213),
(258, '2025_10_08_140731_typeasurance66_table', 214),
(259, '2025_10_08_140853_groupsan66_table', 215),
(260, '2025_10_08_141237_patient66_table', 216),
(261, '2025_10_13_145106_typeassur1310_table', 217),
(262, '2025_10_13_145658_patient1310_table', 218),
(263, '2025_12_02_172703_typesassurance56_table', 219),
(264, '2025_12_02_172923_groups56_table', 220),
(265, '2025_12_02_172958_situationfami56_table', 221),
(266, '2025_12_02_173530_patient56_table', 222),
(267, '2025_12_02_174039_patient56_table_update_fields', 223),
(268, '2025_12_03_143514_typeassura878_table', 224),
(269, '2025_12_03_143547_groups878_table', 225),
(270, '2025_12_03_143618_situationfa878_table', 226),
(271, '2025_12_03_144253_patient8397_table', 227);

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

--
-- Table structure for table `parameters`
--

CREATE TABLE `parameters` (
  `id` int NOT NULL,
  `villes_depart` varchar(500) DEFAULT NULL,
  `tauxtva` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `parameters`
--

INSERT INTO `parameters` (`id`, `villes_depart`, `tauxtva`, `created_at`, `updated_at`) VALUES
(1, '2,38', '20', NULL, '2022-07-11 23:19:01');

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

--
-- Table structure for table `ressources`
--

CREATE TABLE `ressources` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `deleted` bigint NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint DEFAULT NULL,
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ressources`
--

INSERT INTO `ressources` (`id`, `name`, `desc`, `deleted`, `deleted_at`, `deleted_by`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Calendrier', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-28 16:10:51', '2023-07-01 22:37:56'),
(2, 'Tableaux de bord', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-28 18:44:56', '2023-06-28 18:44:56'),
(16, 'Manu:Patient', NULL, 1, '2024-06-15 06:04:42', 1, NULL, NULL, '2024-06-13 09:28:07', '2024-06-15 06:04:42'),
(17, 'Menu patient', NULL, 0, NULL, NULL, NULL, NULL, '2025-07-14 21:24:11', '2025-07-14 21:24:11'),
(18, 'Gestion des patients', NULL, 0, NULL, NULL, NULL, NULL, '2025-12-02 17:43:23', '2025-12-02 17:43:23');

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

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

CREATE TABLE `roles` (
  `id` int NOT NULL,
  `label` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `roles` (`id`, `label`, `desc`, `created_at`, `created_by`, `updated_at`, `updated_by`, `deleted`, `deleted_at`, `deleted_by`) VALUES
(1, 'Administrateur', NULL, '2022-02-26 07:51:58', NULL, '2022-02-26 07:51:58', NULL, 0, NULL, NULL),
(10, 'Assistante', NULL, '2023-07-03 12:36:01', NULL, '2024-05-06 10:14:31', NULL, 1, '2024-05-06 10:14:31', 1),
(11, 'Directeur', NULL, '2023-07-03 12:59:27', NULL, '2024-05-06 10:16:20', NULL, 0, NULL, NULL),
(12, 'Medecin', NULL, '2023-07-03 12:59:27', NULL, '2023-07-03 12:59:51', NULL, 1, '2023-07-03 12:59:51', 1),
(13, 'Medecin', NULL, '2023-07-03 12:59:28', NULL, '2023-07-03 12:59:46', NULL, 1, '2023-07-03 12:59:46', 1);

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

--
-- Table structure for table `roles_droits`
--

CREATE TABLE `roles_droits` (
  `role_id` int NOT NULL,
  `droit_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `roles_fonctionnalites`
--

CREATE TABLE `roles_fonctionnalites` (
  `role_id` int NOT NULL,
  `fonctionnalite_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles_fonctionnalites`
--

INSERT INTO `roles_fonctionnalites` (`role_id`, `fonctionnalite_id`) VALUES
(10, 1),
(10, 3),
(10, 4),
(10, 5),
(10, 7),
(10, 8),
(11, 1),
(11, 2),
(12, 1),
(12, 2),
(12, 3),
(12, 4),
(12, 5),
(12, 6),
(12, 7),
(12, 8),
(12, 9),
(12, 10),
(12, 11),
(12, 12),
(13, 1),
(13, 2),
(13, 3),
(13, 4),
(13, 5),
(13, 6),
(13, 7),
(13, 8),
(13, 9),
(13, 10),
(13, 11),
(13, 12),
(1, 27);

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

--
-- Table structure for table `skineditors`
--

CREATE TABLE `skineditors` (
  `id` bigint UNSIGNED NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statut` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_login` longtext COLLATE utf8mb4_unicode_ci,
  `logo_login` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bg_login` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `css_login` longtext COLLATE utf8mb4_unicode_ci,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_mini` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_layout` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_sidebar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_sidebar_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_sidebar_menu_active` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_sidebar_menu_active_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `layout_css` longtext COLLATE utf8mb4_unicode_ci,
  `desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` bigint NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint DEFAULT NULL,
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint 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 `skineditors`
--

INSERT INTO `skineditors` (`id`, `label`, `statut`, `title_login`, `logo_login`, `bg_login`, `css_login`, `title`, `logo_mini`, `logo_layout`, `color_sidebar`, `color_sidebar_text`, `color_sidebar_menu_active`, `color_sidebar_menu_active_text`, `layout_css`, `desc`, `deleted`, `deleted_at`, `deleted_by`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'EasyCollab', '0', 'EasyCollab', '1714833769.66364969e818f.png', '1714833769.66364969eb0a9.jpg', NULL, 'EasyCollab', '1714833769.66364969eb5d4.png', '1714833769.66364969eb8ec.png', '#068ca6', '#ffffff', '#ffffff', '#068ca6', NULL, NULL, 0, NULL, NULL, 1, 1, '2024-05-04 14:15:48', '2025-12-03 14:33:33'),
(2, 'Bytel', '1', 'Bouygues Telecom', '1714837511.66365807577f3.png', '1714837511.6636580757de9.jpg', '.form-icon img{\r\n    height: 100px !important;\r\n    width: 300px !important;\r\n    margin-top: -8px !important;\r\n}', 'Bouygues Telecom', '1714838214.66365ac6bc2dc.png', '1714838214.66365ac6bc9e0.png', '#25465f', '#ffffff', '#ffffff', '#cc4e0a', '.logo-text img {\r\n    margin: -24px 5px 11px 50px !important;\r\n    height: 53px !important;\r\n    width: 140px !important;\r\n}\r\n\r\n.indigo {\r\n    background-color: #25465f !important;\r\n}\r\n\r\n.btn, .btn-large, .btn-small {\r\n     background-color: #cc4e0a ;\r\n}\r\n\r\n.gradient-45deg-light-blue-cyan {\r\n    background: #cc4e0a !important;\r\n}\r\n\r\n.btn:hover {\r\n    background-color: #cc4e0a;\r\n}\r\nh4 {\r\n    color: #25465f;\r\n}', NULL, 0, '2024-12-04 07:20:35', 1, 1, 1, '2024-05-04 15:26:24', '2025-12-03 14:33:33'),
(5, 'Capgemini', '0', 'Capgemini', '1715501779.66407ad33053a.svg', '1715502130.66407c32d623b.webp', 'img{     height: 110px !important; }', 'Capgemini', '1715501779.66407ad334143.png', '1715501779.66407ad33423f.svg', '#0070ad', '#ffffff', '#ffffff', '#0070ad', NULL, NULL, 0, '2024-12-04 07:20:39', 1, 1, 1, '2024-05-12 08:16:19', '2025-12-03 14:33:33'),
(6, 'Atelier sarrah aberbach', '0', 'Atelier sarrah aberbach', '1717178739.665a1173ecf8e.png', '1717181361.665a1bb1a0486.jpg', 'img {\r\n    height: 76px !important;\r\n    width: 300px !important;\r\n    margin-top: -1px !important;\r\n}', 'Atelier sarrah aberbach', '1717179211.665a134b7f03a.png', '1717227679.665ad09fb6a64.png', '#6d7172', '#ffffff', '#ffffff', '#000000', '.brand-sidebar .logo-wrapper a.brand-logo img {\r\n    height: 14px;\r\n    left: 0 !important;\r\n    margin: 19px;\r\n    padding-right: 14px;\r\n}', NULL, 1, '2024-06-18 12:57:26', 1, 1, 1, '2024-05-31 13:03:31', '2025-12-03 14:33:33'),
(7, 'houseofcurves', '0', 'House of Curves', '1719688137.66805bc91de61.png', '1719688137.66805bc920d35.jpg', 'img {\r\n   height: 60px !important;\r\n    width: 300px !important;\r\n    margin-top: 15px !important;\r\n}', 'House of Curves', '1719688137.66805bc920f85.png', '1719688137.66805bc921131.png', '#d5b8a8', NULL, NULL, '#d5b8a8', '.indigo {\r\n    background-color: #cbad9c!important;\r\n}\r\n\r\n.btn, .btn-large, .btn-small {\r\n     background-color: #cbad9c;\r\n}\r\n\r\n.gradient-45deg-light-blue-cyan {\r\n    background: #cbad9c!important;\r\n}\r\n\r\n.btn:hover {\r\n    background-color: #cbad9c;\r\n}', NULL, 1, '2024-07-02 08:51:07', 1, 1, 1, '2024-06-29 19:08:57', '2025-12-03 14:33:33'),
(8, 'MSPS', '0', 'Ministère de la Santé', '1735044980.676aaf743bf0b.png', '1735061561.676af0396fc08.jpg', '.form-icon img {\r\n    height: 80px !important;\r\n    width: fit-content !important;\r\n    margin-top: 0px !important;\r\n}', 'Ministère de la Santé', '1735046628.676ab5e4c9cae.png', '1735047088.676ab7b0e40c9.png', '#354E82', NULL, NULL, NULL, 'aside {\r\nbackground: linear-gradient(to bottom, #354E82 32%,#4B9562 93%) !important;\r\n}\r\n\r\n.gradient-45deg-light-blue-cyan {\r\n    background: linear-gradient(45deg, #364f82, #364f82) !important;\r\n}\r\n.btn{\r\n    background-color: #364f83 !important;\r\n}\r\n.indigo {\r\n    background-color: #364f83 !important;\r\n}\r\n\r\n.btn-light {\r\n    background-color: #4c9563 !important;\r\n}\r\n.gradient-45deg-light-blue-cyan.gradient-shadow {\r\n    box-shadow: none !important;\r\n}', NULL, 1, '2025-02-15 19:38:44', 1, 1, 1, '2024-12-24 12:56:20', '2025-12-03 14:33:33'),
(9, 'Ostool', '0', 'Ostool', '1759585775.68e125efa5f20.png', '1759586720.68e129a0cd4f1.webp', '.form-icon img{\r\n    height: 72px !important;\r\n    width: 300px !important;\r\n    margin-top: 4px !important;\r\n    margin-bottom: 13px !important;\r\n}', 'Ostool', '1759585775.68e125efaa518.png', '1759585978.68e126ba5a04d.png', '#0c777e', '#00283e', NULL, NULL, NULL, NULL, 1, '2025-12-02 17:21:39', 1, 1, 1, '2025-10-04 13:46:51', '2025-12-03 14:33:33');

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

--
-- Table structure for table `statuts`
--

CREATE TABLE `statuts` (
  `id` bigint UNSIGNED NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `identifiant` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `color` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ordre` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `desc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `deleted` bigint NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint DEFAULT NULL,
  `created_by` bigint DEFAULT NULL,
  `updated_by` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `statuts`
--

INSERT INTO `statuts` (`id`, `code`, `identifiant`, `label`, `color`, `icon`, `ordre`, `desc`, `deleted`, `deleted_at`, `deleted_by`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'POC', '1', 'Créé', '#c3c6c7', 'create', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2024-05-01 08:14:28'),
(2, 'poc2', '1', 'créé', '#b4b7b8', 'create', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-01 22:33:36', '2024-05-01 22:33:36'),
(3, 'poc2', '2', 'En cours de traitement', '#208eb3', 'access_time', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-01 22:33:36', '2024-05-01 22:33:36'),
(4, 'poc2', '3', 'Terminé', '#20b334', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-01 22:33:36', '2024-05-01 22:33:36'),
(5, 'poc3', '1', 'créé', '#d8e2e6', '3d_rotation', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-01 22:39:47', '2024-05-01 22:39:47'),
(6, 'poc3', '2', 'terminé', '#20b353', 'check_box', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-01 22:39:47', '2024-05-01 22:39:47'),
(7, 'poc4', '1', 'créé', '#bac0c2', 'create', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-01 22:41:55', '2024-05-01 22:41:55'),
(8, 'poc4', '2', 'terminé', '#20b32c', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-01 22:41:55', '2024-05-01 22:41:55'),
(9, 'poc5', '1', 'créé', '#208eb3', '3d_rotation', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 09:21:07', '2024-05-03 09:21:07'),
(10, 'poc5', '2', 'en cours', '#36474d', '3d_rotation', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 09:21:07', '2024-05-03 09:21:07'),
(11, 'poc5', '3', 'terminé', '#20b323', 'access_alarm', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 09:21:07', '2024-05-03 09:21:07'),
(12, 'poc6', '1', 'créé', '#9ca3a6', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 09:45:25', '2024-05-03 09:45:25'),
(13, 'poc6', '2', 'En cours', '#27b4e3', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 09:45:25', '2024-05-03 09:45:25'),
(14, 'poc6', '3', 'Terminé', '#20b33b', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 09:45:25', '2024-05-03 09:45:25'),
(15, 'poc7', '1', 's1', '#adb7ba', '3d_rotation', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 09:50:05', '2024-05-03 09:50:05'),
(16, 'poc7', '2', 'créé', '#1d637a', '3d_rotation', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 09:50:05', '2024-05-03 09:50:05'),
(17, 'poc8', '1', 'créé', '#babebf', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 10:34:47', '2024-05-03 10:34:47'),
(18, 'poc8', '2', 'En cours', '#0a9dcf', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 10:34:47', '2024-05-03 10:34:47'),
(19, 'poc8', '3', 'En validation', '#45b320', 'ac_unit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 10:34:47', '2024-05-03 10:34:47'),
(20, 'poc8', '4', 'terminé', '#1e5405', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 10:34:47', '2024-05-03 10:34:47'),
(21, 'ffpatient', '1', 'créé', '#b6bfc2', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 11:25:23', '2024-05-03 11:25:23'),
(22, 'ffpatient', '2', 'En cours validation', '#12b1e6', '3d_rotation', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 11:25:23', '2024-05-03 11:25:23'),
(23, 'ffpatient', '3', 'validé', '#3bb320', 'check_box', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 11:25:23', '2024-05-03 11:25:23'),
(24, 'poc9', '1', 'Planifié', '#c8cbcc', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 21:21:42', '2024-05-03 21:21:42'),
(25, 'poc9', '2', 'En cours', '#3e7ff0', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 21:21:42', '2024-05-03 21:21:42'),
(26, 'poc9', '3', 'Terminé', '#18ab05', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 21:21:42', '2024-05-03 21:21:42'),
(27, 'poc11', '1', 'Planifié', '#aeb3b5', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 22:41:16', '2024-05-03 22:41:16'),
(28, 'poc11', '2', 'En cours', '#0c1ff2', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 22:41:16', '2024-05-03 22:41:16'),
(29, 'poc11', '3', 'Terminé', '#11ab23', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-03 22:41:16', '2024-05-03 22:41:16'),
(30, 'etudiant', '1', 'Créé', '#c6cccf', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-06 10:10:55', '2024-05-06 10:10:55'),
(31, 'etudiant', '2', 'En cours', '#1316e8', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-06 10:10:55', '2024-05-06 10:10:55'),
(32, 'etudiant', '3', 'Validé', '#02c22c', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-06 10:10:55', '2024-05-06 10:10:55'),
(33, 'projet', '1', 'Planifié', '#afb9bd', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-07 18:21:05', '2024-05-07 18:21:05'),
(34, 'projet', '2', 'En cours', '#0eb5ed', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-07 18:21:05', '2024-05-07 18:21:05'),
(35, 'projet', '3', 'Validé', '#04b846', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-07 18:21:05', '2024-05-07 18:21:05'),
(36, 'test2', '1', 'Créé', '#b9bcbd', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-10 10:43:51', '2024-05-10 10:43:51'),
(37, 'test2', '2', 'En cours', '#2024f7', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-10 10:43:51', '2024-05-10 10:43:51'),
(38, 'test2', '3', 'Validé', '#0aa34f', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-10 10:43:51', '2024-05-10 10:43:51'),
(39, 'test3', '1', 'Créé', '#acafb0', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-10 10:46:24', '2024-05-10 10:46:24'),
(40, 'test3', '2', 'En cours', '#070ff0', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-10 10:46:24', '2024-05-10 10:46:24'),
(41, 'test3', '3', 'Validé', '#20b342', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-10 10:46:24', '2024-05-10 10:46:24'),
(42, 'testqk2', '1', 'Créé', '#acb3b5', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-13 16:43:35', '2024-05-13 16:43:35'),
(43, 'testqk2', '2', 'En cours de validation', '#1756e8', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-13 16:43:35', '2024-05-13 16:43:35'),
(44, 'testqk2', '3', 'Validé', '#1ab031', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-13 16:43:35', '2024-05-13 16:43:35'),
(45, 'imputation', '1', 'Créé', '#b5b9ba', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-15 12:23:46', '2024-05-15 12:23:46'),
(46, 'imputation', '2', 'En cours de validation', '#10b0e6', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-15 12:23:46', '2024-05-15 12:23:46'),
(47, 'imputation', '3', 'validée', '#14b840', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-15 12:23:46', '2024-05-15 12:23:46'),
(48, 'test123', '1', 'Créé', '#959a9c', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-22 14:49:47', '2024-05-22 14:49:47'),
(49, 'test123', '2', 'En cours de validation', '#1f1cd9', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-22 14:49:47', '2024-05-22 14:49:47'),
(50, 'test123', '3', 'Validé', '#0e9619', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-05-22 14:49:47', '2024-05-22 14:49:47'),
(51, 'patient2', '1', 'Créé', '#a5adb0', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-06-13 09:14:12', '2024-06-13 09:14:12'),
(52, 'patient2', '2', 'En cours', '#3c9ade', 'av_timer', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-06-13 09:14:12', '2024-06-13 09:14:12'),
(53, 'patient2', '3', 'validé', '#20b34a', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-06-13 09:14:12', '2024-06-13 09:14:12'),
(54, 'reservation', '1', 'Créé', '#88898a', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-06-15 09:49:23', '2024-06-15 09:49:23'),
(55, 'reservation', '2', 'En cours de validation', '#0d93bf', 'av_timer', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-06-15 09:49:23', '2024-06-15 09:49:23'),
(56, 'reservation', '3', 'Validée', '#0cab1c', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-06-15 09:49:23', '2024-06-15 09:49:23'),
(57, 'testttt', '1', 'Planifié', '#c5d2d6', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-06-20 14:03:41', '2024-06-20 14:03:41'),
(58, 'testttt', '2', 'Validé', '#049123', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-06-20 14:03:41', '2024-06-20 14:03:41'),
(59, 'abdel', '1', 'Créé', '#2d84a1', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-07-02 08:53:56', '2024-07-02 08:53:56'),
(60, 'abdel', '2', 'vaa', '#175266', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-07-02 08:53:56', '2024-07-02 08:53:56'),
(61, 'badge', '1', 'Créé', '#b1c1c7', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-07-05 10:22:16', '2024-07-05 10:22:16'),
(62, 'badge', '2', 'En cours d\'attribution', '#2cb7e6', 'av_timer', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-07-05 10:22:16', '2024-07-05 10:22:16'),
(63, 'badge', '3', 'Attribué', '#4cb320', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-07-05 10:22:16', '2024-07-05 10:22:16'),
(64, 'dxcar', '1', 'Valider', '#20b345', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-08-23 09:58:54', '2024-08-23 09:58:54'),
(65, 'dxcar', '2', 'Annuler', '#f7ac34', 'cancel', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-08-23 09:58:54', '2024-08-23 09:58:54'),
(66, 'patient1', '1', 'en cours', '#b1b8ba', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-08-28 15:27:16', '2024-08-28 15:27:16'),
(67, 'patient1', '2', 'Validé', '#11a834', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-08-28 15:27:16', '2024-08-28 15:27:16'),
(68, 'test422', '1', 'En cours', '#7c8487', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-04 22:14:27', '2024-09-04 22:14:27'),
(69, 'test422', '2', 'Validé', '#3e8000', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-04 22:14:27', '2024-09-04 22:14:27'),
(70, 'test422', '3', 'nzihz', '#0555b0', 'add_shopping_cart', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-04 22:14:27', '2024-09-04 22:14:27'),
(71, 'patient44', '1', 'En cours', '#a4afb3', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-05 20:15:56', '2024-09-05 20:15:56'),
(72, 'patient44', '2', 'Validé', '#009e18', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-05 20:15:56', '2024-09-05 20:15:56'),
(73, 'patient44', '3', 'Rojdsodhj', '#009dd1', 'adjust', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-05 20:15:56', '2024-09-05 20:15:56'),
(74, 'patient78', '1', 'Créé', '#949da1', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-11 09:47:05', '2024-09-11 09:47:05'),
(75, 'patient78', '2', 'En cours de validation', '#006080', 'airline_seat_individual_suite', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-11 09:47:05', '2024-09-11 09:47:05'),
(76, 'patient78', '3', 'Validé', '#578000', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-11 09:47:05', '2024-09-11 09:47:05'),
(77, 'patient683', '1', 'En cours', '#728085', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-12 19:18:47', '2024-09-12 19:18:47'),
(78, 'patient683', '2', 'validé', '#51b320', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-12 19:18:47', '2024-09-12 19:18:47'),
(79, 'patient98', '1', 'Créé', '#929da1', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-25 15:54:51', '2024-09-25 15:54:51'),
(80, 'patient98', '2', 'En cours', '#006b8f', 'adjust', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-25 15:54:51', '2024-09-25 15:54:51'),
(81, 'patient98', '3', 'Terminé', '#63a100', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-09-25 15:54:51', '2024-09-25 15:54:51'),
(82, 'patient77', '1', 'En cours', '#677980', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-10-01 12:16:34', '2024-10-01 12:16:34'),
(83, 'patient77', '2', 'Validé', '#66ba00', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-10-01 12:16:34', '2024-10-01 12:16:34'),
(84, 'patient88', '1', 'en coyrs', '#afc1c7', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-10-01 19:13:01', '2024-10-01 19:13:01'),
(85, 'patient88', '2', 'vaidé', '#73b320', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-10-01 19:13:01', '2024-10-01 19:13:01'),
(86, 'ordremission', '1', 'Créé', '#939696', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-11-03 21:33:47', '2024-11-03 21:33:47'),
(87, 'ordremission', '2', 'Validé', '#5a8a00', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-11-03 21:33:47', '2024-11-03 21:33:47'),
(88, 'patientsa', '1', 'Créé', '#818b8f', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-11-12 13:25:43', '2024-11-12 13:25:43'),
(89, 'patientsa', '2', 'Validé', '#53a100', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-11-12 13:25:43', '2024-11-12 13:25:43'),
(90, 'patientsa', '3', 'T Validé', '#009fd4', 'adjust', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-11-12 13:25:43', '2024-11-12 13:25:43'),
(91, 'testphar', '1', 'En cours', '#7a888c', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-11-21 06:00:09', '2024-11-21 06:00:09'),
(92, 'testphar', '2', 'validé', '#46a100', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-11-21 06:00:09', '2024-11-21 06:00:09'),
(93, 'patient92', '1', 'Créé', '#757f82', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-11-21 19:50:28', '2024-11-21 19:50:28'),
(94, 'patient92', '2', 'Validé', '#00940f', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2024-11-21 19:50:28', '2024-11-21 19:50:28'),
(95, 'news', '1', 'Brouillon', '#83888a', 'edit', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 12:20:02', '2025-01-03 12:20:02'),
(96, 'news', '2', 'En validation', '#8fddf5', 'av_timer', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 12:20:02', '2025-01-03 12:20:02'),
(97, 'news', '3', 'Validée', '#007bff ', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 12:20:02', '2025-01-03 12:20:02'),
(98, 'news', '4', 'Publiée', '#3a9600', 'check_box', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-01-03 12:20:02', '2025-01-03 12:20:02'),
(99, 'patient667', '1', 'En cours', '#7b8487', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-02-15 20:06:12', '2025-02-15 20:06:12'),
(100, 'patient667', '2', 'Validé', '#58a100', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-02-15 20:06:12', '2025-02-15 20:06:12'),
(101, 'patient738', '1', 'Créé', '#798082', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-03-07 15:24:22', '2025-03-07 15:24:22'),
(102, 'patient738', '2', 'Validé', '#47b320', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-03-07 15:24:22', '2025-03-07 15:24:22'),
(103, 'pat6352', '1', 'Créé', '#939fa3', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-04-17 07:47:21', '2025-04-17 07:47:21'),
(104, 'pat6352', '2', 'En cours', '#208eb3', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-04-17 07:47:21', '2025-04-17 07:47:21'),
(105, 'patient6338', '1', 'Créé', '#98a0a3', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-05-22 17:04:10', '2025-05-22 17:04:10'),
(106, 'patient6338', '2', 'En cours', '#009dd1', 'airline_seat_recline_extra', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-05-22 17:04:10', '2025-05-22 17:04:10'),
(107, 'patient6338', '3', 'Validé', '#5aad00', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-05-22 17:04:10', '2025-05-22 17:04:10'),
(108, 'purchase', '1', 'Demande d\'achat créée', '#92999c', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(109, 'purchase', '2', 'Demande d\'achat reçue', '#7cc0d6', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(110, 'purchase', '3', 'Fournisseur / prestataire créé', '#004961', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(111, 'purchase', '4', 'Fournisseur / prestataire sélectionné', '#8bb320', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(112, 'purchase', '5', 'Consultation envoyée', '#b3ab20', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(113, 'purchase', '6', 'Offres / devis reçus', '#b32093', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(114, 'purchase', '7', 'Offres vérifiées', '#b32020', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(115, 'purchase', '8', 'Négociation en cours', '#188c88', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(116, 'purchase', '9', 'Bon de commande établi', '#3d20b3', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(117, 'purchase', '10', 'Bon de commande validé', '#004266', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(118, 'purchase', '11', 'Commande en traitement', '#d8e300', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(119, 'purchase', '12', 'Marchandise reçue', '#9820b3', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(120, 'purchase', '13', 'Réception contrôlée', '#b36c20', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(121, 'purchase', '14', 'Stock mis à jour', '#507b8a', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-06-16 08:21:46', '2025-06-16 08:21:46'),
(122, 'patient37763', '1', 'Créé', '#8d9496', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-07-14 21:14:08', '2025-07-14 21:14:08'),
(123, 'patient37763', '2', 'En cours', '#00639c', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-07-14 21:14:08', '2025-07-14 21:14:08'),
(124, 'patient37763', '3', 'Validé', '#4a9900', 'check_box', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-07-14 21:14:08', '2025-07-14 21:14:08'),
(125, 'patient72627', '1', 'Créé', '#8f989c', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-08-18 13:01:06', '2025-08-18 13:01:06'),
(126, 'patient72627', '2', 'En validation', '#2087b3', 'cached', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-08-18 13:01:06', '2025-08-18 13:01:06'),
(127, 'patient72627', '3', 'Validé', '#60b320', 'check_box', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-08-18 13:01:06', '2025-08-18 13:01:06'),
(128, 'patient99', '1', 'Créé', '#787e80', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-09-01 14:55:46', '2025-09-01 14:55:46'),
(129, 'patient99', '2', 'En validation', '#007196', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-09-01 14:55:46', '2025-09-01 14:55:46'),
(130, 'patient99', '3', 'Validé', '#6eb320', 'check_box', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-09-01 14:55:46', '2025-09-01 14:55:46'),
(131, 'patient66', '1', 'Créé', '#6d777a', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-10-08 14:12:37', '2025-10-08 14:12:37'),
(132, 'patient66', '2', 'En cours', '#2060b3', 'av_timer', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-10-08 14:12:37', '2025-10-08 14:12:37'),
(133, 'patient66', '3', 'Validé', '#73b320', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-10-08 14:12:37', '2025-10-08 14:12:37'),
(134, 'patient1310', '1', 'Créé', '#a4a9ab', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-10-13 14:56:58', '2025-10-13 14:56:58'),
(135, 'patient1310', '2', 'En cours', '#3d5dfc', 'av_timer', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-10-13 14:56:58', '2025-10-13 14:56:58'),
(136, 'patient1310', '3', 'Validé', '#4cb320', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-10-13 14:56:58', '2025-10-13 14:56:58'),
(137, 'patient56', '1', 'Créé', '#8c9091', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-12-02 17:35:30', '2025-12-02 17:35:30'),
(138, 'patient56', '2', 'En validation', '#00a1ba', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-12-02 17:35:30', '2025-12-02 17:35:30'),
(139, 'patient56', '3', 'Validdé', '#338000', 'check_box', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-12-02 17:35:30', '2025-12-02 17:35:30'),
(140, 'patient8397', '1', 'Créé', '#979a9c', 'add', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-12-03 14:42:53', '2025-12-03 14:42:53'),
(141, 'patient8397', '2', 'En validation', '#00aee8', 'check', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-12-03 14:42:53', '2025-12-03 14:42:53'),
(142, 'patient8397', '3', 'Validé', '#369900', 'check_box', NULL, NULL, 0, NULL, NULL, NULL, NULL, '2025-12-03 14:42:53', '2025-12-03 14:42:53');

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

--
-- Table structure for table `users_droits`
--

CREATE TABLE `users_droits` (
  `user_id` int DEFAULT NULL,
  `droit_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users_droits`
--

INSERT INTO `users_droits` (`user_id`, `droit_id`) VALUES
(10, 1),
(10, 2),
(10, 3),
(10, 1),
(10, 2),
(10, 3),
(10, 6),
(10, 7),
(10, 8),
(10, 9),
(10, 10),
(10, 11),
(10, 12),
(10, 1),
(10, 2),
(10, 3),
(10, 6),
(10, 7),
(10, 8),
(10, 9),
(10, 10),
(10, 11),
(10, 12),
(10, 1),
(10, 2),
(10, 1),
(10, 2),
(10, 1),
(10, 2),
(10, 3),
(10, 4),
(10, 5),
(10, 6),
(10, 7),
(10, 8),
(10, 9),
(10, 10),
(10, 11),
(10, 12),
(10, 13),
(10, 14),
(10, 15),
(10, 16),
(10, 17),
(10, 18),
(10, 19),
(10, 20),
(10, 21),
(10, 22),
(10, 23),
(10, 24),
(10, 25),
(10, 26),
(10, 27),
(10, 28),
(10, 29),
(10, 30),
(10, 31),
(10, 32),
(10, 33),
(10, 34),
(10, 35),
(10, 36),
(10, 37),
(10, 38),
(10, 39),
(10, 40),
(10, 41),
(10, 42),
(10, 43),
(10, 44),
(10, 45),
(10, 46),
(10, 47),
(10, 48),
(10, 49),
(10, 50),
(10, 51),
(10, 52),
(10, 53),
(10, 54),
(10, 55),
(10, 56),
(10, 57),
(10, 58),
(10, 59),
(10, 60),
(10, 61),
(10, 62),
(10, 63),
(10, 64),
(10, 65),
(10, 66),
(10, 67),
(10, 68),
(10, 69),
(10, 70),
(13, 2),
(13, 3),
(13, 6),
(13, 7),
(13, 8),
(13, 9),
(13, 10),
(13, 11),
(13, 12),
(13, 13),
(13, 14),
(13, 15),
(13, 16),
(13, 37),
(10, 1),
(10, 2),
(10, 3),
(10, 1),
(10, 2),
(10, 3),
(10, 6),
(10, 7),
(10, 8),
(10, 9),
(10, 10),
(10, 11),
(10, 12),
(10, 1),
(10, 2),
(10, 3),
(10, 6),
(10, 7),
(10, 8),
(10, 9),
(10, 10),
(10, 11),
(10, 12),
(10, 1),
(10, 2),
(10, 1),
(10, 2),
(10, 1),
(10, 2),
(10, 3),
(10, 4),
(10, 5),
(10, 6),
(10, 7),
(10, 8),
(10, 9),
(10, 10),
(10, 11),
(10, 12),
(10, 13),
(10, 14),
(10, 15),
(10, 16),
(10, 17),
(10, 18),
(10, 19),
(10, 20),
(10, 21),
(10, 22),
(10, 23),
(10, 24),
(10, 25),
(10, 26),
(10, 27),
(10, 28),
(10, 29),
(10, 30),
(10, 31),
(10, 32),
(10, 33),
(10, 34),
(10, 35),
(10, 36),
(10, 37),
(10, 38),
(10, 39),
(10, 40),
(10, 41),
(10, 42),
(10, 43),
(10, 44),
(10, 45),
(10, 46),
(10, 47),
(10, 48),
(10, 49),
(10, 50),
(10, 51),
(10, 52),
(10, 53),
(10, 54),
(10, 55),
(10, 56),
(10, 57),
(10, 58),
(10, 59),
(10, 60),
(10, 61),
(10, 62),
(10, 63),
(10, 64),
(10, 65),
(10, 66),
(10, 67),
(10, 68),
(10, 69),
(10, 70),
(13, 2),
(13, 3),
(13, 6),
(13, 7),
(13, 8),
(13, 9),
(13, 10),
(13, 11),
(13, 12),
(13, 13),
(13, 14),
(13, 15),
(13, 16),
(13, 37),
(10, 1),
(10, 2),
(10, 3),
(10, 1),
(10, 2),
(10, 3),
(10, 6),
(10, 7),
(10, 8),
(10, 9),
(10, 10),
(10, 11),
(10, 12),
(10, 1),
(10, 2),
(10, 3),
(10, 6),
(10, 7),
(10, 8),
(10, 9),
(10, 10),
(10, 11),
(10, 12),
(10, 1),
(10, 2),
(10, 1),
(10, 2),
(10, 1),
(10, 2),
(10, 3),
(10, 4),
(10, 5),
(10, 6),
(10, 7),
(10, 8),
(10, 9),
(10, 10),
(10, 11),
(10, 12),
(10, 13),
(10, 14),
(10, 15),
(10, 16),
(10, 17),
(10, 18),
(10, 19),
(10, 20),
(10, 21),
(10, 22),
(10, 23),
(10, 24),
(10, 25),
(10, 26),
(10, 27),
(10, 28),
(10, 29),
(10, 30),
(10, 31),
(10, 32),
(10, 33),
(10, 34),
(10, 35),
(10, 36),
(10, 37),
(10, 38),
(10, 39),
(10, 40),
(10, 41),
(10, 42),
(10, 43),
(10, 44),
(10, 45),
(10, 46),
(10, 47),
(10, 48),
(10, 49),
(10, 50),
(10, 51),
(10, 52),
(10, 53),
(10, 54),
(10, 55),
(10, 56),
(10, 57),
(10, 58),
(10, 59),
(10, 60),
(10, 61),
(10, 62),
(10, 63),
(10, 64),
(10, 65),
(10, 66),
(10, 67),
(10, 68),
(10, 69),
(10, 70),
(13, 2),
(13, 3),
(13, 6),
(13, 7),
(13, 8),
(13, 9),
(13, 10),
(13, 11),
(13, 12),
(13, 13),
(13, 14),
(13, 15),
(13, 16),
(13, 37);

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

--
-- Table structure for table `workflow`
--

CREATE TABLE `workflow` (
  `id` int NOT NULL,
  `code` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `row_id` int DEFAULT NULL,
  `statut` int DEFAULT NULL,
  `user` int DEFAULT NULL,
  `date` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `commentaire` text COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `workflow`
--

INSERT INTO `workflow` (`id`, `code`, `row_id`, `statut`, `user`, `date`, `commentaire`) VALUES
(1, 'testttt', 1, 1, 1, '2024-06-20 14:03', NULL),
(2, 'testttt', 1, 2, 1, '2024-06-20 14:04', NULL),
(3, 'badge', 1, 1, 1, '2024-07-05 10:25', NULL),
(4, 'badge', 1, 2, 1, '2024-07-05 10:25', NULL),
(5, 'dxcar', 1, 1, 1, '2024-08-23 09:59', NULL),
(6, 'patient1', 1, 1, 1, '2024-08-28 15:27', NULL),
(7, 'patient1', 1, 2, 1, '2024-08-28 15:28', NULL),
(8, 'test422', 1, 1, 1, '2024-09-04 22:14', NULL),
(9, 'test422', 1, 2, 1, '2024-09-04 22:14', NULL),
(10, 'patient44', 1, 1, 1, '2024-09-05 20:18', NULL),
(11, 'patient44', 1, 2, 1, '2024-09-05 20:19', NULL),
(12, 'patient44', 2, 1, 1, '2024-09-05 20:19', NULL),
(13, 'patient44', 1, 3, 1, '2024-09-05 20:19', NULL),
(14, 'patient78', 1, 1, 1, '2024-09-11 09:49', NULL),
(15, 'patient78', 1, 2, 1, '2024-09-11 09:49', NULL),
(16, 'patient78', 2, 1, 1, '2024-09-11 09:49', NULL),
(17, 'patient78', 2, 2, 1, '2024-09-11 09:50', NULL),
(18, 'patient78', 2, 3, 1, '2024-09-11 09:50', NULL),
(19, 'patient683', 1, 1, 1, '2024-09-12 19:20', NULL),
(20, 'patient683', 1, 2, 1, '2024-09-12 19:20', NULL),
(21, 'patient98', 1, 1, 1, '2024-09-25 15:55', NULL),
(22, 'patient98', 1, 2, 1, '2024-09-25 15:56', NULL),
(23, 'patient98', 2, 1, 1, '2024-09-25 15:56', NULL),
(24, 'patient98', 1, 3, 1, '2024-09-25 15:56', NULL),
(25, 'patient77', 1, 1, 1, '2024-10-01 12:17', NULL),
(26, 'patient77', 1, 2, 1, '2024-10-01 12:17', NULL),
(27, 'patient77', 2, 1, 1, '2024-10-01 12:17', NULL),
(28, 'patient88', 1, 1, 1, '2024-10-01 19:13', NULL),
(29, 'patient88', 1, 2, 1, '2024-10-01 19:13', NULL),
(30, 'patient88', 2, 1, 1, '2024-10-01 19:14', NULL),
(31, 'patientsa', 1, 1, 1, '2024-11-12 13:26', NULL),
(32, 'patientsa', 1, 2, 1, '2024-11-12 13:26', NULL),
(33, 'testphar', 1, 1, 1, '2024-11-21 06:00', NULL),
(34, 'patient92', 1, 1, 1, '2024-11-21 19:51', NULL),
(35, 'patient92', 1, 2, 1, '2024-11-21 19:51', NULL),
(36, 'news', 1, 1, 1, '2025-01-03 12:34', NULL),
(37, 'news', 2, 1, 1, '2025-01-03 12:38', NULL),
(38, 'news', 3, 1, 1, '2025-01-03 12:40', NULL),
(39, 'news', 3, 2, 1, '2025-01-03 12:41', NULL),
(40, 'news', 3, 3, 1, '2025-01-03 12:41', NULL),
(41, 'news', 3, 4, 1, '2025-01-03 12:41', NULL),
(42, 'news', 4, 1, 1, '2025-01-03 12:46', NULL),
(43, 'news', 5, 1, 1, '2025-01-03 12:46', NULL),
(44, 'news', 4, 2, 1, '2025-01-03 12:46', NULL),
(45, 'news', 1, 2, 1, '2025-01-03 12:47', NULL),
(46, 'news', 1, 3, 1, '2025-01-03 12:47', NULL),
(47, 'news', 5, 2, 1, '2025-01-03 12:47', NULL),
(48, 'news', 5, 3, 1, '2025-01-03 12:47', NULL),
(49, 'patient667', 1, 1, 1, '2025-02-15 20:07', NULL),
(50, 'patient667', 1, 2, 1, '2025-02-15 20:08', NULL),
(51, 'patient738', 1, 1, 1, '2025-03-07 15:25', NULL),
(52, 'patient738', 1, 2, 1, '2025-03-07 15:27', NULL),
(53, 'pat7483', 1, 1, 1, '2025-04-17 07:46', NULL),
(54, 'pat6352', 1, 1, 1, '2025-04-17 07:47', NULL),
(55, 'pat6352', 1, 2, 1, '2025-04-17 07:47', NULL),
(56, 'patient6338', 1, 1, 1, '2025-05-22 17:05', NULL),
(57, 'patient6338', 1, 2, 1, '2025-05-22 17:06', NULL),
(58, 'patient6338', 1, 3, 1, '2025-05-22 17:06', NULL),
(59, 'patient37763', 1, 1, 1, '2025-07-14 21:15', NULL),
(60, 'patient37763', 1, 2, 1, '2025-07-14 21:16', NULL),
(61, 'patient37763', 1, 3, 1, '2025-07-14 21:16', NULL),
(62, 'patient37763', 2, 1, 1, '2025-07-14 21:17', NULL),
(63, 'patient37763', 2, 2, 1, '2025-07-14 21:17', NULL),
(64, 'patient37763', 2, 3, 1, '2025-07-14 21:17', NULL),
(65, 'patient72627', 1, 1, 1, '2025-08-18 13:01', NULL),
(66, 'patient72627', 1, 2, 1, '2025-08-18 13:05', NULL),
(67, 'patient72627', 1, 3, 1, '2025-08-18 13:05', NULL),
(68, 'patient99', 1, 1, 1, '2025-09-01 14:59', NULL),
(69, 'patient99', 1, 2, 1, '2025-09-01 14:59', NULL),
(70, 'patient99', 1, 3, 1, '2025-09-01 14:59', NULL),
(71, 'patient66', 1, 1, 1, '2025-10-08 14:14', NULL),
(72, 'patient66', 1, 2, 1, '2025-10-08 14:15', NULL),
(73, 'patient66', 1, 3, 1, '2025-10-08 14:15', NULL),
(74, 'patient1310', 1, 1, 1, '2025-10-13 14:58', NULL),
(75, 'patient1310', 1, 2, 1, '2025-10-13 14:58', NULL),
(76, 'patient1310', 1, 3, 1, '2025-10-13 14:58', NULL),
(77, 'patient56', 1, 1, 1, '2025-12-02 17:38', NULL),
(78, 'patient56', 1, 2, 1, '2025-12-02 17:38', NULL),
(79, 'patient56', 1, 3, 1, '2025-12-02 17:38', NULL),
(80, 'patient8397', 1, 1, 1, '2025-12-03 14:44', NULL),
(81, 'patient8397', 1, 2, 1, '2025-12-03 14:44', NULL),
(82, 'patient8397', 1, 3, 1, '2025-12-03 14:44', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
  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 `fonctionnalites`
--
ALTER TABLE `fonctionnalites`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `fonctionnalites`
--
ALTER TABLE `fonctionnalites`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=160;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=272;

--
-- AUTO_INCREMENT for table `parameters`
--
ALTER TABLE `parameters`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ressources`
--
ALTER TABLE `ressources`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `skineditors`
--
ALTER TABLE `skineditors`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `statuts`
--
ALTER TABLE `statuts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=143;

--
-- AUTO_INCREMENT for table `workflow`
--
ALTER TABLE `workflow`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;
COMMIT;

