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

START TRANSACTION;



--
-- Database: `db761735363`
--

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

--
-- Table structure for table `audiofiles`
--

CREATE TABLE `audiofiles` (
  `id` int(11) NOT NULL,
  `audioname` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `category` varchar(500) NOT NULL,
  `audiofile` varchar(255) NOT NULL,
  `listeraudio` int(11) NOT NULL,
  `downloadaudio` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `audiofiles`
--

INSERT INTO `audiofiles` (`id`, `audioname`, `description`, `category`, `audiofile`, `listeraudio`, `downloadaudio`) VALUES
(7, 'Test', 'New test', '4', '5d7268d7602de.mp3', 0, 0);

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `courseid` int(11) NOT NULL,
  `status` enum('y','n') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `name`, `courseid`, `status`) VALUES
(1, 'Alertness', 5, 'n'),
(2, 'Attitude', 5, 'n'),
(3, 'Safety and your vehicle', 5, 'n'),
(4, 'Safety margins', 5, 'n'),
(5, 'Hazard awareness', 5, 'n'),
(6, 'Vulnerable road users', 5, 'n'),
(7, 'Other types of vehicles', 5, 'n'),
(8, 'Road conditions and vehicle handling', 5, 'n'),
(9, 'Motorway driving', 5, 'n'),
(10, 'Roles of the Road', 5, 'n'),
(11, 'Road and traffic signs', 5, 'n'),
(12, 'Essential documents', 5, 'n'),
(13, 'Incidents, accidents and emergencies', 5, 'n'),
(14, 'Vehicle loading', 5, 'n'),
(25, 'test_ 09 nov', 9, 'n'),
(26, 'Chapter 1: The values and principles of the UK', 4, 'n'),
(27, 'Chapter 2: What is the UK?', 4, 'n'),
(28, 'Chapter 3: A long and illustrious history', 4, 'n'),
(29, 'Chapter 4: A modern, thriving society', 4, 'n'),
(30, 'Chapter 5: The UK government, the law and your role', 4, 'n'),
(31, 'test and test', 10, 'y'),
(32, 'My family', 7, 'n'),
(33, 'Means of transportation', 7, 'y'),
(34, 'Festivals', 7, 'y'),
(35, 'Music', 7, 'y'),
(36, 'Entertainment', 7, 'n'),
(37, 'Special occasions', 7, 'y'),
(38, 'Recent personal experience', 7, 'y'),
(39, 'Weather', 8, 'y'),
(40, 'UK professions and Jobs', 8, 'n'),
(41, 'What are they doing ?', 8, 'n'),
(42, 'Date of birth', 8, 'n'),
(57, 'Wovels and articles', 14, 'y'),
(58, 'dafd', 18, 'y'),
(59, 'nahar', 18, 'y'),
(60, 'afdada', 12, 'n'),
(61, 'afdfadadf', 12, 'n'),
(63, 'Prepositions', 14, 'y'),
(64, 'Question words', 14, 'y'),
(65, 'Weather', 14, 'y'),
(66, 'Occupations', 14, 'y'),
(68, 'afdafd', 15, 'y'),
(69, 'fagfsg', 14, 'y'),
(70, 'test_18 August', 14, 'y'),
(71, 'The Values and Principles of the UK', 16, 'y'),
(73, 'What is the  UK', 16, 'y'),
(76, 'A Long and illustrious History', 16, 'y'),
(77, 'A Modren Thriving Society', 16, 'y'),
(78, 'The  UK Goverment ,The Law and Your Role', 16, 'y'),
(79, 'Chapter 1', 17, 'y'),
(80, 'Chapter 2', 17, 'y'),
(81, 'Lecture', 16, 'y'),
(82, 'Picture', 16, 'y'),
(83, 'Language support', 16, 'y'),
(84, 'Test 1', 20, 'y'),
(85, 'Test 2', 20, 'y'),
(86, 'Test 3', 20, 'n'),
(87, 'Dummy test', 20, 'n'),
(88, 'test yy', 24, 'n');

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

--
-- Table structure for table `columns`
--

CREATE TABLE `columns` (
  `id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `courseid` int(11) NOT NULL,
  `status` enum('y','n') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `columns`
--

INSERT INTO `columns` (`id`, `name`, `courseid`, `status`) VALUES
(1, 'Lecture', 5, 'n'),
(2, 'Questions & Answers', 5, 'y'),
(3, 'Diagrams', 5, 'n'),
(4, 'Pictures', 5, 'n'),
(5, 'Case study', 5, 'n'),
(6, 'Language support', 5, 'y'),
(7, 'test 1', 4, 'y'),
(8, 'test 2', 4, 'y'),
(9, 'test 3', 4, 'y'),
(10, 'test 4', 4, 'y'),
(11, 'test 5', 4, 'y'),
(19, 'Topic', 7, 'y'),
(20, 'Video', 7, 'y'),
(21, 'Audio', 7, 'y'),
(22, 'Questions', 8, 'y'),
(23, 'Video', 8, 'y'),
(24, 'Audio', 8, 'y'),
(35, 'afdafdafda', 18, 'n'),
(36, 'affadadfafda', 12, 'n'),
(37, 'afddada', 12, 'n'),
(38, 'adadfadf', 12, 'n'),
(40, 'dafd', 14, 'n'),
(41, 'Column 1', 17, 'y'),
(42, 'C1', 20, 'y'),
(43, 'C2', 20, 'y'),
(44, 'test1', 21, 'y'),
(45, 'C3', 20, 'y'),
(46, 'Quiz yy', 24, 'y'),
(47, 'hjhjh', 5, 'y'),
(48, 'mhhkjh', 5, 'y');

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

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

CREATE TABLE `courses` (
  `id` int(11) NOT NULL,
  `l_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`id`, `l_name`) VALUES
(2, 'Test3'),
(3, 'Test2'),
(4, 'test 4'),
(5, 'Test 5');

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

--
-- Table structure for table `learningResourses`
--

CREATE TABLE `learningResourses` (
  `id` int(11) NOT NULL,
  `pre_id` int(11) NOT NULL,
  `chapter` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `terminology` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diagrams` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pics` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `case_study` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `learningResourses`
--

INSERT INTO `learningResourses` (`id`, `pre_id`, `chapter`, `terminology`, `diagrams`, `pics`, `case_study`, `status`) VALUES
(2, 4, 'I9kHtCVANO1Changes (1).docx', 'I9kHtCVANO2Changes.docx', 'I9kHtCVANO3banners.jpg', 'I9kHtCVANO4arin-landing-page.jpg', 'I9kHtCVANO5file_example_MP4_640_3MG.mp4', 1);

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

--
-- Table structure for table `learnings`
--

CREATE TABLE `learnings` (
  `id` int(11) NOT NULL,
  `l_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('y','n') COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `learnings`
--

INSERT INTO `learnings` (`id`, `l_name`, `status`) VALUES
(5, 'Driving theory test', 'n'),
(14, 'A2 Test', 'n'),
(16, 'Life in the UK Test', 'y'),
(17, 'Test course', 'y'),
(19, 'Test', 'y'),
(20, 'Dummy', 'y'),
(21, 'Test', 'y'),
(22, 'Test', 'y'),
(23, 'List', 'y'),
(24, 'yyy', 'n');

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

--
-- Table structure for table `student_document`
--

CREATE TABLE `student_document` (
  `id` int(11) NOT NULL,
  `documentname` varchar(500) NOT NULL,
  `listingname` varchar(500) NOT NULL,
  `documentcategory` varchar(500) NOT NULL,
  `documenttype` varchar(500) NOT NULL,
  `documentstatus` enum('y','n') NOT NULL DEFAULT 'y',
  `studentid` int(11) NOT NULL,
  `document_status` enum('on','off') NOT NULL DEFAULT 'on',
  `doc_name` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_document`
--

INSERT INTO `student_document` (`id`, `documentname`, `listingname`, `documentcategory`, `documenttype`, `documentstatus`, `studentid`, `document_status`, `doc_name`) VALUES
(1, 'student_documents/1597237239783px-Test-Logo.svg-1.png', 'test', '1', 'Chapter', 'y', 1, 'on', ''),
(39, 'student_documents/160250168703_CS_Safety and your vehicle.mp4', '03_Safety and your vehicle', '3', '5', 'y', 0, 'on', ''),
(40, 'student_documents/160250249204_Safety margins_.mp4', '04_Safety margins', '4', '5', 'y', 0, 'on', ''),
(41, 'student_documents/160250310105_CS_Hazard awareness.mp4', '05_Hazard awareness', '5', '5', 'y', 0, 'on', ''),
(42, 'student_documents/160250350806_CS_Vulunrable road users.mp4', '06_Vulunrable road users', '6', '5', 'y', 0, 'on', ''),
(43, 'student_documents/160250362507_CS_Other types of vehicles.mp4', '07_Other types of vehicles', '7', '5', 'y', 0, 'on', ''),
(44, 'student_documents/160250370708_CS_Road conditions and vehicle handling.mp4', '08_Road conditions and vehicle handling', '8', '5', 'y', 0, 'on', ''),
(45, 'student_documents/160250379209_CS_Motorway driving.mp4', '09_Motorway driving', '9', '5', 'y', 0, 'on', ''),
(46, 'student_documents/160250470810_CS_Rules of the road.mp4', '10_Rules of the road', '10', '5', 'y', 0, 'on', ''),
(47, 'student_documents/1602505419blind spot.png', 'Blind spot', '1', '4', 'y', 0, 'on', ''),
(48, 'student_documents/1602505464Central reservation and dual carriagway.png', 'Central reservation', '1', '4', 'y', 0, 'on', ''),
(49, 'student_documents/1602505531dual carriageway.png', 'Dual carriageway on motorway', '1', '4', 'y', 0, 'on', ''),
(50, 'student_documents/1602505564drowsiness.png', 'Drowsiness', '1', '4', 'y', 0, 'on', ''),
(51, 'student_documents/1602505597single carriagway.png', 'Single carriageway', '1', '4', 'y', 0, 'on', ''),
(52, 'student_documents/1602505628road lines.png', 'Road lines', '1', '4', 'y', 0, 'on', ''),
(53, 'student_documents/1602505660medicine label.png', 'Medicine lable', '1', '4', 'y', 0, 'on', ''),
(54, 'student_documents/1602505688distracted driving.png', 'Distracted driving', '1', '4', 'y', 0, 'on', ''),
(55, 'student_documents/1602513837Filler cap.png', 'Filler cap', '2', '4', 'y', 0, 'on', ''),
(56, 'student_documents/1602513885objects hanging in vehicle_1.png', 'Objects hanging in vehicle_1', '2', '4', 'y', 0, 'on', ''),
(57, 'student_documents/1602513921objects hanging in vehicle_2.png', 'Objects hanging in vehicle_2', '2', '4', 'y', 0, 'on', ''),
(58, 'student_documents/1602513953objects hanging in vehicle_3.png', 'Objects hanging in vehicle_3', '2', '4', 'y', 0, 'on', ''),
(59, 'student_documents/1602514011Tram.png', 'Tram', '2', '4', 'y', 0, 'on', ''),
(60, 'student_documents/1602514450ABS system pic.png', 'ABC system', '3', '4', 'y', 0, 'on', ''),
(61, 'student_documents/1602514482braking system.png', 'Braking system', '3', '4', 'y', 0, 'on', ''),
(62, 'student_documents/1602514554brow of a hill.png', 'Brow of a hill', '3', '4', 'y', 0, 'on', ''),
(63, 'student_documents/1602514603catalytic converter.png', 'Catalytic converter', '3', '4', 'y', 0, 'on', ''),
(64, 'student_documents/1602514639congession.png', 'Congession', '3', '4', 'y', 0, 'on', ''),
(65, 'student_documents/1602514673convex mirror.png', 'Convex mirror', '3', '4', 'y', 0, 'on', ''),
(66, 'student_documents/1602514710convex mirror_2.png', 'Convex mirror_2', '3', '4', 'y', 0, 'on', ''),
(67, 'student_documents/1602514741dropped kerb.png', 'Dropped kerb', '3', '4', 'y', 0, 'on', ''),
(68, 'student_documents/1602514782head restraint positions.png', 'Head restraint positions', '3', '4', 'y', 0, 'on', ''),
(69, 'student_documents/1602514809lights.png', 'Lights', '3', '4', 'y', 0, 'on', ''),
(70, 'student_documents/1602514851neutral gear position.png', 'Neutral gear position', '3', '4', 'y', 0, 'on', ''),
(71, 'student_documents/1602514892oil dipstick readings.png', 'Oil dipstick reading ', '3', '4', 'y', 0, 'on', ''),
(72, 'student_documents/1602514928one sided chicane.png', 'One sided chicane', '3', '4', 'y', 0, 'on', ''),
(73, 'student_documents/1602514954pedals.png', 'Pedals', '3', '4', 'y', 0, 'on', ''),
(74, 'student_documents/1602514985removeable sterio.png', 'Removeable sterio', '3', '4', 'y', 0, 'on', ''),
(75, 'student_documents/1602515014selective gear changing.png', 'Selective gear changing', '3', '4', 'y', 0, 'on', ''),
(76, 'student_documents/1602515044suspension.png', 'Suspension', '3', '4', 'y', 0, 'on', ''),
(77, 'student_documents/1602515081two sided chicane.png', 'Two sided chicane', '3', '4', 'y', 0, 'on', ''),
(80, 'student_documents/1603109226ABS and warning light.png', '4_ABS and warning light', '4', '4', 'y', 0, 'on', ''),
(81, 'student_documents/1603109271contraflow comparison.png', '4_Contraflow camparison', '4', '4', 'y', 0, 'on', ''),
(82, 'student_documents/1603109306four wheel drive.png', '4_Four wheel drive', '4', '4', 'y', 0, 'on', ''),
(83, 'student_documents/1603109339stopping distance.png', '4_Stopping distance', '4', '4', 'y', 0, 'on', ''),
(84, 'student_documents/1603109433wheelspin.mp4', '4_Wheel spin', '4', '2', 'y', 0, 'on', ''),
(85, 'student_documents/1603109530blind junction.png', '5_Blind juction', '5', '4', 'y', 0, 'on', ''),
(86, 'student_documents/1603109569Controlled juntion.png', '5_Controlled juction', '5', '4', 'y', 0, 'on', ''),
(87, 'student_documents/1603109610filter light.png', '5_Filter light', '5', '4', 'y', 0, 'on', ''),
(88, 'student_documents/1603109655hazard lights and switch.png', '5_Hazard light and switch', '5', '4', 'y', 0, 'on', ''),
(89, 'student_documents/1603109692Junction.png', '5_Junction', '5', '4', 'y', 0, 'on', ''),
(90, 'student_documents/1603109734Junction_1.png', '5_Junction_1', '5', '4', 'y', 0, 'on', ''),
(91, 'student_documents/1603109772Junction_2.png', '5_Junction_2', '5', '4', 'y', 0, 'on', ''),
(92, 'student_documents/1603109797kickdown.png', '5_Kick down', '5', '4', 'y', 0, 'on', ''),
(93, 'student_documents/1603109833Level crossing with barrier.png', '5_Level crossing with barriee', '5', '4', 'y', 0, 'on', ''),
(94, 'student_documents/1603109871level crossing.png', '5_Level crossing', '5', '4', 'y', 0, 'on', ''),
(95, 'student_documents/1603109911open and closed juction.png', '5_Open and closed junction', '5', '4', 'y', 0, 'on', ''),
(96, 'student_documents/1603109943staggered juntion.png', '5_Staggered juction', '5', '4', 'y', 0, 'on', ''),
(97, 'student_documents/1603109975unmarked and marked junction.png', '5_Unmarked and marked juction', '5', '4', 'y', 0, 'on', ''),
(98, 'student_documents/1603118989breakaway cable.png', '6_Breakaway cable', '6', '4', 'y', 0, 'on', ''),
(99, 'student_documents/1603119027Cyclisht blown off course.png', '6_Cyclish blown of course', '6', '4', 'y', 0, 'on', ''),
(100, 'student_documents/1603119132cyclist at juctions.png', '6_Cyclist and motor cyclist at junction', '6', '4', 'y', 0, 'on', ''),
(101, 'student_documents/1603119205Cyclist routes.png', '6_Shared routes', '6', '4', 'y', 0, 'on', ''),
(102, 'student_documents/1603119237deaf and blind pedestrian.png', '6_Deaf and blind pedestrian', '6', '4', 'y', 0, 'on', ''),
(103, 'student_documents/160337367101_Introduction to Driving Theory Test.png', '1_Introduction to DTT', '1', '3', 'y', 0, 'on', ''),
(104, 'student_documents/160337370102_Ready to stop.png', '02_Ready to stop', '1', '3', 'y', 0, 'on', ''),
(105, 'student_documents/160337372603_Overtaking.png', '03_Overtaking', '1', '3', 'y', 0, 'on', ''),
(106, 'student_documents/160337375304_Stay focused.png', '04_Stay focused', '1', '3', 'y', 0, 'on', ''),
(107, 'student_documents/160337378705_Divert your attention.png', '05_Divert your attention', '1', '3', 'y', 0, 'on', ''),
(108, 'student_documents/160337382306_Case study analysis.png', '06_Case study_Alertness', '1', '3', 'y', 0, 'on', ''),
(109, 'student_documents/16033739591_Helping other road users.png', '1_Helping other road users', '2', '3', 'y', 0, 'on', ''),
(110, 'student_documents/16033739812_Night driving.png', '2_Night driving', '2', '3', 'y', 0, 'on', ''),
(111, 'student_documents/16033740093_Emergency vehicle.png', '3_Emergency vehicles', '2', '3', 'y', 0, 'on', ''),
(112, 'student_documents/16033740334_Pedestrian crossings.png', '4_Pedestrian corssings', '2', '3', 'y', 0, 'on', ''),
(113, 'student_documents/16033740595_Tram.png', '5_Tram', '2', '3', 'y', 0, 'on', ''),
(114, 'student_documents/16033740966_Separation distance.png', '6_Separation distance', '2', '3', 'y', 0, 'on', ''),
(115, 'student_documents/16033741237_View obstruction.png', '7_View obstruction', '2', '3', 'y', 0, 'on', ''),
(116, 'student_documents/16033741458_Overtaking situations.png', '8_Overtaking situations', '2', '3', 'y', 0, 'on', ''),
(117, 'student_documents/16033741739_Case study_Attitude.png', '9_Case study_Attitude', '2', '3', 'y', 0, 'on', ''),
(118, 'student_documents/16033742751_Looking after your car.png', '1_Looking after your car', '3', '3', 'y', 0, 'on', ''),
(119, 'student_documents/16033742962_Car maintenance_1.png', '2_Car maintenance', '3', '3', 'y', 0, 'on', ''),
(120, 'student_documents/16033743213_Car maintenance_2.png', '3_Car maintenance_2', '3', '3', 'y', 0, 'on', ''),
(121, 'student_documents/16033743474_Dealing with faults.png', '4_Dealing with faults', '3', '3', 'y', 0, 'on', ''),
(122, 'student_documents/16033743725_Safety equipment.png', '5_Safety equipments', '3', '3', 'y', 0, 'on', ''),
(123, 'student_documents/16033744026_Before starting a journey.png', '6_Before starting a journey', '3', '3', 'y', 0, 'on', ''),
(124, 'student_documents/16033744257_Car security.png', '7_Car security', '3', '3', 'y', 0, 'on', ''),
(125, 'student_documents/16033744518_Environment.png', '8_Environment', '3', '3', 'y', 0, 'on', ''),
(126, 'student_documents/16033744809_Ecosafe driving.png', '9_Ecosafe driving', '3', '3', 'y', 0, 'on', ''),
(127, 'student_documents/160337450010_Fuel.png', '10_Fuel', '3', '3', 'y', 0, 'on', ''),
(128, 'student_documents/160337453511_Case study_safey and your vehicle.png', '11_Case study_Safety ...........', '3', '3', 'y', 0, 'on', ''),
(129, 'student_documents/16034311341_Safety margins.png', '1_Safety margins', '4', '3', 'y', 0, 'on', ''),
(130, 'student_documents/16034311592_Stopping distance.png', '2_Stopping distance', '4', '3', 'y', 0, 'on', ''),
(131, 'student_documents/16034311843_Weather conditions_1.png', '3_Weather conditions_1', '4', '3', 'y', 0, 'on', ''),
(132, 'student_documents/16034312064_Weather conditions_2.png', '4_Weather conditions', '4', '3', 'y', 0, 'on', ''),
(133, 'student_documents/16034312265_Skidding.png', '5_Skidding', '4', '3', 'y', 0, 'on', ''),
(134, 'student_documents/16034312576_ABS_1.png', '6_ABS_1', '4', '3', 'y', 0, 'on', ''),
(135, 'student_documents/16034312787_ABS_2.png', '7_ABS_2', '4', '3', 'y', 0, 'on', ''),
(136, 'student_documents/16034313038_Contraflow system.png', '8_Contraflow system', '4', '3', 'y', 0, 'on', ''),
(137, 'student_documents/16034313259_Coasting.png', '9_Coasting', '4', '3', 'y', 0, 'on', ''),
(138, 'student_documents/160343134710_Driving in.png', '10_Driving in', '4', '3', 'y', 0, 'on', ''),
(139, 'student_documents/160343137411_Driving and parking on downhill.png', '11_Driving and parking on downhill', '4', '3', 'y', 0, 'on', ''),
(140, 'student_documents/160343140112_Case study_safety margins.png', '12_Case study_Safety margins', '4', '3', 'y', 0, 'on', ''),
(141, 'student_documents/16034518871_Static hazards.png', '1_Static hazards', '5', '3', 'y', 0, 'on', ''),
(142, 'student_documents/16034519162_Moving hazards.png', '2_Moving hazards', '5', '3', 'y', 0, 'on', ''),
(143, 'student_documents/16034519563_Yourself.png', '3_Yourself', '5', '3', 'y', 0, 'on', ''),
(144, 'student_documents/16034519864_Alcohols and drugs.png', '4_Alcohols and drugs', '5', '3', 'y', 0, 'on', ''),
(145, 'student_documents/16034520175_Medicine.png', '5_Medicines', '5', '3', 'y', 0, 'on', ''),
(146, 'student_documents/16034520356_Glasses.png', '6_Glasses', '5', '3', 'y', 0, 'on', ''),
(147, 'student_documents/16034520577_You are.png', '7_You are', '5', '3', 'y', 0, 'on', ''),
(148, 'student_documents/16034520878_Case study_Hazard awareness.png', '8_Case study_Hazard awareness', '5', '3', 'y', 0, 'on', ''),
(149, 'student_documents/16034521801_Pedestrians.png', '1_Pedestrians', '6', '3', 'y', 0, 'on', ''),
(150, 'student_documents/16034522042_Crossings.png', '2_Crossings', '6', '3', 'y', 0, 'on', ''),
(151, 'student_documents/16034522273_Cyclists.png', '3_Cyclists', '6', '3', 'y', 0, 'on', ''),
(152, 'student_documents/16034522494_Motorcyclists.png', '4_Motorcyclists', '6', '3', 'y', 0, 'on', ''),
(153, 'student_documents/16034522715_Animals.png', '5_Animals', '6', '3', 'y', 0, 'on', ''),
(154, 'student_documents/16034523096_Case study_Vulnerable road users.png', '6_Case study_Vulnerable road users', '6', '3', 'y', 0, 'on', ''),
(155, 'student_documents/16034523631_Long vehicles.png', '1_Long vehicles', '7', '3', 'y', 0, 'on', ''),
(156, 'student_documents/16034523822_Situations.png', '2_Situations', '7', '3', 'y', 0, 'on', ''),
(157, 'student_documents/16034524123_Case study_Other types of vehicles.png', '3_Case study_Other types of vehicles', '7', '3', 'y', 0, 'on', ''),
(158, 'student_documents/16034524611_Weather conditions.png', '1_Weather conditions', '8', '3', 'y', 0, 'on', ''),
(159, 'student_documents/16034524822_Weather conditions_2.png', '2_Weather conditions_2', '8', '3', 'y', 0, 'on', ''),
(160, 'student_documents/16034525023_Motorway.png', '3_Motorway', '8', '3', 'y', 0, 'on', ''),
(161, 'student_documents/16034525244_Overtaking.png', '4_Overaking', '8', '3', 'y', 0, 'on', ''),
(162, 'student_documents/16034525475_Case study_Handling.png', '5_Case study_Handling', '8', '3', 'y', 0, 'on', ''),
(163, 'student_documents/16034526151_MW Awareness.png', '1_Motoway awareness_1', '9', '3', 'y', 0, 'on', ''),
(164, 'student_documents/16034526392_MW Awareness_2.png', '2_Motorway awareness_2', '9', '3', 'y', 0, 'on', ''),
(165, 'student_documents/16034526643_MW Studs.png', '3_Motorway studs', '9', '3', 'y', 0, 'on', ''),
(166, 'student_documents/16034526914_MW Emergency.png', '4_Motoway emergency', '9', '3', 'y', 0, 'on', ''),
(167, 'student_documents/16034527165_MW Hard shoulder.png', '5_Motoway hardshoulder', '9', '3', 'y', 0, 'on', ''),
(168, 'student_documents/16034589701_Roundabout.png', '1_Roundabout', '10', '3', 'y', 0, 'on', ''),
(169, 'student_documents/16034589912_Box juction.png', '2_Box junction', '10', '3', 'y', 0, 'on', ''),
(170, 'student_documents/16034590213_Stopping and crossing.png', '3_Stopping and crossing', '10', '3', 'y', 0, 'on', ''),
(172, 'student_documents/16034593974_Case study_Rules of the road.png', '4_Case study_Rules of the road', '10', '3', 'y', 0, 'on', ''),
(173, 'student_documents/16034594931_Essential documents.png', '1_Essential documents', '12', '3', 'y', 0, 'on', ''),
(174, 'student_documents/16034595112_Insurance.png', '2_Insurance', '12', '3', 'y', 0, 'on', ''),
(175, 'student_documents/16034595373_After passing practical test.png', '3_After passing practicle test', '12', '3', 'y', 0, 'on', ''),
(176, 'student_documents/16034595654_Case study_Documents.png', '4_Case study_Documents', '12', '3', 'y', 0, 'on', ''),
(177, 'student_documents/16034596281_Problems with vehicles.png', '1_Problems with vehicle', '13', '3', 'y', 0, 'on', ''),
(178, 'student_documents/16034596512_Stopping at an incident.png', '2_Stopping at an incident', '13', '3', 'y', 0, 'on', ''),
(179, 'student_documents/16034596744_Reporting an accident.png', '4_Reporting an accident', '13', '3', 'y', 0, 'on', ''),
(180, 'student_documents/16034596955_Scene of crash.png', '5_Scene of crash', '13', '3', 'y', 0, 'on', ''),
(181, 'student_documents/16034597186_Breathing.png', '6_Breathing', '13', '3', 'y', 0, 'on', ''),
(182, 'student_documents/16034597627_involved in an accident.png', '7_Involved in an accident', '13', '3', 'y', 0, 'on', ''),
(183, 'student_documents/16034597898_Case study_Accidents.png', '8_Case study_accidents', '13', '3', 'y', 0, 'on', ''),
(184, 'student_documents/16034598693_If casualty is not breathing.png', '3_If casuality is not breathing', '13', '3', 'y', 0, 'on', ''),
(185, 'student_documents/16034599481_Towing a trailer.png', '1_Towing a trailer', '14', '3', 'y', 0, 'on', ''),
(186, 'student_documents/16034599682_Load on a vehicle.png', '2_Load on a vehicle', '14', '3', 'y', 0, 'on', ''),
(187, 'student_documents/16034599983_Case study_Loading.png', '3_Case study_Loading', '14', '3', 'y', 0, 'on', ''),
(188, 'student_documents/160346013401_CS_Alertness.mp4', 'Case study_Alertness', '1', '5', 'y', 0, 'on', ''),
(189, 'student_documents/160346051612_CS_Essential documents.mp4', 'Case study_Documents', '12', '3', 'y', 0, 'on', ''),
(190, 'student_documents/160346082214_CS_Vehicle handling.mp4', 'Case study_Handling', '14', '5', 'y', 0, 'on', ''),
(192, 'student_documents/160365672613_CS_Indidents, accidents and emergencies.mp4', 'Case study_Accident', '13', '5', 'y', 0, 'on', ''),
(193, 'student_documents/160365681312_CS_Essential documents.mp4', 'Case_study_Documents', '12', '5', 'y', 0, 'on', ''),
(194, 'student_documents/160371231002_CS_Attitude.mp4', 'Case study_Attitude', '2', '5', 'y', 0, 'on', ''),
(196, 'student_documents/160371263612_CS_Essential documents.mp4', 'Case study_Documents', '12', '5', 'y', 0, 'on', ''),
(197, 'student_documents/1603720754tram.png', '07_Tram', '7', '4', 'y', 0, 'on', ''),
(198, 'student_documents/1603720807crossroads.png', '7_Crossroads', '7', '4', 'y', 0, 'on', ''),
(199, 'student_documents/1603720843staggered crossroads.png', '7_Strggered crossroads', '7', '4', 'y', 0, 'on', ''),
(200, 'student_documents/1603720886Crossroads and staggered crossroads.png', '7_Crossroads and staggered crossroads', '7', '4', 'y', 0, 'on', ''),
(201, 'student_documents/1603720950single carriagway.png', '7_Single carriageway_1', '7', '4', 'y', 0, 'on', ''),
(202, 'student_documents/1603720987single carriagway_2.png', '7_Single carriageway_2', '7', '4', 'y', 0, 'on', ''),
(203, 'student_documents/1603721020single carriageway with centre line.png', '7_Single carriageway with centre line', '7', '4', 'y', 0, 'on', ''),
(204, 'student_documents/1603721065Hazard line on single carriageway.png', '7_Single carriageway with hazard line', '7', '4', 'y', 0, 'on', ''),
(205, 'student_documents/1603721098Dual Carriageway.png', '7_Dual carriageway', '7', '4', 'y', 0, 'on', ''),
(206, 'student_documents/1603721147high sided vehicle.png', 'High sided vehicle', '7', '4', 'y', 0, 'on', ''),
(207, 'student_documents/1603721552box juntion_1.png', '8_Box junction_', '8', '4', 'y', 0, 'on', ''),
(208, 'student_documents/1603721582box juntion.png', '8_Box junction_2', '8', '4', 'y', 0, 'on', ''),
(209, 'student_documents/1603721622road hump.png', '8_Road hump', '8', '4', 'y', 0, 'on', ''),
(210, 'student_documents/1603721659damp road.png', '8_Damp road', '8', '4', 'y', 0, 'on', ''),
(211, 'student_documents/1603721697hard shoulder.png', '8_Hard shoulder', '8', '4', 'y', 0, 'on', ''),
(212, 'student_documents/1603721729hard shoulder and hard line.png', '8_Hard shoulder and hard line', '8', '4', 'y', 0, 'on', ''),
(213, 'student_documents/1603721774lights_full_dipped_fog_sidelights.png', '8_Lights', '8', '4', 'y', 0, 'on', ''),
(214, 'student_documents/1603721816pumping vehicle.png', '8_Pumping vehicle', '8', '4', 'y', 0, 'on', ''),
(215, 'student_documents/1603721994central reservation on dual carriageway.png', 'Central reservation on dual carriagway', '9', '4', 'y', 0, 'on', ''),
(216, 'student_documents/1603722054slip road.png', 'Slip road', '9', '4', 'y', 0, 'on', ''),
(217, 'student_documents/1603722084countdown marker.png', 'Countdown marker', '9', '4', 'y', 0, 'on', ''),
(218, 'student_documents/1603722123emergency refuge area.png', 'Emergency refuge area', '9', '4', 'y', 0, 'on', ''),
(219, 'student_documents/1603722159Gantries.png', 'Gantries', '9', '4', 'y', 0, 'on', ''),
(220, 'student_documents/1603722188marker post.png', 'Marker post', '9', '4', 'y', 0, 'on', ''),
(221, 'student_documents/1603722218SOS.png', 'SOS', '9', '4', 'y', 0, 'on', ''),
(222, 'student_documents/1603722244SOS calling.png', 'SOS Calling', '9', '4', 'y', 0, 'on', ''),
(223, 'student_documents/1603722280reflective studs.png', 'Reflective studs', '9', '4', 'y', 0, 'on', ''),
(224, 'student_documents/1603722311reflective studs explained.png', 'Reflective studs explained', '9', '4', 'y', 0, 'on', ''),
(225, 'student_documents/1603722350crawler lane.png', 'Crawler lane', '9', '4', 'y', 0, 'on', ''),
(226, 'student_documents/1603722392overtaking from right.png', 'Overtaking from right', '9', '4', 'y', 0, 'on', ''),
(227, 'student_documents/1603722425congession.png', 'Congession', '9', '4', 'y', 0, 'on', ''),
(228, 'student_documents/1603722952level crossing.png', 'Level crossing', '10', '4', 'y', 0, 'on', ''),
(229, 'student_documents/1603723000box juntion.png', 'Box juction', '10', '4', 'y', 0, 'on', ''),
(230, 'student_documents/1603723032directorn indicator.png', 'Direction indicator', '10', '4', 'y', 0, 'on', ''),
(231, 'student_documents/1603723093level crossing with barrier.png', 'Level crossing with barrier', '10', '4', 'y', 0, 'on', ''),
(232, 'student_documents/1603723126Level crossing symbols.png', 'Level crossing symbols', '10', '4', 'y', 0, 'on', ''),
(233, 'student_documents/1603723188entering in a property.png', 'Entering in a property', '10', '4', 'y', 0, 'on', ''),
(234, 'student_documents/1603723233Narrow central reservation.png', 'Narrow central reservation_1', '10', '4', 'y', 0, 'on', ''),
(235, 'student_documents/1603723266Narrow central reservation_2.png', 'Narrow central reservation_2', '10', '4', 'y', 0, 'on', ''),
(236, 'student_documents/1603723301reversing from main to side road.png', 'Reversing from main to side road', '10', '4', 'y', 0, 'on', ''),
(237, 'student_documents/1603723356Solid white line_cycle lane.png', 'Solid white line_cycle lane', '10', '4', 'y', 0, 'on', ''),
(238, 'student_documents/1603723413Solid & broken white line with cycle lane.png', 'Solid and broken white line_cycle lane', '10', '4', 'y', 0, 'on', ''),
(239, 'student_documents/1603723451swing out.png', 'Swing out', '10', '4', 'y', 0, 'on', ''),
(240, 'student_documents/1603723474stop line.png', 'Stop line', '10', '4', 'y', 0, 'on', ''),
(241, 'student_documents/1603723509Vehicle spreading salt.png', 'Vehicle spreading salt', '10', '4', 'y', 0, 'on', ''),
(242, 'student_documents/1603723535blue badge.png', 'Blue badge', '10', '4', 'y', 0, 'on', ''),
(243, 'student_documents/1603798259MOT Points.png', 'MOT Points', '12', '4', 'y', 0, 'on', ''),
(245, 'student_documents/1603798680Mouth_2_Mouth resuscitation.png', 'Mouth to mouth resuscitation', '13', '4', 'y', 0, 'on', ''),
(246, 'student_documents/1603799217warning lights.png', 'Warning lights', '13', '4', 'y', 0, 'on', ''),
(248, 'student_documents/1603799387brakeaway cable.png', 'Breakaway cable', '14', '4', 'y', 0, 'on', ''),
(249, 'student_documents/1603799411roof rack.png', 'Roof rack', '14', '4', 'y', 0, 'on', ''),
(250, 'student_documents/1603799432snaking.png', 'Snaking', '14', '4', 'y', 0, 'on', ''),
(251, 'student_documents/1603799458towbar stablizer.png', 'Towbar stablizer', '14', '4', 'y', 0, 'on', ''),
(252, 'student_documents/1603799481towbar.png', 'Towbar', '14', '4', 'y', 0, 'on', ''),
(253, 'student_documents/1603799503Trailer.png', 'Trailer', '14', '4', 'y', 0, 'on', ''),
(254, 'student_documents/1603800173caravan.png', 'Caravan', '14', '4', 'y', 0, 'on', ''),
(262, 'student_documents/1604577777L1_Alertness.pdf', 'L1_Alertness', '1', '1', 'y', 0, 'off', ''),
(264, 'student_documents/1604578122L2_Attitude.pdf', 'L_02_Attitude', '2', '1', 'y', 0, 'on', ''),
(265, 'student_documents/1604578371L3_Safety and your vehicle.pdf', 'L3_Safety and your vehicle', '3', '1', 'y', 0, 'on', ''),
(266, 'student_documents/1604578927L4_Safety margins.pdf', 'L4_Safety margins', '4', '1', 'y', 0, 'on', ''),
(269, 'student_documents/1604579822L5_Hazard awareness.pdf', 'L5_Hazard awareness', '5', '1', 'y', 0, 'on', ''),
(270, 'student_documents/1604678774L6_Vulnerable road users.pdf', 'L_06_Vulnerable road users', '6', '1', 'y', 0, 'on', ''),
(271, 'student_documents/1605092766L1_Alertness.pdf', 'test document', '26', '1', 'y', 0, 'on', ''),
(272, 'student_documents/1605092822L2_Attitude.pdf', 'test pdf', '26', '2', 'y', 0, 'on', ''),
(273, 'student_documents/160509289201_Introduction to Driving Theory Test.png', 'test', '26', '3', 'y', 0, 'on', ''),
(274, 'student_documents/160509291602_Ready to stop.png', 'test', '26', '4', 'y', 0, 'on', ''),
(275, 'student_documents/160509297102_CS_Attitude.mp4', 'test', '26', '5', 'y', 0, 'on', ''),
(276, 'student_documents/1629958058file_example_MP4_480_1_5MG.mp4', 'tteaet', '1', '2', 'y', 0, 'on', ''),
(278, 'student_documents/1629963562file_example_MP4_480_1_5MG.mp4', 'cdadfadf', '1', '2', 'y', 0, 'on', ''),
(279, 'student_documents/1629963590file_example_MP4_480_1_5MG.mp4', 'sfhgsfhsg', '1', '2', 'y', 0, 'on', ''),
(280, 'student_documents/1629963720file_example_MP4_480_1_5MG.mp4', 'jlkjklkl', '1', '2', 'y', 0, 'on', ''),
(284, 'student_documents/163067833613_Questions 1-10.m4v', '13_Questions 1-10', '13', '2', 'y', 0, 'on', ''),
(285, 'student_documents/163067865813_Questions 11-20.m4v', '13_Questions 11-20', '13', '2', 'y', 0, 'on', ''),
(286, 'student_documents/163067899213_Questions 21-30.m4v', '13Questions 21-30', '13', '2', 'y', 0, 'on', ''),
(287, 'student_documents/163092684413_Questions 31-40.m4v', '13_Questions 31-40', '13', '2', 'y', 0, 'on', ''),
(288, 'student_documents/163092718013_Questions 41-50.m4v', '13_Questions 41-50', '13', '2', 'y', 0, 'on', ''),
(289, 'student_documents/163092777413_Questions 51-58.m4v', '13_Questions 50-58', '13', '2', 'y', 0, 'on', ''),
(290, 'student_documents/1631267504Chapter 9 Ques 1-11.m4v', '9_Questions 1-11', '9', '2', 'y', 0, 'on', ''),
(291, 'student_documents/163169737109_QAs_12-22.m4v', '9_Questions_12-22', '9', '2', 'y', 0, 'on', ''),
(292, 'student_documents/1632066031screen-capture.webm', 'video', '84', '42', 'y', 0, 'on', ''),
(293, 'student_documents/1632389152Chptr 9 Ques 23-33(Updated).m4v', '09_Q&AS_23-33', '9', '2', 'y', 0, 'on', ''),
(294, 'student_documents/163239817809_QAs_34-44.m4v', '09_Q&AS_34-44', '9', '2', 'y', 0, 'on', ''),
(295, 'student_documents/163342482209_QAs_45-58.m4v', '09_Q&AS_45-58', '9', '2', 'y', 0, 'on', ''),
(296, 'student_documents/16343062932-er.pdf', 'nhhhh', '8', '5', 'y', 0, 'on', '');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

