-- https://www.phpmyadmin.net/
--
-- Hôte : localhost
-- Généré le : mer. 04 Déc. 2024 à 07:22
-- Version du serveur : 8.0.35-0ubuntu0.23.04.1
-- Version de PHP : 8.1.12-1ubuntu4.3

START TRANSACTION;



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

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

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

--
-- Déchargement des données de la 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');

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

--
-- Structure de la table `failed_jobs`
--

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

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

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

--
-- Déchargement des données de la 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, 0, NULL, NULL, NULL, NULL, '2024-05-15 12:33:57', '2024-05-15 12:33:57'),
(18, 'test', NULL, 0, NULL, NULL, NULL, NULL, '2024-05-22 14:41:39', '2024-05-22 14:41:39'),
(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');

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

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

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

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

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

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

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

INSERT INTO `fonctionnalites_routes` (`fonctionnalite_id`, `route`) VALUES
(2, 'admin');

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

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

--
-- Déchargement des données de la 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', '2024-05-14 09:08:52'),
(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'),
(107, 'patient', 'patient1_list', NULL, '1', NULL, '1', 'menu', NULL, NULL, 1, '2024-08-29 17:03:55', 1, NULL, NULL, '2024-08-28 15:30:07', '2024-08-29 17:03:55'),
(108, 'Group S', 'grps_list', '59', '1', NULL, '1', 'menu', NULL, NULL, 1, '2024-09-05 20:07:09', 1, NULL, NULL, '2024-09-04 22:10:43', '2024-09-05 20:07:09'),
(109, 'Gestion des tyupe', 'typeassura_list', '59', '1', NULL, '1', 'menu', NULL, NULL, 1, '2024-09-11 09:36:56', 1, NULL, NULL, '2024-09-05 20:11:26', '2024-09-11 09:36:56'),
(110, 'Gestion des patients', 'patient44_list', NULL, '1', NULL, '1', 'aspect_ratio', NULL, NULL, 1, '2024-09-11 09:36:45', 1, NULL, NULL, '2024-09-05 20:16:25', '2024-09-11 09:36:45'),
(114, 'Gestion des group', 'groups10_list', '59', '1', NULL, '1', 'menu', NULL, NULL, 1, '2024-09-25 15:45:10', 1, NULL, NULL, '2024-09-12 19:20:10', '2024-09-25 15:45:10'),
(115, 'Gestion des patients', 'patient683_list', NULL, '1', NULL, '1', 'adjust', NULL, NULL, 1, '2024-09-25 15:45:01', 1, NULL, NULL, '2024-09-12 19:20:36', '2024-09-25 15:45:01'),
(116, 'Types d\'assurance', 'typeassur8_list', '59', '1', NULL, '1', 'mms', NULL, NULL, 1, '2024-10-01 12:04:54', 1, NULL, NULL, '2024-09-25 15:50:10', '2024-10-01 12:04:54'),
(122, 'Type d\'assurance', 'typassursa_list', '59', '1', NULL, '1', 'menu', NULL, NULL, 1, '2024-11-13 09:44:09', 1, NULL, NULL, '2024-11-12 13:21:36', '2024-11-13 09:44:09'),
(123, 'Gestion des patients', 'patientsa_list', NULL, '1', NULL, '1', 'person', NULL, NULL, 1, '2024-11-13 09:44:03', 1, NULL, NULL, '2024-11-12 13:26:08', '2024-11-13 09:44:03'),
(124, 'Type assurances', 'typeassur92_list', '59', '1', NULL, '1', 'menu', NULL, NULL, 1, '2024-12-04 07:13:17', 1, NULL, NULL, '2024-11-21 19:47:11', '2024-12-04 07:13:17'),
(125, 'Gestion des patients', 'patient92_list', NULL, '1', NULL, '1', 'person', NULL, NULL, 1, '2024-12-04 07:13:12', 1, NULL, NULL, '2024-11-21 19:51:08', '2024-12-04 07:13:12');

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

--
-- Structure de la table `migrations`
--

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '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);

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

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

--
-- Déchargement des données de la 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');

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

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

--
-- Déchargement des données de la 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');

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

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

--
-- Déchargement des données de la 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);

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

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

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

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

--
-- Déchargement des données de la 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, 19);

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

--
-- Structure de la table `sites`
--

CREATE TABLE `sites` (
  `id` bigint UNSIGNED NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 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;

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

--
-- Structure de la table `skineditors`
--

CREATE TABLE `skineditors` (
  `id` bigint UNSIGNED NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statut` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_login` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `logo_login` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bg_login` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `css_login` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_mini` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_layout` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_sidebar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_sidebar_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_sidebar_menu_active` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_sidebar_menu_active_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `layout_css` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `desc` varchar(255) CHARACTER SET utf8mb4 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;

--
-- Déchargement des données de la 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', '1', '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', '2024-12-04 07:17:40');

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

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

--
-- Déchargement des données de la 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');

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

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

--
-- Déchargement des données de la 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);

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

--
-- Structure de la 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `commentaire` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la 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);

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

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

--
-- Index pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT pour la table `workflow`
--
ALTER TABLE `workflow`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
COMMIT;

