--
-- Host: localhost    Database: golcha
-- ------------------------------------------------------


--
-- Table structure for table `admin_user_infos`
--

CREATE TABLE `admin_user_infos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `admin_user_id` bigint unsigned DEFAULT NULL,
  `full_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_user_infos_admin_user_id_index` (`admin_user_id`),
  KEY `admin_user_infos_created_by_admin_users_info_id_index` (`created_by_admin_users_info_id`),
  KEY `admin_user_infos_updated_by_admin_users_info_id_index` (`updated_by_admin_users_info_id`),
  KEY `admin_user_infos_deleted_by_admin_users_info_id_index` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `admin_user_infos_admin_user_id_foreign` FOREIGN KEY (`admin_user_id`) REFERENCES `admin_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `admin_user_infos_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `admin_user_infos_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `admin_user_infos_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_user_infos`
--

INSERT INTO `admin_user_infos` VALUES (1,1,'Golcha','golcha@gmail.com','9801081830','Kathmandu',NULL,NULL,NULL,NULL,'2025-07-01 23:56:34','2025-07-01 23:56:34');

--
-- Table structure for table `admin_users`
--

CREATE TABLE `admin_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `push_notification_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `is_super_admin` tinyint DEFAULT '0',
  `changed_password` tinyint DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_users_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_users`
--

INSERT INTO `admin_users` VALUES (1,'havit','$2y$12$ju7wZFA3d3xpsN5iq6QQh.2tnQ0quJZV8.rFxP4e1eeyYEGt40X1C',NULL,NULL,1,1,0,NULL,'2025-07-01 23:56:34','2025-07-01 23:56:34');

--
-- Table structure for table `bess_overviews`
--

CREATE TABLE `bess_overviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bess_overviews_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `bess_overviews_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `bess_overviews_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `bess_overviews_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `bess_overviews_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `bess_overviews_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bess_overviews`
--

INSERT INTO `bess_overviews` VALUES (1,'Battery Energy Storage System(BESS)','<p>Battery Energy Storage System (BESS) is a smart technology that stores electricity usually from solar or wind and supplies it during power outages, peak demand, or high-cost periods. It enables energy self-sufficiency, cost savings, and grid reliability</p>',1,1,NULL,NULL,NULL,'2025-09-02 01:48:14','2025-09-02 10:59:32');

--
-- Table structure for table `besses`
--

CREATE TABLE `besses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_order` tinyint DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `besses_created_by_admin_users_info_id_index` (`created_by_admin_users_info_id`),
  KEY `besses_updated_by_admin_users_info_id_index` (`updated_by_admin_users_info_id`),
  KEY `besses_deleted_by_admin_users_info_id_index` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `besses_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `besses_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `besses_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `besses`
--

INSERT INTO `besses` VALUES (1,'How It Works:','<ul>\r\n	<li>Charge: From solar, grid, or other sources.</li>\r\n	<li>Store: Electricity is saved in batteries as DC power.</li>\r\n	<li>Discharge: Converted to AC for household or industrial use.</li>\r\n</ul>',NULL,1,1,NULL,NULL,NULL,'2025-09-02 01:49:09','2025-09-02 01:49:09'),(2,'Key Benefits','<ul>\r\n	<li>Peak shaving to reduce electricity bills</li>\r\n	<li>Smooth renewable integration</li>\r\n	<li>Backup power &amp; grid support</li>\r\n	<li>Revenue via frequency response</li>\r\n	<li>Ideal for microgrids &amp; off-grid areas</li>\r\n</ul>',NULL,1,1,NULL,NULL,NULL,'2025-09-02 01:49:49','2025-09-02 01:49:49'),(3,'Core Components','<ul>\r\n	<li>Lithium Batteries for safety and durability</li>\r\n	<li>BMS for battery monitoring system</li>\r\n	<li>Inverter (PCS) to switch DC&harr;AC</li>\r\n	<li>EMS for smart energy control</li>\r\n	<li>Thermal &amp; Rack Systems for protection and performance</li>\r\n</ul>',NULL,1,1,NULL,NULL,NULL,'2025-09-02 01:50:21','2025-09-02 01:50:21'),(4,'Applications','<ul>\r\n	<li>Homes</li>\r\n	<li>Commercial &amp; industrial setups</li>\r\n	<li>Utility-scale grids</li>\r\n	<li>Remote micro grids</li>\r\n</ul>',NULL,1,1,NULL,NULL,NULL,'2025-09-02 01:50:48','2025-09-02 01:50:48'),(5,'GGE Solutions Include','<ul>\r\n	<li>Residential energy storage</li>\r\n	<li>PV + Storage integration</li>\r\n	<li>C&amp;I peak shaving systems</li>\r\n	<li>Off-grid and microgrid storage</li>\r\n	<li>EV charging + storage hybrid systems</li>\r\n</ul>',NULL,1,1,NULL,NULL,NULL,'2025-09-02 01:51:13','2025-09-02 01:51:13');

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` VALUES ('go_cache_spatie.permission.cache','a:3:{s:5:\"alias\";a:5:{s:1:\"a\";s:2:\"id\";s:1:\"b\";s:4:\"name\";s:1:\"c\";s:12:\"display_name\";s:1:\"d\";s:8:\"key_name\";s:1:\"e\";s:10:\"guard_name\";}s:11:\"permissions\";a:67:{i:0;a:5:{s:1:\"a\";i:1;s:1:\"b\";s:9:\"view.role\";s:1:\"c\";s:9:\"View Role\";s:1:\"d\";s:4:\"role\";s:1:\"e\";s:10:\"admin-user\";}i:1;a:5:{s:1:\"a\";i:2;s:1:\"b\";s:11:\"create.role\";s:1:\"c\";s:11:\"Create Role\";s:1:\"d\";s:4:\"role\";s:1:\"e\";s:10:\"admin-user\";}i:2;a:5:{s:1:\"a\";i:3;s:1:\"b\";s:9:\"edit.role\";s:1:\"c\";s:9:\"Edit Role\";s:1:\"d\";s:4:\"role\";s:1:\"e\";s:10:\"admin-user\";}i:3;a:5:{s:1:\"a\";i:4;s:1:\"b\";s:11:\"delete.role\";s:1:\"c\";s:11:\"Delete Role\";s:1:\"d\";s:4:\"role\";s:1:\"e\";s:10:\"admin-user\";}i:4;a:5:{s:1:\"a\";i:5;s:1:\"b\";s:16:\"view.designation\";s:1:\"c\";s:16:\"View Designation\";s:1:\"d\";s:11:\"designation\";s:1:\"e\";s:10:\"admin-user\";}i:5;a:5:{s:1:\"a\";i:6;s:1:\"b\";s:18:\"create.designation\";s:1:\"c\";s:18:\"Create Designation\";s:1:\"d\";s:11:\"designation\";s:1:\"e\";s:10:\"admin-user\";}i:6;a:5:{s:1:\"a\";i:7;s:1:\"b\";s:16:\"edit.designation\";s:1:\"c\";s:16:\"Edit Designation\";s:1:\"d\";s:11:\"designation\";s:1:\"e\";s:10:\"admin-user\";}i:7;a:5:{s:1:\"a\";i:8;s:1:\"b\";s:18:\"delete.designation\";s:1:\"c\";s:18:\"Delete Designation\";s:1:\"d\";s:11:\"designation\";s:1:\"e\";s:10:\"admin-user\";}i:8;a:5:{s:1:\"a\";i:9;s:1:\"b\";s:9:\"view.user\";s:1:\"c\";s:9:\"View User\";s:1:\"d\";s:4:\"user\";s:1:\"e\";s:10:\"admin-user\";}i:9;a:5:{s:1:\"a\";i:10;s:1:\"b\";s:11:\"create.user\";s:1:\"c\";s:11:\"Create User\";s:1:\"d\";s:4:\"user\";s:1:\"e\";s:10:\"admin-user\";}i:10;a:5:{s:1:\"a\";i:11;s:1:\"b\";s:9:\"edit.user\";s:1:\"c\";s:9:\"Edit User\";s:1:\"d\";s:4:\"user\";s:1:\"e\";s:10:\"admin-user\";}i:11;a:5:{s:1:\"a\";i:12;s:1:\"b\";s:16:\"view.siteSetting\";s:1:\"c\";s:17:\"View Site Setting\";s:1:\"d\";s:11:\"siteSetting\";s:1:\"e\";s:10:\"admin-user\";}i:12;a:5:{s:1:\"a\";i:13;s:1:\"b\";s:19:\"view.changePassword\";s:1:\"c\";s:20:\"View Change Password\";s:1:\"d\";s:14:\"changePassword\";s:1:\"e\";s:10:\"admin-user\";}i:13;a:5:{s:1:\"a\";i:14;s:1:\"b\";s:15:\"view.seoSetting\";s:1:\"c\";s:16:\"View Seo Setting\";s:1:\"d\";s:10:\"seoSetting\";s:1:\"e\";s:10:\"admin-user\";}i:14;a:5:{s:1:\"a\";i:15;s:1:\"b\";s:17:\"create.seoSetting\";s:1:\"c\";s:18:\"Create Seo Setting\";s:1:\"d\";s:10:\"seoSetting\";s:1:\"e\";s:10:\"admin-user\";}i:15;a:5:{s:1:\"a\";i:16;s:1:\"b\";s:15:\"edit.seoSetting\";s:1:\"c\";s:16:\"Edit Seo Setting\";s:1:\"d\";s:10:\"seoSetting\";s:1:\"e\";s:10:\"admin-user\";}i:16;a:5:{s:1:\"a\";i:17;s:1:\"b\";s:17:\"delete.seoSetting\";s:1:\"c\";s:18:\"Delete Seo Setting\";s:1:\"d\";s:10:\"seoSetting\";s:1:\"e\";s:10:\"admin-user\";}i:17;a:5:{s:1:\"a\";i:18;s:1:\"b\";s:17:\"view.successStory\";s:1:\"c\";s:18:\"View Success Story\";s:1:\"d\";s:12:\"successStory\";s:1:\"e\";s:10:\"admin-user\";}i:18;a:5:{s:1:\"a\";i:19;s:1:\"b\";s:19:\"create.successStory\";s:1:\"c\";s:20:\"Create Success Story\";s:1:\"d\";s:12:\"successStory\";s:1:\"e\";s:10:\"admin-user\";}i:19;a:5:{s:1:\"a\";i:20;s:1:\"b\";s:17:\"edit.successStory\";s:1:\"c\";s:18:\"Edit Success Story\";s:1:\"d\";s:12:\"successStory\";s:1:\"e\";s:10:\"admin-user\";}i:20;a:5:{s:1:\"a\";i:21;s:1:\"b\";s:19:\"delete.successStory\";s:1:\"c\";s:20:\"Delete Success Story\";s:1:\"d\";s:12:\"successStory\";s:1:\"e\";s:10:\"admin-user\";}i:21;a:5:{s:1:\"a\";i:22;s:1:\"b\";s:15:\"view.siteBanner\";s:1:\"c\";s:16:\"View Site Banner\";s:1:\"d\";s:10:\"siteBanner\";s:1:\"e\";s:10:\"admin-user\";}i:22;a:5:{s:1:\"a\";i:23;s:1:\"b\";s:17:\"create.siteBanner\";s:1:\"c\";s:18:\"Create Site Banner\";s:1:\"d\";s:10:\"siteBanner\";s:1:\"e\";s:10:\"admin-user\";}i:23;a:5:{s:1:\"a\";i:24;s:1:\"b\";s:15:\"edit.siteBanner\";s:1:\"c\";s:16:\"Edit Site Banner\";s:1:\"d\";s:10:\"siteBanner\";s:1:\"e\";s:10:\"admin-user\";}i:24;a:5:{s:1:\"a\";i:25;s:1:\"b\";s:17:\"delete.siteBanner\";s:1:\"c\";s:18:\"Delete Site Banner\";s:1:\"d\";s:10:\"siteBanner\";s:1:\"e\";s:10:\"admin-user\";}i:25;a:5:{s:1:\"a\";i:26;s:1:\"b\";s:15:\"view.homeBanner\";s:1:\"c\";s:16:\"View Home Banner\";s:1:\"d\";s:10:\"homeBanner\";s:1:\"e\";s:10:\"admin-user\";}i:26;a:5:{s:1:\"a\";i:27;s:1:\"b\";s:17:\"create.homeBanner\";s:1:\"c\";s:18:\"Create Home Banner\";s:1:\"d\";s:10:\"homeBanner\";s:1:\"e\";s:10:\"admin-user\";}i:27;a:5:{s:1:\"a\";i:28;s:1:\"b\";s:15:\"edit.homeBanner\";s:1:\"c\";s:16:\"Edit Home Banner\";s:1:\"d\";s:10:\"homeBanner\";s:1:\"e\";s:10:\"admin-user\";}i:28;a:5:{s:1:\"a\";i:29;s:1:\"b\";s:17:\"delete.homeBanner\";s:1:\"c\";s:18:\"Delete Home Banner\";s:1:\"d\";s:10:\"homeBanner\";s:1:\"e\";s:10:\"admin-user\";}i:29;a:5:{s:1:\"a\";i:30;s:1:\"b\";s:13:\"view.whoWeAre\";s:1:\"c\";s:15:\"View Who We Are\";s:1:\"d\";s:8:\"whoWeAre\";s:1:\"e\";s:10:\"admin-user\";}i:30;a:5:{s:1:\"a\";i:31;s:1:\"b\";s:23:\"view.ourServiceOverview\";s:1:\"c\";s:25:\"View Our Service Overview\";s:1:\"d\";s:18:\"ourServiceOverview\";s:1:\"e\";s:10:\"admin-user\";}i:31;a:5:{s:1:\"a\";i:32;s:1:\"b\";s:16:\"view.ourServices\";s:1:\"c\";s:17:\"View Our Services\";s:1:\"d\";s:11:\"ourServices\";s:1:\"e\";s:10:\"admin-user\";}i:32;a:5:{s:1:\"a\";i:33;s:1:\"b\";s:18:\"create.ourServices\";s:1:\"c\";s:19:\"Create Our Services\";s:1:\"d\";s:11:\"ourServices\";s:1:\"e\";s:10:\"admin-user\";}i:33;a:5:{s:1:\"a\";i:34;s:1:\"b\";s:16:\"edit.ourServices\";s:1:\"c\";s:17:\"Edit Our Services\";s:1:\"d\";s:11:\"ourServices\";s:1:\"e\";s:10:\"admin-user\";}i:34;a:5:{s:1:\"a\";i:35;s:1:\"b\";s:18:\"delete.ourServices\";s:1:\"c\";s:19:\"Delete Our Services\";s:1:\"d\";s:11:\"ourServices\";s:1:\"e\";s:10:\"admin-user\";}i:35;a:5:{s:1:\"a\";i:36;s:1:\"b\";s:18:\"view.whyWorkWithUs\";s:1:\"c\";s:21:\"View Why Work With Us\";s:1:\"d\";s:13:\"whyWorkWithUs\";s:1:\"e\";s:10:\"admin-user\";}i:36;a:5:{s:1:\"a\";i:37;s:1:\"b\";s:20:\"create.whyWorkWithUs\";s:1:\"c\";s:23:\"Create Why Work With Us\";s:1:\"d\";s:13:\"whyWorkWithUs\";s:1:\"e\";s:10:\"admin-user\";}i:37;a:5:{s:1:\"a\";i:38;s:1:\"b\";s:18:\"edit.whyWorkWithUs\";s:1:\"c\";s:21:\"Edit Why Work With Us\";s:1:\"d\";s:13:\"whyWorkWithUs\";s:1:\"e\";s:10:\"admin-user\";}i:38;a:5:{s:1:\"a\";i:39;s:1:\"b\";s:20:\"delete.whyWorkWithUs\";s:1:\"c\";s:23:\"Delete Why Work With Us\";s:1:\"d\";s:13:\"whyWorkWithUs\";s:1:\"e\";s:10:\"admin-user\";}i:39;a:5:{s:1:\"a\";i:40;s:1:\"b\";s:28:\"view.technologyCollaboration\";s:1:\"c\";s:29:\"View Technology Collaboration\";s:1:\"d\";s:23:\"technologyCollaboration\";s:1:\"e\";s:10:\"admin-user\";}i:40;a:5:{s:1:\"a\";i:41;s:1:\"b\";s:30:\"create.technologyCollaboration\";s:1:\"c\";s:31:\"Create Technology Collaboration\";s:1:\"d\";s:23:\"technologyCollaboration\";s:1:\"e\";s:10:\"admin-user\";}i:41;a:5:{s:1:\"a\";i:42;s:1:\"b\";s:28:\"edit.technologyCollaboration\";s:1:\"c\";s:29:\"Edit Technology Collaboration\";s:1:\"d\";s:23:\"technologyCollaboration\";s:1:\"e\";s:10:\"admin-user\";}i:42;a:5:{s:1:\"a\";i:43;s:1:\"b\";s:30:\"delete.technologyCollaboration\";s:1:\"c\";s:31:\"Delete Technology Collaboration\";s:1:\"d\";s:23:\"technologyCollaboration\";s:1:\"e\";s:10:\"admin-user\";}i:43;a:5:{s:1:\"a\";i:44;s:1:\"b\";s:18:\"view.mediaCategory\";s:1:\"c\";s:19:\"View Media Category\";s:1:\"d\";s:13:\"mediaCategory\";s:1:\"e\";s:10:\"admin-user\";}i:44;a:5:{s:1:\"a\";i:45;s:1:\"b\";s:20:\"create.mediaCategory\";s:1:\"c\";s:21:\"Create Media Category\";s:1:\"d\";s:13:\"mediaCategory\";s:1:\"e\";s:10:\"admin-user\";}i:45;a:5:{s:1:\"a\";i:46;s:1:\"b\";s:18:\"edit.mediaCategory\";s:1:\"c\";s:19:\"Edit Media Category\";s:1:\"d\";s:13:\"mediaCategory\";s:1:\"e\";s:10:\"admin-user\";}i:46;a:5:{s:1:\"a\";i:47;s:1:\"b\";s:20:\"delete.mediaCategory\";s:1:\"c\";s:21:\"Delete Media Category\";s:1:\"d\";s:13:\"mediaCategory\";s:1:\"e\";s:10:\"admin-user\";}i:47;a:5:{s:1:\"a\";i:48;s:1:\"b\";s:10:\"view.media\";s:1:\"c\";s:10:\"View Media\";s:1:\"d\";s:5:\"media\";s:1:\"e\";s:10:\"admin-user\";}i:48;a:5:{s:1:\"a\";i:49;s:1:\"b\";s:12:\"create.media\";s:1:\"c\";s:12:\"Create Media\";s:1:\"d\";s:5:\"media\";s:1:\"e\";s:10:\"admin-user\";}i:49;a:5:{s:1:\"a\";i:50;s:1:\"b\";s:10:\"edit.media\";s:1:\"c\";s:10:\"Edit Media\";s:1:\"d\";s:5:\"media\";s:1:\"e\";s:10:\"admin-user\";}i:50;a:5:{s:1:\"a\";i:51;s:1:\"b\";s:12:\"delete.media\";s:1:\"c\";s:12:\"Delete Media\";s:1:\"d\";s:5:\"media\";s:1:\"e\";s:10:\"admin-user\";}i:51;a:5:{s:1:\"a\";i:52;s:1:\"b\";s:23:\"view.ourProjectOverview\";s:1:\"c\";s:25:\"View Our Project Overview\";s:1:\"d\";s:18:\"ourProjectOverview\";s:1:\"e\";s:10:\"admin-user\";}i:52;a:5:{s:1:\"a\";i:53;s:1:\"b\";s:15:\"view.ourProject\";s:1:\"c\";s:16:\"View Our Project\";s:1:\"d\";s:10:\"ourProject\";s:1:\"e\";s:10:\"admin-user\";}i:53;a:5:{s:1:\"a\";i:54;s:1:\"b\";s:17:\"create.ourProject\";s:1:\"c\";s:18:\"Create Our Project\";s:1:\"d\";s:10:\"ourProject\";s:1:\"e\";s:10:\"admin-user\";}i:54;a:5:{s:1:\"a\";i:55;s:1:\"b\";s:15:\"edit.ourProject\";s:1:\"c\";s:16:\"Edit Our Project\";s:1:\"d\";s:10:\"ourProject\";s:1:\"e\";s:10:\"admin-user\";}i:55;a:5:{s:1:\"a\";i:56;s:1:\"b\";s:17:\"delete.ourProject\";s:1:\"c\";s:18:\"Delete Our Project\";s:1:\"d\";s:10:\"ourProject\";s:1:\"e\";s:10:\"admin-user\";}i:56;a:5:{s:1:\"a\";i:57;s:1:\"b\";s:20:\"view.benefitOverview\";s:1:\"c\";s:21:\"View Benefit Overview\";s:1:\"d\";s:15:\"benefitOverview\";s:1:\"e\";s:10:\"admin-user\";}i:57;a:5:{s:1:\"a\";i:58;s:1:\"b\";s:12:\"view.benefit\";s:1:\"c\";s:12:\"View Benefit\";s:1:\"d\";s:7:\"benefit\";s:1:\"e\";s:10:\"admin-user\";}i:58;a:5:{s:1:\"a\";i:59;s:1:\"b\";s:14:\"create.benefit\";s:1:\"c\";s:14:\"Create Benefit\";s:1:\"d\";s:7:\"benefit\";s:1:\"e\";s:10:\"admin-user\";}i:59;a:5:{s:1:\"a\";i:60;s:1:\"b\";s:12:\"edit.benefit\";s:1:\"c\";s:12:\"Edit Benefit\";s:1:\"d\";s:7:\"benefit\";s:1:\"e\";s:10:\"admin-user\";}i:60;a:5:{s:1:\"a\";i:61;s:1:\"b\";s:14:\"delete.benefit\";s:1:\"c\";s:14:\"Delete Benefit\";s:1:\"d\";s:7:\"benefit\";s:1:\"e\";s:10:\"admin-user\";}i:61;a:5:{s:1:\"a\";i:62;s:1:\"b\";s:12:\"view.contact\";s:1:\"c\";s:12:\"View Contact\";s:1:\"d\";s:7:\"contact\";s:1:\"e\";s:10:\"admin-user\";}i:62;a:5:{s:1:\"a\";i:63;s:1:\"b\";s:20:\"view.contactOverview\";s:1:\"c\";s:21:\"View Contact Overview\";s:1:\"d\";s:15:\"contactOverview\";s:1:\"e\";s:10:\"admin-user\";}i:63;a:5:{s:1:\"a\";i:64;s:1:\"b\";s:12:\"view.product\";s:1:\"c\";s:12:\"View Product\";s:1:\"d\";s:7:\"product\";s:1:\"e\";s:10:\"admin-user\";}i:64;a:5:{s:1:\"a\";i:65;s:1:\"b\";s:14:\"create.product\";s:1:\"c\";s:14:\"Create Product\";s:1:\"d\";s:7:\"product\";s:1:\"e\";s:10:\"admin-user\";}i:65;a:5:{s:1:\"a\";i:66;s:1:\"b\";s:12:\"edit.product\";s:1:\"c\";s:12:\"Edit Product\";s:1:\"d\";s:7:\"product\";s:1:\"e\";s:10:\"admin-user\";}i:66;a:5:{s:1:\"a\";i:67;s:1:\"b\";s:14:\"delete.product\";s:1:\"c\";s:14:\"Delete Product\";s:1:\"d\";s:7:\"product\";s:1:\"e\";s:10:\"admin-user\";}}s:5:\"roles\";a:0:{}}',1769250636);

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache_locks`
--


--
-- Table structure for table `contact_overviews`
--

CREATE TABLE `contact_overviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `contact_display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `one_liner_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_bottom_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_bottom_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contact_overviews_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `contact_overviews_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `contact_overviews_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `contact_overviews_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `contact_overviews_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `contact_overviews_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_overviews`
--

INSERT INTO `contact_overviews` VALUES (1,'Explore Solutions','Ready to Go Green? Let’s Talk.','Take the first step towards a sustainable future. Our experts are here to help.','<ul>\r\n	<li>\r\n	<p>We will respond to you within 24 hours.</p>\r\n	</li>\r\n	<li>\r\n	<p>Expert Solutions for Green Renewable Energy Needs</p>\r\n	</li>\r\n	<li>\r\n	<p>Seamless Support for Sustainable Energy Projects</p>\r\n	</li>\r\n</ul>','Let\'s Work Together','<p>We have established ourselves as a trusted partner for leading solar energy providers, green renewable energy companies, major utilities, retailers, and other sustainable energy stakeholders.</p>',1,1,NULL,NULL,NULL,'2025-07-08 01:27:21','2025-07-08 01:27:21');

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` VALUES (1,'binod','independent','bnodxbasnet@gmail.com','9843165356','project enquiry','Dear Sir, good afternoon, please provide me the follwing detail which wasnt found in your website \r\n1. Can you provide me the list of the projects you have built at utility scale on-grid ground-mounted solar power projects in Nepal? place, capacity, operation date if possible techncial detail on major equipment \r\n2. Are you an independent contractor, or are you associated with the foreign partner?','2026-06-03 09:29:59','2026-06-03 09:29:59'),(2,'binod','independent','bnodxbasnet@gmail.com','9843165356','project enquiry','Dear Sir, good afternoon, please provide me the following detail which wasnt found in your website \r\n1. Can you provide me the list of the projects you have built at utility scale on-grid ground-mounted solar power projects in Nepal? place, capacity, operation date, if possible, technical detail on major equipment \r\n2. Are you an independent contractor, or are you associated with the foreign partner?','2026-06-03 09:30:34','2026-06-03 09:30:34');

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

CREATE TABLE `designations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `is_editable` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `designations_name_unique` (`name`),
  KEY `designations_created_by_admin_users_info_id_index` (`created_by_admin_users_info_id`),
  KEY `designations_updated_by_admin_users_info_id_index` (`updated_by_admin_users_info_id`),
  KEY `designations_deleted_by_admin_users_info_id_index` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `designations_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `designations_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `designations_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `designations` VALUES (1,'asdfadf',1,1,1,NULL,NULL,NULL,'2025-07-07 00:33:24','2025-07-07 00:33:24');

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

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

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


--
-- Table structure for table `home_banners`
--

CREATE TABLE `home_banners` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `banner_image_lg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `banner_image_md` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banner_image_mb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alt_tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `button_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_order` tinyint DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `home_banners_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `home_banners_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `home_banners_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `home_banners_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `home_banners_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `home_banners_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_banners`
--

INSERT INTO `home_banners` VALUES (1,'/storage/photos/1/banner image/banner.jpg',NULL,NULL,NULL,'Powering the Future with Renewable Energy','<p>At Golchha, we are committed to driving a sustainable tomorrow by harnessing the limitless potential of renewable energy. With innovative solar solutions, we empower communities and businesses to embrace clean, reliable, and future-ready energy sources.</p>','Explore Solution','https://gge.com.np/contact',1,1,1,1,NULL,NULL,'2025-07-02 05:33:39','2025-10-27 07:47:11'),(2,'/storage/photos/1/banner image/banner.jpg',NULL,NULL,NULL,'Powering the Future with Renewable Energy',NULL,NULL,NULL,3,0,1,NULL,1,NULL,'2025-07-02 05:34:24','2025-07-22 10:46:04'),(3,'/storage/photos/1/banner image/banner.jpg',NULL,NULL,NULL,'Powering the Future with Renewable Energy','<p>At Golchha, we are committed to driving a sustainable tomorrow by harnessing the limitless potential of renewable energy. With innovative solar solutions, we empower communities and businesses to embrace clean, reliable, and future-ready energy sources.</p>','Explore Solution','http://golcha.test/',2,0,1,NULL,1,NULL,'2025-07-06 05:01:30','2025-07-22 10:46:03');

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

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

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


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

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

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


--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `media_category_id` bigint unsigned DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `media_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `media_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  KEY `media_media_category_id_index` (`media_category_id`),
  CONSTRAINT `media_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `media_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `media_media_category_id_foreign` FOREIGN KEY (`media_category_id`) REFERENCES `media_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `media_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` VALUES (1,2,'test','test','/storage/photos/1/about.jpg','07/04/2025','<p>adsfasdfasdf</p>',NULL,NULL,1,1,1,NULL,NULL,'2025-07-03 05:49:16','2025-07-08 05:28:27'),(2,1,'The New Clean Energy','the-new-clean-energy','/storage/photos/1/about.jpg','07/04/2025','<p>adsfasdfasdf</p>',NULL,NULL,1,1,1,NULL,NULL,'2025-07-03 05:49:16','2025-07-22 11:43:12');

--
-- Table structure for table `media_categories`
--

CREATE TABLE `media_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_order` tinyint DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_categories_created_by_admin_users_info_id_index` (`created_by_admin_users_info_id`),
  KEY `media_categories_updated_by_admin_users_info_id_index` (`updated_by_admin_users_info_id`),
  KEY `media_categories_deleted_by_admin_users_info_id_index` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `media_categories_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `media_categories_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `media_categories_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_categories`
--

INSERT INTO `media_categories` VALUES (1,'News',1,1,1,NULL,NULL,NULL,'2025-07-03 05:21:34','2025-07-03 05:22:16'),(2,'Sports',2,1,1,1,NULL,NULL,'2025-07-03 05:21:40','2025-07-03 05:22:16');

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

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

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

INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2025_05_07_052125_create_admin_users_table',1),(5,'2025_05_07_062804_create_designations_table',1),(6,'2025_05_07_062814_create_user_designations_table',1),(7,'2025_05_07_062824_create_user_activities_table',1),(8,'2025_05_07_062826_create_permission_tables',1),(9,'2025_05_07_062955_create_user_permissions_table',1),(10,'2025_05_12_045600_create_site_settings_table',1),(13,'2025_07_02_055855_create_success_stories_table',2),(14,'2025_07_02_074743_create_site_banners_table',3),(15,'2025_07_02_104805_create_home_banners_table',4),(16,'2025_07_02_114930_create_who_we_ares_table',5),(18,'2025_07_03_052139_create_our_service_overviews_table',6),(19,'2025_07_03_071109_create_our_services_table',7),(20,'2025_07_03_100852_create_why_work_with_us_table',8),(21,'2025_07_03_102416_create_technology_collaborations_table',9),(22,'2025_07_03_105100_create_media_categories_table',10),(23,'2025_07_03_105105_create_media_table',11),(24,'2025_07_04_051416_create_our_project_overviews_table',12),(28,'2025_07_04_053042_create_our_projects_table',13),(29,'2025_07_06_052903_create_project_galleries_table',14),(30,'2025_07_06_094908_create_benefit_overviews_table',15),(31,'2025_07_06_094914_create_benefits_table',15),(32,'2025_07_07_093837_create_contacts_table',16),(33,'2025_07_08_065838_create_contact_overviews_table',17),(34,'2025_07_08_075701_create_seo_settings_table',18),(36,'2025_07_09_052731_create_products_table',19);

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

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

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


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

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

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


--
-- Table structure for table `our_project_overviews`
--

CREATE TABLE `our_project_overviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `our_project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `our_project_overviews_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `our_project_overviews_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `our_project_overviews_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `our_project_overviews_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `our_project_overviews_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `our_project_overviews_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `our_project_overviews`
--

INSERT INTO `our_project_overviews` VALUES (1,'Our Projects','Green Energy Solutions That Empower Lives','<p>Discover how Golchha revolutionizes green energy solutions with cutting-edge solar technology. These projects highlight our commitment to sustainability, cost-effectiveness, and customer satisfaction in the renewable energy sector.</p>','/storage/photos/1/solar.png',1,1,NULL,NULL,NULL,'2025-07-03 23:39:23','2025-07-03 23:39:23');

--
-- Table structure for table `our_projects`
--

CREATE TABLE `our_projects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `banner_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `project_overview` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `side_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `highlights` json DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `our_projects_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `our_projects_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `our_projects_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `our_projects_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `our_projects_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `our_projects_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `our_projects`
--

INSERT INTO `our_projects` VALUES (1,'/storage/photos/1/service/service1.png','Green Energy','green-energy','Simara, Bara','<p>Discover how Golchha revolutionizes green energy solutions with cutting-edge solar technology. These projects highlight our commitment to sustainability, cost-effectiveness, and customer satisfaction in the renewable energy sector.</p>','/storage/photos/1/service/service1.png','<p>In Simara, Bara,Golcha collaborated with a real estate giant to integrate cutting-edge solar technology. This project brought sustainable power to residential communities, reducing emissions and costs while enhancing energy efficiency.</p>','/storage/photos/1/Mnemonic 1.png',NULL,NULL,NULL,1,1,1,NULL,NULL,'2025-07-04 04:47:57','2025-07-07 00:17:08'),(2,'/storage/photos/1/service/service2.png','Sharda University','sharda-university','Uttar Pradesh','<p>In Simara, Bara,Golcha collaborated with a real estate giant to integrate cutting-edge solar technology. This project brought sustainable power to residential communities, reducing emissions and costs while enhancing energy efficiency.</p>','/storage/photos/1/about.jpg','<p>In Simara, Bara,Golcha collaborated with a real estate giant to integrate cutting-edge solar technology. This project brought sustainable power to residential communities, reducing emissions and costs while enhancing energy efficiency.</p>','/storage/photos/1/chart.png','[{\"title\": \"Solar Grid Energy\", \"value\": \"Energy\"}, {\"title\": \"Manufacturing Industry\", \"value\": \"Industry\"}]',NULL,NULL,0,1,1,NULL,NULL,'2025-07-04 04:48:35','2025-10-27 07:53:36'),(3,'/storage/photos/1/service/service1.png','Hulas Steel Industries Limited','hulas-steel-industries-limited','Simara, Bara','<p>In Simara, Bara,Golcha collaborated with a real estate giant to integrate cutting-edge solar technology. This project brought sustainable power to residential communities, reducing emissions and costs while enhancing energy efficiency.</p>','/storage/photos/1/solar.png','<p>In Simara, Bara,Golcha collaborated with a real estate giant to integrate cutting-edge solar technology. This project brought sustainable power to residential communities, reducing emissions and costs while enhancing energy efficiency.</p>','/storage/photos/1/about.jpg','[{\"title\": \"Capacity\", \"value\": \"1300kWp\"}, {\"title\": \"Manufacturing\", \"value\": \"Industry\"}, {\"title\": \"Solar Grid\", \"value\": \"Energy\"}]',NULL,NULL,1,1,1,NULL,NULL,'2025-07-04 04:51:08','2025-07-06 06:16:33');

--
-- Table structure for table `our_service_overviews`
--

CREATE TABLE `our_service_overviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `our_services_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `core_value_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `core_value_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `core_value_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `our_service_overviews_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `our_service_overviews_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `our_service_overviews_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `our_service_overviews_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `our_service_overviews_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `our_service_overviews_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `our_service_overviews`
--

INSERT INTO `our_service_overviews` VALUES (1,'Our Services','Exceptional Golchha Services Delivered','<p>At Golchha, we offer cutting-edge solutions in solar and green renewable energy to power your world sustainably. Our services are tailored to meet your energy needs with innovation and reliability.</p>','Core Values','Powering a Greener Tomorrow','/storage/photos/1/chart.png',1,1,NULL,NULL,NULL,'2025-07-02 23:58:59','2025-07-10 09:53:52');

--
-- Table structure for table `our_services`
--

CREATE TABLE `our_services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_order` tinyint DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `our_services_created_by_admin_users_info_id_index` (`created_by_admin_users_info_id`),
  KEY `our_services_updated_by_admin_users_info_id_index` (`updated_by_admin_users_info_id`),
  KEY `our_services_deleted_by_admin_users_info_id_index` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `our_services_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `our_services_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `our_services_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `our_services`
--

INSERT INTO `our_services` VALUES (1,'Consulting Services','<ul>\r\n	<li>Guiding you toward smarter energy decisions</li>\r\n	<li>Site selection &amp; feasibility studies</li>\r\n	<li>ROI optimization &amp; carbon credit consulting</li>\r\n	<li>Subsidy application &amp; regulatory support</li>\r\n	<li>Workshops and capacity building</li>\r\n</ul>','/storage/photos/1/icon/green.webp',1,1,1,1,NULL,NULL,'2025-07-03 01:37:22','2025-07-10 09:56:28'),(2,'Installation and Commissioning','<ul>\r\n	<li>Precision in every Step</li>\r\n	<li>Engineering &amp; system design</li>\r\n	<li>Safe and reliable installations</li>\r\n	<li>Seamless project commissioning</li>\r\n</ul>','/storage/photos/1/icon/recharge.webp',2,1,1,1,NULL,NULL,'2025-07-03 01:38:16','2025-07-10 09:57:13'),(3,'Our Services','<ul>\r\n	<li>Site assessment &amp; DPR preparation</li>\r\n	<li>Design, engineering, and installation</li>\r\n	<li>Remote monitoring &amp; maintenance</li>\r\n	<li>Project financing and leasing options</li>\r\n</ul>','/storage/photos/1/icon/green.webp',NULL,1,1,1,NULL,NULL,'2025-07-03 02:23:55','2025-07-10 09:55:10'),(4,'Operations & Maintenance','<ul>\r\n	<li>Ensuring long-term energy efficiency</li>\r\n	<li>On-site training for operators</li>\r\n	<li>Remote performance monitoring</li>\r\n	<li>Preventive and corrective maintenance</li>\r\n</ul>','/storage/photos/1/icon/bulb.webp',NULL,1,1,NULL,NULL,NULL,'2025-07-10 09:58:00','2025-07-10 09:58:00');

--
-- Table structure for table `our_strategic_alliances`
--

CREATE TABLE `our_strategic_alliances` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `our_strategic_alliances_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `our_strategic_alliances_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `our_strategic_alliances_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `our_strategic_alliances_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `our_strategic_alliances_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `our_strategic_alliances_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `our_strategic_alliances`
--

INSERT INTO `our_strategic_alliances` VALUES (1,'Our Strategic Alliance','<p>In partnership with KSL Cleantech Limited, one of India&rsquo;s most trusted solar energy solution providers, GGE brings global expertise with local insight. With over 400+ successful installations across India, including major infrastructure such as airports, railways, and universities. KSL is a reliable force in solar design, engineering, and integration.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Why KSL Cleantech?&nbsp;</p>\r\n\r\n<ul>\r\n	<li>Technology-agnostic, always adapting to the latest global innovations.</li>\r\n	<li>Turnkey solar solutions with unmatched design, workmanship, and support.</li>\r\n	<li>Dedicated account managers and robust after-sales service.</li>\r\n	<li>Proven experience across rural, urban, defense, industrial, and commercial sectors.</li>\r\n</ul>','/storage/photos/1/Screenshot 2025-09-02 134231.png',1,1,NULL,NULL,NULL,'2025-09-02 02:12:54','2025-09-02 10:59:05');

--
-- Table structure for table `password_reset_tokens`
--

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

--
-- Dumping data for table `password_reset_tokens`
--


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

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

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

INSERT INTO `permissions` VALUES (1,'view.role','View Role','role','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(2,'create.role','Create Role','role','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(3,'edit.role','Edit Role','role','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(4,'delete.role','Delete Role','role','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(5,'view.designation','View Designation','designation','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(6,'create.designation','Create Designation','designation','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(7,'edit.designation','Edit Designation','designation','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(8,'delete.designation','Delete Designation','designation','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(9,'view.user','View User','user','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(10,'create.user','Create User','user','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(11,'edit.user','Edit User','user','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(12,'view.siteSetting','View Site Setting','siteSetting','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(13,'view.changePassword','View Change Password','changePassword','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(14,'view.seoSetting','View Seo Setting','seoSetting','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(15,'create.seoSetting','Create Seo Setting','seoSetting','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(16,'edit.seoSetting','Edit Seo Setting','seoSetting','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(17,'delete.seoSetting','Delete Seo Setting','seoSetting','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(18,'view.successStory','View Success Story','successStory','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(19,'create.successStory','Create Success Story','successStory','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(20,'edit.successStory','Edit Success Story','successStory','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(21,'delete.successStory','Delete Success Story','successStory','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(22,'view.siteBanner','View Site Banner','siteBanner','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(23,'create.siteBanner','Create Site Banner','siteBanner','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(24,'edit.siteBanner','Edit Site Banner','siteBanner','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(25,'delete.siteBanner','Delete Site Banner','siteBanner','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(26,'view.homeBanner','View Home Banner','homeBanner','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(27,'create.homeBanner','Create Home Banner','homeBanner','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(28,'edit.homeBanner','Edit Home Banner','homeBanner','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(29,'delete.homeBanner','Delete Home Banner','homeBanner','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(30,'view.whoWeAre','View Who We Are','whoWeAre','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(31,'view.ourServiceOverview','View Our Service Overview','ourServiceOverview','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(32,'view.ourServices','View Our Services','ourServices','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(33,'create.ourServices','Create Our Services','ourServices','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(34,'edit.ourServices','Edit Our Services','ourServices','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(35,'delete.ourServices','Delete Our Services','ourServices','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(36,'view.whyWorkWithUs','View Why Work With Us','whyWorkWithUs','admin-user','2025-07-09 05:54:38','2025-07-09 05:54:38'),(37,'create.whyWorkWithUs','Create Why Work With Us','whyWorkWithUs','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(38,'edit.whyWorkWithUs','Edit Why Work With Us','whyWorkWithUs','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(39,'delete.whyWorkWithUs','Delete Why Work With Us','whyWorkWithUs','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(40,'view.technologyCollaboration','View Technology Collaboration','technologyCollaboration','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(41,'create.technologyCollaboration','Create Technology Collaboration','technologyCollaboration','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(42,'edit.technologyCollaboration','Edit Technology Collaboration','technologyCollaboration','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(43,'delete.technologyCollaboration','Delete Technology Collaboration','technologyCollaboration','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(44,'view.mediaCategory','View Media Category','mediaCategory','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(45,'create.mediaCategory','Create Media Category','mediaCategory','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(46,'edit.mediaCategory','Edit Media Category','mediaCategory','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(47,'delete.mediaCategory','Delete Media Category','mediaCategory','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(48,'view.media','View Media','media','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(49,'create.media','Create Media','media','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(50,'edit.media','Edit Media','media','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(51,'delete.media','Delete Media','media','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(52,'view.ourProjectOverview','View Our Project Overview','ourProjectOverview','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(53,'view.ourProject','View Our Project','ourProject','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(54,'create.ourProject','Create Our Project','ourProject','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(55,'edit.ourProject','Edit Our Project','ourProject','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(56,'delete.ourProject','Delete Our Project','ourProject','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(57,'view.benefitOverview','View Benefit Overview','benefitOverview','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(58,'view.benefit','View Benefit','benefit','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(59,'create.benefit','Create Benefit','benefit','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(60,'edit.benefit','Edit Benefit','benefit','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(61,'delete.benefit','Delete Benefit','benefit','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(62,'view.contact','View Contact','contact','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(63,'view.contactOverview','View Contact Overview','contactOverview','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(64,'view.product','View Product','product','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(65,'create.product','Create Product','product','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(66,'edit.product','Edit Product','product','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39'),(67,'delete.product','Delete Product','product','admin-user','2025-07-09 05:54:39','2025-07-09 05:54:39');

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `products_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `products_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `products_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `products_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `products_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `products_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1,'Solar water pumps & irrigation systems','solar-water-pumps-irrigation-systems','/storage/photos/1/banner image/banner.jpg','<p>Solar water pumps &amp; irrigation systems. Solarion&rsquo;s work in Berlin focused on transforming the energy infrastructure of a major manufacturing plant.</p>',NULL,NULL,1,1,1,NULL,NULL,'2025-07-09 00:08:30','2025-07-09 00:24:22'),(2,'Solar water pumps & irrigation systems','solar-water-pumps-irrigation-systems-1','/storage/photos/1/banner image/banner.jpg','<p>Solar water pumps &amp; irrigation systems. Solarion&rsquo;s work in Berlin focused on transforming the energy infrastructure of a major manufacturing plant.</p>',NULL,NULL,1,1,1,NULL,NULL,'2025-07-09 00:08:30','2025-07-09 00:24:18');

--
-- Table structure for table `project_galleries`
--

CREATE TABLE `project_galleries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `project_id` bigint unsigned NOT NULL,
  `gallery_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `project_galleries_project_id_foreign` (`project_id`),
  KEY `project_galleries_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `project_galleries_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `project_galleries_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `project_galleries_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `project_galleries_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `project_galleries_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `our_projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `project_galleries_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_galleries`
--

INSERT INTO `project_galleries` VALUES (32,3,'1751785850_about.jpg',1,1,NULL,NULL,NULL,'2025-07-06 01:25:50','2025-07-06 01:25:50'),(33,3,'1751785850_home-banner.jpg',1,1,NULL,NULL,NULL,'2025-07-06 01:25:50','2025-07-06 01:25:50'),(34,3,'1751785886_images.png',1,1,NULL,NULL,NULL,'2025-07-06 01:26:26','2025-07-06 01:26:26'),(35,3,'1751785886_download.jpg',1,1,NULL,NULL,NULL,'2025-07-06 01:26:26','2025-07-06 01:26:26'),(36,3,'1751785886_404562779_1380400385897840_1812893205458726431_n.jpg',1,1,NULL,NULL,NULL,'2025-07-06 01:26:27','2025-07-06 01:26:27'),(37,3,'1751785887_IMG_6495.jpg',1,1,NULL,NULL,NULL,'2025-07-06 01:26:27','2025-07-06 01:26:27'),(38,3,'1751785887_IMG_6490.jpg',1,1,NULL,NULL,NULL,'2025-07-06 01:26:27','2025-07-06 01:26:27'),(39,3,'1751785887_IMG_6489.jpg',1,1,NULL,NULL,NULL,'2025-07-06 01:26:27','2025-07-06 01:26:27'),(40,3,'1751785887_IMG_6491.jpg',1,1,NULL,NULL,NULL,'2025-07-06 01:26:27','2025-07-06 01:26:27'),(52,2,'1751870971_images.png',1,1,NULL,NULL,NULL,'2025-07-07 01:04:31','2025-07-07 01:04:31'),(53,2,'1751870971_download.jpg',1,1,NULL,NULL,NULL,'2025-07-07 01:04:31','2025-07-07 01:04:31'),(54,2,'1751870971_404562779_1380400385897840_1812893205458726431_n.jpg',1,1,NULL,NULL,NULL,'2025-07-07 01:04:31','2025-07-07 01:04:31'),(55,2,'1751870971_IMG_6495.jpg',1,1,NULL,NULL,NULL,'2025-07-07 01:04:31','2025-07-07 01:04:31'),(56,2,'1751870972_IMG_6490.jpg',1,1,NULL,NULL,NULL,'2025-07-07 01:04:32','2025-07-07 01:04:32'),(57,2,'1751870972_IMG_6489.jpg',1,1,NULL,NULL,NULL,'2025-07-07 01:04:32','2025-07-07 01:04:32'),(58,2,'1751870972_IMG_6491.jpg',1,1,NULL,NULL,NULL,'2025-07-07 01:04:32','2025-07-07 01:04:32');

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

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

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


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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1' COMMENT '1 for active and 0 for inactive',
  `created_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`),
  KEY `roles_created_by_admin_users_info_id_index` (`created_by_admin_users_info_id`),
  KEY `roles_updated_by_admin_users_info_id_index` (`updated_by_admin_users_info_id`),
  KEY `roles_deleted_by_admin_users_info_id_index` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `roles_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `roles_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `roles_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `seo_settings`
--

CREATE TABLE `seo_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `page_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `seo_settings_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `seo_settings_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `seo_settings_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `seo_settings_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `seo_settings_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `seo_settings_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seo_settings`
--

INSERT INTO `seo_settings` VALUES (1,'home-page','Home','This is golchha green energy home page',1,1,1,NULL,NULL,'2025-07-08 02:35:53','2025-10-27 08:02:45');

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

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

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

INSERT INTO `sessions` VALUES ('0lEOGe9kFltpNlleaBSgASG8X0RYrXwIabhC6ukR',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTTR2dUNKTG1nSnRIOW1weGNxOGJQalBaODhZUUI4czlJMzVOU1FhZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785282778),('0m2OOhQXfGytabpfT7AkSe9jEaPZavv5Oz3c9fVB',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWlBUUzZyVkE1bjZjMTNZVTFJWWFSeWlxaHFKV0QwcmZjTUlVRTVWZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785050669),('0ViZ7VdHgqDQaXdgShUTxZbDzMKRfmUkJTHD9JGh',NULL,'162.158.235.167','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 CloudflareWebScanner/1.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUmpydmZHR1IwUHJnYTZQVWFzWXp5anVXUXczWHF2YWpGZ0pTckFvNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785040516),('0wbofoz6RM4GVNnfiIg9InUBQzz0mvKjNcKhzYNv',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiS2VLaHV0UVZKcmhyM25BSWxla2N2WWRxSDRVNkVVNDVGN3FXeGtGciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785322780),('0Z1I7JP8V86QUwi1MpreTF7zGgdCuqPSf7bm63XS',NULL,'162.158.235.168','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSzg0NmR6T0UxeXhndGxVaXBncDZmaVBISzFLZVdrU1dERWZYcTZ1aSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9qZWN0Ly5lbnYiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1785173380),('2Zg2N8P8SZ7IprUGkTIGGE8QJSVvKMaIPYngknWw',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiREptQjVCV0tqSHFxQW9ubnROT09aYnlLR2hIU2RhNzQ2dnVCTE15WiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785052513),('39l5HxloTbKsj6ApfShF9bforQfEiMWlb6AvPd6r',NULL,'162.158.235.168','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNVlRcVk2bEpXcFVyTktadDlIZDkyeDBkQmhjbW1PT1B3alQ1OHdDMyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785234273),('3gnPJhDYwvG06s9hRAhoCx46I6fRpNTffQcsuy4b',NULL,'66.132.195.98','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoieWR1TXh5clROQ1EzSUFCOVhtc1lDR1EzOGtTUVJsUzFmYVY4MUh6WSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xNzIuMjM2LjE4Ny42My9nZ2UvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785077498),('3nFTxKjAPfrvoP49dnd7rz16nX1ST4dA8vtzDNIz',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVFVmQjZDaXJ2ZDF4aTV4dE9KUW5ROVluU1ZhQWFEbGVvVU4zT2FMNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785069856),('3tM0fxbP4Olje0bTGn3q0m9v24y0GruhmxThn1Dc',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNFYzT1NValdBb1ZVNGhqSjhXc0RINFVwdnpKSnpEcVRWZWxvbGFKZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vZ2dlLmNvbS5ucC9hYm91dC11cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785282778),('3wUSKfnUUrsqtzEu7BHEmFc7MwxPHxtM9nZp04cH',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOERtRmtmSmFWa29iWFlUYWxjSkVxRHdsUFM1cnplZ09mN250ZTJhaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785241724),('4hC8FctU6KlDx7mqxpRvrl53WKq9QUvy063E961u',NULL,'162.158.235.168','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 CloudflareWebScanner/1.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRk9vYnJkek5PeHNBZ2dpRU1DelZ3WjhncktORnJ1VDhWZTMwT2RPWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785311077),('4vCJxk5UpwS0IC9XCqbs5fmOfN0wMTVf7LtsEeN1',NULL,'162.158.235.168','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 CloudflareWebScanner/1.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRjdmVzg4U2sxZmo2Ymd2TG9zWVlUaEt2dkg2SnlmYUJDV1pXeE5PdSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785050914),('5ZcTBQl9fqMn11wlIhrPB6JNoOpdFdgwB11YgXBT',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoidnZRQVdMazhOdlpJbnRTVVlDMnlmam9jUjJlUDBQQ0ptTURCbTlpNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785056104),('64eC2CzC8vnDLeYaEiIIgU2z2orcgG1RmNAqyzNj',NULL,'162.158.235.167','Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; Touch; MASEJS; rv:11.0) like Gecko','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSlJOUDY0b1RqbHJ2VEpzY25ldHpJT0ZibnZ3N2xWYlBPR3F4Z1F2QSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785117507),('76ZChSlAQ00U9xqbny9R57Jjwo3GEU74cs2JYmRC',NULL,'162.158.235.168','Mozilla/5.0 (compatible; MJ12bot/v2.0.5; http://mj12bot.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ21rNk1DeVRJMXFWTEFiRzI0cGpFbWRqaXBmNGpMYjF5YnZGOXpRVSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785104889),('8lVf0d4XCgLUxMLRD1Sum6xBfLKzJMahk0oLnXpw',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoianRMNGxaRnV3MDNVUEhuOW1VWHZPbGhycGFTdGxrZnhENGdpYThlaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785205954),('8yvOWUDBO3sqFaSanfZOjOfY5wV7pPRBAKF9lGkc',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoidnhTR3VIaU9yVGUwS2ZFRnhzTTd2eXplZUxCWElCTTlha0tLTGR1SiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785113313),('9STLAX8JP8wF3xcc0bZJJWJ5oN2oCZkc6Va0D0eW',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSnNoRXRTVWZyZG1UYWVZTTA2ajJvSzRvR3NJcU9aZFVvMENpNWJpcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785162518),('9yTawB5ySmJX8bteaBIOC2TFQwbVtYpVsMDH6VvT',NULL,'162.158.235.168','Mozilla/5.0 (Linux; Android 12; SAMSUNG SM-A415F) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/23.0 Chrome/115.0.0.0 Mobile Safari/537.3','YTozOntzOjY6Il90b2tlbiI7czo0MDoidXpkOHhmYzhsRk9aYWRiTGRSTFRoSVkzdVp6SEdGUVdHenlPaE9ISSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjM6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9kdWN0L3NvbGFyLXdhdGVyLXB1bXBzLWlycmlnYXRpb24tc3lzdGVtcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785309242),('A382XofvAV36cVAr1sNE9hVsdWSQkOMoJCqVU0Mr',NULL,'162.158.235.168','Go-http-client/2.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoibXc2UzlVNEZROWdZeTFtNGEzTVhCaDFPRU9QQkF6b3Jnc05yNDFpQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785194503),('a67HIIKjUvdo5uwqZ6zXSa3xIas2bmre0tqXWW19',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiekpUZmhnZW5PRjFLY3FrYmg1dmhzbXdXRGhHaUNZYVh6eWNaSzZZZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785076303),('aD5w7c3IDGZrtzDKzbejECYj6hhWbFIhp9e6zNuI',NULL,'162.158.235.168','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36 (compatible; +https://developers.cloudflare.com/security-center/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVWhjUmdxazNZNWhHeG9vOGs5M2lMT1pFVWVza3diM3BmRE5yenBhNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785136319),('akOpR7MKJ3RpaQiX1tMfDVvBWuH0JAntzfGs6VTq',NULL,'43.165.2.110','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiakd6UUlvSVNZTm8zdFZBZ0FhbUNqcE5uQkM4dVk2R2xDZjZ6ckJBeSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xNzIuMjM2LjE4Ny42My9nZ2UvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785121488),('ar9DawYdwzaEsFBAq4s4oIb16KZGhUe3g31KgeUk',NULL,'167.94.146.52','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTzVocGd3Vk1sQVVCaVg5VThkeVRmdmJaT1gzSUlCWTd1SFhFek9VTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xNzIuMjM2LjE4Ny42Mzo0NDMvZ2dlL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785101261),('AvCKTVOWiHwLDZgBJPIdBa2rtzKlYUEyShQOieqV',NULL,'162.158.235.167','Mozilla/5.0 (compatible; MJ12bot/v2.0.5; http://mj12bot.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSVFSUnZ2WHhWNnF1Q29xTXp5amczSnp5QVFuNmFBUFVCa0pSUk5jdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785168312),('avHNTX63b81MSOjo1bK74UX3GC2IxyxAfbhIWkno',NULL,'162.158.235.168','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoieW9xb0loSkY2RnlHbnpHdkF1WEpoWGs4aTB1N2MyRXhmeXBRNFBkZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785137170),('aWqE0FTDP0qRm3p45TfijS70I4pwXc1OEsugYu2E',NULL,'162.158.235.167','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36 (compatible; +https://developers.cloudflare.com/security-center/)','YToyOntzOjY6Il90b2tlbiI7czo0MDoiVkozZ2xaMmVtUkg4QUtZR2FUN3dpU2ZMYzVSTmZXTFJEUUtDd0xqTyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785136307),('b7ef8HYZLny2cbEK0wGkYMyMUEdFiqUxgjST4zWM',NULL,'173.239.254.232','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:105.0) Gecko/20100101 Firefox/105.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTzdBWUR2Rzg3SXVsZUFBc3BZMFZIdGN1U3FldFBCMGRKaWszZXJTNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xNzIuMjM2LjE4Ny42My9nZ2UvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785160348),('bsVKOejnJINc2RORa0KFtKhUYwcezybWQ5kY6FlF',NULL,'162.158.235.168','Mozilla/5.0 (Ubuntu; Linux i686; rv:121.0) Gecko/20100101 Firefox/121.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMUUxS1JJN1VLb3pNVkJraFdBd2U5YmpiUEYxaUNTZ3RINWlVdEZ4cCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785235224),('Bwyts3NXK0sh3AENxOYv4OG18KWACWMMLH1tUFhP',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN050TWZDUmNoaTQ0SkF4NktoMDd5WERNYzVubVRQUDZpMTZadnlJbyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785211125),('bYc6QA5Rk1DDxA1RbxYFpsuxGRkNC5l7hs6F012f',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQVkzcnExMUFyMTRzMDFQQk9mTjZCRVI1UXZkc3FxS2Q5Q3FJTkVvcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785192705),('cLxuCWkhzDpRq2zjxbL9m5UIjd1u6msoZDiYT7Nk',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSm9lUTA0c2J4VTBSY3NWZUJHaDZrTmxsMkVaRzFrWXhjSFNpUEEyeiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785216860),('comcRcFFpfcvFAbcLBPRjsu1ocDHLesPXq1isUFI',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUExjSHpnbFhDc1N1aG9uOGpOVGNLRm1PN3JtQW9PeHFJcEpRQ1FybSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785266165),('d4bqqspWq5lGtbf77RgLr6FKqYfhpqs0ftCzRJXY',NULL,'162.158.235.168','Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity','YTozOntzOjY6Il90b2tlbiI7czo0MDoidjN6UzA4aTVyNkRKVk9qZE1NbEJKakhQVjVYTzFZMEVQNHU1SzQ5TyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785259932),('dmP6uT4d6hcybza3G8ayDPItmwJWfte3dr0WRuWD',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVzBEZHdvc2w3YW1qMEpVYXBrT2NORkEyeEx4WnZXU3ZsNXBibVdiMSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9qZWN0L2dyZWVuLWVuZXJneSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785111440),('dnK80b5JxuJpOXMZBho3GmrBWr5BbikhJ4BXToSf',NULL,'162.158.235.168','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 CloudflareWebScanner/1.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoia21EaTBleTRBaFBKR2VIMDRXaHI5OWhJS0hYZlN1end6aEwzSUNCdyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785224436),('dsRN8GW1vRfw8O0GwRJ2dspWKrNlPR80f4P8kSCN',NULL,'162.158.235.167','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVURqckRsU1kxM2tMZllMdUNocGpleXlCcld5dVlRRVhZeVVlYXV5NiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785046207),('dTMmVx7g7AYNgFfZ7hUn2JledAGW1NXaSDTwi9rq',NULL,'162.158.235.167','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36 (compatible; +https://developers.cloudflare.com/security-center/)','YToyOntzOjY6Il90b2tlbiI7czo0MDoieWRjbjJLWThzTlBTZXRBVFRHSjFrMzY2UjkwdDlBNkJMYUhBN2t3UiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785136307),('e5PBzYG1E2GOZsA61O6JDeGhLLTmAejM6xmtPIsY',NULL,'162.158.235.168','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 CloudflareWebScanner/1.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZG8wSFQyUEp4eHpaQjBJS0Jja1pNYjBodGRZN2xteEhOV3JGelZrYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785137810),('eiDtljtIvzBoDdKtbrOqqqJqUNFzgDzjaPaSiH1M',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVXUxd3VaNXNBVDc3Z2NGalN1OVFBMlZ4VDBmbXRhb0NURlJjeldISiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjU6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9kdWN0L3NvbGFyLXdhdGVyLXB1bXBzLWlycmlnYXRpb24tc3lzdGVtcy0xIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785282780),('eLk81qr4OrJP2QNz1kufW9U1OWMHzfIj1GFwlK6f',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoieDFSZ20wUHBHV05yT3Zpa0ZtMHdZWTNpd1Q3SEthQzFSZVpPS05RNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785226460),('ExTxSvShJyHJhQV17f05VD6b0dzdOsw8la1ALDTG',NULL,'162.158.235.167','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNWVvZmxJT2hzRjdkM1pQMGR1aDRrVmQ0c0xmdHV5NVJ1S242TG1vSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785218972),('fbs91wui1sc7vdqlItnbuZtDUtafTchDO9VQOXEN',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUmxnaXBpOVBydDQyQlRPVklwbjRZOXU4Z1cxSXZhT0VyNW9VcTBJMSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785302060),('fkMy5d8APq8DAE1Y03YFGgjCTnNyhkwjMak0mffD',NULL,'162.158.235.167','Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.7871.128 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoid3NDVlQ0aG9zdFhTUUpsMll3WkZNVVhYOVhBTVBBQnNmOTY0NXRNRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785055432),('FYLez9WVGIFmwER5CSjZU50gZXiCdixrHnJtPieu',NULL,'162.158.235.168','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0 Safari/537.36 Edg/131.0.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVXdYUzhaM2F1eHg0QmhoWDRnUzRDYmw2dFdXUEZudENJNDR6Z3hCViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785119823),('G8QfjNJytydSVz9dSE9qtFcmuj1OitE6tU8zr5az',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMDZjWDA0b0ptcE0ybURaOEFPSkJXcURxYm1OU1RBSUNXMFRMaER6bSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785151348),('GV7b6ZQ7tUKLtd0FCjsJC1nCcGTTarpDgPhEdgft',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoibnVhczZRYlRVejhLNkhsMDMzSUpoZmpVVEtsNHlEZlBDNXlxcWU2SSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785140286),('gXiatIYiMvflFi8Aa1DZPihxV8vaRqVbpMZ1BVXg',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSUJ5T0NkOFpCWFE1anZvY1NEa2g0OEY2ZDl1U0lRRjgyQmc3MmR0dCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vZ2dlLmNvbS5ucC9jb250YWN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785188443),('H1hpYSQsgdEFr2ZsLLwMjljHQELSsecfXSt08fjQ',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSllyMVI1czZwUFBCMFVrbGp2WlZ2TE1xeDVkR0w0cW85TVVBcnBqMSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785312426),('HI02GdjZ1FuCkGSyggSohBbc1OvzHPZDl5qwp2Fh',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTlRteG9zeXc0QmVqUEE4WDdQUERlSzdDbjlrbEVHbUhteWF6SEk2QSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785064066),('HIVuVbvrOCMwnSmg2KCkBftyCGxMexsezMcNzEdO',NULL,'66.132.172.136','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVkZHblBXQ2pIS0Q5bnlRY1FpUld0Z3gwcHRYdTZaMld5WGhkM2g3MiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xNzIuMjM2LjE4Ny42Mzo0NDMvZ2dlL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785260891),('HvbL6PgKtTSGlSDA41cuJCmMVDsTfc0nYwhXICIp',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUmhCb3pybmNJSjhQa0hFeWVJeXE4a0hKck9wcHEyN2hLVWNBdkd4RSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785090757),('iQarw8n4pci4RIB1KdDcusTW0AtdVdi4HCiSTqdj',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaE1sY25Vc2xxdG9jUTVIU2lSYkpheWU1emtJVVRZREVsRTdVTU1BViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9qZWN0L2dyZWVuLWVuZXJneSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785282780),('IWZJ0DbXvJkDjajKqD1PgA2nOrqp1vGcekKh4M2s',NULL,'162.158.235.168','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiT1BTMDl0TWNORnFhTkVaS0hSUWZKNTJ4M090VmNUQ25XWXo2Zm5NYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785111637),('j6YTkXUqqUHioGKb7EKAjGnRzt2pUl2HlhPo9GPw',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTWlEVWZNYmhKMkxJZENVTGJTVmhIcTRxQXprU1k0RTJFWERxS0xlMyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjM6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9kdWN0L3NvbGFyLXdhdGVyLXB1bXBzLWlycmlnYXRpb24tc3lzdGVtcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785282780),('JbFTIdhUwNyMks9vMv2fTFDTi3FlxuzmGWBbw60G',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoidmdnRW42ZW9RYlRXTzBjd2xxdzNFWDhrcFAzYnRqdkduN3NYQm5NQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9qZWN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785091614),('JdIlaHdb0ce3T2CejUu1aQ8vuL51iU5ZFZHUeu2v',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoibEMxZ09CSFhVQTZhQ1VTR3JGMmRsMmJqM0RndGFnTVhVOUlURTRzVyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785132856),('JmrQWr5OrRIivJ4phzRcohPhbQgOGIxDeB00gJUX',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoid1JJdElDbHRQdm56NW5CQjd4aVMyQXJzTmtjdTNzcHJacUZ5V3hGWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDU6Imh0dHBzOi8vZ2dlLmNvbS5ucC9tZWRpYS90aGUtbmV3LWNsZWFuLWVuZXJneSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785282781),('JQXsUvQFQ5UTRKSM7Lg8CKx7sk67MliL8wmNOAfn',NULL,'162.158.235.167','vuln_scanner/3.0.0 (CVE-2026-4020)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMzBia3htMDhiUG9XcmFublprV1pTRXIydkVqb1VBUGJacXkwMkt0ZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTY6Imh0dHBzOi8vZ2dlLmNvbS5ucC8/cGFnZT1ncmF2aXR5c210cC1zZXR0aW5ncyZyZXN0X3JvdXRlPSUyRmdyYXZpdHlzbXRwJTJGdjElMkZ0ZXN0cyUyRm1vY2stZGF0YSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785186967),('JxqnHJn0D1DMkXqLrkbuTf9DSDag89xxhOUIsSo6',NULL,'162.158.235.168','Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVzFtSnpLNzRrRHJpMjUwVXNaSHF2bU5qdWJoTDRPSkdtUlJFMzJ2NCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785067302),('kjso2bLfHzQvED1YtKIxy8kM6IXT5hIMJFwmsfap',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWmt5QjlydW56eVVVd1ZNbXFpTVZhbFFUZERoUEl5WXZyNXVSeElCUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785051546),('kLfCnA2DFpppjrEaqbWdyoVZ0v217HOE4P61nh2D',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaVgwS0xvR05jR0k5SGNZcmtSZXJzUnRUbURSdkNwc1B2b0d3aVpvRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785079312),('kOxzc7neNAEZDhkE1ugIMXa1z45N1fMYOanbDN9r',NULL,'162.158.235.168','Mozilla/5.0 (Linux; Android 12; SAMSUNG SM-A415F) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/23.0 Chrome/115.0.0.0 Mobile Safari/537.3','YTozOntzOjY6Il90b2tlbiI7czo0MDoianFSQzZFWml4RVd2dDhGVFBMU1Q0OGZ0T2pmbEMwN2ZieTlGdGROaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTc6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9qZWN0L2h1bGFzLXN0ZWVsLWluZHVzdHJpZXMtbGltaXRlZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785309242),('L0ofkiSSjwhh3G9hcnuSUXeg5fPqIoCVM6dKeLDW',NULL,'162.158.235.168','Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoieVI1d2o1SVc2cDRPblVMWHYwVG8xZUlieFRSRWJPMTRrbUQ3WExVSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785204688),('LQkkhaLznyTXCOsdgitczTIXuLYU9XbpeNZtgzTY',NULL,'162.158.235.168','Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTXZVZ0pYeDJDS0ZCZHRPVnBNdzN3SzRnT25GUzViTUFNdHZGYlBOWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785199516),('LR9aLlpsiv74NzQoMcpag3iXWwKflrE2h4yTzN4N',NULL,'162.158.235.167','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoidloxSkZaMmRwaVkwS3F1Y1plWklXUmFObWpRSURsMjBld1NMVUhlOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vZ2dlLmNvbS5ucC9hYm91dC11cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785218153),('lRnITxS9vTPnr5FNWJ0xZeblcRmQZNZRxmZeYHSt',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNDJ1cnRMQlVLaUFlYnFDN2VaQkpqaHM5WFIxWWZ1NHdvUnFiQVZ1VSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785265108),('ltURfWourLfwczWAexDv1xlJTJxlr7Irq9FwHmlG',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMlhlaHZqeE1NQ3RneHcxdzdjaHJkUFZvdFdYc0pjb1UzaVJBVUZwQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785172009),('lV4g0RKeLw4BUz7dB5GprCXk4EGuiwBI2BajF2FB',NULL,'162.158.235.168','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 CloudflareWebScanner/1.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoidkZBWjZkcWFRaFdPS20xWlhNZXhtckY0Ukt5Nk1CVnhJeTFuckdMSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785213310),('m0fblGT1iJeqF3b56VdF2WFxIfl1XWdDZbLMZgXd',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWENqUkJwdUQ3Q1hqTUtTRFZuamd3Q0NFVnl2bmY4TzlRU2lRa1hWbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785152263),('M2VfOJzH2GKPH0g4gKNN4yoFwrDzwrJCLHNGt8sW',NULL,'162.158.235.167','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36 +https://forestengine.net/#opt-out','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV1liMDRkeTlaZHZXaWV0YmxFaURMUjZYUWRoUTFTSU5nSTZEZlRRayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785136995),('MbMijZK8VKSdb1jcDd2xyrti2OCXbbWFFisx8Qmu',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVkJBVFpJTkZhdHZBaUtnOThmalVVaEhNNFFxNlVEZkN6VUZnV01MTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785284784),('MCd2z2hvYOnhaoveUs7Xlx1EbPTAon1zxgVSo99E',NULL,'162.158.235.168','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWjFMU2dmQW54UkFzaVpoM3FzRGtZNmpBbVdkMHBEb21RNklkVXVibyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785298535),('mGT3rwCyoTODdw5TFTyQfk4TF5xHy356HRs88CRw',NULL,'162.158.235.167','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiM2VKOU5XbERJSkNpN1JJNVNKTjhycnJNbkphc1JBa2xsZjRBZXVUNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vZ2dlLmNvbS5ucC9hYm91dC11cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785319643),('mJpo2870SxaIbo0JXvSsBDveQj44KOLQEnjLmD5M',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoicmx1eEt0T1h6WmpxQjRiYm9mOTR6VEJMYzJDbnFIY1pTQTk3V3RReiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785169129),('MklHwj2cbV6CLCwr3VXyUhOLFiYHgFHysUPZgZoZ',NULL,'66.132.172.139','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV1BYRjNQUlJZbldVY2RCWU1sSnBkMEdLRTVwV2g0bjFKa1l3T2o2ZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xNzIuMjM2LjE4Ny42My9nZ2UvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785167132),('MQZ28NWYelqjzP0ZxSsSnzFYZDtkXb3pMmsNLG08',NULL,'162.158.235.168','Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115','YTozOntzOjY6Il90b2tlbiI7czo0MDoibFpRTEU3MER3NmwxREpLWWtHOEVMbWdRUzIyMmhEQnNMWXdIYUhUUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTc6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9qZWN0L2h1bGFzLXN0ZWVsLWluZHVzdHJpZXMtbGltaXRlZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785199517),('MtlnAxqdVPSD9RaoH0Td5hGWGVAeAjok4IBqY8KA',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMEdGc0hYMmYybnM2NGVFeE5tTWlZUm5vdXZzVFhNWHplYUg5NWREdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785147199),('nFbb7uvMX7misZu6XIDDjyIPmdwEbWgtoo42RiC1',NULL,'150.109.230.210','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiT0liWG42cTVrYWkySm52TWQzblN1OUVFUXFJczc1OXFwTGxHVnBzbSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xNzIuMjM2LjE4Ny42My9nZ2UvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785125049),('nkIKLZsUf64oZscHyxYjK37pLXoo2ZLyzGKQOt3x',NULL,'162.158.235.168','','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTlVCZWtTbzRkS0xqaGhnS084bjB4OHRjcjJiTktneDAxeWVtYWlnNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wdWJsaWMvaW5kZXgucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785141344),('nOIzi3wVD1iITHrbrqjPCXwQXxQ99LZFnsi8NjyP',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOXQ1T0xkTGhIMFFGT2E3dkw3Z29WN1llMFg0V3oyejdpcW5RcGRJayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785228688),('Nuo7VILfAwhQvfhJCds9oV1WXRVv2CQsikkLd26F',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTDBDT0lHaENIaVZJczFiN0l2Ykt0d09iODlHOUxoTXRRMWxTTlhzZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785056393),('NWnbhXTGZ0BZbnnsWilG3mLt0UaHYYPIQLfM3cdn',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUVdoNzRSNXhFYkdTVHFUMVV5dEhINWFyZVlRUWdBR1RrNjNoYU9WUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vZ2dlLmNvbS5ucC9tZWRpYS90ZXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785282781),('NYb5Wyii1qu8ThQjVIZMxUh4V3Qce9xZVuZX2o22',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMWxOcGJhSDFNcHJYMEtGV1YxRGZwMm9LMVFEQnVKRDRvZm9nRHpFTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785036017),('OBwUxmjQX9Uvxtmi1IWDs8ubEUG8URUR9nVk8rSo',NULL,'162.158.235.168','Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUm9qV09QQzR3R1REU09DS3g1WWlQZzBNRndLU3JRN0hUeUdva3ZuOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjU6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9kdWN0L3NvbGFyLXdhdGVyLXB1bXBzLWlycmlnYXRpb24tc3lzdGVtcy0xIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785199516),('OPEokKlUJMiVJSJYc9ILxTcqz2aPcMQf3uJZuFml',NULL,'162.158.235.167','Pandalytics/2.0 (+https://domainsbot.com/network-crawler-pandalytics-kdc68dhsbd/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoibzBqd0pTWlIwSkRtcUVMQUdsS1RiaWdpNDZCVDY5UkYxUHF1OThvZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785175177),('OUNJblIhzqIXH2eaXZfK7DOxPwEzleCxIDc1O8Tn',NULL,'162.158.235.167','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 CloudflareWebScanner/1.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRXVUTWY5R2pDTDdBTkdadFl4SkRLVldFOTRkbnlYUW13ZmswUkdUZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785299767),('ov3mkZHnrcel2mRejNYrEXhq0hEDLQFMQLfiCGyG',NULL,'162.158.235.167','Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZmdmdXF2VFBvRTd3TFB2NWw0eG56U1lFTXpvV3U5YlFTVVFSQmdUYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785252926),('p3AgNufhjQ5w8WP66EsRif689VrkIB4ArtkZakcf',NULL,'162.158.235.167','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoic0o1OGFuVnZtamVibWthMXI4OWVacWM3UFN5aklZWFZsb0dWOFJLSCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785069449),('p6Dx3E7eymuUXjUelXm018XxFBOCfJZUHlgonuxL',NULL,'162.158.235.167','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSGFrRTVMckxvOWZoS3c2M1h6Q1dNTkQyMEUxcUpMVjF1OGY5cHh5RyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785313466),('P8hWXvR0A0zWaxKMriWJ8QPChBEqmMkpgo6JMMFA',NULL,'213.32.122.82','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2228.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMWFsN2NhWVpCSU02TnkyY1VPM0RqSTNlVndmdG13enNPSVlNamlzNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTc6Imh0dHA6Ly8xNzItMjM2LTE4Ny02My5pcC5saW5vZGV1c2VyY29udGVudC5jb20vZ2dlL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785320122),('pHtDpmvS5FiFOHoXzMlpjXsV6TdAKNNzuAtwnjL5',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUWQxNjRUeWJucEhBeFRsUGw0QkE2YmVhRkFKOEtpQ1JCZlZlczZhUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785264904),('PLOK1ONhxveFD38tkvfdR4Qkd6AqvbAwWjPki8Rz',NULL,'162.158.235.168','Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)','YTozOntzOjY6Il90b2tlbiI7czo0MDoia2FjY0lIamN2SDFKcFhHZnJNQm16WE56cmMxYmhkQVNkdGFQZ1BIcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785261576),('QdJrPLCQw419s9AnSNSp0u0TsKm2l6orp3GaJXqK',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWm5oTmltRG14YlA0RVRoYmg0Tm1Ba0JyVjlZNHdVd3dBOWRlQ2FwRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vZ2dlLmNvbS5ucC9jb250YWN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785154778),('qEP5U7kkhiSfvgk3XUsoJQ2KofDYoDdfK0gcuNsF',NULL,'162.158.235.167','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2pvQnJ5cmcyYVgyTnZ1MVhQQmI0NUJxc1JtNkN5Ujhrbnd5dmlIVSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785240879),('RfWxwyaIV1AU9GTeqN4GqQF1HI3zzTtjWHJOBh4v',NULL,'162.158.235.168','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTHB4UzhRVVhkanpWY1V4SjJlbzZlWTBpQUtZTXdkeURicjMyV0dpcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vZ2dlLmNvbS5ucC9hYm91dC11cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785301834),('rqJ67sxZfSdd44Kz7njGeQULrCvqk1UYyN5npfJS',NULL,'162.158.235.168','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/150.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoieUNISmFBSUhrOVpMdkdsVlBNSWVYU1o2cW0zUDQxaGpuSjhyU29DayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785194504),('rxF2pMgxHgvZXH3oLXL8PrWNOEnerIVy0ztVx6wf',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUExKWmlDRzZrMzBRWWI1ZUtlN1ZhMVhnQW5RbXVSOG9RTENDb1ZJQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vZ2dlLmNvbS5ucC9jb250YWN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785251051),('S2zmXa8xaS1UgAj5Pm8927BHhGJeSpIMu9He86B1',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTU1KdVRXbTRHa2FSR2FuZXJLeGRPd2pld1d0ZXBmZWlVZ3JUSTdwNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785162518),('S52KRUVHRjtGm4vZOpnnXEv9LlpENNce7dLGbonK',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoidExvSFFrVFVZY1dWYWlnMThwclJPWVVOc0dRTHBQMXB5ZjVGejNsTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjQ6Imh0dHBzOi8vZ2dlLmNvbS5ucC9tZWRpYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785282779),('s76ASSEJNCkxSkWRAL6bZYrhSIjxPQmyjFaJmHSm',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2hrRVAzY2dWejJrczhRbXd1ZDZZT095UUJYV0dCb3hWckRoOHlSVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785050668),('saDGsmatLKXlWwl5QCGZ0mNOvdoR7ZLPtLIG2jMe',NULL,'162.158.235.168','Mozilla/5.0 (Linux; Android 12; SAMSUNG SM-A415F) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/23.0 Chrome/115.0.0.0 Mobile Safari/537.3','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTnlMT1JzdW9sNVJTWE1mNFM0N2tnZndTbjdJNDVSWEhMamVXclh6OSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjU6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9kdWN0L3NvbGFyLXdhdGVyLXB1bXBzLWlycmlnYXRpb24tc3lzdGVtcy0xIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785309241),('SHRzncuZmjAYWe075aWweD498vzvByQjxfZiuwAU',NULL,'162.158.235.168','Ruby','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUlJTSWxFN2RQTkhNbWlpcWlSeDcyTGRLQk9SVmtTSVhMeDlCT1JRMSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785147345),('t03uxbnJkb4LcKWc2fyqgQqexI41Mzlv6emGSfgv',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.5 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoibXNxM2VEcWs3Y1V6ZnlkRUVJZGN2TExBQnFsMjNud2pReExtR3FyTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9qZWN0L2dyZWVuLWVuZXJneSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785293494),('tGAViGNkIlJT54dThdJWjTJFKHmOaNI350rN2joh',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV1I4WDl5eGlOQXRnUXBtZDhxdXVJWDU0U3Uzd3k4cUFyZFN4MGZaSiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785255217),('tND26s8uoDJjnSuHF7vtjFqLBQbJxjvxGUnwWX9W',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWXZ6dzlmOUxjMkV5ZHl2b2VOS3Vsc3c5aFRGcFowV0ZJVFBIMmdUaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785122644),('TqyvHUH0AHK9wgnrOBnyaHJh8DgA9ZsCdQH6NT3r',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoib1lVVjB4NkJnNzJMQmEwaHEyenF3V1FTdTUybzZaOTFSNkxwckZ6aSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785160110),('trCt7OeQ93I4TsWhV6emiylCVpVUzWW8dOfv8ibk',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiU0hINWNnUzUyVjNQTUZUZm1OS1JmSldRZzhFVzZ0WlE3TjdwNWNsZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785167334),('tStaQpAhHNQgcjnzV6aj5aNIuw0ZsbOMvwVLDQM9',NULL,'162.158.235.168','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.4419.92 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoidGh0Z2lXUm1xd2Z0UUdIY3VMWmE3ZW1DZUhNMUpHbExmRDZUMlF0UyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785119820),('uB1UQQqJrJjnmAKrq1LlqVbIxwLTz77YbDwGafBr',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTlIydmZ2WGF3RG1XcFhodkZHcnpDSkZVUHVIV0ltWUNwdDYwS25oWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vZ2dlLmNvbS5ucC9hYm91dC11cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785172488),('uhfSxsbGKn27aHayTuW25oOoKNq6jyndTmy2ARlS',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTnBWTFRNVHFjU2I2cm1ONlhkNk1qZU5xMlcwVEdKSkxsalVNNUZkeiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9qZWN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785282779),('ujh2b1K8TzN6mM8VqmAnhhzBTnxYiSj7rdI0fKxm',NULL,'162.158.235.168','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 CloudflareWebScanner/1.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRkZBdTluUEplVTdzN1hjMWVxbmNKSGM2R3NSeE1LcTdaaFBaakdHcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785126768),('um6LbyFgSjWq3Ev3Jyb4PCWmxrKZCWuekB3Hb52u',NULL,'162.158.235.168','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.1 Safari/537.36 Edg/130.0.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTDNrNWQ3eGFTUFBDWURtRlhEY0xLeERwQ3FDd0VPSE1nT01Ua3ZvNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785119815),('UOoC7d6kSM8qWT7UJQOPfjcw7wvASsWYKxzEIupS',NULL,'162.158.235.167','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ0U2OW1Fd0s0aWVnZFVKaFBvUEdqeWwwY3hyR1A3ZDM4S1ZBYTBZYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785244825),('UqyWU8FwIJI7SZZG5EpPk35n7exhRPhBXWEnZG1Z',NULL,'162.158.235.97','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36 (compatible; +https://developers.cloudflare.com/security-center/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRVlhbzQxTFFubUhoQUNHSklCcERMT3pIN1VhcHljSmhTV2JtUWR3SSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZ2dlLmNvbS5ucC4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1785136319),('vM6EKhwH7ApgnYP5LDIOG2pVpnNaytd6ZbUx7tbM',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ2JNNVZxS2VWMElRdnRxeVg2YVM4UThqbmFwN2hUaWF2OFZDQThxdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785059177),('WhKU9xtsSknuwudIkIt8luf7PcPfMEmNIRhSOfsa',NULL,'162.158.235.168','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiR0pBYmR0NU02Vlh3SFlPQU1oTk9MSUFIRml2T1ZPT2RBUlI0NDhYRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785064111),('wI4zJlJokPKhqujIB1EpEwzreTNIhQsnHuLrL57I',NULL,'162.158.235.168','Mozilla/5.0 (compatible; GoFastSiteChecker/1.0)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOHNYQmQyMDgwWjRKVnlMVk5lYVNKQ21aMDVkUExhNDd0QTNRcEVwOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785067984),('WmQEkKcjgZUTRCLY3gy5R8H98UkHe5dLEFji3Sb2',NULL,'162.158.235.167','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMnBqQmgyUWFQSlhDWEpabXk5elBkeGNUeEJuaXE1SWYyeGZ6RGpJUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785104244),('wPEyAXXjZjMYAG6jknayVsasraqPKo5akpruXute',NULL,'162.158.235.167','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYjJORGpNTXlkeWJ1MHMxOHRWT2J1WDZFQVJoYWNqaUV4MzlSUzhrNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785159520),('x176HGW3ddVQWGw9xiQjtiwu3Taee4aDLFUbdSlB',NULL,'162.158.235.167','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 CloudflareWebScanner/1.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiM1VtS3pCelRlVkdremtselFEVXhMVjJCVzVOSnNQeWl3UGJTdDVaNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785238577),('x37A81c12eF1CLoHy6YhFTBqu34XaBQ1bR3S1l4T',NULL,'162.158.235.168','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2lvcmdQdkhyVEx0bFR5N3BhT2dCRmJacjR5YUlnRXlCVnpDVjZaSCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785314143),('xDgHLA5JsSaVo6bM0VKFa8zqL8QENEmUoqvDL4nF',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoicXduMndya28yNWZKSEhxamZTU0lXeWM4QVcxVllZTFZGN3NJMzZzQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785288938),('XdJKb6kwgJ4NJ3u1d7CyCEqSMoQxeSqiCXYtJw4u',NULL,'162.158.235.168','Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYjlyMUxySDdaRW9WQ2J5eE1ITG8zeE5zNGpUaHFNbnpRU1o1V3phaiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjM6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9kdWN0L3NvbGFyLXdhdGVyLXB1bXBzLWlycmlnYXRpb24tc3lzdGVtcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785199516),('xhM1lSD7J0Jyodn9PTFAXnL1MMRGtao76bfBdZwU',NULL,'162.158.235.168','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQlprNjhGYWJLMHNVcHY2aE9ReU9vVnFQc2lsUjR2YXpsMmREaUR6bSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785230268),('xtXDUszIAsq2gdYFrdv8pI3vHGps0rRDYDnkJyiS',NULL,'162.158.235.168','Mozilla/5.0 (compatible; DomainScores/2.1; +https://www.domainscores.net/headers)','YToyOntzOjY6Il90b2tlbiI7czo0MDoiMzFjc3kzRERRWFdHTWV6WXBLVzJRaXJXaTV2U3pURHFrMThCQjlIRiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785193349),('XXwKvixDgNsrdnGV9fIbAmQmkBzmsZqjebzzwGzO',NULL,'162.158.235.168','Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRHpEZzgxUkpFMTFSNGdzelQxTTR0R2NtSURnZXhLcXRQN0hTQXJuYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785061887),('Y2I0fGQ8HoQsMHS0c4I4cZbQvoZEeJdCTEZSsaeg',NULL,'162.158.235.167','','YTozOntzOjY6Il90b2tlbiI7czo0MDoidEZpQ0w0UHB5cmhVVXNvb003SlVOWTYzSjBBaWo0N3ZzZWVVWU50SCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wdWJsaWMvaW5kZXgucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785060157),('y35APj1dyMZpcaVQLYgDkDH9Ug8GUPurIcZ5Q6eZ',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoia1NxNkdqNFpjdDRXR1FYdklPSmlzZWZGOWRIejRzSEhhMTVtU1lZRyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785306140),('yGWaWKOSBlfDTlGHS79Il3VoxAfavC2a39qvtQ92',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMDQ3U1BmUTlBQVBWRFhsdHk3bW5hQ2twWVFxNVVxRE5vbXdCQlZZeiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vZ2dlLmNvbS5ucC9jb250YWN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785282779),('yJ4Mv4nunOFupMHHEkO8FWpOsouhTtFBANkcoMdS',NULL,'162.158.235.168','Mozilla/5.0 (Linux; Android 12; SAMSUNG SM-A415F) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/23.0 Chrome/115.0.0.0 Mobile Safari/537.3','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVTdibmxvSUgxSXN5dTRweEtOb0R4UEdyODYySzZFc0dlTG83ZVlCQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785309241),('YnUk6qQyfgd4jvlG6YbXL5hTEElmnKDDbcA1cHqT',NULL,'162.158.235.168','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoicjFhRk1rcWxqaGg2UzdkRk9sWnFhV0JtemNVTDBwNGthV3o4eHBPYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785089461),('Yr5CJvVJtKlwcp9eXi8rICslKmcUUUMTeLZfrYoM',NULL,'167.94.146.55','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiY2pzOGttbkVrMGU4WjJzS3BVaHd6a1ZRaDNPclJhb2FxZWZwQzZGOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xNzIuMjM2LjE4Ny42Mzo0NDMvZ2dlL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785173064),('ZDuD8n2oqHPn7d7E46ycEvymTqvHIcw2UvoMDTCe',NULL,'162.158.235.168','Mozilla/5.0 (compatible; jscrawler/0.1; +https://github.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNU1KY2hBNzJEc0duUXlOVlhEdFNGVVVJQ0VlTlJXbVBqN1hsazA3ZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTc6Imh0dHBzOi8vZ2dlLmNvbS5ucC9wcm9qZWN0L2h1bGFzLXN0ZWVsLWluZHVzdHJpZXMtbGltaXRlZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785282780);

--
-- Table structure for table `site_banners`
--

CREATE TABLE `site_banners` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `site_page` enum('about-us','our-project','media','contact') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `banner_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt_tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `site_banners_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `site_banners_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `site_banners_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `site_banners_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `site_banners_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `site_banners_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_banners`
--

INSERT INTO `site_banners` VALUES (1,'about-us','About Us','/storage/photos/1/banner image/banner.jpg',NULL,1,1,1,1,NULL,'2025-07-02 02:34:30','2025-07-08 05:29:56'),(2,'our-project','Our Project','/storage/photos/1/banner image/banner.jpg',NULL,1,1,NULL,NULL,NULL,'2025-07-08 05:30:09','2025-07-08 05:30:09'),(3,'media','Media','/storage/photos/1/banner image/banner.jpg',NULL,1,1,NULL,NULL,NULL,'2025-07-08 05:30:17','2025-07-08 05:30:17'),(4,'contact','Contact Us','/storage/photos/1/banner image/banner.jpg',NULL,1,1,NULL,NULL,NULL,'2025-07-08 05:30:26','2025-07-08 05:30:26');

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `about_company` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `map_iframe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `facebook` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `viber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tiktok` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` VALUES (1,'Golchha Green Energy Pvt. Ltd','/storage/photos/1/Company Logo/logo-white.png','rajnikant.chaudhary@gge.com.np','Sundhara - Ganabahal, Kathmandu','9801244449','We are helping the world to save energy','<iframe src=\"https://www.google.com/maps/embed?pb=!1m19!1m8!1m3!1d11293.905603827185!2d85.2985648335995!3d27.702384636171463!3m2!1i1024!2i768!4f13.1!4m8!3e6!4m0!4m5!1s0x39eb1941163b2f3f%3A0x36de35d4ba25395e!2sP826%2B88V%20Hulas%20Steel%20Industries%20Limited%2C%20Kathmandu%2044600!3m2!1d27.700812499999998!2d85.3108125!5e1!3m2!1sen!2snp!4v1759987357126!5m2!1sen!2snp\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>',NULL,NULL,NULL,'https://www.linkedin.com/company/golchha-green-energy/',NULL,NULL,NULL,NULL,1,'2025-07-03 00:01:04','2025-10-27 08:01:04');

--
-- Table structure for table `success_stories`
--

CREATE TABLE `success_stories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `full_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_profile_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_order` tinyint DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `success_stories_created_by_admin_users_info_id_index` (`created_by_admin_users_info_id`),
  KEY `success_stories_updated_by_admin_users_info_id_index` (`updated_by_admin_users_info_id`),
  KEY `success_stories_deleted_by_admin_users_info_id_index` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `success_stories_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `success_stories_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `success_stories_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `success_stories`
--

INSERT INTO `success_stories` VALUES (1,'Emily Rodriguez','Sustainability Consultant','<p>Switching to Golchha was the best decision we made for our energy needs. The seamless integration of renewable solutions truly transformed our business. Highly recommended for anyone aiming for sustainability!</p>','/storage/photos/1/person.jpg',NULL,1,0,1,1,NULL,NULL,'2025-07-02 01:47:06','2025-09-02 06:00:50'),(2,'Emily Rodriguez','Sustainability Consultant','<p>Switching to Golchha was the best decision we made for our energy needs. The seamless integration of renewable solutions truly transformed our business. Highly recommended for anyone aiming for sustainability!</p>','/storage/photos/1/person.jpg',NULL,2,0,1,1,NULL,NULL,'2025-07-02 01:49:38','2025-09-02 06:00:53'),(3,'Emily Rodriguez','Sustainability Consultant','<p>Switching to Golchha was the best decision we made for our energy needs. The seamless integration of renewable solutions truly transformed our business. Highly recommended for anyone aiming for sustainability!</p>','/storage/photos/1/person.jpg',NULL,1,0,1,1,NULL,NULL,'2025-07-02 01:47:06','2025-09-02 06:00:52'),(4,'Emily Rodriguez','Sustainability Consultant','<p>Switching to Golchha was the best decision we made for our energy needs. The seamless integration of renewable solutions truly transformed our business. Highly recommended for anyone aiming for sustainability!</p>','/storage/photos/1/person.jpg',NULL,2,0,1,1,NULL,NULL,'2025-07-02 01:49:38','2025-09-02 06:00:54');

--
-- Table structure for table `technology_collaborations`
--

CREATE TABLE `technology_collaborations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_order` tinyint DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `technology_collaborations_created_by_admin_users_info_id_index` (`created_by_admin_users_info_id`),
  KEY `technology_collaborations_updated_by_admin_users_info_id_index` (`updated_by_admin_users_info_id`),
  KEY `technology_collaborations_deleted_by_admin_users_info_id_index` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `technology_collaborations_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `technology_collaborations_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `technology_collaborations_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `technology_collaborations`
--

INSERT INTO `technology_collaborations` VALUES (1,'Trinasolar',NULL,'/storage/photos/1/technology collaboration/1.png',1,1,1,1,NULL,NULL,'2025-07-03 04:49:04','2025-07-06 05:30:40'),(2,'Growatt',NULL,'/storage/photos/1/technology collaboration/2.png',2,1,1,1,NULL,NULL,'2025-07-03 04:49:40','2025-07-06 05:30:51'),(3,'JaSolar',NULL,'/storage/photos/1/technology collaboration/3.png',NULL,1,1,NULL,NULL,NULL,'2025-07-06 05:31:00','2025-07-06 05:31:00'),(4,'Sungrow',NULL,'/storage/photos/1/technology collaboration/4.png',NULL,1,1,NULL,NULL,NULL,'2025-07-06 05:31:08','2025-07-06 05:31:08'),(5,'Solis',NULL,'/storage/photos/1/technology collaboration/5.png',NULL,1,1,NULL,NULL,NULL,'2025-07-06 05:31:16','2025-07-06 05:31:16'),(6,'Longi',NULL,'/storage/photos/1/technology collaboration/6.png',NULL,1,1,NULL,NULL,NULL,'2025-07-06 05:31:24','2025-07-06 05:31:24'),(7,'ABB',NULL,'/storage/photos/1/technology collaboration/ABB.png',NULL,1,1,1,1,'2025-10-27 07:34:11','2025-10-27 07:28:59','2025-10-27 07:34:11');

--
-- Table structure for table `user_activities`
--

CREATE TABLE `user_activities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `model_id` bigint NOT NULL,
  `model_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_users_info_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_activities_admin_users_info_id_index` (`admin_users_info_id`),
  CONSTRAINT `user_activities_admin_users_info_id_foreign` FOREIGN KEY (`admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_activities`
--


--
-- Table structure for table `user_designations`
--

CREATE TABLE `user_designations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `admin_users_info_id` bigint unsigned DEFAULT NULL,
  `designation_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_designations_admin_users_info_id_index` (`admin_users_info_id`),
  KEY `user_designations_designation_id_index` (`designation_id`),
  CONSTRAINT `user_designations_admin_users_info_id_foreign` FOREIGN KEY (`admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `user_designations_designation_id_foreign` FOREIGN KEY (`designation_id`) REFERENCES `designations` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_designations`
--


--
-- Table structure for table `user_permissions`
--

CREATE TABLE `user_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `user_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `user_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 `user_permissions`
--


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

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `who_we_ares`
--

CREATE TABLE `who_we_ares` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt_tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year_of_expertise` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `happy_client` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `solar_power` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `project_completed` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `our_mission_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `our_vision_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `innovator_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `innovator_short_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned NOT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `who_we_ares_created_by_admin_users_info_id_foreign` (`created_by_admin_users_info_id`),
  KEY `who_we_ares_updated_by_admin_users_info_id_foreign` (`updated_by_admin_users_info_id`),
  KEY `who_we_ares_deleted_by_admin_users_info_id_foreign` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `who_we_ares_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `who_we_ares_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `who_we_ares_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `who_we_ares`
--

INSERT INTO `who_we_ares` VALUES (1,'Powering a Greener Tomorrow','<p><strong>Golchha Green Energy (GGE)</strong> is a dynamic renewable energy venture under the prestigious <strong>Diwakar Golchha Organization (DGO)</strong> one of Nepal&rsquo;s most respected business houses since 1934, with <strong>100 years</strong> of trusted legacy in industrial excellence, community development, and nation-building, shaped by the legacy of Diwakar Golchha a visionary entrepreneur who pioneered over 30 key industries in Nepal. His contributions continue to guide national policy and inspire future generations. GGE leads DGO&rsquo;s vision into a greener, more energy-resilient future.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>At the heart of our journey lies a simple yet powerful belief <strong>&quot;Innovation that Sustains&quot;</strong>.It reflects our commitment to cutting-edge technology combined with long-lasting environmental and social impact.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We aim to bridge the gap between economic growth and environmental responsibility, making clean energy a reality for every Nepali home, institution, and industries</p>','/storage/photos/1/about.jpg','test','10+','500+','25MW','30+','<p>To help adaptation of renewable energy solution across Nepal. Enabling a green future through advance solar EPC technology.</p>','<p>To be a trusted solar EPC company in Nepal leading charge in solar projects, EV charging stations and grid-scale energy storage solution.</p>','Top Innovator Award','Recognized for advancing eco-friendly energy solutions globally.',1,1,NULL,NULL,NULL,'2025-07-02 06:40:52','2025-10-27 07:45:44');

--
-- Table structure for table `why_choose_solars`
--

CREATE TABLE `why_choose_solars` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_order` tinyint DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `why_choose_solars_created_by_admin_users_info_id_index` (`created_by_admin_users_info_id`),
  KEY `why_choose_solars_updated_by_admin_users_info_id_index` (`updated_by_admin_users_info_id`),
  KEY `why_choose_solars_deleted_by_admin_users_info_id_index` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `why_choose_solars_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `why_choose_solars_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `why_choose_solars_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `why_choose_solars`
--

INSERT INTO `why_choose_solars` VALUES (1,'Cost-Effective','<p>Lower your electricity bills and enjoy long-term savings with affordable solar solutions.</p>','/storage/photos/1/icon/coss-effective.png',NULL,1,1,NULL,NULL,NULL,'2025-09-02 02:22:49','2025-09-02 02:22:49'),(2,'Energy Independence','<p>Reduce reliance on the grid and ensure consistent power even during outages with our BESS.</p>','/storage/photos/1/icon/energy.png',NULL,1,1,NULL,NULL,NULL,'2025-09-02 02:23:03','2025-09-02 02:23:03'),(3,'Smart Investment','<p>High-efficiency systems with low maintenance deliver strong, long-term returns.</p>','/storage/photos/1/icon/smart.png',NULL,1,1,NULL,NULL,NULL,'2025-09-02 02:23:19','2025-09-02 02:23:19'),(4,'Sustainable Choice','<p>Use clean, renewable energy and reduce your environmental impact.</p>','/storage/photos/1/icon/sustainable.png',NULL,1,1,NULL,NULL,NULL,'2025-09-02 02:23:38','2025-09-02 02:23:38');

--
-- Table structure for table `why_work_with_us`
--

CREATE TABLE `why_work_with_us` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_order` tinyint DEFAULT NULL,
  `active_status` tinyint NOT NULL DEFAULT '1',
  `created_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `updated_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_by_admin_users_info_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `why_work_with_us_created_by_admin_users_info_id_index` (`created_by_admin_users_info_id`),
  KEY `why_work_with_us_updated_by_admin_users_info_id_index` (`updated_by_admin_users_info_id`),
  KEY `why_work_with_us_deleted_by_admin_users_info_id_index` (`deleted_by_admin_users_info_id`),
  CONSTRAINT `why_work_with_us_created_by_admin_users_info_id_foreign` FOREIGN KEY (`created_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `why_work_with_us_deleted_by_admin_users_info_id_foreign` FOREIGN KEY (`deleted_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL,
  CONSTRAINT `why_work_with_us_updated_by_admin_users_info_id_foreign` FOREIGN KEY (`updated_by_admin_users_info_id`) REFERENCES `admin_user_infos` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `why_work_with_us`
--

INSERT INTO `why_work_with_us` VALUES (1,'Expertise You Can Trust','<p>Backed by years of experience in renewable energy, we provide reliable and efficient solar solutions tailored to your needs.</p>',1,1,1,1,NULL,NULL,'2025-07-03 04:30:28','2025-07-03 04:31:27'),(2,'Innovative Technology','<p>We use cutting-edge technology to maximize energy output while minimizing your environmental footprint.</p>',2,1,1,NULL,NULL,NULL,'2025-07-03 04:30:58','2025-07-03 04:31:27'),(3,'Commitment to Sustainability','<p>Our mission is to help you transition to clean energy, saving costs and protecting the planet for future generations.</p>',3,1,1,1,NULL,NULL,'2025-07-03 04:31:10','2025-07-03 04:31:33');


