-- SQL Dump of Mahfuza Corporate Holdings Database Schema & Seeds
-- Database: `mahfuza_corporate_holdings`
-- Recommended Database Name to create in Laragon phpMyAdmin/HeidiSQL: mahfuza_corporate_holdings

CREATE DATABASE IF NOT EXISTS `mahfuza_corporate_holdings` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `mahfuza_corporate_holdings`;

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

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT '',
  `subtitle` text DEFAULT NULL,
  `about_text` text DEFAULT NULL,
  `address` varchar(255) DEFAULT '',
  `logo` text DEFAULT NULL,
  `video` text DEFAULT NULL,
  `about_title` varchar(255) DEFAULT 'Driving Progress Across Horizons',
  `about_feat1_title` varchar(255) DEFAULT 'Innovation First',
  `about_feat1_desc` text DEFAULT NULL,
  `about_feat1_icon` varchar(50) DEFAULT 'bi-cpu',
  `about_feat2_title` varchar(255) DEFAULT 'Global Standard',
  `about_feat2_desc` text DEFAULT NULL,
  `about_feat2_icon` varchar(50) DEFAULT 'bi-globe-americas',
  `stat1_value` varchar(50) DEFAULT '04+',
  `stat1_label` varchar(100) DEFAULT 'Operating Sectors',
  `stat2_value` varchar(50) DEFAULT '250+',
  `stat2_label` varchar(100) DEFAULT 'Expert Workforce',
  `stat3_value` varchar(50) DEFAULT '12+',
  `stat3_label` varchar(100) DEFAULT 'Global Partners',
  `stat4_value` varchar(50) DEFAULT '100%',
  `stat4_label` varchar(100) DEFAULT 'Compliance',
  `companies_title` varchar(255) DEFAULT 'Our Commercial Enterprises',
  `team_title` varchar(255) DEFAULT 'Corporate Leadership',
  `contact_title` varchar(255) DEFAULT 'Corporate HQ',
  `hero_btn1_text` varchar(100) DEFAULT 'Explore Portfolio',
  `hero_btn1_link` varchar(255) DEFAULT '#companies',
  `hero_btn2_text` varchar(100) DEFAULT 'Get In Touch',
  `hero_btn2_link` varchar(255) DEFAULT '#contact',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `title`, `subtitle`, `about_text`, `address`, `logo`, `video`, `about_title`, `about_feat1_title`, `about_feat1_desc`, `about_feat1_icon`, `about_feat2_title`, `about_feat2_desc`, `about_feat2_icon`, `stat1_value`, `stat1_label`, `stat2_value`, `stat2_label`, `stat3_value`, `stat3_label`, `stat4_value`, `stat4_label`, `companies_title`, `team_title`, `contact_title`, `hero_btn1_text`, `hero_btn1_link`, `hero_btn2_text`, `hero_btn2_link`) VALUES
(1, 'Mahfuza Corporate Holdings', 'Accelerating modern engineering, human deployment workflows, and comprehensive technical solutions globally.', 'Our multi-disciplinary business entity operates across tech ecosystems, dynamic infrastructures, modern global operations, and human resource solutions. We build ecosystems centered around premium sustainability.', 'Mohakhali C/A, Dhaka, Bangladesh', 'https://placehold.co/80x80/0284c7/ffffff?text=M', '', 'Driving Progress Across Horizons', 'Innovation First', 'Harnessing advanced operational dynamics to reshape platforms.', 'bi-cpu', 'Global Standard', 'Delivering export-ready skill management globally.', 'bi-globe-americas', '04+', 'Operating Sectors', '250+', 'Expert Workforce', '12+', 'Global Partners', '100%', 'Compliance', 'Our Commercial Enterprises', 'Corporate Leadership', 'Corporate HQ', 'Explore Portfolio', '#companies', 'Get In Touch', '#contact');

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

--
-- Table structure for table `companies`
--

CREATE TABLE IF NOT EXISTS `companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `link` text NOT NULL,
  `img` text DEFAULT NULL,
  `sort_order` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` (`id`, `name`, `link`, `img`, `sort_order`) VALUES
(1, 'Smart IT Solution', 'https://smartitsolution-demo.com', NULL, 0),
(2, 'Mahfuza Overseas Employment', 'https://mahfuzaoverseas-demo.com', NULL, 1);

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

--
-- Table structure for table `team`
--

CREATE TABLE IF NOT EXISTS `team` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `role` varchar(255) NOT NULL,
  `img` text NOT NULL,
  `sort_order` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `team`
--

INSERT INTO `team` (`id`, `name`, `role`, `img`, `sort_order`) VALUES
(1, 'Ibrahim Khalil', 'Chief Executive Officer / Managing Director', 'https://placehold.co/300x300/0f172a/ffffff?text=IK', 0),
(2, 'Rahman Chowdhury', 'Head of Technical Architecture', 'https://placehold.co/300x300/1e293b/ffffff?text=RC', 1);
