-- phpMyAdmin SQL Dump
-- version 5.1.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Dec 09, 2022 at 10:37 AM
-- Server version: 10.4.19-MariaDB
-- PHP Version: 7.4.19

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

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

--
-- Table structure for table `academic`
--

CREATE TABLE `academic` (
  `id` int(11) NOT NULL,
  `candidateId` varchar(20) NOT NULL,
  `institution` varchar(200) DEFAULT NULL,
  `level` varchar(200) DEFAULT NULL,
  `program` varchar(200) DEFAULT NULL,
  `start` date DEFAULT NULL,
  `end` date DEFAULT NULL,
  `score` varchar(20) DEFAULT NULL,
  `DateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `academic`
--

TRUNCATE TABLE `academic`;
--
-- Dumping data for table `academic`
--

INSERT INTO `academic` (`id`, `candidateId`, `institution`, `level`, `program`, `start`, `end`, `score`, `DateCreated`) VALUES
(1, '2', 'uok', 'bachelor', 'bsc', '2022-08-01', '2022-08-10', 'a', '2022-08-08 04:27:14'),
(2, '3', 'jkuat', 'bachelor', 'bsc human resousce mgt', '2004-01-01', '2008-12-08', 'first class', '2022-08-08 07:57:31');

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

--
-- Table structure for table `additions`
--

CREATE TABLE `additions` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `employee` varchar(50) NOT NULL,
  `jobgroup` varchar(50) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `additions`
--

TRUNCATE TABLE `additions`;
--
-- Dumping data for table `additions`
--

INSERT INTO `additions` (`id`, `name`, `description`, `type`, `employee`, `jobgroup`, `amount`, `startDate`, `endDate`, `dateCreated`) VALUES
(1, 'House allowance -oficer1', 'officer house allowance', 'jobGroup', 'null', '9', '20000', '2022-11-01', '2051-01-26', '2022-11-26 10:28:53'),
(2, 'Transport allowance - officer1', 'transport allowance', 'jobGroup', 'null', '9', '5000', '2022-11-28', '2045-06-28', '2022-11-28 12:41:00'),
(3, 'Airtime Allowance- officer1', 'Artime allowance for officer 1', 'individual', 'K69226/2022', '8', '3000', '2022-11-29', '2022-12-29', '2022-11-29 11:22:46'),
(4, 'house allaowance-mng', 'managers house allawance', 'jobGroup', 'null', '12', '100000', '2022-12-05', '2026-10-25', '2022-12-05 10:18:43'),
(5, 'hod-house allowance', 'hod-house allowance', 'jobGroup', 'null', '13', '100000', '2022-12-05', '2034-10-18', '2022-12-05 10:52:06'),
(6, 'hod-millage allowance', 'hod-millage allowance', 'individual', 'K65972/2022', '8', '10000', '2022-12-05', '2023-03-31', '2022-12-05 10:54:33');

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

--
-- Table structure for table `application`
--

CREATE TABLE `application` (
  `id` int(11) NOT NULL,
  `applicantID` varchar(40) NOT NULL,
  `jobID` varchar(40) NOT NULL,
  `cletter` longtext NOT NULL,
  `salary` varchar(20) NOT NULL,
  `availability` date NOT NULL,
  `attachments` varchar(200) NOT NULL,
  `status` varchar(100) NOT NULL DEFAULT 'inProgress',
  `DateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `application`
--

TRUNCATE TABLE `application`;
--
-- Dumping data for table `application`
--

INSERT INTO `application` (`id`, `applicantID`, `jobID`, `cletter`, `salary`, `availability`, `attachments`, `status`, `DateCreated`) VALUES
(11, '2', '8', 'format', '455500', '2022-08-19', '/Applications/XAMPP/xamppfiles/htdocs/hrm/files/cv/2part1.pdf', '', '2022-08-19 13:04:19'),
(12, '2', '10', 'well done', '20000', '2022-08-19', '/hrm/filescv/2Newton_ID.pdf', 'shortlisted', '2022-08-19 14:20:01'),
(13, '2', '11', 'well done', '200000', '2022-08-17', '/hrm/files/cv/2laptopFinal.pdf', '', '2022-08-19 14:21:25'),
(14, '2', '12', 'WELL DONE', '450000', '2022-08-31', '/hrm/files/cv/2Clinton Laptop docs.pdf', '', '2022-08-19 14:45:28'),
(15, '2', '13', 'I WANT THIS JOB', '4500000', '2022-08-31', '/hrm/files/cv/2NewsFlash_Issue_08_Aug_22_2022.pdf', 'shortlisted', '2022-08-20 08:18:27'),
(16, '4', '13', 'Give me the job', '500000', '2022-09-01', '/hrm/files/cv/4NEW_CV-1.pdf', 'rejected', '2022-08-20 08:45:11'),
(17, '5', '13', 'Have good experience in hr', '300000', '2022-09-01', '/hrm/files/cv/516609851381526062854384450391713.jpg', 'contacted', '2022-08-20 08:46:03'),
(18, '6', '13', 'APPLICATION', '100000', '2022-08-27', '/hrm/files/cv/6', '', '2022-08-20 08:52:28'),
(19, '', '', 'Give me the job', '500000', '2022-09-01', '/hrm/files/cv/NEW_CV-1.pdf', '', '2022-08-20 09:58:20'),
(20, '2', '14', 'na', 'na', '2022-08-20', '/hrm/files/cv/2Sales Rep- MNC Consulting Group Limited.jpeg', '', '2022-08-20 10:13:05'),
(21, '5', '16', 'I need the job', '500000', '2022-08-27', '/hrm/files/cv/5', '', '2022-08-20 10:26:17'),
(22, '2', '10', '<p>gfgfhhfhfff</p>\r\n', '23456786543', '2022-08-25', '/hrm/files/cv/2blank-profile-picture-973460__340.webp', 'shortlisted', '2022-08-25 07:49:10'),
(23, '2', '10', '<p>sdfghj</p>\r\n', '234567', '2022-08-26', '/hrm/files/cv/2images.jpeg', 'shortlisted', '2022-08-25 07:57:34'),
(24, '2', '10', '<p>sdfghjkghj</p>\r\n', '5000000', '2022-08-25', '/hrm/files/cv/2logo.png', 'shortlisted', '2022-08-25 10:01:54'),
(25, '2', '10', '<p>jkgkgkgk</p>\r\n', '345678', '2022-08-31', 'null', 'shortlisted', '2022-08-25 12:54:05'),
(28, '2', '18', '<p>done</p>\r\n', '200000000', '2022-08-31', 'null', '', '2022-08-28 08:34:56');

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

--
-- Table structure for table `awards`
--

CREATE TABLE `awards` (
  `id` int(11) NOT NULL,
  `applicantID` varchar(20) NOT NULL,
  `tile` varchar(300) NOT NULL,
  `body` varchar(100) NOT NULL,
  `class` varchar(100) NOT NULL,
  `dateOfAward` date NOT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `awards`
--

TRUNCATE TABLE `awards`;
--
-- Dumping data for table `awards`
--

INSERT INTO `awards` (`id`, `applicantID`, `tile`, `body`, `class`, `dateOfAward`, `dateCreated`) VALUES
(1, '2', 'NOVEMBER 2020', 'NOVEMBER', 'EMPLOYEE OF THE MONTH AWARDS', '2022-08-29', '2022-08-28 15:42:34'),
(2, '2', 'SCIENCE', 'NACOSTI', 'INNOVATION AWARD', '2016-08-12', '2022-08-28 15:45:10');

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

--
-- Table structure for table `candidates`
--

CREATE TABLE `candidates` (
  `id` int(11) NOT NULL,
  `fullname` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `tell` varchar(200) DEFAULT NULL,
  `idNo` varchar(200) DEFAULT NULL,
  `nationality` varchar(200) DEFAULT NULL,
  `county` varchar(200) DEFAULT NULL,
  `disability` varchar(10) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp(),
  `password` varchar(200) DEFAULT NULL,
  `division` varchar(50) DEFAULT NULL,
  `location` varchar(50) DEFAULT NULL,
  `subLocation` varchar(50) DEFAULT NULL,
  `village` varchar(50) DEFAULT NULL,
  `drivingLicence` varchar(50) DEFAULT NULL,
  `image` varchar(100) DEFAULT '/hrm/files/cv/2blank-profile-picture-973460__340.webp',
  `profession` varchar(100) DEFAULT NULL,
  `code` varchar(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `candidates`
--

TRUNCATE TABLE `candidates`;
--
-- Dumping data for table `candidates`
--

INSERT INTO `candidates` (`id`, `fullname`, `email`, `tell`, `idNo`, `nationality`, `county`, `disability`, `gender`, `dob`, `dateCreated`, `password`, `division`, `location`, `subLocation`, `village`, `drivingLicence`, `image`, `profession`, `code`) VALUES
(1, 'clinton misango', 'cmurilla@outlook.com', '07777777777', '30673304', 'israeli', 'vihiga', '', 'male', '1994-05-31', '2022-08-08 00:44:45', NULL, NULL, NULL, NULL, NULL, '', '/hrm/files/cv/2blank-profile-picture-973460__340.webp', '', NULL),
(2, 'CLINTON', 'cmurilla@gmail.com', '0715745434', '30673304', 'KENYANF', 'BARINGO', 'YES', 'MALE', '1994-05-24', '2022-08-08 03:01:26', '123', 'MATUNGUJR', 'GFGGFG', 'GFGFGF', 'GFHFHFHF', 'YES', '/hrm/files/cv/25687pp1.jpeg', 'CHOOSE', '254'),
(3, 'Douglus gikunju', 'douglas.mnc@mncconsulting.co.ke', '0725789102', '200984557', 'Kenyan', 'Kirinyaga', 'no', 'male', '1987-05-04', '2022-08-08 07:54:25', '1234', NULL, NULL, NULL, NULL, '', NULL, '', NULL),
(4, 'Newton Karani', 'Newtonkarani98@gmail.com', '0713676940', '34831847', 'Kenya', 'Nairobi', 'no', 'male', '1998-01-30', '2022-08-20 08:28:03', '123456', NULL, NULL, NULL, NULL, '', NULL, '', NULL),
(5, 'Douglas', 'dwgikunju@gmail.com ', '0725789102', '22441036', 'Kenyan', 'Kirinyaga', 'no', 'male', '1981-12-04', '2022-08-20 08:28:34', '22441036dg', NULL, NULL, NULL, NULL, '', NULL, '', NULL),
(11, 'JAMES NDAMBIRI', 'cpandambiri@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-22 03:38:24', 'Gacirata', NULL, NULL, NULL, NULL, '', NULL, '', NULL),
(12, 'misango Jacob', 'wintec.co.ke', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-22 03:44:32', '123', NULL, NULL, NULL, NULL, '', NULL, '', NULL),
(13, 'KENNEDY OMONDI OYIENO', 'kennedyoyieno87@gmail.com', '0797496508', '29437721', 'KENYAN', 'SIAYA', 'no', 'male', '1988-12-24', '2022-08-22 07:30:03', 'Ken12345', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL),
(14, 'KENNEDY OMONDI OYIENO', 'kennedyoyieno87@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-22 10:07:27', 'Ken12345', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL),
(15, 'CLINTON MURILLA MISANGO', 'CMISANGO@GMAIL.COM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-08-23 05:43:16', '123', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL);

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

--
-- Table structure for table `deductions`
--

CREATE TABLE `deductions` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `employee` varchar(50) NOT NULL,
  `jobgroup` varchar(50) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `deductions`
--

TRUNCATE TABLE `deductions`;
--
-- Dumping data for table `deductions`
--

INSERT INTO `deductions` (`id`, `name`, `description`, `type`, `employee`, `jobgroup`, `amount`, `startDate`, `endDate`, `dateCreated`) VALUES
(1, 'Pension -officer1', 'pension deduction', 'jobGroup', 'null', '9', '20000', '2022-11-28', '2032-12-28', '2022-11-28 10:22:53'),
(2, 'hod -pension', 'hod -pension', 'jobGroup', 'null', '13', '20000', '2022-12-05', '2029-11-24', '2022-12-05 10:57:23'),
(3, 'ushuru sacco loan ', 'ushuru sacco loan ', 'individual', 'K65972/2022', '8', '50000', '2022-12-05', '2022-08-31', '2022-12-05 10:58:15');

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(300) DEFAULT NULL,
  `head` varchar(100) DEFAULT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `departments`
--

TRUNCATE TABLE `departments`;
--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `name`, `description`, `head`, `dateCreated`) VALUES
(1, 'ict', '112222', 'certificate', '2022-11-23 08:33:50'),
(2, 'Acounting', 'acounting', 'certificate', '2022-11-25 12:01:35'),
(3, 'human resource department', 'hr', 'certificate', '2022-11-25 12:01:58'),
(4, 'management', 'mangement', 'certificate', '2022-11-25 12:03:37'),
(5, 'Marketing', 'Marketing Department', 'K1910/2022', '2022-12-05 10:31:38');

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

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `id` int(11) NOT NULL,
  `fullname` varchar(200) NOT NULL,
  `staffID` varchar(20) NOT NULL,
  `email` varchar(200) NOT NULL,
  `tell` varchar(200) DEFAULT NULL,
  `idNo` varchar(200) DEFAULT NULL,
  `nationality` varchar(200) DEFAULT NULL,
  `county` varchar(200) DEFAULT NULL,
  `disability` varchar(10) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp(),
  `password` varchar(200) DEFAULT NULL,
  `division` varchar(50) DEFAULT NULL,
  `location` varchar(50) DEFAULT NULL,
  `subLocation` varchar(50) DEFAULT NULL,
  `village` varchar(50) DEFAULT NULL,
  `drivingLicence` varchar(50) DEFAULT NULL,
  `image` varchar(100) DEFAULT '/hrm/files/cv/2blank-profile-picture-973460__340.webp',
  `profession` varchar(100) DEFAULT NULL,
  `code` varchar(11) DEFAULT NULL,
  `kraPin` varchar(20) NOT NULL,
  `nssf` varchar(20) NOT NULL,
  `nhif` varchar(20) NOT NULL,
  `department` varchar(100) DEFAULT NULL,
  `jobgroup` varchar(100) DEFAULT NULL,
  `position` varchar(100) DEFAULT NULL,
  `region` varchar(100) DEFAULT NULL,
  `bank` varchar(50) DEFAULT NULL,
  `accNo` varchar(100) DEFAULT NULL,
  `branch` varchar(100) DEFAULT NULL,
  `swiftCode` varchar(50) DEFAULT NULL,
  `Estatus` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `employee`
--

TRUNCATE TABLE `employee`;
--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`id`, `fullname`, `staffID`, `email`, `tell`, `idNo`, `nationality`, `county`, `disability`, `gender`, `dob`, `dateCreated`, `password`, `division`, `location`, `subLocation`, `village`, `drivingLicence`, `image`, `profession`, `code`, `kraPin`, `nssf`, `nhif`, `department`, `jobgroup`, `position`, `region`, `bank`, `accNo`, `branch`, `swiftCode`, `Estatus`) VALUES
(11, 'john  mutisa muriki', 'K3326/2022', 'cmurilla@gmail.com', '0715745434', '30673305', 'kenyan', 'nairobi', 'no', 'male', '2022-11-24', '2022-11-25 10:46:37', NULL, 'nairobi', 'nairobi', 'nairobi', 'nairobi', '23456543', '/hrm/files/cv/2blank-profile-picture-973460__340.webp', '', NULL, 'ajdjdjkffkfkfk', '56765676', '45367847', 'ict', '10', 'Software Developer', 'North Of Nairobi', NULL, NULL, NULL, NULL, 'Active'),
(12, 'Joseph mutua wadika', 'K69226/2022', 'jkw@gmail.com', '0715745430', '30673309', 'Kenyan', 'Nairobi', 'no', 'male', '2022-11-02', '2022-11-25 12:39:42', NULL, 'makunga', 'nakinga', 'na', 'mayoni', '43453354', '/hrm/files/cv/2blank-profile-picture-973460__340.webp', '', NULL, 'A0065785857N', '453535', '6577565657', 'human resource department', '9', 'Head of HR', 'head quaters', NULL, NULL, NULL, NULL, 'Active'),
(13, 'John maina waheguru', 'K1910/2022', 'jkw@gmail.com', '0715745430', '30673308', 'Kenyan', 'Nairobi', 'no', 'male', '2022-11-02', '2022-11-25 12:50:49', NULL, 'makunga', 'nakinga', 'na', 'mayoni', '43453354', '/hrm/files/cv/2blank-profile-picture-973460__340.webp', '', NULL, 'A0065785857N', '453535', '6577565657', 'Acounting', '11', 'Software Developer', 'embu', NULL, NULL, NULL, NULL, 'Active'),
(14, 'DEBORA JULIE OKETCH', 'K48664/2022', 'deboraKnightjulie@gmail.com', '0758042299', '38110645', 'kenyan', 'nairobi', 'no', 'male', '2000-08-04', '2022-12-01 17:26:52', NULL, 'nairobi', 'nairobi', 'nairobi', 'nairobi', '23456543', '/hrm/files/cv/2blank-profile-picture-973460__340.webp', '', NULL, 'A099585858N', '56765676', '45367847', 'ict', '9', 'Software Developer', 'embu', NULL, NULL, NULL, NULL, 'Active'),
(15, 'james Ndambiri ', 'K73722/2022', 'cpandambiri@gmail.com', '0727810285', '22222222', 'kenyan', 'kirinyaga', 'no', 'male', '2022-12-05', '2022-12-05 10:10:30', NULL, 'na', 'na', 'na', 'na', '34533633', '/hrm/files/cv/2blank-profile-picture-973460__340.webp', '', NULL, 'A43553644N', '5444645', '343564567', 'management', '12', 'Head of HR', 'head quaters', 'kcb', '34435334343', 'cbd', '3456', 'Active'),
(16, 'Charlse Mbugua ', 'K65972/2022', 'charles.njoroge@mncconsulting.co.ke', '0723154908', '43546434', 'kenyan', 'kirinyaga', 'no', 'male', '1996-06-05', '2022-12-05 10:47:32', NULL, 'na', 'na', 'na', 'na', '3445566', '/hrm/files/cv/2blank-profile-picture-973460__340.webp', '', NULL, 'A65765454K', '75657556', '24255363', 'Marketing', '13', 'Head of Marketing', 'Nyeri', 'kcb', '34435334343', 'cbd', '3456', 'Active');

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

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

CREATE TABLE `experience` (
  `id` int(11) NOT NULL,
  `candidateId` varchar(20) NOT NULL,
  `employer` varchar(200) DEFAULT NULL,
  `position` varchar(200) DEFAULT NULL,
  `roles` varchar(200) DEFAULT NULL,
  `start` date NOT NULL,
  `end` date NOT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `experience`
--

TRUNCATE TABLE `experience`;
--
-- Dumping data for table `experience`
--

INSERT INTO `experience` (`id`, `candidateId`, `employer`, `position`, `roles`, `start`, `end`, `dateCreated`) VALUES
(1, '2', 'kra', 'engineer', 'development', '2022-08-01', '2022-08-20', '2022-08-08 05:46:18'),
(2, '3', 'kra', 'software engineer', 'development of systems', '2020-01-01', '2022-08-31', '2022-08-08 08:06:19');

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

--
-- Table structure for table `jobgroup`
--

CREATE TABLE `jobgroup` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `department` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `payType` varchar(50) NOT NULL,
  `basic` varchar(50) NOT NULL,
  `rate` varchar(20) NOT NULL,
  `commision` varchar(20) NOT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `jobgroup`
--

TRUNCATE TABLE `jobgroup`;
--
-- Dumping data for table `jobgroup`
--

INSERT INTO `jobgroup` (`id`, `name`, `department`, `description`, `payType`, `basic`, `rate`, `commision`, `dateCreated`) VALUES
(8, 'Commission', 'ict', 'This is where you earn on sales', 'commission', '', '', '25', '2022-11-24 07:55:45'),
(9, 'officer1', 'human resource department', 'entry level graduate', 'basic', '75000', '', '', '2022-11-25 12:18:42'),
(10, 'officer2', 'human resource department', 'entry level', 'timeSheet', '', '100', '', '2022-11-25 12:26:47'),
(11, 'oficer3', 'human resource department', 'commissioned entry level', 'commission', '', '', '10', '2022-11-25 12:33:54'),
(12, 'manager', 'management', 'manager', 'basic', '400000', '', '', '2022-12-05 10:09:02'),
(13, 'Head of department', 'Marketing', 'hod paygrop', 'basic', '300000', '300', '25', '2022-12-05 10:40:45');

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

--
-- Table structure for table `positions`
--

CREATE TABLE `positions` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `duties` longtext NOT NULL,
  `department` varchar(100) NOT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `positions`
--

TRUNCATE TABLE `positions`;
--
-- Dumping data for table `positions`
--

INSERT INTO `positions` (`id`, `name`, `description`, `duties`, `department`, `dateCreated`) VALUES
(1, 'Intern', 'Intern', '<p>Intern&nbsp;</p>\r\n', 'ict', '2022-11-23 09:47:29'),
(2, 'Software Developer', 'Software Developer', '<p>This is what a software developer is supposed to be doing</p>\r\n', 'ict', '2022-11-23 09:57:21'),
(9, 'Head of HR', 'hr boss', '<p>mange human resource</p>\r\n', 'human resource department', '2022-11-25 12:06:44'),
(10, 'Head of Marketing', 'incharge of  Marketing', '<ul>\r\n	<li><strong>incharge of &nbsp;Marketing</strong></li>\r\n</ul>\r\n', 'Marketing', '2022-12-05 10:36:55');

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

--
-- Table structure for table `profesional`
--

CREATE TABLE `profesional` (
  `id` int(11) NOT NULL,
  `candidateID` varchar(20) NOT NULL,
  `institution` varchar(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `program` varchar(100) NOT NULL,
  `start` varchar(100) NOT NULL,
  `mno` varchar(100) NOT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `profesional`
--

TRUNCATE TABLE `profesional`;
--
-- Dumping data for table `profesional`
--

INSERT INTO `profesional` (`id`, `candidateID`, `institution`, `level`, `program`, `start`, `mno`, `dateCreated`) VALUES
(1, '2', 'ICPAK', 'ASSOCIATE', 'CPAK', '2022-08-23', '20', '2022-08-28 13:07:17');

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

--
-- Table structure for table `referrees`
--

CREATE TABLE `referrees` (
  `id` int(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `tell` varchar(50) NOT NULL,
  `applicantID` varchar(10) NOT NULL,
  `organisation` varchar(200) NOT NULL,
  `DateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `referrees`
--

TRUNCATE TABLE `referrees`;
--
-- Dumping data for table `referrees`
--

INSERT INTO `referrees` (`id`, `fullname`, `email`, `tell`, `applicantID`, `organisation`, `DateCreated`) VALUES
(1, 'clint', 'cmurilla@gmail.com', '0715745434', '15', 'kra', '2022-08-24 16:50:00'),
(2, 'jjjjjj', 'cmurilla@gmail.com', '0715745434', '2', 'mnc', '2022-08-25 12:57:03'),
(3, 'full ad', 'cmurilla@gmail.com', '0715745434', '2', 'kenya', '2022-08-25 15:34:42'),
(4, 'full ad', 'cmurilla@gmail.com', '0715745434', '2', 'kenya', '2022-08-25 15:35:04');

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

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `head` varchar(100) DEFAULT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `regions`
--

TRUNCATE TABLE `regions`;
--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`id`, `name`, `address`, `head`, `dateCreated`) VALUES
(1, 'kakamega', '2345 -00100', 'diploma', '2022-11-23 08:51:33'),
(2, 'North Of Nairobi', '1000-00500', 'phd', '2022-11-23 09:58:16'),
(3, 'head quaters', 'thika road', 'diploma', '2022-11-25 12:02:54'),
(4, 'embu', 'embu branch', 'certificate', '2022-11-25 12:03:18'),
(5, 'Nyeri', 'Nyeri Branch', 'K3326/2022', '2022-12-05 10:34:48');

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

--
-- Table structure for table `shortlist`
--

CREATE TABLE `shortlist` (
  `id` int(11) NOT NULL,
  `jobID` varchar(20) NOT NULL,
  `applicantID` varchar(20) NOT NULL,
  `DateCreated` timestamp NOT NULL DEFAULT current_timestamp(),
  `cid` varchar(20) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `written` varchar(20) DEFAULT NULL,
  `oral` varchar(20) DEFAULT NULL,
  `technical` varchar(20) DEFAULT NULL,
  `general` varchar(20) DEFAULT NULL,
  `notes` longtext DEFAULT NULL,
  `total` varchar(20) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `shortlist`
--

TRUNCATE TABLE `shortlist`;
--
-- Dumping data for table `shortlist`
--

INSERT INTO `shortlist` (`id`, `jobID`, `applicantID`, `DateCreated`, `cid`, `telephone`, `written`, `oral`, `technical`, `general`, `notes`, `total`, `status`) VALUES
(2, '13', '5', '2022-08-21 19:16:34', NULL, '20', '40', '10', '5', NULL, NULL, '75', 'selected'),
(3, '13', '6', '2022-08-21 19:37:13', NULL, '20', '35', '10', '11', '8', '<p>well</p>\r\n\r\n<p>good candidate</p>\r\n', '84', 'selected'),
(4, '8', '2', '2022-08-21 23:32:14', NULL, '19', NULL, '30', NULL, '30', '<p><strong>telephone&nbsp;</strong></p>\r\n\r\n<p>good speaker</p>\r\n', '79', 'selected'),
(5, '13', '2', '2022-11-13 23:33:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, '10', '2', '2022-11-14 00:12:43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL);

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `staffID` varchar(50) NOT NULL,
  `type` varchar(20) NOT NULL,
  `month` varchar(20) NOT NULL,
  `year` varchar(20) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `dateCreated` timestamp NOT NULL DEFAULT current_timestamp(),
  `user` varchar(50) DEFAULT NULL,
  `disp` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `transactions`
--

TRUNCATE TABLE `transactions`;
--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `staffID`, `type`, `month`, `year`, `amount`, `dateCreated`, `user`, `disp`) VALUES
(1, 'K3326/2022', 'paye', 'Dec', '2022', '7383.35', '2022-12-05 00:49:42', 'user1', 'PAYE'),
(2, 'K3326/2022', 'nhif', 'Dec', '2022', '1200', '2022-12-05 00:49:42', 'user1', 'NHIF'),
(3, 'K3326/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 00:49:42', 'user1', 'NSSF'),
(4, 'K3326/2022', 'net', 'Dec', '2022', '41216.65', '2022-12-05 00:49:42', 'user1', 'NET'),
(5, 'K69226/2022', 'basic', 'Dec', '2022', '75000', '2022-12-05 00:49:42', 'user1', 'Basic salary'),
(6, 'K69226/2022', 'addition', 'Dec', '2022', '20000', '2022-12-05 00:49:42', 'user1', 'House allowance -oficer1'),
(7, 'K69226/2022', 'addition', 'Dec', '2022', '5000', '2022-12-05 00:49:42', 'user1', 'Transport allowance - officer1'),
(8, 'K69226/2022', 'addition', 'Dec', '2022', '3000', '2022-12-05 00:49:42', 'user1', 'Airtime Allowance- officer1'),
(9, 'K69226/2022', 'paye', 'Dec', '2022', '23283.35', '2022-12-05 00:49:42', 'user1', 'PAYE'),
(10, 'K69226/2022', 'nhif', 'Dec', '2022', '1700', '2022-12-05 00:49:42', 'user1', 'NHIF'),
(11, 'K69226/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 00:49:42', 'user1', 'NSSF'),
(12, 'K69226/2022', 'deductions', 'Dec', '2022', '20000', '2022-12-05 00:49:42', 'user1', 'Pension -officer1'),
(13, 'K69226/2022', 'net', 'Dec', '2022', '77816.65', '2022-12-05 00:49:42', 'user1', 'NET'),
(14, 'K1910/2022', 'paye', 'Dec', '2022', '7383.35', '2022-12-05 00:49:42', 'user1', 'PAYE'),
(15, 'K1910/2022', 'nhif', 'Dec', '2022', '1200', '2022-12-05 00:49:42', 'user1', 'NHIF'),
(16, 'K1910/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 00:49:42', 'user1', 'NSSF'),
(17, 'K1910/2022', 'net', 'Dec', '2022', '41216.65', '2022-12-05 00:49:42', 'user1', 'NET'),
(18, 'K48664/2022', 'basic', 'Dec', '2022', '75000', '2022-12-05 00:49:42', 'user1', 'Basic salary'),
(19, 'K48664/2022', 'addition', 'Dec', '2022', '20000', '2022-12-05 00:49:42', 'user1', 'House allowance -oficer1'),
(20, 'K48664/2022', 'addition', 'Dec', '2022', '5000', '2022-12-05 00:49:42', 'user1', 'Transport allowance - officer1'),
(21, 'K48664/2022', 'paye', 'Dec', '2022', '22383.35', '2022-12-05 00:49:42', 'user1', 'PAYE'),
(22, 'K48664/2022', 'nhif', 'Dec', '2022', '1700', '2022-12-05 00:49:42', 'user1', 'NHIF'),
(23, 'K48664/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 00:49:42', 'user1', 'NSSF'),
(24, 'K48664/2022', 'deductions', 'Dec', '2022', '20000', '2022-12-05 00:49:42', 'user1', 'Pension -officer1'),
(25, 'K48664/2022', 'net', 'Dec', '2022', '75716.65', '2022-12-05 00:49:42', 'user1', 'NET'),
(26, 'K3326/2022', 'paye', 'Dec', '2022', '7383.35', '2022-12-05 11:14:40', 'user1', 'PAYE'),
(27, 'K3326/2022', 'nhif', 'Dec', '2022', '1200', '2022-12-05 11:14:40', 'user1', 'NHIF'),
(28, 'K3326/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:14:40', 'user1', 'NSSF'),
(29, 'K3326/2022', 'net', 'Dec', '2022', '41216.65', '2022-12-05 11:14:40', 'user1', 'NET'),
(30, 'K69226/2022', 'basic', 'Dec', '2022', '75000', '2022-12-05 11:14:40', 'user1', 'Basic salary'),
(31, 'K69226/2022', 'addition', 'Dec', '2022', '20000', '2022-12-05 11:14:40', 'user1', 'House allowance -oficer1'),
(32, 'K69226/2022', 'addition', 'Dec', '2022', '5000', '2022-12-05 11:14:40', 'user1', 'Transport allowance - officer1'),
(33, 'K69226/2022', 'addition', 'Dec', '2022', '3000', '2022-12-05 11:14:40', 'user1', 'Airtime Allowance- officer1'),
(34, 'K69226/2022', 'paye', 'Dec', '2022', '23283.35', '2022-12-05 11:14:40', 'user1', 'PAYE'),
(35, 'K69226/2022', 'nhif', 'Dec', '2022', '1700', '2022-12-05 11:14:40', 'user1', 'NHIF'),
(36, 'K69226/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:14:40', 'user1', 'NSSF'),
(37, 'K69226/2022', 'deductions', 'Dec', '2022', '20000', '2022-12-05 11:14:40', 'user1', 'Pension -officer1'),
(38, 'K69226/2022', 'net', 'Dec', '2022', '77816.65', '2022-12-05 11:14:40', 'user1', 'NET'),
(39, 'K1910/2022', 'paye', 'Dec', '2022', '7383.35', '2022-12-05 11:14:40', 'user1', 'PAYE'),
(40, 'K1910/2022', 'nhif', 'Dec', '2022', '1200', '2022-12-05 11:14:40', 'user1', 'NHIF'),
(41, 'K1910/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:14:40', 'user1', 'NSSF'),
(42, 'K1910/2022', 'net', 'Dec', '2022', '41216.65', '2022-12-05 11:14:40', 'user1', 'NET'),
(43, 'K48664/2022', 'basic', 'Dec', '2022', '75000', '2022-12-05 11:14:40', 'user1', 'Basic salary'),
(44, 'K48664/2022', 'addition', 'Dec', '2022', '20000', '2022-12-05 11:14:40', 'user1', 'House allowance -oficer1'),
(45, 'K48664/2022', 'addition', 'Dec', '2022', '5000', '2022-12-05 11:14:40', 'user1', 'Transport allowance - officer1'),
(46, 'K48664/2022', 'paye', 'Dec', '2022', '22383.35', '2022-12-05 11:14:40', 'user1', 'PAYE'),
(47, 'K48664/2022', 'nhif', 'Dec', '2022', '1700', '2022-12-05 11:14:40', 'user1', 'NHIF'),
(48, 'K48664/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:14:40', 'user1', 'NSSF'),
(49, 'K48664/2022', 'deductions', 'Dec', '2022', '20000', '2022-12-05 11:14:40', 'user1', 'Pension -officer1'),
(50, 'K48664/2022', 'net', 'Dec', '2022', '75716.65', '2022-12-05 11:14:40', 'user1', 'NET'),
(51, 'K73722/2022', 'basic', 'Dec', '2022', '400000', '2022-12-05 11:14:40', 'user1', 'Basic salary'),
(52, 'K73722/2022', 'addition', 'Dec', '2022', '100000', '2022-12-05 11:14:40', 'user1', 'house allaowance-mng'),
(53, 'K73722/2022', 'paye', 'Dec', '2022', '142383.35', '2022-12-05 11:14:40', 'user1', 'PAYE'),
(54, 'K73722/2022', 'nhif', 'Dec', '2022', '1700', '2022-12-05 11:14:40', 'user1', 'NHIF'),
(55, 'K73722/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:14:40', 'user1', 'NSSF'),
(56, 'K73722/2022', 'net', 'Dec', '2022', '355716.65', '2022-12-05 11:14:40', 'user1', 'NET'),
(57, 'K65972/2022', 'basic', 'Dec', '2022', '300000', '2022-12-05 11:14:40', 'user1', 'Basic salary'),
(58, 'K65972/2022', 'addition', 'Dec', '2022', '100000', '2022-12-05 11:14:40', 'user1', 'hod-house allowance'),
(59, 'K65972/2022', 'addition', 'Dec', '2022', '10000', '2022-12-05 11:14:40', 'user1', 'hod-millage allowance'),
(60, 'K65972/2022', 'paye', 'Dec', '2022', '115383.35', '2022-12-05 11:14:40', 'user1', 'PAYE'),
(61, 'K65972/2022', 'nhif', 'Dec', '2022', '1700', '2022-12-05 11:14:40', 'user1', 'NHIF'),
(62, 'K65972/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:14:40', 'user1', 'NSSF'),
(63, 'K65972/2022', 'deductions', 'Dec', '2022', '20000', '2022-12-05 11:14:40', 'user1', 'hod -pension'),
(64, 'K65972/2022', 'deductions', 'Dec', '2022', '50000', '2022-12-05 11:14:40', 'user1', 'ushuru sacco loan '),
(65, 'K65972/2022', 'net', 'Dec', '2022', '292716.65', '2022-12-05 11:14:40', 'user1', 'NET'),
(66, 'K3326/2022', 'paye', 'Dec', '2022', '7383.35', '2022-12-05 11:34:19', 'user1', 'PAYE'),
(67, 'K3326/2022', 'nhif', 'Dec', '2022', '1200', '2022-12-05 11:34:19', 'user1', 'NHIF'),
(68, 'K3326/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:34:19', 'user1', 'NSSF'),
(69, 'K3326/2022', 'net', 'Dec', '2022', '41216.65', '2022-12-05 11:34:19', 'user1', 'NET'),
(70, 'K69226/2022', 'basic', 'Dec', '2022', '75000', '2022-12-05 11:34:19', 'user1', 'Basic salary'),
(71, 'K69226/2022', 'addition', 'Dec', '2022', '20000', '2022-12-05 11:34:19', 'user1', 'House allowance -oficer1'),
(72, 'K69226/2022', 'addition', 'Dec', '2022', '5000', '2022-12-05 11:34:19', 'user1', 'Transport allowance - officer1'),
(73, 'K69226/2022', 'addition', 'Dec', '2022', '3000', '2022-12-05 11:34:19', 'user1', 'Airtime Allowance- officer1'),
(74, 'K69226/2022', 'paye', 'Dec', '2022', '23283.35', '2022-12-05 11:34:19', 'user1', 'PAYE'),
(75, 'K69226/2022', 'nhif', 'Dec', '2022', '1700', '2022-12-05 11:34:19', 'user1', 'NHIF'),
(76, 'K69226/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:34:19', 'user1', 'NSSF'),
(77, 'K69226/2022', 'deductions', 'Dec', '2022', '20000', '2022-12-05 11:34:19', 'user1', 'Pension -officer1'),
(78, 'K69226/2022', 'net', 'Dec', '2022', '77816.65', '2022-12-05 11:34:19', 'user1', 'NET'),
(79, 'K1910/2022', 'paye', 'Dec', '2022', '7383.35', '2022-12-05 11:34:19', 'user1', 'PAYE'),
(80, 'K1910/2022', 'nhif', 'Dec', '2022', '1200', '2022-12-05 11:34:19', 'user1', 'NHIF'),
(81, 'K1910/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:34:19', 'user1', 'NSSF'),
(82, 'K1910/2022', 'net', 'Dec', '2022', '41216.65', '2022-12-05 11:34:19', 'user1', 'NET'),
(83, 'K48664/2022', 'basic', 'Dec', '2022', '75000', '2022-12-05 11:34:19', 'user1', 'Basic salary'),
(84, 'K48664/2022', 'addition', 'Dec', '2022', '20000', '2022-12-05 11:34:19', 'user1', 'House allowance -oficer1'),
(85, 'K48664/2022', 'addition', 'Dec', '2022', '5000', '2022-12-05 11:34:19', 'user1', 'Transport allowance - officer1'),
(86, 'K48664/2022', 'paye', 'Dec', '2022', '22383.35', '2022-12-05 11:34:19', 'user1', 'PAYE'),
(87, 'K48664/2022', 'nhif', 'Dec', '2022', '1700', '2022-12-05 11:34:19', 'user1', 'NHIF'),
(88, 'K48664/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:34:19', 'user1', 'NSSF'),
(89, 'K48664/2022', 'deductions', 'Dec', '2022', '20000', '2022-12-05 11:34:19', 'user1', 'Pension -officer1'),
(90, 'K48664/2022', 'net', 'Dec', '2022', '75716.65', '2022-12-05 11:34:19', 'user1', 'NET'),
(91, 'K73722/2022', 'basic', 'Dec', '2022', '400000', '2022-12-05 11:34:19', 'user1', 'Basic salary'),
(92, 'K73722/2022', 'addition', 'Dec', '2022', '100000', '2022-12-05 11:34:19', 'user1', 'house allaowance-mng'),
(93, 'K73722/2022', 'paye', 'Dec', '2022', '142383.35', '2022-12-05 11:34:19', 'user1', 'PAYE'),
(94, 'K73722/2022', 'nhif', 'Dec', '2022', '1700', '2022-12-05 11:34:19', 'user1', 'NHIF'),
(95, 'K73722/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:34:19', 'user1', 'NSSF'),
(96, 'K73722/2022', 'net', 'Dec', '2022', '355716.65', '2022-12-05 11:34:19', 'user1', 'NET'),
(97, 'K65972/2022', 'basic', 'Dec', '2022', '300000', '2022-12-05 11:34:19', 'user1', 'Basic salary'),
(98, 'K65972/2022', 'addition', 'Dec', '2022', '100000', '2022-12-05 11:34:19', 'user1', 'hod-house allowance'),
(99, 'K65972/2022', 'addition', 'Dec', '2022', '10000', '2022-12-05 11:34:19', 'user1', 'hod-millage allowance'),
(100, 'K65972/2022', 'paye', 'Dec', '2022', '115383.35', '2022-12-05 11:34:19', 'user1', 'PAYE'),
(101, 'K65972/2022', 'nhif', 'Dec', '2022', '1700', '2022-12-05 11:34:19', 'user1', 'NHIF'),
(102, 'K65972/2022', 'nssf', 'Dec', '2022', '200', '2022-12-05 11:34:19', 'user1', 'NSSF'),
(103, 'K65972/2022', 'deductions', 'Dec', '2022', '20000', '2022-12-05 11:34:19', 'user1', 'hod -pension'),
(104, 'K65972/2022', 'deductions', 'Dec', '2022', '50000', '2022-12-05 11:34:19', 'user1', 'ushuru sacco loan '),
(105, 'K65972/2022', 'net', 'Dec', '2022', '292716.65', '2022-12-05 11:34:19', 'user1', 'NET');

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

--
-- Table structure for table `vacances`
--

CREATE TABLE `vacances` (
  `vid` int(11) NOT NULL,
  `jobName` varchar(1000) DEFAULT NULL,
  `position` varchar(1000) DEFAULT NULL,
  `organisation` varchar(1000) DEFAULT NULL,
  `duties` longtext DEFAULT NULL,
  `academic` longtext DEFAULT NULL,
  `skills` longtext DEFAULT NULL,
  `notes` varchar(1000) DEFAULT NULL,
  `expDate` date DEFAULT NULL,
  `creator` varchar(200) DEFAULT NULL,
  `dateCreated` timestamp NULL DEFAULT current_timestamp(),
  `cid` varchar(100) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `intro` longtext DEFAULT NULL,
  `experience` longtext DEFAULT NULL,
  `industry` longtext DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Truncate table before insert `vacances`
--

TRUNCATE TABLE `vacances`;
--
-- Dumping data for table `vacances`
--

INSERT INTO `vacances` (`vid`, `jobName`, `position`, `organisation`, `duties`, `academic`, `skills`, `notes`, `expDate`, `creator`, `dateCreated`, `cid`, `image`, `intro`, `experience`, `industry`, `status`) VALUES
(7, 'Senior software Engineer', 'lead engineer', 'microsoft', '<p>many many many</p>\r\n', '<p>many many many</p>\r\n', '<p>many many many</p>\r\n', 'backend ', '2022-07-08', 'admin', '2022-07-27 00:59:17', '1', NULL, NULL, NULL, NULL, NULL),
(8, 'BUSINESS DEVELOPMENT OFFICER', 'SUPERVISOR', 'MNC', '<ul>\r\n	<li><strong>INDENTIFY BUSINESS GAPS</strong></li>\r\n	<li><strong>RESEARCH AND PROPOSAL WRITTING</strong></li>\r\n</ul>\r\n', '<p>bachelors degree in science</p>\r\n', '<p>computer literarcy</p>\r\n', '', '2022-07-28', 'admin', '2022-07-27 07:15:31', '1', NULL, NULL, NULL, NULL, NULL),
(10, 'BUSINESS DEVELOPMENT OFFICER', 'Supervisors', 'abc limited', '<p><strong>Key roles and responsibilities</strong></p>\r\n\r\n<ul>\r\n	<li>Setting goals and developing plans for business and revenue growth</li>\r\n	<li>Support the firm&rsquo;s marketing department in the creation and execution of the marketing</li>\r\n	<li>strategic plans and step in for the MD when away</li>\r\n	<li>Researching, planning, and implementing new target market initiatives</li>\r\n	<li>Developing quotes and proposals for prospective clients</li>\r\n	<li>Perform other business development and administration duties as instructed</li>\r\n</ul>\r\n\r\n<p>The selected candidate should be able to travel when necessary to meet with clients and/or<br />\r\nstakeholders and build business relationships.</p>\r\n', '<p><strong>Job requirements and qualifications</strong><br />\r\nThe candidates must demonstrate and possess the following skills and qualifications;<br />\r\n AT LEAST a degree or diploma in marketing or business related field<br />\r\n AT LEAST three (3) years of experience<br />\r\n Should be 25-35 years of age<br />\r\n Good administrator<br />\r\n Excellent team leader<br />\r\n Understands market strengths and dynamics<br />\r\n Should have good negotiation and networking skills<br />\r\n Strong interpersonal skills<br />\r\n Proposal writing skills<br />\r\n Must be able to juggle multiple projects at the same time<br />\r\n Excellent critical and analytical skills<br />\r\n Good organizational and time-management skills<br />\r\n Passionate, confident, energetic, and proactive</p>\r\n', '<p>Driving skills.</p>\r\n\r\n<p>computer litracy</p>\r\n\r\n<p>membership of a profesional body is an added advantage</p>\r\n', 'urgent', '2022-08-27', 'admin', '2022-08-08 08:14:44', '1', '/hrm/files/cv/1', '<p>test intro</p>\r\n', '<p>all is needed</p>\r\n', 'tech', NULL),
(11, 'SALES REPRESENTATIVES', 'OFFICER', 'ABC LTD', '<p><br />\r\n Generating leads on new sales.<br />\r\n Meeting or exceeding sales goals.<br />\r\n Negotiating all contracts with prospective clients.<br />\r\n Helping determine pricing schedules for quotes, promotions, and negotiations.<br />\r\n Giving sales presentations to a range of prospective clients.<br />\r\n Performing any other duties and responsibilities deemed necessary.<br />\r\nMake your application by 5:00p.m Sunday, 7th August 2022.</p>\r\n', '<p>The candidate must possess the following set of requirements;<br />\r\n AT LEAST&nbsp;a Diploma in a related field<br />\r\n AT LEAST&nbsp;1 year of experience as a sales representative.<br />\r\n MUST&nbsp;demonstrate good negotiation skills.<br />\r\n Proficient in Computer skills<br />\r\n Proficient in both English and Swahili language (written and spoken).<br />\r\n A quick learner who is self-motivated.<br />\r\n Excellent interpersonal skills.<br />\r\n Has a good ability to multitask.</p>\r\n', '<p>DRIVING SKILLS WILL BE AN ADDED ADVANTAGE</p>\r\n', 'NO VERY AGENT', '2022-08-20', 'admin', '2022-08-08 08:22:53', '1', NULL, NULL, NULL, NULL, NULL),
(12, 'SENIOR SOFTWARE ENGINEER', 'MANGER', 'ABC LTD', '<p>CHIEF DEV</p>\r\n', '<p>BSC COMPUTER SCIENCE</p>\r\n', '<p>N/A</p>\r\n', 'URGENT', '2022-08-19', 'admin', '2022-08-19 14:44:27', '1', NULL, NULL, NULL, NULL, NULL),
(13, 'HUMAN RESOURCE (HR) ASSISTANT', 'OFFICER', 'MNC CONSULTING GROUP - HRM LTD', '<p> Assist with day-to-day operations of the HR functions and duties.<br />\r\n Provide clerical and administrative support to Human Resources executives.<br />\r\n Compile and update employee records (hard and soft copies).<br />\r\n Process documentation and prepare reports relating to personnel activities (staffing,<br />\r\nrecruitment, training, grievances, performance evaluations, etc.).<br />\r\n Coordinate HR projects (meetings, training, surveys, etc.) and take minutes.<br />\r\n Deal with employee requests regarding human resources issues, rules, and regulations.<br />\r\n Assist in payroll preparation by providing relevant data (absences, bonuses, leaves,<br />\r\netc.).<br />\r\n Coordinate communication with candidates and schedule interviews.<br />\r\n Conduct initial orientation to newly hired employees.<br />\r\n Assist our recruiters to source candidates and update our database.<br />\r\n&nbsp;Make your application by 5:00p.m Sunday, 7 th August 2022.</p>\r\n', '<p> AT LEAST&nbsp;two years of experience in a busy human resource department.<br />\r\n AT LEAST a diploma in Human Resource Management.<br />\r\n Proficient in both English and Swahili language (written and spoken).<br />\r\n Excellent interpersonal skills.<br />\r\n A quick learner who is self-motivated with the acumen to follow instructions.<br />\r\n Has a good ability to multitask.<br />\r\n Fast computer typing skills (MS Office, in particular).<br />\r\n Basic knowledge of labor laws.<br />\r\n Excellent organizational skills.<br />\r\n Strong communications skills.</p>\r\n', '<p> AT LEAST&nbsp;two years of experience in a busy human resource department.<br />\r\n AT LEAST a diploma in Human Resource Management.<br />\r\n Proficient in both English and Swahili language (written and spoken).<br />\r\n Excellent interpersonal skills.<br />\r\n A quick learner who is self-motivated with the acumen to follow instructions.<br />\r\n Has a good ability to multitask.<br />\r\n Fast computer typing skills (MS Office, in particular).<br />\r\n Basic knowledge of labor laws.<br />\r\n Excellent organizational skills.<br />\r\n Strong communications skills.</p>\r\n', '10 CANDIDATES', '2022-08-21', 'admin', '2022-08-20 08:10:45', '1', NULL, NULL, NULL, NULL, NULL),
(14, 'BUSINESS DEVELOPMENT MANAGER', 'MANAGER', 'MNC', '<p><a href=\"https://mail.google.com/mail/u/0?ui=2&amp;ik=87616250cf&amp;attid=0.3&amp;permmsgid=msg-f:1740326992306663267&amp;th=1826e22dc9766f63&amp;view=att&amp;disp=safe\"><img alt=\"\" src=\"https://mail.google.com/mail/u/0?ui=2&amp;ik=87616250cf&amp;attid=0.3&amp;permmsgid=msg-f:1740326992306663267&amp;th=1826e22dc9766f63&amp;view=att&amp;disp=safe\" /></a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul>\r\n	<li>Assist with day-to-day operations of the HR functions and duties.</li>\r\n	<li>&nbsp;Provide clerical and administrative support to Human Resources executives.</li>\r\n	<li>&nbsp;Compile and update employee records (hard and soft copies).</li>\r\n	<li>Process documentation and prepare reports relating to personnel activities (staffing,</li>\r\n	<li>recruitment, training, grievances, performance evaluations, etc.).</li>\r\n	<li>&nbsp;Coordinate HR projects (meetings, training, surveys, etc.) and take minutes.</li>\r\n	<li>&nbsp;Deal with employee requests regarding human resources issues, rules, and regulations.</li>\r\n	<li>&nbsp;Assist in payroll preparation by providing relevant data (absences, bonuses, leaves,</li>\r\n	<li>etc.).</li>\r\n	<li>Coordinate communication with candidates and schedule interviews.</li>\r\n	<li>&nbsp;Conduct initial orientation to newly hired employees.</li>\r\n	<li>&nbsp;Assist our recruiters to source candidates and update our database.</li>\r\n	<li>&nbsp;Make your application by 5:00p.m Sunday, 7 th August 2022.</li>\r\n</ul>\r\n', '<p>AT LEAST&nbsp;two years of experience in a busy human resource department.<br />\r\n AT LEAST a diploma in Human Resource Management.<br />\r\n Proficient in both English and Swahili language (written and spoken).<br />\r\n Excellent interpersonal skills.<br />\r\n A quick learner who is self-motivated with the acumen to follow instructions.<br />\r\n Has a good ability to multitask.<br />\r\n Fast computer typing skills (MS Office, in particular).<br />\r\n Basic knowledge of labor laws.<br />\r\n Excellent organizational skills.<br />\r\n Strong communications skills.</p>\r\n', '<p>AT LEAST&nbsp;two years of experience in a busy human resource department.<br />\r\n AT LEAST a diploma in Human Resource Management.<br />\r\n Proficient in both English and Swahili language (written and spoken).<br />\r\n Excellent interpersonal skills.<br />\r\n A quick learner who is self-motivated with the acumen to follow instructions.<br />\r\n Has a good ability to multitask.<br />\r\n Fast computer typing skills (MS Office, in particular).<br />\r\n Basic knowledge of labor laws.<br />\r\n Excellent organizational skills.<br />\r\n Strong communications skills.</p>\r\n', '2 CANDIDATES', '2022-08-22', 'admin', '2022-08-20 09:53:44', '1', NULL, NULL, NULL, NULL, NULL),
(15, 'BUSINESS DEVELOPMENT ENGINEER', 'SUPERVISOR', 'MNC', '<p><img alt=\"\" src=\"http://localhost/hrm/files/cv/2Sales%20Rep-%20MNC%20Consulting%20Group%20Limited.jpeg\" style=\"height:628px; width:1200px\" /></p>\r\n\r\n<p>Setting goals and developing plans for business and revenue growth<br />\r\n Support the firm&rsquo;s marketing department in the creation and execution of the marketing<br />\r\nstrategic plans and step in for the MD when away<br />\r\n Researching, planning, and implementing new target market initiatives<br />\r\n Developing quotes and proposals for prospective clients<br />\r\n Perform other business development and administration duties as instructed<br />\r\nThe selected candidate should be able to travel when necessary to meet with clients and/or<br />\r\nstakeholders and build business relationships.</p>\r\n', '<p> AT LEAST a degree or diploma in marketing or business related field<br />\r\n AT LEAST three (3) years of experience<br />\r\n Should be 25-35 years of age<br />\r\n Good administrator<br />\r\n Excellent team leader<br />\r\n Understands market strengths and dynamics<br />\r\n Should have good negotiation and networking skills<br />\r\n Strong interpersonal skills<br />\r\n Proposal writing skills<br />\r\n Must be able to juggle multiple projects at the same time<br />\r\n Excellent critical and analytical skills<br />\r\n Good organizational and time-management skills<br />\r\n Passionate, confident, energetic, and proactive</p>\r\n', '<p> AT LEAST a degree or diploma in marketing or business related field<br />\r\n AT LEAST three (3) years of experience<br />\r\n Should be 25-35 years of age<br />\r\n Good administrator<br />\r\n Excellent team leader<br />\r\n Understands market strengths and dynamics<br />\r\n Should have good negotiation and networking skills<br />\r\n Strong interpersonal skills<br />\r\n Proposal writing skills<br />\r\n Must be able to juggle multiple projects at the same time<br />\r\n Excellent critical and analytical skills<br />\r\n Good organizational and time-management skills<br />\r\n Passionate, confident, energetic, and proactive</p>\r\n', '4 CANDIDATES', '2022-08-22', 'admin', '2022-08-20 10:17:43', '1', NULL, NULL, NULL, NULL, NULL),
(16, 'THIS IS A TRIAL JOB', 'TEST', 'MNC', '<p><img alt=\"\" src=\"https://mncconsulting.co.ke/wp-content/uploads/2022/07/Front-Office-Manager-and-HR-Assistance-MNC-Consulting-Group-1.png\" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p> AT LEAST a degree or diploma in marketing or business related field<br />\r\n AT LEAST three (3) years of experience<br />\r\n Should be 25-35 years of age<br />\r\n Good administrator<br />\r\n Excellent team leader<br />\r\n Understands market strengths and dynamics<br />\r\n Should have good negotiation and networking skills<br />\r\n Strong interpersonal skills<br />\r\n Proposal writing skills<br />\r\n Must be able to juggle multiple projects at the same time<br />\r\n Excellent critical and analytical skills<br />\r\n Good organizational and time-management skills<br />\r\n Passionate, confident, energetic, and proactive</p>\r\n', '<p> AT LEAST a degree or diploma in marketing or business related field<br />\r\n AT LEAST three (3) years of experience<br />\r\n Should be 25-35 years of age<br />\r\n Good administrator<br />\r\n Excellent team leader<br />\r\n Understands market strengths and dynamics<br />\r\n Should have good negotiation and networking skills<br />\r\n Strong interpersonal skills<br />\r\n Proposal writing skills<br />\r\n Must be able to juggle multiple projects at the same time<br />\r\n Excellent critical and analytical skills<br />\r\n Good organizational and time-management skills<br />\r\n Passionate, confident, energetic, and proactive</p>\r\n', '<p> AT LEAST a degree or diploma in marketing or business related field<br />\r\n AT LEAST three (3) years of experience<br />\r\n Should be 25-35 years of age<br />\r\n Good administrator<br />\r\n Excellent team leader<br />\r\n Understands market strengths and dynamics<br />\r\n Should have good negotiation and networking skills<br />\r\n Strong interpersonal skills<br />\r\n Proposal writing skills<br />\r\n Must be able to juggle multiple projects at the same time<br />\r\n Excellent critical and analytical skills<br />\r\n Good organizational and time-management skills<br />\r\n Passionate, confident, energetic, and proactive</p>\r\n', '1 POST', '2022-08-25', 'admin', '2022-08-20 10:20:55', '1', NULL, NULL, NULL, NULL, NULL),
(17, 'JOB ADVERT 276', 'MANAGER', 'MNC CONSULT', '<p>TEST THE JOB VIEW</p>\r\n', '<p>ALL THAT YOU GOT</p>\r\n', '<p>NOT APPLICABLE</p>\r\n', 'I SLOT', '2022-08-23', 'admin', '2022-08-22 07:45:19', '1', '/hrm/files/cv/1Sales Rep- MNC Consulting Group Limited.jpeg', '<p>THIS IS A JOB INTRODUCTION</p>\r\n', '<p>NO NEEDED FOR NOW</p>\r\n', 'TEST', NULL),
(18, 'SALES REP', 'SUP', 'HRM', '<p>TEST JOB</p>\r\n', '<p>TEST JOB</p>\r\n', '<p>OTHER</p>\r\n', '10', '2022-08-31', 'admin', '2022-08-28 08:25:40', '1', '/hrm/files/cv/1eZamara.jpeg', '<p>TEST JOB</p>\r\n', '<p>TEST JOB</p>\r\n', 'FARMING', NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `vacances`
--
ALTER TABLE `vacances`
  ADD PRIMARY KEY (`vid`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `referrees`
--
ALTER TABLE `referrees`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

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

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

--
-- AUTO_INCREMENT for table `vacances`
--
ALTER TABLE `vacances`
  MODIFY `vid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
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 */;
