-- LogSOC seed: documents referentiels sources (metadata uniquement)
-- file_data (BLOB PDF) et ai_analysis EXCLUS: l'installation re-importe
-- ses propres PDFs si besoin; ici on preserve la tracabilite document_id.
-- Documents publics ANSSI/NIS2/RGPD/DORA/ISO - zero donnee client.
SET NAMES utf8mb4;
/*M!999999\- enable the sandbox mode */ 

INSERT INTO policy_documents (`id`, `name`, `category`, `version`, `status`, `description`, `file_data`, `file_name`, `file_type`, `file_size`, `approved_by`, `approved_at`, `ai_analysis`, `ai_analyzed_at`, `created_by`, `created_at`, `revision`, `review_status`, `reviewed_by_dsi`, `reviewed_by_direction`, `reviewed_dsi_at`, `reviewed_direction_at`, `generated_by_ia`, `skip_analysis`, `organism`, `regulatory_framework`, `document_type`, `classification_level`, `country`, `pdf_path`, `pdf_generated_at`, `signed`, `signed_by`, `signed_at`, `signature_hash`) VALUES
(35,'anssi-guide-admin_securisee_si_ad_v1-0 (3).pdf','reference','1.0','reference','','','anssi-guide-admin_securisee_si_ad_v1-0 (3).pdf','application/pdf',2794931,NULL,NULL,NULL,NULL,NULL,'2026-07-07 07:11:36',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'ANSSI','ANSSI','Guide technique','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(37,'guide-homologation-securite-web-04-2025.pdf','reference','1.0','reference','Anssi homologation Web','','guide-homologation-securite-web-04-2025.pdf','application/pdf',1424744,NULL,NULL,NULL,NULL,NULL,'2026-07-07 07:27:55',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'ANSSI','ANSSI','Guide technique','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(39,'NIS2 l24-3931.pdf','reference','1.0','reference','Rapport Senat','','NIS2 l24-3931.pdf','application/pdf',3867289,NULL,NULL,NULL,NULL,NULL,'2026-07-07 10:08:09',NULL,NULL,NULL,NULL,NULL,NULL,0,1,'ANSSI','NIS2','Loi nationale','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(40,'CERTFR-2025-DUR-001.pdf','reference','1.0','reference','10 règles d’hygiène numérique\r\nconcernant les téléphones mobiles','','CERTFR-2025-DUR-001.pdf','application/pdf',301033,NULL,NULL,NULL,NULL,NULL,'2026-07-07 10:08:09',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'ANSSI','ANSSI','Guide technique','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(41,'20260317_NIS_V2_ReCyF_v2.5.pdf','reference','1.0','reference','Anssi Refrence NIS2','','20260317_NIS_V2_ReCyF_v2.5.pdf','application/pdf',965769,NULL,NULL,NULL,NULL,NULL,'2026-07-07 10:08:09',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'ANSSI','NIS2','Guide technique','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(42,'guide-charte-utilisation-moyens-informatiques-outils-numeriques_anssi.pdf','reference','1.0','reference','Charte informatique Anssi','','guide-charte-utilisation-moyens-informatiques-outils-numeriques_anssi.pdf','application/pdf',751675,NULL,NULL,NULL,NULL,NULL,'2026-07-07 13:28:19',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'ANSSI','ANSSI','Guide technique','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(43,'guide_hygiene_informatique_anssi.pdf','reference','1.0','reference','guide hygiene Anssi','','guide_hygiene_informatique_anssi.pdf','application/pdf',4792863,NULL,NULL,NULL,NULL,NULL,'2026-07-08 08:08:48',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'ANSSI','ANSSI','Guide technique','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(44,'anssi-guide-gestion_crise_cyber.pdf','reference','1.0','reference','Gestion de crise Cyber','','anssi-guide-gestion_crise_cyber.pdf','application/pdf',770829,NULL,NULL,NULL,NULL,NULL,'2026-07-08 08:08:48',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'ANSSI','ANSSI','Guide technique','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(45,'anssi-guide-admin_securisee_si_v3-0.pdf','reference','1.0','reference','Guide securité Anssi','','anssi-guide-admin_securisee_si_v3-0.pdf','application/pdf',2784556,NULL,NULL,NULL,NULL,NULL,'2026-07-08 08:08:48',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'ANSSI','ANSSI','Guide technique','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(46,'250129_np_anssi_guide_ebios_fr_final_collection_WEB.pdf','reference','1.0','reference','Guide Ebios','','250129_np_anssi_guide_ebios_fr_final_collection_WEB.pdf','application/pdf',3840591,NULL,NULL,NULL,NULL,NULL,'2026-07-08 08:08:48',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'ANSSI','ANSSI','Guide technique','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(47,'CELEX_32016R0679_FR_TXT.pdf','reference','1.0','reference','Reglement RGPD.','','CELEX_32016R0679_FR_TXT.pdf','application/pdf',1050270,NULL,NULL,NULL,NULL,NULL,'2026-07-22 13:48:59',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'','RGPD','Reglement UE','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(56,'Guide-documentation-ISO-27001.pdf','reference','1.0','reference','ISO 27001 ','','Guide-documentation-ISO-27001.pdf','application/pdf',10657038,NULL,NULL,NULL,NULL,NULL,'2026-07-31 13:16:31',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'','ISO27001','Guide technique','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(57,'CELEX_32022L2555_FR_TXT.pdf','reference','1.0','reference','NIS CELEX','','CELEX_32022L2555_FR_TXT.pdf','application/pdf',1379941,NULL,NULL,NULL,NULL,NULL,'2026-07-31 13:16:31',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'ANSSI','NIS2','Directive UE','interne','FR',NULL,NULL,0,NULL,NULL,NULL),
(58,'CELEX_32022R2554_FR_TXT.pdf','reference','1.0','reference','DORA','','CELEX_32022R2554_FR_TXT.pdf','application/pdf',1549644,NULL,NULL,NULL,NULL,NULL,'2026-07-31 13:16:31',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'CELEX','DORA','Reglement UE','interne','FR',NULL,NULL,0,NULL,NULL,NULL)
ON DUPLICATE KEY UPDATE `name` = VALUES(`name`), `category` = VALUES(`category`), `version` = VALUES(`version`), `description` = VALUES(`description`), `organism` = VALUES(`organism`), `regulatory_framework` = VALUES(`regulatory_framework`), `document_type` = VALUES(`document_type`), `classification_level` = VALUES(`classification_level`), `country` = VALUES(`country`);