--
-- Host: localhost    Database: gaha6994_kimai_db
-- ------------------------------------------------------


--
-- Table structure for table `kimai2_access_token`
--

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;

--
-- Dumping data for table `kimai2_access_token`
--

INSERT INTO `kimai2_access_token` VALUES
(1,2,'68593e8c7c06692d7c02a23cb','API 2','2026-02-26 17:49:16',NULL);

--
-- Table structure for table `kimai2_activities`
--

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;

--
-- Dumping data for table `kimai2_activities`
--

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');

--
-- Table structure for table `kimai2_activities_meta`
--

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;

--
-- Dumping data for table `kimai2_activities_meta`
--


--
-- Table structure for table `kimai2_activities_rates`
--

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;

--
-- Dumping data for table `kimai2_activities_rates`
--


--
-- Table structure for table `kimai2_activities_teams`
--

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;

--
-- Dumping data for table `kimai2_activities_teams`
--


--
-- Table structure for table `kimai2_bookmarks`
--

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;

--
-- Dumping data for table `kimai2_bookmarks`
--

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\":[]}]');

--
-- Table structure for table `kimai2_configuration`
--

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;

--
-- Dumping data for table `kimai2_configuration`
--

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','yoannbataille@gmail.com'),
(15,'approval.workflow_start','2026-01-01'),
(16,'approval.overtime_ny','1'),
(17,'approval.breakchecks_ny','0'),
(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');

--
-- Table structure for table `kimai2_customer_portals`
--

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;

--
-- Dumping data for table `kimai2_customer_portals`
--

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);

--
-- Table structure for table `kimai2_customers`
--

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;

--
-- Dumping data for table `kimai2_customers`
--

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);

--
-- Table structure for table `kimai2_customers_comments`
--

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;

--
-- Dumping data for table `kimai2_customers_comments`
--


--
-- Table structure for table `kimai2_customers_meta`
--

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;

--
-- Dumping data for table `kimai2_customers_meta`
--


--
-- Table structure for table `kimai2_customers_rates`
--

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;

--
-- Dumping data for table `kimai2_customers_rates`
--

INSERT INTO `kimai2_customers_rates` VALUES
(1,2,3,30,0,NULL),
(2,2,5,60,0,NULL);

--
-- Table structure for table `kimai2_customers_teams`
--

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;

--
-- Dumping data for table `kimai2_customers_teams`
--


--
-- Table structure for table `kimai2_export_templates`
--

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;

--
-- Dumping data for table `kimai2_export_templates`
--


--
-- Table structure for table `kimai2_ext_approval`
--

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=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kimai2_ext_approval`
--

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,0,'2026-02-25 09:39:04'),
(3,3,'2026-02-23','2026-03-01',57600,0,'2026-02-25 09:41:30'),
(4,3,'2026-02-23','2026-03-01',57600,0,'2026-02-25 11:19:11'),
(5,2,'2024-12-30','2025-01-05',0,57600,'2026-02-27 08:14:21'),
(6,2,'2025-12-29','2026-01-04',0,112980,'2026-02-27 08:22:29'),
(7,3,'2026-02-23','2026-03-01',57600,57600,'2026-02-27 08:27:38'),
(8,3,'2026-02-23','2026-03-01',57600,57600,'2026-02-27 08:29:43'),
(9,3,'2026-02-23','2026-03-01',57600,57600,'2026-02-27 08:30:09');

--
-- Table structure for table `kimai2_ext_approval_history`
--

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;

--
-- Dumping data for table `kimai2_ext_approval_history`
--


--
-- Table structure for table `kimai2_ext_approval_overtime_history`
--

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;

--
-- Dumping data for table `kimai2_ext_approval_overtime_history`
--


--
-- Table structure for table `kimai2_ext_approval_status`
--

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;

--
-- Dumping data for table `kimai2_ext_approval_status`
--


--
-- Table structure for table `kimai2_ext_approval_workday_history`
--

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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kimai2_ext_approval_workday_history`
--

INSERT INTO `kimai2_ext_approval_workday_history` VALUES
(1,3,28800,0,0,28800,0,0,0,'2026-12-31');

--
-- Table structure for table `kimai2_invoice_templates`
--

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;

--
-- Dumping data for table `kimai2_invoice_templates`
--

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);

--
-- Table structure for table `kimai2_invoice_templates_meta`
--

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;

--
-- Dumping data for table `kimai2_invoice_templates_meta`
--


--
-- Table structure for table `kimai2_invoices`
--

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;

--
-- Dumping data for table `kimai2_invoices`
--

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);

--
-- Table structure for table `kimai2_invoices_meta`
--

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;

--
-- Dumping data for table `kimai2_invoices_meta`
--


--
-- Table structure for table `kimai2_projects`
--

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;

--
-- Dumping data for table `kimai2_projects`
--

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');

--
-- Table structure for table `kimai2_projects_comments`
--

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;

--
-- Dumping data for table `kimai2_projects_comments`
--


--
-- Table structure for table `kimai2_projects_meta`
--

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;

--
-- Dumping data for table `kimai2_projects_meta`
--


--
-- Table structure for table `kimai2_projects_rates`
--

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;

--
-- Dumping data for table `kimai2_projects_rates`
--

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);

--
-- Table structure for table `kimai2_projects_teams`
--

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;

--
-- Dumping data for table `kimai2_projects_teams`
--


--
-- Table structure for table `kimai2_roles`
--

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;

--
-- Dumping data for table `kimai2_roles`
--

INSERT INTO `kimai2_roles` VALUES
(3,'ROLE_ADMIN'),
(4,'ROLE_SUPER_ADMIN'),
(2,'ROLE_TEAMLEAD'),
(1,'ROLE_USER');

--
-- Table structure for table `kimai2_roles_permissions`
--

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;

--
-- Dumping data for table `kimai2_roles_permissions`
--

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);

--
-- Table structure for table `kimai2_sessions`
--

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;

--
-- Dumping data for table `kimai2_sessions`
--

INSERT INTO `kimai2_sessions` VALUES
('1gs2jqba15s8lb1p4d57a1j3t1','_sf2_attributes|a:1:{s:22:\"_security_secured_area\";s:449:\"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:3;s:8:\"username\";s:19:\"Yoann Mystic Limite\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"diseno@mysticlimite.com\";s:8:\"password\";s:60:\"$2y$13$NlGe9I7Dn6nS8.JNEauNAe42Z9ujIOF8W9sPnaEnTKJRTDO6jyHUi\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:1:{i:0;s:9:\"ROLE_USER\";}}}\";}_sf2_meta|a:3:{s:1:\"u\";i:1772181082;s:1:\"c\";i:1772181082;s:1:\"l\";i:0;}',1772181082,1772182522),
('6lu1p3srjf3lncqud8j6dlck3s','_sf2_attributes|a:5:{s:23:\"_security.last_username\";s:23:\"diseno@mysticlimite.com\";s:22:\"_security_secured_area\";s:410:\"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:3;s:8:\"username\";s:19:\"Yoann Mystic Limite\";s:7:\"enabled\";b:1;s:5:\"email\";s:23:\"diseno@mysticlimite.com\";s:8:\"password\";s:60:\"$2y$13$NlGe9I7Dn6nS8.JNEauNAe42Z9ujIOF8W9sPnaEnTKJRTDO6jyHUi\";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:1:{i:0;s:9:\"ROLE_USER\";}}}\";s:18:\"_csrf/https-search\";s:43:\"2VLO4SikPbK_nrANFlycnZlJ_0w02eu1FWTU107p3DM\";s:28:\"_csrf/https-datatable_update\";s:43:\"sD3O7t1THn0sNaGwfPfuutqKGZqMzQ8ymjV2LzIPvE0\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"aH_1V1roMVIntqhAyB-J8AnK2Y8BjnubvUrPKgoDGIQ\";}_sf2_meta|a:3:{s:1:\"u\";i:1772181011;s:1:\"c\";i:1772180963;s:1:\"l\";i:0;}',1772181011,1772182451),
('8cdg52bl4h9ain7m2agc3pe8vb','_sf2_attributes|a:5:{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:\"m6UYDfLEsDR1QHW08fMppECC_Lm9pfDIw1GTUbRik6E\";s:28:\"_csrf/https-datatable_update\";s:43:\"8kDmoOUtnMyF0Cp3ET7XQRbnAK8tiOpkZ3QgrICoz8Q\";s:32:\"_csrf/https-entities_multiupdate\";s:43:\"vG9Lew9PLmPW5NRO3DwajFLX5jz4-a_IRFBiK2_qBNs\";s:26:\"_csrf/https-timesheet_edit\";s:43:\"Yd1cwBJ_CtdRWSjX8KlB7dASOHyVeUseFjpDBiP177c\";}_sf2_meta|a:3:{s:1:\"u\";i:1772180088;s:1:\"c\";i:1772179942;s:1:\"l\";i:0;}',1772180088,1772181528),
('cag0datumbpar44clvf6os6m9k','_sf2_attributes|a:1:{s:22:\"_security_secured_area\";s:463:\"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: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\";}}}\";}_sf2_meta|a:3:{s:1:\"u\";i:1772184280;s:1:\"c\";i:1772184280;s:1:\"l\";i:0;}',1772184280,1772185720),
('hlfcb3vpedek6vi793v8h3inhh','_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:\"2oc306tfQjX-r9CNhHcqse-rDCrS-lusdfdsX0dgtOg\";s:27:\"_csrf/https-invoice.preview\";s:43:\"HRYLxvC860SnthJPVAH2xm8MrQYp52kfVkuxA7XjCms\";s:26:\"_csrf/https-invoice.create\";s:43:\"W5_tByW8Qj6ip8LXPWQaQICNPb4VFJ_zQfRtX0Ef-HE\";}_sf2_meta|a:3:{s:1:\"u\";i:1772184563;s:1:\"c\";i:1772184440;s:1:\"l\";i:0;}',1772184563,1772186003),
('usf6ma4sdgnm56lajfepuo8aig','_sf2_attributes|a:2:{s:34:\"_security.secured_area.target_path\";s:54:\"https://kimai.studio-folio.com/fr/admin/system-config/\";s:22:\"_security_secured_area\";s:463:\"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: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\";}}}\";}_sf2_meta|a:3:{s:1:\"u\";i:1772184280;s:1:\"c\";i:1772184280;s:1:\"l\";i:0;}',1772184280,1772185720);

--
-- Table structure for table `kimai2_tags`
--

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;

--
-- Dumping data for table `kimai2_tags`
--

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);

--
-- Table structure for table `kimai2_teams`
--

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;

--
-- Dumping data for table `kimai2_teams`
--


--
-- Table structure for table `kimai2_timesheet`
--

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=338 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kimai2_timesheet`
--

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-27 08:00:00','2026-02-27 16:00:00',28800,NULL,0,NULL,0,0,'Europe/Madrid',0,0,'work','2026-02-27 08:26:31','2026-02-27',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),
(336,2,5,9,'2026-02-27 08:00:00','2026-02-27 16:00:00',28800,NULL,0,NULL,0,0,'Europe/Paris',0,0,'work','2026-02-27 08:13:26','2026-02-27',0),
(337,3,5,9,'2026-02-23 08:00:00','2026-02-23 16:00:00',28800,NULL,0,NULL,0,0,'Europe/Madrid',0,0,'work','2026-02-27 08:26:59','2026-02-23',0);

--
-- Table structure for table `kimai2_timesheet_meta`
--

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;

--
-- Dumping data for table `kimai2_timesheet_meta`
--


--
-- Table structure for table `kimai2_timesheet_tags`
--

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;

--
-- Dumping data for table `kimai2_timesheet_tags`
--

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);

--
-- Table structure for table `kimai2_user_preferences`
--

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;

--
-- Dumping data for table `kimai2_user_preferences`
--

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');

--
-- Table structure for table `kimai2_users`
--

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;

--
-- Dumping data for table `kimai2_users`
--

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 09:27:20',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-27 08:27:51',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:0:{}','2026-02-27 08:31:22',NULL,NULL,NULL,'kimai','#ffa500',NULL,'3OM2Q3EKT5N4ZFERD2JFHATEQ4IYTK5343T7PXDALZVKZEVWSI3Q',0,0,2);

--
-- Table structure for table `kimai2_users_teams`
--

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;

--
-- Dumping data for table `kimai2_users_teams`
--


--
-- Table structure for table `kimai2_working_times`
--

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;

--
-- Dumping data for table `kimai2_working_times`
--


--
-- Table structure for table `migration_versions`
--

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;

--
-- Dumping data for table `migration_versions`
--

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);


