-- MySQL dump 10.13  Distrib 8.0.45, for Linux (x86_64)
--
-- Host: localhost    Database: golcha
-- ------------------------------------------------------
-- Server version	8.0.45-0ubuntu0.24.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

DROP TABLE IF EXISTS `admin_user_infos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `admin_user_infos` WRITE;
/*!40000 ALTER TABLE `admin_user_infos` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `admin_user_infos` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `admin_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `admin_users` WRITE;
/*!40000 ALTER TABLE `admin_users` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `admin_users` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `bess_overviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `bess_overviews` WRITE;
/*!40000 ALTER TABLE `bess_overviews` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `bess_overviews` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `besses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `besses` WRITE;
/*!40000 ALTER TABLE `besses` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `besses` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `contact_overviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `contact_overviews` WRITE;
/*!40000 ALTER TABLE `contact_overviews` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `contact_overviews` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `contacts` WRITE;
/*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `contacts` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `designations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `designations` WRITE;
/*!40000 ALTER TABLE `designations` DISABLE KEYS */;
INSERT INTO `designations` VALUES (1,'asdfadf',1,1,1,NULL,NULL,NULL,'2025-07-07 00:33:24','2025-07-07 00:33:24');
/*!40000 ALTER TABLE `designations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `home_banners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `home_banners` WRITE;
/*!40000 ALTER TABLE `home_banners` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `home_banners` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `media` WRITE;
/*!40000 ALTER TABLE `media` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `media` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `media_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `media_categories` WRITE;
/*!40000 ALTER TABLE `media_categories` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `media_categories` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `model_has_permissions` WRITE;
/*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `model_has_roles` WRITE;
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `our_project_overviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `our_project_overviews` WRITE;
/*!40000 ALTER TABLE `our_project_overviews` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `our_project_overviews` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `our_projects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `our_projects` WRITE;
/*!40000 ALTER TABLE `our_projects` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `our_projects` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `our_service_overviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `our_service_overviews` WRITE;
/*!40000 ALTER TABLE `our_service_overviews` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `our_service_overviews` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `our_services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `our_services` WRITE;
/*!40000 ALTER TABLE `our_services` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `our_services` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `our_strategic_alliances`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `our_strategic_alliances` WRITE;
/*!40000 ALTER TABLE `our_strategic_alliances` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `our_strategic_alliances` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `project_galleries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `project_galleries` WRITE;
/*!40000 ALTER TABLE `project_galleries` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `project_galleries` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `role_has_permissions` WRITE;
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `seo_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `seo_settings` WRITE;
/*!40000 ALTER TABLE `seo_settings` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `seo_settings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('7Ka7AqUpTKcG40igdAoTiaoq9xjpsgYRFHinoM81',NULL,'49.51.203.164','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoicW1xYWlzVTI1cUpKMksxSEUxNjMyQUU5VFlrdkVUamNjU2ZCYnJ5UCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777293379),('8Rf6jQFG3VbmmOwT8iRFTRs0AKLLxmEnA177Zaep',NULL,'40.77.167.143','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoibmVFamdIOGVGM0hrYm45MHFtTDBFVTVIRE9Ic011TGVrcjMwWWhsayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vd3d3LmdnZS5jb20ubnAvYWJvdXQtdXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777296880),('BiEzXne5lKgssNogDKlDs7y36SWu9u2ou4THzxeb',NULL,'204.76.203.25','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoicTFIYmJva2tZUHFuV1RiMzhFT0dFV3haOFhHZDRYVk1DYUpMVzI1dSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1777292376),('cZFb0HIW0GmyluhUQA3zJsEUw6Kpgpxg4AqLQFOu',NULL,'87.236.176.189','Mozilla/5.0 (compatible; InternetMeasurement/1.0; +https://internet-measurement.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoia3VwVG4xOG1TVW9GWkp4WVZxaVNNMnlYc3FVM3FrSW0yVnk2NmlaQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777299455),('GsLYlcyNaqTl3RvMlMPgO7wVtuhtQ9IsaatwPAeo',NULL,'79.124.40.174','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYzlVaThKRVNmMEpCczNhSWo1ZVA2Z0huS1dPeU5va3RWNHhzb1FTMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTM6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMvP1hERUJVR19TRVNTSU9OX1NUQVJUPXBocHN0b3JtIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1777293511),('HUgdNgEukBv5FLAhN0532j0ZblUYOOWF8QXDollZ',NULL,'66.228.53.78','Mozilla/5.0 (Macintosh; Intel Mac OS X 13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaWQySm1sNTU3a3pCNGQwQXhZaUIyM0d0RlI2Z2hOcHVyR01IT2VQZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777303885),('JhUGi7d79T4XSG83nfHtNxbiGM4wrViIrbtSmXR1',NULL,'208.115.211.186','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZTNibUNtR3ZqWHBWVnhpTURLcWFQQTBEUHVTTktSeWoxZ3JORTJBYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1777291834),('ksnO0eOnTUuhghdX7OT6Y22gsStch4FpE8tOhhaX',NULL,'131.175.120.42','Go-http-client/1.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoieHRraGhZM1k0c2htUGpEeENsd2VGVkRQQ2MyUU41NzlRZjlJak1TRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777297568),('L8gi7CrlZSxB7S5Joh5BMLmGo6wmjyyBQbnD2PWp',NULL,'115.231.78.11','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.2623.112 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTHk4dFFHdmFoR3lqWlhKdDZqd0lLbEM4UW10RE5VZU1hbHJUZDI3ZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777305339),('nBpJ1sC0mJadMZEhLKQHDvYTvUklKhOBPXQiH2H0',NULL,'43.157.22.109','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRWlDSXQ2UDFXblJ5TUkxODNXWXVmcUhtV2hmOUo4T1RRME05b3lKbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHBzOi8vZ2dlLmNvbS5ucCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1777303882),('ntXbPocU7YL0pCV9YUFx8LxNz8m2TF8t0tkC8ghJ',NULL,'71.6.232.24','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNDhPMHJIVU1lYjF4aDQyQlVDZ20xcUlxSURoSXNZbHB3cnZGMVR4cSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777290982),('pZ4cucLWU9cIbXVmPApxYgq7tRQSCYnGtpybsBx4',NULL,'80.94.95.40','Mozilla/5.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUjZQaUxNcllEckNLN0NkWHZsWE1BRzd6R0k4OVlreERVQTNUOUZRcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NzA6Imh0dHBzOi8vdmVjdG9yZG50bGNybG1ma2NtNGFsbmk3MzR0YmNybmQ1bGs0NHY2c3A0bHFhbDZub3FyZ25ieWQub25pb24iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777302612),('s2HVTxivxeYFNMqs8Vkev3FzI00oHWDq4kCtrLgA',NULL,'104.152.52.230','curl/7.61.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWlp3Z24wRlBJNzBmUEw5RWtqMmZPekkza04zOXo2RWlmdDY0UkFGRCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777304188),('TY2VLxPv41kPectbxL64FkGcb5wkmLbjqKccplsJ',NULL,'172.105.128.12','Mozilla/5.0 (Macintosh; Intel Mac OS X 13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVlZzN2w5MnAzenRtRWUwcHVBdW1BU0ZDQ0M0THE1TWZ0V0w0YWNCTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777303509),('VWTSs1K1RywTOeK4Jzia0FFrcOrGHutYm90MLbRH',NULL,'160.119.76.51','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNTBSSmttWWNhc29YRkg5N2hrSTd4UXVHTFg1Mm1wMFc3SmFXYWZXNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777298173),('whg9ERYDAT54yTpqxdoPaOhFCNf0u1YjIM4hq0xS',NULL,'131.175.120.42','Go-http-client/1.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVDRBelpkaXNucHJJeW9WY3VxUmxnQm1QbWxtTzA5blpOMXV1dnBaSCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777297568),('XNa6mZ55U6QtVCQHgTAPZTvqemVgnRmzpJHYRQ7Z',NULL,'66.228.53.78','Mozilla/5.0 (Macintosh; Intel Mac OS X 13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoibWJNaXNlS2MwMVlUbzhrR2xpbXhKU3JxbXJwaTk2RzVZaDFEUnV6USI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777298133),('Z5VFVQ1XPZYnb0X1991nZe3ribVKwVVK89IAN92l',NULL,'205.169.39.15','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.5938.132 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN0xCQWM2eThHbThCdWNmTlQ0TkpOM0lxdGg0Y1RGSDF5N2NUSHRRMyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777297579),('ZywMDKG3rDXcvUPxuvPN6tBM21RA3tv3tKGYnRUs',NULL,'160.119.76.51','Mozilla/5.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ3RQbVNXNENzdlZrRFlmenYySVBNcmZzYXZoQXE4VGZJMFNxYVZUbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vMTcyLjIzNi4xODcuNjMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1777297714);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `site_banners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `site_banners` WRITE;
/*!40000 ALTER TABLE `site_banners` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `site_banners` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `site_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `site_settings` WRITE;
/*!40000 ALTER TABLE `site_settings` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `site_settings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `success_stories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `success_stories` WRITE;
/*!40000 ALTER TABLE `success_stories` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `success_stories` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `technology_collaborations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `technology_collaborations` WRITE;
/*!40000 ALTER TABLE `technology_collaborations` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `technology_collaborations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_activities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `user_activities` WRITE;
/*!40000 ALTER TABLE `user_activities` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_activities` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_designations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `user_designations` WRITE;
/*!40000 ALTER TABLE `user_designations` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_designations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_permissions`
--

LOCK TABLES `user_permissions` WRITE;
/*!40000 ALTER TABLE `user_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_permissions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `who_we_ares`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `who_we_ares` WRITE;
/*!40000 ALTER TABLE `who_we_ares` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `who_we_ares` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `why_choose_solars`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `why_choose_solars` WRITE;
/*!40000 ALTER TABLE `why_choose_solars` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `why_choose_solars` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `why_work_with_us`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `why_work_with_us` WRITE;
/*!40000 ALTER TABLE `why_work_with_us` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `why_work_with_us` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-04-27 16:01:10
