-- Table structure for table `ops_action_statut_audit`
--

CREATE TABLE `ops_action_statut_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_action_statut_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_action_statut_audit`
--

INSERT INTO `ops_action_statut_audit` VALUES ('a2d60645-98c9-4b23-a782-68b94d5b49d5','d14d59d9-52de-ab4d-e317-68b94df03f21','2025-09-04 08:28:35','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','ordre','int','1','3',NULL,NULL);

--
-- Table structure for table `ops_action_statut_ops_statut`
--

CREATE TABLE `ops_action_statut_ops_statut` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_statut_id` varchar(36) DEFAULT NULL,
  `ops_action_statut_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_action_statut_ops_statut_ida1` (`ops_statut_id`),
  KEY `ops_action_statut_ops_statut_alt` (`ops_action_statut_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_action_statut_ops_statut`
--

INSERT INTO `ops_action_statut_ops_statut` VALUES ('ec00adc7-30f0-d816-9822-6425e4c9f091','2023-03-30 19:37:02',0,'4b5d7cdf-adfb-e9ea-5d7c-6425e48b669d','e9aec68e-5e00-be02-59f2-6425e46fa5a0'),('99ef2466-d6e2-a20f-e323-6425f193f894','2023-03-30 20:32:04',0,'50abeb75-a604-7e27-ada9-6425f11c2695','97ebc4c1-3467-67ba-24b3-6425f183d037'),('16628173-e5d4-4a51-f36b-643ab08f66d0','2024-08-30 15:14:49',1,'82ccb426-84a3-a39d-9e00-643961fc11d2','13c742ac-e4ea-ccbb-43cf-643ab0d21507'),('45fd0ce5-421a-f571-caf4-643ab226ab96','2024-08-30 15:14:49',1,'7bc6074b-4d25-9c22-7234-6439613f5f30','43b85234-efaf-ff8d-3431-643ab2bc496e'),('892301e0-5aa0-06e9-439d-643ab24eb9d2','2023-11-04 08:30:21',1,'7d8daf9e-8cc8-686d-f35f-6439610a7777','86a91640-f6e9-04ab-e4a3-643ab204c849'),('1b46c400-6f97-c665-f24a-643bdee06c77','2023-11-04 08:30:21',1,'7d8daf9e-8cc8-686d-f35f-6439610a7777','189b6009-e5db-0888-e650-643bdedba4c8'),('d0d40731-ff53-8bf1-17fc-643d35e12ae5','2023-04-17 12:01:38',0,'92eaed35-4d69-1d05-753c-643d341bd590','ce34d868-4636-25d0-7f74-643d35f487e2'),('ccf56a56-deeb-a3ea-53b9-643fd8358be3','2024-08-30 15:14:49',1,'d1d30477-249f-476f-213d-643fd81efe73','c9fef6fe-5888-a3bf-9de9-643fd8a923b6'),('ce473045-015c-a05f-750d-643fde75f410','2024-08-30 15:14:49',1,'ce71136e-6c82-9433-00ce-643fddaf4cfa','cbd1b22b-8847-b4b4-e9f7-643fde60a3b4'),('464a7a2a-5530-071a-9b79-64a7096eacc7','2024-08-30 15:14:49',1,'c9507ba3-d740-bfa3-c71a-64a7091d5251','407cf4d8-2dae-d1f1-1788-64a709e8cf0d'),('dbc2e5d8-fc35-c979-2b67-64a7bb9d1d07','2023-11-04 08:41:38',1,'ce71136e-6c82-9433-00ce-643fddaf4cfa','d902c665-9ceb-3f25-6465-64a7bb148d34'),('28ebe8b9-e042-c724-d476-65099fb9e757','2023-09-19 13:19:34',0,'1a01579f-c927-73d3-921b-6421f427b99c','269382b8-8e64-58ce-64a8-65099f2d47fd'),('b9523eb4-4274-b4b9-9adf-6509a0b5df58','2023-09-19 13:20:46',0,'1e8ab9b6-a770-7105-782c-6421f40eacc1','b7299034-8f39-ad90-688a-6509a0f40d82'),('f2bdbca8-8ac2-e078-6a4e-654618d13c17','2023-11-04 10:08:38',0,'8d3712b5-0b70-6e7d-02df-6439618a36f5','efeffad7-5da3-92f4-443f-6546189e82f8'),('e38614aa-dc22-847c-1a4d-655b1193aff1','2023-11-20 07:58:11',0,'e87fa96b-df4a-85cd-df68-655b0e5801b5','e1153024-cfca-87fc-381a-655b113ac57a'),('867ad04e-7bb9-e23c-c497-655b12e7594c','2023-11-20 08:01:25',0,'8d3712b5-0b70-6e7d-02df-6439618a36f5','841ad90c-6a80-7ff8-7266-655b12c0031e'),('91d6e5fd-9c88-d512-7042-659131424a18','2023-12-31 09:16:00',0,'7bd61880-a532-a975-39ba-65913180532e','819fa6f0-94a8-0be0-0395-659131f74302'),('9bcb4840-ee39-d41f-dfe0-6591318929f4','2023-12-31 09:16:00',0,'92b13109-d9cd-2762-69ac-65913129a52a','977cf537-40c0-132b-1f6d-6591311b3c6e'),('af3fb820-7281-39d6-20e5-6591311ffb85','2023-12-31 09:16:00',0,'9c5bd2d3-9966-8d67-0f7a-6591310b56fe','a162f3ca-72c8-c5c1-eaad-6591310e260f'),('b798266a-894a-3ef2-22ca-659131da3f59','2023-12-31 09:16:00',0,'9c5bd2d3-9966-8d67-0f7a-6591310b56fe','b025477b-d050-874a-f593-65913179162a'),('bbdf76d8-a671-e3fb-8ffb-659131c8084c','2023-12-31 09:16:00',0,'9c5bd2d3-9966-8d67-0f7a-6591310b56fe','b8ad323d-8aac-ff4d-769f-659131b666e0'),('d2d338d9-9f69-afb2-e876-659131db29ae','2023-12-31 09:16:00',0,'bf535c0a-5b74-8ddb-8633-6591318f81d5','c387933e-6e2b-73cc-008b-65913182a07f'),('dd4e5ee4-391e-c2aa-8133-659131fb1825','2023-12-31 09:16:00',0,'d376baba-b7e2-4019-7f2c-659131db8887','d9675e0b-9c34-ed1c-e0b6-6591313184ad'),('e8880829-aba7-9a10-75de-65913131f0f9','2023-12-31 09:16:00',0,'de127f15-d9eb-db71-16dc-65913147323e','e3cb73c8-b913-160f-e764-659131ce6f70'),('447e0823-5657-986f-2d40-659131b2b8bd','2023-12-31 09:16:00',0,'ec7a52d2-819e-f10a-4e98-659131d2ee64','f33ad01b-d5c4-da5d-9119-6591318ed746'),('1ce92476-bf41-d992-bd85-659131800733','2023-12-31 09:16:00',0,'a378035a-1956-540a-9a3e-65913111f9a9','e6ce0d04-0413-aaa0-1bce-65913183f147'),('21cc3f73-c017-b9a2-c85b-6591319bdfe4','2023-12-31 09:16:00',0,'a378035a-1956-540a-9a3e-65913111f9a9','1e10c443-740b-4b4b-8332-659131fc6966'),('2511a396-cfc6-9d2f-89ee-65913103e75d','2023-12-31 09:16:00',0,'a378035a-1956-540a-9a3e-65913111f9a9','228ae80e-f1f8-1496-6d3c-659131f0e6e8'),('2fd8c12b-8200-3936-5f84-6591319fc9db','2023-12-31 09:16:00',0,'28dc0e3d-cb12-40de-3665-659131ae5061','2d39e3eb-85c2-23f2-ac74-65913154146f'),('3487fa17-1e93-839c-47cb-6591318c3f9c','2023-12-31 09:16:00',0,'28dc0e3d-cb12-40de-3665-659131ae5061','30eb9ac6-d4cb-43a1-2223-65913190fba0'),('3980937b-1840-3e2b-dbc8-659131349f19','2023-12-31 09:16:00',0,'28dc0e3d-cb12-40de-3665-659131ae5061','359e716e-67d0-2ca4-1011-6591311149e8'),('bee6fd8c-3fca-0cfd-9328-65bfd20e74ae','2024-03-17 08:16:08',1,'52eaa887-fd99-4f81-ad3a-65bfd1a70757','bb4dfd94-f200-b0c5-28e6-65bfd2fe78c6'),('8ab4259a-ca00-45a8-da60-65bfd9a424bb','2024-02-04 18:36:30',0,'7904d095-137e-22fa-8757-65bfd1b2fe4a','884f6eac-8234-068f-5444-65bfd93213c2'),('8e357e0d-a6b5-d561-c0af-65c058eaa6bd','2024-03-17 08:11:49',1,'64af7d27-0f95-8a24-beee-65bfd11db678','8bf5f5b6-f1a9-6072-42a5-65c058978251'),('b9959752-3c03-d582-7a0b-65f2e29ef475','2024-03-14 11:43:31',0,'2f30290f-8d28-9458-c0c8-65f2e2acadc0','b6b4a50c-c69d-93d9-982c-65f2e2be388e'),('38aa384c-54d7-118a-b66e-65f6a4d7f7cc','2024-03-17 08:07:21',0,'7904d095-137e-22fa-8757-65bfd1b2fe4a','35a112b9-d74a-0cc4-f3c8-65f6a4e71ee7'),('ff6102d5-cd26-b588-52e6-65f6a672094f','2024-03-17 08:13:28',0,'75a909c1-5d71-0731-1558-65f6a5e58851','db390a71-d8ad-334f-3ff6-65f6a650c115'),('75ec6885-282d-2142-1d5d-65f6a7dcfb83','2024-03-17 08:18:42',0,'211f9023-a0ad-133d-01c1-65f6a76e928c','738dcd43-e195-f904-3702-65f6a7868f82'),('72e30d9b-e95c-ce2b-e8f8-65f6acf3ab36','2024-03-17 08:42:08',0,'3fa5bd1c-d7cf-40c4-a35f-65f6acc85fac','6eb62270-d8cf-110f-a2f4-65f6ac8ea2d4'),('8fcfb878-0ae5-f7b5-8a69-65f6ad091d2e','2024-03-17 08:42:43',0,'3fa5bd1c-d7cf-40c4-a35f-65f6acc85fac','8d64f6fe-bd67-c3a5-d366-65f6adea0471'),('48ab0fa3-84f9-8c35-ad2d-6605941a5279','2024-03-28 16:02:58',0,'42692445-b4a9-e81f-3f92-660594169b15','453891aa-8535-afdc-fd7e-6605943f0329'),('4d91e153-cd23-d146-3abf-66059477a809','2024-03-28 16:02:58',0,'4965cef4-8e03-ccc4-9e93-660594fa0f6c','4be856d9-ec8d-9095-d5fb-6605948c97ee'),('525f8674-7d3e-4e94-ad71-660594355c47','2024-03-28 16:02:58',0,'4e35552f-31b9-7e76-0c71-660594ba48fc','50acee6f-56ec-6c49-7cc2-660594f93d43'),('5742faaf-ab61-f688-a93e-660594bf48b5','2024-03-28 16:02:58',0,'530cc413-3bc3-0eb9-af11-660594663af7','55951a5a-de84-a082-ea0c-660594267232'),('5c72b967-37e9-2c82-e4a7-660594e51b62','2024-03-28 16:02:58',0,'57f5f43e-2ae6-cfa8-5ae9-660594dd04a1','5ab1fe7d-5d0d-48df-73c7-660594c94e16'),('6e5bfc3d-03af-8ffd-7eaa-66059474044c','2024-03-28 16:02:58',0,'6a4e9ef2-dcfc-f465-453c-66059401de65','6cb008ca-35c4-4f55-b664-660594f6c902'),('7316356f-f977-0cbc-1b83-660594f45f25','2024-03-28 16:02:58',0,'6f034b6e-0b06-5de9-1f4b-660594a2eee1','7171e267-2ede-63bb-93db-660594ffdb3c'),('7effdcb5-b91e-dc3b-c676-660594a2b5c6','2024-03-28 16:02:58',0,'789ff9e1-f529-c0f9-60d7-6605946bed1c','7c4f754e-7b9d-7bf3-c262-6605949d262c'),('82aa15a2-2624-f7f5-c572-660594bcc8fe','2024-03-28 16:02:58',0,'789ff9e1-f529-c0f9-60d7-6605946bed1c','80255cef-5e60-7adb-37b4-66059499aad0'),('89714d6f-8ead-5dd3-0dd3-660594f6be84','2024-03-28 16:02:58',0,'836a2373-4b7f-f8a9-18d6-660594a0543a','867297da-1d9f-9a48-3874-6605949ce518'),('9582293b-9f20-91f2-87f3-66059485badd','2024-03-28 16:02:58',0,'90b0351d-0ac4-5eff-151a-6605944ed1b8','93a51369-3867-4de0-0206-66059473abb4'),('9893b18e-937c-5cda-b1d0-6605944c5871','2024-03-28 16:02:58',0,'90b0351d-0ac4-5eff-151a-6605944ed1b8','969ede3c-1711-113d-0baf-6605945c5122'),('a2bf60e9-36e3-5831-f0a9-6605940ca8c2','2024-03-28 16:02:58',0,'9e2eaefb-bdc3-ba4d-6d70-66059407c841','a0e526e1-cb88-b8a1-c1a3-660594a955cf'),('a818fc46-3536-d280-3ea5-6605945561d1','2024-03-28 16:02:58',0,'a378c871-b168-695e-1945-6605946faae3','a62beee2-c8af-3935-01d2-66059454fed1'),('bcb48da7-8b5c-ce98-ad4b-66059465a7ab','2024-03-28 16:02:58',0,'b7d6a495-ca61-1eff-6a21-660594c2545c','bac4260d-2596-6f32-ca5c-66059429fee3'),('c1e8a149-f5bb-e63f-2ac7-660594f22f22','2024-03-28 16:02:58',0,'bd5dd908-2ab0-898e-abc3-6605948dc7cf','c026c825-6f31-64e1-f38c-660594310a09'),('c7069b78-2ec3-c35b-cad0-660594553f1b','2024-03-28 16:02:58',0,'c29bd117-e4e9-d81e-0000-6605949f1efe','c546c607-df97-9865-f021-66059491ac5a'),('c98d1c58-0552-31ae-4e18-66059479740f','2024-03-28 16:02:58',0,'c29bd117-e4e9-d81e-0000-6605949f1efe','c7d6c681-9537-9258-dece-6605943710f3'),('cea1b032-8810-eb67-758d-66059487aa20','2024-03-28 16:02:58',0,'ca3f1b35-b065-53c4-a77b-660594fd524a','ccd7a3c4-b36d-9b73-6a68-660594225ad0'),('d1697971-120e-e206-d393-660594cdb95b','2024-03-28 16:02:58',0,'ca3f1b35-b065-53c4-a77b-660594fd524a','cf972ac7-be7e-cc33-ba29-6605949dab70'),('d426abb1-160a-b2eb-eadc-660594fca052','2024-03-28 16:02:58',0,'ca3f1b35-b065-53c4-a77b-660594fd524a','d25c2fc6-68b7-a02c-76ed-660594a19827'),('d6abea86-25d4-5a29-84ee-66059424ae2f','2024-03-28 16:02:58',0,'ca3f1b35-b065-53c4-a77b-660594fd524a','d4edf430-a385-96d4-409e-66059428aa1b'),('d95f330f-e8c4-d476-6e0c-660594f7fb8e','2024-03-28 16:02:58',0,'ca3f1b35-b065-53c4-a77b-660594fd524a','d7a4d74f-c0d8-6b7a-878c-660594f0ad11'),('e0b3adbf-dc9b-3b8c-e24c-660594766fa1','2024-03-28 16:02:58',0,'dc01f7cc-2a96-a2dd-d530-660594ab186c','df051091-06a4-3b92-c864-660594c28be8'),('e34ce198-2c6d-d408-e1cb-660594190966','2024-03-28 16:02:58',0,'dc01f7cc-2a96-a2dd-d530-660594ab186c','e1a61c35-cdab-18b8-7598-6605945dbcb4'),('e5f0f78d-537b-8dd2-f108-6605945ce346','2024-03-28 16:02:58',0,'dc01f7cc-2a96-a2dd-d530-660594ab186c','e45913c2-52dc-b173-0e33-660594a44464'),('aa6978d7-ef67-8a87-3fa2-66165c90d141','2024-04-10 09:32:07',0,'1a01579f-c927-73d3-921b-6421f427b99c','a74d3d6e-942f-69dc-fe01-66165c07e874'),('abfa2eaf-a64e-d1c2-49e4-6622397c507c','2024-04-19 09:29:07',0,'bf327162-55c2-2a50-5f19-662237376095','aa41a9ad-1803-074f-3a4f-6622397f6a9f'),('c1c75adc-aa77-980b-62a8-66223ac36647','2024-04-19 09:33:16',0,'2901bbf9-508d-09e2-d090-6622386d5f83','bf4ed4ae-5143-3544-b2b2-66223a38b108'),('575e6c67-e294-ed85-468a-6632778cc586','2024-05-01 17:11:26',0,'4c54f642-5345-f84e-c619-663277f2ff87','50ad3a95-64b7-bd14-ff8b-663277bbc6e8'),('795b53b7-04c8-690f-a180-6632775bf620','2024-05-01 17:11:26',0,'5fec33bf-277b-370f-8ed2-663277759af0','636c583e-759d-41e4-7f99-663277be4bda'),('9c160bda-4439-5f02-4dbf-66327783eab3','2024-05-01 17:11:26',0,'9199277a-308d-bdea-796e-6632773b555c','97dea05e-5a3b-12ec-7102-66327718bb42'),('a0963c20-88df-1056-928c-66327764fb8d','2024-05-01 17:11:26',0,'9199277a-308d-bdea-796e-6632773b555c','9cc63274-f5b7-f689-9507-663277ee7cf4'),('b115a9c6-9b3e-07a0-b6dd-663277a6bc02','2024-05-01 17:11:26',0,'aa520a73-5b82-3179-9698-6632778c4609','ae357b5a-e693-e499-3f71-663277f105b0'),('bb58313d-0f12-d591-b169-663277161741','2024-05-01 17:11:26',0,'b4837a54-e8c5-21dd-1d64-6632772024a5','b899dabc-7d1c-f554-7c3a-663277472ee1'),('b746a477-a323-71a8-ca8f-66339631318f','2024-05-02 13:33:06',0,'ae86abf5-c06a-4e86-540f-663396e9bf2a','b3ace4af-d6d1-60d2-473b-6633961d0a41'),('ed1d6552-45d8-0fc6-48e4-663396d78ce8','2024-05-02 13:33:06',0,'cf0c8cd9-c782-33e2-140c-663396bb3c43','e7714742-700c-e51f-be92-6633962ee1be'),('1275af00-770c-d19e-6e1f-66339673b97b','2024-05-02 13:33:06',0,'944d019d-6a92-0eea-2c01-663396226f0b','e8290e65-f148-9e9c-dbbe-66339628f338'),('1b46a790-41ca-db68-0c10-66339600aa19','2024-05-02 13:33:06',0,'130667ca-e7a4-efff-d2f6-66339604581c','182b6726-7c1c-210e-8b45-663396f1ff56'),('7e0227ed-07fc-c1b9-1979-66348bb84bdc','2024-05-03 07:01:53',0,'9cc0091b-58ba-8b44-2a23-6633abd01f82','7a9c44d3-17b2-a657-178b-66348bdbffbd'),('d7ce4e0d-1cfb-fca7-1f70-66348c839c33','2024-05-03 07:02:35',0,'6f15ed19-eeec-1487-e377-6633ab681caf','d579ab64-c4d0-2428-94d2-66348c48ddb7'),('60c60984-69d8-33c3-43cb-66348c8de325','2024-05-03 07:03:23',0,'e603b874-98b3-babf-9355-6633ab9afc8b','5ea7c4df-90ef-976c-a53e-66348c646656'),('599d9d1f-1124-088d-fbbf-66348caa743d','2024-05-03 07:03:53',0,'91853f1a-ffcb-41f4-7eda-6633ac8c114a','57952ba6-736b-b833-0e6b-66348cd2a2e6'),('88f133b2-1b31-0183-adce-66348c29c717','2024-05-03 07:04:38',0,'4d19d221-fbb2-7fb1-18b9-6633ac55e118','870ba45d-ec59-4e51-0422-66348ccd1d7f'),('5498cbdd-1e71-5d59-eb9f-66348cfb1585','2024-05-03 07:05:15',0,'a41030aa-60a2-d191-02e6-6633acad0a03','5291027e-71d3-26e7-7a7e-66348c2106c3'),('88187b0e-0414-f4ad-4798-66348c3cd5d4','2024-05-03 07:05:51',0,'dbf24cb1-4b1d-d42a-c819-6633b227b50c','86459e58-2a36-3c24-661e-66348cbd2730'),('ebf7e1de-ee15-1c8c-b830-66348c5a588f','2024-05-03 07:06:16',0,'6f7f692d-b579-76b2-bfb0-6633b2843d04','e9d89e66-8a6f-ecf5-c091-66348cf22377'),('bf7ba7c4-3d32-427c-8f63-66348d809de1','2024-05-03 07:09:08',0,'aa520a73-5b82-3179-9698-6632778c4609','bc599848-c4cb-3bab-a54b-66348d4b9d40'),('257f9654-651f-4fb6-e739-66348df634ae','2024-05-03 07:09:32',0,'a5ddc7e1-817d-8511-16d5-6632779ce938','23bbcb20-7bac-47f1-4be6-66348d2af602'),('b3fdeee8-23cb-a391-fba2-66348eabd186','2024-05-03 07:13:50',0,'9cc0091b-58ba-8b44-2a23-6633abd01f82','b20380d6-6a3a-5497-f2cc-66348e83d257'),('5970edc3-1986-b63a-70af-66348ea8e655','2024-05-03 07:14:15',0,'6f15ed19-eeec-1487-e377-6633ab681caf','5701fb71-25a6-9cc3-4662-66348eacfed1'),('dc9ee117-9aca-33a4-4665-66348f95f19d','2024-05-03 07:16:04',0,'dbf24cb1-4b1d-d42a-c819-6633b227b50c','da7da004-3331-0300-5f34-66348f38b1c9'),('f20a35fc-c1e7-607e-3a88-66348f88394a','2024-05-03 07:16:34',0,'6f7f692d-b579-76b2-bfb0-6633b2843d04','f02439ae-07de-4136-8b07-66348f4f8f29'),('daf32fc9-deb4-177d-badc-6634a040b90a','2024-05-03 08:31:04',0,'db998c3c-9c55-b246-7383-6633b12f50fe','d903e615-0a69-97e2-4604-6634a000bd00'),('b3b39c8c-c9e5-7d1a-3998-6634a797e90f','2024-05-03 08:57:56',0,'db998c3c-9c55-b246-7383-6633b12f50fe','b199a9e8-eb02-9d5b-9499-6634a7287b45'),('dbcdb99f-1892-03dd-9b0a-66716044018c','2024-08-30 15:13:12',1,'e1b5d395-fd1a-66ee-0e32-66713b6e48b4','d890b0d5-d2a8-a4aa-229b-667160036b22'),('568029d1-01b5-2071-3aa8-66e15c83fca5','2024-09-11 09:03:00',0,'457b7071-3ecc-7193-123b-66e15c218d86','5007e90d-8710-0a3d-0c41-66e15c462527'),('c110dc80-4600-b6bb-7947-66e15cf858d1','2024-09-11 09:03:06',0,'b55d05a0-19ad-3a4f-acbd-66e15c040684','bd1e0d9a-8d1c-335f-6a5c-66e15cffdb77'),('8ed6854c-a70d-f4c5-271d-66e15cbb429c','2024-09-11 09:03:11',0,'8416fb5a-1a63-faa2-c40e-66e15cd3baf7','8b5ff10d-ee82-f355-25e9-66e15c7d435d'),('dafdddf0-4d62-146d-2540-66e15cc8dfab','2024-09-11 09:03:17',0,'cc0c546b-4897-5904-6ee9-66e15c19f22a','d4a5ccf3-27e6-3c82-4b4b-66e15c6dda40'),('45fc12a7-3c0a-d78a-c35c-66e15c777c8c','2024-09-11 09:03:22',0,'3a0ea712-e37c-a98f-76d0-66e15c272829','41d8dd36-68cb-f050-284d-66e15c337c07'),('d760d303-5838-f6f6-0cd9-66e15c6da213','2024-09-11 09:03:27',0,'cb758f5e-04b4-7e3d-ce80-66e15ca1141d','d33569e0-8597-1fd9-af0a-66e15c6f68b1'),('62c0f721-b0dc-9cd0-36b6-66e15caa55e0','2024-09-11 09:03:32',0,'58c3d56d-59cf-bb0a-8880-66e15c193c57','5f013ddf-5a6f-4006-e19f-66e15c5c8f06'),('984d200e-7b33-1fe7-d367-66e404ae4636','2024-09-13 09:25:13',0,'69b52946-dc89-c193-a941-6421fd2111db','965677e0-7c77-2421-175f-66e40403c1f0'),('b1797de7-4ee1-64bf-61e5-66e4053e0df7','2024-09-13 09:25:27',0,'b037379d-8a12-700c-df1f-66e15c771b03','afdfb99e-f935-1d5d-64e7-66e405589705'),('567ece8d-9800-00fa-f740-66e405422d62','2024-09-13 09:25:35',0,'b86007a2-f31a-a82e-f7e9-66e15cfd0bed','545f1c74-e121-52b4-84ee-66e4057a1b79'),('16dbfd4a-d90d-354c-8a17-66e405a82a4f','2024-09-13 09:26:05',0,'2a87c369-e2d6-2ed7-565f-66e15cb84e22','15177caa-922a-38af-e340-66e405b0a35f'),('7ea7510f-426a-bdf1-0081-66e405593b3c','2024-09-13 09:26:16',0,'4622fe75-1105-1bf1-b2c9-66e15c684019','7d5220c0-919c-fe49-2804-66e405e24016'),('8070a3b8-4586-a733-955e-66fabd664ae8','2024-09-30 15:04:23',0,'2b48e8f8-87bb-d110-f36b-66fab8708e0d','7f0a251f-4d1e-aae8-c9ca-66fabd52dfdd'),('ad07a22e-ef17-7146-aaca-66fabeade601','2024-09-30 15:08:08',0,'98ac0839-1135-5b76-70ca-66fabe4e1007','ab955465-da00-0c96-2654-66fabe1e2adb'),('e1167010-9fe9-7168-6333-66fabeddfbf8','2024-09-30 15:08:23',0,'98ac0839-1135-5b76-70ca-66fabe4e1007','df8b6af3-b924-042d-eea0-66fabe646a67'),('7e7143d7-ad3c-e0d9-7599-66fabe89bcfe','2024-09-30 15:08:39',0,'98ac0839-1135-5b76-70ca-66fabe4e1007','7d24f492-c219-2ebe-b3cc-66fabea633d7'),('b954bb4f-8bb1-c23e-9b89-66fabf8ae033','2024-09-30 15:09:49',0,'c33b2f5a-dc68-7463-6837-66faba84c8dd','b7b65121-5750-af8b-00a5-66fabf247b1b'),('73b18374-386e-ca79-113b-66fabf07a220','2024-09-30 15:11:45',0,'8d8af5be-747e-63c4-5663-66fabb5625c8','7266f5c6-0241-e092-2bb3-66fabf4fc98b'),('8141421e-bd9d-b0aa-0311-66fac10cde7b','2024-09-30 15:18:41',0,'a6946b89-8cd4-04c7-0d70-66fac0bb2d9a','7f861a53-b972-af7b-f681-66fac1684a27'),('e1d3de51-c724-2056-1f32-67068e41463b','2024-10-09 14:09:17',0,'14277a09-ba15-6cd5-6e20-66fab7bfe502','e007e1c7-ad05-a615-b2bc-67068ed9b5db'),('4c7ba530-cf4b-68ca-5e0d-67079129f79b','2024-10-10 08:32:09',0,'6f64f6f3-8f5a-994a-75f4-66e15ca2ef01','4afce0fc-1d62-3859-d70c-67079189ce33'),('47ac7360-62c5-22f7-1e1c-670791d50640','2024-10-10 08:33:28',0,'2a87c369-e2d6-2ed7-565f-66e15cb84e22','4628cf01-a621-8b2b-5012-670791e255e4'),('14fb7b24-c6b7-e275-c593-6756b7968dbe','2024-12-09 09:23:51',0,'9c9c2cc5-ee86-9da6-7daa-674dcd315398','137f11b7-f9e4-7c0c-348d-6756b75f1740'),('c75a7fc6-7f1d-133f-b951-67ae0c4f27c6','2025-02-13 15:13:36',0,'d71ede28-8a07-e1ec-f741-67ae0468070c','c5769346-5403-b8cf-4e4c-67ae0c135123'),('c80d26b8-ba81-eb0c-cb56-67ae1046294f','2025-02-13 15:34:20',0,'4c16a6ac-f2b4-c608-3282-67ae03a3d0b6','c6bbfa61-9ce3-1993-3654-67ae10af6b38'),('c2af1392-5c58-57c4-719e-67ae123c72c0','2025-02-13 15:39:18',0,'13101cd6-bfa6-e461-2306-67ae04966166','c1349794-d90f-0413-15a6-67ae1219d3f1'),('3f2035bf-4729-04ff-0acd-67b7498ee743','2025-02-20 15:24:19',0,'130c8e1e-8ffa-e78e-c227-67ae0313bef0','3d802033-6497-e966-50ec-67b749752db4'),('949d0ae6-acd0-0736-e18e-67b749ad93b0','2025-02-20 15:26:57',0,'ebac804d-8c7d-304f-12fd-67ae0ace38c4','931cc639-0166-5655-b644-67b749e3dd02'),('a25c472a-ea4b-e795-9201-67b74a2e1b22','2025-02-20 15:32:03',0,'edc340ea-27ec-e154-d631-67ae03f988c1','a076a1ca-89d4-e0a3-c2d0-67b74acb2190'),('8c557f10-4283-6e67-69d7-68346a850b24','2025-05-26 13:18:26',0,'cacdaf31-79af-b825-bc9d-6834603e3666','8a7aa6fd-8cb1-26a0-85b6-68346aca2d43'),('e81f132a-96c5-724b-9047-68346ad8f2da','2025-05-26 13:22:05',0,'bda6b4bf-e5a8-3975-9aba-683460824b74','e6c06c80-dd68-903a-7319-68346a4b38ac'),('e9a9f1eb-7bc3-a762-a2d2-683471527cb2','2025-05-26 13:51:37',0,'349aa0e0-59ed-7fb6-0682-683460fd5a33','e8491fc4-5a34-4bb2-2054-6834716f9f2c'),('7777920b-9c44-a10f-68cc-683472bb86c8','2025-05-26 13:53:34',0,'4909d524-f8e9-a050-f623-683468095279','75764df3-01c0-ff7e-685d-683472b7be35'),('a0b82732-edc9-3a59-860f-68347420d225','2025-05-26 14:01:14',0,'21e838b4-f567-54de-8539-6834694ee01f','9d79483e-5b72-2fa1-f5ba-6834742523d6'),('b8f31241-4a53-a0cd-b1c3-683475dcede8','2025-05-26 14:06:26',0,'e2569046-897d-35a8-783b-6834697d5134','b741a76e-2ade-d473-6977-6834757effed'),('4ec9d712-5e45-c0c4-8f67-6835bbb72087','2025-05-27 13:16:33',0,'4675df8e-fce7-85cf-2f2d-6835bba50197','4b3b6687-66f8-4214-662a-6835bb93a2af'),('d110433e-188c-506c-a1a1-68b8016303cd','2025-09-03 08:52:30',0,'bcecb564-a4eb-9e2e-2fee-68b8006a8c01','cf1495ce-ab6e-d8ab-5e6e-68b80118169b'),('bb89b631-7e90-56d6-6868-68b809132a04','2025-09-03 09:25:14',0,'596ada30-dfee-f8fb-8412-68b808556137','b9c950e6-ed0d-eb9c-7166-68b80990a37e'),('57eb30dc-605a-c737-98cf-68b809121c46','2025-09-03 09:26:41',0,'8e3c2e1d-758c-5294-c21d-68b808dcaeec','5670fa96-62fb-d19f-2fb5-68b809c8d1b1'),('ea88fa2b-9d56-e1f1-b6aa-68b8564b6440','2025-09-03 14:55:46',0,'d592d5ed-b75a-3677-c011-68b8491b3ee9','e9242d4b-c5e9-48ea-e124-68b856dca504'),('d43a7f4a-1c98-5449-add3-68b94dd452ea','2025-09-04 08:28:16',0,'d55b5603-a320-0bbf-3ce9-68b84961a693','d14d59d9-52de-ab4d-e317-68b94df03f21'),('64881c02-d6e4-a009-bcda-68ba9ea24842','2025-09-05 08:26:42',0,'878a0170-d8ad-4c6d-5862-68b8492f056c','6293af12-71b5-3476-b4b2-68ba9e2bcdd1'),('49091f16-4296-5975-682a-68dcf57275b9','2025-10-01 09:35:44',0,'99ae10fb-fb08-ae10-814f-68dce8ecc3da','47b40811-1240-8cc5-712f-68dcf5d7aa9f'),('f1290cbb-0659-45bc-398a-68dcf6853b69','2025-10-01 09:38:41',0,'88a26c23-31e7-7ca6-e586-68dce8a77676','db8d0ed5-8d2f-6c33-47f2-68dcf6fb61fb'),('621d586f-35e0-db08-b1f9-68dcf7ba0959','2025-10-01 09:41:07',0,'1389ba38-bede-6c0f-e5f0-68dcea8d5360','609e6869-5085-de9f-12d5-68dcf7743f12'),('d8eb2238-3e3a-5f50-79cc-68e37356fb2e','2025-10-06 07:43:17',0,'2a62751f-2919-ae07-e25a-68dce8804817','d741dd31-b40f-acd6-711f-68e373760a71'),('58a25941-b0b0-3a84-4ca5-68e37419938c','2025-10-06 07:48:53',0,'3fb35d28-3351-f22a-cbb7-68dce877ad9b','575b5506-1519-cc4d-d239-68e3745e5fb9'),('41faf00d-ac67-d1f3-cc80-68e3740fcabd','2025-10-06 07:50:42',0,'3fb35d28-3351-f22a-cbb7-68dce877ad9b','406eea8f-b14f-f362-4b33-68e374bf0451'),('6d7183bd-8c5f-d396-1190-68e3764bbf6c','2025-10-06 07:58:43',0,'51ff984f-c80a-99da-06ff-68dcea96e61d','6bffa73b-bc21-c630-986e-68e376fd92d9'),('587ab545-6443-dc8a-1a7d-68e39098baf4','2025-10-06 09:47:13',0,'4dd149c1-34fc-477d-f2d5-68e390149a3c','54e1aed7-2252-cb3b-5a30-68e3900efd41'),('5e0c53ea-d351-507f-dba5-68e390f99f17','2025-10-06 09:47:13',0,'4dd149c1-34fc-477d-f2d5-68e390149a3c','5b3ba630-713e-986e-e2d3-68e3903cc194'),('794b0ce4-a004-851e-6f5a-68e390c731b4','2025-10-06 09:47:13',0,'6f39a81b-a101-4f09-b238-68e390255ad1','75f7efd4-11bc-defa-0196-68e39064313e'),('defddc5d-16e9-f6ad-0b86-68ff8d31d963','2025-10-27 15:17:23',0,'1ba80378-f81b-d643-538d-683460f58dd0','dd5b2567-06fb-95a1-70ff-68ff8daad338'),('a133876e-b39e-ea12-eeea-68ff8f8e4c69','2025-10-27 15:27:48',0,'ab010cac-3eca-a587-e0c1-68ff81a481c3','9fcecb4b-5ca3-cb12-5a77-68ff8fe370a9'),('3177fa31-9026-7b9d-a40c-68ff8f45b6a6','2025-10-27 15:28:36',0,'78c8ef68-e376-8b27-5bd9-68ff7f0190c7','3035199c-7985-b642-0322-68ff8f3e1236'),('bdf90964-8ac7-6cea-0618-68ff90e6f30d','2025-10-27 15:34:14',0,'b1f006c4-e945-b723-0115-68ff8ebadee4','a71e0dac-3675-8dd3-bcbe-68ff90405e63'),('832d3781-0b4c-4e7b-e1d0-68ff9917f52d','2025-10-27 16:08:36',0,'7a697f27-2068-8703-af8f-68ff99b0cf27','8022d1fb-3f3a-7aa9-2878-68ff99a2b81e'),('5858b695-f921-a56e-1d18-6909fc8c40e9','2025-11-04 13:17:21',0,'4c726801-afe9-27b5-7574-6909fc06399b','52858569-0d1c-d42c-c775-6909fc497717'),('6be28b14-aef5-a9fc-3f39-6909fcf1e2f2','2025-11-04 13:17:21',0,'5ffba449-7de0-23a4-f1f7-6909fc3665e8','678d2301-1b88-2435-db97-6909fc5e7559'),('8b12d87a-a31e-d16b-1795-6909fcfbdaef','2025-11-04 13:17:21',0,'82750e07-f526-34d9-a0b7-6909fce3887c','87198c00-64be-edda-86d5-6909fc7d6798'),('9000fb68-c79a-8a98-1dda-6909fcbf9ff5','2025-11-04 13:17:21',0,'82750e07-f526-34d9-a0b7-6909fce3887c','8c970966-3265-d6c7-29a1-6909fcb7799a'),('ac0864fd-bf93-baee-3282-6909fc267598','2025-11-04 13:17:21',0,'a1c2f791-8cc4-cf66-36cb-6909fc4105ae','a82421ad-bcb8-2df8-3ed8-6909fc822518'),('b56c3f04-81f6-9400-dfc5-6909fcdfe5b4','2025-11-04 13:17:21',0,'ad8e4552-6621-9fbd-03b3-6909fc73be0a','b21c6b4a-b88b-67e9-9e5c-6909fc805c39'),('b9f7b623-cf0f-86ba-0dbc-6909fcd1daf5','2025-11-04 13:17:21',0,'ad8e4552-6621-9fbd-03b3-6909fc73be0a','b6efcf8a-48e5-0c56-92ec-6909fccc7961'),('c816c905-600e-b521-9946-6909fcf50164','2025-11-04 13:17:21',0,'bfc12c23-935e-f305-c6a3-6909fc55bf7a','c4a12a89-109c-11fc-4f1d-6909fc6cc679'),('cce5f56e-9d90-4801-2b1c-6909fc2a4ef0','2025-11-04 13:17:21',0,'bfc12c23-935e-f305-c6a3-6909fc55bf7a','c99e471f-45af-1042-8462-6909fc5906a5'),('e0ff8504-9638-ac02-b227-6909fc1069d1','2025-11-04 13:17:21',0,'d97e9e2d-99af-e4cb-d747-6909fcfdb596','de7515cb-4ab5-27a5-2647-6909fc3f766f'),('8f390f1b-b110-4427-f23f-6909fcd30854','2025-11-04 13:17:21',0,'11f90354-9c75-74ca-7ea3-6909fcd94a34','61f20ae1-6405-2905-09f8-6909fcfce09c'),('daa60b40-bc03-3350-a532-6909fc1cbccc','2025-11-04 13:17:21',0,'11f90354-9c75-74ca-7ea3-6909fcd94a34','ae9e0b29-4c19-b81f-3bd7-6909fca16977'),('38a1a112-cfb7-f22b-ffcf-6909fc3f882c','2025-11-04 13:17:21',0,'306cc3cf-125f-cb77-aef5-6909fc0077e6','353dc53b-2c07-14c0-dcc4-6909fc7be3c9'),('3d006f8f-ab25-58f0-634d-6909fcad2364','2025-11-04 13:17:21',0,'306cc3cf-125f-cb77-aef5-6909fc0077e6','3a40919d-cdd1-3412-b266-6909fcb43a93');

--
-- Table structure for table `ops_agendas`
--

CREATE TABLE `ops_agendas` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `rappel` varchar(100) DEFAULT NULL,
  `date_debut` date DEFAULT NULL,
  `date_fin` date DEFAULT NULL,
  `espacement` int(255) DEFAULT NULL,
  `jours_glissement_debut` int(255) DEFAULT NULL,
  `jours_glissement_fin` int(255) DEFAULT NULL,
  `souhait_glissement_debut` tinyint(1) DEFAULT NULL,
  `souhait_glissement_fin` tinyint(1) DEFAULT NULL,
  `ops_email_creation_id_c` char(36) DEFAULT NULL,
  `ops_email_modification_id_c` char(36) DEFAULT NULL,
  `ops_email_annulation_id_c` char(36) DEFAULT NULL,
  `ops_email_rappel_id_c` char(36) DEFAULT NULL,
  `commentaire_obl` tinyint(1) DEFAULT NULL,
  `date_naissance_obl` tinyint(1) DEFAULT NULL,
  `tel_obl` tinyint(1) DEFAULT NULL,
  `ressource_obl` tinyint(1) DEFAULT NULL,
  `assign_obl` tinyint(1) DEFAULT NULL,
  `email_obl` tinyint(1) DEFAULT NULL,
  `visualisation` varchar(100) DEFAULT NULL,
  `ops_agendas_motifs_id` char(36) DEFAULT NULL,
  `couleur_defaut` varchar(100) DEFAULT NULL,
  `week_end` tinyint(1) DEFAULT 0,
  `min_time` varchar(255) DEFAULT '08:00:00',
  `max_time` varchar(255) DEFAULT '19:00:00',
  `slot_duration` varchar(255) DEFAULT '0',
  `visualisation_gestion` varchar(100) DEFAULT NULL,
  `duree_rdv_temp` int(255) DEFAULT NULL,
  `couleur_planifie` varchar(10) DEFAULT NULL,
  `label_motif` varchar(255) DEFAULT NULL,
  `canal_defaut` varchar(100) DEFAULT NULL,
  `ops_sms_rappel_id_c` char(36) DEFAULT NULL,
  `ops_sms_creation_id_c` char(36) DEFAULT NULL,
  `ops_sms_modification_id_c` char(36) DEFAULT NULL,
  `ops_sms_annulation_id_c` char(36) DEFAULT NULL,
  `lieu` varchar(255) DEFAULT NULL,
  `nature` text DEFAULT NULL,
  `ops_service_id_c` char(36) DEFAULT NULL,
  `assignation_modifiable` tinyint(1) DEFAULT NULL,
  `lieux_multiples` tinyint(1) DEFAULT NULL,
  `texte_reglementaire` text DEFAULT NULL,
  `ops_email_creation_id` char(36) DEFAULT NULL,
  `ops_email_modification_id` char(36) DEFAULT NULL,
  `ops_email_annulation_id` char(36) DEFAULT NULL,
  `ops_email_rappel_id` char(36) DEFAULT NULL,
  `ops_sms_rappel_id` char(36) DEFAULT NULL,
  `ops_sms_creation_id` char(36) DEFAULT NULL,
  `ops_sms_modification_id` char(36) DEFAULT NULL,
  `ops_sms_annulation_id` char(36) DEFAULT NULL,
  `ops_service_id` char(36) DEFAULT NULL,
  `texte_accueil` longtext DEFAULT NULL,
  `afficher_participants` tinyint(1) DEFAULT 0,
  `ops_dispositif_creation_id` char(36) DEFAULT NULL,
  `afficher_creneau_fin` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas`
--

INSERT INTO `ops_agendas` VALUES ('acb01ad2-926a-fb81-e1f0-6425c5b3affe','Administration','2023-03-30 17:23:25','2024-03-28 07:05:20','1','1',NULL,1,'1','60',NULL,NULL,0,1,30,1,1,'','','','',0,0,0,0,0,0,'basicWeek','bd15ce67-a3d9-e8c5-24da-6425c50ba03b',NULL,1,'08:00:00','19:00:00','05','month',20,'','Motif','aucun','','','','',NULL,'CNI\nPasseport','',0,1,'Je valide les informations saisies',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),('287204a7-c1aa-cc01-1bfb-65f37d7022b4','Salle André Malraux','2024-03-14 22:44:48','2024-03-15 09:40:14','1','1',NULL,0,'1','60','2024-03-01','2025-03-01',0,0,0,0,0,NULL,NULL,NULL,NULL,0,0,0,0,0,0,NULL,'','ops_agendas_ressources',1,'08:00:00','19:00:00','30','month',240,'','Lieu',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'','','','','','','','','dfa36ae0-6dc2-05ce-5b9b-65f2d9ae576f',NULL,0,'dfa36ae0-6dc2-05ce-5b9b-65f2d9ae576f',0),('1531a1ac-a30c-a954-5858-662f4d7279f4','Salle des fêtes','2024-04-29 07:35:43','2024-04-29 09:28:02','1','1',NULL,0,'1','86400',NULL,NULL,0,1,60,1,1,NULL,NULL,NULL,NULL,0,0,0,0,0,0,NULL,'5fb00ed8-ca33-abce-7774-65f37f583e81','ops_agendas_lieux',1,'08:00:00','24:00:00','30','month',10,'','Motif',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'3256c795-1613-893e-dd1d-662f65dbee35','c81efa51-6871-027e-1550-662f665f1cfc','7696550f-5ee6-b7dd-3e96-662f670fc582','79f76fd4-6591-fcab-57f3-662f65dee971','','','','','',NULL,0,'4f0364bd-624a-ad43-46a5-662f63d753c5',1);

--
-- Table structure for table `ops_agendas_audit`
--

CREATE TABLE `ops_agendas_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_agendas_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_audit`
--

INSERT INTO `ops_agendas_audit` VALUES ('db3e978e-142c-2591-b4dc-6425c809f8fb','acb01ad2-926a-fb81-e1f0-6425c5b3affe','2023-03-30 17:34:19','1','ops_agendas_motifs_id','id','','bd15ce67-a3d9-e8c5-24da-6425c50ba03b',NULL,NULL),('de7841f1-32b0-1590-c8d4-6425c81c6f19','acb01ad2-926a-fb81-e1f0-6425c5b3affe','2023-03-30 17:34:19','1','motif_defaut','relate','','CNI',NULL,NULL),('916c02ff-3648-71c3-493b-6425c89c3421','acb01ad2-926a-fb81-e1f0-6425c5b3affe','2023-03-30 17:36:15','1','date_debut','date','2023-03-30','',NULL,NULL),('91950f34-d677-857a-7825-6425c81dd68f','acb01ad2-926a-fb81-e1f0-6425c5b3affe','2023-03-30 17:36:15','1','jours_glissement_debut','int','0','1',NULL,NULL),('91acf532-2a97-65c4-2859-6425c81c1caf','acb01ad2-926a-fb81-e1f0-6425c5b3affe','2023-03-30 17:36:15','1','souhait_glissement_debut','bool','0','1',NULL,NULL),('9bd32cb4-7b86-d0a6-bc4a-65f381942d94','287204a7-c1aa-cc01-1bfb-65f37d7022b4','2024-03-14 22:59:30','1','ops_dispositif_creation','relate','Dossier unique organisation d\'un évènement','Dossier unique organisation d\'un évènement',NULL,NULL),('d1a61761-1592-c3e7-6e9b-65f4177a5783','287204a7-c1aa-cc01-1bfb-65f37d7022b4','2024-03-15 09:39:14','1','ops_service_id','id','','cfecac56-5582-057e-17a6-6439648a17e3',NULL,NULL),('d626fbed-8104-a4fb-52fe-65f417bb420e','287204a7-c1aa-cc01-1bfb-65f37d7022b4','2024-03-15 09:39:14','1','service','relate','','Accueil DHAB',NULL,NULL),('d647a09e-e2e5-03e3-66f0-65f417b4b6e7','287204a7-c1aa-cc01-1bfb-65f37d7022b4','2024-03-15 09:39:14','1','ops_dispositif_creation','relate','Dossier unique organisation d\'un évènement','Dossier unique organisation d\'un évènement',NULL,NULL),('d28b59cf-a00d-f8eb-95d0-65f41780d032','287204a7-c1aa-cc01-1bfb-65f37d7022b4','2024-03-15 09:40:14','1','ops_service_id','id','cfecac56-5582-057e-17a6-6439648a17e3','dfa36ae0-6dc2-05ce-5b9b-65f2d9ae576f',NULL,NULL),('d2af2ced-825b-a27a-70ea-65f4174af18f','287204a7-c1aa-cc01-1bfb-65f37d7022b4','2024-03-15 09:40:14','1','service','relate','Accueil DHAB','Dossier unique organisation d\'un évènement',NULL,NULL),('d2c62853-0e5d-a767-ef4e-65f417dccd7e','287204a7-c1aa-cc01-1bfb-65f37d7022b4','2024-03-15 09:40:14','1','ops_dispositif_creation','relate','Dossier unique organisation d\'un évènement','Dossier unique organisation d\'un évènement',NULL,NULL),('31a4878a-4ba8-7897-ea5f-662f56cae829','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 08:13:10','1','ops_agendas_motifs_id','id','','5fb00ed8-ca33-abce-7774-65f37f583e81',NULL,NULL),('320634f6-a8ad-9b95-c6c7-662f568e126f','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 08:13:10','1','ops_dispositif_creation_id','id','','dfa36ae0-6dc2-05ce-5b9b-65f2d9ae576f',NULL,NULL),('32187360-88af-9f02-efc3-662f569f968e','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 08:13:10','1','ops_dispositif_creation','relate','','Dossier unique organisation d\'un évènement',NULL,NULL),('2216ee54-9537-d9f3-a89a-662f63dde4e8','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:07:05','1','ops_dispositif_creation_id','id','dfa36ae0-6dc2-05ce-5b9b-65f2d9ae576f','4f0364bd-624a-ad43-46a5-662f63d753c5',NULL,NULL),('2411070c-b0e4-d29a-d3c5-662f63f25b3a','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:07:05','1','ops_dispositif_creation','relate','Dossier unique organisation d\'un évènement','Réservation de salles',NULL,NULL),('34084947-66a4-7e1d-6b16-662f68b568d1','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:28:02','1','rappel','enum','60','86400',NULL,NULL),('34298a90-be2d-457f-4a85-662f68bf050a','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:28:02','1','ops_email_creation_id','id','','3256c795-1613-893e-dd1d-662f65dbee35',NULL,NULL),('34395cbb-bc33-d2b6-f8e3-662f68c56df4','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:28:02','1','email_creation','relate','','OPS - Salle - Nouveau',NULL,NULL),('34499ba0-8a98-bcbc-5cb8-662f68fc9ea3','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:28:02','1','ops_email_modification_id','id','','c81efa51-6871-027e-1550-662f665f1cfc',NULL,NULL),('34590f46-4c7a-0db0-2365-662f684defc9','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:28:02','1','email_modification','relate','','OPS - Salle - Modification',NULL,NULL),('346b0e58-414c-5d32-88b8-662f6805d3e5','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:28:02','1','ops_email_annulation_id','id','','7696550f-5ee6-b7dd-3e96-662f670fc582',NULL,NULL),('347ace4b-33e7-ff3c-37d3-662f686b133b','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:28:02','1','email_annulation','relate','','OPS - Salle - Suppression',NULL,NULL),('348ae03a-2c7b-8de4-3414-662f68ec28a2','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:28:02','1','ops_email_rappel_id','id','','79f76fd4-6591-fcab-57f3-662f65dee971',NULL,NULL),('349f0d87-b989-d283-82f5-662f68922caa','1531a1ac-a30c-a954-5858-662f4d7279f4','2024-04-29 09:28:02','1','email_rappel','relate','','OPS - Salle - Rappel',NULL,NULL);

--
-- Table structure for table `ops_agendas_droits`
--

CREATE TABLE `ops_agendas_droits` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `visualisation` tinyint(1) DEFAULT 0,
  `instruction` tinyint(1) DEFAULT 0,
  `parametrage` tinyint(1) DEFAULT 0,
  `hors_plage` tinyint(1) DEFAULT 0,
  `motif` tinyint(1) DEFAULT 0,
  `plage_ouverture` tinyint(1) DEFAULT 0,
  `exception` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_droits`
--


--
-- Table structure for table `ops_agendas_droits_audit`
--

CREATE TABLE `ops_agendas_droits_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_agendas_droits_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_droits_audit`
--


--
-- Table structure for table `ops_agendas_droits_ops_agendas`
--

CREATE TABLE `ops_agendas_droits_ops_agendas` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_id` varchar(36) DEFAULT NULL,
  `ops_agendas_droits_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_droits_ops_agendas_ida1` (`ops_agendas_id`),
  KEY `ops_agendas_droits_ops_agendas_alt` (`ops_agendas_droits_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_droits_ops_agendas`
--


--
-- Table structure for table `ops_agendas_droits_ops_agendas_c`
--

CREATE TABLE `ops_agendas_droits_ops_agendas_c` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_droits_ops_agendasops_agendas_ida` varchar(36) DEFAULT NULL,
  `ops_agendas_droits_ops_agendasops_agendas_droits_idb` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_droits_ops_agendas_ida1` (`ops_agendas_droits_ops_agendasops_agendas_ida`),
  KEY `ops_agendas_droits_ops_agendas_alt` (`ops_agendas_droits_ops_agendasops_agendas_droits_idb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_droits_ops_agendas_c`
--


--
-- Table structure for table `ops_agendas_droits_users`
--

CREATE TABLE `ops_agendas_droits_users` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `users_id` varchar(36) DEFAULT NULL,
  `ops_agendas_droits_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_droits_users_ida1` (`users_id`),
  KEY `ops_agendas_droits_users_alt` (`ops_agendas_droits_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_droits_users`
--


--
-- Table structure for table `ops_agendas_droits_users_c`
--

CREATE TABLE `ops_agendas_droits_users_c` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_droits_usersusers_ida` varchar(36) DEFAULT NULL,
  `ops_agendas_droits_usersops_agendas_droits_idb` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_droits_users_ida1` (`ops_agendas_droits_usersusers_ida`),
  KEY `ops_agendas_droits_users_alt` (`ops_agendas_droits_usersops_agendas_droits_idb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_droits_users_c`
--


--
-- Table structure for table `ops_agendas_meetings`
--

CREATE TABLE `ops_agendas_meetings` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_id` varchar(36) DEFAULT NULL,
  `meetings_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_meetings_ida1` (`ops_agendas_id`),
  KEY `ops_agendas_meetings_alt` (`meetings_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_meetings`
--


--
-- Table structure for table `ops_agendas_meetings_c`
--

CREATE TABLE `ops_agendas_meetings_c` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_meetingsops_agendas_ida` varchar(36) DEFAULT NULL,
  `ops_agendas_meetingsmeetings_idb` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_meetings_ida1` (`ops_agendas_meetingsops_agendas_ida`),
  KEY `ops_agendas_meetings_alt` (`ops_agendas_meetingsmeetings_idb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_meetings_c`
--


--
-- Table structure for table `ops_agendas_motifs`
--

CREATE TABLE `ops_agendas_motifs` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `duree` int(255) DEFAULT NULL,
  `couleur` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_motifs`
--

INSERT INTO `ops_agendas_motifs` VALUES ('bd15ce67-a3d9-e8c5-24da-6425c50ba03b','CNI','2023-03-30 17:23:40','2023-03-30 17:34:53','1','1',NULL,0,'',20,'D5FFA6'),('5fb00ed8-ca33-abce-7774-65f37f583e81','En semaine - 80 places (4 heures)','2024-03-14 22:49:39','2024-04-29 07:31:47','1','1',NULL,0,'',240,'FFFFFF'),('25c1746e-9563-3424-bce0-65f37ff9e9d8','En semaine - 50 places (3 heures)','2024-03-14 22:50:08','2024-04-29 07:31:14','1','1',NULL,0,'',180,'FFFFFF'),('dd3f9807-83a0-dcd8-04c4-662f4db10330','Samedi en soirée - 150 places','2024-04-29 07:32:22','2024-04-29 07:32:22','1','1',NULL,0,NULL,239,'FFFFFF'),('6369a139-c2fd-b6e0-3307-662f4d611ec7','Samedi en journée - 150 places','2024-04-29 07:33:14','2024-04-29 07:33:14','1','1',NULL,0,NULL,540,'FFFFFF');

--
-- Table structure for table `ops_agendas_motifs_audit`
--

CREATE TABLE `ops_agendas_motifs_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_agendas_motifs_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_motifs_audit`
--


--
-- Table structure for table `ops_agendas_motifs_meetings`
--

CREATE TABLE `ops_agendas_motifs_meetings` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_motifs_id` varchar(36) DEFAULT NULL,
  `meetings_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_motifs_id` (`ops_agendas_motifs_id`),
  KEY `ops_agendas_motifs_meetings_alt` (`meetings_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_motifs_meetings`
--


--
-- Table structure for table `ops_agendas_motifs_meetings_c`
--

CREATE TABLE `ops_agendas_motifs_meetings_c` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_motifs_meetingsops_agendas_motifs_ida` varchar(36) DEFAULT NULL,
  `ops_agendas_motifs_meetingsmeetings_idb` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_motifs_meetings_ida1` (`ops_agendas_motifs_meetingsops_agendas_motifs_ida`),
  KEY `ops_agendas_motifs_meetings_alt` (`ops_agendas_motifs_meetingsmeetings_idb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_motifs_meetings_c`
--


--
-- Table structure for table `ops_agendas_motifs_ops_agendas`
--

CREATE TABLE `ops_agendas_motifs_ops_agendas` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_motifs_id` varchar(36) DEFAULT NULL,
  `ops_agendas_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_motifs_ops_agendas_alt` (`ops_agendas_motifs_id`,`ops_agendas_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_motifs_ops_agendas`
--

INSERT INTO `ops_agendas_motifs_ops_agendas` VALUES ('140750f4-7b8f-1949-7dd1-662f4f28595f','2024-04-29 07:42:44',0,'5fb00ed8-ca33-abce-7774-65f37f583e81','1531a1ac-a30c-a954-5858-662f4d7279f4'),('29b4e75d-dc14-cbaa-7256-65f37fffda4a','2024-03-14 22:50:08',0,'25c1746e-9563-3424-bce0-65f37ff9e9d8','287204a7-c1aa-cc01-1bfb-65f37d7022b4'),('3d3b0b17-3af7-8e05-9ac3-65f37fb265ab','2024-03-14 22:49:39',0,'5fb00ed8-ca33-abce-7774-65f37f583e81','287204a7-c1aa-cc01-1bfb-65f37d7022b4'),('3e1f624a-f3c2-0043-3493-662f4f0201aa','2024-04-29 07:42:51',0,'dd3f9807-83a0-dcd8-04c4-662f4db10330','1531a1ac-a30c-a954-5858-662f4d7279f4'),('bd43e34d-b6f7-ee18-8106-662f4fb0c612','2024-04-29 07:42:48',0,'6369a139-c2fd-b6e0-3307-662f4d611ec7','1531a1ac-a30c-a954-5858-662f4d7279f4'),('d4bc5e9e-e412-a3be-efd2-662f4fa0f295','2024-04-29 07:42:41',0,'25c1746e-9563-3424-bce0-65f37ff9e9d8','1531a1ac-a30c-a954-5858-662f4d7279f4');

--
-- Table structure for table `ops_agendas_motifs_ops_agendas_c`
--

CREATE TABLE `ops_agendas_motifs_ops_agendas_c` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_motifs_ops_agendasops_agendas_motifs_ida` varchar(36) DEFAULT NULL,
  `ops_agendas_motifs_ops_agendasops_agendas_idb` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_motifs_ops_agendas_alt` (`ops_agendas_motifs_ops_agendasops_agendas_motifs_ida`,`ops_agendas_motifs_ops_agendasops_agendas_idb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_motifs_ops_agendas_c`
--

INSERT INTO `ops_agendas_motifs_ops_agendas_c` VALUES ('beb1a267-3d1d-833d-855d-6425c5d8f2fc','2023-03-30 17:34:53',0,'bd15ce67-a3d9-e8c5-24da-6425c50ba03b','acb01ad2-926a-fb81-e1f0-6425c5b3affe');

--
-- Table structure for table `ops_agendas_motifs_ops_plage_ouverture`
--

CREATE TABLE `ops_agendas_motifs_ops_plage_ouverture` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_motifs_id` varchar(36) DEFAULT NULL,
  `ops_plage_ouverture_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_motifs_ops_plage_ouverture_ida1` (`ops_agendas_motifs_id`),
  KEY `ops_agendas_motifs_ops_plage_ouverture_alt` (`ops_plage_ouverture_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_motifs_ops_plage_ouverture`
--

INSERT INTO `ops_agendas_motifs_ops_plage_ouverture` VALUES ('ad0a4754-e70d-ad19-bde3-662f50daf354','2024-04-29 07:45:46',0,'5fb00ed8-ca33-abce-7774-65f37f583e81','abce5ef4-8296-62bd-7e66-662f50714668'),('1579573d-38bd-2587-1317-662f501d78fa','2024-04-29 07:47:26',0,'25c1746e-9563-3424-bce0-65f37ff9e9d8','146619d1-d3a5-d0f4-a879-662f50902f87'),('bc8b9ec8-4c17-91e5-4eca-662f508f2831','2024-04-29 07:48:34',0,'6369a139-c2fd-b6e0-3307-662f4d611ec7','bb65289a-0acd-228f-8b5b-662f50251ab2'),('278355c1-9f90-0c90-32e5-662f51067684','2024-04-29 07:49:56',0,'dd3f9807-83a0-dcd8-04c4-662f4db10330','264a014c-51af-7423-6c31-662f51047133'),('db16a2f3-95b4-2acd-0ef9-662f70465b51','2024-04-29 10:02:59',0,'25c1746e-9563-3424-bce0-65f37ff9e9d8','d9858afa-6512-a674-e255-662f700d5d47'),('8806965d-4684-bde1-fad9-662f70077c67','2024-04-29 10:04:39',0,'25c1746e-9563-3424-bce0-65f37ff9e9d8','86dca4fd-559e-fdab-1116-662f703f32d1'),('b9de2354-d75d-989d-ca9f-662f71061807','2024-04-29 10:06:19',0,'25c1746e-9563-3424-bce0-65f37ff9e9d8','b83b90da-1710-fc9f-524b-662f71264e37'),('5a7471f1-caf5-bdba-41ed-662f715f21c3','2024-04-29 10:07:06',0,'25c1746e-9563-3424-bce0-65f37ff9e9d8','59533bb0-8806-e2de-fe1b-662f7121b52a'),('b53141b8-e4be-733c-8560-662f717ce97b','2024-04-29 10:08:21',0,'5fb00ed8-ca33-abce-7774-65f37f583e81','b407a6b7-e7fe-7509-bec0-662f71d5509f');

--
-- Table structure for table `ops_agendas_ops_exception`
--

CREATE TABLE `ops_agendas_ops_exception` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_id` varchar(36) DEFAULT NULL,
  `ops_exception_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_ops_exception_ida1` (`ops_agendas_id`),
  KEY `ops_agendas_ops_exception_alt` (`ops_exception_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_ops_exception`
--

INSERT INTO `ops_agendas_ops_exception` VALUES ('106d2f6b-9873-f66a-2f53-662f515d57d6','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','f32d0cb6-b491-ba56-23b5-662f513a409b'),('1278cd1e-2221-2e07-beb5-662f51b514a1','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','113c7f5d-3329-f236-605c-662f518bf78d'),('147bc0ac-5a11-fdf9-21cd-662f5114fa48','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','134118da-604e-123a-9a3c-662f51a62ff9'),('38d70efe-a7a7-b071-2ce8-662f51cc5f87','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','24e40625-3644-1e8a-2bfb-662f519102f4'),('58d60134-c537-3d25-ce50-662f513260c5','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','453e0be8-8784-e77d-0cff-662f51f2cafa'),('7ba30ab3-18ea-bc82-82f9-662f510f299e','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','671f0198-5d6a-780d-f7f9-662f51b69e3e'),('9d370346-a3f4-6e5a-987e-662f51a16d7f','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','899b0cff-7e7f-d2e6-c43d-662f513ad76c'),('bc9a030a-8215-2831-b143-662f5111719a','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','a99f0cdc-b701-f09a-d340-662f51280cf1'),('c2e00078-6bb5-8080-28ce-662f51bd6d04','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','f3a4080c-4390-2d5d-5ba3-662f513749f0'),('e614086e-95b1-7ac6-2d19-662f51b22ec6','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','d1490f46-d88f-4a1b-fb0c-662f511f83bd'),('f2c61a0d-e20a-4490-84ba-662f51538bee','2024-04-29 07:50:43',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','eac65a41-4c83-2c2f-7a4e-662f512072a1');

--
-- Table structure for table `ops_agendas_ops_exception_c`
--

CREATE TABLE `ops_agendas_ops_exception_c` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_ops_exceptionops_agendas_ida` varchar(36) DEFAULT NULL,
  `ops_agendas_ops_exceptionops_exception_idb` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_ops_exception_ida1` (`ops_agendas_ops_exceptionops_agendas_ida`),
  KEY `ops_agendas_ops_exception_alt` (`ops_agendas_ops_exceptionops_exception_idb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_ops_exception_c`
--


--
-- Table structure for table `ops_agendas_ops_plage_ouverture`
--

CREATE TABLE `ops_agendas_ops_plage_ouverture` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_id` varchar(36) DEFAULT NULL,
  `ops_plage_ouverture_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_ops_plage_ouverture_ida1` (`ops_agendas_id`),
  KEY `ops_agendas_ops_plage_ouverture_alt` (`ops_plage_ouverture_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_ops_plage_ouverture`
--

INSERT INTO `ops_agendas_ops_plage_ouverture` VALUES ('11bf0e6d-af42-7075-71c9-65f37e37c769','2024-03-14 22:46:38',0,'287204a7-c1aa-cc01-1bfb-65f37d7022b4','ed8aeab7-c37a-03c7-9543-65f37e34539c'),('15fed654-9716-1262-b60c-662f50ac36cf','2024-04-29 07:47:26',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','146619d1-d3a5-d0f4-a879-662f50902f87'),('2821cb28-f366-b086-7abd-662f51b9fa52','2024-04-29 07:49:56',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','264a014c-51af-7423-6c31-662f51047133'),('5d9d778e-1e7e-9ec9-507e-662f719b02e1','2024-04-29 10:07:06',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','59533bb0-8806-e2de-fe1b-662f7121b52a'),('69a23498-94dd-10a6-d8a6-65f37e744633','2024-03-14 22:48:52',0,'287204a7-c1aa-cc01-1bfb-65f37d7022b4','65913090-94a0-a803-0817-65f37e948e33'),('8add517b-063d-25d2-011b-662f70b5ee03','2024-04-29 10:04:39',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','86dca4fd-559e-fdab-1116-662f703f32d1'),('adb37bc4-b3d1-624f-30d9-662f506b6a0d','2024-04-29 07:45:46',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','abce5ef4-8296-62bd-7e66-662f50714668'),('b7f30eb2-d1cb-95b6-d118-662f71bbb2f2','2024-04-29 10:08:21',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','b407a6b7-e7fe-7509-bec0-662f71d5509f'),('bd21b445-2abe-5eb5-0b3b-662f50d4d6c9','2024-04-29 07:48:34',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','bb65289a-0acd-228f-8b5b-662f50251ab2'),('be405126-0dd8-43e5-1d64-662f7177b586','2024-04-29 10:06:19',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','b83b90da-1710-fc9f-524b-662f71264e37'),('d815d51b-28c2-9ad0-ca5b-65f37e780d7f','2024-03-14 22:47:42',0,'287204a7-c1aa-cc01-1bfb-65f37d7022b4','d3b6c938-0647-f568-2390-65f37e54cfbf'),('df1c6a22-f438-b509-83c6-662f70225473','2024-04-29 10:02:59',0,'1531a1ac-a30c-a954-5858-662f4d7279f4','d9858afa-6512-a674-e255-662f700d5d47'),('f1936bd1-f746-aac3-e47b-65f37ed78546','2024-03-14 22:48:13',0,'287204a7-c1aa-cc01-1bfb-65f37d7022b4','eac1a55e-c68b-7ba1-ee44-65f37e54702f');

--
-- Table structure for table `ops_agendas_ops_plage_ouverture_c`
--

CREATE TABLE `ops_agendas_ops_plage_ouverture_c` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_ops_plage_ouvertureops_agendas_ida` varchar(36) DEFAULT NULL,
  `ops_agendas_ops_plage_ouvertureops_plage_ouverture_idb` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_ops_plage_ouverture_ida1` (`ops_agendas_ops_plage_ouvertureops_agendas_ida`),
  KEY `ops_agendas_ops_plage_ouverture_alt` (`ops_agendas_ops_plage_ouvertureops_plage_ouverture_idb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_ops_plage_ouverture_c`
--

INSERT INTO `ops_agendas_ops_plage_ouverture_c` VALUES ('71a2f934-a5d1-336a-1d7b-6425c68a4c8f','2023-03-30 17:28:01',0,'acb01ad2-926a-fb81-e1f0-6425c5b3affe','5fdb7e8e-2cb7-723a-a925-6425c616ceb3'),('223f0779-ae0d-d35c-1033-6425c6457f7b','2023-03-30 17:28:41',0,'acb01ad2-926a-fb81-e1f0-6425c5b3affe','f35f9c04-7c30-516c-f938-6425c66d61dc'),('5a6c0526-9713-9d51-48a3-6425d0dd7a9b','2023-03-30 18:08:32',0,'acb01ad2-926a-fb81-e1f0-6425c5b3affe','2cef0329-3b6d-4950-4d74-6425d0af860c');

--
-- Table structure for table `ops_agendas_ressources`
--

CREATE TABLE `ops_agendas_ressources` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `couleur` varchar(10) DEFAULT NULL,
  `email1` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_ressources`
--

INSERT INTO `ops_agendas_ressources` VALUES ('bcec0e7d-f9da-dc69-819e-65f381a98569','Salle André Malraux','2024-03-14 22:58:46','2024-03-14 22:58:46','1','1',NULL,0,NULL,'FFFFFF','');

--
-- Table structure for table `ops_agendas_ressources_audit`
--

CREATE TABLE `ops_agendas_ressources_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_agendas_ressources_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_ressources_audit`
--


--
-- Table structure for table `ops_agendas_ressources_meetings`
--

CREATE TABLE `ops_agendas_ressources_meetings` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_ressources_id` varchar(36) DEFAULT NULL,
  `meetings_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_ressources_meetings_ida1` (`ops_agendas_ressources_id`),
  KEY `ops_agendas_ressources_meetings_alt` (`meetings_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_ressources_meetings`
--


--
-- Table structure for table `ops_agendas_ressources_meetings_c`
--

CREATE TABLE `ops_agendas_ressources_meetings_c` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_ressources_meetingsops_agendas_ressources_ida` varchar(36) DEFAULT NULL,
  `ops_agendas_ressources_meetingsmeetings_idb` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_ressources_meetings_ida1` (`ops_agendas_ressources_meetingsops_agendas_ressources_ida`),
  KEY `ops_agendas_ressources_meetings_alt` (`ops_agendas_ressources_meetingsmeetings_idb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_ressources_meetings_c`
--


--
-- Table structure for table `ops_agendas_ressources_ops_agendas`
--

CREATE TABLE `ops_agendas_ressources_ops_agendas` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_ressources_id` varchar(36) DEFAULT NULL,
  `ops_agendas_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_ressources_ops_agendas_alt` (`ops_agendas_ressources_id`,`ops_agendas_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_ressources_ops_agendas`
--

INSERT INTO `ops_agendas_ressources_ops_agendas` VALUES ('90c1b4f0-cb49-fff5-cdb6-65f38171dea6','2024-03-14 22:59:30',0,'bcec0e7d-f9da-dc69-819e-65f381a98569','287204a7-c1aa-cc01-1bfb-65f37d7022b4');

--
-- Table structure for table `ops_agendas_ressources_ops_agendas_c`
--

CREATE TABLE `ops_agendas_ressources_ops_agendas_c` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_agendas_ressources_ops_agendasops_agendas_ressources_ida` varchar(36) DEFAULT NULL,
  `ops_agendas_ressources_ops_agendasops_agendas_idb` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_agendas_ressources_ops_agendas_alt` (`ops_agendas_ressources_ops_agendasops_agendas_ressources_ida`,`ops_agendas_ressources_ops_agendasops_agendas_idb`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_agendas_ressources_ops_agendas_c`
--


--
-- Table structure for table `ops_appairage`
--

CREATE TABLE `ops_appairage` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `logiciel` varchar(100) DEFAULT NULL,
  `parent_type` varchar(255) DEFAULT NULL,
  `parent_id` char(36) DEFAULT NULL,
  `statut` varchar(100) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_appairage_id_del` (`id`,`deleted`),
  KEY `idx_ops_appairage_name_del` (`name`,`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_appairage`
--

INSERT INTO `ops_appairage` VALUES ('4122191d-45e0-7fe7-04a1-66dac3bf826d','55a22ea8-0383-41db-8868-c0443998a768','2024-09-06 08:54:57','2024-10-08 12:45:59','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','e390e1ea-e05a-ae97-d634-66dac33e0751','ok',NULL),('d9f00b2f-5fde-c993-8790-66e14dbcae45','0c3cbff5-bd46-44e9-b61d-2c50ca6b15b1','2024-09-11 07:57:08','2024-09-29 13:38:56','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','809d2aec-6732-a2cb-fca0-66e14d69b458','ok',NULL),('9032de35-c324-4b04-da1b-66e3f91b5629','edeb5a1f-4706-4c5e-9ab3-d5f85acd3d54','2024-09-13 08:34:50','2025-11-04 13:36:32','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',1,'keycloak','OPS_individu','1aaf31af-89f1-0c49-9ca8-66e3f9a9f25b','ok',NULL),('9273b770-ce8f-e58e-c20b-66e3f9a5bc02','685f4a28-6b6e-4f2a-a1e2-79f31760f6fd','2024-09-13 08:35:03','2024-09-13 08:35:03','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','30f3b809-4266-52e9-f592-66e3f957de34','ok',NULL),('9e7f0878-0b52-7977-0965-66e3f9aa439b','01e28a2c-d878-469e-bb19-5beb97cc7eaa','2024-09-13 08:37:41','2024-09-13 09:28:23','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','26b8c834-72e9-488b-29cf-66e3f9b96c41','ok',NULL),('1baa50d1-4a28-a196-082e-66e3f9b7672a','07bc96d4-0de4-43f8-b00a-4a253f5aebed','2024-09-13 08:37:43','2025-02-07 08:46:03','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','ac9f2da6-248c-2d9b-7efc-66e3f90e9c50','ok',NULL),('d91f0f7e-7a93-4d4e-0c76-66e3f9699bda','48e4ad04-8f0a-42de-a528-a8d5c7c8eaf4','2024-09-13 08:37:48','2024-09-13 08:40:59','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','64b493d6-3261-195f-5a58-66e3f9ce46fe','ok',NULL),('d7d7d886-0452-d397-11a3-66e3fa3baa7b','10f3ed9a-fa48-43e5-ab6b-1e0fed1c7eec','2024-09-13 08:41:02','2024-09-13 10:20:34','c4250303-bf3c-53d5-45a9-66e15bb9cb43','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',1,'keycloak','OPS_individu','7ccf81ef-44f1-3340-bf15-66e3fa3f594d','ok',NULL),('de81882a-a06f-9b69-455e-66e3fa1395c7','f3e84cd7-0f21-4110-9de8-ef214c403c39','2024-09-13 08:41:04','2024-09-30 14:24:36','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','7dc8dc3e-48e0-dec8-19b8-66e3fa3fd389','ok',NULL),('9c03dbbe-bc36-e70e-aa39-66fab2f7a75c','926a82d9-628a-4c78-b75f-80c969856a58','2024-09-30 14:15:59','2025-10-27 15:59:53','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','358e481e-4a74-580c-e951-66fab2eefdea','ok',NULL),('d45ac1e9-293d-8229-f80e-66fab2f29e70','ff651910-2a32-4b21-9dc2-86bd7fb0ad6b','2024-09-30 14:16:40','2024-10-02 13:41:00','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','7653ee59-fe29-9af0-35bf-66fab292b5ac','ok',NULL),('58e2517e-aa60-4d9d-8173-66fab2bd6c51','c8ab57b7-7d36-4635-b4ef-066cf538365f','2024-09-30 14:16:44','2024-09-30 14:16:44','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','299c06c5-a4fc-566f-621e-66fab26c568b','ok',NULL),('8c7d21f1-2d05-6017-3b31-66fab232be12','3897571d-b446-40d8-b2c9-724633bae3bd','2024-09-30 14:16:47','2024-09-30 14:16:47','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','4c5a0962-5df2-8fa4-60b9-66fab2946ad1','ok',NULL),('9a142676-1ad9-54d9-63ec-66fab28413b7','f0d2f3fc-0b5d-4256-99fc-23aeff24bdde','2024-09-30 14:16:49','2024-09-30 14:16:49','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','2e2ba959-4cfc-5e03-17ec-66fab24db976','ok',NULL),('737495d0-5d23-58f5-956e-66fab3ae241f','18ea0909-c296-4659-9b26-185fbc8efd69','2024-09-30 14:18:55','2024-09-30 14:18:55','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','cdb004af-1aa1-995a-ffca-66fab3487a0d','ok',NULL),('f0cad053-a966-3bff-aad7-66fab3f196fb','2b7f7d52-1468-40e5-94a7-40c945f798f1','2024-09-30 14:19:17','2024-09-30 14:19:18','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','7f5d7b86-2cae-be77-67ee-66fab3cb2d5d','ok',NULL),('5e4f8466-a944-c02f-eb40-6707842b952a','69412c59-4025-4f5e-9481-0c36bb4b9f75','2024-10-10 07:40:19','2024-10-11 09:14:05','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','d24a3e74-ccb1-70c6-2b57-670784184303','ok',NULL),('5d1c486c-04cf-e7b2-4d3c-6707845f5ec4','932cfadc-c6e1-4830-8984-13ec29671790','2024-10-10 07:40:33','2024-10-10 08:08:10','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','e6a70aca-1659-c27e-b93f-67078495949a','ok',NULL),('ab052e86-6d87-8024-964a-670784dffb5c','7c78ab56-9dec-4ea4-8faf-bbcc2872c20c','2024-10-10 07:40:35','2024-10-10 10:24:26','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','4538c0f8-29d5-8398-8ebb-6707846512b2','ok',NULL),('13b0eecc-2fbf-6811-a132-672251033c66','ead952d4-0931-4cdd-b4d1-cb01890dd7b0','2024-10-30 15:32:34','2025-09-03 08:32:07','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','90e2181f-6c6a-6bbb-bc33-672251ae167a','ok',NULL),('469874c9-2090-3b58-ab75-6733667269fa','e247646c-76f8-44e2-8dd0-4d8364c09628','2024-11-12 14:28:54','2024-11-12 15:34:39','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','cd8ccb72-9b13-8aba-e675-673366a567df','ok',NULL),('c159a84c-9cd8-1e57-30b6-6733660a9345','7dd2fa06-5c2e-4717-a71b-500ab5286cea','2024-11-12 14:29:28','2024-11-12 14:41:31','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','6d5eb31a-427d-53fc-704f-673366c9adbd','ok',NULL),('f21ce363-4b0c-3843-8e8d-67336730e42b','9b853a68-fd26-4fcf-b3fd-917ddafd5142','2024-11-12 14:32:35','2024-11-12 15:26:03','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','4cc31708-4981-5419-5ba6-673367866fc6','ok',NULL),('9aa08e40-fb0e-cbc6-d529-67336a383fb9','9430fd71-150f-4afc-afc4-909b1c8f3501','2024-11-12 14:47:54','2024-11-12 14:53:12','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','40473833-8de7-29b6-a635-67336a888efa','ok',NULL),('af5b7de2-8406-97e5-5928-67446e57bd5b','faaa221e-4b68-4ce0-8708-27dc16006157','2024-11-25 12:31:05','2024-11-25 13:35:18','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','399d6883-990b-6470-25ee-67446e8d29b0','ok',NULL),('141b7241-4775-2672-4505-674d8729c6a0','87cea0c2-768b-48cd-8b7a-c151aaf9744e','2024-12-02 10:09:41','2024-12-09 08:40:40','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','98d36a5b-b859-5bc2-8220-674d87a809db','ok',NULL),('8cbd4a2a-ee97-685f-ccd8-6798e05f7e9a','cb5d8907-7563-40c2-8486-f7dda093ebc7','2025-01-28 13:48:20','2025-01-28 13:48:20','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','ec6e56dc-83fc-535a-3d27-6798e0a31a71','ok',NULL),('5936e5e6-b1da-7cf4-a3d0-67a4a2d5bb04','985e7cef-77d4-474a-84bf-6cf8b53f757a','2025-02-06 11:50:25','2025-02-06 11:50:25','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','c9902691-ad6c-6a43-05d7-67a4a2897dca','ok',NULL),('53d7e6f3-d79d-1adc-2cec-67a5c0955cda','f96efad1-a371-4e43-9ab6-562896d89240','2025-02-07 08:14:13','2025-11-04 13:36:39','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',1,'keycloak','OPS_individu','eaf0878c-1f4e-21fd-a6f7-67a5c03f15e1','ok',NULL),('440a6aa4-a34d-7760-9533-67a5c13cdd1b','904aa2a9-dcdc-49d3-97fa-b0c7913b28fd','2025-02-07 08:17:43','2025-02-07 09:18:43','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','d8d51dbb-e61b-e471-4c30-67a5c10ad4fc','ok',NULL),('12046f34-d069-789f-12d8-67a5c34f2d6c','0e587f4f-eafc-4e51-b80e-1b74f8588c26','2025-02-07 08:23:32','2025-03-14 16:53:08','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','9fe9ec41-b8ec-f47b-4ad2-67a5c308f237','ok',NULL),('c3b98980-2a92-acfa-b453-67a5c3d7a816','58c19f61-eb91-42b5-aeda-9291ac697b57','2025-02-07 08:24:34','2025-02-07 10:05:17','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','562ed9c2-4d38-3f29-de2d-67a5c31f6347','ok',NULL),('4a1a9240-09ff-4b1c-eec4-67a5c3192497','184337a9-1334-4ab8-b556-c371ed91b10c','2025-02-07 08:25:47','2025-02-07 09:48:30','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','d466ce4b-3c26-0209-66a2-67a5c3083e46','ok',NULL),('182541fa-762a-3dfe-e2bf-67aa0648b51a','d300c25a-3984-4efb-b6b7-54c0924d17e0','2025-02-10 14:01:18','2025-02-20 13:07:26','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','a8675563-0c72-37e8-b21e-67aa067df0d5','ok',NULL),('f3b3c780-6e42-0c10-a95f-67aa0707d2fe','6eb264a6-35d1-44b5-ba61-d0b3fc66df1f','2025-02-10 14:03:58','2025-02-20 13:09:19','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','943834a9-065f-7f8f-72ad-67aa07d83e13','ok',NULL),('a8c46262-0cbd-fe71-5d6c-68234634c65d','fec700ff-61ea-4c28-ad25-fe57cee27c9b','2025-05-13 13:17:32','2025-09-25 08:10:37','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','34ef2300-ccfa-2af0-a317-682346eaeeea','ok',NULL),('71b3614d-e613-425a-7bae-6823469009a0','e3eeeb1d-c619-431e-a1c4-6df50847bd9d','2025-05-13 13:18:12','2025-05-27 12:49:44','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','6d370238-e9fe-9643-fb69-682346fc501d','ok',NULL),('5c87e006-923b-8473-661d-68b5a09f3828','dcc31467-39cf-491e-a51c-21b14b31b0f9','2025-09-01 13:34:52','2025-09-08 06:52:39','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','d949f51f-d7dc-8da8-58f8-68b5a002e870','ok',NULL),('860bef98-9c8b-4201-7f4e-68da3e5f3320','9d734c78-fb64-4561-8422-dbdf5814c5c5','2025-09-29 08:08:10','2025-10-06 07:18:57','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','1b6b1544-b6da-afeb-208d-68da3ef19b16','ok',NULL),('2734b636-a4ee-d757-f4cd-68da3e030cea','595761d1-778c-4783-804e-5c5d95266088','2025-09-29 08:08:31','2025-10-06 07:53:10','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','ba364af6-59fe-fba5-d0bc-68da3e1911a2','ok',NULL),('9ae7d810-e910-f45e-9361-68da3e2dbfa0','94d68478-f4f8-4879-9187-ea5bda64923c','2025-09-29 08:08:57','2025-10-06 07:51:47','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','1fb5908f-8e92-e2d1-ba18-68da3e52b930','ok',NULL),('1a775174-abce-2d43-ada2-68e3bd3dbfd8','a431a782-cb74-4948-91d1-33eb70498f1e','2025-10-06 13:02:06','2025-10-27 15:47:02','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','a01b4689-81a4-2cc3-628e-68e3bd6a6ee9','ok',NULL),('432a161f-d6f8-d035-a507-68e3bd166d2d','ab989ee7-180e-4d91-9e41-9b5407bca94a','2025-10-06 13:02:35','2025-10-31 08:47:24','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','dea2143d-aa57-ee74-9e98-68e3bdda9b15','ok',NULL),('db62f0a8-2bcf-3497-3a63-68f74749e6e3','0b01474f-c28d-4dd4-8bc2-74638a318d24','2025-10-21 08:44:21','2025-10-23 14:16:45','1','1','Identifiant KeycloakID (KID) lors de la création par le fournisseur SSO Keycloak',0,'keycloak','OPS_individu','6da48d1c-d991-3ebc-f788-68f747cb60a7','ok',NULL);

--
-- Table structure for table `ops_appairage_audit`
--

CREATE TABLE `ops_appairage_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_appairage_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_appairage_audit`
--

INSERT INTO `ops_appairage_audit` VALUES ('709d2f3b-9d37-1f42-f105-64c27f3c2825','e61b516c-fd05-2aa9-6502-64c27de43eb4','2023-07-27 14:31:46','1','statut','enum','ok','err',NULL,NULL);

--
-- Table structure for table `ops_avis`
--

CREATE TABLE `ops_avis` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `nature` varchar(255) DEFAULT NULL,
  `sollicitation` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `autre_type` varchar(255) DEFAULT NULL,
  `consigne` text DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `user_id` char(36) NOT NULL,
  `avis` varchar(255) DEFAULT NULL,
  `autre_avis` varchar(255) DEFAULT NULL,
  `commentaire` text DEFAULT NULL,
  `montant` float(18,2) DEFAULT NULL,
  `date_reponse` date DEFAULT NULL,
  `date_reponse_souhaitee` date DEFAULT NULL,
  `cle_securite` varchar(32) DEFAULT NULL,
  `individu_id` char(36) DEFAULT NULL,
  `date_activation` date DEFAULT NULL,
  `date_expiration` date DEFAULT NULL,
  `statut_cle` varchar(255) DEFAULT NULL,
  `justificatif` varchar(255) DEFAULT NULL,
  `file_mime_type` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_avis`
--


--
-- Table structure for table `ops_avis_audit`
--

CREATE TABLE `ops_avis_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_avis_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_avis_audit`
--


--
-- Table structure for table `ops_banque`
--

CREATE TABLE `ops_banque` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_banque`
--


--
-- Table structure for table `ops_banque_audit`
--

CREATE TABLE `ops_banque_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_banque_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_banque_audit`
--


--
-- Table structure for table `ops_bon`
--

CREATE TABLE `ops_bon` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `ops_bon_type_list` varchar(255) DEFAULT NULL,
  `identity_number` varchar(255) DEFAULT NULL,
  `date_validity` date DEFAULT NULL,
  `date_reserved` date DEFAULT NULL,
  `ops_bon_statut_list` varchar(255) DEFAULT '0',
  `reserve_par` varchar(255) DEFAULT NULL,
  `reserve_par_id` varchar(255) DEFAULT NULL,
  `champ_texte_1` varchar(255) DEFAULT NULL,
  `champ_texte_2` varchar(255) DEFAULT NULL,
  `champ_texte_3` varchar(255) DEFAULT NULL,
  `champ_date_1` date DEFAULT NULL,
  `champ_date_2` date DEFAULT NULL,
  `champ_texte_long_1` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_bon`
--


--
-- Table structure for table `ops_bon_audit`
--

CREATE TABLE `ops_bon_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_bon_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_bon_audit`
--


--
-- Table structure for table `ops_bon_ops_dossier`
--

CREATE TABLE `ops_bon_ops_dossier` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_dossier_id` varchar(36) DEFAULT NULL,
  `ops_bon_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_bon_ops_dossier_ida1` (`ops_dossier_id`),
  KEY `ops_bon_ops_dossier_alt` (`ops_bon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_bon_ops_dossier`
--


--
-- Table structure for table `ops_bon_ops_individu`
--

CREATE TABLE `ops_bon_ops_individu` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_individu_id` varchar(36) DEFAULT NULL,
  `ops_bon_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_bon_ops_individu_ida1` (`ops_individu_id`),
  KEY `ops_bon_ops_individu_alt` (`ops_bon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_bon_ops_individu`
--


--
-- Table structure for table `ops_bon_ops_individu_1`
--

CREATE TABLE `ops_bon_ops_individu_1` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_individu_id1` varchar(36) DEFAULT NULL,
  `ops_bon_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_bon_ops_individu_1_ida1` (`ops_individu_id1`),
  KEY `ops_bon_ops_individu_1_alt` (`ops_bon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_bon_ops_individu_1`
--


--
-- Table structure for table `ops_bon_ops_personne_morale`
--

CREATE TABLE `ops_bon_ops_personne_morale` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_personne_morale_id` varchar(36) DEFAULT NULL,
  `ops_bon_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_bon_ops_personne_morale_ida1` (`ops_personne_morale_id`),
  KEY `ops_bon_ops_personne_morale_alt` (`ops_bon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_bon_ops_personne_morale`
--


--
-- Table structure for table `ops_business_object`
--

CREATE TABLE `ops_business_object` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `nom_technique` varchar(255) DEFAULT NULL,
  `actif` tinyint(1) DEFAULT 1,
  `type` varchar(100) DEFAULT NULL,
  `format` varchar(100) DEFAULT NULL,
  `variable_envoyee` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_business_object`
--

INSERT INTO `ops_business_object` VALUES ('1b174bf8-8986-aa3d-20d8-64f084f537af','Synthèse d\'un profil','2023-08-31 12:15:55','2023-08-31 12:15:55','1','1','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.',0,NULL,'OpenSub_synthese_profil',1,'ops_personne_morale','pdf_xlsx','numero_rna'),('1c107f3e-2489-1138-3a62-64f084b68057','Les paiements de la commission','2023-08-31 12:14:44','2023-08-31 12:14:44','1','1','',0,NULL,'OpenSub_les_paiements_de_la_commission',1,'ops_commission','pdf_xlsx','uiid'),('298b62e5-f47f-6062-d829-64f084725477','Les paiements du dispositif','2023-08-31 12:15:28','2023-08-31 12:15:28','1','1','',0,NULL,'OpenSub_les_paiements_du_dispositif',1,'ops_dossier','pdf_xlsx','num_dossier'),('48294195-2d6e-329f-b6b5-64f0844656fd','Les dossiers de la réunion','2023-08-31 12:13:55','2023-08-31 12:13:55','1','1','',0,NULL,'OpenSub_les_dossiers_de_la_reunion',1,'ops_reunion','pdf_xlsx','uiid'),('5cf95245-c57d-0442-db69-64f084c301fb','Les dossiers du dispositif','2023-08-31 12:14:21','2023-08-31 12:14:21','1','1','Lorem ipsum dolor sit amet. Ut rerum eius sit vitae neque non aliquam assumenda non recusandae nihil. Ut ducimus minima non aperiam cupiditate ad minus debitis sit nulla autem qui omnis illum ut facilis veniam ex voluptatum cupiditate? Est alias enim est voluptatem reiciendis ut sunt voluptatum? Eos reiciendis dolorum maxime veniam aut quibusdam saepe.\n\nQui itaque explicabo et repellendus sunt qui eius velit eos perspiciatis consequuntur et internos illo qui perferendis consequatur eos quae molestias. Aut reiciendis maxime ex commodi velit ut doloribus accusantium in obcaecati voluptates. Qui illum obcaecati At corporis delectus ut iure quae non suscipit nihil ab consequatur beatae.',0,NULL,'OpenSub_les_dossiers_du_dispositif',1,'ops_dossier','pdf_xlsx','num_dossier'),('7d03ba15-e0df-05ed-cdcb-64f084080175','Les paiements de la réunion','2023-08-31 12:15:07','2023-08-31 12:15:07','1','1','',0,NULL,'OpenSub_les_paiements_de_la_reunion',1,'ops_reunion','pdf_xlsx','uiid'),('9fcf666f-5b0a-4b7f-1c15-65f2c670b561','Valorisation globale aides et subventions','2024-03-14 09:43:35','2024-03-14 09:43:35','1','1','',0,NULL,'OpenSub_valorisation_aides_subventions_une_asso',1,'ops_personne_morale','pdf_xlsx','numero_rna'),('e6bf21f1-0e64-5907-5cf0-64f083176f71','Les dossiers de la commission','2023-08-31 12:13:31','2023-08-31 12:13:31','1','1','Ce rapport retourne la liste des dossiers de la commission avec différentes déclinaisons :\nune synthèse des dossiers / une ventilation par thématique / une ventilation par territoire',0,NULL,'OpenSub_les_dossiers_de_la_commission',1,'ops_commission','pdf_xlsx','uiid');

--
-- Table structure for table `ops_business_object_audit`
--

CREATE TABLE `ops_business_object_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_business_object_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_business_object_audit`
--


--
-- Table structure for table `ops_calendrier_garde`
--

CREATE TABLE `ops_calendrier_garde` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `event_list` longblob DEFAULT NULL,
  `famille_1_couleur` varchar(255) DEFAULT NULL,
  `famille_2_couleur` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_calendrier_garde`
--

INSERT INTO `ops_calendrier_garde` VALUES ('76ad19c6-2a46-275f-cfec-64288a6f3e81','Romane DURAND','2023-04-01 19:48:33','2023-04-03 20:03:30','1','1',NULL,0,'','eyI4MDQ1NGI0ZC1hOGJlLTgyNTUtZjUyNi02NDI4OGFlYmU2OGQiOlsiMjAyMy0wMy0zMCIsIjIwMjMtMDMtMzEiLCIyMDIzLTA0LTAzIiwiMjAyMy0wNC0wNCIsIjIwMjMtMDQtMDUiLCIyMDIzLTA0LTA2IiwiMjAyMy0wNC0wNyIsIjIwMjMtMDQtMDEiLCIyMDIzLTA0LTAyIiwiMjAyMy0wNC0xMCIsIjIwMjMtMDQtMTEiLCIyMDIzLTA0LTE3IiwiMjAyMy0wNC0xOCIsIjIwMjMtMDQtMTkiLCIyMDIzLTA0LTIwIiwiMjAyMy0wNC0yMSIsIjIwMjMtMDQtMjIiLCIyMDIzLTA0LTIzIiwiMjAyMy0wNC0xNCIsIjIwMjMtMDQtMTUiLCIyMDIzLTA0LTE2IiwiMjAyMy0wNC0yNiIsIjIwMjMtMDQtMjciLCIyMDIzLTA0LTI4IiwiMjAyMy0wNC0yOSIsIjIwMjMtMDQtMzAiLCIyMDIzLTA1LTAxIiwiMjAyMy0wNS0wMiIsIjIwMjMtMDUtMDMiLCIyMDIzLTA1LTA4IiwiMjAyMy0wNS0wOSIsIjIwMjMtMDUtMTAiLCIyMDIzLTA1LTExIiwiMjAyMy0wNS0xMiIsIjIwMjMtMDUtMTMiLCIyMDIzLTA1LTE0IiwiMjAyMy0wNS0yMiIsIjIwMjMtMDUtMjMiLCIyMDIzLTA1LTI0IiwiMjAyMy0wNS0yNSIsIjIwMjMtMDUtMjYiLCIyMDIzLTA1LTI3IiwiMjAyMy0wNS0yOCIsIjIwMjMtMDUtMjkiLCIyMDIzLTA1LTMwIiwiMjAyMy0wNS0zMSIsIjIwMjMtMDYtMDEiLCIyMDIzLTA2LTAyIiwiMjAyMy0wNi0wMyIsIjIwMjMtMDYtMDQiXSwiNGU1YjI2OTMtMWU3Ny0zZmZiLTUwMmYtNjQyODhhMjRjNjE4IjpbIjIwMjMtMDQtMDgiLCIyMDIzLTA0LTA5IiwiMjAyMy0wNC0yNCIsIjIwMjMtMDQtMjUiLCIyMDIzLTA0LTEyIiwiMjAyMy0wNC0xMyIsIjIwMjMtMDUtMDQiLCIyMDIzLTA1LTA1IiwiMjAyMy0wNS0wNiIsIjIwMjMtMDUtMDciLCIyMDIzLTA1LTE1IiwiMjAyMy0wNS0xNiIsIjIwMjMtMDUtMTciLCIyMDIzLTA1LTE4IiwiMjAyMy0wNS0xOSIsIjIwMjMtMDUtMjAiLCIyMDIzLTA1LTIxIiwiMjAyMy0wMy0yOCIsIjIwMjMtMDMtMjkiLCIyMDIzLTAzLTI3Il19',NULL,NULL);

--
-- Table structure for table `ops_campagne`
--

CREATE TABLE `ops_campagne` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `millesime` varchar(255) DEFAULT NULL,
  `date_debut` date DEFAULT NULL,
  `date_fin` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_campagne`
--

INSERT INTO `ops_campagne` VALUES ('a40f60c8-2aa9-bb12-06c2-65bfc8d5013a','Voeux du Président','2024-02-04 17:25:59','2024-02-04 19:35:25','1','1','Différentes manifestations de voeux du Président',0,'','2024','2024-01-01','2024-02-29'),('e9ad60b2-ea3a-e6b1-0829-65c05d3b4cb2','Voeux aux entreprises','2024-02-05 04:03:05','2024-02-05 04:03:05','1','1',NULL,0,NULL,'2024','2024-01-01','2024-02-15');

--
-- Table structure for table `ops_campagne_audit`
--

CREATE TABLE `ops_campagne_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_campagne_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_campagne_audit`
--

INSERT INTO `ops_campagne_audit` VALUES ('c19227d0-2094-af2e-b274-65bfc8852510','a40f60c8-2aa9-bb12-06c2-65bfc8d5013a','2024-02-04 17:26:06','1','millesime','varchar','','2024',NULL,NULL);

--
-- Table structure for table `ops_campagne_documents`
--

CREATE TABLE `ops_campagne_documents` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_campagne_id` varchar(36) DEFAULT NULL,
  `document_id` varchar(36) DEFAULT NULL,
  `document_revision_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_campagne_documents_ida1` (`ops_campagne_id`),
  KEY `ops_campagne_documents_alt` (`document_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_campagne_documents`
--


--
-- Table structure for table `ops_campagne_ops_dispositif`
--

CREATE TABLE `ops_campagne_ops_dispositif` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_dispositif_id` varchar(36) DEFAULT NULL,
  `ops_campagne_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_campagne_ops_dispositif_ida1` (`ops_dispositif_id`),
  KEY `ops_campagne_ops_dispositif_alt` (`ops_campagne_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_campagne_ops_dispositif`
--

INSERT INTO `ops_campagne_ops_dispositif` VALUES ('ec764f20-0a80-de79-7fe5-65c05de4d166','2024-02-05 04:03:05',0,'b89ad20d-078c-1fc5-9ebd-65bfc95774b2','e9ad60b2-ea3a-e6b1-0829-65c05d3b4cb2');

--
-- Table structure for table `ops_campagne_ops_dossier`
--

CREATE TABLE `ops_campagne_ops_dossier` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_campagne_id` varchar(36) DEFAULT NULL,
  `ops_dossier_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_campagne_ops_dossier_ida1` (`ops_campagne_id`),
  KEY `ops_campagne_ops_dossier_alt` (`ops_dossier_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_campagne_ops_dossier`
--

INSERT INTO `ops_campagne_ops_dossier` VALUES ('929f402c-3bb5-aab5-9222-65bfe6c05822','2024-02-26 07:25:37',1,'a40f60c8-2aa9-bb12-06c2-65bfc8d5013a','588aa22c-08cf-f106-067f-65bfd82283a2');

--
-- Table structure for table `ops_classement`
--

CREATE TABLE `ops_classement` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `classement_type_id` char(36) DEFAULT NULL,
  `niveau_1_id` char(36) DEFAULT NULL,
  `niveau_2_id` char(36) DEFAULT NULL,
  `niveau_3_id` char(36) DEFAULT NULL,
  `niveau_4_id` char(36) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_classement`
--


--
-- Table structure for table `ops_classement_audit`
--

CREATE TABLE `ops_classement_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_classement_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_classement_audit`
--


--
-- Table structure for table `ops_classement_ops_dossier`
--

CREATE TABLE `ops_classement_ops_dossier` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_niveau_1_id` varchar(36) DEFAULT NULL,
  `ops_classement_id` varchar(36) DEFAULT NULL,
  `ops_dossier_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_classement_ops_dossier_alt` (`ops_classement_id`),
  KEY `ops_classement_ops_dossier_ida1` (`ops_dossier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_classement_ops_dossier`
--


--
-- Table structure for table `ops_classement_type`
--

CREATE TABLE `ops_classement_type` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_classement_type`
--

INSERT INTO `ops_classement_type` VALUES ('4d5ba03e-a251-9ffb-40d5-642892086e98','Budget','2023-04-01 20:23:36','2023-04-01 20:23:36','1','1','',0,NULL),('b765ab28-47b3-a109-5c88-64e38f31cee3','Statistiques','2023-08-21 16:21:36','2023-08-21 16:21:36','1','1','',0,NULL);

--
-- Table structure for table `ops_classement_type_audit`
--

CREATE TABLE `ops_classement_type_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_classement_type_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_classement_type_audit`
--


--
-- Table structure for table `ops_commission`
--

CREATE TABLE `ops_commission` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `libelle_court` varchar(128) DEFAULT NULL,
  `libelle_long` varchar(255) DEFAULT NULL,
  `statut_commission` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_commission`
--

INSERT INTO `ops_commission` VALUES ('715b7705-7e9e-bb57-b3b2-64286539229a','18 octobre 2024',NULL,'2025-09-03 12:32:32','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','1',NULL,0,'','18 octobre 2024',NULL,'1'),('32f8fee1-7a69-4ec6-1bdc-642865b93a2f','10 septembre 2024',NULL,'2024-06-24 10:43:30','1','1',NULL,0,'','10 septembre 2024',NULL,'1'),('61d35938-a119-a080-6bf1-666ae6968015','5 novembre 2024',NULL,'2024-06-24 10:44:42','1','604ce6b2-0113-9588-7fa6-65f42e2efabe',NULL,0,'','5 novembre 2024','admission commission','1'),('399e73b6-d499-e353-2cde-674dc28a2783','ED_Com_culture',NULL,'2024-12-02 14:21:48','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'ED_Com_culture','ED_Com_culture','1'),('13bff1fb-cecb-0d60-7744-67adbd098fb1','Commission culture',NULL,'2025-02-13 09:37:57','1','1',NULL,0,NULL,'Commission culture','','1'),('eaba8a34-572f-3f6c-ad80-67b72c01df4e','commission test',NULL,'2025-02-20 13:24:10','1','1',NULL,0,NULL,'commission test','','1'),('2fed6442-7c45-7df5-1039-67b72de034f8','Commission de février 2025',NULL,'2025-02-20 13:25:55','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,'','Commission de février 2025','LM','1'),('af3ff3d7-af64-a5c6-5ac6-67b72d7d9f85','SP_Commission_test1',NULL,'2025-02-20 13:25:25','c4250303-bf3c-53d5-45a9-66e15bb9cb43','c4250303-bf3c-53d5-45a9-66e15bb9cb43',NULL,0,NULL,'SP_Commission_test1','','1'),('c0e982de-0554-783c-8dd3-682c53b26adb','Test Natalia',NULL,'2025-05-20 10:04:12','1','1',NULL,0,NULL,'Test Natalia','','1'),('ae24af3d-4719-2d01-c289-68b6b361f63d','commission éducation',NULL,'2025-09-02 09:07:44','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'commission éducation','','1'),('4693f3a9-6323-2b37-6c69-68b8363db236','Commission test Alice',NULL,'2025-09-04 14:43:13','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,'','Commission test Alice',NULL,'1'),('40be4c00-1f96-d64f-529a-68dcd5b48627','commission test Natalia',NULL,'2025-10-01 07:17:15','1','1',NULL,0,NULL,'commission test Natalia','long','1'),('9eea7b02-fd14-eb88-f725-68dcd9c99733','commis Sion 01 octobre 2025',NULL,'2025-10-01 07:35:34','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'commis Sion 01 octobre 2025','','1'),('6fe61801-dace-ca49-a2ef-68dcda1dfa58','CD Commission CD',NULL,'2025-10-01 07:38:35','c4250303-bf3c-53d5-45a9-66e15bb9cb43','c4250303-bf3c-53d5-45a9-66e15bb9cb43',NULL,0,NULL,'CD Commission CD','CD Commission CD','1'),('acde2da5-194f-6961-a59e-68dcdaa0e228','Depot de bilan',NULL,'2025-10-01 07:39:36','e64475cf-02f9-b7e1-4f19-66e15ba04a6c','e64475cf-02f9-b7e1-4f19-66e15ba04a6c',NULL,0,NULL,'Depot de bilan','','1'),('ec6a2258-953f-750b-3ba6-690478333d9c','Commission Natalia du 31/10/2025',NULL,'2025-10-31 08:50:53','1','1',NULL,0,NULL,'Commission Natalia du 31/10/2025','','1'),('e9cee81a-de87-33d1-e317-69047a797cca','AB_Comission Test',NULL,'2025-10-31 08:59:34','81297ee7-4d44-54e8-1090-66e15bd4b75c','81297ee7-4d44-54e8-1090-66e15bd4b75c',NULL,0,NULL,'AB_Comission Test','','1'),('a294037c-ebf3-af14-b932-69047b93098b','Commission Coup de pouce TPE SC du 19/11/2025',NULL,'2025-10-31 09:02:19','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,'','Commission Coup de pouce TPE SC du 19/11/2025',NULL,'1'),('d24b6865-799c-1bcf-2a96-69047bb12629','OP_commission',NULL,'2025-10-31 09:05:02','c4250303-bf3c-53d5-45a9-66e15bb9cb43','c4250303-bf3c-53d5-45a9-66e15bb9cb43',NULL,0,NULL,'OP_commission','','1'),('a865bde4-b834-ff7d-5354-69047b918d72','AB_ComTest',NULL,'2025-10-31 09:06:02','81297ee7-4d44-54e8-1090-66e15bd4b75c','81297ee7-4d44-54e8-1090-66e15bd4b75c',NULL,0,NULL,'AB_ComTest','','1');

--
-- Table structure for table `ops_commission_audit`
--

CREATE TABLE `ops_commission_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_commission_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_commission_audit`
--

INSERT INTO `ops_commission_audit` VALUES ('32d7cf0f-dd10-0721-440f-64e7102ebf0c','715b7705-7e9e-bb57-b3b2-64286539229a','2023-08-24 08:10:52','1','name','name','6 avril 2023','6 octobre 2023',NULL,NULL),('35f4d01f-5513-be06-7309-64e710ec80a3','715b7705-7e9e-bb57-b3b2-64286539229a','2023-08-24 08:10:52','1','libelle_court','varchar','6 avril 2023','6 octobre 2023',NULL,NULL),('262e2c40-8c58-ee34-dc72-64e710d599d5','32f8fee1-7a69-4ec6-1bdc-642865b93a2f','2023-08-24 08:11:02','1','name','name','17 mai 2023','17 novembre 2023',NULL,NULL),('26612c6b-3bec-2ad2-1f52-64e710a31ecd','32f8fee1-7a69-4ec6-1bdc-642865b93a2f','2023-08-24 08:11:02','1','libelle_court','varchar','17 mai 2023','17 novembre 2023',NULL,NULL),('49a73bdd-0759-962a-7962-651ae0d7cfb0','715b7705-7e9e-bb57-b3b2-64286539229a','2023-10-02 15:22:37','1','name','name','6 octobre 2023','25 octobre 2023',NULL,NULL),('49d59e06-3611-f53a-a4d9-651ae09d819d','715b7705-7e9e-bb57-b3b2-64286539229a','2023-10-02 15:22:37','1','libelle_court','varchar','6 octobre 2023','25 octobre 2023',NULL,NULL),('80920b1b-7cda-3af2-f27e-651ae3f997c1','715b7705-7e9e-bb57-b3b2-64286539229a','2023-10-02 15:38:05','1','name','name','25 octobre 2023','2 octobre 2023',NULL,NULL),('823001a0-4d9d-e85c-fdb0-651ae392f88b','715b7705-7e9e-bb57-b3b2-64286539229a','2023-10-02 15:38:05','1','libelle_court','varchar','25 octobre 2023','2 octobre 2023',NULL,NULL),('21c66ac1-3ad2-c6c8-f8eb-65522649e36f','715b7705-7e9e-bb57-b3b2-64286539229a','2023-11-13 13:38:54','1','name','name','2 octobre 2023','18 décembre 2023',NULL,NULL),('23697ce2-3f2f-b59e-bea9-655226cca0ce','715b7705-7e9e-bb57-b3b2-64286539229a','2023-11-13 13:38:54','1','libelle_court','varchar','2 octobre 2023','18 décembre 2023',NULL,NULL),('e9d7e911-944b-1724-1c66-655226064a5f','32f8fee1-7a69-4ec6-1bdc-642865b93a2f','2023-11-13 13:39:07','1','name','name','17 novembre 2023','22 novembre 2023',NULL,NULL),('e9f3706c-c6be-df52-f7e5-6552262853e3','32f8fee1-7a69-4ec6-1bdc-642865b93a2f','2023-11-13 13:39:07','1','libelle_court','varchar','17 novembre 2023','22 novembre 2023',NULL,NULL),('3a1cc905-43ff-9de8-7a5c-65b24d1ea241','715b7705-7e9e-bb57-b3b2-64286539229a','2024-01-25 12:01:07','1','name','name','18 décembre 2023','18 avril 2024',NULL,NULL),('3ccd4496-c46e-0a02-fb69-65b24db97330','715b7705-7e9e-bb57-b3b2-64286539229a','2024-01-25 12:01:07','1','libelle_court','varchar','18 décembre 2023','18 avril 2024',NULL,NULL),('431cb238-037f-e413-0170-65b24d5fcbc2','32f8fee1-7a69-4ec6-1bdc-642865b93a2f','2024-01-25 12:02:03','1','name','name','22 novembre 2023','27 mars 2024',NULL,NULL),('43499682-3859-4156-c6de-65b24d501c7c','32f8fee1-7a69-4ec6-1bdc-642865b93a2f','2024-01-25 12:02:03','1','libelle_court','varchar','22 novembre 2023','27 mars 2024',NULL,NULL),('e29ef423-f3cc-1c1e-0aeb-66794d171d0f','32f8fee1-7a69-4ec6-1bdc-642865b93a2f','2024-06-24 10:43:30','1','name','name','27 mars 2024','10 septembre 2024',NULL,NULL),('e31a57f2-b681-fda3-15da-66794db178f4','32f8fee1-7a69-4ec6-1bdc-642865b93a2f','2024-06-24 10:43:30','1','libelle_court','varchar','27 mars 2024','10 septembre 2024',NULL,NULL),('46f10133-06bf-5090-fc54-66794db6b3fc','715b7705-7e9e-bb57-b3b2-64286539229a','2024-06-24 10:43:59','1','name','name','18 avril 2024','18 octobre 2024',NULL,NULL),('4706abda-c8e3-9ea5-e401-66794d954eea','715b7705-7e9e-bb57-b3b2-64286539229a','2024-06-24 10:43:59','1','libelle_court','varchar','18 avril 2024','18 octobre 2024',NULL,NULL),('7d6af848-0e2a-ffdc-77f6-66794e5fce26','61d35938-a119-a080-6bf1-666ae6968015','2024-06-24 10:44:42','1','name','name','commission du 24-06','5 novembre 2024',NULL,NULL),('7d87d724-e3c9-4c68-9ad9-66794eb22057','61d35938-a119-a080-6bf1-666ae6968015','2024-06-24 10:44:42','1','libelle_court','varchar','commission du 24-06','5 novembre 2024',NULL,NULL),('c9849e56-6da2-7f25-56e5-67b72dfc037a','2fed6442-7c45-7df5-1039-67b72de034f8','2025-02-20 13:25:55','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','libelle_long','varchar','','LM',NULL,NULL),('a04416bf-849b-b8e7-8e5d-68b9a5b606be','4693f3a9-6323-2b37-6c69-68b8363db236','2025-09-04 14:43:13','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','name','name','Commission test ','Commission test Alice',NULL,NULL),('a0ae0802-8642-3cad-55fe-68b9a576d3cd','4693f3a9-6323-2b37-6c69-68b8363db236','2025-09-04 14:43:13','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','libelle_court','varchar','Commission test ','Commission test Alice',NULL,NULL);

--
-- Table structure for table `ops_commission_documents`
--

CREATE TABLE `ops_commission_documents` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_commission_id` varchar(36) DEFAULT NULL,
  `document_id` varchar(36) DEFAULT NULL,
  `document_revision_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_commission_documents_ida1` (`ops_commission_id`),
  KEY `ops_commission_documents_alt` (`document_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_commission_documents`
--


--
-- Table structure for table `ops_commission_ops_contrat`
--

CREATE TABLE `ops_commission_ops_contrat` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_commission_id` varchar(36) DEFAULT NULL,
  `ops_contrat_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_commission_ops_contrat_ida1` (`ops_commission_id`),
  KEY `ops_commission_ops_contrat_alt` (`ops_contrat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_commission_ops_contrat`
--


--
-- Table structure for table `ops_commission_ops_dossier`
--

CREATE TABLE `ops_commission_ops_dossier` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_dossier_id` varchar(36) DEFAULT NULL,
  `ops_commission_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_commission_ops_dossier_alt` (`ops_commission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_commission_ops_dossier`
--

INSERT INTO `ops_commission_ops_dossier` VALUES ('f3df8865-2856-d790-e6ee-642995782b98','2023-04-02 14:47:10',0,'dec717c3-944b-c29e-32b5-642859513777','715b7705-7e9e-bb57-b3b2-64286539229a'),('ea900878-a70d-2659-b80a-64a83a4ca189','2023-10-02 15:38:55',1,'e757d5b0-4f34-19df-4824-6494b0c1c0a5','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('44f95bbb-d8fd-2f81-d70a-64a83a1a2ce9','2024-02-26 07:14:33',1,'58169f71-f103-2ff8-c79d-6488648d2c73','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('26f70526-40b6-e668-eaf2-64a84b864cd5','2023-07-07 17:29:12',0,'7943a5d3-07f4-3153-0626-64a7d08fca5e','715b7705-7e9e-bb57-b3b2-64286539229a'),('2a63cddd-e928-67a3-aed3-64a84bd78248','2023-07-07 17:29:12',0,'b9b9ac3a-4510-5620-dbe5-64a7c5adb0d3','715b7705-7e9e-bb57-b3b2-64286539229a'),('2d1e188e-6f4a-84e9-29f2-64a84b5221a2','2023-07-07 17:29:12',0,'7644eefe-c966-4d8c-0587-64a7c2f79e84','715b7705-7e9e-bb57-b3b2-64286539229a'),('2b5496af-b4d3-334a-6ad6-64e7117061d5','2024-09-04 11:52:38',1,'3573056e-f3d4-5abb-7dd0-64e70d48964c','715b7705-7e9e-bb57-b3b2-64286539229a'),('9fb3d7bc-94fe-0990-aec0-650458b96aef','2023-10-02 15:40:06',1,'efd2480c-54cd-8e37-9538-65044da1b799','715b7705-7e9e-bb57-b3b2-64286539229a'),('a6ed1737-ff45-0100-6d3f-6504585ebca6','2024-09-04 11:52:38',1,'3573056e-f3d4-5abb-7dd0-64e70d48964c','715b7705-7e9e-bb57-b3b2-64286539229a'),('9f72c283-906f-6e4a-0d47-651adf811bfa','2023-10-02 15:40:06',1,'efd2480c-54cd-8e37-9538-65044da1b799','715b7705-7e9e-bb57-b3b2-64286539229a'),('9ba00747-e678-faf1-045b-651adfbe86d3','2023-10-02 15:40:06',1,'efd2480c-54cd-8e37-9538-65044da1b799','715b7705-7e9e-bb57-b3b2-64286539229a'),('85e200ea-02a1-5851-cb6a-651ae008d747','2024-09-04 11:52:38',1,'3573056e-f3d4-5abb-7dd0-64e70d48964c','715b7705-7e9e-bb57-b3b2-64286539229a'),('b3520f50-68ca-8b98-2876-651ae2ce3c98','2024-09-04 11:52:38',1,'3573056e-f3d4-5abb-7dd0-64e70d48964c','715b7705-7e9e-bb57-b3b2-64286539229a'),('983434a0-a0be-33cb-c6b6-651ae33182ff','2024-09-04 11:52:38',1,'8efe16ff-3f1b-1c94-d91d-64e71924eb86','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('f3f0ca17-f2f6-17cc-09a2-651ae4541aff','2023-10-02 15:38:55',0,'e757d5b0-4f34-19df-4824-6494b0c1c0a5','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('834b737c-1a01-a771-25a7-651ae46c2840','2024-09-04 11:52:38',1,'8efe16ff-3f1b-1c94-d91d-64e71924eb86','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('e21766c4-b711-7a53-830e-651ae4cf22f0','2024-02-26 07:14:33',1,'58169f71-f103-2ff8-c79d-6488648d2c73','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('7319955e-f01e-015b-2930-651ae4235e9b','2023-10-02 15:40:06',0,'efd2480c-54cd-8e37-9538-65044da1b799','715b7705-7e9e-bb57-b3b2-64286539229a'),('d90bcfc2-6994-572d-8e94-651c12a3a295','2024-09-04 12:28:42',1,'4ff66170-1baf-c948-93bb-651c08a5c978','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('13351012-4b8a-d7df-6c1a-6526628dc346','2024-09-04 12:28:42',1,'e7842f25-35b3-12e6-f930-65265abbec93','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('81c758a6-3c1d-ecf1-3f02-652663ecb033','2024-09-04 12:28:42',1,'e7842f25-35b3-12e6-f930-65265abbec93','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('ee935817-cd9e-a4cd-1f55-652f8df689d4','2024-02-26 07:26:55',1,'26cc4c33-ebf1-f088-c962-652f878378a5','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('21de99a3-2e58-5f00-3863-652fda3680aa','2024-03-28 06:48:37',1,'c163e312-eed0-0fa5-f445-652fd1f41035','715b7705-7e9e-bb57-b3b2-64286539229a'),('cd2500bb-be6c-4535-cfe6-655239cc47b5','2024-09-04 12:28:42',1,'3b6cfcdb-c22e-2946-1a28-655230f7e9d0','715b7705-7e9e-bb57-b3b2-64286539229a'),('3f6800e2-05d4-bed6-5755-65b24044d2c6','2024-01-25 15:37:54',1,'503c7bca-de4c-4dd8-9601-65b0ea845d5a','715b7705-7e9e-bb57-b3b2-64286539229a'),('7ec50bc7-fbe1-649f-8a53-65b240b8eaf4','2024-01-25 15:37:54',1,'e1840acb-d9db-1d5b-be6d-65b0dcb6d167','715b7705-7e9e-bb57-b3b2-64286539229a'),('b4518fca-3cdd-2000-4ce1-65b280541adb','2024-09-04 11:55:02',1,'503c7bca-de4c-4dd8-9601-65b0ea845d5a','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('b8ecbf98-1132-f86a-e4e7-65b280cf383c','2024-09-04 11:55:02',1,'e1840acb-d9db-1d5b-be6d-65b0dcb6d167','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('bf177811-c031-ebb4-ea8d-65b2800c3b03','2024-09-04 11:55:02',1,'5f4d8356-60fa-836e-f2c0-65afc5f8dc38','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('e3740867-7391-e984-ca30-65d4d72c623d','2024-02-21 10:24:09',1,'ec740e5e-cd50-7fc1-6cba-65d4d48dabb0','715b7705-7e9e-bb57-b3b2-64286539229a'),('15097dcd-d3bf-59ab-02fb-65d5cfc06244','2024-06-24 14:23:17',1,'7dbd2fe9-6aa8-0073-f4c6-65d5bc318902','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('194c85d5-8922-04ab-0b87-65d5cfd01fd1','2024-08-30 18:44:07',1,'ec740e5e-cd50-7fc1-6cba-65d4d48dabb0','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('119326a7-7459-8152-fa6b-65d5cf02f05a','2024-06-24 14:23:17',1,'7dbd2fe9-6aa8-0073-f4c6-65d5bc318902','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('e16a179c-57a4-f2ff-57a6-65fab6e6ba5d','2024-06-24 14:31:08',1,'c475ada6-69cb-0074-1797-65f49d7207dd','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('65793954-0ff3-4e77-9329-65fbe0484ef8','2024-08-30 18:44:02',1,'ec29044f-995f-bf37-d33a-65fbdc633948','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('74c5687e-264b-dfc2-27db-660eb0c4fab5','2024-06-24 14:30:49',1,'9a55eb67-ce77-df45-d2a9-660ead8e00d3','715b7705-7e9e-bb57-b3b2-64286539229a'),('9fa3a597-5d5a-3714-cb36-6614e5497427','2024-06-24 10:47:35',1,'f1ddcda2-81e6-bd86-f73a-6614e1e86361','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('af2c6c6a-d0ce-6e30-eac7-6617ebabfa33','2024-06-24 10:47:26',1,'880a5a63-9ea0-8f53-756a-6617e9023ee9','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('ea8520a3-2f6b-777b-dca6-662770c07946','2024-06-24 10:47:26',1,'880a5a63-9ea0-8f53-756a-6617e9023ee9','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('14297434-b49e-df8e-9d03-662b93b9fc38','2024-06-24 10:47:26',1,'880a5a63-9ea0-8f53-756a-6617e9023ee9','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('bbc20787-dbf8-573d-5ec2-662b9ca952bb','2024-08-30 18:44:02',1,'ec29044f-995f-bf37-d33a-65fbdc633948','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('a88d2d34-2aaa-1723-e745-662b9c235aa4','2024-08-30 18:44:02',1,'ec29044f-995f-bf37-d33a-65fbdc633948','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('3daf29d3-f24c-e7a8-ff38-66470e844eca','2024-08-30 18:47:37',1,'132b929b-16bd-c189-3569-663e1267b729','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('aac90b55-9cdf-7ab9-3dab-664f47d2e609','2024-06-24 10:47:02',1,'879f382a-5cf4-d999-24d1-663a1a162c56','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('5fffeb8b-2111-af0c-084f-6655e11b1ca2','2024-06-24 10:47:02',1,'879f382a-5cf4-d999-24d1-663a1a162c56','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('5b7ce2c2-c189-ecd5-9f6a-666ae7053ab6','2024-06-24 14:30:34',1,'88ad7cef-5802-9885-5193-666809b47326','61d35938-a119-a080-6bf1-666ae6968015'),('2087a26c-90b1-b3dc-1201-66714319afc9','2024-06-24 14:24:50',1,'c357fb89-e829-aeee-b0f8-66713d85eaaa','61d35938-a119-a080-6bf1-666ae6968015'),('368651b6-2ec8-5acc-9c91-667841e1f90b','2024-06-24 14:24:50',1,'c357fb89-e829-aeee-b0f8-66713d85eaaa','61d35938-a119-a080-6bf1-666ae6968015'),('4313b7b0-34b9-a5c0-0acd-6678426d388f','2024-06-24 14:30:34',1,'88ad7cef-5802-9885-5193-666809b47326','61d35938-a119-a080-6bf1-666ae6968015'),('a03d6f42-131f-916b-b7f3-667842631467','2024-06-24 10:47:02',1,'879f382a-5cf4-d999-24d1-663a1a162c56','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('ce1cbdda-9018-10f2-8e6a-667842200a83','2024-06-24 10:47:26',1,'880a5a63-9ea0-8f53-756a-6617e9023ee9','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('43147d36-384a-9570-836d-667842d6db8b','2024-06-24 10:47:35',1,'f1ddcda2-81e6-bd86-f73a-6614e1e86361','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('752aa9a4-6760-2073-98ee-667842b005ac','2024-06-24 14:30:49',1,'9a55eb67-ce77-df45-d2a9-660ead8e00d3','715b7705-7e9e-bb57-b3b2-64286539229a'),('767694b9-458a-d476-7720-66784200b3fa','2024-08-30 18:44:02',1,'ec29044f-995f-bf37-d33a-65fbdc633948','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('8f379ec0-1a76-869a-bc90-667843c339f8','2024-06-24 14:31:08',1,'c475ada6-69cb-0074-1797-65f49d7207dd','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('dfd84edf-c22f-4805-2dc8-6678436c0043','2024-06-24 14:23:17',1,'7dbd2fe9-6aa8-0073-f4c6-65d5bc318902','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('a909b5ad-1f87-077c-ceea-6678434b04a0','2024-08-30 18:44:07',1,'ec740e5e-cd50-7fc1-6cba-65d4d48dabb0','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('c185012d-cfdb-4e61-c408-66784377fadf','2024-09-04 11:55:02',1,'503c7bca-de4c-4dd8-9601-65b0ea845d5a','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('a4e31568-9021-9c41-2628-6678436bf14f','2024-09-04 11:55:02',1,'e1840acb-d9db-1d5b-be6d-65b0dcb6d167','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('a5525be4-e45e-8400-71fc-6678435707f7','2024-09-04 11:55:02',1,'5f4d8356-60fa-836e-f2c0-65afc5f8dc38','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('57d04821-a9b7-4ec0-1d11-667843f55d9b','2024-09-04 12:28:42',1,'3b6cfcdb-c22e-2946-1a28-655230f7e9d0','715b7705-7e9e-bb57-b3b2-64286539229a'),('6263ae6b-125c-c251-6afc-6678431e9329','2024-09-04 12:28:42',1,'e7842f25-35b3-12e6-f930-65265abbec93','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('59a54a06-752b-bc4c-d408-667843011ca6','2024-09-04 11:52:38',1,'8efe16ff-3f1b-1c94-d91d-64e71924eb86','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('3d4fff8c-310b-5531-9eee-667843b00e40','2024-09-04 11:52:38',1,'3573056e-f3d4-5abb-7dd0-64e70d48964c','715b7705-7e9e-bb57-b3b2-64286539229a'),('7bcc4db4-32f9-fa9d-968f-66794efab28d','2024-06-24 10:47:02',0,'879f382a-5cf4-d999-24d1-663a1a162c56','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('445e5330-e185-39ed-0465-66794e2a7d0c','2024-06-24 10:47:26',0,'880a5a63-9ea0-8f53-756a-6617e9023ee9','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('28c2beba-2dfb-2693-a2c6-66794eaa3978','2024-06-24 10:47:35',0,'f1ddcda2-81e6-bd86-f73a-6614e1e86361','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('5d6587f8-6d89-dee2-4f4e-66794eb9f89e','2024-08-30 18:44:02',1,'ec29044f-995f-bf37-d33a-65fbdc633948','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('3f5a3d1c-78a1-dbb9-d9f3-66794e12aa3c','2024-06-24 14:23:17',1,'7dbd2fe9-6aa8-0073-f4c6-65d5bc318902','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('f3510392-3b85-5d2a-dbea-66794e007848','2024-08-30 18:44:07',1,'ec740e5e-cd50-7fc1-6cba-65d4d48dabb0','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('aaeeba08-e58a-3a47-c443-66794e39a14c','2024-08-30 18:44:07',1,'ec740e5e-cd50-7fc1-6cba-65d4d48dabb0','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('d2080120-8f07-4487-294c-66794e47e22b','2024-09-04 11:55:02',1,'503c7bca-de4c-4dd8-9601-65b0ea845d5a','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('585442d9-ac84-8768-2c55-66794edb8575','2024-09-04 11:55:02',1,'e1840acb-d9db-1d5b-be6d-65b0dcb6d167','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('9aa57459-309b-e3d9-060f-66794e814fad','2024-09-04 11:55:02',1,'5f4d8356-60fa-836e-f2c0-65afc5f8dc38','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('983300c9-90f8-ec0f-7d31-66794f9a520e','2024-09-04 11:52:38',1,'8efe16ff-3f1b-1c94-d91d-64e71924eb86','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('7ffeb650-4901-69c5-e7d4-66794f42d4ad','2024-06-24 14:24:50',1,'c357fb89-e829-aeee-b0f8-66713d85eaaa','61d35938-a119-a080-6bf1-666ae6968015'),('229807b2-bd0b-813c-962d-66794fed942f','2024-06-24 14:30:34',1,'88ad7cef-5802-9885-5193-666809b47326','61d35938-a119-a080-6bf1-666ae6968015'),('a416300e-1e8b-a88a-649d-66794ffb072f','2024-06-24 14:30:49',1,'9a55eb67-ce77-df45-d2a9-660ead8e00d3','715b7705-7e9e-bb57-b3b2-64286539229a'),('868e77f5-f410-9b30-b476-667950d3e82c','2024-06-24 14:30:34',1,'88ad7cef-5802-9885-5193-666809b47326','61d35938-a119-a080-6bf1-666ae6968015'),('e330fd15-6309-47dd-177e-667950936232','2024-06-24 14:30:34',1,'88ad7cef-5802-9885-5193-666809b47326','61d35938-a119-a080-6bf1-666ae6968015'),('89e80dcb-f907-3d35-b002-667950085ba8','2024-06-24 14:23:17',1,'7dbd2fe9-6aa8-0073-f4c6-65d5bc318902','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('7cea0808-a53a-c0ab-1da0-6679506123fd','2024-08-30 18:44:07',1,'ec740e5e-cd50-7fc1-6cba-65d4d48dabb0','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('e34dc49e-7a85-ea29-faad-667951471239','2024-09-04 11:55:02',1,'503c7bca-de4c-4dd8-9601-65b0ea845d5a','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('4c1c0290-90d3-115b-c841-6679513f818b','2024-09-04 11:55:02',1,'5f4d8356-60fa-836e-f2c0-65afc5f8dc38','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('d5c543d5-e803-04ac-a8ca-667951f74892','2024-06-24 14:31:08',1,'c475ada6-69cb-0074-1797-65f49d7207dd','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('a4f8f7df-1d2f-93d3-4db5-66797f2d7eca','2024-09-04 11:55:02',1,'5f4d8356-60fa-836e-f2c0-65afc5f8dc38','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('ce9b92c1-d0ff-423a-1f05-6679805c3264','2024-08-30 18:44:07',1,'ec740e5e-cd50-7fc1-6cba-65d4d48dabb0','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('39e345be-9591-bc92-dece-6679819dee01','2024-09-04 11:55:02',1,'5f4d8356-60fa-836e-f2c0-65afc5f8dc38','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('526bcc96-7718-2ca6-1970-667981780cdd','2024-06-24 14:23:17',0,'7dbd2fe9-6aa8-0073-f4c6-65d5bc318902','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('d07c0abf-ebe8-e706-a86c-66798114b8e5','2024-09-04 11:52:38',1,'3573056e-f3d4-5abb-7dd0-64e70d48964c','715b7705-7e9e-bb57-b3b2-64286539229a'),('ecf14eaf-5614-f042-8fbf-667981f57c62','2024-09-04 11:55:02',1,'e1840acb-d9db-1d5b-be6d-65b0dcb6d167','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('22aa96bf-04bf-5c82-9819-66798159232e','2024-06-24 14:24:50',0,'c357fb89-e829-aeee-b0f8-66713d85eaaa','61d35938-a119-a080-6bf1-666ae6968015'),('33ef9545-6cb6-ed92-f685-667981cadbdd','2024-08-30 18:44:02',1,'ec29044f-995f-bf37-d33a-65fbdc633948','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('93eee875-6ac9-4cfb-a821-667981bd2272','2024-09-04 12:28:42',1,'3b6cfcdb-c22e-2946-1a28-655230f7e9d0','715b7705-7e9e-bb57-b3b2-64286539229a'),('b0e03508-efb7-8d06-db4e-66798148f1ce','2024-09-04 11:52:38',1,'8efe16ff-3f1b-1c94-d91d-64e71924eb86','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('10fb0769-7470-a815-e226-66798376fa6a','2024-06-24 14:30:34',0,'88ad7cef-5802-9885-5193-666809b47326','61d35938-a119-a080-6bf1-666ae6968015'),('ecc7f2f5-93b9-e68e-8072-66798354759f','2024-06-24 14:30:49',0,'9a55eb67-ce77-df45-d2a9-660ead8e00d3','715b7705-7e9e-bb57-b3b2-64286539229a'),('1b3cab2b-bb44-a85c-66dc-667983b53459','2024-06-24 14:31:08',0,'c475ada6-69cb-0074-1797-65f49d7207dd','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('8978f628-7d91-a11b-2345-667983bb7451','2024-09-04 12:28:42',1,'e7842f25-35b3-12e6-f930-65265abbec93','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('45328154-2095-847f-f21e-667983855ce7','2024-09-04 12:28:42',1,'e7842f25-35b3-12e6-f930-65265abbec93','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('9f963777-ea9f-25e4-024f-667983edf7c9','2024-09-04 12:28:42',1,'e7842f25-35b3-12e6-f930-65265abbec93','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('d8af7b8f-f932-75ca-e631-66d2121a7226','2024-08-30 18:44:02',0,'ec29044f-995f-bf37-d33a-65fbdc633948','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('6cdec479-b322-5100-f0e6-66d212af2765','2024-08-30 18:44:07',0,'ec740e5e-cd50-7fc1-6cba-65d4d48dabb0','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('13c8c5f5-2eb5-cf6f-0ce8-66d213c42ff0','2024-09-04 11:55:02',1,'e1840acb-d9db-1d5b-be6d-65b0dcb6d167','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('1cfe3d93-7913-c3cc-0ad7-66d213638273','2024-09-04 12:28:42',1,'4ff66170-1baf-c948-93bb-651c08a5c978','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('965e9560-2c46-1998-1b4b-66d213905b8b','2024-08-30 18:47:37',0,'132b929b-16bd-c189-3569-663e1267b729','32f8fee1-7a69-4ec6-1bdc-642865b93a2f'),('5a389b41-e905-2d8b-6886-66fab56eabb7','2024-09-30 14:30:06',0,'55455a2f-0b91-1f8d-7181-66fab5680d04','715b7705-7e9e-bb57-b3b2-64286539229a'),('88e70d99-d18b-ad1b-c94b-674dc09b7dfb','2024-12-02 14:14:59',0,'d8f54698-39a9-47b6-2796-6748315c11cb','715b7705-7e9e-bb57-b3b2-64286539229a'),('9fc19daf-6c4f-937e-850e-674dc29c5f6a','2025-02-07 08:36:54',1,'928e0998-4a2a-5fbc-a1e9-674dbacd69cf','399e73b6-d499-e353-2cde-674dc28a2783'),('da2951a0-8949-848b-60d6-67a5c6eeb8c1','2025-02-07 08:36:54',0,'ccd41f17-58df-505d-c9a7-67a4a1860fc0','61d35938-a119-a080-6bf1-666ae6968015'),('dcde7c02-6614-0188-734c-67a5c6267e82','2025-02-07 08:36:54',0,'dff04d11-4ce7-bc11-2139-6756b7c948dd','61d35938-a119-a080-6bf1-666ae6968015'),('de5935c3-5e1b-15b9-f28f-67a5c687869f','2025-02-07 08:36:54',0,'f7540819-9b02-9636-dcd5-674dce7b942c','61d35938-a119-a080-6bf1-666ae6968015'),('e0670a71-4258-7b22-76b1-67a5c681fe27','2025-02-07 08:36:54',0,'928e0998-4a2a-5fbc-a1e9-674dbacd69cf','61d35938-a119-a080-6bf1-666ae6968015'),('9766a3c4-8cee-8174-4526-67b72ff00969','2025-02-20 13:36:12',0,'4524beee-c181-2410-0562-67ae01d4d63b','2fed6442-7c45-7df5-1039-67b72de034f8'),('ed2e360d-74fd-5f76-c826-67b7305d1a3c','2025-02-20 13:38:35',0,'e13a3f5c-1717-a9f6-35c6-67ae08a59617','af3ff3d7-af64-a5c6-5ac6-67b72d7d9f85'),('98d00832-3c5f-40ab-29e2-682c53e1d0d6','2025-05-20 10:04:35',1,'a1d42296-845a-5d21-be7b-682c4dd0fe47','399e73b6-d499-e353-2cde-674dc28a2783'),('a86dd943-7d24-8142-bc5e-682c534ecb09','2025-05-20 10:04:35',0,'a1d42296-845a-5d21-be7b-682c4dd0fe47','c0e982de-0554-783c-8dd3-682c53b26adb'),('7912e444-6349-f039-747a-68b6b46b2286','2025-09-02 09:10:50',1,'93744285-8476-81a7-913e-68b6b2c04f7a','ae24af3d-4719-2d01-c289-68b6b361f63d'),('87f7b5c3-b379-01ce-4b1d-68b6b4d82d12','2025-09-02 09:10:50',0,'93744285-8476-81a7-913e-68b6b2c04f7a','ae24af3d-4719-2d01-c289-68b6b361f63d'),('c3dd475a-d315-e410-c419-68b9a5621770','2025-09-04 14:41:45',0,'c951c9a4-83a6-3c25-4497-68b9855f0fb6','4693f3a9-6323-2b37-6c69-68b8363db236'),('b24b80f2-154e-946b-27e8-68dcd6fe4683','2025-10-01 07:42:32',1,'91040b57-1930-2251-414e-68dba64c91c2','40be4c00-1f96-d64f-529a-68dcd5b48627'),('ca597bdc-1621-ffda-66cc-68dcd9097c40','2025-10-01 07:50:14',1,'315d3f17-a896-5e8a-f1d3-68dbab060dcb','715b7705-7e9e-bb57-b3b2-64286539229a'),('cd733d40-9b1e-42ac-b529-68dcd9da56d6','2025-10-01 07:40:57',1,'71210ef6-c039-8bc2-af20-68dba37a2d0c','715b7705-7e9e-bb57-b3b2-64286539229a'),('d030c181-14e9-f084-c9b4-68dcd9b85745','2025-10-01 07:32:31',0,'137792a4-df3b-bbf3-1a72-68db984be19b','715b7705-7e9e-bb57-b3b2-64286539229a'),('d18c128e-47d8-27af-99b2-68dcd920c54e','2025-10-01 07:32:31',0,'6065839f-bb81-e125-70c1-68db956133a2','715b7705-7e9e-bb57-b3b2-64286539229a'),('d2e6dbbe-eab1-d095-1709-68dcd981d05b','2025-10-01 07:32:31',0,'c99e45a8-eeee-af3e-65cf-68db95d87739','715b7705-7e9e-bb57-b3b2-64286539229a'),('d44237e7-5ff5-93e5-d6c1-68dcd977fd84','2025-10-01 07:32:31',0,'cbc437ab-7d2c-527e-6c34-68db93ebb515','715b7705-7e9e-bb57-b3b2-64286539229a'),('3c915033-984d-81dd-46cc-68dcdb491da8','2025-10-01 07:41:22',1,'71210ef6-c039-8bc2-af20-68dba37a2d0c','9eea7b02-fd14-eb88-f725-68dcd9c99733'),('3a6c9272-9043-96c5-1841-68dcdb09ea52','2025-10-01 07:41:22',0,'71210ef6-c039-8bc2-af20-68dba37a2d0c','9eea7b02-fd14-eb88-f725-68dcd9c99733'),('e27d9352-c146-aae9-51d3-68dcdb50d275','2025-10-01 07:50:14',1,'315d3f17-a896-5e8a-f1d3-68dbab060dcb','715b7705-7e9e-bb57-b3b2-64286539229a'),('e29a2262-71f3-068a-5c2b-68dcdb3b1a47','2025-10-01 07:42:32',0,'91040b57-1930-2251-414e-68dba64c91c2','acde2da5-194f-6961-a59e-68dcdaa0e228'),('79700a42-2037-416f-9132-68dcdb2fb40b','2025-10-01 07:50:14',1,'315d3f17-a896-5e8a-f1d3-68dbab060dcb','715b7705-7e9e-bb57-b3b2-64286539229a'),('302b622e-bf4c-827d-aa94-68dcdd32525c','2025-10-01 07:50:14',0,'315d3f17-a896-5e8a-f1d3-68dbab060dcb','6fe61801-dace-ca49-a2ef-68dcda1dfa58'),('4134fd53-e64f-800c-816e-68f7422fab09','2025-10-31 09:08:59',1,'59667b62-e099-180d-a701-68f740afb3c1','715b7705-7e9e-bb57-b3b2-64286539229a'),('1a33047d-6761-93fc-3841-68f74212512b','2025-10-31 09:08:59',1,'59667b62-e099-180d-a701-68f740afb3c1','715b7705-7e9e-bb57-b3b2-64286539229a'),('4729dab8-042d-f9bb-b6ac-68f742445a50','2025-10-31 09:08:59',1,'59667b62-e099-180d-a701-68f740afb3c1','715b7705-7e9e-bb57-b3b2-64286539229a'),('de049bd1-2547-12df-fcff-68f7434bfced','2025-10-31 09:08:59',1,'59667b62-e099-180d-a701-68f740afb3c1','715b7705-7e9e-bb57-b3b2-64286539229a'),('e75acaa0-cf71-5e3d-c676-69047bc45c52','2025-10-31 09:08:59',1,'bfa78423-c096-64d5-bf13-68ff94cd740e','a294037c-ebf3-af14-b932-69047b93098b'),('bacd7a9e-30fe-6dd4-f0f2-69047ca914cb','2025-10-31 09:07:52',1,'3d006894-e2e5-6db9-35d8-68ff94443408','d24b6865-799c-1bcf-2a96-69047bb12629'),('790a0d61-7f0f-22c3-6e8c-69047c01962a','2025-10-31 09:07:52',0,'3d006894-e2e5-6db9-35d8-68ff94443408','61d35938-a119-a080-6bf1-666ae6968015'),('7a87091c-b747-2c0c-4705-69047c305152','2025-10-31 09:07:52',0,'d19d0946-e7c3-330b-a2ed-68ff947a00d6','61d35938-a119-a080-6bf1-666ae6968015'),('9ebec204-e3f6-cb80-ac02-69047cd78a09','2025-10-31 09:08:59',0,'bfa78423-c096-64d5-bf13-68ff94cd740e','a294037c-ebf3-af14-b932-69047b93098b'),('a0435b2e-f4e6-20eb-09c5-69047c35d0b0','2025-10-31 09:08:59',0,'14c6a7f5-7216-14e8-4789-68ff83fb0cd0','a294037c-ebf3-af14-b932-69047b93098b'),('a27e5e15-7409-f173-c6f2-69047cee1e1d','2025-10-31 09:08:59',0,'59667b62-e099-180d-a701-68f740afb3c1','a294037c-ebf3-af14-b932-69047b93098b');

--
-- Table structure for table `ops_connecteur`
--

CREATE TABLE `ops_connecteur` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `url_api` varchar(255) DEFAULT NULL,
  `architecture` varchar(100) DEFAULT NULL,
  `type_connexion` varchar(100) DEFAULT NULL,
  `identifiant` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `path_connexion` varchar(255) DEFAULT NULL,
  `valeur_retour` varchar(255) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `name_token` varchar(255) DEFAULT NULL,
  `grant_type` varchar(255) DEFAULT NULL,
  `client_id` varchar(255) DEFAULT NULL,
  `client_secret` varchar(255) DEFAULT NULL,
  `scope` varchar(255) DEFAULT NULL,
  `auth_name_1` varchar(255) DEFAULT NULL,
  `auth_value_1` varchar(255) DEFAULT NULL,
  `auth_name_2` varchar(255) DEFAULT NULL,
  `auth_value_2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_connecteur`
--

INSERT INTO `ops_connecteur` VALUES ('1d40f7e3-5581-fde5-8f1e-64885cfcc4f2','Mon connecteur','2023-06-13 12:09:30','2023-06-13 12:09:30','1','1',NULL,0,NULL,'http','rest','token','','','','','','','','','','','','','','');

--
-- Table structure for table `ops_connecteur_audit`
--

CREATE TABLE `ops_connecteur_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_connecteur_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_connecteur_audit`
--


--
-- Table structure for table `ops_connecteur_ops_flux`
--

CREATE TABLE `ops_connecteur_ops_flux` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_connecteur_id` varchar(36) DEFAULT NULL,
  `ops_flux_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_connecteur_ops_flux_ida1` (`ops_connecteur_id`),
  KEY `ops_connecteur_ops_flux_alt` (`ops_flux_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_connecteur_ops_flux`
--

INSERT INTO `ops_connecteur_ops_flux` VALUES ('213ef9ba-391a-db66-b0e0-64885c3216e9','2023-06-13 12:10:44',0,'1d40f7e3-5581-fde5-8f1e-64885cfcc4f2','207ce8ef-2785-e472-a416-64885cef62d7');

--
-- Table structure for table `ops_contrat`
--

CREATE TABLE `ops_contrat` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `thematique` varchar(100) DEFAULT NULL,
  `interet` varchar(100) DEFAULT NULL,
  `ops_sous_territoire_id` char(36) DEFAULT NULL,
  `date_debut` date DEFAULT NULL,
  `date_fin` date DEFAULT NULL,
  `date_vote` date DEFAULT NULL,
  `date_signature` date DEFAULT NULL,
  `cloture` tinyint(1) DEFAULT 0,
  `montant_alloue_local` decimal(18,2) DEFAULT 0.00,
  `montant_consomme_local` decimal(18,2) DEFAULT 0.00,
  `montant_disponible_local` decimal(18,2) DEFAULT 0.00,
  `montant_alloue_territorial` decimal(18,2) DEFAULT 0.00,
  `montant_consomme_territorial` decimal(18,2) DEFAULT 0.00,
  `montant_disponible_territorial` decimal(18,2) DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_contrat`
--

INSERT INTO `ops_contrat` VALUES ('19b381f5-7816-94e7-b219-6569eccbae15','Contrat RL','2023-12-01 14:25:42','2023-12-01 14:25:42','1','1','',0,NULL,NULL,'territorial','','2023-12-04','2023-12-29',NULL,NULL,0,35000.00,0.00,0.00,12000.00,0.00,0.00),('20601084-c15e-f315-31e7-651adb372c00','Contrat de territoire n° 1','2023-10-02 15:01:46','2024-05-02 08:39:56','1','1','aaaa',0,'',NULL,'local','','2023-10-01','2023-12-31',NULL,'2023-12-19',0,10000.54,4959.00,5041.54,5000.00,2400.00,2600.00);

--
-- Table structure for table `ops_contrat_audit`
--

CREATE TABLE `ops_contrat_audit` (
  `id` char(36) NOT NULL,
  `parent_id` char(36) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `field_name` varchar(100) DEFAULT NULL,
  `data_type` varchar(100) DEFAULT NULL,
  `before_value_string` varchar(255) DEFAULT NULL,
  `after_value_string` varchar(255) DEFAULT NULL,
  `before_value_text` text DEFAULT NULL,
  `after_value_text` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ops_contrat_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_contrat_audit`
--


--
-- Table structure for table `ops_contrat_documents`
--

CREATE TABLE `ops_contrat_documents` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_contrat_id` varchar(36) DEFAULT NULL,
  `document_id` varchar(36) DEFAULT NULL,
  `document_revision_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_contrat_documents_ida1` (`ops_contrat_id`),
  KEY `ops_contrat_documents_alt` (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_contrat_documents`
--


--
-- Table structure for table `ops_contrat_ops_dossier`
--

CREATE TABLE `ops_contrat_ops_dossier` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_contrat_id` varchar(36) DEFAULT NULL,
  `ops_dossier_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_contrat_ops_dossier_ida1` (`ops_contrat_id`),
  KEY `ops_contrat_ops_dossier_alt` (`ops_dossier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_contrat_ops_dossier`
--


--
-- Table structure for table `ops_contrat_ops_personne_morale`
--

CREATE TABLE `ops_contrat_ops_personne_morale` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_personne_morale_id` varchar(36) DEFAULT NULL,
  `ops_contrat_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_contrat_ops_personne_morale_alt` (`ops_personne_morale_id`,`ops_contrat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_contrat_ops_personne_morale`
--


--
-- Table structure for table `ops_contrat_ops_programmation`
--

CREATE TABLE `ops_contrat_ops_programmation` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `ops_contrat_id` varchar(36) DEFAULT NULL,
  `ops_programmation_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_contrat_ops_programmation_ida1` (`ops_contrat_id`),
  KEY `ops_contrat_ops_programmation_alt` (`ops_programmation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_contrat_ops_programmation`
--


--
-- Table structure for table `ops_contrat_securitygroups`
--

CREATE TABLE `ops_contrat_securitygroups` (
  `id` varchar(36) NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `securitygroups_id` varchar(36) DEFAULT NULL,
  `ops_contrat_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ops_contrat_securitygroups_alt` (`securitygroups_id`,`ops_contrat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_contrat_securitygroups`
--


--
-- Table structure for table `ops_conversation`
--

CREATE TABLE `ops_conversation` (
  `id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT 0,
  `assigned_user_id` char(36) DEFAULT NULL,
  `parent_type` varchar(100) DEFAULT NULL,
  `parent_id` char(36) DEFAULT NULL,
  `statut` varchar(15) DEFAULT NULL,
  `stamp` varchar(20) DEFAULT NULL,
  `source_id` varchar(36) DEFAULT NULL,
  `origin` varchar(36) DEFAULT NULL,
  `prenom` varchar(100) DEFAULT NULL,
  `nom` varchar(100) DEFAULT NULL,
  `message` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ops_conversation`
--

INSERT INTO `ops_conversation` VALUES ('371ad722-e9b1-4556-a2e2-66e405267798','','2024-09-13 09:28:59','2024-09-13 09:29:27','1','1',NULL,0,'','OPS_dossier','efe94c1e-460c-d952-0ea0-66e405325019','lu','20240913112859216000','1','agent',NULL,'Administrator','Qm9uam91ciBjaGVyIHVzYWdlciwgbm91cyByZXN0b25zIMOgIHZvdHJlIGRpc3Bvc2l0aW9uIHBvdXIgLi4u'),('a43accb1-4f4f-5185-5204-66e40513f700','','2024-09-13 09:29:27','2024-09-13 09:29:45','1','1',NULL,0,'','OPS_dossier','973acc69-359d-aca5-dd04-66e40513cabd','lu','20240913112927662000','1','agent',NULL,'Administrator','Qm9uam91ciA7KQ=='),('b83fde81-b23b-5435-0eef-66e406a333f5','','2024-09-13 09:30:18','2024-09-13 09:30:18','1','1',NULL,0,NULL,'OPS_dossier','a71eee8a-7ffc-5490-70d3-66e40661fef7','nouveau','20240913113018738000','1','agent','','Administrator','SGV5ISDDp2EgdmEgYmllbiA/'),('47c83a3d-a3a6-5cd8-9281-66e4061c2856','','2024-09-13 09:31:00','2024-09-13 09:31:25','1','1',NULL,0,'','OPS_dossier','3db8f573-67e5-ea57-4527-66e405bc5f66','lu','20240913113100283000','1','agent',NULL,'Administrator','Q2UgdGV4dGUgc2VyYSBlbnZvecOpIGRhbnMgbGEgY29udmVyc2F0aW9uIMOgIGwmIzAzOTt1c2FnZXIgZMOocyBxdWUgbCYjMDM5O2FjdGlvbiBkZSBzdGF0dXQgc2VyYSBleMOpY3V0w6llLg=='),('8528108c-313c-565e-b254-66fab5d9c41d','','2024-09-30 14:30:06','2024-09-30 14:30:06','d84bd81b-83f8-4df1-9bf8-66e15cabfa6b','d84bd81b-83f8-4df1-9bf8-66e15cabfa6b',NULL,0,NULL,'OPS_dossier','55455a2f-0b91-1f8d-7181-66fab5680d04','nouveau','20240930163006535000','d84bd81b-83f8-4df1-9bf8-66e15cabfa6b','agent','','Formation 6','SGV5ISDDp2EgdmEgYmllbiA/'),('72c33708-d0bd-2f6a-f19f-67050737203d','','2024-10-08 10:19:36','2024-10-08 10:19:36','1','1',NULL,0,NULL,'OPS_dossier','95812164-4a46-5e80-a965-670507cdfdd8','nouveau','20241008121936459000','1','agent','','Administrator','dGVzdA=='),('6b96cdd2-80f7-1ace-73c5-6706521c3e05','','2024-10-09 09:52:30','2024-10-09 09:52:30','1','1',NULL,0,NULL,'OPS_dossier','904cbd95-439c-244a-e0cf-670652625224','nouveau','20241009115230431000','1','agent','','Administrator','SGV5ISDDp2EgdmEgYmllbiA/'),('ae6c5915-bcd4-b7bf-a084-67068dee1772','','2024-10-09 14:05:10','2024-10-09 14:05:10','1','1',NULL,0,NULL,'OPS_dossier','77855a54-2b4e-b2b7-1f12-67068d6ce566','nouveau','20241009160510705000','1','agent','','Administrator','Qm9uam91ciBldCBiaWVudmVudSAh'),('83d6d273-dc06-2f49-efdc-67068de63e78','','2024-10-09 14:05:59','2024-10-09 14:06:23','1','1',NULL,0,'','OPS_dossier','77855a54-2b4e-b2b7-1f12-67068d6ce566','lu','20241009160559519000','358e481e-4a74-580c-e951-66fab2eefdea','usager',NULL,NULL,'UXVlc3Rpb24gdXNhZ2Vy'),('1a13d58e-9aec-efba-0620-67068d8a3b8a','','2024-10-09 14:06:32','2024-10-09 14:06:32','1','1',NULL,0,NULL,'OPS_dossier','77855a54-2b4e-b2b7-1f12-67068d6ce566','nouveau','20241009160632096000','1','agent','','Administrator','csOpcG9uc2UgZGUgbCdhZ2VudA=='),('27fb4a82-5c65-cd78-a762-67068e25a734','','2024-10-09 14:07:23','2024-10-10 08:34:11','326c449b-a872-58d3-5ae2-66e15b07aa48','1',NULL,0,'','OPS_dossier','904cbd95-439c-244a-e0cf-670652625224','lu','20241009160723147000','358e481e-4a74-580c-e951-66fab2eefdea','usager',NULL,NULL,'UsOpcG9uZHU='),('9b0138ad-5432-133c-4407-67068f4c62b6','','2024-10-09 14:11:55','2024-10-09 14:11:55','1','1',NULL,0,NULL,'OPS_dossier','77855a54-2b4e-b2b7-1f12-67068d6ce566','nouveau','20241009161155625000','1','agent','','Administrator','dGVzdA=='),('c02039eb-6432-e108-a37f-67078f89fbea','','2024-10-10 08:24:33','2024-10-10 08:26:13','1','1',NULL,0,'','OPS_dossier','77855a54-2b4e-b2b7-1f12-67068d6ce566','lu','20241010102433770000','358e481e-4a74-580c-e951-66fab2eefdea','usager',NULL,NULL,'csOpcG9uc2UgdXNhZ2VyIDEwIG9jdA=='),('90deeea5-9d4a-2e0e-1c4d-670791f37c83','','2024-10-10 08:34:56','2024-10-10 08:34:56','326c449b-a872-58d3-5ae2-66e15b07aa48','326c449b-a872-58d3-5ae2-66e15b07aa48',NULL,0,NULL,'OPS_dossier','904cbd95-439c-244a-e0cf-670652625224','nouveau','20241010103456584000','326c449b-a872-58d3-5ae2-66e15b07aa48','agent','','Formation 4','Qm9uam91ciwKQ29udGVudSwgdGV4dGUgZXQgQ2llLg=='),('5bed9390-205c-1fa7-45d2-670792f51e3b','','2024-10-10 08:38:41','2024-10-10 08:39:14','e64475cf-02f9-b7e1-4f19-66e15ba04a6c','1',NULL,0,'','OPS_dossier','7f1c2c2a-3d39-e1c2-cecb-6707910058dd','lu','20241010103841362000','d24a3e74-ccb1-70c6-2b57-670784184303','usager',NULL,NULL,'alwmIzAzOTthaSB1biBzb3VjaSBwb3VyIHJlbXBsaXIgbW9uIGFkcmVzc2U='),('2aac2040-d589-b51a-3995-670792ffa513','','2024-10-10 08:39:44','2024-10-10 08:39:44','e64475cf-02f9-b7e1-4f19-66e15ba04a6c','e64475cf-02f9-b7e1-4f19-66e15ba04a6c',NULL,0,NULL,'OPS_dossier','7f1c2c2a-3d39-e1c2-cecb-6707910058dd','nouveau','20241010103944164000','e64475cf-02f9-b7e1-4f19-66e15ba04a6c','agent','','Formation 3','Yydlc3QgcXUnaWwgeSBhIHVuIGJ1ZywgYydlc3Qgbm9ybWFs'),('484d0835-e23c-6566-e9ee-67079371dfd7','','2024-10-10 08:41:54','2024-10-10 08:41:54','1','1',NULL,0,NULL,'OPS_dossier','16bcb229-77c1-1bf0-2ed7-67079201ed9c','nouveau','20241010104154286000','1','agent','','Administrator','[encoded data, 6160 characters]'),('9ab2336f-7a75-bcac-91a6-6707940ac547','','2024-10-10 08:48:43','2024-10-10 08:48:43','1','1',NULL,0,NULL,'OPS_dossier','bd425bd6-ff88-1d88-4bda-67079491aec6','nouveau','20241010104843622000','1','agent','','Administrator','[encoded data, 6160 characters]'),('936e8793-6fd0-3628-3e3c-670796b9efc3','','2024-10-10 08:55:02','2024-10-10 08:55:02','326c449b-a872-58d3-5ae2-66e15b07aa48','326c449b-a872-58d3-5ae2-66e15b07aa48',NULL,0,NULL,'OPS_dossier','d7d80a90-9919-76e1-1d22-670796be3be2','nouveau','20241010105502592000','326c449b-a872-58d3-5ae2-66e15b07aa48','agent','','Formation 4','Q291Y291ICE='),('d8d55e29-6e15-f221-b3e5-670796f4f2cc','','2024-10-10 08:56:39','2024-10-10 08:59:03','1','1',NULL,0,'','OPS_dossier','d7d80a90-9919-76e1-1d22-670796be3be2','lu','20241010105639871000','e6a70aca-1659-c27e-b93f-67078495949a','usager',NULL,NULL,'Q291Y291IEFsYWluICENCg=='),('a01c261a-8e04-f380-61de-67336b031ce7','','2024-11-12 14:51:29','2024-11-12 14:51:29','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','efe94c1e-460c-d952-0ea0-66e405325019','nouveau','20241112155129646000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','Qm9uam91ciwgbWVyY2kgZGUgYmllbiB2b3Vsb2lyIGNvbXBsZXRlciBsZSBCUC4uLg=='),('758af0ca-80ad-d617-d7d6-67336b3ab83f','','2024-11-12 14:53:10','2025-02-07 10:13:19','1','1',NULL,0,'','OPS_dossier','efe94c1e-460c-d952-0ea0-66e405325019','lu','20241112155310465000','ac9f2da6-248c-2d9b-7efc-66e3f90e9c50','usager',NULL,NULL,'TEUgYnAgZXN0IGVudm95w6kgw6AgcGFyaXQgZHUgLi4u'),('16c3f0d4-9573-97d8-3eda-67336b86cc8b','','2024-11-12 14:53:40','2024-11-12 14:53:40','1','1',NULL,0,NULL,'OPS_dossier','1e4484cf-ce06-d8b2-a718-67336b900dc4','nouveau','20241112155341083000','1','agent','','Administrator','Qm9uam91ciA7KQ=='),('871ae8a1-c1e2-4923-634f-67336ca68347','','2024-11-12 14:54:12','2024-11-12 14:54:12','7ca44aa3-d16b-0799-4128-66e15c64d2de','7ca44aa3-d16b-0799-4128-66e15c64d2de',NULL,0,NULL,'OPS_dossier','1e4484cf-ce06-d8b2-a718-67336b900dc4','nouveau','20241112155412543000','7ca44aa3-d16b-0799-4128-66e15c64d2de','agent','','Formation 7','dGVzdA=='),('f17c3e37-93a6-94df-87ec-67483115893b','','2024-11-28 09:03:29','2024-11-28 09:03:29','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','d8f54698-39a9-47b6-2796-6748315c11cb','nouveau','20241128100329978000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','Ym9uam91ciwKbWVyY2kgZCdlbnZveWVyIHZvdHJlIFJJQg=='),('9bc63c88-7c7a-b0d3-5824-67483208e421','','2024-11-28 09:05:16','2024-11-28 09:07:15','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','1',NULL,0,'','OPS_dossier','d8f54698-39a9-47b6-2796-6748315c11cb','lu','20241128100516592000','ac9f2da6-248c-2d9b-7efc-66e3f90e9c50','usager',NULL,NULL,'Y1wmIzAzOTtlc3QgZmFpdA=='),('49a6d4b0-b4f9-d938-92d6-674d92b2384a','','2024-12-02 10:56:30','2024-12-02 10:56:30','1','1',NULL,0,NULL,'OPS_dossier','86afb1b3-ce99-a4b4-cf70-674d92cd7057','nouveau','20241202115631283000','1','agent','','Administrator','[encoded data, 6160 characters]'),('81da1899-4c2a-efc3-1bed-674d94632c33','','2024-12-02 11:05:32','2024-12-02 11:05:32','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','4274ff95-9415-ff66-57a9-674d947d7b2b','nouveau','20241202120532521000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','[encoded data, 6160 characters]'),('e4bc136a-cc8e-179b-43a3-674db337b5b8','','2024-12-02 13:17:39','2024-12-02 13:17:39','1','1',NULL,0,NULL,'OPS_dossier','44287d1a-6c50-f0c7-9213-674db37987ab','nouveau','20241202141739920000','1','agent','','Administrator','[encoded data, 6160 characters]'),('16115a28-0572-6696-a0ac-674db58dff96','','2024-12-02 13:26:50','2024-12-02 13:26:50','1','1',NULL,0,NULL,'OPS_dossier','751677fd-e865-7e9f-8024-674db5306822','nouveau','20241202142651080000','1','agent','','Administrator','[encoded data, 6160 characters]'),('9aeb8c7a-cb6c-9c7d-e2fe-674dbaefd56e','','2024-12-02 13:47:39','2024-12-02 13:47:39','1','1',NULL,0,NULL,'OPS_dossier','928e0998-4a2a-5fbc-a1e9-674dbacd69cf','nouveau','20241202144739623000','1','agent','','Administrator','[encoded data, 6160 characters]'),('52f9533b-0e84-f4a9-90ee-67a4a1dc9bb4','','2025-02-06 11:47:36','2025-02-06 11:47:36','1','1',NULL,0,NULL,'OPS_dossier','ccd41f17-58df-505d-c9a7-67a4a1860fc0','nouveau','20250206124736329000','1','agent','','Administrator','SGV5ISDDp2EgdmEgYmllbiA/'),('321a14b3-4ad0-7d72-8d90-67a5da5f03af','','2025-02-07 10:03:42','2025-02-07 10:03:42','1','1',NULL,0,NULL,'OPS_dossier','9aa29f2f-9312-093b-9d71-67a5dad46352','nouveau','20250207110343194000','1','agent','','Administrator','[encoded data, 6160 characters]'),('a383820a-7c50-fe04-9c10-67a5dbe83919','','2025-02-07 10:06:43','2025-02-07 10:06:43','1','1',NULL,0,NULL,'OPS_dossier','480ffde2-c6b2-6562-0ad3-67a5da080a8f','nouveau','20250207110643660000','1','agent','','Administrator','[encoded data, 6160 characters]'),('a3d4bec9-8d75-40ff-4db7-67aa117fd0b2','','2025-02-10 14:45:41','2025-02-10 14:45:41','1','1',NULL,0,NULL,'OPS_dossier','e20a0770-c13c-6a39-08e8-67aa106ff10d','nouveau','20250210154541661000','1','agent','','Administrator','[encoded data, 6160 characters]'),('ae53e8bb-f8c7-4877-062d-67aa1192f868','','2025-02-10 14:49:31','2025-02-10 14:49:31','1','1',NULL,0,NULL,'OPS_dossier','b0c16c13-11a6-c302-d0a4-67aa11d56f04','nouveau','20250210154931704000','1','agent','','Administrator','Q2UgdGV4dGUgc2VyYSBlbnZvecOpIGRhbnMgbGEgY29udmVyc2F0aW9uIMOgIGwmIzAzOTt1c2FnZXIgZMOocyBxdWUgbCYjMDM5O2FjdGlvbiBkZSBzdGF0dXQgc2VyYSBleMOpY3V0w6llLg=='),('7314a087-c99e-cb2e-657b-67aa12d1c852','','2025-02-10 14:53:11','2025-02-10 14:53:11','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','b0c16c13-11a6-c302-d0a4-67aa11d56f04','nouveau','20250210155311461000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','Q291Y291'),('515cc2ee-671a-2755-2a91-67aa125ab976','','2025-02-10 14:53:39','2025-02-10 14:53:39','1','1',NULL,0,NULL,'OPS_dossier','b0c16c13-11a6-c302-d0a4-67aa11d56f04','nouveau','20250210155339315000','1','agent','','Administrator','bWVzc2FnZSDDoCBsJ3VzYWdlcg=='),('6f9447c6-57c5-4a31-a7b0-67aa13227081','','2025-02-10 14:54:45','2025-02-10 14:54:45','1','1',NULL,0,NULL,'OPS_dossier','bd425bd6-ff88-1d88-4bda-67079491aec6','nouveau','20250210155445440000','358e481e-4a74-580c-e951-66fab2eefdea','usager',NULL,NULL,'csOpcG9uc2UgZGUgbFwmIzAzOTt1c2FnZXI='),('6fc4431a-2e00-37c7-f791-67aa13294876','','2025-02-10 14:55:07','2025-02-10 14:55:19','1','1',NULL,0,'','OPS_dossier','b0c16c13-11a6-c302-d0a4-67aa11d56f04','lu','20250210155507443000','943834a9-065f-7f8f-72ad-67aa07d83e13','usager',NULL,NULL,'UmVwb25zZSBkZSBTUCAuLi4='),('de87bf18-e7e7-fde6-b3ad-67aa13635246','','2025-02-10 14:57:25','2025-02-10 14:57:25','1','1',NULL,0,NULL,'OPS_dossier','b0c16c13-11a6-c302-d0a4-67aa11d56f04','nouveau','20250210155725901000','1','agent','','Administrator','bWVzc2FnZSBkZSBsJ2FnZW50'),('1bf782f5-240a-b192-2b16-67aa143058ce','','2025-02-10 14:58:51','2025-02-10 14:58:51','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','e20a0770-c13c-6a39-08e8-67aa106ff10d','nouveau','20250210155851104000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','Y291Y291'),('9c3ae49a-4c3e-fa66-c423-67aa14c2b031','','2025-02-10 15:01:16','2025-02-10 15:01:28','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','1',NULL,0,'','OPS_dossier','e20a0770-c13c-6a39-08e8-67aa106ff10d','lu','20250210160116624000','a8675563-0c72-37e8-b21e-67aa067df0d5','usager',NULL,NULL,'bWVo'),('8f18e180-7b62-7d2c-bbe6-67aa1406b1f7','','2025-02-10 15:01:39','2025-02-10 15:01:39','1','1',NULL,0,NULL,'OPS_dossier','b0c16c13-11a6-c302-d0a4-67aa11d56f04','nouveau','20250210160139564000','1','agent','','Administrator','dGVzdCBhdmVjIG5vdGlm'),('c89187d8-fec3-bd8e-a28d-67adf17b5aa0','','2025-02-13 13:19:45','2025-02-13 13:19:45','1','1',NULL,0,NULL,'OPS_dossier','c3099b64-6e9e-ff5c-f3ec-67adf122f5c3','nouveau','20250213141945809000','1','agent','','Administrator','[encoded data, 6160 characters]'),('16f2cab7-9f8f-fc62-8e0a-67adf402ae63','','2025-02-13 13:34:30','2025-02-13 13:34:30','1','1',NULL,0,NULL,'OPS_dossier','b6220f91-4079-2a13-68f6-67adf49cf96e','nouveau','20250213143431084000','1','agent','','Administrator','Q2UgdGV4dGUgc2VyYSBlbnZvecOpIGRhbnMgbGEgY29udmVyc2F0aW9uIMOgIGwmIzAzOTt1c2FnZXIgZMOocyBxdWUgbCYjMDM5O2FjdGlvbiBkZSBzdGF0dXQgc2VyYSBleMOpY3V0w6llLg=='),('8ec9578d-bef3-4e4a-8e72-67adf6e5d82f','','2025-02-13 13:39:12','2025-02-13 13:39:12','1','1',NULL,0,NULL,'OPS_dossier','125d039c-f871-3ace-54d4-67adf5dcecb0','nouveau','20250213143912574000','1','agent','','Administrator','[encoded data, 6160 characters]'),('c7fa4f9e-5710-7b0b-b263-67adf70e4c2e','','2025-02-13 13:45:35','2025-02-13 13:45:35','1','1',NULL,0,NULL,'OPS_dossier','33750615-70c8-9c88-5f7e-67adf7e70ccf','nouveau','20250213144535809000','1','agent','','Administrator','Q2UgdGV4dGUgc2VyYSBlbnZvecOpIGRhbnMgbGEgY29udmVyc2F0aW9uIMOgIGwmIzAzOTt1c2FnZXIgZMOocyBxdWUgbCYjMDM5O2FjdGlvbiBkZSBzdGF0dXQgc2VyYSBleMOpY3V0w6llLg=='),('eeb70b96-2c3e-b508-fe55-67adf8283e88','','2025-02-13 13:50:58','2025-02-13 13:50:58','1','1',NULL,0,NULL,'OPS_dossier','95c0e3c6-525b-d62c-e21f-67adf8b39c66','nouveau','20250213145058959000','1','agent','','Administrator','Q2UgdGV4dGUgc2VyYSBlbnZvecOpIGRhbnMgbGEgY29udmVyc2F0aW9uIMOgIGwmIzAzOTt1c2FnZXIgZMOocyBxdWUgbCYjMDM5O2FjdGlvbiBkZSBzdGF0dXQgc2VyYSBleMOpY3V0w6llLg=='),('82638ef5-fc0b-9191-0858-68235458d333','','2025-05-13 14:17:28','2025-05-13 14:17:28','1','1',NULL,0,NULL,'OPS_dossier','429c050c-dfb5-ccf9-0f0b-682354b08ef0','nouveau','20250513161728524000','1','agent','','Administrator','[encoded data, 6160 characters]'),('baaf992e-8cff-4985-0774-682355a3cc14','','2025-05-13 14:19:50','2025-05-13 14:19:50','1','1',NULL,0,NULL,'OPS_dossier','d6b1840e-ede5-8d04-86cd-682352da401a','nouveau','20250513161950754000','1','agent','','Administrator','bWVzc2FnZSBkZSBsJ2FnZW50'),('f1e252a5-03cd-dc86-9afe-682355975273','','2025-05-13 14:20:26','2025-05-13 14:20:26','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','429c050c-dfb5-ccf9-0f0b-682354b08ef0','nouveau','20250513162026981000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','dGVzdCBNRw=='),('46b913cd-a98d-ae7d-c02b-6823550a56f2','','2025-05-13 14:21:16','2025-05-13 14:22:20','1','1',NULL,0,'','OPS_dossier','d6b1840e-ede5-8d04-86cd-682352da401a','lu','20250513162116274000','6d370238-e9fe-9643-fb69-682346fc501d','usager',NULL,NULL,'dHJvdXbDqQ=='),('7a38b9ac-f3dc-7382-0d21-6823550fd0e5','','2025-05-13 14:23:38','2025-05-13 14:24:12','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','1',NULL,0,'','OPS_dossier','429c050c-dfb5-ccf9-0f0b-682354b08ef0','lu','20250513162338485000','34ef2300-ccfa-2af0-a317-682346eaeeea','usager',NULL,NULL,'dnUgdGVzdCBNRw=='),('b180f2d9-ba9e-da4a-617d-68235e536af1','','2025-05-13 14:59:34','2025-05-13 14:59:34','1','1',NULL,0,NULL,'OPS_dossier','6a9a4ec7-53a4-67d8-61b1-68235ed27e62','nouveau','20250513165934717000','1','agent','','Administrator','[encoded data, 6160 characters]'),('8f1d95bc-b91d-3baf-aa65-68235ff94ef2','','2025-05-13 15:06:02','2025-05-13 15:06:02','1','1',NULL,0,NULL,'OPS_dossier','3a89baf0-5861-f78f-2c39-68235f790790','nouveau','20250513170602575000','1','agent','','Administrator','[encoded data, 6160 characters]'),('cbbf0db6-18e9-2adf-c0cc-682c47a52cdc','','2025-05-20 09:14:23','2025-05-20 09:14:23','1','1',NULL,0,NULL,'OPS_dossier','c5f43767-90b9-67a6-6eb3-682c466deba6','nouveau','20250520111424035000','1','agent','','Administrator','[encoded data, 6160 characters]'),('b1f4504b-8f59-7fed-84e8-682c4ae3f807','','2025-05-20 09:24:39','2025-05-20 09:24:39','1','1',NULL,0,NULL,'OPS_dossier','708c45f2-3bcf-96f8-7856-682c4a7b78bd','nouveau','20250520112439719000','1','agent','','Administrator','[encoded data, 6160 characters]'),('b67d3a1c-f0df-cfc3-1454-682c4dc99b4c','','2025-05-20 09:39:28','2025-05-20 09:39:28','1','1',NULL,0,NULL,'OPS_dossier','b197ba67-0326-cdf6-b503-682c4d6664af','nouveau','20250520113928737000','1','agent','','Administrator','[encoded data, 6160 characters]'),('a38f33c3-70a8-30c2-fd06-6835ce56e4d9','','2025-05-27 14:38:09','2025-05-27 14:38:09','1','1',NULL,0,NULL,'OPS_dossier','87d8094b-5e71-037a-3936-68348366cc63','nouveau','20250527163809660000','1','agent','','Administrator','ZmZmZmZmZmZmZmZmZmZmZg=='),('3bb3fca8-ce36-f2f5-cbe2-68b6a346e800','','2025-09-02 07:58:58','2025-09-02 07:58:58','1','1',NULL,0,NULL,'OPS_dossier','a8713f97-06cc-93f3-4cd8-68b6a2f9e43b','nouveau','20250902095859233000','1','agent','','Administrator','[encoded data, 6160 characters]'),('d1d606bc-9f62-86d8-6a57-68b6a4506e05','','2025-09-02 08:01:33','2025-09-02 08:01:33','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','d7e74d98-73fd-4297-70ff-68b6a48f0f80','nouveau','20250902100134044000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','[encoded data, 6160 characters]'),('81ae027e-99a1-5f62-44e9-68b6a6411f23','','2025-09-02 08:12:17','2025-09-02 08:12:17','1','1',NULL,0,NULL,'OPS_dossier','bb8111f0-16ca-4b3a-f688-68b6a6e88f90','nouveau','20250902101218023000','1','agent','','Administrator','[encoded data, 6160 characters]'),('ba200f5c-b39c-10cd-e550-68b6b258b855','','2025-09-02 09:02:22','2025-09-02 09:02:22','1','1',NULL,0,NULL,'OPS_dossier','93744285-8476-81a7-913e-68b6b2c04f7a','nouveau','20250902110223037000','1','agent','','Administrator','[encoded data, 6160 characters]'),('24bfcfb8-a537-91ae-9d75-68b80dfd34f8','','2025-09-03 09:43:27','2025-09-03 09:43:27','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','dd4c02bd-6f5e-4567-b44d-68b7fdcf1911','nouveau','20250903114327139000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','dGVzdCBxdWVzdGlvbg=='),('bc6df948-712a-6681-095b-68b80e0a1cea','','2025-09-03 09:44:58','2025-09-03 09:45:15','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','1',NULL,0,'','OPS_dossier','dd4c02bd-6f5e-4567-b44d-68b7fdcf1911','lu','20250903114458756000','90e2181f-6c6a-6bbb-bc33-672251ae167a','usager',NULL,NULL,'csOpcG9uc2U='),('4f93a83c-c78e-3355-a424-68b80e36a6cb','','2025-09-03 09:45:56','2025-09-03 09:45:56','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','dd4c02bd-6f5e-4567-b44d-68b7fdcf1911','nouveau','20250903114556316000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','dGVzdCAy'),('4d7a1813-d14c-af28-7982-68b844307fa0','','2025-09-03 13:36:38','2025-09-03 13:36:38','1','1',NULL,0,NULL,'OPS_dossier','7988bf2a-0940-5999-6298-68b8424623df','nouveau','20250903153638307000','1','agent','','Administrator','[encoded data, 6160 characters]'),('33f7881c-8cbc-07a7-82d9-68b84414bd7f','','2025-09-03 13:38:09','2025-09-03 13:38:09','1','1',NULL,0,NULL,'OPS_dossier','a76439d3-5534-7aef-0bea-68b84489fa96','nouveau','20250903153809203000','1','agent','','Administrator','[encoded data, 6160 characters]'),('2bd88ad2-c21e-2fb4-f5a0-68baa73502c7','','2025-09-05 09:03:42','2025-09-05 09:03:42','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','8cf29d6f-1e82-7c90-335d-68baa189dcc3','nouveau','20250905110342169000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','Qm9uam91cg=='),('bb6da8c5-8e1b-57a4-3fb0-68baa757d72b','','2025-09-05 09:04:15','2025-09-05 09:09:31','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','1',NULL,0,'','OPS_dossier','8cf29d6f-1e82-7c90-335d-68baa189dcc3','lu','20250905110415752000','d949f51f-d7dc-8da8-58f8-68b5a002e870','usager',NULL,NULL,'Qm9uam91cg=='),('ce04f7ec-89aa-5f08-3ea7-68da50f74b13','','2025-09-29 09:26:06','2025-09-29 09:26:06','1','1',NULL,0,NULL,'OPS_dossier','791750e7-b9f9-5a8d-fab9-68da505f0d84','nouveau','20250929112606826000','1','agent','','Administrator','[encoded data, 6160 characters]'),('97439a45-d8fb-69f5-5ba8-68da54871571','','2025-09-29 09:43:31','2025-09-29 09:43:31','1','1',NULL,0,NULL,'OPS_dossier','e859650c-9d43-a108-685f-68da53612778','nouveau','20250929114331606000','1','agent','','Administrator','cXVlc3Rpb24gw6AgbCd1c2FnZXI='),('e682169c-a537-4cde-efba-68da5570a54f','','2025-09-29 09:44:45','2025-09-29 09:44:45','1','1',NULL,0,NULL,'OPS_dossier','71f4911d-1472-608d-64be-68da53eaabcb','nouveau','20250929114445934000','1','agent','','Administrator','dGVzdA=='),('199b6832-7ac9-b024-8835-68da559cd906','','2025-09-29 09:44:49','2025-09-29 09:44:49','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','984bab36-6ea9-3a3f-cc48-66e15b39ccb8',NULL,0,NULL,'OPS_dossier','ea988709-e974-0956-045b-68da515d2fbb','nouveau','20250929114449095000','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','agent','','Formation 1','YXR0ZW50aW9uClRFU1QgZGUgbGEgY29udmVyc2F0aW9uIHZpYSBsJ2luc3RydWN0aW9uIGJhY2tvZmZpY2U='),('6d8659ed-2a30-a27f-64b2-68da5501d8f5','','2025-09-29 09:45:44','2025-09-29 09:45:52','1','1',NULL,0,'','OPS_dossier','71f4911d-1472-608d-64be-68da53eaabcb','lu','20250929114544433000','358e481e-4a74-580c-e951-66fab2eefdea','usager',NULL,NULL,'csOpcG9uc2UgdXNhZ2Vy'),('1b520881-aaad-5a7e-542a-68da55ad152c','','2025-09-29 09:46:42','2025-09-29 09:48:24','984bab36-6ea9-3a3f-cc48-66e15b39ccb8','1',NULL,0,'','OPS_dossier','ea988709-e974-0956-045b-68da515d2fbb','lu','20250929114642992000','ba364af6-59fe-fba5-d0bc-68da3e1911a2','usager',NULL,NULL,'alwmIzAzOTthaSBiaWVuIHJlw6d1IHZvdHJlIG1lc3NhZ2UuIA=='),('ca2e7905-2537-ee6e-71d5-68da59cf50e2','','2025-09-29 10:04:04','2025-09-29 10:04:04','1','1',NULL,0,NULL,'OPS_dossier','7860da19-eade-b954-9380-68da596d98c3','nouveau','20250929120404818000','1','agent','','Administrator','[encoded data, 6160 characters]'),('c1a720eb-6931-3bde-7f20-68da5a15c338','','2025-09-29 10:06:45','2025-09-29 10:06:45','e64475cf-02f9-b7e1-4f19-66e15ba04a6c','e64475cf-02f9-b7e1-4f19-66e15ba04a6c',NULL,0,NULL,'OPS_dossier','a6f711dc-ae35-e625-c788-68da5a7c2a4c','nouveau','20250929120645783000','e64475cf-02f9-b7e1-4f19-66e15ba04a6c','agent','','Formation 3','[encoded data, 6160 characters]'),('dda9a48f-0f2d-46d2-fb71-68da5a71d8c0','','2025-09-29 10:06:45','2025-09-29 10:06:45','1','1',NULL,0,NULL,'OPS_dossier','c4551dbe-7df1-377b-150f-68da5a44d97e','nouveau','20250929120645898000','1','agent','','Administrator','[encoded data, 6160 characters]'),('d0391a0d-9bd7-cb65-0fe2-68da5fe7dfc6','','2025-09-29 10:30:08','2025-09-29 10:30:08','1','1',NULL,0,NULL,'OPS_dossier','e859650c-9d43-a108-685f-68da53612778','nouveau','20250929123008805000','1b6b1544-b6da-afeb-208d-68da3ef19b16','usager',NULL,NULL,'Xl4='),('a3299342-1460-3c6f-f6d2-68db93c402d0','','2025-09-30 08:25:21','2025-09-30 08:25:21','1','1',NULL,0,NULL,'OPS_dossier','cbc437ab-7d2c-527e-6c34-68db93ebb515','nouveau','20250930102521657000','1','agent','','Administrator','[encoded data, 6160 characters]'),('e6f118cd-6517-521b-5cdc-68db95732b50','','2025-09-30 08:30:04','2025-09-30 08:30:04','e64475cf-02f9-b7e1-4f19-66e15ba04a6c','e64475cf-02f9-b7e1-4f19-66e15ba04a6c',NULL,0,NULL,'OPS_dossier','c99e45a8-eeee-af3e-65cf-68db95d87739','nouveau','20250930103004935000','e64475cf-02f9-b7e1-4f19-66e15ba04a6c','agent','','Formation 3','[encoded data, 6160 characters]'),('22b2a849-005c-587b-98be-68db9581467a','','2025-09-30 08:31:35','2025-09-30 08:31:35','1','1',NULL,0,NULL,'OPS_dossier','6065839f-bb81-e125-70c1-68db956133a2','nouveau','20250930103136132000','1','agent','','Administrator','[encoded data, 6160 characters]'),('4243492a-410d-92c9-fbfb-68db98b3b2e2','','2025-09-30 08:45:51','2025-09-30 08:45:51','1','1',NULL,0,NULL,'OPS_dossier','137792a4-df3b-bbf3-1a72-68db984be19b','nouveau','20250930104551261000','1','agent','','Administrator','[encoded data, 6160 characters]'),('453618df-1e43-5dca-0d5d-68dba674c244','','2025-09-30 09:46:06','2025-09-30 09:46:06','1','1',NULL,0,NULL,'OPS_dossier','91040b57-1930-2251-414e-68dba64c91c2','nouveau','20250930114606269000','1','agent','','Administrator','[encoded data, 6160 characters]'),('463e919c-4b67-1db3-abd8-68e3caace5ac','','2025-10-06 13:57:18','2025-10-06 13:57:18','1','1',NULL,0,NULL,'OPS_dossier','ead76d37-c706-b7e3-b957-68e3ca1feca3','nouveau','20251006155718277000','1','agent','','Administrator','[encoded data, 6160 characters]'),('c22de768-0e2f-b561-6038-68e3db8af966','','2025-10-06 15:06:40','2025-10-06 15:06:40','1','1',NULL,0,NULL,'OPS_dossier','e6a8db8d-80d8-2ce9-ff16-68e3dabefc8c','nouveau','20251006170640785000','1','agent','','Administrator','[encoded data, 6160 characters]'),('38561abb-5aa2-e232-dfce-68f7403b1b37','','2025-10-21 08:14:32','2025-10-21 08:14:32','1','1',NULL,0,NULL,'OPS_dossier','59667b62-e099-180d-a701-68f740afb3c1','nouveau','20251021101432220000','1','agent','','Administrator','[encoded data, 6160 characters]'),('bd279234-5760-ee25-c90c-68f755551f29','','2025-10-21 09:40:50','2025-10-21 09:40:50','1','1',NULL,0,NULL,'OPS_dossier','e3c7639d-5235-b934-e16e-68f7547acc1f','nouveau','20251021114050765000','1','agent','','Administrator','[encoded data, 6160 characters]'),('788801a4-2a20-4e30-b6f6-68fa2ed59583','','2025-10-23 13:33:06','2025-10-23 13:33:06','1','1',NULL,0,NULL,'OPS_dossier','d76aeee8-a48d-1f3e-71f7-68fa2e2a4726','nouveau','20251023153306482000','1','agent','','Administrator','[encoded data, 6160 characters]'),('3456bd8f-798d-f203-8b40-68fa2fb3140f','','2025-10-23 13:38:08','2025-10-23 13:38:08','81297ee7-4d44-54e8-1090-66e15bd4b75c','81297ee7-4d44-54e8-1090-66e15bd4b75c',NULL,0,NULL,'OPS_dossier','2f050cc9-2387-7bac-5ede-68fa2f6f1755','nouveau','20251023153809204000','81297ee7-4d44-54e8-1090-66e15bd4b75c','agent','','Formation 5','[encoded data, 6160 characters]'),('5da907ec-858d-88cc-8474-68ff9469b19f','','2025-10-27 15:48:17','2025-10-27 15:48:17','1','1',NULL,0,NULL,'OPS_dossier','d19d0946-e7c3-330b-a2ed-68ff947a00d6','nouveau','20251027164817373000','1','agent','','Administrator','[encoded data, 6160 characters]');

--
