-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 12, 2021 at 12:48 PM
-- Server version: 10.4.21-MariaDB
-- PHP Version: 7.3.30

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: `mngl`
--

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sub_category_type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(599) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8_unicode_ci DEFAULT 'Active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `categories` (`id`, `parent_id`, `name`, `alias`, `type`, `category_type`, `sub_category_type`, `url`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 'Home', 'home', 'Main-Menu', 'Heading', NULL, '/', 'Active', NULL, NULL, '2021-10-12 03:59:20', '2021-10-12 03:59:20', NULL),
(2, NULL, 'Corporate', 'corporate', 'Main-Menu', 'Heading', NULL, NULL, 'Active', NULL, NULL, '2021-10-12 04:00:12', '2021-10-12 04:00:12', NULL),
(3, NULL, 'CSR', 'csr', 'Main-Menu', 'Heading', NULL, NULL, 'Active', NULL, NULL, '2021-10-12 04:00:47', '2021-10-12 04:00:47', NULL),
(4, NULL, 'Investors', 'investors', 'Main-Menu', 'Heading', NULL, NULL, 'Active', NULL, NULL, '2021-10-12 04:01:14', '2021-10-12 04:01:14', NULL),
(5, NULL, 'Media', 'media', 'Main-Menu', 'Heading', NULL, NULL, 'Active', NULL, NULL, '2021-10-12 04:01:47', '2021-10-12 04:01:47', NULL),
(6, NULL, 'Career', 'Career', 'Main-Menu', 'Heading', NULL, NULL, 'Active', NULL, NULL, '2021-10-12 04:02:10', '2021-10-12 04:02:10', NULL),
(7, 2, 'About MNGL', 'about-mngl', 'Main-Menu', 'Heading', NULL, '/about-mngl', 'Active', NULL, NULL, '2021-10-12 04:04:47', '2021-10-12 04:04:47', NULL),
(8, 2, 'Vision', 'vision', 'Main-Menu', 'Heading', NULL, '/vision', 'Active', NULL, NULL, '2021-10-12 04:05:20', '2021-10-12 04:05:20', NULL),
(9, 2, 'Business Objectives', 'business-objectives', 'Main-Menu', 'Heading', NULL, '/business-objectives', 'Active', NULL, NULL, '2021-10-12 04:07:20', '2021-10-12 04:07:20', NULL),
(10, 2, 'Board Of Directors', 'board-of-directors', 'Main-Menu', 'Heading', NULL, '/board-of-directors', 'Active', NULL, NULL, '2021-10-12 04:08:41', '2021-10-12 04:08:41', NULL),
(11, 2, 'Awards', 'awards', 'Main-Menu', 'Heading', NULL, '/awards', 'Active', NULL, NULL, '2021-10-12 04:12:02', '2021-10-12 04:12:02', NULL),
(12, 2, 'Future Outlook', 'future-outlook', 'Main-Menu', 'Heading', NULL, '/future-outlook', 'Active', NULL, NULL, '2021-10-12 04:12:54', '2021-10-12 04:12:54', NULL),
(13, 3, 'CSR Policy', 'csr-policy', 'Main-Menu', 'Heading', NULL, '/csr-policy', 'Active', NULL, NULL, '2021-10-12 04:14:42', '2021-10-12 04:14:42', NULL),
(14, 3, 'CSR Projects', 'csr-projects', 'Main-Menu', 'Heading', NULL, '/csr-projects', 'Active', NULL, NULL, '2021-10-12 04:15:59', '2021-10-12 04:15:59', NULL),
(15, 3, 'CSR Committee', 'csr-committee', 'Main-Menu', 'Heading', NULL, '/csr-committee', 'Active', NULL, NULL, '2021-10-12 04:16:34', '2021-10-12 04:16:34', NULL),
(16, 3, 'CSR Activities', 'csr-activities', 'Main-Menu', 'Heading', NULL, '/csr-activities', 'Active', NULL, NULL, '2021-10-12 04:17:06', '2021-10-12 04:17:06', NULL),
(17, 4, 'Financial Results', 'financial-results', 'Main-Menu', 'Heading', NULL, '/financial-results', 'Active', NULL, NULL, '2021-10-12 04:19:16', '2021-10-12 04:19:16', NULL),
(18, 4, 'Annual Reports', 'annual-reports', 'Main-Menu', 'Heading', NULL, '/annual-reports', 'Active', NULL, NULL, '2021-10-12 04:24:56', '2021-10-12 04:24:56', NULL),
(19, 4, 'Annual General Meetings', 'annual-general-meetings', 'Main-Menu', 'Heading', NULL, '/annual-general-meetings', 'Active', NULL, NULL, '2021-10-12 04:25:51', '2021-10-12 04:25:51', NULL),
(20, 4, 'Corporate Governance', 'corporate-governance', 'Main-Menu', 'Heading', NULL, '/corporate-governance', 'Active', NULL, NULL, '2021-10-12 04:28:14', '2021-10-12 04:28:14', NULL),
(21, 4, 'Policies', 'policies', 'Main-Menu', 'Heading', NULL, '/policies', 'Active', NULL, NULL, '2021-10-12 04:29:32', '2021-10-12 04:29:32', NULL),
(22, 4, 'Investor Guide', 'investor-guide', 'Main-Menu', 'Heading', NULL, '/investor-guide', 'Active', NULL, NULL, '2021-10-12 04:30:18', '2021-10-12 04:30:18', NULL),
(23, 4, 'Investor Updates & Presentation', 'investor-updates', 'Main-Menu', 'Heading', NULL, '/investor-updates', 'Active', NULL, NULL, '2021-10-12 04:34:22', '2021-10-12 04:34:22', NULL),
(24, 4, 'Shareholders Information', 'shareholders-information', 'Main-Menu', 'Heading', NULL, '/shareholders-information', 'Active', NULL, NULL, '2021-10-12 04:34:59', '2021-10-12 04:34:59', NULL),
(25, 5, 'News', 'news', 'Main-Menu', 'Heading', NULL, '/news', 'Active', NULL, NULL, '2021-10-12 04:35:34', '2021-10-12 04:35:34', NULL),
(26, 5, 'Gallery', 'gallery', 'Main-Menu', 'Heading', NULL, '/gallery', 'Active', NULL, NULL, '2021-10-12 04:35:59', '2021-10-12 04:35:59', NULL),
(27, 6, 'Life @ MNGL', 'life-at-mngl', 'Main-Menu', 'Heading', NULL, '/life-at-mngl', 'Active', NULL, NULL, '2021-10-12 04:37:07', '2021-10-12 04:37:07', NULL),
(28, 6, 'Current Opportunities', 'current-opportunities', 'Main-Menu', 'Heading', NULL, '/current-opportunities', 'Active', NULL, NULL, '2021-10-12 04:37:56', '2021-10-12 04:37:56', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories_parent_id_foreign` (`parent_id`),
  ADD KEY `categories_created_by_foreign` (`created_by`),
  ADD KEY `categories_updated_by_foreign` (`updated_by`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`),
  ADD CONSTRAINT `categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `categories_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `admins` (`id`);
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 */;
