-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Oct 28, 2024 at 08:15 AM
-- Server version: 10.11.9-MariaDB
-- PHP Version: 7.2.34
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: `u471889385_bhaweshthakur`
--
-- --------------------------------------------------------
--
-- Table structure for table `about_sections`
--
CREATE TABLE `about_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_image` text DEFAULT NULL,
`video_type` enum('youtube','other') DEFAULT NULL,
`video_url` text DEFAULT NULL,
`section_title` text DEFAULT NULL,
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`button_name` text DEFAULT NULL,
`button_url` text DEFAULT NULL,
`button_name_2` text DEFAULT NULL,
`cv_file` 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_sections`
--
INSERT INTO `about_sections` (`id`, `language_id`, `style`, `section_image`, `video_type`, `video_url`, `section_title`, `title`, `description`, `button_name`, `button_url`, `button_name_2`, `cv_file`, `created_at`, `updated_at`) VALUES
(1, 1, 'style1', '1726071978-05.jpeg', 'youtube', '', '', '', '', '', '', '', NULL, '2024-09-11 16:26:18', '2024-09-11 16:26:18');
-- --------------------------------------------------------
--
-- Table structure for table `about_section_features`
--
CREATE TABLE `about_section_features` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `banners`
--
CREATE TABLE `banners` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1','style2','style3','style4') NOT NULL DEFAULT 'style1',
`section_image` text DEFAULT NULL,
`section_image_2` text DEFAULT NULL,
`section_image_3` text DEFAULT NULL,
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`youtube_video_url` text DEFAULT NULL,
`button_name` text DEFAULT NULL,
`button_url` text DEFAULT NULL,
`button_name_2` text DEFAULT NULL,
`button_url_2` 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 `banners`
--
INSERT INTO `banners` (`id`, `language_id`, `style`, `section_image`, `section_image_2`, `section_image_3`, `title`, `description`, `youtube_video_url`, `button_name`, `button_url`, `button_name_2`, `button_url_2`, `created_at`, `updated_at`) VALUES
(1, 1, 'style1', '1729014572-i2mju_1280_WhatsAppImage20230413at21.02.23-removebg-preview.png', NULL, NULL, 'addddd', 'adaddadddd', '', 'learn more', '', '', '', '2024-10-15 17:49:32', '2024-10-15 17:49:32');
-- --------------------------------------------------------
--
-- Table structure for table `blogs`
--
CREATE TABLE `blogs` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`category_name` varchar(255) NOT NULL,
`category_id` int(11) NOT NULL,
`author_name` varchar(255) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`title` text NOT NULL,
`description` text DEFAULT NULL,
`short_description` text DEFAULT NULL,
`section_image` text DEFAULT NULL,
`section_image_2` text DEFAULT NULL,
`image_status` enum('show','hide') NOT NULL DEFAULT 'show',
`type` enum('with_this_account','anonymous') NOT NULL,
`slug` text NOT NULL,
`view` int(11) NOT NULL DEFAULT 0,
`order` int(11) NOT NULL DEFAULT 0,
`status` enum('published','draft') NOT NULL DEFAULT 'published',
`tag` text DEFAULT NULL,
`breadcrumb_status` enum('yes','no') NOT NULL DEFAULT 'no',
`custom_breadcrumb_image` text DEFAULT NULL,
`meta_description` text DEFAULT NULL,
`meta_keyword` 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 `blog_sections`
--
CREATE TABLE `blog_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`section_title` text DEFAULT NULL,
`title` text DEFAULT NULL,
`button_name` text DEFAULT NULL,
`button_url` text DEFAULT NULL,
`section_item` int(11) NOT NULL DEFAULT 3,
`paginate_item` int(11) NOT NULL DEFAULT 12,
`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 `bottom_button_widgets`
--
CREATE TABLE `bottom_button_widgets` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`button_name` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`status` enum('enable','disable') NOT NULL DEFAULT 'enable',
`button_name_2` varchar(255) DEFAULT NULL,
`whatsapp` varchar(255) DEFAULT NULL,
`status_whatsapp` enum('enable','disable') NOT NULL DEFAULT 'enable',
`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 `breadcrumb_images`
--
CREATE TABLE `breadcrumb_images` (
`id` bigint(20) UNSIGNED NOT NULL,
`section_image` 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 `call_to_actions`
--
CREATE TABLE `call_to_actions` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`title` text DEFAULT NULL,
`button_name` text DEFAULT NULL,
`button_url` 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 `careers`
--
CREATE TABLE `careers` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`category_name` varchar(255) NOT NULL,
`category_id` int(11) NOT NULL,
`type` enum('icon','image') NOT NULL,
`icon` varchar(255) DEFAULT NULL,
`section_image` text DEFAULT NULL,
`title` text NOT NULL,
`short_description` text DEFAULT NULL,
`career_slug` text NOT NULL,
`status` enum('published','draft') NOT NULL DEFAULT 'published',
`button_name` text DEFAULT NULL,
`button_url` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `career_categories`
--
CREATE TABLE `career_categories` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`category_name` varchar(255) NOT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`status` int(11) NOT NULL,
`career_category_slug` varchar(255) NOT 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 `career_contents`
--
CREATE TABLE `career_contents` (
`id` bigint(20) UNSIGNED NOT NULL,
`career_id` bigint(20) UNSIGNED NOT NULL,
`section_image` text DEFAULT NULL,
`description` longtext DEFAULT NULL,
`breadcrumb_status` enum('yes','no') NOT NULL DEFAULT 'no',
`custom_breadcrumb_image` text DEFAULT NULL,
`meta_description` text DEFAULT NULL,
`meta_keyword` 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 `career_sections`
--
CREATE TABLE `career_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`section_title` text DEFAULT NULL,
`title` text DEFAULT NULL,
`button_name` text DEFAULT NULL,
`button_url` text DEFAULT NULL,
`company_title` text DEFAULT NULL,
`company_description` text DEFAULT NULL,
`company_contact_title` text DEFAULT NULL,
`email` text DEFAULT NULL,
`phone` text DEFAULT NULL,
`address` text DEFAULT NULL,
`section_item` int(11) NOT NULL DEFAULT 6,
`paginate_item` int(11) NOT NULL DEFAULT 12,
`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 `categories`
--
CREATE TABLE `categories` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`category_name` varchar(255) NOT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`status` int(11) NOT NULL,
`category_slug` varchar(255) NOT 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 `color_options`
--
CREATE TABLE `color_options` (
`id` bigint(20) UNSIGNED NOT NULL,
`color_option` int(11) NOT NULL DEFAULT 0,
`main_color` varchar(255) DEFAULT NULL,
`secondary_color` varchar(255) DEFAULT NULL,
`scroll_button_color` varchar(255) DEFAULT NULL,
`bottom_button_color` varchar(255) DEFAULT NULL,
`bottom_button_hover_color` varchar(255) DEFAULT NULL,
`side_button_color` varchar(255) DEFAULT NULL,
`type` enum('default','customize') NOT NULL DEFAULT 'default',
`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 `color_options`
--
INSERT INTO `color_options` (`id`, `color_option`, `main_color`, `secondary_color`, `scroll_button_color`, `bottom_button_color`, `bottom_button_hover_color`, `side_button_color`, `type`, `created_at`, `updated_at`) VALUES
(1, 26, '#214be0', '#171718', '#ff4500', '#212529', '#333', '#25d366', 'default', '2024-09-11 16:33:36', '2024-09-11 16:36:04');
-- --------------------------------------------------------
--
-- Table structure for table `contact_infos`
--
CREATE TABLE `contact_infos` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`type` enum('icon','image') NOT NULL,
`icon` varchar(255) DEFAULT NULL,
`section_image` text DEFAULT NULL,
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `contact_info_sections`
--
CREATE TABLE `contact_info_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_title` text DEFAULT NULL,
`title` 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 `contact_info_widgets`
--
CREATE TABLE `contact_info_widgets` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`address` text DEFAULT NULL,
`email` text DEFAULT NULL,
`phone` text DEFAULT NULL,
`working_hour` 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 `contact_messages`
--
CREATE TABLE `contact_messages` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`message` text NOT NULL,
`read` int(11) NOT NULL DEFAULT 0,
`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 `counters`
--
CREATE TABLE `counters` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`timer` text DEFAULT NULL,
`title` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `counters`
--
INSERT INTO `counters` (`id`, `language_id`, `style`, `timer`, `title`, `order`, `created_at`, `updated_at`) VALUES
(1, 1, 'style1', '15', 'sfff', 1, '2024-10-15 17:51:51', '2024-10-15 17:51:51');
-- --------------------------------------------------------
--
-- Table structure for table `counter_sections`
--
CREATE TABLE `counter_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_title` text DEFAULT NULL,
`title` 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 `draft_views`
--
CREATE TABLE `draft_views` (
`id` bigint(20) UNSIGNED NOT NULL,
`status` enum('enable','disable') NOT NULL DEFAULT 'enable',
`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 `external_urls`
--
CREATE TABLE `external_urls` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`button_name` text DEFAULT NULL,
`button_url` 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 `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 `faqs`
--
CREATE TABLE `faqs` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1','style2','style3') NOT NULL DEFAULT 'style1',
`question` text DEFAULT NULL,
`answer` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `faq_sections`
--
CREATE TABLE `faq_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1','style2') NOT NULL DEFAULT 'style1',
`section_title` text DEFAULT NULL,
`title` 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 `favicons`
--
CREATE TABLE `favicons` (
`id` bigint(20) UNSIGNED NOT NULL,
`favicon_image` 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 `features`
--
CREATE TABLE `features` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`type` enum('icon','image') NOT NULL,
`icon` varchar(255) DEFAULT NULL,
`section_image` text DEFAULT NULL,
`subtitle` text DEFAULT NULL,
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `features`
--
INSERT INTO `features` (`id`, `language_id`, `style`, `type`, `icon`, `section_image`, `subtitle`, `title`, `description`, `order`, `created_at`, `updated_at`) VALUES
(1, 1, 'style1', 'icon', 'fab fa-accusoft', NULL, 'ds', 'dfdff', 'ssfdsff', 0, '2024-10-15 17:51:21', '2024-10-15 17:51:21');
-- --------------------------------------------------------
--
-- Table structure for table `feature_sections`
--
CREATE TABLE `feature_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_title` text DEFAULT NULL,
`title` 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 `fonts`
--
CREATE TABLE `fonts` (
`id` bigint(20) UNSIGNED NOT NULL,
`title_font_link` text DEFAULT NULL,
`title_font_family` text DEFAULT NULL,
`text_font_link` text DEFAULT NULL,
`text_font_family` 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 `footers`
--
CREATE TABLE `footers` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`category_name` text NOT NULL,
`category_id` int(11) NOT NULL,
`title` text NOT NULL,
`url` text NOT NULL,
`status` enum('published','draft') NOT NULL DEFAULT 'published',
`order` int(11) NOT NULL DEFAULT 0,
`footer_slug` text NOT 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 `footer_categories`
--
CREATE TABLE `footer_categories` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`category_name` varchar(255) NOT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`order` int(11) NOT NULL DEFAULT 0,
`footer_category_slug` text NOT 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 `footer_images`
--
CREATE TABLE `footer_images` (
`id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_image` 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 `frontend_keywords`
--
CREATE TABLE `frontend_keywords` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`key` text DEFAULT NULL,
`value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `frontend_keywords`
--
INSERT INTO `frontend_keywords` (`id`, `language_id`, `key`, `value`) VALUES
(1, 1, 'home', 'Home'),
(2, 1, 'name', 'Name'),
(3, 1, 'email', 'Email'),
(4, 1, 'phone', 'Phone'),
(5, 1, 'your_message', 'Your message'),
(6, 1, 'message_submit', 'Message Submit'),
(7, 1, 'send_message', 'Send Message'),
(8, 1, 'read_more', 'Read More'),
(9, 1, 'view_details', 'View Details'),
(10, 1, 'enter_your_email', 'Enter your email'),
(11, 1, 'subscribe_now', 'Subscribe Now'),
(12, 1, 'search', 'Search'),
(13, 1, 'type_to_search', 'Type to search...'),
(14, 1, 'categories', 'Categories'),
(15, 1, 'recent_posts', 'Recent Posts'),
(16, 1, 'popular_tags', 'Popular Tags'),
(17, 1, 'tags', 'Tags'),
(18, 1, 'next_post', 'Next Post'),
(19, 1, 'prev_post', 'Previous Post'),
(20, 1, 'copy_link_and_share', 'Copy Url and Share:'),
(21, 1, 'share_on', 'Share on: '),
(22, 1, 'nothing_found', 'Nothing found.'),
(23, 1, 'all_works', 'All Works'),
(24, 1, 'all', 'All'),
(25, 1, 'about_us', 'About Us'),
(26, 1, 'anonymous', 'Anonymous'),
(27, 1, 'all_services', 'All Services'),
(28, 1, 'all_teams', 'All Teams'),
(29, 1, 'all_blogs', 'All Blogs'),
(30, 1, 'all_portfolio', 'All Portfolio'),
(31, 1, 'recent_services', 'Recent Services'),
(32, 1, 'recent_portfolio', 'Recent Portfolio'),
(33, 1, 'recent_blogs', 'Recent Blogs'),
(34, 1, 'recommended', 'Recommended'),
(35, 1, 'address', 'Address'),
(36, 1, 'working_hour', 'Working Hour');
-- --------------------------------------------------------
--
-- Table structure for table `gallery_images`
--
CREATE TABLE `gallery_images` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`section_image` text DEFAULT NULL,
`title` text DEFAULT NULL,
`subtitle` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `gallery_image_sections`
--
CREATE TABLE `gallery_image_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`section_item` int(11) NOT NULL DEFAULT 3,
`paginate_item` int(11) NOT NULL DEFAULT 6,
`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 `google_analytics`
--
CREATE TABLE `google_analytics` (
`id` bigint(20) UNSIGNED NOT NULL,
`google_analytic` varchar(255) NOT 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 `header_images`
--
CREATE TABLE `header_images` (
`id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_image` text DEFAULT NULL,
`section_image_2` 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 `header_images`
--
INSERT INTO `header_images` (`id`, `style`, `section_image`, `section_image_2`, `created_at`, `updated_at`) VALUES
(2, 'style1', '1729015071-WhatsApp_Image_2024-08-14_at_7.47.20_PM-removebg-preview.png', '1729014997-L7 750X400.jpg', '2024-10-15 17:56:36', '2024-10-15 17:57:51');
-- --------------------------------------------------------
--
-- Table structure for table `header_infos`
--
CREATE TABLE `header_infos` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`email` 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 `histories`
--
CREATE TABLE `histories` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_image` text DEFAULT NULL,
`history_date` text DEFAULT NULL,
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `histories`
--
INSERT INTO `histories` (`id`, `language_id`, `style`, `section_image`, `history_date`, `title`, `description`, `order`, `created_at`, `updated_at`) VALUES
(1, 1, 'style1', '1729014642-WhatsApp_Image_2024-08-14_at_7.47.20_PM-removebg-preview.png', 'ssdfdsf', 'dfdff', 'sfsfsf', 0, '2024-10-15 17:50:42', '2024-10-15 17:50:42');
-- --------------------------------------------------------
--
-- Table structure for table `history_sections`
--
CREATE TABLE `history_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_title` text DEFAULT NULL,
`title` 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 `languages`
--
CREATE TABLE `languages` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_name` varchar(255) NOT NULL,
`language_code` varchar(255) NOT NULL,
`direction` int(11) NOT NULL,
`status` int(11) NOT NULL,
`display_dropdown` int(11) NOT NULL,
`default_site_language` int(11) NOT 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 `languages`
--
INSERT INTO `languages` (`id`, `language_name`, `language_code`, `direction`, `status`, `display_dropdown`, `default_site_language`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 0, 1, 1, 1, '2024-03-18 08:12:50', '2024-03-18 08:12:50');
-- --------------------------------------------------------
--
-- Table structure for table `maps`
--
CREATE TABLE `maps` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`map_iframe` 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 `menus`
--
CREATE TABLE `menus` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`menu_name` varchar(255) NOT NULL,
`uri` text DEFAULT NULL,
`url` text DEFAULT NULL,
`view` int(11) NOT NULL DEFAULT 0,
`status` enum('published','draft') NOT NULL DEFAULT 'published',
`order` int(11) NOT NULL DEFAULT 0,
`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 `menus`
--
INSERT INTO `menus` (`id`, `language_id`, `menu_name`, `uri`, `url`, `view`, `status`, `order`, `created_at`, `updated_at`) VALUES
(1, 1, 'Home', '#', NULL, 0, 'published', 0, NULL, NULL),
(2, 1, 'About', 'about', NULL, 0, 'published', 0, NULL, NULL),
(3, 1, 'Services', '#', NULL, 0, 'published', 0, NULL, NULL),
(4, 1, 'Pages', '#', NULL, 0, 'published', 0, NULL, NULL),
(5, 1, 'News', '#', NULL, 0, 'published', 0, NULL, NULL),
(6, 1, 'Contact', 'contact', NULL, 0, 'published', 0, NULL, NULL);
-- --------------------------------------------------------
--
-- 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_reset_tokens_table', 1),
(3, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2023_03_13_171754_create_sessions_table', 1),
(7, '2023_03_13_212902_create_languages_table', 1),
(8, '2023_03_13_212916_create_panel_keywords_table', 1),
(9, '2023_03_13_212935_create_frontend_keywords_table', 1),
(10, '2023_03_13_220600_create_permission_tables', 1),
(11, '2023_04_10_232147_create_site_infos_table', 1),
(12, '2023_04_11_120934_create_features_table', 1),
(13, '2023_04_12_110018_create_favicons_table', 1),
(14, '2023_04_12_110037_create_header_images_table', 1),
(15, '2023_04_12_110052_create_footer_images_table', 1),
(16, '2023_04_12_120359_create_external_urls_table', 1),
(17, '2023_04_14_152419_create_about_sections_table', 1),
(18, '2023_04_19_124444_create_testimonials_table', 1),
(19, '2023_04_19_124452_create_testimonial_sections_table', 1),
(20, '2023_04_20_235907_create_faqs_table', 1),
(21, '2023_04_20_235916_create_faq_sections_table', 1),
(22, '2023_04_22_035047_create_categories_table', 1),
(23, '2023_04_22_035106_create_blogs_table', 1),
(24, '2023_04_22_035115_create_blog_sections_table', 1),
(25, '2023_04_24_154815_create_call_to_actions_table', 1),
(26, '2023_04_26_121311_create_socials_table', 1),
(27, '2023_04_29_100441_create_tawk_tos_table', 1),
(28, '2023_04_29_105535_create_color_options_table', 1),
(29, '2023_05_11_084604_create_footer_categories_table', 1),
(30, '2023_05_11_092810_create_footers_table', 1),
(31, '2023_05_16_132304_create_plans_table', 1),
(32, '2023_05_16_132336_create_plan_sections_table', 1),
(33, '2023_07_06_132028_create_page_names_table', 1),
(34, '2023_07_06_140307_create_page_builders_table', 1),
(35, '2023_07_12_095945_create_about_section_features_table', 1),
(36, '2023_07_12_125353_create_menus_table', 1),
(37, '2023_07_12_125403_create_submenus_table', 1),
(38, '2023_07_31_131631_create_seos_table', 1),
(39, '2023_08_01_133227_create_preloaders_table', 1),
(40, '2023_08_02_053410_create_google_analytics_table', 1),
(41, '2023_08_11_051329_create_panel_images_table', 1),
(42, '2023_08_12_074725_create_photos_table', 1),
(43, '2023_09_04_055154_create_subscribe_sections_table', 1),
(44, '2023_09_10_113849_create_subscribes_table', 1),
(45, '2023_09_11_113842_create_contact_infos_table', 1),
(46, '2023_09_28_132904_create_gallery_images_table', 1),
(47, '2023_09_28_132915_create_gallery_image_sections_table', 1),
(48, '2023_09_30_114716_create_bottom_button_widgets_table', 1),
(49, '2023_09_30_114811_create_side_button_widgets_table', 1),
(50, '2023_10_18_102034_create_contact_messages_table', 1),
(51, '2023_11_11_114838_create_header_infos_table', 1),
(52, '2023_11_13_022825_create_service_categories_table', 1),
(53, '2023_11_13_024753_create_services_table', 1),
(54, '2023_11_13_024820_create_service_sections_table', 1),
(55, '2023_11_13_024845_create_service_contents_table', 1),
(56, '2023_11_13_024902_create_service_features_table', 1),
(57, '2023_11_13_024912_create_service_feature_sections_table', 1),
(58, '2023_11_17_144416_create_sponsors_table', 1),
(59, '2023_11_17_153619_create_why_chooses_table', 1),
(60, '2023_11_17_153630_create_why_choose_sections_table', 1),
(61, '2023_11_20_003959_create_video_sections_table', 1),
(62, '2023_11_20_011730_create_counters_table', 1),
(63, '2023_11_20_030759_create_team_categories_table', 1),
(64, '2023_11_20_030855_create_teams_table', 1),
(65, '2023_11_20_030901_create_team_sections_table', 1),
(66, '2023_11_20_104012_create_maps_table', 1),
(67, '2023_11_20_105144_create_contact_info_sections_table', 1),
(68, '2023_11_21_035123_create_portfolio_categories_table', 1),
(69, '2023_11_21_035131_create_portfolios_table', 1),
(70, '2023_11_21_035141_create_portfolio_sections_table', 1),
(71, '2023_11_21_035206_create_portfolio_contents_table', 1),
(72, '2023_11_21_035228_create_portfolio_details_table', 1),
(73, '2023_11_21_035233_create_portfolio_detail_sections_table', 1),
(74, '2023_11_28_013700_create_contact_info_widgets_table', 1),
(75, '2023_12_05_101926_create_breadcrumb_images_table', 1),
(76, '2023_12_12_115104_create_fonts_table', 1),
(77, '2024_01_01_044650_create_banners_table', 1),
(78, '2024_01_01_125354_create_feature_sections_table', 1),
(79, '2024_01_02_011416_create_service_infos_table', 1),
(80, '2024_01_02_014845_create_counter_sections_table', 1),
(81, '2024_01_02_020038_create_work_processes_table', 1),
(82, '2024_01_02_020044_create_work_process_sections_table', 1),
(83, '2024_01_02_120922_create_portfolio_images_table', 1),
(84, '2024_01_11_105005_create_draft_views_table', 1),
(85, '2024_01_15_024512_create_histories_table', 1),
(86, '2024_01_15_024519_create_history_sections_table', 1),
(87, '2024_01_15_120836_create_career_categories_table', 1),
(88, '2024_01_15_120844_create_careers_table', 1),
(89, '2024_01_15_120853_create_career_sections_table', 1),
(90, '2024_01_16_120226_create_career_contents_table', 1),
(91, '2024_01_20_025100_create_pages_table', 1);
-- --------------------------------------------------------
--
-- Table structure for table `model_has_permissions`
--
CREATE TABLE `model_has_permissions` (
`permission_id` bigint(20) UNSIGNED NOT NULL,
`model_type` varchar(255) NOT NULL,
`model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `model_has_roles`
--
CREATE TABLE `model_has_roles` (
`role_id` bigint(20) UNSIGNED NOT NULL,
`model_type` varchar(255) NOT NULL,
`model_id` bigint(20) UNSIGNED NOT NULL
) 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
(1, 'App\\Models\\User', 1);
-- --------------------------------------------------------
--
-- Table structure for table `pages`
--
CREATE TABLE `pages` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`title` text NOT NULL,
`description` text DEFAULT NULL,
`section_image` text DEFAULT NULL,
`page_slug` text NOT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`status` enum('published','draft') NOT NULL DEFAULT 'published',
`breadcrumb_status` enum('yes','no') NOT NULL DEFAULT 'no',
`custom_breadcrumb_image` text DEFAULT NULL,
`meta_description` text DEFAULT NULL,
`meta_keyword` 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 `page_builders`
--
CREATE TABLE `page_builders` (
`id` bigint(20) UNSIGNED NOT NULL,
`page_uri` varchar(255) NOT NULL,
`page_name` varchar(255) NOT NULL,
`page_name_id` int(11) NOT NULL,
`default_item` text DEFAULT NULL,
`updated_item` text DEFAULT NULL,
`breadcrumb_title` text DEFAULT NULL,
`breadcrumb_item` text DEFAULT NULL,
`breadcrumb_status` enum('yes','no') NOT NULL DEFAULT 'no',
`custom_breadcrumb_image` text DEFAULT NULL,
`meta_title` text DEFAULT NULL,
`meta_description` text DEFAULT NULL,
`meta_keyword` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`segment_count` int(11) NOT NULL DEFAULT 1,
`is_default` enum('yes','no') NOT NULL DEFAULT 'no',
`status` int(11) NOT 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 `page_builders`
--
INSERT INTO `page_builders` (`id`, `page_uri`, `page_name`, `page_name_id`, `default_item`, `updated_item`, `breadcrumb_title`, `breadcrumb_item`, `breadcrumb_status`, `custom_breadcrumb_image`, `meta_title`, `meta_description`, `meta_keyword`, `order`, `segment_count`, `is_default`, `status`, `created_at`, `updated_at`) VALUES
(1, '/', 'public-homepage-index', 1, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"banner-style1\",\"folder\":\"banner\",\"order\":0},{\"id\":\"about-style1\",\"folder\":\"about\",\"order\":0},{\"id\":\"feature-style1\",\"folder\":\"feature\",\"order\":0},{\"id\":\"service-style1\",\"folder\":\"service\",\"order\":0},{\"id\":\"counter-style1\",\"folder\":\"counter\",\"order\":0},{\"id\":\"work-process-style1\",\"folder\":\"work_process\",\"order\":0},{\"id\":\"why-choose-style1\",\"folder\":\"why_choose\",\"order\":0},{\"id\":\"video-style1\",\"folder\":\"video\",\"order\":0},{\"id\":\"portfolio-style1\",\"folder\":\"portfolio\",\"order\":0},{\"id\":\"call-to-action-style1\",\"folder\":\"call_to_action\",\"order\":0},{\"id\":\"team-style1\",\"folder\":\"team\",\"order\":0},{\"id\":\"testimonial-style1\",\"folder\":\"testimonial\",\"order\":0},{\"id\":\"faq-style1\",\"folder\":\"faq\",\"order\":0},{\"id\":\"subscribe-style1\",\"folder\":\"subscribe\",\"order\":0},{\"id\":\"blog-style1\",\"folder\":\"blog\",\"order\":0},{\"id\":\"sponsor-style1\",\"folder\":\"sponsor\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, NULL, NULL, 'no', NULL, 'Homepage', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(2, 'index-2', 'homepage-2-index', 2, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"banner-style2\",\"folder\":\"banner\",\"order\":0},{\"id\":\"about-style1\",\"folder\":\"about\",\"order\":0},{\"id\":\"feature-style1\",\"folder\":\"feature\",\"order\":0},{\"id\":\"service-style1\",\"folder\":\"service\",\"order\":0},{\"id\":\"counter-style1\",\"folder\":\"counter\",\"order\":0},{\"id\":\"work-process-style1\",\"folder\":\"work_process\",\"order\":0},{\"id\":\"why-choose-style1\",\"folder\":\"why_choose\",\"order\":0},{\"id\":\"video-style1\",\"folder\":\"video\",\"order\":0},{\"id\":\"portfolio-style1\",\"folder\":\"portfolio\",\"order\":0},{\"id\":\"call-to-action-style1\",\"folder\":\"call_to_action\",\"order\":0},{\"id\":\"team-style1\",\"folder\":\"team\",\"order\":0},{\"id\":\"testimonial-style1\",\"folder\":\"testimonial\",\"order\":0},{\"id\":\"faq-style1\",\"folder\":\"faq\",\"order\":0},{\"id\":\"subscribe-style1\",\"folder\":\"subscribe\",\"order\":0},{\"id\":\"blog-style1\",\"folder\":\"blog\",\"order\":0},{\"id\":\"sponsor-style1\",\"folder\":\"sponsor\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, NULL, NULL, 'no', NULL, 'Homepage', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(3, 'index-3', 'homepage-3-index', 3, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"banner-style3\",\"folder\":\"banner\",\"order\":0},{\"id\":\"about-style1\",\"folder\":\"about\",\"order\":0},{\"id\":\"feature-style1\",\"folder\":\"feature\",\"order\":0},{\"id\":\"service-style1\",\"folder\":\"service\",\"order\":0},{\"id\":\"counter-style1\",\"folder\":\"counter\",\"order\":0},{\"id\":\"work-process-style1\",\"folder\":\"work_process\",\"order\":0},{\"id\":\"why-choose-style1\",\"folder\":\"why_choose\",\"order\":0},{\"id\":\"video-style1\",\"folder\":\"video\",\"order\":0},{\"id\":\"portfolio-style1\",\"folder\":\"portfolio\",\"order\":0},{\"id\":\"call-to-action-style1\",\"folder\":\"call_to_action\",\"order\":11},{\"id\":\"team-style1\",\"folder\":\"team\",\"order\":0},{\"id\":\"testimonial-style1\",\"folder\":\"testimonial\",\"order\":0},{\"id\":\"faq-style1\",\"folder\":\"faq\",\"order\":0},{\"id\":\"subscribe-style1\",\"folder\":\"subscribe\",\"order\":0},{\"id\":\"blog-style1\",\"folder\":\"blog\",\"order\":16},{\"id\":\"sponsor-style1\",\"folder\":\"sponsor\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, NULL, NULL, 'no', NULL, 'Homepage', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(4, 'index-4', 'homepage-4-index', 4, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"banner-style4\",\"folder\":\"banner\",\"order\":0},{\"id\":\"about-style1\",\"folder\":\"about\",\"order\":0},{\"id\":\"feature-style1\",\"folder\":\"feature\",\"order\":0},{\"id\":\"service-style1\",\"folder\":\"service\",\"order\":0},{\"id\":\"counter-style1\",\"folder\":\"counter\",\"order\":0},{\"id\":\"work-process-style1\",\"folder\":\"work_process\",\"order\":0},{\"id\":\"why-choose-style1\",\"folder\":\"why_choose\",\"order\":0},{\"id\":\"video-style1\",\"folder\":\"video\",\"order\":0},{\"id\":\"portfolio-style1\",\"folder\":\"portfolio\",\"order\":0},{\"id\":\"call-to-action-style1\",\"folder\":\"call_to_action\",\"order\":0},{\"id\":\"team-style1\",\"folder\":\"team\",\"order\":0},{\"id\":\"testimonial-style1\",\"folder\":\"testimonial\",\"order\":0},{\"id\":\"faq-style1\",\"folder\":\"faq\",\"order\":0},{\"id\":\"subscribe-style1\",\"folder\":\"subscribe\",\"order\":0},{\"id\":\"blog-style1\",\"folder\":\"blog\",\"order\":0},{\"id\":\"sponsor-style1\",\"folder\":\"sponsor\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, NULL, NULL, 'no', NULL, 'Homepage', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(5, 'about', 'about-index', 5, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"breadcrumb-style1\",\"folder\":\"breadcrumb\",\"order\":0},{\"id\":\"about-style1\",\"folder\":\"about\",\"order\":0},{\"id\":\"history-style1\",\"folder\":\"history\",\"order\":0},{\"id\":\"sponsor-style1\",\"folder\":\"sponsor\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, 'About Us', 'Home, About Us', 'no', NULL, 'About Us', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(6, 'services', 'service-index', 6, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"breadcrumb-style1\",\"folder\":\"breadcrumb\",\"order\":0},{\"id\":\"service-style2\",\"folder\":\"service\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, 'Our Services', 'Home, Our Services', 'no', NULL, 'Our Services', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(7, 'service', 'service-detail-show', 7, NULL, NULL, 'Service Detail', 'Home, Service Detail', 'no', NULL, NULL, NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(8, 'service/category', 'service-category-index', 8, NULL, NULL, 'Service Category', 'Home, Service Category', 'no', NULL, NULL, NULL, NULL, 0, 2, 'yes', 1, NULL, NULL),
(9, 'faqs', 'faq-index', 9, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"breadcrumb-style1\",\"folder\":\"breadcrumb\",\"order\":0},{\"id\":\"faq-style2\",\"folder\":\"faq\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, 'Faqs', 'Home, Our Faqs', 'no', NULL, 'Fags', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(10, 'gallery', 'gallery-index', 10, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"breadcrumb-style1\",\"folder\":\"breadcrumb\",\"order\":0},{\"id\":\"gallery-style2\",\"folder\":\"gallery\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, 'Gallery', 'Home, Our Gallery', 'no', NULL, 'Gallery', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(11, 'teams', 'team-index', 11, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"breadcrumb-style1\",\"folder\":\"breadcrumb\",\"order\":0},{\"id\":\"team-style2\",\"folder\":\"team\",\"order\":0},0{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, 'Teams', 'Home, Our Teams', 'no', NULL, 'Teams', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(12, 'team/category', 'team-category-index', 12, NULL, NULL, 'Team Category', 'Home, Team Category', 'no', NULL, NULL, NULL, NULL, 0, 2, 'yes', 1, NULL, NULL),
(13, 'portfolios', 'portfolio-index', 13, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"breadcrumb-style1\",\"folder\":\"breadcrumb\",\"order\":0},{\"id\":\"portfolio-style2\",\"folder\":\"portfolio\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, 'Portfolio', 'Home, Our Portfolio', 'no', NULL, 'Portfolio', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(14, 'portfolio', 'portfolio-detail-show', 14, NULL, NULL, 'Portfolio Detail', 'Home, Portfolio Detail', 'no', NULL, NULL, NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(15, 'portfolio/category', 'portfolio-category-index', 15, NULL, NULL, 'Portfolio Category', 'Home, Portfolio Category', 'no', NULL, NULL, NULL, NULL, 0, 2, 'yes', 1, NULL, NULL),
(16, 'plans', 'plan-index', 16, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"breadcrumb-style1\",\"folder\":\"breadcrumb\",\"order\":0},{\"id\":\"plan-style1\",\"folder\":\"plan\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, 'Pricing', 'Home, Plans', 'no', NULL, 'Pricing', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(17, 'careers', 'career-index', 17, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"breadcrumb-style1\",\"folder\":\"breadcrumb\",\"order\":0},{\"id\":\"career-style2\",\"folder\":\"career\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, 'Our Careers', 'Home, Our Careers', 'no', NULL, 'Career', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(18, 'career', 'career-detail-show', 18, NULL, NULL, 'Career Detail', 'Home, Career Detail', 'no', NULL, NULL, NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(19, 'blogs', 'blog-index', 19, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"breadcrumb-style1\",\"folder\":\"breadcrumb\",\"order\":0},{\"id\":\"blog-style2\",\"folder\":\"blog\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, 'Our Blogs', 'Home, Blogs', 'no', NULL, 'Our Blogs', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(20, 'blog', 'blog-detail-show', 20, NULL, NULL, 'Blog Detail', 'Home, Blog Detail', 'no', NULL, 'Blog Detail', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(21, 'blog/category', 'blog-category-index', 21, NULL, NULL, 'Blog Category', 'Home, Blog Category', 'no', NULL, NULL, NULL, NULL, 0, 2, 'yes', 1, NULL, NULL),
(22, 'blog/tag', 'blog-tag-index', 22, NULL, NULL, 'Blog Tag', 'Home, Blog Tag', 'no', NULL, NULL, NULL, NULL, 0, 2, 'yes', 1, NULL, NULL),
(23, 'blog/search', 'blog-search-index', 23, NULL, NULL, 'Search Results', 'Home, Search Results', 'no', NULL, NULL, NULL, NULL, 0, 2, 'yes', 1, NULL, NULL),
(24, 'contact', 'contact-index', 24, '[{\"id\":\"header-style1\",\"folder\":\"header\",\"order\":0},{\"id\":\"breadcrumb-style1\",\"folder\":\"breadcrumb\",\"order\":0},{\"id\":\"contact-style1\",\"folder\":\"contact\",\"order\":0},{\"id\":\"map-style1\",\"folder\":\"map\",\"order\":0},{\"id\":\"footer-style1\",\"folder\":\"footer\",\"order\":0}]', NULL, 'Contact Us', 'Home, Contact Us', 'no', NULL, 'Contact Us', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL),
(25, 'page', 'page-detail-show', 21, NULL, NULL, 'Page Detail', 'Home, Page Detail', 'no', NULL, 'Page Detail', NULL, NULL, 0, 1, 'yes', 1, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `page_names`
--
CREATE TABLE `page_names` (
`id` bigint(20) UNSIGNED NOT NULL,
`page_name` varchar(255) NOT NULL,
`is_default` enum('yes','no') NOT NULL,
`page_builder` enum('yes','no') NOT NULL,
`segment_count` int(11) NOT NULL DEFAULT 1,
`order` int(11) NOT NULL DEFAULT 0,
`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 `page_names`
--
INSERT INTO `page_names` (`id`, `page_name`, `is_default`, `page_builder`, `segment_count`, `order`, `created_at`, `updated_at`) VALUES
(1, 'public-homepage-index', 'yes', 'yes', 1, 0, NULL, NULL),
(2, 'homepage-2-index', 'yes', 'yes', 1, 0, NULL, NULL),
(3, 'homepage-3-index', 'yes', 'yes', 1, 0, NULL, NULL),
(4, 'homepage-4-index', 'yes', 'yes', 1, 0, NULL, NULL),
(5, 'about-index', 'yes', 'yes', 1, 0, NULL, NULL),
(6, 'service-index', 'yes', 'yes', 1, 0, NULL, NULL),
(7, 'service-detail-show', 'yes', 'no', 1, 0, NULL, NULL),
(8, 'service-category-index', 'yes', 'no', 2, 0, NULL, NULL),
(9, 'faq-index', 'yes', 'yes', 1, 0, NULL, NULL),
(10, 'gallery-index', 'yes', 'yes', 1, 0, NULL, NULL),
(11, 'team-index', 'yes', 'yes', 1, 0, NULL, NULL),
(12, 'team-category-index', 'yes', 'no', 2, 0, NULL, NULL),
(13, 'portfolio-index', 'yes', 'yes', 1, 0, NULL, NULL),
(14, 'portfolio-detail-show', 'yes', 'no', 1, 0, NULL, NULL),
(15, 'portfolio-category-index', 'yes', 'no', 2, 0, NULL, NULL),
(16, 'plan-index', 'yes', 'yes', 1, 0, NULL, NULL),
(17, 'career-index', 'yes', 'yes', 1, 0, NULL, NULL),
(18, 'career-detail-show', 'yes', 'no', 1, 0, NULL, NULL),
(19, 'blog-index', 'yes', 'yes', 1, 0, NULL, NULL),
(20, 'blog-detail-show', 'yes', 'no', 1, 0, NULL, NULL),
(21, 'blog-category-index', 'yes', 'no', 2, 0, NULL, NULL),
(22, 'blog-tag-index', 'yes', 'no', 2, 0, NULL, NULL),
(23, 'blog-search-index', 'yes', 'no', 2, 0, NULL, NULL),
(24, 'contact-index', 'yes', 'yes', 1, 0, NULL, NULL),
(25, 'page-detail-show', 'yes', 'no', 1, 0, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `panel_images`
--
CREATE TABLE `panel_images` (
`id` bigint(20) UNSIGNED NOT NULL,
`section_image` text DEFAULT NULL,
`section_image_2` 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 `panel_keywords`
--
CREATE TABLE `panel_keywords` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`key` text DEFAULT NULL,
`value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `panel_keywords`
--
INSERT INTO `panel_keywords` (`id`, `language_id`, `key`, `value`) VALUES
(1, 1, 'admin_role_manage', 'Admin Role Manage'),
(2, 1, 'add_admin_role', 'Add Admin Role'),
(3, 1, 'role_name', 'Role Name'),
(4, 1, 'permissions', 'Permissions'),
(5, 1, 'set_permissions_for_this_role', 'set permissions for this role'),
(6, 1, 'submit', 'Submit'),
(7, 1, 'admin_roles', 'Admin Roles'),
(8, 1, 'has_all_permissions', 'has all permissions'),
(9, 1, 'action', 'Action'),
(10, 1, 'edit_admin_role', 'Edit Admin Role'),
(11, 1, 'admin_manage', 'Admin Manage'),
(12, 1, 'all_admin', 'All Admin'),
(13, 1, 'all_admin_created_by_super_admin', 'All Admin Created By Super Admin'),
(14, 1, 'add_admin_user', 'Add Admin User'),
(15, 1, 'edit_admin_user', 'Edit Admin User'),
(16, 1, 'name', 'Name'),
(17, 1, 'email', 'Email'),
(18, 1, 'edit_email', 'Edit Email'),
(19, 1, 'new_password', 'New Password'),
(20, 1, 'confirm_password', 'Confirm Password'),
(21, 1, 'image', 'Image'),
(22, 1, 'size', 'size'),
(23, 1, 'delete', 'Delete'),
(24, 1, 'close', 'Close'),
(25, 1, 'you_wont_be_able_to_revert_this', 'You wont be able to revert this!'),
(26, 1, 'cancel', 'Cancel'),
(27, 1, 'yes_delete_it', 'Yes, delete it!'),
(28, 1, 'success', 'Success'),
(29, 1, 'warning', 'Warning'),
(30, 1, 'error', 'Error'),
(31, 1, 'created_successfully', 'Created Successfully'),
(32, 1, 'updated_successfully', 'Updated Successfully'),
(33, 1, 'deleted_successfully', 'Deleted Successfully'),
(34, 1, 'current_image', 'Current Image'),
(35, 1, 'dashboard', 'Dashboard'),
(36, 1, 'uploads', 'Uploads'),
(37, 1, 'add_photo', 'Add Photo'),
(38, 1, 'photos', 'Photos'),
(39, 1, 'order', 'Order'),
(40, 1, 'copy_image_link', 'Copy Image Link'),
(41, 1, 'edit_photo', 'Edit Photo'),
(42, 1, 'title', 'Title'),
(43, 1, 'description', 'Description'),
(44, 1, 'please_use_recommended_sizes', 'You do not have to use the recommended sizes. However, please use the recommended sizes for your site design to look its best.'),
(45, 1, 'image_status', 'Image Status'),
(46, 1, 'blogs', 'Blogs'),
(47, 1, 'categories', 'Categories'),
(48, 1, 'add_category', 'Add Category'),
(49, 1, 'edit_category', 'Edit Category'),
(50, 1, 'category_name', 'Category Name'),
(51, 1, 'please_choose', 'Please choose.'),
(52, 1, 'please_create_a_category', 'Please create a category.'),
(53, 1, 'status', 'Status'),
(54, 1, 'select_your_option', 'Select Your Option'),
(55, 1, 'not_yet_created', 'Not yet created.'),
(56, 1, 'category', 'Category'),
(57, 1, 'post_date', 'Post Date'),
(58, 1, 'view', 'View'),
(59, 1, 'add_blog', 'Add Blog'),
(60, 1, 'edit_blog', 'Edit Blog'),
(61, 1, 'short_description', 'Short Description'),
(62, 1, 'tag', 'Tag'),
(63, 1, 'separate_with_commas', 'Separate with commas'),
(64, 1, 'author', 'Author'),
(65, 1, 'with_this_account', 'With this account'),
(66, 1, 'anonymous', 'Anonymous'),
(67, 1, 'seo_optimization', 'Seo Optimization'),
(68, 1, 'meta_title', 'Meta Title'),
(69, 1, 'meta_description', 'Meta Description'),
(70, 1, 'meta_keyword', 'Meta Keyword'),
(71, 1, 'edit_breadcrumb', 'Edit Breadcrumb'),
(72, 1, 'edit_breadcrumb_and_page_seo', 'Edit Breadcrumb and Page Seo'),
(73, 1, 'breadcrumb_customization', 'Breadcrumb Customization'),
(74, 1, 'use_special_breadcrumb', 'Do you want to use special breadcrumb for the page?'),
(75, 1, 'yes', 'Yes'),
(76, 1, 'no', 'No'),
(77, 1, 'custom_breadcrumb_image', 'Custom Breadcrumb Image'),
(78, 1, 'published', 'Published'),
(79, 1, 'draft', 'Draft'),
(80, 1, 'section_item', 'Section Item'),
(81, 1, 'paginate_item', 'Paginate Item'),
(82, 1, 'section_title', 'Section Title'),
(83, 1, 'section_title_and_description', 'Section Title/Description'),
(84, 1, 'edit_section_title_description', 'Edit Section Title/Description'),
(85, 1, 'add_new', 'Add New'),
(86, 1, 'page_builder', 'Page Builder'),
(87, 1, 'page_names', 'Page Names'),
(88, 1, 'page_name', 'Page Name'),
(89, 1, 'is_default', 'Is Default'),
(90, 1, 'add_page_name', 'Add Page Name'),
(91, 1, 'edit_page_name', 'Edit Page Name'),
(92, 1, 'pages', 'Pages'),
(93, 1, 'page_uri', 'Page Uri'),
(94, 1, 'add_page', 'Add Page'),
(95, 1, 'edit_page', 'Edit Page'),
(96, 1, 'example', 'Example: '),
(97, 1, '1_segment_usage', '1 Segment Usage ->'),
(98, 1, '2_segment_usage', '2 Segment Usage ->'),
(99, 1, 'please_base_on_the_count_of_segments', 'Please base on the count of segments.'),
(100, 1, 'sections', 'Sections'),
(101, 1, 'updated_page_sections', 'Updated page sections'),
(102, 1, 'return_to_default_page_settings', 'Return to default page settings'),
(103, 1, 'yes_apply', 'Yes apply!'),
(104, 1, 'update', 'Update'),
(105, 1, 'breadcrumb_title', 'Breadcrumb Title'),
(106, 1, 'breadcrumb_item', 'Breadcrumb Item'),
(107, 1, 'page_builder_is_not_available_on_this_page', 'Page builder is not available on this page.'),
(108, 1, 'menus', 'Menus'),
(109, 1, 'menu', 'Menu'),
(110, 1, 'menu_name', 'Menu Name'),
(111, 1, 'add_menu_name', 'Add Menu Name'),
(112, 1, 'edit_menu_name', 'Edit Menu Name'),
(113, 1, 'pages_within_the_site', 'Pages within the site'),
(114, 1, 'empty', 'Empty'),
(115, 1, 'to_use_the_url_enter_empty_in_this_field', 'To use the url enter empty in this field.'),
(116, 1, 'uri', 'Uri'),
(117, 1, 'url', 'Url'),
(118, 1, 'submenu', 'Submenu'),
(119, 1, 'submenu_name', 'Submenu Name'),
(120, 1, 'add_submenu', 'Add Submenu'),
(121, 1, 'edit_submenu', 'Edit Submenu'),
(122, 1, 'reset', 'Reset'),
(123, 1, 'youtube_video_url', 'Youtube Video Url'),
(124, 1, 'pdf', 'pdf'),
(125, 1, 'history', 'History'),
(126, 1, 'add_history', 'Add History'),
(127, 1, 'edit_history', 'Edit History'),
(128, 1, 'history_date', 'History Date'),
(129, 1, 'why_choose', 'Why Choose'),
(130, 1, 'add_why_choose', 'Add Why Choose'),
(131, 1, 'edit_why_choose', 'Edit Why Choose'),
(132, 1, 'percent_rate', 'Percent Rate'),
(133, 1, 'sponsors', 'Sponsors'),
(134, 1, 'add_sponsor', 'Add Sponsor'),
(135, 1, 'edit_sponsor', 'Edit Sponsor'),
(136, 1, 'video', 'Video'),
(137, 1, 'edit_video', 'Edit Video'),
(138, 1, 'careers', 'Careers'),
(139, 1, 'add_career', 'Add Career'),
(140, 1, 'edit_career', 'Edit Career'),
(141, 1, 'edit_career_content', 'Edit Career Content'),
(142, 1, 'banner', 'Banner'),
(143, 1, 'edit_banner', 'Edit Banner'),
(144, 1, 'features', 'Features'),
(145, 1, 'add_feature', 'Add Feature'),
(146, 1, 'edit_feature', 'Edit Feature'),
(147, 1, 'type', 'Type'),
(148, 1, 'icon', 'Icon'),
(149, 1, 'back', 'Back'),
(150, 1, 'about', 'About'),
(151, 1, 'edit_about', 'Edit About'),
(152, 1, 'button_name', 'Button Name'),
(153, 1, 'button_url', 'Button Url'),
(154, 1, 'button_name_2', 'Button Name 2'),
(155, 1, 'button_url_2', 'Button Url 2'),
(156, 1, 'recommended_tags', 'Recommended tags'),
(157, 1, 'subtitle', 'Subtitle'),
(158, 1, 'price', 'Price'),
(159, 1, 'work_process', 'Work Process'),
(160, 1, 'add_work_process', 'Add Work Process'),
(161, 1, 'edit_work_process', 'Edit Work Process'),
(162, 1, 'testimonials', 'Testimonials'),
(163, 1, 'add_testimonial', 'Add Testimonial'),
(164, 1, 'edit_testimonial', 'Edit Testimonial'),
(165, 1, 'job', 'Job'),
(166, 1, 'star', 'Star'),
(167, 1, 'faqs', 'Faqs'),
(168, 1, 'add_faq', 'Add Faq'),
(169, 1, 'edit_faq', 'Edit Faq'),
(170, 1, 'answer', 'Answer'),
(171, 1, 'question', 'Question'),
(172, 1, 'plan', 'Plan'),
(173, 1, 'add_plan', 'Add Plan'),
(174, 1, 'edit_plan', 'Edit Plan'),
(175, 1, 'currency', 'Currency'),
(176, 1, 'extra_text', 'Extra Text'),
(177, 1, 'feature_list', 'Feature List'),
(178, 1, 'non_feature_list', 'Non Feature List'),
(179, 1, 'recommended', 'Recommended'),
(180, 1, 'teams', 'Teams'),
(181, 1, 'add_team', 'Add Team'),
(182, 1, 'edit_team', 'Edit Team'),
(183, 1, 'subscribe', 'Subscribe'),
(184, 1, 'edit_subscribe', 'Edit Subscribe'),
(185, 1, 'call_to_action', 'Call To Action'),
(186, 1, 'edit_call_to_action', 'Edit Call To Action'),
(187, 1, 'contact_info', 'Contact Info'),
(188, 1, 'add_contact_info', 'Add Contact Info'),
(189, 1, 'edit_contact_info', 'Edit Contact Info'),
(190, 1, 'contact', 'Contact'),
(191, 1, 'map', 'Map'),
(192, 1, 'map_iframe', 'Map Iframe (link in src)'),
(193, 1, 'map_iframe_desc_placeholder', 'Please find your address on Google Map. And click the Share Button on the Left Side. You will see the Map Placement Area. In the Copy Html field in this section Copy and paste the link in the src from the code inside.'),
(194, 1, 'footer', 'Footer'),
(195, 1, 'add_footer', 'Add Footer'),
(196, 1, 'edit_footer', 'Edit Footer'),
(197, 1, 'add_footer_category', 'Add Footer Category'),
(198, 1, 'services', 'Services'),
(199, 1, 'add_service', 'Add Service'),
(200, 1, 'edit_service', 'Edit Service'),
(201, 1, 'additional_features', 'Additional Features'),
(202, 1, 'portfolio', 'Portfolio'),
(203, 1, 'add_portfolio', 'Add Portfolio'),
(204, 1, 'edit_portfolio', 'Edit Portfolio'),
(205, 1, 'thumbnail', 'Thumbnail'),
(206, 1, 'portfolio_images', 'Portfolio Images'),
(207, 1, 'add_image', 'Add Image'),
(208, 1, 'edit_image', 'Edit Image'),
(209, 1, 'details', 'Details'),
(210, 1, 'add_detail', 'Add Detail'),
(211, 1, 'edit_detail', 'Edit Detail'),
(212, 1, 'gallery', 'Gallery'),
(213, 1, 'add_gallery', 'Add Gallery'),
(214, 1, 'edit_gallery', 'Edit Gallery'),
(215, 1, 'settings', 'Settings'),
(216, 1, 'preloader', 'Preloader'),
(217, 1, 'favicon', 'Favicon'),
(218, 1, 'header_info', 'Header Info'),
(219, 1, 'header_image', 'Header Image'),
(220, 1, 'footer_image', 'Footer Image'),
(221, 1, 'edit_footer_image', 'Edit Footer Image'),
(222, 1, 'panel_image', 'Panel Image'),
(223, 1, 'admin_logo', 'Admin Logo'),
(224, 1, 'admin_small_logo', 'Admin Small Logo'),
(225, 1, 'external_url', 'External Url'),
(226, 1, 'contact_info_widget', 'Contact Info Widget'),
(227, 1, 'breadcrumb_image', 'Breadcrumb Image'),
(228, 1, 'site_info', 'Site Info'),
(229, 1, 'edit_site_info', 'Edit Site Info'),
(230, 1, 'copyright', 'Copyright'),
(231, 1, 'socials', 'Socials'),
(232, 1, 'add_social', 'Add Social'),
(233, 1, 'edit_social', 'Edit Social'),
(234, 1, 'google_analytic', 'Google Analytic'),
(235, 1, 'font', 'Font'),
(236, 1, 'draft_view', 'Draft View'),
(237, 1, 'tawk_to', 'Tawk to'),
(238, 1, 'quick_access_buttons', 'Quick Access Buttons'),
(239, 1, 'side_buttons', 'Side Buttons'),
(240, 1, 'email_or_whatsapp', 'Email or Whatsapp'),
(241, 1, 'enable', 'Enable'),
(242, 1, 'disable', 'Disable'),
(243, 1, 'bottom_buttons', 'Bottom Buttons'),
(244, 1, 'whatsapp', 'Whatsapp'),
(245, 1, 'color_option', 'Color Option'),
(246, 1, 'ready_color_option', 'Ready Color Option'),
(247, 1, 'customize_color', 'Customize Color'),
(248, 1, 'main_color', 'Main Color'),
(249, 1, 'secondary_color', 'Secondary Color'),
(250, 1, 'scroll_button_color', 'Scroll Button Color'),
(251, 1, 'bottom_button_color', 'Bottom Button Color'),
(252, 1, 'bottom_button_hover_color', 'Bottom Button Hover Color'),
(253, 1, 'side_button_color', 'Side Button Color'),
(254, 1, 'for_pages_without_page_builder', 'for pages without page builder'),
(255, 1, 'subscribe_section', 'Subscribe Section'),
(256, 1, 'you_can_see_this_section_on_some_pages_that_do_not_have_a_page_builder', 'You can see this section on some pages that do not have a page builder'),
(257, 1, 'recent_portfolio_section', 'Recent Portfolio Section'),
(258, 1, 'messages', 'Messages'),
(259, 1, 'mark_all_as_read', 'Mark All As Read'),
(260, 1, 'phone', 'Phone'),
(261, 1, 'message', 'Message'),
(262, 1, 'read_status', 'Read Status'),
(263, 1, 'read', 'Read'),
(264, 1, 'unread', 'Unread'),
(265, 1, 'mark', 'Mark'),
(266, 1, 'seo', 'Seo'),
(267, 1, 'languages', 'Languages'),
(268, 1, 'default_site_language', 'Default Site Language'),
(269, 1, 'add_language', 'Add Language'),
(270, 1, 'language_name', 'Language Name'),
(271, 1, 'language_code', 'Language Code'),
(272, 1, 'direction', 'Direction'),
(273, 1, 'display_dropdown', 'Display Dropdown?'),
(274, 1, 'show', 'Show'),
(275, 1, 'hide', 'Hide'),
(276, 1, 'keywords', 'Keywords'),
(277, 1, 'for_admin_panel', 'For Admin Panel'),
(278, 1, 'for_frontend', 'For Frontend'),
(279, 1, 'profile', 'Profile'),
(280, 1, 'change_password', 'Change Password'),
(281, 1, 'current_password', 'Current Password'),
(282, 1, 'pending_approval', 'Pending Approval'),
(283, 1, 'approval', 'Approval'),
(284, 1, 'data_language', 'Data Language'),
(285, 1, 'which_language', 'Which language do you want to create the data?'),
(286, 1, 'reminding', 'Please note that all the entries you create will be based on your chosen language.'),
(287, 1, 'notifications', 'Notifications'),
(288, 1, 'logout', 'Logout'),
(289, 1, 'optimizer', 'Optimizer'),
(290, 1, 'required_fields', 'Fields marked are required'),
(291, 1, 'site', 'Site'),
(292, 1, 'add_keyword', 'Add Keyword'),
(293, 1, 'key', 'Key'),
(294, 1, 'value', 'Value'),
(295, 1, 'delete_selected', 'Delete selected?'),
(296, 1, 'comments', 'Comments'),
(297, 1, 'all', 'All'),
(298, 1, 'logo', 'Logo'),
(299, 1, 'see_edit', 'See Edit'),
(300, 1, 'subscribers', 'Subscribers'),
(301, 1, 'add_subscriber', 'Add Subscriber'),
(302, 1, 'default_page', 'Default Page'),
(303, 1, 'custom_page', 'Custom Page'),
(304, 1, 'language', 'Language'),
(305, 1, 'video_type', 'Video Type'),
(306, 1, 'youtube', 'Youtube'),
(307, 1, 'other', 'Other'),
(308, 1, 'video_url', 'Video Url'),
(309, 1, 'add_more', 'Add More'),
(310, 1, 'add_counter', 'Add Counter'),
(311, 1, 'edit_counter', 'Edit Counter'),
(312, 1, 'counters', 'Counters'),
(313, 1, 'timer', 'Timer'),
(314, 1, 'item', 'Item'),
(315, 1, 'segment_count', 'Segment Count: '),
(316, 1, 'select', 'Select'),
(317, 1, 'when_you_leave_this_section_blank_it_will_go_to_its_own_detail_page', 'When you leave this section blank it will go to its own detail page.'),
(318, 1, 'address', 'Address'),
(319, 1, 'working_hour', 'Working Hour'),
(320, 1, 'facebook_url', 'Facebook Url'),
(321, 1, 'twitter_url', 'Twitter Url'),
(322, 1, 'instagram_url', 'Instagram Url'),
(323, 1, 'youtube_url', 'Youtube Url'),
(324, 1, 'linkedin_url', 'Linkedin Url'),
(325, 1, 'copied_text', 'Copied Text'),
(326, 1, 'copy_url', 'Copy Url'),
(327, 1, 'the_transaction_is_invalid', 'The transaction is invalid.'),
(328, 1, 'fixed_page_setting ', 'Fixed Page Setting'),
(329, 1, 'touch', 'Touch'),
(330, 1, 'you_can_also_activate_the_breadcrumb_image_for_all_pages_from_here', 'You can also activate the breadcrumb image for all pages from here.'),
(331, 1, 'service_content', 'Service Content'),
(332, 1, 'service_info', 'Service Info'),
(333, 1, 'service_features', 'Service Features'),
(334, 1, 'add_service_feature', 'Add Service Feature'),
(335, 1, 'edit_service_feature', 'Edit Service Feature'),
(336, 1, 'edit_breadcrumb_and_seo', 'Edit Breadcrumb and Seo'),
(337, 1, 'page_url_copied', 'Page Url Copied'),
(338, 1, 'portfolio_content', 'Portfolio Content'),
(339, 1, 'portfolio_details', 'Portfolio Details'),
(340, 1, 'add_portfolio_detail', 'Add Portfolio Detail'),
(341, 1, 'edit_portfolio_detail', 'Edit Portfolio Detail'),
(342, 1, 'add_portfolio_image', 'Add Portfolio Image'),
(343, 1, 'edit_portfolio_image', 'Edit Portfolio Image'),
(344, 1, 'edit_portfolio_content', 'Edit Portfolio Content'),
(345, 1, 'company_title', 'Company Title'),
(346, 1, 'company_description', 'Company Description'),
(347, 1, 'company_contact_title', 'Company Contact Title'),
(348, 1, 'career_content', 'Career Content'),
(349, 1, 'edit_map', 'Edit Map'),
(350, 1, 'edit_service_content', 'Edit Service Content'),
(351, 1, 'edit_service_info', 'Edit Service Info'),
(352, 1, 'move', 'Move'),
(353, 1, 'style1', 'style 1'),
(354, 1, 'style2', 'style 2'),
(355, 1, 'style3', 'style 3'),
(356, 1, 'style4', 'style 4');
-- --------------------------------------------------------
--
-- Table structure for table `password_reset_tokens`
--
CREATE TABLE `password_reset_tokens` (
`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 `permissions`
--
CREATE TABLE `permissions` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`guard_name` varchar(255) NOT 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 `permissions`
--
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'upload check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(2, 'page builder check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(3, 'menu check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(4, 'blog check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(5, 'section check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(6, 'service check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(7, 'portfolio check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(8, 'team check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(9, 'gallery check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(10, 'career check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(11, 'page check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(12, 'contact message check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(13, 'subscribe check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(14, 'setting check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(15, 'language check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50'),
(16, 'clear cache check', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50');
-- --------------------------------------------------------
--
-- 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 `photos`
--
CREATE TABLE `photos` (
`id` bigint(20) UNSIGNED NOT NULL,
`gallery_image` text NOT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `photos`
--
INSERT INTO `photos` (`id`, `gallery_image`, `order`, `created_at`, `updated_at`) VALUES
(1, '1726071563-WhatsApp_Image_2023-09-25_at_8.56.17_AM-removebg-preview.png', 0, '2024-09-11 16:19:23', '2024-09-11 16:19:23');
-- --------------------------------------------------------
--
-- Table structure for table `plans`
--
CREATE TABLE `plans` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`name` text DEFAULT NULL,
`tag` text DEFAULT NULL,
`currency` text DEFAULT NULL,
`price` text DEFAULT NULL,
`extra_text` text DEFAULT NULL,
`feature_list` text DEFAULT NULL,
`non_feature_list` text DEFAULT NULL,
`button_name` text DEFAULT NULL,
`button_url` text DEFAULT NULL,
`recommended` enum('yes','no') NOT NULL DEFAULT 'no',
`order` int(11) NOT NULL DEFAULT 0,
`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 `plan_sections`
--
CREATE TABLE `plan_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`section_title` text DEFAULT NULL,
`title` 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 `portfolios`
--
CREATE TABLE `portfolios` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`category_name` varchar(255) NOT NULL,
`category_id` int(11) NOT NULL,
`title` text NOT NULL,
`section_image` text DEFAULT NULL,
`portfolio_slug` text NOT NULL,
`status` enum('published','draft') NOT NULL DEFAULT 'published',
`url` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `portfolio_categories`
--
CREATE TABLE `portfolio_categories` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`category_name` varchar(255) NOT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`status` int(11) NOT NULL,
`portfolio_category_slug` varchar(255) NOT 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 `portfolio_contents`
--
CREATE TABLE `portfolio_contents` (
`id` bigint(20) UNSIGNED NOT NULL,
`portfolio_id` bigint(20) UNSIGNED NOT NULL,
`section_image` text DEFAULT NULL,
`description` longtext DEFAULT NULL,
`breadcrumb_status` enum('yes','no') NOT NULL DEFAULT 'no',
`custom_breadcrumb_image` text DEFAULT NULL,
`meta_description` text DEFAULT NULL,
`meta_keyword` 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 `portfolio_details`
--
CREATE TABLE `portfolio_details` (
`id` bigint(20) UNSIGNED NOT NULL,
`portfolio_id` bigint(20) UNSIGNED NOT NULL,
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `portfolio_detail_sections`
--
CREATE TABLE `portfolio_detail_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`portfolio_id` bigint(20) UNSIGNED NOT NULL,
`title` 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 `portfolio_images`
--
CREATE TABLE `portfolio_images` (
`id` bigint(20) UNSIGNED NOT NULL,
`portfolio_id` bigint(20) UNSIGNED NOT NULL,
`section_image` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `portfolio_sections`
--
CREATE TABLE `portfolio_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`section_title` text DEFAULT NULL,
`title` text DEFAULT NULL,
`button_name` text DEFAULT NULL,
`button_url` text DEFAULT NULL,
`section_item` int(11) NOT NULL DEFAULT 6,
`paginate_item` int(11) NOT NULL DEFAULT 12,
`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 `preloaders`
--
CREATE TABLE `preloaders` (
`id` bigint(20) UNSIGNED NOT NULL,
`status` enum('enable','disable') NOT NULL DEFAULT 'enable',
`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 `roles`
--
CREATE TABLE `roles` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`guard_name` varchar(255) NOT 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 `roles`
--
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'super-admin', 'web', '2024-03-18 08:12:50', '2024-03-18 08:12:50');
-- --------------------------------------------------------
--
-- Table structure for table `role_has_permissions`
--
CREATE TABLE `role_has_permissions` (
`permission_id` bigint(20) UNSIGNED NOT NULL,
`role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `seos`
--
CREATE TABLE `seos` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`meta_title` text DEFAULT NULL,
`meta_description` text DEFAULT NULL,
`meta_keyword` text DEFAULT NULL,
`fb_app_id` 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 `services`
--
CREATE TABLE `services` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`category_name` varchar(255) NOT NULL,
`category_id` int(11) NOT NULL,
`type` enum('icon','image') NOT NULL,
`icon` varchar(255) DEFAULT NULL,
`section_image` text DEFAULT NULL,
`section_image_2` text DEFAULT NULL,
`title` text NOT NULL,
`short_description` text DEFAULT NULL,
`service_slug` text NOT NULL,
`status` enum('published','draft') NOT NULL DEFAULT 'published',
`button_name` text DEFAULT NULL,
`button_url` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `services`
--
INSERT INTO `services` (`id`, `language_id`, `style`, `category_name`, `category_id`, `type`, `icon`, `section_image`, `section_image_2`, `title`, `short_description`, `service_slug`, `status`, `button_name`, `button_url`, `order`, `created_at`, `updated_at`) VALUES
(1, 1, 'style1', 'a', 1, 'image', '', '1729014863-L7 750X400.jpg', '1729014863-L3.jpg', 'dgdgdgggdgdgtjyukul', 'opl.k.kj.k.', 'dgdgdgggdgdgtjyukul', 'published', 'efffssmkk', '', 0, '2024-10-15 17:54:23', '2024-10-15 17:54:23');
-- --------------------------------------------------------
--
-- Table structure for table `service_categories`
--
CREATE TABLE `service_categories` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`category_name` varchar(255) NOT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`status` int(11) NOT NULL,
`service_category_slug` varchar(255) NOT 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 `service_categories`
--
INSERT INTO `service_categories` (`id`, `language_id`, `category_name`, `order`, `status`, `service_category_slug`, `created_at`, `updated_at`) VALUES
(1, 1, 'a', 1, 1, 'a', '2024-10-15 17:53:28', '2024-10-15 17:53:28'),
(2, 1, 'b', 1, 1, 'b', '2024-10-15 17:53:39', '2024-10-15 17:53:39');
-- --------------------------------------------------------
--
-- Table structure for table `service_contents`
--
CREATE TABLE `service_contents` (
`id` bigint(20) UNSIGNED NOT NULL,
`service_id` bigint(20) UNSIGNED NOT NULL,
`section_image` text DEFAULT NULL,
`description` longtext DEFAULT NULL,
`breadcrumb_status` enum('yes','no') NOT NULL DEFAULT 'no',
`custom_breadcrumb_image` text DEFAULT NULL,
`meta_description` text DEFAULT NULL,
`meta_keyword` 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 `service_features`
--
CREATE TABLE `service_features` (
`id` bigint(20) UNSIGNED NOT NULL,
`service_id` bigint(20) UNSIGNED NOT NULL,
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `service_feature_sections`
--
CREATE TABLE `service_feature_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`service_id` bigint(20) UNSIGNED NOT NULL,
`title` 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 `service_infos`
--
CREATE TABLE `service_infos` (
`id` bigint(20) UNSIGNED NOT NULL,
`service_id` bigint(20) UNSIGNED NOT NULL,
`video_type` enum('youtube','other') DEFAULT NULL,
`video_url` text DEFAULT NULL,
`section_image` text DEFAULT NULL,
`title` text DEFAULT NULL,
`item` 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 `service_sections`
--
CREATE TABLE `service_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`section_title` text DEFAULT NULL,
`title` text DEFAULT NULL,
`button_name` text DEFAULT NULL,
`button_url` text DEFAULT NULL,
`section_item` int(11) NOT NULL DEFAULT 6,
`paginate_item` int(11) NOT NULL DEFAULT 12,
`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 `sessions`
--
CREATE TABLE `sessions` (
`id` varchar(255) NOT NULL,
`user_id` bigint(20) UNSIGNED DEFAULT NULL,
`ip_address` varchar(45) DEFAULT NULL,
`user_agent` text DEFAULT NULL,
`payload` longtext NOT NULL,
`last_activity` int(11) NOT NULL
) 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
('1l6WQIwaizZMPjbuoYpE8BEBHhhzCL9EwdtyCTBw', NULL, '34.73.73.157', 'ZoominfoBot (zoominfobot at zoominfo dot com)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSWFYNFdaT1o5TUFySVF3N2JHdlhNUjFCeWVsNzc1NWdCMEJrYjIzeiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyOToiaHR0cHM6Ly93d3cuYmhhd2VzaHRoYWt1ci5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1730072022),
('1RLsvalEYZ7est10DnTzeJqblmHUiejXdAQ6Xgf4', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoidG9IcnB5TTJNM2JLVU9aekc2clRZSFlhT2VFSjZhZ1ZnRzBCM0FnUiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730061893),
('2cZlATlWQCLFtGPxcJVsgiZ9eh3EpOv1KQMo6t3G', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNHdmSlpDcjZXVlZBYllxbE5zWFlPMmxUTWZpQjVpZlU4bUU0b0hEQSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730060555),
('65blM6JDYotM72pgfBxFLpdcV9N9uyILcUfrzO7a', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoidURCSUtldU5hdEZpUWRidVZjTEUxd1pHSjdBbmlBODhBeGEwN2ZCSiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730064846),
('7cfcH42zZIM7T90aO0D2AIkuhvbPudV2pPVoAYJa', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWkVXZE9XSjdDRWxnQTN1dEt1c0VibTViUWR5b05lQTRvcGw0bEpIQiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730062479),
('9xgdsTYLwoKywskQ7TI1WyKaMISa2oHuRx5qvneY', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoicWozNFpmWGo0REUxajdXVWloMEpMSFB6c0ZWcW5vc3ZTN1dHYU16bCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730059862),
('aB266QOCnpT094f3ewrSH4PmBxgB0c7oKPt1l5M5', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZ2JoYkZLNjlSQ1h1MU85a0FPRVdwbm1lakEwczZVSkxNMTN3VXU2VCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730066577),
('akFT2F6Hap5TlSAfX3VSC9hRfzupnNtZ7fCj7pjY', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoicXRVQmlGamRGTXFCUHcycktuS1JKOFl3RmZiNTVjazR2RTViOTBnWiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730063817),
('avOnP03xRZExqLY1BqVJWq4sdQTNCq1Jd3xa3xrc', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSDFpcGhRVEEwWkduQTRUN2NDdkJXYXZSMVJ2N1dGS2NmaDYxZ0tIWCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730059297),
('B10eNJL4KVRGtYCphqDDbclaFayOzHbTUrnkuWIs', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTlZJZU5ESWl5cm1KVndWSUszMm53cElWbWNoMzFyU05KNmhlWGdpeSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730064781),
('bEGH2HAP3KfuCY1yv76lWBVGWelCQREWkBnAjyqa', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiS2tHYlUzNXhzemc2dGxYUlZMbW9jYUFnWHVCWmxwaE1jNVcweUhsVyI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730060525),
('bqleuQ3HnLzCRq6VPCUp7HQ9HbTU1xswLLvfvxlh', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOWlWYWwwMHB4d01YUkxaNldpUjU5UmlZcG11RENZZnR1Tk5yQzV2dCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730064698),
('cVG3Drh4wiLo5whLR91lHx2fgwxU9lOJ3SKH30dL', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoieHY1TU5EQ2ZTMGhoejhwMTNlSWRzWnZGbnlrWFV1MDFlTzNGN2l2UyI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730066366),
('dRSueMxINTMLsrMJPWbQy0nk2F92udKrNQabyI0I', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiYUVVNUdoWWhJcHlCTGNIWFFJaVpEQ2NkWFptaGJqVExGbnNFQmN1OSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730062082),
('EBcGLLfP67S0MHX9133TZQ87vHRmC0AwJQrB2aQ3', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoibzJFVjBwa09zbzRiTklLNWxicVVGNk9zdkEzbTdXbmNOU1BJNUkzdiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730063062),
('ERIfJ60kMs8ZTFktHGEOy71hGEuKODuqwqlOqoIH', NULL, '2602:ffe4:8:1001::5', 'Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; spider-feedback@bytedance.com)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiaFlEd1FleGpUUDVKdm43bmRtQzVFd1JlQ3V2Y3VVWVZrNHFUc2ZDWiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo4NDoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS9hc3NldHMvZnJvbnQvaW1nL2hpc3RvcnkvcG9ydGZvbGlvXzE2Mjc5NTE4MTIxNjg3MDEzMTAuanBnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730100074),
('Err34966y9egkTLz5GeZuok9Vil7ZtxA9yIqURIQ', NULL, '42.83.147.53', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko)Chrome/74.0.3729.169 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWFpaOVRkY01BTkRYSTVGSzBVc3FzNE9hOGdoR2wwazExUFdoMDNUbCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyNToiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1730084838),
('ETgzzHrjJgaGE8cW7ODSn2mKIWOfIhsYe3lS3NWZ', NULL, '159.203.46.229', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZHJOSlhqRHo0dTk1WHNnUU1WM1h5dGNWZjZmcmp6M241bUZhNHNTTiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyNToiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1730058366),
('FA1OOlhSesQCn1lI4d9rJNT9eJuZFVx7hN8ntNZx', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZ3hlNDFBU3ZsbDFwajU1NHo5UHB4bmdINXRZYlRVbDYyVEFLSWt4cyI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730061977),
('GlxKUcPjDHC5uOcXQMMnCn7YDpXfBzfE3ENyq1vs', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMjM0WmZ5VlRoc0RyMGpscUhFNUxwWmo5NHZXZXJpWU9IUXpMdUNyOSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730062748),
('HM2jUeK7AgVCQZCoW59gEE2G8inmvni4KLLjMvHJ', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoib2NZTDZycHZnYk9BWVFCSFNHdmd6YTdRODRnMnNsc05TRVdXRmNNUSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730061451),
('IF5ZP13SAwNsb1c5unsfAeES5wedEjCNvjRIooxq', NULL, '34.73.73.157', 'ZoominfoBot (zoominfobot at zoominfo dot com)', 'YToxMDp7czo2OiJfdG9rZW4iO3M6NDA6IkttUTdhMVNVeUZRWHMzdHlNSjh3bHVwNWtWb2dHMW9qS2xsc2ZVY3oiO3M6MTg6ImZsYXNoZXI6OmVudmVsb3BlcyI7YTowOnt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjE6Imh0dHBzOi8vd3d3LmJoYXdlc2h0aGFrdXIuY29tL2xhbmd1YWdlL3NldC1sb2NhbGUvMS8tYnJhY2tldC0iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjI1OiJsYW5ndWFnZV9pZF9mcm9tX2Ryb3Bkb3duIjtzOjE6IjEiO3M6Mjc6Imxhbmd1YWdlX25hbWVfZnJvbV9kcm9wZG93biI7czo3OiJFbmdsaXNoIjtzOjI3OiJsYW5ndWFnZV9jb2RlX2Zyb21fZHJvcGRvd24iO3M6MjoiZW4iO3M6MTM6Imxhbmd1YWdlX2NvZGUiO3M6MjoiZW4iO3M6MzI6Imxhbmd1YWdlX2RpcmVjdGlvbl9mcm9tX2Ryb3Bkb3duIjtpOjA7czozNToibGFuZ3VhZ2VfZGVmYXVsdF9zaXRlX2Zyb21fZHJvcGRvd24iO2k6MTt9', 1730072021),
('ikuFY5ZQ8n12U3lVBebCd9CRDhgQyKQWJicS4nIp', NULL, '134.209.35.33', 'curl/7.76.1', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiV2tYUlR2ekplZnF0dTU4cHczUnZKUGhyamdDcVJVYXdzcUlDOWJHcCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNzoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS9saWNlbnNlLnR4dCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1730072050),
('Im5tYgDTtzSuFfb63JKyiIOpoAjbD2D7WHoV2qeE', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoibWhVQWV1Y0xyV0RCRHVyVTZ3aUJNdnlZQWlDSG1GQnBWWUVqOVJOdyI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730060078),
('inpeiydNz0IyjDBLFFd5dalrp7GP1ksWPoEC2TqP', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWThuNzlmUHlZQVh2Y2pKM2hscGVYOTU2ODNLd2IzUEpGSnRreE1uciI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730064264),
('IQTHouySuC8MUp6SFdsbdx2NJSd2v7XAepBBO2r3', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMTczY1dZWE5CQjE3OFBaRGM4dEs5ZEhidUplQUdUUGpGN0FnVUVnNSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730057708),
('iUJPQGdzc6UCCoGGO79GKeNCKZqLNpnAEdAQkM0g', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiU1FWTGprOVVlc0lZTzE3b2RqbHdhc0lNYUZWRUZYdUxnamJCMVVmNSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730059973),
('j06d2aowB7WGRX7EiXpMeAfYVAOxER2F8UJd1lr5', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMTZnOGJMeThrS2dYV09KdmtRZklBM0x0N2t2WlN6M05jeVh5RmZHbSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730058518),
('kGEOfuLFg0xVJT2vh4sPR06kubzvvlXKg7SZ5V7m', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiY1U0UnlxNk9aR1NDMG11S2hOdWxndmNLc0w3cDJYOTI1YmZSTTNYbCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730064377),
('KGPF4UoM7PMYCrsN8luCGOVBGnhY5zqX1WpcUPJU', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoidEsyTm0yTEtvOUdjcE92bWUxbURmT2tOWkljREVtWmxmNHNId2xNUCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730063040),
('KM7L8yqNL59AySkdbceFRtlISy5i2i2oeqXADycF', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRmw2SUxnTktENzlPazNNVVJTWk9qWFR5MkNwNDFEQ2VUdU9wVnZySSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730062246),
('lphrmvN8Q0sMeOqX7yz5Bl22PBpFbvfpTUPTjnXJ', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZlhSMDJZa3lLVktiQTAxcGo0bjJlVFVrdzNzUzBNY25GYUc3T3EzSCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730057070),
('m6CO8XJsCuesrSRdyykLiGmbtBIHChdfXvHcZrrR', NULL, '2a12:5940:5433::2', 'Mozilla/5.0 (Linux; Android 10; Redmi Note 8 Pro) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.181 Mobile Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMEV0RGVMOGo0OEQ5UWVLbGFJREZUTzl2aGRFd0FwNW9wSWdZTXd4cSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyNToiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1730064093),
('MWr0S1qxcVRp72c6boU6h57VmVCMVUIQ3DjNCHfT', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiaTJqeXRWYnF3RjFkb2sxQnk5ZTc2M3hJZU5yS3ppb2xmOHdRd1JPUSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730065898),
('NT1rxqUhewZxlQbqEXyAj7QLKIFVFCPwdjgqge0B', NULL, '2001:bc8:1201:71:b283:feff:fed1:1d64', 'Mozilla/5.0 (X11; Linux x86_64; rv:130.0) Gecko/20100101 Firefox/130.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTllLWXJpTnNXRTlrUGVzQXhKMzY0NEVxeXhPS2xRRzBpUmdzQlhYTCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyNToiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1730099219),
('nurhUJBO3NreAJxQyM4iu0xrY6fAcLSF81XKe11a', NULL, '157.55.39.193', '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', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMkY5MDJwaWRuME5EaG5EVjIwWU1QbWRtQ1JQOHFJUHV6eXRoTG90RCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozMToiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS9wbGFucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1730063231),
('nxlYy696JHyoYTCyjs6wDaTF1x6Pngf6yqP3Nwrw', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoidmVHZEtpR2FIME9oMnhpN0FSeWxLVEpma1c5T3AzRERDSktudWY5RCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730062893),
('oaJs5mlMnz1aWgUFyftR3XQXsl42EZN035DHS3j3', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQzg2QVFpOEFoQmVlOFdLREJzeFFLRllqbER2dnVxVjJUMDFaakR0MiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730059275),
('onrxdOXUcPDOfv2ww4hP2jZXu9FxNxBMSY54mYrv', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZGpHRDUyZ1VBME9UOXh0M0pYSHpQQmFLVEgzOEpCMzY1SjZkSjVxVyI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730065379),
('OswEEFBFLqlhTFPiX0p2tCFWBRFNdXD83clPj4jI', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiV2dycWNtUWIybVQ2akROMGR1TG9yM1VOaElDeUE4MGtOTmV3QWFMYiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730060164),
('P5w4rknnxl1Sa2R5BJ3PUcbHAbm3SUshjJaxigk0', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWTZ2NktrdjJ1UGJ0ZVd5eGlaeVBvcUZIOVN6MjVWRWhlcUZyZDEwcSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730059392),
('P7BRHlxOwR9vo9u6o4AiVGzPHVZaMFauiDvJL1nI', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTDlaVzdGeFhsMUJ0WVE5Rm9CbmphZ3dhSEFPMFZISGdueW5hanF0cCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730058795),
('pIeWXP95SZtq2VLNz3X507k2AoIcpeXZhiPhPNhv', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiallVdjlyN0tvR2tBMzRoUHZVOGxXYkhhQXhCWkFUWWdCaWlsc0FrcyI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730057221),
('pyPU8QEpqm60dN1oZDK0xO55Tpjytew5meABzWc2', NULL, '114.119.145.129', 'Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiempBWmZKWERpSjNUcXVTaHRtR1NrQXNXTnFVU0JSd1VYOWFHT3V3aSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0ODoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS8/bmJtYm0lMkZjMjEwMTIxLmh0bWw9Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730058873),
('s5AHZgHOUMAhysp9IgRWjP8ap3yg3eApk92dliZU', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTkk1YUpiQnhUNHhkMzlHZ1l3ZlBDRmRrbW9uS09WTW1EdHlwYkd6diI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730057750),
('tqakzBSARGy6p3AHygOUOq8WnTt1rDBYIMl6y0LD', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiYWFWRjRzUWRsNXFucUVaejgyOTM2dk55QUNvMHNQbkxqUkFSMzZvSSI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730064655),
('uhf2uE2CMlRyEqD3fz4aBLjhyu2ILlekfxArVUiP', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoibngxYlN5dkxoQXN2dzlWZHNxVTNZNDZpYmJEdzA4TksyZTJPVlY0RiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730066788),
('vgXtaWQBx8B9Byhg1a2cVRA0cgAstVaDGpvSGAVh', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiakpaRjEyN09UcmhpdDJ0QU11VFN6bGxGTDA1MlFpQWtXOTViYTlpdiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730062124),
('wOsS4YTcytirNv94W8muOSeacgbSNRXaSFdER6m0', NULL, '35.237.90.131', 'ZoominfoBot (zoominfobot at zoominfo dot com)', 'YToxMDp7czo2OiJfdG9rZW4iO3M6NDA6IkNpUmRxQno5YzZxeVA1Y2FialM4SEZCSTl3NmNYWTQ0a2M4THYxNkIiO3M6MTg6ImZsYXNoZXI6OmVudmVsb3BlcyI7YTowOnt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vYmhhd2VzaHRoYWt1ci5jb20vdGVhbXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjI1OiJsYW5ndWFnZV9pZF9mcm9tX2Ryb3Bkb3duIjtzOjE6IjEiO3M6Mjc6Imxhbmd1YWdlX25hbWVfZnJvbV9kcm9wZG93biI7czo3OiJFbmdsaXNoIjtzOjI3OiJsYW5ndWFnZV9jb2RlX2Zyb21fZHJvcGRvd24iO3M6MjoiZW4iO3M6MTM6Imxhbmd1YWdlX2NvZGUiO3M6MjoiZW4iO3M6MzI6Imxhbmd1YWdlX2RpcmVjdGlvbl9mcm9tX2Ryb3Bkb3duIjtpOjA7czozNToibGFuZ3VhZ2VfZGVmYXVsdF9zaXRlX2Zyb21fZHJvcGRvd24iO2k6MTt9', 1730066323),
('wQ7swRAkoGeyr1p7xdK05jhQKOLveqvddqNpE4lo', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWHpsdmRrdzI4Mm1vNU5oS0xxcHAydWY0aGJsajNCWEFTSEY5T2NCYiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730061070),
('wYUg3m8EKgWn94UkFRwEmN3y1Hh5y2iU0JncHMWl', NULL, '193.233.141.88', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1264.71', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWmhvUGVqdm8wSUwxYjk0bWxrWEVOMEpsbXdBZk1DZ2lOUElkZGZIUiI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozMzoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS9jb250YWN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730067454),
('XBJfJ9hehgtYQFYU557CTgE7XTOJZCdKzedQ7hk5', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOHdlSG5kRUNEdU1hSmFzcG1ieXRLdk9MT3lyTjdxWVkzSmpNejBkTCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730058666),
('y3fkhYTwDpENOLPVdPvH1n60UBcZmJSfBLhDME23', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSkZFVnpxcUxRaWZadEVCQXV6Wmx5WDlXbkhtQVM5ZlFocjRKcFp5dCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730062395),
('y7Ohz5PONqFs4lNMbKVmOjzdtRl8xECFiQy7iPLh', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSUxJb25HQWJqWDhqNFpRUXAyNVRmVU0wRjFzYlNIQlBHMGs0VUdWUyI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730057137),
('ZLWo122V4YJXzSLVvDsNFuOYKKQA91aa6jtragkr', NULL, '148.252.156.90', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTzl5S2tHUE5XN3FFZ2dYYWFlU1ZXemFsYktsSVpNRXFrRlRGaHo2UCI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNjoiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbS94bWxycGMucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1730062727),
('ztW5qPIXQxEs3yZi4JOKcLlCIOo5fVLlhUdrpWO0', NULL, '36.41.75.167', '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', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTmg5UVgwcFhiaU9DaEhqbGE2ejIyd3JCcmR2MUl1WDZNWHNoVktGciI7czoxODoiZmxhc2hlcjo6ZW52ZWxvcGVzIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyNToiaHR0cHM6Ly9iaGF3ZXNodGhha3VyLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1730098258);
-- --------------------------------------------------------
--
-- Table structure for table `side_button_widgets`
--
CREATE TABLE `side_button_widgets` (
`id` bigint(20) UNSIGNED NOT NULL,
`social_media` varchar(255) NOT NULL,
`link` varchar(255) DEFAULT NULL,
`status` enum('enable','disable') NOT NULL DEFAULT 'enable',
`contact` varchar(255) NOT NULL,
`email_or_whatsapp` varchar(255) DEFAULT NULL,
`status_whatsapp` enum('enable','disable') NOT NULL DEFAULT 'enable',
`phone` varchar(255) DEFAULT NULL,
`status_phone` enum('enable','disable') NOT NULL DEFAULT 'enable',
`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 `site_infos`
--
CREATE TABLE `site_infos` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`description` text DEFAULT NULL,
`copyright` 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 `socials`
--
CREATE TABLE `socials` (
`id` bigint(20) UNSIGNED NOT NULL,
`social_media` varchar(255) NOT NULL,
`url` varchar(255) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`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 `sponsors`
--
CREATE TABLE `sponsors` (
`id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_image` text DEFAULT NULL,
`url` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `submenus`
--
CREATE TABLE `submenus` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`menu_id` int(11) NOT NULL,
`menu_name` varchar(255) NOT NULL,
`submenu_name` text NOT NULL,
`uri` text DEFAULT NULL,
`url` text DEFAULT NULL,
`view` int(11) NOT NULL DEFAULT 0,
`status` enum('published','draft') NOT NULL DEFAULT 'published',
`order` int(11) NOT NULL DEFAULT 0,
`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 `submenus`
--
INSERT INTO `submenus` (`id`, `language_id`, `menu_id`, `menu_name`, `submenu_name`, `uri`, `url`, `view`, `status`, `order`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'Home', 'Home Default', '/', NULL, 0, 'published', 0, NULL, NULL),
(2, 1, 1, 'Home', 'Home Particles', 'index-2', NULL, 0, 'published', 0, NULL, NULL),
(3, 1, 1, 'Home', 'Home Slider', 'index-3', NULL, 0, 'published', 0, NULL, NULL),
(4, 1, 1, 'Home', 'Home Video', 'index-4', NULL, 0, 'published', 0, NULL, NULL),
(5, 1, 3, 'Services', 'Services', 'services', NULL, 0, 'published', 0, NULL, NULL),
(6, 1, 4, 'Pages', 'Faqs', 'faqs', NULL, 0, 'published', 0, NULL, NULL),
(7, 1, 4, 'Pages', 'Gallery', 'gallery', NULL, 0, 'published', 0, NULL, NULL),
(8, 1, 4, 'Pages', 'Teams', 'teams', NULL, 0, 'published', 0, NULL, NULL),
(9, 1, 4, 'Pages', 'Portfolio', 'portfolios', NULL, 0, 'published', 0, NULL, NULL),
(10, 1, 4, 'Pages', 'Plans', 'plans', NULL, 0, 'published', 0, NULL, NULL),
(11, 1, 4, 'Pages', 'Career', 'careers', NULL, 0, 'published', 0, NULL, NULL),
(12, 1, 5, 'News', 'Blogs', 'blogs', NULL, 0, 'published', 0, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `subscribes`
--
CREATE TABLE `subscribes` (
`id` bigint(20) UNSIGNED NOT NULL,
`email` text NOT 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 `subscribe_sections`
--
CREATE TABLE `subscribe_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`title` 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 `tawk_tos`
--
CREATE TABLE `tawk_tos` (
`id` bigint(20) UNSIGNED NOT NULL,
`tawk_to` 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 `teams`
--
CREATE TABLE `teams` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`category_name` varchar(255) NOT NULL,
`category_id` int(11) NOT NULL,
`section_image` text DEFAULT NULL,
`name` text NOT NULL,
`job` text DEFAULT NULL,
`facebook_url` text DEFAULT NULL,
`twitter_url` text DEFAULT NULL,
`instagram_url` text DEFAULT NULL,
`youtube_url` text DEFAULT NULL,
`linkedin_url` text DEFAULT NULL,
`team_slug` text NOT NULL,
`status` enum('published','draft') NOT NULL DEFAULT 'published',
`order` int(11) NOT NULL DEFAULT 0,
`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 `teams`
--
INSERT INTO `teams` (`id`, `language_id`, `style`, `category_name`, `category_id`, `section_image`, `name`, `job`, `facebook_url`, `twitter_url`, `instagram_url`, `youtube_url`, `linkedin_url`, `team_slug`, `status`, `order`, `created_at`, `updated_at`) VALUES
(1, 1, 'style1', 'mk', 1, '1729014943-Black and Green Modern Business Tips Instagram Post.png', 'Bhawesh Thakur', 'hhhhh', 'https://greenhealth4you.com/', '', '', '', '', 'bhawesh-thakur', 'published', 0, '2024-10-15 17:55:43', '2024-10-15 17:55:43');
-- --------------------------------------------------------
--
-- Table structure for table `team_categories`
--
CREATE TABLE `team_categories` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`category_name` varchar(255) NOT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`status` int(11) NOT NULL,
`team_category_slug` varchar(255) NOT 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 `team_categories`
--
INSERT INTO `team_categories` (`id`, `language_id`, `category_name`, `order`, `status`, `team_category_slug`, `created_at`, `updated_at`) VALUES
(1, 1, 'mk', 1, 1, 'mk', '2024-10-15 17:54:59', '2024-10-15 17:54:59');
-- --------------------------------------------------------
--
-- Table structure for table `team_sections`
--
CREATE TABLE `team_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`section_title` text DEFAULT NULL,
`title` text DEFAULT NULL,
`button_name` text DEFAULT NULL,
`button_url` text DEFAULT NULL,
`section_item` int(11) NOT NULL DEFAULT 3,
`paginate_item` int(11) NOT NULL DEFAULT 12,
`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 `testimonials`
--
CREATE TABLE `testimonials` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_image` text DEFAULT NULL,
`name` text DEFAULT NULL,
`job` text DEFAULT NULL,
`description` text DEFAULT NULL,
`star` int(11) NOT NULL DEFAULT 0,
`order` int(11) NOT NULL DEFAULT 0,
`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 `testimonial_sections`
--
CREATE TABLE `testimonial_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_title` text DEFAULT NULL,
`title` 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 `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,
`two_factor_secret` text DEFAULT NULL,
`two_factor_recovery_codes` text DEFAULT NULL,
`two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`current_team_id` bigint(20) UNSIGNED DEFAULT NULL,
`profile_photo_path` varchar(2048) DEFAULT NULL,
`type` int(11) 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`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `remember_token`, `current_team_id`, `profile_photo_path`, `type`, `created_at`, `updated_at`) VALUES
(1, 'Super-Admin User', 'superadmin16@bhaweshthakur.com', '2024-03-18 08:12:51', '$2y$10$Pv2zD4r0AtcjbfB3LPLG2e5Un/1RDP2blaLBG3M5qKPSMK32IhgtK', NULL, NULL, NULL, 'pWzph3YjiKrbJ48TGAOmMiTcVWgZ8oUk710Zs08YchE2HvOBnDFeurMeLKRY', NULL, NULL, 0, '2024-03-18 08:12:51', '2024-03-18 08:12:51');
-- --------------------------------------------------------
--
-- Table structure for table `video_sections`
--
CREATE TABLE `video_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_image` text DEFAULT NULL,
`video_type` enum('youtube','other') DEFAULT NULL,
`video_url` text DEFAULT NULL,
`title` 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 `video_sections`
--
INSERT INTO `video_sections` (`id`, `language_id`, `style`, `section_image`, `video_type`, `video_url`, `title`, `created_at`, `updated_at`) VALUES
(1, 1, 'style1', '1726072104-454445356_1411537476200760_630695487709827636_n.jpg', 'other', '', '', '2024-09-11 16:28:24', '2024-09-11 16:28:24');
-- --------------------------------------------------------
--
-- Table structure for table `why_chooses`
--
CREATE TABLE `why_chooses` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`timer` text DEFAULT NULL,
`title` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `why_choose_sections`
--
CREATE TABLE `why_choose_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_image` text DEFAULT NULL,
`section_title` text DEFAULT NULL,
`title` text DEFAULT NULL,
`description` text DEFAULT NULL,
`item` 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 `work_processes`
--
CREATE TABLE `work_processes` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_image` text DEFAULT NULL,
`title` text DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT 0,
`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 `work_processes`
--
INSERT INTO `work_processes` (`id`, `language_id`, `style`, `section_image`, `title`, `order`, `created_at`, `updated_at`) VALUES
(1, 1, 'style1', '1729014748-yt 2048x1152.jpg', 'dfdff', 1, '2024-10-15 17:52:28', '2024-10-15 17:52:28');
-- --------------------------------------------------------
--
-- Table structure for table `work_process_sections`
--
CREATE TABLE `work_process_sections` (
`id` bigint(20) UNSIGNED NOT NULL,
`language_id` bigint(20) UNSIGNED NOT NULL,
`style` enum('style1') NOT NULL DEFAULT 'style1',
`section_title` text DEFAULT NULL,
`title` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `about_sections`
--
ALTER TABLE `about_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `about_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `about_section_features`
--
ALTER TABLE `about_section_features`
ADD PRIMARY KEY (`id`),
ADD KEY `about_section_features_language_id_foreign` (`language_id`);
--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
ADD PRIMARY KEY (`id`),
ADD KEY `banners_language_id_foreign` (`language_id`);
--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
ADD PRIMARY KEY (`id`),
ADD KEY `blogs_language_id_foreign` (`language_id`);
--
-- Indexes for table `blog_sections`
--
ALTER TABLE `blog_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `blog_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `bottom_button_widgets`
--
ALTER TABLE `bottom_button_widgets`
ADD PRIMARY KEY (`id`),
ADD KEY `bottom_button_widgets_language_id_foreign` (`language_id`);
--
-- Indexes for table `breadcrumb_images`
--
ALTER TABLE `breadcrumb_images`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `call_to_actions`
--
ALTER TABLE `call_to_actions`
ADD PRIMARY KEY (`id`),
ADD KEY `call_to_actions_language_id_foreign` (`language_id`);
--
-- Indexes for table `careers`
--
ALTER TABLE `careers`
ADD PRIMARY KEY (`id`),
ADD KEY `careers_language_id_foreign` (`language_id`);
--
-- Indexes for table `career_categories`
--
ALTER TABLE `career_categories`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `career_categories_category_name_unique` (`category_name`),
ADD KEY `career_categories_language_id_foreign` (`language_id`);
--
-- Indexes for table `career_contents`
--
ALTER TABLE `career_contents`
ADD PRIMARY KEY (`id`),
ADD KEY `career_contents_career_id_foreign` (`career_id`);
--
-- Indexes for table `career_sections`
--
ALTER TABLE `career_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `career_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `categories_category_name_unique` (`category_name`),
ADD KEY `categories_language_id_foreign` (`language_id`);
--
-- Indexes for table `color_options`
--
ALTER TABLE `color_options`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `contact_infos`
--
ALTER TABLE `contact_infos`
ADD PRIMARY KEY (`id`),
ADD KEY `contact_infos_language_id_foreign` (`language_id`);
--
-- Indexes for table `contact_info_sections`
--
ALTER TABLE `contact_info_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `contact_info_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `contact_info_widgets`
--
ALTER TABLE `contact_info_widgets`
ADD PRIMARY KEY (`id`),
ADD KEY `contact_info_widgets_language_id_foreign` (`language_id`);
--
-- Indexes for table `contact_messages`
--
ALTER TABLE `contact_messages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `counters`
--
ALTER TABLE `counters`
ADD PRIMARY KEY (`id`),
ADD KEY `counters_language_id_foreign` (`language_id`);
--
-- Indexes for table `counter_sections`
--
ALTER TABLE `counter_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `counter_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `draft_views`
--
ALTER TABLE `draft_views`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `external_urls`
--
ALTER TABLE `external_urls`
ADD PRIMARY KEY (`id`),
ADD KEY `external_urls_language_id_foreign` (`language_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 `faqs`
--
ALTER TABLE `faqs`
ADD PRIMARY KEY (`id`),
ADD KEY `faqs_language_id_foreign` (`language_id`);
--
-- Indexes for table `faq_sections`
--
ALTER TABLE `faq_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `faq_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `favicons`
--
ALTER TABLE `favicons`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `features`
--
ALTER TABLE `features`
ADD PRIMARY KEY (`id`),
ADD KEY `features_language_id_foreign` (`language_id`);
--
-- Indexes for table `feature_sections`
--
ALTER TABLE `feature_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `feature_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `fonts`
--
ALTER TABLE `fonts`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `footers`
--
ALTER TABLE `footers`
ADD PRIMARY KEY (`id`),
ADD KEY `footers_language_id_foreign` (`language_id`);
--
-- Indexes for table `footer_categories`
--
ALTER TABLE `footer_categories`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `footer_categories_category_name_unique` (`category_name`),
ADD KEY `footer_categories_language_id_foreign` (`language_id`);
--
-- Indexes for table `footer_images`
--
ALTER TABLE `footer_images`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `frontend_keywords`
--
ALTER TABLE `frontend_keywords`
ADD PRIMARY KEY (`id`),
ADD KEY `frontend_keywords_language_id_foreign` (`language_id`);
--
-- Indexes for table `gallery_images`
--
ALTER TABLE `gallery_images`
ADD PRIMARY KEY (`id`),
ADD KEY `gallery_images_language_id_foreign` (`language_id`);
--
-- Indexes for table `gallery_image_sections`
--
ALTER TABLE `gallery_image_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `gallery_image_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `google_analytics`
--
ALTER TABLE `google_analytics`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `header_images`
--
ALTER TABLE `header_images`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `header_infos`
--
ALTER TABLE `header_infos`
ADD PRIMARY KEY (`id`),
ADD KEY `header_infos_language_id_foreign` (`language_id`);
--
-- Indexes for table `histories`
--
ALTER TABLE `histories`
ADD PRIMARY KEY (`id`),
ADD KEY `histories_language_id_foreign` (`language_id`);
--
-- Indexes for table `history_sections`
--
ALTER TABLE `history_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `history_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `maps`
--
ALTER TABLE `maps`
ADD PRIMARY KEY (`id`),
ADD KEY `maps_language_id_foreign` (`language_id`);
--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `menus_menu_name_unique` (`menu_name`),
ADD KEY `menus_language_id_foreign` (`language_id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);
--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);
--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
ADD PRIMARY KEY (`id`),
ADD KEY `pages_language_id_foreign` (`language_id`);
--
-- Indexes for table `page_builders`
--
ALTER TABLE `page_builders`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `page_builders_page_uri_unique` (`page_uri`);
--
-- Indexes for table `page_names`
--
ALTER TABLE `page_names`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `page_names_page_name_unique` (`page_name`);
--
-- Indexes for table `panel_images`
--
ALTER TABLE `panel_images`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `panel_keywords`
--
ALTER TABLE `panel_keywords`
ADD PRIMARY KEY (`id`),
ADD KEY `panel_keywords_language_id_foreign` (`language_id`);
--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
ADD PRIMARY KEY (`email`);
--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);
--
-- 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 `photos`
--
ALTER TABLE `photos`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
ADD PRIMARY KEY (`id`),
ADD KEY `plans_language_id_foreign` (`language_id`);
--
-- Indexes for table `plan_sections`
--
ALTER TABLE `plan_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `plan_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `portfolios`
--
ALTER TABLE `portfolios`
ADD PRIMARY KEY (`id`),
ADD KEY `portfolios_language_id_foreign` (`language_id`);
--
-- Indexes for table `portfolio_categories`
--
ALTER TABLE `portfolio_categories`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `portfolio_categories_category_name_unique` (`category_name`),
ADD KEY `portfolio_categories_language_id_foreign` (`language_id`);
--
-- Indexes for table `portfolio_contents`
--
ALTER TABLE `portfolio_contents`
ADD PRIMARY KEY (`id`),
ADD KEY `portfolio_contents_portfolio_id_foreign` (`portfolio_id`);
--
-- Indexes for table `portfolio_details`
--
ALTER TABLE `portfolio_details`
ADD PRIMARY KEY (`id`),
ADD KEY `portfolio_details_portfolio_id_foreign` (`portfolio_id`);
--
-- Indexes for table `portfolio_detail_sections`
--
ALTER TABLE `portfolio_detail_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `portfolio_detail_sections_portfolio_id_foreign` (`portfolio_id`);
--
-- Indexes for table `portfolio_images`
--
ALTER TABLE `portfolio_images`
ADD PRIMARY KEY (`id`),
ADD KEY `portfolio_images_portfolio_id_foreign` (`portfolio_id`);
--
-- Indexes for table `portfolio_sections`
--
ALTER TABLE `portfolio_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `portfolio_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `preloaders`
--
ALTER TABLE `preloaders`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);
--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
ADD PRIMARY KEY (`permission_id`,`role_id`),
ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);
--
-- Indexes for table `seos`
--
ALTER TABLE `seos`
ADD PRIMARY KEY (`id`),
ADD KEY `seos_language_id_foreign` (`language_id`);
--
-- Indexes for table `services`
--
ALTER TABLE `services`
ADD PRIMARY KEY (`id`),
ADD KEY `services_language_id_foreign` (`language_id`);
--
-- Indexes for table `service_categories`
--
ALTER TABLE `service_categories`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `service_categories_category_name_unique` (`category_name`),
ADD KEY `service_categories_language_id_foreign` (`language_id`);
--
-- Indexes for table `service_contents`
--
ALTER TABLE `service_contents`
ADD PRIMARY KEY (`id`),
ADD KEY `service_contents_service_id_foreign` (`service_id`);
--
-- Indexes for table `service_features`
--
ALTER TABLE `service_features`
ADD PRIMARY KEY (`id`),
ADD KEY `service_features_service_id_foreign` (`service_id`);
--
-- Indexes for table `service_feature_sections`
--
ALTER TABLE `service_feature_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `service_feature_sections_service_id_foreign` (`service_id`);
--
-- Indexes for table `service_infos`
--
ALTER TABLE `service_infos`
ADD PRIMARY KEY (`id`),
ADD KEY `service_infos_service_id_foreign` (`service_id`);
--
-- Indexes for table `service_sections`
--
ALTER TABLE `service_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `service_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
ADD PRIMARY KEY (`id`),
ADD KEY `sessions_user_id_index` (`user_id`),
ADD KEY `sessions_last_activity_index` (`last_activity`);
--
-- Indexes for table `side_button_widgets`
--
ALTER TABLE `side_button_widgets`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `site_infos`
--
ALTER TABLE `site_infos`
ADD PRIMARY KEY (`id`),
ADD KEY `site_infos_language_id_foreign` (`language_id`);
--
-- Indexes for table `socials`
--
ALTER TABLE `socials`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sponsors`
--
ALTER TABLE `sponsors`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `submenus`
--
ALTER TABLE `submenus`
ADD PRIMARY KEY (`id`),
ADD KEY `submenus_language_id_foreign` (`language_id`);
--
-- Indexes for table `subscribes`
--
ALTER TABLE `subscribes`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `subscribe_sections`
--
ALTER TABLE `subscribe_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `subscribe_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `tawk_tos`
--
ALTER TABLE `tawk_tos`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `teams`
--
ALTER TABLE `teams`
ADD PRIMARY KEY (`id`),
ADD KEY `teams_language_id_foreign` (`language_id`);
--
-- Indexes for table `team_categories`
--
ALTER TABLE `team_categories`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `team_categories_category_name_unique` (`category_name`),
ADD KEY `team_categories_language_id_foreign` (`language_id`);
--
-- Indexes for table `team_sections`
--
ALTER TABLE `team_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `team_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
ADD PRIMARY KEY (`id`),
ADD KEY `testimonials_language_id_foreign` (`language_id`);
--
-- Indexes for table `testimonial_sections`
--
ALTER TABLE `testimonial_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `testimonial_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_email_unique` (`email`);
--
-- Indexes for table `video_sections`
--
ALTER TABLE `video_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `video_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `why_chooses`
--
ALTER TABLE `why_chooses`
ADD PRIMARY KEY (`id`),
ADD KEY `why_chooses_language_id_foreign` (`language_id`);
--
-- Indexes for table `why_choose_sections`
--
ALTER TABLE `why_choose_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `why_choose_sections_language_id_foreign` (`language_id`);
--
-- Indexes for table `work_processes`
--
ALTER TABLE `work_processes`
ADD PRIMARY KEY (`id`),
ADD KEY `work_processes_language_id_foreign` (`language_id`);
--
-- Indexes for table `work_process_sections`
--
ALTER TABLE `work_process_sections`
ADD PRIMARY KEY (`id`),
ADD KEY `work_process_sections_language_id_foreign` (`language_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `about_sections`
--
ALTER TABLE `about_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `about_section_features`
--
ALTER TABLE `about_section_features`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `blog_sections`
--
ALTER TABLE `blog_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bottom_button_widgets`
--
ALTER TABLE `bottom_button_widgets`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `breadcrumb_images`
--
ALTER TABLE `breadcrumb_images`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `call_to_actions`
--
ALTER TABLE `call_to_actions`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `careers`
--
ALTER TABLE `careers`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `career_categories`
--
ALTER TABLE `career_categories`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `career_contents`
--
ALTER TABLE `career_contents`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `career_sections`
--
ALTER TABLE `career_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `color_options`
--
ALTER TABLE `color_options`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `contact_infos`
--
ALTER TABLE `contact_infos`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `contact_info_sections`
--
ALTER TABLE `contact_info_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `contact_info_widgets`
--
ALTER TABLE `contact_info_widgets`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `contact_messages`
--
ALTER TABLE `contact_messages`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `counters`
--
ALTER TABLE `counters`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `counter_sections`
--
ALTER TABLE `counter_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `draft_views`
--
ALTER TABLE `draft_views`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `external_urls`
--
ALTER TABLE `external_urls`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `faq_sections`
--
ALTER TABLE `faq_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `favicons`
--
ALTER TABLE `favicons`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `features`
--
ALTER TABLE `features`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `feature_sections`
--
ALTER TABLE `feature_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `fonts`
--
ALTER TABLE `fonts`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `footers`
--
ALTER TABLE `footers`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `footer_categories`
--
ALTER TABLE `footer_categories`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `footer_images`
--
ALTER TABLE `footer_images`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `frontend_keywords`
--
ALTER TABLE `frontend_keywords`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT for table `gallery_images`
--
ALTER TABLE `gallery_images`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `gallery_image_sections`
--
ALTER TABLE `gallery_image_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `google_analytics`
--
ALTER TABLE `google_analytics`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `header_images`
--
ALTER TABLE `header_images`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `header_infos`
--
ALTER TABLE `header_infos`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `histories`
--
ALTER TABLE `histories`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `history_sections`
--
ALTER TABLE `history_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `maps`
--
ALTER TABLE `maps`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `page_builders`
--
ALTER TABLE `page_builders`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `page_names`
--
ALTER TABLE `page_names`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `panel_images`
--
ALTER TABLE `panel_images`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `panel_keywords`
--
ALTER TABLE `panel_keywords`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=357;
--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- 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 `photos`
--
ALTER TABLE `photos`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `plan_sections`
--
ALTER TABLE `plan_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `portfolios`
--
ALTER TABLE `portfolios`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `portfolio_categories`
--
ALTER TABLE `portfolio_categories`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `portfolio_contents`
--
ALTER TABLE `portfolio_contents`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `portfolio_details`
--
ALTER TABLE `portfolio_details`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `portfolio_detail_sections`
--
ALTER TABLE `portfolio_detail_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `portfolio_images`
--
ALTER TABLE `portfolio_images`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `portfolio_sections`
--
ALTER TABLE `portfolio_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `preloaders`
--
ALTER TABLE `preloaders`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `seos`
--
ALTER TABLE `seos`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `service_categories`
--
ALTER TABLE `service_categories`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `service_contents`
--
ALTER TABLE `service_contents`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `service_features`
--
ALTER TABLE `service_features`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `service_feature_sections`
--
ALTER TABLE `service_feature_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `service_infos`
--
ALTER TABLE `service_infos`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `service_sections`
--
ALTER TABLE `service_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `side_button_widgets`
--
ALTER TABLE `side_button_widgets`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `site_infos`
--
ALTER TABLE `site_infos`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `socials`
--
ALTER TABLE `socials`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `sponsors`
--
ALTER TABLE `sponsors`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `submenus`
--
ALTER TABLE `submenus`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `subscribes`
--
ALTER TABLE `subscribes`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `subscribe_sections`
--
ALTER TABLE `subscribe_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tawk_tos`
--
ALTER TABLE `tawk_tos`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `teams`
--
ALTER TABLE `teams`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `team_categories`
--
ALTER TABLE `team_categories`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `team_sections`
--
ALTER TABLE `team_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `testimonial_sections`
--
ALTER TABLE `testimonial_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `video_sections`
--
ALTER TABLE `video_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `why_chooses`
--
ALTER TABLE `why_chooses`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `why_choose_sections`
--
ALTER TABLE `why_choose_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `work_processes`
--
ALTER TABLE `work_processes`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `work_process_sections`
--
ALTER TABLE `work_process_sections`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `about_sections`
--
ALTER TABLE `about_sections`
ADD CONSTRAINT `about_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `about_section_features`
--
ALTER TABLE `about_section_features`
ADD CONSTRAINT `about_section_features_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `banners`
--
ALTER TABLE `banners`
ADD CONSTRAINT `banners_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `blogs`
--
ALTER TABLE `blogs`
ADD CONSTRAINT `blogs_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `blog_sections`
--
ALTER TABLE `blog_sections`
ADD CONSTRAINT `blog_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `bottom_button_widgets`
--
ALTER TABLE `bottom_button_widgets`
ADD CONSTRAINT `bottom_button_widgets_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `call_to_actions`
--
ALTER TABLE `call_to_actions`
ADD CONSTRAINT `call_to_actions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `careers`
--
ALTER TABLE `careers`
ADD CONSTRAINT `careers_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `career_categories`
--
ALTER TABLE `career_categories`
ADD CONSTRAINT `career_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `career_contents`
--
ALTER TABLE `career_contents`
ADD CONSTRAINT `career_contents_career_id_foreign` FOREIGN KEY (`career_id`) REFERENCES `careers` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `career_sections`
--
ALTER TABLE `career_sections`
ADD CONSTRAINT `career_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
ADD CONSTRAINT `categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `contact_infos`
--
ALTER TABLE `contact_infos`
ADD CONSTRAINT `contact_infos_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `contact_info_sections`
--
ALTER TABLE `contact_info_sections`
ADD CONSTRAINT `contact_info_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `contact_info_widgets`
--
ALTER TABLE `contact_info_widgets`
ADD CONSTRAINT `contact_info_widgets_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `counters`
--
ALTER TABLE `counters`
ADD CONSTRAINT `counters_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `counter_sections`
--
ALTER TABLE `counter_sections`
ADD CONSTRAINT `counter_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `external_urls`
--
ALTER TABLE `external_urls`
ADD CONSTRAINT `external_urls_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `faqs`
--
ALTER TABLE `faqs`
ADD CONSTRAINT `faqs_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `faq_sections`
--
ALTER TABLE `faq_sections`
ADD CONSTRAINT `faq_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `features`
--
ALTER TABLE `features`
ADD CONSTRAINT `features_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `feature_sections`
--
ALTER TABLE `feature_sections`
ADD CONSTRAINT `feature_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `footers`
--
ALTER TABLE `footers`
ADD CONSTRAINT `footers_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `footer_categories`
--
ALTER TABLE `footer_categories`
ADD CONSTRAINT `footer_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `frontend_keywords`
--
ALTER TABLE `frontend_keywords`
ADD CONSTRAINT `frontend_keywords_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `gallery_images`
--
ALTER TABLE `gallery_images`
ADD CONSTRAINT `gallery_images_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `gallery_image_sections`
--
ALTER TABLE `gallery_image_sections`
ADD CONSTRAINT `gallery_image_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `header_infos`
--
ALTER TABLE `header_infos`
ADD CONSTRAINT `header_infos_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `histories`
--
ALTER TABLE `histories`
ADD CONSTRAINT `histories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `history_sections`
--
ALTER TABLE `history_sections`
ADD CONSTRAINT `history_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `maps`
--
ALTER TABLE `maps`
ADD CONSTRAINT `maps_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `menus`
--
ALTER TABLE `menus`
ADD CONSTRAINT `menus_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- 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 `pages`
--
ALTER TABLE `pages`
ADD CONSTRAINT `pages_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `panel_keywords`
--
ALTER TABLE `panel_keywords`
ADD CONSTRAINT `panel_keywords_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `plans`
--
ALTER TABLE `plans`
ADD CONSTRAINT `plans_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `plan_sections`
--
ALTER TABLE `plan_sections`
ADD CONSTRAINT `plan_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `portfolios`
--
ALTER TABLE `portfolios`
ADD CONSTRAINT `portfolios_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `portfolio_categories`
--
ALTER TABLE `portfolio_categories`
ADD CONSTRAINT `portfolio_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `portfolio_contents`
--
ALTER TABLE `portfolio_contents`
ADD CONSTRAINT `portfolio_contents_portfolio_id_foreign` FOREIGN KEY (`portfolio_id`) REFERENCES `portfolios` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `portfolio_details`
--
ALTER TABLE `portfolio_details`
ADD CONSTRAINT `portfolio_details_portfolio_id_foreign` FOREIGN KEY (`portfolio_id`) REFERENCES `portfolios` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `portfolio_detail_sections`
--
ALTER TABLE `portfolio_detail_sections`
ADD CONSTRAINT `portfolio_detail_sections_portfolio_id_foreign` FOREIGN KEY (`portfolio_id`) REFERENCES `portfolios` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `portfolio_images`
--
ALTER TABLE `portfolio_images`
ADD CONSTRAINT `portfolio_images_portfolio_id_foreign` FOREIGN KEY (`portfolio_id`) REFERENCES `portfolios` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `portfolio_sections`
--
ALTER TABLE `portfolio_sections`
ADD CONSTRAINT `portfolio_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`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;
--
-- Constraints for table `seos`
--
ALTER TABLE `seos`
ADD CONSTRAINT `seos_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `services`
--
ALTER TABLE `services`
ADD CONSTRAINT `services_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `service_categories`
--
ALTER TABLE `service_categories`
ADD CONSTRAINT `service_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `service_contents`
--
ALTER TABLE `service_contents`
ADD CONSTRAINT `service_contents_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `service_features`
--
ALTER TABLE `service_features`
ADD CONSTRAINT `service_features_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `service_feature_sections`
--
ALTER TABLE `service_feature_sections`
ADD CONSTRAINT `service_feature_sections_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `service_infos`
--
ALTER TABLE `service_infos`
ADD CONSTRAINT `service_infos_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `service_sections`
--
ALTER TABLE `service_sections`
ADD CONSTRAINT `service_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `site_infos`
--
ALTER TABLE `site_infos`
ADD CONSTRAINT `site_infos_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `submenus`
--
ALTER TABLE `submenus`
ADD CONSTRAINT `submenus_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `subscribe_sections`
--
ALTER TABLE `subscribe_sections`
ADD CONSTRAINT `subscribe_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `teams`
--
ALTER TABLE `teams`
ADD CONSTRAINT `teams_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `team_categories`
--
ALTER TABLE `team_categories`
ADD CONSTRAINT `team_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `team_sections`
--
ALTER TABLE `team_sections`
ADD CONSTRAINT `team_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `testimonials`
--
ALTER TABLE `testimonials`
ADD CONSTRAINT `testimonials_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `testimonial_sections`
--
ALTER TABLE `testimonial_sections`
ADD CONSTRAINT `testimonial_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `video_sections`
--
ALTER TABLE `video_sections`
ADD CONSTRAINT `video_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `why_chooses`
--
ALTER TABLE `why_chooses`
ADD CONSTRAINT `why_chooses_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `why_choose_sections`
--
ALTER TABLE `why_choose_sections`
ADD CONSTRAINT `why_choose_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `work_processes`
--
ALTER TABLE `work_processes`
ADD CONSTRAINT `work_processes_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `work_process_sections`
--
ALTER TABLE `work_process_sections`
ADD CONSTRAINT `work_process_sections_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`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 */;