ZHk0r9tV

1-- phpMyAdmin SQL Dump
2-- version 4.0.10.7
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Jun 24, 2017 at 01:47 PM
7-- Server version: 5.6.34-79.1-log
8-- PHP Version: 5.4.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `cocoalab_tracking`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `accident_history`
27--
28
29CREATE TABLE IF NOT EXISTS `accident_history` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `fk_vehicle` int(11) DEFAULT NULL,
32  `fk_driver` int(11) DEFAULT NULL,
33  `fk_location_locality` int(11) DEFAULT NULL,
34  `severity` varchar(255) DEFAULT NULL,
35  `notes` text,
36  `status` int(11) DEFAULT NULL,
37  `created_at` timestamp NULL DEFAULT NULL,
38  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
39  PRIMARY KEY (`id`),
40  KEY `fk_accident_history_vehicle_idx` (`fk_vehicle`),
41  KEY `fk_accident_history_driver_idx` (`fk_driver`),
42  KEY `fk_location_locality_id` (`fk_location_locality`)
43) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
44 
45-- Table structure for table `account`
46--
47
48CREATE TABLE IF NOT EXISTS `account` (
49  `id` int(11) NOT NULL AUTO_INCREMENT,
50  `username` varchar(255) DEFAULT NULL,
51  `password` varchar(255) DEFAULT NULL,
52  `password_reset_token` text,
53  `activation_token` text,
54  `password_token_expiry` timestamp NULL DEFAULT NULL,
55  `auth_key` text,
56  `is_verified` int(11) DEFAULT NULL,
57  `fk_person` int(11) DEFAULT NULL,
58  `is_banned` int(11) NOT NULL DEFAULT '1',
59  `status` int(11) DEFAULT '1',
60  `created_at` timestamp NULL DEFAULT NULL,
61  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
62  PRIMARY KEY (`id`),
63  KEY `fk_account_person_idx` (`fk_person`)
64) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=110 ;
65
66--
67-- Dumping data for table `account`
68--
69
70INSERT INTO `account` (`id`, `username`, `password`, `password_reset_token`, `activation_token`, `password_token_expiry`, `auth_key`, `is_verified`, `fk_person`, `is_banned`, `status`, `created_at`, `modified_at`) VALUES
71(85, 'admin@cocoalabs.in', '$2y$13$TmJH5z9rMFwsNUVlqeljuuE6fo8j9OjqgEk3HU/0UM80L89xth7Ye', NULL, NULL, NULL, NULL, 1, 143, 1, 1, '2017-06-14 00:00:00', '2017-06-16 12:56:33'),
72(86, 'anu.cocoalabs@gmail.com', '$2y$13$Yu5PdzdnxBhjfLQTfvOASu.0oY6tooqyucVaLryF//fv4zpFmqIXC', NULL, NULL, '2017-06-13 13:11:02', NULL, NULL, 144, 1, 1, NULL, '2017-06-14 13:11:02'),
73(87, 'anugra+1@cocoalabs.in', '$2y$13$eonygBAvnQT9rOknwqqtPOeuDojFdtM.sh5c5w9HM0KV620sQekz.', NULL, NULL, '2017-06-16 08:38:16', NULL, NULL, 147, 1, 1, NULL, '2017-06-17 08:38:16'),
74(88, 'anu.cocoalabs+11@gmail.com', '$2y$13$bghzctc9od1nxxOrI9RXCeXNYug2ySLfiLsd7AHgLS2CIS5Y1UYLm', 'fGaAKbStdePXon7AbHLrYhKBztmBl8cS_1497504285', NULL, '2017-06-16 05:24:45', NULL, NULL, 149, 1, 1, NULL, '2017-06-15 05:24:45'),
75(89, 'anu.cocoalabs+22@gmail.com', '$2y$13$b1xhgUiWmVsn0fxcoZDpCOHRNH8yInXi82bDW/VDq2VT6raiUI8vS', '3u0G7um-DFfB9tQqwJNlE2J9ZcP_5PLX_1497508144', NULL, '2017-06-16 06:29:04', NULL, NULL, 150, 1, 1, NULL, '2017-06-15 06:29:04'),
76(90, 'anugra+17@cocoalabs.in', '$2y$13$IMP6gEQEdirbqcN8n2sCwOT3L0aOr0nKilmwUtSVHCbsePSn1NLN.', NULL, NULL, '2017-06-14 06:50:54', NULL, NULL, 151, 1, 1, NULL, '2017-06-15 06:50:54'),
77(91, 'anu.cocoalabs+23@gmail.com', '$2y$13$DllrQcQvOixQQXK1WJSE..d3.Rx8CUrEWMnvPoHLPaDqc10H/BZRS', 'bDDaK_mN7qoopFN-JRHzt7w4uSAJtiSv_1497509786', NULL, '2017-06-16 06:56:26', NULL, NULL, 152, 1, 1, NULL, '2017-06-15 06:56:26'),
78(92, 'anu.cocoalabs+25@gmail.com', '$2y$13$tEvQLxZ2S/TBJMBRehGtJ.k8LpFoThauJN9OsuciKoifpO6XyPAbC', NULL, NULL, '2017-06-14 08:31:44', NULL, NULL, 153, 1, 1, NULL, '2017-06-15 08:31:44'),
79(93, 'anu.cocoalabs+26@gmail.com', '$2y$13$ByUCvPrjqMVO1Apt4lPF9.hXpgonBN8cyokB2NnJaaIuaqVAK/zA2', 'IWXzxuzsrbhUZ3UqzurwiJyhnYeAWOVz_1497515048', NULL, '2017-06-16 08:24:08', NULL, NULL, 154, 0, 1, NULL, '2017-06-15 08:34:32'),
80(94, 'anu.cocoalabs+151@gmail.com', '$2y$13$uAUdBZNUGQwSMEFhmIJWVOdZN9rSc6uqMtdGYj.XLfEsyE.Tno1G.', 'DuNggFUNudUE51npbRea82_8VtjW0jtK_1497515704', NULL, '2017-06-16 08:35:04', NULL, NULL, 155, 1, 1, NULL, '2017-06-15 08:35:04'),
81(95, 'anu.cocoalabs+28@gmail.com', '$2y$13$cx7bYkugOaOzf6/x6lORiOb.hsJv9KnMy8W8ffcrYPKlzimoJKmEy', NULL, NULL, '2017-06-15 05:03:41', NULL, NULL, 156, 1, 1, NULL, '2017-06-16 05:03:41'),
82(96, 'anugra+4@cocoalabs.in', '$2y$13$0MdkEvEaOCoK9Zpgwg.OEewMyKw.m/BvDQBcfbn8/vB58LsYXfqcS', NULL, NULL, '2017-06-15 04:58:08', NULL, NULL, 158, 1, 1, NULL, '2017-06-16 04:58:08'),
83(97, 'anu.cocoalabs+00@gmail.com', '$2y$13$9eJmppdsJ1gY11d62KJWn.CPtkbAvPnZKG0Muq/NHunB1R1tQvD4u', NULL, NULL, '2017-06-15 07:46:09', NULL, NULL, 159, 1, 1, NULL, '2017-06-16 07:46:09'),
84(98, 'anugra+00@cocoalabs.in', '$2y$13$iv6bL5JGbgf8Zsyg.7iNO.FOmUZUMwgRI/ffBGXxNpZeQcbs71SVC', NULL, NULL, '2017-06-15 09:02:23', NULL, NULL, 160, 1, 1, NULL, '2017-06-17 06:29:05'),
85(99, 'anugra+16@cocoalabs.in', '$2y$13$nWrUEv.SdeE4Y8Zr.fo.tObAfuJdGP2qfzl20fVVUQGuTyCCQWetK', 'kkzDF_yvrhk5_CEaC5FXWFm_EkCSNj2p_1497681197', NULL, '2017-06-18 06:33:17', NULL, NULL, 161, 1, 1, NULL, '2017-06-17 06:33:17'),
86(100, 'anu.cocoalabs+13@gmail.com', '$2y$13$EPIZiUYXc/7aDdVdhWURJuTrW905aXGaM/dj/9lUZZBAXVk6UPbXm', NULL, NULL, '2017-06-16 07:05:10', NULL, NULL, 163, 1, 1, NULL, '2017-06-17 07:05:10'),
87(101, 'anugra+22@cocoalabs.in', '$2y$13$Eud3TJrFfk2fH1nA0zie5O5uqLGcMEgPttZcls0hR1w6cDbUSTAw2', NULL, NULL, '2017-06-16 10:20:40', NULL, NULL, 164, 1, 1, NULL, '2017-06-17 10:20:40'),
88(102, 'anu.cocoalabs+122@gmail.com', '$2y$13$H4ZPI7s0icEXwWmY6KEuG.ir6YFJmQGDzEYUbZ9wUON3W2yd5S98G', '5u5VMKd8mSTajXvBuPmscZB5MxTO2luK_1497683350', NULL, '2017-06-18 07:09:10', NULL, NULL, 165, 1, 1, NULL, '2017-06-17 07:09:10'),
89(103, 'anu.cocoalabs+14@gmail.com', '$2y$13$0nDvEeaW8kZbUd6UVjMbY.MwFjemkpPxE22pgJeAtWG1PApAkdbcm', 'HONaQvquPqON5-m9hBwYt31zsX5g67ZD_1497683738', NULL, '2017-06-18 07:15:38', NULL, NULL, 166, 1, 1, NULL, '2017-06-17 07:15:38'),
90(104, 'anu.cocoalabs+15@gmail.com', '$2y$13$S4ww.LuqtPKh/TaK5vP/9OoA3.BJF98A.W5MtXRxVtxcXw8y8pWx6', 'OpbVbkhziF3YHXI3Ke7C35tWor2rYHl6_1497683941', NULL, '2017-06-18 07:19:01', NULL, NULL, 167, 1, 1, NULL, '2017-06-17 07:19:01'),
91(105, 'anu.cocodfdsalabs+11@gmail.com', '$2y$13$zFiuvDy343FZM2mR9KbWTOej2WMuNLMEpSgB86b640XAFHNJbE5QK', 'tBZ6m-d1GRQgK2LhEqEv6LmOno8P09hT_1497689793', NULL, '2017-06-18 08:56:33', NULL, NULL, 170, 0, 1, NULL, '2017-06-17 09:17:33'),
92(106, 'anugra+109@cocoalabs.in', '$2y$13$jSZoAJLA0yF8wy6Hc6iTX.a8uonUBkGHggvT2hP1X.lEfAOQiW4Em', 'ejr7zMug7PW5NK5KvcPyF2I0wvlkgppY_1497700182', NULL, '2017-06-18 11:49:42', NULL, NULL, 174, 1, 1, NULL, '2017-06-17 11:49:42'),
93(107, 'anugra+134@cocoalabs.in', '$2y$13$FN9qqKRMRgCOKAcHUNbJ9OPqonH07GW/Wrbt.z7rioSq/43F.IYHS', 'FNoF1mDIyLLOIvMTwraUKWwYqGUS3kL5_1497700347', NULL, '2017-06-18 11:52:27', NULL, NULL, 175, 1, 1, NULL, '2017-06-17 11:52:27'),
94(108, 'anugra+901@cocoalabs.in', '$2y$13$offUgr7ulpt/3CQVdryVceajeZo33PvhhzOiO9teNvbZj.775jAPu', '77pMu9V1UMWaBe_V9QrGMAkgGTMC6hag_1497878464', NULL, '2017-06-20 13:21:04', NULL, NULL, 176, 1, 1, NULL, '2017-06-19 13:21:04'),
95(109, 'sunubhai+11@cocoalabs.in', '$2y$13$/5UHCfFYkg2p2DtGLyLePuNaK4scquu2F7XwcU6ZpLVYF8iQl8FmC', 'fm6GDeu78izp_hVjKezkxhHdhhTT3vei_1497864772', NULL, '2017-06-20 09:32:52', NULL, NULL, 178, 1, 1, NULL, '2017-06-19 09:32:52');
96
97-- --------------------------------------------------------
98
99--
100-- Table structure for table `activity_log`
101--
102
103CREATE TABLE IF NOT EXISTS `activity_log` (
104  `id` int(11) NOT NULL AUTO_INCREMENT,
105  `fk_account` int(11) DEFAULT NULL,
106  `ip` varchar(45) DEFAULT NULL,
107  `location_info` text,
108  `created_at` timestamp NULL DEFAULT NULL,
109  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
110  `status` int(11) DEFAULT '1',
111  PRIMARY KEY (`id`),
112  KEY `fk_activity_log_account_idx` (`fk_account`)
113) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
114
115-- --------------------------------------------------------
116
117--
118-- Table structure for table `address`
119--
120
121CREATE TABLE IF NOT EXISTS `address` (
122  `id` int(11) NOT NULL AUTO_INCREMENT,
123  `title` varchar(255) DEFAULT NULL,
124  `address_line1` varchar(255) DEFAULT NULL,
125  `address_line2` varchar(255) DEFAULT NULL,
126  `address_line3` varchar(255) DEFAULT NULL,
127  `fk_locality` int(11) DEFAULT NULL,
128  `fk_state` int(11) DEFAULT NULL,
129  `fk_city` int(11) DEFAULT NULL,
130  `fk_district` int(11) DEFAULT NULL,
131  `fk_country` int(11) DEFAULT NULL,
132  `status` int(11) DEFAULT NULL,
133  `created_at` timestamp NULL DEFAULT NULL,
134  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
135  PRIMARY KEY (`id`),
136  KEY `fk_address_city_idx` (`fk_city`),
137  KEY `fk_address_district_idx` (`fk_district`),
138  KEY `fk_address_state_idx` (`fk_state`),
139  KEY `fk_address_country_idx` (`fk_country`),
140  KEY `fk_locality` (`fk_locality`)
141) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=181 ;
142
143--
144-- Dumping data for table `address`
145--
146
147INSERT INTO `address` (`id`, `title`, `address_line1`, `address_line2`, `address_line3`, `fk_locality`, `fk_state`, `fk_city`, `fk_district`, `fk_country`, `status`, `created_at`, `modified_at`) VALUES
148(144, NULL, 'Cocoalabs', 'Indeevaram', 'Koratty', 84, 52, 73, 57, 39, 1, '2017-06-14 00:00:00', '2017-06-17 05:24:24'),
149(145, NULL, 'Rose nagar', '', NULL, 85, 51, 74, 58, 39, NULL, NULL, '2017-06-14 13:09:36'),
150(146, NULL, 'anasseril', '', NULL, 86, 51, 74, 58, 39, NULL, NULL, '2017-06-14 13:10:38'),
151(147, NULL, 'anasseril', 'anasseril', NULL, 86, 51, 74, 58, 39, NULL, NULL, '2017-06-14 13:18:11'),
152(148, NULL, 'Cocoalabs India Pvt Ltd', 'Nalukettu Road', '', 84, 52, 73, 57, 39, NULL, NULL, '2017-06-17 08:39:29'),
153(149, NULL, 'Thommankuthu', 'Karimannoor', NULL, 87, 51, 75, 59, 39, NULL, NULL, '2017-06-15 04:27:15'),
154(150, NULL, 'Panamgar Nagar', '', NULL, 85, 51, 76, 60, 39, NULL, NULL, '2017-06-15 05:24:44'),
155(151, NULL, 'Vihat nagar', '', NULL, 88, 52, 77, 61, 39, NULL, NULL, '2017-06-15 06:29:03'),
156(152, NULL, 'Chirappady', 'Kothamangalam', NULL, 89, 51, 78, 62, 39, NULL, NULL, '2017-06-15 06:50:12'),
157(153, NULL, 'sree nagar', '', NULL, 90, 51, 79, 62, 39, NULL, NULL, '2017-06-15 06:56:25'),
158(154, NULL, 'Wallet Road', '', NULL, 85, 51, 80, 57, 39, NULL, NULL, '2017-06-15 08:23:36'),
159(155, NULL, 'Wallet Road', '', NULL, 85, 51, 80, 57, 39, NULL, NULL, '2017-06-15 08:24:07'),
160(156, NULL, 'dfg', '', NULL, 85, 51, 79, 62, 39, NULL, NULL, '2017-06-15 08:35:03'),
161(157, NULL, 'Kanna Junction', '', NULL, 85, 51, 81, 62, 39, NULL, NULL, '2017-06-15 08:37:18'),
162(158, NULL, 'Vannappuram', 'Mundanmudi', NULL, 87, 51, 82, 59, 39, NULL, NULL, '2017-06-15 09:26:14'),
163(159, NULL, 'ethrsths', 'dfgbfgb', NULL, 92, 51, 83, 63, 40, NULL, NULL, '2017-06-16 08:48:53'),
164(160, NULL, 'indeevaram', '', '', 84, 51, 73, 57, 39, NULL, NULL, '2017-06-16 07:48:29'),
165(161, NULL, 'Kaloor', '', NULL, 93, 52, 79, 62, 40, NULL, NULL, '2017-06-16 09:34:05'),
166(162, NULL, 'Vannappuram', 'Pothanikadu', NULL, 87, 52, 85, 63, 39, NULL, NULL, '2017-06-17 06:33:17'),
167(163, NULL, 'Vannappuram', 'Kaliyar', NULL, 94, 52, 79, 62, 39, NULL, NULL, '2017-06-17 06:53:27'),
168(164, NULL, 'University Junction ', '', NULL, 85, 52, 86, 62, 39, NULL, NULL, '2017-06-17 07:01:42'),
169(165, NULL, 'Vannappuram', 'Aluva', NULL, 95, 52, 87, 61, 39, NULL, NULL, '2017-06-17 07:04:57'),
170(166, NULL, 'Vihat nagar', '', NULL, 97, 52, 86, 62, 39, NULL, NULL, '2017-06-17 07:14:19'),
171(167, NULL, 'Housing Colony', '', NULL, 85, 52, 88, 65, 39, NULL, NULL, '2017-06-17 07:16:21'),
172(168, NULL, 'Kmk Junction ', '', NULL, 85, 52, 89, 66, 39, NULL, NULL, '2017-06-17 07:19:00'),
173(169, NULL, 'Vannappuram', 'Kaliyar', NULL, 86, 52, 74, 58, 39, NULL, NULL, '2017-06-17 07:24:44'),
174(170, NULL, 'Vannappuram', 'Kaliyar', NULL, 87, 52, 75, 59, 39, NULL, NULL, '2017-06-17 07:33:14'),
175(171, NULL, 'ewr', '', NULL, 85, 51, 90, 67, 39, NULL, NULL, '2017-06-17 09:16:34'),
176(172, NULL, 'AKM', 'aegvzsv', NULL, 87, 52, 75, 59, 39, NULL, NULL, '2017-06-17 09:06:41'),
177(173, NULL, 'COCOALABS INDIA PVT LTD , INDEEVARAM, INFOPARK, KORATTY', 'aegvzsv', NULL, 98, 52, 76, 60, 39, NULL, NULL, '2017-06-17 09:43:55'),
178(174, NULL, 'Vannappuram', 'Kaliyar', NULL, 99, 52, 82, 59, 39, NULL, NULL, '2017-06-17 10:47:52'),
179(175, NULL, 'AKM', '', NULL, 100, 52, 89, 66, 39, NULL, NULL, '2017-06-17 11:49:41'),
180(176, NULL, 'a', '', NULL, 84, 52, 73, 57, 39, NULL, NULL, '2017-06-17 11:52:26'),
181(177, NULL, 'Pothanikadu', '', NULL, 87, 52, 75, 59, 39, NULL, NULL, '2017-06-19 04:18:33'),
182(178, NULL, 'Kakkanad', 'Vpm', NULL, 94, 52, 83, 63, 39, NULL, NULL, '2017-06-19 04:44:18'),
183(179, NULL, 'fgsg', 'sfsdf', NULL, 101, 52, 76, 60, 39, NULL, NULL, '2017-06-19 09:32:51'),
184(180, NULL, 'dshf', 'gbkjlnk', NULL, 84, 52, 73, 57, 39, NULL, NULL, '2017-06-19 09:33:24');
185
186-- --------------------------------------------------------
187
188--
189-- Table structure for table `auth`
190--
191
192CREATE TABLE IF NOT EXISTS `auth` (
193  `id` int(11) NOT NULL,
194  `fk_user_id` int(11) NOT NULL,
195  `source` text NOT NULL,
196  `source_id` text NOT NULL,
197  KEY `fk_auth_user_idx` (`fk_user_id`)
198) ENGINE=MyISAM DEFAULT CHARSET=latin1;
199
200-- --------------------------------------------------------
201
202--
203-- Table structure for table `auth_assignment`
204--
205
206CREATE TABLE IF NOT EXISTS `auth_assignment` (
207  `item_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
208  `user_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
209  `created_at` int(11) DEFAULT NULL,
210  PRIMARY KEY (`item_name`,`user_id`)
211) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
212
213--
214-- Dumping data for table `auth_assignment`
215--
216
217INSERT INTO `auth_assignment` (`item_name`, `user_id`, `created_at`) VALUES
218('Normal User', '100', NULL),
219('Normal User', '101', NULL),
220('Normal User', '102', NULL),
221('Normal User', '103', NULL),
222('Normal User', '104', NULL),
223('Normal User', '105', NULL),
224('Normal User', '106', NULL),
225('Normal User', '107', NULL),
226('Normal User', '108', NULL),
227('Normal User', '109', NULL),
228('Normal User', '31', NULL),
229('Normal User', '32', NULL),
230('Normal User', '33', NULL),
231('Normal User', '34', NULL),
232('Normal User', '35', NULL),
233('Normal User', '36', NULL),
234('Normal User', '37', NULL),
235('Normal User', '38', NULL),
236('Normal User', '39', NULL),
237('Normal User', '40', NULL),
238('Normal User', '41', NULL),
239('Normal User', '42', NULL),
240('Normal User', '43', NULL),
241('Normal User', '44', NULL),
242('Normal User', '45', NULL),
243('Normal User', '46', NULL),
244('Normal User', '47', NULL),
245('Normal User', '48', NULL),
246('Normal User', '49', NULL),
247('Normal User', '50', NULL),
248('Normal User', '51', NULL),
249('Normal User', '52', NULL),
250('Normal User', '53', NULL),
251('Normal User', '54', NULL),
252('Normal User', '55', NULL),
253('Normal User', '56', NULL),
254('Normal User', '57', NULL),
255('Normal User', '58', NULL),
256('Normal User', '59', NULL),
257('Normal User', '60', NULL),
258('Normal User', '61', NULL),
259('Normal User', '62', NULL),
260('Normal User', '63', NULL),
261('Normal User', '64', NULL),
262('Normal User', '65', NULL),
263('Normal User', '66', NULL),
264('Normal User', '67', NULL),
265('Normal User', '68', NULL),
266('Normal User', '69', NULL),
267('Normal User', '70', NULL),
268('Normal User', '71', NULL),
269('Normal User', '72', NULL),
270('Normal User', '73', NULL),
271('Normal User', '74', NULL),
272('Normal User', '75', NULL),
273('Normal User', '76', NULL),
274('Normal User', '77', NULL),
275('Normal User', '78', NULL),
276('Normal User', '79', NULL),
277('Normal User', '80', NULL),
278('Normal User', '81', NULL),
279('Normal User', '82', NULL),
280('Normal User', '83', NULL),
281('Normal User', '86', NULL),
282('Normal User', '87', NULL),
283('Normal User', '88', NULL),
284('Normal User', '89', NULL),
285('Normal User', '90', NULL),
286('Normal User', '91', NULL),
287('Normal User', '92', NULL),
288('Normal User', '93', NULL),
289('Normal User', '94', NULL),
290('Normal User', '95', NULL),
291('Normal User', '96', NULL),
292('Normal User', '97', NULL),
293('Normal User', '98', NULL),
294('Normal User', '99', NULL),
295('Super Admin', '85', NULL);
296
297-- --------------------------------------------------------
298
299--
300-- Table structure for table `auth_item`
301--
302
303CREATE TABLE IF NOT EXISTS `auth_item` (
304  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
305  `type` smallint(6) NOT NULL,
306  `description` text COLLATE utf8_unicode_ci,
307  `rule_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
308  `data` blob,
309  `created_at` int(11) DEFAULT NULL,
310  `updated_at` int(11) DEFAULT NULL,
311  PRIMARY KEY (`name`),
312  KEY `rule_name` (`rule_name`),
313  KEY `idx-auth_item-type` (`type`)
314) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
315
316--
317-- Dumping data for table `auth_item`
318--
319
320INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
321('Access Company', 2, NULL, NULL, NULL, 1496907828, 1496907828),
322('Access Device', 2, NULL, NULL, NULL, 1496907828, 1496907828),
323('Access Driver', 2, NULL, NULL, NULL, 1496907828, 1496907828),
324('Access Vehicle', 2, NULL, NULL, NULL, 1496907828, 1496907828),
325('Normal User', 1, '', NULL, NULL, 1496908771, 1496927681),
326('Super Admin', 1, NULL, NULL, NULL, 1496907828, 1496907828),
327('View Dashboard', 2, NULL, NULL, NULL, 1496907828, 1496907828);
328
329-- --------------------------------------------------------
330
331--
332-- Table structure for table `auth_item_child`
333--
334
335CREATE TABLE IF NOT EXISTS `auth_item_child` (
336  `parent` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
337  `child` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
338  PRIMARY KEY (`parent`,`child`),
339  KEY `child` (`child`)
340) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
341
342--
343-- Dumping data for table `auth_item_child`
344--
345
346INSERT INTO `auth_item_child` (`parent`, `child`) VALUES
347('Super Admin', 'Access Company'),
348('Super Admin', 'Access Device'),
349('Normal User', 'Access Driver'),
350('Super Admin', 'Access Driver'),
351('Access Driver', 'Access Vehicle'),
352('Normal User', 'Access Vehicle'),
353('Super Admin', 'Access Vehicle'),
354('Normal User', 'View Dashboard'),
355('Super Admin', 'View Dashboard');
356
357-- --------------------------------------------------------
358
359--
360-- Table structure for table `auth_rule`
361--
362
363CREATE TABLE IF NOT EXISTS `auth_rule` (
364  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
365  `data` blob,
366  `created_at` int(11) DEFAULT NULL,
367  `updated_at` int(11) DEFAULT NULL,
368  PRIMARY KEY (`name`)
369) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
370
371-- --------------------------------------------------------
372
373--
374-- Table structure for table `behaviour`
375--
376
377CREATE TABLE IF NOT EXISTS `behaviour` (
378  `id` int(11) NOT NULL AUTO_INCREMENT,
379  `fk_vehicle` int(11) DEFAULT NULL,
380  `fk_driver` int(11) DEFAULT NULL,
381  `speed_kmph` float DEFAULT NULL,
382  `lat` float DEFAULT NULL,
383  `lng` float DEFAULT NULL,
384  `noted_at` timestamp NULL DEFAULT NULL,
385  `created_at` timestamp NULL DEFAULT NULL,
386  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
387  `status` int(11) DEFAULT NULL,
388  `behaviour_type` varchar(45) DEFAULT NULL,
389  PRIMARY KEY (`id`),
390  KEY `fk_behavour_vehicle_idx` (`fk_vehicle`),
391  KEY `fk_behaviour_driver_idx` (`fk_driver`)
392) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
393
394-- --------------------------------------------------------
395
396--
397-- Table structure for table `city`
398--
399
400CREATE TABLE IF NOT EXISTS `city` (
401  `id` int(11) NOT NULL AUTO_INCREMENT,
402  `name` varchar(255) DEFAULT NULL,
403  `code` varchar(45) DEFAULT NULL,
404  `status` int(11) DEFAULT NULL,
405  `created_at` timestamp NULL DEFAULT NULL,
406  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
407  `fk_district` int(11) DEFAULT NULL,
408  PRIMARY KEY (`id`),
409  KEY `fk_city_district_idx` (`fk_district`)
410) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=92 ;
411
412--
413-- Dumping data for table `city`
414--
415
416INSERT INTO `city` (`id`, `name`, `code`, `status`, `created_at`, `modified_at`, `fk_district`) VALUES
417(73, 'Chalakkudy', NULL, 1, '2017-06-14 00:00:00', '2017-06-14 12:57:09', 57),
418(74, 'Neeleswaram', NULL, 1, NULL, '2017-06-17 07:16:21', 58),
419(75, 'Vatakara', NULL, 1, NULL, '2017-06-16 07:50:19', 59),
420(76, 'Chovva', NULL, 1, NULL, '2017-06-15 05:24:44', 60),
421(77, 'Chennai', NULL, 1, NULL, '2017-06-15 06:29:03', 61),
422(78, 'Muvatupuzha', NULL, 1, NULL, '2017-06-15 06:50:12', 62),
423(79, 'Kochi', NULL, 1, NULL, '2017-06-15 06:56:25', 62),
424(80, 'Mannuthi', NULL, 1, NULL, '2017-06-15 08:23:36', 57),
425(81, 'Elamakkara', NULL, 1, NULL, '2017-06-15 08:37:18', 62),
426(82, 'Vannappuram', NULL, 1, NULL, '2017-06-15 09:26:14', 59),
427(83, 'Thodupuzha', NULL, 1, NULL, '2017-06-16 08:24:42', 63),
428(84, 'Thodupuzha', NULL, 1, NULL, '2017-06-16 08:24:42', NULL),
429(85, 'Kothamangalam', NULL, 1, NULL, '2017-06-17 06:33:17', 63),
430(86, 'Palarivattom', NULL, 1, NULL, '2017-06-17 07:01:42', 62),
431(87, 'Palarivattom', NULL, 1, NULL, '2017-06-17 07:14:19', 61),
432(88, 'Neeleswaram', NULL, 1, NULL, '2017-06-17 07:16:21', 65),
433(89, 'Njarakkal', NULL, 1, NULL, '2017-06-17 07:19:00', 66),
434(90, 'Eerode', NULL, 1, NULL, '2017-06-17 09:16:09', 67),
435(91, 'Eerode', NULL, 1, NULL, '2017-06-17 09:16:09', 67);
436
437-- --------------------------------------------------------
438
439--
440-- Table structure for table `company`
441--
442
443CREATE TABLE IF NOT EXISTS `company` (
444  `id` int(11) NOT NULL AUTO_INCREMENT,
445  `fk_package` int(11) DEFAULT NULL,
446  `fk_account` int(11) DEFAULT NULL,
447  `name` varchar(255) DEFAULT NULL,
448  `logo` varchar(255) DEFAULT NULL,
449  `fk_image` int(11) DEFAULT NULL,
450  `fk_address` int(11) DEFAULT NULL,
451  `overspeed_limit` float DEFAULT NULL,
452  `is_banned` int(11) NOT NULL DEFAULT '1',
453  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
454  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
455  `status` int(11) DEFAULT '1',
456  PRIMARY KEY (`id`),
457  KEY `fk_company_package_idx` (`fk_package`),
458  KEY `fk_company_account_idx` (`fk_account`),
459  KEY `fk_company_address_idx` (`fk_address`),
460  KEY `fk_image` (`fk_image`)
461) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
462
463--
464-- Dumping data for table `company`
465--
466
467INSERT INTO `company` (`id`, `fk_package`, `fk_account`, `name`, `logo`, `fk_image`, `fk_address`, `overspeed_limit`, `is_banned`, `created_at`, `modified_at`, `status`) VALUES
468(1, NULL, 86, 'Manushj', NULL, NULL, 145, NULL, 1, '2017-06-14 13:09:37', '2017-06-14 13:09:37', 1),
469(2, NULL, 87, 'Friends', 'Overspeed', NULL, 148, 80, 1, '2017-06-15 04:14:59', '2017-06-15 09:33:19', 1),
470(3, NULL, 88, 'Roopras Pvt Ltd', NULL, NULL, 150, NULL, 1, '2017-06-15 05:24:45', '2017-06-15 05:24:45', 1),
471(4, NULL, 89, 'Mayoor solutions', NULL, NULL, 151, NULL, 1, '2017-06-15 06:29:04', '2017-06-15 06:29:04', 1),
472(5, NULL, 90, 'Holidays', 'ghjkkk', 322, 152, 80, 1, '2017-06-15 06:50:13', '2017-06-15 08:12:58', 1),
473(6, NULL, 91, 'Kallada Travels', NULL, NULL, 153, NULL, 1, '2017-06-15 06:56:26', '2017-06-15 06:56:26', 1),
474(7, NULL, 92, 'Uber', NULL, NULL, 154, NULL, 1, '2017-06-15 08:23:36', '2017-06-15 08:23:36', 1),
475(10, NULL, 95, 'Maruti', NULL, NULL, 157, NULL, 1, '2017-06-15 08:37:19', '2017-06-15 08:37:19', 1),
476(11, NULL, 96, 'Cool', 'cmvh', NULL, 159, 80, 1, '2017-06-16 04:56:33', '2017-06-16 05:05:32', 1),
477(12, NULL, 97, 'folia animates', NULL, NULL, 160, NULL, 1, '2017-06-16 07:45:24', '2017-06-16 07:45:24', 1),
478(13, NULL, 98, 'Machan''s', '', NULL, 161, 120, 1, '2017-06-16 09:01:48', '2017-06-17 06:29:05', 1),
479(14, NULL, 99, 'Kunjuz', 'dsrjdtdytj', NULL, 162, 80, 1, '2017-06-17 06:33:18', '2017-06-17 06:34:32', 1),
480(15, NULL, 100, 'Appolo', NULL, NULL, 164, NULL, 1, '2017-06-17 07:01:44', '2017-06-17 07:01:44', 1),
481(16, NULL, 101, 'Appuz', NULL, NULL, 165, NULL, 1, '2017-06-17 07:04:58', '2017-06-17 07:04:58', 1),
482(17, NULL, 102, 'Pappy', NULL, NULL, 166, NULL, 1, '2017-06-17 07:09:10', '2017-06-17 07:09:10', 1),
483(18, NULL, 103, 'Meenaz ', NULL, NULL, 167, NULL, 1, '2017-06-17 07:15:38', '2017-06-17 07:15:38', 1),
484(19, NULL, 104, 'Riyan Furnitures', NULL, NULL, 168, NULL, 1, '2017-06-17 07:19:01', '2017-06-17 07:19:01', 1),
485(20, NULL, 105, 'erewrewr', NULL, NULL, 171, NULL, 0, '2017-06-17 08:56:33', '2017-06-17 09:17:33', 1),
486(21, NULL, 106, 'Achayan''s', NULL, NULL, 175, NULL, 1, '2017-06-17 11:49:42', '2017-06-17 11:49:42', 1),
487(22, NULL, 107, 'Bismi', NULL, NULL, 176, NULL, 1, '2017-06-17 11:52:27', '2017-06-17 11:52:27', 1),
488(23, NULL, 108, 'Uduppi', '', 416, 177, 80, 1, '2017-06-19 04:18:35', '2017-06-19 04:21:39', 1),
489(24, NULL, 109, 'appzoc', 'dgtyh', NULL, 179, 67, 1, '2017-06-19 09:32:52', '2017-06-19 13:16:11', 1);
490
491-- --------------------------------------------------------
492
493--
494-- Table structure for table `country`
495--
496
497CREATE TABLE IF NOT EXISTS `country` (
498  `id` int(11) NOT NULL AUTO_INCREMENT,
499  `name` varchar(255) DEFAULT NULL,
500  `code` varchar(45) DEFAULT NULL,
501  `status` int(11) DEFAULT '1',
502  `created_at` timestamp NULL DEFAULT NULL,
503  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
504  PRIMARY KEY (`id`)
505) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 ;
506
507--
508-- Dumping data for table `country`
509--
510
511INSERT INTO `country` (`id`, `name`, `code`, `status`, `created_at`, `modified_at`) VALUES
512(39, 'India', NULL, 1, '2017-06-14 00:00:00', '2017-06-16 09:35:24'),
513(40, 'Inddia', NULL, NULL, NULL, '2017-06-16 09:35:28'),
514(41, 'America', NULL, NULL, NULL, '2017-06-16 08:46:53');
515
516-- --------------------------------------------------------
517
518--
519-- Table structure for table `device`
520--
521
522CREATE TABLE IF NOT EXISTS `device` (
523  `id` int(11) NOT NULL AUTO_INCREMENT,
524  `serial_no` double DEFAULT NULL,
525  `imei_no` varchar(255) DEFAULT NULL,
526  `sim_no` int(11) DEFAULT NULL,
527  `fk_vehicle` int(11) DEFAULT NULL,
528  `is_banned` int(11) NOT NULL DEFAULT '1',
529  `created_at` timestamp NULL DEFAULT NULL,
530  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
531  `status` int(11) DEFAULT '1',
532  PRIMARY KEY (`id`),
533  KEY `fk_device_vehicle_idx` (`fk_vehicle`)
534) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
535
536--
537-- Dumping data for table `device`
538--
539
540INSERT INTO `device` (`id`, `serial_no`, `imei_no`, `sim_no`, `fk_vehicle`, `is_banned`, `created_at`, `modified_at`, `status`) VALUES
541(1, 77777, '324324', 21212, 36, 1, NULL, '2017-06-15 08:45:57', 1),
542(2, 998, '456788', 54669809, 39, 1, NULL, '2017-06-15 07:13:55', 1),
543(3, 9877, '6576', 58770979, 36, 1, NULL, '2017-06-15 08:46:04', 1),
544(4, 678, '56', 2147483647, 36, 1, NULL, '2017-06-15 08:46:00', 1),
545(5, 23435, '8709098', 2147483647, 38, 1, NULL, '2017-06-15 08:06:09', 1),
546(6, 688, '435658689', 2147483647, 39, 1, NULL, '2017-06-15 08:46:16', 0),
547(7, 8999, '6757899', 2147483647, 35, 1, NULL, '2017-06-15 08:07:25', 1),
548(8, 3432424324, '324324', 3243243, 38, 1, NULL, '2017-06-15 08:08:10', 1),
549(9, 66666, '666', 6666666, 36, 1, NULL, '2017-06-15 08:46:39', 0),
550(10, 88988, '76876797', 4556789, 38, 1, NULL, '2017-06-15 08:09:42', 1),
551(11, 554554, '43534', 32131, 40, 1, NULL, '2017-06-17 06:04:19', 0),
552(12, 12345, '324324', 21212, 37, 1, NULL, '2017-06-16 06:14:09', 1),
553(13, 324324, '234324', 32423432, 37, 1, NULL, '2017-06-16 06:16:00', 1),
554(14, 56465646, '54654654', 546456546, 38, 1, NULL, '2017-06-16 06:17:15', 1),
555(15, 565464, '45654', 654654, 37, 1, NULL, '2017-06-16 07:21:30', 1),
556(16, 32432, '432432', 324324, 36, 1, NULL, '2017-06-17 05:03:56', 1),
557(17, 76876, '67876', 76867, 38, 1, NULL, '2017-06-17 05:04:28', 1),
558(18, 57698670, '65876896709', 2147483647, 36, 1, NULL, '2017-06-17 05:27:51', 1),
559(19, 57658, '876986987', 2147483647, 39, 1, NULL, '2017-06-17 06:02:39', 1),
560(20, 6986, '6896', 587698, 37, 1, NULL, '2017-06-17 06:06:16', 1),
561(21, 435345435, '345345', 5345345, 37, 1, NULL, '2017-06-17 09:18:30', 1),
562(22, 2435235, '2354642', 245235, 53, 1, NULL, '2017-06-19 04:54:02', 1),
563(23, 454747, '74574', 7867896, 36, 1, NULL, '2017-06-19 13:12:34', 1);
564
565-- --------------------------------------------------------
566
567--
568-- Table structure for table `device_vehicle_map`
569--
570
571CREATE TABLE IF NOT EXISTS `device_vehicle_map` (
572  `id` int(11) NOT NULL AUTO_INCREMENT,
573  `fk_device` int(11) DEFAULT NULL,
574  `fk_vehicle` int(11) DEFAULT NULL,
575  `created_at` timestamp NULL DEFAULT NULL,
576  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
577  `status` int(11) DEFAULT '1',
578  PRIMARY KEY (`id`),
579  KEY `fk_device_vehicle_map_vehicle_idx` (`fk_vehicle`),
580  KEY `fk_device_vehicle_map_device_idx` (`fk_device`)
581) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
582
583-- --------------------------------------------------------
584
585--
586-- Table structure for table `district`
587--
588
589CREATE TABLE IF NOT EXISTS `district` (
590  `id` int(11) NOT NULL AUTO_INCREMENT,
591  `name` varchar(255) DEFAULT NULL,
592  `code` varchar(45) DEFAULT NULL,
593  `status` int(11) DEFAULT NULL,
594  `created_at` timestamp NULL DEFAULT NULL,
595  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
596  `fk_state` int(11) DEFAULT NULL,
597  PRIMARY KEY (`id`),
598  KEY `fk_district_state_idx` (`fk_state`)
599) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;
600
601--
602-- Dumping data for table `district`
603--
604
605INSERT INTO `district` (`id`, `name`, `code`, `status`, `created_at`, `modified_at`, `fk_state`) VALUES
606(57, 'Thrissur', NULL, 1, '2017-06-14 00:00:00', '2017-06-17 07:13:12', 52),
607(58, 'Kasargod', NULL, 1, NULL, '2017-06-17 07:16:21', 52),
608(59, 'Kozhikode', NULL, 1, NULL, '2017-06-17 07:13:18', 52),
609(60, 'Kannur', NULL, 1, NULL, '2017-06-17 07:13:32', 52),
610(61, 'Ernakulam', NULL, 1, NULL, '2017-06-17 07:14:19', 51),
611(62, 'Ernakulam', NULL, 1, NULL, '2017-06-17 07:13:35', 52),
612(63, 'Idukki', NULL, 1, NULL, '2017-06-17 07:13:38', 52),
613(65, 'Kasargod', NULL, 1, NULL, '2017-06-17 07:16:21', 52),
614(66, 'Thiruvananthapuram', NULL, 1, NULL, '2017-06-17 07:19:00', 52),
615(67, 'Chennai', NULL, 1, NULL, '2017-06-17 08:56:32', 51);
616
617-- --------------------------------------------------------
618
619--
620-- Table structure for table `document`
621--
622
623CREATE TABLE IF NOT EXISTS `document` (
624  `id` int(11) NOT NULL AUTO_INCREMENT,
625  `title` varchar(255) DEFAULT NULL,
626  `fk_vehicle` int(11) DEFAULT NULL,
627  `fk_driver` int(11) DEFAULT NULL,
628  `status` int(11) DEFAULT '1',
629  `created_at` timestamp NULL DEFAULT NULL,
630  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
631  PRIMARY KEY (`id`),
632  KEY `fk_document_vehicle_idx` (`fk_vehicle`),
633  KEY `fk_document_driver_idx` (`fk_driver`)
634) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=168 ;
635
636--
637-- Dumping data for table `document`
638--
639
640INSERT INTO `document` (`id`, `title`, `fk_vehicle`, `fk_driver`, `status`, `created_at`, `modified_at`) VALUES
641(146, '', 38, NULL, 1, NULL, '2017-06-15 05:58:08'),
642(147, '', 43, NULL, 1, NULL, '2017-06-15 10:12:26'),
643(148, 'sdfsfs', NULL, 26, 1, NULL, '2017-06-17 09:38:25'),
644(149, '', NULL, 26, 1, NULL, '2017-06-15 12:16:54'),
645(150, '', NULL, 26, 1, NULL, '2017-06-15 12:17:36'),
646(151, 'xdfvgsdgsdg', NULL, 27, 1, NULL, '2017-06-15 12:43:18'),
647(152, '', NULL, 27, 1, NULL, '2017-06-15 13:03:25'),
648(153, '', NULL, 27, 1, NULL, '2017-06-16 04:47:52'),
649(154, '', NULL, 27, 1, NULL, '2017-06-16 04:51:44'),
650(155, '', NULL, 26, 1, NULL, '2017-06-16 11:26:25'),
651(156, 'Abcd', 50, NULL, 1, NULL, '2017-06-17 07:36:04'),
652(157, 'dummy', 49, NULL, 1, NULL, '2017-06-17 07:37:26'),
653(158, 'sdfsgsg', 49, NULL, 1, NULL, '2017-06-17 08:40:55'),
654(159, 'rgegete', 50, NULL, 1, NULL, '2017-06-17 08:42:13'),
655(160, 'hgfjygk', 51, NULL, 1, NULL, '2017-06-17 09:12:44'),
656(161, 'hjjg', 51, NULL, 1, NULL, '2017-06-17 09:14:14'),
657(162, 'hgcgj', NULL, 31, 1, NULL, '2017-06-17 09:46:39'),
658(163, 'fhjfh', NULL, 30, 1, NULL, '2017-06-17 10:28:25'),
659(164, 'fagd', NULL, 32, 1, NULL, '2017-06-17 10:48:26'),
660(165, 'jhkj', 51, NULL, 1, NULL, '2017-06-19 06:03:18'),
661(166, 'Ddas', 53, NULL, 1, NULL, '2017-06-19 09:46:48'),
662(167, 'bb', NULL, 33, 1, NULL, '2017-06-22 05:38:04');
663
664-- --------------------------------------------------------
665
666--
667-- Table structure for table `document_image_map`
668--
669
670CREATE TABLE IF NOT EXISTS `document_image_map` (
671  `id` int(11) NOT NULL AUTO_INCREMENT,
672  `fk_document` int(11) DEFAULT NULL,
673  `fk_image` int(11) DEFAULT NULL,
674  `created_at` timestamp NULL DEFAULT NULL,
675  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
676  `status` int(11) DEFAULT '1',
677  PRIMARY KEY (`id`),
678  KEY `fk_document_image_map_document_idx` (`fk_document`),
679  KEY `fk_document_image_map_image_idx` (`fk_image`)
680) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=228 ;
681
682--
683-- Dumping data for table `document_image_map`
684--
685
686INSERT INTO `document_image_map` (`id`, `fk_document`, `fk_image`, `created_at`, `modified_at`, `status`) VALUES
687(169, 151, 326, NULL, NULL, 1),
688(170, 151, 327, NULL, NULL, 1),
689(171, 153, 337, NULL, NULL, 1),
690(172, 154, 338, NULL, NULL, 1),
691(179, 157, 359, NULL, NULL, 1),
692(185, 158, 367, NULL, NULL, 1),
693(186, 158, 368, NULL, NULL, 1),
694(187, 159, 370, NULL, NULL, 1),
695(188, 159, 371, NULL, NULL, 1),
696(189, 159, 372, NULL, NULL, 1),
697(191, 159, 374, NULL, NULL, 1),
698(192, 160, 387, NULL, NULL, 1),
699(193, 160, 388, NULL, NULL, 1),
700(194, 160, 389, NULL, NULL, 1),
701(195, 160, 390, NULL, NULL, 1),
702(196, 160, 391, NULL, NULL, 1),
703(197, 161, 392, NULL, NULL, 1),
704(199, 161, 394, NULL, NULL, 1),
705(200, 161, 395, NULL, NULL, 1),
706(201, 161, 396, NULL, NULL, 1),
707(202, 148, 397, NULL, NULL, 1),
708(203, 162, 398, NULL, NULL, 1),
709(204, 162, 399, NULL, NULL, 1),
710(205, 162, 400, NULL, NULL, 1),
711(206, 162, 401, NULL, NULL, 1),
712(207, 162, 402, NULL, NULL, 1),
713(208, 162, 403, NULL, NULL, 1),
714(209, 163, 404, NULL, NULL, 1),
715(210, 163, 405, NULL, NULL, 1),
716(211, 163, 406, NULL, NULL, 1),
717(215, 164, 410, NULL, NULL, 1),
718(217, 164, 412, NULL, NULL, 1),
719(218, 164, 413, NULL, NULL, 1),
720(219, 164, 414, NULL, NULL, 1),
721(220, 164, 415, NULL, NULL, 1),
722(221, 165, 420, NULL, NULL, 1),
723(222, 166, 427, NULL, NULL, 1),
724(223, 166, 428, NULL, NULL, 1),
725(224, 166, 429, NULL, NULL, 1),
726(226, 166, 431, NULL, NULL, 1),
727(227, 167, 432, NULL, NULL, 1);
728
729-- --------------------------------------------------------
730
731--
732-- Table structure for table `driver`
733--
734
735CREATE TABLE IF NOT EXISTS `driver` (
736  `id` int(11) NOT NULL AUTO_INCREMENT,
737  `fk_person` int(11) DEFAULT NULL,
738  `fk_company` int(11) DEFAULT NULL,
739  `fk_vehicle` int(11) DEFAULT NULL,
740  `licence_no` varchar(255) DEFAULT NULL,
741  `notes` text,
742  `rating` float DEFAULT NULL,
743  `created_at` timestamp NULL DEFAULT NULL,
744  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
745  `status` int(11) DEFAULT '1',
746  `is_banned` int(11) NOT NULL DEFAULT '1',
747  `joining_date` date DEFAULT NULL,
748  PRIMARY KEY (`id`),
749  KEY `fk_driver_person_idx` (`fk_person`),
750  KEY `fk_driver_company_idx` (`fk_company`)
751) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
752
753--
754-- Dumping data for table `driver`
755--
756
757INSERT INTO `driver` (`id`, `fk_person`, `fk_company`, `fk_vehicle`, `licence_no`, `notes`, `rating`, `created_at`, `modified_at`, `status`, `is_banned`, `joining_date`) VALUES
758(26, 146, 2, 35, '45657568', NULL, NULL, NULL, '2017-06-15 12:40:32', 1, 0, '1970-01-01'),
759(27, 148, 1, 37, '0978543456', NULL, NULL, NULL, '2017-06-15 09:18:10', 1, 1, '1970-01-01'),
760(28, 157, 2, 37, '76978', NULL, NULL, NULL, '2017-06-15 11:38:51', 0, 1, '1970-01-01'),
761(29, 162, 14, 48, '67858768', NULL, NULL, NULL, '2017-06-17 06:53:27', 1, 1, '2017-06-10'),
762(30, 168, 16, 49, '68776678678', NULL, NULL, NULL, '2017-06-17 12:41:49', 1, 1, '2017-06-13'),
763(31, 172, 2, 36, '1435432', NULL, NULL, NULL, '2017-06-17 10:13:14', 1, 1, '1970-01-01'),
764(32, 173, 16, 50, '545645i58', NULL, NULL, NULL, '2017-06-17 10:51:57', 1, 1, '1970-01-13'),
765(33, 177, 23, 53, '876987', NULL, NULL, NULL, '2017-06-19 04:44:19', 1, 1, '1970-01-01');
766
767-- --------------------------------------------------------
768
769--
770-- Table structure for table `fuel_type`
771--
772
773CREATE TABLE IF NOT EXISTS `fuel_type` (
774  `id` int(11) NOT NULL AUTO_INCREMENT,
775  `name` varchar(255) DEFAULT NULL,
776  `status` int(11) DEFAULT NULL,
777  `created_at` timestamp NULL DEFAULT NULL,
778  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
779  PRIMARY KEY (`id`)
780) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
781
782--
783-- Dumping data for table `fuel_type`
784--
785
786INSERT INTO `fuel_type` (`id`, `name`, `status`, `created_at`, `modified_at`) VALUES
787(1, 'petrol', 1, '2017-05-23 18:30:00', '2017-05-24 12:30:45'),
788(2, 'diesel', 1, '2017-05-23 18:30:00', '2017-05-24 12:30:45');
789
790-- --------------------------------------------------------
791
792--
793-- Table structure for table `gear_type`
794--
795
796CREATE TABLE IF NOT EXISTS `gear_type` (
797  `id` int(11) NOT NULL AUTO_INCREMENT,
798  `name` varchar(45) DEFAULT NULL,
799  `created_at` timestamp NULL DEFAULT NULL,
800  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
801  `status` int(11) DEFAULT '1',
802  PRIMARY KEY (`id`)
803) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
804
805--
806-- Dumping data for table `gear_type`
807--
808
809INSERT INTO `gear_type` (`id`, `name`, `created_at`, `modified_at`, `status`) VALUES
810(1, 'geared', '2017-05-23 18:30:00', '2017-05-24 12:21:16', 1),
811(2, 'gearless', '2017-05-23 18:30:00', '2017-05-24 12:21:16', 1);
812
813-- --------------------------------------------------------
814
815--
816-- Table structure for table `gender`
817--
818
819CREATE TABLE IF NOT EXISTS `gender` (
820  `id` int(11) NOT NULL AUTO_INCREMENT,
821  `name` varchar(45) DEFAULT NULL,
822  `status` int(11) DEFAULT NULL,
823  `created_at` timestamp NULL DEFAULT NULL,
824  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
825  PRIMARY KEY (`id`)
826) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
827
828--
829-- Dumping data for table `gender`
830--
831
832INSERT INTO `gender` (`id`, `name`, `status`, `created_at`, `modified_at`) VALUES
833(1, 'male', NULL, NULL, '2017-05-24 11:35:07'),
834(2, 'female', NULL, NULL, '2017-05-24 11:35:15');
835
836-- --------------------------------------------------------
837
838--
839-- Table structure for table `geofence`
840--
841
842CREATE TABLE IF NOT EXISTS `geofence` (
843  `id` int(11) NOT NULL AUTO_INCREMENT,
844  `lat` float DEFAULT NULL,
845  `lng` float DEFAULT NULL,
846  `fk_vehicle` int(11) DEFAULT NULL,
847  `fk_company` int(11) DEFAULT NULL,
848  `fk_geofence` int(11) DEFAULT NULL COMMENT 'parent point',
849  `status` int(11) DEFAULT NULL,
850  `created_at` timestamp NULL DEFAULT NULL,
851  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
852  `geofencecol` varchar(45) DEFAULT NULL,
853  PRIMARY KEY (`id`),
854  KEY `fk_geofence_vehicle_idx` (`fk_vehicle`),
855  KEY `fk_geofence_geonce_idx` (`fk_geofence`),
856  KEY `fk_geofence_company_idx` (`fk_company`)
857) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
858
859-- --------------------------------------------------------
860
861--
862-- Table structure for table `image`
863--
864
865CREATE TABLE IF NOT EXISTS `image` (
866  `id` int(11) NOT NULL AUTO_INCREMENT,
867  `uri_thumb` varchar(255) DEFAULT NULL,
868  `uri_full` varchar(255) DEFAULT NULL,
869  `uri_medium` varchar(255) DEFAULT NULL,
870  `title` varchar(255) DEFAULT NULL,
871  `flag` int(11) DEFAULT NULL,
872  `status` int(11) DEFAULT NULL,
873  `created_at` timestamp NULL DEFAULT NULL,
874  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
875  PRIMARY KEY (`id`)
876) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=434 ;
877
878--
879-- Dumping data for table `image`
880--
881
882INSERT INTO `image` (`id`, `uri_thumb`, `uri_full`, `uri_medium`, `title`, `flag`, `status`, `created_at`, `modified_at`) VALUES
883(2, 'uploads/download.jpg', 'uploads/download.jpg', NULL, NULL, NULL, NULL, NULL, '2017-05-25 10:13:45'),
884(22, NULL, 'uploads/1-8eb5242eb41c55404cf5210efee2e569d83a8946.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
885(23, NULL, 'uploads/1-6a8f88791974e112f24fe26f5552513dfefe405c.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
886(24, NULL, 'uploads/3-86fcfffa419a345c8549e5e9202d3f082ce41422.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
887(25, NULL, 'uploads/3-d58733044dbc4852e1d5a7d5073f863aee22ab57.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
888(26, NULL, 'uploads/1_635132100886107347-2fdd564e6231daf118428974e6275d4a5967240d.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
889(27, NULL, 'uploads/4-71c395f7e633d704dd55c368577227ccb4fa3691.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
890(28, NULL, 'uploads/download - Copy-fdc7cfb0f65505605309dbec26107609be9581d5.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
891(29, NULL, 'uploads/download - Copy-864cc36485777ae7b7277879b18efe51f513b7c9.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
892(30, NULL, 'uploads/Cafe_Monico_XX - Copy-952786b1f0ca6648cad8d4087d96c2e9a5c586d1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
893(31, NULL, 'uploads/1-fe6c7014587bf560eaede23badc6eedd1bfec573.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
894(32, NULL, 'uploads/Cafe_Monico_XX - Copy-6be4f6ec2dae4f9aeb0aa88e50f15d942e919146.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
895(33, NULL, 'uploads/1_635132100886107347-c81b421f1dd3602f12c1a27fe1a081fb6e1817cf.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
896(34, NULL, 'uploads/1_635132100886107347-a1f3e6a2aedb41e7d95a0a68cd1acd158d9fc95a.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
897(35, NULL, 'uploads/4-d5e4fcd072f06c7ae7c4dbc2b6b9cc69447b0f24.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
898(36, NULL, 'uploads/4-b45359aca26d84972f8bc15c5bf743df36166667.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
899(37, NULL, 'uploads/4-41c6c4f0bdd14d2e12c62de64dd09bcb10b39a58.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
900(38, NULL, 'uploads/Cafe_Monico_XX - Copy-eedf2228d7e51bbe8942a4a29758349081bf4ae8.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
901(39, NULL, 'uploads/1-fa50510dd4ae2cc95ed14f409ba639b945109106.png', NULL, NULL, NULL, NULL, NULL, NULL),
902(40, NULL, 'uploads/2-12f1f3db4758e4e552ebaba321153f5befb95acd.png', NULL, NULL, NULL, NULL, NULL, NULL),
903(41, NULL, 'uploads/3-12f1f3db4758e4e552ebaba321153f5befb95acd.png', NULL, NULL, NULL, NULL, NULL, NULL),
904(42, NULL, 'uploads/2-9a4471e5c90be5a97e3a82ea841f645cb5769aa4.png', NULL, NULL, NULL, NULL, NULL, NULL),
905(43, NULL, 'uploads/3-253d16438f473cf9f3c4d6ab5c518c6519d95fee.png', NULL, NULL, NULL, NULL, NULL, NULL),
906(44, NULL, 'uploads/2-cc31555f775ad517a87e67407205a1ec965ed171.png', NULL, NULL, NULL, NULL, NULL, NULL),
907(45, NULL, 'uploads/1-61361b305f53408c5704f533ba1bc19c9693dcbb.png', NULL, NULL, NULL, NULL, NULL, NULL),
908(47, NULL, 'uploads/Belgian-Cocoa-Shots_4-8b8d457eea216b75fbbc041e09d1f5150886f7b0.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
909(49, NULL, 'uploads/Assam-Tea_2-b3f9d5512fb3602a48590646a45c2029bfc1c39d.png', NULL, NULL, NULL, NULL, NULL, NULL),
910(50, NULL, 'uploads/Aztec-Ethiopian-Coffee_0-b3f9d5512fb3602a48590646a45c2029bfc1c39d.png', NULL, NULL, NULL, NULL, NULL, NULL),
911(51, NULL, 'uploads/2-e20c5d7d69c99bda6071d4b670dbd8afbf30665a.png', NULL, NULL, NULL, NULL, NULL, NULL),
912(52, NULL, 'uploads/3-e20c5d7d69c99bda6071d4b670dbd8afbf30665a.png', NULL, NULL, NULL, NULL, NULL, NULL),
913(53, NULL, 'uploads/2-7f3b97ea94c26cc942707cedcb1f2f8ac565a739.png', NULL, NULL, NULL, NULL, NULL, NULL),
914(54, NULL, 'uploads/3-7f3b97ea94c26cc942707cedcb1f2f8ac565a739.png', NULL, NULL, NULL, NULL, NULL, NULL),
915(57, NULL, 'uploads/Big-Crunch-Chicken-Classic-Burger_0 - Copy-623110a774cb96a374f9ca8eec59972330a14779.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
916(58, NULL, 'uploads/Big-Crunch-Chicken-Classic-Burger_0-623110a774cb96a374f9ca8eec59972330a14779.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
917(62, NULL, 'uploads/3-6c7c0343fa94a2fdd237c93dbd8ebbc97d4a287f.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
918(63, NULL, 'uploads/1-3b2432eddce613e3654f5725d769422d725d8b46.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
919(64, NULL, 'uploads/4-87c61e8c074234cb777ad64749c905ca02ea9619.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
920(65, NULL, 'uploads/download-08d8072543e026583309a9d4827eb40ce4afc915.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
921(82, NULL, 'uploads/1-3e497edefa3a534a76c15a3dace8c794466553a0.png', NULL, NULL, NULL, NULL, NULL, NULL),
922(85, NULL, 'uploads/1604779_1069809083059175_3615869767911685165_n-ee747e6986c2ec32a52b3ba0af5bfe5fa50df03a.png', NULL, NULL, NULL, NULL, NULL, NULL),
923(91, NULL, 'uploads/4-a53fc5722b3b9b35184fcc2c2b165700a7420bf4.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
924(92, NULL, 'uploads/2-9d3f0c4b5846f16bacdcaec677e8127572c598fd.png', NULL, NULL, NULL, NULL, NULL, NULL),
925(95, NULL, 'uploads/3-a8ce50d54b63ceff106bf3f344485f3068b260c7bd32737b92193c96104f36be-01bd7e5d15f476e7b5fa1cdcf5e540899f37adef.png', NULL, NULL, NULL, NULL, NULL, NULL),
926(96, NULL, 'uploads/Contoh Invoice-01bd7e5d15f476e7b5fa1cdcf5e540899f37adef.png', NULL, NULL, NULL, NULL, NULL, NULL),
927(97, NULL, 'uploads/download-01bd7e5d15f476e7b5fa1cdcf5e540899f37adef.png', NULL, NULL, NULL, NULL, NULL, NULL),
928(98, NULL, 'uploads/download-34268b7650fa295e605ce8525b9e3bf266729336.png', NULL, NULL, NULL, NULL, NULL, NULL),
929(99, NULL, 'uploads/free-invoice-34268b7650fa295e605ce8525b9e3bf266729336.gif', NULL, NULL, NULL, NULL, NULL, NULL),
930(100, NULL, 'uploads/free-invoice-0cce2ba36914437d8128711d7875024c602149d4.gif', NULL, NULL, NULL, NULL, NULL, NULL),
931(101, NULL, 'uploads/download - Copy-37b901ced565d82e01478bb384396f770edba2b5.png', NULL, NULL, NULL, NULL, NULL, NULL),
932(102, NULL, 'uploads/download-37b901ced565d82e01478bb384396f770edba2b5.png', NULL, NULL, NULL, NULL, NULL, NULL),
933(103, NULL, 'uploads/1604779_1069809083059175_3615869767911685165_n-1c0ffd269884b9ae0a15fe3954e79a03e29b0c56.png', NULL, NULL, NULL, NULL, NULL, NULL),
934(109, NULL, 'uploads/Cloth House - Copy-378097c27356d680d9286970f8428153480c2173.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
935(110, NULL, 'uploads/Cafe_Monico_XX - Copy-7cf61cc503cd88861fba2e203f62c005d59562a1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
936(111, NULL, 'uploads/3-fdd2daad2b8ee5492ffec35e24f5bbfa6f209fec.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
937(112, NULL, 'uploads/3-d44caf10be009f601431cfcad60a455d6fe42d95.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
938(113, NULL, 'uploads/3-bf85bacfd85fb1fdc557fc8bbc91252bed134b88.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
939(114, NULL, 'uploads/3-059fcac35d061d2ee4a0127fc1bb7c1ab9012a1d.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
940(115, NULL, 'uploads/3-5ef236b907d240e2c372904b4fa7f4abf36cd0ba.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
941(118, NULL, 'uploads/Belgian-Cocoa-Shots_4-3ebdfecc8e1fc3aa06d145418aa29a8c0e407acb.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
942(120, NULL, 'uploads/Big-Crunch-Chicken-Classic-Burger_0-3ebdfecc8e1fc3aa06d145418aa29a8c0e407acb.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
943(121, NULL, 'uploads/1-bb1afbe09001a05185c95d283a233850718dafc9.png', NULL, NULL, NULL, NULL, NULL, NULL),
944(153, NULL, 'uploads/1-48d898f286524b9e0213dad5a2b81f071a4bfb17.png', NULL, NULL, NULL, NULL, NULL, NULL),
945(162, NULL, 'uploads/1604779_1069809083059175_3615869767911685165_n-599d2fd2677457bc8b80e91351b50810905f6c5b.png', NULL, NULL, NULL, NULL, NULL, NULL),
946(165, NULL, 'uploads/Assam-Tea_2-b0091136aba1c35429ca260a0a2a8f69dc0425e3.png', NULL, NULL, NULL, NULL, NULL, NULL),
947(166, NULL, 'uploads/Aztec-Ethiopian-Coffee_0-b2bb6e2fd30cb39dc89e12d912eeab1844a2d4f2.png', NULL, NULL, NULL, NULL, NULL, NULL),
948(167, NULL, 'uploads/500x378-African-Pepper_0-929e1e70a7435f5f5a22901492d30d4368a4869b.png', NULL, NULL, NULL, NULL, NULL, NULL),
949(169, NULL, 'uploads/2-02a7c48c41f26a53ab1107f81a7fb8dcec8e09b7.png', NULL, NULL, NULL, NULL, NULL, NULL),
950(170, NULL, 'uploads/1-f46a8b4533e89f45b4ebe1ec069deefba372b94e.png', NULL, NULL, NULL, NULL, NULL, NULL),
951(171, NULL, 'uploads/2-f46a8b4533e89f45b4ebe1ec069deefba372b94e.png', NULL, NULL, NULL, NULL, NULL, NULL),
952(172, NULL, 'uploads/3-f46a8b4533e89f45b4ebe1ec069deefba372b94e.png', NULL, NULL, NULL, NULL, NULL, NULL),
953(173, NULL, 'uploads/1-809d6fe6e452196377dfdf0443ef89a2f3b88a2c.png', NULL, NULL, NULL, NULL, NULL, NULL),
954(174, NULL, 'uploads/Desert-c0f91d4fde76f9f77067adb372dbc9f237aa73ad.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
955(175, NULL, 'uploads/Koala-a3713c27f8e87a220cc79d0f9bb889067e832d36.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
956(176, NULL, 'uploads/Penguins-ffe41d17e4ba4ec703eeec4d452fec9d04ff8586.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
957(177, NULL, 'uploads/1-a4a123e99007a163bcba084b0dd1b70d925fa30d.png', NULL, NULL, NULL, NULL, NULL, NULL),
958(178, NULL, 'uploads/2-f2638013e8881117b262054e902ed381550f5718.png', NULL, NULL, NULL, NULL, NULL, NULL),
959(179, NULL, 'uploads/1-635f58c9b5c33a4bef074a7b9ae12145f4235695.png', NULL, NULL, NULL, NULL, NULL, NULL),
960(180, NULL, 'uploads/2-635f58c9b5c33a4bef074a7b9ae12145f4235695.png', NULL, NULL, NULL, NULL, NULL, NULL),
961(181, NULL, 'uploads/3-635f58c9b5c33a4bef074a7b9ae12145f4235695.png', NULL, NULL, NULL, NULL, NULL, NULL),
962(183, NULL, 'uploads/3-010c238581acd7d492decdfd33f4b37e8584a070.png', NULL, NULL, NULL, NULL, NULL, NULL),
963(184, NULL, 'uploads/3-210012e7a643d430f1535bf5a0eaad84775da9f7.png', NULL, NULL, NULL, NULL, NULL, NULL),
964(185, NULL, 'uploads/1604779_1069809083059175_3615869767911685165_n-eb2771b6604c5fb47c30b581052f56f946b80855.png', NULL, NULL, NULL, NULL, NULL, NULL),
965(186, NULL, 'uploads/3-4c90751f2d5f730c243612b539db2f3160ba5565.png', NULL, NULL, NULL, NULL, NULL, NULL),
966(187, NULL, 'uploads/2-1a0f1875392640ca404b2e7a85166e2c86b6ec42.png', NULL, NULL, NULL, NULL, NULL, NULL),
967(188, NULL, 'uploads/3-08cdbf207c17e17c775fa3495f24e44eb918ef57.png', NULL, NULL, NULL, NULL, NULL, NULL),
968(189, NULL, 'uploads/1-c10d84ae475354dcb56faa2c9de2310f1bd442fd.png', NULL, NULL, NULL, NULL, NULL, NULL),
969(190, NULL, 'uploads/2-c10d84ae475354dcb56faa2c9de2310f1bd442fd.png', NULL, NULL, NULL, NULL, NULL, NULL),
970(191, NULL, 'uploads/3-c10d84ae475354dcb56faa2c9de2310f1bd442fd.png', NULL, NULL, NULL, NULL, NULL, NULL),
971(192, NULL, 'uploads/2-a6292f358d86ef9a248d96b32ab9e7aadaf8c081.png', NULL, NULL, NULL, NULL, NULL, NULL),
972(193, NULL, 'uploads/Cafe-Coffee-Day-ed79a249cb57299f2587ca5331e202736fdddae4.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
973(194, NULL, 'uploads/Cafe-Coffee-Day-a2eefc8f2e53bc92f27c9997f29910b1ca58e046.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
974(195, NULL, 'uploads/b437caf747a6f5c5e0e09d6a0252d1cb-f7ad1c535d661ff1ef9dc9f8a039bae85580b411.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
975(196, NULL, 'uploads/1-1bd867e9578fa114b1329559f58634a8ed32be97.png', NULL, NULL, NULL, NULL, NULL, NULL),
976(202, NULL, 'uploads/3034007-inline-i-applelogo-5e65ee87264c9baa9e7a48a2d13ef8ff45e40781.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
977(203, NULL, 'uploads/Belgian-Cocoa-Shots_4-2765d39fa06f19c147b49d3796dc66bc1d8071e5.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
978(204, NULL, 'uploads/1-4c7c992d7a24faf71b8af28014f5dbc39cb7c44f.png', NULL, NULL, NULL, NULL, NULL, NULL),
979(205, NULL, 'uploads/2-4c7c992d7a24faf71b8af28014f5dbc39cb7c44f.png', NULL, NULL, NULL, NULL, NULL, NULL),
980(206, NULL, 'uploads/3-4c7c992d7a24faf71b8af28014f5dbc39cb7c44f.png', NULL, NULL, NULL, NULL, NULL, NULL),
981(207, NULL, 'uploads/1-3b96016b13733471646e1ebfde9c0e11f10ea846.png', NULL, NULL, NULL, NULL, NULL, NULL),
982(208, NULL, 'uploads/3-5f212d443a4d075254fcf1cb792f7378a770a768.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
983(209, NULL, 'uploads/1-169e7f7e1171180ca136b95bd19ca2aa84633f60.png', NULL, NULL, NULL, NULL, NULL, NULL),
984(211, NULL, 'uploads/3-351e4346d0dadbe0c9b8d2a4b70001086251e81a.png', NULL, NULL, NULL, NULL, NULL, NULL),
985(212, NULL, 'uploads/1_635132100886107347-67ca58e8ff578ab5f0d3dbb2bc3f2201d71980e2.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
986(213, NULL, 'uploads/1_635132100886107347-5704b9f3a086139d63585f4e26c485c8464e8650.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
987(214, NULL, 'uploads/1-9cb79ebd3b7bcbff374247697a1c7f9dc9792b5d.png', NULL, NULL, NULL, NULL, NULL, NULL),
988(215, NULL, 'uploads/2-9cb79ebd3b7bcbff374247697a1c7f9dc9792b5d.png', NULL, NULL, NULL, NULL, NULL, NULL),
989(216, NULL, 'uploads/3-9cb79ebd3b7bcbff374247697a1c7f9dc9792b5d.png', NULL, NULL, NULL, NULL, NULL, NULL),
990(217, NULL, 'uploads/4-36050afeb1216d588cb0d39f313ca0218c96b1d2.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
991(218, NULL, 'uploads/1-7b1b63a64c7c3f2577f7082d244cb23499206842.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
992(219, NULL, 'uploads/1_635132100886107347-e505e1b5810395c65587e3fe337b56686782ceef.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
993(220, NULL, 'uploads/icon-e6faaa42c35372a57038ee5a5a5c54a185fc8f5c.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
994(221, NULL, 'uploads/icon-e6faaa42c35372a57038ee5a5a5c54a185fc8f5c.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
995(222, NULL, 'uploads/Cafe_Monico_XX - Copy-251a4bd8104304e1577c7862aca46180fe469a7d.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
996(232, NULL, 'uploads/Trackfly - Web & API - Trackfly - Sign up-Compan--- - Task Report - 14 March 2017-e902e9026b17d9524f21b034b36e4a1e4ff9296d.pdf', NULL, NULL, NULL, NULL, NULL, NULL),
997(233, NULL, 'uploads/Trackfly - Web & API - Trackfly - Sign up-Compan--- - Task Report - 14 March 2017-4593a5d939b15facd90c2fe69fba2ff870e644fd.pdf', NULL, NULL, NULL, NULL, NULL, NULL),
998(234, NULL, 'uploads/MV5BMjM1OTMxNzUyM15BMl5BanBnXkFtZTgwNjYzMTIzOTE@-_V1_UX182_CR0,0,182,268_AL__QL50-e2f6685774071197aec85c663f8392cbb441c0d4.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
999(241, NULL, 'uploads/MV5BMjI4MzU5NTExNF5BMl5BanBnXkFtZTgwNzY1MTEwMDI@-_V1_UX182_CR0,0,182,268_AL__QL50-0544cbd1022ee52bb469811e9d672d5b2de1afb5.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1000(245, NULL, 'uploads/N3BgXEI-a4e4eaf4e0318cf4ce707c6c4551b8877a709f79.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1001(256, NULL, 'uploads/Chrysanthemum-jpeg-a3e85bcb5e895509ff7aba57025d2dcea06bc6a4.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1002(257, NULL, 'uploads/4-9011e1d847e936a4c6c73dc1c8be63cfdc3f87af.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1003(260, NULL, 'uploads/3-7bbd6a5febf8156ff62c42e214a9aeaa4ffce63e.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1004(266, NULL, 'uploads/1-582a19def2111a4ddf0c09b6284b8db498dc7577.png', NULL, NULL, NULL, NULL, NULL, NULL),
1005(267, NULL, 'uploads/2-582a19def2111a4ddf0c09b6284b8db498dc7577.png', NULL, NULL, NULL, NULL, NULL, NULL),
1006(270, NULL, 'uploads/2-582a19def2111a4ddf0c09b6284b8db498dc7577.png', NULL, NULL, NULL, NULL, NULL, NULL),
1007(271, NULL, 'uploads/3-582a19def2111a4ddf0c09b6284b8db498dc7577.png', NULL, NULL, NULL, NULL, NULL, NULL),
1008(272, NULL, 'uploads/1-b9a7b2abf241c00ec5c835bbb44dd9995c18149d.png', NULL, NULL, NULL, NULL, NULL, NULL),
1009(275, NULL, 'uploads/Penguins-1b6088a5e8d75913158085e4f2b22f387d7b4c2f.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1010(276, NULL, 'uploads/N3BgXEI-c037285dc8db3cbbada9e282da5380c64bdda805.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1011(277, NULL, 'uploads/Eu0bK-22f6f0ff9c982704de4622473992140541d2bdf9.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1012(278, NULL, 'uploads/Chrysanthemum-jpeg-864de207f9b4c0ead20fb6a227930528c90dfaf5.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1013(279, NULL, 'uploads/3034007-inline-i-applelogo-df5ec458ab42be6228d585dada36c1912b4ddbc4.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1014(280, NULL, 'uploads/1604779_1069809083059175_3615869767911685165_n-df5ec458ab42be6228d585dada36c1912b4ddbc4.png', NULL, NULL, NULL, NULL, NULL, NULL),
1015(281, NULL, 'uploads/Belgian-Cocoa-Shots_4-e1056b30d4f036abb7a7ea7373fa09b51c56feb0.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1016(282, NULL, 'uploads/Koala-4139b7b35e532ddaff40c89105c65accc5b33486.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1017(283, NULL, 'uploads/Chrysanthemum-jpeg-380589df33ef595fa86385970667cc578ec0ab60.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1018(284, NULL, 'uploads/download-52ab241979e0185e9ed3eb1e84d7c8dc648d99c9.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1019(285, NULL, 'uploads/3-d05c7f7aa6580e1cd9de2c218e2a72871550553e.png', NULL, NULL, NULL, NULL, NULL, NULL),
1020(286, NULL, 'uploads/MV5BMTYzODYzODU2Ml5BMl5BanBnXkFtZTgwNTc1MTA2NzE@-_V1_UX182_CR0,0,182,268_AL__QL50-415cb91a14b148faff83b7252313f9f0641df009.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1021(287, NULL, 'uploads/Trackfly - Web & API - Trackfly - Sign up-Compan--- - Task Report - 14 March 2017-957208a29038028e1061b19de8f2f78a98e6b414.pdf', NULL, NULL, NULL, NULL, NULL, NULL),
1022(288, NULL, 'uploads/MV5BMzUzNDM2NzM2MV5BMl5BanBnXkFtZTgwNTM3NTg4OTE@-_V1_UX182_CR0,0,182,268_AL__QL50-6eec79398f86429187f5195a9483e7d765fb7245.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1023(289, NULL, 'uploads/MV5BMjEwMzMxODIzOV5BMl5BanBnXkFtZTgwNzg3OTAzMDI@-_V1_UX182_CR0,0,182,268_AL__QL50-34d4d15ab23a7f9e27e584d94b832e1d7ae5f8f0.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1024(290, NULL, 'uploads/MV5BMjI4MzU5NTExNF5BMl5BanBnXkFtZTgwNzY1MTEwMDI@-_V1_UX182_CR0,0,182,268_AL__QL50-dbc8ad5bab6fea3910c9312be6d68c7d64ce9b8f.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1025(291, NULL, 'uploads/MV5BMjEwMzMxODIzOV5BMl5BanBnXkFtZTgwNzg3OTAzMDI@-_V1_UX182_CR0,0,182,268_AL__QL50-6979f7267498e5adbf69b92edc20a68a3a457b75.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1026(292, NULL, 'uploads/MV5BMjI4MzU5NTExNF5BMl5BanBnXkFtZTgwNzY1MTEwMDI@-_V1_UX182_CR0,0,182,268_AL__QL50-dcfe313bc2700e99175e04ee5cec51822e63b6a0.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1027(293, NULL, 'uploads/maxresdefault-ef8be0178511c57427dc5f50723d449a54521b16.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1028(300, NULL, 'uploads/maxresdefault-cbdd5250b5d3cc7cbeff2249baffb6d0b5f9259f.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1029(301, NULL, 'uploads/maxresdefault-99c404979e42357c32f558ca70c41e92138b447e.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1030(302, NULL, 'uploads/maxresdefault-5a12d37824aa1fda2f8242393b0b8cc39f87e321.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1031(303, NULL, 'uploads/Chrysanthemum-jpeg-5fc2f6795e721f7a798d3c85568b72dae4416b98.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1032(311, NULL, 'uploads/Penguins-a5a50cf56b720e16bd5cd0784a85617403feb266.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1033(312, NULL, 'uploads/Penguins-0b520681925882f8bbfd8da217366f6a8a44bc00.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1034(313, NULL, 'uploads/Tulips-af882074a74a12acea0aa012754bb98200bb8b6a.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1035(314, NULL, 'uploads/maxresdefault-47bb9c52ff26ba67b1e42e8c7749295892056e04.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1036(315, NULL, 'uploads/X0Pqjpy-97016a4178e36748acd1f99e3aeadcd6412e545e.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1037(316, NULL, 'uploads/Hydrangeas-fda4993aee94b39b440d9bd0361faf52c8448e7f.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1038(317, NULL, 'uploads/images-94380b948577ccc1115275787264ce24d58178c3.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1039(318, NULL, 'uploads/Eu0bK-b3cf45ba2077397b2641dc1cb6493be7972ea875.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1040(319, NULL, 'uploads/CLCSS_banner-042d5ec9ccf0c5a571356d2cc3010da779389fe3.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1041(320, NULL, 'uploads/Lighthouse-c5a98f52f8458b6622b04c0b8532f27788ba11b7.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1042(321, NULL, 'uploads/images-c86eefb08613f29d172ba475d9ee23c841d8f4b6.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1043(322, NULL, 'uploads/3-82cb411342b6851755d6581af6db13ce6922b543.png', NULL, NULL, NULL, NULL, NULL, NULL),
1044(323, NULL, 'uploads/maxresdefault-d3b3116faf8e13c9adb86aae51b14851a2ff3865.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1045(324, NULL, 'uploads/maxresdefault-88c1d45855d614adeb560d6d0cdebb54d8f0fc12.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1046(325, NULL, 'uploads/maxresdefault-53bb9dfdc4a9bd8d97afd6b47765bf3ab09911c5.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1047(334, NULL, 'uploads/1-7666f77f85c841044c4a3bafa9555fce320be217.png', NULL, NULL, NULL, NULL, NULL, NULL),
1048(338, NULL, 'uploads/Koala-2637a5ae47575d05d391f3a8c3f6e643212e5837.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1049(339, NULL, 'uploads/maxresdefault-3d46e5a73336710e0c3604729af0466ecd97a8b2.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1050(340, NULL, 'uploads/maxresdefault-7da7af7d85ac9505c6ae0448dd147497b581220e.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1051(341, NULL, 'uploads/maxresdefault-41ab945b66892ef52b0a6cee4196ec6120626e40.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1052(343, NULL, 'uploads/428b2366f19a19dd81852c8e4080a30c_movies-99f096ec6f4546388c128f0c546d4f6b5fa6bad8.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1053(344, NULL, 'uploads/Chrysanthemum-jpeg-99f096ec6f4546388c128f0c546d4f6b5fa6bad8.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1054(346, NULL, 'uploads/Desert-99f096ec6f4546388c128f0c546d4f6b5fa6bad8.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1055(349, NULL, 'uploads/N3BgXEI-df0ef45a2a7dc3775e91e6dc5cf76e0250f4a160.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1056(350, NULL, 'uploads/Penguins-df0ef45a2a7dc3775e91e6dc5cf76e0250f4a160.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1057(351, NULL, 'uploads/Tulips-df0ef45a2a7dc3775e91e6dc5cf76e0250f4a160.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1058(352, NULL, 'uploads/X0Pqjpy-df0ef45a2a7dc3775e91e6dc5cf76e0250f4a160.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1059(359, NULL, 'uploads/1-7fd560859942d6bd89cd59fc0daaef255fcb4e5c.png', NULL, NULL, NULL, NULL, NULL, NULL),
1060(364, NULL, 'uploads/maxresdefault-ed416a84fd5fcb3425875c9e61485aade405a402.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1061(365, NULL, 'uploads/maxresdefault-07de38cdc4848b836c3e5d789ffec7cdf73e19b8.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1062(367, NULL, 'uploads/2-806f26d7732dd23f254cac8b544a2c269ae33a3b.png', NULL, NULL, NULL, NULL, NULL, NULL),
1063(368, NULL, 'uploads/3-806f26d7732dd23f254cac8b544a2c269ae33a3b.png', NULL, NULL, NULL, NULL, NULL, NULL),
1064(369, NULL, 'uploads/maxresdefault-ac8d7a2166fe43107d67df45d709c74d2dacea1a.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1065(370, NULL, 'uploads/Jellyfish-7b24481699372a661f3867731157a9ac2906da02.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1066(371, NULL, 'uploads/jpeg-home-7b24481699372a661f3867731157a9ac2906da02.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1067(372, NULL, 'uploads/Penguins-ced2023e93c829b68cc2ec278c5d3077860bcb9a.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1068(374, NULL, 'uploads/X0Pqjpy-ced2023e93c829b68cc2ec278c5d3077860bcb9a.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1069(376, NULL, 'uploads/428b2366f19a19dd81852c8e4080a30c_movies-c0e6c636959ebe8e810ca9b67af9540b1c383bb1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1070(377, NULL, 'uploads/Chrysanthemum-jpeg-c0e6c636959ebe8e810ca9b67af9540b1c383bb1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1071(378, NULL, 'uploads/CLCSS_banner-c0e6c636959ebe8e810ca9b67af9540b1c383bb1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1072(379, NULL, 'uploads/Desert-c0e6c636959ebe8e810ca9b67af9540b1c383bb1.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1073(381, NULL, 'uploads/Chrysanthemum-jpeg-b9bfcee3795d431a977b569e1558a23599f60b1c.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1074(382, NULL, 'uploads/CLCSS_banner-b9bfcee3795d431a977b569e1558a23599f60b1c.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1075(383, NULL, 'uploads/Desert-b9bfcee3795d431a977b569e1558a23599f60b1c.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1076(386, NULL, 'uploads/download-b9bfcee3795d431a977b569e1558a23599f60b1c.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1077(387, NULL, 'uploads/3-711a8d89c1aef9cc8bdbff1dae036af595ead17e.png', NULL, NULL, NULL, NULL, NULL, NULL),
1078(388, NULL, 'uploads/428b2366f19a19dd81852c8e4080a30c_movies-711a8d89c1aef9cc8bdbff1dae036af595ead17e.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1079(389, NULL, 'uploads/Chrysanthemum-jpeg-711a8d89c1aef9cc8bdbff1dae036af595ead17e.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1080(390, NULL, 'uploads/CLCSS_banner-711a8d89c1aef9cc8bdbff1dae036af595ead17e.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1081(391, NULL, 'uploads/Desert-711a8d89c1aef9cc8bdbff1dae036af595ead17e.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1082(392, NULL, 'uploads/3-11574d1b0d48618ec6ab44e026d51bb75f6f0b1b.png', NULL, NULL, NULL, NULL, NULL, NULL),
1083(394, NULL, 'uploads/Chrysanthemum-jpeg-11574d1b0d48618ec6ab44e026d51bb75f6f0b1b.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1084(395, NULL, 'uploads/CLCSS_banner-11574d1b0d48618ec6ab44e026d51bb75f6f0b1b.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1085(396, NULL, 'uploads/Desert-11574d1b0d48618ec6ab44e026d51bb75f6f0b1b.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1086(397, NULL, 'uploads/3-882a4324809594f8420c8f4e3acdd624173ce2f8.png', NULL, NULL, NULL, NULL, NULL, NULL),
1087(398, NULL, 'uploads/3-757641021b2989716405284c774faea2e6fb5119.png', NULL, NULL, NULL, NULL, NULL, NULL),
1088(399, NULL, 'uploads/428b2366f19a19dd81852c8e4080a30c_movies-757641021b2989716405284c774faea2e6fb5119.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1089(401, NULL, 'uploads/CLCSS_banner-757641021b2989716405284c774faea2e6fb5119.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1090(402, NULL, 'uploads/Desert-757641021b2989716405284c774faea2e6fb5119.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1091(403, NULL, 'uploads/download (1)-757641021b2989716405284c774faea2e6fb5119.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1092(410, NULL, 'uploads/3-3cc34c7aeb21e06ad868b8afa457f466a9ae5cf0.png', NULL, NULL, NULL, NULL, NULL, NULL),
1093(412, NULL, 'uploads/Chrysanthemum-jpeg-3cc34c7aeb21e06ad868b8afa457f466a9ae5cf0.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1094(413, NULL, 'uploads/CLCSS_banner-3cc34c7aeb21e06ad868b8afa457f466a9ae5cf0.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1095(414, NULL, 'uploads/Desert-3cc34c7aeb21e06ad868b8afa457f466a9ae5cf0.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1096(415, NULL, 'uploads/download (1)-3cc34c7aeb21e06ad868b8afa457f466a9ae5cf0.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1097(416, NULL, 'uploads/3-fbed03e2efe8c98fe66e8723e25c2bb37b6013d8.png', NULL, NULL, NULL, NULL, NULL, NULL),
1098(417, NULL, 'uploads/428b2366f19a19dd81852c8e4080a30c_movies-e17815ce5827f1d5c9a1d39df83eec24f211fd4f.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1099(418, NULL, 'uploads/download (2)-34a55e95267147889b4134eca262dba0f81f2906.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1100(419, NULL, 'uploads/download-aa319f3ccffeee1d7caf194e9627b34804878a4e.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1101(420, NULL, 'uploads/Koala-7496835b34518f63d71d1d7fbf08714ef8f4f6f6.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1102(421, NULL, 'uploads/3-feb3a2cfe19a8f0fe349980a63402bbbf9c85068.png', NULL, NULL, NULL, NULL, NULL, NULL),
1103(423, NULL, 'uploads/Chrysanthemum-jpeg-feb3a2cfe19a8f0fe349980a63402bbbf9c85068.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1104(424, NULL, 'uploads/CLCSS_banner-d3622e8d598b3fd6b02626d695a28891bffcc64a.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1105(426, NULL, 'uploads/jpeg-home-1786585f4b126880383e54c50615d47ee16852ab.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1106(427, NULL, 'uploads/3-de51db801c3badd8e9a16ecb7127277065161843.png', NULL, NULL, NULL, NULL, NULL, NULL),
1107(428, NULL, 'uploads/428b2366f19a19dd81852c8e4080a30c_movies-de51db801c3badd8e9a16ecb7127277065161843.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1108(429, NULL, 'uploads/Chrysanthemum-jpeg-de51db801c3badd8e9a16ecb7127277065161843.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1109(431, NULL, 'uploads/Desert-de51db801c3badd8e9a16ecb7127277065161843.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1110(432, NULL, 'uploads/19119-001-5378dae54f0e9e87d3e38da691cc1cdee457543f.jpg', NULL, NULL, NULL, NULL, NULL, NULL),
1111(433, NULL, 'uploads/designers-bvlgari-aa9ac4561505196c57335b1e9f3a2514d2fc1460.jpg', NULL, NULL, NULL, NULL, NULL, NULL);
1112
1113-- --------------------------------------------------------
1114
1115--
1116-- Table structure for table `locality`
1117--
1118
1119CREATE TABLE IF NOT EXISTS `locality` (
1120  `id` int(11) NOT NULL AUTO_INCREMENT,
1121  `name` varchar(255) DEFAULT NULL,
1122  `code` varchar(45) DEFAULT NULL,
1123  `status` int(11) DEFAULT NULL,
1124  `created_at` timestamp NULL DEFAULT NULL,
1125  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1126  `fk_city` int(11) DEFAULT NULL,
1127  `lat` float DEFAULT NULL,
1128  `lng` float DEFAULT NULL,
1129  PRIMARY KEY (`id`),
1130  KEY `fk_locality_city_idx` (`fk_city`)
1131) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=102 ;
1132
1133--
1134-- Dumping data for table `locality`
1135--
1136
1137INSERT INTO `locality` (`id`, `name`, `code`, `status`, `created_at`, `modified_at`, `fk_city`, `lat`, `lng`) VALUES
1138(84, 'koratty', NULL, 1, '2017-06-14 00:00:00', '2017-06-14 13:00:18', 73, NULL, NULL),
1139(85, '', NULL, NULL, NULL, '2017-06-14 13:09:36', 74, NULL, NULL),
1140(86, 'kurichithanam', NULL, NULL, NULL, '2017-06-14 13:10:38', 74, NULL, NULL),
1141(87, 'Bank junction', NULL, NULL, NULL, '2017-06-17 07:14:19', 75, NULL, NULL),
1142(88, 'Karam Pakkam', NULL, NULL, NULL, '2017-06-15 06:29:03', 77, NULL, NULL),
1143(89, 'Puthupaddy', NULL, NULL, NULL, '2017-06-15 06:50:12', 78, NULL, NULL),
1144(90, 'Palarivattom', NULL, NULL, NULL, '2017-06-15 06:56:25', 79, NULL, NULL),
1145(91, 'Kayamkulam', NULL, NULL, NULL, '2017-06-15 11:04:33', NULL, NULL, NULL),
1146(92, 'sdgdf', NULL, NULL, NULL, '2017-06-16 04:56:32', 75, NULL, NULL),
1147(93, 'South', NULL, NULL, NULL, '2017-06-16 09:01:47', 79, NULL, NULL),
1148(94, 'Aluva', NULL, NULL, NULL, '2017-06-17 06:53:27', 79, NULL, NULL),
1149(95, 'Kochi', NULL, NULL, NULL, '2017-06-17 07:04:57', 87, NULL, NULL),
1150(96, 'Vpm', NULL, NULL, NULL, '2017-06-17 07:09:09', 87, NULL, NULL),
1151(97, 'Bank junction', NULL, NULL, NULL, '2017-06-17 07:14:19', 86, NULL, NULL),
1152(98, 'ssccs', NULL, NULL, NULL, '2017-06-17 09:43:55', 76, NULL, NULL),
1153(99, 'ahjhhhh', NULL, NULL, NULL, '2017-06-17 10:47:52', 82, NULL, NULL),
1154(100, 'ajjhjkj', NULL, NULL, NULL, '2017-06-17 11:49:41', 89, NULL, NULL),
1155(101, 'dfgdger', NULL, NULL, NULL, '2017-06-19 09:32:51', 76, NULL, NULL);
1156
1157-- --------------------------------------------------------
1158
1159--
1160-- Table structure for table `meta`
1161--
1162
1163CREATE TABLE IF NOT EXISTS `meta` (
1164  `id` int(11) NOT NULL AUTO_INCREMENT,
1165  `key` varchar(255) DEFAULT NULL,
1166  `value` varchar(255) DEFAULT NULL,
1167  `created_at` timestamp NULL DEFAULT NULL,
1168  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1169  `status` int(11) DEFAULT '1',
1170  PRIMARY KEY (`id`)
1171) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1172
1173-- --------------------------------------------------------
1174
1175--
1176-- Table structure for table `migration`
1177--
1178
1179CREATE TABLE IF NOT EXISTS `migration` (
1180  `version` varchar(180) NOT NULL,
1181  `apply_time` int(11) DEFAULT NULL,
1182  PRIMARY KEY (`version`)
1183) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1184
1185--
1186-- Dumping data for table `migration`
1187--
1188
1189INSERT INTO `migration` (`version`, `apply_time`) VALUES
1190('m000000_000000_base', 1496828435),
1191('m140506_102106_rbac_init', 1496828450);
1192
1193-- --------------------------------------------------------
1194
1195--
1196-- Table structure for table `package`
1197--
1198
1199CREATE TABLE IF NOT EXISTS `package` (
1200  `id` int(11) NOT NULL AUTO_INCREMENT,
1201  `name` varchar(255) DEFAULT NULL,
1202  `description` text,
1203  `fk_account` int(11) DEFAULT NULL COMMENT 'admin user who created the package',
1204  `created_at` timestamp NULL DEFAULT NULL,
1205  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1206  `status` int(11) DEFAULT '1',
1207  PRIMARY KEY (`id`),
1208  KEY `fk_package_account_idx` (`fk_account`)
1209) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1210
1211-- --------------------------------------------------------
1212
1213--
1214-- Table structure for table `package_attribute`
1215--
1216
1217CREATE TABLE IF NOT EXISTS `package_attribute` (
1218  `id` int(11) NOT NULL AUTO_INCREMENT,
1219  `fk_package` int(11) DEFAULT NULL,
1220  `name` varchar(255) DEFAULT NULL,
1221  `value` text,
1222  `created_at` timestamp NULL DEFAULT NULL,
1223  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1224  `status` int(11) DEFAULT '1',
1225  PRIMARY KEY (`id`),
1226  KEY `fk_package_attribute_package_idx` (`fk_package`)
1227) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1228
1229-- --------------------------------------------------------
1230
1231--
1232-- Table structure for table `package_pricing`
1233--
1234
1235CREATE TABLE IF NOT EXISTS `package_pricing` (
1236  `id` int(11) NOT NULL AUTO_INCREMENT,
1237  `fk_package` int(11) DEFAULT NULL,
1238  `price` float DEFAULT NULL,
1239  `no_of_months` int(11) DEFAULT NULL,
1240  `created_at` timestamp NULL DEFAULT NULL,
1241  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1242  `status` int(11) DEFAULT '1',
1243  PRIMARY KEY (`id`),
1244  KEY `fk_package_pricing_package_idx` (`fk_package`)
1245) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1246
1247-- --------------------------------------------------------
1248
1249--
1250-- Table structure for table `person`
1251--
1252
1253CREATE TABLE IF NOT EXISTS `person` (
1254  `id` int(11) NOT NULL AUTO_INCREMENT,
1255  `first_name` varchar(45) DEFAULT NULL,
1256  `middle_name` varchar(45) DEFAULT NULL,
1257  `last_name` varchar(45) DEFAULT NULL,
1258  `dob` date DEFAULT NULL,
1259  `email` varchar(255) DEFAULT NULL,
1260  `phone1` varchar(45) DEFAULT NULL,
1261  `phone2` varchar(45) DEFAULT NULL,
1262  `fk_address` int(11) DEFAULT NULL,
1263  `fk_image` int(11) DEFAULT NULL,
1264  `fk_gender` int(11) DEFAULT NULL,
1265  `status` int(11) DEFAULT NULL,
1266  `created_at` timestamp NULL DEFAULT NULL,
1267  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1268  PRIMARY KEY (`id`),
1269  KEY `fk_person_address_idx` (`fk_address`),
1270  KEY `fk_person_gender_idx` (`fk_gender`),
1271  KEY `fk_person_image_idx` (`fk_image`)
1272) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=180 ;
1273
1274--
1275-- Dumping data for table `person`
1276--
1277
1278INSERT INTO `person` (`id`, `first_name`, `middle_name`, `last_name`, `dob`, `email`, `phone1`, `phone2`, `fk_address`, `fk_image`, `fk_gender`, `status`, `created_at`, `modified_at`) VALUES
1279(143, 'Admin', '', 'Cocoalabs', '1970-01-01', 'admin@cocoalabs.in', '8978675678', '', 144, NULL, 1, NULL, NULL, '2017-06-17 08:03:24'),
1280(144, 'Manus', 'r', 'k', NULL, 'anu.cocoalabs@gmail.com', '8978675678', NULL, 145, NULL, NULL, NULL, NULL, '2017-06-14 13:09:52'),
1281(145, 'sunu', '', '', '1991-12-31', 'sunucocoalabs@gmail.com', '8606280313', '04822250472', 146, NULL, 2, NULL, NULL, '2017-06-14 13:10:38'),
1282(146, 'sunubhai', 'A', 'S', '1970-01-01', 'sunucocoalabs+2@gmail.com', '8606280313', '675676588768', 147, NULL, 2, NULL, NULL, '2017-06-17 06:37:20'),
1283(147, 'Babu', 'Paul', 'Varghese', '1970-01-01', 'anugra+1@cocoalabs.in', '99999999999', '', 148, NULL, 1, NULL, NULL, '2017-06-17 08:39:42'),
1284(148, 'Jose', '', 'John', '1994-05-02', 'anugra@cocoalabs.in', '98097867467', '5756689978', 149, NULL, 1, NULL, NULL, '2017-06-15 07:13:07'),
1285(149, 'Munna', 's', ' Bhai', NULL, 'anu.cocoalabs+11@gmail.com', '23432543545', NULL, 150, NULL, NULL, NULL, NULL, '2017-06-15 05:24:44'),
1286(150, 'Thanvi', 'Das', 'K', NULL, 'anu.cocoalabs+22@gmail.com', '8978675678', NULL, 151, NULL, NULL, NULL, NULL, '2017-06-15 06:29:03'),
1287(151, 'Raju', '', 'Varghese', NULL, 'anugra+17@cocoalabs.in', '78658757698', NULL, 152, NULL, NULL, NULL, NULL, '2017-06-15 06:50:12'),
1288(152, 'Viswan', '', '', NULL, 'anu.cocoalabs+23@gmail.com', '8978675678', NULL, 153, NULL, NULL, NULL, NULL, '2017-06-15 06:56:25'),
1289(153, 'Rakesh', 'K', 'R', NULL, 'anu.cocoalabs+25@gmail.com', '8978675678', NULL, 154, NULL, NULL, NULL, NULL, '2017-06-15 08:23:36'),
1290(154, 'Rakesh', 'K', 'R', NULL, 'anu.cocoalabs+26@gmail.com', '8978675678', NULL, 155, NULL, NULL, NULL, NULL, '2017-06-15 08:24:07'),
1291(155, 'gfh', '', '', NULL, 'anu.cocoalabs+151@gmail.com', '3254235352', NULL, 156, NULL, NULL, NULL, NULL, '2017-06-15 08:35:03'),
1292(156, 'Veena', 'V', 'Shenoy', NULL, 'anu.cocoalabs+28@gmail.com', '3254235352', NULL, 157, NULL, NULL, NULL, NULL, '2017-06-15 08:37:18'),
1293(157, 'Manu', 'k', 'R', '1970-01-01', 'anugra+1654@cocoalabs.in', '98676546758', '', 158, NULL, 1, NULL, NULL, '2017-06-17 06:41:30'),
1294(158, 'John', '', '', NULL, 'anugra+4@cocoalabs.in', '658797345455', NULL, 159, NULL, NULL, NULL, NULL, '2017-06-16 04:56:32'),
1295(159, 'Ammukutty', '', '', '1970-01-01', 'anu.cocoalabs+00@gmail.com', '86678676709', '', 160, NULL, NULL, NULL, NULL, '2017-06-16 07:48:29'),
1296(160, 'George', '', '', NULL, 'anugra+00@cocoalabs.in', '5646758796', NULL, 161, NULL, NULL, NULL, NULL, '2017-06-16 09:01:47'),
1297(161, 'Bibi', 'Paul', 'Babu', NULL, 'anugra+16@cocoalabs.in', '67586887987', NULL, 162, NULL, 1, NULL, NULL, '2017-06-17 06:55:38'),
1298(162, 'Sam', '', '', '1995-03-22', 'anugra+156@cocoalabs.in', '46758798698', '', 163, NULL, 1, NULL, NULL, '2017-06-17 06:53:27'),
1299(163, 'Manu', 'k', 'k', NULL, 'anu.cocoalabs+13@gmail.com', '8978675678', NULL, 164, NULL, 1, NULL, NULL, '2017-06-17 07:01:56'),
1300(164, 'Kuku', '', '', NULL, 'anugra+22@cocoalabs.in', '58757697587', NULL, 165, NULL, 1, NULL, NULL, '2017-06-17 07:04:57'),
1301(165, 'Abi', '', '', NULL, 'anu.cocoalabs+122@gmail.com', '546598966986', NULL, 166, NULL, 2, NULL, NULL, '2017-06-17 07:09:09'),
1302(166, 'Thinu', '', '', NULL, 'anu.cocoalabs+14@gmail.com', '8978675678', NULL, 167, NULL, 2, NULL, NULL, '2017-06-17 07:15:37'),
1303(167, 'Wilson', '', '', NULL, 'anu.cocoalabs+15@gmail.com', '8978675678', NULL, 168, NULL, 1, NULL, NULL, '2017-06-17 07:56:57'),
1304(168, 'Ritzz', '', '', '1970-01-01', 'anugra9876@cocoalabs.in', '54765879677', '', 169, NULL, 1, NULL, NULL, '2017-06-17 07:24:44'),
1305(169, 'Anugra', '', '', NULL, 'anugra+112345@cocoalabs.in', '356478657687', NULL, 170, NULL, NULL, NULL, NULL, '2017-06-17 07:33:14'),
1306(170, 'fdff', '', '', NULL, 'anu.cocodfdsalabs+11@gmail.com', '8978675678', NULL, 171, NULL, 1, NULL, NULL, '2017-06-17 08:56:32'),
1307(171, 'Ammu', '', '', NULL, 'anugra+167@cocoalabs.in', '465876987868', NULL, 172, NULL, NULL, NULL, NULL, '2017-06-17 09:06:41'),
1308(172, 'Minu', '', '', '1970-01-01', 'anugra+71@cocoalabs.in', '233524654236', '', 173, NULL, 1, NULL, NULL, '2017-06-17 09:44:56'),
1309(173, 'Vinu', '', '', '1970-01-07', 'anugra+41@cocoalabs.in', '2452668899', '', 174, NULL, 1, NULL, NULL, '2017-06-17 10:47:52'),
1310(174, 'Amal', '', '', NULL, 'anugra+109@cocoalabs.in', '5878689709', NULL, 175, NULL, 1, NULL, NULL, '2017-06-17 11:49:41'),
1311(175, 'Sanju', '', '', NULL, 'anugra+134@cocoalabs.in', '46875896790', NULL, 176, NULL, 1, NULL, NULL, '2017-06-17 11:52:26'),
1312(176, 'Geon', '', '', NULL, 'anugra+901@cocoalabs.in', '6587689709', NULL, 177, NULL, 1, NULL, NULL, '2017-06-19 04:18:33'),
1313(177, 'Biju', '', '', '1999-02-01', 'anugra+14@cocoalabs.in', '4354376575', '', 178, NULL, 1, NULL, NULL, '2017-06-19 12:49:06'),
1314(178, 'sinu', '', '', NULL, 'suncocoalabs@gmail.com', '8606280313', NULL, 179, NULL, 2, NULL, NULL, '2017-06-19 09:38:30'),
1315(179, 'Abu', '', '', NULL, 'anugra+43@cocoalabs.in', '54668979666', NULL, 180, NULL, NULL, NULL, NULL, '2017-06-19 09:33:24');
1316
1317-- --------------------------------------------------------
1318
1319--
1320-- Table structure for table `state`
1321--
1322
1323CREATE TABLE IF NOT EXISTS `state` (
1324  `id` int(11) NOT NULL AUTO_INCREMENT,
1325  `name` varchar(255) DEFAULT NULL,
1326  `code` varchar(45) DEFAULT NULL,
1327  `status` int(11) DEFAULT NULL,
1328  `created_at` timestamp NULL DEFAULT NULL,
1329  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1330  `fk_country` int(11) DEFAULT NULL,
1331  PRIMARY KEY (`id`),
1332  KEY `fk_state_country_idx` (`fk_country`)
1333) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;
1334
1335--
1336-- Dumping data for table `state`
1337--
1338
1339INSERT INTO `state` (`id`, `name`, `code`, `status`, `created_at`, `modified_at`, `fk_country`) VALUES
1340(51, 'Tamilnadu', NULL, 1, '2017-06-14 00:00:00', '2017-06-16 08:24:42', 39),
1341(52, 'Kerala', NULL, 1, NULL, '2017-06-16 08:25:04', 39);
1342
1343-- --------------------------------------------------------
1344
1345--
1346-- Table structure for table `vehicle`
1347--
1348
1349CREATE TABLE IF NOT EXISTS `vehicle` (
1350  `id` int(11) NOT NULL AUTO_INCREMENT,
1351  `number` varchar(255) DEFAULT NULL,
1352  `fk_vehicle_type` int(11) DEFAULT NULL,
1353  `fk_vehicle_model` int(11) DEFAULT NULL,
1354  `fk_vehicle_driver` int(11) DEFAULT NULL,
1355  `overspeed_limit` float DEFAULT NULL,
1356  `fk_person_registrant` int(11) DEFAULT NULL,
1357  `hypothentication` text,
1358  `color` varchar(45) DEFAULT NULL,
1359  `no_of_tyres` int(11) DEFAULT NULL,
1360  `mileage` varchar(45) DEFAULT NULL,
1361  `engine_no` int(11) DEFAULT NULL,
1362  `chassis_no` int(11) DEFAULT NULL,
1363  `maunfactured_date` date DEFAULT NULL,
1364  `purchase_date` date DEFAULT NULL,
1365  `purchased_from` varchar(255) DEFAULT NULL,
1366  `fk_gear_type` int(11) DEFAULT NULL,
1367  `notes` varchar(45) DEFAULT NULL,
1368  `status` int(11) DEFAULT '1',
1369  `is_banned` int(11) NOT NULL DEFAULT '1',
1370  `created_at` timestamp NULL DEFAULT NULL,
1371  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1372  `fk_company` int(11) DEFAULT NULL,
1373  `fk_fuel_type` int(11) DEFAULT NULL,
1374  PRIMARY KEY (`id`),
1375  KEY `fk_vehicle_vehicle_type_idx` (`fk_vehicle_type`),
1376  KEY `fk_vehicle_vehicle_model_idx` (`fk_vehicle_model`),
1377  KEY `fk_vehicle_driver_idx` (`fk_vehicle_driver`),
1378  KEY `fk_vehicle_person_registrant_idx` (`fk_person_registrant`),
1379  KEY `fk_vehicle_gear_type_idx` (`fk_gear_type`),
1380  KEY `fk_vehicle_company_idx` (`fk_company`),
1381  KEY `fk_vehicle_fuel_type_idx` (`fk_fuel_type`)
1382) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ;
1383
1384--
1385-- Dumping data for table `vehicle`
1386--
1387
1388INSERT INTO `vehicle` (`id`, `number`, `fk_vehicle_type`, `fk_vehicle_model`, `fk_vehicle_driver`, `overspeed_limit`, `fk_person_registrant`, `hypothentication`, `color`, `no_of_tyres`, `mileage`, `engine_no`, `chassis_no`, `maunfactured_date`, `purchase_date`, `purchased_from`, `fk_gear_type`, `notes`, `status`, `is_banned`, `created_at`, `modified_at`, `fk_company`, `fk_fuel_type`) VALUES
1389(35, 'KL 5 2234', 1, 1, NULL, NULL, NULL, NULL, 'black', 4, '55', 464645776, 2147483647, '2017-06-15', '2017-06-22', 'pala', 2, NULL, 0, 1, '2017-06-14 13:15:48', '2017-06-19 08:50:39', NULL, 2),
1390(36, 'KL 8865', 1, 1, NULL, NULL, NULL, NULL, 'White', 6, '15', 12345, 9876, '2015-09-22', '2017-06-13', 'Kochi', 1, NULL, 1, 1, '2017-06-15 04:18:23', '2017-06-15 04:35:24', NULL, 2),
1391(37, 'KL 7777', 3, 3, NULL, NULL, NULL, NULL, '', 4, '', NULL, NULL, '1970-01-01', '1970-01-01', '', 1, NULL, 1, 1, '2017-06-15 04:44:49', '2017-06-15 11:43:37', 2, 1),
1392(38, 'KL 1111', 1, 2, NULL, NULL, NULL, NULL, 'Black', 4, '12', 12233, 654433, '2016-07-28', '2017-03-21', 'Ernakulam', 1, NULL, 1, 1, '2017-06-15 04:49:26', '2017-06-15 07:24:46', 2, 1),
1393(39, 'KL 2222', 6, 4, NULL, NULL, NULL, NULL, 'Blue', 4, '15', 3425, 5674, '2016-08-19', '2017-06-12', 'Aluva', 1, NULL, 1, 1, '2017-06-15 06:35:59', '2017-06-15 07:24:49', 2, 1),
1394(40, 'KL 5555', 3, 4, NULL, NULL, NULL, NULL, 'White', 46356, '20', 4321, 1243134, '2017-05-28', '2017-06-15', 'Aluva', 1, NULL, 1, 1, '2017-06-15 08:36:35', '2017-06-15 11:43:03', NULL, 1),
1395(41, '346346456', 3, 4, NULL, 88, NULL, NULL, 'dgdhfdfh', 6, '66', 657567575, 5757567, '1970-01-01', '1970-01-01', 'dfgdfhdh', 2, 'dfdfhd', 1, 1, '2017-06-15 09:20:28', '2017-06-15 09:45:11', 3, 1),
1396(42, 'KL 9876', 6, 2, NULL, NULL, NULL, NULL, 'White', 4, '15', 5435, 235325, '2016-10-26', '2017-06-15', 'Ernakulam', 1, NULL, 1, 1, '2017-06-15 09:22:39', '2017-06-15 09:22:39', 2, 2),
1397(43, '45757567', 2, 3, NULL, NULL, NULL, NULL, 'fghfh', 575, '576567567', 567568568, 58585, '2017-06-22', '2017-06-22', 'hyftrhftr', 2, NULL, 1, 1, '2017-06-15 09:45:47', '2017-06-15 09:45:47', 1, 2),
1398(44, '7457567567', 2, 1, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, '1970-01-01', '1970-01-01', '', 1, NULL, 1, 1, '2017-06-15 10:30:24', '2017-06-15 10:30:47', 1, 1),
1399(45, 'kl 4 7709', 3, 1, NULL, NULL, NULL, NULL, 'blank', 4, '70', 45657568, 67867969, '2017-06-09', '2017-06-07', 'pala', 2, NULL, 1, 1, '2017-06-16 07:21:41', '2017-06-16 09:44:10', 2, 2),
1400(46, 'kl 0000', 1, 3, NULL, NULL, NULL, NULL, 'sdgdrgh', 4, '80', 2147483647, 2147483647, '2017-06-15', '2017-06-15', 'afsgfsw', 1, NULL, 1, 1, '2017-06-16 07:47:17', '2017-06-16 07:47:17', 12, 2),
1401(47, 'KL 0000', 9, 2, NULL, NULL, NULL, NULL, 'White', 4, '14', 5476578, 6587, '2016-09-02', '2017-06-16', 'Ernakulam', 1, NULL, 1, 1, '2017-06-16 09:04:48', '2017-06-16 09:04:48', 13, 2),
1402(48, 'KL 6666', 6, 2, NULL, NULL, NULL, NULL, 'Blue', 4, '13', 76768689, 6587698, '2016-07-13', '2017-06-15', 'Kochi', 1, NULL, 1, 1, '2017-06-17 06:48:16', '2017-06-17 06:48:16', 14, 1),
1403(49, 'KL 4444', 4, 1, NULL, NULL, NULL, NULL, 'White', 4, '15', 7587, 4767, '2015-07-22', '2017-06-14', 'Kochi', 1, NULL, 1, 1, '2017-06-17 07:15:38', '2017-06-17 07:15:38', 16, 1),
1404(50, 'KL 123456', 4, 1, NULL, 80, 169, '876899', 'Black', 6, '13', 6578, 768767, '1970-01-01', '1970-01-01', 'Aluva', 1, 'nfdtmghf', 1, 1, '2017-06-17 07:30:04', '2017-06-17 08:30:01', 16, 1),
1405(51, 'KL 67890', 6, 2, NULL, 80, 171, 'gdchgjch', 'Blue', 12, '20', 656576, 5867, '1970-01-01', '1970-01-01', 'Aluva', 1, '', 1, 1, '2017-06-17 08:57:43', '2017-06-17 09:16:59', 2, 1),
1406(52, 'KL 00000', 2, 1, NULL, NULL, NULL, NULL, 'White', 6, '12', 57587, 65768, '2017-06-13', '2017-06-13', 'Aluva', 1, NULL, 0, 1, '2017-06-17 09:48:43', '2017-06-19 08:43:43', 2, 2),
1407(53, 'KL 3333', 6, 1, NULL, NULL, 179, '', 'White', 4, '15', 5876, 5868, '1970-01-01', '1970-01-01', 'Thodupuzha', 1, '', 1, 0, '2017-06-19 04:37:21', '2017-06-19 13:09:37', 23, 1);
1408
1409-- --------------------------------------------------------
1410
1411--
1412-- Table structure for table `vehicle_brand`
1413--
1414
1415CREATE TABLE IF NOT EXISTS `vehicle_brand` (
1416  `id` int(11) NOT NULL AUTO_INCREMENT,
1417  `name` varchar(255) DEFAULT NULL,
1418  `fk_image` int(11) DEFAULT NULL,
1419  `description` text,
1420  `status` int(11) DEFAULT '1',
1421  `created_at` timestamp NULL DEFAULT NULL,
1422  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1423  PRIMARY KEY (`id`),
1424  KEY `fk_vehicle_brand_image_idx` (`fk_image`)
1425) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
1426
1427--
1428-- Dumping data for table `vehicle_brand`
1429--
1430
1431INSERT INTO `vehicle_brand` (`id`, `name`, `fk_image`, `description`, `status`, `created_at`, `modified_at`) VALUES
1432(1, 'Toyotta', NULL, NULL, 1, '2017-06-14 00:00:00', '2017-06-14 13:13:15'),
1433(2, 'Volkswagen', 301, 'Volkswagen is an Brand', 1, NULL, '2017-06-14 13:17:17'),
1434(3, 'Hero Honda', 316, 'ddfygg,jh, huhii uygliugiu', 0, NULL, '2017-06-15 06:31:57'),
1435(4, 'Hero Honda', 317, 'ghfmhjgfjh tfy,fgi.oi yguioi', 1, NULL, '2017-06-15 06:31:50'),
1436(5, 'Maruti', 319, 'qertyioi ertyuoiop fgjkl', 1, NULL, '2017-06-15 06:34:01'),
1437(6, 'Tata', 324, 'its tata ', 1, NULL, '2017-06-15 10:39:31'),
1438(7, 'agsdg', NULL, 'dfhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh', 1, NULL, '2017-06-16 05:13:22'),
1439(8, 'dfss', 340, 'fsdfds', 0, NULL, '2017-06-17 04:49:15'),
1440(9, 'rtsetsr', 365, 'dgdfgdg', 0, NULL, '2017-06-17 08:40:53'),
1441(10, 'Honda', 418, 'sdfgdsdgg dbfsgsg sgsg', 1, NULL, '2017-06-19 04:51:21');
1442
1443-- --------------------------------------------------------
1444
1445--
1446-- Table structure for table `vehicle_driver_map`
1447--
1448
1449CREATE TABLE IF NOT EXISTS `vehicle_driver_map` (
1450  `id` int(11) NOT NULL AUTO_INCREMENT,
1451  `fk_vehicle` int(11) DEFAULT NULL,
1452  `fk_driver` int(11) DEFAULT NULL,
1453  `date_from` date DEFAULT NULL,
1454  `date_to` date DEFAULT NULL,
1455  `is_current` int(11) DEFAULT '1',
1456  `created_at` timestamp NULL DEFAULT NULL,
1457  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1458  `status` int(11) DEFAULT '1',
1459  PRIMARY KEY (`id`),
1460  KEY `fk_vehicle_driver_map_vehicle_idx` (`fk_vehicle`),
1461  KEY `fk_vehicle_driver_map_driver_idx` (`fk_driver`)
1462) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;
1463
1464--
1465-- Dumping data for table `vehicle_driver_map`
1466--
1467
1468INSERT INTO `vehicle_driver_map` (`id`, `fk_vehicle`, `fk_driver`, `date_from`, `date_to`, `is_current`, `created_at`, `modified_at`, `status`) VALUES
1469(1, 37, 27, NULL, NULL, 1, NULL, '2017-06-15 09:18:10', 1),
1470(2, 39, 26, NULL, NULL, 1, NULL, '2017-06-15 09:18:29', 1),
1471(3, 35, 26, NULL, NULL, 1, NULL, '2017-06-15 12:40:32', 1),
1472(4, 52, 31, NULL, NULL, 1, NULL, '2017-06-17 09:49:13', 1),
1473(5, 46, 31, NULL, NULL, 1, NULL, '2017-06-17 09:49:35', 1),
1474(6, 39, 31, NULL, NULL, 1, NULL, '2017-06-17 09:50:21', 1),
1475(7, 51, 31, NULL, NULL, 1, NULL, '2017-06-17 09:50:39', 1),
1476(8, 46, 31, NULL, NULL, 1, NULL, '2017-06-17 09:51:49', 1),
1477(9, 52, 31, NULL, NULL, 1, NULL, '2017-06-17 09:52:06', 1),
1478(10, 38, 31, NULL, NULL, 1, NULL, '2017-06-17 09:54:41', 1),
1479(11, 40, 31, NULL, NULL, 1, NULL, '2017-06-17 09:55:08', 1),
1480(12, 37, 31, NULL, NULL, 1, NULL, '2017-06-17 10:00:08', 1),
1481(13, 48, 31, NULL, NULL, 1, NULL, '2017-06-17 10:00:33', 1),
1482(14, 37, 31, NULL, NULL, 1, NULL, '2017-06-17 10:01:17', 1),
1483(15, 37, 31, NULL, NULL, 1, NULL, '2017-06-17 10:01:35', 1),
1484(16, 38, 31, NULL, NULL, 1, NULL, '2017-06-17 10:06:42', 1),
1485(17, 35, 31, NULL, NULL, 1, NULL, '2017-06-17 10:11:48', 1),
1486(18, 36, 31, NULL, NULL, 1, NULL, '2017-06-17 10:12:02', 1),
1487(19, 50, 32, NULL, NULL, 1, NULL, '2017-06-17 10:51:57', 1),
1488(20, 50, 30, NULL, NULL, 1, NULL, '2017-06-17 12:20:11', 1),
1489(21, 50, 30, NULL, NULL, 1, NULL, '2017-06-17 12:20:19', 1),
1490(22, 49, 30, NULL, NULL, 1, NULL, '2017-06-17 12:21:03', 1),
1491(23, 50, 30, NULL, NULL, 1, NULL, '2017-06-17 12:21:09', 1),
1492(24, 50, 30, NULL, NULL, 1, NULL, '2017-06-17 12:21:16', 1),
1493(25, 50, 30, NULL, NULL, 1, NULL, '2017-06-17 12:41:41', 1),
1494(26, 49, 30, NULL, NULL, 1, NULL, '2017-06-17 12:41:49', 1),
1495(27, 53, 33, NULL, NULL, 1, NULL, '2017-06-19 12:52:53', 1);
1496
1497-- --------------------------------------------------------
1498
1499--
1500-- Table structure for table `vehicle_image_map`
1501--
1502
1503CREATE TABLE IF NOT EXISTS `vehicle_image_map` (
1504  `id` int(11) NOT NULL AUTO_INCREMENT,
1505  `fk_image` int(11) DEFAULT NULL,
1506  `fk_vehicle` int(11) DEFAULT NULL,
1507  `created_at` timestamp NULL DEFAULT NULL,
1508  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1509  `status` int(11) DEFAULT '1',
1510  PRIMARY KEY (`id`),
1511  KEY `fk_vehicle_image_map_vehicle_idx` (`fk_vehicle`),
1512  KEY `fk_vehicle_image_map_image_idx` (`fk_image`)
1513) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;
1514
1515--
1516-- Dumping data for table `vehicle_image_map`
1517--
1518
1519INSERT INTO `vehicle_image_map` (`id`, `fk_image`, `fk_vehicle`, `created_at`, `modified_at`, `status`) VALUES
1520(1, 304, 38, NULL, NULL, 1),
1521(2, 305, 38, NULL, NULL, 1),
1522(3, 306, 38, NULL, NULL, 1),
1523(4, 307, 38, NULL, NULL, 1),
1524(5, 308, 38, NULL, NULL, 1),
1525(6, 328, 44, NULL, NULL, 1),
1526(7, 329, 44, NULL, NULL, 1),
1527(8, 330, 44, NULL, NULL, 1),
1528(9, 331, 44, NULL, NULL, 1),
1529(10, 332, 44, NULL, NULL, 1),
1530(11, 333, 44, NULL, NULL, 1),
1531(12, 334, 44, NULL, NULL, 1),
1532(13, 335, 44, NULL, NULL, 1),
1533(14, 336, 44, NULL, NULL, 1),
1534(15, 342, 50, NULL, NULL, 1),
1535(16, 343, 50, NULL, NULL, 1),
1536(17, 344, 50, NULL, NULL, 1),
1537(18, 345, 50, NULL, NULL, 1),
1538(19, 346, 50, NULL, NULL, 1),
1539(20, 347, 50, NULL, NULL, 1),
1540(21, 348, 50, NULL, NULL, 1),
1541(22, 349, 50, NULL, NULL, 1),
1542(23, 350, 50, NULL, NULL, 1),
1543(24, 351, 50, NULL, NULL, 1),
1544(25, 352, 50, NULL, NULL, 1),
1545(26, 375, 51, NULL, NULL, 1),
1546(27, 376, 51, NULL, NULL, 1),
1547(28, 377, 51, NULL, NULL, 1),
1548(29, 378, 51, NULL, NULL, 1),
1549(30, 379, 51, NULL, NULL, 1),
1550(31, 380, 51, NULL, NULL, 1),
1551(32, 381, 51, NULL, NULL, 1),
1552(33, 382, 51, NULL, NULL, 1),
1553(34, 383, 51, NULL, NULL, 1),
1554(35, 384, 51, NULL, NULL, 1),
1555(36, 385, 51, NULL, NULL, 1),
1556(37, 386, 51, NULL, NULL, 1),
1557(38, 421, 53, NULL, NULL, 1),
1558(39, 422, 53, NULL, NULL, 1),
1559(40, 423, 53, NULL, NULL, 1),
1560(41, 424, 53, NULL, NULL, 1),
1561(42, 425, 53, NULL, NULL, 1),
1562(43, 426, 53, NULL, NULL, 1),
1563(44, 433, 53, NULL, NULL, 1);
1564
1565-- --------------------------------------------------------
1566
1567--
1568-- Table structure for table `vehicle_model`
1569--
1570
1571CREATE TABLE IF NOT EXISTS `vehicle_model` (
1572  `id` int(11) NOT NULL AUTO_INCREMENT,
1573  `name` varchar(255) DEFAULT NULL,
1574  `fk_vehicle_brand` int(11) DEFAULT NULL,
1575  `fk_image` int(11) DEFAULT NULL,
1576  `description` text,
1577  `status` int(11) DEFAULT '1',
1578  `created_at` timestamp NULL DEFAULT NULL,
1579  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1580  PRIMARY KEY (`id`),
1581  KEY `fk_vehicle_model_vehicle_brand_idx` (`fk_vehicle_brand`),
1582  KEY `fk_vehicle_model_image_idx` (`fk_image`)
1583) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
1584
1585--
1586-- Dumping data for table `vehicle_model`
1587--
1588
1589INSERT INTO `vehicle_model` (`id`, `name`, `fk_vehicle_brand`, `fk_image`, `description`, `status`, `created_at`, `modified_at`) VALUES
1590(1, 'Innova', 1, NULL, NULL, 1, '2017-06-14 00:00:00', '2017-06-14 13:13:40'),
1591(2, 'POLO GTTI', 2, 302, 'POLO GTTI is volkswagen model', 1, NULL, '2017-06-14 13:18:44'),
1592(3, 'NIce', 1, 318, 'gvhhjj hhjhjjj hhjjj', 1, NULL, '2017-06-15 06:32:36'),
1593(4, '800', 5, 320, 'gfv,hjgkgj hjgukghk', 1, NULL, '2017-06-15 06:34:39'),
1594(5, 'Normal POLO', 2, 325, 'its normal polo', 1, NULL, '2017-06-15 10:40:49'),
1595(6, 'sdf', 2, 341, 'dsfdsf', 0, NULL, '2017-06-17 04:49:35'),
1596(7, 'sdfs', 4, NULL, 'dsfdsfs', 0, NULL, '2017-06-17 04:49:55'),
1597(8, 'fgfdg', 2, 369, 'fdgfdg', 0, NULL, '2017-06-17 08:41:12'),
1598(9, 'Honda City', 10, 419, 'gvjhvjkbhj', 1, NULL, '2017-06-19 04:53:22');
1599
1600-- --------------------------------------------------------
1601
1602--
1603-- Table structure for table `vehicle_type`
1604--
1605
1606CREATE TABLE IF NOT EXISTS `vehicle_type` (
1607  `id` int(11) NOT NULL AUTO_INCREMENT,
1608  `name` varchar(255) DEFAULT NULL,
1609  `fk_image` int(11) DEFAULT NULL,
1610  `description` text,
1611  `status` int(11) DEFAULT '1',
1612  `created_at` timestamp NULL DEFAULT NULL,
1613  `modified_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1614  PRIMARY KEY (`id`),
1615  KEY `fk_vehicle_type_image_idx` (`fk_image`)
1616) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
1617
1618--
1619-- Dumping data for table `vehicle_type`
1620--
1621
1622INSERT INTO `vehicle_type` (`id`, `name`, `fk_image`, `description`, `status`, `created_at`, `modified_at`) VALUES
1623(1, 'Heavy Loaded', NULL, NULL, 0, '2017-06-14 00:00:00', '2017-06-14 13:16:38'),
1624(2, 'Heavy Loaded', 300, 'Heavy loaded Vehicle', 1, NULL, '2017-06-14 13:16:33'),
1625(3, 'Normal', 311, 'Medium msaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh8uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa ah', 0, NULL, '2017-06-15 06:17:52'),
1626(4, 'Normal', 312, 'Medium', 1, NULL, '2017-06-15 06:18:21'),
1627(5, 'Low', 313, 'Good', 1, NULL, '2017-06-15 06:19:03'),
1628(6, 'Light Weight', 314, 'agahd gusgdiu udshfiusyf', 1, NULL, '2017-06-15 06:21:12'),
1629(7, 'Average', 315, 'ggghjhj hjjkk fyfy\r\n', 1, NULL, '2017-06-15 06:23:37'),
1630(8, 'i10', 321, 'ghfjgk hjgkug', 1, NULL, '2017-06-15 07:08:18'),
1631(9, 'Small Vehicle', 323, 'its a small vehicle', 1, NULL, '2017-06-15 10:38:37'),
1632(10, 'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh', NULL, 'ghhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhk................................................uyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyh', 0, NULL, '2017-06-16 06:05:56'),
1633(11, 'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh', NULL, 'ghhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhk................................................uyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyh', 0, NULL, '2017-06-16 06:05:48'),
1634(12, 'gvsfgb', NULL, 'bdvgsfg', 0, NULL, '2017-06-16 12:12:22'),
1635(13, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', NULL, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 0, NULL, '2017-06-16 06:09:41'),
1636(14, 'fdsf', 339, 'sfdfdsfds', 0, NULL, '2017-06-17 04:48:53'),
1637(15, 'vcvcv', 364, 'cvcvvc', 0, NULL, '2017-06-17 08:40:27'),
1638(16, 'i10 Grand', 417, 'hjhjhkhkjkljkljlkjlkj jnkikjkljl fs', 1, NULL, '2017-06-19 04:50:44');
1639
1640--
1641-- Constraints for dumped tables
1642--
1643
1644--
1645-- Constraints for table `accident_history`
1646--
1647ALTER TABLE `accident_history`
1648  ADD CONSTRAINT `accident_history_ibfk_1` FOREIGN KEY (`fk_location_locality`) REFERENCES `locality` (`id`),
1649  ADD CONSTRAINT `fk_accident_history_driver` FOREIGN KEY (`fk_driver`) REFERENCES `driver` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
1650  ADD CONSTRAINT `fk_accident_history_vehicle` FOREIGN KEY (`fk_vehicle`) REFERENCES `vehicle` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
1651
1652--
1653-- Constraints for table `account`
1654--
1655ALTER TABLE `account`
1656  ADD CONSTRAINT `fk_account_person` FOREIGN KEY (`fk_person`) REFERENCES `person` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
1657
1658--
1659-- Constraints for table `activity_log`
1660--
1661ALTER TABLE `activity_log`
1662  ADD CONSTRAINT `fk_activity_log_account` FOREIGN KEY (`fk_account`) REFERENCES `account` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
1663
1664--
1665-- Constraints for table `address`
1666--
1667ALTER TABLE `address`
1668  ADD CONSTRAINT `address_ibfk_1` FOREIGN KEY (`fk_locality`) REFERENCES `locality` (`id`),
1669  ADD CONSTRAINT `fk_address_city` FOREIGN KEY (`fk_city`) REFERENCES `city` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
1670  ADD CONSTRAINT `fk_address_country` FOREIGN KEY (`fk_country`) REFERENCES `country` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
1671  ADD CONSTRAINT `fk_address_district` FOREIGN KEY (`fk_district`) REFERENCES `district` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
1672  ADD CONSTRAINT `fk_address_state` FOREIGN KEY (`fk_state`) REFERENCES `state` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
1673
1674--
1675-- Constraints for table `auth_assignment`
1676--
1677ALTER TABLE `auth_assignment`
1678  ADD CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
1679
1680--
1681-- Constraints for table `auth_item`
1682--
1683ALTER TABLE `auth_item`
1684  ADD CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE;
1685
1686--
1687-- Constraints for table `auth_item_child`
1688--
1689ALTER TABLE `auth_item_child`
1690  ADD CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
1691  ADD CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
1692
1693--
1694-- Constraints for table `behaviour`
1695--
1696ALTER TABLE `behaviour`
1697  ADD CONSTRAINT `fk_behaviour_driver` FOREIGN KEY (`fk_driver`) REFERENCES `driver` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
1698  ADD CONSTRAINT `fk_behavour_vehicle` FOREIGN KEY (`fk_vehicle`) REFERENCES `vehicle` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
1699
1700--
1701-- Constraints for table `city`
1702--
1703ALTER TABLE `city`
1704  ADD CONSTRAINT `fk_city_district` FOREIGN KEY (`fk_district`) REFERENCES `district` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
1705
1706--
1707-- Constraints for table `company`
1708--
1709ALTER TABLE `company`
1710  ADD CONSTRAINT `company_ibfk_1` FOREIGN KEY (`fk_image`) REFERENCES `image` (`id`),
1711  ADD CONSTRAINT `fk_company_account` FOREIGN KEY (`fk_account`) REFERENCES `account` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
1712  ADD CONSTRAINT `fk_company_address` FOREIGN KEY (`fk_address`) REFERENCES `address` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
1713  ADD CONSTRAINT `fk_company_package` FOREIGN KEY (`fk_package`) REFERENCES `package` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
1714
1715--
1716-- Constraints for table `device`
1717--
1718ALTER TABLE `device`
1719  ADD CONSTRAINT `fk_device_vehicle` FOREIGN KEY (`fk_vehicle`) REFERENCES `vehicle` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
1720
1721/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1722/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1723/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;