-- Script de restauration des métadatas et picklists depuis le backup 20250918
-- Date: 2025-09-19

-- Vider les tables actuelles
DELETE FROM metadatas WHERE 1=1;
DELETE FROM picklists WHERE 1=1;

-- Réinitialiser les AUTO_INCREMENT
ALTER TABLE metadatas AUTO_INCREMENT = 1;
ALTER TABLE picklists AUTO_INCREMENT = 1;

-- Restauration des métadatas
INSERT INTO `metadatas` VALUES (1,'900dbd58-fbd3-4fa1-9ef4-63093647ca7c','metadatas_id',1,'metadatas','integer',NULL,'id','Id',0,0,0,0,NULL,NULL,NULL,NULL,1,1,1,1,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(2,'81d0434a-8a44-4ed4-a4e4-11439208f47e','metadatas_uuid',0,'metadatas','string',NULL,'uuid','UUID',0,0,0,0,NULL,NULL,NULL,NULL,2,2,2,2,NULL,1,0,21,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(3,'d80a654d-f657-42e1-8087-5cb7a2d7f5e2','metadatas_name',0,'metadatas','string',NULL,'name','Name',0,0,0,0,NULL,NULL,NULL,NULL,3,3,3,3,NULL,1,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(4,'84e21772-24ba-4924-a8c2-aa297d5f4ae2','metadatas_mandatory',0,'metadatas','integer',NULL,'mandatory','Mandatory',1,1,1,1,NULL,NULL,NULL,NULL,21,21,21,21,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(5,'bc972360-96ff-461b-9c38-b140c3b5ca04','metadatas_object',0,'metadatas','string',NULL,'object','Object',1,1,1,1,NULL,NULL,NULL,NULL,16,16,16,16,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(6,'c46d9cb1-f37a-49ad-b174-1609eb6c366f','metadatas_type',0,'metadatas','string',NULL,'type','Type',1,1,1,1,NULL,NULL,NULL,NULL,17,17,17,17,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(7,'0833d61d-b92f-4bf3-9905-a0b2fc8a494f','metadatas_reference',0,'metadatas','string',NULL,'reference','Reference',1,1,1,1,NULL,NULL,NULL,NULL,18,18,18,18,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(8,'8aab4924-14fd-4627-aa93-40392289e8a3','metadatas_fieldname',0,'metadatas','string',NULL,'fieldname','Fieldname',1,1,1,1,NULL,NULL,NULL,NULL,19,19,19,19,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(9,'f09e97da-2219-4d5f-88f7-b455236ff5c8','metadatas_displayname',0,'metadatas','string',NULL,'displayname','Displayname',1,1,1,1,NULL,NULL,NULL,NULL,20,20,20,20,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(10,'220b4f72-a671-4f50-8b8f-90a65b0a3b31','metadatas_list',0,'metadatas','integer',NULL,'list','List',1,1,1,1,NULL,NULL,NULL,NULL,24,24,24,24,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(11,'d35e3caa-1827-4d63-afa1-f743b890452e','metadatas_create',0,'metadatas','integer',NULL,'create','Create',1,1,1,1,NULL,NULL,NULL,NULL,23,23,23,23,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(12,'251c6ea9-47e4-4b27-a236-4d84dab8420b','metadatas_detail',0,'metadatas','integer',NULL,'detail','Detail',1,1,1,1,NULL,NULL,NULL,NULL,25,25,25,25,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(13,'4ef24719-0393-4a75-95f9-8c7916aa9949','metadatas_context',0,'metadatas','integer',NULL,'context','Context',1,1,1,1,NULL,NULL,NULL,NULL,13,13,13,13,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(14,'a59b11c2-8d05-4823-971d-f73b1f0cb465','metadatas_enum',0,'metadatas','string',NULL,'enum','Enum',1,1,1,1,NULL,NULL,NULL,NULL,30,30,30,30,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(15,'fec607b8-4005-4fce-abde-53161af71fc2','metadatas_report',0,'metadatas','integer',NULL,'report','Report',1,1,1,1,NULL,NULL,NULL,NULL,22,22,22,22,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(16,'45284370-547e-4ef6-b547-195e6f48cdce','metadatas_file',0,'metadatas','string',NULL,'file','File',1,1,1,1,NULL,NULL,NULL,NULL,31,31,31,31,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(17,'f105e70e-4e29-4b7d-8fac-8c218293742b','metadatas_repertoire',0,'metadatas','string',NULL,'repertoire','Repertoire',1,1,1,1,NULL,NULL,NULL,NULL,32,32,32,32,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(18,'a195e431-a9f7-46b9-9d20-caf22ab679f4','metadatas_sequencelist',0,'metadatas','integer',NULL,'sequencelist','Sequencelist',1,1,1,1,NULL,NULL,NULL,NULL,18,18,18,18,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(19,'313ba8c4-6052-4886-91bd-a49eabfb5133','metadatas_sequenceupdate',0,'metadatas','integer',NULL,'sequenceupdate','Sequenceupdate',1,1,1,1,NULL,NULL,NULL,NULL,19,19,19,19,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(20,'ccc6a511-70ee-4cdf-8ddd-0aee55c8a6a5','metadatas_sequencedetail',0,'metadatas','integer',NULL,'sequencedetail','Sequencedetail',1,1,1,1,NULL,NULL,NULL,NULL,20,20,20,20,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(21,'f1a4f689-297f-45ef-b4f6-8cefbe60ec75','metadatas_sequencecreate',0,'metadatas','integer',NULL,'sequencecreate','Sequencecreate',1,1,1,1,NULL,NULL,NULL,NULL,21,21,21,21,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(22,'29800881-c1f4-4b7f-8337-919e0ebc52d3','metadatas_target',0,'metadatas','integer',NULL,'target','Target',1,1,1,1,NULL,NULL,NULL,NULL,22,22,22,22,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(23,'2ec90924-f282-4d3e-aaeb-656fc845e194','metadatas_header',0,'metadatas','integer',NULL,'header','Header',1,1,1,1,NULL,NULL,NULL,NULL,23,23,23,23,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(24,'ad90de4a-e4f9-43c3-8b21-f2fc70f85e89','metadatas_archived',0,'metadatas','integer',NULL,'archived','Archived',1,1,1,1,NULL,NULL,NULL,NULL,24,24,24,24,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(25,'2db54a40-7b6c-451c-a918-a31e7e7bcdf4','metadatas_blocs_id',0,'metadatas','reference','blocs','blocs_id','Blocs id',1,1,1,1,NULL,NULL,NULL,NULL,25,25,25,25,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(26,'3d8bbe5f-0026-479c-8c39-99f02700c04f','metadatas_modules_id',0,'metadatas','reference','modules','modules_id','Modules id',1,1,1,1,NULL,NULL,NULL,NULL,26,26,26,26,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(27,'670226af-5250-4241-be8a-76ae3697d826','metadatas_created_at',0,'metadatas','timestamp',NULL,'created_at','Created at',1,1,1,1,NULL,NULL,NULL,NULL,4,4,4,4,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(28,'0f5329d2-5a73-40e5-bb1b-02ec97c35963','metadatas_updated_at',0,'metadatas','datetime',NULL,'updated_at','Updated at',1,1,1,1,NULL,NULL,NULL,NULL,5,5,5,5,NULL,NULL,0,8,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0),(29,'2e7abc26-7f37-4226-88a0-4a43c02451e0','metadatas_is_deleted',1,'metadatas','integer',NULL,'is_deleted','Is deleted',1,1,1,1,NULL,NULL,NULL,NULL,29,29,29,29,NULL,NULL,0,1,21,'2025-07-23 19:54:05','2025-07-23 19:54:05',0);

-- NOTE: Le fichier contient beaucoup plus de données. Ce script contient seulement un échantillon.
-- Pour récupérer toutes les données, il faudrait extraire la ligne complète depuis le fichier backup.