-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 15, 2018 at 11:40 AM
-- Server version: 10.1.36-MariaDB
-- PHP Version: 5.6.38

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `jobportal`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `uname` varchar(50) DEFAULT NULL,
  `pass` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `uname`, `pass`) VALUES
(1, 'admin@gmail.com', 'jpadmin');

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

--
-- Table structure for table `area_of_sectors`
--

CREATE TABLE `area_of_sectors` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `designation`
--

CREATE TABLE `designation` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `experience`
--

CREATE TABLE `experience` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `job_post`
--

CREATE TABLE `job_post` (
  `id` int(11) NOT NULL,
  `job_type` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `designation` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `qualification` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `job_location` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `year_of_passing` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `pre_cgpa` float DEFAULT NULL,
  `specialization` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `area_of_sector` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `exp` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `number_of_vacancies` int(11) DEFAULT NULL,
  `lasr_date_application` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `hiring_process` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `salary_range` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `min` int(11) DEFAULT NULL,
  `max` int(11) DEFAULT NULL,
  `r_id` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `pay_count` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '0',
  `post_date` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `application` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
  `technology` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `job_desc` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `written_test` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT 'No',
  `group_discussion` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT 'No',
  `technical_round` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT 'No',
  `hr_round` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT 'No',
  `meta_desc` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `meta_keyword` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `author` varchar(50) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `job_role`
--

CREATE TABLE `job_role` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `job_types`
--

CREATE TABLE `job_types` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `jp_applay_job`
--

CREATE TABLE `jp_applay_job` (
  `id` int(11) NOT NULL,
  `job_id` varchar(50) DEFAULT NULL,
  `s_email` varchar(150) DEFAULT NULL,
  `r_id` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `jp_contect_us`
--

CREATE TABLE `jp_contect_us` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `mno` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `msg` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `subject` varchar(250) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `jp_custom_ads`
--

CREATE TABLE `jp_custom_ads` (
  `id` int(11) NOT NULL,
  `home_page` varchar(50) DEFAULT NULL,
  `link1` varchar(250) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `single_page_top` varchar(50) DEFAULT NULL,
  `single_page_bottom` varchar(50) DEFAULT NULL,
  `both_page` varchar(50) DEFAULT NULL,
  `add_img` varchar(300) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jp_custom_ads`
--

INSERT INTO `jp_custom_ads` (`id`, `home_page`, `link1`, `status`, `single_page_top`, `single_page_bottom`, `both_page`, `add_img`) VALUES
(1, 'yes', 'http://a.net', 'InActive', 'yes', 'yes', 'no', 'uploads/ads/marker.png');

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

--
-- Table structure for table `jp_language`
--

CREATE TABLE `jp_language` (
  `language_id` int(11) NOT NULL,
  `language_key` varchar(250) DEFAULT NULL,
  `language_type` varchar(250) DEFAULT NULL,
  `english` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `french` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `greek` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `russian` varchar(250) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jp_language`
--

INSERT INTO `jp_language` (`language_id`, `language_key`, `language_type`, `english`, `french`, `greek`, `russian`) VALUES
(1, 'login', 'menu_header', 'Login', 's\'identifier', '', ''),
(2, 'jobs', 'menu_header', 'Jobs', 'emplois', '', ''),
(3, 'applied_job', 'menu_header', 'My Applied Jobs', 'Mes emplois appliqu', '', 'z'),
(4, 'profile_setting', 'menu_header', 'Profile Setting', 'Param', '', ''),
(5, 'logout', 'menu_header', 'Logout', 'Connectez - Out', '', ''),
(6, 'home_page_heading', 'home_page', 'Are You Looking For A Job', 'Are You Looking For A Job', 'q', ' Ты ищешь работу'),
(7, 'text_filter_placeholder', 'home_page', 'Search Job Here by Location, Skills', 'Recherche d\'emploi ici par lieu, comp', '', ''),
(8, 'filter_up_side_msg', 'home_page', 'you are on the right place', 'Vous ', '', 'вы находитесь в нужном месте'),
(9, 'view_btn', 'home_page', 'View', 'vue', '', ''),
(10, 'applied_keyword', 'general_keyword', 'Applied', '', '', ''),
(11, 'left_job_type', 'home_page', 'Job Type', 'Type d\'emploi', '', ''),
(12, 'left_location', 'home_page', 'Location', 'Emplacement', '', ''),
(13, 'left_designation', 'home_page', 'Designation', 'La d', '', ''),
(14, 'left_qualification', 'home_page', 'Qualification', 'Qualification', '', ''),
(15, 'left_experience', 'home_page', 'Experience', 'Exp', '', ''),
(16, 'search_locatiion', 'home_page', 'Search..', 'Chercher..', '', ''),
(17, 'my_applied_job_headding', 'my_applied_job_page', 'My Applied Job', 'Mon travail appliqu', '', ''),
(18, 'u_profile_keyword', 'user_profile_page', 'Profile', 'Profil', '', ''),
(19, 'user_personal_details', 'user_profile_page', 'Personal details', 'D', '', ''),
(20, 'user_name', 'user_profile_page', 'Full Name', 'Nom complet', '', ''),
(21, 'user_mno', 'user_profile_page', 'Mobile', 'Mobile', '', ''),
(22, 'user_address', 'user_profile_page', 'Current Address', 'Adresse actuelle', '', ''),
(23, 'user_search_preferences', 'user_profile_page', 'Search preferences', 'Pr', '', ''),
(24, 'user_location', 'user_profile_page', 'PREFERRED LOCATION', 'LIEU PR', '', ''),
(25, 'user_job_type', 'user_profile_page', 'Job Type', 'Type d\'emploi', '', ''),
(27, 'user_qualification', 'user_profile_page', 'Qualification', 'Qualification', '', ''),
(28, 'user_passing_year', 'user_profile_page', 'Year Of Passing ', 'Ann', '', ''),
(29, 'user_cgpa', 'user_profile_page', 'PERCENTAGE/CGPA', 'POURCENTAGE / MPC', '', ''),
(30, 'user_aofs', 'user_profile_page', 'AREA OF SECTOR', 'ZONE DE SECTEUR', '', ''),
(31, 'user_exp', 'user_profile_page', 'JOB TYPE', 'TYPE D\'EMPLOI', '', ''),
(32, 'user_resume', 'user_profile_page', 'UPLOAD RESUME', 'UPLOAD RESUME', '', ''),
(33, 'user_resume_download', 'user_profile_page', 'Download Resume', 'T', '', ''),
(34, 'user_password_change', 'user_profile_page', 'Change Password', '\';sdjklolsjf', '', ''),
(35, 'user_ps', 'user_profile_page', 'Password', 'Mot de passe', '', ''),
(36, 'user_cps', 'user_profile_page', 'Retype password', 'retaper le mot de passe', '', ''),
(37, 'u_p_save_btn', 'user_profile_page', 'Save Changes', 'Sauvegarder les modifications', '', ''),
(38, 'login_heading', 'login_page', 'Login', 'S\'identifier', '', ''),
(39, 'login_option1', 'login_page', 'Seeker', 'Chercheur', '', ''),
(40, 'login_option2', 'login_page', 'recruiter', 'recruteur', '', ''),
(41, 'email_login', 'login_page', 'Your Email', 'Votre email', '', ''),
(43, 'password_login', 'login_page', 'Password', 'Mot de passe', '', ''),
(44, 'forgot_password', 'login_page', 'Forgot Password', 'Mot de passe oubli', '', ''),
(45, 'login_btn', 'login_page', 'Login', 'S\'identifier', '', ''),
(46, 'register_msg', 'login_page', 'Don t Have An Account', 'Don t avoir un compte', '', ''),
(47, 'Register_keyword', 'login_page', 'Register', 'registre', '', ''),
(48, 'forgot_ps_heading', 'login_page', 'Forgot Password', 'Mot de passe oubli', '', ''),
(49, 'forgot_ps_option1', 'login_page', 'Seeker', 'Chercheur', '', ''),
(50, 'forgot_ps_option2', 'login_page', 'Recruiter', 'Recruteur', '', ''),
(51, 'forget_ps_email', 'login_page', 'Enter E-Mail Address', 'Entrer l\'adresse e-mail', '', ''),
(52, 'forgot_ps_btn', 'login_page', 'Ok', 'Un', '', ''),
(53, 'register_page_heading', 'register_page', 'Register', 'registre', '', ''),
(54, 'register_email', 'register_page', 'Your Email', 'Votre email', '', ''),
(55, 'resister_mno', 'register_page', 'Mobile No', 'Mobile No', '', ''),
(56, 'register_ps', 'register_page', 'Password', 'Mot de passe', '', ''),
(57, 'register_cps', 'register_page', 'Confirm Password', 'Confirmez le mot de passe', '', ''),
(58, 'register_btn', 'register_page', 'Register', 'registre', '', ''),
(59, 'login_msg', 'register_page', 'Already Have An Account', 'test', '', ''),
(60, 'login_keyword', 'register_page', 'Login', 'S\'identifier', '', ''),
(63, 'register_option1', 'register_page', 'Seeker', 'Chercheur', '', ''),
(64, 'register_option2', 'register_page', 'Recruiter', 'Recruteur', '', ''),
(65, 'register_name', 'register_page', 'Your Name', 'votre nom', '', ''),
(66, 'my_jobs1', 'recruiter_header', 'My Jobs', 'Mes emplois', 'q', ''),
(67, 'post_a_job1', 'recruiter_header', 'Post a job', 'Publier une offre', '', ''),
(68, 'r_profile_setting', 'recruiter_header', 'Profile Setting', 'Param', '', ''),
(69, 'applied_seeker', 'recruiter_header', 'Applied Seeker', 'Chercheur appliqu', '', ''),
(71, 'recruiter_home_heading', 'recruiter_home', 'My jobs', '', '', ''),
(72, 'edit_keyword', 'genral_keyword', 'Edit', '', '', ''),
(73, 'change_logo', 'recruiter_profile_page', 'Change logo', 'Changer de logo', '', ''),
(74, 'org_type_title', 'recruiter_profile_page', 'ORGANISATION TYPE', 'TYPE D\'ORGANISATION', '', ''),
(75, 'type1', 'recruiter_profile_page', 'Company', 'Compagnie', '', ''),
(76, 'type2', 'recruiter_profile_page', 'Consultant', 'Consultant', '', ''),
(77, 'org_name', 'recruiter_profile_page', 'Name', 'pr', '', ''),
(78, 'org_location11', 'recruiter_profile_page', 'City', 'Emplacement', '', ''),
(79, 'org_address1', 'recruiter_profile_page', 'Address', 'Adresse', '', ''),
(80, 'org_website', 'recruiter_profile_page', 'Website', 'Site Internet', '', ''),
(81, 'org_desc', 'recruiter_profile_page', 'Organisation Details', 'description', '', ''),
(82, 'pay_detail', 'recruiter_profile_page', 'Payment detail', 'D', '', ''),
(83, 'pay_date', 'recruiter_profile_page', 'Pay Date', 'Date de paiement', '', ''),
(84, 'plan', 'recruiter_profile_page', 'Plan', 'Plan', '', ''),
(85, 'job_post', 'recruiter_profile_page', 'Job Post', 'Poste de travail', '', ''),
(86, 'r_download', 'recruiter_profile_page', 'Resume download', 'Reprendre le t', '', ''),
(87, 'validity', 'recruiter_profile_page', 'Validity', 'Validit', '', ''),
(88, 'active_new_plan', 'recruiter_profile_page', 'Active New Plan', 'Nouveau plan actif', '', ''),
(89, 'job_post_heading1', 'job_post_page', 'Post a Job', 'Publier une offre', '', ''),
(90, 'job_type', 'job_post_page', 'Job Type', 'Type d\'emploi', '', ''),
(91, 'desi', 'job_post_page', 'Designation', 'La d', '', ''),
(92, 'qua', 'job_post_page', 'Qualification', 'Qualification', '', ''),
(93, 'job_location', 'job_post_page', 'JOB LOCATION', 'LIEU DE TRAVAIL', '', ''),
(94, 'p_year', 'job_post_page', 'YEAR OF PASSING', 'ANN', '', ''),
(95, 'job_cgpa', 'job_post_page', 'PERCENTAGE/CGPA', 'POURCENTAGE / MPC', '', ''),
(96, 'sp', 'job_post_page', 'specialization', 'sp', '', ''),
(97, 'job_aofs', 'job_post_page', 'AREA OF SECTOR', 'ZONE DE SECTEUR', '', ''),
(98, 'job_exp', 'job_post_page', 'EXPERIENCE', 'EXP', '', ''),
(99, 'num_if_v', 'job_post_page', 'NUMBER OF VACANCIES', 'NOMBRE DE CHAMBRES VACANTES', '', ''),
(100, 'last_date_of_a', 'job_post_page', 'Last Date of Application', 'Derni', '', ''),
(101, 'tech', 'job_post_page', 'TECHNOLOGY', 'LA TECHNOLOGIE', '', ''),
(102, 'h_pro', 'job_post_page', 'Hiring Process', 'Processus d\'embauche', '', ''),
(103, 'job_desc1', 'job_post_page', 'Job Description', 'Description de l\'emploi', '', ''),
(104, 's_range', 'job_post_page', 'SALARY RANGE', '', '', ''),
(105, 'min1', 'job_post_page', 'Minimum', 'Le minimum', '', ''),
(106, 'max1', 'job_post_page', 'Maximum ', 'Maximum', '', ''),
(107, 'meta_desc1', 'job_post_page', 'META DESCRIPTION', 'META DESCRIPTION', '', ''),
(108, 'meta_keyword1', 'job_post_page', 'META KEYWORD', 'META KEYWORD', '', ''),
(109, 'aname', 'job_post_page', 'AUTHOR NAME', 'NOM DE L\'AUTEUR', '', ''),
(110, 'job_post_btn', 'job_post_page', 'Job Post', 'Poste de travail', '', ''),
(111, 'select_keyword', 'genral_keyword', 'Select', '', '', ''),
(113, 'jon_tool_top1', 'job_post_page', '( ex. java,c++ etc )', '(ex. java, c ++, etc.)', '', ''),
(114, 'jon_tool_top2', 'job_post_page', '( ex job name , location etc)', '(ex nom du travail, emplacement, etc.)', '', ''),
(115, 's_written_test_k', 'single_job', 'Written Test', 'Examen ', '', ''),
(116, 's_gtoup_d_k', 'single_job', 'Group Discussion', 'Discussion de groupe', '', ''),
(117, 's_r_round_k', 'single_job', 'Technical Round', 'Tour Technique', '', ''),
(118, 's_hr_round_k', 'single_job', 'HR Round', 'Ronde RH', '', ''),
(119, 'per_year1', 'job_post_page', 'Per Year', 'Par an', '', ''),
(120, 'per_month', 'job_post_page', 'Per Month', 'Par mois', '', ''),
(121, 'per_day', 'job_post_page', 'Per Day', 'Par jour', '', ''),
(122, 'per_hour', 'job_post_page', 'Per Hour', 'Par heure', '', ''),
(123, 'edit_job_post_heading', 'job_post_page', 'Edit a Job', 'Modifier un emploi', '', ''),
(124, 'edit_job_btn', 'job_post_page', 'Update Job', 'Mise ', '', ''),
(125, 'single_form_keyword', 'single_job', 'From', 'De', '', ''),
(126, 'single_organisation_keyword', 'single_job', 'Organisation', 'Organisation', '', ''),
(127, 'single_job_post_date', 'single_job', 'Job Posted', 'Job Post', '', ''),
(128, 'single_job_type', 'single_job', 'Job Type', 'Type d\'emploi', '', ''),
(129, 'single_designation', 'single_job', 'Designation', 'La d', '', ''),
(130, 'single_qualification', 'single_job', 'Qualification', 'Qualification', '', ''),
(131, 'single_specialization', 'single_job', 'Specialization', 'Sp', '', ''),
(132, 'single_application_last_date', 'single_job', 'Last Date of Application', 'Derni', '', ''),
(133, 'single_min', 'single_job', 'Minimum Salary', 'Salaire minimum', '', ''),
(134, 'single_max', 'single_job', 'Maximum Salary', 'Salaire maximum', '', ''),
(135, 'single_h_pro', 'single_job', 'Hiring Process', 'Processus d\'embauche', '', ''),
(136, 'single_job_desc', 'single_job', 'Job Description', 'Description de l\'emploi', '', ''),
(137, 'single_org_d', 'single_job', 'Organisation Details', 'D', '', ''),
(138, 'single_type', 'single_job', 'Type', 'Type', '', ''),
(139, 'single_location', 'single_job', 'Location', 'Emplacement', '', ''),
(140, 'single_website', 'single_job', 'Website', 'Site Internet', '', ''),
(141, 'applay_btn', 'single_job', 'Apply', 'Appliquer', '', ''),
(142, 'already_applied_btn', 'sible_job', 'You Already Applied', '', '', ''),
(143, 'l_back_to_home', 'login_page', 'Back To Home', 'De retour ', '', ''),
(144, 'l_or_keyword', 'login_page', 'Or', 'Ou', '', ''),
(145, 'applied_keyword', 'home_page', 'Applied', 'Appliqu1', 'Εφαρμοσμένος', 'прикладной'),
(146, 'validaton_email_empty', 'validation', 'Enter email address', 'Entrer l\'adresse e-mail', '', ''),
(147, 'validaton_password_empty', 'validation', 'Enter password', 'Entrer le mot de passe', '', ''),
(148, 'validation_valid_email', 'validation', 'Enter a valid email address', 'Entrez une adresse mail valide', '', ''),
(149, 'validation_password_short', 'validation', 'Password is Short', 'Le mot de passe est court', '', ''),
(150, 'validation_email_veri', 'validation', 'Please verify your email address', 'Veuillez v', '', ''),
(151, 'validation_account_dis', 'validation', 'Your Account Disabled', 'Votre compte d', '', ''),
(152, 'validation_login_error', 'validation', 'The email address or password doesn\'t match any account', 'L\'adresse e-mail ou le mot de passe ne correspond ', '', ''),
(153, 'validation_name_empty', 'validation', 'Enter your name', 'Entrez votre nom', '', ''),
(154, 'validation_mno_empty', 'validation', 'Enter a mobile number', 'Entrez un num', '', ''),
(155, 'validation_cps_empty', 'validation', 'Enter Confirm password', 'Entrer Confirmer le mot de passe', '', ''),
(156, 'validation_valid_mno', 'validation', 'Enter a valid mobile number', 'Entrez un num', '', ''),
(157, 'validation_email_exists', 'validation', 'E-Mail already exists', 'L\'email existe d', '', ''),
(158, 'validation_mno_exists', 'validation', 'Mobile number already exists', 'Num', '', ''),
(159, 'validation_new_ps_send', 'validation', 'New Password Send on Your E-Mail', 'Nouveau mot de passe Envoyer sur votre e-mail', '', ''),
(160, 'validation_select_plocation', 'validation', 'Select preferred location', 'S', '', ''),
(161, 'validation', 'validation', 'Select preferred location', 'S', '', ''),
(162, 'validation_select_qua', 'validation', 'Select your qualification', 'S', '', ''),
(163, 'validation_cps_short', 'validation', 'Confirm password is short', 'Confirmer le mot de passe est court', '', ''),
(164, 'validation_ps_not', 'validation', 'your password do not match. please try again', 'votre mot de passe ne correspond pas. Veuillez r', '', ''),
(166, 'validation_not_found_msg', 'validation', 'Result Not Found', 'R', '', ''),
(167, 'validation_not_found_msg2', 'validation', 'No job found', 'Aucun travail trouv', '', ''),
(168, 'validation_select_aofs', 'validation', 'Select area Of sector', 'S', '', ''),
(169, 'validation_enter_address', 'validation', 'Enter your address', 'Entrez votre adresse', '', ''),
(170, 'validation_pyeat', 'validation', 'Enter a passing Year', 'Entrez une ann', '', ''),
(171, 'validation_enter_cgpa', 'validation', 'Enter your CGPA/Percentage', 'Entrez votre MPC / pourcentage', '', ''),
(172, 'validation_v_cgpa', 'validation', 'Enter valid CGPA/Percentage', 'Entrer une MPC / un pourcentage valide', '', ''),
(173, 'validation_select_resume', 'validation', 'Please upload resume', 'Veuillez t', '', ''),
(174, 'validation_profile_success', 'validation', 'Profile successfully updated', 'Profil mis ', '', ''),
(175, 'validation_org_name', 'validation', 'Enter name', 'Entrez le nom', '', ''),
(176, 'validation_org_loc', 'validation', 'Enter location', 'Entrez le lieu', '', ''),
(177, 'validation_org_address', 'validation', 'Enter Address', 'Entrer l\'adresse', '', ''),
(178, 'validation_website_link', 'validation', 'Enter Website URL', 'Entrez l\'URL du site Web', '', ''),
(179, 'validation_org_desc', 'validation', 'Enter Description', 'Entrez la description', '', ''),
(180, 'validation_valid_link', 'validation', 'Enter valid website URL', 'Entrez une URL de site Web valide', '', ''),
(181, 'home_not_avil_msg', 'home_page', 'Not available', 'Indisponible', '', ''),
(182, 'h_job_not_found', 'home_page', 'No job found', 'Aucun travail trouv', 'a', ''),
(183, 'h_work_exp', 'home_page', 'Work Experience', 'L\'exp', '', ''),
(184, 'h_job_location', 'home_page', 'Job Location', 'lieu de travail', '', ''),
(185, 'h_req_skils', 'home_page', 'Skills Required', 'Comp', '', ''),
(186, 'h_icon', 'home_page', 'icon', 'ic', '', ''),
(187, 'h_skils', 'home_page', 'skills', 'comp', '', ''),
(188, 'r_back_to_home', 'register_page', 'Back To Home', 'De retour ', '', ''),
(189, 'r_or', 'register_page', 'Or', 'Ou', '', ''),
(190, 'my_a_applied', 'my_applied_job_page', 'Applied', 'Appliqu', '', ''),
(191, 'my_a_view', 'my_applied_job_page', 'View', 'Vue', '', ''),
(192, 's_tool_tip1', 'single_job', 'Work Experience', 'L\'exp', '', ''),
(193, 's_tool_tip2', 'single_job', 'Job Location', 'lieu de travail', '', ''),
(194, 's_tool_tip3', 'single_job', 'Skills Required', 'Comp', '', ''),
(195, 'user_p_select', 'user_profile_page', 'Select', 'S', '', ''),
(196, 'r_logout', 'recruiter_header', 'Logout', 'Connectez - Out', '', ''),
(197, 'r_applied', 'recruiter_home', 'Applied', '', '', ''),
(198, 'r_view', 'recruiter_home', 'View', '', '', ''),
(199, 'r_edit', 'recruiter_home', 'Edit', '', '', ''),
(200, 'r_tool_tip1', 'recruiter_home', 'Work Experience', '', '', ''),
(201, 'r_tool_tip2', 'recruiter_home', 'Job Location', '', '', ''),
(202, 'r_tool_tip3', 'recruiter_home', 'Skills Required', '', '', ''),
(203, 'r_j__written_test_k', 'job_post_page', 'Written Test', 'Examen ', '', ''),
(204, 'r_j__hr_round_k', 'job_post_page', 'HR Round', 'Ronde RH', '', ''),
(205, 'r_j__r_round_k', 'job_post_page', 'Technical Round', 'Tour Technique', '', ''),
(206, 'r_j__gtoup_d_k', 'job_post_page', 'Group Discussion', 'Discussion de groupe', '', ''),
(207, 'job_post_select', 'job_post_page', 'Select', 'S', '', ''),
(208, 'job_posted', 'job_post_page', 'Job Posted', 'Job Post', '', ''),
(209, 'form_k', 'job_post_page', 'From', 'De', '', ''),
(210, 'org_k', 'job_post_page', 'Organisation', 'Organisation', '', ''),
(211, 'org_desc', 'job_post_page', 'Organisation Details', 'Discription', '', ''),
(212, 'org_type', 'job_post_page', 'Type', 'Type', '', ''),
(213, 'j_location', 'job_post_page', 'Location', 'Emplacement', '', ''),
(214, 'j_website', 'job_post_page', 'Website', 'Site Internet', '', ''),
(215, 'tt1', 'job_post_page', 'Work Experience', 'L\'exp', '', ''),
(216, 'tt2', 'job_post_page', 'Job Location', 'lieu de travail', '', ''),
(217, 'tt3', 'job_post_page', 'Skills Required', 'Comp', '', ''),
(218, 's_change', 'recruiter_profile_page', 'Save Changes', 'Sauvegarder les modifications', '', ''),
(219, 'rec-pay_error', 'recruiter_profile_page', 'Information Not available', 'Information non disponible', '', ''),
(220, 'profile_keyword', 'recruiter_profile_page', 'Profile', 'Profil', '', ''),
(221, 'applied_s_heading', 'applied_seeker_page', 'Applied Seeker', '', '', ''),
(222, 'a_s_error', 'applied_seeker_page', 'Applied Seeker Not Found', '', '', ''),
(223, 'view_btn', 'applied_seeker_page', 'View', '', '', ''),
(224, 'job_btn', 'applied_seeker_page', 'Job', '', '', ''),
(225, 'ps_not_change', 'validation', 'email address doesn\'t match any account', 'adresse e-mail ne correspond ', '', ''),
(226, 'c_address', 'validation', 'Enter current address', 'Entrez l\'adresse actuelle', '', ''),
(227, 'pro_not_up', 'validation', 'Profile Not Update', 'Profil non mis ', '', ''),
(228, 'only_jpg', 'validation', 'Profile image only jpg and png file allowed', 'Image de profil uniquement fichier jpg et png autoris', '', ''),
(229, 'ppic_not', 'validation', 'Profile Image ', 'Image de profil non mise ', '', ''),
(230, 'pro_pic_up', 'validation', 'Profile Image updated', 'Image de profil mise ', '', ''),
(231, 'filter_error', 'home_page', 'No job found with this filter', 'aucun travail trouv', '', ''),
(232, 'applay_success', 'my_applied_job_page', 'job applied Successfully', 'emploi appliqu', '', ''),
(233, NULL, 'applied_seeker', '', '', '', ''),
(234, 'active_new_p', 'applied_seeker', 'Active New Plan Click Here', 'Active New Plan Cliquez ici', '', ''),
(235, 'applied_seeker_not_found', 'applied_seeker', 'Applied Seeker Not Found', 'Chercheur appliqu', '', ''),
(236, 'applied_s_heading', 'applied_seeker', 'Applied Seeker', 'Chercheur appliqu', '', ''),
(237, 'view_btn', 'applied_seeker', 'View', 'Vue', '', ''),
(238, 'job_btn', 'applied_seeker', 'Job', 'Emploi', '', ''),
(239, 'seeker_d_heading', 'seeker_info', 'Seeker details', 'D', '', ''),
(240, 'seeker_name', 'seeker_info', 'Seeker Name', 'Nom du chercheur', '', ''),
(241, 'job_type', 'seeker_info', 'Job Type', 'Type d\'emploi', '', ''),
(242, 'qualification', 'seeker_info', 'Qualification', 'Qualification', '', ''),
(243, 'p_year', 'seeker_info', 'Passing Year', 'Ann', '', ''),
(244, 'resume_keyword', 'seeker_info', 'Resume', 'CV', '', ''),
(245, 'resume_download', 'seeker_info', 'Download Resume', 'T', '', ''),
(246, 'Job_details\r\n', 'applied_job_info', 'Job details', 'D', '', ''),
(247, 'i_name', 'applied_job_info', 'Organisation Name', 'Nom de l\'organisme', '', ''),
(248, 'job_posted', 'applied_job_info', 'Job Posted', 'Job Post', '', ''),
(249, 'j_type', 'applied_job_info', 'Job Type', 'Type d\'emploi', '', ''),
(250, 'desi', 'applied_job_info', 'Designation', 'La d', '', ''),
(251, 'qualification', 'applied_job_info', 'Qualification', 'Qualification', '', ''),
(252, 'last_date_a', 'applied_job_info', 'Last Date of Application', 'Derni', '', ''),
(253, 'sp', 'applied_job_info', 'Specialization', 'Sp', '', ''),
(254, 'job_type_select', 'validation', 'Select job type', 'S', '', ''),
(255, 'select_desi', 'validation', 'Select designation', 'S', '', ''),
(256, 'select_job_loc', 'validation', 'Select job location', 'S', '', ''),
(257, 'select_sp', 'validation', 'Select specialization', 'S', '', ''),
(258, 'select_exp', 'validation', 'Select experience', 'S', '', ''),
(259, 'select_r_range', 'validation', 'Select salary range', 'S', '', ''),
(260, 'enter_per_cgpa', 'validation', 'Enter percentage/CGPA', ' Entrez le pourcentage / MPC', '', ''),
(261, 'invelid_per_cgpa', 'validation', 'Invalid percentage/CGPA', 'Pourcentage invalide / MPC', '', ''),
(262, 'enter_tech', 'validation', 'Enter technology', 'Entrez la technologie', '', ''),
(263, 'enter_number_of_v', 'validation', 'Enter number of vacancies  ', 'Entrez le nombre de postes vacants', '', ''),
(264, 'enter_meta_desc', 'validation', 'Enter meta description', 'Entrez meta description', '', ''),
(265, 'enter_meta_key', 'validation', 'Enter meta keyword', 'Entrez le mot-cl', '', ''),
(266, 'enter_a_name', 'validation', 'Enter author name', 'Entrez le nom de l\'auteur', '', ''),
(267, 'enter_job_desc', 'validation', 'Enter job description', 'Entrez la description de poste', '', ''),
(268, 'enter_min_s', 'validation', 'Enter minimun salary', 'Entrer le salaire minimum', '', ''),
(269, 'enter_max_S', 'validation', 'Enter maximum salary', 'Entrer le salaire maximum', '', ''),
(270, 'min_less_max', 'validation', 'Please enter minimun  salary less than maximum salary', 'Veuillez entrer le salaire minimum inf', '', ''),
(271, ' min_s_num', 'validation', 'Minimun salary only number allow', 'Le nombre minimum de salaire ne permet que', '', ''),
(272, 'max_s_num', 'validation', 'Maximum salary only number allow', 'Nombre maximum de salaire uniquement autoris', '', ''),
(273, 'job_post_limit_out', 'validation', 'Your job post limit out please purchase new plan', 'Votre offre d\'emploi est limit', '', ''),
(274, 'job_post_success', 'validation', 'Job posted successfully', 'Job post', '', ''),
(275, 'job_not_post', 'validation', 'Job not posted', 'Job non post', '', ''),
(276, 'job_up_success', 'validation', 'Post successfully updated', 'Message mis ', '', ''),
(277, 'job_not_up', 'validation', 'Post not updated', 'Message non mis ', '', ''),
(278, 'pricing_plans_heading', 'revenue_plans', 'Pricing Plans', 'Plans de tarification', '', ''),
(279, 'select_keyword', 'revenue_plans', 'Select', 'S', '', ''),
(280, 'paymenu_heading', 'payment', 'Payment', 'Paiement4', '', ''),
(281, 'pay_with_key', 'payment', 'Pay with', 'Payer avec', '', ''),
(282, 'pay_now_btn', 'payment', 'Pay Now', 'Payez maintenant', '', ''),
(283, 'profile_update_err', 'user_profile_page', 'Please update your profile setting before applying for the job.', 'Veuillez mettre ', '', ''),
(284, 'pdf_doc_allow_resume', 'validation', 'Uploaded file is not a valid resume file. Only PDF and DOC files are allowed', 'Le fichier t', '', ''),
(285, 'old_ps_enter', 'login_page', 'Old Password', '', '', ''),
(286, 'male_keyword', 'user_profile_page', 'Male', 'M', '', ''),
(287, 'female_keyword', 'user_profile_page', 'Female', 'female1', '', ''),
(288, 'gender_keyword', 'user_profile_page', 'Gender', 'Le genre', '', ''),
(289, 'fresher_keyword', 'user_profile_page', 'Fresher', 'Plus frais', '', ''),
(290, 'experienced_keyword', 'user_profile_page', 'Experienced', 'Experienced', '', ''),
(291, 'guest_keyword', 'login_page', 'Guest', 'Client', '', ''),
(292, 'all_field_required', 'validation', 'All Field Required', 'Tous les champs requis', '', ''),
(293, 'fill_keyword', 'valedation', 'Please filed correct details', '', '', ''),
(294, NULL, 'valedation', '', '', '', ''),
(295, 'policy_heading', 'compliamce', 'Privacy Policy', 'Politique de confidentialit', '', ''),
(296, 'about_heading', 'compliamce', 'About Us', '', '', ''),
(297, 'terms_heading', 'compliamce', 'Terms & Condition', 'Termes et conditions', '', ''),
(298, 'trem_keyword', 'menu_header', 'Terms & Condition', 'Termes et conditions', '', ''),
(299, 'ptivcy_keyword', 'menu_header', 'Privacy Policy', 'Politique de confidentialit', '', ''),
(300, 'about_keyword', 'menu_header', 'About Us', '', '', ''),
(301, 'contect_keyword', 'menu_header', 'Contact Us', 'Contactez nous', '', ''),
(302, 'contect_heding', 'compliamce', 'Contact Us', 'Contactez nous', '', ''),
(303, 'sub_empty', 'validation', 'Enter Subject', 'Entrez le sujet', '', ''),
(304, 'msg_empty', 'validation', 'Enter Subject', 'Entrez le sujet', '', ''),
(305, 'msg_send', 'validation', 'Message Sent', 'Message envoy', '', ''),
(306, 'msg_not_send', 'validation', 'Message Not Send', 'Message non envoy', '', ''),
(307, 'full_name_keyword', 'compliamce', 'Full Name', 'Nom complet', '', ''),
(308, 'mobile_no_keyword', 'compliamce', 'Phone Number', 'Num', '', ''),
(309, 'sub_keyword', 'compliamce', 'Subject', 'Assujettir', '', ''),
(310, 'msg_keyword', 'compliamce', 'Message', 'Message', '', ''),
(311, 'submit_btn', 'compliamce', 'Submit', 'Soumettre', '', ''),
(312, 'pdf_doc_msg', 'user_profile_page', 'only .pdf  and documents file are allowed to be attached', '  seuls les fichiers PDF et documents sont autoris', ' ', ' '),
(313, 'profile_update_err', 'recruiter_profile_page', 'Please update your profile before Post  the Job. ', ' a', ' ', ' '),
(314, 'trem_keyword', 'recruiter_header', 'Terms & Condition', ' Termes et conditions', ' ', ' '),
(315, 'ptivcy_keyword', 'recruiter_header', ' Privacy Policy', ' Politique de confidentialit', ' ', ' '),
(316, 'about_keyword', 'recruiter_header', 'About Us ', ' Politique de confidentialité', ' ', ' '),
(317, 'contect_keyword', 'recruiter_header', 'Contact Us', ' Contactez nous', ' ', ' '),
(318, 'email_enter', 'recruiter_profile_page', 'E-Mail', 'E-Mail', NULL, NULL),
(319, 'payment_process', 'revenue_plans', 'please complete your payment process', 'veuillez compl', NULL, NULL),
(320, 'plan_exp', 'validation', 'Your plan has expired', 'Votre plan a expir', NULL, NULL),
(323, 'gender_heading', 'user_profile_page', 'Gender', NULL, NULL, NULL),
(324, 'delete_job_msg', 'recruiter_home', 'do you want to delete this job', NULL, NULL, NULL),
(325, 'exp_keyword', 'user_profile_page', 'Experienced', NULL, NULL, NULL),
(326, 'fresher_keyword', 'user_profile_page', 'Fresher', NULL, NULL, NULL),
(327, 'job_not_found_msg', 'recruiter_home', 'No job found', NULL, NULL, NULL),
(328, 'rec_filter_placeholder', 'recruiter_home', 'Search Job Here by Location, Skills ', NULL, NULL, NULL);

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

--
-- Table structure for table `jp_language_name`
--

CREATE TABLE `jp_language_name` (
  `id` int(11) NOT NULL,
  `name` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jp_language_name`
--

INSERT INTO `jp_language_name` (`id`, `name`) VALUES
(2, 'english'),
(3, 'french'),
(13, 'greek'),
(14, 'russian');

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

--
-- Table structure for table `jp_notification`
--

CREATE TABLE `jp_notification` (
  `id` int(11) NOT NULL,
  `title` text CHARACTER SET utf8,
  `message` text CHARACTER SET utf8,
  `date1` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `jp_payment`
--

CREATE TABLE `jp_payment` (
  `id` int(11) NOT NULL,
  `p_id` varchar(50) DEFAULT NULL,
  `payment_type` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `pay_amount` varchar(50) DEFAULT NULL,
  `source` text,
  `pay_date` text,
  `email` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `jp_payu`
--

CREATE TABLE `jp_payu` (
  `pay_id` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `mode` varchar(50) DEFAULT NULL,
  `amount` varchar(50) DEFAULT NULL,
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `jp_plans`
--

CREATE TABLE `jp_plans` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `amount_inr` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `duration` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `description` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `amount_usd` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `condation1` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `value1` varchar(20) CHARACTER SET utf8 DEFAULT '1',
  `value2` varchar(50) CHARACTER SET utf8 DEFAULT '1',
  `status` varchar(20) DEFAULT 'Active',
  `plan_duration_type` text,
  `plan_duration_count` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jp_plans`
--

INSERT INTO `jp_plans` (`id`, `name`, `amount_inr`, `duration`, `description`, `amount_usd`, `condation1`, `value1`, `value2`, `status`, `plan_duration_type`, `plan_duration_count`) VALUES
(4, 'test', '1', '300', 'q', '2', 'number_job_post', 'ALL', 'ALL', 'Active', 'Months', '10');

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

--
-- Table structure for table `jp_resume_count`
--

CREATE TABLE `jp_resume_count` (
  `id` int(11) NOT NULL,
  `seeker` varchar(100) DEFAULT NULL,
  `recruiter` varchar(100) DEFAULT NULL,
  `pay_count` varchar(20) NOT NULL DEFAULT '0',
  `job_id` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `jp_revenue`
--

CREATE TABLE `jp_revenue` (
  `id` int(11) NOT NULL,
  `type` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `month` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `price` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `currency` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `symbol` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `description` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `condation` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `value1` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `value2` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `show_on_reg` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `plan_duration_type` text,
  `plan_duration_count` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jp_revenue`
--

INSERT INTO `jp_revenue` (`id`, `type`, `month`, `price`, `currency`, `symbol`, `description`, `condation`, `value1`, `value2`, `show_on_reg`, `plan_duration_type`, `plan_duration_count`) VALUES
(1, 'Recurring', '1', '5', 'USD', '$', 'a', 'number_job_post', '1', '', 'yes', 'Years', '2');

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

--
-- Table structure for table `jp_review`
--

CREATE TABLE `jp_review` (
  `id` int(11) NOT NULL,
  `rat_rating` text CHARACTER SET utf8,
  `comment` text CHARACTER SET utf8,
  `seeker_email` text CHARACTER SET utf8,
  `recruiter_email` text CHARACTER SET utf8
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `jp_setting`
--

CREATE TABLE `jp_setting` (
  `id` int(11) NOT NULL,
  `title` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `keyword` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `description` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `author` text CHARACTER SET utf8,
  `fevi` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `logo_img` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `bg_img` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `google_analytics` text CHARACTER SET utf8,
  `copyright` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `language` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `google_adds_s` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
  `terms_condition` longtext CHARACTER SET utf8,
  `privacy_policy` longtext CHARACTER SET utf8,
  `about_us` longtext CHARACTER SET utf8,
  `contect_img` text CHARACTER SET utf8,
  `add_mob_s` text CHARACTER SET utf8,
  `firebase` text CHARACTER SET utf8,
  `cookie_text` text CHARACTER SET utf8,
  `c_title` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `c_link_text` text CHARACTER SET utf8,
  `c_link` text CHARACTER SET utf8,
  `c_btn_text` text CHARACTER SET utf8,
  `about_img` text CHARACTER SET utf8,
  `main_loder` text CHARACTER SET utf8,
  `paypal_status` text CHARACTER SET utf8,
  `paypal_email` text CHARACTER SET utf8,
  `payu_status` text CHARACTER SET utf8,
  `merchant_key` text CHARACTER SET utf8,
  `merchant_salt` text CHARACTER SET utf8,
  `terms_condition_update_date` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `privacy_policy_update_date` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `google_client_id` text,
  `google_client_secret` text,
  `google_login_status` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jp_setting`
--

INSERT INTO `jp_setting` (`id`, `title`, `keyword`, `description`, `author`, `fevi`, `logo_img`, `bg_img`, `google_analytics`, `copyright`, `language`, `google_adds_s`, `terms_condition`, `privacy_policy`, `about_us`, `contect_img`, `add_mob_s`, `firebase`, `cookie_text`, `c_title`, `c_link_text`, `c_link`, `c_btn_text`, `about_img`, `main_loder`, `paypal_status`, `paypal_email`, `payu_status`, `merchant_key`, `merchant_salt`, `terms_condition_update_date`, `privacy_policy_update_date`, `google_client_id`, `google_client_secret`, `google_login_status`) VALUES
(2, 'job portal', 'Job', 'test', 'kamlesh yadav', '', '', '', '<script>\r\n// code1\r\n</script>', 'Copyright 2018, All Rights Reserved.', 'english', '<script></script>', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Section 1: Collected Information</strong></p><p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Section 1: Collected Information</strong></p><p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Section 2: Use of Data Collected</strong></p><p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><strong>Section 3: Disclosure of Data to Third Parties</strong></p><p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>', '<p>lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p>It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p>It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p>It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>', '', '', '', 'We use  them to give you the  best experience. If you continue using our website, we\'ll assume that you are happy to receive all cookies on this website.  {LINK} ', 'Accept Cookies', 'More information', 'http://pixelpages.net/job_portal/home/policy', 'Accept Cookies', 'uploads/setting/payu.jpg', '', 'active', '', 'active', '', '', '2nd  October 2018 ', '2nd  October 2018 ', '', '', 'active');

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

--
-- Table structure for table `jp_setting_email`
--

CREATE TABLE `jp_setting_email` (
  `id` int(11) NOT NULL,
  `seeker_email` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `seeker_veri_msg` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `seeker_forgot_msg` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `seeker_subject` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `recruiter_email` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `recruiter_veri_msg` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `recruiter_forgot_msg` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `recruiter_subject` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `compliamce_pages` varchar(50) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jp_setting_email`
--

INSERT INTO `jp_setting_email` (`id`, `seeker_email`, `seeker_veri_msg`, `seeker_forgot_msg`, `seeker_subject`, `recruiter_email`, `recruiter_veri_msg`, `recruiter_forgot_msg`, `recruiter_subject`, `compliamce_pages`) VALUES
(1, 'xyz@jp.com', 'Please verify your email address', 'Your Seeker Account New Password ', 'Job Portal Seeker Account', 'xyz@jp.com', 'verify your email address', 'Your job portal  Recruiter account new password', 'Job Portal Recruiter Account', NULL);

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

--
-- Table structure for table `jp_setting_footer`
--

CREATE TABLE `jp_setting_footer` (
  `id` int(11) NOT NULL,
  `name` varchar(250) DEFAULT NULL,
  `link` varchar(250) DEFAULT NULL,
  `status` varchar(250) DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jp_setting_footer`
--

INSERT INTO `jp_setting_footer` (`id`, `name`, `link`, `status`) VALUES
(1, 'Behance', 'https://www.behance.net/', 'Active'),
(2, 'Facebook', 'https://www.facebook.com/', 'Active'),
(3, 'Google', 'https://www.google.com', 'Active'),
(4, 'Linkedin', 'https://www.linkedin.com/', 'Active'),
(5, 'Instagram', 'https://www.instagram.com/', 'Active'),
(6, 'pinterest', 'https://in.pinterest.com/', 'Active'),
(7, 'Twitter', 'https://twitter.com/', 'Active'),
(8, 'Youtube', 'https://www.youtube.com/', 'Active');

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

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(20) CHARACTER SET cp1250 COLLATE cp1250_bin NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `qualification`
--

CREATE TABLE `qualification` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `recruiter`
--

CREATE TABLE `recruiter` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `mno` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `ps` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `org_type` varchar(50) CHARACTER SET utf8 DEFAULT '--',
  `location` varchar(50) CHARACTER SET utf8 DEFAULT '--',
  `address` varchar(200) CHARACTER SET utf8 DEFAULT '--',
  `website` varchar(100) CHARACTER SET utf8 DEFAULT '--',
  `des` varchar(250) CHARACTER SET utf8 DEFAULT '--',
  `veri` varchar(50) CHARACTER SET utf8 DEFAULT '--',
  `img` varchar(250) CHARACTER SET utf8 DEFAULT 'assets/images/user.svg',
  `plan` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `pay` varchar(50) CHARACTER SET utf8 DEFAULT 'no',
  `pay_date` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `type` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `month` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `show_on_reg` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT 'Active',
  `pay_count` varchar(50) CHARACTER SET utf8 DEFAULT '0',
  `paypal` text CHARACTER SET utf8,
  `counter` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
  `google_id` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `seeker`
--

CREATE TABLE `seeker` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `mno` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `ps` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `gender` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `current_address` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `p_locaion` varchar(50) DEFAULT NULL,
  `job_type` varchar(50) CHARACTER SET utf8 DEFAULT ' ',
  `qua` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `p_year` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `cgpa` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `aofs` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `exp` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `resume` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `veri` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `img` varchar(250) CHARACTER SET utf8 DEFAULT 'assets/images/user.svg',
  `counter` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '0',
  `status` varchar(20) CHARACTER SET utf8 DEFAULT 'Active',
  `token` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
  `google_id` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `specialization`
--

CREATE TABLE `specialization` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `jp_language`
--
ALTER TABLE `jp_language`
  ADD PRIMARY KEY (`language_id`);

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

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

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

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

--
-- Indexes for table `jp_plans`
--
ALTER TABLE `jp_plans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

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

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

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

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

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

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

--
-- Indexes for table `location`
--
ALTER TABLE `location`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `area_of_sectors`
--
ALTER TABLE `area_of_sectors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `designation`
--
ALTER TABLE `designation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `experience`
--
ALTER TABLE `experience`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_post`
--
ALTER TABLE `job_post`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_role`
--
ALTER TABLE `job_role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `job_types`
--
ALTER TABLE `job_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jp_applay_job`
--
ALTER TABLE `jp_applay_job`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jp_contect_us`
--
ALTER TABLE `jp_contect_us`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jp_custom_ads`
--
ALTER TABLE `jp_custom_ads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `jp_language`
--
ALTER TABLE `jp_language`
  MODIFY `language_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=329;

--
-- AUTO_INCREMENT for table `jp_language_name`
--
ALTER TABLE `jp_language_name`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `jp_notification`
--
ALTER TABLE `jp_notification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jp_payment`
--
ALTER TABLE `jp_payment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jp_payu`
--
ALTER TABLE `jp_payu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jp_plans`
--
ALTER TABLE `jp_plans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `jp_resume_count`
--
ALTER TABLE `jp_resume_count`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `jp_revenue`
--
ALTER TABLE `jp_revenue`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `jp_review`
--
ALTER TABLE `jp_review`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jp_setting`
--
ALTER TABLE `jp_setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `jp_setting_email`
--
ALTER TABLE `jp_setting_email`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `jp_setting_footer`
--
ALTER TABLE `jp_setting_footer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `location`
--
ALTER TABLE `location`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `qualification`
--
ALTER TABLE `qualification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `recruiter`
--
ALTER TABLE `recruiter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `seeker`
--
ALTER TABLE `seeker`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `specialization`
--
ALTER TABLE `specialization`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

--
-- 30 April 2020 Start
--

ALTER TABLE `jp_setting` ADD `chat_system` varchar(100) DEFAULT 'false' AFTER `google_login_status`;

INSERT INTO `jp_language` (`language_key`, `language_type`, `english`) VALUES
('chat_text', 'menu_header', 'Chats'),('chat_btn_text', 'home_page', 'Chat'),('rchat_btn_text', 'recruiter_home', 'Chat'),('chat_btn_text', 'my_applied_job_page', 'Chat'),('chat_btn_text', 'single_job', 'Chat'),('chat_text', 'recruiter_header', 'Chats');

CREATE TABLE `jp_chat_message` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` varchar(500),
  `user_to` varchar(500),
  `msg` text,
  `deliver` int,
  `date` datetime,
  PRIMARY KEY (id),
  INDEX (id)
)CHARACTER SET utf8 COLLATE utf8_unicode_ci;

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