--
-- Host: localhost    Database: pixlogix_hrm_dev
-- ------------------------------------------------------


--
-- Table structure for table `activities`
--

CREATE TABLE `activities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `interview_id` bigint(20) unsigned DEFAULT NULL,
  `candidate_id` bigint(20) unsigned DEFAULT NULL,
  `employee_id` bigint(20) unsigned DEFAULT NULL,
  `type` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activities_interview_id_foreign` (`interview_id`),
  KEY `activities_candidate_id_foreign` (`candidate_id`),
  KEY `activities_employee_id_foreign` (`employee_id`),
  CONSTRAINT `activities_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activities_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `activities_interview_id_foreign` FOREIGN KEY (`interview_id`) REFERENCES `interviews` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activities`
--


--
-- Table structure for table `attendance_logs`
--

CREATE TABLE `attendance_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `entry_type` varchar(255) DEFAULT NULL,
  `check_in` datetime DEFAULT NULL,
  `check_out` datetime DEFAULT NULL,
  `working_hours` time DEFAULT NULL,
  `time_difference` time DEFAULT NULL,
  `break_hours` time DEFAULT NULL,
  `break_timings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`break_timings`)),
  `todos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`todos`)),
  `status` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attendance_logs_employee_id_foreign` (`employee_id`),
  CONSTRAINT `attendance_logs_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attendance_logs`
--


--
-- Table structure for table `badges`
--

CREATE TABLE `badges` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `badges`
--


--
-- Table structure for table `candidate_tasks`
--

CREATE TABLE `candidate_tasks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `candidate_id` bigint(20) unsigned NOT NULL,
  `task_date` date NOT NULL,
  `text_description` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `candidate_tasks_candidate_id_foreign` (`candidate_id`),
  CONSTRAINT `candidate_tasks_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `candidate_tasks`
--


--
-- Table structure for table `candidates`
--

CREATE TABLE `candidates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` text NOT NULL,
  `last_name` text NOT NULL,
  `email` text NOT NULL,
  `phone` int(11) NOT NULL,
  `location` text DEFAULT NULL,
  `designation` text NOT NULL,
  `opening` text NOT NULL,
  `experience` int(11) NOT NULL,
  `expected_ctc` text NOT NULL,
  `current_ctc` text NOT NULL,
  `notice_period` int(11) NOT NULL,
  `resume` text NOT NULL,
  `description` longtext NOT NULL,
  `source` text NOT NULL,
  `current_status` text NOT NULL,
  `final_status` text NOT NULL,
  `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`tags`)),
  `candidate_id` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `candidates_candidate_id_unique` (`candidate_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `candidates`
--

INSERT INTO `candidates` VALUES (1,'jack','Pattel','jack@gmail.com',1212121212,'Ahmedabad','Wordpress Developer','',2,'20000','18000',2,'','','','','',' {\"test\":\"sss\"}','ADAFD','2024-05-29 00:54:54','2024-05-29 00:55:06');

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `source` varchar(255) NOT NULL,
  `employee_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL,
  `updated_by` varchar(255) NOT NULL,
  `created_by` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clients_employee_id_foreign` (`employee_id`),
  CONSTRAINT `clients_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clients`
--


--
-- Table structure for table `department_goals`
--

CREATE TABLE `department_goals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `employee_id` bigint(20) unsigned DEFAULT NULL,
  `department_id` bigint(20) unsigned DEFAULT NULL,
  `duration` varchar(255) NOT NULL,
  `weightage` bigint(20) unsigned DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `completion` bigint(20) unsigned NOT NULL,
  `remarks` text NOT NULL,
  `user_submit_goal` tinyint(1) DEFAULT NULL,
  `tl_submit_goal` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `department_goals_employee_id_foreign` (`employee_id`),
  KEY `department_goals_department_id_foreign` (`department_id`),
  CONSTRAINT `department_goals_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE SET NULL,
  CONSTRAINT `department_goals_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `department_goals`
--


--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` VALUES (1,'Human Resource',1,0,'2022-10-04 04:39:15','2022-10-04 04:39:15'),(2,'Technical HR',1,1,'2022-11-01 03:50:53','2022-11-01 03:50:53'),(3,'Development',1,0,'2022-11-04 19:42:15','2022-11-04 19:42:15'),(4,'Frontend + UI/UX',1,0,'2022-11-16 00:50:11','2022-11-16 00:50:11'),(6,'Magento',1,3,'2022-11-16 05:14:35','2022-11-21 21:36:41');

--
-- Table structure for table `designations`
--

CREATE TABLE `designations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `designations`
--

INSERT INTO `designations` VALUES (1,'Web Developer',1,'2022-10-04 05:06:15','2022-10-04 05:06:15'),(2,'HR',1,'2022-10-13 07:31:54','2022-10-13 07:31:54'),(3,'Web Designer',1,'2022-11-16 01:08:57','2022-11-25 23:41:35'),(4,'Team Leader',1,'2022-11-17 00:46:49','2022-11-17 00:46:49'),(5,'Project Manager',1,'2022-11-17 00:47:03','2022-11-17 00:47:03'),(8,'Recruiter',1,'2022-11-28 21:15:49','2022-11-28 21:15:49');

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` longtext NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` VALUES (1,'site.created','Site created Successfully','<!-- START CENTERED WHITE CONTAINER -->\r\n          <table role=\"presentation\" class=\"main\">\r\n\r\n            <!-- START MAIN CONTENT AREA -->\r\n            <tr>\r\n              <td class=\"wrapper\">\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                  <tr>\r\n                    <td>\r\n                      <p>Hi there,</p>\r\n                      <p>Your Account is created with the username as \"{full_name}\" and you employee id is <b>\"{employee_id}\"</p>\r\n                      <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"btn btn-primary\">\r\n                        <tbody>\r\n                          <tr>\r\n                            <td align=\"left\">\r\n                              <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                <tbody>\r\n                                  <tr>\r\n                                    <td> <a href=\"{{route(\'login\')}}\" target=\"_blank\">Login Now</a> </td>\r\n                                  </tr>\r\n                                </tbody>\r\n                              </table>\r\n                            </td>\r\n                          </tr>\r\n                        </tbody>\r\n                      </table>                        \r\n                    </td>\r\n                  </tr>\r\n                </table>\r\n              </td>\r\n            </tr>\r\n\r\n          <!-- END MAIN CONTENT AREA -->\r\n          </table>\r\n          <!-- END CENTERED WHITE CONTAINER -->',1,'2022-12-05 23:53:28','2023-02-01 08:15:45'),(2,'site.updated','Site updated','<!-- START CENTERED WHITE CONTAINER -->\r\n        <table role=\"presentation\" class=\"main\">\r\n\r\n          <!-- START MAIN CONTENT AREA -->\r\n          <tr>\r\n            <td class=\"wrapper\">\r\n              <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                <tr>\r\n                  <td>\r\n                    <p>Hi there,</p>\r\n                    <p>Your company details has been updated successfully</p>                        \r\n                  </td>\r\n                </tr>\r\n              </table>\r\n            </td>\r\n          </tr>\r\n\r\n        <!-- END MAIN CONTENT AREA -->\r\n        </table>\r\n        <!-- END CENTERED WHITE CONTAINER -->',1,'2022-12-05 23:53:44','2023-02-01 08:21:34'),(3,'site.deleted','Site deleted','<!-- START CENTERED WHITE CONTAINER -->\r\n        <table role=\"presentation\" class=\"main\">\r\n\r\n          <!-- START MAIN CONTENT AREA -->\r\n          <tr>\r\n            <td class=\"wrapper\">\r\n              <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                <tr>\r\n                  <td>\r\n                    <p>Hi there,</p>\r\n                    <p>This mail is to inform you that the company named <strong>\"{{$name}}\"</strong> has been removed from our organization.</p>                        \r\n                  </td>\r\n                </tr>\r\n              </table>\r\n            </td>\r\n          </tr>\r\n\r\n        <!-- END MAIN CONTENT AREA -->\r\n        </table>\r\n        <!-- END CENTERED WHITE CONTAINER -->',1,'2022-12-05 23:54:00','2023-02-01 08:21:51'),(4,'user.created','Login account created','<!-- START CENTERED WHITE CONTAINER -->\r\n                    <table role=\"presentation\" class=\"main\">\r\n\r\n                        <!-- START MAIN CONTENT AREA -->\r\n                        <tr>\r\n                            <td class=\"wrapper\">\r\n                                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                    <tr>\r\n                                        <td>\r\n                                            <p>Hi there,</p>\r\n                                            <p>Your Account is created with the username as\r\n                                                <strong>\"{name}\"</strong> You can now login and access the\r\n                                                services now.</p>\r\n                                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"\r\n                                                class=\"btn btn-primary\">\r\n                                                <tbody>\r\n                                                    <tr>\r\n                                                        <td align=\"left\">\r\n                                                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\"\r\n                                                                cellspacing=\"0\">\r\n                                                                <tbody>\r\n                                                                    <tr>\r\n                                                                        <td><a href=\"{{ route(\'login\') }}\"\r\n                                                                                target=\"_blank\">Login here</a> </td>\r\n                                                                    </tr>\r\n                                                                </tbody>\r\n                                                            </table>\r\n                                                        </td>\r\n                                                    </tr>\r\n                                                </tbody>\r\n                                            </table>\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n\r\n                        <!-- END MAIN CONTENT AREA -->\r\n                    </table>\r\n                    <!-- END CENTERED WHITE CONTAINER -->',1,'2022-12-05 23:55:04','2023-02-01 08:22:31'),(5,'user.suspended','Account Suspended','<!-- START CENTERED WHITE CONTAINER -->\r\n        <table role=\"presentation\" class=\"main\">\r\n\r\n          <!-- START MAIN CONTENT AREA -->\r\n          <tr>\r\n            <td class=\"wrapper\">\r\n              <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                <tr>\r\n                  <td>\r\n                    <p>Hi there,</p>\r\n                    <p>Your acccount has beed suspended by the Organization due to some reasons. please contact you management for more details.</p>                        \r\n                  </td>\r\n                </tr>\r\n              </table>\r\n            </td>\r\n          </tr>\r\n\r\n        <!-- END MAIN CONTENT AREA -->\r\n        </table>\r\n        <!-- END CENTERED WHITE CONTAINER -->',1,'2022-12-05 23:55:38','2023-02-01 08:22:43'),(6,'user.updated','Account Updated','<!-- START CENTERED WHITE CONTAINER -->\r\n                    <table role=\"presentation\" class=\"main\">\r\n\r\n                        <!-- START MAIN CONTENT AREA -->\r\n                        <tr>\r\n                            <td class=\"wrapper\">\r\n                                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                    <tr>\r\n                                        <td>\r\n                                            <p>Hi there,</p>\r\n                                            <p>Your acccount has updated please check the account privilages by logging in\r\n                                                with you account credentials.</p>\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n\r\n                        <!-- END MAIN CONTENT AREA -->\r\n                    </table>\r\n                    <!-- END CENTERED WHITE CONTAINER -->',1,'2022-12-05 23:55:52','2023-02-01 08:22:58'),(7,'user.password_updated','Password updated','<!-- START CENTERED WHITE CONTAINER -->\r\n                    <table role=\"presentation\" class=\"main\">\r\n\r\n                        <!-- START MAIN CONTENT AREA -->\r\n                        <tr>\r\n                            <td class=\"wrapper\">\r\n                                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                    <tr>\r\n                                        <td>\r\n                                            <p>Hi there,</p>\r\n                                            <p>Your account password has been updated recently.</p>\r\n                                            <p> Click here to check you account status </p>\r\n                                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"\r\n                                                class=\"btn btn-primary\">\r\n                                                <tbody>\r\n                                                    <tr>\r\n                                                        <td align=\"left\">\r\n                                                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\"\r\n                                                                cellspacing=\"0\">\r\n                                                                <tbody>\r\n                                                                    <tr>\r\n                                                                        <td><a href=\"{{ route(\'login\') }}\"\r\n                                                                                target=\"_blank\">Login</a> </td>\r\n                                                                    </tr>\r\n                                                                </tbody>\r\n                                                            </table>\r\n                                                        </td>\r\n                                                    </tr>\r\n                                                </tbody>\r\n                                            </table>\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n\r\n                        <!-- END MAIN CONTENT AREA -->\r\n                    </table>\r\n                    <!-- END CENTERED WHITE CONTAINER -->',1,'2022-12-05 23:56:15','2023-02-01 08:23:11'),(8,'employee.created','Welcome {{$full_name}}','<!-- START CENTERED WHITE CONTAINER -->\r\n          <table role=\"presentation\" class=\"main\">\r\n\r\n            <!-- START MAIN CONTENT AREA -->\r\n            <tr>\r\n              <td class=\"wrapper\">\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                  <tr>\r\n                    <td>\r\n                      <p>Hi there,</p>\r\n                      <p>Your Account is created with the username as \"{{$full_name}}\" and you employee id is <b>\"{{$employee_id}}\"</p>\r\n                      <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"btn btn-primary\">\r\n                        <tbody>\r\n                          <tr>\r\n                            <td align=\"left\">\r\n                              <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                <tbody>\r\n                                  <tr>\r\n                                    <td> <a href=\"{{route(\'login\')}}\" target=\"_blank\">Login Now</a> </td>\r\n                                  </tr>\r\n                                </tbody>\r\n                              </table>\r\n                            </td>\r\n                          </tr>\r\n                        </tbody>\r\n                      </table>                        \r\n                    </td>\r\n                  </tr>\r\n                </table>\r\n              </td>\r\n            </tr>\r\n\r\n          <!-- END MAIN CONTENT AREA -->\r\n          </table>\r\n          <!-- END CENTERED WHITE CONTAINER -->',1,'2022-12-05 23:56:36','2023-02-01 08:23:25'),(9,'employee.updated','Account Updated','<!-- START CENTERED WHITE CONTAINER -->\r\n                    <table role=\"presentation\" class=\"main\">\r\n\r\n                        <!-- START MAIN CONTENT AREA -->\r\n                        <tr>\r\n                            <td class=\"wrapper\">\r\n                                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                    <tr>\r\n                                        <td>\r\n                                            <p>Hi there,</p>\r\n                                            <p>Your acccount has updated please check the account privilages by logging in\r\n                                                with you account credentials.</p>\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n\r\n                        <!-- END MAIN CONTENT AREA -->\r\n                    </table>\r\n                    <!-- END CENTERED WHITE CONTAINER -->',1,'2022-12-09 22:43:08','2023-02-01 08:23:42'),(10,'leave.created','Leave Created','Leave Created',1,'2022-12-19 06:43:59','2022-12-19 06:43:59'),(11,'leave.approved','Leave Approved','Leave Approved',1,'2022-12-19 06:44:13','2022-12-19 06:44:13'),(12,'leave.denied','Leave Denied','Leave Denied',1,'2022-12-19 06:44:28','2022-12-19 06:44:28'),(13,'site.updaterequest','Update request sent','<!-- START CENTERED WHITE CONTAINER -->\r\n                    <table role=\"presentation\" class=\"main\">\r\n\r\n                        <!-- START MAIN CONTENT AREA -->\r\n                        <tr>\r\n                            <td class=\"wrapper\">\r\n                                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                    <tr>\r\n                                        <td>\r\n                                            <p>Hi there,</p>\r\n                                            {message}\r\n                                            \r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n\r\n                        <!-- END MAIN CONTENT AREA -->\r\n                    </table>\r\n                    <!-- END CENTERED WHITE CONTAINER -->',1,'2023-01-13 10:58:11','2023-02-01 08:22:03');

--
-- Table structure for table `employee_documents`
--

CREATE TABLE `employee_documents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `document_id` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `created_by` varchar(255) NOT NULL,
  `updated_by` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_documents_employee_id_foreign` (`employee_id`),
  CONSTRAINT `employee_documents_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employee_documents`
--


--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `employee_id` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `middle_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `gender` varchar(255) NOT NULL,
  `department_id` bigint(20) unsigned NOT NULL,
  `sub_department_id` bigint(20) unsigned NOT NULL,
  `designation_id` bigint(20) unsigned NOT NULL,
  `level_id` bigint(20) unsigned NOT NULL,
  `report_to` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`report_to`)),
  `role` bigint(20) unsigned NOT NULL,
  `profile_image` text DEFAULT NULL,
  `joining_date` date NOT NULL,
  `company_phone` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `employees_employee_id_unique` (`employee_id`),
  UNIQUE KEY `employees_email_unique` (`email`),
  UNIQUE KEY `employees_slug_unique` (`slug`),
  KEY `employees_department_id_foreign` (`department_id`),
  KEY `employees_sub_department_id_foreign` (`sub_department_id`),
  KEY `employees_designation_id_foreign` (`designation_id`),
  KEY `employees_level_id_foreign` (`level_id`),
  CONSTRAINT `employees_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `employees_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`),
  CONSTRAINT `employees_level_id_foreign` FOREIGN KEY (`level_id`) REFERENCES `levels` (`id`),
  CONSTRAINT `employees_sub_department_id_foreign` FOREIGN KEY (`sub_department_id`) REFERENCES `departments` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employees`
--


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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext 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 `feedback`
--

CREATE TABLE `feedback` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `point_id` bigint(20) unsigned DEFAULT NULL,
  `feedback_type` varchar(255) NOT NULL,
  `employee_id` bigint(20) unsigned DEFAULT NULL,
  `feedback_points` text NOT NULL,
  `status` smallint(6) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `feedback_point_id_foreign` (`point_id`),
  KEY `feedback_employee_id_foreign` (`employee_id`),
  CONSTRAINT `feedback_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE SET NULL,
  CONSTRAINT `feedback_point_id_foreign` FOREIGN KEY (`point_id`) REFERENCES `feedback_points` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedback`
--


--
-- Table structure for table `feedback_points`
--

CREATE TABLE `feedback_points` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `template_id` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedback_points`
--


--
-- Table structure for table `feedback_template`
--

CREATE TABLE `feedback_template` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `clone_id` varchar(255) NOT NULL,
  `temp_name` varchar(255) NOT NULL,
  `department_id` varchar(255) NOT NULL,
  `role_id` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedback_template`
--


--
-- Table structure for table `feedback_templates`
--

CREATE TABLE `feedback_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `clone_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `department_id` varchar(255) NOT NULL,
  `role_id` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedback_templates`
--


--
-- Table structure for table `feedbackfilladmin`
--

CREATE TABLE `feedbackfilladmin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `feedpoint_id` int(11) NOT NULL,
  `self_feedback` varchar(255) NOT NULL,
  `rm_feedback` varchar(255) NOT NULL,
  `management_feedback` varchar(255) NOT NULL,
  `self_feedback_id` int(11) NOT NULL,
  `rm_feedback_id` int(11) NOT NULL,
  `management_feedback_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedbackfilladmin`
--


--
-- Table structure for table `forget_attendances`
--

CREATE TABLE `forget_attendances` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `attendance_log_id` bigint(20) unsigned NOT NULL,
  `entry_type` varchar(255) NOT NULL,
  `check_in` datetime DEFAULT NULL,
  `check_out` datetime DEFAULT NULL,
  `working_hours` time DEFAULT NULL,
  `time_difference` time DEFAULT NULL,
  `break_hours` time DEFAULT NULL,
  `break_timings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`break_timings`)),
  `reason` text NOT NULL,
  `comment` text DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `approved` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `forget_attendances_employee_id_foreign` (`employee_id`),
  KEY `forget_attendances_attendance_log_id_foreign` (`attendance_log_id`),
  CONSTRAINT `forget_attendances_attendance_log_id_foreign` FOREIGN KEY (`attendance_log_id`) REFERENCES `attendance_logs` (`id`),
  CONSTRAINT `forget_attendances_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `forget_attendances`
--


--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallery`
--


--
-- Table structure for table `gallerycat`
--

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

--
-- Dumping data for table `gallerycat`
--


--
-- Table structure for table `h_r_requests`
--

CREATE TABLE `h_r_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_employee_id` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `to_employee_id` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `h_r_requests`
--


--
-- Table structure for table `holidays`
--

CREATE TABLE `holidays` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `holidays`
--


--
-- Table structure for table `interviews`
--

CREATE TABLE `interviews` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `candidate_id` bigint(20) unsigned NOT NULL,
  `interviewDate` date NOT NULL,
  `interviewTime` time NOT NULL,
  `interviewStage` enum('Screening','Technical','Practical','Final') NOT NULL DEFAULT 'Screening',
  `finalStatus` enum('Pending','Offered','Shortlisted','Offer Accepted','Offer Rejected','Rejected','Not Qualified') NOT NULL DEFAULT 'Pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `interviews`
--


--
-- Table structure for table `kra_category`
--

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

--
-- Dumping data for table `kra_category`
--


--
-- Table structure for table `kra_templates`
--

CREATE TABLE `kra_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `clone_id` varchar(255) NOT NULL,
  `temp_name` varchar(255) NOT NULL,
  `department_id` varchar(255) NOT NULL,
  `role_id` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kra_templates`
--


--
-- Table structure for table `kraadmin`
--

CREATE TABLE `kraadmin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `self_disc` varchar(255) NOT NULL,
  `rm_disc` varchar(255) NOT NULL,
  `manage_disc` varchar(255) NOT NULL,
  `self_rate` varchar(255) NOT NULL,
  `rm_rate` varchar(255) NOT NULL,
  `manage_rate` varchar(255) NOT NULL,
  `self_id` int(11) NOT NULL,
  `rm_id` int(11) NOT NULL,
  `manage_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kraadmin`
--


--
-- Table structure for table `kraadminfill`
--

CREATE TABLE `kraadminfill` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `self_disc` varchar(255) NOT NULL,
  `rm_disc` varchar(255) NOT NULL,
  `manage_disc` varchar(255) NOT NULL,
  `self_rate` varchar(255) NOT NULL,
  `rm_rate` varchar(255) NOT NULL,
  `manage_rate` varchar(255) NOT NULL,
  `self_id` int(11) NOT NULL,
  `rm_id` int(11) NOT NULL,
  `manage_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kraadminfill`
--


--
-- Table structure for table `krafilladmin`
--

CREATE TABLE `krafilladmin` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `point_id` int(11) NOT NULL,
  `self_disc` varchar(255) NOT NULL,
  `rm_disc` varchar(255) NOT NULL,
  `management_disc` varchar(255) NOT NULL,
  `self_rate` varchar(255) NOT NULL,
  `rm_rate` varchar(255) NOT NULL,
  `management_rate` varchar(255) NOT NULL,
  `self_id` int(11) NOT NULL,
  `rm_id` int(11) NOT NULL,
  `management_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `krafilladmin`
--


--
-- Table structure for table `krapoints`
--

CREATE TABLE `krapoints` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pname` varchar(255) NOT NULL,
  `cat_id` varchar(255) NOT NULL,
  `p1` varchar(255) NOT NULL,
  `p2` varchar(255) NOT NULL,
  `p3` varchar(255) NOT NULL,
  `p4` varchar(255) NOT NULL,
  `p5` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `krapoints`
--


--
-- Table structure for table `leaves`
--

CREATE TABLE `leaves` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `type` varchar(255) NOT NULL,
  `day_type` varchar(255) NOT NULL,
  `paid_count` double(8,2) NOT NULL,
  `total` double(8,2) NOT NULL,
  `reason` text NOT NULL,
  `is_informed` tinyint(1) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `leaves_employee_id_foreign` (`employee_id`),
  CONSTRAINT `leaves_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `leaves`
--


--
-- Table structure for table `levels`
--

CREATE TABLE `levels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `levels`
--

INSERT INTO `levels` VALUES (2,'Senior',1,'2022-10-13 06:49:37','2022-11-04 18:41:33'),(4,'Junior',1,'2022-10-13 07:30:56','2022-11-04 18:38:23'),(6,'Team Leader',1,'2022-11-16 01:15:23','2022-11-18 23:52:28'),(10,'Trainee',1,'2022-11-28 21:20:57','2022-11-28 21:20:57'),(12,'Intern',1,'2022-11-28 21:21:30','2022-11-28 21:21:30');

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

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

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2022_08_07_074223_create_sites_table',1),(4,'2022_08_08_203730_create_permission_tables',1),(5,'2022_08_09_175729_create_departments_table',1),(6,'2022_08_09_200934_create_designations_table',1),(7,'2022_08_09_200951_create_levels_table',1),(8,'2022_10_02_165540_create_site_requests_table',1),(9,'2022_11_04_100748_add_status_column_to_sites_table',2),(32,'2022_11_28_012636_create_subscription_plans_table',3),(33,'2022_12_04_122631_create_email_templates_table',4),(34,'2023_01_03_220311_create_site_update_requests_table',5),(125,'2019_08_19_000000_create_failed_jobs_table',6),(126,'2019_12_14_000001_create_personal_access_tokens_table',6),(127,'2022_08_09_204114_create_employees_table',6),(128,'2022_08_12_005051_create_personal_infos_table',6),(129,'2022_08_15_113500_add_slug_to_employees_table',6),(130,'2022_08_15_143958_create_badges_table',6),(131,'2022_08_15_202939_create_holidays_table',6),(132,'2022_08_16_160530_create_timelines_table',6),(133,'2022_08_27_085254_create_h_r_requests_table',6),(134,'2022_10_22_211256_add_certificate_column_to_timelines_table',6),(135,'2022_10_25_091603_create_employee_documents_table',6),(136,'2022_10_30_140444_add_company_phone_column_to_employees_table',6),(137,'2022_11_05_192238_create_attendance_logs_table',6),(138,'2022_11_09_023502_create_forget_attendances_table',6),(139,'2022_11_10_151930_create_leaves_table',6),(140,'2022_11_11_002618_create_partial_leaves_table',6),(141,'2022_11_11_141616_create_clients_table',6),(142,'2022_11_11_165224_create_projects_table',6),(143,'2022_11_12_114400_create_todos_table',6),(144,'2022_11_12_153510_create_worklogs_table',6),(145,'2022_11_12_153525_create_worklog_tasks_table',6),(146,'2022_11_15_172648_create_site_infos_table',6),(147,'2022_11_15_195008_add_total_and_paid_column_to_leaves_table',6),(149,'2023_03_01_103756_create_kra_category',6),(151,'2023_03_06_155648_create_kraadminfill_table',6),(152,'2023_03_07_160046_create_kraadmin_table',6),(153,'2023_03_07_171848_rollback',6),(154,'2023_03_07_172324_drop_kraadminfill_table',6),(155,'2023_03_07_172650_create_krafilladmin_table',6),(156,'2023_03_09_220314_create_feedback_template_table',6),(157,'2023_03_11_153617_create_feedback_points_table',6),(158,'2023_03_12_165430_create_feedbackfilladmin_table',6),(159,'2023_03_13_123746_create_gallerycat_table',6),(160,'2023_03_13_123759_create_gallery_table',6),(161,'2023_04_18_134453_add_role_id_to_employees',6),(162,'2023_04_25_121915_add_role_id_to_employees',6),(163,'2023_04_25_124345_create_notification_table',6),(165,'2023_08_28_155924_create_feedback_templates_table',7),(166,'2023_08_28_164837_create_feedback_points_table',8),(167,'2023_08_31_125215_create_feedback_table',9),(168,'2023_09_08_151119_create_department_goals_table',10),(170,'2023_09_08_153812_create_department_goals_table',11),(171,'2023_09_12_113331_create_user_goals_table',12),(172,'2023_09_14_122253_add_submit_goal_to_user_goals_table',13),(173,'2023_09_14_135118_add_submit_goals_to_department_goals_table',14),(174,'2024_05_10_145353_create_openings_table',15),(176,'2024_05_20_130617_create_candidates_table',16),(177,'2024_05_28_122113_create_interviews_table',17),(178,'2024_05_30_120037_create_candidate_tasks_table',18),(179,'2024_06_12_122438_create_notes_table',19),(180,'2024_09_09_171510_create_activities_table',20);

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

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) 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`
--

INSERT INTO `model_has_permissions` VALUES (31,'App\\Models\\User',1),(32,'App\\Models\\User',41),(33,'App\\Models\\User',40);

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

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) 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),(1,'App\\Models\\User',40),(1,'App\\Models\\User',41),(2,'App\\Models\\User',2),(2,'App\\Models\\User',7),(2,'App\\Models\\User',8),(2,'App\\Models\\User',9),(2,'App\\Models\\User',10),(2,'App\\Models\\User',14),(2,'App\\Models\\User',17),(2,'App\\Models\\User',18),(2,'App\\Models\\User',19),(2,'App\\Models\\User',20),(2,'App\\Models\\User',29),(2,'App\\Models\\User',30),(2,'App\\Models\\User',31),(2,'App\\Models\\User',32),(2,'App\\Models\\User',36),(2,'App\\Models\\User',37),(2,'App\\Models\\User',42),(2,'App\\Models\\User',44),(2,'App\\Models\\User',45),(2,'App\\Models\\User',46),(2,'App\\Models\\User',47),(2,'App\\Models\\User',51),(2,'App\\Models\\User',53),(2,'App\\Models\\User',54),(2,'App\\Models\\User',55),(2,'App\\Models\\User',56),(2,'App\\Models\\User',57),(2,'App\\Models\\User',60),(2,'App\\Models\\User',64),(2,'App\\Models\\User',73),(2,'App\\Models\\User',74),(2,'App\\Models\\User',75),(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),(2,'App\\Models\\User',90),(2,'App\\Models\\User',96),(2,'App\\Models\\User',118),(2,'App\\Models\\User',121),(2,'App\\Models\\User',140),(2,'App\\Models\\User',153),(3,'App\\Models\\User',3),(3,'App\\Models\\User',4),(3,'App\\Models\\User',12),(3,'App\\Models\\User',13),(3,'App\\Models\\User',16),(3,'App\\Models\\User',43),(3,'App\\Models\\User',49),(3,'App\\Models\\User',58),(3,'App\\Models\\User',61),(3,'App\\Models\\User',63),(3,'App\\Models\\User',66),(3,'App\\Models\\User',67),(3,'App\\Models\\User',68),(3,'App\\Models\\User',69),(3,'App\\Models\\User',72),(3,'App\\Models\\User',76),(3,'App\\Models\\User',91),(3,'App\\Models\\User',92),(3,'App\\Models\\User',93),(3,'App\\Models\\User',94),(3,'App\\Models\\User',95),(3,'App\\Models\\User',122),(3,'App\\Models\\User',135),(3,'App\\Models\\User',138),(3,'App\\Models\\User',142),(3,'App\\Models\\User',143),(3,'App\\Models\\User',144),(3,'App\\Models\\User',145),(3,'App\\Models\\User',151),(3,'App\\Models\\User',152),(3,'App\\Models\\User',154),(3,'App\\Models\\User',155),(4,'App\\Models\\User',5),(4,'App\\Models\\User',6),(4,'App\\Models\\User',11),(4,'App\\Models\\User',15),(4,'App\\Models\\User',21),(4,'App\\Models\\User',22),(4,'App\\Models\\User',23),(4,'App\\Models\\User',24),(4,'App\\Models\\User',25),(4,'App\\Models\\User',26),(4,'App\\Models\\User',27),(4,'App\\Models\\User',33),(4,'App\\Models\\User',34),(4,'App\\Models\\User',35),(4,'App\\Models\\User',38),(4,'App\\Models\\User',39),(4,'App\\Models\\User',50),(4,'App\\Models\\User',52),(4,'App\\Models\\User',59),(4,'App\\Models\\User',70),(4,'App\\Models\\User',71),(4,'App\\Models\\User',125),(4,'App\\Models\\User',127),(4,'App\\Models\\User',131),(4,'App\\Models\\User',133),(4,'App\\Models\\User',139),(4,'App\\Models\\User',141),(4,'App\\Models\\User',147),(14,'App\\Models\\User',128),(14,'App\\Models\\User',129),(14,'App\\Models\\User',130),(14,'App\\Models\\User',146),(14,'App\\Models\\User',148),(14,'App\\Models\\User',149),(15,'App\\Models\\User',62),(15,'App\\Models\\User',136);

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `candidate_id` bigint(20) unsigned NOT NULL,
  `note_description` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notes_candidate_id_foreign` (`candidate_id`),
  CONSTRAINT `notes_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notes`
--


--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_id` int(11) NOT NULL,
  `to_id` int(11) NOT NULL,
  `message` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification`
--


--
-- Table structure for table `partial_leaves`
--

CREATE TABLE `partial_leaves` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `date` date NOT NULL,
  `from` datetime NOT NULL,
  `to` datetime NOT NULL,
  `reason` text NOT NULL,
  `is_informed` tinyint(1) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `partial_leaves_employee_id_foreign` (`employee_id`),
  CONSTRAINT `partial_leaves_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partial_leaves`
--


--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` VALUES ('hrm@gmail.com','$2y$10$khfXVuM.3CSKthexrrQ1ce/s4lcPYMWKyXKQhK0irbMcGOqexKuMy','2022-11-11 00:45:08'),('johndoe@domain.com','$2y$10$kLlNrZF2QVa5pY4wS5IQgO4cAgVYSANQwocO5/Z9.At1YCeN.kbr.','2022-11-11 02:59:03'),('sabir.pixlogix@gmail.com','$2y$10$D5CrrztDTXAd4eejt6G9yuGRFDlEUICQIHfybKoqmQT5jY/JPFXXa','2022-12-09 00:40:51'),('liyisem105@letpays.com','$2y$10$j27Eh/PeFoxMw4FzqvNyxuE3iVbKA0PUUIKvLolXU/k9B4QeIObnm','2022-12-30 09:22:16'),('ricin74665@v3dev.com','$2y$10$41xp9iM/hWjmnMsxrVoeGO2T583.5vXNPZDKpDN8Hfr6o0BJ45dRK','2023-01-13 09:16:54'),('digneshparmar436@gmail.com','$2y$10$jFh7h/ZA2EMcx9Nsp0TFXe6bPp1z8jSkIdnc8PmUpFmybsLGxW3TC','2023-02-25 03:45:05'),('sagar@pixlogix.com','$2y$10$1tET1C9AWpgdQkgfD0crTOQdbMbEdPNFgQTOTSWvQEjEC6CjfzJNK','2023-06-22 05:45:05'),('kartik@pixlogix.com','$2y$10$C7UtKZmYeVIKS/BcLD7ybOF01wbCRLH14HZtT5J/Lue7TlOTRqV.K','2023-08-01 04:08:18'),('bidizymu@mailinator.com','$2y$10$lOpdMtKBLLL89P5Z7czWhOmUvQR4hUJSf.Mq.sOLwz1V8H7ZW36ya','2023-09-18 22:16:59'),('testsitecreate818@gmail.com','$2y$10$vq/aBftZ2j2bPfnMzY8b3etLNx4Ur0YRGzMzyUUGvSDeZrIhKstxy','2023-09-19 22:58:56'),('harshad.pixlogi@gmail.com','$2y$10$h8q6wrlxRjlxvghM3q5Bx.OmNEm8ac.LwyK97qvMBZ8xOwrSPrctC','2023-09-27 23:47:24'),('harshad.pixl@gmail.com','$2y$10$QSZSKtUD4IpFFBbUzBocVO0MZJD0yOBrL/8wpK2EM9s8FpdKSJMne','2023-09-27 23:53:23'),('harshad.pib fvx@lgmail.com','$2y$10$NOcoNw6T0MAGuWDGPfqLDegEx8mac.bg5ikYrc6XiqQWuFqFBorJS','2023-09-27 23:54:48'),('harshad.pib fvx@vdslgmail.com','$2y$10$G.yVK2hl60M3wtVBCpK8duDyrrAScJuuTNt6v1qA9v8fcfXANEdPO','2023-09-27 23:55:16'),('harshrdfgvad.pib fvx@vdslgmail.com','$2y$10$AdBDuZm08H3KLwrWRTkc6.knqE006ahyxn0XatVq/QD52AZTuInIO','2023-09-27 23:55:49'),('harshad.pixlogix@gmail.com','$2y$10$VbUTULEAZIaVJBEjEv16ouc04hz1gutplwkuX8q5mGi52fdHG9KJu','2023-09-28 00:02:04'),('tofeda@mailinator.com','$2y$10$nLCjMFCgbUKLhG2EcjYMTeT47a2UCwrVrzw97jVfEtUYPcvuuKt0W','2023-09-28 00:21:32'),('hexomi@mailinator.com','$2y$10$8DYE3dQXqyN9XZ1B.kbwsOLVtvpwzZF/G8NwiLsFXQwIRbvJyBq32','2023-09-28 00:22:49'),('rylyqaqu@mailinator.com','$2y$10$n22WYb59FB813rlDKzM5feX93izt45lWjmFoE39JMTloHtz/vz4FK','2023-09-28 01:47:17'),('lejek@mailinator.com','$2y$10$ob99nYdZeyG2J1X6TKUeCOP1MGl6FM9RSQ6R1Efjj5BwUYXE0paCu','2023-09-28 01:51:55'),('sigerad460@bitofee.com','$2y$10$Ar3e02.xH4T3uwuvLBxx2ekgtMq7PUeeuta8RKVYZaM1wluxvv.wG','2024-01-30 21:41:58'),('sigerad461@bitofee.com','$2y$10$K5mwW3Lnw.4lrLeMPnNxGOdzW9wQ/RMAlV8yvQI5Z/AGQ6X8tRnV.','2024-01-30 21:50:39'),('sigerad462@bitofee.com','$2y$10$7vsWhQHyjZQetoiiZjaC/.1qTldyZT26aBgVCx990rTBdDguxDvi.','2024-01-30 21:56:36'),('sigerad440@bitofee.com','$2y$10$UreghHdGrpCRwBp0bp.I/uTHJlsqC2LrN6FrV2NxngE5NYMWwY9/O','2024-01-30 22:02:44'),('sigerad400@bitofee.com','$2y$10$tJ45.UL5FAnOrXiM3f/XKOlSiQp7Tew6BruAfh3XnCF4ULoi/XWH.','2024-01-30 22:03:40');

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

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `deletable` tinyint(1) NOT NULL DEFAULT 1,
  `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=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` VALUES (1,'Create Role','web','Role',1,'2022-10-04 04:52:58','2022-10-04 04:52:58'),(2,'View Role','web','Role',1,'2022-10-04 04:53:04','2022-10-04 04:53:04'),(3,'Edit Role','web','Role',1,'2022-10-04 04:53:15','2022-10-04 04:53:15'),(4,'Delete Role','web','Role',1,'2022-10-04 04:53:23','2022-10-04 04:53:23'),(5,'Create Department','web','Department',1,'2022-10-04 04:53:33','2022-10-04 04:53:33'),(6,'View Department','web','Department',1,'2022-10-04 04:53:46','2022-10-04 04:53:46'),(7,'Edit Department','web','Department',1,'2022-10-04 04:53:53','2022-10-04 04:53:53'),(8,'Delete Department','web','Department',1,'2022-10-04 04:54:01','2022-10-04 04:54:10'),(9,'Create Designation','web','Designation',1,'2022-10-04 04:54:22','2022-10-04 04:54:22'),(10,'View Designation','web','Designation',1,'2022-10-04 04:54:33','2022-10-04 04:54:33'),(11,'Edit Designation','web','Designation',1,'2022-10-04 04:54:40','2022-10-04 04:54:40'),(12,'Delete Designation','web','Designation',1,'2022-10-04 04:54:49','2022-10-04 04:54:49'),(13,'Create Level','web','Level',1,'2022-10-04 04:54:56','2022-10-04 04:54:56'),(14,'View Level','web','Level',1,'2022-10-04 04:55:07','2022-10-04 04:55:07'),(15,'Edit Level','web','Level',1,'2022-10-04 04:55:16','2022-10-04 04:55:16'),(16,'Delete Level','web','Level',1,'2022-10-04 04:55:22','2022-10-04 04:55:22'),(17,'Create Employee','web','Employee',1,'2022-10-04 04:55:29','2022-10-04 04:55:29'),(18,'View Employee','web','Employee',1,'2022-10-04 04:55:36','2022-10-04 04:55:36'),(19,'Create Achievement','web','Achievement',1,'2022-10-04 06:47:23','2022-10-04 06:47:23'),(20,'View Achievement','web','Achievement',1,'2022-10-04 06:47:32','2022-10-04 06:47:32'),(22,'Create Badge','web','Badge',1,'2022-10-04 06:58:54','2022-10-04 06:58:54'),(23,'View Badge','web','Badge',1,'2022-10-04 06:59:01','2022-10-04 06:59:01'),(24,'Edit Badge','web','Badge',1,'2022-10-04 06:59:12','2022-10-04 06:59:12'),(25,'Delete Badge','web','Badge',1,'2022-10-04 06:59:22','2022-10-04 06:59:22'),(26,'Create Holiday','web','Holiday',1,'2022-10-04 09:42:29','2022-10-04 09:42:29'),(27,'View Holiday','web','Holiday',1,'2022-10-04 09:42:36','2022-10-04 09:42:36'),(28,'Edit Holiday','web','Holiday',1,'2022-10-04 09:42:43','2022-10-04 09:42:43'),(29,'Delete Holiday','web','Holiday',1,'2022-10-04 09:42:52','2022-10-04 09:42:52'),(30,'Edit Employee','web','Employee',1,'2022-10-24 05:30:19','2022-10-24 05:30:19'),(31,'All','web','Manage',1,'2022-12-02 03:25:51','2022-12-03 03:25:58'),(32,'Manage Users','web','Manage',1,'2022-11-05 23:24:14','2022-11-05 23:24:14'),(33,'Manage Sites','web','Manage',1,'2022-11-05 23:25:28','2022-11-05 23:25:28'),(39,'View Attendance','web','Attendance',1,'2022-11-10 01:59:19','2022-11-10 01:59:19'),(41,'View Forget Attendance','web','Forget Attendance',1,'2022-11-15 02:37:14','2022-11-15 02:37:14'),(42,'Edit Worklog','web','Worklog',1,'2022-11-15 02:37:31','2022-11-15 02:37:31'),(43,'View Worklog','web','Worklog',1,'2022-11-15 02:37:31','2022-11-15 02:37:31'),(44,'Edit Worklog Request','web','Worklog Request',1,'2022-11-15 02:38:03','2022-11-15 02:38:03'),(45,'View Worklog Request','web','Worklog Request',1,'2022-11-15 02:38:03','2022-11-15 02:38:03'),(47,'View Leave','web','Leave',1,'2022-11-15 02:39:43','2022-11-15 02:39:43'),(48,'View Report','web','Report',1,'2022-11-15 02:40:02','2022-11-15 02:40:02'),(49,'Create Client','web','Client',1,'2022-11-15 02:40:32','2022-11-15 02:40:32'),(50,'Edit Client','web','Client',1,'2022-11-15 02:40:32','2022-11-15 02:40:32'),(51,'View Client','web','Client',1,'2022-11-15 02:40:32','2022-11-15 02:40:32'),(52,'Delete Client','web','Client',1,'2022-11-15 02:40:32','2022-11-15 02:40:32'),(53,'Create Project','web','Project',1,'2022-11-15 02:40:46','2022-11-15 02:40:46'),(54,'Edit Project','web','Project',1,'2022-11-15 02:40:46','2022-11-15 02:40:46'),(55,'View Project','web','Project',1,'2022-11-15 02:40:47','2022-11-15 02:40:47'),(56,'Delete Project','web','Project',1,'2022-11-15 02:40:47','2022-11-15 02:40:47'),(58,'View Site Options','web','Site Options',1,'2022-11-16 03:39:49','2022-11-16 03:39:49'),(59,'View Recent Project','web','Recent Project',1,'2022-11-21 03:20:19','2022-11-21 03:20:19'),(60,'Edit Site Options','web','Site Options',1,'2022-11-21 03:26:47','2022-11-21 03:26:47'),(61,'Edit Achievement','web','Achievement',1,'2022-11-25 21:12:57','2022-11-25 21:12:57'),(67,'Create Email Template','web','Email Template',1,'2022-12-05 22:53:13','2022-12-05 22:53:13'),(68,'Edit Email Template','web','Email Template',1,'2022-12-05 22:57:06','2022-12-05 22:57:06'),(69,'View Email Template','web','Email Template',1,'2022-12-05 22:57:06','2022-12-05 22:57:06'),(70,'Create KRA','web','KRA',1,'2023-09-19 20:17:52','2023-09-19 20:17:52'),(71,'Edit KRA','web','KRA',1,'2023-09-19 20:17:52','2023-09-19 20:17:52'),(72,'Delete KRA','web','KRA',1,'2023-09-19 20:17:52','2023-09-19 20:17:52'),(76,'Create Goals','web','Goals',1,'2023-09-19 20:18:30','2023-09-19 20:18:30'),(77,'Edit Goals','web','Goals',1,'2023-09-19 20:18:30','2023-09-19 20:18:30'),(78,'Delete Goals','web','Goals',1,'2023-09-19 20:18:30','2023-09-19 20:18:30'),(79,'Create Feedbacks','web','Feedbacks',1,'2023-09-19 20:18:39','2023-09-19 20:18:39'),(80,'Edit Feedbacks','web','Feedbacks',1,'2023-09-19 20:18:39','2023-09-19 20:18:39'),(81,'Delete Feedbacks','web','Feedbacks',1,'2023-09-19 20:18:39','2023-09-19 20:18:39'),(82,'Create News','web','News',1,'2023-09-19 20:29:44','2023-09-19 20:29:44'),(83,'Edit News','web','News',1,'2023-09-19 20:29:44','2023-09-19 20:29:44'),(84,'Delete News','web','News',1,'2023-09-19 20:29:44','2023-09-19 20:29:44'),(85,'Create Gallery','web','Gallery',1,'2023-09-19 20:30:02','2023-09-19 20:30:02'),(86,'Edit Gallery','web','Gallery',1,'2023-09-19 20:30:02','2023-09-19 20:30:02'),(87,'Delete Gallery','web','Gallery',1,'2023-09-19 20:30:03','2023-09-19 20:30:03'),(88,'View Feedbacks','web','Feedbacks',1,'2023-10-05 22:56:52','2023-10-05 22:56:52'),(89,'View Goals','web','Goals',1,'2023-10-05 22:57:22','2023-10-05 22:57:22'),(90,'View KRA','web','KRA',1,'2023-10-05 22:57:30','2023-10-05 22:57:30'),(91,'View Gallery','web','Gallery',1,'2023-10-05 22:58:42','2023-10-05 22:58:42'),(92,'View News','web','News',1,'2023-10-05 22:58:57','2023-10-05 22:58:57');

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `personal_infos`
--

CREATE TABLE `personal_infos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `personal_email` varchar(255) DEFAULT NULL,
  `marital_status` varchar(255) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `contact_no` varchar(255) DEFAULT NULL,
  `about_me` text DEFAULT NULL,
  `linked_in` varchar(255) DEFAULT NULL,
  `current_address` text DEFAULT NULL,
  `permanent_address` text DEFAULT NULL,
  `blood_group` varchar(255) DEFAULT NULL,
  `hobbies` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`hobbies`)),
  `emergency_contact` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`emergency_contact`)),
  `bank_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`bank_details`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `personal_infos_employee_id_foreign` (`employee_id`),
  CONSTRAINT `personal_infos_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_infos`
--


--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `project_id` varchar(255) NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `employee_id` bigint(20) unsigned NOT NULL,
  `delivery_date` date NOT NULL,
  `bench_hours` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`bench_hours`)),
  `total_bench_hours` int(11) NOT NULL DEFAULT 0,
  `given_hours` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`given_hours`)),
  `total_given_hours` int(11) NOT NULL DEFAULT 0,
  `project_health` int(11) NOT NULL DEFAULT 100,
  `sow` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`sow`)),
  `status` varchar(255) NOT NULL DEFAULT 'Pending',
  `updated_by` varchar(255) NOT NULL,
  `created_by` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `projects_client_id_foreign` (`client_id`),
  KEY `projects_employee_id_foreign` (`employee_id`),
  CONSTRAINT `projects_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `projects_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--


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

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) 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,2),(1,3),(1,4),(1,14),(2,2),(2,3),(2,4),(2,14),(3,2),(3,3),(3,4),(3,14),(4,2),(4,3),(4,4),(4,14),(5,2),(5,3),(5,4),(5,14),(6,2),(6,3),(6,4),(6,14),(7,2),(7,3),(7,4),(7,14),(8,2),(8,3),(8,4),(8,14),(9,2),(9,3),(9,4),(9,14),(10,2),(10,3),(10,4),(10,14),(11,2),(11,3),(11,4),(11,14),(12,2),(12,3),(12,4),(12,14),(13,2),(13,3),(13,4),(13,14),(14,2),(14,3),(14,4),(14,14),(15,2),(15,3),(15,4),(15,14),(16,2),(16,3),(16,4),(16,14),(17,2),(17,3),(17,4),(17,14),(18,2),(18,3),(18,4),(18,14),(19,2),(19,3),(19,4),(19,14),(20,2),(20,3),(20,4),(20,14),(22,2),(22,3),(22,4),(22,14),(23,2),(23,3),(23,4),(23,14),(24,2),(24,3),(24,4),(24,14),(25,2),(25,3),(25,4),(25,14),(26,2),(26,3),(26,4),(26,14),(27,2),(27,3),(27,4),(27,14),(28,2),(28,3),(28,4),(28,14),(29,2),(29,3),(29,4),(29,14),(30,2),(30,3),(30,4),(30,14),(39,2),(39,3),(39,4),(39,14),(41,2),(41,3),(41,4),(41,14),(42,2),(42,3),(42,4),(42,14),(43,2),(43,3),(43,4),(43,14),(44,2),(44,3),(44,4),(44,14),(45,2),(45,3),(45,4),(45,14),(47,2),(47,3),(47,4),(47,14),(48,2),(48,3),(48,4),(48,14),(49,2),(49,3),(49,4),(49,14),(50,2),(50,3),(50,4),(50,14),(51,2),(51,3),(51,4),(51,14),(52,2),(52,3),(52,4),(52,14),(53,2),(53,3),(53,4),(53,14),(54,2),(54,3),(54,4),(54,14),(55,2),(55,3),(55,4),(55,14),(56,2),(56,3),(56,4),(56,14),(58,2),(58,3),(58,4),(58,14),(59,2),(59,3),(59,4),(59,14),(60,2),(60,3),(60,4),(60,14),(61,2),(61,3),(61,4),(61,14),(67,2),(67,3),(67,4),(67,14),(68,2),(68,3),(68,4),(68,14),(69,2),(69,3),(69,4),(69,14),(70,2),(70,4),(70,14),(70,15),(71,2),(71,4),(71,14),(71,15),(72,2),(72,4),(72,14),(72,15),(76,2),(76,3),(76,4),(76,14),(76,15),(77,2),(77,4),(77,14),(77,15),(78,2),(78,4),(78,14),(78,15),(79,2),(79,4),(79,14),(79,15),(80,2),(80,4),(80,14),(80,15),(81,2),(81,4),(81,14),(81,15),(82,2),(82,4),(82,14),(82,15),(83,2),(83,4),(83,14),(83,15),(84,2),(84,4),(84,14),(84,15),(85,2),(85,4),(85,14),(85,15),(86,2),(86,4),(86,14),(86,15),(87,2),(87,4),(87,14),(87,15),(88,3),(88,4),(88,15),(89,3),(89,4),(89,15),(90,3),(90,4),(90,15),(91,3),(91,4),(91,15),(92,3),(92,4),(92,15);

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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `deletable` tinyint(1) NOT NULL DEFAULT 1,
  `role_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `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=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'Super Admin','web',0,1,'2022-10-04 04:39:15','2022-10-04 04:39:15'),(2,'Admin','web',0,2,'2022-10-04 04:39:15','2022-10-04 04:39:15'),(3,'Employee','web',0,3,'2022-10-04 04:39:15','2022-10-04 04:39:15'),(4,'HR','web',0,4,'2022-10-04 08:20:20','2022-10-04 08:20:20'),(14,'Project Manager','web',0,14,'2022-11-16 00:11:09','2022-11-16 00:11:09'),(15,'Team Leader','web',0,15,'2022-11-17 00:50:42','2022-11-17 00:50:42'),(16,'Test Role','web',0,16,'2022-11-19 00:00:00','2022-11-19 00:00:00');

--
-- Table structure for table `site_infos`
--

CREATE TABLE `site_infos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`value`)),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_infos`
--


--
-- Table structure for table `site_requests`
--

CREATE TABLE `site_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `site_name` varchar(255) NOT NULL,
  `first_name` text NOT NULL,
  `middle_name` text DEFAULT NULL,
  `last_name` text NOT NULL,
  `phone` text NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_requests`
--

INSERT INTO `site_requests` VALUES (10,'John Doe Site','John',NULL,'Doe','+1 234567890','johndoe@domain.com','',2,'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec.','2022-12-02 03:39:59','2022-12-02 03:39:59'),(11,'My site','Max',NULL,'Well','9876543210','maxwell@mymail.com','',2,'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec.','2022-12-22 02:55:10','2022-12-22 02:55:10');

--
-- Table structure for table `site_update_requests`
--

CREATE TABLE `site_update_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `site_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_update_requests`
--

INSERT INTO `site_update_requests` VALUES (1,1,'sed','asd',2,NULL,'2023-01-11 08:17:32','2023-01-11 08:17:32'),(2,1,'xcf','sffd',2,NULL,'2023-01-11 08:42:46','2023-01-11 08:42:46'),(3,25,'My Request','MEssage',42,1,'2023-01-11 09:05:14','2023-01-11 09:54:15'),(4,25,'My Requestsd','fasfasdf',42,0,'2023-01-11 10:00:54','2023-01-11 10:01:13'),(5,25,'My Request','gfcbhnkm.',42,1,'2023-01-11 10:20:47','2023-01-11 10:26:27'),(6,25,'My Request','y56y8uotcgfiugihlcvhjb yv iug uiuyf hgvhggvh yhgv iugv h jh hgvhjb j j vhbv bm bnbvbnvbvbjnbhjbnm k kh bkj  hv  bkjgvijv hiu gvo iuviviouviouygcgitfgo gh gihcvo hgh ghjgggiufh',42,NULL,'2023-01-11 10:21:06','2023-01-11 10:21:06'),(7,25,'My Request','jgkhjnk',42,NULL,'2023-01-13 11:05:54','2023-01-13 11:05:54'),(8,25,'My Request','jgkhjnk',42,NULL,'2023-01-13 11:06:23','2023-01-13 11:06:23'),(9,39,'Testing','This is for testing purpose.\r\n6/2/2023\r\n\r\n-HR',96,NULL,'2023-02-07 02:13:45','2023-02-07 02:13:45'),(10,39,'Upgrade Plan','I want to upgrade plan, so I can add more number of employees. What will be the steps?',96,NULL,'2023-02-08 20:59:37','2023-02-08 20:59:37');

--
-- Table structure for table `sites`
--

CREATE TABLE `sites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `slug` text NOT NULL,
  `db_name` varchar(255) NOT NULL,
  `db_password` varchar(255) DEFAULT NULL,
  `db_user` varchar(255) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `message` longtext DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sites_db_name_unique` (`db_name`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sites`
--

INSERT INTO `sites` VALUES (49,'Sagartest',121,'sagartest','pixlogix_72680sagartest','1lm6evgL','pixlogix_72680sagartest',2,NULL,0,'2023-02-25 03:25:22','2023-06-07 02:06:33'),(50,'Recruitment Tool',132,'recruitment-tool','pixlogix_47380meettest','4npa8gUg','pixlogix_47380meettest',2,NULL,1,'2023-04-20 03:08:34','2023-04-20 03:08:35');

--
-- Table structure for table `subscription_plans`
--

CREATE TABLE `subscription_plans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `plan_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`plan_details`)),
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_plans`
--

INSERT INTO `subscription_plans` VALUES (1,'Silver','{\"max_employees\":\"2\"}',1,'2022-11-29 02:31:11','2022-11-29 02:31:11'),(2,'Gold','{\"max_employees\":\"30\"}',1,'2022-11-29 02:31:18','2023-02-09 20:50:14'),(3,'Bronze','{\"max_employees\":\"1\"}',1,'2022-12-02 05:58:46','2022-12-02 05:58:46');

--
-- Table structure for table `timelines`
--

CREATE TABLE `timelines` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date DEFAULT NULL,
  `badge_id` bigint(20) unsigned DEFAULT NULL,
  `certificate` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `timelines_employee_id_foreign` (`employee_id`),
  KEY `timelines_badge_id_foreign` (`badge_id`),
  CONSTRAINT `timelines_badge_id_foreign` FOREIGN KEY (`badge_id`) REFERENCES `badges` (`id`),
  CONSTRAINT `timelines_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `timelines`
--


--
-- Table structure for table `todos`
--

CREATE TABLE `todos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `project_id` bigint(20) unsigned NOT NULL,
  `description` text NOT NULL,
  `start_from` date NOT NULL,
  `status` varchar(255) NOT NULL,
  `planned_hours` time NOT NULL,
  `delivery_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `todos_employee_id_foreign` (`employee_id`),
  KEY `todos_project_id_foreign` (`project_id`),
  CONSTRAINT `todos_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  CONSTRAINT `todos_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `todos`
--


--
-- Table structure for table `user_goals`
--

CREATE TABLE `user_goals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `employee_id` bigint(20) unsigned DEFAULT NULL,
  `department_id` bigint(20) unsigned DEFAULT NULL,
  `duration` varchar(255) NOT NULL,
  `weightage` bigint(20) unsigned DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `completion` bigint(20) unsigned NOT NULL,
  `remarks` text NOT NULL,
  `user_submit_goal` varchar(255) DEFAULT NULL,
  `tl_submit_goal` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_goals_employee_id_foreign` (`employee_id`),
  KEY `user_goals_department_id_foreign` (`department_id`),
  CONSTRAINT `user_goals_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE SET NULL,
  CONSTRAINT `user_goals_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_goals`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` text NOT NULL,
  `middle_name` text DEFAULT NULL,
  `last_name` text NOT NULL,
  `phone` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `site_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `remember_token` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `deletable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=457 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'',NULL,'','','admin','admin@gmail.com',NULL,'$2y$10$c7YC3Cqi4B6iI26JdBcyd.H.hHNkNMECyTvl3Lm7/v4u8CeCHSAoO',0,'Bku3xPYm5Ksi2IUXl2cmmXTFpqiQqA7ZirzQtLO5BYiaZKq0lASyBWEJTXJ8',1,0,'2022-10-04 14:39:15','2022-10-23 17:09:32'),(2,'HRM',NULL,'Admin','7894561230','HRM Admin','hrm@gmail.com',NULL,'$2y$10$ALzY70RlnENPs4.Qc2RjZOc9BABdGEm229P7POCk/BgUK7q5a9JK6',1,'meDxSWPkopueNULT4Nnvkey87gdGUyg7RUyWHTXcZC1O3pu6vTKSEtQZUlw5',1,0,'2022-10-04 14:50:47','2023-03-08 19:36:54'),(3,'Employee','','last','','Employee  last','employee@gmail.com',NULL,'$2y$10$YsdDPOZ1Ty62Uo9RAMTsTueFOcNDethwu2Sw.ocn/ZqI0QEvoO6aG',1,'t21CTBgBnOa4ONqCSyIHjc8tw5NPsFAq83ncXkTOsPTVx2pyAJGH95m8qofu',1,1,'2022-10-04 16:30:37','2023-01-31 17:58:28'),(5,'Serina','KeithSpears','Estes','1','Serina KeithSpears Estes','mywymewen@mailinator.com',NULL,'$2y$10$YsdDPOZ1Ty62Uo9RAMTsTueFOcNDethwu2Sw.ocn/ZqI0QEvoO6aG',0,'iuG7jb76oFORifrauVUDqRc6hkXsFC8eDY4iw7eR5TWdevUFkEQXUfIKus5p',0,1,'2022-10-04 18:21:28','2023-05-24 09:30:17'),(6,'darshil','N','Bhatt','','darshil N Bhatt','ba1@pixlogix.com',NULL,'$2y$10$/Y0dx/jyshhw4irJQEh9JOy3QN4qk3wuNOLdfXZriSJm3KYHtbPJO',1,NULL,1,1,'2022-10-12 08:37:56','2023-02-24 19:56:57'),(28,'',NULL,'','','Abdul  Zaffars','abdulzaffar@gmail.com',NULL,'$2y$10$XTOwdo/mZ0p34lGQGt5lE.D87khztDs6kL/hN67RGW4Pztk6QaiEG',1,NULL,1,1,'2022-10-31 10:18:55','2023-01-31 17:58:28'),(40,'',NULL,'','','siteadmin','siteadmin@gmail.com',NULL,'$2y$10$RdsCVy9ATkSxHUWfKEs/CeYVsT8ACvL47ouLNPyTawm4JNpjC/.4i',0,NULL,1,1,'2022-11-05 08:14:19','2022-11-05 08:14:19'),(41,'',NULL,'','','Users Admin','usersadmin@gmail.com',NULL,'$2y$10$3Fowp0TeHiM5BXkTsS/76uZruRcxFaKpvB1vcMvzHKtU8ohd.jM7e',0,'WyrCTn3WIKKejSMcgedHTr8u3lO34bgSrek7xBAIglAgZIf5MSBuKQS9XA47',1,1,'2022-11-05 08:59:41','2022-11-05 08:59:41'),(42,'Abdul',NULL,'ZAffar','789456103','Abdul ZAffar','zaffars@pixlogix.com',NULL,'$2y$10$fvc9MfTNzRRGdjg5SzrV1.XeVd6TT7MxQGjXRiVL6rKLmX2jw.ZqS',39,'UEHok2q7Oh0CDaugoGhXNxS2ru4qG07TgUI0AhWAVokAFQnFid8AY8ZHIm3I',1,1,'2022-11-06 06:55:22','2023-03-08 18:50:51'),(63,'',NULL,'','','Aoibhe middle Murtagh','froztech@gmail.com',NULL,'$2y$10$4D1vJ7GIkMna0at3CLvD0.clXwDLN9e/6hVOUnC9BlEHxIX908viO',0,NULL,1,1,'2022-11-18 06:57:48','2022-11-18 06:57:48'),(65,'',NULL,'','','P  M','pm@pm.com',NULL,'$2y$10$zht45BbEviaOZBcA.0R.QO2ZQ.WHfZo.DhoxvkKWD0NhA77h4PO4u',1,NULL,1,1,'2022-11-19 15:03:20','2023-01-31 17:58:28'),(74,'Van der Mark','der','Mark','9876543210','Van der Mark der Mark','mark@domain.com',NULL,'$2y$10$EfIWAbmdkoLddghCRJVi2urXcbdfUlMds79S8SJdTw0oj/M1515Py',28,NULL,1,0,'2022-12-02 10:12:03','2022-12-02 10:12:03'),(76,'',NULL,'','','Sabir  Malek','sabir10.pixlogix@gmail.com',NULL,'$2y$10$wPutW0rW1y/L8WwvuYNs5ObmZ7k7ttkFYLTtcYLErGjE0/uPZjwKi',1,'dVtBuq1bWLQeXOeUTCiqCwVECZaTL0BEbDEHCGR32DoaWsBM1B9O3pQdYMQ4',1,1,'2022-12-07 13:27:26','2023-01-31 17:58:28'),(79,'hbjm',NULL,'jbm','678778','hbjm jbm','nbm@mn.vom',NULL,'$2y$10$xRMWG16XEzPDCoaRnXL5X.Ww93g/DnLoKkIkw2Ua0SC0vuUOmTClG',32,NULL,1,0,'2022-12-25 18:06:27','2022-12-25 18:06:27'),(80,'hbjmjh',NULL,'jbm','678778','hbjmjh jbm','nbhgjhbm@mn.vom',NULL,'$2y$10$qSETN9.AHdZalRWGUEPSj.U/gxLHiXVH9WrlgTgccD7rMLUI./8bC',39,NULL,1,0,'2022-12-25 18:08:41','2023-05-25 14:33:06'),(81,'hbjmjh',NULL,'jbm','678778','hbjmjh jbm','nbhgjhsdbm@mn.vom',NULL,'$2y$10$TiQUVTUKd2Q4iVmX3idTYuIygQbN.DV/sMVKhVNaUA0MP0cd4NEOq',34,NULL,1,0,'2022-12-25 18:10:26','2022-12-25 18:10:26'),(82,'Milan',NULL,'Patel','98765','Milan Patel','milan@restside.com',NULL,'$2y$10$zruAGHGGCDqm13WsgIubH.6S25dNCR2LVS8Pj8h9dO/dE1YRE5Z0y',35,NULL,0,0,'2022-12-28 08:55:27','2022-12-28 08:56:16'),(90,'li',NULL,'ugj','345465767','li ugj','liyisem105@letpays.com',NULL,'$2y$10$oTEPxvA1pGYWsOa87aRGpuD93W0JP7bSL4oQj1l0kYm.7SpGSVh4a',1,NULL,1,1,'2022-12-30 19:22:15','2022-12-30 19:22:15'),(96,'Pixlogix','','HRM','1234567890','Pixlogix  HRM','pixlogix@gmail.com',NULL,'$2y$10$EcQL10vN22HYLPvTt5T5MusnMnEtghASMmGKywp0XNWTtfdm30hnu',50,'ouhycrgUwnkT9ZlGxGS2rSYnJPNvh7QDV8Ub0ngoQy8hAk5IweDfiRfMYiEX',1,0,'2023-02-03 08:11:31','2023-05-25 08:13:17'),(99,'Chanda','R','Kankasania','9979041567','Chanda R Kankasania','hr@pixlogix.com',NULL,'$2y$10$D55KmhoOijUUGCV0.1kV4u7T7UMO27.v1n0AQXmsVZ2icEI.UgbgS',50,'9KrwBn51bot99bcCNMFSB98N3Y4oPWOK4mp4FVvLNkmZOZ5OvJhCo4I225VJ',1,1,'2023-02-07 15:26:38','2024-02-09 17:19:31'),(100,'',NULL,'','','Milan  Patel','milan@pixlogix.com',NULL,'$2y$10$AfkuslFwEfliC7lSMvvkDusWIPlUl4XVO0WdVHwynhfSeANkb2n8K',39,'RdG2V6fg1FegPhRg2DLH6Tvsrf5IR3MhQ5Hv1bpbxQE1p0ydsuNandO2VlFM',0,1,'2023-02-08 13:48:47','2023-08-08 10:04:14'),(101,'Khushbu','','Parmar','','Khushbu  Parmar','career@pixlogix.com',NULL,'$2y$10$MYzAo3XJhYBXCNMxBvL8cuW8g6xp38Vk7K58.tM3IGZpJYKH2i6v2',50,'shoTBMGMmwZCekKVVAUCqOLFNgimu2byf7BQeGktnkSht2TpujiQax8Eev0I',1,1,'2023-02-08 14:13:40','2023-08-04 13:19:46'),(102,'',NULL,'','','Bharat  Dangar','bharat@pixlogix.com',NULL,'$2y$10$GOs.ZkoHmZr/n3DOB81eZeJu8Tf3OKDx2Z9oKqKTaO0MD9tI09Dgy',39,'64NFVhyvYl5HsPBuUmij3t8MqBsN7WtUclVHr96RkCehMtQj9dWFM21qpUJ1',0,1,'2023-02-08 14:27:09','2024-01-03 08:32:49'),(103,'vaibhavi',NULL,'patel','1478520369','vaibhavi patel','vaibhavi@pixlogix.com',NULL,'$2y$10$Eevu4esY6nZmo.izqQ0aF.85PRq0enD3CBsklimhWv.AHRXcDzVf6',39,'npJkiUFtSNJuujZs4duSMgp6PiZssZ0jj8KdoLeOKVi7nRrKUyre7XtFgMK6',0,1,'2023-02-08 14:30:34','2023-08-08 10:05:20'),(105,'Parth','','Jogi','','Parth  Jogi','parth.jogi.pixlogix@gmail.com',NULL,'$2y$10$wNT6KJTTV7GzMC4qlGGiFun.Jtu9gIIcMQ61mcHXory7utG5RL00a',39,'kmQjpXn1MRUaOAi5lFLpPjVIYEX80NpkLQPnoEDA4MT9ZkssFGkiKzqOZYoO',0,1,'2023-02-08 14:40:09','2024-07-02 07:56:41'),(106,'Niket','','Garala','7474747474','Niket  Garala','niket.pixlogix@gmail.com',NULL,'$2y$10$8TpFjk2zgfV/jrs/xgpcR.hqpGRamadlm41ZgCZTFHuxmPJqoKSYC',39,'GgVh4VO1hweZWq4Jb7lHKkjMb2wpcOq32hSvP7NIsQrTATa45l7Usjrqr5bA',1,1,'2023-02-08 14:42:49','2023-05-25 08:13:17'),(107,'Ravi','','Jethva','','Ravi  Jethva','ravi@pixlogix.com',NULL,'$2y$10$XDRhjSlAqzRYEDR7OA4DuOZQUJQwJeihT/tXV79OA1lTGDxHTj11i',39,'lRrMoXXFOFhCC9ocz4wf39tZseFvAlN9oL70qs8XGw80946pn2TR40wlOrF8',1,1,'2023-02-08 14:45:41','2023-08-02 08:48:01'),(108,'Neel','','Bhatt','','Neel  Bhatt','neel.pixlogix@gmail.com',NULL,'$2y$10$vaSinmGMp2w9mhLuJtnPn.zLviOW8gUNTYfxoEuOdDKypKICTeDKW',39,'WxSw7O42C64MHbYYIU0rV0arX0caS6t2oNx3JJqEXxnyWm1OBbs1ckGQdwft',1,1,'2023-02-08 14:46:08','2023-05-31 06:35:01'),(109,'Hardik','','Nakum','','Hardik  Nakum','hardik.pixlogix@gmail.com',NULL,'$2y$10$O.ci9aLxfM4E55kx2Peyc.QOz4exrecjYC1UnxXqgA3vHqZ2okyja',39,'XRwAo7Gt1EfQIdqE12WaAM1WBVNdBgRJeUYNkEFUDIGNXgo2atGB4fREo5IZ',0,1,'2023-02-08 14:48:31','2024-06-01 11:09:00'),(110,'Kavya','','Mehta','','Kavya  Mehta','kavya.pixlogix@gmail.com',NULL,'$2y$10$S6ihZAoyUbNvu1QLSXvJK.1iLXVbjij2BaVQCl1ousWqeWjmgQatm',39,'R7LwQmbgefah2qRoO4yPXDF9UkxzZVw96ecWs5jVQSqerv1zuKOhaC07oHQe',1,1,'2023-02-08 14:49:00','2023-10-26 05:55:38'),(111,'Sangita','','Galathiya','','Sangita  Galathiya','sangita.pixlogix@gmail.com',NULL,'$2y$10$ISgp6uQpGSIBsq4rQap4/u8Nocx0cmrKu6fukOd.R41WUtNVeRC.m',39,'6kNxEHE3wfOsPfDRojY8PVbCDdDqGH3XWzMJotlXH4JxM4axebfQFZ6AmKqE',1,1,'2023-02-08 14:51:01','2023-09-22 07:00:16'),(112,'Parth','','Shiroya','','Parth  Shiroya','parth.pixlogix@gmail.com',NULL,'$2y$10$LUP2QlzkEjDCgj.wiE0C7O7VD6VuGy2e2Zhrnlvlu5E5ikiRSzl6u',39,'lsAdCdHmVtYVcNnWem63d6phwA7YZ4Srm1n2xeV4MqZGhvDuOGznETlThWJA',1,1,'2023-02-08 14:54:21','2023-08-15 05:21:04'),(113,'',NULL,'','','Chirag  Patel','seo@pixlogix.com',NULL,'$2y$10$Q/3tM9ouRU985xIzqmMfa.KKCDDAXMYYLignGvbFqFdwh9xQNXNA2',39,'FZUvn3CMbseO2pksJNhMD6w5h5Uw28Gt49N4NQuy7msyiZnO0NBvbonZYpEk',0,1,'2023-02-09 06:39:38','2023-09-02 07:49:14'),(114,'',NULL,'','','Ashish  Tiwari','ashish@pixlogix.com',NULL,'$2y$10$sObQTva3DfiNj7Sx0w.nruh6b/zz1gcpV05koZlq.PcLA5P1FT9Lu',39,'fvclREDrtixpmt37KeOXiu2jtF7GCzOz0XDNzJRYIsz6YI7CZWSkh1HPCBj4',1,1,'2023-02-09 06:41:37','2023-06-24 08:13:05'),(115,'',NULL,'','','Reena  Parmar','reena.pixlogix@gmail.com',NULL,'$2y$10$I2gaX8Bqn3Zouotp3CdrHurEsa0UXI8wr7yI0Aqz1pb28.LCgDSy6',39,'9E8BBTL4NnwXry6KEQDL8AJe1qAlX4mYfoFZOGSMK79D4lbz4jdlYA42Sjw7',1,1,'2023-02-09 06:43:31','2023-05-31 05:53:02'),(116,'Priti','','Sharma','','Priti  Sharma','priti.pixlogix@gmail.com',NULL,'$2y$10$dzYFbQQUDVOogo/cCx/3RuE1S9XmpdZkyiCIbBeDlEkLEqIvTGyQ.',39,'EnpCrKZpeDz0HF8iuEN8nKNLDeX8p3OV2uWo1Dh7kzXaNSFmjTbekid8RmUA',1,1,'2023-02-09 06:45:03','2023-07-22 11:50:48'),(117,'Zeel','','Thacker','','Zeel  Thacker','zeel@pixlogix.com',NULL,'$2y$10$l/.ZH6lYMCOzpXy2yLgqYeVYQqdFS1fPkebOo94x1Nxamb5pvX4Ge',39,'vt5VrlaXciAUNv9EWhQNHOzLL2d4C2kupAD2MZN8qzT7nJG44ZCT5KC46Ep5',1,1,'2023-02-09 06:53:38','2024-06-06 12:15:47'),(118,'',NULL,'','','Aoibhe sfg ZAffar','adminsdds@gmail.coms',NULL,'$2y$10$PJpXp79mrubkmZSolpQBHel58n1KCE4vhRFMnNbhQzkfNDKlStCk6',1,NULL,1,1,'2023-03-03 20:59:11','2023-03-03 20:59:11'),(120,'',NULL,'','','Mukund  Patel','mukund@pixlogix.com',NULL,'$2y$10$OdQXoIvkz/NqjyqE79uvpesxkBq/KbHL/wzmAP9L8QBj0NSebvJG.',39,'57pT7mgLNgRh2Mu1AgrL31Hqtu1p2b6SfxnGPyOnkGLWn8eWrTFat7bGOWBx',0,1,'2023-03-21 07:41:28','2023-05-31 07:14:43'),(135,'aaa','a','dsfs','939393993','aaa a dsfs','abc1111@gmail.com',NULL,'$2y$10$tYfUTHnOYz87MBJ/vQkVg.ENUQIeDBUEHgP7zLrOkbqFxd11DiQh6',39,NULL,1,1,'2023-04-06 14:37:41','2023-04-06 14:37:41'),(136,'bb','vv','bbbb','38383883','bb vv bbbb','vbvb@gmail.com',NULL,'$2y$10$ZkgHTaBLLpo3ZwmqPQeqbO5k2g71kyulsKNhVuU6T52Rnm4RN/SCC',39,NULL,1,1,'2023-04-06 14:38:27','2023-04-06 14:38:27'),(158,'',NULL,'','','mukund p p','mukundp719@gmail.com',NULL,'$2y$10$TAzxaSyIujcfo6KrXHgfS.9kPB8m6lQBo8yOfp9SlU7h76AlABm3q',41,NULL,0,1,'2023-04-11 14:37:11','2023-04-12 09:53:26'),(168,'sdaf','dsfa','sdf','1230456789','sdaf dsfa sdf','sadfsd@dsg.com',NULL,'$2y$10$QE/5ssXzT0A7VSpTcEqqAeT/NrnaiBayL3I1sRn2DV7XSMoG7dVbe',48,NULL,1,0,'2023-04-12 11:55:31','2023-04-12 11:55:31'),(170,'dsfa','dfsasdf','dsds','1047852369','dsfa dfsasdf dsds','dasaa@rstgrsr.com',NULL,'$2y$10$6y.twPKFdgNfspJzE/1kHunXd0s7/yIuxwAxf554gaSEK1JeXX1x2',50,NULL,1,0,'2023-04-12 12:05:16','2023-04-12 12:05:16'),(206,'Divyaraj','','Bheda','','Divyaraj  Bheda','divyaraj@pixlogix.com',NULL,'$2y$10$mrZfdjmLcAM6DDet6eQsV.fzRO513JJvRhFbWVsGyuyf5c9DOP/MK',39,'klcs4pp9X0sBtYRxS4LFOTaK1EVduDTWKVeVBDqqIjpcPeVtFvDNMi0YhJAK',1,1,'2023-04-25 06:27:30','2024-05-01 10:55:45'),(208,'Meet','','Kapadiya','','Meet  Kapadiya','meet@pixlogix.com',NULL,'$2y$10$ak03V3/BeN1g71flnHIjIu6VdnyZuETBnmU6n7QStLLYDMSLiVOj2',39,'QjVJhVkNHuKLtPOmkeOQXoDhV7L4cEJOM3b0lWvOKTZfgfV4MWMLSiPZLOVV',0,1,'2023-04-25 07:10:17','2024-04-13 07:14:03'),(210,'',NULL,'','','Moinuddin  Marfatia','moin@pixlogix.com',NULL,'$2y$10$twT.AKJhcM1Os50leHPy2eZidrGNNXybp4dZ9DVSLGL3B.ykw.ruC',39,NULL,0,1,'2023-04-25 07:15:27','2023-05-31 07:12:19'),(211,'Sabir','','Malek','','Sabir  Malek','sabir.pixlogix@gmail.com',NULL,'$2y$10$U524tIeIZVMQJ1b5ivR/4.aSq3jOddZGdxqAnFJWvzoqQbMmzpeOa',39,'SsdwqpZr1PsvkHS7FphydQvcMtrXzyMxEJDQN3lLTpIP1OrYV9Qc18N7XDjj',1,1,'2023-04-25 07:18:06','2023-09-02 06:25:16'),(213,'Vijay','','Maru','','Vijay  Maru','vijay@pixlogix.com',NULL,'$2y$10$9GoWTR7GxJ229zjhgzC2H.MiC80Vej3FWVhC7Bn4e7KUdIyTKiAgK',39,'Qzj7WHLsEbcLI1SVIrvnHQ7jDbp0D0gCxJsABic5YS70XoODltUaJvs1MGMN',1,1,'2023-04-25 08:26:30','2024-06-06 12:14:38'),(214,'',NULL,'','','Meet  K','meetpatel5393@gmail.com',NULL,'$2y$10$1FXDBY.R4d9CSVKVuKEfd.TjtCgTUYAa/qPkY7OM5pF7EkHVkSaCe',39,'REC8ZIeDaaX84Q4n9X05LmjZL7YLNJSUcsmh2r2NgkQrif8JNEwjR0AqA0QV',1,1,'2023-04-25 11:11:59','2023-05-25 08:13:17'),(218,'',NULL,'','','Sagar  Pandya','sagar@pixlogix.com',NULL,'$2y$10$E8S/H97U2h6hSjT5Vdoy/u4d5IYeAUNLsGcOkLykhtc9AbaUQjUH2',39,'IcYdhCqk5VxDmMuVdcM82Vb5q0uqrn5ywkNqEVztTg4XeQJjfit48RAeZiTM',0,1,'2023-04-27 09:38:04','2023-08-08 10:04:51'),(245,'',NULL,'','','Knox Kevyn Powers Thompson','vagomu@mailinator.com',NULL,'$2y$10$Z.L93k2PGc0rkBQJ87g4Z.xjOVXw8iTnOsDfBJMyPSpGRJzSfcO8q',39,NULL,1,1,'2023-05-11 18:34:16','2023-05-25 08:13:17'),(246,'Cally','Burton Kane','Robbins','','Cally Burton Kane Robbins','newemployee@givmail.com',NULL,'$2y$10$kyrqwG7YnNnTAcWiJT.6/uD0MTm/N/z5joBpst3/I8lpBkeqe6yIe',39,'6goanj5q5j7S22wgSyIBVZX5l6Rux0UO1Ia4u0A5EhWvbKREjIRnhRcsAmDI',0,1,'2023-05-12 11:22:25','2023-05-25 08:07:34'),(251,'user',NULL,'user','74185296177','user user','newuser@getnada.com',NULL,'$2y$10$.2lWkOHaD7yeo8CTf.lL1Oie.D5sBe8QSC7FL/h3eyd7Vv1ZfujjC',0,'8dbghbszRt9woaF5DqkyaL9VDGhCxK0wcbsFdKYtdxfJBglKzc7veBjXpr8b',1,1,'2023-05-16 06:47:33','2023-05-16 06:50:24'),(263,'',NULL,'','','Risa Linda Morton Wood','kypoco@mailinator.com',NULL,'$2y$10$JVrRP2xj1/Vgi41D29s2M.C6wNXMHSnFJN34vBFID6Fu8nzukiQRW',39,NULL,1,1,'2023-05-19 11:26:11','2023-05-25 08:13:17'),(271,'John','_','Doe','748529637525','John _ Doe','employeecreate@gmail.com',NULL,'$2y$10$qzul4GsMyP8OlExZWcsQS.pO7s4mmBJN1dUtMvJi2f21IWgQwd0Hy',1,NULL,1,1,'2023-05-19 13:21:20','2023-05-19 13:26:10'),(315,'',NULL,'','','Amal Naomi Finley Eaton','qonu@mailinator.com',NULL,'$2y$10$27AQYGLQr1yHY3HbTl29DuX/VlMmJGPocDHJZTDU4P3g35nR1fD9u',39,NULL,1,1,'2023-05-25 07:27:36','2023-05-25 07:27:36'),(316,'',NULL,'','','Miranda Dolan Webb Vance','jipoja@getnada.com',NULL,'$2y$10$VWAGW8CW1Dp4xkWcuNEK4uVMUfxwtWi//ZXgwQo3X43Qke9xDy3uG',39,NULL,1,1,'2023-05-25 07:28:50','2023-05-25 08:13:17'),(317,'',NULL,'','','Yasir Karyn Newton Hayes','waralum@mailinator.com',NULL,'$2y$10$XiQRbW7jPzLDiNJns1Fg7uoNzpOvFyxb9OWrG3COOjhCzF.8qYbq2',39,NULL,1,1,'2023-05-25 07:53:24','2023-05-25 08:13:17'),(320,'',NULL,'','','Faith Karleigh Rivera Boyer','zivoqehaf@mailinator.com',NULL,'$2y$10$ttGZTGJYUQrbqo0cINjPc.ngliDj2m02GkZqiQgugiL1ZNTPX5Pv6',39,NULL,1,1,'2023-05-25 08:01:44','2023-05-25 08:13:17'),(321,'',NULL,'','','Cadman Marah Ramsey Rich','sutybocexe@mailinator.com',NULL,'$2y$10$SJ5di9aL5SWwrGR4enx1EeSwNJ3A1AoO5b6lf0DRpSRjs9HOYJhIG',39,NULL,1,1,'2023-05-25 08:05:47','2023-05-25 08:13:17'),(322,'',NULL,'','','Ariana Hamish Bender Holder','cawad@mailinator.com',NULL,'$2y$10$YSvEZK1EWUYeeq8zgCLFKet.IE9cmyPoWyAnhqUK6GEMdYSqVznBO',39,NULL,1,1,'2023-05-25 08:08:05','2023-05-25 08:13:17'),(323,'',NULL,'','','Candace Adria Puckett Cline','jecegepugu@mailinator.com',NULL,'$2y$10$TT0INzMqrQdaWQlttVWz2.KED8Q9dNxUcswLj3N2ws/OvIzv5STty',39,NULL,1,1,'2023-05-25 08:13:22','2023-05-25 08:13:22'),(324,'',NULL,'','','Kristen Ronan Armstrong Bridges','jyzexeka@mailinator.com',NULL,'$2y$10$U1sKmuLXCLSKMDbv9TwHCeBNcCLL9t7BTI/Zz/Fejz.AGYoZGEJqW',39,NULL,1,1,'2023-05-25 08:14:19','2023-05-25 08:14:19'),(325,'',NULL,'','','Scott Marcia Lancaster Bates','mybu@mailinator.com',NULL,'$2y$10$Bx18GRwCgy1wzMkUKQrbReGH85JJ2cdHaxW1Pqk6XRLImtUivrlde',39,NULL,1,1,'2023-05-25 08:17:29','2023-05-25 08:17:29'),(326,'',NULL,'','','Chastity Buffy Delgado Noble','zelovir@vomoto.com',NULL,'$2y$10$pTr6/ZxcaKRCqnEcm3/kQO5DyPG4JXkUj.HIMLSQISB0rQwmz6dZm',39,NULL,1,1,'2023-05-25 08:18:37','2023-05-25 08:18:37'),(327,'',NULL,'','','Inga Elizabeth Ellison Horne','qanugik@getnada.com',NULL,'$2y$10$N8Js8QsIYqiumf3gl1LmqO.50g.Z9icROzLSIGSDualZ/m0f9aGne',39,NULL,1,1,'2023-05-25 08:23:59','2023-05-25 08:23:59'),(328,'',NULL,'','','Steven Allistair Crane Farrell','fyvuqujel@mailinator.com',NULL,'$2y$10$OSicD77fx0pFAKTQqUPhyeHOhR8ERapH7Gmiru.mMOFNpLfiQLj2e',39,NULL,1,1,'2023-05-25 08:25:44','2023-05-25 08:25:44'),(329,'',NULL,'','','Keiko Amela Jacobs Deleon','witerep@getnada.com',NULL,'$2y$10$pbHuZVrIHdJQfwf4fr0pmOZGuStqwPV0k3UKsD2AL42bhWARPcwj6',39,NULL,1,1,'2023-05-25 08:28:33','2023-05-25 08:28:33'),(330,'',NULL,'','','Reece Zeph Kirk Espinoza','puryki@getnada.com',NULL,'$2y$10$JLb9bBwHdk7hpjnVJVAVLOsWw4tXtuN6MrNi2ilgFgpbcvgn5AiQq',39,NULL,1,1,'2023-05-25 08:30:01','2023-05-25 08:30:01'),(331,'',NULL,'','','Malachi Chaim Park Gutierrez','radyhapap@getnada.com',NULL,'$2y$10$S8kKA7lVqklLvQUaaac7AepF1yB4gslaUg0OWegjFYxZAYVi2OF6K',39,NULL,1,1,'2023-05-25 08:31:37','2023-05-25 08:31:37'),(332,'',NULL,'','','Elizabeth Jermaine Bridges Short','qicil@getnada.com',NULL,'$2y$10$jy/8jNEO7NCqbEinWu/dM.1gLPMMeM9BiEuxrrdvsP9ozq8ZjtR9.',39,NULL,1,1,'2023-05-25 08:32:16','2023-05-25 08:32:16'),(333,'',NULL,'','','Cheryl Emma Cantu Stanley','tukyjoli@getnada.com',NULL,'$2y$10$lUbu/6v4pCMcthRQKFhHgu/XoYPuf4MUxYuw3tcK8QGaC./7JBeF2',39,NULL,1,1,'2023-05-25 08:33:23','2023-05-25 08:33:23'),(334,'',NULL,'','','Kerry Yasir Buckley Hopkins','roziq@getnada.com',NULL,'$2y$10$JJpXvPf9CrMcUF3xcZc3XOZmFTaLulbhPrByh9XRzUURjeQKyxMf2',39,NULL,1,1,'2023-05-25 08:34:35','2023-05-25 08:34:35'),(335,'',NULL,'','','Ariana Leo Clarke Russell','lalyna@getnada.com',NULL,'$2y$10$IDWlEijjRAnpnWxoWs4uLOpQHkv9BVBKwQdFRJnOz6JF7hy7kTESu',39,NULL,1,1,'2023-05-25 08:37:36','2023-05-25 08:37:36'),(336,'',NULL,'','','Kimberly Forrest Tyson Melton','bijox@getnada.com',NULL,'$2y$10$2Bll4kZMC9bdqpHyG8kRuO37eM67LvCYsV3Ta.d0DNBV0qRV0/dZy',39,NULL,1,1,'2023-05-25 08:39:11','2023-05-25 08:39:11'),(337,'',NULL,'','','Burton Madonna Burks Lynch','munyxe@getnada.com',NULL,'$2y$10$qULaur2v1MLvXYTtgCyvM.JTxpVfzhv7Jl8hihIEGFlz7t8s/zPf.',39,NULL,1,1,'2023-05-25 08:41:44','2023-05-25 08:41:44'),(338,'',NULL,'','','Zorita Zia Gibson Hernandez','pyluc@getnada.com',NULL,'$2y$10$YOPSk0X3dotlsGFYkgqxz.Mt5eE6Lk0HRuQU8.IYNZvIkSDp1lq3C',39,NULL,1,1,'2023-05-25 08:43:07','2023-05-25 08:43:07'),(339,'',NULL,'','','Christian Raymond Reyes Chan','dozydijic@getnada.com',NULL,'$2y$10$sH5R2luxRp9gBxZxlRV.WuZHs2un4htbGd7tJyYUXUkn7aq7mvmJy',39,NULL,1,1,'2023-05-25 08:58:40','2023-05-25 08:58:40'),(340,'',NULL,'','','Sopoline Dexter Barron Combs','locegoza@getnada.com',NULL,'$2y$10$3v3JqZUN4OAJPb5q9/R89OP5YLA0QnINzqyUXt.T69C34u4fqVQQi',39,NULL,1,1,'2023-05-25 11:08:06','2023-05-25 11:08:06'),(341,'',NULL,'','','Cade Ingrid Schultz Taylor','fyzicoc@getnada.com',NULL,'$2y$10$n6ZE60dBbyaiKFbaKjctheCLBV200K74W/Wb2QUQUrk7T4DMxAZJ2',39,NULL,1,1,'2023-05-25 11:09:35','2023-05-25 11:09:35'),(342,'',NULL,'','','Myles Sylvia Wyatt Shelton','gowoqa@getnada.com',NULL,'$2y$10$ymroAyAXDv1T1ebpuSD3j.bjvhkWLGgRGZOMfO4LSLwiyBY7.zWxi',39,NULL,1,1,'2023-05-25 11:11:51','2023-05-25 11:11:51'),(343,'',NULL,'','','Aretha Ocean Herrera Henry','rewugilyc@getnada.com',NULL,'$2y$10$WU2WdbWux/JXyQhautDFNeM6SIimaqx60kz2/xAWyZLXeZ5Rh.cAy',39,NULL,1,1,'2023-05-25 11:18:34','2023-05-25 11:18:34'),(344,'',NULL,'','','Raya Cherokee Ruiz Watkins','qulojipod@getnada.com',NULL,'$2y$10$Ln.0J4mbIJi0ipdayjKnwuFmCrFOTG3ixDKodnf7Kyp/tEybbRq8O',39,NULL,1,1,'2023-05-25 11:20:52','2023-05-25 11:20:52'),(345,'',NULL,'','','Pascale Gwendolyn Peterson Atkinson','kybahola@getnada.com',NULL,'$2y$10$1PYPhTQtTkv2ZHEUBT7RYOXW7EXe6iSsln4qm0Y3eJAS.xT/i6RtS',39,NULL,1,1,'2023-05-25 11:26:43','2023-05-25 11:26:43'),(346,'John','','Doe','','John  Doe','ruputi@getnada.com',NULL,'$2y$10$SQkHqUVe3hiqG2zazKDNIuP0mA3vuj.WPtpExZUJi7pAmLC8NlfJS',39,'09VUEa1svLGN8w9tjPVrDDKFepXDGaLJXxNJ5RaDH6X2DFOxdpkzWf5fiNJ4',1,1,'2023-05-25 12:31:51','2023-05-25 12:38:56'),(347,'John',NULL,'doe','1233','John doe','rekasevy@getnada.com',NULL,'$2y$10$0OmYQuUJShVJ2.r19evw2.jaGnUcTrdybD7bIWTV4Z4Oe81wzhzYe',1,'E1CuVS8dg0V3xx2gvMPsWk0TQ6tBL680JhoJ38wMuF62gHl1DCqFoMcLPoV1',1,1,'2023-05-25 14:09:54','2023-05-25 15:39:52'),(348,'',NULL,'','','john  cina','jodyze@getnada.com',NULL,'$2y$10$SAA9FVmg6Tk9Jq3.cdkK7uW5pN4eg1GCLkiIod3NUC2pqyOGNkwTK',39,NULL,1,1,'2023-05-25 15:02:57','2023-05-25 15:02:57'),(349,'',NULL,'','','Micah Giacomo Craig Chaney','jybilykob@getnada.com',NULL,'$2y$10$zA/mvDKFBnDLSynYzUJEQeAoS1rVGjSPO6CheUtUj9CMh/o1rK0xi',39,NULL,1,1,'2023-05-25 16:20:05','2023-05-25 16:20:05'),(350,'',NULL,'','','Kendall Risa Boyer Cardenas','rulawira@getnada.com',NULL,'$2y$10$LM73a9FOTU0ZLk0tCXrvr.0sHjYR0O.7mb19Hox7fsML0SRgMEqZu',39,NULL,1,1,'2023-05-25 16:21:08','2023-05-25 16:21:08'),(351,'',NULL,'','','Shaeleigh Damon Aguilar Gates','wefumev@getnada.com',NULL,'$2y$10$Tj5Pa8uhQ40MklUPSsd2X.nzR6b.FvzNgJiolDRASNeo8lZIBugES',39,NULL,1,1,'2023-05-25 16:22:53','2023-05-25 16:22:53'),(352,'Lawrence','Yardley Anthony','Porter','','Lawrence Yardley Anthony Porter','cajuqijo@getnada.com',NULL,'$2y$10$Q6xir84KIs3MUQ/BgRXuc.LAjWim2APV/YfqPUZiEYiFxk0EJ17ke',39,'E80QccKo5CQ8UTzJDK1LrPzOYzAfgYKjpb4UZFOeyTGQ8L6VIGNRI2kDeqhX',1,1,'2023-05-25 16:29:01','2023-05-25 16:36:20'),(353,'',NULL,'','','Emery Candace Fowler Gould','qoras@getnada.com',NULL,'$2y$10$UZo5CassUfcP1PWrtR07YuqrBfzrBvf1o.KxniO7gyLqb1xqo4l3G',39,NULL,1,1,'2023-05-25 16:31:08','2023-05-25 16:31:08'),(360,'Indira','Xerxes Craig','Walter','1','Indira Xerxes Craig Walter','macihoko@getnada.com',NULL,'$2y$10$IXtFjpl/wLgwN4XTH3l84eObz2ecsP/Hv4y4rDbxVziOnZzfVlin.',113,NULL,1,0,'2023-05-27 07:12:21','2023-05-27 07:12:21'),(361,'Brynn','Rae Colon','Dotson','1','Brynn Rae Colon Dotson','kecuzuruw@getnada.com',NULL,'$2y$10$CcoDDlCpcmPlmLmCUwhnJufvEn2Gd2A0jhi2snqgjqv2vMf8b2lVi',114,NULL,1,0,'2023-05-27 07:13:23','2023-05-27 07:13:23'),(362,'Alana','Paul Farmer','Warner','1','Alana Paul Farmer Warner','xorerykil@getnada.com',NULL,'$2y$10$wyy1Eg.6y2.USeLiDvKFpOxg0rEoyhfkgsJdFEDiZsmySN6ajZFai',115,NULL,1,0,'2023-05-27 07:15:24','2023-05-27 07:15:24'),(363,'Ciara','Christian Gentry','Johns','1','Ciara Christian Gentry Johns','xusyr@getnada.com',NULL,'$2y$10$.jiY9nGXPzvPposJhpLqHupBLAN3PPXp3u7b/S8qBoTiXQCvOZrfu',116,NULL,1,0,'2023-05-27 07:19:10','2023-05-27 07:19:10'),(364,'Alexis','Elaine Hancock','Wilson','1','Alexis Elaine Hancock Wilson','xeheso@getnada.com',NULL,'$2y$10$A89TCvyX56PRGsO0woS13.dRF0R5qddv3aGdrxOWoGHZ79dHwTmKq',117,NULL,1,0,'2023-05-27 07:45:43','2023-05-27 07:45:43'),(365,'Gretchen','Lewis Perry','Baker','1','Gretchen Lewis Perry Baker','jimuzogah@getnada.com',NULL,'$2y$10$xRF9NwqSkE5FhgqW0AU4kejxhfeUFjp4BSz/WoOovPoF2O2cJg7Qe',118,NULL,1,0,'2023-05-27 07:46:58','2023-05-27 07:46:58'),(366,'James','Jesse Cameron','Schroeder','1','James Jesse Cameron Schroeder','mililag@getnada.com',NULL,'$2y$10$KMspkOnm6LqAeRM8FhjDtulM9Pr3FhbeVoqvwsfbOInWYl61JBGvi',119,NULL,1,0,'2023-05-27 08:00:06','2023-05-27 08:00:06'),(367,'Shellie','Candice Owens','Leon','1','Shellie Candice Owens Leon','kymyruvi@getnada.com',NULL,'$2y$10$8JzjQHSaYfkvvo7c.SyBJOZhbLCcY9Feo7cisFXrXHpeoUbmCJ8B2',120,NULL,1,0,'2023-05-27 08:03:39','2023-05-27 08:03:39'),(368,'Genevieve','Brielle Sargent','Pacheco','1','Genevieve Brielle Sargent Pacheco','memitu@getnada.com',NULL,'$2y$10$T0z6Z0YOtc44Socmoj4XYOoYQVtZSx/tlM20xAOV/WR9I/wGcGMnm',121,NULL,1,0,'2023-05-27 08:04:43','2023-05-27 08:04:43'),(369,'Idola','Pearl Butler','Tucker','312','Idola Pearl Butler Tucker','tiqeginuc@getnada.com',NULL,'$2y$10$QS5oDbGuaoXAq1M67UFaw.Xi19Z2PXF.ghrWr3GpAd4DTfprVc0bq',122,NULL,1,0,'2023-05-27 08:06:26','2023-05-27 08:06:26'),(370,'Addison','Larissa Greer','Ellison','1','Addison Larissa Greer Ellison','qecis@getnada.com',NULL,'$2y$10$xXf.ysrFYf9GATCc44i96.nEoMBLKz2FnQs6w0xYT2EgLTeGNVdkK',123,NULL,1,0,'2023-05-27 08:08:12','2023-05-27 08:08:12'),(371,'Theodore','Chloe Melendez','Crosby','132','Theodore Chloe Melendez Crosby','jibewygoh@getnada.com',NULL,'$2y$10$HhNszxODbo.PhLI9/YBa0.gfYajuesDbdisMF.Atw8BG2.PKypGg.',124,NULL,1,0,'2023-05-27 08:16:42','2023-05-27 08:16:42'),(372,'Fallon','Debra Benjamin','Mckinney','1','Fallon Debra Benjamin Mckinney','qyhuxavo@getnada.com',NULL,'$2y$10$JAC0Wy75pMIvLDGoz/Ddfu68AHACWp5GtwhFvEMCf9ZrWYDvg/Y9i',125,NULL,1,0,'2023-05-27 08:25:32','2023-05-27 08:25:32'),(373,'Selma','Giacomo Oneill','Hess','1','Selma Giacomo Oneill Hess','jutunomaz@getnada.com',NULL,'$2y$10$l0WDJtl.gWRMY4GHmgkd0.BzmXStx/PsHwlsjd8OIR1ROY69jsWv6',126,NULL,1,0,'2023-05-27 08:26:11','2023-05-27 08:26:11'),(374,'Alfreda','Jonas Jones','Salas','1','Alfreda Jonas Jones Salas','kiriha@mailinator.com',NULL,'$2y$10$A3vG8DNbj28awlmrmxACFet7rPf2LPnOZN00VwHx0Mugh0IfnkCQe',127,NULL,1,0,'2023-05-27 08:29:15','2023-05-27 08:29:15'),(375,'',NULL,'','','Mikayla Aquila Langley Whitley','fetygyku@getnada.com',NULL,'$2y$10$ytoaYLNLxR2c3sU/QAIHJ.YcRvMXJK2Pk7x1m7D5nZM0QmVnF6lo2',39,NULL,1,1,'2023-05-30 06:11:21','2023-05-30 06:11:21'),(376,'',NULL,'','','Karina Latifah Thomas Gates','qataj@getnada.com',NULL,'$2y$10$6t8femvMBBFFo1yx0op8A.d3/PdV047PjjDRnDTj07gYFwDITGLA2',39,NULL,1,1,'2023-05-30 06:13:36','2023-05-30 06:13:36'),(377,'',NULL,'','','Patrick Macaulay Gregory Mckay','cyfuwekar@getnada.com',NULL,'$2y$10$U/K1WAY0CUNvzEm0Fi8DYefn3ntLCf48QF3myPNFr4BH.KQy5.oNW',39,NULL,1,1,'2023-05-30 06:16:34','2023-05-30 06:16:34'),(378,'',NULL,'','','Jessamine Christen Turner Wiley','ricycuc@getnada.com',NULL,'$2y$10$JEQXM0U3cpQFMxhf7pHFbuEbrcI.3FuHov65/3Bo5AeJxBrfkmnpm',39,NULL,1,1,'2023-05-30 06:19:05','2023-05-30 06:19:05'),(380,'',NULL,'','','Brett Elvis Booth Lane','jotedeqyb@mailinator.com',NULL,'$2y$10$56Eb0p0uvmfZZPzswO0FgurxjuAwezN.JzQg.vWKNaUsLRw5/t/ru',39,NULL,1,1,'2023-05-30 06:22:11','2023-05-30 06:22:11'),(381,'',NULL,'','','Simon Karen Wilkerson Burch','zufyhoseg@mailinator.com',NULL,'$2y$10$WQO29Tv5v4ss9fYNtT9ZnurwY3tc7H7xn4EIYRnAdAFEbXQorcsgm',39,NULL,1,1,'2023-05-30 06:23:32','2023-05-30 06:23:32'),(382,'',NULL,'','','Sylvester Flavia English Howe','sodydule@mailinator.com',NULL,'$2y$10$yLuam2h1ePfXBu64B2OzSeviAHHGfXxWHUoS/.zkQKPF8P.TexGfu',39,NULL,1,1,'2023-05-30 06:24:35','2023-05-30 06:24:35'),(383,'',NULL,'','','Alexander Orlando Landry Simon','byfam@mailinator.com',NULL,'$2y$10$Wy36ywC30icaJ4f1l3fCPOkv8NdWOrlW1F2Ok9tK9K5pk14vhnOyu',39,NULL,1,1,'2023-05-30 06:26:25','2023-05-30 06:26:25'),(390,'',NULL,'','','Dignesh  Parmar','dignesh.pixlogix@gmail.com',NULL,'$2y$10$RYVtBr/N8bgLzHG.HEXry..6y5Kcjm343H5FROEml6w3C12kGU/ei',39,'XvrChhz44DlqiTsqn0100VxXr5xlEA2BoQYDIecMob4gljCzl7w8I50sDUW2',0,1,'2023-05-31 07:16:40','2023-08-08 10:03:45'),(391,'Yogita','','Jadeja','','Yogita  Jadeja','yogita@pixlogix.com',NULL,'$2y$10$vGUooZRsb6zklYEW77Ve7OB65tUew4dxSTCGW5WEU1DaIALpLvvi2',39,'SsXLXdF3z6hXBBrQVeVyYdSloZdYj8xNM6JjcykIs62urhSyHjMrxviDYjL4',1,1,'2023-05-31 07:18:28','2024-06-06 12:15:13'),(392,'',NULL,'','','Mihir  Jagada','mihir.jagada.pixlogix@gmail.com',NULL,'$2y$10$QkeA4ITbO4GPJZQb06kWoe4HIRPAhiFD3FnM3pwgTNvXz4pfkiZIO',39,'ph4FG1V0gLyVfqhGXWABtxkLZXd7VIbxEss6s45qwgObOmyfZLZBz7G0UarP',1,1,'2023-05-31 07:32:46','2024-04-23 13:56:20'),(393,'Sonali','','Prajapati','','Sonali  Prajapati','sonali@pixlogix.com',NULL,'$2y$10$DLf044kbL9k/1AUGVl0bl.IGUiv9ogcjIdimI3bw6GOSaeebfG/li',39,'oVNfJh0F5BKLhPh89m43bdjrd4V4JyO6JY4cSHeYNxFVui5cSqCuslBiwP2l',0,1,'2023-06-27 13:31:51','2024-01-04 08:48:16'),(394,'',NULL,'','','Aqil  Badshah','aqil@pixlogix.com',NULL,'$2y$10$ATLBKPJfkQhf.UrqruYXiu0c.0fcpPUl9F2yQaA4Qb48hx0dsu/eS',39,'FOiwWzuDnrJK044rapHjXCxDwDps060zwUZ4hbznTkUTGBIFbt8AnOjCWSr3',0,1,'2023-06-27 13:46:38','2024-01-03 08:40:19'),(395,'',NULL,'','','Pavas  Dave','pavas@pixlogix.com',NULL,'2UXYxBvBEiD8IXKd9jqV9dzSoD4Cd48wOnkxrKcivjXPqzlHh4e1zZlfYHbp',39,'94sKuq7uWPR4gyr5DNsAcOzw24IjnTAfEukDZgqNaicDraRjwKY63QFxleNg',1,1,'2023-06-27 13:59:01','2023-09-13 06:30:41'),(396,'Kartik','','Kacha','','Kartik  Kacha','kartik@pixlogix.com',NULL,'$2y$10$IyEdUYAVorDpgtCghqbSt.5sSoQAzeLeOmy4xnPKymQROz26WWTGS',39,'SY1x2lFzzSUOBetxNJJq6czKPQmnWg5N23hkh14uTYRMikZPWWWi3VDZoEwC',1,1,'2023-06-27 14:01:22','2023-12-09 10:56:40'),(397,'',NULL,'','','Dhaval  Prajapati','dhaval.pixlogix@gmail.com',NULL,'$2y$10$PPlKHzrYFEIzVDSiq7prQuwRaYng7SnLJV3HH2z3Dcr8y.7nqyU82',39,'PKuJX3ULXYe9bwaX3yc8aUkN0RHLMYgcx4NF9gX9gH50krYjvtqSrnj2eJ0s',0,1,'2023-06-27 14:03:05','2024-01-13 07:52:57'),(398,'',NULL,'','','Jeel  Kalsariya','jeel.pixlogix@gmail.com',NULL,'$2y$10$WNIEGo1JmC7B5b1CDDwfUuZu.M0buKycFaPiLigkpKHsAXiPtxgoW',39,'p5Ip5RRKjW0aBllVKlhyh8z6ilfG6jYMS20Otejx0949eiUNPriuQMvQar46',0,1,'2023-06-27 14:04:51','2024-02-01 14:33:32'),(401,'',NULL,'','','Prashant  Khanpara','prashant@pixlogix.com',NULL,'$2y$10$2OBpMhr5veY5eVXzPt7Rne6xH201lSewA4HBUEcyOW97Kw7g.dWiO',39,'4cJTOrUVePlE3goUNXa5iVjGzB84ITpJJdYSJ7ipz8Q8jQjubQaMYdzot6QX',0,1,'2023-07-05 14:54:21','2023-09-16 07:03:11'),(402,'',NULL,'','','Brijesh  Gandhi','brijesh@pixlogix.com',NULL,'$2y$10$7TC8V7EvhVgRFzSHzmSo9uYN5Y7/8MLGPr0S.aLIB0zVYfZVCzEqa',39,'DJ3eIGhH2WojqJtQVBJS1sD9LFB1pVAigpO3nYUsBwNKnozKPMKXZVyrAyBA',0,1,'2023-07-08 07:08:08','2023-09-02 07:48:53'),(404,'Kevin','C','Patel','','Kevin C Patel','ba@pixlogix.com',NULL,'$2y$10$U0NfM9MlisKjwbIq639awe//4M0GWAG.peIWilm5Tkml5tnUHPlxm',39,'H7alKRfLPF9fwCXk71k1x50JrlojF65dhrkkRlGMRT0OVBMNch6RLB3SzOzs',0,1,'2023-07-22 08:29:14','2024-07-02 07:43:53'),(405,'Harshad','','Hadiya','','Harshad  Hadiya','harshad.pixlogix@gmail.com',NULL,'$2y$10$w4dzzUEpCCc/OA7AnydbC.LTatRgKOMwc3mjyCVYMfa8D0aJkDemO',39,'8cPlzAemNCublkR1i1pMw5OPSkU6Ddwuh0WTuTt32WH6zo3qiFqK9kb6bkUq',1,1,'2023-07-22 08:37:17','2024-06-06 12:17:35'),(406,'Harshad','hhhh','Hadiya','74185296310','Harshad hhhh Hadiya','testsitecreate818@gmail.com',NULL,'$2y$10$H41A3OoKFh2SuLF06uXpVOAo.jkT4JUxPoZ8d27glW41TQiNZK6XW',131,'nm97soQomcIqwDgwXS47XwPh9GODfvqN0RWoe0EsrwtyuwmcF34w9X0vBmNL',1,0,'2023-07-27 11:44:49','2023-07-28 14:48:06'),(436,'Krupa','','Ladani','','Krupa  Ladani','krupa.pixlogix@gmail.com',NULL,'$2y$10$xWf0tEHdQ66evpCbuqSZxezqBxHF9Un5Gj3Bo9fLJwVbx9v/nzTvC',39,'YR6H8oILDcchhfvnUmrJOwTWCXRxAxpkRK30L9eoKea5qSJLmTEjUD9iT40N',1,1,'2023-09-05 13:10:49','2023-09-12 09:01:01'),(438,'Ikramul','','Shekh','','Ikramul  Shekh','ikramul.pixlogix@gmail.com',NULL,'$2y$10$wGl7KWZjpgPBVlh8oXqWr.qu3tobrgeDdP/GH6MG5Nc9JRlfXvEKC',39,'NCYgYUTOrwIe2h8tooHw8bjgH23BnBIzi4sjzT90HbdusU30be5Rvrg22ZwI',1,1,'2023-10-07 13:42:51','2023-12-09 10:55:51'),(443,'',NULL,'','','Chirag Manishkumar Jalu','chirag@pixlogix.com',NULL,'$2y$10$ZHxvUsPH99V8TSnhQt7VeO40UjBmMryleyKBMvCrzAVviJr6QjpZm',39,'OxbrGQ02i6eOre6IjlSPeAeemKFR0PrAl4cNQwK1wXBOFNbtYaLWPse1lyjG',0,1,'2023-10-27 13:29:48','2024-04-04 07:54:29'),(444,'Preet','','Soni','','Preet  Soni','preet.pixlogix@gmail.com',NULL,'$2y$10$eclIBkrFmqSOpvv95YzMl.cf2BnpfhCLHZhpS0iFtEvQrjtwS/g8G',39,'HlPQYuBk87mf9dmZeAJQUxzUO1rGpYWZ9mLtvGOLlEyC8E6e1wuTK13ynN7t',1,1,'2023-10-29 07:59:17','2023-12-09 11:05:39'),(445,'Avesh','','Baliwala','','Avesh  Baliwala','avesh.pixlogix@gmail.com',NULL,'$2y$10$zJj7yqdEOQx9hkrzxlMQ/OL7/UpYoV26VpG1NC.xlX.1hRUwPDXR.',39,'TePRHJcJSh7zLcekLL90xLD5WTcRT8VkCylsIbqbR7pIfb5QyR4vJlgaQFCy',0,1,'2023-12-02 07:07:19','2024-04-04 08:17:36'),(446,'Samir','','Bhimbha','','Samir  Bhimbha','info@pixlogix.com',NULL,'$2y$10$M04/9wipmVSx8v16MIGW7.xqotV6t7QeZS/.uNJxjkQGs90dlYjwm',39,'hQclkqkkF7roEb42Qul1APsqDFTek5PlEoFqGSJwSmXn8TAzpsf3Pp1YXVx0',1,1,'2023-12-20 14:51:26','2023-12-21 07:52:26'),(447,'',NULL,'','','Harshil  Mehta','harshil@pixlogix.com',NULL,'$2y$10$AHaBepv94xeD4Ve.jGsxCOngJhNDKmO6p3LMKHwlELaZCRIm9QTSC',39,'1uYVi1eMytVKpKitAEMSqhT3J8NUbqAF7k2CZj9Qa2WeQu35p7uTpOQxDup3',1,1,'2024-01-02 10:06:13','2024-01-03 06:58:20'),(449,'',NULL,'','','Riddhi  Patel','riddhi@pixlogix.com',NULL,'$2y$10$OswNJzaCvNSEoZZfpIvTEuKGfPdnjc3xHM6Lj0ORHmOlWPRReo8.C',39,'cbFnDPZFq8DhtnrvZM9yY6k47Chx0CB9T9jDjlbFwvoBG4cTzrwvxBGtcJBD',0,1,'2024-02-03 12:50:21','2024-06-01 14:19:30'),(450,'HR','test','Testing','','HR test Testing','cajir93715@bitofee.com',NULL,'$2y$10$rOBLHGHfdD9FcU.cLtMWl.YkQ74BstBaXi.1CYMAgKRPzOChEk7bi',50,'rcJEj7k79I0eFfmM8pxqlCzdvRc93I3WMGoUF8TxLndZ4y2rDRkbKakcnOok',1,1,'2024-02-08 08:32:10','2024-02-08 14:08:27'),(451,'EmployeeK','M','TestK','','EmployeeK M TestK','yehayi8917@alibrs.com',NULL,'$2y$10$NCQkm.WcSdaWlVFmSmQ7nuUwTaBn002QpG73AA20AKVgTKxzFAO3e',50,'UJWg6ErZ5BdUV3mogw3zpofS31CSNbZEmDMjFnLLeQOH0xIc23SoRgCsoFGn',1,1,'2024-02-08 08:33:56','2024-06-11 11:31:11'),(452,'Hardik','','Rathod','','Hardik  Rathod','hardikr@pixlogix.com',NULL,'$2y$10$FjIkoEU3IDiv55V3rCbZuOZmgRVqFzirLCG7muv2EAahHzXLAGemS',39,'6gsZIMqzrIEpMY18spA8KzluXqcylC7AXCwZMQiK4EXV5GCmAxUkmUdUVPXC',0,1,'2024-02-13 13:44:00','2024-06-29 11:53:44'),(453,'',NULL,'','','Kalpesh  Rajora','pc@pixlogix.com',NULL,'$2y$10$Xje6jd4dHar5j3Y1oCeH5ucsaFXe4A7gnpz3YV0AaHDNVBjEXK8o2',39,'xw9UjcabfVNItNfR6ekXuUSrI63M8jGMLL7hQFie5PcnhZfZcleBUlwOjMs5',0,1,'2024-02-20 13:40:39','2024-04-30 10:18:24'),(454,'',NULL,'','','Kevin  Patel','kevin@pixlogix.com',NULL,'$2y$10$jWQvR3gluA1OuHRJIFHzce8W6nrj2HVG2HLGXZLDKEdlmZi/QeXpq',39,'E4BWclajqXCoLtMeXLrX4ynFie6qhhXqexdYcFV857EYPfLo6mcjaJXT9M9P',0,1,'2024-03-23 11:26:07','2024-07-10 11:25:41'),(455,'Deeshit','','Parikh','','Deeshit  Parikh','deeshit@pixlogix.com',NULL,'$2y$10$muTLH/isSFFEimNxQWaJO.MvuhiTc8Q6nFXhGhmhLz/ZphX1IL2Rm',39,'TqMQodDPxtsd4KtqdbDsB0PYnDKSzndgREh3O9LafHSDSe6vXsZhH6KASmet',1,1,'2024-05-25 12:15:44','2024-07-09 05:42:53'),(456,'Jigar','','Pandya','','Jigar  Pandya','jigar@pixlogix.com',NULL,'$2y$10$oyFHsyQxg3lct9FrLthpeexZpUCDutZRq.cxQ.ngvi9KCEouAR/Q.',39,'bhYycOWRil5JwhuZaykwk2PD7rzDX4t0kfW7Q3eM17QmV1HrDyHo0R2Xiua5',1,1,'2024-06-29 09:38:11','2024-07-02 07:17:38');

--
-- Table structure for table `worklog_tasks`
--

CREATE TABLE `worklog_tasks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `worklog_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `project_id` bigint(20) unsigned NOT NULL,
  `client_name` varchar(255) NOT NULL,
  `project_name` varchar(255) NOT NULL,
  `scope` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `hours` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `worklog_tasks_employee_id_foreign` (`employee_id`),
  KEY `worklog_tasks_worklog_id_foreign` (`worklog_id`),
  KEY `worklog_tasks_client_id_foreign` (`client_id`),
  KEY `worklog_tasks_project_id_foreign` (`project_id`),
  CONSTRAINT `worklog_tasks_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `worklog_tasks_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`),
  CONSTRAINT `worklog_tasks_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`),
  CONSTRAINT `worklog_tasks_worklog_id_foreign` FOREIGN KEY (`worklog_id`) REFERENCES `worklogs` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `worklog_tasks`
--


--
-- Table structure for table `worklogs`
--

CREATE TABLE `worklogs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` bigint(20) unsigned NOT NULL,
  `date` date NOT NULL,
  `total_hours` double(8,2) NOT NULL,
  `time_difference` double(8,2) NOT NULL DEFAULT 0.00,
  `hrm_hours` time NOT NULL DEFAULT '00:00:00',
  `status` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `worklogs_employee_id_foreign` (`employee_id`),
  CONSTRAINT `worklogs_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `worklogs`
--



