-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `piwnrbcd_ehouse_staff_portal`
--

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

--
-- Table structure for table `applicantdocument`
--

CREATE TABLE `applicantdocument` (
  `id` int(11) NOT NULL,
  `documentname` varchar(500) NOT NULL,
  `documenttype` varchar(500) NOT NULL,
  `listingname` varchar(500) NOT NULL,
  `documentstatus` enum('1','0') NOT NULL DEFAULT '1',
  `applicantid` int(11) NOT NULL,
  `courseid` int(11) NOT NULL,
  `message` text NOT NULL,
  `messagedate` datetime NOT NULL DEFAULT current_timestamp(),
  `readstatus` enum('y','n') NOT NULL DEFAULT 'n'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `applicantdocument`
--

INSERT INTO `applicantdocument` (`id`, `documentname`, `documenttype`, `listingname`, `documentstatus`, `applicantid`, `courseid`, `message`, `messagedate`, `readstatus`) VALUES
(1, 'uploads/1590236194Certificate.png', 'Applicantcertificate', '', '1', 3, 35, '', '2020-05-23 14:16:34', 'y'),
(2, 'uploads/1590236233Attendance.png', 'Applicantattendance', '', '1', 3, 35, '', '2020-05-23 14:17:13', 'y'),
(3, 'uploads/159023627118 May.png', 'Applicantpicture', '', '1', 3, 35, 'Pictuere uploaded', '2020-05-23 14:17:51', 'y'),
(4, 'uploads/1590346939ehouse.png', 'Applicantcertificate', '', '1', 1, 1, 'Please check your certificate', '2020-05-24 21:02:19', 'y'),
(5, 'uploads/1590346988Attendance.png', 'Applicantattendance', '', '1', 1, 1, 'Attendance sent', '2020-05-24 21:03:08', 'y'),
(6, 'uploads/1590347070ehouse.png', 'Other', '', '1', 1, 1, 'Reference letter', '2020-05-24 21:04:30', 'y'),
(7, 'uploads/1590347074ehouse.png', 'Other', '', '1', 1, 1, 'Reference letter', '2020-05-24 21:04:35', 'y'),
(8, 'uploads/1590487128accountant.docx', 'Applicantcertificate', '', '1', 1, 3, 'Applicant certificate is being uploaded', '2020-05-26 11:58:48', 'y'),
(9, 'uploads/1590487164accounts_2015_16.xlsx', 'Applicantattendance', '', '1', 1, 3, '', '2020-05-26 11:59:24', 'y'),
(10, 'uploads/159060676127 May.png', 'Applicantcertificate', '', '1', 3, 4, 'Hello', '2020-05-27 21:12:41', 'y'),
(11, 'uploads/159060679327 May.png', 'Applicantattendance', '', '1', 3, 4, 'attendance sent', '2020-05-27 21:13:13', 'y'),
(12, 'uploads/1590606842New Microsoft Office Word Document.docx', 'Other', '', '1', 3, 4, 'other message sent', '2020-05-27 21:14:02', 'y'),
(13, 'uploads/159075044829 May.png', 'Applicantcertificate', '', '1', 5, 6, 'sdfkjasdfkjasd', '2020-05-29 13:07:28', 'y'),
(14, 'uploads/159075046429 May.png', 'Applicantattendance', '', '1', 5, 6, 'asdfklja;sdkf', '2020-05-29 13:07:44', 'y'),
(15, 'uploads/159075048429 May.png', 'Other', '', '1', 5, 6, 'wrwfsdkfas', '2020-05-29 13:08:04', 'y'),
(16, 'uploads/159085962029 May.png', 'Uploaddocuments', '', '1', 5, 6, '', '2020-05-30 19:27:00', 'y'),
(17, 'uploads/1590859645Sequence change.docx', 'Uploaddocuments', '', '1', 5, 6, '', '2020-05-30 19:27:25', 'y'),
(18, 'uploads/1590859669new id.docx', 'Uploaddocuments', '', '1', 5, 6, '', '2020-05-30 19:27:49', 'y'),
(19, 'uploads/1590859701WhatsApp Image 2019-03-14 at 12.57.18 PM(1).jpeg', 'Uploaddocuments', '', '1', 5, 6, '', '2020-05-30 19:28:21', 'y'),
(20, 'uploads/1591026813WhatsApp Image 2019-03-14 at 12.57.18 PM(1).jpeg', 'Achievement', '', '1', 5, 6, 'Another test', '2020-06-01 17:53:33', 'y'),
(21, 'uploads/1591027134WhatsApp Image 2019-03-14 at 12.57.18 PM(1).jpeg', 'Uploaddocuments', '', '1', 5, 6, '', '2020-06-01 17:58:54', 'y'),
(22, 'uploads/1591027536WhatsApp Image 2019-03-14 at 2.25.03 PM.jpeg', 'Uploaddocuments', '', '1', 5, 6, '', '2020-06-01 18:05:36', 'y'),
(23, 'uploads/1591187323WhatsApp Image 2019-03-14 at 12.57.18 PM.jpeg', 'Uploaddocuments', '', '1', 5, 6, '', '2020-06-03 14:28:43', 'y'),
(24, 'uploads/1591275125WhatsApp Image 2019-03-14 at 12.57.17 PM.jpeg', 'Applicantcertificate', '', '1', 6, 7, 'It is certificate', '2020-06-04 14:52:05', 'y'),
(25, 'uploads/1591275151WhatsApp Image 2019-03-14 at 12.57.18 PM(1).jpeg', 'Applicantattendance', '', '1', 6, 7, 'It is attendance', '2020-06-04 14:52:31', 'y'),
(26, 'uploads/1591275205WhatsApp Image 2019-03-14 at 12.57.18 PM.jpeg', 'Achievement', '', '1', 6, 7, 'It is achievement', '2020-06-04 14:53:25', 'y'),
(27, 'uploads/1591275301WhatsApp Image 2019-03-14 at 2.25.03 PM.jpeg', 'Noticeboard', '', '1', 6, 7, 'It is noticeboard', '2020-06-04 14:55:01', 'y'),
(28, 'uploads/1591275536WhatsApp Image 2019-03-14 at 12.57.18 PM(1).jpeg', 'Other', '', '1', 6, 7, 'other message sent', '2020-06-04 14:58:56', 'y'),
(29, 'uploads/1591276365ehouse.png', 'Uploaddocuments', '', '1', 6, 7, '', '2020-06-04 15:12:45', 'n'),
(30, 'uploads/1591276383Courses_dosti.xlsx', 'Uploaddocuments', '', '1', 6, 7, '', '2020-06-04 15:13:03', 'n'),
(31, 'uploads/159127672129 May.png', 'Applicantpicture', '', '1', 6, 7, '', '2020-06-04 15:18:41', 'n'),
(32, 'uploads/159163092129 May.png', 'Achievement', '', '1', 7, 8, 'It is achievement', '2020-06-08 17:42:01', 'y'),
(33, 'uploads/159163126229 May.png', 'Applicantcertificate', '', '1', 7, 8, 'It is certificate', '2020-06-08 17:47:42', 'y'),
(34, 'uploads/1591631376Attendance.png', 'Applicantattendance', '', '1', 7, 8, 'It is attendance', '2020-06-08 17:49:36', 'y'),
(35, 'uploads/159163148729 May.png', 'Noticeboard', '', '1', 7, 8, 'It is notice board message', '2020-06-08 17:51:27', 'y'),
(36, 'uploads/159163157129 May.png', 'Other', '', '1', 7, 8, 'It is another noticeboard message', '2020-06-08 17:52:51', 'y'),
(37, 'uploads/1591631765Services.docx', 'Uploaddocuments', '', '1', 7, 8, '', '2020-06-08 17:56:05', 'y'),
(38, 'uploads/1591631812Services.pdf', 'Uploaddocuments', '', '1', 7, 8, '', '2020-06-08 17:56:52', 'y'),
(39, 'uploads/1591631979Countdown marker.png', 'Uploaddocuments', '', '1', 7, 8, '', '2020-06-08 17:59:39', 'y'),
(40, 'uploads/29 May.png', 'Applicantpicture', '', '1', 8, 9, '', '2020-06-10 17:13:55', 'y'),
(41, 'uploads/accountant.docx', 'Uploaddocuments', '', '1', 8, 9, '', '2020-06-10 17:24:21', 'y'),
(42, 'uploads/Current students.xlsx', 'Uploaddocuments', '', '1', 8, 9, '', '2020-06-10 17:25:07', 'y'),
(43, 'uploads/Attendance.png', 'Applicantattendance', '', '1', 8, 9, '10 June : It is attendance', '2020-06-10 17:42:20', 'y'),
(44, 'uploads/1601302606Pen.docx', 'Uploaddocuments', 'test document', '1', 23, 25, '', '2020-09-28 16:16:46', 'n'),
(45, 'uploads/1601463257accountant.docx', 'Uploaddocuments', 'test document', '1', 26, 32, '', '2020-09-30 12:54:17', 'y'),
(46, 'uploads/1606144325IMG-20201123-WA0039 copy.jpg', 'Applicantpicture', 'Haider Mushtaq', '1', 29, 32, '', '2020-11-23 16:06:03', 'y'),
(47, 'uploads/1606150716Haider Mushtaq CV.docx', 'Uploaddocuments', 'CV', '1', 29, 32, '', '2020-11-23 17:58:36', 'y'),
(49, 'uploads/1606217799Haider Mushtaq CV.pdf', 'Uploaddocuments', 'CV', '1', 29, 32, '', '2020-11-24 12:36:39', 'y'),
(50, 'uploads/1606217839IELTS Certificate of Haider.pdf', 'Uploaddocuments', 'IELTS Certificate', '1', 29, 32, '', '2020-11-24 12:37:19', 'y'),
(51, 'uploads/1606217878Diploma.pdf', 'Uploaddocuments', 'D.A.E certificate', '1', 29, 32, '', '2020-11-24 12:37:58', 'y'),
(52, 'uploads/1606217973Diploma back side.pdf', 'Uploaddocuments', 'D.A.E certificate backside', '1', 29, 32, '', '2020-11-24 12:39:33', 'y'),
(53, 'uploads/1606218010Matric certificate.pdf', 'Uploaddocuments', 'Matric certificate', '1', 29, 32, '', '2020-11-24 12:40:10', 'y'),
(54, 'uploads/1606218069Matric certificate back side.pdf', 'Uploaddocuments', 'Matric certificate backside', '1', 29, 32, '', '2020-11-24 12:41:09', 'y'),
(55, 'uploads/1606218116Diploma marksheet first year.pdf', 'Uploaddocuments', 'D.A.E marksheet first year', '1', 29, 32, '', '2020-11-24 12:41:56', 'y'),
(56, 'uploads/1606218181Diploma marksheet second year.pdf', 'Uploaddocuments', 'D.A.E marksheet second year', '1', 29, 32, '', '2020-11-24 12:43:01', 'y'),
(57, 'uploads/1606218218Diploma marksheet third year.pdf', 'Uploaddocuments', 'D.A.E marksheet third year', '1', 29, 32, '', '2020-11-24 12:43:38', 'y'),
(58, 'uploads/1606218252CNIC front.pdf', 'Uploaddocuments', 'CNIC Front side', '1', 29, 32, '', '2020-11-24 12:44:12', 'y'),
(59, 'uploads/1606218280CNIC backside.pdf', 'Uploaddocuments', 'CNIC Backside', '1', 29, 32, '', '2020-11-24 12:44:40', 'y'),
(60, 'uploads/1606218310Passport.pdf', 'Uploaddocuments', 'Passport', '1', 29, 32, '', '2020-11-24 12:45:10', 'y'),
(61, 'uploads/1606218332AutoCAD.pdf', 'Uploaddocuments', 'AutoCAD', '1', 29, 32, '', '2020-11-24 12:45:32', 'y'),
(62, 'uploads/1606323955Doc13.pdf', 'Uploaddocuments', 'Enoch Ohenebeng ', '1', 31, 34, '', '2020-11-25 18:05:55', 'y'),
(63, 'uploads/1606324027Doc14.pdf', 'Uploaddocuments', 'passport picture', '1', 31, 34, '', '2020-11-25 18:07:07', 'y'),
(64, 'uploads/1606324076Doc15.pdf', 'Uploaddocuments', 'Registration Assess Form', '1', 31, 34, '', '2020-11-25 18:07:56', 'y'),
(65, 'uploads/1606324146Doc16.pdf', 'Uploaddocuments', 'Registration Assessment Form', '1', 31, 34, '', '2020-11-25 18:09:06', 'y'),
(66, 'uploads/1606324388Doc17.pdf', 'Uploaddocuments', 'Birth Certificate', '1', 31, 34, '', '2020-11-25 18:13:08', 'y'),
(67, 'uploads/1606324437Doc18.pdf', 'Uploaddocuments', 'Senior High Certificate', '1', 31, 34, '', '2020-11-25 18:13:57', 'y'),
(68, 'uploads/1606324477Doc19.pdf', 'Uploaddocuments', 'Curriculum vitae ', '1', 31, 34, '', '2020-11-25 18:14:37', 'y'),
(69, 'uploads/1606324513Doc20.pdf', 'Uploaddocuments', 'Curriculum vitae', '1', 31, 34, '', '2020-11-25 18:15:14', 'y'),
(70, 'uploads/1606324578Doc21.pdf', 'Uploaddocuments', 'Testimonial', '1', 31, 34, '', '2020-11-25 18:16:18', 'y'),
(71, 'uploads/1606581687CCI_000669-compressed.pdf', 'Uploaddocuments', 'Registration assessment form', '1', 29, 32, '', '2020-11-28 17:41:27', 'y'),
(72, 'uploads/0001_HM.pdf', 'Other', '', '1', 29, 32, 'Conditional Offer letter', '2021-01-13 07:44:48', 'y'),
(73, 'uploads/Conditional Offer Letter.pdf', 'Noticeboard', '', '1', 31, 34, 'Conditional Offer Letter', '2021-01-13 11:38:30', 'n'),
(74, 'uploads/1610627455fee slip', 'Uploaddocuments', 'Fee submission remittance slip', '1', 29, 32, '', '2021-01-14 13:30:55', 'y'),
(75, 'uploads/WhatsApp Image 2021-03-14 at 1.20.22 PM.jpeg', 'Applicantpicture', '', '1', 25, 31, 'dd', '2021-03-16 19:27:50', 'n'),
(76, 'uploads/y.jpeg', 'Noticeboard', '', '1', 25, 31, 'afdafd', '2021-03-16 19:28:38', 'n'),
(77, 'uploads/1615921804WhatsApp Image 2021-03-10 at 10.53.24 PM.jpeg', 'Applicantpicture', 'dd', '1', 63, 83, '', '2021-03-16 19:51:56', 'n'),
(78, 'uploads/1615920770y.jpeg', 'Uploaddocuments', 'marksheet', '1', 63, 83, '', '2021-03-16 19:52:50', 'n'),
(79, 'uploads/1615921267y.jpeg', 'Uploaddocuments', 'Test', '1', 63, 83, '', '2021-03-16 20:01:07', 'n'),
(80, 'uploads/1615974568Eric Boakye.jpeg', 'Applicantpicture', 'Testimonial', '1', 61, 81, '', '2021-03-16 20:01:56', 'y'),
(81, 'uploads/1615922073wassce results.pdf', 'Uploaddocuments', 'School Certificate', '1', 61, 81, '', '2021-03-16 20:14:33', 'y'),
(82, 'uploads/16159223010019-PCS-EB.pdf', 'Uploaddocuments', 'Offer document', '1', 61, 81, '', '2021-03-16 20:18:21', 'y'),
(83, 'uploads/1616150107passport picture.jpg', 'Applicantpicture', 'passport picture', '1', 59, 79, '', '2021-03-19 11:35:07', 'y'),
(84, 'uploads/1616150957SodaPDF-merged-Merging_Result-1[1].pdf', 'Uploaddocuments', 'passport', '1', 59, 79, '', '2021-03-19 11:49:17', 'y'),
(85, 'uploads/1616151039SodaPDF-merged-Merging_Result-2[1].pdf', 'Uploaddocuments', 'registration assessment form', '1', 59, 79, '', '2021-03-19 11:50:39', 'y'),
(86, 'uploads/1616151095SodaPDF-merged-Merging_Result-3[1].pdf', 'Uploaddocuments', 'advert', '1', 59, 79, '', '2021-03-19 11:51:35', 'y'),
(87, 'uploads/1616151155SodaPDF-merged-Merging_Result-4[1].pdf', 'Uploaddocuments', 'birth certificate ', '1', 59, 79, '', '2021-03-19 11:52:35', 'y'),
(88, 'uploads/1616151216SodaPDF-merged-Merging_Result-5[1].pdf', 'Uploaddocuments', 'High school certificate ', '1', 59, 79, '', '2021-03-19 11:53:36', 'y'),
(89, 'uploads/1616151250SodaPDF-merged-Merging_Result-6[1].pdf', 'Uploaddocuments', 'curriculum vitae', '1', 59, 79, '', '2021-03-19 11:54:10', 'y'),
(90, 'uploads/1616151284SodaPDF-merged-Merging_Result-7[1].pdf', 'Uploaddocuments', 'testimonial', '1', 59, 79, '', '2021-03-19 11:54:44', 'y'),
(91, 'uploads/1616151331SodaPDF-merged-Merging_Result-8[1].pdf', 'Uploaddocuments', 'acceptance letter', '1', 59, 79, '', '2021-03-19 11:55:31', 'y'),
(92, 'uploads/1616159586cv.pdf', 'Uploaddocuments', 'Cv', '1', 61, 81, '', '2021-03-19 14:13:06', 'y'),
(93, 'uploads/1616159621passport.pdf', 'Uploaddocuments', 'passport', '1', 61, 81, '', '2021-03-19 14:13:41', 'y'),
(94, 'uploads/1616159693Online results.pdf', 'Uploaddocuments', 'online results', '1', 61, 81, '', '2021-03-19 14:14:53', 'y'),
(95, 'uploads/1616159735Results.pdf', 'Uploaddocuments', 'results', '1', 61, 81, '', '2021-03-19 14:15:35', 'y'),
(96, 'uploads/1616159763School Testimonial.pdf', 'Uploaddocuments', 'school testimonial', '1', 61, 81, '', '2021-03-19 14:16:03', 'y'),
(97, 'uploads/1616264318job offer letter.pdf', 'Uploaddocuments', 'Job Offer Letter', '1', 61, 81, '', '2021-03-20 19:18:38', 'y'),
(98, 'uploads/1619439773certificate_17.jpg', 'Uploaddocuments', 'BSC Degree/Certificate', '1', 66, 86, '', '2021-04-26 14:22:53', 'y'),
(99, 'uploads/1619439806certificate_2.jpg', 'Uploaddocuments', 'DAE/Inter Certificate', '1', 66, 86, '', '2021-04-26 14:23:26', 'y'),
(100, 'uploads/1619439822certificate_5.jpg', 'Uploaddocuments', 'Matriculation', '1', 66, 86, '', '2021-04-26 14:23:42', 'y'),
(101, 'uploads/1619439839New Doc 2019-08-01 19.02.42_1.jpg', 'Uploaddocuments', 'PEC Register Certificate', '1', 66, 86, '', '2021-04-26 14:23:59', 'y'),
(102, 'uploads/1619439857New Doc 2019-06-18 13.47.48_1.jpg', 'Uploaddocuments', 'NIC Front Side', '1', 66, 86, '', '2021-04-26 14:24:17', 'y'),
(103, 'uploads/1619439870New Doc 2019-06-18 13.47.48_2.jpg', 'Uploaddocuments', 'NIC Back Side', '1', 66, 86, '', '2021-04-26 14:24:30', 'y'),
(104, 'uploads/1619440199Picture.jpg', 'Applicantpicture', 'Picture', '1', 66, 86, '', '2021-04-26 14:28:28', 'y'),
(105, 'uploads/1619774968Passport.jpg', 'Uploaddocuments', 'Passport', '1', 66, 86, '', '2021-04-30 11:29:28', 'n'),
(106, 'uploads/1643624803CV-Gubran Alamrani 2021 (1).pdf', 'Uploaddocuments', 'My C.V', '1', 79, 99, '', '2022-01-31 11:26:43', 'y'),
(107, 'uploads/1643624832CV-Gubran Alamrani 2021 (1).pdf', 'Uploaddocuments', 'My C.V', '1', 79, 99, '', '2022-01-31 11:27:12', 'y'),
(108, 'uploads/1643625000bank payment.png', 'Uploaddocuments', 'bank payment', '1', 79, 99, '', '2022-01-31 11:30:00', 'y'),
(109, 'uploads/1643625727my passport.pdf', 'Uploaddocuments', 'My Passport', '1', 79, 99, '', '2022-01-31 11:42:07', 'y'),
(110, 'uploads/1643626446Bank transfer.pdf', 'Uploaddocuments', 'Bank transfer', '1', 77, 97, '', '2022-01-31 11:54:06', 'y'),
(111, 'uploads/1643626672my passport.pdf', 'Uploaddocuments', 'My Passport', '1', 77, 97, '', '2022-01-31 11:57:52', 'y'),
(112, 'uploads/1644775906Scan.pdf', 'Uploaddocuments', 'JUMA JOHN DENG -CV', '1', 82, 102, '', '2022-02-13 19:11:46', 'y'),
(113, 'uploads/1644776016Scan.pdf', 'Uploaddocuments', 'Passport', '1', 82, 102, '', '2022-02-13 19:13:36', 'y'),
(114, 'uploads/1644776361IMG-20220213-WA0063.jpg', 'Applicantpicture', 'photo', '1', 82, 102, '', '2022-02-13 19:15:40', 'y');

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

--
-- Table structure for table `booking_table`
--

CREATE TABLE `booking_table` (
  `id` int(11) NOT NULL,
  `training` varchar(150) NOT NULL,
  `month` varchar(250) NOT NULL,
  `training_dates` date NOT NULL,
  `city` varchar(250) NOT NULL,
  `address` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `booking_table`
--

INSERT INTO `booking_table` (`id`, `training`, `month`, `training_dates`, `city`, `address`) VALUES
(7, 'Door supervisor training', 'January', '2019-03-01', 'Leeds', 'test  ');

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

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

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

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

--
-- Table structure for table `coursedetails`
--

CREATE TABLE `coursedetails` (
  `booking_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `courseid` varchar(50) NOT NULL,
  `course` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `paricipnts` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `trainingdundedby` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `dob` timestamp NULL DEFAULT NULL,
  `contactnumber` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `workplace` varchar(255) NOT NULL,
  `jobtitle` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `mobilenumber` varchar(255) NOT NULL,
  `kinfirstname` varchar(255) NOT NULL,
  `kinlastname` varchar(255) NOT NULL,
  `relationship` varchar(300) NOT NULL,
  `kinaddress` varchar(255) NOT NULL,
  `kintelephone` varchar(255) NOT NULL,
  `kinmobile` varchar(255) NOT NULL,
  `kinemail` varchar(255) NOT NULL,
  `hearaboutus` text NOT NULL,
  `message` text NOT NULL,
  `payment_method` varchar(255) NOT NULL,
  `tandc` enum('y','n') NOT NULL,
  `notification` enum('y','n') NOT NULL,
  `imagetype` varchar(500) NOT NULL,
  `image` varchar(285) NOT NULL,
  `status` enum('archived','enrolled','registered') NOT NULL,
  `paymentreceipt` varchar(500) NOT NULL,
  `userid` int(11) NOT NULL,
  `hereabout` varchar(500) NOT NULL,
  `other_text` text NOT NULL,
  `form_status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `coursedetails`
--

INSERT INTO `coursedetails` (`booking_id`, `course_id`, `courseid`, `course`, `date`, `paricipnts`, `country`, `trainingdundedby`, `firstname`, `lastname`, `dob`, `contactnumber`, `email`, `workplace`, `jobtitle`, `city`, `mobilenumber`, `kinfirstname`, `kinlastname`, `relationship`, `kinaddress`, `kintelephone`, `kinmobile`, `kinemail`, `hearaboutus`, `message`, `payment_method`, `tandc`, `notification`, `imagetype`, `image`, `status`, `paymentreceipt`, `userid`, `hereabout`, `other_text`, `form_status`) VALUES
(32, 5, '', 'Principles of team leading', '2021-04-20', '0', 'Pakistan', 'Him/herself', 'Haider', 'Mushtaq', NULL, '00923405145202', 'haiderkhanzada12@gmail.com', '', '', 'Rawalakot Azad Kashmir', '00923405145202', 'Majid', 'Nawaz', 'Cousin', '49 wooler avenue ls11 7JE', '', '00447466282825', 'Khan.majj@gmail.com', '', '', '', 'y', 'y', '', '', 'archived', ' ', 29, 'Other', '', 0),
(81, 7, '', 'Customer service', '2021-03-16', '', 'Ghana', 'Organization', 'Eric', 'Boakye', '1994-08-27 22:00:00', '233244671903', 'erikwoode20@gmail.com', 'Newgener Hardware', 'Newgener hardware', 'Accra', '+233244671903', 'Isaac', 'Boakye', 'Brother', '60 Winrose Drive,Leeds LS10 3AD', '447868179560', '447868179560', 'Ikeb69@gmail.com', '', '', '', 'y', 'y', '', '', 'archived', '', 61, 'Agent or consultant', '', 0),
(95, 5, '', 'Principles of team leading', '2021-10-17', '', 'United Arab Erimates', 'Training funded by', 'saima', 'ghazal', '1986-05-09 22:00:00', '00971561310753', 'sam.saimoo4@gmail.com', 'Union Insurance Company', 'Insurance Specialist', 'Dubai', '00971561310753', 'Hasnain', 'Sajjad', 'Spouse', 'Apartment 617 Elite 8 sports city dubai', '00971504264501', '00971504264501', 'hasnain386@gmail.com', '', '', '', 'y', 'y', '', '', 'archived', '', 75, 'Other', '', 0),
(97, 6, '', 'Principles of business administration', '2022-01-23', '', 'Saudi Arabia', 'Self', 'OSAMAH', 'HASHEM', '1978-10-21 23:00:00', '00966536668893', 'osama.alhasham@hotmail.com', 'Al Othaim Holding Company', 'Marketing Specialist', 'Riyadh ', '00966536668893', 'OMAR', 'ISMAIEL', 'Friend', 'Riyadh ', '00966503065019', '00966503065019', 'omar7742@hotmail.com', '', '', '', 'y', 'y', '', '', 'archived', '', 77, 'Other', '', 0),
(98, 6, '', 'Principles of business administration', '2022-01-27', '', 'Saudi Arabia', 'Self', 'ZUHDI', 'BABIKIR', '1978-04-21 23:00:00', '966599207054', 'zuhdyabdo2@gmail.com', '', 'Computer technician', 'RIYADH', '+966599207054', 'ZUHDI', 'BABIKIR', 'me', 'SAUDIB ARAIA - RIYADH', '0599207054', '966599207054', 'zuhdyabdo2@gmail.com', '', '', '', 'y', 'y', '', '', 'enrolled', '', 78, 'Other', '', 0),
(99, 6, '', 'Principles of business administration', '2022-01-28', '', 'Turkey', 'Self', 'GUBRAN', 'ALAMRANI', '1988-04-09 22:00:00', '00905528411988', 'alamrani.gubran@gmail.com', 'Ministry of Planning and International Cooperation.', 'Currently, Director General of Cabinet Affairs at the Ministry of Planning and International Cooperation.', 'Istanbul', '00905528411988', 'OSAMAH', 'HASHEM', 'Friend', 'Riyadh', '00966536668893', '00966536668893', 'osama.alhasham@hotmail.com', '', '', '', 'y', 'y', '', '', 'archived', '', 79, 'Other', '', 1),
(101, 6, '', 'Principles of business administration', '2022-02-08', '', 'Kenya', 'Self', 'Mourine', 'Karimi', '1996-02-05 23:00:00', '0706681947', 'mourineckarimi@gmail.com', 'Self employment', 'Self employed', 'Kianyaga', '254706681947', 'Charles', 'Muriithi', 'Husband', '178 Kianyaga', '254712621390', '254712621390', 'charlesmuriithi@gmail.com', '', '', '', 'y', 'y', '', '', 'enrolled', '', 81, 'Facebook', '', 0),
(102, 6, '', 'Principles of business administration', '2022-02-13', '', 'Kenya', 'Self', 'JUMA  JOHN ', 'DENG', '0000-00-00 00:00:00', '00211912300791', 'mminnovationservices@gmail.com', 'DAR PETROLUM OPERTATING COMPANY/ HUMAN RESOURCES INSTITUTE,NAIROBI,KENYA', 'SENIOR MANPOWER PLANNING AND RECURITMENT', 'JUBA, REBUBLIC OF SOUTHSUDAN', '+211912300791', 'ADUT MAKOI AGUENG', 'BOT', 'WIFE', 'CHESTNUT APARTMENT, KILIMANI, NAIROBI, KENYA.', '00254791776130', '00254791776130', 'adutmakoiagueng@gmail.com', '', '', '', 'y', 'y', '', '', 'enrolled', '', 82, 'Agent or consultant', '', 0),
(107, 6, '', 'Principles of business administration', '2022-02-27', '', 'Kenya', 'Company', 'Ecojen Holdings ', 'LTD', '2015-02-10 23:00:00', '0714778163', 'abokaloyce@gmail.com', 'Aloyce Juma Abok', 'General Manager', 'Kisumu', 'KE', 'Aloyce Juma', 'Abok', 'Brother', '+254714778163', '254714778163', '254714778163', 'abokaloyce@gmail.com', '', '', '', 'y', 'y', '', '', 'enrolled', '', 87, 'Facebook', '', 0),
(108, 6, '', 'Principles of business administration', '2022-03-27', '', 'Sudan', 'Others', 'Elham Ahmed Kubr', 'Adam', '1989-07-14 22:00:00', '0923231996', 'homeahmed48@gmail.com', 'compass international for development ltd', 'Secretary', 'Omdurman ', '+249923231996', 'Iman', 'Adam', 'Sister', '1 Wellesley Gardens B13 9YY', '07846557444', '07846557444', 'midotota88@hotmail.com', '', '', '', 'y', 'y', '', '', 'enrolled', '', 88, 'Other', '', 0),
(109, 6, '', 'principles of business administration', '2022-03-27', '', 'Sudan', 'Company', 'MOHAMED', 'IBRAHIM', '2022-03-26 23:00:00', '096988810', 'mohamedkosti34@gmail.com', 'Raza Nur', 'Sales Representative', 'Khartoum ', '+249969888105', 'KHALID', 'ABDALLAH ', 'FRIEND', 'Khartoum ', '602432', '999809678', 'seeda82011@gmail.com', '', '', '', 'y', 'y', '', '', 'enrolled', '', 89, 'Google', '', 0),
(113, 6, '', 'Principles of business administration', '2022-03-28', '', 'Sudan', 'Company', 'MOHAMED', 'ALI', '2022-03-27 22:00:00', '0969888105', 'mohamedkoti34@gmail.com', 'Raza Nur', 'Sales Representative', 'Khartom', '+249969888105', 'IBRAHIEM', 'ALI', 'brother ', 'South sudan', '+211929543503', '+211929543503', 'ahsnabrahym477@gmail.com', '', '', '', 'y', 'y', '', '', 'enrolled', '', 93, 'Agent or consultant', '', 0),
(114, 1998, '', 'Principles of Team Leading', '2023-04-08', '', 'Pakistan', 'Self', 'Tom', 'Jerry', '0000-00-00 00:00:00', '+923043515100', 'entertain@gg.com', '', 'PHP Developer', 'Purcellville', '', '', '', '', '', '', '', '', '', '', 'Bank Transfer', 'y', 'y', '', '', 'enrolled', 'Full Fee - &pound; 3,500.00', 23, '', '', 0),
(115, 1998, '', 'Principles of Team Leading', '2023-04-08', '', 'Afghanistan', '', 'Mahboob', 'Ahmad', '0000-00-00 00:00:00', '+447455222161', 'info@ehouse.co.uk', 'Sample', 'Sample', 'Sample', '+447455555555', 'Sample', 'Sample', 'Sample', 'Sample', '+447455222161', '+447455555555', 'admin@ehouse.co.uk', '', '', 'Bank Transfer', 'y', 'y', '', '', 'enrolled', 'Full Fee - &pound; 3,500.00', 24, '', '', 0);

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

--
-- Table structure for table `courses`
--

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

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

--
-- Table structure for table `ehouse_forms`
--

CREATE TABLE `ehouse_forms` (
  `id` int(11) NOT NULL,
  `form_name` varchar(100) NOT NULL,
  `form_id` varchar(50) NOT NULL,
  `full_name` varchar(20) NOT NULL,
  `date_of_birth` varchar(10) NOT NULL,
  `email_id` varchar(50) NOT NULL,
  `your_mobile` varchar(15) NOT NULL,
  `your_phone` varchar(15) NOT NULL,
  `home_address` varchar(200) NOT NULL,
  `apply_for` varchar(100) NOT NULL,
  `current_job` varchar(200) NOT NULL,
  `how_hear` varchar(50) NOT NULL,
  `apply_date` varchar(20) NOT NULL,
  `qualification_type` varchar(100) NOT NULL,
  `qualification_name` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ehouse_forms`
--

INSERT INTO `ehouse_forms` (`id`, `form_name`, `form_id`, `full_name`, `date_of_birth`, `email_id`, `your_mobile`, `your_phone`, `home_address`, `apply_for`, `current_job`, `how_hear`, `apply_date`, `qualification_type`, `qualification_name`, `status`) VALUES
(21, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Tariq Mahmood', '1985-12-15', 'tm9895454@gmail.com', '07920423140', '', '14 Torre  Crescent', 'N / A', 'Unemployed', 'Friend referral', '2021-07-21', 'Under 10 years qualification', 'Matriculation', 'registered'),
(22, 'B1 TEST REGISTRATION FORM', '3', 'Faiza Ahmad', '1987-02-15', 'aimalkhan333@yahoo.com', '07448689345', '', '44 Rosewll road Leeds', 'ILR ( Indefinite Leave to Remain)', 'House wife', 'X-Student', '2021-07-21', 'Under 10 years qualification', 'Matriculation', 'archived'),
(23, 'Life in The UK Test', '2', 'Sudayday Udoye', '1978-10-29', 'sudoye@yahoo.com', '07765652208', '', 'Gipton gate LS9 6SU', 'Citizenship', 'N/A', 'Friend referral', '2021-07-21', 'Under 5 years qualification', 'Not sure', 'archived'),
(24, 'B1 TEST REGISTRATION FORM', '3', 'Nazia Hamraz', '1990-02-22', 'hamraz.shah@yahoo.com', '07967860786', '', '15 Copgrove Road Leeds LS8 2SP', 'ILR ( Indefinite Leave to Remain)', 'House wife', 'X-Student', '2021-07-21', 'Under 10 years qualification', 'Matriculation', 'archived'),
(25, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Concilie B Nankunda', '1963-09-04', 'cilie02@yahoo.co.uk', '07940993344', '', '21 Carlton rise  Leeds LS7 1HH', 'Citizenship', 'Unemployed', 'Google', '2021-07-21', 'Under 5 years qualification', 'Not sure', 'archived'),
(29, 'Life in The UK Test', '2', 'Khalid Farah', '1977-09-23', 'info@ehouse.org.uk', '07480618054', '', '27 Avirday mount LS12 2NX', 'ILR ( Indefinite Leave to Remain)', 'Wharehouse', 'Google', '2021-07-23 17:08:12', 'Under 15 years qualification', 'Computing ', 'registered'),
(38, 'A2 Test', '4', 'Maria Yaseen', '1996-12-14', 'mahmoodsaqib20@yahoo.com', '07988184034', '', '7 LS8 3JG', 'Spouse visa extension', 'House wife', 'Friend referral', '2021-07-26 16:33:49', 'Under 10 years qualification', 'Middle', 'archived'),
(39, 'B1 TEST REGISTRATION FORM', '3', 'Mena Khan', '1990-11-12', 'khanomid283@yahoo.com', '07456508108', '', '60 Esther Avenue WF2 8BX', 'ILR ( Indefinite Leave to Remain)', 'House wife', 'X-Student', '2021-07-26 16:38:22', 'Under 10 years qualification', '7th Class', 'archived'),
(40, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Kasim S Anwar', '1995-06-23', 'kasimanwar33@gmail.com', '07762955895', '', '54 Coldcourse avenue LS9 6NB', 'N / A', 'Job', 'Friend referral', '2021-07-29 15:49:44', 'Under 12 years qualification\r\n																', 'NVQ Entry 3', 'registered'),
(42, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Mohammed Akter Hussa', '1982-10-10', 'hussainakter969@gmail.com', '07858181691', '', '62 Bankside street LS8 5DZ', 'N / A', 'Unemployed', 'Friend referral', '2021-08-02 13:56:34', 'Under 10 years qualification', 'Matriculation', 'registered'),
(45, 'A2 Test', '4', 'Fatima Imtiaz', '1982-08-02', 'mohd.nawaz@hotmail.co.uk', '07498624606', '', '32 Fearnville grove LS8 3DS', 'N / A', 'Housewife', 'Friend referral', '2021-08-03 19:26:59', 'Under 15 years qualification', 'MA History', 'archived'),
(52, 'Life in The UK Test', '2', 'Ghlam Ali', '1962-08-09', 'echresh45@gmail.com', '07476697814', '', '2 Cross green lane', 'Citizenship', 'Butcher', 'Friend referral', '2021-08-20 19:03:53', 'Under 5 years qualification', 'Under 8', 'registered'),
(58, 'A2 Test', '4', 'Syeda Tarika Begum', '1998-10-16', 'dummy@gmail.com', '07387009186', '', 'Dummy', 'Spouse visa extension', 'Housewife', 'Flyer (Mosque)', '2021-08-25 12:57:03', 'Under 10 years qualification', 'Middle', 'archived'),
(79, 'Life in The UK Test', '2', 'Rabia Akhtar', '1997-04-01', 'rabia411977@gmail.com', '07848799461', '', 'N/A', 'Citizenship', 'Housewife', 'Friend referral', '2021-09-06 11:46:49', 'Under 5 years qualification', 'Matric', 'archived'),
(80, 'Life in The UK Test', '2', 'Tauseef Asghar Khan', '1990-04-06', 'tauseef1973@gmail.com', '07860608441', '', 'N/A', 'Citizenship', 'Factory work', 'Friend referral', '2021-09-06 11:54:18', 'Under 5 years qualification', 'Matric', 'archived'),
(81, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Yasir Sarfraz', '1978-01-10', 'Yasirsarfraz870@yahoo.com', '077322586', '', '4 darfeild grove leeds', 'Citizenship', 'Cheif', 'X-Student', '2021-09-06 12:00:08', 'Under 5 years qualification', 'Matric', 'registered'),
(82, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Alisha Javed', '1997-02-23', 'alishahussainx786@gmail.com', '07927052908', '', '44 savile road LS7 3ER', 'Citizenship', 'Housewife', 'Friend referral', '2021-09-06 12:04:57', 'Under 10 years qualification', 'F.A', 'archived'),
(83, 'A2 Test', '4', 'Harjinder kaur', '1990-06-09', 'abc123@gmail.com', '07308485854', '', '29raincliffe street LS99 LW', 'Citizenship', 'barbar', 'X-Student', '2021-09-07 16:46:46', 'Under 5 years qualification', 'Matric', 'archived'),
(84, 'B1 TEST REGISTRATION FORM', '3', 'Helon Begum', '1980-12-02', 'Helonbegum123@gmail.com', '07708315204', '', '60 hilltop mount LS84 EW', 'Citizenship', 'Housewife', 'Others', '2021-09-08 11:26:56', 'Under 5 years qualification', 'N/P', 'registered'),
(85, 'Life in The UK Test', '2', 'Mena khan', '1990-12-11', 'khanomid283@yahoo.com', '07456508108', '', '60 estner avenue wakefield west yorkshire WF28  BX', 'Citizenship', 'Housewife', 'X-Student', '2021-09-08 11:51:11', 'Under 5 years qualification', 'N/P', 'archived'),
(86, 'Life in The UK Test', '2', 'Mohammad Shoaib', '1987-02-22', 'mohammadshoaib2314@gmail.com', '07588616561', '', '16 seaforth place leeds ls96af', 'Citizenship', 'Restaurant', 'Friend referral', '2021-09-08 12:11:50', 'Under 5 years qualification', 'N/A', 'archived'),
(87, 'B1 TEST REGISTRATION FORM', '3', 'Mohammad Shoukat', '1975-10-22', 'shoki2210@gmail.com', '07366561767', '', '69 Karnae road LS5 JS', 'Citizenship', 'Restaurant', 'Shop banner', '2021-09-08 12:28:35', 'Under 5 years qualification', 'N/A', 'archived'),
(88, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Samia Kazimi', '1988-01-04', 'samiakazimi1@hotmail.com', '07845817281', '', '31 torre gardens leeds ', 'Citizenship', 'Housewife', 'Friend referral', '2021-09-13 14:03:49', 'Under 5 years qualification', 'Matric', 'registered'),
(89, 'A2 Test', '4', 'Mahtab ghodrani nasr', '1984-09-22', 'mahtabghodrati1771@yahoo.com', '07367462057', '', '100 whin cover Rd LS1 25JZ', 'Citizenship', 'Housewife', 'Shop banner', '2021-09-20 16:00:27', 'Under 5 years qualification', 'Matric', 'registered'),
(90, 'A2 Test', '4', 'Syed oliur Rahman', '1979-10-25', 'syedrahman1979@yahoo.com', '07821936855', '', '7 giptonwood grove LS82TG', 'Citizenship', 'Restaurant', 'Flyer (Mosque)', '2021-09-22 12:41:02', 'Under 5 years qualification', 'N/P', 'archived'),
(91, 'B1 TEST REGISTRATION FORM', '3', 'Syeda Rumana Begum', '1987-04-01', 'syedarumana@icloud.com', '07473915805', '', '29 Hiltop Mount LS8 4JS', 'Citizenship', 'Housewife', 'X-Student', '2021-09-29 13:40:48', 'Under 5 years qualification', 'N/P', 'registered'),
(92, 'B1 TEST REGISTRATION FORM', '3', 'Shakera Khatun', '1979-04-02', 'shakerakhatun1979@gmail.com', '07732835220', '', '33 Hill crest LS7 4EB', 'Citizenship', 'Housewife', 'X-Student', '2021-10-04 14:56:40', 'Under 5 years qualification', 'Matric', 'registered'),
(93, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Shahida Akhter Chomp', '1986-12-25', 'shahidaakhter1986@gmail.com', '07570809103', '', '61 Markham Avenue LS8 4LE', 'Citizenship', 'Housewife', 'Friend referral', '2021-10-04 15:02:12', 'Under 5 years qualification', 'N/A', 'archived'),
(94, 'B1 TEST REGISTRATION FORM', '3', 'Tauseef Asghar Khan', '1990-06-04', 'tauseef1973@gmail.com', '07860608441', '', 'N/A', 'Citizenship', 'Factory work', 'X-Student', '2021-10-05 13:51:21', 'Under 5 years qualification', 'N/P', 'archived'),
(95, 'B1 TEST REGISTRATION FORM', '3', 'Murad Bejrga', '1990-10-07', 'muradbejrga@gmail.com', '7474180702', '', '23 Dulverton grove Leeds LS11 OLD', 'Citizenship', 'N/P', 'Whats message, Text message, Viber message', '2021-10-07 12:46:33', 'Under 5 years qualification', 'N/P', 'archived'),
(96, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Begum MRS Musammat S', '1990-03-12', 'salmanoorbegum@gmail.com', '07466239898', '', '53 Hiltop Mount Leeds LS8 4EW', 'Citizenship', 'Housewife', 'Friend referral', '2021-10-11 13:15:52', 'Under 5 years qualification', 'N/P', 'registered'),
(97, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Khujista Abdul', '1984-08-18', 'khujistaabdul4@gmail.com', '07401279479', '', '40  Burmantofts St Leeds LS9 7QE', 'Citizenship', 'Housewife', 'banner', '2021-10-11 15:41:38', 'Under 5 years qualification', 'N/P', 'archived'),
(98, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Ali Turkamani', '1967-10-07', 'a.turkamani46@gmail.com', '07716781881', '', '25 Tinshll Avenue', 'Citizenship', 'Unemployed', 'Friend referral', '2021-10-11 16:37:26', 'Under 5 years qualification', 'N/P', 'registered'),
(99, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Rouguiata Diallo', '2000-06-03', 'diallorouguiata25@gmail.com', '07723058127', '', '36 Lindon road LS11 6HA', 'Citizenship', 'Student', 'Others', '2021-10-12 13:27:22', 'Under 5 years qualification', 'N/P', 'archived'),
(100, 'Life in The UK Test', '2', 'Maria Khalil', '1989-02-12', 'ahsankhalil0706@gmail.com', '07447338467', '', '9 St Chaos drive LS6 3PZ', 'Citizenship', 'Housewife', 'Google', '2021-10-13 12:15:09', 'Under 5 years qualification', 'N/P', 'archived'),
(101, 'Life in The UK Test', '2', 'Issofa  Mout Apbeme', '1979-02-23', 'motabemey@yahoo.com', '07578641914', '', '18 Meanwood valley mount LS6 4EW', 'Citizenship', 'Car mechanic', 'Google', '2021-10-14 13:49:12', 'Under 5 years qualification', 'N/P', 'archived'),
(103, 'Life in The UK Test', '2', 'Henna Yuboah', '1972-10-25', 'hennayuboah21@gmail.com', '07460391965', '', '115 Gipton Gate East LS9  6SU', 'Citizenship', 'Cleaning', 'Friend referral', '2021-10-18 13:58:49', 'Under 5 years qualification', 'N/P', 'archived'),
(104, 'Life in The UK Test', '2', 'Shahnaz Bibi', '1972-01-01', 'shanaz187786@icloud.com', '07596448193', '', '30 Maxbrough Avenue LS7 3EF', 'ILR ( Indefinite Leave to Remain)', 'Housewife', 'Flyer (Door)', '2021-10-25 16:16:20', 'Under 5 years qualification', 'N/P', 'archived'),
(105, 'Life in The UK Test', '2', 'Akbar Noori ', '1979-01-01', 'akbarnoori1979@gmail.com', '07440430870', '', '14 Ellden terrace LS2 9AB', 'Citizenship', 'Shopkeeper', 'X-Student', '2021-10-27 16:29:45', 'Under 5 years qualification', 'N/P', 'archived'),
(106, 'Life in The UK Test', '2', 'Uzma Khatoon', '1986-04-06', 'uzmakhatoon730@gmail.com', '07927818314', '', '30 Maxbrough Avenue LS7 3EF', 'Citizenship', 'Housewife', 'Friend referral', '2021-11-01 12:22:14', 'Under 5 years qualification', 'N/P', 'archived'),
(108, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Tahera Khatun', '1988-07-11', 'taherak512@gmail.com', '07536646094', '', '81 Shepherds Lane LS8 5AT', 'N / A', 'Housewife', 'Friend referral', '2021-11-03 14:01:33', 'Under 5 years qualification', 'N/P', 'archived'),
(109, 'Life in The UK Test', '2', 'Nouf  Alanazy', '1992-09-06', 'nouf_2992@icloud.com', '07397600011', '', '64 Nowell mount LS9 6HW', 'Citizenship', 'Housewife', 'Friend referral', '2021-11-09 12:02:03', 'Under 5 years qualification', 'N/A', 'archived'),
(110, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Zubair Aslam', '1975-11-09', 'aslamzubair@hotmail.com', '07948614649', '', '36 Second Avenue LS12 1LB', 'N / A', 'career', 'Social media ( Facebook, Youtube', '2021-11-09 14:17:33', 'Under 5 years qualification', 'N/P', 'registered'),
(111, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Saqib Mahmood', '1996-02-13', 'mahmoodsaqib20@yahoo.com', '07360052420', '', '7 Amberton mount', 'N / A', 'Cheif', 'X-Student', '2021-11-10 12:31:43', 'Under 5 years qualification', 'N/P', 'registered'),
(113, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Sunday Udoye', '1978-10-29', 'sudoye@yahoo.com', '07765632208', '', '113 Gipton gate east Leeds LS9 6SU', 'N / A', 'N/P', 'X-Student', '2021-11-23 12:33:05', 'Under 5 years qualification', 'N/P', 'registered'),
(114, 'Life in The UK Test', '2', 'Syeda Tarika Begum', '1998-10-16', 'suj3d786@hotmail.com', '07864988667', '', '11 Amberton lane LS8 3JB', 'Citizenship', 'Housewife', 'X-Student', '2021-12-02 12:38:10', 'Under 5 years qualification', 'N/P', 'registered'),
(115, 'Life in The UK Test', '2', 'Maria Yaseen', '1996-04-14', 'yaseenmaria634@gmail.com', '07988184034', '', '07 Amberton mount Leeds LS8 3JG', 'Citizenship', 'Housewife', 'X-Student', '2021-12-06 12:35:12', 'Under 5 years qualification', 'N/P', 'registered'),
(116, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Mary Mer', '1975-07-02', 'marymer786@gmail.com', '07516919985', '', '20 Lilac court LS14 6GQ', 'N / A', 'Housewife', 'Friend referral', '2021-12-13 12:23:31', 'Under 5 years qualification', 'N/P', 'registered'),
(117, 'Life in The UK Test', '2', 'Patrice Johns ', '1976-10-07', 'patriceejo@hotmail.com', '07597264501', '', '7 Wykeham Street Fallowfield Manchester M14 7NP ', 'ILR ( Indefinite Leave to Remain)', 'Carer', 'Google', '2021-12-17 23:48:42', 'Under 10 years qualification', 'Access to HE', 'enrolled'),
(118, 'Life in The UK Test', '2', 'Helon Begum', '1980-02-15', 'helonbegum123@gmail.com', '07708315204', '', '58 Hiltop Mount LS8 4EW', 'Citizenship', 'Housewife', 'X-Student', '2021-12-28 13:26:33', 'Under 5 years qualification', 'N/P', 'archived'),
(119, 'B1 TEST REGISTRATION FORM', '3', 'Qamrul Islam', '1986-07-05', 'qamrulislam786@gmail.com', '07492051876', '', '3 Hares mount  LS8 4LJ', 'Citizenship', 'Restaurant', 'X-Student', '2021-12-31 13:11:00', 'Under 5 years qualification', 'N/A', 'archived'),
(120, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Hakan liker', '1990-03-04', 'hakam123@gmail.com', '07508399216', '', '12 flat norman towers Leeds LS16 5ER', 'N / A', 'Restaurant', 'X-Student', '2022-01-04 11:46:20', 'Under 5 years qualification', 'N/P', 'enrolled'),
(121, 'Life in The UK Test', '2', 'Bushra Kousar', '1987-03-02', 'bushrakausar8287@gmail.com', '07564509305', '', '29 Hassle road Leeds LS6 1EH', 'Citizenship', 'Study', 'Friend referral', '2022-01-05 13:30:58', 'Under 5 years qualification', 'N/P', 'archived'),
(122, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Akbar Noori', '1979-01-01', 'nooriakbar0@gmail.com', '07448933906', '', '14 Ellden terrace LS2 9AB', 'N / A', 'Shopkeeper', 'X-Student', '2022-01-10 14:25:17', 'Under 5 years qualification', 'N/P', 'archived'),
(123, 'B1 TEST REGISTRATION FORM', '3', 'Uzma Khatoon', '1986-05-04', 'uzmakhatoon730@gmail.com', '07927818314', '', '30 Maxbrough Avenue LS7 3EF', 'Citizenship', 'Housewife', 'X-Student', '2022-01-18 12:46:19', 'Under 5 years qualification', 'N/P', 'archived'),
(125, 'B1 TEST REGISTRATION FORM', '3', 'Samaira Saddique', '1990-06-06', 'samairasaddique81@gmail.com', '07737404898', '', '44 Luxar street LS8 5LA', 'Spouse visa extension', 'Housewife', 'X-Student', '2022-01-27 12:33:23', 'Under 5 years qualification', 'N/P', 'archived'),
(126, 'Life in The UK Test', '2', 'Nabilah Kousar', '1977-09-26', 'nabilahakousar1977@gmail.com', '0771694648', '', '991 Scotthall road LS17 6HJ', 'Citizenship', 'Housewife', 'Friend referral', '2022-01-27 12:38:14', 'Under 5 years qualification', 'N/P', 'archived'),
(127, 'Life in The UK Test', '2', 'Syeda Golshan', '1987-01-01', 'syedagolshan@gmail.com', '07825132899', '', '6 Easterly road cross LS8 3PB', 'Citizenship', 'Housewife', 'Friend referral', '2022-01-27 13:07:32', 'Under 5 years qualification', 'N/P', 'enrolled'),
(129, 'Life in The UK Test', '2', 'Saba Hussain', '1993-12-06', 'Sabahussain19933@gmail.com', '07424311467', '', '3 Hartly Avenue', 'Citizenship', 'Housewife', 'Friend referral', '2022-02-10 15:04:32', 'Under 5 years qualification', 'lukt', 'archived'),
(130, 'Life in The UK Test', '2', 'Dharamjit Kaur', '1974-12-06', 'kdharamjit4@gmail.com', '0788211579', '', '26 Millennium WAY', 'Citizenship', 'Housewife', 'Friend referral', '2022-02-10 15:14:06', 'Under 5 years qualification', 'luck', 'archived'),
(131, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Shadia Ahmed ', '2002-02-18', 'shadias929@gmail.com', '07462822839', '', '52 green Lane BD8 7SP', 'Citizenship', 'Study ', 'Social media ( Facebook, Youtube', '2022-02-14 12:28:00', 'Under 5 years qualification', 'Maths ', 'enrolled'),
(132, 'DRIVING THEORY TEST REGISTRATION FORM', '1', 'Ezaldin Mohamed Adam', '1999-03-13', 'ezdinm7@gmail.com', '0730121311', '', '28 Pemberton drive ', 'ILR ( Indefinite Leave to Remain)', 'Carpenter ', 'Friend referral', '2022-02-15 13:35:58', 'Under 5 years qualification', 'College ', 'enrolled'),
(133, 'Life in The UK Test', '2', 'Crarricky', '', 'Crarricky@mktmail.xyz', '', '', 'Avarua', 'Spouse visa extension', '', 'Social media ( Facebook, Youtube', '2022-05-31 23:56:37', 'Under 12 years qualification ', 'Crarricky', 'enrolled'),
(134, 'Life in The UK Test', '2', 'SarahPl', '', 'sarah888@mailo.com', '', '', 'Los Angeles', 'Spouse visa extension', '', 'Flyer (Door)', '2023-03-13 18:42:48', 'Under 12 years qualification ', 'SarahPl', 'enrolled'),
(135, 'Life in The UK Test', '2', 'Svetlcje', '', 'ir.cze.n.ko.s.vetla.nas.2.030@gmail.com\r\n', '86229314384', '', 'Lviv', 'N / A', '', 'banner', '2023-04-01 13:15:46', 'Under 15 years qualification', 'Svetlcje', 'enrolled'),
(136, 'Life in The UK Test', '2', 'Serzxwu', '', 's.e.r.z.krut.o.golovthem.an@gmail.com\r\n', '86967633389', '', 'Poltava', 'Spouse visa extension', '', 'banner', '2023-04-10 13:40:00', 'Under 12 years qualification ', 'Serzxwu', 'enrolled'),
(137, 'Life in The UK Test', '2', 'Vilianaolf', '', 'vill.anumo.ru.c.h.ko.mos.t@gmail.com\r\n', '86528344693', '', 'Charkiv', 'N / A', '', 'Shop banner', '2023-04-10 13:40:09', 'Under 15 years qualification', 'Vilianaolf', 'enrolled'),
(139, 'Life in The UK Test', '2', 'Vilianasrz', '', 'v.i.lla.nu.m.o.r.u.chk.o.m.o.s.t@gmail.com\r\n', '82216866639', '', 'Charkiv', 'Spouse visa extension', '', 'Others', '2023-04-11 18:46:10', 'Under 15 years qualification', 'Vilianasrz', 'enrolled'),
(140, 'Life in The UK Test', '2', 'Veronawoh', '', 've.r.on.a.sk.u.tenkoa.ll.st.a.r@gmail.com\r\n', '89266723793', '', 'Minsk', 'N / A', '', 'Flyer (Mosque)', '2023-04-12 12:32:14', 'Under 12 years qualification ', 'Veronawoh', 'enrolled'),
(141, 'Life in The UK Test', '2', 'Ilushikcys', '', 'skre.b.co.vi.l.i.u.s.hka.20.8.6@gmail.com\r\n', '86666695399', '', 'Melitopol', 'Spouse visa extension', '', 'Flyer (Mosque)', '2023-04-13 15:59:46', 'Under 12 years qualification ', 'Ilushikcys', 'enrolled'),
(142, 'Life in The UK Test', '2', 'Daviddxp', '', 's.e.m.ec.ze.n.kod.av.i.d.bi.gm.a.n@gmail.com\r\n', '83523293829', '', 'Warsaw', 'Spouse visa extension', '', 'Friend referral', '2023-04-13 16:42:52', 'Under 15 years qualification', 'Daviddxp', 'enrolled'),
(143, 'Life in The UK Test', '2', 'Ilushikipy', '', 's.kr.e.bc.ov.il.i.ush.k.a2.086@gmail.com\r\n', '86464761687', '', 'Melitopol', 'Spouse visa extension', '', 'Road sign', '2023-04-14 17:33:47', 'Under 12 years qualification ', 'Ilushikipy', 'enrolled'),
(144, 'Life in The UK Test', '2', 'Eldarwke', '', 'aleksej.s.t.ukor.uk.o.v2.0.48@gmail.com\r\n', '82372886849', '', 'Warsaw', 'Spouse visa extension', '', 'banner', '2023-04-16 08:10:03', 'Under 12 years qualification ', 'Eldarwke', 'enrolled'),
(145, 'Life in The UK Test', '2', 'Vikiqfb', '', 'v.ikt.oriy.a.skuc.h.k.o19.9.9@gmail.com\r\n', '83544994361', '', 'Poltava', 'Spouse visa extension', '', 'Others', '2023-04-16 23:12:01', 'Under 12 years qualification ', 'Vikiqfb', 'enrolled'),
(146, 'Life in The UK Test', '2', 'Eldarabs', '', 'a.lekse.js.t.uko.r.uko.v.2.0.48@gmail.com\r\n', '85294974415', '', 'Warsaw', 'Spouse visa extension', '', 'Shop banner', '2023-04-17 03:24:20', 'Under 15 years qualification', 'Eldarabs', 'enrolled'),
(147, 'Life in The UK Test', '2', 'Eldarxif', '', 'a.l.ek.s.e.j.s.t.u.ko.ru.k.ov204.8@gmail.com\r\n', '85324848952', '', 'Warsaw', 'Spouse visa extension', '', 'Flyer (Door)', '2023-04-17 22:01:17', 'Under 15 years qualification', 'Eldarxif', 'enrolled'),
(148, 'Life in The UK Test', '2', 'Viktoriwbo', '', 'v.i.k.to.r.i.a.i.love.ba.c.kcha.m@gmail.com\r\n', '88987814677', '', 'New York', 'Spouse visa extension', '', 'Others', '2023-04-19 09:04:54', 'Under 12 years qualification ', 'Viktoriwbo', 'enrolled'),
(149, 'Life in The UK Test', '2', 'Vikiizf', '', 'sh.u.plet.c.ov.a.vi.kt.ori.i.a@gmail.com', '85924675673', '', 'Poltava', 'Spouse visa extension', '', 'Friend referral', '2023-04-19 21:20:33', 'Under 12 years qualification ', 'Vikiizf', 'enrolled'),
(150, 'Life in The UK Test', '2', 'Viktoriouv', '', 'v.i.k.to.r.ia.il.oveb.ac.kc.h.am@gmail.com\r\n', '88612216818', '', 'New York', 'Spouse visa extension', '', 'Social media ( Facebook, Youtube', '2023-04-21 03:10:54', 'Under 12 years qualification ', 'Viktoriouv', 'enrolled'),
(151, 'Life in The UK Test', '2', 'Robvay', '', 'r.obe.r.t.br.ownm.oon.mans@gmail.com\r\n', '81356151792', '', 'Lviv', 'N / A', '', 'Flyer (Door)', '2023-04-22 08:31:38', 'Under 15 years qualification', 'Robvay', 'enrolled'),
(152, 'Life in The UK Test', '2', 'Robegw', '', 'ro.be.r.tbr.o.w.nmoo.n.m.a.n.s@gmail.com\r\n', '81221583978', '', 'Lviv', 'Spouse visa extension', '', 'banner', '2023-04-23 08:23:18', 'Under 12 years qualification ', 'Robegw', 'enrolled'),
(153, 'Life in The UK Test', '2', 'Robkxq', '', 'ro.ber.t.br.ow.n.m.oonmans@gmail.com\r\n', '84595937125', '', 'Lviv', 'N / A', '', 'banner', '2023-04-25 06:27:06', 'Under 15 years qualification', 'Robkxq', 'enrolled'),
(154, 'Life in The UK Test', '2', 'Margaretahf', '', 'm.a.rg.are.lov.etro.b.erts@gmail.com\r\n', '84554164344', '', 'Lviv', 'N / A', '', 'Friend referral', '2023-04-30 07:30:38', 'Under 15 years qualification', 'Margaretahf', 'enrolled'),
(155, 'Life in The UK Test', '2', 'Margaretubw', '', 'marg.a.r.elove.tr.o.b.erts@gmail.com\r\n', '83184851621', '', 'Lviv', 'Spouse visa extension', '', 'X-Student', '2023-05-01 17:41:20', 'Under 12 years qualification ', 'Margaretubw', 'enrolled');

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

--
-- Table structure for table `govdetails`
--

CREATE TABLE `govdetails` (
  `gov_id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `courseid` int(11) NOT NULL,
  `dept_name` varchar(255) NOT NULL,
  `dept_oficeaddress` varchar(255) NOT NULL,
  `contactperson_address` varchar(255) NOT NULL,
  `contactperson_position` varchar(255) NOT NULL,
  `contactperson_email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `fax` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `govdetails`
--

INSERT INTO `govdetails` (`gov_id`, `userid`, `courseid`, `dept_name`, `dept_oficeaddress`, `contactperson_address`, `contactperson_position`, `contactperson_email`, `phone`, `fax`) VALUES
(1, 0, 5, '', '', '', '', '', '', ''),
(2, 0, 5, '', '', '', '', '', '', ''),
(3, 12, 5, '', '', '', '', '', '', ''),
(4, 13, 5, '', '', '', '', '', '', ''),
(5, 14, 5, '', '', '', '', '', '', ''),
(6, 15, 5, '', '', '', '', '', '', ''),
(7, 16, 5, '', '', '', '', '', '', ''),
(8, 17, 5, '', '', '', '', '', '', ''),
(9, 18, 5, '', '', '', '', '', '', ''),
(10, 19, 6, '', '', '', '', '', '', ''),
(11, 20, 7, '', '', '', '', '', '', ''),
(12, 21, 5, '', '', '', '', '', '', ''),
(13, 22, 5, '', '', '', '', '', '', ''),
(14, 23, 5, '', '', '', '', '', '', ''),
(15, 24, 5, '', '', '', '', '', '', ''),
(16, 25, 5, '', '', '', '', '', '', ''),
(17, 26, 5, '', '', '', '', '', '', ''),
(18, 27, 5, '', '', '', '', '', '', ''),
(19, 28, 5, '', '', '', '', '', '', ''),
(20, 29, 5, '', '', '', '', '', '', ''),
(21, 30, 5, '', '', '', '', '', '', ''),
(22, 31, 5, '', '', '', '', '', '', ''),
(23, 32, 6, '', '', '', '', '', '', ''),
(24, 33, 5, '', '', '', '', '', '', ''),
(25, 32, 5, '', '', '', '', '', '', ''),
(26, 33, 7, '', '', '', '', '', '', ''),
(27, 34, 5, '', '', '', '', '', '', ''),
(28, 35, 6, '', '', '', '', '', '', ''),
(29, 36, 7, '', '', '', '', '', '', ''),
(30, 37, 5, '', '', '', '', '', '', '');

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

--
-- Table structure for table `online_forms`
--

CREATE TABLE `online_forms` (
  `id` int(11) NOT NULL,
  `form_id` varchar(100) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `contact_no` varchar(15) NOT NULL,
  `email_id` varchar(100) NOT NULL,
  `current_status` varchar(50) NOT NULL,
  `qualification_type` varchar(50) NOT NULL,
  `qualification_name` varchar(50) NOT NULL,
  `country` varchar(50) NOT NULL,
  `city` varchar(50) NOT NULL,
  `how_hear` varchar(50) NOT NULL,
  `apply_date` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `online_forms`
--

INSERT INTO `online_forms` (`id`, `form_id`, `first_name`, `last_name`, `contact_no`, `email_id`, `current_status`, `qualification_type`, `qualification_name`, `country`, `city`, `how_hear`, `apply_date`, `status`) VALUES
(3, '3', 'nahar', 'singh', '878978798', 'heh@gmail.com', 'Employer', 'Last ', 'afda', 'afda', 'afda', 'Instagram', '2021-07-11', 'registered'),
(4, '3', 'nahar', 'singh', '878978798', 'heh@gmail.com', 'Employer', 'Last ', 'afda', 'afda', 'afda', 'Instagram', '2021-07-25', 'registered'),
(11, '2', 'Naima  Toun Kara', 'Toun kara', '07481906390', 'Naimatounkara1@gmail.com', 'Student ', 'Current', 'IT users skills', 'United Kingdom', 'Leeds', 'Other', '2021-09-07', 'enrolled'),
(12, 'Digital Skills in Employment', 'Majid', 'Ali', '+923129819874', 'pukhtoonyar047@gmail.com', 'Other', 'Other', 'Intermediate', 'Pakistan', 'Peshawar', 'Social media (Facebook, Youtube)', '2023-06-02', 'enrolled'),
(13, 'Certificate in IT User Skills', 'Waqas', 'Ahmed', '03217432055', 'waqas4693@gmail.com', 'Student', 'Current', 'BS Computer Science', 'Pakistan', 'Lahore', 'Friend referral', '2023-06-10', 'enrolled');

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

--
-- Table structure for table `organization`
--

CREATE TABLE `organization` (
  `org_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `org_name` varchar(255) NOT NULL,
  `org_address` varchar(255) NOT NULL,
  `org_web` varchar(255) NOT NULL,
  `org_contactperson` varchar(255) NOT NULL,
  `org_persionemail` varchar(255) NOT NULL,
  `org_phone` varchar(255) NOT NULL,
  `org_fax` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `organization`
--

INSERT INTO `organization` (`org_id`, `course_id`, `user_id`, `org_name`, `org_address`, `org_web`, `org_contactperson`, `org_persionemail`, `org_phone`, `org_fax`) VALUES
(2, 6, 0, 'w2TnYwP9zFPn <html><a href=\"https://google.ru\"><img src=\"https://d.radikal.ru/d28/2008/18/24c8109ba1a4.jpg\" width=\"600\" height=\"234\" alt=\"bill\"></a> </html>  1', '??????', '??????', 'w2TnYwP9zFPn <html><a href=\"https://google.ru\"><img src=\"https://d.radikal.ru/d28/2008/18/24c8109ba1a4.jpg\" width=\"600\" height=\"234\" alt=\"bill\"></a> </html>  1', 'dion.kittelson@mail.ru', '518 243 4610', 'w2TnYwP9zFPn <html><a href=\"https://google.ru\"><img src=\"https://d.radikal.ru/d28/2008/18/24c8109ba1a4.jpg\" width=\"600\" height=\"234\" alt=\"bill\"></a> </html>  3'),
(3, 6, 0, 'Nill', 'Nill', 'Nill', 'Nill', 'Nill', '0000', '000000'),
(4, 6, 0, 'Nill', 'Nill', 'Nill', 'Nill', 'Nill', '0000', '000000'),
(5, 6, 0, 'Nill', 'Nill', 'Nill', 'Nill', 'Nill', '0000', '000000'),
(6, 6, 0, 'Nill', 'Nill', 'Nill', 'Nill', 'Nill', '0000', '000000'),
(7, 6, 0, 'Nill', 'Nill', 'Nill', 'Nill', 'Nill', '0000', '000000'),
(8, 6, 0, 'inex insitution', 'inex institution multan', 'www.inex-institution.Webs.com', 'Amir tabasam ( director)', 'inex-institution@yahoo.com', '000000', '00000000'),
(9, 6, 0, 'inex insitution', 'inex institution multan', 'www.inex-institution.Webs.com', 'Amir tabasam ( director)', 'inex-institution@yahoo.com', '000000', '00000000');

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

--
-- Table structure for table `registration_table`
--

CREATE TABLE `registration_table` (
  `register_id` int(11) NOT NULL,
  `register_firstname` varchar(250) DEFAULT NULL,
  `register_lastname` varchar(250) DEFAULT NULL,
  `register_emailid` varchar(300) DEFAULT NULL,
  `register_mobilenumber` varchar(50) DEFAULT NULL,
  `register_training` varchar(250) DEFAULT NULL,
  `register_trainingfundedby` varchar(250) DEFAULT NULL,
  `register_country` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `registration_table`
--

INSERT INTO `registration_table` (`register_id`, `register_firstname`, `register_lastname`, `register_emailid`, `register_mobilenumber`, `register_training`, `register_trainingfundedby`, `register_country`) VALUES
(0, 'ff', 'ffff', 'sumadaodran@gmail.com', '55555555', 'Principles of Leadership', 'Him/herself', 'Afganistan'),
(0, 'test', 'test', 'test@ehouse.org.uk', '7899test', 'Principles of Leadership', 'Government', 'Pakistan');

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

--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `id` int(11) NOT NULL,
  `resourse_name` varchar(500) NOT NULL,
  `resourse_type` enum('staff','student') NOT NULL DEFAULT 'student',
  `resource_category` varchar(500) NOT NULL,
  `resourse_status` enum('0','1') NOT NULL DEFAULT '0',
  `resource_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resources`
--

INSERT INTO `resources` (`id`, `resourse_name`, `resourse_type`, `resource_category`, `resourse_status`, `resource_date`) VALUES
(3, 'resources/1587830646test.png', 'student', '', '1', '2020-05-25 19:04:10'),
(4, 'resources/1587830654test.png', 'student', '', '1', '2020-05-25 19:04:10');

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

--
-- Table structure for table `staff_document`
--

CREATE TABLE `staff_document` (
  `id` int(11) NOT NULL,
  `documentname` varchar(500) NOT NULL,
  `listingname` varchar(500) NOT NULL,
  `documenttype` varchar(500) NOT NULL,
  `documentstatus` enum('y','n') NOT NULL DEFAULT 'y',
  `staffid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `staff_document`
--

INSERT INTO `staff_document` (`id`, `documentname`, `listingname`, `documenttype`, `documentstatus`, `staffid`) VALUES
(1, 'staff_documents/159282566129 May.png', 'Latest picture being uploaded', 'Latest picture', 'y', 2),
(2, 'staff_documents/159300069529 May.png', 'DBS is being uploaded', 'DBS Disclosure', 'y', 2),
(3, 'staff_documents/159308122029 May.png', 'It is my picture', 'Latest picture', 'y', 4),
(4, 'staff_documents/1593697470baby-elephant-with-heart-small.jpg', 'test', 'Latest picture', 'y', 5),
(5, 'staff_documents/1594117805Attendance.png', 'picture', 'Latest picture', 'y', 6),
(6, 'staff_documents/1594118342Attendance.png', 'Valid UK Passport', 'Valid UK Passport  / UK Residence permit', 'y', 6),
(7, 'staff_documents/1594118371Attendance.png', 'Working rights', 'Valid non-UK passport + Working rights', 'y', 6),
(8, 'staff_documents/1594118399Attendance.png', 'CPDs', 'CPDs / Professional training', 'y', 6),
(9, 'staff_documents/1594118424Attendance.png', 'Proof of address', 'Proof of address', 'y', 6),
(10, 'staff_documents/1594118448Attendance.png', 'DBS is being uploaded', 'DBS Disclosure', 'y', 6),
(11, 'staff_documents/1594118470Attendance.png', 'Qualifications', 'Qualifications', 'y', 6),
(12, 'staff_documents/1594118512Attendance.png', 'CV', 'CV', 'y', 6),
(13, 'staff_documents/1594120553Attendance.png', 'Other', 'Other', 'y', 6),
(14, 'staff_documents/1594120692Attendance.png', 'Valid UK Passport', 'Valid UK Passport  / UK Residence permit', 'y', 6),
(15, 'staff_documents/1594120697Attendance.png', 'Valid UK Passport', 'Valid UK Passport  / UK Residence permit', 'y', 6),
(16, 'staff_documents/1594120736Attendance.png', 'Other', 'Valid UK Passport  / UK Residence permit', 'y', 6),
(17, 'staff_documents/1594120741Attendance.png', 'Other', 'Valid UK Passport  / UK Residence permit', 'y', 6),
(18, 'staff_documents/1594120771Attendance.png', 'Other', 'Other', 'y', 6),
(19, 'staff_documents/1594120777Attendance.png', 'Other', 'Other', 'y', 6),
(20, 'staff_documents/1594497347Attendance.png', 'Valid UK Passport', 'Valid UK Passport  / UK Residence permit', 'y', 8),
(21, 'staff_documents/1594497400Attendance.png', 'Other', 'Other', 'y', 8),
(22, 'staff_documents/1600168824S R BOKHARI CV.pdf', 'S R Bokhari CV. PDF', 'CV', 'y', 17),
(23, 'staff_documents/1600169169Sabir Hussain CV.pdf', 'Sabir Hussain CV.PDF', 'CV', 'y', 16),
(24, 'staff_documents/1600169263Lloyd Spencer CV July19.docx', 'LLoyd Spancer CV.PDF', 'CV', 'y', 15),
(25, 'staff_documents/1600169267Lloyd Spencer CV July19.docx', 'LLoyd Spancer CV.PDF', 'CV', 'y', 15),
(26, 'staff_documents/1600169321Edward Boakye CV.docx', 'Edward Boakye CV', 'CV', 'y', 14),
(27, 'staff_documents/1600169406Dr Ahmed _CV.docx', 'Ahmed Mustafa CV', 'CV', 'y', 13),
(28, 'staff_documents/1600169462Sheikh Maalik.pdf', 'Sheikh Shahzad CV', 'CV', 'y', 12),
(29, 'staff_documents/1600169567mahboob_CV_2018_Mar.docx', 'Mahboob CV', 'CV', 'y', 11),
(30, 'staff_documents/1600172166Active IQ level 3 Award In Education and Training.jpg', 'ACtive IQ Level', 'Qualifications', 'y', 17),
(31, 'staff_documents/1600172171Active IQ level 3 Award In Education and Training.jpg', 'ACtive IQ Level', 'Qualifications', 'y', 17),
(32, 'staff_documents/1600172293Principal_Job description.docx', 'Principal Job Description', 'Other', 'y', 17),
(33, 'staff_documents/1600172600Business improvement event.JPG', 'Business Improv', 'Qualifications', 'y', 13),
(34, 'staff_documents/1600172643Conflict management event.JPG', 'Conflict Management', 'Qualifications', 'y', 13),
(35, 'staff_documents/1600172650Conflict management event.JPG', 'Conflict Management', 'Qualifications', 'y', 13),
(36, 'staff_documents/1600172654Conflict management event.JPG', 'Conflict Management', 'Qualifications', 'y', 13),
(37, 'staff_documents/1600172672MBA.JPG', 'MBA ', 'Qualifications', 'y', 13),
(38, 'staff_documents/1600172701PhD in HR Management.JPG', 'PhD in HR', 'Qualifications', 'y', 13),
(39, 'staff_documents/1600172777Agile-FoundationCert.pdf', 'Agile Foundation', 'Qualifications', 'y', 12),
(40, 'staff_documents/1600172806BCS-CISMPEXAM.pdf', 'BCS CISMPEXAM', 'Qualifications', 'y', 12),
(41, 'staff_documents/1600172879CERTIFICATE PRINCE2 ORG.pdf', 'Certificate Prince', 'Qualifications', 'y', 12),
(42, 'staff_documents/1600172897CERTIFICATE PRINCE2 ORG.pdf', 'Certificate Prince', 'Qualifications', 'y', 12),
(43, 'staff_documents/1600172966MSc_Computer Systems & Networking_SBL.jpg', 'MSc Computer', 'Qualifications', 'y', 11),
(44, 'staff_documents/1600173008Mahboob_ncfe_assessor training.doc', 'Ncf Training', 'Qualifications', 'y', 11),
(45, 'staff_documents/1600173015Mahboob_ncfe_assessor training.doc', 'Ncf Training', 'Qualifications', 'y', 11),
(46, 'staff_documents/1600173045NCFE_Certificate of Attendance_New Assessor.pdf', 'Ncfe Certificate', 'Qualifications', 'y', 11),
(47, 'staff_documents/1600173069NOCN_L 2 Award in Door Supervision.jpg', 'Award', 'Qualifications', 'y', 11),
(48, 'staff_documents/1600337121Passport_Rashad.docx', 'Passport Rashad', 'Valid UK Passport  / UK Residence permit', 'y', 17),
(49, 'staff_documents/1600337163Passport_Rashad.png', 'Rashad Passport', 'Valid UK Passport  / UK Residence permit', 'y', 17),
(50, 'staff_documents/1600337304AET Certificate_Rashad.pdf', 'AET certificate ', 'Qualifications', 'y', 17),
(51, 'staff_documents/1600337327Child abuse_Rashad.pdf', 'Child Abuse', 'Qualifications', 'y', 17),
(52, 'staff_documents/1600337350Child abuse_Rashad.pdf', 'Child Abuse', 'Qualifications', 'y', 17),
(53, 'staff_documents/1600337427Child Accident Prevention_Rashad.pdf', 'Child Accident Prevention', 'CPDs / Professional training', 'y', 17),
(54, 'staff_documents/1600337459Child Sexual Exploitation_Rashad.pdf', 'Child Sexual Expoliation', 'CPDs / Professional training', 'y', 17),
(55, 'staff_documents/1600337516eSafety for teachers and staff_Rashad.pdf', 'eSafety', 'CPDs / Professional training', 'y', 17),
(56, 'staff_documents/1600337538PREVENT_Rashad.pdf', 'Prevent', 'CPDs / Professional training', 'y', 17),
(57, 'staff_documents/1600337636Marketing manager_Job description.docx', 'Marketing', 'Other', 'y', 17),
(58, 'staff_documents/1600337671Safeguarding Officer_Job description.docx', 'Safeguarding officer', 'Other', 'y', 17),
(59, 'staff_documents/1600337724JD_Principal.pdf', 'JD principal', 'Other', 'y', 17),
(60, 'staff_documents/1600337816Prevent_sabir hussain.pdf', 'Prevent', 'CPDs / Professional training', 'y', 16),
(61, 'staff_documents/1600337841Safeguarding_sabir hussain.pdf', 'Safeguarding ', 'CPDs / Professional training', 'y', 16),
(62, 'staff_documents/1600337887JD_Programme lead.pdf', 'JD Programme lead', 'Qualifications', 'y', 16),
(63, 'staff_documents/1600337913Lead trainer_ Job description.doc', 'Lead trainer', 'Qualifications', 'y', 16),
(64, 'staff_documents/1600337979JD_Student Welfare Officer.pdf', 'Student welfare training', 'CPDs / Professional training', 'y', 15),
(65, 'staff_documents/1600338001Prevent_Lloyd.pdf', 'Prevent', 'CPDs / Professional training', 'y', 15),
(66, 'staff_documents/1600338022Safeguarding_Lloyd.pdf', 'Safeguarding', 'CPDs / Professional training', 'y', 15),
(67, 'staff_documents/1600338060Student Welfare Officer_ Job description.doc', 'Student welfare officer', 'Other', 'y', 15),
(68, 'staff_documents/1600338089CV_Lloyd.docx', 'CV', 'CV', 'y', 15),
(69, 'staff_documents/1600338107CV_Lloyd.pdf', 'CV PDF', 'CV', 'y', 15),
(70, 'staff_documents/1600338157Prevent certificate.jpg', 'Prevent', 'CPDs / Professional training', 'y', 14),
(71, 'staff_documents/1600338184Prevent certificate_edward.docx', 'prevent Certificate', 'CPDs / Professional training', 'y', 14),
(72, 'staff_documents/1600338299Prevent cert_Dr Younus.PNG', 'Prevent', 'CPDs / Professional training', 'y', 13),
(73, 'staff_documents/1600338357Prevent training certificate.docx', 'prevent Certificate', 'CPDs / Professional training', 'y', 13),
(74, 'staff_documents/1600338384Prevent training certificate.docx', 'prevent Certificate', 'CPDs / Professional training', 'y', 13),
(75, 'staff_documents/1600338385Prevent training certificate.docx', 'prevent Certificate', 'CPDs / Professional training', 'y', 13),
(76, 'staff_documents/1600338410Safeguarding cert_Dr Younus.docx', 'Safeguarding', 'CPDs / Professional training', 'y', 13),
(77, 'staff_documents/1600338443Safeguarding cert_Dr Younus.jpeg', 'Safeguarding certificate', 'CPDs / Professional training', 'y', 13),
(78, 'staff_documents/1600338469Safeguarding cert_Dr Younus.pdf', 'Safeguarding', 'CPDs / Professional training', 'y', 13),
(79, 'staff_documents/1600338496Trainer_ Job description.doc', 'trainer JD', 'Other', 'y', 13),
(80, 'staff_documents/1600338573Driving licence+Residence permit.pdf', 'Driving Licence', 'Proof of address', 'y', 13),
(81, 'staff_documents/1600338596DB S_1.pdf', 'DBS1', 'DBS Disclosure', 'y', 13),
(82, 'staff_documents/1600338618DB S_2.pdf', 'DBS2', 'DBS Disclosure', 'y', 13),
(83, 'staff_documents/1600338657AHMED M YOUNES ACAcv 12.2018.docx (1).docx', 'Ahmed Mustafa', 'Other', 'y', 13),
(84, 'staff_documents/1600338711DBS Disclosure.jpeg', 'DBS Disclosure', 'DBS Disclosure', 'y', 12),
(85, 'staff_documents/1600338731DBS_Sheikh.docx', 'DBS', 'DBS Disclosure', 'y', 12),
(86, 'staff_documents/1600338791CMI Level 7 Diploma in Strategic Management and Leadership.jpg', 'CMI Level 7', 'Qualifications', 'y', 12),
(87, 'staff_documents/1600338832CTLLS-Edexcel Level 4 Award in Preparing to Teach in the Lifelong Learning Sector (QCF ).jpg', 'CTLLS Edexcel level 4', 'Qualifications', 'y', 12),
(88, 'staff_documents/1600338890Master of IT.jpg', 'Master of IT', 'Qualifications', 'y', 12),
(89, 'staff_documents/1600338915MSc in information Systerms_Leeds Metropolitan University.jpg', 'MSc ', 'Qualifications', 'y', 12),
(90, 'staff_documents/1600338945PTLLS_Level 4 Award in Preparing to Teach in the Lifelong Learning Sector (QCF ).jpg', 'PTLLS level 4', 'Qualifications', 'y', 12),
(91, 'staff_documents/1600338990DBS_Trainer_Sheikh.pdf', 'DBS ', 'DBS Disclosure', 'y', 12),
(92, 'staff_documents/1600339048Driving Licence (1).jpg', 'Driving Licence 1', 'Proof of address', 'y', 12),
(93, 'staff_documents/1600339065Driving Licence (1).jpg', 'Driving Licence 1', 'Proof of address', 'y', 12),
(94, 'staff_documents/1600339102Driving Licence (2).jpg', 'Driving Licence 2', 'Proof of address', 'y', 12),
(95, 'staff_documents/1600339118Driving Licence (2).jpg', 'Driving Licence 2', 'Proof of address', 'y', 12),
(96, 'staff_documents/1600339140driving licence.docx', 'Driving Licence ', 'Proof of address', 'y', 12),
(97, 'staff_documents/1600339173passport.docx', 'Passort  Sheikh', 'Valid UK Passport  / UK Residence permit', 'y', 12),
(98, 'staff_documents/1600339222Passport.jpg', 'Passport', 'Valid UK Passport  / UK Residence permit', 'y', 12),
(99, 'staff_documents/1600339251Prevent Practitionare 2017.pdf', 'Prevent ', 'CPDs / Professional training', 'y', 12),
(100, 'staff_documents/1600339295PreventingBullying2017.pdf', 'prevent Bullying', 'CPDs / Professional training', 'y', 12),
(101, 'staff_documents/1600339335Safeguarding Young People- 2017.pdf', 'Safeguarding young people', 'CPDs / Professional training', 'y', 12),
(102, 'staff_documents/1600339364JD_Trainer.pdf', 'JD trainer', 'Other', 'y', 12),
(103, 'staff_documents/1600339408Sheikh Maalik.pdf', 'Sheikh Maalik', 'Other', 'y', 12),
(104, 'staff_documents/1600339430Trainer_ Job description.doc', 'trainer JD', 'Other', 'y', 12),
(105, 'staff_documents/1600339507DBS_MD_Mahboob.pdf', 'DBS', 'DBS Disclosure', 'y', 11),
(106, 'staff_documents/1600339559fire safety_mahboob.pdf', 'Fire Safety', 'CPDs / Professional training', 'y', 11),
(107, 'staff_documents/1600339588health & safety induction_mahboob.pdf', 'Health and safety induction', 'CPDs / Professional training', 'y', 11),
(108, 'staff_documents/1600339620manual handling_mahboob.pdf', 'Manual handling', 'CPDs / Professional training', 'y', 11),
(109, 'staff_documents/1600339645office safety_mahboob.pdf', 'Office safety', 'CPDs / Professional training', 'y', 11),
(110, 'staff_documents/1600339683Administrator_Job_Description.doc', 'Administrator JD', 'Other', 'y', 11),
(111, 'staff_documents/1600339704Director_Job Description.doc', 'Directors JD', 'Other', 'y', 11),
(112, 'staff_documents/1600339734JD_Managing Director.pdf', 'JD managing director', 'Other', 'y', 11),
(113, 'staff_documents/1600339758mahboob_CV_April_2020.docx', 'CV April 2020', 'CV', 'y', 11),
(114, 'staff_documents/1600339774mahboob_CV_April_2020.pdf', 'CV', 'CV', 'y', 11),
(115, 'staff_documents/1600339801passport.docx', 'Passport', 'Valid UK Passport  / UK Residence permit', 'y', 11),
(116, 'staff_documents/1600339844passport.jpg', 'Passport ', 'Valid UK Passport  / UK Residence permit', 'y', 11),
(117, 'staff_documents/1600339878Prevent Duty cert_mahboob.pdf', 'Prevent Duty certificate', 'CPDs / Professional training', 'y', 11),
(118, 'staff_documents/1600339920Proof of address.jpg', 'proof of address', 'Proof of address', 'y', 11),
(119, 'staff_documents/1600339949Safeguarding and Safer Recruitment Certificate.pdf', 'Safeguarding', 'CPDs / Professional training', 'y', 11);

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

--
-- Table structure for table `student_info`
--

CREATE TABLE `student_info` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `family_name` varchar(50) DEFAULT NULL,
  `other_names` varchar(100) DEFAULT NULL,
  `gender` varchar(1) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `marital_status` varchar(10) DEFAULT NULL,
  `nationality` varchar(50) DEFAULT NULL,
  `passport_number` varchar(20) DEFAULT NULL,
  `country_of_issue` varchar(50) DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `learning_disabilities` varchar(3) DEFAULT NULL,
  `disabilities_details` text DEFAULT NULL,
  `allergies` varchar(3) DEFAULT NULL,
  `allergies_details` text DEFAULT NULL,
  `how_hear_about` text DEFAULT NULL,
  `telephone_number` varchar(15) DEFAULT NULL,
  `mobile_number` varchar(15) DEFAULT NULL,
  `email_address` varchar(100) DEFAULT NULL,
  `whatsapp_number` varchar(15) DEFAULT NULL,
  `home_address` text DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `postcode` varchar(15) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `emergency_name` varchar(100) DEFAULT NULL,
  `relationship` varchar(50) DEFAULT NULL,
  `emergency_telephone` varchar(15) DEFAULT NULL,
  `emergency_email` varchar(100) DEFAULT NULL,
  `course` varchar(50) DEFAULT NULL,
  `study_session` varchar(15) DEFAULT NULL,
  `uk_visa_applied` varchar(3) DEFAULT NULL,
  `uk_travel_before` varchar(3) DEFAULT NULL,
  `uk_denied_entry` varchar(3) DEFAULT NULL,
  `uk_deported_removed` varchar(3) DEFAULT NULL,
  `uk_overstayed_visa` varchar(3) DEFAULT NULL,
  `other_countries_travel` varchar(3) DEFAULT NULL,
  `foreign_country_residence` text DEFAULT NULL,
  `denied_entry_other_country` varchar(3) DEFAULT NULL,
  `deported_removed_other_country` varchar(3) DEFAULT NULL,
  `visa_applied_other_country` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_info`
--

INSERT INTO `student_info` (`id`, `user_id`, `first_name`, `family_name`, `other_names`, `gender`, `date_of_birth`, `marital_status`, `nationality`, `passport_number`, `country_of_issue`, `expiry_date`, `learning_disabilities`, `disabilities_details`, `allergies`, `allergies_details`, `how_hear_about`, `telephone_number`, `mobile_number`, `email_address`, `whatsapp_number`, `home_address`, `city`, `postcode`, `country`, `emergency_name`, `relationship`, `emergency_telephone`, `emergency_email`, `course`, `study_session`, `uk_visa_applied`, `uk_travel_before`, `uk_denied_entry`, `uk_deported_removed`, `uk_overstayed_visa`, `other_countries_travel`, `foreign_country_residence`, `denied_entry_other_country`, `deported_removed_other_country`, `visa_applied_other_country`) VALUES
(1, 0, 'Abubakar', 'Aziz', 'nill', 'M', '0000-00-00', 'single', '11', '11', '11', '0000-00-00', 'yes', '11', 'yes', '11', '11', '11', '11', '11@aa', '21', '11', 'AA', '11', 'PAK', '11', '11', '11', '11@AAA', 'general_english_6', 'morning', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', '1111', 'yes', 'yes', '11'),
(2, 79, 'Test', 'Test', 'Test', 'M', '0000-00-00', 'single', 'Test', 'Test', 'Test', '0000-00-00', 'yes', 'Test', 'yes', 'Test', 'Test', 'Test', 'Test', 'Test@aaa', 'Test', 'Test', 'Test', 'Test', 'Test', 'Test', 'Test', 'Test', 'Test@aaa', 'general_english_11', 'morning', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'Test', 'yes', 'yes', 'Test'),
(3, 79, 'Test', 'Test', 'Test', 'M', '0000-00-00', 'single', 'Test', 'Test', 'Test', '0000-00-00', 'yes', 'Test', 'yes', 'Test', 'Test', 'Test', 'Test', 'Test@aaa', 'Test', 'Test', 'Test', 'Test', 'Test', 'Test', 'Test', 'Test', 'Test@aaa', 'general_english_11', 'morning', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'Test', 'yes', 'yes', 'Test'),
(4, 79, 'abc', 'abc', 'abc', 'M', '0000-00-00', 'single', 'abc', 'abc', 'abc', '0000-00-00', 'yes', 'abc', 'yes', 'abc', 'abc', 'abc', 'abc', 'abc@aa', 'abc', 'abc', 'abc', 'abc', 'abc', 'abc', 'abc', 'abc', 'abc@aa', 'business_english_11', 'morning', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'abc', 'yes', 'yes', 'abc'),
(5, 79, 'abc', 'abc', 'abc', 'M', '0000-00-00', 'single', 'abc', 'abc', 'abc', '0000-00-00', 'yes', 'abc', 'yes', 'abc', 'abc', 'abc', 'abc', 'abc@aa', 'abc', 'abc', 'abc', 'abc', 'abc', 'abc', 'abc', 'abc', 'abc@aa', 'business_english_11', 'morning', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'abc', 'yes', 'yes', 'abc');

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

--
-- Table structure for table `training`
--

CREATE TABLE `training` (
  `id` int(11) NOT NULL,
  `training` varchar(150) NOT NULL,
  `level` varchar(500) NOT NULL,
  `weekdays` varchar(500) NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `trainingurls` varchar(300) NOT NULL,
  `trainingtype` varchar(500) NOT NULL DEFAULT 'Leadership and management skills training',
  `fees` varchar(200) NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `training`
--

INSERT INTO `training` (`id`, `training`, `level`, `weekdays`, `startdate`, `enddate`, `trainingurls`, `trainingtype`, `fees`, `content`) VALUES
(5, 'Principles of team leading', 'Level 2 Certificate', '6 Weeks', '2021-09-07', '2021-10-13', '', 'Business and management skills training', '£3,200', '                                                                                 \r\n   <b>Principles of team leading </b>\r\n\r\n   <p>Strong team leadership is essential for providing guidance, direction and instruction within a group and inevitably leads to more effective teamwork and more motivated employees. Being able to manage a team effectively is critical in the current job market, where employee productivity and team outcomes are closely monitored. </p>\r\n   <b>Short course / training content</b>\r\n   <ul>\r\n<li>Principles of team leading</li>\r\n<li>Understanding business</li>\r\n<li>Understanding how to communicate work-related information</li>\r\n<li>Understanding how to deliver customer service and resolve problems</li>\r\n<li>Understanding how to develop working relationships with colleagues</li>\r\n<li>Introduction to coaching</li>\r\n<li>Introduction to mentoring</li>\r\n<li>Understanding personal development</li>\r\n\r\n</ul>\r\n          <b>What you will get</b> <br>\r\n\r\n\r\n   <ul>\r\n<li>Accredited Level 2 qualification</li>\r\n<li>Increment in competency level that matters for employer</li>\r\n<li>Enhancement in personal and professional development</li>\r\n<li>Importance of clear communication</li>\r\n \r\n</ul>\r\n\r\n<b>This short course / training is for </b> <br>\r\n\r\n\r\n   <ul>\r\n<li>It is suitable for those wanting to embark on a career in management and who wish to achieve a qualification to support their work</li>\r\n<li>It is ideal for those either looking for their first management position or those already working in a team leading role who are looking for ways to enhance their knowledge and skills</li>\r\n \r\n</ul>\r\n'),
(6, 'Principles of business administration', 'Level 2 Certificate', '6 Weeks', '2021-10-19', '2021-11-24', '', 'Business and management skills training', '£3,200', '                                                                         \r\n   <b>Principles of business administration</b>\r\n\r\n   <p>There were an estimated 5.5 million private sector businesses in the UK at the start of 2016. Despite the recent economic difficulties, the trend has been steadily increasing in the business population. Today’s global economy brings with it a wealth of new markets, shrinking profit margins and increasing operating expenses; the need for good business administration has never been greater. </p>\r\n   <b>Course Content</b>\r\n   <ul>\r\n<li>Develop understanding of basic administration concepts and practices</li>\r\n<li>Review essential knowledge for daily and more complex administration tasks</li>\r\n<li>Learn business and administration national occupational standards</li>\r\n\r\n</ul>\r\n          <b>What you will learn </b> <br>\r\n\r\n\r\n   <ul>\r\n<li>Principles of Providing Administrative Services </li>\r\n<li>Principles of Business Document Production and Information Management</li>\r\n<li>Understand Communication in a Business Environment</li>\r\n<li>Understand Employer Organisations</li>\r\n<li>Understand How to Develop Working Relationships with Colleagues</li>\r\n \r\n</ul>\r\n\r\n          <b>What you will get</b> <br>\r\n\r\n\r\n   <ul>\r\n<li>Accredited Level 2 qualification</li>\r\n<li>Evidence of your competency to employers</li>\r\n<li>Enhancement in personal and professional development</li>\r\n<li>Relevant skills, knowledge and understanding leading to improved experience for those using your services \r\n\r\n</li>\r\n \r\n</ul>\r\n\r\n<b>This short course / training is for </b> <br>\r\n\r\n\r\n   <ul>\r\n<li>Who wish to achieve a qualification to support their work</li>\r\n<li>For those looking for management position in any business</li>\r\n \r\n</ul>\r\n'),
(7, 'Customer service', 'Level 2 Certificate', '6 Weeks', '2021-10-19', '2021-11-24', '', 'Sales and customer service training', '£3,200', '                                                                                 \r\n   <b>Customer care</b>\r\n\r\n   <p>In order to have a truly successful business, you need to provide good customer service. It is believed that 96% of unhappy customers don’t ever complain; however, 91% of those simply leave and never come back. The main reason for customer churn is not price but bad customer service. Handling a business’s issues in a professional and courteous manner is an essential day-to-day task.</p>\r\n   <b>Course Content</b>\r\n   <ul>\r\n<li>Learn to deliver excellent customer service</li>\r\n<li>Increase awareness of understanding and meeting customers’ needs</li>\r\n<li>Giving a great customer experience</li>\r\n<li>Learn from feedback and promote products and services </li>\r\n\r\n</ul>\r\n          <b>What you will learn </b> <br>\r\n\r\n\r\n   <ul>\r\n<li>Principles of customer service</li>\r\n<li>Understand customers</li>\r\n<li>Understand employer organizations</li>\r\n \r\n</ul>\r\n\r\n          <b>What you will get</b> <br>\r\n\r\n\r\n   <ul>\r\n<li>Accredited Level 2 qualification</li>\r\n<li>Increment in competency level that matters for employer</li>\r\n<li>Enhancement in professional development</li>\r\n<li>Skills to handle successfully customer complaints</li>\r\n<li>Skills to reduce customer complaints</li>\r\n \r\n</ul>\r\n\r\n<b>This short course / training is for </b> <br>\r\n\r\n\r\n   <ul>\r\n<li>Who wish to achieve a qualification to move up in their career</li>\r\n<li>For those looking for customer service position in any business</li>\r\n \r\n</ul>\r\n');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `coursedetails`
--
ALTER TABLE `coursedetails`
  ADD PRIMARY KEY (`booking_id`);

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`);

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

--
-- Indexes for table `govdetails`
--
ALTER TABLE `govdetails`
  ADD PRIMARY KEY (`gov_id`);

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

--
-- Indexes for table `organization`
--
ALTER TABLE `organization`
  ADD PRIMARY KEY (`org_id`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `coursedetails`
--
ALTER TABLE `coursedetails`
  MODIFY `booking_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;

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

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

--
-- AUTO_INCREMENT for table `govdetails`
--
ALTER TABLE `govdetails`
  MODIFY `gov_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

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

--
-- AUTO_INCREMENT for table `organization`
--
ALTER TABLE `organization`
  MODIFY `org_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `courses`
--
ALTER TABLE `courses`
  ADD CONSTRAINT `courses_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);
COMMIT;

