-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 14, 2017 at 02:54 AM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 5.6.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `ezycab`
--

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

--
-- Table structure for table `area`
--

CREATE TABLE `area` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` int(11) NOT NULL,
  `vehicle_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `passenger_id` int(11) NOT NULL,
  `invoice_no` int(11) NOT NULL,
  `invoice_status` int(11) NOT NULL,
  `pickup_date` date NOT NULL,
  `hours` int(11) NOT NULL,
  `mins` int(11) NOT NULL,
  `passengers` int(4) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `pickup_address` varchar(200) NOT NULL,
  `pickup_post_code` varchar(20) NOT NULL,
  `drop_address` varchar(200) NOT NULL,
  `drop_post_code` varchar(11) NOT NULL,
  `waiting_time` varchar(100) NOT NULL,
  `waiting_charges` decimal(10,2) NOT NULL,
  `parking` decimal(10,2) NOT NULL,
  `fare` decimal(10,2) NOT NULL,
  `other` decimal(10,2) NOT NULL,
  `total_fare` decimal(10,2) NOT NULL,
  `payment_type` int(11) NOT NULL,
  `comments` text NOT NULL,
  `job_status` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` (`id`, `vehicle_id`, `customer_id`, `passenger_id`, `invoice_no`, `invoice_status`, `pickup_date`, `hours`, `mins`, `passengers`, `driver_id`, `pickup_address`, `pickup_post_code`, `drop_address`, `drop_post_code`, `waiting_time`, `waiting_charges`, `parking`, `fare`, `other`, `total_fare`, `payment_type`, `comments`, `job_status`) VALUES
(395, 1, 253, 407, 0, 1, '2017-02-13', 19, 53, 5, 233, 'f', 'f', 'f', 'f', 'mins', '10.00', '10.00', '10.00', '70.00', '100.00', 0, 'No Comments', '2');

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

--
-- Table structure for table `company_contact`
--

CREATE TABLE `company_contact` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company_contact`
--

INSERT INTO `company_contact` (`id`, `customer_id`, `name`, `mobile`, `email`) VALUES
(361, 263, 'MR LUISI MR GIRAUDI MR BARBERIS ', '07808939220', 'RAJTAKKAR@YAHOO.CO.UK'),
(360, 277, '', '', ''),
(359, 263, 'MR GIRAUDI', '07', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(356, 263, 'Mr AND MRS LUISI', '', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(357, 263, 'MR AND MRS BARBERIS', '', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(358, 276, '', '', ''),
(362, 263, 'MR LUISI MR GIRAUDI  ', '07808939220', 'RAJTAKKAR@YAHOO.CO.UK'),
(363, 259, '', '', ''),
(364, 259, 'MR A ', '07808939220', 'RAJ.TAKKAR@YAHOO.CO.UK'),
(365, 259, 'MR B', '07808939220', 'RAJTAKKAR@YAHOO.CO.UK'),
(366, 259, 'MR C', '07808939220 ', 'RAJTAKKAR@YAHOO.CO.UK'),
(367, 278, '', '', ''),
(368, 259, 'MR D', '07808939220', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(369, 259, 'MR F', '07808939220', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(370, 259, 'MR E ', '07808939220', 'RAJTAKKAR@YAHOO@CO.UK'),
(371, 259, '', '', ''),
(372, 259, '', '', ''),
(373, 259, 'MR G ', '07808939220', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(374, 259, 'MR H', '07808939220', 'RAJTAKKAR@YAHOO.CO.UK'),
(375, 274, 'MR A SHEIK ', '+192893293221', 'RAJTAKKAR@YAHOO.COM'),
(376, 274, 'MR B SHIEK ', '+91382323211', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(377, 274, 'MR C SHIEK ', '+92482888238', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(378, 274, '', '', ''),
(379, 274, 'MR E SHEIKH', '94589339887', 'RAJTAKKAR@YAHOO.CO.UK'),
(380, 274, 'MR D SHEIKH ', '07808939220', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(381, 274, 'MR G SHIEH', '089847328974', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(382, 274, 'MR Y SHEIL', '08787643442', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(383, 270, 'DR R T AK', '+913232323', 'ROHITTAKKAR@YAHOO.CO.UK'),
(384, 270, 'DR R TAK ', ' +913232323 ', ' ROHIT.TAKKAR@YAHOO.CO.UK'),
(385, 274, 'MR A A A ', '07829382973', 'ROHIT.TAKKAR@YAHOO.CO.UK'),
(386, 279, 'RAWAN NAYYAR', '07878777777', 'RAWANN@HOTMAIL.CO.UK'),
(387, 270, 'DR R HELLO', '0784988334', 'RAJTAKKAR@YAHOO.CO.UK'),
(388, 257, 'DR R RRR', ' 07878788888', 'ROHIT.Takkar@yahoo.co.uk'),
(389, 257, 'chinwxex', '+91938748892', 'rajtakkar@yahoo.co.uk'),
(390, 259, 'DR hhhh', ' 0784988334 ', ' RAJTAKKAR@YAHOO.CO.UK'),
(391, 257, 'Ddddd', '  0784988334  ', '  RAJTAKKAR@YAHOO.CO.UK'),
(392, 280, '', '', ''),
(393, 265, 'dr ggg', '987383732', 'rajtakkar@yahoo.co.uk'),
(394, 265, 'khd', '4656456', 'rajtakkar@yahoo.co.uk'),
(395, 269, 'rdh', '839932432', 'rajtakkar@yahoo.co.uk'),
(396, 259, 'Demo Smith', '07792560326', ' jaspinder32@gmail.com'),
(397, 269, 'dr hhjjj', '0789986877', 'rajtakkar@yahoo.co.uk'),
(398, 269, 'dr niraj', '07397387283', 'rajtakkar@yahoo.co.uk'),
(399, 269, 'dr aaa', '087488434', 'rajtakkar@yahoo.co.uk'),
(400, 260, 'rohhh', '0986567909', 'rajtakkar@yahoo.co.uk'),
(401, 264, 'MRS S RAY', '08676788', 'rajtakkar@yahoo.co.uk'),
(402, 259, 'MR R DAY', '07839372932', 'rajtakkar@yahoo.co.uk'),
(403, 263, 'DR VVV', '9877887778', 'rajtakkar@yahoo.co.uk'),
(404, 258, 'AMAI KUMAR DUTTA MEHTA', '', ''),
(405, 258, 'MR S KHAN', '9808080080983', 'rajtakkar@yahoo.co.uk'),
(406, 265, 'RRRR', '7777777', 'rajtakkar@yahoo.co.uk'),
(407, 263, 'AMAI KUMAR DUTTA ME  ANDHTA  AND ROHIT KUMAR', '   07808939220 ', '  rajtakkar@yahoo.co.uk'),
(408, 266, 'MR A SINGH ', '983884884', 'rajtakkar@yahoo.co.uk'),
(409, 257, 'stan nawara', '07808939220', 'rohit.takkar@yahoo.co.uk'),
(410, 254, 'ALAN SUGAR', '07398378282', 'rajtakkar@yahoo.co.uk'),
(411, 256, 'JESSICA', '07710257711', 'rajtakkar@yahoo.co.uk'),
(412, 270, 'MANJIT TAKKAR', '07710257711', 'rohit.takkar@yahoo.co.uk'),
(413, 274, 'MR F DDA', '   07808939220 ', '  rajtakkar@yahoo.co.uk'),
(414, 265, 'hello jjj', '32466576879', 'rajtakkar@yahoo.co.uk'),
(415, 270, 'mr r singh', '97387377373', 'rajtakkar@yahoo.co.uk'),
(416, 255, 'mr t singh', '048848848', 'rajtakkar@yahoo.co.uk'),
(417, 259, 'ccxcscx', '788565', 'rajtakkar@yahoo.co.uk'),
(418, 259, 'R KHAN', '0784749283', 'rajtakkar@yahoo.co.uk'),
(419, 281, '', '', ''),
(420, 255, 'MR AB SINGH', '07858885443', 'rajtakkar@yahoo.co.uk'),
(421, 265, 'MR ANDRE', '0705004544', 'rajtakkar@yahoo.co.uk'),
(422, 265, 'FGSDGF', ' 46656 ', ' rajtakkar@yahoo.co.uk'),
(423, 265, 'MARK', '08788787833', 'rajtakkar@yahoo.co.uk'),
(424, 265, 'ROHAN ', '0889899888899', 'rajtakkar@yahoo.co.uk'),
(425, 265, 'GINA', '078977883343', 'rajtakkar@yahoo.co.uk'),
(426, 265, 'AMAN', '0783392299', 'rajtakkar@yahoo.co.uk'),
(427, 282, '', '', ''),
(428, 257, 'jp rangaswami', '07808939220', 'rajtakkar@yahoo.co.uk'),
(429, 263, 'MAEVE INNES', '07974229259', 'rajtakkar@yahoo.co.uk'),
(430, 253, 'Rajesh Thakkar', '0785262', 'rajtakkar@yahoo.co.uk'),
(431, 253, 'David Smith', '07859655', 'jaspinder32@gmail.com'),
(432, 253, 'jas', '  078  ', '   jaspinder32@gmail.com');

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `mobile` varchar(11) NOT NULL,
  `email` varchar(50) NOT NULL,
  `address1` varchar(50) NOT NULL,
  `address2` varchar(50) NOT NULL,
  `city` varchar(20) NOT NULL,
  `post_code` varchar(10) NOT NULL,
  `payment_terms` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `name`, `phone`, `mobile`, `email`, `address1`, `address2`, `city`, `post_code`, `payment_terms`) VALUES
(253, 'Jas', '07792560326', '', '', '37 Hatton Avneue', '', '', 'SL2 1NE', ''),
(254, 'Hilton', '07792560326', '', 'jaspinder32@gmail.com', 'Heathrow', '', '', 'SL2 1NE', ''),
(255, 'DRIVEN WORLDWIDE LTD', '', '', '', '35B TRANQUIL VALE BLACKHEATH LONDON ', '', '', 'SE3 OBU', ''),
(256, 'TOTAL CHAUFFEUR SERVICE', '', '', '', 'SUIT G02 150 MINORIES LONDON ', '', '', 'EC3N1LS', ''),
(257, 'DEUTSCHE BANK', '', '', '', '1 APPOLD STREET ', '', '', 'EC2A 2HE', ''),
(258, 'ORBITAL CHAUFFEURS ', '', '', '', '25 NORMANFIELD GREAT DUNMOW ESSEX ', '', '', 'CM61XA', ''),
(259, 'ABOUT TOWN CARRIAGES', '', '', '', 'EXCELL EXHIBITION CENTRE BUSINESS SERVICES DESK RO', '', '', ' E161XL', ''),
(260, 'LIMO PLUS INTERNATIONAL', '', '', '', 'INTTEC HOUSE ST NICHOLAS CLOSE FLEET HAMPSHIRE ', '', '', 'GU51 4JA', ''),
(261, 'TOP EXECUTIVE', '', '', '', 'ELMWOOD HOUSE OLD HOWLETTS LANE RUISLIP ', '', '', 'HA4 7RH', ''),
(262, 'MR LALONI ANDRE', '', '', '', 'UBS INVESTMENT BANK AV.BIBI.-4.440-10TH FLOOR ITAI', '', '', '', ''),
(263, 'AIRSHOW INTERNATIONAL', '', '', '', '20 ECCLESTON STREET LONDON', '', '', ' SW1W9LT', ''),
(264, 'SILVER SCREEN LIMOUSINES', '', '', '', '590A GREEN LANE,PALMERS GREEN LONDON ', '', '', 'N135RY', ''),
(265, 'MARCO DE CARVALHO', '', '', '', 'AV.BRIGADEIRO FARIA LIMA,4.440-14TH FLOOR ITAIM BI', '', '', '', ''),
(266, 'VIRTUSA CORPORATION', '', '', '', '2000 WEST PARK DRIVE WESTBOROUGH,MA 01581', '', '', '', ''),
(267, 'THE HOUSE OF CHAUFFEURS', '', '', '', 'ONEGA HOUSE 112 MAIN ROAD,SIDCUP,KENT', '', '', 'DA14 6NE', ''),
(268, 'WEST MIDDLESEX CARS', '', '', '', '14 SOUTH ROAD LONDON ', '', '', 'W5 4RY', ''),
(269, 'BOB BOLTON D&R SERVICES', '', '', '', 'ASHMOUNT RIDGE LANE MOEPHAM KENT ', '', '', 'DA13 ODP', ''),
(270, 'CAREY ENGLAND LTD', '', '', '', 'MANDERSON HOUSE COMMERCE ROAD BRENTFORD ', '', '', 'TW8 8LH', ''),
(271, 'TBR LOGISTICKS LTD', '', '', '', '15 BIRKMYRE ROAD GLASGOW ', '', '', 'G51 3JH', ''),
(272, 'LDN CHAUFFEUR', '', '', '', '4 GRAFTON HOUSE GRAFTON ROAD NEW MALDEN ', '', '', 'KT3 3AA', ''),
(273, 'TREKLERS LTD', '', '', '', '61 SUNDEALA CLOSE SUNBURY-ON-THAMES', '', '', ' TW16 5BE', ''),
(274, 'DHABI ENTERPRISES EST', '', '', '', 'P.O.B 46111,ABU DHABI', '', '', 'ABU DHABI', ''),
(281, 'R', '', '', '', '', '', '', '', ''),
(282, '', '', '', '', '', '', '', '', ''),
(283, 'Demo', '0', '', '@', 'high road', '', '', 'SL3 5LK', '');

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

--
-- Table structure for table `customer_type`
--

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

--
-- Dumping data for table `customer_type`
--

INSERT INTO `customer_type` (`id`, `name`) VALUES
(1, 'Residential'),
(2, 'Commercial');

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

--
-- Table structure for table `driver_bookings`
--

CREATE TABLE `driver_bookings` (
  `id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `invoice_no` int(11) NOT NULL,
  `invoice_status` int(11) NOT NULL,
  `waiting_time` varchar(100) NOT NULL,
  `waiting_charges` decimal(10,2) NOT NULL,
  `parking` decimal(10,2) NOT NULL,
  `fare` decimal(10,2) NOT NULL,
  `other` decimal(10,2) NOT NULL,
  `total_fare` decimal(10,2) NOT NULL,
  `status` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `driver_bookings`
--

INSERT INTO `driver_bookings` (`id`, `booking_id`, `driver_id`, `invoice_no`, `invoice_status`, `waiting_time`, `waiting_charges`, `parking`, `fare`, `other`, `total_fare`, `status`) VALUES
(918, 395, 233, 0, 0, 'mins', '100.00', '100.00', '100.00', '700.00', '1000.00', '1'),
(919, 395, 233, 0, 0, 'mins', '100.00', '100.00', '100.00', '700.00', '1000.00', '1');

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

--
-- Table structure for table `driver_invoices`
--

CREATE TABLE `driver_invoices` (
  `invoice_no` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `nett` decimal(10,2) NOT NULL,
  `commission` decimal(10,2) NOT NULL,
  `gross` decimal(10,2) NOT NULL,
  `status` varchar(10) NOT NULL,
  `pay_date` date NOT NULL,
  `description` text NOT NULL,
  `percentage` decimal(10,2) NOT NULL,
  `percentage_amount` decimal(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `driver_invoices`
--

INSERT INTO `driver_invoices` (`invoice_no`, `driver_id`, `date`, `nett`, `commission`, `gross`, `status`, `pay_date`, `description`, `percentage`, `percentage_amount`) VALUES
(148, 233, '2017-02-13', '1000.00', '500.00', '450.00', '2', '0000-00-00', '', '10.00', '50.00');

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` int(11) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `address` varchar(250) NOT NULL,
  `post_code` varchar(20) NOT NULL,
  `pco_number` varchar(20) NOT NULL,
  `badge_number` varchar(50) NOT NULL,
  `badge_expiry` date NOT NULL,
  `driver_photo` varchar(200) NOT NULL,
  `pco_expiry` date NOT NULL,
  `tfl_expiry` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`id`, `first_name`, `phone`, `email`, `address`, `post_code`, `pco_number`, `badge_number`, `badge_expiry`, `driver_photo`, `pco_expiry`, `tfl_expiry`) VALUES
(208, 'HARCHAND SINGH ', '07944688935', 'hsinghlondon@yahoo.co.uk', '8 FIFTH AVENUE HAYES MIDDLESEX 	', 'UB3 2ER		', '852780301', '0', '0000-00-00', '', '2019-03-23', '2017-05-11'),
(209, 'KULBUSHEN SHARMA', '07947865130', 'kulbushansharma@icloud.com', '20 CEDAR GROVE SOUTHALL 		', 'UB1 2XD	', '176940501', '0', '0000-00-00', 'KULBUSHEN SHARMA-Scan0001.jpg', '2019-11-24', '2017-04-19'),
(210, 'KULBUSHEN SHARMA', '07947865130', 'kulbushansharma@icloud.com', '20 CEDAR GROVE SOUTHALL 		', 'UB1 2XD	', '176940501', '0', '0000-00-00', 'KULBUSHEN SHARMA-Scan0001.jpg', '2019-11-24', '2017-04-19'),
(211, 'SHARNBIRSINGH SANDHU', '07809885001', 'sandhu.sharnbir@yahoo.com', '40 DENBIGH DRIVE HAYES 	', 'UB3 1QF	', '1639570201', '0', '0000-00-00', '', '2019-09-18', '2017-09-17'),
(212, 'ARMINDER SINGH', '07877145291', 'akarwalian@yahoo.co.uk', '271 WORDSWORTH WAY WEST DRAYTON 			', 'UB7 9HT', '930230401', '0', '0000-00-00', '', '2019-12-08', '2017-09-14'),
(213, 'TARSEM SINGH', '07917877078', 'chana_tarsem@hotmail.co.uk', '19 TALL TREES COLNBROOK SLOUGH 			', 'SL3 OJS', '835260401', '0', '0000-00-00', '', '2019-08-31', '2017-09-14'),
(214, 'HARPREET SINGH', '07401010104', 'singh219@yahoo.co.uk', '7 HAWKFIELE COURT ISLEWORTH 			', 'TW7 6NU', '1006730201', '0', '0000-00-00', '', '2017-07-03', '2017-11-09'),
(215, 'KARAM SINGH KALSI', '07950553534', 'karamkalsi@yahoo.co.uk', '66 HYDE WAY HAYES', 'UB3 4PH	', '491770401', '0', '0000-00-00', '', '2018-09-17', '2017-04-25'),
(216, 'PRADEEP SETHI', '07933383333', 'pradeepsethi1@gmail.com', '32 KINGSBRIDGE ROAD SOUTHALL 			', 'UB2 5RT', '1754970102', '0', '0000-00-00', '', '2017-08-10', '2017-06-05'),
(217, 'FARUKH SHEIKH', '07803529741', 'fsheikh@hotmail.co.uk', '221 ELTHAM AVENUE SLOUGH		', ' SL1 5AF	', '101490501', '0', '0000-00-00', '', '2019-07-27', '2017-03-01'),
(218, 'KHUSHPRIT SINGH GANDHI', '07886025551', 'khushpritgandhi.edsl@yahoo.co.uk', '89 WHITETHORN AVENUE WEST DRAYTON 		', 'UB7 8LA	', '1457450201', '0', '0000-00-00', '', '2018-07-08', '2017-08-10'),
(219, 'MOHAMMED AL HAKIM', '07388021288', 'MSALHAKIM@YAHOO.CO.UK', '124B PERCY ROAD LONDON ', 'W12 9QL', '1691020103', '0', '0000-00-00', '', '2017-04-11', '1970-01-01'),
(222, 'NARESH C BABBER', '7539204505', 'NARESH@BABBER.COM', 'F8,ASHWOOD HOUSE,15 THE AVENUE PINNER 	', 'HA5 4DH		', '573860401', '0', '0000-00-00', '', '2019-09-11', '1970-01-01'),
(223, 'JAIDEV WADHWA ', '7940484658', 'jaidev68@live.com', '91 NORTHFIELD ROAD HOUNSLOW 			', 'TW5 9JQ', '1830080101', '0', '0000-00-00', '', '2017-12-11', '1970-01-01'),
(224, 'MOHAMMAD WASIM', '07888734093', 'MWASIM786@YAHOO.COM', 'UPPER FLAT, 139 LEYTONSTONE ROAD LONDON ', 'E151LH	', '1689280104', '0', '0000-00-00', '', '2017-04-08', '2017-09-29'),
(225, 'TOP EXECUTIVES', '07795026276', 'mark@decosta.fsbusiness.co.uk', 'ELMWOOD HOUSE OLD HOWLETTS LANE RUISLIP 		', 'HA4 7RH	', 'OPERATOR NUMBER - 36', '0', '0000-00-00', '', '2020-04-06', '1970-01-01'),
(226, 'JAVED HUSSAIN', '07878088281', 'javedhussain51@hotmail.com', '229 LONG ELMES HARROW ', 'HA3 6LE		', '452430401', '0', '0000-00-00', '', '2018-08-03', '2017-02-10'),
(227, 'JAKARIA AHMED', '7855555479', 'jakaria.ahmed@yahoo.co.uk', '114 KELSON HOUSE STEWART STREET 	', 'E14 3JN', '903920301', '0', '0000-00-00', '', '2017-02-07', '2017-10-12'),
(228, 'TALAT MAHMOOD', '07950111634', 'talat1505@yahoo.com', '104 ANSON ROAD LONDON ', 'NW2 6AH			', '166120501', '0', '0000-00-00', '', '2019-11-28', '2017-08-17'),
(229, 'SALMAN BABAR', '07445228442', 'salmanbabar11@yahoo.com', '38 HUDSON ROAD HARLINGTON HAYES 		', 'UB3 5EL	', '2344900102', '0', '0000-00-00', '', '2019-06-12', '2017-12-15'),
(230, 'BOGDAN L FLUERARU', '07557807481', 'lucyan_84@yahoo.com', '263 LORDSHIP LANE TOTTENHAM 		', 'N17 6AA	', '1760340101', '0', '0000-00-00', '', '2017-07-06', '2017-11-21'),
(231, 'SAMIR MUSHTAQ HUSSAIN', '07802764249', 'SAMHUS81@ICLOUD.COM', '28 HINTON AVENUE HOUNSLOW', ' TW46AR', '2365490101', '0', '0000-00-00', '', '2019-07-04', '2017-07-31'),
(232, 'ROHIT', '07710257711', 'ROHIT.TAKKAR@YAHOO.CO.UK', '12 LAMPTON PARK ROAD ', 'TW34HS', '57575756563', '0', '0000-00-00', '', '2017-05-11', '2017-05-20'),
(233, 'Jas Brar', '02058 02058 020', 'jaspinder32@gmail.com', 'Flat 1, High Street', 'SL2 1NE', '077778787878', '2147483647', '2017-02-26', '', '2017-02-01', '2017-02-02'),
(234, 'RAJESH TAKKAR', '07808939220', 'rajtakkar@yahoo.co.uk', '12 LAMPTON PARK ROAD HOUNSLOW', 'TW34HS', '', '0', '0000-00-00', '', '1970-01-01', '1970-01-01'),
(235, 'RAWAN KUMAR NAYYAR', '07958222041', 'rawann@hotmail.co.uk', '27 EDERLINE AVENUE LONDON 		', 'SW16 4RZ	', '729610301', '0', '0000-00-00', '', '2018-01-27', '2017-04-06');

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

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `invoice_no` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `nett` decimal(10,2) NOT NULL,
  `vat` decimal(10,2) NOT NULL,
  `gross` decimal(10,2) NOT NULL,
  `status` varchar(10) NOT NULL,
  `pay_date` date NOT NULL,
  `description` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` (`invoice_no`, `customer_id`, `date`, `nett`, `vat`, `gross`, `status`, `pay_date`, `description`) VALUES
(134, 253, '2017-02-13', '50.00', '10.00', '60.00', '2', '0000-00-00', ''),
(133, 272, '2017-02-13', '50.00', '10.00', '60.00', '2', '0000-00-00', ''),
(130, 253, '2017-02-12', '571.50', '114.30', '685.80', '2', '0000-00-00', ''),
(132, 272, '2017-02-13', '50.00', '10.00', '60.00', '2', '0000-00-00', '');

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

--
-- Table structure for table `invoice_details`
--

CREATE TABLE `invoice_details` (
  `id` int(11) NOT NULL,
  `invoice_no` int(11) NOT NULL,
  `srno` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `qty` int(10) NOT NULL,
  `sub_total` decimal(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_status`
--

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

--
-- Dumping data for table `invoice_status`
--

INSERT INTO `invoice_status` (`id`, `name`) VALUES
(1, 'Paid'),
(2, 'Raised'),
(4, 'Cancelled'),
(5, 'Not Paid');

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

--
-- Table structure for table `job_status`
--

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

--
-- Dumping data for table `job_status`
--

INSERT INTO `job_status` (`id`, `name`) VALUES
(1, 'Pending'),
(2, 'Confirmed');

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

--
-- Table structure for table `payments_recieved`
--

CREATE TABLE `payments_recieved` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `comments` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payments_recieved`
--

INSERT INTO `payments_recieved` (`id`, `customer_id`, `date`, `amount`, `comments`) VALUES
(1, 230, '2017-01-09', '100.00', 'N/A'),
(2, 230, '2017-01-10', '1500.00', 'N/A'),
(3, 230, '2017-01-24', '220.00', 'N/A'),
(4, 230, '2017-01-09', '100.00', 'N/A'),
(5, 230, '2017-01-09', '100.00', 'N/A'),
(6, 230, '2017-01-09', '100.00', 'N/A'),
(7, 220, '2017-01-02', '500.00', 'N/A'),
(8, 220, '2017-01-02', '500.00', 'N/A'),
(9, 232, '2017-01-12', '2300.00', 'on time'),
(10, 263, '0000-00-00', '0.00', 'N/A');

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

--
-- Table structure for table `payment_type`
--

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

--
-- Dumping data for table `payment_type`
--

INSERT INTO `payment_type` (`id`, `name`) VALUES
(1, 'Fully Paid'),
(2, 'Not Paid'),
(3, 'Part Paid'),
(4, 'Cash on Delivery'),
(5, 'Full Paid in Account');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL DEFAULT '1',
  `user_name` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `user_role` varchar(15) NOT NULL,
  `user_id` int(50) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `group_id`, `user_name`, `password`, `status`, `user_role`, `user_id`, `created`) VALUES
(1, 1, 'raj', '555', 1, 'admin', 0, '2017-01-26 11:00:44');

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

--
-- Table structure for table `vehicles`
--

CREATE TABLE `vehicles` (
  `id` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `make` varchar(50) NOT NULL,
  `passengers` varchar(10) NOT NULL,
  `mot_date` date NOT NULL,
  `insurance_date` date NOT NULL,
  `color` varchar(50) NOT NULL,
  `reg` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vehicles`
--

INSERT INTO `vehicles` (`id`, `driver_id`, `make`, `passengers`, `mot_date`, `insurance_date`, `color`, `reg`) VALUES
(143, 208, '2', '4', '1970-01-01', '2017-06-06', 'black', 'GX15VSY'),
(144, 209, '3', '7', '2017-03-03', '2017-05-19', 'SILVER', 'G6 RAP'),
(145, 211, '2', '4', '1970-01-01', '2017-11-01', 'SILVER', 'BX66YYU'),
(146, 212, '2', '4', '1970-01-01', '2017-10-09', 'BLACK', 'BX66YYN'),
(147, 213, '2', '4', '1970-01-01', '2017-10-09', 'BLACK', 'BX66YYM'),
(148, 214, '2', '4', '1970-01-01', '2017-08-04', 'BLACK', 'BD66YYM'),
(149, 215, '3', '7', '1970-01-01', '2017-09-14', 'SILVER', 'OU12ZYF'),
(150, 216, '4', '7', '1970-01-01', '2017-08-26', 'BLACK', 'MM15LUE'),
(151, 217, '1', '4', '1970-01-01', '1970-01-01', 'SILVER', 'SN16ZPP'),
(152, 218, '4', '7', '1970-01-01', '2017-12-01', 'BLACK', 'RF16SYV'),
(153, 219, '4', '7', '1970-01-01', '1970-01-01', 'SILVER', 'GX16XYR'),
(155, 221, '4', '7', '2017-02-12', '2017-02-12', 'BLACK', 'SK15AVT'),
(156, 222, '2', '', '2017-08-04', '2017-07-31', '', 'GU14WTA'),
(157, 223, '1', '', '1970-01-01', '1970-01-01', 'BLACK', 'SK64BJJ'),
(158, 224, '2', '', '1970-01-01', '2017-09-28', 'BLACK', 'EO64MRV'),
(160, 226, '2', '4', '1970-01-01', '2017-02-04', 'BLACK', 'kv15jnk'),
(161, 227, '3', '7', '1970-01-01', '2017-07-16', 'BLACK', 'X33ONE'),
(162, 228, '4', '7', '1970-01-01', '2017-07-07', 'BLACK', 'FA15OYK'),
(163, 229, '1', '4', '1970-01-01', '2017-07-04', 'BLACK', 'FV66OZO'),
(164, 230, '3', '', '1970-01-01', '2017-09-16', 'BLACK', 'KW14YWS'),
(165, 231, '2', '4', '1970-01-01', '2017-07-31', 'SILVER', 'GY16TWM'),
(166, 232, '1', '4', '1970-01-01', '2017-04-20', 'WHITE', 'SN17XXP'),
(167, 233, '2', '5', '2017-02-27', '1970-01-01', 'red', 'JK89 7UK'),
(168, 234, '', '', '1970-01-01', '1970-01-01', '', ''),
(169, 235, '3', '7', '1970-01-01', '2017-07-30', 'BLACK', 'X1NYR'),
(170, 236, '2', '4', '2017-02-28', '2017-02-27', 'red', 'JK89 7UK'),
(173, 240, '1', '4', '2017-02-21', '2017-02-28', 'red', 'RG89');

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

--
-- Table structure for table `vehicle_make`
--

CREATE TABLE `vehicle_make` (
  `model` varchar(50) NOT NULL,
  `make` varchar(50) NOT NULL,
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vehicle_make`
--

INSERT INTO `vehicle_make` (`model`, `make`, `id`) VALUES
('', 'MERCEDES S CLASS', 1),
('', 'MERCEDES E CLASS', 2),
('', 'MERCEDES VIANO', 3),
('', 'MERCEDES V CLASS', 4),
('', 'EXECUTIVE', 5),
('', 'BENTLEY', 6),
('', 'ROLLS ROYCE', 7),
('', 'RANGE ROVER', 8),
('', 'BMW 7 SERIES', 9);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

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

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

--
-- Indexes for table `driver_invoices`
--
ALTER TABLE `driver_invoices`
  ADD PRIMARY KEY (`invoice_no`);

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

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`invoice_no`);

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `area`
--
ALTER TABLE `area`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=396;
--
-- AUTO_INCREMENT for table `company_contact`
--
ALTER TABLE `company_contact`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=433;
--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=284;
--
-- AUTO_INCREMENT for table `customer_type`
--
ALTER TABLE `customer_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `driver_bookings`
--
ALTER TABLE `driver_bookings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=920;
--
-- AUTO_INCREMENT for table `driver_invoices`
--
ALTER TABLE `driver_invoices`
  MODIFY `invoice_no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149;
--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=236;
--
-- AUTO_INCREMENT for table `invoices`
--
ALTER TABLE `invoices`
  MODIFY `invoice_no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135;
--
-- AUTO_INCREMENT for table `invoice_details`
--
ALTER TABLE `invoice_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;
--
-- AUTO_INCREMENT for table `invoice_status`
--
ALTER TABLE `invoice_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `job_status`
--
ALTER TABLE `job_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `payments_recieved`
--
ALTER TABLE `payments_recieved`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `payment_type`
--
ALTER TABLE `payment_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `vehicles`
--
ALTER TABLE `vehicles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=174;
--
-- AUTO_INCREMENT for table `vehicle_make`
--
ALTER TABLE `vehicle_make`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
/*!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 */;
