-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `xcelenergy`
--

-- --------------------------------------------------------

--
-- Table structure for table `abouts`
--

CREATE TABLE IF NOT EXISTS `abouts` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `abouts`
--

INSERT INTO `abouts` (`id`, `title`, `description`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'Alfabet Global, your trusted partner in local and international investments.', 'Alfabet Global is a leading national and international investment company in Bangladesh. We believe in enabling growth and prosperity through quality investments and financing options. Our strength is delivering high value to our clients through innovative investments, deep market insights, and unwavering commitment to quality. No matter what challenges in local markets or exploring the global markets, Alphabet Global is your best partner to achieve sustainable growth and financial success.', '1746345921_WhatsApp Image 2025-04-22 at 4.17.24 PM.jpeg', '2025-03-09 22:44:43', '2025-05-04 02:05:21');

-- --------------------------------------------------------

--
-- Table structure for table `admin_menu`
--

CREATE TABLE IF NOT EXISTS `admin_menu` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL DEFAULT '0',
  `order` int NOT NULL DEFAULT '0',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `admin_operation_log`
--

CREATE TABLE IF NOT EXISTS `admin_operation_log` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `input` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_operation_log_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `admin_permissions`
--

CREATE TABLE IF NOT EXISTS `admin_permissions` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `http_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `http_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_permissions_name_unique` (`name`),
  UNIQUE KEY `admin_permissions_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `admin_roles`
--

CREATE TABLE IF NOT EXISTS `admin_roles` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) 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 `admin_roles_name_unique` (`name`),
  UNIQUE KEY `admin_roles_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `admin_role_menu`
--

CREATE TABLE IF NOT EXISTS `admin_role_menu` (
  `role_id` int NOT NULL,
  `menu_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_menu_role_id_menu_id_index` (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `admin_role_permissions`
--

CREATE TABLE IF NOT EXISTS `admin_role_permissions` (
  `role_id` int NOT NULL,
  `permission_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_permissions_role_id_permission_id_index` (`role_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `admin_role_users`
--

CREATE TABLE IF NOT EXISTS `admin_role_users` (
  `role_id` int NOT NULL,
  `user_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_users_role_id_user_id_index` (`role_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `admin_user_permissions`
--

CREATE TABLE IF NOT EXISTS `admin_user_permissions` (
  `user_id` int NOT NULL,
  `permission_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_user_permissions_user_id_permission_id_index` (`user_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `blogs`
--

CREATE TABLE IF NOT EXISTS `blogs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `date`, `title`, `name`, `description`, `photo`, `created_at`, `updated_at`) VALUES
(7, '2025-03-13', 'Bangladesh Stocks Rise', 'gssdf', 'Dhaka, Bangladesh (BBN) - Bangladesh’s stocks on Sunday extended its winning streak as investors continued their buying spree on large-cap issues amid optimism.\r\n\r\nDhaka Stock Exchange (DSE)’s turnover, a crucial indicator of the market, increased to BDT 20.10 billion on the country\'s premier bourse which was BDT16.06 billion at the previous session of the week.', '1745666296_agriculture 2.jpg', '2025-03-13 00:00:47', '2025-04-26 06:10:21'),
(8, '2025-03-14', 'Walton Hi-Tech Industries reported', 'Lord Liton', 'Company revealed its unaudited financial statement for the first half of FY25 at a meeting held on Monday (27 January), according to officials familiar with the matter.\r\n\r\nDuring the period, its net profit dropped by 11% to Tk304 crore, compared to the same period last year.\r\n\r\nThe Business Standard Google News Keep updated, follow The Business Standard\'s Google news channel\r\nAt the end of the first half, its earnings per share stood at Tk10.05.', '1745666391_1745665436_1940051.jpg', '2025-03-13 00:36:19', '2025-04-26 05:19:51');

-- --------------------------------------------------------

--
-- Table structure for table `carousels`
--

CREATE TABLE IF NOT EXISTS `carousels` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `button_1_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_1_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_2_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_2_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `carousels`
--

INSERT INTO `carousels` (`id`, `image`, `title`, `description`, `button_1_text`, `button_1_link`, `button_2_text`, `button_2_link`, `created_at`, `updated_at`) VALUES
(2, '1741423726_steptodown.com104416.jpg', 'Alfabet Global: Where Investment Opportunities Thrive', 'Invest confidently with us! We are Bangladesh\'s premier investment firm, offering national and international opportunities for sustainable growth and prosperity. Secure your future today!', 'btn1', NULL, 'btn2', NULL, '2025-03-08 02:48:46', '2025-03-08 03:53:19'),
(3, '1741427961.jpg', 'Empowering Your Wealth: National and International Investment Solutions in Bangladesh', 'Alfabet Global offers innovative solutions for national and international markets, driving growth and creating value. Let\'s build your financial future.', NULL, NULL, NULL, NULL, '2025-03-08 03:48:31', '2025-03-08 03:59:55'),
(4, '1741427911.jpg', 'Bridging Local Potential with Global Success: Smart Investments in Bangladesh', 'Invest confidently with us! We are Bangladesh\'s premier investment firm, offering national and international opportunities for sustainable growth and prosperity. Secure your future today!', NULL, NULL, NULL, NULL, '2025-03-08 03:50:10', '2025-03-08 03:58:31');

-- --------------------------------------------------------

--
-- Table structure for table `ceo_messages`
--

CREATE TABLE IF NOT EXISTS `ceo_messages` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ceo_messages`
--

INSERT INTO `ceo_messages` (`id`, `name`, `title`, `photo`, `description`, `created_at`, `updated_at`) VALUES
(2, 'Managing Director Message', '\"Technology prowess to deliver the high quality required in the world. That is the strength of the Xcel Energy brand.\"', '1746518724_Stock Market Investments.jpg', 'At Xcel Energy BD Ltd, our commitment is to deliver clean, efficient, and sustainable LPG solutions that empower industries and communities alike. As we strive to become the leading provider of innovative LPG technologies, we focus on safety, reliability, and environmental responsibility. Our comprehensive range of services-including LPG storage tanks, vaporizing units, regulating units, and distribution headers-are designed to meet diverse industrial and commercial needs with excellence. Thank you for trusting Xcel Energy BD Ltd as your partner in advancing cleaner energy solutions. Together, we will build a brighter, greener future.\r\nSincerely,\r\nMiah Nuruddin Ahamad Apu\r\nManaging Director\r\nXcel Energy BD Ltd', '2025-05-06 02:05:24', '2025-05-06 02:05:24');

-- --------------------------------------------------------

--
-- Table structure for table `company_infos`
--

CREATE TABLE IF NOT EXISTS `company_infos` (
  `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 DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_infos`
--

INSERT INTO `company_infos` (`id`, `name`, `email`, `phone`, `address`, `description`, `logo`, `created_at`, `updated_at`) VALUES
(2, 'Xcel energy', 'info@alfabetglobalgmail.com', '0123456789', '7-9, Kawran Bazar, Dhaka-1215, Bangladesh', 'Alphabet Global is committed to sustainable development and responsible investment practices.', '1746420772.png', '2025-03-08 01:29:56', '2025-05-04 22:52:52');

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `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;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `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;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `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;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `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=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) 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, '2016_01_04_173148_create_admin_tables', 1),
(5, '2025_03_05_093657_create_team_members_table', 1),
(6, '2025_03_06_062800_create_permission_tables', 1),
(7, '2025_03_08_050405_create_company_infos_table', 2),
(8, '2025_03_08_073611_create_carousels_table', 3),
(9, '2025_03_09_095458_create_abouts_table', 4),
(10, '2025_03_11_050815_create_services_table', 5),
(11, '2025_03_11_094111_create_testimonials_table', 6),
(12, '2025_03_12_082445_create_projects_table', 7),
(13, '2025_03_13_045830_create_blogs_table', 8),
(14, '2025_05_04_091835_create_row2s_table', 9),
(15, '2025_05_06_061651_create_ceo_messages_table', 10),
(16, '2025_05_06_085650_create_photos_table', 11),
(17, '2025_05_06_110330_create_videos_table', 12);

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(2, 'App\\Models\\User', 1),
(1, 'App\\Models\\User', 2);

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `photos`
--

CREATE TABLE IF NOT EXISTS `photos` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `photos`
--

INSERT INTO `photos` (`id`, `title`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'aaaa', '1746524400_agriculture 2.jpg', '2025-05-06 03:27:30', '2025-05-06 03:40:00'),
(2, 'bbbbb', '1746524388_1745665436_1940051.jpg', '2025-05-06 03:35:56', '2025-05-06 03:39:48'),
(4, 'wwww', '1746525813-WhatsApp Image 2025-04-22 at 4.17.24 PM.jpeg', '2025-05-06 04:03:33', '2025-05-06 04:03:33');

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `projects` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `projects` (`id`, `title`, `description`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'Project Titan: High-Growth Investment Portfolio Design', 'A strategic initiative to craft tailored, high-yield investment portfolios for clients seeking aggressive growth. The project includes deep market analysis, risk assessment modeling, and diversification planning to align with both short-term gains and long-term financial goals.', '1741771721_steptodown.com104416.jpg', '2025-03-12 03:11:44', '2025-04-17 00:11:12'),
(2, 'Project InsightEdge: Business Feasibility & Market Entry Consulting', 'This project offers end-to-end consultancy for startups and businesses planning market expansion. It includes competitive analysis, SWOT profiling, regulatory compliance, and financial projections—ensuring informed decision-making and sustainable market penetration.', '1745660005_steptodown.com104416.jpg', '2025-04-17 00:15:19', '2025-04-26 03:33:25'),
(3, 'Project Legacy: Wealth Planning & Succession Advisory', 'Aimed at high-net-worth individuals and family offices, this project focuses on multi-generational wealth management. Services include tax optimization, estate planning, trust setup, and legacy preservation strategies delivered with a personalized advisory approach.', '1745660017_steptodown.com104416.jpg', '2025-04-17 00:17:50', '2025-04-26 03:33:37');

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `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 `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'web', '2025-03-06 00:40:26', '2025-03-06 00:40:26'),
(2, 'user', 'web', '2025-03-06 00:40:26', '2025-03-06 00:40:26');

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `row2s`
--

CREATE TABLE IF NOT EXISTS `row2s` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `row2s`
--

INSERT INTO `row2s` (`id`, `title`, `photo`, `created_at`, `updated_at`) VALUES
(2, 'new', '1746352984_1745665436_1940051.jpg', '2025-05-04 04:03:04', '2025-05-04 04:03:04');

-- --------------------------------------------------------

--
-- Table structure for table `services`
--

CREATE TABLE IF NOT EXISTS `services` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `title`, `short_description`, `description`, `image`, `created_at`, `updated_at`) VALUES
(3, 'Consulting & Advisory', 'Alfabet offers expert consulting & advisory services, including investment strategies, M&A advisory, risk analysis, and wealth management. Get tailored financial solutions today!', '📘 Our Core Consulting & Advisory Services\r\n\r\n✅ Strategic Investment Consulting\r\nDesigning bespoke investment strategies to maximize returns and minimize risk, tailored to your financial goals and market conditions.\r\n\r\n✅ Market Research & Risk Analysis\r\nUsing data-driven insights and advanced analytics to identify market trends, opportunities, and risk factors before they impact your portfolio or business.\r\n\r\n✅ Mergers & Acquisitions (M&A) Advisory\r\nExpert end-to-end support for cross-border deals, business consolidations, and strategic acquisitions, including valuation, due diligence, and integration.\r\n\r\n✅ Wealth & Portfolio Management Advisory\r\nHelping high-net-worth individuals and institutions build and manage diversified portfolios with a focus on performance, security, and sustainability.\r\n\r\n✅ Business Growth & Expansion Strategies\r\nAssisting businesses in identifying new markets, strategic partnerships, and global expansion opportunities with minimal risk and maximum ROI.\r\n\r\n💼 Why Choose Our Consulting & Advisory Services?\r\n\r\n🌍 Global Perspective: Access to a worldwide network of experts and markets.\r\n\r\n📈 Performance-Driven Strategies: Focused on sustainable growth and measurable outcomes.\r\n\r\n🧠 Industry Expertise: Specialized knowledge across finance, technology, real estate, and more.\r\n\r\n🤝 Personalized Support: Tailored advisory built around your goals, risk profile, and industry dynamics.\r\n\r\n🔍 Transparency & Integrity: Trustworthy advice with clear, actionable recommendations.\r\n\r\n👤 Who We Work With\r\n\r\nBusinesses & Corporates: Looking to expand, merge, or optimize operations.\r\n\r\nStartups & Entrepreneurs: In need of strategic direction and investor readiness.\r\n\r\nInstitutional Investors: Requiring data-backed portfolio strategies and market insights.\r\n\r\nHigh-Net-Worth Individuals: Seeking wealth preservation, growth, and succession planning.\r\n\r\n🚀 Achieve More with Expert Advisory\r\n\r\nWhether you\'re navigating market uncertainties, planning a merger, or seeking long-term financial growth, our Consulting & Advisory Services provide the clarity and expertise you need to move forward with confidence.\r\n\r\n👉 Contact us today to schedule a strategic consultation. Your success starts here.', '1745235937_Business & Financial Consulting .jpg', '2025-03-11 00:16:14', '2025-04-21 23:34:27'),
(16, 'Global Investment Solutions', 'Discover expert-driven global investment solutions, including risk management, portfolio diversification, and strategic financial growth. Optimize your investments today!', '🌍 What We Offer in Global Investment Solutions\r\n\r\n✅ International Portfolio Diversification\r\nGain exposure to equities, bonds, real estate, and alternative assets across developed and emerging markets. We balance your investments to minimize volatility and enhance returns.\r\n\r\n✅ Risk Management & Geopolitical Analysis\r\nWe provide real-time insights into currency risks, political developments, and regulatory environments, ensuring your global investments are protected.\r\n\r\n✅ Access to Emerging Markets & High-Growth Sectors\r\nFrom Asia-Pacific to Latin America, we help clients identify fast-growing industries such as technology, clean energy, and infrastructure.\r\n\r\n✅ Sustainable & ESG Investment Strategies\r\nInvest responsibly with ESG-aligned opportunities that offer both ethical alignment and strong performance in the global market.\r\n\r\n✅ Tax-Efficient Cross-Border Investment Structuring\r\nOur tax experts ensure your international investments are compliant and optimized for tax efficiency across jurisdictions.\r\n\r\n✅ Advisory for Institutional & High-Net-Worth Investors\r\nWe specialize in creating custom strategies for institutional investors and HNWIs, offering exclusive access to private equity, hedge funds, and global ventures.\r\n\r\n💡 Why Choose Our Global Investment Solutions?\r\n\r\n🌐 Global Network: Direct access to markets in North America, Europe, Asia, and emerging economies.\r\n\r\n📊 Data-Driven Insights: Deep analytics and forecasting to guide your strategy.\r\n\r\n🤝 Personalized Advisory: One-on-one investment consultation based on your goals and risk appetite.\r\n\r\n🔒 Compliance & Security: Every investment is thoroughly vetted for legal and financial safety.\r\n\r\n🧭 Who Can Benefit?\r\nInstitutional Investors: Pension funds, insurance firms, and family offices seeking strategic asset allocation.\r\n\r\nHigh-Net-Worth Individuals: Looking to build or expand a global investment portfolio.\r\n\r\nCorporates & Entrepreneurs: Expanding operations or capitalizing on international growth trends.\r\n\r\n📞 Start Your Global Investment Journey Today\r\n\r\nTake the first step toward international wealth growth and financial freedom. Partner with us for Global Investment Solutions that deliver results beyond borders.\r\n\r\n👉 Contact us today for a personalized consultation.', '1745236260_steptodown.com567106 (1).jpg', '2025-03-11 03:19:47', '2025-04-21 23:32:18'),
(17, 'Investment Services', 'Discover expert investment services, including portfolio management, risk analysis, and global diversification. Optimize your wealth with tailored financial solutions today!', '💼 Our Core Investment Services\r\n\r\n✅ Portfolio Management\r\nCustomized portfolios built with a mix of equities, bonds, real estate, and alternative assets to maximize returns while managing risk.\r\n\r\n✅ Wealth Management\r\nIntegrated solutions for high-net-worth individuals focused on asset preservation, growth, tax efficiency, and legacy planning.\r\n\r\n✅ Financial Planning & Advisory\r\nHolistic investment planning that incorporates life goals, retirement strategies, education funds, and estate considerations.\r\n\r\n✅ Retirement & Pension Planning\r\nStructuring long-term retirement solutions with steady income generation and tax-optimized withdrawal strategies.\r\n\r\n✅ Alternative Investments\r\nAccess to exclusive investment vehicles including private equity, hedge funds, venture capital, and digital assets.\r\n\r\n✅ Real Estate Investment Consulting\r\nResearch-backed property investment strategies for residential, commercial, and international markets.\r\n\r\n✅ ESG & Sustainable Investing\r\nAlign your investments with your values through environmentally and socially responsible portfolios.\r\n\r\n📊 Why Choose Our Investment Services?\r\n\r\n🎯 Goal-Oriented Strategies – Every plan is personalized to your lifestyle and financial objectives.\r\n\r\n📉 Risk Management – Minimize exposure with sophisticated risk assessment and diversification.\r\n\r\n🌍 Global Market Access – Invest confidently across international sectors and asset classes.\r\n\r\n🧠 Experienced Advisors – Work with professionals who understand the market, the economy, and your needs.\r\n\r\n🔒 Fiduciary Commitment – We prioritize your interests in every decision.\r\n\r\n👥 Who Benefits from Our Services?\r\n\r\nIndividuals & Families – Seeking long-term wealth, education planning, or retirement security.\r\n\r\nHigh-Net-Worth Individuals – Requiring bespoke portfolio strategies and estate planning.\r\n\r\nEntrepreneurs & Business Owners – Looking to grow and protect their wealth post-exit.\r\n\r\nInstitutions – Seeking expert investment consulting for large-scale funds and endowments.\r\n\r\n🔧 Our Investment Approach\r\n\r\nDiscovery – We understand your goals, risk tolerance, and timeline.\r\n\r\nStrategy Development – Tailored investment planning based on market data and economic trends.\r\n\r\nImplementation – Your capital is allocated across asset classes for optimal performance.\r\n\r\nMonitoring & Adjustment – Portfolios are actively managed and rebalanced to stay on track.\r\n\r\n📞 Take Control of Your Financial Future\r\n\r\nWith [Your Company Name] as your trusted advisor, you gain more than just returns—you gain a partner committed to your long-term success.\r\n\r\n👉 Schedule your investment consultation today. Let’s grow your wealth—strategically.', '1745236321_Private Equity 1 (1).jpg', '2025-03-11 03:21:25', '2025-04-21 23:36:20');

-- --------------------------------------------------------

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

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

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

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('E3f36BQfikv5r6l6fB0eqNa7zwgTRsS61dVeebIP', 2, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoicWlzYWhDeDVSMEExQkVOZmNJcElOTDhpcUV2SkNJOVlzdlpLOVZKcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC92aWRlb3MiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToyO30=', 1746604867),
('vwLNwn2fXRbzwALBGuRycXcd6obptZjQdqEwnTsR', 2, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiN0JLcVIzTVIwdGR1T3V3UHRyeUlxeFM1S3M3bWhMczV6cWZtbktQZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC92aWRlby1nYWxsZXJ5Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Mjt9', 1746534298);

-- --------------------------------------------------------

--
-- Table structure for table `team_members`
--

CREATE TABLE IF NOT EXISTS `team_members` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `team_members`
--

INSERT INTO `team_members` (`id`, `name`, `position`, `image`, `created_at`, `updated_at`) VALUES
(2, 'Foysal', 'Managing Director', '1746531554_1576864886.jpg', '2025-03-07 22:25:38', '2025-05-07 00:43:38'),
(3, 'jahirul', 'Chief Executive Officer', '1746531566_1576864886.jpg', '2025-03-07 22:54:47', '2025-05-07 00:43:52'),
(5, 'musah', 'developer', '1746600265_1576864886.jpg', '2025-05-07 00:44:25', '2025-05-07 00:44:25');

-- --------------------------------------------------------

--
-- Table structure for table `testimonials`
--

CREATE TABLE IF NOT EXISTS `testimonials` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `profession` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `profession`, `description`, `photo`, `created_at`, `updated_at`) VALUES
(2, 'Md jahirul Islam', 'Digital Marketing', 'Alfabet delivers expert Consulting & Advisory services, empowering businesses and investors with strategic insights, risk analysis, and tailored financial solutions for sustainable growth.', '1745235098_man-avatar-profile-picture-social-media-vector-illustration-eps10_268834-1894 (1).jpg', '2025-03-11 04:05:31', '2025-04-21 05:31:38'),
(3, 'Hossain Mohammad Sadi', 'Digital Marketing', 'Alfabet provides strategic consulting and advisory services, helping businesses and investors navigate complex markets, optimize growth, and mitigate risks.', '1745235109_man-avatar-profile-picture-social-media-vector-illustration-eps10_268834-1894 (1).jpg', '2025-03-17 00:09:15', '2025-04-21 05:31:49'),
(4, 'Sylas', 'Digital Marketing', 'Alfabet delivers expert Consulting & Advisory services, providing strategic insights and risk management solutions to help businesses and investors maximize growth.', '1745235117_man-avatar-profile-picture-social-media-vector-illustration-eps10_268834-1894 (1).jpg', '2025-03-17 00:13:01', '2025-04-21 05:31:57');

-- --------------------------------------------------------

--
-- Table structure for table `videos`
--

CREATE TABLE IF NOT EXISTS `videos` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `title`, `video_link`, `created_at`, `updated_at`) VALUES
(2, 'aaaa', 'https://www.youtube.com/watch?v=RzABWy52ofc', '2025-05-06 06:24:55', '2025-05-06 06:24:55'),
(3, 'shakib khan', 'https://www.youtube.com/watch?v=jXv5owNTPKc', '2025-05-07 00:59:21', '2025-05-07 00:59:21');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

