/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19-11.4.10-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: gaha6994_kimai_db -- ------------------------------------------------------ -- Server version 11.4.10-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!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' */; /*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */; -- -- Table structure for table `kimai2_access_token` -- DROP TABLE IF EXISTS `kimai2_access_token`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_access_token` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `token` varchar(100) NOT NULL, `name` varchar(50) NOT NULL, `last_usage` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', `expires_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_6FB0DB1E5F37A13B` (`token`), KEY `IDX_6FB0DB1EA76ED395` (`user_id`), CONSTRAINT `FK_6FB0DB1EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_access_token` -- LOCK TABLES `kimai2_access_token` WRITE; /*!40000 ALTER TABLE `kimai2_access_token` DISABLE KEYS */; INSERT INTO `kimai2_access_token` VALUES (1,2,'68593e8c7c06692d7c02a23cb','API 2','2026-02-26 17:49:16',NULL); /*!40000 ALTER TABLE `kimai2_access_token` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_activities` -- DROP TABLE IF EXISTS `kimai2_activities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_activities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) DEFAULT NULL, `name` varchar(150) NOT NULL, `comment` longtext DEFAULT NULL, `visible` tinyint(1) NOT NULL DEFAULT 1, `color` varchar(7) DEFAULT NULL, `time_budget` int(11) NOT NULL, `budget` double NOT NULL, `budget_type` varchar(10) DEFAULT NULL, `billable` tinyint(1) NOT NULL DEFAULT 1, `invoice_text` longtext DEFAULT NULL, `number` varchar(10) DEFAULT NULL, `created_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', PRIMARY KEY (`id`), KEY `IDX_8811FE1C166D1F9C` (`project_id`), KEY `IDX_8811FE1C7AB0E859166D1F9C` (`visible`,`project_id`), KEY `IDX_8811FE1C7AB0E859166D1F9C5E237E06` (`visible`,`project_id`,`name`), KEY `IDX_8811FE1C7AB0E8595E237E06` (`visible`,`name`), CONSTRAINT `FK_8811FE1C166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `kimai2_projects` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_activities` -- LOCK TABLES `kimai2_activities` WRITE; /*!40000 ALTER TABLE `kimai2_activities` DISABLE KEYS */; INSERT INTO `kimai2_activities` VALUES (1,NULL,'Graphisme',NULL,1,'#ff00ff',0,0,NULL,1,NULL,'0002','2026-02-06 16:03:08'), (2,NULL,'Commercial',NULL,1,'#00bfff',0,0,NULL,1,NULL,'0003','2026-02-06 16:03:08'), (3,NULL,'Gestion',NULL,1,'#808080',0,0,NULL,1,NULL,'0001','2026-02-06 16:03:09'), (5,NULL,'Présentiel',NULL,1,'#9acd32',0,0,NULL,1,NULL,'0004','2026-02-06 18:03:32'), (6,NULL,'Formation','Période de formation sur un projet',1,'#c0c0c0',0,0,NULL,0,NULL,'0006','2026-02-25 08:57:29'); /*!40000 ALTER TABLE `kimai2_activities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_activities_meta` -- DROP TABLE IF EXISTS `kimai2_activities_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_activities_meta` ( `id` int(11) NOT NULL AUTO_INCREMENT, `activity_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `value` text DEFAULT NULL, `visible` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_A7C0A43D81C060965E237E06` (`activity_id`,`name`), KEY `IDX_A7C0A43D81C06096` (`activity_id`), CONSTRAINT `FK_A7C0A43D81C06096` FOREIGN KEY (`activity_id`) REFERENCES `kimai2_activities` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_activities_meta` -- LOCK TABLES `kimai2_activities_meta` WRITE; /*!40000 ALTER TABLE `kimai2_activities_meta` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_activities_meta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_activities_rates` -- DROP TABLE IF EXISTS `kimai2_activities_rates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_activities_rates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `activity_id` int(11) NOT NULL, `rate` double NOT NULL, `fixed` tinyint(1) NOT NULL, `internal_rate` double DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_4A7F11BEA76ED39581C06096` (`user_id`,`activity_id`), KEY `IDX_4A7F11BEA76ED395` (`user_id`), KEY `IDX_4A7F11BE81C06096` (`activity_id`), CONSTRAINT `FK_4A7F11BE81C06096` FOREIGN KEY (`activity_id`) REFERENCES `kimai2_activities` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_4A7F11BEA76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_activities_rates` -- LOCK TABLES `kimai2_activities_rates` WRITE; /*!40000 ALTER TABLE `kimai2_activities_rates` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_activities_rates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_activities_teams` -- DROP TABLE IF EXISTS `kimai2_activities_teams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_activities_teams` ( `activity_id` int(11) NOT NULL, `team_id` int(11) NOT NULL, PRIMARY KEY (`activity_id`,`team_id`), KEY `IDX_986998DA81C06096` (`activity_id`), KEY `IDX_986998DA296CD8AE` (`team_id`), CONSTRAINT `FK_986998DA296CD8AE` FOREIGN KEY (`team_id`) REFERENCES `kimai2_teams` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_986998DA81C06096` FOREIGN KEY (`activity_id`) REFERENCES `kimai2_activities` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_activities_teams` -- LOCK TABLES `kimai2_activities_teams` WRITE; /*!40000 ALTER TABLE `kimai2_activities_teams` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_activities_teams` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_bookmarks` -- DROP TABLE IF EXISTS `kimai2_bookmarks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_bookmarks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `type` varchar(20) NOT NULL, `name` varchar(50) NOT NULL, `content` longtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_4016EF25A76ED3955E237E06` (`user_id`,`name`), KEY `IDX_4016EF25A76ED395` (`user_id`), CONSTRAINT `FK_4016EF25A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_bookmarks` -- LOCK TABLES `kimai2_bookmarks` WRITE; /*!40000 ALTER TABLE `kimai2_bookmarks` DISABLE KEYS */; INSERT INTO `kimai2_bookmarks` VALUES (1,1,'dashboard','default','[{\"id\":\"PaginatedWorkingTimeChart\",\"options\":[]},{\"id\":\"DurationToday\",\"options\":[]},{\"id\":\"DurationWeek\",\"options\":[]},{\"id\":\"DurationMonth\",\"options\":[]},{\"id\":\"DurationYear\",\"options\":[]},{\"id\":\"TotalsCustomer\",\"options\":[]},{\"id\":\"UserTeamProjects\",\"options\":[]},{\"id\":\"activeUsersToday\",\"options\":[]}]'), (2,2,'dashboard','default','[{\"id\":\"PaginatedWorkingTimeChart\",\"options\":[]},{\"id\":\"AmountMonth\",\"options\":[]},{\"id\":\"TotalsProject\",\"options\":[]},{\"id\":\"DurationToday\",\"options\":[]},{\"id\":\"DurationWeek\",\"options\":[]},{\"id\":\"DurationMonth\",\"options\":[]},{\"id\":\"DurationYear\",\"options\":[]}]'); /*!40000 ALTER TABLE `kimai2_bookmarks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_configuration` -- DROP TABLE IF EXISTS `kimai2_configuration`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_configuration` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `value` text DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_1C5D63D85E237E06` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_configuration` -- LOCK TABLES `kimai2_configuration` WRITE; /*!40000 ALTER TABLE `kimai2_configuration` DISABLE KEYS */; INSERT INTO `kimai2_configuration` VALUES (1,'defaults.customer.timezone','Europe/Paris'), (2,'defaults.customer.country','FR'), (3,'customer.choice_pattern','{name}'), (4,'customer.number_format','{cc,4}'), (5,'customer.rules.allow_duplicate_number','0'), (6,'defaults.user.timezone','Europe/Paris'), (7,'defaults.user.language','fr'), (8,'defaults.user.theme','auto'), (9,'theme.avatar_url','0'), (10,'theme.branding.logo','https://filedn.eu/ldpPwshr8924EaXpTfjmimk/studio-folio.com/Logo/studio-folio_560x560px.jpg'), (11,'theme.branding.company','STUDIO FOLIO'), (12,'defaults.customer.currency','EUR'), (13,'company.financial_year',''), (14,'approval.meta_field_email_link_url',NULL), (15,'approval.workflow_start','2026-01-01'), (16,'approval.overtime_ny','1'), (17,'approval.breakchecks_ny','1'), (18,'approval.include_admin_ny','1'), (19,'approval.teamlead_selfapprove_ny','1'), (20,'approval.customer_for_free_days','6'), (21,'approval.mail_submitted_ny','1'), (22,'approval.mail_action_ny','1'), (23,'approval.expected_duration_ny','1'), (24,'approval.hide_approved_ny','0'), (25,'easy_backup.setting_mysqldump_command','/usr/bin/mysqldump --user={user} --password={password} --host={host} --port={port} --single-transaction --force {database}'), (26,'easy_backup.setting_mysql_restore_command','/usr/bin/mysql --user={user} --password={password} --host={host} --port={port} {database} < {sql_file}'), (27,'easy_backup.setting_backup_dir','var/easy_backup/'), (28,'easy_backup.setting_paths_to_backup','.env\nconfig/packages/local.yaml\nvar/data/\nvar/plugins/\nvar/invoices/\ntemplates/invoice\nvar/export/\ntemplates/export/\nmysqldump/*.sql'), (29,'easy_backup.setting_backup_amount_max','-1'), (30,'invoice.number_format','{Y}-{cy,3}'), (31,'invoice.rounding_mode','classic'); /*!40000 ALTER TABLE `kimai2_configuration` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_customer_portals` -- DROP TABLE IF EXISTS `kimai2_customer_portals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_customer_portals` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer_id` int(11) DEFAULT NULL, `project_id` int(11) DEFAULT NULL, `share_key` varchar(20) NOT NULL, `password` varchar(255) DEFAULT NULL, `entry_user_visible` tinyint(1) NOT NULL DEFAULT 0, `entry_rate_visible` tinyint(1) NOT NULL DEFAULT 0, `record_merge_mode` varchar(50) NOT NULL, `annual_chart_visible` tinyint(1) NOT NULL DEFAULT 0, `monthly_chart_visible` tinyint(1) NOT NULL DEFAULT 0, `budget_stats_visible` tinyint(1) NOT NULL DEFAULT 0, `time_budget_stats_visible` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_7747AE6BF06F2E59` (`share_key`), KEY `IDX_7747AE6B9395C3F3` (`customer_id`), KEY `IDX_7747AE6B166D1F9C` (`project_id`), CONSTRAINT `FK_7747AE6B166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `kimai2_projects` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_7747AE6B9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `kimai2_customers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_customer_portals` -- LOCK TABLES `kimai2_customer_portals` WRITE; /*!40000 ALTER TABLE `kimai2_customer_portals` DISABLE KEYS */; INSERT INTO `kimai2_customer_portals` VALUES (1,3,NULL,'7a1251ce03804130bf3f',NULL,1,1,'MERGE',1,1,0,0), (2,6,NULL,'c1859182328d46aaa575',NULL,0,0,'MERGE',1,1,0,0); /*!40000 ALTER TABLE `kimai2_customer_portals` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_customers` -- DROP TABLE IF EXISTS `kimai2_customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_customers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `number` varchar(50) DEFAULT NULL, `comment` longtext DEFAULT NULL, `visible` tinyint(1) NOT NULL, `company` varchar(100) DEFAULT NULL, `contact` varchar(100) DEFAULT NULL, `address` longtext DEFAULT NULL, `country` varchar(2) NOT NULL, `currency` varchar(3) NOT NULL, `phone` varchar(30) DEFAULT NULL, `fax` varchar(30) DEFAULT NULL, `mobile` varchar(30) DEFAULT NULL, `email` varchar(75) DEFAULT NULL, `homepage` varchar(100) DEFAULT NULL, `timezone` varchar(64) NOT NULL, `color` varchar(7) DEFAULT NULL, `time_budget` int(11) NOT NULL, `budget` double NOT NULL, `vat_id` varchar(50) DEFAULT NULL, `budget_type` varchar(10) DEFAULT NULL, `billable` tinyint(1) NOT NULL DEFAULT 1, `invoice_template_id` int(11) DEFAULT NULL, `invoice_text` longtext DEFAULT NULL, `created_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', `address_line1` varchar(150) DEFAULT NULL, `address_line2` varchar(150) DEFAULT NULL, `address_line3` varchar(150) DEFAULT NULL, `postcode` varchar(20) DEFAULT NULL, `city` varchar(50) DEFAULT NULL, `buyer_reference` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_5A9760447AB0E859` (`visible`), KEY `IDX_5A97604412946D8B` (`invoice_template_id`), CONSTRAINT `FK_5A97604412946D8B` FOREIGN KEY (`invoice_template_id`) REFERENCES `kimai2_invoice_templates` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_customers` -- LOCK TABLES `kimai2_customers` WRITE; /*!40000 ALTER TABLE `kimai2_customers` DISABLE KEYS */; INSERT INTO `kimai2_customers` VALUES (3,'PLAN\'UP','3',NULL,1,'PLAN\'UP','Benoît Quevy',NULL,'FR','EUR','04 56 40 60 76',NULL,'06 11 43 14 04','benoit.quevy@plan-up.com','https://plan-up.com','Europe/Paris','#9acd32',108000,0,'FR19523016210','month',1,1,'Rapport d\'heures disponible sur https://kimai.studio-folio.com/fr/auth/customer-portal/7a1251ce03804130bf3f','2026-02-06 16:03:08','241, rue des Vignes',NULL,NULL,'38660','Saint-Vincent de Mercuze',NULL), (4,'STUDIO FOLIO','1',NULL,1,'Yoann BATAILLE','Yoann BATAILLE',NULL,'FR','EUR','0480161716',NULL,'0661818811','yoannbataille@gmail.com','https://studio-folio.com','Europe/Paris','#000000',0,0,'FR61754053346',NULL,0,NULL,'TVA non applicable, art 293 B du CGI','2026-02-06 16:03:09','9 Rue Perrotte',NULL,NULL,'14100','Saint-Martin-de-la-Lieue',NULL), (5,'IMPRIMERIE DES BERGUES','2',NULL,1,'IMPRIMERIE DES BERGUES','Stéphane CHEVALIER',NULL,'CH','CHF','022 343 17 76',NULL,NULL,'info@bergues.ch','https://www.bergues.ch','Europe/Paris','#ff00ff',0,0,'CH-660.1.280.003-4',NULL,1,2,NULL,'2026-02-06 16:27:43','18, rue Saint-Joseph',NULL,NULL,'1227','Carouge',NULL), (6,'MYSTIC LIMITE','4',NULL,1,NULL,NULL,NULL,'FR','EUR',NULL,NULL,NULL,NULL,NULL,'Europe/Paris','#ffa500',0,0,NULL,NULL,1,NULL,NULL,'2026-02-06 16:27:43',NULL,NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `kimai2_customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_customers_comments` -- DROP TABLE IF EXISTS `kimai2_customers_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_customers_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer_id` int(11) NOT NULL, `created_by_id` int(11) NOT NULL, `message` longtext NOT NULL, `created_at` datetime NOT NULL, `pinned` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `IDX_A5B142D99395C3F3` (`customer_id`), KEY `IDX_A5B142D9B03A8386` (`created_by_id`), CONSTRAINT `FK_A5B142D99395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `kimai2_customers` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_A5B142D9B03A8386` FOREIGN KEY (`created_by_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_customers_comments` -- LOCK TABLES `kimai2_customers_comments` WRITE; /*!40000 ALTER TABLE `kimai2_customers_comments` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_customers_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_customers_meta` -- DROP TABLE IF EXISTS `kimai2_customers_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_customers_meta` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `value` text DEFAULT NULL, `visible` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_A48A760F9395C3F35E237E06` (`customer_id`,`name`), KEY `IDX_A48A760F9395C3F3` (`customer_id`), CONSTRAINT `FK_A48A760F9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `kimai2_customers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_customers_meta` -- LOCK TABLES `kimai2_customers_meta` WRITE; /*!40000 ALTER TABLE `kimai2_customers_meta` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_customers_meta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_customers_rates` -- DROP TABLE IF EXISTS `kimai2_customers_rates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_customers_rates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `customer_id` int(11) NOT NULL, `rate` double NOT NULL, `fixed` tinyint(1) NOT NULL, `internal_rate` double DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_82AB0AECA76ED3959395C3F3` (`user_id`,`customer_id`), KEY `IDX_82AB0AECA76ED395` (`user_id`), KEY `IDX_82AB0AEC9395C3F3` (`customer_id`), CONSTRAINT `FK_82AB0AEC9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `kimai2_customers` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_82AB0AECA76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_customers_rates` -- LOCK TABLES `kimai2_customers_rates` WRITE; /*!40000 ALTER TABLE `kimai2_customers_rates` DISABLE KEYS */; INSERT INTO `kimai2_customers_rates` VALUES (1,2,3,30,0,NULL), (2,2,5,60,0,NULL); /*!40000 ALTER TABLE `kimai2_customers_rates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_customers_teams` -- DROP TABLE IF EXISTS `kimai2_customers_teams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_customers_teams` ( `customer_id` int(11) NOT NULL, `team_id` int(11) NOT NULL, PRIMARY KEY (`customer_id`,`team_id`), KEY `IDX_50BD83889395C3F3` (`customer_id`), KEY `IDX_50BD8388296CD8AE` (`team_id`), CONSTRAINT `FK_50BD8388296CD8AE` FOREIGN KEY (`team_id`) REFERENCES `kimai2_teams` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_50BD83889395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `kimai2_customers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_customers_teams` -- LOCK TABLES `kimai2_customers_teams` WRITE; /*!40000 ALTER TABLE `kimai2_customers_teams` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_customers_teams` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_export_templates` -- DROP TABLE IF EXISTS `kimai2_export_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_export_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `renderer` varchar(20) NOT NULL, `language` varchar(6) DEFAULT NULL, `columns` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`columns`)), `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`options`)), PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_2F0CA26F2B36786B` (`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_export_templates` -- LOCK TABLES `kimai2_export_templates` WRITE; /*!40000 ALTER TABLE `kimai2_export_templates` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_export_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_ext_approval` -- DROP TABLE IF EXISTS `kimai2_ext_approval`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_ext_approval` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `expected_duration` int(11) NOT NULL, `actual_duration` int(11) NOT NULL, `creation_date` datetime NOT NULL, PRIMARY KEY (`id`), KEY `IDX_775C89B0A76ED395` (`user_id`), CONSTRAINT `FK_775C89B0A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_ext_approval` -- LOCK TABLES `kimai2_ext_approval` WRITE; /*!40000 ALTER TABLE `kimai2_ext_approval` DISABLE KEYS */; INSERT INTO `kimai2_ext_approval` VALUES (1,2,'2024-11-18','2024-11-24',0,57600,'2026-02-25 09:37:52'), (2,3,'2026-02-23','2026-03-01',57600,3600,'2026-02-25 09:39:04'), (3,3,'2026-02-23','2026-03-01',57600,3600,'2026-02-25 09:41:30'), (4,3,'2026-02-23','2026-03-01',57600,3600,'2026-02-25 11:19:11'); /*!40000 ALTER TABLE `kimai2_ext_approval` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_ext_approval_history` -- DROP TABLE IF EXISTS `kimai2_ext_approval_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_ext_approval_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `approval_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `status_id` int(11) NOT NULL, `date` datetime NOT NULL, `message` longtext DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_A8341CE3FE65F000` (`approval_id`), KEY `IDX_A8341CE3A76ED395` (`user_id`), KEY `IDX_A8341CE36BF700BD` (`status_id`), CONSTRAINT `FK_A8341CE36BF700BD` FOREIGN KEY (`status_id`) REFERENCES `kimai2_ext_approval_status` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_A8341CE3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_A8341CE3FE65F000` FOREIGN KEY (`approval_id`) REFERENCES `kimai2_ext_approval` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_ext_approval_history` -- LOCK TABLES `kimai2_ext_approval_history` WRITE; /*!40000 ALTER TABLE `kimai2_ext_approval_history` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_ext_approval_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_ext_approval_overtime_history` -- DROP TABLE IF EXISTS `kimai2_ext_approval_overtime_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_ext_approval_overtime_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `duration` int(11) NOT NULL, `apply_date` date NOT NULL, PRIMARY KEY (`id`), KEY `IDX_4A7F32DDA76ED395` (`user_id`), CONSTRAINT `FK_4A7F32DDA76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_ext_approval_overtime_history` -- LOCK TABLES `kimai2_ext_approval_overtime_history` WRITE; /*!40000 ALTER TABLE `kimai2_ext_approval_overtime_history` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_ext_approval_overtime_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_ext_approval_status` -- DROP TABLE IF EXISTS `kimai2_ext_approval_status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_ext_approval_status` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_ext_approval_status` -- LOCK TABLES `kimai2_ext_approval_status` WRITE; /*!40000 ALTER TABLE `kimai2_ext_approval_status` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_ext_approval_status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_ext_approval_workday_history` -- DROP TABLE IF EXISTS `kimai2_ext_approval_workday_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_ext_approval_workday_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `monday` int(11) NOT NULL, `tuesday` int(11) NOT NULL, `wednesday` int(11) NOT NULL, `thursday` int(11) NOT NULL, `friday` int(11) NOT NULL, `saturday` int(11) NOT NULL, `sunday` int(11) NOT NULL, `valid_till` date NOT NULL, PRIMARY KEY (`id`), KEY `IDX_85E5D521A76ED395` (`user_id`), CONSTRAINT `FK_85E5D521A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_ext_approval_workday_history` -- LOCK TABLES `kimai2_ext_approval_workday_history` WRITE; /*!40000 ALTER TABLE `kimai2_ext_approval_workday_history` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_ext_approval_workday_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_invoice_templates` -- DROP TABLE IF EXISTS `kimai2_invoice_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_invoice_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(60) NOT NULL, `title` varchar(255) NOT NULL, `company` varchar(255) DEFAULT NULL, `address` longtext DEFAULT NULL, `due_days` int(11) NOT NULL, `vat` double NOT NULL, `calculator` varchar(20) NOT NULL, `number_generator` varchar(20) NOT NULL, `renderer` varchar(20) NOT NULL, `payment_terms` longtext DEFAULT NULL, `vat_id` varchar(50) DEFAULT NULL, `contact` longtext DEFAULT NULL, `payment_details` longtext DEFAULT NULL, `language` varchar(6) NOT NULL, `customer_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_1626CFE95E237E06` (`name`), KEY `IDX_1626CFE99395C3F3` (`customer_id`), CONSTRAINT `FK_1626CFE99395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `kimai2_customers` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_invoice_templates` -- LOCK TABLES `kimai2_invoice_templates` WRITE; /*!40000 ALTER TABLE `kimai2_invoice_templates` DISABLE KEYS */; INSERT INTO `kimai2_invoice_templates` VALUES (1,'€ en heures par jour','Facture',NULL,NULL,30,0,'default','default','default','TVA non applicable, art 293 B du CGI\nConditions de règlement : 30 jours\n\nMerci pour votre confiance et votre collaboration.',NULL,'T. (fr) +33 (0)4 80 16 17 16\nT. (ch) 41 (0)22 519 06 49\ncontact@studio-folio.com\nwww.studio-folio.com','Yoann Bataille / IBAN FR76 4061 8804 5900 0409 3308 318 / BIC BOUSFRPPXXX','fr',4), (2,'CHF par projet','Facture',NULL,NULL,30,0,'project_activity','default','invoice','TVA non applicable, art 293 B du CGI\nConditions de règlement : 30 jours\n\nMerci pour votre confiance et votre collaboration.',NULL,'T. (fr) +33 (0)4 80 16 17 16\nT. (ch) 41 (0)22 519 06 49\ncontact@studio-folio.com\nwww.studio-folio.com','Yoann Bataille / IBAN CH31 0878 1000 2380 9180 0 / BIC SWQBCHZZXXX','fr',4), (4,'Word','Facture',NULL,NULL,30,0,'default','date','project-en',NULL,NULL,NULL,NULL,'fr',4); /*!40000 ALTER TABLE `kimai2_invoice_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_invoice_templates_meta` -- DROP TABLE IF EXISTS `kimai2_invoice_templates_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_invoice_templates_meta` ( `id` int(11) NOT NULL AUTO_INCREMENT, `template_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `value` text DEFAULT NULL, `visible` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_A165B0555DA0FB85E237E06` (`template_id`,`name`), KEY `IDX_A165B0555DA0FB8` (`template_id`), CONSTRAINT `FK_A165B0555DA0FB8` FOREIGN KEY (`template_id`) REFERENCES `kimai2_invoice_templates` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_invoice_templates_meta` -- LOCK TABLES `kimai2_invoice_templates_meta` WRITE; /*!40000 ALTER TABLE `kimai2_invoice_templates_meta` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_invoice_templates_meta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_invoices` -- DROP TABLE IF EXISTS `kimai2_invoices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_invoices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `invoice_number` varchar(50) NOT NULL, `created_at` datetime NOT NULL, `timezone` varchar(64) NOT NULL, `total` double NOT NULL, `tax` double NOT NULL, `currency` varchar(3) NOT NULL, `status` varchar(20) NOT NULL, `due_days` int(11) NOT NULL, `vat` double NOT NULL, `invoice_filename` varchar(150) NOT NULL, `payment_date` date DEFAULT NULL, `comment` longtext DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_76C38E372DA68207` (`invoice_number`), UNIQUE KEY `UNIQ_76C38E372323B33D` (`invoice_filename`), KEY `IDX_76C38E37A76ED395` (`user_id`), KEY `IDX_76C38E379395C3F3` (`customer_id`), CONSTRAINT `FK_76C38E379395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `kimai2_customers` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_76C38E37A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_invoices` -- LOCK TABLES `kimai2_invoices` WRITE; /*!40000 ALTER TABLE `kimai2_invoices` DISABLE KEYS */; INSERT INTO `kimai2_invoices` VALUES (2,3,2,'2026/001','2026-02-13 17:31:13','Europe/Paris',582,0,'EUR','paid',30,0,'2026-001-PLAN_UP.pdf','2026-01-19',NULL), (3,3,2,'2026/002','2026-02-13 17:35:05','Europe/Paris',433,0,'EUR','paid',30,0,'2026-002-PLAN_UP.pdf','2026-02-18',NULL); /*!40000 ALTER TABLE `kimai2_invoices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_invoices_meta` -- DROP TABLE IF EXISTS `kimai2_invoices_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_invoices_meta` ( `id` int(11) NOT NULL AUTO_INCREMENT, `invoice_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `value` text DEFAULT NULL, `visible` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_7EDC37D92989F1FD5E237E06` (`invoice_id`,`name`), KEY `IDX_7EDC37D92989F1FD` (`invoice_id`), CONSTRAINT `FK_7EDC37D92989F1FD` FOREIGN KEY (`invoice_id`) REFERENCES `kimai2_invoices` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_invoices_meta` -- LOCK TABLES `kimai2_invoices_meta` WRITE; /*!40000 ALTER TABLE `kimai2_invoices_meta` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_invoices_meta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_projects` -- DROP TABLE IF EXISTS `kimai2_projects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_projects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer_id` int(11) NOT NULL, `name` varchar(150) NOT NULL, `order_number` tinytext DEFAULT NULL, `comment` longtext DEFAULT NULL, `visible` tinyint(1) NOT NULL, `budget` double NOT NULL, `color` varchar(7) DEFAULT NULL, `time_budget` int(11) NOT NULL, `order_date` datetime DEFAULT NULL, `start` datetime DEFAULT NULL, `end` datetime DEFAULT NULL, `timezone` varchar(64) DEFAULT NULL, `budget_type` varchar(10) DEFAULT NULL, `billable` tinyint(1) NOT NULL DEFAULT 1, `invoice_text` longtext DEFAULT NULL, `global_activities` tinyint(1) NOT NULL DEFAULT 1, `number` varchar(10) DEFAULT NULL, `created_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', PRIMARY KEY (`id`), KEY `IDX_407F12069395C3F3` (`customer_id`), KEY `IDX_407F12069395C3F37AB0E8595E237E06` (`customer_id`,`visible`,`name`), KEY `IDX_407F12069395C3F37AB0E859BF396750` (`customer_id`,`visible`,`id`), CONSTRAINT `FK_407F12069395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `kimai2_customers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_projects` -- LOCK TABLES `kimai2_projects` WRITE; /*!40000 ALTER TABLE `kimai2_projects` DISABLE KEYS */; INSERT INTO `kimai2_projects` VALUES (2,3,'Prospection',NULL,NULL,1,0,'#9acd32',108000,NULL,NULL,NULL,'Europe/Paris','month',1,NULL,1,'0003','2026-02-06 16:03:08'), (5,4,'Gestion interne',NULL,NULL,1,0,'#000000',0,NULL,NULL,NULL,'Europe/Paris',NULL,1,NULL,1,'0006','2026-02-06 16:03:09'), (6,5,'Amis Montagnards, bulletin février 2026',NULL,NULL,1,400,'#0000ff',0,NULL,NULL,NULL,'Europe/Paris',NULL,1,NULL,1,'0004','2026-02-06 16:30:31'), (7,5,'Logo \"Instant Coiffure\"',NULL,NULL,1,0,'#c0c0c0',0,NULL,NULL,NULL,'Europe/Paris',NULL,1,NULL,1,'0005','2026-02-06 16:30:31'), (8,3,'Téléconseiller',NULL,NULL,1,0,'#00ff00',0,NULL,NULL,NULL,'Europe/Paris',NULL,1,NULL,1,'0007','2026-02-06 16:30:31'), (9,6,'Presente en el trabajo',NULL,NULL,1,0,'#ffa500',0,NULL,NULL,NULL,'Europe/Paris',NULL,0,NULL,1,'0008','2026-02-06 16:30:31'), (10,5,'Triptyque Imprimerie des Bergues',NULL,NULL,1,360,NULL,0,'2026-01-28 23:00:00',NULL,NULL,'Europe/Paris',NULL,1,NULL,1,'0009','2026-02-06 16:30:31'); /*!40000 ALTER TABLE `kimai2_projects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_projects_comments` -- DROP TABLE IF EXISTS `kimai2_projects_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_projects_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `created_by_id` int(11) NOT NULL, `message` longtext NOT NULL, `created_at` datetime NOT NULL, `pinned` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `IDX_29A23638166D1F9C` (`project_id`), KEY `IDX_29A23638B03A8386` (`created_by_id`), CONSTRAINT `FK_29A23638166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `kimai2_projects` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_29A23638B03A8386` FOREIGN KEY (`created_by_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_projects_comments` -- LOCK TABLES `kimai2_projects_comments` WRITE; /*!40000 ALTER TABLE `kimai2_projects_comments` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_projects_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_projects_meta` -- DROP TABLE IF EXISTS `kimai2_projects_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_projects_meta` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `value` text DEFAULT NULL, `visible` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_50536EF2166D1F9C5E237E06` (`project_id`,`name`), KEY `IDX_50536EF2166D1F9C` (`project_id`), CONSTRAINT `FK_50536EF2166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `kimai2_projects` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_projects_meta` -- LOCK TABLES `kimai2_projects_meta` WRITE; /*!40000 ALTER TABLE `kimai2_projects_meta` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_projects_meta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_projects_rates` -- DROP TABLE IF EXISTS `kimai2_projects_rates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_projects_rates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `project_id` int(11) NOT NULL, `rate` double NOT NULL, `fixed` tinyint(1) NOT NULL, `internal_rate` double DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_41535D55A76ED395166D1F9C` (`user_id`,`project_id`), KEY `IDX_41535D55A76ED395` (`user_id`), KEY `IDX_41535D55166D1F9C` (`project_id`), CONSTRAINT `FK_41535D55166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `kimai2_projects` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_41535D55A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_projects_rates` -- LOCK TABLES `kimai2_projects_rates` WRITE; /*!40000 ALTER TABLE `kimai2_projects_rates` DISABLE KEYS */; INSERT INTO `kimai2_projects_rates` VALUES (2,2,2,30,0,NULL), (8,2,6,60,0,NULL), (9,NULL,7,60,0,NULL), (10,NULL,10,60,0,NULL); /*!40000 ALTER TABLE `kimai2_projects_rates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_projects_teams` -- DROP TABLE IF EXISTS `kimai2_projects_teams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_projects_teams` ( `project_id` int(11) NOT NULL, `team_id` int(11) NOT NULL, PRIMARY KEY (`project_id`,`team_id`), KEY `IDX_9345D431166D1F9C` (`project_id`), KEY `IDX_9345D431296CD8AE` (`team_id`), CONSTRAINT `FK_9345D431166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `kimai2_projects` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_9345D431296CD8AE` FOREIGN KEY (`team_id`) REFERENCES `kimai2_teams` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_projects_teams` -- LOCK TABLES `kimai2_projects_teams` WRITE; /*!40000 ALTER TABLE `kimai2_projects_teams` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_projects_teams` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_roles` -- DROP TABLE IF EXISTS `kimai2_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_roles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_roles` -- LOCK TABLES `kimai2_roles` WRITE; /*!40000 ALTER TABLE `kimai2_roles` DISABLE KEYS */; INSERT INTO `kimai2_roles` VALUES (3,'ROLE_ADMIN'), (4,'ROLE_SUPER_ADMIN'), (2,'ROLE_TEAMLEAD'), (1,'ROLE_USER'); /*!40000 ALTER TABLE `kimai2_roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_roles_permissions` -- DROP TABLE IF EXISTS `kimai2_roles_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_roles_permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `role_id` int(11) NOT NULL, `permission` varchar(50) NOT NULL, `allowed` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `role_permission` (`role_id`,`permission`), KEY `IDX_D263A3B8D60322AC` (`role_id`), CONSTRAINT `FK_D263A3B8D60322AC` FOREIGN KEY (`role_id`) REFERENCES `kimai2_roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_roles_permissions` -- LOCK TABLES `kimai2_roles_permissions` WRITE; /*!40000 ALTER TABLE `kimai2_roles_permissions` DISABLE KEYS */; INSERT INTO `kimai2_roles_permissions` VALUES (1,1,'view_activity',0), (2,1,'create_activity',0), (3,1,'budget_activity',0), (4,1,'delete_activity',0), (5,1,'edit_activity',0), (6,1,'permissions_activity',0), (7,1,'time_activity',0), (8,2,'budget_activity',1), (9,2,'delete_activity',1), (10,2,'edit_activity',1), (11,2,'permissions_activity',1), (12,2,'time_activity',1), (13,2,'view_activity',1), (14,1,'budget_customer',0), (15,1,'comments_customer',0), (16,1,'create_customer',0), (17,1,'delete_customer',0), (18,1,'details_customer',0), (19,1,'edit_customer',0), (20,1,'permissions_customer',0), (21,1,'time_customer',0), (22,1,'view_customer',0), (23,1,'create_export',0), (24,1,'create_export_template',0), (25,1,'role_permissions',0), (26,4,'budget_team_customer',1), (27,4,'comments_team_customer',1), (28,4,'details_team_customer',1), (29,4,'edit_team_customer',1), (30,4,'time_team_customer',1), (31,4,'view_team_customer',1), (32,4,'budget_teamlead_customer',1), (33,4,'comments_teamlead_customer',1), (34,4,'details_teamlead_customer',1), (35,4,'edit_teamlead_customer',1), (36,4,'permissions_teamlead_customer',1), (37,4,'time_teamlead_customer',1), (38,4,'view_teamlead_customer',1), (39,4,'budget_team_project',1), (40,4,'comments_team_project',1), (41,4,'details_team_project',1), (42,4,'edit_team_project',1), (43,4,'time_team_project',1), (44,4,'view_team_project',1), (45,4,'budget_teamlead_project',1), (46,4,'comments_teamlead_project',1), (47,4,'details_teamlead_project',1), (48,4,'edit_teamlead_project',1), (49,4,'permissions_teamlead_project',1), (50,4,'time_teamlead_project',1), (51,4,'view_teamlead_project',1), (52,4,'delete_invoice',1), (53,4,'budget_teamlead_activity',1), (54,4,'view_team_activity',1), (55,4,'time_team_activity',1), (56,4,'edit_team_activity',1), (57,4,'budget_team_activity',1), (58,4,'edit_teamlead_activity',1), (59,4,'permissions_teamlead_activity',1), (60,4,'time_teamlead_activity',1), (61,4,'view_teamlead_activity',1), (62,1,'edit_team_activity',0); /*!40000 ALTER TABLE `kimai2_roles_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_sessions` -- DROP TABLE IF EXISTS `kimai2_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_sessions` ( `id` varbinary(128) NOT NULL, `data` longblob NOT NULL, `time` int(10) unsigned NOT NULL, `lifetime` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `lifetime_idx` (`lifetime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_sessions` -- LOCK TABLES `kimai2_sessions` WRITE; /*!40000 ALTER TABLE `kimai2_sessions` DISABLE KEYS */; INSERT INTO `kimai2_sessions` VALUES ('1q260ht5glmqfapice0j8hmbub','_sf2_attributes|a:4:{s:22:\"_security_secured_area\";s:528:\"O:68:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\RememberMeToken\":3:{i:0;s:39:\"123456789098765432112345678900987654321\";i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";s:18:\"_csrf/https-search\";s:43:\"pihI1yFB-tuSEWgE_P6-61Q-GKGnT4tb2JIT6R12Sss\";s:28:\"_csrf/https-datatable_update\";s:43:\"-p1s16I-TBxLqoE2bIkeb6lmiWgf8AUOf9s8K6AsshU\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"M-LHpkFbsk9GjXaWz0P_U99-DjkGDerxJuXMO0moVeQ\";}_sf2_meta|a:3:{s:1:\"u\";i:1772128405;s:1:\"c\";i:1772128404;s:1:\"l\";i:0;}',1772128407,1772129847), ('23ri43r60t28nu91i354lr5j6t','_sf2_attributes|a:2:{s:28:\"_csrf/https-datatable_update\";s:43:\"gMBTDYcOd2bWEBzYu3hQCyjBybfoZznKNPsbAO8PiLc\";s:22:\"_security_secured_area\";s:528:\"O:68:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\RememberMeToken\":3:{i:0;s:39:\"123456789098765432112345678900987654321\";i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";}_sf2_meta|a:3:{s:1:\"u\";i:1772039392;s:1:\"c\";i:1772039392;s:1:\"l\";i:0;}',1772039397,1772040837), ('334nhc4b0if14b9ouh41jiee69','_sf2_attributes|a:13:{s:22:\"_security_secured_area\";s:424:\"O:74:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken\":3:{i:0;N;i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:1;s:8:\"username\";s:5:\"admin\";s:7:\"enabled\";b:1;s:5:\"email\";s:24:\"contact@studio-folio.com\";s:8:\"password\";s:60:\"$2y$13$XdEbM7/WlYdEEOwlPZq.deyBC2JJM.4fNXYKZlmW7x1aLACZYkMpC\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:2:{i:0;s:16:\"ROLE_SUPER_ADMIN\";i:1;s:9:\"ROLE_USER\";}}}\";s:23:\"_security.last_username\";s:5:\"admin\";s:18:\"_csrf/https-search\";s:43:\"BVy4KJ3G0ROyTFQd9y86Xi_aLNdZviPHgZKXKJO-gSI\";s:28:\"_csrf/https-datatable_update\";s:43:\"4LHSs7gF7qn9P1na9u0PcaluA65Lb6OcMtLh9Jtvur4\";s:26:\"_csrf/https-invoice.status\";s:43:\"-pkd97PE3LdeZNjpRmaYzKVkTIcd6z6mw5qzTc7sRTo\";s:35:\"_csrf/https-invoice.delete_template\";s:43:\"EKdLPxXrfeJZWP6SaTlY96sSGMS303kwag6-nCWNs_E\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"fKRVIsv24wrrsJ_3zfsYfYnmrE1QxcZgu1N1BvmIsiU\";s:41:\"_csrf/https-admin_invoice_document_upload\";s:43:\"HbnmwkAg7ekhiXnR8gy5PRFpMa6vSeJXPNvNCUmLHY4\";s:35:\"_csrf/https-invoice.delete_document\";s:43:\"k68lFTVvHQu1PsQM-Ezh_SA1JjnVARGY3QTpudl0Iu4\";s:27:\"_csrf/https-invoice.preview\";s:43:\"NQaguZgeid-WOfWfKN8ZMPdMYWR2s4Vtc9lafnigHu0\";s:26:\"_csrf/https-invoice.create\";s:43:\"CKLaHi2M_PsoESwyXmMLAyEV6WRrf-X6QIueSAQmMzg\";s:34:\"_csrf/https-admin_invoice_template\";s:43:\"RcVtAniBlDjht5Cs_3cJJOFVqLMr6prRSwMZMlcUu4M\";s:38:\"_csrf/https-edit_system_configurations\";s:43:\"AJYZE1Q2983Br0r_umAptNjU6Q2xcrCNzmMrMnmNXbw\";}_sf2_meta|a:3:{s:1:\"u\";i:1772175814;s:1:\"c\";i:1772168779;s:1:\"l\";i:0;}',1772175814,1772177254), ('c73butpnaa3jg01vtel3p67ipb','_sf2_attributes|a:4:{s:22:\"_security_secured_area\";s:528:\"O:68:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\RememberMeToken\":3:{i:0;s:39:\"123456789098765432112345678900987654321\";i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";s:18:\"_csrf/https-search\";s:43:\"fKxAap9v0ThuN0IibfL0njOn89MD_n88LK6HgTg9rDY\";s:28:\"_csrf/https-datatable_update\";s:43:\"zRv00WnbMEfHJDo0cELOUdYMRZvCTGzhUsvQ9xFv4FA\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"3rpXvf8O25_rPW_76k9X6ziSBrOgSTIJiF_03JC3VUE\";}_sf2_meta|a:3:{s:1:\"u\";i:1772125610;s:1:\"c\";i:1772125299;s:1:\"l\";i:0;}',1772125610,1772127050), ('clnousipb04dk6q5rn2gmd6fkk','_sf2_attributes|a:6:{s:22:\"_security_secured_area\";s:489:\"O:74:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken\":3:{i:0;N;i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";s:23:\"_security.last_username\";s:23:\"yoannbataille@gmail.com\";s:18:\"_csrf/https-search\";s:43:\"_Erc7sQTwK1mm3Ytc3WrXcoXkAlOG3QdshQu3xcYU6w\";s:28:\"_csrf/https-datatable_update\";s:43:\"dygdsRYFs66o0K1Ru_WOgLAR8xSZ1vlFny1xEZpky3w\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"RI1vejJQvOd7QXf_qm-dLvQT5w_5kGL18BxCS1bfs10\";s:26:\"_csrf/https-timesheet_edit\";s:43:\"9JcV1J6FnSn9PQfiISFt7IUbOayPfsoAyhXkI1xXs_E\";}_sf2_meta|a:3:{s:1:\"u\";i:1772030939;s:1:\"c\";i:1772030782;s:1:\"l\";i:0;}',1772030939,1772032379), ('d200lrqbk4a5qclsj78i5uuoad','_sf2_attributes|a:2:{s:28:\"_csrf/https-datatable_update\";s:43:\"YUlV_Sw--cFz6mUvr2Au_7xd7wM2ao6x71ozVVkI5js\";s:22:\"_security_secured_area\";s:528:\"O:68:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\RememberMeToken\":3:{i:0;s:39:\"123456789098765432112345678900987654321\";i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";}_sf2_meta|a:3:{s:1:\"u\";i:1772040011;s:1:\"c\";i:1772039392;s:1:\"l\";i:0;}',1772040011,1772041451), ('egoj49mef7pkqoiiukihaa86mo','_sf2_attributes|a:9:{s:22:\"_security_secured_area\";s:489:\"O:74:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken\":3:{i:0;N;i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";s:23:\"_security.last_username\";s:23:\"yoannbataille@gmail.com\";s:18:\"_csrf/https-search\";s:43:\"05XMMdFMDHR5oegI_VJvQ56NkuYgN64zvxiENymwUYY\";s:27:\"_csrf/https-invoice.preview\";s:43:\"441oDvn5E6HUBRNshRiNvYO5MZ_XfgmfxCRPTCfaqK4\";s:26:\"_csrf/https-invoice.create\";s:43:\"4g0gpiCgj7Xk0UghSxeSRd4IK8pYtCmm0VUznSpWv54\";s:28:\"_csrf/https-datatable_update\";s:43:\"M8LVxTEBUkrHwCRftoBTGvPeQzUzyZZ9BDZBs-yn0Es\";s:29:\"_csrf/https-project.duplicate\";s:43:\"heWu1vaENbKP10xaR0-Ms5WOgFQ6RayNAPk8oHMoiEU\";s:33:\"_csrf/https-admin_project_comment\";s:43:\"voRG4BnTiGmG5GjylxvFYWfoCmtt2LtqMnhc-V0hWrQ\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"-t4DVWVTeie3J3ZeV6dBC7Rewu__xlYyiq5awqkYr28\";}_sf2_meta|a:3:{s:1:\"u\";i:1772126484;s:1:\"c\";i:1772125352;s:1:\"l\";i:0;}',1772126484,1772127924), ('f28q21ns2euh165hs7veq79p3q','_sf2_attributes|a:5:{s:23:\"_security.last_username\";s:23:\"yoannbataille@gmail.com\";s:22:\"_security_secured_area\";s:489:\"O:74:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken\":3:{i:0;N;i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";s:18:\"_csrf/https-search\";s:43:\"tWVEk79gFszUCO3Gc2is7nvkO-qaOjmKJQ2Ni_9X58I\";s:28:\"_csrf/https-datatable_update\";s:43:\"l_wk8K6BLIsRZIqRv5-U4MOCSyDe-Qmmf1C_9wSwzNA\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"to6vvZomFiE8NmfVvlM5Yhzx1TSxSMhoRafIJ1vqvoM\";}_sf2_meta|a:3:{s:1:\"u\";i:1772127332;s:1:\"c\";i:1772125953;s:1:\"l\";i:0;}',1772127332,1772128772), ('hrrbhg9i7hf27gdk7thsm21q15','_sf2_attributes|a:5:{s:22:\"_security_secured_area\";s:424:\"O:74:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken\":3:{i:0;N;i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:1;s:8:\"username\";s:5:\"admin\";s:7:\"enabled\";b:1;s:5:\"email\";s:24:\"contact@studio-folio.com\";s:8:\"password\";s:60:\"$2y$13$XdEbM7/WlYdEEOwlPZq.deyBC2JJM.4fNXYKZlmW7x1aLACZYkMpC\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:2:{i:0;s:16:\"ROLE_SUPER_ADMIN\";i:1;s:9:\"ROLE_USER\";}}}\";s:23:\"_security.last_username\";s:5:\"admin\";s:18:\"_csrf/https-search\";s:43:\"e689LQK2HpliRSEiWlw7c3Kg0Wproo02iBUeqEh3wEo\";s:28:\"_csrf/https-datatable_update\";s:43:\"YlYmCtOA3IIp7QkpC2cCLqJGv3p9hxqeOw35YhjeT30\";s:38:\"_csrf/https-edit_system_configurations\";s:43:\"m0Bxp97406u0IrGHBt7pqqXDdeSXWADu1AAh8uVxtis\";}_sf2_meta|a:3:{s:1:\"u\";i:1772179299;s:1:\"c\";i:1772177465;s:1:\"l\";i:0;}',1772179299,1772180739), ('i378ep336503ucktakviq8u7n4','_sf2_attributes|a:8:{s:23:\"_security.last_username\";s:23:\"yoannbataille@gmail.com\";s:22:\"_security_secured_area\";s:489:\"O:74:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken\":3:{i:0;N;i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";s:18:\"_csrf/https-search\";s:43:\"RBS_vr4rb_MuSyYvwo7SUMdD7gU5rILntUDRcVsmI84\";s:28:\"_csrf/https-datatable_update\";s:43:\"996qaDWKsiHGcIWM4eZmaq8C2kFLu58YKGJTPWx6RNw\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"2GxFRiPWjm9tbuKR0UB2V6l6FE1wXxVAz0XnKEESiKU\";s:35:\"_csrf/https-invoice.delete_template\";s:43:\"GjvXgk9Gk87kTg_ckQEJ4YmLUEsDD_cuXjk5HaRd2zA\";s:34:\"_csrf/https-admin_invoice_template\";s:43:\"VfcNE_ZAWRbF0HCFmU3HpnU3ix8JeCjKuRzQbYWio88\";s:38:\"_csrf/https-edit_system_configurations\";s:43:\"UPfxShjKyfhTtN3MTf4nOvm4FKDDVW-_8nHceuriKMc\";}_sf2_meta|a:3:{s:1:\"u\";i:1772014095;s:1:\"c\";i:1772012425;s:1:\"l\";i:0;}',1772014095,1772015535), ('psd8r94rj5iha1k6m7n4pus6ri','_sf2_attributes|a:2:{s:28:\"_csrf/https-datatable_update\";s:43:\"f5AZibRAqy5ToOnvFoAQgGL7O2W8-fZOxo9JRLKPYLc\";s:22:\"_security_secured_area\";s:528:\"O:68:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\RememberMeToken\":3:{i:0;s:39:\"123456789098765432112345678900987654321\";i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";}_sf2_meta|a:3:{s:1:\"u\";i:1772039392;s:1:\"c\";i:1772039392;s:1:\"l\";i:0;}',1772039397,1772040837), ('tc8q7qm9g7ngr6e0ltugjtvnr7','_sf2_attributes|a:22:{s:22:\"_security_secured_area\";s:489:\"O:74:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken\":3:{i:0;N;i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";s:23:\"_security.last_username\";s:23:\"yoannbataille@gmail.com\";s:18:\"_csrf/https-search\";s:43:\"SipBJTowYAhbWZyyUMXW0PB3ArW6Ts1ThWZE_BQBKaU\";s:27:\"_csrf/https-invoice.preview\";s:43:\"dXZr7oho1RyBnBpdgc-6i4PSRU2olrp8rEhcuk3MUDE\";s:26:\"_csrf/https-invoice.create\";s:43:\"P3uJbjRVknK-BQ-f55Goatptl1paSgbcXzmBHm70iQs\";s:32:\"_csrf/https-timesheet_quick_edit\";s:43:\"QsDjoCTsaSODyzsEDklgQGdVH722RIt1QA06J-9TLyE\";s:28:\"_csrf/https-datatable_update\";s:43:\"fnTKILrjGTR36DYlOx-PaSn6Xf4qI1v6H_60a3MhuM4\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"_f2Y_56UuL8a5LvgJOEPAffggHZ_qQ-9EZPXf9z1KWo\";s:33:\"_csrf/https-timesheet_multiupdate\";s:43:\"KbkyQGhOGsxLhrKw7gaskJ4E02_VYe1CL8udtXbSjzs\";s:26:\"_csrf/https-timesheet_edit\";s:43:\"q7zfcMRUuetBsD2x8LJEPyf06DyjBiZqf6I2SP42qJA\";s:29:\"_csrf/https-project.duplicate\";s:43:\"3RDYBDrDXIIUattCKQRrwit7qR4ldVCRVugcbslHPKA\";s:33:\"_csrf/https-admin_project_comment\";s:43:\"oysT1DQXju_YqKranwwjydt0eu_9Ikct0ICo8G0gRYc\";s:30:\"_csrf/https-admin_project_edit\";s:43:\"FC1HPDnLxlY4go95LoaRdbjdWuEBsaRb71QBIlMh6FE\";s:35:\"_csrf/https-invoice.delete_template\";s:43:\"BsQV77OVeDwdwfqI03P4GZ00d6uqG9R2GvEtQ59Sbak\";s:41:\"_csrf/https-admin_invoice_document_upload\";s:43:\"I-a4Hjco2sDUc-TP8nccWTxg0wGVTfYVss7VNbtEbMc\";s:35:\"_csrf/https-invoice.delete_document\";s:43:\"jdTDK3f0W34Oxz2r3HBm0AhJwuJybmHl2kVbg0SLMxw\";s:34:\"_csrf/https-admin_invoice_template\";s:43:\"BnBEmEp-iZYIYIUE63FrPakOiqDSPM2gK4HySxzSW64\";s:34:\"_csrf/https-admin_customer_comment\";s:43:\"6GGBI4_7POM7DYA3MXLv4r_d9w9eKbNFkKS-Umiu9pM\";s:31:\"_csrf/https-admin_customer_edit\";s:43:\"jtPBPlVrDqi7J9NvHnWgf9i7_CDzXLwS1GwazCW98Xo\";s:28:\"_csrf/https-doctor.flush_log\";s:43:\"GFcyI-SL6qNsCVsDmKMp_MgALWYKk28cWLSA9CSnNrs\";s:27:\"_csrf/https-import_csv_data\";s:43:\"HkfglT0Q7-sTI1NsOKcURwmvG_Ud9DLhFMgJuHDfjec\";s:38:\"_csrf/https-edit_system_configurations\";s:43:\"FhbWhi0LopwEf9ZYQrQXGfIYMC9binyOUW729f2d27Y\";}_sf2_meta|a:3:{s:1:\"u\";i:1772019861;s:1:\"c\";i:1772018311;s:1:\"l\";i:0;}',1772019862,1772021302), ('vd0ea3071orpv03sd001jbf8fi','_sf2_attributes|a:8:{s:23:\"_security.last_username\";s:23:\"yoannbataille@gmail.com\";s:22:\"_security_secured_area\";s:489:\"O:74:\"Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken\":3:{i:0;N;i:1;s:12:\"secured_area\";i:2;a:5:{i:0;O:15:\"App\\Entity\\User\":5:{s:2:\"id\";i:2;s:8:\"username\";s:23:\"yoannbataille@gmail.com\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"yoannbataille@gmail.com\";s:8:\"password\";s:60:\"$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:4:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";i:3;s:9:\"ROLE_USER\";}}}\";s:18:\"_csrf/https-search\";s:43:\"ED4MrJ69lv0wjAMOPk4veKN1Yd2b0_3DW0OlBeRD-mw\";s:28:\"_csrf/https-datatable_update\";s:43:\"bXQID206N8KYGmwZegZLX1oRoA1xepVV3JZR5L1IxNI\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"9GgFgnxRo1rcgKHbdRfPksx_ZS5vkC_wZavr4Z9lMuY\";s:33:\"_csrf/https-edit_user_preferences\";s:43:\"rU4R7mgYNXzv_XZCqYTV0gtk6PVQodx55O5XtKEMf0Y\";s:36:\"_csrf/https-edit_user_password_token\";s:43:\"h-mz1WDtwL-FGX8ZWB7_kT_hQxetNCbhSte2b9fdqjc\";s:29:\"_csrf/https-access_token_form\";s:43:\"6CipzAzYEVcs65PvNjlteDUYDdm027cRIjLihXTzPEM\";}_sf2_meta|a:3:{s:1:\"u\";i:1772127066;s:1:\"c\";i:1772125995;s:1:\"l\";i:0;}',1772127066,1772128506), ('vjhon382sud6k312574ptr4afa','_sf2_attributes|a:2:{s:34:\"_security.secured_area.target_path\";s:48:\"https://www.kimai.studio-folio.com/fr/timesheet/\";s:24:\"_csrf/https-authenticate\";s:43:\"QNbhFud3w0rJhrGFJacp81QkoeOx28XOzT5QdYiKwOo\";}_sf2_meta|a:3:{s:1:\"u\";i:1772128500;s:1:\"c\";i:1772128500;s:1:\"l\";i:0;}',1772128500,1772129940); /*!40000 ALTER TABLE `kimai2_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_tags` -- DROP TABLE IF EXISTS `kimai2_tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `color` varchar(7) DEFAULT NULL, `visible` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_27CAF54C5E237E06` (`name`), KEY `IDX_27CAF54C7AB0E859` (`visible`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_tags` -- LOCK TABLES `kimai2_tags` WRITE; /*!40000 ALTER TABLE `kimai2_tags` DISABLE KEYS */; INSERT INTO `kimai2_tags` VALUES (22,'identite_visuelle_logo',NULL,1), (23,'phase_conception',NULL,1), (24,'print',NULL,1), (25,'forfait',NULL,1), (26,'phase_revision',NULL,1), (27,'2026-02',NULL,1), (28,'présentiel',NULL,1), (29,'frais',NULL,1), (30,'phase_production',NULL,1); /*!40000 ALTER TABLE `kimai2_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_teams` -- DROP TABLE IF EXISTS `kimai2_teams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_teams` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `color` varchar(7) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_3BEDDC7F5E237E06` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_teams` -- LOCK TABLES `kimai2_teams` WRITE; /*!40000 ALTER TABLE `kimai2_teams` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_teams` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_timesheet` -- DROP TABLE IF EXISTS `kimai2_timesheet`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_timesheet` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user` int(11) NOT NULL, `activity_id` int(11) NOT NULL, `project_id` int(11) NOT NULL, `start_time` datetime NOT NULL, `end_time` datetime DEFAULT NULL, `duration` int(11) DEFAULT NULL, `description` longtext DEFAULT NULL, `rate` double NOT NULL, `fixed_rate` double DEFAULT NULL, `hourly_rate` double DEFAULT NULL, `exported` tinyint(1) NOT NULL DEFAULT 0, `timezone` varchar(64) NOT NULL, `internal_rate` double DEFAULT NULL, `billable` tinyint(1) NOT NULL DEFAULT 1, `category` varchar(10) NOT NULL DEFAULT 'work', `modified_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', `date_tz` date NOT NULL COMMENT '(DC2Type:date_immutable)', `break` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_4F60C6B18D93D649` (`user`), KEY `IDX_4F60C6B181C06096` (`activity_id`), KEY `IDX_4F60C6B1166D1F9C` (`project_id`), KEY `IDX_4F60C6B18D93D649502DF587` (`user`,`start_time`), KEY `IDX_4F60C6B1502DF587` (`start_time`), KEY `IDX_4F60C6B1502DF58741561401` (`start_time`,`end_time`), KEY `IDX_4F60C6B1502DF587415614018D93D649` (`start_time`,`end_time`,`user`), KEY `IDX_4F60C6B1BDF467148D93D649` (`date_tz`,`user`), KEY `IDX_4F60C6B1415614018D93D649` (`end_time`,`user`), KEY `IDX_TIMESHEET_TICKTAC` (`end_time`,`user`,`start_time`), KEY `IDX_TIMESHEET_RECENT_ACTIVITIES` (`user`,`project_id`,`activity_id`), KEY `IDX_TIMESHEET_RESULT_STATS` (`user`,`id`,`duration`), CONSTRAINT `FK_4F60C6B1166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `kimai2_projects` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_4F60C6B181C06096` FOREIGN KEY (`activity_id`) REFERENCES `kimai2_activities` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_4F60C6B18D93D649` FOREIGN KEY (`user`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_timesheet` -- LOCK TABLES `kimai2_timesheet` WRITE; /*!40000 ALTER TABLE `kimai2_timesheet` DISABLE KEYS */; INSERT INTO `kimai2_timesheet` VALUES (37,2,1,7,'2026-02-06 10:30:00','2026-02-06 11:38:00',4080,'',68,NULL,60,0,'Europe/Paris',68,1,'work','2026-02-13 17:55:41','2026-02-06',0), (38,2,1,7,'2026-02-06 09:41:00','2026-02-06 10:20:00',2340,'',39,NULL,60,0,'Europe/Paris',39,1,'work','2026-02-13 17:55:41','2026-02-06',0), (39,2,1,7,'2026-02-06 09:26:00','2026-02-06 09:35:00',540,'',9,NULL,60,0,'Europe/Paris',9,1,'work','2026-02-13 17:55:41','2026-02-06',0), (40,2,1,7,'2026-02-06 08:55:00','2026-02-06 09:09:00',840,NULL,14,NULL,60,0,'Europe/Paris',14,1,'work','2026-02-16 13:10:41','2026-02-06',0), (41,2,2,2,'2026-02-05 16:16:00','2026-02-05 16:57:00',2460,'',20.5,NULL,30,0,'Europe/Paris',20.5,1,'work','2026-02-13 17:29:30','2026-02-05',0), (42,2,2,2,'2026-02-05 15:46:00','2026-02-05 16:16:00',1800,'Kdo',15,NULL,30,0,'Europe/Paris',15,1,'work','2026-02-13 17:29:30','2026-02-05',0), (43,2,2,2,'2026-02-05 15:37:00','2026-02-05 15:44:00',420,'Kdo',3.5,NULL,30,0,'Europe/Paris',3.5,1,'work','2026-02-13 17:29:30','2026-02-05',0), (44,2,2,2,'2026-02-05 14:46:00','2026-02-05 15:38:00',3120,'',26,NULL,30,0,'Europe/Paris',26,1,'work','2026-02-13 17:29:30','2026-02-05',0), (45,2,1,10,'2026-02-05 14:44:00','2026-02-05 14:46:00',120,NULL,2,NULL,60,0,'Europe/Paris',2,1,'work','2026-02-25 11:15:42','2026-02-05',0), (46,2,1,7,'2026-02-05 14:41:00','2026-02-05 14:43:00',120,NULL,2,NULL,60,0,'Europe/Paris',2,1,'work','2026-02-16 13:10:48','2026-02-05',0), (47,2,1,6,'2026-02-05 14:17:00','2026-02-05 14:38:00',1260,'Livraison du bulletin de février 2026',21,NULL,60,0,'Europe/Paris',21,1,'work','2026-02-25 11:24:11','2026-02-05',0), (48,2,5,2,'2026-02-04 11:00:00','2026-02-04 13:00:00',7200,'RDV Laurent Rouzier',60,NULL,30,0,'Europe/Paris',60,1,'work','2026-02-13 17:29:30','2026-02-04',0), (49,2,5,2,'2026-02-04 13:00:00','2026-02-04 13:00:00',0,'Frais de représentation LexoMusic - 85,55€',85.55,85.55,NULL,0,'Europe/Paris',85.55,1,'work','2026-02-16 13:05:25','2026-02-04',0), (50,2,3,5,'2026-02-03 21:47:00','2026-02-03 21:48:00',60,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-06 18:03:32','2026-02-03',0), (51,2,2,2,'2026-02-03 10:10:00','2026-02-03 11:47:00',5820,'',48.5,NULL,30,0,'Europe/Paris',48.5,1,'work','2026-02-13 17:29:30','2026-02-03',0), (52,2,3,5,'2026-02-02 19:05:00','2026-02-02 20:30:00',5100,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-06 18:03:32','2026-02-02',0), (53,2,2,2,'2026-02-02 16:42:00','2026-02-02 17:13:00',1860,'',15.5,NULL,30,0,'Europe/Paris',15.5,1,'work','2026-02-13 17:29:30','2026-02-02',0), (54,2,3,5,'2026-02-02 11:21:00','2026-02-02 12:00:00',2340,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-06 18:03:32','2026-02-02',0), (55,2,1,6,'2026-01-30 15:54:00','2026-01-30 19:30:00',12960,'Bulletin de février 2026',216,NULL,60,0,'Europe/Paris',216,1,'work','2026-02-25 11:24:11','2026-01-30',0), (56,2,1,6,'2026-01-29 17:10:00','2026-01-29 17:40:00',1800,'Bulletin de février 2026',30,NULL,60,0,'Europe/Paris',30,1,'work','2026-02-25 11:24:11','2026-01-29',0), (57,2,3,5,'2026-01-29 14:30:00','2026-01-29 17:00:00',9000,'Préparation devis. Travail sur le nouveau site web.',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-06 18:03:32','2026-01-29',0), (58,2,3,5,'2026-01-29 08:45:00','2026-01-29 10:37:00',6720,'Préparation devis. Travail sur le nouveau site web.',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-06 18:03:32','2026-01-29',0), (59,2,1,6,'2026-01-28 10:00:00','2026-01-28 10:19:00',1140,'Bulletin de février 2026',19,NULL,60,0,'Europe/Paris',19,1,'work','2026-02-25 11:24:11','2026-01-28',0), (60,2,3,2,'2026-01-23 08:38:00','2026-01-23 09:40:00',3720,'',31,NULL,30,1,'Europe/Paris',31,1,'work','2026-02-13 17:29:30','2026-01-23',0), (61,2,2,2,'2026-01-22 17:26:00','2026-01-22 19:09:00',6180,'RDV téléphonique avec M. Rouzier (Lexomusique), accord de principe pour signer.',51.5,NULL,30,1,'Europe/Paris',51.5,1,'work','2026-02-13 17:29:30','2026-01-22',0), (62,2,2,2,'2026-01-22 17:00:00','2026-01-22 17:20:00',1200,'Relance prioritaire',10,NULL,30,1,'Europe/Paris',10,1,'work','2026-02-13 17:29:30','2026-01-22',0), (64,2,2,2,'2026-01-21 15:49:00','2026-01-21 17:58:00',7740,'Relance prioritaire',64.5,NULL,30,1,'Europe/Paris',64.5,1,'work','2026-02-13 17:29:30','2026-01-21',0), (65,2,2,2,'2026-01-21 14:28:00','2026-01-21 15:22:00',3240,'Relance prioritaire',27,NULL,30,1,'Europe/Paris',27,1,'work','2026-02-13 17:29:30','2026-01-21',0), (66,2,2,2,'2026-01-20 10:26:00','2026-01-20 12:08:00',6120,'Relance prioritaire',51,NULL,30,1,'Europe/Paris',51,1,'work','2026-02-13 17:29:30','2026-01-20',0), (67,2,2,2,'2026-01-20 09:20:00','2026-01-20 10:16:00',3360,'Relance prioritaire',28,NULL,30,1,'Europe/Paris',28,1,'work','2026-02-13 17:29:30','2026-01-20',0), (70,2,2,2,'2026-01-14 13:00:00','2026-01-14 16:45:00',13500,'Relance prioritaire',112.5,NULL,30,1,'Europe/Paris',112.5,1,'work','2026-02-13 17:29:30','2026-01-14',0), (71,2,2,2,'2026-01-14 09:03:00','2026-01-14 10:17:00',4440,'Relance prioritaire',37,NULL,30,1,'Europe/Paris',37,1,'work','2026-02-13 17:29:30','2026-01-14',0), (72,2,2,2,'2026-01-14 08:41:00','2026-01-14 09:04:00',1380,'Kdo',11.5,NULL,30,1,'Europe/Paris',11.5,1,'work','2026-02-13 17:29:30','2026-01-14',0), (73,2,2,2,'2026-01-14 08:23:00','2026-01-14 08:41:00',1080,'Relance prioritaire',9,NULL,30,1,'Europe/Paris',9,1,'work','2026-02-13 17:29:30','2026-01-14',0), (77,2,3,5,'2026-01-01 10:00:00','2026-01-01 13:40:00',13200,'',0,NULL,NULL,0,'Europe/Paris',NULL,1,'work','2026-02-06 18:03:32','2026-01-01',0), (78,2,3,5,'2025-12-31 11:41:00','2025-12-31 12:00:00',1140,'',0,NULL,NULL,0,'Europe/Paris',NULL,1,'work','2026-02-06 18:03:32','2025-12-31',0), (191,2,1,10,'2026-02-11 09:09:00','2026-02-11 09:10:00',60,'Recherches',1,NULL,60,0,'Europe/Paris',1,1,'work','2026-02-25 11:15:42','2026-02-11',0), (192,2,1,10,'2026-02-11 09:09:00','2026-02-11 09:17:00',480,'Recherches',8,NULL,60,0,'Europe/Paris',8,1,'work','2026-02-25 11:15:42','2026-02-11',0), (193,2,1,10,'2026-02-11 11:25:00','2026-02-11 13:26:00',7260,'Recherches',121,NULL,60,0,'Europe/Paris',121,1,'work','2026-02-25 11:15:42','2026-02-11',0), (194,2,1,10,'2026-02-11 14:46:00','2026-02-11 16:59:00',7980,'Proposition 1ere maquette',133,NULL,60,0,'Europe/Paris',133,1,'work','2026-02-25 11:15:42','2026-02-11',0), (196,2,2,2,'2025-12-30 23:00:00','2025-12-31 18:24:00',69840,'Heures pour le mois de décembre',582,NULL,30,1,'Europe/Paris',582,1,'work','2026-02-13 17:29:30','2025-12-31',0), (197,2,1,10,'2026-02-15 09:00:00','2026-02-15 10:15:00',4500,'Corrections 1ere maquette',75,NULL,60,0,'Europe/Paris',75,1,'work','2026-02-25 11:15:42','2026-02-15',0), (198,2,1,10,'2026-02-15 10:23:00','2026-02-15 11:09:00',2760,'Corrections 1ere maquette',46,NULL,60,0,'Europe/Paris',46,1,'work','2026-02-25 11:15:42','2026-02-15',0), (200,2,1,6,'2026-02-05 15:00:00','2026-02-05 15:00:00',0,'Facturation du bulletin de février 2026',0,NULL,60,0,'Europe/Paris',0,1,'work','2026-02-25 11:24:11','2026-02-05',0), (201,2,2,2,'2026-02-17 09:14:00','2026-02-17 11:53:00',9540,NULL,79.5,NULL,30,0,'Europe/Paris',79.5,1,'work','2026-02-17 11:52:32','2026-02-17',0), (202,2,2,2,'2026-02-18 08:30:00','2026-02-18 09:04:00',2040,NULL,17,NULL,30,0,'Europe/Paris',17,1,'work','2026-02-18 09:03:46','2026-02-18',0), (203,2,2,2,'2026-02-18 09:26:00','2026-02-18 11:21:00',6900,NULL,57.5,NULL,30,0,'Europe/Paris',57.5,1,'work','2026-02-18 11:20:04','2026-02-18',0), (207,2,5,9,'2026-02-23 08:00:00','2026-02-23 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2026-02-23',0), (208,2,5,9,'2026-02-19 08:00:00','2026-02-19 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2026-02-19',0), (209,2,5,9,'2026-02-16 08:00:00','2026-02-16 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2026-02-16',0), (210,2,5,9,'2026-02-12 08:00:00','2026-02-12 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2026-02-12',0), (211,2,5,9,'2026-01-22 08:00:00','2026-01-22 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2026-01-22',0), (212,2,5,9,'2026-01-19 08:00:00','2026-01-19 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2026-01-19',0), (213,2,5,9,'2026-01-15 08:00:00','2026-01-15 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2026-01-15',0), (214,2,5,9,'2026-01-13 08:00:00','2026-01-13 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2026-01-13',0), (215,2,5,9,'2026-01-12 08:00:00','2026-01-12 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2026-01-12',0), (216,2,5,9,'2026-01-08 08:00:00','2026-01-08 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2026-01-08',0), (217,2,5,9,'2025-12-29 08:00:00','2025-12-29 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-12-29',0), (218,2,5,9,'2025-12-22 08:00:00','2025-12-22 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-12-22',0), (219,2,5,9,'2025-12-18 08:00:00','2025-12-18 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-12-18',0), (220,2,5,9,'2025-12-15 08:00:00','2025-12-15 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-12-15',0), (221,2,5,9,'2025-12-11 08:00:00','2025-12-11 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-12-11',0), (222,2,5,9,'2025-12-04 08:00:00','2025-12-04 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-12-04',0), (223,2,5,9,'2025-12-01 08:00:00','2025-12-01 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-12-01',0), (224,2,5,9,'2025-11-27 08:00:00','2025-11-27 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-11-27',0), (225,2,5,9,'2025-11-24 08:00:00','2025-11-24 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-11-24',0), (226,2,5,9,'2025-11-20 08:00:00','2025-11-20 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-11-20',0), (227,2,5,9,'2025-11-17 08:00:00','2025-11-17 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-11-17',0), (228,2,5,9,'2025-11-13 08:00:00','2025-11-13 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-11-13',0), (229,2,5,9,'2025-11-10 08:00:00','2025-11-10 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-11-10',0), (230,2,5,9,'2025-11-06 08:00:00','2025-11-06 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-11-06',0), (231,2,5,9,'2025-11-03 08:00:00','2025-11-03 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-11-03',0), (232,2,5,9,'2025-10-30 08:00:00','2025-10-30 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-10-30',0), (233,2,5,9,'2025-10-27 08:00:00','2025-10-27 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-10-27',0), (234,2,5,9,'2025-10-23 07:00:00','2025-10-23 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-10-23',0), (235,2,5,9,'2025-10-20 07:00:00','2025-10-20 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-10-20',0), (236,2,5,9,'2025-10-16 07:00:00','2025-10-16 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-10-16',0), (237,2,5,9,'2025-10-13 07:00:00','2025-10-13 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-10-13',0), (238,2,5,9,'2025-10-09 07:00:00','2025-10-09 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-10-09',0), (239,2,5,9,'2025-10-06 07:00:00','2025-10-06 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-10-06',0), (240,2,5,9,'2025-10-02 07:00:00','2025-10-02 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-10-02',0), (241,2,5,9,'2025-09-29 07:00:00','2025-09-29 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-09-29',0), (242,2,5,9,'2025-09-25 07:00:00','2025-09-25 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-09-25',0), (243,2,5,9,'2025-09-22 07:00:00','2025-09-22 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-09-22',0), (244,2,5,9,'2025-09-18 07:00:00','2025-09-18 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-09-18',0), (245,2,5,9,'2025-09-15 07:00:00','2025-09-15 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-09-15',0), (246,2,5,9,'2025-09-11 07:00:00','2025-09-11 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-09-11',0), (247,2,5,9,'2025-09-08 07:00:00','2025-09-08 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-09-08',0), (248,2,5,9,'2025-09-04 07:00:00','2025-09-04 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-09-04',0), (249,2,5,9,'2025-09-01 07:00:00','2025-09-01 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-09-01',0), (250,2,5,9,'2025-08-28 07:00:00','2025-08-28 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-08-28',0), (251,2,5,9,'2025-08-25 07:00:00','2025-08-25 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-08-25',0), (252,2,5,9,'2025-08-21 07:00:00','2025-08-21 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-08-21',0), (253,2,5,9,'2025-08-18 07:00:00','2025-08-18 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-08-18',0), (254,2,5,9,'2025-08-14 07:00:00','2025-08-14 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-08-14',0), (255,2,5,9,'2025-07-10 07:00:00','2025-07-10 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-07-10',0), (256,2,5,9,'2025-07-07 07:00:00','2025-07-07 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-07-07',0), (257,2,5,9,'2025-07-03 07:00:00','2025-07-03 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-07-03',0), (258,2,5,9,'2025-06-30 07:00:00','2025-06-30 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-06-30',0), (259,2,5,9,'2025-06-26 07:00:00','2025-06-26 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-06-26',0), (260,2,5,9,'2025-06-23 07:00:00','2025-06-23 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-06-23',0), (261,2,5,9,'2025-06-19 07:00:00','2025-06-19 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-06-19',0), (262,2,5,9,'2025-06-16 07:00:00','2025-06-16 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-06-16',0), (263,2,5,9,'2025-06-12 07:00:00','2025-06-12 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-06-12',0), (264,2,5,9,'2025-06-05 07:00:00','2025-06-05 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-06-05',0), (265,2,5,9,'2025-06-02 07:00:00','2025-06-02 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-06-02',0), (266,2,5,9,'2025-05-29 07:00:00','2025-05-29 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-05-29',0), (267,2,5,9,'2025-05-26 07:00:00','2025-05-26 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-05-26',0), (268,2,5,9,'2025-05-22 07:00:00','2025-05-22 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-05-22',0), (269,2,5,9,'2025-05-19 07:00:00','2025-05-19 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-05-19',0), (270,2,5,9,'2025-05-15 07:00:00','2025-05-15 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-05-15',0), (271,2,5,9,'2025-05-12 07:00:00','2025-05-12 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-05-12',0), (272,2,5,9,'2025-05-08 07:00:00','2025-05-08 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-05-08',0), (273,2,5,9,'2025-05-05 07:00:00','2025-05-05 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-05-05',0), (274,2,5,9,'2025-04-28 07:00:00','2025-04-28 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-04-28',0), (275,2,5,9,'2025-04-25 07:00:00','2025-04-25 15:00:00',28800,'Día extra para descargar un trailer',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-04-25',0), (276,2,5,9,'2025-04-24 07:00:00','2025-04-24 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-04-24',0), (277,2,5,9,'2025-04-21 07:00:00','2025-04-21 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-04-21',0), (278,2,5,9,'2025-04-14 07:00:00','2025-04-14 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-04-14',0), (279,2,5,9,'2025-04-10 07:00:00','2025-04-10 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-04-10',0), (280,2,5,9,'2025-04-03 07:00:00','2025-04-03 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-04-03',0), (281,2,5,9,'2025-03-31 07:00:00','2025-03-31 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-03-31',0), (282,2,5,9,'2025-03-20 08:00:00','2025-03-20 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-03-20',0), (283,2,5,9,'2025-03-17 08:00:00','2025-03-17 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-03-17',0), (284,2,5,9,'2025-03-13 08:00:00','2025-03-13 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-03-13',0), (285,2,5,9,'2025-03-10 08:00:00','2025-03-10 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-03-10',0), (286,2,5,9,'2025-03-06 08:00:00','2025-03-06 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-03-06',0), (287,2,5,9,'2025-03-03 08:00:00','2025-03-03 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-03-03',0), (288,2,5,9,'2025-02-27 08:00:00','2025-02-27 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-02-27',0), (289,2,5,9,'2025-02-24 08:00:00','2025-02-24 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-02-24',0), (290,2,5,9,'2025-02-20 08:00:00','2025-02-20 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-02-20',0), (291,2,5,9,'2025-02-17 08:00:00','2025-02-17 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-02-17',0), (292,2,5,9,'2025-02-13 08:00:00','2025-02-13 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-02-13',0), (293,2,5,9,'2025-02-10 08:00:00','2025-02-10 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-02-10',0), (294,2,5,9,'2025-02-06 08:00:00','2025-02-06 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-02-06',0), (295,2,5,9,'2025-02-03 08:00:00','2025-02-03 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-02-03',0), (296,2,5,9,'2025-01-30 08:00:00','2025-01-30 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-01-30',0), (297,2,5,9,'2025-01-27 08:00:00','2025-01-27 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-01-27',0), (298,2,5,9,'2025-01-23 08:00:00','2025-01-23 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-01-23',0), (299,2,5,9,'2025-01-20 08:00:00','2025-01-20 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-01-20',0), (300,2,5,9,'2025-01-16 08:00:00','2025-01-16 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-01-16',0), (301,2,5,9,'2025-01-13 08:00:00','2025-01-13 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-01-13',0), (302,2,5,9,'2025-01-09 08:00:00','2025-01-09 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-01-09',0), (303,2,5,9,'2025-01-02 08:00:00','2025-01-02 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2025-01-02',0), (304,2,5,9,'2024-12-30 08:00:00','2024-12-30 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-12-30',0), (305,2,5,9,'2024-12-26 08:00:00','2024-12-26 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-12-26',0), (306,2,5,9,'2024-12-23 08:00:00','2024-12-23 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-12-23',0), (307,2,5,9,'2024-12-19 08:00:00','2024-12-19 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-12-19',0), (308,2,5,9,'2024-12-16 08:00:00','2024-12-16 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-12-16',0), (309,2,5,9,'2024-12-12 08:00:00','2024-12-12 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-12-12',0), (310,2,5,9,'2024-12-09 08:00:00','2024-12-09 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-12-09',0), (311,2,5,9,'2024-12-05 08:00:00','2024-12-05 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-12-05',0), (312,2,5,9,'2024-12-02 08:00:00','2024-12-02 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-12-02',0), (313,2,5,9,'2024-11-28 08:00:00','2024-11-28 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-11-28',0), (314,2,5,9,'2024-11-25 08:00:00','2024-11-25 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-11-25',0), (315,2,5,9,'2024-11-21 08:00:00','2024-11-21 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-11-21',0), (316,2,5,9,'2024-11-18 08:00:00','2024-11-18 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-11-18',0), (317,2,5,9,'2024-11-14 08:00:00','2024-11-14 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-11-14',0), (318,2,5,9,'2024-11-11 08:00:00','2024-11-11 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-11-11',0), (319,2,5,9,'2024-11-07 08:00:00','2024-11-07 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-11-07',0), (320,2,5,9,'2024-11-04 08:00:00','2024-11-04 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-11-04',0), (321,2,5,9,'2024-10-31 08:00:00','2024-10-31 16:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-10-31',0), (322,2,5,9,'2024-10-24 07:00:00','2024-10-24 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-10-24',0), (323,2,5,9,'2024-10-21 07:00:00','2024-10-21 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-10-21',0), (324,2,5,9,'2024-10-17 07:00:00','2024-10-17 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-10-17',0), (325,2,5,9,'2024-10-14 07:00:00','2024-10-14 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-10-14',0), (326,2,5,9,'2024-10-10 07:00:00','2024-10-10 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-10-10',0), (327,2,5,9,'2024-10-07 07:00:00','2024-10-07 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-10-07',0), (328,2,5,9,'2024-10-03 07:00:00','2024-10-03 15:00:00',28800,'',0,NULL,NULL,0,'Europe/Paris',NULL,0,'work','2026-02-24 08:43:22','2024-10-03',0), (329,2,1,10,'2026-02-24 09:20:00','2026-02-24 12:52:00',12720,'2eme proposition de maquette',212,NULL,60,0,'Europe/Paris',212,1,'work','2026-02-25 11:15:42','2026-02-24',0), (330,2,1,10,'2026-02-24 15:30:00','2026-02-24 16:26:00',3360,'Corrections 2eme maquette',56,NULL,60,0,'Europe/Paris',56,1,'work','2026-02-25 11:15:42','2026-02-24',0), (331,2,6,5,'2026-02-25 08:21:00','2026-02-25 08:23:00',120,'Tuto Kimai',0,NULL,0,0,'Europe/Paris',0,0,'work','2026-02-25 08:58:07','2026-02-25',0), (332,2,6,5,'2026-02-25 08:22:00','2026-02-25 11:39:00',11820,'Tuto Kimai',0,NULL,0,0,'Europe/Paris',0,0,'work','2026-02-25 14:48:24','2026-02-25',0), (333,3,5,9,'2026-02-25 08:00:00','2026-02-25 09:00:00',3600,NULL,0,NULL,0,0,'Europe/Madrid',0,0,'work','2026-02-25 09:38:51','2026-02-25',0), (334,2,3,5,'2026-02-26 17:27:00','2026-02-26 17:29:00',120,NULL,0,NULL,0,0,'Europe/Paris',0,0,'work','2026-02-26 17:28:04','2026-02-26',0), (335,2,3,5,'2026-02-26 17:28:00','2026-02-26 17:29:00',60,NULL,0,NULL,0,0,'Europe/Paris',0,0,'work','2026-02-26 17:28:13','2026-02-26',0); /*!40000 ALTER TABLE `kimai2_timesheet` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_timesheet_meta` -- DROP TABLE IF EXISTS `kimai2_timesheet_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_timesheet_meta` ( `id` int(11) NOT NULL AUTO_INCREMENT, `timesheet_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `value` text DEFAULT NULL, `visible` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CB606CBAABDD46BE5E237E06` (`timesheet_id`,`name`), KEY `IDX_CB606CBAABDD46BE` (`timesheet_id`), CONSTRAINT `FK_CB606CBAABDD46BE` FOREIGN KEY (`timesheet_id`) REFERENCES `kimai2_timesheet` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_timesheet_meta` -- LOCK TABLES `kimai2_timesheet_meta` WRITE; /*!40000 ALTER TABLE `kimai2_timesheet_meta` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_timesheet_meta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_timesheet_tags` -- DROP TABLE IF EXISTS `kimai2_timesheet_tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_timesheet_tags` ( `timesheet_id` int(11) NOT NULL, `tag_id` int(11) NOT NULL, PRIMARY KEY (`timesheet_id`,`tag_id`), KEY `IDX_732EECA9ABDD46BE` (`timesheet_id`), KEY `IDX_732EECA9BAD26311` (`tag_id`), CONSTRAINT `FK_732EECA9ABDD46BE` FOREIGN KEY (`timesheet_id`) REFERENCES `kimai2_timesheet` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_732EECA9BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `kimai2_tags` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_timesheet_tags` -- LOCK TABLES `kimai2_timesheet_tags` WRITE; /*!40000 ALTER TABLE `kimai2_timesheet_tags` DISABLE KEYS */; INSERT INTO `kimai2_timesheet_tags` VALUES (37,22), (37,23), (37,24), (38,22), (38,23), (38,24), (39,22), (39,23), (39,24), (40,22), (40,23), (40,24), (45,23), (45,24), (46,22), (46,23), (46,24), (47,24), (47,25), (47,26), (47,27), (48,28), (49,28), (49,29), (55,24), (55,25), (55,27), (55,30), (56,23), (56,24), (56,25), (56,27), (191,23), (191,24), (192,23), (192,24), (193,23), (193,24), (193,25), (194,24), (194,30), (197,24), (197,30), (198,24), (198,30), (200,24), (200,25), (200,27), (329,24), (329,30), (330,24), (330,30); /*!40000 ALTER TABLE `kimai2_timesheet_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_user_preferences` -- DROP TABLE IF EXISTS `kimai2_user_preferences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_user_preferences` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `value` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_8D08F631A76ED3955E237E06` (`user_id`,`name`), KEY `IDX_8D08F631A76ED395` (`user_id`), CONSTRAINT `FK_8D08F631A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_user_preferences` -- LOCK TABLES `kimai2_user_preferences` WRITE; /*!40000 ALTER TABLE `kimai2_user_preferences` DISABLE KEYS */; INSERT INTO `kimai2_user_preferences` VALUES (1,1,'timezone','Europe/Paris'), (2,1,'language','fr'), (3,1,'skin','auto'), (4,1,'hourly_rate','0'), (5,1,'internal_rate',NULL), (6,1,'locale','fr'), (7,1,'first_weekday','monday'), (8,1,'update_browser_title','1'), (9,1,'calendar_initial_view','month'), (10,1,'login_initial_view','timesheet'), (11,1,'favorite_routes',''), (12,1,'daily_stats',''), (13,1,'export_decimal',''), (14,1,'__wizards__','intro,profile'), (15,2,'timezone','Europe/Paris'), (16,2,'language','fr'), (17,2,'skin','auto'), (18,3,'timezone','Europe/Madrid'), (19,3,'language','es'), (20,3,'skin','auto'), (21,1,'_latest_approval',NULL), (22,2,'hourly_rate','0'), (23,2,'internal_rate',NULL), (24,2,'locale','fr'), (25,2,'first_weekday','monday'), (26,2,'update_browser_title','1'), (27,2,'calendar_initial_view','month'), (28,2,'login_initial_view','timesheet'), (29,2,'favorite_routes',''), (30,2,'daily_stats','0'), (31,2,'export_decimal','0'), (32,2,'__wizards__','intro,profile'), (33,3,'hourly_rate','0'), (34,3,'internal_rate',NULL), (35,3,'locale','es'), (36,3,'first_weekday','monday'), (37,3,'update_browser_title','1'), (38,3,'calendar_initial_view','month'), (39,3,'login_initial_view','timesheet'), (40,3,'favorite_routes',''), (41,3,'daily_stats',''), (42,3,'export_decimal',''), (43,3,'__wizards__','intro,profile'), (44,2,'_latest_approval',NULL), (45,3,'_latest_approval',NULL), (46,3,'work_contract_type','day'), (47,3,'work_monday','28800'), (48,3,'work_thursday','28800'); /*!40000 ALTER TABLE `kimai2_user_preferences` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_users` -- DROP TABLE IF EXISTS `kimai2_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(180) NOT NULL, `email` varchar(180) NOT NULL, `password` varchar(255) NOT NULL, `alias` varchar(60) DEFAULT NULL, `enabled` tinyint(1) NOT NULL, `registration_date` datetime DEFAULT NULL, `title` varchar(50) DEFAULT NULL, `avatar` varchar(255) DEFAULT NULL, `roles` longtext NOT NULL COMMENT '(DC2Type:array)', `last_login` datetime DEFAULT NULL, `confirmation_token` varchar(180) DEFAULT NULL, `password_requested_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', `api_token` varchar(255) DEFAULT NULL, `auth` varchar(20) DEFAULT NULL, `color` varchar(7) DEFAULT NULL, `account` varchar(30) DEFAULT NULL, `totp_secret` varchar(255) DEFAULT NULL, `totp_enabled` tinyint(1) NOT NULL DEFAULT 0, `system_account` tinyint(1) NOT NULL DEFAULT 0, `supervisor_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_B9AC5BCEF85E0677` (`username`), UNIQUE KEY `UNIQ_B9AC5BCEE7927C74` (`email`), UNIQUE KEY `UNIQ_B9AC5BCEC05FB297` (`confirmation_token`), KEY `IDX_B9AC5BCE19E9AC5F` (`supervisor_id`), CONSTRAINT `FK_B9AC5BCE19E9AC5F` FOREIGN KEY (`supervisor_id`) REFERENCES `kimai2_users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_users` -- LOCK TABLES `kimai2_users` WRITE; /*!40000 ALTER TABLE `kimai2_users` DISABLE KEYS */; INSERT INTO `kimai2_users` VALUES (1,'admin','contact@studio-folio.com','$2y$13$XdEbM7/WlYdEEOwlPZq.deyBC2JJM.4fNXYKZlmW7x1aLACZYkMpC',NULL,1,'2026-02-05 12:40:11',NULL,NULL,'a:1:{i:0;s:16:\"ROLE_SUPER_ADMIN\";}','2026-02-27 07:31:05',NULL,NULL,NULL,'kimai',NULL,NULL,'VCM25R5N6W6BG56UKZRYKLPS7ZQMBZ4JVSD6NZW65MADUDW5KV7A',0,0,NULL), (2,'yoannbataille@gmail.com','yoannbataille@gmail.com','$2y$13$RGVrFrciizxtV4y7HQxCVepOCdR8G/guuri49qEFno.uRsUX.ls3K','Yoann BATAILLE',1,'2026-02-06 16:03:07','Graphiste & Commercial',NULL,'a:3:{i:0;s:13:\"ROLE_TEAMLEAD\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:16:\"ROLE_SUPER_ADMIN\";}','2026-02-26 18:12:16',NULL,NULL,'$2y$13$hZmYMOKDbgIoSlOKvqBp7Oj3BIsBNRlsFIbacuWJ/YC4/V7CAhFWC','kimai','#ffff00',NULL,'TSRVV5GDRN4HMAMUTAUHFXGE5IVKWYDVIEFBMIR5CTM5PWJRISCQ',0,0,NULL), (3,'Yoann Mystic Limite','diseno@mysticlimite.com','$2y$13$NlGe9I7Dn6nS8.JNEauNAe42Z9ujIOF8W9sPnaEnTKJRTDO6jyHUi','Yoann Bataille ML',1,'2026-02-06 18:03:32','Diseñador Grafico',NULL,'a:1:{i:0;s:13:\"ROLE_TEAMLEAD\";}','2026-02-25 09:38:21',NULL,NULL,NULL,'kimai','#ffa500',NULL,'3OM2Q3EKT5N4ZFERD2JFHATEQ4IYTK5343T7PXDALZVKZEVWSI3Q',0,0,2); /*!40000 ALTER TABLE `kimai2_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_users_teams` -- DROP TABLE IF EXISTS `kimai2_users_teams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_users_teams` ( `user_id` int(11) NOT NULL, `team_id` int(11) NOT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `teamlead` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_B5E92CF8A76ED395296CD8AE` (`user_id`,`team_id`), KEY `IDX_B5E92CF8A76ED395` (`user_id`), KEY `IDX_B5E92CF8296CD8AE` (`team_id`), CONSTRAINT `FK_B5E92CF8296CD8AE` FOREIGN KEY (`team_id`) REFERENCES `kimai2_teams` (`id`) ON DELETE CASCADE, CONSTRAINT `FK_B5E92CF8A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_users_teams` -- LOCK TABLES `kimai2_users_teams` WRITE; /*!40000 ALTER TABLE `kimai2_users_teams` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_users_teams` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kimai2_working_times` -- DROP TABLE IF EXISTS `kimai2_working_times`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kimai2_working_times` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `approved_by` int(11) DEFAULT NULL, `date` date NOT NULL COMMENT '(DC2Type:date_immutable)', `expected` int(11) NOT NULL, `actual` int(11) NOT NULL, `approved_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_F95E4933A76ED395AA9E377A` (`user_id`,`date`), KEY `IDX_F95E4933A76ED395` (`user_id`), KEY `IDX_F95E49334EA3CB3D` (`approved_by`), CONSTRAINT `FK_F95E49334EA3CB3D` FOREIGN KEY (`approved_by`) REFERENCES `kimai2_users` (`id`) ON DELETE SET NULL, CONSTRAINT `FK_F95E4933A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kimai2_working_times` -- LOCK TABLES `kimai2_working_times` WRITE; /*!40000 ALTER TABLE `kimai2_working_times` DISABLE KEYS */; /*!40000 ALTER TABLE `kimai2_working_times` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migration_versions` -- DROP TABLE IF EXISTS `migration_versions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `migration_versions` ( `version` varchar(191) NOT NULL, `executed_at` datetime DEFAULT NULL, `execution_time` int(11) DEFAULT NULL, PRIMARY KEY (`version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migration_versions` -- LOCK TABLES `migration_versions` WRITE; /*!40000 ALTER TABLE `migration_versions` DISABLE KEYS */; INSERT INTO `migration_versions` VALUES ('DoctrineMigrations\\Version20180701120000','2026-02-05 12:38:13',436), ('DoctrineMigrations\\Version20180715160326','2026-02-05 12:38:14',533), ('DoctrineMigrations\\Version20180730044139','2026-02-05 12:38:14',75), ('DoctrineMigrations\\Version20180805183527','2026-02-05 12:38:14',70), ('DoctrineMigrations\\Version20180903202256','2026-02-05 12:38:15',54), ('DoctrineMigrations\\Version20180905190737','2026-02-05 12:38:15',161), ('DoctrineMigrations\\Version20180924111853','2026-02-05 12:38:15',43), ('DoctrineMigrations\\Version20181031220003','2026-02-05 12:38:15',424), ('DoctrineMigrations\\Version20190124004014','2026-02-05 12:38:15',65), ('DoctrineMigrations\\Version20190201150324','2026-02-05 12:38:15',28), ('DoctrineMigrations\\Version20190219200020','2026-02-05 12:38:15',1), ('DoctrineMigrations\\Version20190305152308','2026-02-05 12:38:15',154), ('DoctrineMigrations\\Version20190321181243','2026-02-05 12:38:15',21), ('DoctrineMigrations\\Version20190502161758','2026-02-05 12:38:15',108), ('DoctrineMigrations\\Version20190510205245','2026-02-05 12:38:16',97), ('DoctrineMigrations\\Version20190605171157','2026-02-05 12:38:16',114), ('DoctrineMigrations\\Version20190617100845','2026-02-05 12:38:16',321), ('DoctrineMigrations\\Version20190706224211','2026-02-05 12:38:16',219), ('DoctrineMigrations\\Version20190706224219','2026-02-05 12:38:16',372), ('DoctrineMigrations\\Version20190729162655','2026-02-05 12:38:17',182), ('DoctrineMigrations\\Version20190730123324','2026-02-05 12:38:17',474), ('DoctrineMigrations\\Version20190813162649','2026-02-05 12:38:17',125), ('DoctrineMigrations\\Version20191024100951','2026-02-05 12:38:17',96), ('DoctrineMigrations\\Version20191108151534','2026-02-05 12:38:18',165), ('DoctrineMigrations\\Version20191113132640','2026-02-05 12:38:18',86), ('DoctrineMigrations\\Version20191116110124','2026-02-05 12:38:18',123), ('DoctrineMigrations\\Version20191204120823','2026-02-05 12:38:18',106), ('DoctrineMigrations\\Version20200109102138','2026-02-05 12:38:18',318), ('DoctrineMigrations\\Version20200125123942','2026-02-05 12:38:18',126), ('DoctrineMigrations\\Version20200204124425','2026-02-05 12:38:19',118), ('DoctrineMigrations\\Version20200205115243','2026-02-05 12:38:19',499), ('DoctrineMigrations\\Version20200205115244','2026-02-05 12:38:19',184), ('DoctrineMigrations\\Version20200308171950','2026-02-05 12:38:19',243), ('DoctrineMigrations\\Version20200323163038','2026-02-05 12:38:20',219), ('DoctrineMigrations\\Version20200323163039','2026-02-05 12:38:20',1), ('DoctrineMigrations\\Version20200413133226','2026-02-05 12:38:20',152), ('DoctrineMigrations\\Version20200524142042','2026-02-05 12:38:20',165), ('DoctrineMigrations\\Version20200705152310','2026-02-05 12:38:20',163), ('DoctrineMigrations\\Version20200725213424','2026-02-05 12:38:20',253), ('DoctrineMigrations\\Version20210316224358','2026-02-05 12:38:21',200), ('DoctrineMigrations\\Version20210320162820','2026-02-05 12:38:21',168), ('DoctrineMigrations\\Version20210405105611','2026-02-05 12:38:21',159), ('DoctrineMigrations\\Version20210605154245','2026-02-05 12:38:21',335), ('DoctrineMigrations\\Version20210704111542','2026-02-05 12:38:21',192), ('DoctrineMigrations\\Version20210717211144','2026-02-05 12:38:22',161), ('DoctrineMigrations\\Version20210719123928','2026-02-05 12:38:22',229), ('DoctrineMigrations\\Version20210727104955','2026-02-05 12:38:22',304), ('DoctrineMigrations\\Version20210802152259','2026-02-05 12:38:22',157), ('DoctrineMigrations\\Version20210802152814','2026-02-05 12:38:22',25), ('DoctrineMigrations\\Version20210802160837','2026-02-05 12:38:22',260), ('DoctrineMigrations\\Version20210802174318','2026-02-05 12:38:23',208), ('DoctrineMigrations\\Version20210802174319','2026-02-05 12:38:23',0), ('DoctrineMigrations\\Version20210802174320','2026-02-05 12:38:23',254), ('DoctrineMigrations\\Version20211008092010','2026-02-05 12:38:23',151), ('DoctrineMigrations\\Version20211230163612','2026-02-05 12:38:23',147), ('DoctrineMigrations\\Version20220101204501','2026-02-05 12:38:23',235), ('DoctrineMigrations\\Version20220315224645','2026-02-05 12:38:24',221), ('DoctrineMigrations\\Version20220404150236','2026-02-05 12:38:24',173), ('DoctrineMigrations\\Version20220531145920','2026-02-05 12:38:24',223), ('DoctrineMigrations\\Version20220722125847','2026-02-05 12:38:24',161), ('DoctrineMigrations\\Version20230126002049','2026-02-05 12:38:24',511), ('DoctrineMigrations\\Version20230126002050','2026-02-05 12:38:25',200), ('DoctrineMigrations\\Version20230327143628','2026-02-05 12:38:25',314), ('DoctrineMigrations\\Version20230606125948','2026-02-05 12:38:26',219), ('DoctrineMigrations\\Version20230819090536','2026-02-05 12:38:26',370), ('DoctrineMigrations\\Version20231130000719','2026-02-05 12:38:26',1), ('DoctrineMigrations\\Version20240214061246','2026-02-05 12:38:26',224), ('DoctrineMigrations\\Version20240326125247','2026-02-05 12:38:26',44), ('DoctrineMigrations\\Version20240920105524','2026-02-05 12:38:26',1), ('DoctrineMigrations\\Version20240926111739','2026-02-05 12:38:26',91), ('DoctrineMigrations\\Version20250608143244','2026-02-05 12:38:26',186), ('DoctrineMigrations\\Version20251031142000','2026-02-05 12:38:27',225), ('DoctrineMigrations\\Version20251031143000','2026-02-05 12:38:27',70), ('DoctrineMigrations\\Version20251214160001','2026-02-05 12:38:27',239); /*!40000 ALTER TABLE `migration_versions` ENABLE KEYS */; UNLOCK TABLES; /*!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 */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */; -- Dump completed on 2026-02-27 9:01:42