-- phpMyAdmin SQL Dump
-- version 4.2.11
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Mar 13, 2019 at 08:24 AM
-- Server version: 5.6.21
-- PHP Version: 5.6.3
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: `assessor_backend`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin_users`
--
CREATE TABLE IF NOT EXISTS `admin_users` (
`id` int(11) NOT NULL,
`username` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`role_type` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `admin_users`
--
INSERT INTO `admin_users` (`id`, `username`, `email`, `password`, `role_type`) VALUES
(1, 'admin', 'admin@techware.co.in', '21232f297a57a5a743894a0e4a801fc3', 1);
-- --------------------------------------------------------
--
-- Table structure for table `checker`
--
CREATE TABLE IF NOT EXISTS `checker` (
`id` int(11) NOT NULL,
`checker_name` varchar(255) NOT NULL,
`image` varchar(750) NOT NULL,
`post_code` varchar(50) NOT NULL,
`phone` varchar(25) NOT NULL,
`email` varchar(50) NOT NULL,
`city` varchar(100) NOT NULL,
`state` varchar(50) NOT NULL,
`appointed_location` varchar(555) NOT NULL,
`password` varchar(50) NOT NULL,
`address` text NOT NULL,
`status` int(11) NOT NULL DEFAULT '1' COMMENT '1=>Active,0=>Inactive,2=>delete',
`on_duty` int(11) NOT NULL COMMENT '1- On Duty, 0- Off Duty'
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `checker`
--
INSERT INTO `checker` (`id`, `checker_name`, `image`, `post_code`, `phone`, `email`, `city`, `state`, `appointed_location`, `password`, `address`, `status`, `on_duty`) VALUES
(1, 'roy', '', '', '343454645656', 'roy.techware@gmail.com', '', '', 'g4', 's1YQOH', '', 1, 0),
(2, 'agl', '', '', '1212121212', 'ajil.techware1@gmail.com', '', '', '3', 'rY1nMb', '', 1, 0),
(3, 'raj', '', '', '1234567898', 'raj@gmail.com', '', '', 'fr', '123456', '', 1, 0),
(4, 'ER', '', '', '3332221123', 'ajil.techware2@gmail.com', '', '', 'RR', 'c8858a872ab648d0c1ffe6b1f98cc071', '', 1, 0),
(5, 'agk', '', '', '2345432345', 'ajil.techware@gmail.com', '', '', '33', '54af47a4c913ebd035ae6199a0087ceb', '', 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `check_in_history`
--
CREATE TABLE IF NOT EXISTS `check_in_history` (
`id` int(55) NOT NULL,
`user_id` int(55) NOT NULL,
`checker_id` int(55) NOT NULL,
`checkin_pin` varchar(222) NOT NULL,
`no_of_person` int(55) NOT NULL,
`checkin_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `check_in_history`
--
INSERT INTO `check_in_history` (`id`, `user_id`, `checker_id`, `checkin_pin`, `no_of_person`, `checkin_date`) VALUES
(1, 7, 2, 'AUCDE', 5, '2019-03-12 12:40:42'),
(2, 7, 2, 'AUCDE', 5, '2019-03-12 12:48:49'),
(3, 7, 2, 'AUCDE', 5, '2019-03-13 06:10:59'),
(4, 7, 2, 'AUCDE', 5, '2019-03-13 06:11:18');
-- --------------------------------------------------------
--
-- Table structure for table `service_log`
--
CREATE TABLE IF NOT EXISTS `service_log` (
`id` int(11) NOT NULL,
`url` varchar(255) DEFAULT NULL,
`parameter` longtext,
`auth` varchar(255) DEFAULT NULL,
`result` text,
`time` varchar(255) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=120 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `service_log`
--
INSERT INTO `service_log` (`id`, `url`, `parameter`, `auth`, `result`, `time`) VALUES
(1, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 08:43:02'),
(2, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:28:52'),
(3, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:30:40'),
(4, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:31:18'),
(5, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:33:02'),
(6, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:33:36'),
(7, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:34:12'),
(8, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:34:27'),
(9, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:34:45'),
(10, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:35:04'),
(11, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:35:43'),
(12, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:53:22'),
(13, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 09:57:38'),
(14, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 10:00:40'),
(15, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 10:08:16'),
(16, 'Webservices_user/check_pin', '{\n"pin":"2pSRby"\n}', '', NULL, '2019-03-12 10:09:33'),
(17, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:12:27'),
(18, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:12:49'),
(19, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:17:12'),
(20, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:18:04'),
(21, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:19:02'),
(22, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:19:30'),
(23, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:20:15'),
(24, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:24:08'),
(25, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:28:45'),
(26, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:29:42'),
(27, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:30:22'),
(28, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:31:20'),
(29, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:32:54'),
(30, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:33:19'),
(31, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:34:16'),
(32, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:35:52'),
(33, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:40:32'),
(34, 'Webservices_user/user_registration', '{\n"pin":"AUCDE",\n"phone_number":"4444444",\n"password":"ajil",\n"name":"agr"\n}', '', NULL, '2019-03-12 10:40:48'),
(35, 'Webservices_user/do_login', '{\n"email":"ajil.techware@gmail.com",\n"password":"ajil"\n}', '', NULL, '2019-03-12 10:50:50'),
(36, 'Webservices_user/do_login', '{\n"email":"ajil.techware@gmail.com",\n"password":"ajil"\n}', '', NULL, '2019-03-12 10:51:58'),
(37, 'Webservices_user/get_qr', '{"pin":"AUCDE"}', '', NULL, '2019-03-12 11:00:00'),
(38, 'Webservices_user/get_qr', '{"pin":"AUCDE"}', '', NULL, '2019-03-12 11:00:34'),
(39, 'Webservices_user/forgot_password', '{\n"new_password":"ajilgr",\n"pin":"AUCDE"\n}', '', NULL, '2019-03-12 11:07:02'),
(40, 'Webservices_user/edit_user', '{\n"phone_number":"111111111",\n"name":"roy",\n"gender":"1",\n"email":"roy@gmail.com",\n"dob":"1993-08-12",\n"pin":"GLV4u"\n}', '', NULL, '2019-03-12 11:23:29'),
(41, 'Webservices_user/update_profile_photo', '', '', NULL, '2019-03-12 12:00:11'),
(42, 'Webservices_user/update_profile_photo', '', '', NULL, '2019-03-12 12:01:04'),
(43, 'Webservices_user/update_profile_photo', '', '', NULL, '2019-03-12 12:02:06'),
(44, 'Webservices_user/update_profile_photo', '', '', NULL, '2019-03-12 12:02:38'),
(45, 'Webservices_user/update_profile_photo', '', '', NULL, '2019-03-12 12:03:12'),
(46, 'Webservices_user/update_profile_photo', '', '', NULL, '2019-03-12 12:03:41'),
(47, 'Webservices_user/edit_user', '{\n"phone_number":"111111111",\n"name":"roy",\n"gender":"1",\n"email":"roy@gmail.com",\n"dob":"1993-08-12",\n"pin":"GLV4u"\n}', '', NULL, '2019-03-12 12:04:40'),
(48, 'Webservices_user/update_profile_photo', '', '', NULL, '2019-03-12 12:05:16'),
(49, 'Webservices_user/update_profile_photo', '', '', NULL, '2019-03-12 12:05:42'),
(50, 'Webservices_user/update_profile_photo', '', '', NULL, '2019-03-12 12:06:08'),
(51, 'Webservices_user/get_qr', '{\n"email":"ajil.techware@gmail.com",\n"password":"ajil"\n}', '', NULL, '2019-03-12 12:08:32'),
(52, 'Webservices_user/get_qr', '{\n"email":"ajil.techware@gmail.com",\n"password":"agr"\n}', '', NULL, '2019-03-12 12:09:26'),
(53, 'Webservices_user/get_qr', '{\n"email":"ajil.techware@gmail.com",\n"password":"ajilgr"\n}', '', NULL, '2019-03-12 12:10:06'),
(54, 'Webservices_user/get_qr', '{\n"email":"ajil.techware@gmail.com",\n"password":"ajilgr"\n}', '', NULL, '2019-03-12 12:10:13'),
(55, 'Webservices_user/forgot_password', '{\n"new_password":"ajilgr",\n"pin":"AUCDE"\n}', '', NULL, '2019-03-12 12:11:01'),
(56, 'Webservices_user/do_login', '{\n"email":"ajil.techware@gmail.com",\n"password":"ajilgr"\n}', '', NULL, '2019-03-12 12:11:23'),
(57, 'Webservices_user/do_login', '{\n"email":"ajil.techware@gmail.com",\n"password":"ajilgr"\n}', '', NULL, '2019-03-12 12:13:00'),
(58, 'Webservices_checker/do_login', '{\n"email":"raj@gmail.com",\n"password":"123456"\n}', '', NULL, '2019-03-12 12:41:43'),
(59, 'Webservices_checker/do_login', '{\n"email":"raj@gmail.com",\n"password":"123456"\n}', '', NULL, '2019-03-12 12:42:02'),
(60, 'Webservices_checker/do_login', '{\n"email":"raj@gmail.com",\n"password":"123456"\n}', '', NULL, '2019-03-12 12:43:08'),
(61, 'Webservices_checker/do_login', '{\n"email":"raj@gmail.com",\n"password":"123456"\n}', '', NULL, '2019-03-12 12:43:31'),
(62, 'Webservices_checker/do_login', '{\n"email":"raj@gmail.com",\n"password":"123456"\n}', '', NULL, '2019-03-12 12:43:49'),
(63, 'Webservices_checker/do_login', '{\n"email":"raj@gmail.com",\n"password":"123456"\n}', '', NULL, '2019-03-12 12:44:46'),
(64, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:17:33'),
(65, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:18:52'),
(66, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:19:42'),
(67, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:20:12'),
(68, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:21:15'),
(69, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:21:32'),
(70, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:23:31'),
(71, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:26:48'),
(72, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:28:36'),
(73, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:28:49'),
(74, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:30:04'),
(75, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:30:25'),
(76, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:30:53'),
(77, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:31:05'),
(78, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:31:14'),
(79, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:31:24'),
(80, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:31:38'),
(81, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:32:29'),
(82, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:33:02'),
(83, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:33:26'),
(84, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:34:45'),
(85, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:36:22'),
(86, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:36:53'),
(87, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:37:04'),
(88, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:37:48'),
(89, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:38:37'),
(90, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:38:51'),
(91, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:39:09'),
(92, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:39:44'),
(93, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:40:42'),
(94, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-12 01:48:49'),
(95, 'Webservices_checker/do_login', '{\n"email":"raj@gmail.com",\n"":""\n}', '', NULL, '2019-03-13 05:57:41'),
(96, 'Webservices_checker/do_login', '{\n"email":"ajil.techware@gmail.com",\n"password":"ir0zoT"\n}', '', NULL, '2019-03-13 05:59:04'),
(97, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-13 07:10:59'),
(98, 'Webservices_checker/check_pin', '{\n"pin":"AUCDE",\n"checker_id":"2"\n\n}', '', NULL, '2019-03-13 07:11:18'),
(99, 'Webservices_checker/do_login', '{\n"email":"ajil.techware@gmail.com",\n"password":"ir0zoT"\n}', '', NULL, '2019-03-13 07:11:49'),
(100, 'Webservices_checker/do_login', '{\n"email":"ajil.techware@gmail.com",\n"password":"ir0zoT"\n}', '', NULL, '2019-03-13 07:11:56'),
(101, 'Webservices_checker/do_login', '{\n"email":"ajil.techware@gmail.com",\n"password":"ir0zoT"\n}', '', NULL, '2019-03-13 07:12:57'),
(102, 'Webservices_checker/do_login', '{\n"email":"ajil.techware@gmail.com",\n"password":"ir0zoT"\n}', '', NULL, '2019-03-13 07:13:12'),
(103, 'Webservices_checker/do_login', '{\n "email":"ajil.techware@gmail.com",\n "password":"ir0zoT"\n}', '', NULL, '2019-03-13 07:14:16'),
(104, 'Webservices_checker/do_login', '{"password":"ir0zoT","email":"ajil.techware@gmail.com"}', '', NULL, '2019-03-13 07:15:58'),
(105, 'Webservices_checker/do_login', '{"email":"ajil.techware@gmail.com","password":"HomeVC"}', '', NULL, '2019-03-13 07:18:40'),
(106, 'Webservices_checker/do_login', '{"email":"ajil.techware@gmail.com","password":"ir0zoT"}', '', NULL, '2019-03-13 07:18:54'),
(107, 'Webservices_checker/do_login', '{"email":"ajil.techware@gmail.com","password":"HomeVC"}', '', NULL, '2019-03-13 07:19:46'),
(108, 'Webservices_checker/do_login', '{"email":"ajil.techware@gmail.com","password":"ir0zoT"}', '', NULL, '2019-03-13 07:20:00'),
(109, 'Webservices_checker/do_login', '{"email":"ajil.techware@gmail.com","password":"ir0zoT"}', '', NULL, '2019-03-13 07:20:02'),
(110, 'Webservices_checker/do_login', '{"email":"ajil.techware@gmail.com","password":"ir0zoT"}', '', NULL, '2019-03-13 07:21:19'),
(111, 'Webservices_checker/do_login', '{"password":"ir0zoT","email":"ajil.techware@gmail.com"}', '', NULL, '2019-03-13 07:26:15'),
(112, 'Webservices_checker/do_login', '{"password":"ir0zoT","email":"ajil.techware@gmail.com"}', '', NULL, '2019-03-13 07:32:32'),
(113, 'Webservices_checker/do_login', '{"email":"ajil.techware@gmail.com","password":"ir0zoT"}', '', NULL, '2019-03-13 07:35:24'),
(114, 'Webservices_checker/do_login', '{"password":"ir0zoT","email":"ajil.techware@gmail.com"}', '', NULL, '2019-03-13 07:39:58'),
(115, 'Webservices_checker/do_login', '{"email":"ajil.techware@gmail.com","password":"ir0zoT"}', '', NULL, '2019-03-13 07:42:05'),
(116, 'Webservices_checker/do_login', '{"email":"ajil.techware@gmail.com","password":"ir0zoT"}', '', NULL, '2019-03-13 07:45:31'),
(117, 'Webservices_user/user_registration', '{\n"pin":"gpywQ",\n"phone_number":"4444444",\n"password":"123456",\n"name":"royraju"\n}', '', NULL, '2019-03-13 07:52:57'),
(118, 'Webservices_checker/do_login', '{"password":"ir0zoT","email":"ajil.ajil.techware@gmail.com"}', '', NULL, '2019-03-13 08:22:23'),
(119, 'Webservices_checker/do_login', '{"password":"ir0zoT","email":"ajil.techware@gmail.com"}', '', NULL, '2019-03-13 08:22:36');
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL,
`title` varchar(500) NOT NULL,
`logo` varchar(500) NOT NULL,
`favicon` varchar(500) NOT NULL,
`tax` int(10) NOT NULL,
`admin_charge` int(50) NOT NULL,
`booking_code` varchar(100) NOT NULL,
`key` varchar(200) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `title`, `logo`, `favicon`, `tax`, `admin_charge`, `booking_code`, `key`) VALUES
(1, '#303', 'assets/uploads/settings//1552292460.png', '', 12, 20, 'AJDY', 'AIzaSyA364oH1fQORNMYHeq7M8Ppkby68RSX6E8');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL,
`name` varchar(50) DEFAULT NULL,
`phone` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`dob` date NOT NULL,
`gender` int(4) NOT NULL COMMENT '1=>male,2=>female',
`profile_photo` varchar(555) NOT NULL,
`password` varchar(55) NOT NULL,
`check_id` varchar(250) NOT NULL,
`no_allowed_persons` int(55) NOT NULL,
`address` longtext,
`cheker_id` int(55) DEFAULT NULL,
`qr_code` varchar(444) NOT NULL,
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`expiration_date` date NOT NULL,
`status` int(11) NOT NULL DEFAULT '0' COMMENT '0=>Inviting,1=>Check-in,2=>Expired',
`note` longtext,
`active` int(4) NOT NULL DEFAULT '0' COMMENT '0=>Inactive,1=>active'
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `name`, `phone`, `email`, `dob`, `gender`, `profile_photo`, `password`, `check_id`, `no_allowed_persons`, `address`, `cheker_id`, `qr_code`, `created_on`, `expiration_date`, `status`, `note`, `active`) VALUES
(2, 'ajil', '1122334455', 'ajilkrishnagr@gmail.com', '0000-00-00', 0, '', '', '2pSRby', 8, 'add', NULL, 'assets/images/qrcode/2pSRby.png', '2019-03-11 10:00:37', '2019-03-24', 0, NULL, 1),
(5, 'roy', '111111111', 'roy@gmail.com', '1993-08-12', 1, '', '', 'GLV4u', 4, NULL, NULL, 'assets/images/qrcode/GLV4u.png', '2019-03-12 10:23:29', '2019-03-20', 0, NULL, 0),
(4, 'agl', '1234567876', 'ajil.techware1@gmail.com', '0000-00-00', 0, '', '', 'K7Nnov', 9, 'add', NULL, 'assets/images/qrcode/K7Nnov.png', '2019-03-12 05:28:25', '2019-03-21', 0, NULL, 1),
(6, NULL, '22222222', 'ajil.techware2@gmail.com', '0000-00-00', 0, '', '', 'QAUg6', 4, NULL, NULL, 'assets/images/qrcode/QAUg6.png', '2019-03-12 06:01:50', '2019-03-16', 0, NULL, 0),
(7, 'agr', '4444444', 'ajil.techware@gmail.com', '0000-00-00', 0, 'assets/uploads/profile_pic/1570520802benzz.jpg', '809b86e603e333d270390b2228dcc01c', 'AUCDE', 5, NULL, NULL, 'assets/images/qrcode/AUCDE.png', '2019-03-12 11:06:08', '2019-03-20', 0, NULL, 0),
(8, 'royraju', '4444444', 'roy.techware@gmail.com', '0000-00-00', 0, '', 'e10adc3949ba59abbe56e057f20f883e', '8hfwQt', 9, NULL, NULL, 'assets/images/qrcode/8hfwQt.png', '2019-03-13 07:14:27', '2019-03-19', 0, NULL, 1);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admin_users`
--
ALTER TABLE `admin_users`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `checker`
--
ALTER TABLE `checker`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `check_in_history`
--
ALTER TABLE `check_in_history`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `service_log`
--
ALTER TABLE `service_log`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `admin_users`
--
ALTER TABLE `admin_users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `checker`
--
ALTER TABLE `checker`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `check_in_history`
--
ALTER TABLE `check_in_history`
MODIFY `id` int(55) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `service_log`
--
ALTER TABLE `service_log`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=120;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
/*!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 */;