-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 12, 2023 at 01:31 AM
-- Server version: 10.5.20-MariaDB-cll-lve
-- PHP Version: 7.4.27

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `eastxzce_demo`
--

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

--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_bn` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `short_description_bn` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `description_bn` longtext DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_des` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `about_us`
--

INSERT INTO `about_us` (`id`, `title`, `title_bn`, `image`, `short_description`, `short_description_bn`, `description`, `description_bn`, `meta_title`, `meta_des`, `created_at`, `updated_at`) VALUES
(1, 'About Us', 'আমাদের সম্পর্কে', 'img/2023/1773996204756676Slider2.jpg', 'Welcome to Habib Electronics: Your Trusted Electronic Services Provider\r\n\r\nAt Habib Electronics, we pride ourselves on being your one-stop destination for all your electronic service needs. With a rich history of excellence spanning over two decades, we have established ourselves as a reliable and customer-centric electronic services provider. From repairs to installations and everything in between, we\'ve got you covered.', 'Welcome to Habib Electronics: Your Trusted Electronic Services Provider\r\n\r\nAt Habib Electronics, we pride ourselves on being your one-stop destination for all your electronic service needs. With a rich history of excellence spanning over two decades, we have established ourselves as a reliable and customer-centric electronic services provider. From repairs to installations and everything in between, we\'ve got you covered.', '<p><strong>Welcome to Habib Electronics: Your Trusted Electronic Services Provider</strong></p>\r\n<p>At Habib Electronics, we pride ourselves on being your one-stop destination for all your electronic service needs. With a rich history of excellence spanning over two decades, we have established ourselves as a reliable and customer-centric electronic services provider. From repairs to installations and everything in between, we\'ve got you covered.</p>\r\n<p><strong>Our Services</strong></p>\r\n<p><em>1. Electronic Repairs:</em> Is your favorite gadget not working as it should? Our team of skilled technicians specializes in diagnosing and repairing a wide range of electronic devices. Whether it\'s your smartphone, laptop, television, gaming console, or any other device, we have the expertise to bring it back to life.</p>\r\n<p><em>2. Appliance Installations:</em> Planning to upgrade your home with new electronic appliances? Our professionals are well-equipped to handle the installation of various appliances, including refrigerators, washing machines, air conditioners, and more. We ensure a seamless setup process to make your life more comfortable.</p>\r\n<p><em>3. Audio-Visual Solutions:</em> Transform your entertainment experience with our audio-visual solutions. Whether you need assistance in setting up a home theater system, installing soundbars, or optimizing your TV\'s picture quality, our experts can help you achieve the perfect audio and visual balance.</p>\r\n<p><em>4. Computer Services:</em> Is your computer running slow? Are you facing software glitches? Our computer services cover everything from hardware upgrades to software troubleshooting. We\'ll get your computer back to its optimal performance, so you can work and play without interruptions.</p>\r\n<p><em>5. Electronic Consultation:</em> Unsure about which electronic products to buy for your needs? Our knowledgeable staff provides personalized consultations to guide you in making informed decisions. We\'ll consider your preferences, budget, and requirements to recommend the best solutions.</p>\r\n<p><strong>Why Choose Us?</strong></p>\r\n<p><em>Experienced Technicians:</em> Our team comprises skilled technicians with years of experience in the field. They stay up-to-date with the latest technologies and repair techniques to ensure efficient and effective services.</p>\r\n<p><em>Customer-Centric Approach:</em> At Habib Electronics, customer satisfaction is our top priority. We listen to your concerns, provide transparent explanations, and offer cost-effective solutions tailored to your needs.</p>\r\n<p><em>Quality Assurance:</em> We believe in delivering quality services that stand the test of time. We use genuine parts for repairs and installations, ensuring the longevity and reliability of your electronic devices.</p>\r\n<p><em>Timely Services:</em> We understand the importance of your time and aim to provide timely services without compromising on quality. Our efficient processes ensure that your devices are back in your hands as soon as possible.</p>\r\n<p><em>Affordable Pricing:</em> Quality electronic services shouldn\'t break the bank. We offer competitive pricing for all our services, making top-notch repairs and installations accessible to everyone.</p>', '<p><strong>Welcome to Habib Electronics: Your Trusted Electronic Services Provider</strong></p>\r\n<p>At Habib Electronics, we pride ourselves on being your one-stop destination for all your electronic service needs. With a rich history of excellence spanning over two decades, we have established ourselves as a reliable and customer-centric electronic services provider. From repairs to installations and everything in between, we\'ve got you covered.</p>\r\n<p><strong>Our Services</strong></p>\r\n<p><em>1. Electronic Repairs:</em> Is your favorite gadget not working as it should? Our team of skilled technicians specializes in diagnosing and repairing a wide range of electronic devices. Whether it\'s your smartphone, laptop, television, gaming console, or any other device, we have the expertise to bring it back to life.</p>\r\n<p><em>2. Appliance Installations:</em> Planning to upgrade your home with new electronic appliances? Our professionals are well-equipped to handle the installation of various appliances, including refrigerators, washing machines, air conditioners, and more. We ensure a seamless setup process to make your life more comfortable.</p>\r\n<p><em>3. Audio-Visual Solutions:</em> Transform your entertainment experience with our audio-visual solutions. Whether you need assistance in setting up a home theater system, installing soundbars, or optimizing your TV\'s picture quality, our experts can help you achieve the perfect audio and visual balance.</p>\r\n<p><em>4. Computer Services:</em> Is your computer running slow? Are you facing software glitches? Our computer services cover everything from hardware upgrades to software troubleshooting. We\'ll get your computer back to its optimal performance, so you can work and play without interruptions.</p>\r\n<p><em>5. Electronic Consultation:</em> Unsure about which electronic products to buy for your needs? Our knowledgeable staff provides personalized consultations to guide you in making informed decisions. We\'ll consider your preferences, budget, and requirements to recommend the best solutions.</p>\r\n<p><strong>Why Choose Us?</strong></p>\r\n<p><em>Experienced Technicians:</em> Our team comprises skilled technicians with years of experience in the field. They stay up-to-date with the latest technologies and repair techniques to ensure efficient and effective services.</p>\r\n<p><em>Customer-Centric Approach:</em> At Habib Electronics, customer satisfaction is our top priority. We listen to your concerns, provide transparent explanations, and offer cost-effective solutions tailored to your needs.</p>\r\n<p><em>Quality Assurance:</em> We believe in delivering quality services that stand the test of time. We use genuine parts for repairs and installations, ensuring the longevity and reliability of your electronic devices.</p>\r\n<p><em>Timely Services:</em> We understand the importance of your time and aim to provide timely services without compromising on quality. Our efficient processes ensure that your devices are back in your hands as soon as possible.</p>\r\n<p><em>Affordable Pricing:</em> Quality electronic services shouldn\'t break the bank. We offer competitive pricing for all our services, making top-notch repairs and installations accessible to everyone.</p>', 'M/S Habib Electronic Servings Center', 'M/S Habib Electronic Servings Center', NULL, '2023-08-12 08:30:17');

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

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_bn` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `phone_bn` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `address_bn` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`id`, `name`, `name_bn`, `email`, `phone`, `phone_bn`, `address`, `address_bn`, `created_at`, `updated_at`) VALUES
(3, 'Bheramara Depot', 'ভেড়ামারা ডিপো', 'ewcl.bheramara@gmail.com', '+88 01708155845', '+৮৮ ০১৭০-৮১৫৫৮৪৫', 'Bheramara, Kustia-7040.', 'ভেড়ামারা , কুষ্টিয়া-৭০৪০।', '2023-01-07 09:51:15', '2023-02-04 03:25:41'),
(6, 'Jessore Depot', 'যশোর ডিপো', 'ewcl.jashore@gmail.com', '+88 01708155846', '+৮৮ ০১৭০-৮১৫৫৮৪৬', 'Puraton Kosba, Lichu bagan, Jashore Sadar, Jashore.', 'পুরাতন কসবা, লিচু বাগান, যশোর সদর, যশোর।', '2023-01-23 00:47:09', '2023-02-04 03:52:11'),
(8, 'Bogura Depot', 'বগুড়া ডিপো', 'ewclbogura@gmail.com', '+88 01708155847', '+৮৮ ০১৭০৮১৫৫৮৪৭', 'House No.-181/34, Nandon Kanon, Chack Sutrapur Lane, Namaj Ghar, Bogra.', 'হাউস নং-১৮১/৩৪, নন্দন কানন, চক সুত্রাপুর লেন, নামাজগড়, বগুড়া।', '2023-02-05 00:09:57', '2023-02-05 00:09:57'),
(9, 'Rangpur Depot', 'রংপুর ডিপো', 'ewcl.rongpurdepot@gmail.com', '+88 01708155850', '+৮৮ ০১৭০৮১৫৫৮৫০', 'C/O Dr. Md. Shaiful Islam (Raju), Holding No-213, Road No-1, Bus Terminal Road, Bokul Tola, Goneshpur, Rangpur', 'প্রযত্নে : এমডি. সাইফুল ইসলাম (রাজু), হোল্ডিং নং-২১৩, বাস টার্মিনাল রোড, বকুল তলা, গনেশপুর, রংপুর।', '2023-02-05 00:12:02', '2023-02-05 00:12:02'),
(10, 'Dinajpur Depot', 'দিনাজপুর ডিপো', 'ewcl.dinajpur@gmail.com', '+880 1708155849', '+৮৮ ০১৭০৮১৫৫৮৪৯', 'C/O: Md. Mohiuddin Mondol Bokul, House No-A/21, Block No-09, Housing State, Uposohor Puraton Mosjid, Dinajpur Sadar, Dinajpur-5200.', 'প্রযত্নে : মহিউদ্দিন মন্ডল বকুল, হাউস নং- এ/২১, ব্লক নং-০৯, হাউজিং স্ট্রেট, উপশহর পুরাতন মসজিদ, দিনাজপুর সদর, দিনাজপুর-৫২০০।', '2023-02-05 00:13:20', '2023-02-05 00:13:20'),
(11, 'Tangail  Depot', 'টাঙ্গাইল  ডিপো', 'ewcl.tangail@gmail.com', '+88 01708155851', '+৮৮ ০১৭০৮১৫৫৮৫১', 'Holding No: S-16 & S-17, BSCIC   I/A, Tarotia, Tangail.', 'হোল্ডিং নম্বর : S-16 & S-17, BSCIC I/A, তারোটিয়া, টাঙ্গাইল।', '2023-02-05 00:15:05', '2023-02-05 00:15:05'),
(12, 'Comilla Depot', 'কুমিল্লা ডিপো', 'ewcl.cumilla@gmail.com', '+88 01708155868', '+৮৮ ০১৭০৮১৫৫৮৬৮', 'Jahanara Monzil, Shylet Road, In front of Debpur Polish Farir, Cantonment, Comilla', 'জাহানারা মনজিল, সিলেট রোড, দেবপুর পুলিশ ফাঁড়ির সামনে, ক্যান্টনমেন্ট, কুমিল্লা।', '2023-02-05 00:16:21', '2023-02-05 00:16:21');

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

--
-- Table structure for table `branch_intros`
--

CREATE TABLE `branch_intros` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_bn` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `description_bn` longtext DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_des` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branch_intros`
--

INSERT INTO `branch_intros` (`id`, `title`, `title_bn`, `image`, `description`, `description_bn`, `meta_title`, `meta_des`, `created_at`, `updated_at`) VALUES
(1, 'Our Depot', 'আমাদের ডিপো', NULL, '<p>Our company has multiple depots in Bangladesh. Our products come from factories in depots. From these depots our products are delivered to the customers. We have depots in many places in Bangladesh. Notable depots are Barmara, Bogra, Rangpur, Tangail, Dinajpur, Comilla. These depots are designed to deliver products to customers easily.</p>', '<p>বাংলাদেশের&nbsp;বিভিন্ন জায়গায় আমাদের প্রতিষ্ঠানের একাধিক ডিপো রয়েছে।&nbsp;আমাদের ফ্যাক্টরী থেকে&nbsp;ডিপো গুলোতে&nbsp;পণ্য সমূহ আসে। এইকল ডিপো থেকে পণ্য সমূহ পরিবেশকের নিকট পোঁছে দেওয়া হয়। আমাদের উল্লেখযোগ্য ডিপো&nbsp;সমূহ হলো ভেড়ামারা , যশোর, বগুড়া, রংপুর,&nbsp;দিনাজপুর, টাঙ্গাইল এবং কুমিল্লা। সহজ ভাবে পরিবেশকের নিকট পণ্য পৌঁছে দেওয়া লক্ষেই এই সকল ডিপো সমূহ তৈরি করা হয়েছে।</p>', 'বাংলাদেশের বিভিন্ন জায়গায় আমাদের প্রতিষ্ঠানের একাধিক ডিপো রয়েছে।', 'Our company has multiple depots in Bangladesh.', NULL, '2023-02-04 22:12:06');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_bn` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `description_bn` longtext DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `rank` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_des` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `name_bn`, `slug`, `description`, `description_bn`, `image`, `rank`, `meta_title`, `meta_des`, `created_at`, `updated_at`) VALUES
(10, 'LCD TV Services', 'LCD TV Services', 'lcd-tv-services', 'Is your LCD TV displaying strange colors, lines, or going blank? Our experienced technicians can diagnose and repair a wide range of issues, from power problems to screen defects. We use advanced diagnostic tools to quickly identify the root cause and provide you with a cost-effective solution.', 'Is your LCD TV displaying strange colors, lines, or going blank? Our experienced technicians can diagnose and repair a wide range of issues, from power problems to screen defects. We use advanced diagnostic tools to quickly identify the root cause and provide you with a cost-effective solution.', 'img/2023/1773997010828665slider8 - Copy.jpg', '1', NULL, NULL, '2023-08-12 08:38:22', '2023-08-12 08:43:06'),
(11, '4k TV Servics', '4k TV Servics', '4k-tv-servics', 'Accidents happen, and sometimes LCD screens get damaged. Whether your TV screen has cracked, developed dead pixels, or is malfunctioning, we offer professional screen replacement services. We use high-quality replacement panels to restore your TV\'s visual excellence.', 'Accidents happen, and sometimes LCD screens get damaged. Whether your TV screen has cracked, developed dead pixels, or is malfunctioning, we offer professional screen replacement services. We use high-quality replacement panels to restore your TV\'s visual excellence.', 'img/2023/1773997022535857tv2.jpg', '2', NULL, NULL, '2023-08-12 08:39:20', '2023-08-12 08:43:17'),
(12, 'QLED Repairs', 'QLED Repairs', 'qled-repairs', 'Is your TV not delivering the vibrant colors and clear sound it used to? Our experts can perform thorough picture and sound calibration to ensure you\'re getting the best viewing experience possible. We\'ll fine-tune settings to optimize color accuracy, contrast, and audio clarity.', 'Is your TV not delivering the vibrant colors and clear sound it used to? Our experts can perform thorough picture and sound calibration to ensure you\'re getting the best viewing experience possible. We\'ll fine-tune settings to optimize color accuracy, contrast, and audio clarity.', 'img/2023/1773997032388234slider8 - Copy.jpg', '3', NULL, NULL, '2023-08-12 08:40:19', '2023-08-12 08:43:27');

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

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

CREATE TABLE `companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `favicon` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_bn` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `phone_bn` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `address_bn` text DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_des` text DEFAULT NULL,
  `google_maps` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `companies` (`id`, `logo`, `favicon`, `name`, `name_bn`, `email`, `phone`, `phone_bn`, `address`, `address_bn`, `meta_title`, `meta_des`, `google_maps`, `created_at`, `updated_at`) VALUES
(1, 'img/2023/1773995195308236habib.PNG', 'img/2023/1758733673740963agricul.png', 'M/S Habib Electronic Servings Center', 'M/S Habib Electronic Servings Center', 'habibelectronic@gmail.com', '01747942255', '01747942255', 'Shop-178, Bangabandhu National Stadium Market, Dhaka-1000', 'Shop-178, Bangabandhu National Stadium Market, Dhaka-1000', 'Habib Electronic Servings Center', 'Habib Electronic Servings Center', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3652.549101217445!2d90.41058117608539!3d23.72779078964257!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3755b9a18d0b0931%3A0xdab240983bb02610!2sBangabandhu%20National%20Stadium!5e0!3m2!1sen!2sbd!4v1691814127256!5m2!1sen!2sbd\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', NULL, '2023-08-12 08:22:37');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `founder_speeches`
--

CREATE TABLE `founder_speeches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_bn` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_bn` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `designation_bn` varchar(255) DEFAULT NULL,
  `speech` longtext DEFAULT NULL,
  `speech_bn` longtext DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_des` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `founder_speeches`
--

INSERT INTO `founder_speeches` (`id`, `title`, `title_bn`, `image`, `name`, `name_bn`, `designation`, `designation_bn`, `speech`, `speech_bn`, `meta_title`, `meta_des`, `created_at`, `updated_at`) VALUES
(1, 'Founder Speech', 'Founder Speech', 'img/2023/1773996082266110Slider1.jpg', 'MD. Ariful Islam', 'MD. Ariful Islam', 'MD. Ariful Islam', 'MD. Ariful Islam', '<p><strong>Welcome to Habib Electronics: Your Trusted Electronic Services Provider</strong></p>\r\n<p>At Habib Electronics, we pride ourselves on being your one-stop destination for all your electronic service needs. With a rich history of excellence spanning over two decades, we have established ourselves as a reliable and customer-centric electronic services provider. From repairs to installations and everything in between, we\'ve got you covered.</p>', '<p><strong>Welcome to Habib Electronics: Your Trusted Electronic Services Provider</strong></p>\r\n<p>At Habib Electronics, we pride ourselves on being your one-stop destination for all your electronic service needs. With a rich history of excellence spanning over two decades, we have established ourselves as a reliable and customer-centric electronic services provider. From repairs to installations and everything in between, we\'ve got you covered.</p>', 'Welcome to Habib Electronics: Your Trusted Electronic Services Provider', 'Welcome to Habib Electronics: Your Trusted Electronic Services Provider', NULL, '2023-08-12 08:28:21');

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

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_bn` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `rank` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `galleries`
--

INSERT INTO `galleries` (`id`, `title`, `title_bn`, `image`, `rank`, `created_at`, `updated_at`) VALUES
(7, 'Habib Electronic', 'Habib Electronic', 'img/2023/1773997805663973Slider5.jpg', '1', '2023-08-12 08:55:44', '2023-08-12 08:55:44'),
(8, 'Habib Electronic', 'Habib Electronic', 'img/2023/1773997819986548slider6.jpg', '2', '2023-08-12 08:55:58', '2023-08-12 08:55:58');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(18, '2022_12_16_125836_create_companies_table', 2),
(19, '2022_12_16_125915_create_branches_table', 2),
(20, '2022_12_25_155619_create_sliders_table', 2),
(21, '2022_12_25_155744_create_about_us_table', 2),
(22, '2022_12_25_160115_create_founder_speeches_table', 2),
(23, '2022_12_25_160149_create_mission_visions_table', 2),
(24, '2022_12_25_160208_create_teams_table', 2),
(25, '2022_12_25_160236_create_social_media_table', 2),
(26, '2022_12_25_160321_create_categories_table', 2),
(27, '2022_12_25_160333_create_products_table', 2),
(28, '2022_12_25_160352_create_galleries_table', 2),
(29, '2022_12_25_160408_create_blogs_table', 2),
(30, '2022_12_25_160422_create_messages_table', 2),
(31, '2023_01_06_120750_create_branch_intros_table', 3);

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

--
-- Table structure for table `mission_visions`
--

CREATE TABLE `mission_visions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_bn` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `vision` longtext DEFAULT NULL,
  `vision_bn` longtext DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_des` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mission_visions`
--

INSERT INTO `mission_visions` (`id`, `title`, `title_bn`, `image`, `vision`, `vision_bn`, `meta_title`, `meta_des`, `created_at`, `updated_at`) VALUES
(1, 'Mission & Visions', 'Mission & Visions', 'img/2023/1773995920026459slider6.jpg', '<h4 class=\"page-title-main\">Mission &amp; Visions</h4>', '<h4 class=\"page-title-main\">Mission &amp; Visions</h4>', 'M/S Habib Electronic Servings Center', 'M/S Habib Electronic Servings Center', NULL, '2023-08-12 08:25:46');

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

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

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

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

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

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

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_bn` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `description_bn` longtext DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `rank` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_des` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_bn` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `description_bn` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `title_bn`, `description`, `description_bn`, `image`, `created_at`, `updated_at`) VALUES
(1, 'M/S Habib Electronic Servings Center', 'M/S Habib Electronic Servings Center', NULL, NULL, 'img/2023/1773996285155464Slider2.jpg', '2022-12-30 07:12:07', '2023-08-12 08:31:34');

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

--
-- Table structure for table `social_media`
--

CREATE TABLE `social_media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `linked_in` varchar(255) DEFAULT NULL,
  `instragram` varchar(255) DEFAULT NULL,
  `youTube` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `social_media`
--

INSERT INTO `social_media` (`id`, `facebook`, `twitter`, `linked_in`, `instragram`, `youTube`, `created_at`, `updated_at`) VALUES
(1, 'https://www.facebook.com', 'https://twitter.com', 'https://www.linkedin.com', 'https://www.bdtradeinfo.com/company/east-west-chemicals-ltd-31046', 'https://www.youtube.com', NULL, '2023-03-27 08:55:35');

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

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_bn` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `designation_bn` varchar(255) DEFAULT NULL,
  `rank` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(2, 'Hescbd', 'eastwestchemicalsltd@gmail.com', NULL, '$2a$04$UL9.FwBGffxUmORZkkYYXu2GyTUyi1b.jgIsteLzxGs2k4JhiNVG2', NULL, '2023-02-24 12:13:12', '2023-02-24 12:13:12');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about_us`
--
ALTER TABLE `about_us`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `branch_intros`
--
ALTER TABLE `branch_intros`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `founder_speeches`
--
ALTER TABLE `founder_speeches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mission_visions`
--
ALTER TABLE `mission_visions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_category_id_index` (`category_id`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `social_media`
--
ALTER TABLE `social_media`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `teams`
--
ALTER TABLE `teams`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about_us`
--
ALTER TABLE `about_us`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `branch_intros`
--
ALTER TABLE `branch_intros`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `founder_speeches`
--
ALTER TABLE `founder_speeches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `mission_visions`
--
ALTER TABLE `mission_visions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `social_media`
--
ALTER TABLE `social_media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `teams`
--
ALTER TABLE `teams`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;
COMMIT;

/*!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 */;
