buslogistics 11-25.sql

-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 27, 2019 at 05:59 PM
-- Server version: 10.4.8-MariaDB
-- PHP Version: 7.3.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `buslogistics`
--
CREATE DATABASE IF NOT EXISTS `buslogistics` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `buslogistics`;

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

--
-- Table structure for table `bus`
--

DROP TABLE IF EXISTS `bus`;
CREATE TABLE IF NOT EXISTS `bus` (
  `BusNumber` varchar(8) NOT NULL,
  `BusOwnerID` int(11) NOT NULL,
  `Active` int(1) DEFAULT 0,
  PRIMARY KEY (`BusNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bus`
--

INSERT INTO `bus` VALUES
('T100 WQG', 5, 1),
('T103 MOK', 11, 1),
('T105 RDG', 8, 1),
('T114 LPM', 15, 1),
('T115 AVL', 9, 1),
('T119 DTR', 1, 1),
('T124 SKK', 3, 1),
('T125 UTQ', 2, 1),
('T128 TLW', 11, 1),
('T129 QEG', 17, 1),
('T129 XVO', 18, 1),
('T140 DQS', 10, 0),
('T145 MUT', 18, 1),
('T149 YEB', 18, 0),
('T150 VYT', 1, 1),
('T156 FUG', 14, 1),
('T169 RTF', 2, 1),
('T171 TJX', 16, 1),
('T172 SXW', 18, 1),
('T176 EBT', 16, 1),
('T177 IXZ', 19, 1),
('T182 JWM', 16, 1),
('T183 OOH', 2, 1),
('T186 SDA', 5, 1),
('T186 XRC', 12, 1),
('T188 BKZ', 7, 1),
('T188 YRE', 16, 1),
('T196 ENT', 11, 1),
('T196 SNR', 3, 1),
('T199 SMO', 12, 0),
('T200 HJX', 16, 1),
('T202 LQX', 2, 1),
('T203 AOL', 2, 1),
('T203 SML', 15, 1),
('T212 OCT', 2, 1),
('T213 FPU', 3, 1),
('T214 HGL', 18, 1),
('T216 JQG', 2, 1),
('T223 IHJ', 2, 1),
('T223 MJB', 11, 1),
('T227 DGQ', 9, 1),
('T229 JNB', 7, 1),
('T229 NYY', 16, 1),
('T233 KUE', 17, 1),
('T237 HRK', 15, 1),
('T241 POJ', 2, 1),
('T251 SDR', 16, 1),
('T253 YYA', 17, 1),
('T259 AQJ', 5, 1),
('T263 PKD', 2, 1),
('T265 RWR', 20, 0),
('T269 IFR', 9, 1),
('T272 VBO', 2, 1),
('T280 SNE', 13, 1),
('T282 LTW', 1, 1),
('T286 JAN', 6, 1),
('T288 BVY', 13, 1),
('T289 HKF', 8, 1),
('T290 SPC', 4, 1),
('T290 TTK', 14, 1),
('T291 ENC', 8, 1),
('T292 EQJ', 5, 1),
('T296 ZLA', 3, 0),
('T299 BIJ', 5, 1),
('T300 QDH', 16, 1),
('T302 UXK', 13, 1),
('T304 YZL', 9, 1),
('T306 OPI', 15, 1),
('T307 ITR', 1, 1),
('T312 PKS', 17, 1),
('T316 FVU', 17, 1),
('T321 NPX', 2, 1),
('T321 NQZ', 1, 1),
('T321 PQY', 11, 1),
('T328 HEE', 1, 1),
('T330 OUX', 19, 1),
('T330 UHJ', 9, 1),
('T340 QKA', 9, 1),
('T341 INY', 4, 1),
('T341 UDD', 20, 0),
('T342 BNZ', 4, 1),
('T350 XSX', 17, 1),
('T352 AXJ', 16, 1),
('T357 JHJ', 7, 1),
('T361 ZPI', 1, 0),
('T362 VZH', 3, 1),
('T373 GST', 13, 1),
('T378 JBQ', 7, 1),
('T378 TOJ', 8, 1),
('T380 GRT', 6, 1),
('T384 QAK', 3, 1),
('T389 CUX', 3, 1),
('T403 LJT', 7, 1),
('T403 OJI', 17, 1),
('T405 VGR', 1, 1),
('T407 UWL', 3, 1),
('T408 XLR', 1, 1),
('T409 HPI', 9, 1),
('T412 NUH', 19, 1),
('T414 DOF', 11, 1),
('T419 GFZ', 14, 1),
('T419 TXI', 2, 1),
('T421 MOS', 8, 1),
('T422 NWW', 13, 1),
('T424 UPB', 13, 1),
('T424 WPQ', 13, 1),
('T425 BDA', 18, 1),
('T430 OQH', 11, 1),
('T431 EOE', 3, 1),
('T431 HII', 6, 1),
('T436 ZIB', 15, 1),
('T444 FGH', 1, 1),
('T444 SBH', 15, 1),
('T448 GYB', 19, 1),
('T456 OFT', 16, 1),
('T459 SAH', 7, 1),
('T462 OKS', 5, 1),
('T463 YZK', 14, 1),
('T466 NLI', 14, 1),
('T467 KBA', 17, 1),
('T468 OVD', 18, 1),
('T470 LYW', 6, 1),
('T471 ZDG', 7, 1),
('T472 EGB', 13, 0),
('T473 CQK', 12, 1),
('T473 IFX', 20, 1),
('T477 DVR', 1, 1),
('T478 XWJ', 13, 1),
('T481 MNR', 13, 1),
('T482 CPG', 8, 1),
('T484 NBY', 1, 1),
('T484 ZFV', 1, 1),
('T496 RIY', 8, 1),
('T498 ZJX', 6, 1),
('T500 RCT', 9, 1),
('T507 PCM', 19, 1),
('T511 JTB', 15, 1),
('T513 JHJ', 14, 1),
('T515 GWG', 12, 1),
('T521 GLM', 9, 1),
('T525 GTI', 8, 1),
('T526 VBA', 8, 1),
('T527 HAJ', 7, 1),
('T527 HJN', 13, 0),
('T531 TBV', 1, 1),
('T535 JVB', 3, 1),
('T541 HWS', 1, 1),
('T542 AUG', 1, 0),
('T542 DZX', 1, 1),
('T545 XPV', 8, 1),
('T548 DCF', 17, 1),
('T554 KYI', 2, 1),
('T555 JJJ', 1, 0),
('T560 UMX', 5, 1),
('T569 MFK', 2, 1),
('T569 SPZ', 3, 1),
('T571 GNL', 18, 1),
('T571 QBN', 7, 1),
('T574 PSL', 13, 1),
('T577 ZIY', 15, 1),
('T590 UAG', 10, 1),
('T596 ESC', 18, 1),
('T596 MSA', 11, 1),
('T606 JLK', 5, 1),
('T606 MKU', 9, 1),
('T608 WGH', 11, 1),
('T609 LHJ', 17, 1),
('T609 LNE', 15, 1),
('T613 SKO', 3, 1),
('T614 VYE', 20, 1),
('T616 ZMP', 17, 1),
('T624 QYZ', 3, 1),
('T628 MYL', 5, 1),
('T631 YAE', 20, 1),
('T635 MJB', 14, 1),
('T636 LOP', 15, 1),
('T646 BMG', 20, 1),
('T646 VYD', 16, 1),
('T648 VNJ', 11, 1),
('T649 BPH', 10, 1),
('T651 JRW', 2, 0),
('T653 CUO', 13, 1),
('T655 QYC', 16, 1),
('T657 BLC', 10, 0),
('T657 CXO', 4, 1),
('T659 DPF', 17, 1),
('T662 GNA', 2, 1),
('T664 IIB', 12, 1),
('T674 INS', 5, 1),
('T675 ABP', 8, 0),
('T675 YTI', 12, 1),
('T676 BYE', 18, 1),
('T677 AEP', 17, 1),
('T682 GON', 5, 1),
('T682 UHP', 18, 1),
('T685 LYH', 17, 1),
('T687 SOP', 14, 1),
('T691 EYD', 5, 1),
('T694 JJG', 3, 1),
('T699 SLV', 10, 1),
('T702 HQD', 5, 1),
('T711 ONX', 6, 1),
('T712 QPI', 4, 1),
('T714 BVS', 12, 1),
('T718 YWH', 12, 1),
('T721 ZMQ', 12, 1),
('T722 JMA', 9, 1),
('T726 JCP', 12, 1),
('T733 WUO', 17, 1),
('T737 BAW', 17, 1),
('T739 OJQ', 8, 1),
('T739 RWE', 1, 1),
('T746 DAP', 5, 1),
('T747 VQD', 2, 1),
('T748 RUE', 15, 1),
('T749 TCE', 9, 1),
('T752 JLP', 9, 1),
('T754 WMU', 2, 1),
('T755 CHO', 11, 1),
('T757 KOF', 17, 1),
('T760 YVD', 3, 1),
('T761 KHD', 4, 1),
('T761 VHT', 20, 1),
('T762 LLR', 7, 1),
('T764 BGD', 12, 1),
('T764 IRJ', 8, 1),
('T769 KZM', 9, 1),
('T770 BCE', 7, 0),
('T770 YZO', 17, 1),
('T771 HBV', 18, 1),
('T774 UVT', 14, 1),
('T774 UYN', 15, 1),
('T774 ZES', 11, 1),
('T778 DEV', 8, 1),
('T782 AZF', 5, 1),
('T784 HAT', 12, 1),
('T784 HIU', 12, 1),
('T786 LZE', 8, 1),
('T787 MWZ', 4, 1),
('T796 ZRL', 11, 1),
('T800 BZE', 12, 1),
('T803 NZL', 9, 1),
('T805 CDS', 13, 1),
('T805 GTS', 18, 1),
('T808 LZD', 5, 1),
('T808 VTG', 11, 1),
('T809 CTH', 13, 1),
('T810 DHF', 13, 1),
('T811 CWP', 5, 0),
('T814 SPC', 8, 1),
('T815 ASB', 6, 1),
('T821 KMB', 8, 1),
('T824 VHM', 10, 1),
('T825 TOS', 3, 1),
('T825 WLS', 6, 1),
('T826 ADT', 13, 1),
('T827 GIL', 7, 1),
('T835 TYS', 20, 1),
('T837 LZG', 11, 1),
('T839 KMN', 5, 1),
('T841 URU', 5, 0),
('T846 EDU', 8, 1),
('T846 FTA', 14, 1),
('T846 PRS', 16, 1),
('T848 EFG', 11, 1),
('T850 XSG', 17, 1),
('T851 ZQS', 4, 1),
('T852 IAB', 3, 1),
('T857 IWY', 17, 1),
('T858 PJG', 13, 1),
('T858 UHX', 11, 1),
('T861 BYY', 10, 1),
('T863 DUU', 14, 1),
('T863 GXC', 1, 1),
('T864 TQA', 10, 0),
('T875 HQU', 4, 1),
('T879 FPG', 13, 1),
('T883 VFG', 15, 1),
('T884 CUM', 3, 0),
('T887 KGY', 5, 1),
('T888 OLZ', 17, 1),
('T890 NNX', 1, 1),
('T890 XZT', 9, 1),
('T897 KXJ', 15, 1),
('T897 UIS', 16, 1),
('T899 ODT', 5, 1),
('T899 THO', 5, 1),
('T900 GDH', 8, 1),
('T910 DER', 7, 1),
('T913 RXM', 7, 1),
('T920 KPA', 15, 1),
('T922 TSQ', 17, 1),
('T924 BIF', 5, 1),
('T924 VDQ', 13, 1),
('T927 EUF', 8, 1),
('T928 KZE', 2, 1),
('T929 BUC', 1, 1),
('T929 GEV', 6, 1),
('T929 GKG', 6, 1),
('T931 ABX', 12, 1),
('T938 ABE', 17, 1),
('T939 OQL', 8, 1),
('T942 YFF', 2, 1),
('T956 DWW', 19, 1),
('T961 MXJ', 20, 1),
('T962 ELT', 6, 1),
('T964 ZBU', 5, 1),
('T966 RWS', 18, 1),
('T970 IEM', 16, 1),
('T971 KFT', 19, 1),
('T971 YED', 4, 1),
('T977 MGM', 19, 1),
('T978 TGH', 11, 1),
('T980 VOA', 11, 1),
('T988 CNM', 9, 1),
('T991 JMA', 5, 1),
('T993 SPW', 18, 1),
('T995 FOU', 7, 1),
('T998 ISO', 20, 1),
('T998 KJK', 16, 1),
('T998 ULZ', 6, 1),
('T000 LLL', 20, 0);

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

--
-- Table structure for table `driver`
--

DROP TABLE IF EXISTS `driver`;
CREATE TABLE IF NOT EXISTS `driver` (
  `DriverID` int(11) NOT NULL AUTO_INCREMENT,
  `FirstName` varchar(45) DEFAULT NULL,
  `LastName` varchar(45) DEFAULT NULL,
  `Username` varchar(45) DEFAULT NULL,
  `Password` varchar(100) DEFAULT NULL,
  `PhoneNumber` varchar(15) DEFAULT NULL,
  `AssignedBus` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`DriverID`),
  KEY `AssignedBus_idx` (`AssignedBus`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `driver`
--

INSERT INTO `driver` VALUES
(1, 'Boniface', 'Kavishe', 'bkavishe', 'bkav27299', '629327299', 'T444 FGH'),
(2, 'Maria', 'Massawe', 'mmassawe', 'mmas70042', '671070042', 'T995 FOU'),
(3, 'Agnes', 'Seif', 'aseif', 'asei51673', '613751673', 'T171 TJX'),
(4, 'Subira', 'Mwinyi', 'smwinyi', 'smwi85965', '652985965', 'T887 KGY'),
(5, 'Charles', 'Mohamed', 'cmohamed', 'cmoh69567', '650069567', 'T814 SPC'),
(6, 'Juma', 'Mohamed', 'jmohamed', 'jmoh80824', '746480824', 'T237 HRK'),
(7, 'Agnes', 'Kikwete', 'akikwete', 'akik75759', '639575759', 'T970 IEM'),
(8, 'Karimu', 'Mkapa', 'kmkapa', 'kmka21932', '638521932', 'T815 ASB'),
(9, 'Christopher', 'Nayar', 'cnayar', 'cnay27947', '744227947', 'T988 CNM'),
(10, 'Nderi', 'Ndungai', 'nndungai', 'nndu41882', '737341882', 'T478 XWJ'),
(11, 'Mwanaidi', 'Riwa', 'mriwa', 'mriw17003', '746017003', 'T253 YYA'),
(12, 'Ridhiwani', 'Kavishe', 'rkavishe', 'rkav78596', '640878596', 'T924 VDQ'),
(13, 'Ridhiwani', 'Mohamed', 'rmohamed', 'rmoh39035', '762939035', 'T330 UHJ'),
(14, 'Faith', 'Minja', 'fminja', 'fmin55693', '751755693', 'T223 MJB'),
(15, 'John', 'Moshi', 'jmoshi', 'jmos41608', '644341608', 'T931 ABX'),
(16, 'Malaki', 'Mhagama', 'mmhagama', 'mmha18221', '773718221', 'T769 KZM'),
(17, 'Agnes', 'Kaseja', 'akaseja', 'akas77848', '623177848', 'T699 SLV'),
(18, 'Malaika', 'Khambaita', 'mkhambaita', 'mkha89257', '631689257', 'T527 HJN'),
(19, 'Musa', 'Mbilinyi', 'mmbilinyi', 'mmbi30916', '682630916', 'T900 GDH'),
(20, 'Malaki', 'Mwinyi', 'mmwinyi', 'mmwi73747', '748073747', 'T863 GXC'),
(21, 'Flora', 'Moshi', 'fmoshi', 'fmos37598', '687637598', 'T809 CTH'),
(22, 'Juma', 'Mashingia', 'jmashingia', 'jmas01753', '741401753', 'T966 RWS'),
(23, 'Musa', 'Lyimo', 'mlyimo', 'mlyi98421', '783998421', 'T784 HAT'),
(24, 'Olivia', 'Moshi', 'omoshi', 'omos26323', '718026323', 'T848 EFG'),
(25, 'Farida', 'Massawe', 'fmassawe', 'fmas00407', '771800407', 'T927 EUF'),
(26, 'Patricia', 'Mohamed', 'pmohamed', 'pmoh96515', '686096515', 'T737 BAW'),
(27, 'Musa', 'Minja', 'mminja', 'mmin05817', '634805817', 'T200 HJX'),
(28, 'Malaki', 'Mohamed', 'mmohamed', 'mmoh33774', '769133774', 'T613 SKO'),
(29, 'Ramla', 'Mhagama', 'rmhagama', 'rmha37017', '737937017', 'T569 MFK'),
(30, 'Neema', 'Massawe', 'nmassawe', 'nmas43384', '788843384', 'T328 HEE'),
(31, 'Tumaini', 'Riwa', 'triwa', 'triw87188', '676487188', 'T229 NYY'),
(32, 'Phillip', 'Mkapa', 'pmkapa', 'pmka90641', '619690641', 'T541 HWS'),
(33, 'Yohanyi', 'Ndungai', 'yndungai', 'yndu62506', '775262506', 'T341 INY'),
(34, 'Mwajuma', 'Nyerere', 'mnyerere', 'mnye73844', '672373844', 'T749 TCE'),
(35, 'Karimu', 'Mosha', 'kmosha', 'kmos80528', '775280528', 'T754 WMU'),
(36, 'Maria', 'Kahama', 'mkahama', 'mkah82771', '641782771', 'T805 CDS'),
(37, 'Maria', 'Kahama', 'mkahama', 'mkah98212', '745998212', 'T302 UXK'),
(38, 'Olivia', 'Ndungai', 'ondungai', 'ondu23701', '612823701', 'T657 BLC'),
(39, 'Olivia', 'Khambaita', 'okhambaita', 'okha55145', '746255145', 'T888 OLZ'),
(40, 'Neema', 'Minja', 'nminja', 'nmin12629', '764512629', 'T330 OUX'),
(41, 'Juma', 'Kavishe', 'jkavishe', 'jkav29467', '631829467', 'T378 JBQ'),
(42, 'Flora', 'Mwinyi', 'fmwinyi', 'fmwi75396', '736775396', 'T774 ZES'),
(43, 'Subira', 'Seif', 'sseif', 'ssei35249', '683335249', 'T803 NZL'),
(44, 'Faith', 'Moshi', 'fmoshi', 'fmos71628', '730471628', 'T837 LZG'),
(45, 'Charles', 'Khambaita', 'ckhambaita', 'ckha32991', '620132991', 'T500 RCT'),
(46, 'Ben', 'Riwa', 'briwa', 'briw96791', '782896791', 'T124 SKK'),
(47, 'Boniface', 'Khambaita', 'bkhambaita', 'bkha86273', '656286273', 'T408 XLR'),
(48, 'Patricia', 'Massawe', 'pmassawe', 'pmas63736', '723363736', 'T890 XZT'),
(49, 'Juma', 'Riwa', 'jriwa', 'jriw14322', '783114322', 'T103 MOK'),
(50, 'Karimu', 'Kaseja', 'kkaseja', 'kkas21236', '787221236', 'T459 SAH'),
(51, 'Tumaini', 'Kahama', 'tkahama', 'tkah91307', '644391307', 'T606 JLK'),
(52, 'Patricia', 'Nyerere', 'pnyerere', 'pnye71876', '677171876', 'T531 TBV'),
(53, 'Christopher', 'Mohamed', 'cmohamed', 'cmoh15975', '763115975', 'T362 VZH'),
(54, 'Juma', 'Kaseja', 'jkaseja', 'jkas34603', '649634603', 'T272 VBO'),
(55, 'Ramla', 'Nyerere', 'rnyerere', 'rnye75116', '681475116', 'T304 YZL'),
(56, 'Christopher', 'Kavishe', 'ckavishe', 'ckav48118', '784148118', 'T899 ODT'),
(57, 'Mwajuma', 'Mhagama', 'mmhagama', 'mmha07330', '744707330', 'T229 JNB'),
(58, 'Ramla', 'Minja', 'rminja', 'rmin73846', '742173846', 'T227 DGQ'),
(59, 'Tumaini', 'Macha', 'tmacha', 'tmac87514', '767687514', 'T662 GNA'),
(60, 'Patricia', 'Kahama', 'pkahama', 'pkah99894', '647999894', 'T764 BGD'),
(61, 'John', 'Kikwete', 'jkikwete', 'jkik17608', '620617608', 'T778 DEV'),
(62, 'Tumaini', 'Bayi', 'tbayi', 'tbay35314', '622835314', 'T203 AOL'),
(63, 'Sarafina', 'Mwinyi', 'smwinyi', 'smwi85967', '680785967', 'T646 VYD'),
(64, 'Tumaini', 'Lyimo', 'tlyimo', 'tlyi50148', '643450148', 'T361 ZPI'),
(65, 'John', 'Mosha', 'jmosha', 'jmos95425', '621595425', 'T971 KFT'),
(66, 'Agnes', 'Riwa', 'ariwa', 'ariw96387', '725196387', 'T462 OKS'),
(67, 'Faith', 'Mohamed', 'fmohamed', 'fmoh18245', '787118245', 'T119 DTR'),
(68, 'Ridhiwani', 'Massawe', 'rmassawe', 'rmas60203', '758560203', 'T757 KOF'),
(69, 'Phillip', 'Mosha', 'pmosha', 'pmos81086', '750281086', 'T733 WUO'),
(70, 'Yohanyi', 'Macha', 'ymacha', 'ymac65320', '734565320', 'T875 HQU'),
(71, 'Ridhiwani', 'Nyerere', 'rnyerere', 'rnye47633', '661547633', 'T299 BIJ'),
(72, 'Phillip', 'Ndungai', 'pndungai', 'pndu58776', '780358776', 'T858 PJG'),
(73, 'Mwajuma', 'Minja', 'mminja', 'mmin39904', '681639904', 'T389 CUX'),
(74, 'Maria', 'Bayi', 'mbayi', 'mbay36350', '656036350', 'T463 YZK'),
(75, 'Sara', 'Mwinyi', 'smwinyi', 'smwi77517', '772877517', 'T186 XRC'),
(76, 'Christopher', 'Mosha', 'cmosha', 'cmos31835', '636331835', 'T321 PQY'),
(77, 'Juma', 'Mbilinyi', 'jmbilinyi', 'jmbi19776', '778219776', 'T286 JAN'),
(78, 'Mwanaidi', 'Mohamed', 'mmohamed', 'mmoh35015', '622335015', 'T105 RDG'),
(79, 'Ridhiwani', 'Mbilinyi', 'rmbilinyi', 'rmbi39674', '666739674', 'T289 HKF'),
(80, 'Olivia', 'Bayi', 'obayi', 'obay95890', '622695890', 'T484 ZFV'),
(81, 'Phillip', 'Khambaita', 'pkhambaita', 'pkha56794', '786056794', 'T574 PSL'),
(82, 'Farida', 'Mushi', 'fmushi', 'fmus00264', '716200264', 'T721 ZMQ'),
(83, 'Olivia', 'Kaseja', 'okaseja', 'okas23363', '759923363', 'T929 BUC'),
(84, 'Neema', 'Bayi', 'nbayi', 'nbay89045', '772989045', 'T380 GRT'),
(85, 'Yohanyi', 'Khambaita', 'ykhambaita', 'ykha68031', '615868031', 'T542 AUG'),
(86, 'Subira', 'Kikwete', 'skikwete', 'skik25725', '671325725', 'T702 HQD'),
(87, 'Sara', 'Massawe', 'smassawe', 'smas08282', '767408282', 'T525 GTI'),
(88, 'Olivia', 'Kavishe', 'okavishe', 'okav76497', '664876497', 'T182 JWM'),
(89, 'Neema', 'Mashingia', 'nmashingia', 'nmas80099', '777080099', 'T755 CHO'),
(90, 'Aika', 'Moshi', 'amoshi', 'amos38648', '738438648', 'T682 GON'),
(91, 'Christopher', 'Bayi', 'cbayi', 'cbay01350', '660601350', 'T513 JHJ'),
(92, 'Karimu', 'Bayi', 'kbayi', 'kbay25342', '657725342', 'T403 OJI'),
(93, 'Subira', 'Riwa', 'sriwa', 'sriw87987', '675487987', 'T357 JHJ'),
(94, 'Neema', 'Macha', 'nmacha', 'nmac62126', '720262126', 'T456 OFT'),
(95, 'Farida', 'Minja', 'fminja', 'fmin83231', '669783231', 'T646 BMG'),
(96, 'Maria', 'Mushi', 'mmushi', 'mmus44599', '771044599', 'T761 KHD'),
(97, 'Nderi', 'Nayar', 'nnayar', 'nnay52786', '615752786', 'T694 JJG'),
(98, 'Karimu', 'Minja', 'kminja', 'kmin76593', '781676593', 'T676 BYE'),
(99, 'Juma', 'Bayi', 'jbayi', 'jbay89262', '685189262', 'T624 QYZ'),
(100, 'Flora', 'Macha', 'fmacha', 'fmac46154', '769546154', 'T826 ADT'),
(101, 'Subira', 'Mohamed', 'smohamed', 'smoh84527', '638584527', 'T649 BPH'),
(102, 'Ridhiwani', 'Mkapa', 'rmkapa', 'rmka32992', '669832992', 'T674 INS'),
(103, 'Ramla', 'Minja', 'rminja', 'rmin39934', '748239934', 'T125 UTQ'),
(104, 'Christopher', 'Kavishe', 'ckavishe', 'ckav37165', '623537165', 'T172 SXW'),
(105, 'Mwanaidi', 'Mkapa', 'mmkapa', 'mmka65677', '758465677', 'T850 XSG'),
(106, 'Karimu', 'Lyimo', 'klyimo', 'klyi93034', '764893034', 'T280 SNE'),
(107, 'Sarafina', 'Nayar', 'snayar', 'snay92632', '615192632', 'T978 TGH'),
(108, 'John', 'Nyerere', 'jnyerere', 'jnye11861', '783211861', 'T471 ZDG'),
(109, 'Faith', 'Massawe', 'fmassawe', 'fmas61141', '633761141', 'T863 DUU'),
(110, 'Phillip', 'Seif', 'pseif', 'psei43670', '681243670', 'T129 XVO'),
(111, 'Ben', 'Bayi', 'bbayi', 'bbay85679', '762985679', 'T176 EBT'),
(112, 'Malaki', 'Mushi', 'mmushi', 'mmus72605', '741572605', 'T956 DWW'),
(113, 'Nderi', 'Kahama', 'nkahama', 'nkah12497', '619612497', 'T571 GNL'),
(114, 'Juma', 'Kikwete', 'jkikwete', 'jkik77168', '660477168', 'T259 AQJ'),
(115, 'Gift', 'Kaseja', 'gkaseja', 'gkas36815', '614836815', 'T202 LQX'),
(116, 'Ben', 'Minja', 'bminja', 'bmin90647', '751590647', 'T939 OQL'),
(117, 'Christopher', 'Mashingia', 'cmashingia', 'cmas75705', '611775705', 'T942 YFF'),
(118, 'Gift', 'Kavishe', 'gkavishe', 'gkav10177', '714510177', 'T808 LZD'),
(119, 'Mwanaidi', 'Mkapa', 'mmkapa', 'mmka42309', '633842309', 'T852 IAB'),
(120, 'Yohanyi', 'Moshi', 'ymoshi', 'ymos15144', '673115144', 'T470 LYW'),
(121, 'Mwanaidi', 'Mohamed', 'mmohamed', 'mmoh00161', '660900161', 'T808 VTG'),
(122, 'Mwanaidi', 'Mbilinyi', 'mmbilinyi', 'mmbi52500', '630952500', 'T841 URU'),
(123, 'Olivia', 'Bayi', 'obayi', 'obay86767', '729286767', 'T140 DQS'),
(124, 'Mwajuma', 'Massawe', 'mmassawe', 'mmas32475', '621932475', 'T169 RTF'),
(125, 'Juma', 'Mushi', 'jmushi', 'jmus19200', '630219200', 'T998 ULZ'),
(126, 'Faith', 'Mohamed', 'fmohamed', 'fmoh75542', '772475542', 'T861 BYY'),
(127, 'Neema', 'Minja', 'nminja', 'nmin03308', '731203308', 'T653 CUO'),
(128, 'Farida', 'Khambaita', 'fkhambaita', 'fkha78983', '759878983', 'T770 YZO'),
(129, 'Farida', 'Lyimo', 'flyimo', 'flyi66424', '752066424', 'T407 UWL'),
(130, 'Gift', 'Khambaita', 'gkhambaita', 'gkha40921', '634640921', 'T609 LHJ'),
(131, 'Ridhiwani', 'Mhagama', 'rmhagama', 'rmha04759', '738904759', 'T352 AXJ'),
(132, 'Juma', 'Kaseja', 'jkaseja', 'jkas64982', '774964982', 'T290 SPC'),
(133, 'Nderi', 'Nayar', 'nnayar', 'nnay44232', '623844232', 'T421 MOS'),
(134, 'Phillip', 'Mushi', 'pmushi', 'pmus54200', '635754200', 'T448 GYB'),
(135, 'Malaika', 'Kikwete', 'mkikwete', 'mkik32607', '666832607', 'T507 PCM'),
(136, 'Mwajuma', 'Kikwete', 'mkikwete', 'mkik82816', '669682816', 'T403 LJT'),
(137, 'Farida', 'Seif', 'fseif', 'fsei12321', '776712321', 'T771 HBV'),
(138, 'Mwajuma', 'Kikwete', 'mkikwete', 'mkik92234', '743492234', 'T312 PKS'),
(139, 'Ridhiwani', 'Mwinyi', 'rmwinyi', 'rmwi82452', '618782452', 'T964 ZBU'),
(140, 'Mwanaidi', 'Mosha', 'mmosha', 'mmos76271', '662776271', 'T560 UMX'),
(141, 'Patricia', 'Mkapa', 'pmkapa', 'pmka82840', '752482840', 'T291 ENC'),
(142, 'Flora', 'Ndungai', 'fndungai', 'fndu27995', '633827995', 'T199 SMO'),
(143, 'Juma', 'Lyimo', 'jlyimo', 'jlyi58532', '656358532', 'T596 MSA'),
(144, 'John', 'Nayar', 'jnayar', 'jnay01118', '773101118', 'T924 BIF'),
(145, 'Nderi', 'Mushi', 'nmushi', 'nmus60739', '775460739', 'T682 UHP'),
(146, 'Ben', 'Bayi', 'bbayi', 'bbay08849', '763108849', 'T913 RXM'),
(147, 'Mwajuma', 'Minja', 'mminja', 'mmin76474', '780376474', 'T150 VYT'),
(148, 'Farida', 'Mwinyi', 'fmwinyi', 'fmwi74871', '633574871', 'T980 VOA'),
(149, 'Faith', 'Lyimo', 'flyimo', 'flyi72977', '765872977', 'T747 VQD'),
(150, 'Tumaini', 'Ndungai', 'tndungai', 'tndu47727', '762847727', 'T787 MWZ'),
(151, 'John', 'Mkapa', 'jmkapa', 'jmka22894', '663322894', 'T928 KZE'),
(152, 'Karimu', 'Minja', 'kminja', 'kmin31330', '776431330', 'T128 TLW'),
(153, 'Farida', 'Khambaita', 'fkhambaita', 'fkha03818', '742203818', 'T196 SNR'),
(154, 'Karimu', 'Lyimo', 'klyimo', 'klyi84621', '769884621', 'T714 BVS'),
(155, 'Charles', 'Mwinyi', 'cmwinyi', 'cmwi43937', '786943937', 'T677 AEP'),
(156, 'Malaika', 'Kikwete', 'mkikwete', 'mkik67950', '720167950', 'T675 ABP'),
(157, 'Patricia', 'Mwinyi', 'pmwinyi', 'pmwi80701', '782880701', 'T899 THO'),
(158, 'Nderi', 'Kahama', 'nkahama', 'nkah88659', '657088659', 'T961 MXJ'),
(159, 'Sara', 'Riwa', 'sriwa', 'sriw49684', '658349684', 'T444 SBH'),
(160, 'John', 'Mohamed', 'jmohamed', 'jmoh05237', '729305237', 'T929 GEV'),
(161, 'Aika', 'Mkapa', 'amkapa', 'amka84794', '766484794', 'T212 OCT'),
(162, 'Patricia', 'Moshi', 'pmoshi', 'pmos50252', '627150252', 'T129 QEG'),
(163, 'Farida', 'Riwa', 'friwa', 'friw06226', '638306226', 'T292 EQJ'),
(164, 'Farida', 'Kaseja', 'fkaseja', 'fkas65569', '681665569', 'T203 SML'),
(165, 'Aika', 'Mhagama', 'amhagama', 'amha55430', '754755430', 'T635 MJB'),
(166, 'Malaika', 'Kaseja', 'mkaseja', 'mkas83529', '770183529', 'T910 DER'),
(167, 'Subira', 'Kaseja', 'skaseja', 'skas59919', '777359919', 'T648 VNJ'),
(168, 'Malaika', 'Ndungai', 'mndungai', 'mndu73583', '677173583', 'T498 ZJX'),
(169, 'Patricia', 'Macha', 'pmacha', 'pmac22709', '779322709', 'T545 XPV'),
(170, 'Flora', 'Riwa', 'friwa', 'friw15740', '746215740', 'T515 GWG'),
(171, 'Maria', 'Kavishe', 'mkavishe', 'mkav52166', '613652166', 'T664 IIB'),
(172, 'Christopher', 'Nayar', 'cnayar', 'cnay08215', '622508215', 'T527 HAJ'),
(173, 'Faith', 'Bayi', 'fbayi', 'fbay98160', '627398160', 'T241 POJ'),
(174, 'Farida', 'Mosha', 'fmosha', 'fmos18853', '729918853', 'T321 NQZ'),
(175, 'Tumaini', 'Mbilinyi', 'tmbilinyi', 'tmbi21865', '671921865', 'T920 KPA'),
(176, 'Malaika', 'Massawe', 'mmassawe', 'mmas83715', '655583715', 'T897 KXJ'),
(177, 'Subira', 'Riwa', 'sriwa', 'sriw94133', '739994133', 'T482 CPG'),
(178, 'Malaki', 'Khambaita', 'mkhambaita', 'mkha25159', '640925159', 'T419 GFZ'),
(179, 'Ramla', 'Moshi', 'rmoshi', 'rmos59779', '755159779', 'T431 HII'),
(180, 'Tumaini', 'Kahama', 'tkahama', 'tkah51226', '677451226', 'T496 RIY'),
(181, 'Mwanaidi', 'Kikwete', 'mkikwete', 'mkik55604', '614455604', 'T846 EDU'),
(182, 'Malaki', 'Mashingia', 'mmashingia', 'mmas72687', '732172687', 'T484 NBY'),
(183, 'Juma', 'Kahama', 'jkahama', 'jkah63380', '784163380', 'T340 QKA'),
(184, 'Sarafina', 'Seif', 'sseif', 'ssei07073', '711607073', 'T722 JMA'),
(185, 'Faith', 'Kavishe', 'fkavishe', 'fkav07911', '634107911', 'T782 AZF'),
(186, 'Flora', 'Macha', 'fmacha', 'fmac23463', '773323463', 'T290 TTK'),
(187, 'John', 'Mohamed', 'jmohamed', 'jmoh09298', '666709298', 'T796 ZRL'),
(188, 'Yohanyi', 'Riwa', 'yriwa', 'yriw39461', '678739461', 'T687 SOP'),
(189, 'Flora', 'Massawe', 'fmassawe', 'fmas67817', '756767817', 'T846 FTA'),
(190, 'Christopher', 'Mashingia', 'cmashingia', 'cmas60511', '612660511', 'T890 NNX'),
(191, 'Maria', 'Seif', 'mseif', 'msei93175', '769393175', 'T839 KMN'),
(192, 'Farida', 'Khambaita', 'fkhambaita', 'fkha13156', '617713156', 'T726 JCP'),
(193, 'Karimu', 'Mashingia', 'kmashingia', 'kmas26842', '741026842', 'T214 HGL'),
(194, 'Nderi', 'Seif', 'nseif', 'nsei13917', '779813917', 'T177 IXZ'),
(195, 'Charles', 'Massawe', 'cmassawe', 'cmas02511', '667102511', 'T251 SDR'),
(196, 'Flora', 'Khambaita', 'fkhambaita', 'fkha72003', '627472003', 'T467 KBA'),
(197, 'Ramla', 'Mushi', 'rmushi', 'rmus45177', '733045177', 'T821 KMB'),
(198, 'Ramla', 'Mkapa', 'rmkapa', 'rmka17506', '687717506', 'T282 LTW'),
(199, 'Juma', 'Mashingia', 'jmashingia', 'jmas45753', '733445753', 'T596 ESC'),
(200, 'Charles', 'Moshi', 'cmoshi', 'cmos42899', '728542899', 'T879 FPG');

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

--
-- Table structure for table `owner`
--

DROP TABLE IF EXISTS `owner`;
CREATE TABLE IF NOT EXISTS `owner` (
  `OwnerID` int(11) NOT NULL AUTO_INCREMENT,
  `FirstName` varchar(45) DEFAULT NULL,
  `LastName` varchar(45) DEFAULT NULL,
  `Username` varchar(45) DEFAULT NULL,
  `Password` varchar(100) DEFAULT NULL,
  `PhoneNumber` varchar(15) DEFAULT NULL,
  `Active` int(1) DEFAULT 0,
  PRIMARY KEY (`OwnerID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `owner`
--

INSERT INTO `owner` VALUES
(1, 'Juma', 'Kavishe', 'jkavishe', 'jkav26769', '643826769', 1),
(2, 'Patricia', 'Minja', 'pminja', 'pmin66760', '642066760', 1),
(3, 'Neema', 'Lyimo', 'nlyimo', 'nlyi22913', '662422913', 1),
(4, 'Olivia', 'Mushi', 'omushi', 'omus63515', '650663515', 1),
(5, 'Aika', 'Khambaita', 'akhambaita', 'akha21224', '677521224', 1),
(6, 'John', 'Mohamed', 'jmohamed', 'jmoh60911', '659560911', 1),
(7, 'Subira', 'Mhagama', 'smhagama', 'smha59559', '681659559', 1),
(8, 'Yohanyi', 'Mashingia', 'ymashingia', 'ymas30343', '630830343', 1),
(9, 'Musa', 'Nayar', 'mnayar', 'mnay71423', '657071423', 1),
(10, 'Agnes', 'Mbilinyi', 'ambilinyi', 'ambi95803', '634695803', 1),
(11, 'Maria', 'Kahama', 'mkahama', 'mkah43624', '769343624', 1),
(12, 'Christopher', 'Mwinyi', 'cmwinyi', 'cmwi28162', '656728162', 1),
(13, 'Ben', 'Nyerere', 'bnyerere', 'bnye99509', '643299509', 1),
(14, 'Karimu', 'Mkapa', 'kmkapa', 'kmka68904', '616868904', 1),
(15, 'Malaika', 'Kikwete', 'mkikwete', 'mkik91370', '787891370', 1),
(16, 'Anande', 'Swai', 'aswai', 'aswa74196', '714574196', 1),
(17, 'Salima', 'Kahama', 'skahama', 'skah30266', '722430266', 1),
(18, 'Sabrina', 'Omar', 'somar', 'soma89422', '734589422', 1),
(19, 'Sophia', 'Egan', 'segan', 'sega76837', '728976837', 1),
(20, 'Amani', 'Tarimo', 'atarimo', 'atar46745', '775046745', 1);

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

--
-- Table structure for table `route`
--

DROP TABLE IF EXISTS `route`;
CREATE TABLE IF NOT EXISTS `route` (
  `RouteCode` varchar(7) NOT NULL,
  `StartLocation` varchar(45) DEFAULT NULL,
  `EndLocation` varchar(45) DEFAULT NULL,
  `MorningNeed` int(11) DEFAULT NULL,
  `AfternoonNeed` int(11) DEFAULT NULL,
  PRIMARY KEY (`RouteCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `route`
--

INSERT INTO `route` VALUES
('DOU-KCM', 'Double Road', 'KCMC', 8, 8),
('DOU-KRI', 'Double Road', 'Kristo Mfalme', 5, 5),
('KCM-KRI', 'KCMC', 'Kristo Mfalme', 5, 8),
('KCM-MAI', 'KCMC', 'Mailisita', 5, 5),
('KCM-SHA', 'KCMC', 'Shanti Town', 5, 5),
('MAI-SAN', 'Mailisita', 'Sanya Juu', 5, 5),
('MAJ-KIB', 'Majengo', 'Kiboriloni', 5, 5),
('MAW-STE', 'Mawenzi', 'Stendi', 8, 8),
('SAN-BOM', 'Sanya Juu', 'Boma Ng\'ombe', 5, 5),
('SHA-SOW', 'Shanti Town', 'Soweto', 5, 5),
('SOW-MAI', 'Soweto', 'Mailisita', 5, 5),
('SOW-STE', 'Soweto', 'Stendi', 8, 8),
('STE-KCM', 'Stendi', 'KCMC', 8, 8),
('STE-KIB', 'Stendi', 'Kiboriloni', 5, 5),
('STE-MAJ', 'Stendi', 'Majengo', 5, 5);

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

--
-- Table structure for table `schedule`
--

DROP TABLE IF EXISTS `schedule`;
CREATE TABLE IF NOT EXISTS `schedule` (
  `ScheduleID` int(11) NOT NULL AUTO_INCREMENT,
  `ScheduleDate` date NOT NULL,
  `RouteCode` varchar(7) NOT NULL,
  `BusNumber` varchar(8) NOT NULL,
  `Run` varchar(2) NOT NULL,
  `Admin` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ScheduleID`),
  KEY `RouteCode_idx` (`RouteCode`),
  KEY `BusNumber_idx` (`BusNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=5544 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `schedule`
--

INSERT INTO `schedule` VALUES
(2, '2019-09-03', 'KCM-KRI', 'T995 FOU', 'AM', 0),
(4, '2019-09-03', 'KCM-KRI', 'T887 KGY', 'AM', 0),
(5, '2019-09-03', 'KCM-KRI', 'T814 SPC', 'AM', 0),
(6, '2019-09-03', 'KCM-KRI', 'T237 HRK', 'AM', 0),
(7, '2019-09-03', 'KCM-KRI', 'T970 IEM', 'PM', 0),
(8, '2019-09-03', 'KCM-KRI', 'T815 ASB', 'PM', 0),
(9, '2019-09-03', 'KCM-KRI', 'T988 CNM', 'PM', 0),
(10, '2019-09-03', 'KCM-KRI', 'T478 XWJ', 'PM', 0),
(11, '2019-09-03', 'KCM-KRI', 'T253 YYA', 'PM', 0),
(12, '2019-09-03', 'KCM-KRI', 'T924 VDQ', 'PM', 0),
(13, '2019-09-03', 'KCM-MAI', 'T330 UHJ', 'AM', 0),
(14, '2019-09-03', 'KCM-MAI', 'T223 MJB', 'AM', 0),
(15, '2019-09-03', 'KCM-MAI', 'T931 ABX', 'AM', 0),
(16, '2019-09-03', 'KCM-MAI', 'T769 KZM', 'AM', 0),
(17, '2019-09-03', 'KCM-MAI', 'T699 SLV', 'AM', 0),
(18, '2019-09-03', 'KCM-MAI', 'T527 HJN', 'PM', 0),
(19, '2019-09-03', 'KCM-MAI', 'T900 GDH', 'PM', 0),
(20, '2019-09-03', 'KCM-MAI', 'T863 GXC', 'PM', 0),
(21, '2019-09-03', 'KCM-MAI', 'T809 CTH', 'PM', 0),
(22, '2019-09-03', 'KCM-SHA', 'T966 RWS', 'AM', 0),
(23, '2019-09-03', 'KCM-SHA', 'T784 HAT', 'AM', 0),
(24, '2019-09-03', 'KCM-SHA', 'T848 EFG', 'AM', 0),
(25, '2019-09-03', 'KCM-SHA', 'T927 EUF', 'AM', 0),
(26, '2019-09-03', 'KCM-SHA', 'T737 BAW', 'AM', 0),
(27, '2019-09-03', 'KCM-SHA', 'T200 HJX', 'PM', 0),
(28, '2019-09-03', 'KCM-SHA', 'T613 SKO', 'PM', 0),
(29, '2019-09-03', 'KCM-SHA', 'T569 MFK', 'PM', 0),
(30, '2019-09-03', 'KCM-SHA', 'T328 HEE', 'PM', 0),
(31, '2019-09-03', 'KCM-SHA', 'T229 NYY', 'PM', 0),
(32, '2019-09-03', 'SOW-MAI', 'T541 HWS', 'AM', 0),
(33, '2019-09-03', 'SOW-MAI', 'T341 INY', 'AM', 0),
(34, '2019-09-03', 'SOW-MAI', 'T749 TCE', 'AM', 0),
(35, '2019-09-03', 'SOW-MAI', 'T754 WMU', 'AM', 0),
(36, '2019-09-03', 'SOW-MAI', 'T805 CDS', 'PM', 0),
(37, '2019-09-03', 'SOW-MAI', 'T302 UXK', 'PM', 0),
(38, '2019-09-03', 'SOW-MAI', 'T657 BLC', 'PM', 0),
(39, '2019-09-03', 'SOW-MAI', 'T888 OLZ', 'PM', 0),
(40, '2019-09-03', 'SOW-STE', 'T330 OUX', 'AM', 0),
(41, '2019-09-03', 'SOW-STE', 'T378 JBQ', 'AM', 0),
(42, '2019-09-03', 'SOW-STE', 'T774 ZES', 'AM', 0),
(43, '2019-09-03', 'SOW-STE', 'T803 NZL', 'AM', 0),
(44, '2019-09-03', 'SOW-STE', 'T837 LZG', 'AM', 0),
(45, '2019-09-03', 'SOW-STE', 'T500 RCT', 'AM', 0),
(46, '2019-09-03', 'SOW-STE', 'T124 SKK', 'PM', 0),
(47, '2019-09-03', 'SOW-STE', 'T408 XLR', 'PM', 0),
(48, '2019-09-03', 'SOW-STE', 'T890 XZT', 'PM', 0),
(49, '2019-09-03', 'SOW-STE', 'T103 MOK', 'PM', 0),
(50, '2019-09-03', 'SOW-STE', 'T459 SAH', 'PM', 0),
(51, '2019-09-03', 'SOW-STE', 'T606 JLK', 'PM', 0),
(52, '2019-09-03', 'SOW-STE', 'T531 TBV', 'AM', 0),
(53, '2019-09-03', 'SOW-STE', 'T362 VZH', 'PM', 0),
(54, '2019-09-03', 'STE-KIB', 'T272 VBO', 'AM', 0),
(55, '2019-09-03', 'STE-KIB', 'T304 YZL', 'AM', 0),
(56, '2019-09-03', 'STE-KIB', 'T899 ODT', 'AM', 0),
(57, '2019-09-03', 'STE-KIB', 'T229 JNB', 'AM', 0),
(58, '2019-09-03', 'STE-KIB', 'T227 DGQ', 'PM', 0),
(59, '2019-09-03', 'STE-KIB', 'T662 GNA', 'PM', 0),
(60, '2019-09-03', 'STE-KIB', 'T764 BGD', 'PM', 0),
(61, '2019-09-03', 'STE-KIB', 'T778 DEV', 'PM', 0),
(62, '2019-09-03', 'STE-KIB', 'T203 AOL', 'AM', 0),
(63, '2019-09-03', 'STE-KIB', 'T646 VYD', 'PM', 0),
(64, '2019-09-03', 'STE-MAJ', 'T361 ZPI', 'AM', 0),
(65, '2019-09-03', 'STE-MAJ', 'T971 KFT', 'AM', 0),
(66, '2019-09-03', 'STE-MAJ', 'T462 OKS', 'AM', 0),
(67, '2019-09-03', 'STE-MAJ', 'T119 DTR', 'AM', 0),
(68, '2019-09-03', 'STE-MAJ', 'T757 KOF', 'PM', 0),
(69, '2019-09-03', 'STE-MAJ', 'T733 WUO', 'PM', 0),
(70, '2019-09-03', 'STE-MAJ', 'T875 HQU', 'PM', 0),
(71, '2019-09-03', 'STE-MAJ', 'T299 BIJ', 'PM', 0),
(72, '2019-09-03', 'STE-MAJ', 'T858 PJG', 'AM', 0),
(73, '2019-09-03', 'STE-KCM', 'T389 CUX', 'AM', 0),
(74, '2019-09-03', 'STE-KCM', 'T463 YZK', 'AM', 0),
(75, '2019-09-03', 'STE-KCM', 'T186 XRC', 'AM', 0),
(76, '2019-09-03', 'STE-KCM', 'T321 PQY', 'AM', 0),
(77, '2019-09-03', 'STE-KCM', 'T286 JAN', 'AM', 0),
(78, '2019-09-03', 'STE-KCM', 'T105 RDG', 'AM', 0),
(79, '2019-09-03', 'STE-KCM', 'T289 HKF', 'AM', 0),
(80, '2019-09-03', 'STE-KCM', 'T484 ZFV', 'AM', 0),
(81, '2019-09-03', 'STE-KCM', 'T574 PSL', 'PM', 0),
(82, '2019-09-03', 'STE-KCM', 'T721 ZMQ', 'PM', 0),
(83, '2019-09-03', 'STE-KCM', 'T929 BUC', 'PM', 0),
(84, '2019-09-03', 'STE-KCM', 'T380 GRT', 'PM', 0),
(85, '2019-09-03', 'STE-KCM', 'T542 AUG', 'PM', 0),
(86, '2019-09-03', 'STE-KCM', 'T702 HQD', 'PM', 0),
(87, '2019-09-03', 'STE-KCM', 'T525 GTI', 'PM', 0),
(88, '2019-09-03', 'STE-KCM', 'T182 JWM', 'PM', 0),
(89, '2019-09-03', 'DOU-KRI', 'T755 CHO', 'AM', 0),
(90, '2019-09-03', 'DOU-KRI', 'T682 GON', 'AM', 0),
(91, '2019-09-03', 'DOU-KRI', 'T513 JHJ', 'AM', 0),
(92, '2019-09-03', 'DOU-KRI', 'T403 OJI', 'AM', 0),
(93, '2019-09-03', 'DOU-KRI', 'T357 JHJ', 'PM', 0),
(94, '2019-09-03', 'DOU-KRI', 'T456 OFT', 'PM', 0),
(95, '2019-09-03', 'DOU-KRI', 'T646 BMG', 'PM', 0),
(96, '2019-09-03', 'DOU-KRI', 'T761 KHD', 'PM', 0),
(97, '2019-09-03', 'DOU-KCM', 'T694 JJG', 'AM', 0),
(98, '2019-09-03', 'DOU-KCM', 'T676 BYE', 'AM', 0),
(99, '2019-09-03', 'DOU-KCM', 'T624 QYZ', 'AM', 0),
(100, '2019-09-03', 'DOU-KCM', 'T826 ADT', 'AM', 0),
(101, '2019-09-03', 'DOU-KCM', 'T649 BPH', 'AM', 0),
(102, '2019-09-03', 'DOU-KCM', 'T674 INS', 'AM', 0),
(103, '2019-09-03', 'DOU-KCM', 'T125 UTQ', 'AM', 0),
(104, '2019-09-03', 'DOU-KCM', 'T172 SXW', 'AM', 0),
(105, '2019-09-03', 'DOU-KCM', 'T850 XSG', 'PM', 0),
(106, '2019-09-03', 'DOU-KCM', 'T280 SNE', 'PM', 0),
(107, '2019-09-03', 'DOU-KCM', 'T978 TGH', 'PM', 0),
(108, '2019-09-03', 'DOU-KCM', 'T471 ZDG', 'PM', 0),
(109, '2019-09-03', 'DOU-KCM', 'T863 DUU', 'PM', 0),
(110, '2019-09-03', 'DOU-KCM', 'T129 XVO', 'PM', 0),
(111, '2019-09-03', 'DOU-KCM', 'T176 EBT', 'PM', 0),
(112, '2019-09-03', 'DOU-KCM', 'T956 DWW', 'PM', 0),
(113, '2019-09-03', 'SHA-SOW', 'T571 GNL', 'AM', 0),
(114, '2019-09-03', 'SHA-SOW', 'T259 AQJ', 'AM', 0),
(115, '2019-09-03', 'SHA-SOW', 'T202 LQX', 'AM', 0),
(116, '2019-09-03', 'SHA-SOW', 'T939 OQL', 'PM', 0),
(117, '2019-09-03', 'SHA-SOW', 'T942 YFF', 'PM', 0),
(118, '2019-09-03', 'SHA-SOW', 'T808 LZD', 'PM', 0),
(119, '2019-09-03', 'MAJ-KIB', 'T852 IAB', 'PM', 0),
(120, '2019-09-03', 'MAJ-KIB', 'T470 LYW', 'PM', 0),
(121, '2019-09-03', 'MAJ-KIB', 'T808 VTG', 'PM', 0),
(122, '2019-09-03', 'MAJ-KIB', 'T841 URU', 'PM', 0),
(123, '2019-09-03', 'MAJ-KIB', 'T140 DQS', 'PM', 0),
(124, '2019-09-03', 'MAJ-KIB', 'T169 RTF', 'PM', 0),
(125, '2019-09-03', 'MAJ-KIB', 'T998 ULZ', 'PM', 0),
(126, '2019-09-03', 'MAI-SAN', 'T861 BYY', 'AM', 0),
(127, '2019-09-03', 'MAI-SAN', 'T653 CUO', 'AM', 0),
(128, '2019-09-03', 'MAI-SAN', 'T770 YZO', 'AM', 0),
(129, '2019-09-03', 'MAI-SAN', 'T407 UWL', 'AM', 0),
(130, '2019-09-03', 'MAI-SAN', 'T609 LHJ', 'PM', 0),
(131, '2019-09-03', 'MAI-SAN', 'T352 AXJ', 'PM', 0),
(132, '2019-09-03', 'MAI-SAN', 'T290 SPC', 'PM', 0),
(133, '2019-09-03', 'MAI-SAN', 'T421 MOS', 'PM', 0),
(134, '2019-09-03', 'MAW-STE', 'T448 GYB', 'AM', 0),
(135, '2019-09-03', 'MAW-STE', 'T507 PCM', 'AM', 0),
(136, '2019-09-03', 'MAW-STE', 'T403 LJT', 'AM', 0),
(137, '2019-09-03', 'MAW-STE', 'T771 HBV', 'AM', 0),
(138, '2019-09-03', 'MAW-STE', 'T312 PKS', 'AM', 0),
(139, '2019-09-03', 'MAW-STE', 'T964 ZBU', 'AM', 0),
(140, '2019-09-03', 'MAW-STE', 'T560 UMX', 'PM', 0),
(141, '2019-09-03', 'MAW-STE', 'T291 ENC', 'PM', 0),
(142, '2019-09-03', 'MAW-STE', 'T199 SMO', 'PM', 0),
(143, '2019-09-03', 'MAW-STE', 'T596 MSA', 'PM', 0),
(144, '2019-09-03', 'MAW-STE', 'T924 BIF', 'PM', 0),
(145, '2019-09-03', 'MAW-STE', 'T682 UHP', 'PM', 0),
(146, '2019-09-03', 'SAN-BOM', 'T913 RXM', 'AM', 0),
(147, '2019-09-03', 'SAN-BOM', 'T150 VYT', 'AM', 0),
(148, '2019-09-03', 'SAN-BOM', 'T980 VOA', 'AM', 0),
(149, '2019-09-03', 'SAN-BOM', 'T747 VQD', 'AM', 0),
(150, '2019-09-03', 'SAN-BOM', 'T787 MWZ', 'PM', 0),
(151, '2019-09-03', 'SAN-BOM', 'T928 KZE', 'PM', 0),
(152, '2019-09-03', 'SAN-BOM', 'T128 TLW', 'PM', 0),
(153, '2019-09-03', 'SAN-BOM', 'T196 SNR', 'PM', 0),
(1405, '2019-11-23', 'DOU-KCM', 'T929 BUC', 'AM', 0),
(1406, '2019-11-03', 'DOU-KCM', 'T929 BUC', 'AM', 0),
(1407, '2019-11-24', 'DOU-KCM', 'T929 BUC', 'AM', 0),
(1408, '2019-11-25', 'DOU-KCM', 'T929 BUC', 'AM', 0),
(1409, '2019-11-26', 'DOU-KCM', 'T929 BUC', 'AM', 0),
(1410, '2019-11-27', 'DOU-KCM', 'T929 BUC', 'AM', 0),
(5507, '2019-11-23', 'DOU-KCM', 'T651 JRW', 'AM', 0),
(5508, '2019-11-24', 'DOU-KCM', 'T651 JRW', 'AM', 0),
(5509, '2019-11-25', 'DOU-KCM', 'T651 JRW', 'AM', 0),
(5510, '2019-11-26', 'DOU-KCM', 'T651 JRW', 'AM', 0),
(5511, '2019-11-27', 'DOU-KCM', 'T651 JRW', 'PM', 0),
(5512, '2019-11-28', 'DOU-KCM', 'T651 JRW', 'PM', 0),
(5513, '2019-11-29', 'DOU-KCM', 'T651 JRW', 'PM', 0),
(5515, '2019-12-01', 'DOU-KCM', 'T651 JRW', 'PM', 0),
(5537, '2019-12-02', 'SAN-BOM', 'T171 TJX', 'PM', 0),
(5538, '2019-12-03', 'SAN-BOM', 'T171 TJX', 'AM', 0),
(5539, '2019-12-04', 'SAN-BOM', 'T171 TJX', 'PM', 0),
(5540, '2019-12-05', 'SAN-BOM', 'T171 TJX', 'PM', 0),
(5541, '2019-12-06', 'SAN-BOM', 'T171 TJX', 'PM', 0),
(5542, '2019-12-07', 'SAN-BOM', 'T171 TJX', 'PM', 0),
(5543, '2019-12-08', 'SAN-BOM', 'T171 TJX', 'PM', 0);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `driver`
--
ALTER TABLE `driver`
  ADD CONSTRAINT `AssignedBus` FOREIGN KEY (`AssignedBus`) REFERENCES `bus` (`BusNumber`);

--
-- Constraints for table `schedule`
--
ALTER TABLE `schedule`
  ADD CONSTRAINT `BusNumber` FOREIGN KEY (`BusNumber`) REFERENCES `bus` (`BusNumber`),
  ADD CONSTRAINT `RouteCode` FOREIGN KEY (`RouteCode`) REFERENCES `route` (`RouteCode`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;