-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 03, 2022 at 05:38 AM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 7.4.33
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: `jobsite`
--
-- --------------------------------------------------------
--
-- Table structure for table `ad`
--
CREATE TABLE `ad` (
`id` bigint(20) UNSIGNED NOT NULL,
`ad_home_cat_right` longtext DEFAULT NULL,
`ad_home_gvtsection_top` longtext DEFAULT NULL,
`ad_home_pvtsection_top` longtext DEFAULT NULL,
`ad_blogsection_top` longtext DEFAULT NULL,
`ad_footer_home_top` longtext DEFAULT NULL,
`ad_singlejob_top` longtext DEFAULT NULL,
`ad_singlejob_rightside` longtext DEFAULT NULL,
`ad_catarchivejob_right` longtext 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 `ad`
--
INSERT INTO `ad` (`id`, `ad_home_cat_right`, `ad_home_gvtsection_top`, `ad_home_pvtsection_top`, `ad_blogsection_top`, `ad_footer_home_top`, `ad_singlejob_top`, `ad_singlejob_rightside`, `ad_catarchivejob_right`, `created_at`, `updated_at`) VALUES
(1, '<img src=\"https://dummyimage.com/400x340/bfbfbf/ffffff&text=AD\" alt=\"\" class=\"w-100\" />', '<img src=\"https://dummyimage.com/1200x150/bdbdbd/fff&text=ad\" alt=\"\" width=\"100%\" height=\"auto\">', '<img src=\"https://dummyimage.com/1200x150/bdbdbd/fff&text=ad\" alt=\"\" width=\"100%\" height=\"auto\">', '<img src=\"https://dummyimage.com/1200x150/bdbdbd/fff&text=ad\" alt=\"\" width=\"100%\" height=\"auto\">', '<img src=\"https://dummyimage.com/1200x150/bdbdbd/fff&text=ad\" alt=\"\" width=\"100%\" height=\"auto\">', '<img src=\"https://dummyimage.com/1200x150/bdbdbd/fff&text=ad\" alt=\"\" width=\"100%\" height=\"auto\">', '<img src=\"https://dummyimage.com/400x400/000/fff\" alt=\"\" width=\"100%\"><br>', '<img src=\"https://dummyimage.com/400x400/000/fff\" alt=\"\" width=\"100%\"><br><br>\r\n<img src=\"https://dummyimage.com/400x400/000/fff\" alt=\"\" width=\"100%\"><br>', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `blog`
--
CREATE TABLE `blog` (
`id` bigint(20) UNSIGNED NOT NULL,
`blog_title` varchar(255) DEFAULT NULL,
`blog_description` longtext DEFAULT NULL,
`blog_image` varchar(255) DEFAULT NULL,
`blog_meta_title` varchar(255) DEFAULT NULL,
`blog_meta_description` longtext DEFAULT NULL,
`blog_status` varchar(255) DEFAULT NULL,
`blog_slug` varchar(255) DEFAULT NULL,
`blog_views` varchar(255) DEFAULT '0',
`blog_published_date` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `blog`
--
INSERT INTO `blog` (`id`, `blog_title`, `blog_description`, `blog_image`, `blog_meta_title`, `blog_meta_description`, `blog_status`, `blog_slug`, `blog_views`, `blog_published_date`, `created_at`, `updated_at`) VALUES
(1, 'How To Improve Your Communication Skills in 2022', 'How To Improve Your Communication Skills in 2022', 'public/image/blog/637244fa086d6.jpg', 'How To Improve Your Communication Skills in 2022', 'sdfsdf', '1', 'how-to-improve-your-communication-skills-in-2022', '10', '10/11/2022', NULL, NULL),
(3, 'This is 2 How To Improve Your Communication', 'This is 2 How To Improve Your Communication', 'public/image/blog/6372474763d9c.jpg', 'How To Improve Your Communication Skills in 2022', 'dasdasds', '1', 'this-is-2-how-to-improve-your-communication', '13', '10/11/2022', NULL, NULL),
(4, '3 NUmber How To Improve Your Communication', '3 NUmber How To Improve Your Communication', 'public/image/blog/6372475eb87f1.jpg', 'How To Improve Your Communication Skills in 2022', 'asdasdasdas', '1', '3-number-how-to-improve-your-communication', '2', '10/11/2022', NULL, NULL),
(5, '4 Blog How To Improve Your Communication', '4 Blog How To Improve Your Communication', 'public/image/blog/63724e65ca379.jpg', 'How To Improve Your Communication Skills in 2022', 'dasdasdasdas', '1', '4-blog-how-to-improve-your-communication', '10', '10/11/2022', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`id` bigint(20) UNSIGNED NOT NULL,
`category_name` varchar(255) 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;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (`id`, `category_name`, `category_slug`, `created_at`, `updated_at`) VALUES
(1, 'IT', 'it', NULL, NULL),
(3, 'HR & Admin', 'hr-admin', NULL, NULL),
(4, 'Electrician', 'electrician', NULL, NULL),
(5, 'Software Enginner', 'software-enginner', NULL, NULL),
(6, 'Executive', 'executive', NULL, NULL),
(7, 'Sales Manager', 'sales-manager', NULL, NULL),
(8, 'Accounting', 'accounting', NULL, NULL),
(9, 'Web Developer', 'web-developer', NULL, NULL),
(10, 'Graphics Designer', 'graphics-designer', NULL, NULL),
(11, 'Content Writer', 'content-writer', NULL, NULL),
(12, 'Pion', 'pion', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `companies`
--
CREATE TABLE `companies` (
`id` bigint(20) UNSIGNED NOT NULL,
`company_name` varchar(255) NOT NULL,
`company_short_form` varchar(255) DEFAULT NULL,
`company_logo` varchar(255) DEFAULT NULL,
`company_web` varchar(255) DEFAULT NULL,
`company_slug` varchar(255) DEFAULT NULL,
`font_page` int(255) DEFAULT NULL,
`company_type` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `companies`
--
INSERT INTO `companies` (`id`, `company_name`, `company_short_form`, `company_logo`, `company_web`, `company_slug`, `font_page`, `company_type`, `created_at`, `updated_at`) VALUES
(2, 'Bangladesh Development Board', 'BWDB', 'public/image/companyimage/63722cd3631cd.png', '#', 'bangladesh-development-board', 1, '1', NULL, NULL),
(3, 'Tengamara Songo', 'TMSS', 'public/image/companyimage/63722c7a43a68.png', '#', 'tengamara-songo', 1, '2', NULL, NULL),
(4, 'Bangladesh Bridge Board', 'BBB', 'public/image/companyimage/63722d0d29ace.png', 'http://tmitstore.com/', 'bangladesh-bridge-board', 1, '1', NULL, NULL),
(5, 'TM IT STORE', 'TM IT', 'public/image/companyimage/63722d5885ba9.jpg', 'http://tmitstore.com/', 'tm-it-store', 1, '2', NULL, NULL),
(6, 'Shaid Amon Company', 'SAC', 'public/image/companyimage/63722d9748fda.png', '#', 'shaid-amon-company', 1, '2', NULL, NULL),
(7, 'Bangladesh Education Board', 'BEB', 'public/image/companyimage/63722dae06f4d.png', '#', 'bangladesh-education-board', 1, '1', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `employeeedutions`
--
CREATE TABLE `employeeedutions` (
`id` bigint(20) UNSIGNED NOT NULL,
`candidate_id` int(11) DEFAULT NULL,
`psc_roll` varchar(255) DEFAULT NULL,
`psc_year` varchar(255) DEFAULT NULL,
`psc_school` varchar(255) DEFAULT NULL,
`jsc_roll` varchar(255) DEFAULT NULL,
`jsc_year` varchar(255) DEFAULT NULL,
`jsc_school` varchar(255) DEFAULT NULL,
`ssc_examname` varchar(255) DEFAULT NULL,
`ssc_major` varchar(255) DEFAULT NULL,
`ssc_board` varchar(255) DEFAULT NULL,
`ssc_year` varchar(255) DEFAULT NULL,
`ssc_roll` varchar(255) DEFAULT NULL,
`ssc_regi` varchar(255) DEFAULT NULL,
`ssc_result_nature` varchar(255) DEFAULT NULL,
`ssc_result` varchar(255) DEFAULT NULL,
`hsc_examname` varchar(255) DEFAULT NULL,
`hsc_major` varchar(255) DEFAULT NULL,
`hsc_board` varchar(255) DEFAULT NULL,
`hsc_year` varchar(255) DEFAULT NULL,
`hsc_roll` varchar(255) DEFAULT NULL,
`hsc_regi` varchar(255) DEFAULT NULL,
`hsc_result_nature` varchar(255) DEFAULT NULL,
`hsc_result` varchar(255) DEFAULT NULL,
`b_exam_name` varchar(255) DEFAULT NULL,
`b_result_nature` varchar(255) DEFAULT NULL,
`b_subject` varchar(255) DEFAULT NULL,
`b_result` varchar(255) DEFAULT NULL,
`b_institute` varchar(255) DEFAULT NULL,
`b_pass_year` varchar(255) DEFAULT NULL,
`b_pass_time` varchar(255) DEFAULT NULL,
`ms_exam_name` varchar(255) DEFAULT NULL,
`ms_result_nature` varchar(255) DEFAULT NULL,
`ms_subject` varchar(255) DEFAULT NULL,
`ms_result` varchar(255) DEFAULT NULL,
`ms_institute` varchar(255) DEFAULT NULL,
`ms_pass_year` varchar(255) DEFAULT NULL,
`ms_pass_time` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `employeeedutions`
--
INSERT INTO `employeeedutions` (`id`, `candidate_id`, `psc_roll`, `psc_year`, `psc_school`, `jsc_roll`, `jsc_year`, `jsc_school`, `ssc_examname`, `ssc_major`, `ssc_board`, `ssc_year`, `ssc_roll`, `ssc_regi`, `ssc_result_nature`, `ssc_result`, `hsc_examname`, `hsc_major`, `hsc_board`, `hsc_year`, `hsc_roll`, `hsc_regi`, `hsc_result_nature`, `hsc_result`, `b_exam_name`, `b_result_nature`, `b_subject`, `b_result`, `b_institute`, `b_pass_year`, `b_pass_time`, `ms_exam_name`, `ms_result_nature`, `ms_subject`, `ms_result`, `ms_institute`, `ms_pass_year`, `ms_pass_time`, `created_at`, `updated_at`) VALUES
(10, 27, '02156', '2019', 'ACP School', '45665', '2022', 'ACP School', 'ssc', 'Science', 'rajshahi', '2018', '562421', '575489652', NULL, '4.56', 'HSC', 'Science', 'Rajshahi', '2020', '575548', '5745892', NULL, '5.00', 'BSC in Engineering', NULL, 'CSE', '3.35', 'Dhaka University', '2019', '03 Year', 'MSC In Engineering', NULL, 'CSE', '3.30', 'Dhaka University', '2028', '2 year', '2022-11-10 09:15:46', '2022-11-10 09:15:46'),
(13, 30, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-11-23 05:39:33', '2022-11-23 05:39:33');
-- --------------------------------------------------------
--
-- Table structure for table `employeeinfos`
--
CREATE TABLE `employeeinfos` (
`id` bigint(20) UNSIGNED NOT NULL,
`candidate_id` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`name_bangle` varchar(255) DEFAULT NULL,
`father_name` varchar(255) DEFAULT NULL,
`father_name_bangla` varchar(255) DEFAULT NULL,
`mother_name` varchar(255) DEFAULT NULL,
`mother_name_bangla` varchar(255) DEFAULT NULL,
`date_of_birth` date DEFAULT NULL,
`gender` varchar(255) DEFAULT NULL,
`religion` varchar(255) DEFAULT NULL,
`birth_certificate_no` varchar(255) DEFAULT NULL,
`nid` varchar(255) DEFAULT NULL,
`passport_no` varchar(255) DEFAULT NULL,
`nationality` varchar(255) DEFAULT NULL,
`maritial_status` varchar(255) DEFAULT NULL,
`husband_or_spouse_name` varchar(255) DEFAULT NULL,
`quota` varchar(255) DEFAULT NULL,
`mobile_no` varchar(255) DEFAULT NULL,
`pa_name` varchar(255) DEFAULT NULL,
`pa_division` varchar(255) DEFAULT NULL,
`pa_zela` varchar(255) DEFAULT NULL,
`pa_thana` varchar(255) DEFAULT NULL,
`pa_postoffice` varchar(255) DEFAULT NULL,
`pa_post_code` varchar(255) DEFAULT NULL,
`pa_village_road` varchar(255) DEFAULT NULL,
`ca_name` varchar(255) DEFAULT NULL,
`ca_division` varchar(255) DEFAULT NULL,
`ca_zela` varchar(255) DEFAULT NULL,
`ca_thana` varchar(255) DEFAULT NULL,
`ca_postoffice` varchar(255) DEFAULT NULL,
`ca_post_code` varchar(255) DEFAULT NULL,
`ca_village_road` varchar(255) DEFAULT NULL,
`profession_vision` longtext DEFAULT NULL,
`profession_overview` longtext DEFAULT NULL,
`personal_image` varchar(255) DEFAULT NULL,
`rf1_name` varchar(255) DEFAULT NULL,
`rf1_designation` varchar(255) DEFAULT NULL,
`rf1_organization` varchar(255) DEFAULT NULL,
`rf1_mobile` varchar(255) DEFAULT NULL,
`rf1_email` varchar(255) DEFAULT NULL,
`rf2_name` varchar(255) DEFAULT NULL,
`rf2_designation` varchar(255) DEFAULT NULL,
`rf2_organization` varchar(255) DEFAULT NULL,
`rf2_mobile` varchar(255) DEFAULT NULL,
`rf2_email` varchar(255) DEFAULT NULL,
`personal_signature` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `employeeinfos`
--
INSERT INTO `employeeinfos` (`id`, `candidate_id`, `name`, `name_bangle`, `father_name`, `father_name_bangla`, `mother_name`, `mother_name_bangla`, `date_of_birth`, `gender`, `religion`, `birth_certificate_no`, `nid`, `passport_no`, `nationality`, `maritial_status`, `husband_or_spouse_name`, `quota`, `mobile_no`, `pa_name`, `pa_division`, `pa_zela`, `pa_thana`, `pa_postoffice`, `pa_post_code`, `pa_village_road`, `ca_name`, `ca_division`, `ca_zela`, `ca_thana`, `ca_postoffice`, `ca_post_code`, `ca_village_road`, `profession_vision`, `profession_overview`, `personal_image`, `rf1_name`, `rf1_designation`, `rf1_organization`, `rf1_mobile`, `rf1_email`, `rf2_name`, `rf2_designation`, `rf2_organization`, `rf2_mobile`, `rf2_email`, `personal_signature`, `created_at`, `updated_at`) VALUES
(5, '27', 'Md. Tanzim Hossen', 'Md. Tanzim Hossen', 'Md. Tofazzal Hossen', 'মো: তোফাজ্জল হোসেন', 'Most. Ruma Begum', 'মোছা: রুমা বেগম', '2022-10-03', '1', '1', '432423234', '245784563214', '42323234234', NULL, '1', 'Jesmin Ara', '1', '+8801774137135', 'Tofazzal Hossain', 'Dhaka', 'Bogura', 'Shajahanpur', 'Ranirhat', '5800', 'Zora dhakkin Para', 'Tofazzal Hossain', 'Rajshahi', 'Bogura', 'Shajahanpur', 'Ranirhat', '5800', 'Zora dhakkin Para', 'Seeking a challenging position in a technical organization that can provide me with an opportunity to improve my skills and strengths in conjunction with the organization goals and to attain excellence through experience.', 'Seeking a challenging position in a technical organization that can provide me with an opportunity to improve my skills and strengths in conjunction with the organization goals and to attain excellence through experience.', 'public/image/user/636e43773ed56.jpg', 'Tanzim', 'Director', 'TM IT', '+8801774137135', 'tasiftanzim2@gmail.com', 'Tanzim 2', 'Director2', 'TM IT2', '+88017741371352', 'tasiftanzim2@gmail.com2', 'public/image/user/637ca9c164968.png', '2022-11-10 09:15:46', '2022-11-10 09:15:46'),
(8, '30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'public/image/user/637e07cc0fb32.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-11-23 05:39:33', '2022-11-23 05:39:33');
-- --------------------------------------------------------
--
-- Table structure for table `employee_languages`
--
CREATE TABLE `employee_languages` (
`id` bigint(20) UNSIGNED NOT NULL,
`emlan_candidate_id` varchar(255) DEFAULT NULL,
`emlan_details` longtext 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 `employee_languages`
--
INSERT INTO `employee_languages` (`id`, `emlan_candidate_id`, `emlan_details`, `created_at`, `updated_at`) VALUES
(5, '27', 'Language: Bangla , reading, Writing, Listening is very good<br>\r\nLanguage: English, reading, Writing, Listening is very good', '2022-11-10 09:15:46', '2022-11-10 09:15:46'),
(8, '30', NULL, '2022-11-23 05:39:33', '2022-11-23 05:39:33');
-- --------------------------------------------------------
--
-- Table structure for table `empoyee_experiences`
--
CREATE TABLE `empoyee_experiences` (
`id` bigint(20) UNSIGNED NOT NULL,
`emex_candidate_id` int(11) DEFAULT NULL,
`emex_details` longtext 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 `empoyee_experiences`
--
INSERT INTO `empoyee_experiences` (`id`, `emex_candidate_id`, `emex_details`, `created_at`, `updated_at`) VALUES
(4, 27, 'Company Name: ABC Company, Work Role: ABC Work, Staring Date: 10/10/2019 To Till Now', '2022-11-10 09:15:46', '2022-11-10 09:15:46'),
(7, 30, NULL, '2022-11-23 05:39:33', '2022-11-23 05:39:33');
-- --------------------------------------------------------
--
-- 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 `footerclumname`
--
CREATE TABLE `footerclumname` (
`id` bigint(20) UNSIGNED NOT NULL,
`footer_heading_cloumn_name` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `footerclumname`
--
INSERT INTO `footerclumname` (`id`, `footer_heading_cloumn_name`, `created_at`, `updated_at`) VALUES
(1, 'জব প্রার্থীরা', NULL, NULL),
(2, 'নিয়োগকর্তা', NULL, NULL),
(3, 'টেলিটক', NULL, NULL),
(4, 'সামাজিক মিডিয়া', NULL, NULL),
(5, 'হেডার মেনু', NULL, NULL),
(6, 'টি এম আই টি কর্তৃক সংরক্ষিত', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `footertop`
--
CREATE TABLE `footertop` (
`id` bigint(20) UNSIGNED NOT NULL,
`footer_cloumn_id` varchar(255) DEFAULT NULL,
`footer_menu_name` varchar(255) DEFAULT NULL,
`footer_menu_link` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `footertop`
--
INSERT INTO `footertop` (`id`, `footer_cloumn_id`, `footer_menu_name`, `footer_menu_link`, `created_at`, `updated_at`) VALUES
(7, '1', 'জব সন্ধান', '#', NULL, NULL),
(8, '1', 'জব প্রার্থীদের লগইন', '#', NULL, NULL),
(9, '1', 'পেশার পরামর্শ', '#', NULL, NULL),
(10, '1', 'সাহায্য করুন', '#', NULL, NULL),
(11, '2', 'নিয়োগকর্তার প্রবেশ', '#', NULL, NULL),
(12, '2', 'গবেষণা প্রতিবেদন', '#', NULL, NULL),
(13, '2', 'অনলাইনে কিনুন', '#', NULL, NULL),
(14, '2', 'প্রশ্ন উত্তর', '#', NULL, NULL),
(15, '3', 'আমাদের সম্পর্কে', '#', NULL, NULL),
(16, '3', 'আমাদের সাথে যোগাযোগ করুন', '#', NULL, NULL),
(17, '3', 'এইচটিএমএল সাইটম্যাপ', '#', NULL, NULL),
(18, '3', 'চাকুরির অ্যাপ', '#', NULL, NULL),
(19, '4', 'ফেসবুক', '#', NULL, NULL),
(20, '4', 'টুইটার', '#', NULL, NULL),
(21, '4', 'লিংকডিন', '#', NULL, NULL),
(22, '4', 'ইনস্টাগ্রাম', '#', NULL, NULL),
(23, '5', 'হোম', 'http://localhost/jobsite', NULL, NULL),
(24, '5', 'প্রোডাক্ট', 'http://localhost/jobsite/product-archive', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `generalsetting`
--
CREATE TABLE `generalsetting` (
`id` bigint(20) UNSIGNED NOT NULL,
`site_title` varchar(255) DEFAULT NULL,
`site_description` varchar(255) DEFAULT NULL,
`site_keyword` varchar(255) DEFAULT NULL,
`site_logo` varchar(255) DEFAULT NULL,
`site_favicon` varchar(255) DEFAULT NULL,
`site_author` varchar(255) DEFAULT NULL,
`site_googlesiteverify` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `generalsetting`
--
INSERT INTO `generalsetting` (`id`, `site_title`, `site_description`, `site_keyword`, `site_logo`, `site_favicon`, `site_author`, `site_googlesiteverify`, `created_at`, `updated_at`) VALUES
(1, 'TM IT STORE', 'BEst Web Development Company', 'Jobsite,', 'public/image/site/636fa5e5908ea.jpg', 'public/image/site/636fa61c02ee3.jpg', 'Tanzim', 'dasdasd43edd', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `joborder`
--
CREATE TABLE `joborder` (
`id` bigint(20) UNSIGNED NOT NULL,
`candidate_id` int(11) DEFAULT NULL,
`job_id` int(11) DEFAULT NULL,
`payment_method` varchar(255) DEFAULT NULL,
`sender_number` varchar(255) DEFAULT NULL,
`payment_status` varchar(255) DEFAULT NULL,
`transaction_id` varchar(255) DEFAULT NULL,
`paybleamount` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `joborder`
--
INSERT INTO `joborder` (`id`, `candidate_id`, `job_id`, `payment_method`, `sender_number`, `payment_status`, `transaction_id`, `paybleamount`, `status`, `created_at`, `updated_at`) VALUES
(13, 28, 3, 'bkash', '01774137134', '1', '8J66P429W0', '150', '1', NULL, NULL),
(16, 27, 7, 'Bkash', '01774137135', '2', '8J61PCD9WF', '220', '1', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `jobs`
--
CREATE TABLE `jobs` (
`id` bigint(20) UNSIGNED NOT NULL,
`company_id` varchar(255) DEFAULT NULL,
`category_id` varchar(255) DEFAULT NULL,
`job_type_id` varchar(255) NOT NULL,
`job_title` varchar(255) DEFAULT NULL,
`job_description` longtext DEFAULT NULL,
`expaire_date` date DEFAULT NULL,
`apply_satrt` date DEFAULT NULL,
`job_number` varchar(255) DEFAULT NULL,
`job_fee` int(255) DEFAULT NULL,
`job_serviec_fee` int(255) DEFAULT NULL,
`job_total_fee` int(255) DEFAULT NULL,
`private_jobapply_link` varchar(255) DEFAULT NULL,
`scrollabe` int(255) DEFAULT NULL,
`meta_job_descrip` varchar(255) DEFAULT NULL,
`status` int(255) DEFAULT NULL,
`views` int(255) DEFAULT 0,
`created_at` timestamp NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `jobs`
--
INSERT INTO `jobs` (`id`, `company_id`, `category_id`, `job_type_id`, `job_title`, `job_description`, `expaire_date`, `apply_satrt`, `job_number`, `job_fee`, `job_serviec_fee`, `job_total_fee`, `private_jobapply_link`, `scrollabe`, `meta_job_descrip`, `status`, `views`, `created_at`, `updated_at`) VALUES
(3, '4', '5', '1', 'Computer Oparator', 'Place <em>some</em> <u>text</u> <strong>here</strong>', '2022-11-24', '2022-11-08', '23324', 100, 50, 150, NULL, 1, NULL, 1, 12, NULL, NULL),
(4, '3', '7', '3', 'HR Admin', 'Place <em>some</em> <u>text</u> <strong>here</strong>', '2022-11-25', NULL, '23324', 100, 50, 150, NULL, NULL, NULL, 1, 4, NULL, NULL),
(5, '4', '1', '3', 'Sales manager', 'Place <em>some</em> <u>text</u> <strong>here</strong>', '2022-11-18', NULL, '23324', 100, 50, 150, NULL, NULL, NULL, 1, 36, NULL, NULL),
(6, '2', '1', '1', 'Software Engineer', 'Place <em>some</em> <u>text</u> <strong>here</strong>', '2022-11-09', '2022-11-18', '233243333', 1000, 20, 1020, NULL, 1, NULL, 1, 4, '2022-11-08 14:17:38', NULL),
(7, '2', '1', '1', 'Laravel Developer', 'Place <em>some</em> <u>text</u> <strong>here</strong>', '2022-11-24', '2022-11-12', '45454545', 200, 20, 220, NULL, 2, NULL, 1, 14, '2022-11-12 15:05:15', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `jobtypes`
--
CREATE TABLE `jobtypes` (
`id` bigint(20) UNSIGNED NOT NULL,
`job_type_name` varchar(255) NOT NULL,
`job_type_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 `jobtypes`
--
INSERT INTO `jobtypes` (`id`, `job_type_name`, `job_type_slug`, `created_at`, `updated_at`) VALUES
(1, 'Govt', 'govt', NULL, NULL),
(3, 'Private', 'private', 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_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_11_01_111245_create_categories_table', 2),
(6, '2022_11_01_114442_create_jobtypes_table', 3),
(7, '2022_11_01_164457_create_jobs_table', 4),
(8, '2022_11_02_124637_create_employeeinfo_table', 5),
(9, '2022_11_02_141339_create_employeeeducation_table', 6),
(10, '2022_11_06_084810_create_examples_table', 7),
(11, '2022_11_06_085858_create_employeeedutions_table', 8),
(12, '2022_11_06_092043_create_employeeinfos_table', 9),
(13, '2022_11_06_104537_create_empoyee_experiences_table', 10),
(14, '2022_11_06_105523_create_employee_languages_table', 11),
(15, '2022_11_10_124320_create_joborder_table', 12),
(16, '2022_11_12_130520_create_generalsetting_table', 13),
(19, '2022_11_14_103142_create_footertop_table', 14),
(20, '2022_11_14_103204_create_footerclumname_table', 14),
(21, '2022_11_14_124233_create_blog_table', 15),
(22, '2022_11_16_111035_create_pages_table', 16),
(23, '2022_11_21_101213_create_pdfpayment_table', 17),
(24, '2022_11_23_181423_create_product_table', 18),
(25, '2022_11_24_113901_create_productorder_table', 19),
(26, '2022_11_26_140912_create_ad_table', 20),
(27, '2022_11_30_114515_create_payment_method_table', 21),
(28, '2022_11_30_121804_create_payment_instruction_table', 22);
-- --------------------------------------------------------
--
-- Table structure for table `pages`
--
CREATE TABLE `pages` (
`id` bigint(20) UNSIGNED NOT NULL,
`page_heading` varchar(255) DEFAULT NULL,
`page_descriptions` longtext DEFAULT NULL,
`page_feature_image` varchar(255) DEFAULT NULL,
`page_meta_title` varchar(255) DEFAULT NULL,
`page_meta_description` varchar(255) DEFAULT NULL,
`page_status` varchar(255) DEFAULT NULL,
`page_view` 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 `pages`
--
INSERT INTO `pages` (`id`, `page_heading`, `page_descriptions`, `page_feature_image`, `page_meta_title`, `page_meta_description`, `page_status`, `page_view`, `created_at`, `updated_at`) VALUES
(2, 'This is a page 524', 'Place <em>some</em> <u>text</u> <strong>here524</strong>', 'public/image/page/6374cb2d92e54.jpg', 'This is a page 2254', 'This is a page Meta description254', '1', 4, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `password_resets`
--
CREATE TABLE `password_resets` (
`email` varchar(255) NOT NULL,
`token` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `password_resets`
--
INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES
('tasiftanzim2@gmail.com', '$2y$10$Gn4.PdfasfXapHg3YwE1yOJw2vv515umX5rP9sLGoEv1LCZnKzmGy', '2022-11-12 08:42:06');
-- --------------------------------------------------------
--
-- Table structure for table `payment_instruction`
--
CREATE TABLE `payment_instruction` (
`id` bigint(20) UNSIGNED NOT NULL,
`name_image` varchar(255) DEFAULT NULL,
`postion_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 `payment_instruction`
--
INSERT INTO `payment_instruction` (`id`, `name_image`, `postion_name`, `created_at`, `updated_at`) VALUES
(1, 'public/image/paymentins/638754ab2f699.png', 'job Order', NULL, NULL),
(2, 'public/image/paymentins/6387554882fa2.png', 'product order', NULL, NULL),
(3, 'public/image/paymentins/63875573177a7.png', 'PDF Order', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `payment_method`
--
CREATE TABLE `payment_method` (
`id` bigint(20) UNSIGNED NOT NULL,
`method_number` varchar(255) DEFAULT NULL,
`method` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `payment_method`
--
INSERT INTO `payment_method` (`id`, `method_number`, `method`, `status`, `created_at`, `updated_at`) VALUES
(3, 'Bkash (01700000000)', 'Bkash', NULL, NULL, NULL),
(4, 'Rocket (01700000000)', 'Rocket', NULL, NULL, NULL),
(5, 'Nagad (01700000000)', 'Nagad', NULL, NULL, NULL),
(6, 'Cellfin (01700000000)', 'Cellfin', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `pdfpayment`
--
CREATE TABLE `pdfpayment` (
`id` bigint(20) UNSIGNED NOT NULL,
`pdfcandidate_id` varchar(255) DEFAULT NULL,
`pdfpaymentsender_name` varchar(255) DEFAULT NULL,
`pdfpayment_ammount` varchar(255) DEFAULT NULL,
`pdfpayment_method` varchar(255) DEFAULT NULL,
`pdfpayment_trx` varchar(255) DEFAULT NULL,
`pdfpayment_status` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `pdfpayment`
--
INSERT INTO `pdfpayment` (`id`, `pdfcandidate_id`, `pdfpaymentsender_name`, `pdfpayment_ammount`, `pdfpayment_method`, `pdfpayment_trx`, `pdfpayment_status`, `created_at`, `updated_at`) VALUES
(9, '27', '01774137135', '200', 'nagad', 'dasdasdsad57745', '2', NULL, NULL);
-- --------------------------------------------------------
--
-- 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,
`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 `product`
--
CREATE TABLE `product` (
`id` bigint(20) UNSIGNED NOT NULL,
`product_name` varchar(255) DEFAULT NULL,
`product_image` varchar(255) DEFAULT NULL,
`product_sortdes` longtext DEFAULT NULL,
`product_bigdes` longtext DEFAULT NULL,
`product_price` varchar(255) DEFAULT NULL,
`product_status` varchar(255) DEFAULT NULL,
`product_slug` varchar(255) DEFAULT NULL,
`product_meta_title` varchar(255) DEFAULT NULL,
`product_meta_des` longtext 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 `product`
--
INSERT INTO `product` (`id`, `product_name`, `product_image`, `product_sortdes`, `product_bigdes`, `product_price`, `product_status`, `product_slug`, `product_meta_title`, `product_meta_des`, `created_at`, `updated_at`) VALUES
(1, 'Facebook Boost 100 Dollar2', 'public/image/product/637e6ac8b6109.jpg', 'Short DescriptionShort DescriptionShort DescriptionShort DescriptionShort DescriptionShort Description', 'Place <em>some</em> <u>text</u> <strong>here big description</strong>', '৳ 1400', '1', 'facebook-boost-100-dollar2', 'Facebook Boost 10 Dollar', 'Short DescriptionShort DescriptionShort DescriptionShort DescriptionShort DescriptionShort Description', NULL, NULL),
(2, 'Facebook Like 2000', 'public/image/product/637e6b4347a12.png', 'Short DescriptionShort DescriptionShort DescriptionShort DescriptionShort Description', 'Place <em>some</em> <u>text</u> <strong>here</strong>', '৳ 100', '1', 'facebook-like-2000', 'Facebook LIke 2000', 'Short DescriptionShort DescriptionShort DescriptionShort DescriptionShort Description', NULL, NULL),
(4, 'Reloadable VISA Card', 'public/image/product/637e6d56ab8e1.jpg', 'Reloadable VISA Card vReloadable VISA Card Reloadable VISA Card Reloadable VISA Card', 'Place <em>some</em> <u>text</u> <strong>here</strong>', '৳ 900', '1', 'reloadable-visa-card', 'Reloadable VISA Card Reloadable VISA Card Reloadable VISA Card Reloadable VISA Card', 'Reloadable VISA Card Reloadable VISA Card Reloadable VISA Card Reloadable VISA Card Reloadable VISA Card', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `productorder`
--
CREATE TABLE `productorder` (
`id` bigint(20) UNSIGNED NOT NULL,
`por_candicate_id` varchar(255) DEFAULT NULL,
`por_product_id` varchar(255) DEFAULT NULL,
`por_product_name` varchar(255) DEFAULT NULL,
`por_payment_amount` varchar(255) DEFAULT NULL,
`por_payment_trx` varchar(255) DEFAULT NULL,
`por_payment_sendernumber` varchar(255) DEFAULT NULL,
`por_payment_method` varchar(255) DEFAULT NULL,
`por_status` varchar(255) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `productorder`
--
INSERT INTO `productorder` (`id`, `por_candicate_id`, `por_product_id`, `por_product_name`, `por_payment_amount`, `por_payment_trx`, `por_payment_sendernumber`, `por_payment_method`, `por_status`, `created_at`, `updated_at`) VALUES
(1, '27', '4', NULL, '৳ 900', 'sdasdas3rree55666', '01774137135', 'bkash', '2', NULL, NULL);
-- --------------------------------------------------------
--
-- 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,
`is_admin` tinyint(1) DEFAULT NULL,
`photo_path` varchar(255) DEFAULT NULL,
`password` varchar(255) NOT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `is_admin`, `photo_path`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(2, 'admin', 'admin@gmail.com', NULL, 1, NULL, '$2y$10$.dr0D13Ehm3zHHeSz9B6AO3T.CGvT3UosPggwx6dmz78r3laE8abK', NULL, '2022-10-31 03:43:59', '2022-10-31 03:43:59'),
(27, 'Tamim Hossain', 'tasiftanzim2@gmail.com', NULL, NULL, 'public/image/user/6370f3d5d5716.jpg', '$2y$10$jL0He1FyRUKVF2e4Opo/COiJJOkB9SPc3Orqpdz8OLQl6rBEFUEI.', NULL, '2022-11-10 09:15:46', '2022-11-10 09:15:46'),
(30, 'Tanzim', 'tanzim@gmail.com', NULL, NULL, 'public/image/user/637e07df8081d.jpg', '$2y$10$XwADVySpSUtyf0vHrPBLZOMCM5iCnlYfZq642hhwBDei9H.jFneEO', NULL, '2022-11-23 05:39:33', '2022-11-23 05:39:33');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `ad`
--
ALTER TABLE `ad`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `blog`
--
ALTER TABLE `blog`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `employeeedutions`
--
ALTER TABLE `employeeedutions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `employeeinfos`
--
ALTER TABLE `employeeinfos`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `employee_languages`
--
ALTER TABLE `employee_languages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `empoyee_experiences`
--
ALTER TABLE `empoyee_experiences`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
--
-- Indexes for table `footerclumname`
--
ALTER TABLE `footerclumname`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `footertop`
--
ALTER TABLE `footertop`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `generalsetting`
--
ALTER TABLE `generalsetting`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `joborder`
--
ALTER TABLE `joborder`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `jobtypes`
--
ALTER TABLE `jobtypes`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
ADD KEY `password_resets_email_index` (`email`);
--
-- Indexes for table `payment_instruction`
--
ALTER TABLE `payment_instruction`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `payment_method`
--
ALTER TABLE `payment_method`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `pdfpayment`
--
ALTER TABLE `pdfpayment`
ADD PRIMARY KEY (`id`);
--
-- 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 `product`
--
ALTER TABLE `product`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `productorder`
--
ALTER TABLE `productorder`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_email_unique` (`email`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `ad`
--
ALTER TABLE `ad`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `blog`
--
ALTER TABLE `blog`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `employeeedutions`
--
ALTER TABLE `employeeedutions`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `employeeinfos`
--
ALTER TABLE `employeeinfos`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `employee_languages`
--
ALTER TABLE `employee_languages`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `empoyee_experiences`
--
ALTER TABLE `empoyee_experiences`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `footerclumname`
--
ALTER TABLE `footerclumname`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `footertop`
--
ALTER TABLE `footertop`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `generalsetting`
--
ALTER TABLE `generalsetting`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `joborder`
--
ALTER TABLE `joborder`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `jobtypes`
--
ALTER TABLE `jobtypes`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `payment_instruction`
--
ALTER TABLE `payment_instruction`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `payment_method`
--
ALTER TABLE `payment_method`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `pdfpayment`
--
ALTER TABLE `pdfpayment`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- 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 `product`
--
ALTER TABLE `product`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `productorder`
--
ALTER TABLE `productorder`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
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 */;