-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 03, 2019 at 10:24 AM
-- Server version: 5.0.41
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `kciascc`
-- 

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

-- 
-- Table structure for table `tbl_customer`
-- 

CREATE TABLE `tbl_customer` (
  `id` int(100) NOT NULL auto_increment,
  `membership` varchar(1000) NOT NULL default 'INDIVIDUAL MEMBER',
  `fname` varchar(1000) NOT NULL,
  `sname` varchar(1000) NOT NULL,
  `phone` varchar(1000) NOT NULL,
  `email` varchar(1000) NOT NULL,
  `dob` date NOT NULL,
  `idno` varchar(1000) NOT NULL,
  `company` varchar(1000) NOT NULL,
  `paddress` varchar(1000) NOT NULL,
  `town` varchar(1000) NOT NULL,
  `latt` varchar(1000) NOT NULL,
  `lng` varchar(1000) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `tbl_customer`
-- 

INSERT INTO `tbl_customer` (`id`, `membership`, `fname`, `sname`, `phone`, `email`, `dob`, `idno`, `company`, `paddress`, `town`, `latt`, `lng`) VALUES 
(1, 'INDIVIDUAL MEMBER', 'Betty', 'Kangatsi', '+254722396056', 'edwardmoenga003@gmail.com', '1983-11-03', '23018773', 'TheTech Co.', 'Mamangina Drive', 'MOMBASA', '-1.3092104107026732', '36.9201584905386');

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

-- 
-- Table structure for table `tbl_ecall`
-- 

CREATE TABLE `tbl_ecall` (
  `id` int(100) NOT NULL auto_increment,
  `custid` varchar(100) NOT NULL,
  `date` date NOT NULL,
  `long` varchar(100) NOT NULL,
  `latt` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_ecall`
-- 


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

-- 
-- Table structure for table `tbl_fback`
-- 

CREATE TABLE `tbl_fback` (
  `id` int(100) NOT NULL auto_increment,
  `custid` varchar(100) NOT NULL,
  `feedback` varchar(1000) NOT NULL,
  `fdate` date NOT NULL,
  `response` varchar(1000) NOT NULL,
  `rdate` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `tbl_fback`
-- 

INSERT INTO `tbl_fback` (`id`, `custid`, `feedback`, `fdate`, `response`, `rdate`) VALUES 
(1, '1', 'I have come to collect my vehicle twice and both times I was set to wait and did not get my vehicle. What is going on?', '2019-11-21', 'We sincerely apologize for the inconvinince caused. Please let us know which sales representative you dealt with so that we can followup on the issue.', '2019-11-22');

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

-- 
-- Table structure for table `tbl_fleet`
-- 

CREATE TABLE `tbl_fleet` (
  `id` int(100) NOT NULL auto_increment,
  `custid` varchar(100) NOT NULL,
  `vfleet` varchar(100) NOT NULL,
  `vin` varchar(100) NOT NULL,
  `regno` varchar(100) NOT NULL,
  `yor` varchar(100) NOT NULL,
  `isuzu` varchar(100) NOT NULL,
  `vmodel` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `tbl_fleet`
-- 

INSERT INTO `tbl_fleet` (`id`, `custid`, `vfleet`, `vin`, `regno`, `yor`, `isuzu`, `vmodel`) VALUES 
(1, '1', 'EXISTING FLEET', 'Q34521F67', 'KCW 264G', '2019', 'ISUZU', 'NQR66 BUS LUXURY 33 SEATER BODY(REINFORCED)'),
(2, '1', 'EXISTING FLEET', 'Q1323H6645', 'KCW 412F', '2019', 'ISUZU', 'NQR66 BUS LUXURY 33 SEATER BODY(REINFORCED)');

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

-- 
-- Table structure for table `tbl_model`
-- 

CREATE TABLE `tbl_model` (
  `id` int(100) NOT NULL auto_increment,
  `vmodel` varchar(1000) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `qdescription` varchar(1000) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=100 ;

-- 
-- Dumping data for table `tbl_model`
-- 

INSERT INTO `tbl_model` (`id`, `vmodel`, `description`, `qdescription`) VALUES 
(1, 'TFR 86 SC (HR + AC)', '(HR + AC)', 'New Isuzu TFR 86, 4x2 Single Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine newly launched Pick Up with its sleek High ride design, strong features, dependable suspension.'),
(2, 'TFR 86 SC (HR + AC) with insurance (HR + AC)', '(HR + AC)', 'New Isuzu TFR 86, 4x2 Single Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine newly launched Pick Up with its sleek High ride design, strong features, dependable suspension.'),
(3, 'TFR 86 SC (HR + AC+ AIR BAG)', '(HR + AC + AIR BAG)', 'New Isuzu TFR 86, 4x2 Single Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine Newly launched Pick Up with its sleek High ride design, strong features, dependable suspension.'),
(4, 'TFR 86 SC (HR + AC + AIR BAG) with insurance', '(HR + AC + AIR BAG) with insurance', 'New Isuzu TFR 86, 4x2 Single Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine Newly launched Pick Up with its sleek High ride design, strong features, dependable suspension.'),
(5, 'TFS 86 SC (HR + AC+ AIR BAG)', '(HR + AC+ AIR BAG)', 'New Isuzu TFR 86, 4x4 Single Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine Newly launched Pick Up with its sleek High ride design, strong features, dependable suspension.'),
(6, 'TFS 86 SC (HR + AC + AIR BAG) with insurance', '(HR + AC+ AIR BAG) with insurance', 'New Isuzu TFR 86, 4x4 Single Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine Newly launched Pick Up with its sleek High ride design, strong features, dependable suspension.'),
(7, 'TFS 86 DC DELUXE - UNACCESSORISED', 'DELUXE - UNACCESSORISED', 'New Isuzu TFS 86, 4X4 Double Cab 2.5CC, Base Powerful and fuel efficient Turbo charged engine, newly launched loaded pick-up with its sleek High Ride design, Strong features, Dependable suspension and AC. Inclusive of Inspection and Registration.'),
(8, 'TFS 86 DC DELUXE - UNACCESSORISED with insurance', 'UNACCESSORISED with insurance', 'New Isuzu TFS 86, 4X4 Double Cab 2.5CC, Base Powerful and fuel efficient Turbo charged engine, newly launched loaded pick-up with its sleek High Ride design, Strong features, Dependable suspension and AC. Inclusive of Inspection and Registration.'),
(9, 'TFS 86 DC DELUXE - ACCESSORISED', 'DELUXE - ACCESSORISED', 'New Isuzu TFR 86, 4x4 Double Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine Newly launched Pick Up with its sleek High ride design, strong features, dependable suspension, fitted with AC, Airbag.'),
(10, 'TFS 86 DC DELUXE - ACCESSORISED with insurance', 'ACCESSORISED with insurance', 'New Isuzu TFR 86, 4x4 Double Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine Newly launched Pick Up with its sleek High ride design, strong features, dependable suspension, fitted with AC, Airbag.'),
(11, 'TFS 85 DC LUXURY MANUAL - ACCESSORISED', 'LUXURY MANUAL - ACCESSORISED', 'New Isuzu TFR 86, 4x4 Accesorised Double Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine Newly launched Pick Up with its sleek High ride design, strong features, dependable suspension, fitted with AC, Airbag.'),
(12, 'TFS 85 DC LUXURY MANUAL - ACCESSORISED with insurance', 'ACCESSORISED with insurance', 'New Isuzu TFR 86, 4x4 Accesorised Double Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine Newly launched Pick Up with its sleek High ride design, strong features, dependable suspension, fitted with AC, Airbag.'),
(13, 'TFS 85 DC LUXURY AUTOMATIC - ACCESSORISED', 'LUXURY AUTOMATIC - ACCESSORISED', 'New Isuzu TFR 86, 4x4 Accesorised Double Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine Newly launched Pick Up with its sleek High ride design, strong features, dependable suspension, fitted with AC, Airbag.'),
(14, 'TFS 85 DC LUXURY AUTOMATIC - ACCESSORISED with insurance', 'ACCESSORISED with insurance', 'New Isuzu TFR 86, 4x4 Accesorised Double Cab 2.5 C.C powerful & fuel-efficient Turbo Charged Diesel Engine Newly launched Pick Up with its sleek High ride design, strong features, dependable suspension, fitted with AC, Airbag.'),
(15, 'ISUZU MUX SUV', 'SUV', 'New Isuzu MU-X, 4x4 SUV powerful & fuel-efficient Turbo Charged Diesel Engine 3-litre 130kW/380Nm, 6-speed transmission with 230mm of ground clearance and seven seats.'),
(16, 'ISUZU MUX with insurance', 'SUV with insurance', 'New Isuzu MU-X, 4x4 SUV powerful & fuel-efficient Turbo Charged Diesel Engine 3-litre 130kW/380Nm, 6-speed transmission with 230mm of ground clearance and seven seats.'),
(17, 'NHR TRUCK CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu NHR 55E, GVW 3.3 Ton Cab chassis only with 2.8 Litre 4JB1 diesel propelled engine'),
(18, 'NHR TRUCK ENCLOSED PLAIN BODY', 'ENCLOSED PLAIN BODY', 'New Isuzu NHR 55E, GVW 3.3 Ton Cab chassis with 2.8 Litre 4JB1 diesel propelled engine, complete with a fully enclosed truck body painted to preffered colours.'),
(19, 'NHR TRUCK FIXED HIGHSIDED', 'FIXED HIGHSIDED', 'New Isuzu NHR 55E, GVW 3.3 Ton Cab chassis with 2.8 Litre 4JB1 diesel propelled engine, complete with a fixed highsided truck body painted to preffered colours.'),
(20, 'NHR TRUCK LOW DROPSIDE', 'LOW DROPSIDE', 'New Isuzu NHR 55E, GVW 3.3 Ton Cab chassis with 2.8 Litre 4JB1 diesel propelled engine, complete with a low dropside truck body painted to preffered colours.'),
(21, 'NHR TRUCK HIGH DROPSIDE', 'HIGH DROPSIDE', 'New Isuzu NHR 55E, GVW 3.3 Ton Cab chassis with 2.8 Litre 4JB1 diesel propelled engine, complete with a high dropside truck body painted to preffered colours.'),
(22, 'NHR TRUCK ENCLOSED CORRUGATED BODY', 'ENCLOSED CORRUGATED BODY', 'New Isuzu NHR 55E, GVW 3.3 Ton Cab chassis with 2.8 Litre 4JB1 diesel propelled engine, complete with an enclosed corrugated truck body and painted to preffered colours.'),
(23, 'NKR TRUCK - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu NKR 66L, 4x2, GVM 5.7 Tons Cab chassis only with a diesel propelled engine.'),
(24, 'NKR TRUCK ENCLOSED PLAIN BODY', 'ENCLOSED PLAIN BODY', 'New Isuzu NKR 66L, 4x2, GVM 5.7 Tons Cab chassis with an enclosed plain body and a diesel propelled engine.'),
(25, 'NKR TRUCK FIXED HIGHSIDED', 'FIXED HIGHSIDED', 'New Isuzu NKR 66L, 4x2, GVM 5.7 Tons Cab chassis with a fixed highsided body and a diesel propelled engine.'),
(26, 'NKR TRUCK LOW DROPSIDE', 'LOW DROPSIDE', 'New Isuzu NKR 66L, 4x2, GVM 5.7 Tons Cab chassis with a low dropside body and a diesel propelled engine.'),
(27, 'NKR TRUCK HIGH DROPSIDE', 'HIGH DROPSIDE', 'New Isuzu NKR 66L, 4x2, GVM 5.7 Tons Cab chassis with a high dropside body and a diesel propelled engine.'),
(28, 'NKR TRUCK ENCLOSED CORRUGATED BODY', 'ENCLOSED CORRUGATED BODY', 'New Isuzu NKR 66L, 4x2, GVM 5.7 Tons Cab chassis with an enclosed corrugated body and a diesel propelled engine.'),
(29, 'NPR TRUCK - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu NPR 66P, 4x2, GVM 7.3 Tons Cab chassis only with a diesel propelled 4.3 Ltrs engine.'),
(30, 'NPR TRUCK ENCLOSED PLAIN BODY', 'ENCLOSED PLAIN BODY', 'New Isuzu NPR 66P, 4x2, GVM 7.3 Tons Cab chassis with a diesel propelled 4.3 Ltrs engine, Complete with a Fully Enclosed plain Truck Body painted to preferred colour.'),
(31, 'NPR TRUCK FIXED HIGHSIDED', 'FIXED HIGHSIDED', 'New Isuzu NPR 66P, 4x2, GVM 7.3 Tons Cab chassis with a diesel propelled 4.3 Ltrs engine, Complete with a fixed High Sided Truck Body painted to preferred colour.'),
(32, 'NPR TRUCK LOW DROPSIDE', 'LOW DROPSIDE', 'New Isuzu NPR 66P, 4x2, GVM 7.3 Tons Cab chassis with a diesel propelled 4.3 Ltrs engine, Complete with a Low Dropsided Truck Body painted to preferred colour.'),
(33, 'NPR TRUCK HIGH DROPSIDE', 'HIGH DROPSIDE', 'New Isuzu NPR 66P, 4x2, GVM 7.3 Tons Cab chassis with a diesel propelled 4.3 Ltrs engine, Complete with a High Dropside Truck Body painted to preferred colour.'),
(34, 'NPR TRUCK ENCLOSED CORRUGATED BODY', 'ENCLOSED CORRUGATED BODY', 'New Isuzu NPR 66P, 4x2, GVM 7.3 Tons Cab chassis with a diesel propelled 4.3 Ltrs engine, Complete with a Fully Enclosed corrugated Truck Body painted to preferred colour.'),
(35, 'NPR TRUCK TIPPER BODY WITH STABILIZER', 'TIPPER BODY WITH STABILIZER', 'New Isuzu NPR 66P, 4x2, GVM 7.3 Tons Cab chassis with a diesel propelled 4.3 Ltrs engine, Complete with a Tipper Body with Stabilizer painted to preferred colour.'),
(36, 'NPR TRUCK REFUSE COLLECTOR BODY', 'REFUSE COLLECTOR BODY', 'New Isuzu NPR 66P, 4x2, GVM 7.3 Tons Cab chassis with a diesel propelled 4.3 Ltrs engine, Complete with a Refuse Collector Body painted to preferred colour.'),
(37, 'FRR TRUCK - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis only with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission.'),
(38, 'FRR TRUCK ENCLOSED PLAIN BODY', 'ENCLOSED PLAIN BODY', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission, Complete with an Enclosed Plain Body Painted to preferred colours.'),
(39, 'FRR TRUCK FIXED HIGHSIDED', 'FIXED HIGHSIDED', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission, Complete with a Fixed Highsided Body Painted to preferred colours.'),
(40, 'FRR TRUCK LOW DROPSIDE', 'LOW DROPSIDE', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission, Complete with a Low Dropside Body Painted to preferred colours.'),
(41, 'FRR TRUCK HIGH DROPSIDE', 'HIGH DROPSIDE', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission, Complete with a High Dropside Body Painted to preferred colours.'),
(42, 'FRR TRUCK ENCLOSED CORRUGATED BODY', 'ENCLOSED CORRUGATED BODY', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission, Complete with an Enclosed Corrugated Body Painted to preferred colours.'),
(43, 'FRR TRUCK TIPPER BODY WITH STABILIZER', 'TIPPER BODY WITH STABILIZER', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission, Complete with a Tipper Body with Stabilizer and Painted to preferred colours.'),
(44, 'FRR TRUCK REFUSE COLLECTOR BODY', 'REFUSE COLLECTOR BODY', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission, Complete with a Refuse Collector Body Painted to preferred colours.'),
(45, 'FRR TRUCK VACUUM EXAUSTER 6000 L', 'VACUUM EXAUSTER 6000 L', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission, Complete with a 6000L Vacuum Exhauster Body Painted to preferred colours.'),
(46, 'FRR TRUCK WATER TANKER C/W PTO 6000L', 'WATER TANKER C/W PTO 6000L', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission, Complete with a 6000L Water Tanker Body Painted to preferred colours.'),
(47, 'FRR TRUCK FUEL TANKER', 'FUEL TANKER', 'New Isuzu FRR 33L, 4x2, GVM 9.9 Tons Cab chassis with a diesel propelled 185HP, 8226cc engine, 6 Speed transmission, Complete with a Fuel Tanker Body Painted to preferred colours.'),
(48, 'FSR TRUCK - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu FSR 33H, Cab Chassis only with a Diesel propelled Engine with its new and powerful 8226cc, 198 horsepower.'),
(49, 'FSR TRUCK ENCLOSED PLAIN BODY', 'ENCLOSED PLAIN BODY', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with an Enclosed Plain Truck Body.'),
(50, 'FSR TRUCK FIXED HIGHSIDED', 'FIXED HIGHSIDED', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with a Fixed Highsided Truck Body.'),
(51, 'FSR TRUCK LOW DROPSIDE', 'LOW DROPSIDE', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with a Low Dropside Truck Body.'),
(52, 'FSR TRUCK HIGH DROPSIDE', 'HIGH DROPSIDE', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with a High Dropside Truck Body.'),
(53, 'FSR TRUCK ENCLOSED CORRUGATED BODY', 'ENCLOSED CORRUGATED BODY', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with an Enclosed Corrugated Truck Body.'),
(54, 'FSR TRUCK REINFORCED LOW DROP SIDE S/HAR', 'REINFORCED LOW DROP SIDE S/HAR', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with a Reinforced Low Dropside Truck Body.'),
(55, 'FSR TRUCK REINFORCED HIGH DROP SIDE S/HAR', 'REINFORCED HIGH DROP SIDE S/HAR', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with a Reinforced High Dropside Truck Body.'),
(56, 'FSR TRUCK TIPPER BODY WITH STABILIZER', 'TIPPER BODY WITH STABILIZER', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with a Tipper Truck Body with Stabilizer.'),
(57, 'FSR TRUCK REFUSE COLLECTOR BODY', 'REFUSE COLLECTOR BODY', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with a Refuse Collector Truck Body.'),
(58, 'FSR TRUCK VACUUM EXAUSTER 8000 L', 'VACUUM EXAUSTER 8000 L', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with a Refuse Collector Truck Body.'),
(59, 'FSR TRUCK WATER TANKER C/W PTO 7000 - 8000 L', 'WATER TANKER C/W PTO 7000 - 8000 L', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with a Vacuum Exhauster Truck Body.'),
(60, 'FSR TRUCK FUEL TANKER', 'FUEL TANKER', 'New Isuzu FSR 33H, Cab Chassis with a Diesel propelled Engine having a powerful 8226cc, 198 horsepower, two wheel base version, Complete with a Fuel Tanker Truck Body.'),
(61, 'FVR TRUCK - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu FVR 23M Cab chassis only with a 236HP, 9,839cc diesel propelled engine, 6-speed transmission.'),
(62, 'FVR TRUCK ENCLOSED PLAIN BODY', 'ENCLOSED PLAIN BODY', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a fully enclosed plain body.'),
(63, 'FVR TRUCK FIXED HIGHSIDED', 'FIXED HIGHSIDED', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a fixed highsided truck body.'),
(64, 'FVR TRUCK LOW DROPSIDE', 'LOW DROPSIDE', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a low dropside truck body.'),
(65, 'FVR TRUCK HIGH DROPSIDE', 'HIGH DROPSIDE', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a high dropside truck body.'),
(66, 'FVR TRUCK ENCLOSED CORRUGATED BODY', 'ENCLOSED CORRUGATED BODY', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with an enclosed corrugated truck body.'),
(67, 'FVR TRUCK REINFORCED LOW DROP SIDE S/HAR', 'REINFORCED LOW DROP SIDE S/HAR', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a reinforced low dropside truck body.'),
(68, 'FVR TRUCK REINFORCED HIGH DROP SIDE S/HAR', 'REINFORCED HIGH DROP SIDE S/HAR', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a reinforced high dropside truck body.'),
(69, 'FVR TRUCK TIPPER BODY WITH STABILIZER', 'TIPPER BODY WITH STABILIZER', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a Tipper Body with Stabilizer.'),
(70, 'FVR TRUCK REFUSE COLLECTOR BODY', 'REFUSE COLLECTOR BODY', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a Refuse Collector Body.'),
(71, 'FVR TRUCK VACUUM EXAUSTER 10000 L', 'VACUUM EXAUSTER 10000 L', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a Vacuum Exhauster Truck body.'),
(72, 'FVR TRUCK WATER TANKER C/W PTO 9000 - 10000 L', 'WATER TANKER C/W PTO 9000 - 10000 L', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a Water Tanker Truck body.'),
(73, 'FVR TRUCK FUEL TANKER', 'FUEL TANKER', 'New Isuzu FVR 23M Cab chassis with a 236HP, 9839cc diesel propelled engine, 6 speed transmission, GVW 16Ton with a Fuel Tanker Truck body.'),
(74, 'FVZ TRUCK - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu FVZ 23S Cab chassis only with a diesel propelled 236 HP, 9839cc engine, 9-speed transmission, GVW 20 ton.'),
(75, 'FVZ TRUCK ENCLOSED PLAIN BODY', 'ENCLOSED PLAIN BODY', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with an enclosed plain truck body.'),
(76, 'FVZ TRUCK FIXED HIGHSIDED', 'FIXED HIGHSIDED', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with a fixed highsided truck body.'),
(77, 'FVZ TRUCK LOW DROPSIDE', 'LOW DROPSIDE', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with a low dropside truck body.'),
(78, 'FVZ TRUCK HIGH DROPSIDE', 'HIGH DROPSIDE', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with a high dropside truck body.'),
(79, 'FVZ TRUCK ENCLOSED CORRUGATED BODY', 'ENCLOSED CORRUGATED BODY', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with an enclosed corrugated truck body.'),
(80, 'FVZ TRUCK REINFORCED LOW DROP SIDE S/HAR', 'REINFORCED LOW DROP SIDE S/HAR', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with a reinforced low dropside truck body.'),
(81, 'FVZ TRUCK REINFORCED HIGH DROP SIDE S/HAR', 'REINFORCED HIGH DROP SIDE S/HAR', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with a reinforced high dropside truck body.'),
(82, 'FVZ TRUCK TIPPER BODY WITH STABILIZER', 'TIPPER BODY WITH STABILIZER', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with a tipper truck body with stabilizer.'),
(83, 'FVZ TRUCK REFUSE COLLECTOR BODY', 'REFUSE COLLECTOR BODY', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with a refuse collector truck body.'),
(84, 'FVZ TRUCK VACUUM EXAUSTER 14000 L', 'VACUUM EXAUSTER 14000 L', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with a vacuum exhauster truck body.'),
(85, 'FVZ TRUCK WATER TANKER C/W PTO 14000 - 15000 L', 'WATER TANKER C/W PTO 14000 - 15000 L', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with a water tanker truck body.'),
(86, 'FVZ TRUCK FUEL TANKER', 'FUEL TANKER', 'New Isuzu FVZ 23S Cab chassis with a diesel propelled 236 HP, 9839cc engine, 9 speed transmission, GVW 20 ton with a fuel tanker truck body.'),
(87, 'NKR BUS - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu NKR 66L, chassis only 26 Seater Institution Mini Bus with a Diesel propelled Engine.'),
(88, 'NKR BUS SEMI LUX 26-SEATER BODY (REINFORCED)', 'SEMI LUX 26-SEATER BODY (REINFORCED)', 'New Isuzu NKR 66L, 26 Seater Institution Mini Bus with a Diesel propelled Engine, painted to preferred colour scheme & logo, fitted with Speed Governor, Velvet covered front & Rexine behind High Back Square Tube Type Seats with Grab Handles, Rexine Loose Headrest Seat Covers & Seatbelts, Inside Parcel Carriers, Roof Rack, Radio + 2 Speakers, Tint on upper fixed glasses only. Inclusive of Inspection.'),
(89, 'NPR BUS - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu NPR 29 Seater Institution Mini Bus with a Diesel propelled Engine.'),
(90, 'NPR BUS SEMI-LUX 29-SEATER BODY(REINFORCED)', 'SEMI-LUX 29-SEATER BODY(REINFORCED)', 'New Isuzu NPR 29 Seater Institution Mini Bus with a Diesel propelled Engine, painted to preferred colour scheme & logo, fitted with Speed Governor, Velvet covered front & Rexine behind High Back Square Tube Type Seats with Grab Handles, Rexine Loose Headrest Seat Covers & Seatbelts, Inside Parcel Carriers, Roof Rack, Radio + 2 Speakers, Tint on upper fixed glasses only. Inclusive of Inspection.'),
(91, 'NQR 33 SEATER BUS - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu NQR 33 Seater Institution Mini Bus chassis only with a Diesel propelled Engine'),
(92, 'NQR66 BUS SEMI-LUX 33 SEATER BODY(REINFORCED)', 'SEMI-LUX 33 SEATER BODY(REINFORCED)', 'New Isuzu NQR 33 Seater Institution Mini Bus with a Diesel propelled Engine, painted to preferred colour scheme & logo, fitted with Speed Governor, Velvet covered front & Rexine behind High Back Square Tube Type Seats with Grab Handles, Rexine Loose Headrest Seat Covers & Seatbelts, Inside Parcel Carriers, Roof Rack, Radio + 2 Speakers, Tint on upper fixed glasses only. Inclusive of Inspection.'),
(93, 'NQR66 BUS LUXURY 33 SEATER BODY(REINFORCED)', 'LUXURY 33 SEATER BODY(REINFORCED)', 'New Isuzu NQR 33 Seater Institution Mini Bus with a Diesel propelled Engine, painted to preferred colour scheme & logo, fitted with Speed Governor, Velvet covered front & Rexine behind High Back Square Tube Type Seats with Grab Handles, Rexine Loose Headrest Seat Covers & Seatbelts, Inside Parcel Carriers, Roof Rack, Radio + 2 Speakers, Tint on upper fixed glasses only. Inclusive of Inspection.'),
(94, 'FRR COWL 51 SEATER BUS - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu FRR 33L, 50 Seater Semi-Luxury Institution Bus chassis only with a Diesel propelled Engine'),
(95, 'FRR COWL SEMI-LUX 51-SEATER BODY(REINFORCED)', 'SEMI-LUX 51-SEATER BODY(REINFORCED', 'New Isuzu FRR 33L, 50 Seater Semi-Luxury Institution Bus with a Diesel propelled Engine, painted to preffered colour scheme and logo, fitted with Speed Governor, Velvet covered front and Rexine covered behind High Back Square Tube Type Seats with Grab Handles, Loose Headrest Covers and Seatbelts, Inside Parcel Carriers and Roof Rack, Radio + 4 Speakers, Rear spoiler.'),
(96, 'MV SWB 62 SEATER BUS - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu MV123 (SWB), 62 Seater Institution Bus chassis only with a Diesel propelled Engine'),
(97, 'MV SWB SEMI-LUX 62-SEATER BODY(REINFORCED)', 'SEMI-LUX 62-SEATER BODY(REINFORCED)', 'New Isuzu MV123 (SWB), 62 Seater Institution Bus with a Diesel propelled Engine, painted to preferred colour scheme and logo, fitted with Speed Governor, Velvet covered front & Rexine behind High Back Square Tube Type Seats with Grab Handles, Rexine Loose Headrest Covers & Seatbelts, Inside Parcel Carriers, Roof Rack, Single handrail.'),
(98, 'MV LWB 67 SEATER BUS - CHASSIS ONLY', 'CHASSIS ONLY', 'New Isuzu MV123 (LWB), 67 Seater Institution Bus chassis only with a Diesel propelled Engine'),
(99, 'MV LWB SEMI-LUX 67-SEATER BODY(REINFORCED)', 'SEMI-LUX 67-SEATER BODY(REINFORCED)', 'New Isuzu MV123 (LWB), 67 Seater Institution Bus with a Diesel propelled Engine, painted to preferred colour scheme and logo, fitted with Speed Governor, Velvet covered front & Rexine behind High Back Square Tube Type Seats with Grab Handles, Rexine Loose Headrest Covers & Seatbelts, Inside Parcel Carriers, Roof Rack, Single handrail. Inclusive of Inspection and Registration.');

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

-- 
-- Table structure for table `tbl_rate`
-- 

CREATE TABLE `tbl_rate` (
  `id` int(100) NOT NULL auto_increment,
  `custid` varchar(100) NOT NULL,
  `srep` varchar(100) NOT NULL,
  `comment` varchar(1000) NOT NULL,
  `rate` varchar(100) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `tbl_rate`
-- 

INSERT INTO `tbl_rate` (`id`, `custid`, `srep`, `comment`, `rate`, `date`) VALUES 
(1, '1', 'CALLEB MARTIN NYOKUMA', 'Good work. Take note of the delay when collecting vehicle.', '4', '2019-11-21');

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

-- 
-- Table structure for table `tbl_service`
-- 

CREATE TABLE `tbl_service` (
  `id` int(100) NOT NULL auto_increment,
  `custid` varchar(100) NOT NULL,
  `fleet` varchar(100) NOT NULL,
  `servicetype` varchar(100) NOT NULL,
  `slocation` varchar(100) NOT NULL,
  `clocation` varchar(100) NOT NULL,
  `clocdescription` varchar(1000) NOT NULL,
  `isoffice` varchar(100) NOT NULL default 'Office',
  `latt` varchar(100) NOT NULL,
  `lng` varchar(100) NOT NULL,
  `sdate` date NOT NULL,
  `yn` varchar(100) NOT NULL,
  `comments` varchar(1000) NOT NULL,
  `rdate` date NOT NULL,
  `confirmed` varchar(100) NOT NULL default '0',
  `date` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- 
-- Dumping data for table `tbl_service`
-- 

INSERT INTO `tbl_service` (`id`, `custid`, `fleet`, `servicetype`, `slocation`, `clocation`, `clocdescription`, `isoffice`, `latt`, `lng`, `sdate`, `yn`, `comments`, `rdate`, `confirmed`, `date`) VALUES 
(1, '1', 'KCW 264G', 'Comprehensive Service', 'Workshop', 'Workshop', '', 'Office', '', '', '2019-11-28', 'no', 'The date chosen for service is fully booked. We recommend the next day. We will give priority on that day. Confirm if it will work for you.', '2019-11-29', '0', '2019-11-25'),
(2, '1', 'KCW 412F', 'Minor Service', 'Field', 'Utawala', 'Kincar', 'Office', '', '', '2019-12-10', '', '', '0000-00-00', '0', '2019-12-02'),
(3, '1', 'KCW 264G', 'Repair Service', 'Field', 'Uthiru', 'vet labs', 'Office', '-1.252602124010547', '36.732570827007294', '2019-12-05', '', '', '0000-00-00', '0', '2019-12-02'),
(4, '1', 'KCW 264G', 'Repair Service', 'Field', 'Uthiru', 'vet labs', 'Office', '-1.252602124010547', '36.732570827007294', '2019-12-05', '', '', '0000-00-00', '0', '2019-12-02'),
(5, '1', 'KCW 264G', 'Repair Service', 'Field', 'Uthiru', 'vet labs', 'Office', '-1.252224693278698', '36.73250913619995', '2019-12-05', '', '', '0000-00-00', '0', '2019-12-02'),
(6, '1', 'KCW 264G', 'Comprehensive Service', 'Office', 'Thika', '', 'Office', '-1.332872', '36.864744', '2019-12-10', '', '', '0000-00-00', '0', '2019-12-02'),
(7, '1', 'KCW 264G', 'Comprehensive Service', 'Office', 'Nyeri', '', 'Office', '-1.332872', '36.864744', '2019-12-04', '', '', '0000-00-00', '0', '2019-12-02'),
(8, '1', 'KCW 264G', 'Comprehensive Service', 'Office', 'kisii', '', 'Office', '-1.332872', '36.864744', '2019-12-03', '', '', '0000-00-00', '0', '2019-12-02'),
(9, '1', 'KCW 412F', 'Repair Service', 'Field', 'kisumu', '', 'Office', '-1.299740309264184', '36.80370233952999', '2019-12-09', '', '', '0000-00-00', '0', '2019-12-03');

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

-- 
-- Table structure for table `tbl_sreps`
-- 

CREATE TABLE `tbl_sreps` (
  `id` int(10) NOT NULL auto_increment,
  `fullname` varchar(100) NOT NULL,
  `uname` varchar(50) NOT NULL,
  `ugroup` varchar(20) NOT NULL,
  `uteam` varchar(100) default NULL,
  `date` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

-- 
-- Dumping data for table `tbl_sreps`
-- 

INSERT INTO `tbl_sreps` (`id`, `fullname`, `uname`, `ugroup`, `uteam`, `date`) VALUES 
(1, 'CALLEB MARTIN NYOKUMA', 'caleb', 'Sales Rep', 'Team A', '2017-01-27'),
(2, 'NARAIN SINGH SOKHI', 'ns', 'Sales Rep', '', '2017-02-14'),
(3, 'FRANKLINE KATHURIMA MWITI', 'frankline', 'Sales Rep', 'Team B', '2017-02-16'),
(4, 'AMOS KIRUKU MATHU', 'amos', 'Sales Rep', 'Team B', '2018-09-11'),
(5, 'JOHN MITHAMO MURIUKI', 'john', 'Sales Rep', 'Team A', '2018-09-11'),
(6, 'ELIZABETH MURUGI', 'eliza-m', 'Sales Rep', 'Team A', '2018-10-26'),
(7, 'BETTY KAGWIRA', 'betty', 'Sales Rep', 'Team B', '2018-10-26'),
(8, 'WINNIE MWANGI', 'winnie', 'Sales Rep', 'Team B', '2018-10-26'),
(9, 'FAITH JEBET', 'faith', 'Sales Rep', 'Team A', '2018-10-26'),
(10, 'JOSLINE MURIUKI', 'josline', 'Sales Rep', 'Team B', '2018-10-26'),
(11, 'DAMARIS JEBET', 'damaris', 'Sales Rep', 'Team A', '2018-10-26'),
(12, 'JERITAH MICHIRA', 'jeritah', 'Sales Rep', 'Team A', '2018-10-26'),
(13, 'SAMUEL GACHUHI', 'sam2018', 'Sales Rep', NULL, '2018-10-26'),
(14, 'ESTHER SOMBA', 'esther', 'Sales Rep', 'Team B', '2018-10-26'),
(15, 'WILLIAM MAINA', 'william', 'Sales Rep', NULL, '2019-01-31'),
(16, 'FAY WANJIKU', 'fay', 'Sales Rep', 'Team A', '2019-01-31'),
(17, 'MAUREEN MUKIRI KABURU', 'maureen', 'Sales Rep', 'Team B', '2019-01-31'),
(18, 'ANNAH MWANIKI', 'annah', 'Sales Rep', 'Team A', '2019-01-31'),
(19, 'ANITA WAWUDA', 'anita', 'Sales Rep', 'Team B', '2019-01-31'),
(20, 'ELIUD MUTHUI', 'eliud', 'Sales Rep', 'Team B', '2019-01-31'),
(21, 'PETER KURIA', 'peterk', 'Sales Rep', NULL, '2019-07-11'),
(22, 'LUCY NKIROTE', 'nkirote', 'Sales Rep', NULL, '2019-07-11'),
(23, 'FLORENCE AQUILLAH', 'acquillah', 'Sales Rep', NULL, '2019-07-11'),
(24, 'DINAH OKUMU', 'dinah', 'Sales Rep', NULL, '2019-07-11'),
(25, 'JOAN GITARI', 'joan', 'Sales Rep', NULL, '2019-07-11'),
(26, 'MARTIN IMBALI', 'martini', 'Sales Rep', NULL, '2019-07-11'),
(27, 'KELVIN MURIITHI', 'kelvin', 'Sales Rep', NULL, '2019-07-11');

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

-- 
-- Table structure for table `tbl_user`
-- 

CREATE TABLE `tbl_user` (
  `id` int(100) NOT NULL auto_increment,
  `fname` varchar(1000) NOT NULL,
  `sname` varchar(1000) NOT NULL,
  `uname` varchar(1000) NOT NULL,
  `pass` varchar(1000) NOT NULL,
  `date` date NOT NULL,
  `custid` varchar(1000) NOT NULL,
  `ismain` varchar(100) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `tbl_user`
-- 

INSERT INTO `tbl_user` (`id`, `fname`, `sname`, `uname`, `pass`, `date`, `custid`, `ismain`) VALUES 
(1, 'Edward', 'Moenga', 'edd', 'edd', '2019-11-13', '', '1'),
(2, 'Betty', 'Kangatsi', 'bettyk', 'bet', '2019-11-14', '1', '1');