text: -- phpMyAdmin SQL Dump
  -- version 4.7.4
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Jun 04, 2018 at 06:25 AM
  -- Server version: 10.1.28-MariaDB
  -- PHP Version: 5.6.32
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `mrec_db`
  --
  CREATE DATABASE IF NOT EXISTS `mrec_db` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  USE `mrec_db`;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `pcdom_area`
  --
  
  CREATE TABLE `pcdom_area` (
    `area_id` int(11) NOT NULL,
    `district_id` int(11) NOT NULL,
    `area_name` varchar(100) NOT NULL,
    `created` varchar(100) NOT NULL,
    `modified` varchar(100) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `pcdom_area`
  --
  
  INSERT INTO `pcdom_area` (`area_id`, `district_id`, `area_name`, `created`, `modified`) VALUES
  (1, 1, 'Balingasag', '2018-04-10 09:37:32', ''),
  (2, 1, 'Mambajao', '2018-04-10 09:37:32', ''),
  (3, 2, 'Tagoloan B', '2018-04-10 09:37:57', ''),
  (4, 2, 'Jasaan', '2018-04-10 09:37:57', ''),
  (5, 3, 'Malaybalay 1st', '2018-04-10 09:42:09', ''),
  (6, 3, 'Malaybalay 3rd', '2018-04-10 09:42:09', ''),
  (7, 4, 'Valencia A', '2018-04-10 09:43:30', ''),
  (8, 4, 'Quezon', '2018-04-10 09:43:30', ''),
  (9, 4, 'Maramag', '2018-04-10 09:43:30', ''),
  (10, 5, 'Lapasan', '2018-04-10 09:44:21', ''),
  (11, 5, 'Cugman', '2018-04-10 09:44:21', ''),
  (12, 5, 'Puntod', '2018-04-10 09:44:21', ''),
  (13, 6, 'Bugo', '2018-04-10 09:44:43', ''),
  (14, 6, 'Trinitas', '2018-04-10 09:44:43', ''),
  (15, 6, 'Macabalan', '2018-04-10 09:44:43', ''),
  (16, 7, 'CDO 1st', '2018-04-10 09:46:28', ''),
  (17, 7, 'CDO 2nd', '2018-04-10 09:46:28', ''),
  (18, 7, 'Lumbia', '2018-04-10 09:46:28', ''),
  (19, 8, 'Carmen C', '2018-04-10 09:47:05', ''),
  (20, 8, 'Canitoan-A', '2018-04-10 09:47:05', ''),
  (21, 8, 'Kauswagan', '2018-04-10 09:47:05', ''),
  (22, 10, 'Patag A', '2018-04-10 09:47:50', ''),
  (23, 10, 'Patag B', '2018-04-10 09:47:50', ''),
  (24, 10, 'Iponan B', '2018-04-10 09:47:50', ''),
  (25, 10, 'Bulua', '2018-04-10 09:47:50', ''),
  (26, 9, 'Gitagum', '2018-04-10 09:48:17', ''),
  (27, 9, 'Initao', '2018-04-10 09:48:17', ''),
  (28, 9, 'Manticao', '2018-04-10 09:48:17', ''),
  (29, 11, 'Manabay A', '2018-04-10 09:50:16', ''),
  (30, 11, 'Tangub A', '2018-04-10 09:50:16', ''),
  (31, 11, 'Tangub B', '2018-04-10 09:50:16', ''),
  (32, 12, 'Clarin', '2018-04-10 09:50:38', ''),
  (33, 12, 'City', '2018-04-10 09:50:38', ''),
  (34, 12, 'Manabay B', '2018-04-10 09:50:38', ''),
  (35, 13, 'Sta. Lucia A', '2018-04-10 09:51:17', ''),
  (36, 13, 'Molave', '2018-04-10 09:51:17', ''),
  (37, 13, 'Balangasan B', '2018-04-10 09:51:17', ''),
  (38, 14, 'Balangasan A', '2018-04-10 09:52:01', ''),
  (39, 14, 'Kawit', '2018-04-10 09:52:01', ''),
  (40, 15, 'Villaflor A', '2018-04-10 09:52:39', ''),
  (41, 15, 'Villaflor B', '2018-04-10 09:52:39', ''),
  (42, 15, 'Mobod', '2018-04-10 09:52:39', ''),
  (43, 15, 'Oroquieta', '2018-04-10 09:52:39', ''),
  (44, 16, 'Talairon', '2018-04-10 09:53:15', ''),
  (45, 16, 'Jimenez', '2018-04-10 09:53:15', ''),
  (46, 16, 'Aloran', '2018-04-10 09:53:15', ''),
  (47, 16, 'Plaridel', '2018-04-10 09:53:15', ''),
  (48, 17, 'Galas', '2018-04-10 09:54:54', ''),
  (49, 17, 'Dipolog 2nd', '2018-04-10 09:54:54', ''),
  (50, 17, 'Katipunan', '2018-04-10 09:54:54', ''),
  (51, 17, 'Capitol', '2018-04-10 09:54:54', ''),
  (52, 18, 'Rizal', '2018-04-10 09:55:15', ''),
  (53, 18, 'Dipolog 1st', '2018-04-10 09:55:15', ''),
  (54, 19, 'Camague', '2018-04-10 09:55:49', ''),
  (55, 19, 'Kiwalan', '2018-04-10 09:55:49', ''),
  (56, 20, 'Iligan 3rd', '2018-04-10 09:56:18', ''),
  (57, 20, 'Iligan 2nd', '2018-04-10 09:56:18', ''),
  (58, 20, 'Iligan 1st', '2018-04-10 09:56:18', ''),
  (59, 7, 'Macanhan', '2018-05-02 05:16:35', ''),
  (60, 8, 'Carmen A', '2018-05-02 05:19:41', ''),
  (61, 8, 'Carmen B', '2018-05-02 05:19:41', ''),
  (62, 2, 'tagoloan A', '2018-05-02 05:24:28', ''),
  (63, 2, 'jasaan', '2018-05-09 06:40:59', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `pcdom_companionship`
  --
  
  CREATE TABLE `pcdom_companionship` (
    `companionship_id` int(11) NOT NULL,
    `missionary_one_id` varchar(10) NOT NULL,
    `missionary_two_id` varchar(10) NOT NULL,
    `missionary_three_id` varchar(10) NOT NULL,
    `zone_id` varchar(10) NOT NULL,
    `district_id` varchar(10) NOT NULL,
    `area_id` varchar(10) NOT NULL,
    `companionship_as_at_month` varchar(100) NOT NULL,
    `companionship_as_at_year` varchar(100) NOT NULL,
    `created` varchar(100) NOT NULL,
    `modified` varchar(100) NOT NULL,
    `assignment` varchar(100) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `pcdom_companionship`
  --
  
  INSERT INTO `pcdom_companionship` (`companionship_id`, `missionary_one_id`, `missionary_two_id`, `missionary_three_id`, `zone_id`, `district_id`, `area_id`, `companionship_as_at_month`, `companionship_as_at_year`, `created`, `modified`, `assignment`) VALUES
  (1, '9', '10', '', '1', '1', '1', 'April', '2018', '', '', 'zl'),
  (2, '11', '12', '', '1', '2', '3', 'April', '2018', '2018-04-10 10:39:01', '', 'stl'),
  (3, '13', '14', '', '2', '3', '5', 'April', '2018', '2018-04-10 10:41:30', '', 'zl'),
  (4, '15', '16', '', '2', '4', '7', 'April', '2018', '2018-04-10 11:08:07', '', 'stl'),
  (5, '17', '18', '', '3', '5', '10', 'April', '2018', '2018-04-10 11:09:13', '', 'zl'),
  (6, '19', '20', '', '3', '5', '11', 'April', '2018', '2018-04-10 11:09:49', '', 'stl'),
  (7, '21', '22', '114', '4', '7', '16', 'April', '2018', '2018-04-10 11:10:35', '', 'zl'),
  (8, '16', '24', '25', '4', '8', '19', 'April', '2018', '2018-04-10 11:11:26', '', 'stl'),
  (9, '27', '26', '', '5', '10', '24', 'April', '2018', '2018-04-10 11:12:04', '', 'zl'),
  (10, '28', '29', '', '5', '10', '25', 'April', '2018', '2018-04-10 11:12:44', '', 'stl'),
  (11, '30', '31', '', '6', '11', '29', 'April', '2018', '2018-04-10 11:13:15', '', 'zl'),
  (12, '32', '33', '', '6', '12', '32', 'April', '2018', '2018-04-10 11:13:56', '', 'stl'),
  (13, '34', '35', '', '7', '13', '35', 'April', '2018', '2018-04-10 11:14:36', '', 'zl'),
  (14, '36', '37', '', '7', '14', '38', 'April', '2018', '2018-04-10 11:15:31', '', 'stl'),
  (15, '38', '39', '', '8', '15', '40', 'April', '2018', '2018-04-10 11:17:21', '', 'stl'),
  (16, '40', '41', '', '8', '16', '44', 'April', '2018', '2018-04-10 11:18:20', '', 'stl'),
  (17, '42', '43', '', '9', '17', '48', 'April', '2018', '2018-04-10 11:19:27', '', 'zl'),
  (18, '44', '45', '', '9', '17', '49', 'April', '2018', '2018-04-10 11:20:11', '', 'stl'),
  (19, '46', '47', '48', '10', '19', '54', 'April', '2018', '2018-04-10 11:20:53', '', 'zl'),
  (20, '49', '50', '', '10', '20', '56', 'April', '2018', '2018-04-10 11:21:34', '', 'stl'),
  (21, '51', '52', '53', '1', '1', '2', 'April', '2018', '2018-04-10 11:25:37', '', 'regular'),
  (22, '133', '134', '', '1', '2', '4', 'April', '2018', '2018-04-10 11:26:57', '', 'regular'),
  (23, '54', '55', '', '2', '3', '6', 'April', '2018', '2018-04-10 11:27:30', '', 'regular'),
  (24, '58', '59', '', '2', '4', '8', 'April', '2018', '2018-04-10 11:27:54', '', 'regular'),
  (25, '60', '61', '', '2', '4', '9', 'April', '2018', '2018-04-10 11:28:38', '', 'regular'),
  (26, '62', '63', '', '3', '6', '13', 'April', '2018', '2018-04-12 05:04:49', '', 'regular'),
  (27, '64', '65', '', '3', '6', '14', 'April', '2018', '2018-04-12 05:05:11', '', 'regular'),
  (28, '66', '67', '', '3', '6', '15', 'April', '2018', '2018-04-12 05:05:32', '', 'regular'),
  (29, '68', '69', '', '3', '5', '12', 'April', '2018', '2018-04-12 05:05:55', '', 'regular'),
  (30, '70', '71', '', '4', '7', '17', 'April', '2018', '2018-04-12 05:06:33', '', 'regular'),
  (31, '72', '55', '74', '4', '7', '18', 'April', '2018', '2018-04-12 05:07:09', '', 'ap'),
  (32, '77', '78', '', '4', '8', '20', 'April', '2018', '2018-04-12 05:07:48', '', 'regular'),
  (33, '79', '80', '', '4', '8', '21', 'April', '2018', '2018-04-12 05:08:19', '', 'regular'),
  (34, '81', '57', '', '5', '9', '26', 'April', '2018', '2018-04-12 05:09:12', '', 'regular'),
  (35, '82', '83', '', '5', '9', '27', 'April', '2018', '2018-04-12 05:09:41', '', 'regular'),
  (36, '84', '85', '', '5', '9', '28', 'April', '2018', '2018-04-12 05:10:15', '', 'regular'),
  (37, '86', '87', '88', '5', '10', '22', 'April', '2018', '2018-04-12 05:10:47', '', 'mrec'),
  (38, '89', '90', '', '5', '10', '23', 'April', '2018', '2018-04-12 05:11:32', '', 'fsec'),
  (39, '91', '92', '', '6', '11', '30', 'April', '2018', '2018-04-12 05:12:09', '', 'regular'),
  (40, '93', '94', '', '6', '11', '31', 'April', '2018', '2018-04-12 05:13:48', '', 'regular'),
  (41, '95', '96', '', '6', '12', '33', 'April', '2018', '2018-04-12 05:14:19', '', 'regular'),
  (42, '97', '98', '', '6', '12', '34', 'April', '2018', '2018-04-12 05:14:44', '', 'regular'),
  (43, '99', '100', '', '7', '13', '36', 'April', '2018', '2018-04-12 05:15:12', '', 'regular'),
  (44, '101', '102', '', '7', '13', '37', 'April', '2018', '2018-04-12 05:15:39', '', 'regular'),
  (45, '103', '104', '', '7', '14', '39', 'April', '2018', '2018-04-12 05:16:06', '', 'regular'),
  (46, '107', '108', '', '8', '15', '42', 'April', '2018', '2018-04-12 05:17:06', '', 'regular'),
  (47, '109', '110', '', '8', '15', '41', 'April', '2018', '2018-04-12 05:17:27', '', 'regular'),
  (48, '111', '112', '', '8', '15', '43', 'April', '2018', '2018-04-12 05:17:50', '', 'regular'),
  (49, '113', '114', '', '8', '16', '45', 'April', '2018', '2018-04-12 05:18:14', '', 'regular'),
  (50, '115', '116', '', '8', '16', '46', 'April', '2018', '2018-04-12 05:18:38', '', 'regular'),
  (51, '117', '118', '', '8', '16', '47', 'April', '2018', '2018-04-12 05:19:02', '', 'regular'),
  (52, '119', '120', '', '9', '17', '50', 'April', '2018', '2018-04-12 05:19:43', '', 'regular'),
  (53, '121', '122', '', '9', '17', '51', 'April', '2018', '2018-04-12 05:20:04', '', 'regular'),
  (54, '123', '124', '', '9', '18', '52', 'April', '2018', '2018-04-12 05:20:26', '', 'regular'),
  (55, '125', '126', '', '9', '18', '53', 'April', '2018', '2018-04-12 05:21:08', '', 'regular'),
  (56, '127', '128', '', '10', '19', '55', 'April', '2018', '2018-04-12 05:21:35', '', 'regular'),
  (57, '129', '130', '', '10', '20', '57', 'April', '2018', '2018-04-12 05:22:01', '', 'regular'),
  (58, '131', '132', '', '10', '20', '58', 'April', '2018', '2018-04-12 05:22:20', '', 'regular'),
  (60, '42', '89', '', '9', '17', '48', 'May', '2018', '2018-05-02 04:06:33', '', 'zl'),
  (61, '119', '120', '', '9', '17', '50', 'May', '2018', '2018-05-02 04:13:29', '', 'dl'),
  (62, '44', '45', '122', '9', '17', '49', 'May', '2018', '2018-05-02 04:14:44', '', 'stl'),
  (63, '125', '126', '', '9', '18', '53', 'May', '2018', '2018-05-02 04:16:20', '', 'dl'),
  (64, '123', '124', '', '9', '18', '52', 'May', '2018', '2018-05-02 04:16:48', '', 'regular'),
  (65, '39', '94', '', '8', '15', '40', 'May', '2018', '2018-05-02 04:51:57', '', 'zl'),
  (66, '109', '110', '', '8', '15', '41', 'May', '2018', '2018-05-02 04:52:31', '', 'dl'),
  (67, '107', '139', '', '8', '15', '42', 'May', '2018', '2018-05-02 04:53:16', '', 'regular'),
  (68, '118', '144', '', '8', '16', '47', 'May', '2018', '2018-05-02 04:54:18', '', 'dl'),
  (69, '41', '135', '', '8', '16', '44', 'May', '2018', '2018-05-02 04:54:53', '', 'stl'),
  (70, '113', '78', '', '8', '16', '45', 'May', '2018', '2018-05-02 04:57:42', '', 'regular'),
  (71, '115', '116', '', '8', '16', '46', 'May', '2018', '2018-05-02 04:58:10', '', 'regular'),
  (72, '35', '90', '', '7', '13', '35', 'May', '2018', '2018-05-02 04:59:15', '', 'zl'),
  (73, '100', '138', '', '7', '13', '36', 'May', '2018', '2018-05-02 05:02:14', '', 'dl'),
  (74, '130', '140', '', '7', '14', '39', 'May', '2018', '2018-05-02 05:02:58', '', 'dl'),
  (75, '37', '102', '', '7', '14', '38', 'May', '2018', '2018-05-02 05:03:48', '', 'stl'),
  (76, '31', '81', '', '6', '11', '29', 'May', '2018', '2018-05-02 05:06:15', '', 'zl'),
  (77, '93', '66', '', '6', '11', '30', 'May', '2018', '2018-05-02 05:07:00', '', 'dl'),
  (78, '95', '96', '', '6', '12', '33', 'May', '2018', '2018-05-02 05:07:48', '', 'dl'),
  (79, '70', '33', '', '6', '12', '32', 'May', '2018', '2018-05-02 05:08:15', '', 'stl'),
  (80, '97', '98', '', '6', '12', '34', 'May', '2018', '2018-05-02 05:08:48', '', 'regular'),
  (81, '26', '17', '', '5', '10', '24', 'May', '2018', '2018-05-02 05:10:06', '', 'zl'),
  (82, '28', '29', '', '5', '10', '25', 'May', '2018', '2018-05-02 05:10:45', '', 'stl'),
  (83, '87', '86', '', '5', '10', '22', 'May', '2018', '2018-05-02 05:11:14', '', 'mrec'),
  (84, '76', '75', '', '5', '10', '23', 'May', '2018', '2018-05-02 05:11:48', '', 'regular'),
  (85, '51', '85', '', '5', '24', '28', 'May', '2018', '2018-05-02 05:13:28', '', 'dl'),
  (86, '83', '73', '', '5', '24', '27', 'May', '2018', '2018-05-02 05:14:14', '', 'regular'),
  (87, '57', '92', '', '5', '24', '26', 'May', '2018', '2018-05-02 05:14:39', '', 'regular'),
  (88, '22', '91', '', '4', '7', '16', 'May', '2018', '2018-05-02 05:15:36', '', 'zl'),
  (89, '56', '106', '108', '4', '7', '59', 'May', '2018', '2018-05-02 05:17:10', '', 'dl'),
  (90, '111', '71', '', '4', '7', '17', 'May', '2018', '2018-05-02 05:17:48', '', 'regular'),
  (91, '74', '27', '46', '4', '7', '18', 'May', '2018', '2018-05-02 05:18:45', '', 'ap'),
  (92, '117', '53', '', '4', '8', '20', 'May', '2018', '2018-05-02 05:19:16', '', 'dl'),
  (93, '25', '143', '', '4', '8', '60', 'May', '2018', '2018-05-02 05:20:07', '', 'regular'),
  (94, '24', '141', '', '4', '8', '61', 'May', '2018', '2018-05-02 05:20:43', '', 'regular'),
  (95, '9', '18', '', '11', '2', '1', 'May', '2018', '2018-05-02 05:23:32', '', 'zl'),
  (96, '103', '142', '', '11', '2', '4', 'May', '2018', '2018-05-02 05:24:09', '', 'dl'),
  (97, '12', '80', '', '11', '2', '62', 'May', '2018', '2018-05-02 05:25:01', '', 'regular'),
  (98, '20', '112', '', '11', '2', '3', 'May', '2018', '2018-05-02 05:25:23', '', 'regular'),
  (99, '62', '63', '', '11', '6', '13', 'May', '2018', '2018-05-02 05:25:52', '', 'dl'),
  (100, '64', '65', '', '11', '6', '14', 'May', '2018', '2018-05-02 05:26:35', '', 'regular'),
  (101, '52', '82', '', '11', '6', '2', 'May', '2018', '2018-05-02 05:27:09', '', 'regular'),
  (102, '68', '69', '', '11', '23', '12', 'May', '2018', '2018-05-02 05:27:35', '', 'dl'),
  (103, '19', '101', '', '11', '23', '11', 'May', '2018', '2018-05-02 05:28:04', '', 'stl'),
  (104, '67', '134', '', '11', '23', '10', 'May', '2018', '2018-05-02 05:28:26', '', 'regular'),
  (105, '13', '14', '', '2', '25', '5', 'May', '2018', '2018-05-02 05:29:43', '', 'zl'),
  (106, '54', '61', '', '2', '25', '6', 'May', '2018', '2018-05-02 05:30:12', '', 'regular'),
  (107, '121', '16', '', '2', '25', '7', 'May', '2018', '2018-05-02 05:30:42', '', 'stl'),
  (108, '58', '59', '', '2', '4', '8', 'May', '2018', '2018-05-02 05:31:12', '', 'dl'),
  (109, '60', '145', '', '2', '4', '9', 'May', '2018', '2018-05-02 05:32:10', '', 'regular'),
  (110, '21', '133', '', '10', '26', '54', 'May', '2018', '2018-05-02 05:33:42', '', 'zl'),
  (111, '127', '128', '', '10', '26', '55', 'May', '2018', '2018-05-02 05:34:15', '', 'dl'),
  (112, '129', '137', '', '10', '20', '57', 'May', '2018', '2018-05-02 05:34:44', '', 'dl'),
  (113, '79', '50', '', '10', '20', '56', 'May', '2018', '2018-05-02 05:35:11', '', 'stl'),
  (114, '131', '132', '', '10', '20', '58', 'May', '2018', '2018-05-02 05:35:41', '', 'regular');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `pcdom_district`
  --
  
  CREATE TABLE `pcdom_district` (
    `district_id` int(11) NOT NULL,
    `zone_id` int(11) NOT NULL,
    `district_name` varchar(100) NOT NULL,
    `created` varchar(100) NOT NULL,
    `modified` varchar(100) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `pcdom_district`
  --
  
  INSERT INTO `pcdom_district` (`district_id`, `zone_id`, `district_name`, `created`, `modified`) VALUES
  (1, 1, 'Mambajao', '2018-04-06 05:59:42', ''),
  (2, 1, 'Jasaan', '2018-04-06 05:59:42', ''),
  (3, 2, 'Malaybalay 3rd', '2018-04-06 06:00:14', ''),
  (4, 2, 'Quezon', '2018-04-06 06:00:14', ''),
  (5, 3, 'Manolo Fortich', '2018-04-06 06:00:31', ''),
  (6, 3, 'Bugo', '2018-04-06 06:00:31', ''),
  (7, 4, 'Macanhan', '2018-04-06 06:00:50', ''),
  (8, 4, 'Canito-an', '2018-04-06 06:00:50', ''),
  (9, 5, 'Initao', '2018-04-06 06:01:03', ''),
  (10, 5, 'Patag', '2018-04-06 06:01:03', ''),
  (11, 6, 'Tangub', '2018-04-06 06:01:17', ''),
  (12, 6, 'City', '2018-04-06 06:01:17', ''),
  (13, 7, 'Sta. Lucia', '2018-04-06 06:01:34', ''),
  (14, 7, 'Kawit', '2018-04-06 06:01:34', ''),
  (15, 8, 'Villaflor', '2018-04-06 06:01:53', ''),
  (16, 8, 'Jimenez', '2018-04-06 06:01:53', ''),
  (17, 9, 'Katipunan', '2018-04-06 06:02:15', ''),
  (18, 9, 'Dipolog 1st', '2018-04-06 06:02:15', ''),
  (19, 10, 'Camague', '2018-04-06 06:02:30', ''),
  (20, 10, 'Iligan', '2018-04-06 06:02:30', ''),
  (23, 11, 'Puntod', '2018-05-02 03:37:00', ''),
  (24, 5, 'Manticao', '2018-05-02 05:12:51', ''),
  (25, 2, 'Malaybalay', '2018-05-02 05:29:03', ''),
  (26, 10, 'Kiwalan', '2018-05-02 05:33:20', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `pcdom_missionaries`
  --
  
  CREATE TABLE `pcdom_missionaries` (
    `missionary_id` int(11) NOT NULL,
    `district_id` varchar(10) NOT NULL,
    `missionaries_name` varchar(100) NOT NULL,
    `gender` varchar(50) NOT NULL,
    `status` varchar(50) NOT NULL,
    `calling` varchar(50) NOT NULL,
    `created` varchar(50) NOT NULL,
    `modified` varchar(50) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `pcdom_missionaries`
  --
  
  INSERT INTO `pcdom_missionaries` (`missionary_id`, `district_id`, `missionaries_name`, `gender`, `status`, `calling`, `created`, `modified`) VALUES
  (9, '', 'Elder Viodor', 'male', '', '', '2018-04-02 07:13:15', ''),
  (10, '', 'Elder Brudo', 'male', 'released', '', '2018-04-02 07:13:15', '2018-05-02 02:52:35'),
  (11, '', 'Sister Barcenilla', 'female', 'released', '', '2018-04-02 07:13:15', '2018-05-02 02:52:14'),
  (12, '', 'Sister Salvador', 'female', '', '', '2018-04-02 07:13:15', ''),
  (13, '', 'Elder Marcelo', 'male', '', '', '2018-04-02 07:13:15', ''),
  (14, '', 'Elder Manosig', 'male', '', '', '2018-04-02 07:13:15', ''),
  (15, '', 'Sister Toledo', 'female', 'released', '', '2018-04-02 07:13:15', '2018-05-02 02:56:03'),
  (16, '', 'Sister Bulatao', 'female', '', '', '2018-04-02 07:13:15', ''),
  (17, '', 'Elder Montemayor', 'male', '', '', '2018-04-02 07:13:15', ''),
  (18, '', 'Elder Darilay', 'male', '', '', '2018-04-02 07:13:15', ''),
  (19, '', 'Sister Reobal', 'female', '', '', '2018-04-02 07:13:15', ''),
  (20, '', 'Sister Laus', 'female', '', '', '2018-04-02 07:13:15', ''),
  (21, '', 'Elder Francisco', 'male', '', '', '2018-04-02 07:13:15', ''),
  (22, '', 'Elder Arpellida', 'male', '', '', '2018-04-02 07:13:15', ''),
  (23, '', 'Sister Bulado', 'female', 'released', '', '2018-04-02 07:13:15', '2018-05-02 02:52:46'),
  (24, '', 'Sister Merelos', 'female', '', '', '2018-04-02 07:13:15', ''),
  (25, '', 'Sister Arzadon', 'female', '', '', '2018-04-02 07:13:15', '2018-04-02 08:14:12'),
  (26, '', 'Elder David', 'male', '', '', '2018-04-02 07:13:15', ''),
  (27, '', 'Elder Cortez', 'male', '', '', '2018-04-02 07:13:15', ''),
  (28, '', 'Sister Cabie', 'female', '', '', '2018-04-02 07:18:37', ''),
  (29, '', 'Sister De Guzman', 'female', '', '', '2018-04-02 07:18:37', ''),
  (30, '', 'Elder Labag', 'male', 'released', '', '2018-04-02 07:18:37', '2018-05-02 02:53:38'),
  (31, '', 'Elder Calumpiano', 'male', '', '', '2018-04-02 07:18:37', ''),
  (32, '', 'Sister Viola', 'female', 'released', '', '2018-04-02 07:18:37', '2018-05-02 02:56:12'),
  (33, '', 'Sister Simbol', 'female', '', '', '2018-04-02 07:18:37', ''),
  (34, '', 'Elder Laguna', 'male', 'released', '', '2018-04-02 07:18:37', '2018-05-02 02:53:58'),
  (35, '', 'Elder Olivete', 'male', '', '', '2018-04-02 07:18:37', ''),
  (36, '', 'Sister Defuntaron', 'female', 'released', '', '2018-04-02 07:18:37', '2018-05-02 02:53:13'),
  (37, '', 'Sister Pangilingan', 'female', '', '', '2018-04-02 07:18:37', ''),
  (38, '', 'Elder Madriaga', 'male', 'released', '', '2018-04-02 07:18:37', '2018-05-02 02:54:21'),
  (39, '', 'Elder Dorosan', 'male', '', '', '2018-04-02 07:18:37', ''),
  (40, '', 'Sister Peralta', 'female', 'released', '', '2018-04-02 07:18:37', '2018-05-02 02:54:43'),
  (41, '', 'Sister Corton', 'female', '', '', '2018-04-02 07:18:37', ''),
  (42, '', 'Elder Mercurio', 'male', '', '', '2018-04-02 07:18:37', ''),
  (43, '', 'Elder Tiva', 'female', 'released', '', '2018-04-02 07:18:37', '2018-05-02 02:55:55'),
  (44, '', 'Sister Medina', 'female', '', '', '2018-04-02 07:18:37', ''),
  (45, '', 'Sister Rada', 'female', '', '', '2018-04-02 07:18:37', ''),
  (46, '', 'Elder Villamor', 'male', '', '', '2018-04-02 07:18:37', ''),
  (47, '', 'Elder Dumbrigue', 'male', 'released', '', '2018-04-02 07:18:37', '2018-05-02 02:53:29'),
  (48, '', 'Elder Santos', 'male', 'released', '', '2018-04-02 07:18:37', '2018-05-02 02:55:32'),
  (49, '', 'Sister Magpali', 'female', 'released', '', '2018-04-02 07:18:37', '2018-05-02 02:54:32'),
  (50, '', 'Sister Nueva', 'female', '', '', '2018-04-02 07:18:37', ''),
  (51, '24', 'Elder Magadan', 'male', '', 'dl', '2018-04-02 08:25:45', '2018-05-15 11:55:21'),
  (52, '', 'Elder Sabayo', 'male', '', '', '2018-04-02 08:25:45', ''),
  (53, '', 'Elder Gonzales Cedrick', 'male', '', '', '2018-04-02 08:25:45', '2018-05-02 04:56:41'),
  (54, '25', 'Elder Baisac', 'male', '', 'dl', '2018-04-02 08:25:45', '2018-05-15 11:52:49'),
  (55, '', 'Elder Santiago', 'male', 'released', '', '2018-04-02 08:25:45', '2018-05-02 02:55:21'),
  (56, '7', 'Elder Conejos', 'male', '', 'dl', '2018-04-02 08:25:45', '2018-05-15 11:53:17'),
  (57, '', 'Elder Pajarillo', 'male', '', '', '2018-04-02 08:25:45', ''),
  (58, '', 'Elder Arcayos', 'male', '', 'dl', '2018-04-02 08:25:45', '2018-05-07 10:53:05'),
  (59, '', 'Elder Sucaldito', 'male', '', '', '2018-04-02 08:25:45', ''),
  (60, '4', 'Elder Gipa', 'male', '', '', '2018-04-02 08:25:45', '2018-05-15 11:53:01'),
  (61, '', 'Elder Ruizol', 'male', '', '', '2018-04-02 08:25:45', ''),
  (62, '6', 'Elder Salcedo', 'male', '', 'dl', '2018-04-02 08:25:45', '2018-05-15 11:52:28'),
  (63, '', 'Elder Paña', 'male', '', '', '2018-04-02 08:25:45', ''),
  (64, '', 'Elder Ampit', 'male', '', '', '2018-04-02 08:25:45', ''),
  (65, '', 'Elder Vallo', 'male', '', '', '2018-04-02 08:25:45', ''),
  (66, '', 'Elder Gutierrez Joel', 'male', '', '', '2018-04-02 08:25:45', '2018-05-02 04:50:48'),
  (67, '', 'Elder Dela Torre', 'male', '', '', '2018-04-02 08:25:45', ''),
  (68, '23', 'Elder Floralde', 'male', '', 'dl', '2018-04-02 08:25:45', '2018-05-15 11:52:15'),
  (69, '', 'Elder Manaban', 'male', '', '', '2018-04-02 08:25:45', ''),
  (70, '', 'Sister Castro', 'female', '', '', '2018-04-02 08:25:45', ''),
  (71, '', 'Sister Villaruz', 'female', '', '', '2018-04-02 08:25:45', ''),
  (72, '', 'Elder Aro', 'male', 'released', '', '2018-04-02 08:25:45', '2018-05-02 02:52:03'),
  (73, '', 'Elder Santiago', 'male', '', '', '2018-04-02 08:25:45', ''),
  (74, '', 'Elder Alpay', 'male', '', '', '2018-04-02 08:25:45', ''),
  (75, '', 'Elder Baltazar', 'male', '', '', '2018-04-02 08:25:45', ''),
  (76, '', 'Elder Villapaz', 'male', '', '', '2018-04-02 08:25:45', ''),
  (77, '', 'Elder Basmayor', 'male', 'released', '', '2018-04-02 08:25:45', '2018-05-02 02:52:24'),
  (78, '', 'Elder Gonzales Joshua', 'male', '', '', '2018-04-02 08:25:45', '2018-05-02 04:56:53'),
  (79, '', 'Sister Parañal', 'female', '', '', '2018-04-02 08:25:45', ''),
  (80, '', 'Sister Caballero', 'female', '', '', '2018-04-02 08:25:45', ''),
  (81, '', 'Elder Cubos', 'male', '', '', '2018-04-02 08:25:45', ''),
  (82, '', 'Elder Duerme', 'male', '', '', '2018-04-02 08:25:45', ''),
  (83, '', 'Elder Ejara', 'male', '', '', '2018-04-02 08:25:45', ''),
  (84, '', 'Elder Co', 'male', 'released', '', '2018-04-02 08:25:45', '2018-05-02 02:52:59'),
  (85, '', 'Elder Torres', 'male', '', '', '2018-04-02 08:25:45', ''),
  (86, '', 'Elder Mahayahay', 'male', '', '', '2018-04-02 08:25:45', ''),
  (87, '10', 'Elder Besario', 'male', '', 'dl', '2018-04-02 08:25:45', '2018-05-15 11:18:23'),
  (88, '', 'Elder Cabanilla', 'male', '', '', '2018-04-02 08:25:45', ''),
  (89, '', 'Elder Bituaran', 'male', '', '', '2018-04-02 08:25:45', ''),
  (90, '', 'Elder Jardin', 'male', '', '', '2018-04-02 08:25:45', ''),
  (91, '', 'Elder Monares', 'male', '', '', '2018-04-02 08:25:45', ''),
  (92, '', 'Elder Castillo', 'male', '', '', '2018-04-02 08:25:45', ''),
  (93, '11', 'Elder Abonete', 'male', '', 'dl', '2018-04-02 08:25:45', '2018-05-15 11:55:42'),
  (94, '', 'Elder Gutierrez Jomar', 'male', '', '', '2018-04-02 08:25:45', '2018-05-02 04:51:03'),
  (95, '12', 'Elder Ortiz', 'male', '', 'dl', '2018-04-02 08:25:45', '2018-05-15 11:56:03'),
  (96, '', 'Elder Tomas', 'male', '', '', '2018-04-02 08:25:45', ''),
  (97, '', 'Elder Solis', 'male', '', '', '2018-04-02 08:25:45', ''),
  (98, '', 'Elder Gilamon', 'male', '', '', '2018-04-02 08:25:45', ''),
  (99, '', 'Elder Loperas', 'male', 'released', '', '2018-04-02 08:25:45', '2018-05-02 02:54:12'),
  (100, '13', 'Elder Casipong', 'male', '', 'dl', '2018-04-02 08:25:45', '2018-05-15 11:56:18'),
  (101, '', 'Sister Nuguit', 'female', '', '', '2018-04-02 08:26:47', ''),
  (102, '', 'Sister Rotor', 'female', '', '', '2018-04-02 08:26:47', ''),
  (103, '2', 'Elder Ayop', 'male', '', 'dl', '2018-04-02 08:26:47', '2018-05-15 11:51:40'),
  (104, '', 'Elder Taduran', 'male', 'released', '', '2018-04-02 08:26:47', '2018-05-02 02:55:45'),
  (105, '', 'Elder Ebuen', 'male', '', '', '2018-04-02 08:26:47', ''),
  (106, '', 'Elder Bagnos', 'male', '', '', '2018-04-02 08:26:47', ''),
  (107, '', 'Elder Ardinez', 'male', '', '', '2018-04-02 08:26:47', ''),
  (108, '', 'Elder Ablen', 'male', 'IN FIELD', '', '2018-04-02 08:26:47', '2018-05-02 02:49:02'),
  (109, '15', 'Elder Cruz', 'male', '', 'dl', '2018-04-02 08:26:47', '2018-05-15 11:56:51'),
  (110, '', 'Elder Peña', 'male', '', '', '2018-04-02 08:26:47', ''),
  (111, '', 'Sister Racoma', 'female', '', '', '2018-04-02 08:29:16', ''),
  (112, '', 'Sister Quitan', 'female', '', '', '2018-04-02 08:29:16', ''),
  (113, '', 'Elder Espina', 'male', '', '', '2018-04-02 08:29:16', ''),
  (114, '', 'Elder Singh', 'male', '', '', '2018-04-02 08:29:16', ''),
  (115, '', 'Elder Noquera', 'male', '', '', '2018-04-02 08:29:16', ''),
  (116, '', 'Elder Orillan', 'male', '', '', '2018-04-02 08:29:16', ''),
  (117, '8', 'Elder Mendez', 'male', '', 'dl', '2018-04-02 08:29:16', '2018-05-15 11:53:38'),
  (118, '16', 'Elder Niedo', 'male', '', 'dl', '2018-04-02 08:29:16', '2018-05-15 11:57:15'),
  (119, '17', 'Elder Lababit', 'male', '', 'dl', '2018-04-02 08:29:16', '2018-05-15 11:57:30'),
  (120, '', 'Elder Vargas', 'male', '', '', '2018-04-02 08:29:16', ''),
  (121, '', 'Sister Dacuno', 'female', '', '', '2018-04-02 08:29:16', ''),
  (122, '', 'Sister Tejada', 'female', '', '', '2018-04-02 08:29:16', ''),
  (123, '', 'Elder Villanueva', 'male', '', '', '2018-04-02 08:29:16', ''),
  (124, '', 'Elder Abraham', 'male', '', '', '2018-04-02 08:29:16', ''),
  (125, '18', 'Elder Macaro', 'male', '', 'dl', '2018-04-02 08:29:16', '2018-05-15 11:57:43'),
  (126, '', 'Elder Binhaon', 'male', '', '', '2018-04-02 08:29:16', ''),
  (127, '26', 'Elder Selobrico', 'male', '', 'dl', '2018-04-02 08:29:16', '2018-05-15 11:57:55'),
  (128, '', 'Elder Laresma', 'male', '', '', '2018-04-02 08:29:16', ''),
  (129, '20', 'Elder Sandaya', 'male', '', 'dl', '2018-04-02 08:29:16', '2018-05-15 11:58:08'),
  (130, '14', 'Elder Basa', 'male', '', 'dl', '2018-04-02 08:29:16', '2018-05-15 11:56:32'),
  (131, '', 'Elder Layug', 'male', '', '', '2018-04-02 08:29:16', ''),
  (132, '', 'Elder Nasayaw', 'male', '', '', '2018-04-02 08:29:16', ''),
  (133, '', 'Elder Yucaran', 'male', '', '', '2018-04-02 08:50:30', ''),
  (134, '', 'elder jarden', 'male', '', '', '2018-04-10 11:26:08', ''),
  (135, '', 'Sister Alingcastre', 'female', '', '', '2018-05-02 03:04:09', ''),
  (136, '', 'Elder Arcuno', 'male', '', '', '2018-05-02 03:04:09', ''),
  (137, '', 'Elder Aure', 'male', '', '', '2018-05-02 03:04:09', ''),
  (138, '', 'Elder Begino', 'male', '', '', '2018-05-02 03:04:09', ''),
  (139, '', 'Elder Garcia', 'male', '', '', '2018-05-02 03:04:09', ''),
  (140, '', 'Elder Lillo', 'male', '', '', '2018-05-02 03:04:09', ''),
  (141, '', 'Sister Manaay', 'female', '', '', '2018-05-02 03:04:09', ''),
  (142, '', 'Elder Maquimot', 'male', '', '', '2018-05-02 03:04:09', ''),
  (143, '', 'Sister Sanoy', 'female', '', '', '2018-05-02 03:04:09', ''),
  (144, '', 'Elder Veterbo', 'male', '', '', '2018-05-02 03:04:09', ''),
  (145, '', 'Elder Arnuco', 'male', '', '', '2018-05-02 05:31:44', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `pcdom_statistics`
  --
  
  CREATE TABLE `pcdom_statistics` (
    `stats_id` int(11) NOT NULL,
    `companionship_id` int(11) NOT NULL,
    `zone_id` int(11) NOT NULL,
    `district_id` int(11) NOT NULL,
    `area_id` int(11) NOT NULL,
    `baptism` varchar(100) NOT NULL,
    `confirm` varchar(100) NOT NULL,
    `ibd` varchar(100) NOT NULL,
    `iasm` varchar(100) NOT NULL,
    `ni` varchar(100) NOT NULL,
    `ph` varchar(100) NOT NULL,
    `wh` varchar(100) NOT NULL,
    `tsa` varchar(100) NOT NULL,
    `week_number` varchar(100) NOT NULL,
    `month` varchar(100) NOT NULL,
    `year` varchar(100) NOT NULL,
    `week_date` varchar(100) NOT NULL,
    `created` varchar(100) NOT NULL,
    `modified` varchar(100) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `pcdom_statistics`
  --
  
  INSERT INTO `pcdom_statistics` (`stats_id`, `companionship_id`, `zone_id`, `district_id`, `area_id`, `baptism`, `confirm`, `ibd`, `iasm`, `ni`, `ph`, `wh`, `tsa`, `week_number`, `month`, `year`, `week_date`, `created`, `modified`) VALUES
  (1, 1, 1, 1, 1, '0', '0', '15', '3', '6', '54', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', '2018-04-24 07:52:43'),
  (2, 2, 1, 2, 3, '0', '0', '10', '3', '10', '46', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (3, 21, 1, 1, 2, '0', '0', '6', '2', '5', '53', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (4, 22, 1, 2, 4, '0', '0', '2', '2', '2', '49', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (5, 7, 4, 7, 16, '0', '0', '2', '0', '3', '48', '3', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (6, 8, 4, 8, 19, '0', '0', '6', '1', '4', '40', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (7, 30, 4, 7, 17, '0', '0', '15', '5', '5', '51', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (8, 31, 4, 7, 18, '0', '0', '7', '1', '11', '46', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (9, 32, 4, 8, 20, '0', '0', '9', '1', '1', '36', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (10, 33, 4, 8, 21, '0', '0', '15', '5', '5', '51', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (11, 5, 3, 5, 10, '0', '0', '4', '5', '2', '51', '8', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (12, 6, 3, 5, 11, '0', '0', '3', '4', '11', '45', '10', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (13, 26, 3, 6, 13, '0', '0', '5', '1', '5', '49', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (14, 27, 3, 6, 14, '0', '0', '2', '3', '5', '55', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (15, 28, 3, 6, 15, '0', '0', '12', '3', '3', '48', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (16, 29, 3, 5, 12, '0', '0', '2', '0', '8', '57', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (17, 9, 5, 10, 24, '0', '0', '14', '2', '5', '50', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (18, 10, 5, 10, 25, '0', '0', '16', '0', '15', '47', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (19, 34, 5, 9, 26, '3', '3', '10', '3', '1', '53', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (20, 35, 5, 9, 27, '0', '0', '2', '1', '5', '53', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (21, 36, 5, 9, 28, '1', '1', '3', '0', '13', '61', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (22, 37, 5, 10, 22, '0', '0', '6', '1', '16', '29', '36', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (23, 38, 5, 10, 23, '0', '0', '0', '0', '4', '30', '32', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (24, 17, 9, 17, 48, '0', '0', '6', '3', '2', '49', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (25, 18, 9, 17, 49, '0', '0', '5', '1', '5', '41', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (26, 52, 9, 17, 50, '0', '0', '10', '2', '3', '52', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (27, 53, 9, 17, 51, '0', '0', '10', '6', '5', '49', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (28, 54, 9, 18, 52, '0', '0', '10', '1', '5', '54', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (29, 55, 9, 18, 53, '0', '0', '4', '4', '3', '47', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (30, 19, 10, 19, 54, '0', '0', '19', '2', '6', '39', '9', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (31, 20, 10, 20, 56, '0', '0', '7', '3', '3', '40', '5', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (32, 56, 10, 19, 55, '0', '0', '8', '1', '6', '41', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (33, 57, 10, 20, 57, '0', '0', '7', '1', '6', '48', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (34, 58, 10, 20, 58, '0', '0', '19', '8', '8', '48', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (35, 3, 2, 3, 5, '0', '0', '12', '0', '10', '55', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (36, 4, 2, 4, 7, '0', '0', '3', '3', '8', '45', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (37, 23, 2, 3, 6, '0', '0', '3', '0', '2', '52', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (38, 24, 2, 4, 8, '0', '0', '4', '2', '3', '56', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (39, 25, 2, 4, 9, '0', '0', '9', '8', '11', '51.5', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (40, 15, 8, 15, 40, '0', '0', '10', '2', '8', '51', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (41, 16, 8, 16, 44, '0', '0', '9', '3', '5', '39', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (42, 46, 8, 15, 42, '0', '0', '4', '2', '2', '30', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (43, 47, 8, 15, 41, '0', '0', '8', '0', '4', '29', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (44, 48, 8, 15, 43, '0', '0', '4', '5', '10', '52.5', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (45, 49, 8, 16, 45, '1', '1', '6', '2', '12', '58', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (46, 50, 8, 16, 46, '0', '0', '10', '1', '5', '54', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (47, 51, 8, 16, 47, '0', '0', '10', '4', '22', '51', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (48, 11, 6, 11, 29, '0', '0', '6', '1', '5', '49', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (49, 12, 6, 12, 32, '0', '0', '1', '0', '3', '40', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (50, 39, 6, 11, 30, '0', '0', '2', '0', '8', '50', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (51, 40, 6, 11, 31, '0', '0', '9', '6', '10', '54', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (52, 41, 6, 12, 33, '0', '0', '6', '1', '1', '48', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (53, 42, 6, 12, 34, '0', '0', '7', '0', '6', '53', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (54, 13, 7, 13, 35, '0', '0', '10', '2', '6', '46', '5', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (55, 14, 7, 14, 38, '0', '0', '14', '0', '4', '42', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (56, 43, 7, 13, 36, '0', '0', '8', '2', '4', '49', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (57, 44, 7, 13, 37, '0', '0', '11', '1', '4', '3', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (58, 45, 7, 14, 39, '0', '0', '6', '1', '5', '48.5', '0', '', '1', 'April', '2018', '2018-April-2 To 2018-April-8', '2018-04-13 02:40:18', ''),
  (59, 1, 1, 1, 1, '0', '0', '12', '8', '6', '55', '0', '124', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (60, 2, 1, 2, 3, '0', '0', '3', '6', '9', '54', '0', '116', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (61, 21, 1, 1, 2, '0', '0', '5', '6', '2', '52', '0', '93', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (62, 22, 1, 2, 4, '0', '0', '2', '0', '2', '51', '0', '85', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (63, 7, 4, 7, 16, '0', '0', '2', '2', '1', '52', '3', '', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (64, 8, 4, 8, 19, '0', '0', '6', '7', '4', '40', '0', '', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (65, 30, 4, 7, 17, '0', '0', '16', '13', '7', '65', '0', '139', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (66, 31, 4, 7, 18, '0', '0', '3', '4', '6', '41', '0', '76', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (67, 32, 4, 8, 20, '0', '0', '9', '1', '5', '52', '0', '0', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (68, 33, 4, 8, 21, '0', '0', '0', '0', '0', '0', '0', '0', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (69, 5, 3, 5, 10, '0', '0', '6', '5', '5', '51', '5', '', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (70, 6, 3, 5, 11, '0', '0', '7', '4', '7', '54.5', '5', '', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (71, 26, 3, 6, 13, '0', '0', '5', '1', '5', '51', '0', '', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (72, 27, 3, 6, 14, '0', '0', '2', '0', '5', '56', '0', '', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (73, 28, 3, 6, 15, '0', '0', '12', '3', '3', '55', '0', '', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (74, 29, 3, 5, 12, '0', '0', '5', '1', '6', '56.5', '0', '', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (75, 9, 5, 10, 24, '0', '0', '20', '7', '10', '54', '0', '170', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (76, 10, 5, 10, 25, '0', '0', '12', '1', '6', '46.5', '0', '82', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (77, 34, 5, 9, 26, '0', '0', '10', '4', '11', '56.5', '0', '71', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (78, 35, 5, 9, 27, '1', '0', '0', '1', '4', '6', '0', '71', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (79, 36, 5, 9, 28, '0', '0', '6', '1', '12', '61', '0', '89', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (80, 37, 5, 10, 22, '0', '0', '7', '2', '13', '34.5', '35', '', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (81, 38, 5, 10, 23, '0', '0', '0', '4', '8', '31', '39', '', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (82, 17, 9, 17, 48, '1', '1', '6', '9', '2', '54', '0', '76', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (83, 18, 9, 17, 49, '0', '0', '5', '2', '3', '50', '0', '81', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (84, 52, 9, 17, 50, '1', '1', '11', '1', '4', '53', '0', '103', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (85, 53, 9, 17, 51, '0', '0', '10', '8', '7', '50', '0', '103', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (86, 54, 9, 18, 52, '0', '0', '12', '1', '13', '49', '0', '98', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (87, 55, 9, 18, 53, '0', '0', '6', '1', '2', '46', '0', '80', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (88, 19, 10, 19, 54, '1', '1', '12', '5', '6', '54', '0', '186', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (89, 20, 10, 20, 56, '1', '1', '10', '2', '6', '53', '0', '180', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (90, 56, 10, 19, 55, '0', '0', '8', '3', '7', '53', '0', '90', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (91, 57, 10, 20, 57, '1', '1', '7', '4', '8', '53', '0', '128', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (92, 58, 10, 20, 58, '2', '2', '14', '8', '6', '56', '0', '128', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (93, 3, 2, 3, 5, '0', '0', '12', '3', '6', '43', '12', '110', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (94, 4, 2, 4, 7, '0', '0', '3', '0', '10', '59', '2', '137', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (95, 23, 2, 3, 6, '0', '0', '7', '0', '5', '58', '0', '158', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (96, 24, 2, 4, 8, '0', '0', '4', '3', '3', '54', '0', '96', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (97, 25, 2, 4, 9, '0', '0', '9', '10', '13', '54', '0', '116', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (98, 15, 8, 15, 40, '0', '0', '8', '3', '5', '40', '0', '149', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (99, 16, 8, 16, 44, '1', '1', '7', '3', '15', '31', '0', '101', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (100, 46, 8, 15, 42, '2', '2', '2', '1', '4', '29', '0', '95', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (101, 47, 8, 15, 41, '0', '0', '8', '0', '2', '30', '0', '149', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (102, 48, 8, 15, 43, '0', '0', '5', '5', '3', '26', '0', '142', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (103, 49, 8, 16, 45, '0', '0', '7', '4', '6', '50', '0', '102', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (104, 50, 8, 16, 46, '0', '0', '10', '2', '3', '48', '0', '150', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (105, 51, 8, 16, 47, '0', '0', '10', '5', '13', '49', '0', '98', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (106, 11, 6, 11, 29, '0', '0', '6', '2', '3', '56', '0', '148', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (107, 12, 6, 12, 32, '0', '0', '6', '2', '25', '55', '0', '76', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (108, 39, 6, 11, 30, '0', '0', '3', '0', '4', '56', '0', '152', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (109, 40, 6, 11, 31, '2', '0', '9', '1', '1', '56', '0', '152', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (110, 41, 6, 12, 33, '1', '1', '4', '0', '12', '55', '0', '101', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (111, 42, 6, 12, 34, '0', '0', '8', '5', '8', '56', '0', '148', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (112, 13, 7, 13, 35, '0', '0', '10', '2', '3', '52', '0', '148', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (113, 14, 7, 14, 38, '0', '0', '14', '2', '3', '49', '0', '183', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (114, 43, 7, 13, 36, '2', '2', '2', '1', '4', '29', '0', '95', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (115, 44, 7, 13, 37, '0', '0', '11', '1', '12', '50.5', '0', '183', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (116, 45, 7, 14, 39, '0', '0', '7', '3', '6', '53', '0', '86', '2', 'April', '2018', '2018-Apr-09 To 2018-Apr-15', '2018-04-16 04:01:45', ''),
  (117, 1, 1, 1, 1, '1', '1', '15', '4', '10', '52', '0', '120', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (118, 2, 1, 2, 3, '6', '1', '4', '6', '7', '50', '0', '120', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (119, 21, 1, 1, 2, '0', '0', '5', '4', '2', '52', '0', '97', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (120, 22, 1, 2, 4, '0', '0', '6', '2', '4', '54', '0', '81', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (121, 7, 4, 7, 16, '0', '0', '2', '1', '1', '46', '0', '91', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (122, 8, 4, 8, 19, '1', '1', '6', '2', '10', '52', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (123, 30, 4, 7, 17, '3', '3', '10', '0', '1', '53', '0', '64', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (124, 31, 4, 7, 18, '0', '0', '3', '1', '0', '0', '62', '78', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (125, 32, 4, 8, 20, '0', '0', '4', '0', '1', '48', '0', '111', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (126, 33, 4, 8, 21, '0', '0', '0', '0', '0', '0', '0', '0', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (127, 5, 3, 5, 10, '2', '2', '5', '2', '2', '50', '9', '116', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (128, 6, 3, 5, 11, '0', '0', '4', '7', '10', '56', '3', '137', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (129, 26, 3, 6, 13, '0', '0', '5', '2', '6', '52', '0', '64', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (130, 27, 3, 6, 14, '0', '0', '2', '1', '5', '56', '0', '64', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (131, 28, 3, 6, 15, '3', '3', '10', '0', '1', '53', '0', '78', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (132, 29, 3, 5, 12, '1', '0', '10', '4', '14', '58', '0', '113', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (133, 9, 5, 10, 24, '1', '1', '16', '9', '4', '58.5', '3', '145', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (134, 10, 5, 10, 25, '0', '0', '14', '1', '11', '50', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (135, 34, 5, 9, 26, '1', '1', '14', '0', '8', '53', '0', '68', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (136, 35, 5, 9, 27, '0', '0', '1', '4', '5', '51.5', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (137, 36, 5, 9, 28, '0', '0', '2', '0', '8', '57', '0', '109', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (138, 37, 5, 10, 22, '1', '1', '6', '5', '6', '31.5', '35', '109', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (139, 38, 5, 10, 23, '0', '0', '3', '5', '3', '33', '34', '109', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (140, 17, 9, 17, 48, '1', '1', '4', '1', '2', '51', '0', '96', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (141, 18, 9, 17, 49, '0', '0', '5', '3', '8', '53', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (142, 52, 9, 17, 50, '1', '1', '9', '1', '0', '48', '0', '88', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (143, 53, 9, 17, 51, '1', '0', '7', '4', '6', '56', '0', '100', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (144, 54, 9, 18, 52, '0', '0', '12', '10', '13', '62', '0', '62', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (145, 55, 9, 18, 53, '0', '0', '8', '1', '3', '53', '0', '87', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (146, 19, 10, 19, 54, '2', '2', '12', '5', '8', '53', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (147, 20, 10, 20, 56, '0', '0', '10', '1', '4', '41', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (148, 56, 10, 19, 55, '1', '0', '4', '2', '1', '49', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (149, 57, 10, 20, 57, '0', '0', '8', '16', '3', '50', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (150, 58, 10, 20, 58, '0', '0', '13', '7', '6', '45', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (151, 3, 2, 3, 5, '0', '0', '12', '2', '5', '40', '15', '120', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (152, 4, 2, 4, 7, '0', '0', '1', '0', '2', '48', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (153, 23, 2, 3, 6, '0', '0', '8', '3', '6', '47', '0', '115', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (154, 24, 2, 4, 8, '0', '0', '5', '3', '0', '54', '0', '117', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (155, 25, 2, 4, 9, '8', '8', '4', '9', '5', '59', '0', '101', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (156, 15, 8, 15, 40, '0', '0', '7', '1', '4', '42', '5', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (157, 16, 8, 16, 44, '0', '0', '6', '4', '10', '28', '0', '121', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (158, 46, 8, 15, 42, '0', '0', '2', '0', '4', '30', '0', '152', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (159, 47, 8, 15, 41, '0', '0', '8', '0', '2', '28', '0', '152', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (160, 48, 8, 15, 43, '0', '0', '5', '6', '7', '43', '0', '117', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (161, 49, 8, 16, 45, '0', '0', '8', '3', '5', '53', '0', '102', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (162, 50, 8, 16, 46, '0', '0', '10', '2', '3', '54', '0', '95', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (163, 51, 8, 16, 47, '0', '0', '9', '6', '8', '48', '0', '108', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (164, 11, 6, 11, 29, '1', '1', '4', '1', '5', '51', '0', '138', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (165, 12, 6, 12, 32, '1', '1', '1', '2', '9', '43', '0', '97', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (166, 39, 6, 11, 30, '0', '0', '4', '2', '8', '56', '0', '130', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (167, 40, 6, 11, 31, '0', '2', '5', '1', '2', '55', '0', '130', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (168, 41, 6, 12, 33, '0', '0', '4', '1', '3', '59', '0', '119', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (169, 42, 6, 12, 34, '0', '0', '8', '1', '1', '57', '0', '138', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (170, 13, 7, 13, 35, '0', '0', '7', '4', '5', '51', '0', '', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (171, 14, 7, 14, 38, '1', '1', '14', '2', '1', '45.5', '0', '145', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (172, 43, 7, 13, 36, '0', '0', '4', '0', '4', '50', '0', '64', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (173, 44, 7, 13, 37, '0', '0', '13', '3', '2', '49.5', '0', '145', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (174, 45, 7, 14, 39, '1', '1', '6', '5', '7', '48', '0', '89', '3', 'April', '2018', '2018-Apr-16 To 2018-Apr-22', '2018-04-24 03:48:58', ''),
  (175, 1, 1, 1, 1, '2', '2', '8', '4', '0', '28', '24', '158', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (176, 2, 1, 2, 3, '0', '5', '12', '1', '2', '38', '0', '119', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', '2018-04-30 12:47:25'),
  (177, 21, 1, 1, 2, '0', '0', '5', '4', '3', '53', '0', '89', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (178, 22, 1, 2, 4, '2', '2', '4', '0', '2', '17', '0', '89', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (179, 7, 4, 7, 16, '0', '0', '1', '2', '1', '50', '5', '111', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (180, 8, 4, 8, 19, '0', '0', '6', '2', '5', '44', '0', '148', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (181, 30, 4, 7, 17, '0', '0', '15', '8', '8', '50.5', '0', '147', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (182, 31, 4, 7, 18, '0', '0', '4', '0', '0', '5', '60', '', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (183, 32, 4, 8, 20, '0', '0', '5', '1', '2', '48', '0', '114', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (184, 33, 4, 8, 21, '0', '0', '0', '0', '0', '0', '0', '0', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (185, 5, 3, 5, 10, '0', '0', '4', '2', '1', '42', '0', '125', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (186, 6, 3, 5, 11, '0', '0', '2', '5', '4', '40', '5', '127', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (187, 26, 3, 6, 13, '2', '2', '10', '4', '10', '50', '0', '147', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (188, 27, 3, 6, 14, '0', '0', '2', '2', '4', '55', '0', '66', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (189, 28, 3, 6, 15, '0', '0', '0', '0', '0', '0', '0', '', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (190, 29, 3, 5, 12, '0', '1', '16', '4', '8', '56', '0', '112', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (191, 9, 5, 10, 24, '0', '0', '18', '5', '2', '45.5', '15', '146', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (192, 10, 5, 10, 25, '0', '0', '12', '4', '5', '51.5', '0', '', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (193, 34, 5, 9, 26, '0', '0', '5', '3', '9', '50', '0', '65', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (194, 35, 5, 9, 27, '0', '0', '5', '1', '5', '49', '0', '115', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (195, 36, 5, 9, 28, '0', '0', '14', '1', '5', '43', '0', '100', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (196, 37, 5, 10, 22, '0', '0', '3', '5', '8', '29', '40', '130', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (197, 38, 5, 10, 23, '0', '0', '8', '5', '4', '9', '60', '130', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (198, 17, 9, 17, 48, '0', '0', '5', '2', '2', '53', '0', '100', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (199, 18, 9, 17, 49, '0', '1', '6', '12', '2', '59', '0', '97', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (200, 52, 9, 17, 50, '1', '1', '9', '1', '1', '51', '0', '102', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (201, 53, 9, 17, 51, '0', '0', '0', '0', '0', '0', '0', '', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (202, 54, 9, 18, 52, '0', '0', '12', '2', '5', '60', '0', '63', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (203, 55, 9, 18, 53, '0', '0', '9', '4', '4', '52', '0', '74', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (204, 19, 10, 19, 54, '0', '0', '5', '4', '5', '51', '0', '186', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (205, 20, 10, 20, 56, '0', '0', '7', '2', '4', '43.5', '0', '163', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (206, 56, 10, 19, 55, '0', '1', '5', '1', '3', '54', '0', '71', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (207, 57, 10, 20, 57, '1', '1', '8', '1', '2', '35', '0', '99', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (208, 58, 10, 20, 58, '2', '2', '9', '4', '5', '49', '0', '', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (209, 3, 2, 3, 5, '4', '4', '8', '5', '7', '58', '17', '130', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (210, 4, 2, 4, 7, '0', '0', '1', '1', '1', '36', '0', '150', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (211, 23, 2, 3, 6, '0', '0', '8', '3', '6', '55', '0', '107', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (212, 24, 2, 4, 8, '3', '3', '0', '1', '0', '50', '0', '100', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (213, 25, 2, 4, 9, '0', '0', '4', '7', '8', '26', '0', '97', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (214, 15, 8, 15, 40, '1', '1', '9', '1', '3', '50', '0', '133', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (215, 16, 8, 16, 44, '3', '3', '5', '3', '5', '25', '0', '120', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (216, 46, 8, 15, 42, '0', '0', '4', '0', '7', '51', '0', '116', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (217, 47, 8, 15, 41, '0', '0', '8', '1', '2', '51', '0', '133', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (218, 48, 8, 15, 43, '0', '0', '0', '0', '0', '0', '0', '', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (219, 49, 8, 16, 45, '1', '1', '6', '4', '7', '50', '0', '108', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (220, 50, 8, 16, 46, '1', '1', '10', '1', '4', '52', '0', '97', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (221, 51, 8, 16, 47, '0', '0', '4', '1', '5', '48', '0', '', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (222, 11, 6, 11, 29, '1', '1', '3', '0', '5', '50', '0', '136', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (223, 12, 6, 12, 32, '1', '1', '0', '0', '2', '42.5', '0', '107', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (224, 39, 6, 11, 30, '0', '0', '0', '0', '0', '0', '0', '0', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (225, 40, 6, 11, 31, '0', '0', '2', '3', '6', '57', '0', '164', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (226, 41, 6, 12, 33, '0', '0', '1', '2', '3', '48', '0', '125', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (227, 42, 6, 12, 34, '0', '0', '7', '1', '5', '53', '0', '136', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (228, 13, 7, 13, 35, '0', '0', '3', '5', '11', '38', '0', '133', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (229, 14, 7, 14, 38, '0', '0', '10', '3', '4', '51.5', '0', '149', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (230, 43, 7, 13, 36, '0', '0', '6', '0', '3', '18.5', '0', '80', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (231, 44, 7, 13, 37, '0', '0', '0', '0', '0', '0', '0', '', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (232, 45, 7, 14, 39, '0', '0', '2', '7', '5', '17', '0', '60', '4', 'April', '2018', '2018-Apr-23 To 2018-Apr-29', '2018-04-30 04:37:08', ''),
  (233, 88, 4, 7, 16, '0', '0', '1', '2', '0', '37', '0', '', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (234, 89, 4, 7, 59, '0', '0', '5', '0', '4', '48', '0', '', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (235, 90, 4, 7, 17, '0', '0', '11', '6', '6', '49', '0', '', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (236, 91, 4, 7, 18, '0', '0', '4', '1', '4', '15', '52', '', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (237, 92, 4, 8, 20, '0', '0', '2', '2', '5', '47', '0', '', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (238, 93, 4, 8, 60, '0', '0', '4', '1', '10', '44', '0', '', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (239, 94, 4, 8, 61, '0', '0', '3', '1', '3', '47', '0', '', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (240, 95, 11, 2, 1, '0', '0', '10', '5', '2', '44', '0', '128', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (241, 96, 11, 2, 4, '0', '0', '6', '0', '8', '50', '0', '95', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (242, 97, 11, 2, 62, '0', '0', '13', '3', '8', '47', '0', '126', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (243, 98, 11, 2, 3, '0', '0', '0', '0', '3', '31', '0', '126', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (244, 99, 11, 6, 13, '0', '0', '5', '2', '5', '50', '0', '157', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (245, 100, 11, 6, 14, '0', '0', '4', '9', '5', '57', '0', '66', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (246, 101, 11, 6, 2, '0', '0', '5', '3', '3', '52', '0', '98', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (247, 102, 11, 23, 12, '0', '0', '18', '4', '8', '58', '0', '88', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (248, 103, 11, 23, 11, '0', '0', '0', '5', '9', '40.5', '0', '127', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (249, 104, 11, 23, 10, '1', '1', '8', '1', '5', '55', '0', '117', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (250, 81, 5, 10, 24, '1', '1', '14', '4', '2', '34', '0', '128', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (251, 82, 5, 10, 25, '0', '0', '11', '1', '6', '27', '0', '87', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (252, 83, 5, 10, 22, '0', '0', '3', '2', '4', '23', '52', '130', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (253, 84, 5, 10, 23, '0', '0', '8', '2', '1', '14', '53', '130', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (254, 85, 5, 24, 28, '0', '0', '8', '0', '4', '51', '0', '101', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (255, 86, 5, 24, 27, '0', '0', '0', '4', '1', '55', '0', '82', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (256, 87, 5, 24, 26, '0', '0', '3', '11', '5', '52', '0', '76', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (257, 60, 9, 17, 48, '0', '0', '6', '2', '3', '48', '7', '72', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (258, 61, 9, 17, 50, '0', '0', '12', '2', '5', '56', '0', '84', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (259, 62, 9, 17, 49, '0', '0', '10', '10', '4', '59', '', '112', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (260, 63, 9, 18, 53, '0', '0', '10', '4', '3', '51', '0', '72', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (261, 64, 9, 18, 52, '0', '0', '10', '10', '14', '63', '0', '63', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (262, 110, 10, 26, 54, '0', '0', '5', '3', '9', '54', '0', '84', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (263, 111, 10, 26, 55, '0', '0', '5', '3', '9', '54', '0', '84', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (264, 112, 10, 20, 57, '0', '0', '7', '4', '8', '59', '0', '', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (265, 113, 10, 20, 56, '0', '0', '7', '1', '4', '24', '0', '', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (266, 114, 10, 20, 58, '1', '1', '6', '6', '3', '50', '0', '116', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (267, 105, 2, 25, 5, '0', '0', '4', '2', '8', '26', '32', '110', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (268, 106, 2, 25, 6, '0', '0', '5', '0', '3', '45', '0', '113', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (269, 107, 2, 25, 7, '0', '0', '2', '3', '1', '26', '32', '165', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (270, 108, 2, 4, 8, '0', '0', '2', '2', '1', '53', '0', '116', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (271, 109, 2, 4, 9, '0', '0', '8', '5', '9', '57', '0', '97', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (272, 65, 8, 15, 40, '0', '0', '10', '2', '5', '50', '0', '110', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (273, 66, 8, 15, 41, '0', '0', '11', '1', '3', '51', '0', '110', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (274, 67, 8, 15, 42, '0', '0', '7', '1', '11', '52', '0', '99', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (275, 68, 8, 16, 47, '0', '0', '6', '6', '22', '60', '0', '140', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (276, 69, 8, 16, 44, '0', '0', '6', '8', '4', '23.5', '0', '136', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (277, 70, 8, 16, 45, '1', '1', '3', '0', '2', '11', '0', '111', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (278, 71, 8, 16, 46, '0', '0', '10', '1', '6', '52', '0', '95', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (279, 76, 6, 11, 29, '0', '0', '2', '3', '1', '27', '0', '151', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (280, 77, 6, 11, 30, '0', '0', '9', '1', '6', '52', '0', '', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (281, 78, 6, 12, 33, '0', '0', '4', '4', '2', '58', '0', '114', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (282, 79, 6, 12, 32, '0', '0', '11', '1', '6', '27', '0', '87', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (283, 80, 6, 12, 34, '0', '0', '5', '0', '3', '54', '0', '151', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (284, 72, 7, 13, 35, '0', '0', '7', '5', '5', '53', '0', '120', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (285, 73, 7, 13, 36, '0', '0', '6', '1', '7', '63.5', '0', '67', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (286, 74, 7, 14, 39, '0', '0', '8', '1', '8', '60', '0', '73', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (287, 75, 7, 14, 38, '1', '0', '19', '4', '13', '50.5', '0', '124', '1', 'May', '2018', '2018-Apr-30 To 2018-May-06', '2018-05-07 05:28:26', ''),
  (288, 88, 4, 7, 16, '0', '0', '3', '3', '3', '39', '3', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (289, 89, 4, 7, 59, '0', '0', '5', '0', '2', '42', '0', '131', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (290, 90, 4, 7, 17, '4', '4', '9', '7', '6', '48', '0', '90', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (291, 91, 4, 7, 18, '0', '0', '0', '0', '0', '0', '0', '0', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (292, 92, 4, 8, 20, '1', '1', '1', '2', '4', '48', '0', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (293, 93, 4, 8, 60, '0', '0', '6', '0', '5', '43', '0', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (294, 94, 4, 8, 61, '0', '0', '5', '1', '5', '43', '0', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (295, 95, 11, 2, 1, '0', '0', '14', '6', '4', '35', '15', '133', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (296, 96, 11, 2, 4, '0', '0', '7', '2', '3', '41', '0', '116', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (297, 97, 11, 2, 62, '0', '0', '16', '1', '6', '38', '0', '116', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (298, 98, 11, 2, 3, '0', '0', '3', '0', '9', '36', '0', '116', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (299, 99, 11, 6, 13, '0', '0', '5', '3', '5', '50', '0', '147', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (300, 100, 11, 6, 14, '0', '0', '4', '3', '5', '48', '0', '74', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (301, 101, 11, 6, 2, '0', '0', '5', '3', '2', '52', '0', '113', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (302, 102, 11, 23, 12, '0', '0', '19', '5', '9', '48', '0', '88', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (303, 103, 11, 23, 11, '0', '0', '8', '6', '1', '22', '16', '122', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (304, 104, 11, 23, 10, '0', '0', '14', '3', '6', '46', '0', '112', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (305, 81, 5, 10, 24, '0', '0', '14', '4', '3', '42', '3', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (306, 82, 5, 10, 25, '0', '0', '8', '2', '10', '44', '4.5', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (307, 83, 5, 10, 22, '0', '0', '3', '1', '4', '28', '59', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (308, 84, 5, 10, 23, '0', '0', '4', '0', '0', '17', '42', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (309, 85, 5, 24, 28, '0', '0', '10', '1', '6', '44', '0', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (310, 86, 5, 24, 27, '0', '0', '7', '1', '4', '47', '0', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (311, 87, 5, 24, 26, '0', '0', '11', '1', '2', '42', '0', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (312, 60, 9, 17, 48, '0', '0', '7', '2', '4', '55', '0', '82', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (313, 61, 9, 17, 50, '1', '1', '16', '6', '5', '57', '0', '100', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', '2018-05-15 09:40:41'),
  (314, 62, 9, 17, 49, '0', '0', '17', '4', '2', '53', '0', '88', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (315, 63, 9, 18, 53, '0', '0', '9', '2', '5', '52', '0', '87', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (316, 64, 9, 18, 52, '0', '0', '12', '9', '11', '62', '0', '59', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (317, 110, 10, 26, 54, '2', '2', '4', '1', '1', '41', '0', '169', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (318, 111, 10, 26, 55, '0', '0', '5', '5', '4', '33', '0', '91', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (319, 112, 10, 20, 57, '0', '0', '9', '9', '5', '36', '0', '132', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (320, 113, 10, 20, 56, '0', '0', '2', '3', '3', '36.5', '0', '172', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (321, 114, 10, 20, 58, '0', '0', '11', '8', '4', '37', '0', '122', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (322, 105, 2, 25, 5, '0', '0', '8', '1', '6', '49', '11', '98', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (323, 106, 2, 25, 6, '0', '0', '6', '1', '4', '55', '0', '115', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (324, 107, 2, 25, 7, '0', '0', '5', '4', '4', '50', '5', '177', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (325, 108, 2, 4, 8, '0', '0', '4', '2', '2', '53', '0', '141', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (326, 109, 2, 4, 9, '1', '1', '8', '4', '11', '54', '0', '114', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (327, 65, 8, 15, 40, '0', '0', '5', '1', '4', '50', '0', '105', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (328, 66, 8, 15, 41, '0', '0', '0', '0', '0', '0', '0', '0', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (329, 67, 8, 15, 42, '0', '0', '7', '8', '8', '52', '0', '175', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (330, 68, 8, 16, 47, '0', '0', '8', '2', '10', '51', '0', '98', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (331, 69, 8, 16, 44, '1', '1', '6', '3', '17', '50.5', '0', '123', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (332, 70, 8, 16, 45, '0', '0', '13', '1', '8', '53', '0', '135', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (333, 71, 8, 16, 46, '1', '1', '10', '0', '8', '50', '0', '78', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (334, 76, 6, 11, 29, '0', '0', '3', '1', '13', '54', '0', '146', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (335, 77, 6, 11, 30, '1', '1', '8', '3', '6', '56', '0', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (336, 78, 6, 12, 33, '0', '0', '3', '7', '6', '52', '0', '109', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (337, 79, 6, 12, 32, '0', '0', '11', '3', '6', '57.5', '0', '95', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (338, 80, 6, 12, 34, '0', '0', '6', '0', '2', '57', '0', '148', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (339, 72, 7, 13, 35, '0', '0', '9', '2', '9', '62', '2', '', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (340, 73, 7, 13, 36, '0', '0', '7', '2', '5', '60', '0', '67', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (341, 74, 7, 14, 39, '0', '0', '4', '5', '11', '50', '0', '77', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', ''),
  (342, 75, 7, 14, 38, '2', '3', '21', '6', '2', '51.5', '0', '112', '2', 'May', '2018', '2018-May-07 To 2018-May-13', '2018-05-14 06:07:27', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `pcdom_users`
  --
  
  CREATE TABLE `pcdom_users` (
    `user_id` int(11) NOT NULL,
    `email` varchar(100) NOT NULL,
    `password` varchar(300) NOT NULL,
    `firstname` varchar(50) NOT NULL,
    `middlename` varchar(50) NOT NULL,
    `lastname` varchar(50) NOT NULL,
    `last_login` varchar(100) NOT NULL,
    `created` varchar(50) NOT NULL,
    `modified` varchar(50) NOT NULL,
    `login_type` varchar(50) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `pcdom_users`
  --
  
  INSERT INTO `pcdom_users` (`user_id`, `email`, `password`, `firstname`, `middlename`, `lastname`, `last_login`, `created`, `modified`, `login_type`) VALUES
  (1, 'felmeraldb@gmail.com', '2429ada13f1c95aaacc0562c09bc148c3e1bec8e', 'felmerald', 'calago', 'besario', '2018-05-09 06:41:55', '2018-03-28 04:25:14', '', 'mrec'),
  (3, 'felmerald.besario@myldsmail.net', '2429ada13f1c95aaacc0562c09bc148c3e1bec8e', 'administrator', 'Admin', 'Super', '2018-05-09 06:18:19', '2018-03-28 04:53:12', '', 'admin'),
  (4, 'destoni.mahayahay@myldsmail.net', '6dc5ba199c62fbde8df5546121d8fa9995c81097', 'Destoni', 'Middle', 'Mahayahay', '', '2018-03-30 06:11:26', '', 'supply'),
  (5, 'jeth.ablen@myldsmail.net', '46ebcb1a5fc3b1b9283cd814dd4fe3ea0c1977de', 'Jeth', 'Cresencio', 'Ablen', '2018-05-09 06:19:46', '2018-05-09 06:17:09', '', 'mrec'),
  (6, 'joshua.cabanilla@myldsmail.net', 'f2f97b7b516f091fbebb705b9fd12d62fd1f3e5b', 'Joshua John', 'Juan', 'Cabanilla', '', '2018-05-09 06:18:07', '', 'mrec');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `pcdom_zone`
  --
  
  CREATE TABLE `pcdom_zone` (
    `zone_id` int(11) NOT NULL,
    `zone_name` varchar(100) NOT NULL,
    `created` varchar(100) NOT NULL,
    `modified` varchar(100) NOT NULL,
    `in_used` varchar(20) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `pcdom_zone`
  --
  
  INSERT INTO `pcdom_zone` (`zone_id`, `zone_name`, `created`, `modified`, `in_used`) VALUES
  (1, 'Balingasag Zone', '2018-04-06 05:32:34', '2018-05-18 03:20:21', 'not_used'),
  (2, 'Malaybalay Zone', '2018-04-06 05:32:34', '', ''),
  (3, 'CDO East Zone', '2018-04-06 05:32:34', '2018-05-18 03:27:34', 'not_used'),
  (4, 'CDO Central Zone', '2018-04-06 05:32:34', '', ''),
  (5, 'CDO West  Zone', '2018-04-06 05:32:34', '', ''),
  (6, 'Ozamiz Zone', '2018-04-06 05:32:34', '', ''),
  (7, 'Pagadian Zone', '2018-04-06 05:32:34', '', ''),
  (8, 'Oroquieta Zone', '2018-04-06 05:32:34', '', ''),
  (9, 'Dipolog Zone', '2018-04-06 05:32:34', '', ''),
  (10, 'Iligan Zone', '2018-04-06 05:32:34', '', ''),
  (11, 'CDO EAST BALINGASAG', '2018-05-02 03:36:06', '', '');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `pcdom_area`
  --
  ALTER TABLE `pcdom_area`
    ADD PRIMARY KEY (`area_id`);
  
  --
  -- Indexes for table `pcdom_companionship`
  --
  ALTER TABLE `pcdom_companionship`
    ADD PRIMARY KEY (`companionship_id`),
    ADD KEY `companionship_id` (`companionship_id`),
    ADD KEY `missionary_one_id` (`missionary_one_id`),
    ADD KEY `missionary_two_id` (`missionary_two_id`),
    ADD KEY `missionary_three_id` (`missionary_three_id`),
    ADD KEY `zone_id` (`zone_id`),
    ADD KEY `district_id` (`district_id`),
    ADD KEY `area_id` (`area_id`);
  
  --
  -- Indexes for table `pcdom_district`
  --
  ALTER TABLE `pcdom_district`
    ADD PRIMARY KEY (`district_id`);
  
  --
  -- Indexes for table `pcdom_missionaries`
  --
  ALTER TABLE `pcdom_missionaries`
    ADD PRIMARY KEY (`missionary_id`),
    ADD KEY `missionary_id` (`missionary_id`);
  
  --
  -- Indexes for table `pcdom_statistics`
  --
  ALTER TABLE `pcdom_statistics`
    ADD PRIMARY KEY (`stats_id`),
    ADD KEY `stats_id` (`stats_id`),
    ADD KEY `companionship_id` (`companionship_id`),
    ADD KEY `zone_id` (`zone_id`),
    ADD KEY `district_id` (`district_id`),
    ADD KEY `area_id` (`area_id`);
  
  --
  -- Indexes for table `pcdom_users`
  --
  ALTER TABLE `pcdom_users`
    ADD PRIMARY KEY (`user_id`),
    ADD KEY `user_id` (`user_id`);
  
  --
  -- Indexes for table `pcdom_zone`
  --
  ALTER TABLE `pcdom_zone`
    ADD PRIMARY KEY (`zone_id`),
    ADD KEY `zone_id` (`zone_id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `pcdom_area`
  --
  ALTER TABLE `pcdom_area`
    MODIFY `area_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;
  
  --
  -- AUTO_INCREMENT for table `pcdom_companionship`
  --
  ALTER TABLE `pcdom_companionship`
    MODIFY `companionship_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=115;
  
  --
  -- AUTO_INCREMENT for table `pcdom_district`
  --
  ALTER TABLE `pcdom_district`
    MODIFY `district_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
  
  --
  -- AUTO_INCREMENT for table `pcdom_missionaries`
  --
  ALTER TABLE `pcdom_missionaries`
    MODIFY `missionary_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=146;
  
  --
  -- AUTO_INCREMENT for table `pcdom_statistics`
  --
  ALTER TABLE `pcdom_statistics`
    MODIFY `stats_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=343;
  
  --
  -- AUTO_INCREMENT for table `pcdom_users`
  --
  ALTER TABLE `pcdom_users`
    MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `pcdom_zone`
  --
  ALTER TABLE `pcdom_zone`
    MODIFY `zone_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  COMMIT;
  
  /*!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 */;
  