--
-- Host: 192.168.1.249    Database: grh-app
-- ------------------------------------------------------


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2024_09_30_122635_add_deleted_at_to_users_table',1),(5,'2024_09_30_125448_create_permission_tables',1),(6,'2024_09_30_153437_create_profiles_table',1),(7,'2024_09_30_154703_create_teams_table',1),(8,'2024_10_04_101429_add_team_id_to_users_table',1),(9,'2024_10_04_101543_remove_user_id_from_teams_table',1),(10,'2024_10_07_074324_add_valid_balance_from_users_table',1),(11,'2024_10_07_150727_create_leaves_table',1),(12,'2024_10_21_083744_update_valid_balance_to_decimal_in_users_table',1),(13,'2024_10_21_103404_add_authorization_hours_to_users_table',1),(14,'2024_10_21_130438_add_authorization_hour_to_leaves_table',1),(15,'2025_01_15_143151_aad_start_time_to_leaves_table',2),(16,'2025_02_10_085431_add_deduction_days_to_leaves_table',3);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(1,'App\\Models\\User',3),(1,'App\\Models\\User',4),(3,'App\\Models\\User',5),(3,'App\\Models\\User',6),(2,'App\\Models\\User',7),(2,'App\\Models\\User',9),(3,'App\\Models\\User',10),(3,'App\\Models\\User',11),(3,'App\\Models\\User',12),(3,'App\\Models\\User',13),(2,'App\\Models\\User',14),(2,'App\\Models\\User',15),(2,'App\\Models\\User',17),(2,'App\\Models\\User',19),(2,'App\\Models\\User',20),(2,'App\\Models\\User',22),(2,'App\\Models\\User',23),(2,'App\\Models\\User',24),(2,'App\\Models\\User',26),(2,'App\\Models\\User',27),(2,'App\\Models\\User',28),(2,'App\\Models\\User',29),(2,'App\\Models\\User',30),(2,'App\\Models\\User',31),(1,'App\\Models\\User',32),(2,'App\\Models\\User',34),(2,'App\\Models\\User',35),(2,'App\\Models\\User',36),(2,'App\\Models\\User',37),(3,'App\\Models\\User',38),(2,'App\\Models\\User',39),(2,'App\\Models\\User',40),(2,'App\\Models\\User',41),(2,'App\\Models\\User',42),(2,'App\\Models\\User',43),(2,'App\\Models\\User',44),(2,'App\\Models\\User',45),(2,'App\\Models\\User',46),(2,'App\\Models\\User',47),(2,'App\\Models\\User',48),(2,'App\\Models\\User',49),(2,'App\\Models\\User',50),(2,'App\\Models\\User',51),(2,'App\\Models\\User',53),(2,'App\\Models\\User',54),(2,'App\\Models\\User',55),(2,'App\\Models\\User',57),(1,'App\\Models\\User',59),(2,'App\\Models\\User',60),(2,'App\\Models\\User',61),(2,'App\\Models\\User',62),(2,'App\\Models\\User',63),(2,'App\\Models\\User',64),(2,'App\\Models\\User',65),(2,'App\\Models\\User',66),(2,'App\\Models\\User',67),(2,'App\\Models\\User',68),(2,'App\\Models\\User',69),(2,'App\\Models\\User',70),(2,'App\\Models\\User',71),(2,'App\\Models\\User',72),(2,'App\\Models\\User',73),(2,'App\\Models\\User',74),(2,'App\\Models\\User',75),(2,'App\\Models\\User',76),(2,'App\\Models\\User',77),(2,'App\\Models\\User',78),(2,'App\\Models\\User',79),(2,'App\\Models\\User',80),(2,'App\\Models\\User',81),(2,'App\\Models\\User',82),(2,'App\\Models\\User',83),(2,'App\\Models\\User',84),(1,'App\\Models\\User',85),(2,'App\\Models\\User',86);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'approve leave','web','2025-01-02 13:19:17','2025-01-02 13:19:17');

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile_picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `profiles_user_id_foreign` (`user_id`),
  CONSTRAINT `profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` VALUES (1,1,'admin',' ','23735335','/storage/images/placeholder.png','Route Ain klm 3 Ceinture Bourguiba','2025-01-02 13:19:17','2025-01-02 13:19:17'),(2,2,'Sydnee','Wise','00000000','/storage/profile_pictures/TbWE9XRaN1GRXkSerGmSoJtKZ5Opo4uVkCEcBx6T.png','Et alias nemo fugit','2025-01-02 13:33:20','2025-01-02 13:33:20'),(3,3,'Hadley','Bell','00000000','/storage/profile_pictures/xy6GdxZS2oiUUT1Q1xjysJkYJiManL1TACraP0DF.png','Tempora occaecat quo','2025-01-02 13:33:45','2025-01-02 13:33:45'),(4,4,'Nita','Decker','00000000','/storage/profile_pictures/ASTca57MLOnhHuu4cYAss4cAvci08qd17uv99TdY.png','Et qui aliquid non u','2025-01-02 13:34:02','2025-01-02 13:34:02'),(5,5,'Aurora','Shaffer','00000000',NULL,'Consequat Nemo maxi','2025-01-02 13:44:26','2025-01-02 13:44:26'),(7,7,'Lyle','Boyd','00000000',NULL,'Minima minima omnis','2025-01-02 13:55:59','2025-01-02 13:55:59'),(9,10,'Sonia','Rekik','29152554','/storage/profile_pictures/C7crOUHk8P4roVGWF8nv4HWjnb42PZby7ZKwf4gP.png','Route Saltnia','2025-01-03 08:40:07','2025-01-03 10:15:14'),(10,11,'Zeineb','Fourati','24332206','/storage/profile_pictures/kQHV63AHwM9RgLVP7Mcd5QS0IvWKQafbYlSoWjVM.jpg','Rourte L\'afrane','2025-01-03 08:41:50','2025-01-08 08:08:08'),(11,12,'Ghada','Besbes','21786030',NULL,'Route de Tunis','2025-01-03 08:42:51','2025-01-03 08:42:51'),(12,13,'Ines','Ben Ameur','29707079',NULL,'Route L\'Afrane','2025-01-03 08:44:36','2025-01-03 08:44:36'),(13,14,'Fatma','Hachicha','22673302',NULL,'Route de Tunis','2025-01-03 09:08:25','2025-01-03 09:08:25'),(14,15,'Omar','Jmal','94186113',NULL,'Gremda','2025-01-03 09:59:02','2025-01-03 10:01:00'),(15,17,'Anis','Khlif','51064512','/storage/profile_pictures/yelCXMmj8PWGAvfTKaDvIpneTYJpuKf7WWxeXjeW.png','Rte Gabes Km6','2025-01-03 10:10:51','2025-01-08 13:07:55'),(16,19,'nizar','arous','20268795','/storage/images/placeholder.png','route tunis km 1.5','2025-01-03 10:29:38','2025-01-03 10:29:38'),(17,20,'Majd','Ghabri','23213744','/storage/profile_pictures/oyL3oZ43CksqxNMFeMYrSmeILolStK6F6jIbNpnP.png','Rte Sokra','2025-01-03 10:33:22','2025-01-08 13:13:59'),(18,22,'Ghada','Berguiga','20992452','/storage/profile_pictures/IzaDfW7GSYBiGOUFa7tT61JbWhtMOe4LYAo6E7kQ.jpg','Rte Sokra','2025-01-03 10:35:54','2025-05-02 08:57:29'),(19,23,'Maher','Boughdiri','25458799','/storage/images/placeholder.png','Rte Matar','2025-01-03 12:09:04','2025-01-03 12:17:36'),(20,24,'Rassem','Ben Salah','54558017','/storage/images/placeholder.png','Rte Taniour','2025-01-03 12:10:03','2025-01-03 12:10:03'),(21,26,'Firas','Graja','52425007','/storage/images/placeholder.png','najet-kerkennha','2025-01-03 12:17:23','2025-01-08 14:11:30'),(22,27,'Karim','Hbiri','54773113','/storage/images/placeholder.png','Karim.hbiri@softtodo.com','2025-01-03 12:18:37','2025-01-03 12:18:37'),(23,28,'Dhouha','Mkaouar','55407404','/storage/profile_pictures/S8D5nFprHYFHiUnIWHanxfJBaQfTijbyYoYgPsDl.jpg','dhouha.mkaouar@softtodo.com','2025-01-03 12:22:11','2025-01-08 13:13:23'),(24,29,'Manel','Abdelhedi','53427775','/storage/images/placeholder.png','manel.abdelhedi@softtodo.com','2025-01-03 12:23:12','2025-01-03 12:23:12'),(25,30,'Olfa','Cheikhrouho','26789910','/storage/images/placeholder.png','Gremda','2025-01-03 12:24:11','2025-01-03 12:24:11'),(26,31,'Siwar','Zayani','23975444','/storage/images/placeholder.png','Route L\'afrane','2025-01-03 12:26:10','2025-01-08 13:06:26'),(27,32,'Ons','Chaari','52642453','/storage/images/placeholder.png','Route Manzel chaker','2025-01-03 12:27:24','2025-01-03 12:27:24'),(28,34,'Oussema','Loukil','22689980','/storage/images/placeholder.png','Amsterdam','2025-01-03 12:30:06','2025-01-08 13:10:47'),(29,35,'Omar','Sakhraoui','27161321','/storage/images/placeholder.png','Manzel Chaker','2025-01-03 12:33:59','2025-01-03 12:33:59'),(30,36,'sirine','Ben Fajria','26668990','/storage/images/placeholder.png','gremda','2025-01-03 12:36:09','2025-01-03 12:36:09'),(31,37,'Mariem','Moalla','58757557','/storage/images/placeholder.png','Rte lafrane','2025-01-03 12:46:37','2025-01-03 12:46:37'),(32,38,'Wafa','Trigui','20192511','/storage/profile_pictures/E10oQXVo75uzMRGJR9PaIkENyauptLtiORHLvNCL.jpg','Rte Saltniya','2025-01-03 12:47:54','2025-02-17 07:58:20'),(33,39,'Mariem','Mekki','24183426','/storage/images/placeholder.png','Rte Sidi Mansour klm 9','2025-01-03 13:07:17','2025-01-09 08:17:24'),(34,40,'Ayoub','Yaiech','24043800','/storage/images/placeholder.png','Sfax','2025-01-03 13:08:20','2025-01-03 13:08:20'),(35,41,'Omar','Ghorbel','21668026','/storage/images/placeholder.png','Rte Mahdia','2025-01-03 13:09:28','2025-01-03 13:09:28'),(36,42,'Jihed','Goui','27801491','/storage/images/placeholder.png','Rte Manzel Chaker','2025-01-03 13:10:07','2025-01-03 13:10:07'),(37,43,'Salma','Mhamdi','52819011','/storage/images/placeholder.png','Ghraba','2025-01-03 13:10:57','2025-01-03 13:10:57'),(38,44,'Chedlia','Ben Amor','58135005','/storage/images/placeholder.png','Lafrane','2025-01-03 13:11:48','2025-01-03 13:11:48'),(39,45,'Amal','Gadhrib','27025686','/storage/images/placeholder.png','Route Lafrane','2025-01-03 13:12:51','2025-04-18 07:41:30'),(40,46,'Kawther','Jmaiel','22218743','/storage/images/placeholder.png','Rte De Tunis','2025-01-03 13:13:33','2025-01-03 13:13:33'),(41,47,'Ala','Euchi','44670761','/storage/profile_pictures/L0OfcmW8lh4B7ttkgP6MFCdiNTWR8ZO3jvwMAWNL.jpg','Route mharza km 2.5, sfax','2025-01-03 13:14:23','2025-02-06 09:32:41'),(42,48,'Mohamed Sadok','Boukataya','5264333','/storage/images/placeholder.png','Rte Mahdia','2025-01-03 13:15:07','2025-01-03 13:15:07'),(43,49,'Mayssa','Bouden','92204799','/storage/profile_pictures/wksV5rZaq56nyJ7ICZai8XV2GAKbgWR7LbVSCGkV.jpg','****','2025-01-03 13:16:02','2025-05-06 14:51:40'),(44,50,'Mariem','Chaabene','+21653445968','/storage/images/placeholder.png','Rte Gremda','2025-01-03 13:16:51','2025-01-08 13:17:53'),(45,51,'Bilel','Belguith','20256488','/storage/images/placeholder.png','****','2025-01-03 13:18:33','2025-01-03 13:18:33'),(46,53,'Mohamed Aziz','Chaouch','*******','/storage/images/placeholder.png','Tunis','2025-01-03 13:21:23','2025-02-27 10:22:53'),(47,54,'Mohamed Amine','Oueslati','26936934','/storage/images/placeholder.png','Tunis','2025-01-03 13:22:26','2025-01-03 13:22:26'),(48,55,'Moataz','Guidara','44542216','/storage/images/placeholder.png','*****','2025-01-03 13:25:20','2025-01-03 13:25:20'),(49,57,'Racem','Fourati','********','/storage/images/placeholder.png','Rte L\'afrane','2025-01-03 14:14:33','2025-01-03 14:14:33'),(50,59,'Fatma','Abid','23735335','/storage/images/placeholder.png','Rte Manzel Chaker','2025-01-03 15:41:57','2025-01-03 15:41:57'),(51,60,'Mariem','Moalla','23211952','/storage/images/placeholder.png','Route l\'Afrane00','2025-01-06 10:02:48','2026-01-05 08:51:58'),(52,61,'Majdi','Ajroud','25782473','/storage/profile_pictures/mg3lp3Q0eMI8BWXNlqmS2FKEWJYvrtFFEtHGNZ0U.jpg','Tunis','2025-01-07 14:32:39','2025-08-29 12:57:34'),(53,62,'Amir','Kacem','54261990','/storage/images/placeholder.png','Tunis','2025-01-07 14:33:16','2025-01-07 14:33:16'),(54,63,'Amir','Kacem','54261990','/storage/images/placeholder.png','Tunis','2025-01-07 14:33:31','2025-01-07 14:33:31'),(55,64,'Saif Eddine','Ayedi','52784782','/storage/profile_pictures/7RVNFgL2VdDvnQl88cy02PXVj9CsaDesLNISHzc2.jpg','Route Mahdia Sekiet-daier','2025-01-08 14:03:32','2025-01-08 14:03:32'),(56,65,'Oussema','Kassis','*****','/storage/images/placeholder.png','****','2025-01-08 14:14:32','2025-01-08 14:14:32'),(57,66,'Oussema','Kassis','*****','/storage/images/placeholder.png','****','2025-01-08 14:15:10','2025-01-08 14:15:10'),(58,67,'Thabet','Sakhraoui','23308977','/storage/images/placeholder.png','Rte Manzel Chaker','2025-01-20 15:56:21','2025-01-20 15:56:21'),(59,68,'Ghassen','Marzougui','00000000','/storage/images/placeholder.png',NULL,'2025-02-26 15:42:55','2025-02-26 15:42:55'),(60,69,'Mohamed Karim','Ben Amar','00000000','/storage/images/placeholder.png',NULL,'2025-02-26 15:43:38','2025-02-26 15:43:38'),(61,70,'Hosni','Abbes','00','/storage/images/placeholder.png',NULL,'2025-02-28 08:26:29','2025-02-28 08:26:29'),(62,71,'Rihab','Boukhris','00000000','/storage/images/placeholder.png',NULL,'2025-02-28 08:38:06','2025-02-28 08:38:06'),(63,72,'Mohamed','Ben Salah','29884294','/storage/images/placeholder.png',NULL,'2025-03-14 09:36:32','2025-03-14 09:36:32'),(64,73,'Yassin','Abid','00000000','/storage/images/placeholder.png',NULL,'2025-03-18 10:48:53','2025-03-18 10:48:53'),(65,74,'Mohamed','Koubaa','00000000','/storage/images/placeholder.png',NULL,'2025-03-26 12:11:03','2025-03-26 12:14:14'),(66,75,'Khaled','Medhouib','00000000','/storage/images/placeholder.png',NULL,'2025-04-14 08:53:53','2025-04-14 08:53:53'),(67,76,'Houssem','Mhiri','00000000','/storage/images/placeholder.png',NULL,'2025-04-21 09:52:21','2025-04-21 09:52:21'),(68,77,'Wassim','Alyaoui','00000000','/storage/images/placeholder.png',NULL,'2025-06-18 08:26:43','2025-06-18 08:26:43'),(69,78,'Melek','Smaoui','00000000','/storage/images/placeholder.png','Sfax, Route el ain Km 3','2025-07-21 11:59:56','2025-07-21 11:59:56'),(70,79,'Oussema','Chkir','00000000','/storage/images/placeholder.png','Sfax, Route el ain Km 3','2025-07-31 12:26:01','2025-07-31 12:26:01'),(71,80,'Islem','Frioui','00000000','/storage/images/placeholder.png','tunis','2025-08-01 08:34:40','2025-08-01 08:34:40'),(72,81,'Ahmed','Belguith','00000000','/storage/images/placeholder.png','sfax','2025-08-01 09:00:43','2025-08-01 09:00:43'),(73,82,'Molka','Haddar','*****','/storage/images/placeholder.png','****','2025-08-20 10:50:08','2025-08-20 10:50:08'),(74,83,'Mohamed Bilel','Abidi','*****','/storage/images/placeholder.png','****','2025-09-12 08:12:33','2026-01-05 08:55:20'),(75,84,'Ahmed','Ellouze','57097748','/storage/images/placeholder.png',NULL,'2025-11-05 15:07:12','2025-11-05 15:07:12'),(76,85,'Areej','Ouerghui','52668548','/storage/images/placeholder.png',NULL,'2026-01-13 15:02:59','2026-01-13 15:02:59'),(77,86,'Ghassen','Saad','********','/storage/images/placeholder.png','Tunis','2026-02-03 07:57:16','2026-02-03 07:57:16');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,1);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'admin','web','2025-01-02 13:19:17','2025-01-02 13:19:17'),(2,'user','web','2025-01-02 13:19:17','2025-01-02 13:19:17'),(3,'project_manager','web','2025-01-02 13:19:17','2025-01-02 13:19:17');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('1Rp7vhO8OQxc0bmprcd1l1dlUhqjDHGMTMgVGF7u',28,'192.168.1.231','Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/144.0.7559.95 Mobile/15E148 Safari/604.1','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiak5MbHVrcW9IVVVnUnVOcGFWUGRpTTBFd3VmTjV2cG1JOXVUMlZDUCI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Mjg7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUvdGVhbXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1770212223),('6LNuXYBEnVrLYJIR0BB6W72T1MjAbvdoUU4nU0ma',NULL,'192.168.1.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiekFpcnk5dXZMZ1pIbjBPY0ZzVzVOZWx3cmlueDRmMXFLMHdOWUp4NSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1770210653),('6Q3dArgBFRIbeRuoZAAdgvIU0poxz3RepgWqBRTj',NULL,'192.168.1.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSm9aNHc3cFlydHFnc3NrWHlVVzd6eWgzYlZCd082UWV2T0dnNFpmWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1770208856),('AhmOD6lzBH4hZVTGOHAPabPwYT2dGVyAurc7aQ3x',NULL,'192.168.1.231','','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNndaZ1FRcTFYY1AwZlI2aEtsQm5DYXlUMzcxOWE5RlJ5blVYUFpsNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1770210666),('DAvyi6E4OQSLBQAeJdACmxL49d6WVHAwt2deJIOi',28,'192.168.1.231','Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/144.0.7559.95 Mobile/15E148 Safari/604.1','YTo0OntzOjY6Il90b2tlbiI7czo0MDoianlsZ3MzUDZtS0I4MWlLekN6RnJKS2oxZnRJaEZTNkFMcVEweGNuOSI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Mjg7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUvdGVhbXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1770208932),('ikeQhgCjLyN6Fs1bEY1WotOkMBJsIyUSaFGo72cW',26,'192.168.1.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoibjNiUldINjlQU1VIRnVYYmFLNHVIWGVvcFFDQVg4Z1hvUkdaVWVBNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTQ0OiJodHRwOi8vZ2VzdGlvbi1jb25nZS5zb2Z0MmRvLmRlL3Jlc2V0LXBhc3N3b3JkLzgzMGY2NzEyNGVjMzZlMDdhZWYxZDhjMWFkYjM1NzU0NmZhMjY4MWViY2VjNTc5OTQxNmZmZTdkYzFhMzhkNGE/ZW1haWw9ZmlyYXMuZ3JhamElNDBzb2Z0dG9kby5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToyNjt9',1770210592),('jCIJ5FZxfwwBxQk58fRMGinoaXrLR4Mb0gbSNOs0',NULL,'192.168.1.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoib2tXSDVjRHZKYXA4WlVKN1Q4NHJTNldEQ3NTM0hnb2hjdVBlZktudyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1770210652),('mLCH6J0ihG8MWnEdDbAfnWeA1ofLTMBtjj5RULIG',NULL,'192.168.1.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.3','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOWlMSE9ENWdZaTFJcVJtbWdtM2FlUElpOWtVTWFaRXlNaVFpcExLRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1770211580),('OzTLwTfg4idDiPkB7pR4NOs7Dn9lYKgRxiPPs4r1',85,'192.168.1.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZ05LVmtyQ1dWamVoMkV1aXNyUXN0OHAzQnd4d0s3SXhib3ZyZUVrWiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo4NTt9',1770210495),('PL1hJreMvfbcM1rm2o6GdQrb0xkwGzsH6tF3WpX3',71,'192.168.1.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiV2hRWENmUFZRSVFVWFhrc01sVzJwZUlBMXgyWFJLZXZzck51RjlTQyI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NzE7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUvdGVhbXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1770210477),('qyQozwl51Ox5Q4voL1SyhcVXLL7PW7vGjj5q4rnI',73,'192.168.1.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoicGt3TlRnZ0NnQTU5UDU0RVl6blIxblUxQjFWNEF0SGtLRlNnbzVBTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo3Mzt9',1770212723),('u9tqhfqceNDfCuiMHdV400gIoa9SqoehI8br2Qpo',NULL,'192.168.1.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWWhneHM1Tk5KNHhXdGdHTFpIYUdtdW5TS2lHdjlrc1RDZEFEcHVrQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1770210667),('XNSZKBnm8YSOLiyqMUCzCeRg3V7kNvCyaFASCpyr',81,'192.168.1.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoicU5kb1pKMmJyZm9aMTlhMlVjUmVZRWJlTjZxRW1uZ2xMMEJKbTNrUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo4MTt9',1770213908),('xr086W0eRjWpefjtPEfWyzJLqhWYI6nDxeSrKOfA',26,'192.168.1.231','Mozilla/5.0 (Linux; Android 12; M2101K7BG Build/SP1A.210812.016; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/144.0.7559.109 Mobile Safari/537.36 [FB_IAB/FB4A;FBAV/546.0.0.35.70;]','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQ3hhTjBFSFpheE1NcWxlVmdxS1dkeExPbVk3dVZvQzB5WG9kaEUyaiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly9nZXN0aW9uLWNvbmdlLnNvZnQyZG8uZGUvZGFzaGJvYXJkIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MjY7fQ==',1770210678);

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `team_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `project_manager_id` bigint unsigned DEFAULT NULL,
  `profile_picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `teams_project_manager_id_foreign` (`project_manager_id`),
  CONSTRAINT `teams_project_manager_id_foreign` FOREIGN KEY (`project_manager_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` VALUES (1,'softtodo',1,'','2025-01-02 13:19:17','2025-03-24 09:01:43'),(3,'MGO',13,NULL,'2025-01-02 14:00:37','2025-01-03 08:44:50'),(4,'Finanztip',11,NULL,'2025-01-03 08:45:00','2025-01-03 08:45:00'),(5,'Gold Land',10,NULL,'2025-01-03 08:46:03','2025-01-03 08:46:03'),(6,'Konversions Kraft',12,NULL,'2025-01-03 13:25:44','2025-01-03 13:25:44'),(7,'Ping',59,NULL,'2025-01-06 14:29:29','2025-01-06 14:29:29'),(8,'Phillip Baumgärtner',59,NULL,'2025-01-06 14:29:49','2025-01-06 14:29:49'),(9,'Systém Média',59,NULL,'2025-01-08 13:24:37','2025-01-08 13:24:37'),(10,'HR',59,NULL,'2025-03-26 11:04:58','2025-03-26 11:04:58');


