/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `api_keys`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `api_keys` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `api_keys_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `badge_alerts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `badge_alerts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `badge_id` bigint unsigned NOT NULL,
  `alert_level` enum('info','warning','error','critical') COLLATE utf8mb4_unicode_ci NOT NULL,
  `condition_type` enum('greater_than','less_than','equal_to','between') COLLATE utf8mb4_unicode_ci NOT NULL,
  `threshold_value` decimal(15,2) NOT NULL,
  `threshold_max` decimal(15,2) DEFAULT NULL,
  `message` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `notification_config` json DEFAULT NULL,
  `last_triggered` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `badge_alerts_badge_id_is_active_index` (`badge_id`,`is_active`),
  KEY `badge_alerts_alert_level_index` (`alert_level`),
  CONSTRAINT `badge_alerts_badge_id_foreign` FOREIGN KEY (`badge_id`) REFERENCES `badges` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `badge_cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `badge_cache` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `badge_id` bigint unsigned NOT NULL,
  `module_id` int NOT NULL DEFAULT '1',
  `value` decimal(15,2) NOT NULL DEFAULT '0.00',
  `formatted_value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadata` json DEFAULT NULL,
  `calculated_at` timestamp NOT NULL,
  `expires_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `badge_cache_badge_id_expires_at_index` (`badge_id`,`expires_at`),
  KEY `badge_cache_expires_at_index` (`expires_at`),
  CONSTRAINT `badge_cache_badge_id_foreign` FOREIGN KEY (`badge_id`) REFERENCES `badges` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `badges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `badges` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `agregat` enum('count','sum','avg','max','min','percentage') COLLATE utf8mb4_unicode_ci NOT NULL,
  `field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `modules_id` int DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1',
  `config` json DEFAULT NULL,
  `cache_duration` int NOT NULL DEFAULT '300',
  `last_calculated` timestamp NULL DEFAULT NULL,
  `is_real_time` tinyint(1) NOT NULL DEFAULT '0',
  `alert_threshold` decimal(15,2) DEFAULT NULL,
  `trend_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `badges_uuid_unique` (`uuid`),
  UNIQUE KEY `badges_name_unique` (`name`),
  KEY `badges_name_is_deleted_index` (`name`,`is_deleted`),
  KEY `badges_is_real_time_index` (`is_real_time`),
  KEY `badges_last_calculated_index` (`last_calculated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `blocs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blocs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bloc_order` int NOT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `blocs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `colors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `colors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(55) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_back` varchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_front` varchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `sequence` int DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `colors_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ctas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ctas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ctas_enum_id` bigint unsigned DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` int DEFAULT NULL,
  `roles` json DEFAULT NULL,
  `modules_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ctas_uuid_unique` (`uuid`),
  UNIQUE KEY `ctas_name_unique` (`name`),
  KEY `ctas_modules_id_foreign` (`modules_id`),
  KEY `ctas_ctas_enum_id_foreign` (`ctas_enum_id`),
  CONSTRAINT `ctas_ctas_enum_id_foreign` FOREIGN KEY (`ctas_enum_id`) REFERENCES `ctas_enum` (`id`),
  CONSTRAINT `ctas_modules_id_foreign` FOREIGN KEY (`modules_id`) REFERENCES `modules` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ctas_backup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ctas_backup` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `view` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` int DEFAULT NULL,
  `modules_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `backup_version` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backup_created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ctas_uuid_unique` (`uuid`),
  UNIQUE KEY `ctas_name_unique` (`name`),
  KEY `ctas_modules_id_foreign` (`modules_id`),
  KEY `ctas_backup_backup_version_backup_created_at_index` (`backup_version`,`backup_created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ctas_enum`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ctas_enum` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `view` enum('list','detail','create','update') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'list',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `roles` json DEFAULT NULL,
  `sequence` tinyint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ctas_enum_uuid_unique` (`uuid`),
  UNIQUE KEY `ctas_enum_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `dashboards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dashboards` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_id` bigint unsigned NOT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT '0 = inactif, 1 = actif',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dashboards_uuid_unique` (`uuid`),
  KEY `dashboards_module_id_foreign` (`module_id`),
  CONSTRAINT `dashboards_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `domaines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domaines` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sequence` int DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `domaines_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `menus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `route` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1',
  `roles` json DEFAULT NULL,
  `sequence` int DEFAULT NULL,
  `modules_id` bigint unsigned DEFAULT NULL,
  `domaines_id` bigint unsigned DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_uuid_unique` (`uuid`),
  KEY `menus_modules_id_index` (`modules_id`),
  KEY `menus_domaines_id_index` (`domaines_id`),
  CONSTRAINT `menus_domaines_id_foreign` FOREIGN KEY (`domaines_id`) REFERENCES `domaines` (`id`) ON DELETE CASCADE,
  CONSTRAINT `menus_modules_id_foreign` FOREIGN KEY (`modules_id`) REFERENCES `modules` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `menus_backup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `menus_backup` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `route` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1',
  `sequence` int DEFAULT NULL,
  `modules_id` bigint unsigned DEFAULT NULL,
  `domaines_id` bigint unsigned DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `backup_version` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backup_created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_uuid_unique` (`uuid`),
  KEY `menus_modules_id_index` (`modules_id`),
  KEY `menus_domaines_id_index` (`domaines_id`),
  KEY `menus_backup_backup_version_backup_created_at_index` (`backup_version`,`backup_created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `metadatas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `metadatas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mandatory` tinyint DEFAULT NULL,
  `object` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `searchable` tinyint(1) NOT NULL DEFAULT '0',
  `filterable` tinyint(1) NOT NULL DEFAULT '1',
  `exportable` tinyint(1) NOT NULL DEFAULT '1',
  `hidden_for_roles` json DEFAULT NULL,
  `reference` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fieldname` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `displayname` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `list` tinyint DEFAULT NULL,
  `create` tinyint DEFAULT NULL,
  `update` tinyint NOT NULL DEFAULT '0',
  `detail` tinyint DEFAULT NULL,
  `context` tinyint DEFAULT NULL,
  `is_enum` tinyint NOT NULL DEFAULT '0',
  `enum_kind` enum('single','multi','badge') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'single',
  `default` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `report` tinyint DEFAULT NULL,
  `file` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `repertoire` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sequencelist` int DEFAULT NULL,
  `sequenceupdate` int DEFAULT NULL,
  `sequencedetail` int DEFAULT NULL,
  `sequencecreate` int DEFAULT NULL,
  `target` tinyint DEFAULT NULL,
  `header` tinyint DEFAULT NULL,
  `archived` int DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT '0 = inactif, 1 = actif',
  `blocs_id` int unsigned DEFAULT NULL,
  `modules_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `metadatas_uuid_unique` (`uuid`),
  KEY `metadatas_blocs_id_foreign` (`blocs_id`),
  KEY `metadatas_modules_id_foreign` (`modules_id`),
  CONSTRAINT `metadatas_blocs_id_foreign` FOREIGN KEY (`blocs_id`) REFERENCES `blocs` (`id`),
  CONSTRAINT `metadatas_modules_id_foreign` FOREIGN KEY (`modules_id`) REFERENCES `modules` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `metadatas_backup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `metadatas_backup` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mandatory` tinyint DEFAULT NULL,
  `object` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `update` tinyint NOT NULL DEFAULT '0',
  `reference` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fieldname` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `displayname` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `list` tinyint DEFAULT NULL,
  `create` tinyint DEFAULT NULL,
  `detail` tinyint DEFAULT NULL,
  `context` tinyint DEFAULT NULL,
  `enum` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `report` tinyint DEFAULT NULL,
  `file` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `repertoire` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sequencelist` tinyint DEFAULT NULL,
  `sequenceupdate` tinyint DEFAULT NULL,
  `sequencedetail` tinyint DEFAULT NULL,
  `sequencecreate` tinyint DEFAULT NULL,
  `target` tinyint DEFAULT NULL,
  `header` tinyint DEFAULT NULL,
  `archived` int DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT '0 = inactif, 1 = actif',
  `blocs_id` int unsigned DEFAULT NULL,
  `modules_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `backup_version` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backup_created_at` timestamp NULL DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `metadatas_backup_backup_version_backup_created_at_index` (`backup_version`,`backup_created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `metadatas_generated`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `metadatas_generated` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_id` bigint unsigned DEFAULT NULL,
  `module` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_role_id` bigint unsigned DEFAULT NULL,
  `struct` longtext COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `metadatas_generated_uuid_unique` (`uuid`),
  UNIQUE KEY `metadatas_generated_name_unique` (`name`),
  KEY `metadatas_generated_module_id_index` (`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `modules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `modules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source` enum('data','backoffice') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'data',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sequence` int DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `modules_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `picklists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `picklists` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `field` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sequence` int DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT '0 = inactif, 1 = actif',
  `colors_id` bigint unsigned DEFAULT NULL,
  `metadatas_id` bigint unsigned DEFAULT NULL,
  `modules_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `picklists_uuid_unique` (`uuid`),
  UNIQUE KEY `picklists_name_unique` (`name`),
  KEY `picklists_colors_id_foreign` (`colors_id`),
  KEY `picklists_metadatas_id_foreign` (`metadatas_id`),
  KEY `picklists_modules_id_foreign` (`modules_id`),
  CONSTRAINT `picklists_colors_id_foreign` FOREIGN KEY (`colors_id`) REFERENCES `colors` (`id`),
  CONSTRAINT `picklists_metadatas_id_foreign` FOREIGN KEY (`metadatas_id`) REFERENCES `metadatas` (`id`),
  CONSTRAINT `picklists_modules_id_foreign` FOREIGN KEY (`modules_id`) REFERENCES `modules` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `picklists_backup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `picklists_backup` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `field` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sequence` int DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT '0 = inactif, 1 = actif',
  `colors_id` bigint unsigned DEFAULT NULL,
  `metadatas_id` bigint unsigned DEFAULT NULL,
  `modules_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `backup_version` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backup_created_at` timestamp NULL DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `picklists_backup_backup_version_backup_created_at_index` (`backup_version`,`backup_created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `legacy_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_assignable` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1' COMMENT '0 = inactif, 1 = actif',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `users_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users_roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `role_id` smallint unsigned NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_user_role` (`user_id`,`role_id`),
  KEY `idx_ur_user_id` (`user_id`),
  KEY `idx_ur_role_id` (`role_id`),
  CONSTRAINT `users_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `users_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1,'2025_01_01_000000_create_base_chaps_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (2,'2025_01_01_000001_create_metadatas_generated_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (3,'2025_08_24_212257_create_badges_system_from_estair',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (4,'2025_09_12_161036_add_sequence_to_domaines_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (5,'2025_09_12_161338_add_sequence_to_modules_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (6,'2025_09_12_162645_create_dashboards_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (7,'2025_09_18_155757_fix_backup_tables_unique_constraints',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (8,'2025_09_18_162645_create_ctas_enum_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (9,'2025_09_18_163000_create_backup_tables_and_versioning',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (10,'2025_09_19_113415_add_is_active_to_metadatas_and_picklists_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (11,'2025_09_19_114122_add_is_active_to_backup_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (12,'2025_09_19_114651_add_is_active_to_remaining_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (13,'2025_09_22_171209_add_is_active_to_backup_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (14,'2025_10_15_110132_update_compagnies_references_to_companies',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (15,'2025_10_16_120619_create_sessions_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (16,'2025_10_17_153628_add_update_column_to_metadatas_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (17,'2025_10_22_083428_add_update_column_to_metadatas_backup_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (18,'2025_10_22_143621_add_is_active_to_badges_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (19,'2025_11_14_120202_add_foreign_key_domaines_id_to_menus_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (20,'2025_11_16_150310_add_default_column_to_metadatas_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (21,'2025_11_20_193335_change_sequence_columns_to_int_in_metadatas_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (22,'2025_12_15_153832_change_sequence_to_int_in_modules_and_domaines',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (23,'2026_01_01_000001_create_identity_roles_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (24,'2026_01_01_000002_create_identity_users_roles_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (25,'2026_03_30_000001_normalize_ctas_and_add_roles',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (26,'2026_04_26_000001_change_sessions_user_id_to_string',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (27,'2026_05_09_000001_align_roles_to_canonical',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (28,'2026_05_09_000002_extend_ctas_enum_for_workflow_actions',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (29,'2026_05_09_000003_add_label_to_picklists',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (30,'2026_05_09_000004_refactor_metadatas_enum_to_is_enum',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (31,'2026_05_21_000001_add_field_flags_to_metadatas_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (32,'2026_05_22_000001_seed_default_field_flags',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (33,'2026_05_22_000002_hide_currency_column_on_financial_modules',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (34,'2026_05_22_000003_add_hidden_for_roles_to_metadatas_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (35,'2026_06_01_000001_align_roles_table_to_canonical',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (36,'2025_01_01_000000_create_base_chaps_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (37,'2025_01_01_000001_create_metadatas_generated_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (38,'2025_08_24_212257_create_badges_system_from_estair',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (39,'2025_09_12_161036_add_sequence_to_domaines_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (40,'2025_09_12_161338_add_sequence_to_modules_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (41,'2025_09_12_162645_create_dashboards_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (42,'2025_09_18_155757_fix_backup_tables_unique_constraints',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (43,'2025_09_18_162645_create_ctas_enum_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (44,'2025_09_18_163000_create_backup_tables_and_versioning',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (45,'2025_09_19_113415_add_is_active_to_metadatas_and_picklists_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (46,'2025_09_19_114122_add_is_active_to_backup_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (47,'2025_09_19_114651_add_is_active_to_remaining_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (48,'2025_09_22_171209_add_is_active_to_backup_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (49,'2025_10_15_110132_update_compagnies_references_to_companies',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (50,'2025_10_16_120619_create_sessions_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (51,'2025_10_17_153628_add_update_column_to_metadatas_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (52,'2025_10_22_083428_add_update_column_to_metadatas_backup_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (53,'2025_10_22_143621_add_is_active_to_badges_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (54,'2025_11_14_120202_add_foreign_key_domaines_id_to_menus_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (55,'2025_11_16_150310_add_default_column_to_metadatas_tables',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (56,'2025_11_20_193335_change_sequence_columns_to_int_in_metadatas_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (57,'2025_12_15_153832_change_sequence_to_int_in_modules_and_domaines',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (58,'2026_03_30_000001_normalize_ctas_and_add_roles',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (59,'2026_04_26_000001_change_sessions_user_id_to_string',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (60,'2026_05_09_000001_align_roles_to_canonical',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (61,'2026_05_09_000002_extend_ctas_enum_for_workflow_actions',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (62,'2026_05_09_000003_add_label_to_picklists',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (63,'2026_05_09_000004_refactor_metadatas_enum_to_is_enum',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (64,'2026_05_21_000001_add_field_flags_to_metadatas_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (65,'2026_05_22_000001_seed_default_field_flags',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (66,'2026_05_22_000002_hide_currency_column_on_financial_modules',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (67,'2026_05_22_000003_add_hidden_for_roles_to_metadatas_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (68,'2026_06_01_000001_align_roles_table_to_canonical',1);
