-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 15, 2016 at 11:04 AM
-- Server version: 5.5.49-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.19
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `taxiapp`
--
-- --------------------------------------------------------
--
-- Table structure for table `adminlogin`
--
CREATE TABLE IF NOT EXISTS `adminlogin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`username` varchar(250) NOT NULL,
`password` varchar(250) NOT NULL,
`role` varchar(250) NOT NULL,
`email` varchar(250) NOT NULL,
`mobile` varchar(250) NOT NULL,
`gender` varchar(250) NOT NULL,
`image` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `adminlogin`
--
INSERT INTO `adminlogin` (`id`, `name`, `username`, `password`, `role`, `email`, `mobile`, `gender`, `image`) VALUES
(1, 'Sarju Tank', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin', 'sarju@techintegrity.in', '1452635874', 'male', 'adminimage/admin.png');
-- --------------------------------------------------------
--
-- Table structure for table `airport_details`
--
CREATE TABLE IF NOT EXISTS `airport_details` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `airport_details`
--
INSERT INTO `airport_details` (`id`, `name`) VALUES
(7, ' Singapore'),
(10, 'Melbourne');
-- --------------------------------------------------------
--
-- Table structure for table `app_languages`
--
CREATE TABLE IF NOT EXISTS `app_languages` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`language_name` varchar(50) NOT NULL,
`language_meta` longtext NOT NULL,
`status` varchar(10) NOT NULL COMMENT '0->disabled, 1->Enaled',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `app_languages`
--
INSERT INTO `app_languages` (`id`, `language_name`, `language_meta`, `status`) VALUES
(8, 'Tamil', '{"New_user_Sign_Up_Now":"\\u0baa\\u0bc1\\u0ba4\\u0bbf\\u0baf \\u0baa\\u0baf\\u0ba9\\u0bb0\\u0bcd ? \\u0b87\\u0baa\\u0bcd\\u0baa\\u0bc6\\u0bbe\\u0ba4\\u0bc1 \\u0baa\\u0ba4\\u0bbf\\u0bb5\\u0bc1 \\u0b9a\\u0bc6\\u0baf\\u0bcd !","Sign_In":"\\u0b89\\u0bb3\\u0bcd\\u0ba8\\u0bc1\\u0bb4\\u0bc8\\u0baf\\u0bb5\\u0bc1\\u0bae\\u0bcd","Forgot_Password":"\\u0b95\\u0b9f\\u0bb5\\u0bc1\\u0b9a\\u0bcd\\u0b9a\\u0bc6\\u0bbe\\u0bb2\\u0bcd \\u0bae\\u0bb1\\u0ba8\\u0bcd\\u0ba4\\u0bc1 \\u0bb5\\u0bbf\\u0b9f\\u0bcd\\u0b9f\\u0bc0\\u0bb0\\u0bcd\\u0b95\\u0bb3\\u0bbe","Or_sign_In_with":"\\u0b85\\u0bb2\\u0bcd\\u0bb2\\u0ba4\\u0bc1 \\u0b95\\u0bc6\\u0bbe\\u0ba3\\u0bcd\\u0b9f\\u0bc1 \\u0b89\\u0bb3\\u0bcd\\u0ba8\\u0bc1\\u0bb4\\u0bc8\\u0baf\\u0bb5\\u0bc1\\u0bae\\u0bcd","SIGN_UP":"\\u0baa\\u0ba4\\u0bbf\\u0bb5\\u0bc1","Name":"\\u0baa\\u0bc6\\u0baf\\u0bb0\\u0bcd","User_Name":"\\u0baa\\u0baf\\u0ba9\\u0bb0\\u0bcd\\u0baa\\u0bc6\\u0baf\\u0bb0\\u0bcd","Mobile":"\\u0bae\\u0bc6\\u0bbe\\u0baa\\u0bc8\\u0bb2\\u0bcd","Mail":"\\u0bae\\u0bbf\\u0ba9\\u0bcd\\u0ba9\\u0b9e\\u0bcd\\u0b9a\\u0bb2\\u0bcd","Password":"\\u0b95\\u0b9f\\u0bb5\\u0bc1\\u0b9a\\u0bcd\\u0b9a\\u0bc6\\u0bbe\\u0bb2\\u0bcd","Confirm_Password":"\\u0b95\\u0b9f\\u0bb5\\u0bc1\\u0b9a\\u0bcd\\u0b9a\\u0bc6\\u0bbe\\u0bb2\\u0bcd\\u0bb2\\u0bc8 \\u0b89\\u0bb1\\u0bc1\\u0ba4\\u0bbf\\u0baa\\u0bcd\\u0baa\\u0b9f\\u0bc1\\u0ba4\\u0bcd\\u0ba4\\u0bc1\\u0b95","Enter_your_name":"\\u0b89\\u0b99\\u0bcd\\u0b95\\u0bb3\\u0bcd \\u0baa\\u0bc6\\u0baf\\u0bb0\\u0bc8 \\u0b89\\u0bb3\\u0bcd\\u0bb3\\u0bbf\\u0b9f\\u0bb5\\u0bc1\\u0bae\\u0bcd","Enter_user_name":"\\u0baa\\u0baf\\u0ba9\\u0bb0\\u0bcd\\u0baa\\u0bc6\\u0baf\\u0bb0\\u0bcd \\u0ba8\\u0bc1\\u0bb4\\u0bc8\\u0baf","Enter_your_number":"\\u0b89\\u0b99\\u0bcd\\u0b95\\u0bb3\\u0bcd \\u0b8e\\u0ba3\\u0bcd\\u0ba3\\u0bc8 \\u0b9a\\u0bc7\\u0bb0\\u0bcd\\u0b95\\u0bcd\\u0b95\\u0bb5\\u0bc1\\u0bae\\u0bcd","Enter_valid_mobile_number":"\\u0b9a\\u0bb0\\u0bbf\\u0baf\\u0bbe\\u0ba9 \\u0bae\\u0bc6\\u0bbe\\u0baa\\u0bc8\\u0bb2\\u0bcd \\u0b8e\\u0ba3\\u0bcd\\u0ba3\\u0bc8 \\u0b9a\\u0bc7\\u0bb0\\u0bcd\\u0b95\\u0bcd\\u0b95\\u0bb5\\u0bc1\\u0bae\\u0bcd","Enter_email":"\\u0bae\\u0bbf\\u0ba9\\u0bcd\\u0ba9\\u0b9e\\u0bcd\\u0b9a\\u0bb2\\u0bcd \\u0b89\\u0bb3\\u0bcd\\u0bb3\\u0bbf\\u0b9f\\u0bb5\\u0bc1\\u0bae\\u0bcd","Enter_valid_email":"\\u0b9a\\u0bb0\\u0bbf\\u0baf\\u0bbe\\u0ba9 \\u0bae\\u0bbf\\u0ba9\\u0bcd\\u0ba9\\u0b9e\\u0bcd\\u0b9a\\u0bb2\\u0bc8 \\u0b89\\u0bb3\\u0bcd\\u0bb3\\u0bbf\\u0b9f\\u0bb5\\u0bc1\\u0bae\\u0bcd","Enter_Password":"\\u0b95\\u0b9f\\u0bb5\\u0bc1\\u0b9a\\u0bcd\\u0b9a\\u0bc6\\u0bbe\\u0bb2\\u0bcd \\u0ba8\\u0bc1\\u0bb4\\u0bc8\\u0baf","Minimum_6_characters":"\\u0b95\\u0bc1\\u0bb1\\u0bc8\\u0ba8\\u0bcd\\u0ba4\\u0baa\\u0b9f\\u0bcd\\u0b9a\\u0bae\\u0bcd 6 \\u0b8e\\u0bb4\\u0bc1\\u0ba4\\u0bcd\\u0ba4\\u0bc1","Passwords_do_not_match":"\\u0b95\\u0b9f\\u0bb5\\u0bc1\\u0b9a\\u0bcd\\u0b9a\\u0bc6\\u0bbe\\u0bb1\\u0bcd\\u0b95\\u0bb3\\u0bcd \\u0baa\\u0bc6\\u0bbe\\u0bb0\\u0bc1\\u0ba8\\u0bcd\\u0ba4\\u0bb5\\u0bbf\\u0bb2\\u0bcd\\u0bb2\\u0bc8","Enter_user_name_email_mobile":"\\u0baa\\u0baf\\u0ba9\\u0bb0\\u0bcd \\u0baa\\u0bc6\\u0baf\\u0bb0\\u0bcd \\/ \\u0bae\\u0bbf\\u0ba9\\u0bcd\\u0ba9\\u0b9e\\u0bcd\\u0b9a\\u0bb2\\u0bcd \\/ \\u0bae\\u0bc6\\u0bbe\\u0baa\\u0bc8\\u0bb2\\u0bcd \\u0b89\\u0bb3\\u0bcd\\u0bb3\\u0bbf\\u0b9f\\u0bb5\\u0bc1\\u0bae\\u0bcd","My_Trips":"\\u0b8e\\u0ba9\\u0bcd \\u0baa\\u0baf\\u0ba3\\u0b99\\u0bcd\\u0b95\\u0bb3\\u0bcd","Logout":"\\u0bb5\\u0bc6\\u0bb3\\u0bbf\\u0baf\\u0bc7\\u0bb1\\u0bc1","My_Ride":"\\u0b8e\\u0ba9\\u0bcd \\u0bb0\\u0bc8\\u0b9f\\u0bc1","NEW_RIDES":"\\u0baa\\u0bc1\\u0ba4\\u0bbf\\u0baf \\u0b9a\\u0bb5\\u0bbe\\u0bb0\\u0bbf\\u0b95\\u0bb3\\u0bcd","COMPLETED":"\\u0ba8\\u0bbf\\u0bb1\\u0bc8\\u0bb5\\u0bc1","CANCELLED":"\\u0bb0\\u0ba4\\u0bcd\\u0ba4\\u0bc1","Trip_Details":"\\u0baa\\u0baf\\u0ba3\\u0bae\\u0bcd \\u0bb5\\u0bbf\\u0baa\\u0bb0\\u0b99\\u0bcd\\u0b95\\u0bb3\\u0bcd","BOOKING_ID":"\\u0baa\\u0ba4\\u0bbf\\u0bb5\\u0bc1 \\u0b90\\u0b9f\\u0bbf\\u0baf\\u0bc8","PICKUP_POINT":"\\u0b8e\\u0b9f\\u0bc1 \\u0baa\\u0bc1\\u0bb3\\u0bcd\\u0bb3\\u0bbf","TO":"TO T","DROP_POINT":"DROP POINT T","VEHICLE_DETAILS":"VEHICLE DETAILS T","CAB_TYPE":"CAB TYPE T","DRIVER_DETAILS":"DRIVER DETAILS T","Payment_Details":"Payment Details T","Distance":"Details T","Total_Amount":"Total Amount T","Accept":"Accept T","SEND_YOUR_FEED_BACK":"SEND YOUR FEED BACK T","No_network_connection":"No network connection! T","GET_DIRECTIONS":"GET DIRECTIONS T","START_NOW":"START NOW T","Map_View":"Map View T","Rate_Card":"Rate Card T","RUNNING_DETAILES":"RUNNING DETAILES T","CURRENT_LOCATION":"CURRENT LOCATION T","MINIMUM_DISTANCE":"MINIMUM DISTANCE T","MINIMUM_RATE":"MINIMUM RATE T","STANDARD_RATE":"STANDARD RATE T","TRIP_TYPE":"TRIP TYPE T","TOTAL_TRAVELED":"TOTAL TRAVELED T","TOTAL_RATE":"TOTAL RATE T","CANCEL":"CANCEL T","STOP":"STOP T","hidden_lang":"Tamil"}', '1'),
(9, 'English', '', '0'),
(10, 'Malayalam', '', '0'),
(11, 'Telunk', '', '0'),
(12, 'Marathi ', '', '0');
-- --------------------------------------------------------
--
-- Table structure for table `blogs`
--
CREATE TABLE IF NOT EXISTS `blogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`block_name` text NOT NULL,
`blog_content` text NOT NULL,
`baner_car` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `blogs`
--
INSERT INTO `blogs` (`id`, `block_name`, `blog_content`, `baner_car`) VALUES
(1, 'Quality&Reliability1', 'Pool of well maintained cars to choose from Amenities for comfort and convenience Well trained and experienced cab drivers 24hr cab availability Modern technologies for better experience and safety Safe and reliable service at affordable pricing \n
\n
\n
\n
\n
\n
\n\nCall us 24 hours available \n \n\n800 666 7777 \n \n\nCall My Cab is a taxi and cab service provider across India, we provide the most convenient and affordable taxi services in just a mouse click. Our cabs will be at your door steps within short time and this would save you from calling multiple cab companies for checking cab availability. We promise you a safer and affordable trip, experience an amazing journey at a smarter price.
\n \n \n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
It''s New and It''s Everywhere! \n
India’s quickest and most amazing and affordable way to book and track a cab is here. Download our free Call My Cab app now and make the most convenient and amazing cab service in your pockets, Be taxi ready always.
\n
Get Call My Cab on your mobile. \n
+91
\n
\n
\n
\n
\n \n
\n
\n
\n
\n
Our cities Bangalore
Bangalore City Cab Service
Bangalore Airport Cab Service
Chennai
Chennai City Cab Service
Chennai Airport Cab Service
Delhi
Delhi City Cab Service
Delhi Airport Cab Service
Hyderabad
Hyderabad City Cab Service
Hyderabad Airport Cab Service
\n \n \n \n \n \n \n \n \n \n \n \n \n \n Welcome To naqil ! \n \n \n Please Find Below Your Login Details \n \n \n \n \n \n \n User Name \n {username} \n \n \n Password \n {password} \n \n \n
\n \n \n \n Thank You, \n \n \n {SITE_NAME} Team \n \n \n
\n \n \n \n
\n'),
(2, 'Forgot Password', 'Somebody requested a new password for your Indiaries', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n Hi, \r\n \r\n Your login email is : \r\n {email} \r\n \r\n \r\n Your new password is : \r\n {password} \r\n \r\n \r\n {SITE_NAME} Team \r\n \r\n \r\n
\r\n \r\n \r\n \r\n
\r\n');
-- --------------------------------------------------------
--
-- Table structure for table `package_details`
--
CREATE TABLE IF NOT EXISTS `package_details` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`package` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `package_details`
--
INSERT INTO `package_details` (`id`, `package`) VALUES
(1, '4hrs 40Kms'),
(6, '9hrs 90kms');
-- --------------------------------------------------------
--
-- Table structure for table `pages`
--
CREATE TABLE IF NOT EXISTS `pages` (
`p_id` int(11) NOT NULL AUTO_INCREMENT,
`pages` varchar(250) NOT NULL,
PRIMARY KEY (`p_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;
--
-- Dumping data for table `pages`
--
INSERT INTO `pages` (`p_id`, `pages`) VALUES
(1, 'adduser'),
(2, 'promocode'),
(3, 'add_driver'),
(4, 'add_settings'),
(5, 'taxi_details_air'),
(6, 'taxi_details'),
(7, 'taxi_details_hourly'),
(8, 'taxi_details_outstation'),
(9, 'userlist'),
(10, 'airportview'),
(11, 'dashboard'),
(12, 'edit_user'),
(13, 'hourlyview'),
(14, 'outstationview'),
(15, 'pointview'),
(16, 'edit_airport'),
(17, 'edit_taxi'),
(18, 'edit_driver'),
(19, 'edit_hourly'),
(20, 'edit_outstation'),
(21, 'edit_point'),
(22, 'edit_promocode'),
(23, 'edit_airport_taxi'),
(24, 'edit_hourly_taxi'),
(25, 'edit_outstation_taxi'),
(26, 'role_management'),
(27, 'taxi_airport'),
(28, 'taxi_view'),
(29, 'taxi_hourly'),
(30, 'taxi_outstation'),
(31, 'view_driver'),
(32, 'view_promocode'),
(33, 'backened_user'),
(34, 'add_backend_user'),
(35, 'edit_bakend_user'),
(36, 'addpoint'),
(37, 'addair'),
(38, 'addhourly'),
(39, 'addout'),
(40, 'view_airmanage'),
(41, 'add_airmanage'),
(42, 'edit_air_manage'),
(43, 'view_package'),
(44, 'add_package'),
(45, 'edit_package'),
(46, 'view_places'),
(47, 'places_add'),
(48, 'edit_places'),
(49, 'view_language'),
(50, 'add_language'),
(51, 'edit_language'),
(52, 'view_page'),
(53, 'add_page'),
(54, 'add_banner'),
(55, 'view_pages'),
(56, 'edit_pages'),
(57, 'pointdriver'),
(58, 'airportdriver'),
(59, 'hourlydriver'),
(60, 'outdriver'),
(61, 'wallet_list'),
(62, 'callback_list');
-- --------------------------------------------------------
--
-- Table structure for table `places`
--
CREATE TABLE IF NOT EXISTS `places` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`location` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `places`
--
INSERT INTO `places` (`id`, `location`) VALUES
(1, 'qwqwqww'),
(2, 'qwqwqw'),
(3, 'vamanapuramd'),
(4, 'Heraklion');
-- --------------------------------------------------------
--
-- Table structure for table `promocode`
--
CREATE TABLE IF NOT EXISTS `promocode` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`promocode` varchar(100) NOT NULL,
`type` varchar(25) NOT NULL,
`amount` varchar(250) NOT NULL,
`startdate` datetime NOT NULL,
`enddate` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `promocode`
--
INSERT INTO `promocode` (`id`, `promocode`, `type`, `amount`, `startdate`, `enddate`) VALUES
(3, 'eeeeeeee', 'Fixed', '55', '2015-11-26 17:16:00', '2015-11-27 17:16:00');
-- --------------------------------------------------------
--
-- Table structure for table `role`
--
CREATE TABLE IF NOT EXISTS `role` (
`r_id` int(11) NOT NULL AUTO_INCREMENT,
`rolename` varchar(250) NOT NULL,
`created_date` varchar(250) NOT NULL,
PRIMARY KEY (`r_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;
--
-- Dumping data for table `role`
--
INSERT INTO `role` (`r_id`, `rolename`, `created_date`) VALUES
(1, 'admin', '2015-05-19 13:02:37'),
(6, 'user', '2015-05-25 09:13:48'),
(40, 'asd', '');
-- --------------------------------------------------------
--
-- Table structure for table `role_permission`
--
CREATE TABLE IF NOT EXISTS `role_permission` (
`r_id` int(11) NOT NULL AUTO_INCREMENT,
`role_id` int(11) NOT NULL,
`page_id` varchar(250) NOT NULL,
PRIMARY KEY (`r_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `role_permission`
--
INSERT INTO `role_permission` (`r_id`, `role_id`, `page_id`) VALUES
(1, 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62'),
(2, 2, '14,2,27,29,26,'),
(3, 3, '15,10,13,14,32,2,4,'),
(5, 90, '1,'),
(6, 92, '1,2,'),
(7, 6, '15,57,10,58,'),
(8, 5, '15,10,13,14,32,2,31,3,4,26,26,33,34,35,40,41,42,'),
(9, 23, '51,');
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(250) NOT NULL,
`logo` varchar(250) NOT NULL,
`favicon` varchar(250) NOT NULL,
`smtp_username` varchar(250) NOT NULL,
`smtp_host` varchar(250) NOT NULL,
`smtp_password` varchar(250) NOT NULL,
`email` varchar(250) NOT NULL,
`places` varchar(245) NOT NULL,
`country` varchar(255) NOT NULL,
`communication` varchar(205) NOT NULL,
`sender_id` varchar(208) NOT NULL,
`sms_username` varchar(204) NOT NULL,
`sms_password` varchar(204) NOT NULL,
`languages` varchar(250) NOT NULL,
`sidebar` varchar(250) NOT NULL,
`paypal` varchar(250) NOT NULL,
`paypalid` varchar(250) NOT NULL,
`serv_secret_key` text NOT NULL,
`analatic_code` text NOT NULL,
`measurements` varchar(250) NOT NULL,
`currency` varchar(250) CHARACTER SET utf8 NOT NULL,
`paypal_option` varchar(250) NOT NULL,
`verification` varchar(250) NOT NULL,
`mechanic_assigned` varchar(25) NOT NULL,
`authorize_net_url` varchar(250) NOT NULL,
`authorize_key` varchar(250) NOT NULL,
`authorize_id` varchar(250) NOT NULL,
`braintree_merchant_id` varchar(250) NOT NULL,
`braintree_public_key` varchar(250) NOT NULL,
`braintree_private_key` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `title`, `logo`, `favicon`, `smtp_username`, `smtp_host`, `smtp_password`, `email`, `places`, `country`, `communication`, `sender_id`, `sms_username`, `sms_password`, `languages`, `sidebar`, `paypal`, `paypalid`, `serv_secret_key`, `analatic_code`, `measurements`, `currency`, `paypal_option`, `verification`, `mechanic_assigned`, `authorize_net_url`, `authorize_key`, `authorize_id`, `braintree_merchant_id`, `braintree_public_key`, `braintree_private_key`) VALUES
(1, 'naqilcom', 'upload/logo.png', 'upload/favicon.png', 'admin', 'localhost', 'admin', 'techware@co.in', 'google', 'Saudi riyal', 'email', 'TWSMSG', 'nixon', '968808', '', 'Horizontal', 'https://www.sandbox.paypal.com/cgi-bin/webscr', 'shajeermhmmd@gmail.com', 'My_key', 'UA-66794740-1', 'km', 'ريال', 'PayPal,By hand,Authorize.Net', 'on', 'on', 'https://www.paypal.com/cgi-bin/webscr', '6Wxf5863CD67gCrh', '5PvGS4m8s', 'gngrm93xnb5xsqx7', 'j2295fzc7jvdr68t', '2130762be87849cc0750228f0e94ca88');
-- --------------------------------------------------------
--
-- Table structure for table `static_pages`
--
CREATE TABLE IF NOT EXISTS `static_pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`page_name` varchar(50) NOT NULL,
`page_title` text NOT NULL,
`page_content` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `static_pages`
--
INSERT INTO `static_pages` (`id`, `page_name`, `page_title`, `page_content`) VALUES
(1, 'about_us', 'About Us', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\nLorem Ipsum Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\nLorem Ipsum Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\nLorem Ipsum Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\n\nIt is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. \nIt is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. \nIt is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. \nIt is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. \nIt is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. \n \nIt is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.
'),
(2, 'contact_us', 'Contact', ' Techware Solution, Heavenly Plaza ES&FS 7th Floor,Kakkanad, Cochin, Kerala – 682021 or contact us by sending us mail on support@site.in
');
-- --------------------------------------------------------
--
-- Table structure for table `time_detail`
--
CREATE TABLE IF NOT EXISTS `time_detail` (
`tid` int(11) NOT NULL AUTO_INCREMENT,
`day_start_time` varchar(255) NOT NULL,
`day_end_time` varchar(255) NOT NULL,
PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `time_detail`
--
INSERT INTO `time_detail` (`tid`, `day_start_time`, `day_end_time`) VALUES
(1, '09:00', '18:00');
-- --------------------------------------------------------
--
-- Table structure for table `userdetails`
--
CREATE TABLE IF NOT EXISTS `userdetails` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`image` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`username` varchar(100) NOT NULL,
`mobile` varchar(250) NOT NULL,
`email` varchar(50) NOT NULL,
`gender` varchar(250) NOT NULL,
`dob` date NOT NULL,
`password` varchar(50) NOT NULL,
`pickupadd` varchar(250) NOT NULL,
`user_status` varchar(11) NOT NULL,
`wallet_amount` varchar(250) NOT NULL,
`device_id` longtext NOT NULL,
`type` varchar(250) NOT NULL,
`facebook_id` text NOT NULL,
`twitter_id` text NOT NULL,
`isdevice` varchar(255) NOT NULL,
`device_token` varchar(255) NOT NULL,
`flag` varchar(10) NOT NULL DEFAULT 'no',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=94 ;
--
-- Dumping data for table `userdetails`
--
INSERT INTO `userdetails` (`id`, `image`, `name`, `username`, `mobile`, `email`, `gender`, `dob`, `password`, `pickupadd`, `user_status`, `wallet_amount`, `device_id`, `type`, `facebook_id`, `twitter_id`, `isdevice`, `device_token`, `flag`) VALUES
(3, 'driver311349813360-2016-07-29_10:59:15_img.png', 'Krishna', 'krs123', '9154211321', 'krs123@gmail.com', 'Female', '0000-00-00', 'c6692e2f7e49845ef53ab8a1169cae28', '', 'Active', '', '', '', '0', '0', '', '', 'no'),
(5, 'user357161836698-2016-09-03_08:28:27_img.png', 'Hiral121', 'hiral', '7405646091', 'hiral@gmail.com', 'Female', '1994-08-29', 'f0c996139e15f8b19ffbfbac9952964f', '', 'Active', '', '', '', '0', '0', '0', '', 'yes'),
(7, '', 'Priya', 'priya', '9154322654', 'tistest6@gmail.com', '', '0000-00-00', '25d55ad283aa400af464c76d713c07ad', '', 'Active', '', '', '', '0', '0', '', '', 'no'),
(10, '', 'Mohammed ghamdi', 'moghamdi', '0505473844', 'moghamdi55@gmail.com ', 'Gender', '0000-00-00', '6c972a410e564979252141e800cab937', '', 'Active', '', '', '', '0', '0', '1', '', 'no'),
(13, '', 'Test', 'test1', '7405646092', 'test1@gmail.com', 'Male', '1994-10-27', 'ceb6c970658f31504a901b89dcd3e461', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(25, '', 'Sarju999', 'sarju999', '1234567852', 'sarju@techintegrity.in', '', '2001-07-29', 'otasPt2K', '', 'Active', '', '', '', '1509375066049817', '0', '0', '', 'no'),
(26, '', 'Tis1', 'tis123', '9876543210', 'tis123@gmail.com', 'Female', '1982-08-30', '23c78edaa8bbcb35412e74b793215a4a', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(27, '', 'Jack', 'jack Chan', '9638527410', 'jack@gmail.com', 'Male', '1988-08-02', '66cb87e4e66a825d10cf4227e0e82eee', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(28, 'user135781024117-2016-08-04_02:01:34_img.png', 'Iostest1', 'iostest1', '9978654321', 'iostest1@gmail.com', 'Male', '1981-08-04', 'e73ac62eb7716fb9b4fa8f09cf67775b', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(29, '', 'Test123456', 'test123456', '4448889990', 'test123456@gmail.com', 'Male', '1982-08-04', '47ec2dd791e31e2ef2076caf64ed9b3d', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(30, '', 'Doll123456', 'doll123456', '8889996660', 'doll123456@gmail.com', 'Male', '1982-10-04', '6f5931400a51922b365b70fa4ed6d4a1', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(31, 'user3098288550-2016-08-04_03:42:36_img.png', 'Hh123', 'hh123', '7779998880', 'hh123@gmail.com', 'Male', '1987-05-18', 'cb2253b218975359dfe8a46242ea120f', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(42, '', 'Abc123', 'abc123', '7778889999', 'abc123@gmail.com', 'Male', '1981-08-04', '9a361ed860ec2617da5af72079594a21', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(45, 'driver378926083911-2016-08-06_11:31:27_img.png', 'Tes', 'test', '1234512345', 'testt@gmail.com', 'Male', '2008-08-06', 'c06db68e819be6ec3d26c6038d8e8d1f', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(46, '', 'Ketann', 'ketann', '1234567890', 'ketantis@gmail.com', 'Gender', '2016-08-06', '8b03d5ba789f45f34ab9de916c72e146', '', 'Active', '', '', '', '', '0', '1', '', 'yes'),
(47, '', 'Alfaisal3233', 'Alfaisal3233', '0501086332', 'faisal3233@gmail.com', 'Male', '1973-06-01', 'ed56493d65d661a0ade739d17925e205', '', 'Active', '', '', '', '', '0', '1', '', 'no'),
(48, 'user138841238338-2016-08-08_10:25:23_img.png', 'Riya', 'riya123', '7894563210', 'riya@gmail.com', 'Female', '1994-08-23', '859d6a15420bb9cf8815689a550de6cc', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(49, 'user626358192414-20160808_102757.jpg', 'User test', 'user test', '14785236', 'ketan@gmail.com', 'Male', '2016-08-08', '8b03d5ba789f45f34ab9de916c72e146', '', 'Active', '', '', '', '', '0', '1', '', 'no'),
(51, '', 'Sangna Tis', 'fb user', '369852147', 'fb@tis.com', 'Male', '2016-08-08', '8b03d5ba789f45f34ab9de916c72e146', '', 'Active', '', '', '', '1820379518185926', '', '1', '', 'no'),
(53, '', 'Sec user', 'sec use', '147850236', 'use@gmail.com', 'Male', '2016-08-08', '8b03d5ba789f45f34ab9de916c72e146', '', 'Active', '', '', '', '', '', '1', '', 'no'),
(54, '', 'Test', 'test001', '1234554321', 'test11@gmail.com', 'Male', '1994-10-27', 'c06db68e819be6ec3d26c6038d8e8d1f', '', 'Active', '', '', '', '', '', '1', '', 'no'),
(55, '', 'Testtest', 'test002', '1234566543', 'test002@gmail.com', 'Male', '1994-10-27', 'c06db68e819be6ec3d26c6038d8e8d1f', '', 'Active', '', '', '', '', '', '1', '', 'no'),
(56, 'driver361468635965-2016-08-16_11:53:12_img.png', 'Krs123', 'krish', '9175466323', 'krs2@gmail.com', 'Female', '2016-08-02', '9059e74cef3fa468265076b8bffc6cc0', '', 'Active', '', '', '', '1720613024829243', '0', '0', '', 'no'),
(57, '', 'Mohammed', 'moghamdi55', '0500716251', 'mohammedksa@yahoo.com', 'Male', '2015-08-10', '5f2b0f3cb823f1579f0cd990633f826b', '', 'Active', '', '', '', '', '', '1', '', 'no'),
(59, '', 'Sarju', 'sarju', '147856329', 'sarjutest@techintegrity.in', 'Male', '2016-08-09', 'aaf0f8ba5fb9e1827d9077aef89c8c07', '', 'Active', '', '', '', '', '', '1', '', 'no'),
(60, '', 'Sharif', '1234sha', '00966506070150', 'ph.binekrish@gmail.com', 'Male', '2016-08-12', '43e3b543cf0f0f02a6c046c718eeb8bb', '', 'Active', '', '', '', '', '', '1', '', 'no'),
(61, 'driver143390874844-2016-08-31_08:02:26_img.png', 'Naqil Test', 'naqiltest', '7874125103', 'tismember1@gmail.com', 'Male', '2007-06-10', '16d7a4fca7442dda3ad93c9a726597e4', '', 'Active', '', '', '', '0', '0', '0', '', 'yes'),
(62, 'driver191088122781-2016-08-15_05:20:53_img.png', 'Harshil', 'harshil', '7405646092', 'surani@gmail.com', 'Male', '1994-10-27', '982d324c31284025fb8ad1ca255a228b', '', 'Active', '', '', '', '628944123931574', '0', '0', '', 'yes'),
(63, 'driver777040311601-2016-08-13_07:47:00_img.png', 'Abctest', 'abctest', '9990008885', 'abctest@gmail.com', 'Female', '2016-08-02', 'ec067853d5e854bb186dd7d18b99d22f', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(64, 'user304674180690-2016-08-15_09:40:34_img.png', 'Sarju', 'tank', '9712993486', 'test@techintegrity.in', 'Female', '1988-08-15', '47ec2dd791e31e2ef2076caf64ed9b3d', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(65, '', 'Surani', 'surani', '7016673032', 'harshill@gmail.com', 'Male', '1994-10-27', '6283e7f4c03f424a80c2e9791cd80a48', '', 'Inactive', '', '', '', '0', '0', '0', '', 'no'),
(66, 'driver134165686555-2016-08-15_11:36:18_img.png', 'Final', 'finaltest', '1234567898', 'final@gmail.com', 'Male', '1985-08-15', 'd81aa7d5d5aa1fa946c4f8c91ad29242', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(67, '', 'Ahmed Binhassan', 'ahmedbinhassan', '9498997133', 'ahmed.s.binhassan@gmail.com', '', '0000-00-00', '5a05254570cc97ac9582ad7c5877f1ad', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(68, '', 'Sarjutest', 'tanktest', '1236547891', 'sarju@gmail.com', 'Male', '1998-08-18', '0659c7992e268962384eb17fafe88364', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(69, '', 'Sarjutest', 'tanktestqreqeer', '1236547890', 'sarjubnbm@gmail.com', 'Male', '1998-08-18', '0659c7992e268962384eb17fafe88364', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(70, '', 'Tsarju', 'tsarju', '1231478526', 'tsarju@gmail.com', 'Male', '1998-08-18', '0659c7992e268962384eb17fafe88364', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(71, '', 'TechService1', 'tech', '12345665432', 'tech@gmail.com', 'Male', '1994-10-27', '51d917f1e20bad9f5258378d532fe8b4', '', 'Active', '', '', '', '', '877105759', '1', '', 'no'),
(72, '', '0', 'vatsal', '4545454545', 'vatsal1@gmail.com', 'Male', '0000-00-00', 'e38594900410ff025a6bb8d036f4b4e3', '', 'Active', '', '', '', '', '', '0', '', 'yes'),
(73, 'driver380123280454-2016-08-31_09:24:21_img.png', 'Master', 'master', '1234501234', 'master@gmail.com', 'Male', '1994-10-08', '3b450b11a940f97b5a211861b4114689', '', 'Active', '', '', '', '628944123931574', '0', '0', '', 'no'),
(74, 'driver759030811954-2016-09-01_08:37:45_img.png', 'Naqiltestt', 'testt', '9909199091', 'test@gmail.com', 'Male', '1994-10-26', '16d7a4fca7442dda3ad93c9a726597e4', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(75, 'user75792819727-20160901_143147.jpg', 'Ketan test', 'ketantest', '7874454546', 'ketantis123@gmail.com', 'Male', '2016-08-01', '97e1df20f138d18f29227380004fb51c', '', 'Active', '', '', '', '', '', '1', '', 'yes'),
(77, 'user376640597358-2016-09-01_03:13:51_img.png', 'devill', 'devill', '1234567850', 'devil@yahoo.in', 'Male', '1994-10-27', '8c60ed9a210d0ee9d493b38e141aeee3', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(79, 'driver209151065908-2016-09-01_02:13:46_img.png', 'Sarju', 'sarju001', '0987654321', 'sarju1@gmail.com', 'Male', '1994-10-27', '79181a7d6a1531bb101d94e7b0703071', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(82, 'user800748870242-2016-09-05_07:59:19_img.png', 'First', 'first', '7405646099', 'first@gmail.com', 'Male', '1994-10-27', '79181a7d6a1531bb101d94e7b0703071', '', 'Active', '', '', '', '0', '0', '0', '', 'yes'),
(84, '', 'Erwinsm2', 'erwinsm2', '0728767282', 'hello@step4th.co.zs', 'Gender', '0000-00-00', '0659c7992e268962384eb17fafe88364', '', 'Active', '', '', '', '', '', '1', '', 'yes'),
(86, '', 'Rocky Spero', 'rocky', '1234567891', 'uttamgajjar@techintegrity.in', 'Male', '1988-09-02', 'a1109fb84511bc88d90dff250a110477', '', 'Active', '', '', '', '417345905128861', '0', '0', '', 'no'),
(87, '', 'Gggggggg', 'rtfuhfhf', '5454545454', 'rryryryu@gmail.com', 'Male', '1995-09-12', 'ee059a260e2b0ee69c1942a94aa5deff', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(88, '', 'Faisal', 'Alfaisal', '0505102293', 'faisal@orbitstel.com', '', '0000-00-00', 'ed56493d65d661a0ade739d17925e205', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(89, '', 'Faisals', 'faisalss', '0590047291', 'falsalem99@gmail.com', 'Male', '1997-09-03', '926dd770e78c10dd4f9523fadda083a1', '', 'Active', '', '', '', '0', '0', '0', '', 'no'),
(90, '', 'Sharif', 'binekrish', '0506070150', 'ph_sharif@yahoo.com', 'Male', '1974-06-21', 'b9445212dfd3a76af18036ecfd3c230a', '', 'Active', '', '', '', '0', '0', '0', '', 'yes'),
(91, '', 'Abcd', 'abcd', '7405646000', 'uttamgajjar@techintegrity.com', 'Male', '1994-10-27', '79181a7d6a1531bb101d94e7b0703071', '', 'Active', '', '', '', '', '', '1', '', 'no'),
(92, '', 'ehehehe', 'dgdh', '79484848484', 'd@gmail.com', 'Gender', '0000-00-00', '8b03d5ba789f45f34ab9de916c72e146', '', 'Active', '', '', '', '', '', '1', '', 'no'),
(93, '', 'Sultan', 'sultan60', '0592440040', 'sultan747@hotmail.com', 'Gender', '0000-00-00', '6ff097b777a6ed4184dbf21f2076ed81', '', 'Active', '', '', '', '', '', '1', '', 'no');
-- --------------------------------------------------------
--
-- Table structure for table `user_app_language`
--
CREATE TABLE IF NOT EXISTS `user_app_language` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`language_name` varchar(100) NOT NULL,
`language_meta` longtext NOT NULL,
`status` varchar(10) NOT NULL COMMENT '0-> disabled, 1->Enabled',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `user_app_language`
--
INSERT INTO `user_app_language` (`id`, `language_name`, `language_meta`, `status`) VALUES
(1, 'English', '{"Newuser_SignUp_now":"New user SignUp now","Or_sign_In_with":"Or sign In with","Forgot_Password":"Forgot Password","No_network_connection":"No network connection","Sign_In":"Sign In","SIGN_UP":"SIGN UP","Enter_your_name":"Enter your name","Name":"Name","Enter_user_name":"Enter user name","Enter_your_number":"Enter your number","Enter_valid_mobile_number":"Enter valid mobile number","Mobile":"Mobile","Enter_email":"Enter email","Enter_valid_email":"Enter valid email","Enter_Password":"Enter Password","Mail":"Mail","SIGN_IN":"SIGN IN","Enter_username_email_mobile":"Enter user name \\/ email \\/ mobile","Mobile_User_Name_Email":"Mobile \\/ User Name \\/ Email","password":"password","CallMy_Cab":"CallMyCab","Enter_Pickup_location":"Enter Pickup location","Enter_Drop_location":"Enter Drop location","Toyota_etios_tata_indigo_maruti_dezire":"Toyota etios \\/ tata indigo \\/ maruti dezire","Fare_Breakup":"Fare Breakup","First":"First","After":"After","Ridetime_rate":"Ride time rate","Airport_rate_may_differ_peaktime_chargesmayapply":"Airport rate may differ peak time charges may apply","RIDE_LATER":"RIDE LATER","RIDE_NOW":"RIDE NOW","Cancel":"Cancel","Book":"Book","Book_My_Ride":"Book My Ride","My_Trips":"My Trips","Rate_Card":"Rate Card","Logout":"Logout","My_Trip":"My Trip","Profile":"Profile","User_Name":"User Name","MAIL":"MAIL","CHANEGE_PASSWORD":"CHANEGE PASSWORD","Enter_new_Password":"Enter new Password","Minimum_6_characters":"Minimum 6 characters","Passwords_do_not_match":"Passwords do not match","Conform_password":"Conform password","RESET_PASSWORD":"RESET PASSWORD","Trip_Details":"Trip Details","BOOKING_ID":"BOOKING ID","PICKUP_POINT":"PICKUP POINT","TO":"TO","DROP_POINT":"DROP POINT","VEHICLE_DETAILS":"VEHICLE DETAILS","CAB_TYPE":"CAB TYPE","DRIVER_DETAILS":"DRIVER DETAILS","Payment_Details":" Distance Total Amount SEND YOUR FEED BACK","Distance":"Distance","Total_Amount":"Total Amount","SEND_YOUR_FEED_BACK":"SEND YOUR FEED BACK","hidden_lang":"English"}', '1');
-- --------------------------------------------------------
--
-- Table structure for table `visits`
--
CREATE TABLE IF NOT EXISTS `visits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(250) NOT NULL,
`country` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `visits`
--
INSERT INTO `visits` (`id`, `ip`, `country`) VALUES
(1, '192.168.138.31', 'EU'),
(2, '192.168.1.31', 'IN'),
(3, '192.168.138.6', ''),
(4, '192.168.1.16', ''),
(5, '192.168.138.19', ''),
(6, '192.168.138.17', ''),
(7, '192.168.1.6', ''),
(8, '192.168.138.9', '');
-- --------------------------------------------------------
--
-- Table structure for table `wallet`
--
CREATE TABLE IF NOT EXISTS `wallet` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(250) NOT NULL,
`item_no` varchar(250) NOT NULL,
`amount` varchar(250) NOT NULL COMMENT 'in $',
`status` varchar(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `wallet`
--
INSERT INTO `wallet` (`id`, `username`, `item_no`, `amount`, `status`) VALUES
(2, 'baby', '4YL9241607693264Y', '11.00', 'Completed');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Quality
Reliability
