-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `vlmbdcom_kaizen`
--

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

--
-- Table structure for table `company_info`
--

CREATE TABLE `company_info` (
  `id` bigint(20) NOT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `short_name` varchar(255) NOT NULL,
  `email_address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `date_format` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `company_info`
--

INSERT INTO `company_info` (`id`, `company_name`, `short_name`, `email_address`, `phone`, `website`, `address`, `date_format`, `logo`) VALUES
(1, 'Ventura Leatherware Mfy BD Ltd.', 'VLMBD', 'golam.mostofa@bdventura.com', '01723695251', 'www.vlmbd.com', 'Uttara EPZ, Nilphamri, Bangladesh', 'dd/mm/yyyy', 'default-50x50.gif');

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

--
-- Table structure for table `department_info`
--

CREATE TABLE `department_info` (
  `department_id` int(11) NOT NULL,
  `department_name` varchar(255) NOT NULL,
  `dept_head_email` varchar(255) DEFAULT NULL,
  `kaizen_group` tinyint(4) NOT NULL,
  `kpi_yes` tinyint(4) NOT NULL DEFAULT 2,
  `chk_status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `department_info`
--

INSERT INTO `department_info` (`department_id`, `department_name`, `dept_head_email`, `kaizen_group`, `kpi_yes`, `chk_status`) VALUES
(1, 'IT', 'golam.mostofa@bdventura.com', 2, 2, 1),
(2, 'HCM', 'saiful.hoque@bdventura.com', 2, 2, 1),
(3, 'Admin', 'aynal.haque@bdventura.com', 2, 2, 1),
(4, 'FIN & ACC', 'jwel.ahmmed@bdventura.com', 2, 2, 1),
(7, 'MERCHANDISING', 'melody.xie@bdventura.com', 2, 2, 1),
(8, 'LOGISTICS', 'shakhawat.hossen@bdventura.com', 2, 2, 1),
(9, 'IA', 'sarwar.hossen@bdventura.com', 2, 2, 1),
(10, 'SCM', 'robert.luo@bdventura.com', 2, 2, 1),
(12, 'A', 'akram.hossain@bdventura.com', 1, 1, 1),
(13, 'B', 'akram.hossain@bdventura.com', 1, 1, 1),
(14, 'C', 'akram.hossain@bdventura.com', 1, 1, 1),
(15, 'D', 'akram.hossain@bdventura.com', 1, 1, 1),
(16, 'SLG-A', 'akram.hossain@bdventura.com', 1, 2, 2),
(17, 'SLG-B', 'akram.hossain@bdventura.com', 1, 2, 2),
(18, 'PE', 'evan.chen@bdventura.com', 1, 2, 1),
(19, 'QC & QA', 'ajay.kumar@bdventura.com', 1, 2, 1),
(20, 'PC & Packing', 'austin.xu@bdventura.com', 1, 2, 1),
(21, 'TPM', 'Nelson.xiao@bdventura.com', 1, 2, 1),
(22, 'Lean', 'thomas.zou@bdventura.com', 1, 2, 1),
(23, 'IM', 'thomas.zou@bdventura.com', 1, 2, 1),
(24, 'SLG', 'akram.hossain@bdventura.com', 1, 1, 1),
(25, 'F', 'golam.mostofa@bdventura.com', 1, 1, 1),
(26, 'QCO', 'amitav.saha@bdventura.com', 1, 2, 1);

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

--
-- Table structure for table `divisional_head`
--

CREATE TABLE `divisional_head` (
  `div_id` int(11) NOT NULL,
  `department_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `div_email_address` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `divisional_head`
--

INSERT INTO `divisional_head` (`div_id`, `department_id`, `name`, `div_email_address`) VALUES
(1, 1, 'Malik Ma', 'malik.ma@hkthewell.com'),
(2, 2, 'Malik Ma', 'malik.ma@hkthewell.com'),
(3, 3, 'Malik Ma', 'malik.ma@hkthewell.com'),
(4, 4, 'Malik Ma', 'malik.ma@hkthewell.com'),
(5, 7, 'Sarah Duan\r\n', 'sarah.duan@bdventura.com'),
(6, 8, 'Sarah Duan', 'sarah.duan@bdventura.com'),
(7, 19, 'Chris Park \r\n', 'chris.park@bdventura.com'),
(8, 10, 'Lawrence Cheung\r\n', 'lawrence.cheung@ms.hkthewell.com'),
(9, 12, 'Steven Xu', 'steven.xu@bdventura.com'),
(10, 13, 'Steven Xu', 'steven.xu@bdventura.com'),
(11, 14, 'Steven Xu', 'steven.xu@bdventura.com'),
(12, 15, 'Steven Xu', 'steven.xu@bdventura.com'),
(13, 16, 'Steven Xu', 'steven.xu@bdventura.com'),
(14, 17, 'Steven Xu', 'steven.xu@bdventura.com'),
(15, 18, 'Steven Xu', 'steven.xu@bdventura.com'),
(16, 19, 'Steven Xu', 'steven.xu@bdventura.com'),
(17, 20, 'Steven Xu', 'steven.xu@bdventura.com'),
(18, 21, 'Steven Xu', 'steven.xu@bdventura.com'),
(19, 22, 'Malik Ma', 'malik.ma@hkthewell.com');

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

--
-- Table structure for table `floorline_info`
--

CREATE TABLE `floorline_info` (
  `line_id` smallint(6) NOT NULL,
  `department_id` smallint(6) NOT NULL,
  `line_no` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `floorline_info`
--

INSERT INTO `floorline_info` (`line_id`, `department_id`, `line_no`) VALUES
(1, 12, 'A1'),
(2, 12, 'A2'),
(3, 12, 'A3'),
(4, 12, 'A4'),
(5, 12, 'A5'),
(6, 12, 'A6'),
(7, 12, 'A7'),
(8, 12, 'A8'),
(9, 12, 'A9'),
(10, 13, 'B1'),
(11, 13, 'B2'),
(12, 13, 'B3'),
(13, 13, 'B4'),
(14, 13, 'B5'),
(15, 13, 'B6'),
(16, 13, 'B7'),
(17, 13, 'B8'),
(18, 13, 'B9'),
(19, 13, 'B10'),
(20, 13, 'B11'),
(21, 13, 'B12'),
(22, 14, 'C1'),
(23, 14, 'C2'),
(24, 14, 'C3'),
(25, 14, 'C4'),
(26, 14, 'C5'),
(27, 14, 'C6'),
(28, 14, 'C7'),
(29, 14, 'C8'),
(30, 14, 'C9'),
(31, 14, 'C10'),
(32, 14, 'C11'),
(33, 14, 'C12'),
(34, 15, 'D1'),
(35, 15, 'D2'),
(36, 15, 'D3'),
(37, 15, 'D4'),
(38, 15, 'D5'),
(39, 15, 'D6'),
(40, 15, 'D7'),
(41, 15, 'D8'),
(42, 15, 'D9'),
(43, 15, 'D10'),
(44, 15, 'D11'),
(45, 15, 'D12'),
(46, 16, 'SLG A-1'),
(47, 16, 'SLG A-2'),
(48, 16, 'SLG A-3'),
(49, 16, 'SLG A-4'),
(50, 16, 'SLG A-5'),
(51, 16, 'SLG A-6'),
(52, 17, 'SLG B-1'),
(53, 17, 'SLG B-2'),
(54, 17, 'SLG B-3'),
(55, 17, 'SLG B-4'),
(56, 17, 'SLG B-5'),
(57, 17, 'SLG B-6'),
(58, 24, 'SLG 1'),
(59, 24, 'SLG 2'),
(60, 24, 'SLG 3'),
(61, 24, 'SLG 4'),
(62, 24, 'SLG 5'),
(63, 24, 'SLG 6'),
(64, 24, 'SLG 7'),
(65, 24, 'SLG 8'),
(66, 24, 'SLG 9'),
(67, 24, 'SLG 10'),
(68, 24, 'SLG 11'),
(69, 24, 'SLG 12'),
(70, 25, 'F1'),
(71, 25, 'F2'),
(72, 25, 'F3');

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

--
-- Table structure for table `floor_info`
--

CREATE TABLE `floor_info` (
  `floor_id` int(11) NOT NULL,
  `floor_no` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `floor_info`
--

INSERT INTO `floor_info` (`floor_id`, `floor_no`) VALUES
(1, 'A-Floor'),
(2, 'B-Floor'),
(3, 'C-Floor'),
(4, 'D Floor'),
(5, 'SLG-A'),
(6, 'SLG-B');

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

--
-- Table structure for table `kaizen_information`
--

CREATE TABLE `kaizen_information` (
  `kaizen_id` bigint(20) NOT NULL,
  `kaizen_group` tinyint(4) NOT NULL DEFAULT 1,
  `best_kaizen` tinyint(4) NOT NULL DEFAULT 1,
  `serial_no` varchar(255) DEFAULT NULL,
  `sn_count` bigint(20) DEFAULT NULL,
  `employee_card_id` varchar(255) DEFAULT NULL,
  `employee_name` varchar(255) DEFAULT NULL,
  `assist_by_id` varchar(255) DEFAULT NULL,
  `dept_name` varchar(255) DEFAULT NULL,
  `employee_photo` varchar(255) DEFAULT NULL,
  `titles_id` int(11) DEFAULT NULL,
  `kaizen_date` varchar(255) DEFAULT NULL,
  `submit_date` varchar(255) DEFAULT NULL,
  `best_submit_date` varchar(255) DEFAULT NULL,
  `before_note` varchar(1000) DEFAULT NULL,
  `after_note` varchar(1000) DEFAULT NULL,
  `kaizen_type` varchar(255) DEFAULT NULL,
  `quality` varchar(255) NOT NULL,
  `cost` varchar(255) NOT NULL,
  `times` varchar(255) NOT NULL,
  `productivity` varchar(255) NOT NULL,
  `morale` varchar(255) NOT NULL,
  `safety` varchar(255) NOT NULL,
  `style` varchar(255) DEFAULT NULL,
  `line_id` smallint(6) DEFAULT NULL,
  `before_pic1` varchar(255) DEFAULT NULL,
  `before_pic2` varchar(255) DEFAULT NULL,
  `before_pic3` varchar(255) DEFAULT NULL,
  `before_pic4` varchar(255) DEFAULT NULL,
  `after_pic1` varchar(255) DEFAULT NULL,
  `after_pic2` varchar(255) DEFAULT NULL,
  `after_pic3` varchar(255) DEFAULT NULL,
  `after_pic4` varchar(255) DEFAULT NULL,
  `before_pic_des` text DEFAULT NULL,
  `after_pic_des` text DEFAULT NULL,
  `improve_des` mediumtext DEFAULT NULL,
  `review_date` varchar(255) DEFAULT NULL,
  `kaizen_status` tinyint(4) NOT NULL DEFAULT 0,
  `video_link` varchar(255) DEFAULT NULL,
  `yokoten_status` tinyint(4) NOT NULL DEFAULT 0,
  `best_status` tinyint(4) NOT NULL DEFAULT 0,
  `kaizen_mark` decimal(11,2) NOT NULL DEFAULT 0.00,
  `user_id` int(11) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `review_department` smallint(6) DEFAULT NULL,
  `yapproved_by` int(11) DEFAULT NULL,
  `bapproved_by` int(11) DEFAULT NULL,
  `reject_note` varchar(500) DEFAULT NULL,
  `mac_address` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `kaizen_type`
--

CREATE TABLE `kaizen_type` (
  `type_id` int(11) NOT NULL,
  `kaizen_type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kaizen_type`
--

INSERT INTO `kaizen_type` (`type_id`, `kaizen_type`) VALUES
(1, 'Q'),
(2, 'C'),
(3, 'P'),
(4, 'T'),
(5, 'M'),
(6, 'S');

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

--
-- Table structure for table `line_target`
--

CREATE TABLE `line_target` (
  `target_id` int(11) NOT NULL,
  `line_id` int(11) NOT NULL,
  `target_number` int(11) NOT NULL,
  `target_date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `line_target`
--

INSERT INTO `line_target` (`target_id`, `line_id`, `target_number`, `target_date`) VALUES
(1, 1, 12, '2017-10-29'),
(2, 2, 12, '2017-10-29'),
(3, 3, 12, '2017-10-29'),
(4, 4, 12, '2017-10-29'),
(5, 5, 12, '2017-10-29'),
(6, 6, 12, '2017-10-29'),
(7, 7, 12, '2017-10-29'),
(8, 8, 12, '2017-10-29'),
(9, 10, 12, '2017-10-29'),
(10, 11, 12, '2017-10-29'),
(11, 12, 12, '2017-10-29'),
(12, 13, 12, '2017-10-29'),
(13, 14, 12, '2017-10-29'),
(14, 15, 12, '2017-10-29'),
(15, 16, 12, '2017-10-29'),
(16, 17, 12, '2017-10-29'),
(17, 18, 12, '2017-10-29'),
(18, 22, 12, '2017-10-29'),
(19, 23, 12, '2017-10-29'),
(20, 24, 12, '2017-10-29'),
(21, 25, 12, '2017-10-29'),
(22, 26, 12, '2017-10-29'),
(23, 27, 12, '2017-10-29'),
(24, 28, 12, '2017-10-29'),
(25, 29, 12, '2017-10-29'),
(26, 30, 12, '2017-10-29'),
(27, 34, 12, '2017-10-29'),
(28, 35, 12, '2017-10-29'),
(29, 36, 12, '2017-10-29'),
(30, 37, 12, '2017-10-29'),
(31, 38, 12, '2017-10-29'),
(32, 39, 12, '2017-10-29'),
(33, 40, 12, '2017-10-29'),
(34, 41, 12, '2017-10-29'),
(35, 42, 12, '2017-10-29'),
(39, 49, 8, '2017-10-29'),
(40, 50, 8, '2017-10-29'),
(41, 51, 8, '2017-10-29'),
(43, 47, 8, '2017-10-29'),
(44, 46, 8, '2017-10-29'),
(45, 48, 8, '2017-10-29'),
(46, 52, 8, '2017-10-29'),
(47, 53, 8, '2017-10-29'),
(48, 54, 8, '2017-10-29'),
(49, 55, 8, '2017-10-29'),
(50, 56, 8, '2017-10-29'),
(51, 57, 8, '2017-10-29'),
(52, 1, 12, '2017-11-29'),
(53, 2, 12, '2017-11-29'),
(54, 3, 12, '2017-11-29'),
(55, 4, 12, '2017-11-29'),
(56, 5, 12, '2017-11-29'),
(57, 6, 12, '2017-11-29'),
(58, 7, 12, '2017-11-29'),
(59, 8, 12, '2017-11-29'),
(60, 10, 12, '2017-11-29'),
(61, 11, 12, '2017-11-29'),
(62, 12, 12, '2017-11-29'),
(63, 13, 12, '2017-11-29'),
(64, 14, 12, '2017-11-29'),
(65, 15, 12, '2017-11-29'),
(66, 16, 12, '2017-11-29'),
(67, 17, 12, '2017-11-29'),
(68, 18, 12, '2017-11-29'),
(69, 22, 12, '2017-11-29'),
(70, 23, 12, '2017-11-29'),
(71, 24, 12, '2017-11-29'),
(72, 25, 12, '2017-11-29'),
(73, 26, 12, '2017-11-29'),
(74, 27, 12, '2017-11-29'),
(75, 28, 12, '2017-11-29'),
(76, 29, 12, '2017-11-29'),
(77, 30, 12, '2017-11-29'),
(78, 34, 12, '2017-11-29'),
(79, 35, 12, '2017-11-29'),
(80, 36, 12, '2017-11-29'),
(81, 37, 12, '2017-11-29'),
(82, 38, 12, '2017-11-29'),
(83, 39, 12, '2017-11-29'),
(84, 40, 12, '2017-11-29'),
(85, 41, 12, '2017-11-29'),
(86, 42, 12, '2017-11-29'),
(87, 46, 8, '2017-11-29'),
(88, 47, 8, '2017-11-29'),
(89, 48, 8, '2017-11-29'),
(90, 49, 8, '2017-11-29'),
(91, 50, 8, '2017-11-29'),
(92, 51, 8, '2017-11-29'),
(93, 52, 8, '2017-11-29'),
(94, 53, 8, '2017-11-29'),
(95, 54, 8, '2017-11-29'),
(96, 55, 8, '2017-11-29'),
(97, 56, 8, '2017-11-29'),
(98, 57, 8, '2017-11-29'),
(99, 1, 12, '2017-12-24'),
(100, 2, 12, '2017-12-24'),
(101, 3, 12, '2017-12-24'),
(102, 4, 12, '2017-12-24'),
(103, 5, 12, '2017-12-24'),
(104, 6, 12, '2017-12-24'),
(105, 7, 12, '2017-12-24'),
(106, 8, 12, '2017-12-24'),
(107, 10, 12, '2017-12-24'),
(108, 11, 12, '2017-12-24'),
(109, 12, 12, '2017-12-24'),
(110, 13, 12, '2017-12-24'),
(111, 14, 12, '2017-12-24'),
(112, 15, 12, '2017-12-24'),
(113, 16, 12, '2017-12-24'),
(114, 17, 12, '2017-12-24'),
(115, 18, 12, '2017-12-24'),
(116, 22, 12, '2017-12-24'),
(117, 23, 12, '2017-12-24'),
(118, 24, 12, '2017-12-24'),
(119, 25, 12, '2017-12-24'),
(120, 26, 12, '2017-12-24'),
(121, 27, 12, '2017-12-24'),
(122, 28, 12, '2017-12-24'),
(123, 29, 12, '2017-12-24'),
(124, 30, 12, '2017-12-24'),
(125, 34, 12, '2017-12-24'),
(126, 35, 12, '2017-12-24'),
(127, 36, 12, '2017-12-24'),
(128, 37, 12, '2017-12-24'),
(129, 38, 12, '2017-12-24'),
(130, 39, 12, '2017-12-24'),
(131, 40, 12, '2017-12-24'),
(132, 41, 12, '2017-12-24'),
(133, 42, 12, '2017-12-24'),
(134, 46, 8, '2017-12-24'),
(135, 47, 8, '2017-12-24'),
(136, 48, 8, '2017-12-24'),
(137, 49, 8, '2017-12-24'),
(138, 50, 8, '2017-12-24'),
(139, 51, 8, '2017-12-24'),
(140, 52, 8, '2017-12-24'),
(141, 53, 8, '2017-12-24'),
(142, 54, 8, '2017-12-24'),
(143, 55, 8, '2017-12-24'),
(144, 56, 8, '2017-12-24'),
(145, 57, 8, '2017-12-24'),
(146, 1, 12, '2018-02-04'),
(147, 2, 12, '2018-02-04'),
(148, 3, 12, '2018-02-04'),
(149, 4, 12, '2018-02-04'),
(150, 5, 12, '2018-02-04'),
(151, 6, 12, '2018-02-04'),
(152, 7, 12, '2018-02-04'),
(153, 8, 12, '2018-02-04'),
(154, 10, 12, '2018-02-04'),
(155, 11, 12, '2018-02-04'),
(156, 12, 12, '2018-02-04'),
(157, 13, 12, '2018-02-04'),
(158, 14, 12, '2018-02-04'),
(159, 15, 12, '2018-02-04'),
(160, 16, 12, '2018-02-04'),
(161, 17, 12, '2018-02-04'),
(162, 18, 12, '2018-02-04'),
(163, 22, 12, '2018-02-04'),
(164, 23, 12, '2018-02-04'),
(165, 24, 12, '2018-02-04'),
(166, 25, 12, '2018-02-04'),
(167, 26, 12, '2018-02-04'),
(168, 27, 12, '2018-02-04'),
(169, 28, 12, '2018-02-04'),
(170, 29, 12, '2018-02-04'),
(171, 30, 12, '2018-02-04'),
(172, 34, 12, '2018-02-04'),
(173, 35, 12, '2018-02-04'),
(174, 36, 12, '2018-02-04'),
(175, 37, 12, '2018-02-04'),
(176, 38, 12, '2018-02-04'),
(177, 39, 12, '2018-02-04'),
(178, 40, 12, '2018-02-04'),
(179, 41, 12, '2018-02-04'),
(180, 42, 12, '2018-02-04'),
(181, 58, 8, '2018-01-21'),
(182, 59, 8, '2018-02-12'),
(183, 60, 8, '2018-02-13'),
(184, 61, 8, '2018-02-12'),
(185, 62, 8, '2018-02-13'),
(186, 63, 8, '2018-02-13'),
(187, 64, 8, '2018-02-13'),
(188, 65, 8, '2018-02-13'),
(189, 66, 8, '2018-02-13'),
(190, 67, 8, '2018-02-13'),
(191, 68, 8, '2018-02-13'),
(192, 69, 8, '2018-02-13'),
(193, 46, 8, '2018-01-30'),
(194, 1, 12, '2018-02-25'),
(195, 2, 12, '2018-02-25'),
(196, 3, 12, '2018-02-25'),
(197, 4, 12, '2018-02-25'),
(198, 5, 12, '2018-02-25'),
(199, 6, 12, '2018-02-25'),
(200, 7, 12, '2018-02-25'),
(201, 8, 12, '2018-02-25'),
(202, 10, 12, '2018-02-25'),
(203, 11, 12, '2018-02-25'),
(204, 12, 12, '2018-02-25'),
(205, 13, 12, '2018-02-25'),
(206, 14, 12, '2018-02-25'),
(207, 15, 12, '2018-02-25'),
(208, 16, 12, '2018-02-25'),
(209, 17, 12, '2018-02-25'),
(210, 18, 12, '2018-02-25'),
(211, 22, 12, '2018-02-25'),
(212, 23, 12, '2018-02-25'),
(213, 24, 12, '2018-02-25'),
(214, 25, 12, '2018-02-25'),
(215, 26, 12, '2018-02-25'),
(216, 27, 12, '2018-02-25'),
(217, 28, 12, '2018-02-25'),
(218, 29, 12, '2018-02-25'),
(219, 30, 12, '2018-02-25'),
(220, 34, 12, '2018-02-25'),
(221, 35, 12, '2018-02-25'),
(222, 36, 12, '2018-02-25'),
(223, 37, 12, '2018-02-25'),
(224, 38, 12, '2018-02-25'),
(225, 39, 12, '2018-02-25'),
(226, 40, 12, '2018-02-25'),
(227, 41, 12, '2018-02-25'),
(228, 42, 12, '2018-02-25'),
(229, 58, 8, '2018-02-25'),
(230, 59, 8, '2018-02-25'),
(231, 60, 8, '2018-02-25'),
(232, 61, 8, '2018-02-25'),
(233, 62, 8, '2018-02-25'),
(234, 63, 8, '2018-02-25'),
(235, 64, 8, '2018-02-25'),
(236, 65, 8, '2018-02-25'),
(237, 66, 8, '2018-02-25'),
(238, 67, 8, '2018-02-25'),
(239, 68, 8, '2018-02-25'),
(240, 69, 8, '2018-02-25'),
(241, 1, 12, '2018-04-10'),
(242, 2, 12, '2018-04-04'),
(243, 3, 12, '2018-04-03'),
(244, 4, 12, '2018-04-10'),
(245, 5, 12, '2018-04-04'),
(246, 6, 12, '2018-04-11'),
(247, 7, 12, '2018-04-10'),
(248, 8, 12, '2018-04-10'),
(249, 10, 12, '2018-04-10'),
(250, 11, 12, '2018-04-10'),
(251, 12, 12, '2018-04-17'),
(252, 13, 12, '2018-04-11'),
(253, 14, 12, '2018-04-10'),
(254, 15, 12, '2018-04-16'),
(255, 16, 12, '2018-04-17'),
(256, 17, 12, '2018-04-10'),
(257, 18, 12, '2018-04-10'),
(258, 22, 12, '2018-04-10'),
(259, 23, 12, '2018-04-11'),
(260, 24, 12, '2018-04-10'),
(261, 25, 12, '2018-04-10'),
(262, 26, 12, '2018-04-10'),
(263, 27, 12, '2018-04-10'),
(264, 28, 12, '2018-04-10'),
(265, 29, 12, '2018-04-10'),
(266, 30, 12, '2018-04-10'),
(267, 34, 12, '2018-04-10'),
(268, 35, 12, '2018-04-10'),
(269, 36, 12, '2018-04-10'),
(270, 37, 12, '2018-04-03'),
(271, 38, 12, '2018-04-11'),
(272, 39, 12, '2018-04-10'),
(273, 40, 12, '2018-04-10'),
(274, 41, 12, '2018-04-11'),
(275, 42, 12, '2018-04-10'),
(276, 58, 8, '2018-04-10'),
(277, 59, 8, '2018-04-10'),
(278, 60, 8, '2018-04-11'),
(279, 61, 8, '2018-04-11'),
(280, 62, 8, '2018-04-03'),
(281, 63, 8, '2018-04-10'),
(282, 64, 8, '2018-04-10'),
(283, 65, 8, '2018-04-10'),
(284, 66, 8, '2018-04-10'),
(285, 67, 8, '2018-04-09'),
(286, 68, 8, '2018-04-10'),
(287, 69, 8, '2018-04-10'),
(288, 1, 12, '2018-05-16'),
(289, 2, 12, '2018-05-16'),
(290, 3, 12, '2018-05-16'),
(291, 4, 12, '2018-05-16'),
(292, 5, 12, '2018-05-16'),
(293, 6, 12, '2018-05-16'),
(294, 7, 12, '2018-05-16'),
(295, 8, 12, '2018-05-16'),
(296, 10, 12, '2018-05-16'),
(297, 11, 12, '2018-05-16'),
(298, 12, 12, '2018-05-16'),
(299, 13, 12, '2018-05-16'),
(300, 14, 12, '2018-05-16'),
(301, 15, 12, '2018-05-16'),
(302, 16, 12, '2018-05-16'),
(303, 17, 12, '2018-05-16'),
(304, 18, 12, '2018-05-16'),
(305, 22, 12, '2018-05-16'),
(306, 23, 12, '2018-05-16'),
(307, 24, 12, '2018-05-16'),
(308, 25, 12, '2018-05-16'),
(309, 26, 12, '2018-05-16'),
(310, 27, 12, '2018-05-16'),
(311, 28, 12, '2018-05-16'),
(312, 29, 12, '2018-05-16'),
(313, 30, 12, '2018-05-16'),
(314, 34, 12, '2018-05-16'),
(315, 35, 12, '2018-05-16'),
(316, 36, 12, '2018-05-16'),
(317, 37, 12, '2018-05-16'),
(318, 38, 12, '2018-05-16'),
(319, 39, 12, '2018-05-16'),
(320, 40, 12, '2018-05-16'),
(321, 41, 12, '2018-05-16'),
(322, 58, 8, '2018-05-16'),
(323, 59, 8, '2018-05-16'),
(324, 60, 8, '2018-05-16'),
(325, 61, 8, '2018-05-16'),
(326, 62, 8, '2018-05-16'),
(327, 63, 8, '2018-05-16'),
(328, 64, 8, '2018-05-16'),
(329, 65, 8, '2018-05-16'),
(330, 66, 8, '2018-05-16'),
(331, 67, 8, '2018-05-16'),
(332, 68, 8, '2018-05-16'),
(333, 69, 8, '2018-05-16'),
(334, 1, 9, '2018-06-10'),
(335, 2, 9, '2018-06-03'),
(336, 3, 9, '2018-06-10'),
(337, 4, 9, '2018-06-10'),
(338, 5, 9, '2018-06-10'),
(339, 6, 9, '2018-06-10'),
(340, 7, 9, '2018-06-10'),
(341, 8, 9, '2018-06-10'),
(342, 10, 9, '2018-06-10'),
(343, 11, 9, '2018-06-10'),
(344, 12, 9, '2018-06-10'),
(345, 13, 9, '2018-06-10'),
(346, 14, 9, '2018-06-10'),
(347, 15, 9, '2018-06-11'),
(348, 16, 9, '2018-06-10'),
(349, 17, 9, '2018-06-10'),
(350, 18, 9, '2018-06-10'),
(351, 22, 9, '2018-06-10'),
(352, 23, 9, '2018-06-10'),
(353, 24, 9, '2018-06-10'),
(354, 27, 9, '2018-06-10'),
(355, 26, 9, '2018-06-10'),
(356, 28, 9, '2018-06-10'),
(357, 29, 9, '2018-06-10'),
(358, 25, 9, '2018-06-10'),
(360, 30, 9, '2018-06-10'),
(361, 34, 9, '2018-06-10'),
(362, 35, 9, '2018-06-10'),
(363, 36, 9, '2018-06-10'),
(364, 37, 9, '2018-06-10'),
(365, 38, 9, '2018-06-10'),
(366, 39, 18, '2018-06-10'),
(367, 40, 9, '2018-06-10'),
(370, 41, 9, '2018-06-10'),
(372, 58, 6, '2018-06-10'),
(374, 59, 6, '2018-06-10'),
(375, 60, 6, '2018-06-10'),
(376, 61, 6, '2018-06-10'),
(377, 62, 6, '2018-06-10'),
(378, 63, 6, '2018-06-10'),
(379, 64, 6, '2018-06-10'),
(380, 65, 6, '2018-06-10'),
(381, 66, 6, '2018-06-10'),
(382, 67, 6, '2018-06-10'),
(383, 68, 6, '2018-06-10'),
(384, 69, 6, '2018-06-10'),
(385, 1, 12, '2018-07-11'),
(386, 2, 12, '2018-07-11'),
(387, 3, 12, '2018-07-11'),
(388, 4, 12, '2018-07-11'),
(389, 5, 12, '2018-07-11'),
(390, 6, 12, '2018-07-11'),
(391, 7, 12, '2018-07-11'),
(392, 8, 12, '2018-07-11'),
(393, 10, 12, '2018-07-11'),
(394, 11, 12, '2018-07-11'),
(395, 12, 12, '2018-07-11'),
(396, 13, 12, '2018-07-11'),
(397, 14, 12, '2018-07-11'),
(398, 15, 12, '2018-07-11'),
(399, 16, 12, '2018-07-11'),
(400, 17, 12, '2018-07-11'),
(401, 18, 12, '2018-07-11'),
(402, 22, 12, '2018-07-11'),
(403, 23, 12, '2018-07-11'),
(404, 24, 12, '2018-07-11'),
(405, 25, 12, '2018-07-11'),
(406, 26, 12, '2018-07-11'),
(407, 27, 12, '2018-07-11'),
(408, 28, 12, '2018-07-11'),
(409, 29, 12, '2018-07-11'),
(410, 30, 12, '2018-07-11'),
(411, 34, 12, '2018-07-11'),
(412, 35, 12, '2018-07-11'),
(413, 36, 12, '2018-07-11'),
(414, 37, 12, '2018-07-11'),
(415, 38, 12, '2018-07-11'),
(416, 39, 24, '2018-07-11'),
(417, 40, 12, '2018-07-11'),
(418, 41, 12, '2018-07-11'),
(419, 58, 8, '2018-07-11'),
(420, 59, 8, '2018-07-11'),
(421, 60, 8, '2018-07-11'),
(422, 61, 8, '2018-07-11'),
(423, 62, 8, '2018-07-11'),
(424, 63, 8, '2018-07-11'),
(425, 64, 8, '2018-07-11'),
(426, 65, 8, '2018-07-11'),
(427, 66, 8, '2018-07-11'),
(428, 67, 8, '2018-07-11'),
(535, 1, 12, '2018-08-14'),
(536, 2, 12, '2018-08-14'),
(537, 3, 12, '2018-08-14'),
(538, 4, 12, '2018-08-14'),
(539, 5, 12, '2018-08-14'),
(540, 6, 12, '2018-08-14'),
(541, 7, 12, '2018-08-14'),
(542, 8, 12, '2018-08-14'),
(543, 10, 12, '2018-08-14'),
(544, 11, 12, '2018-08-14'),
(545, 12, 12, '2018-08-14'),
(546, 13, 12, '2018-08-14'),
(547, 14, 12, '2018-08-14'),
(548, 15, 12, '2018-08-14'),
(549, 16, 12, '2018-08-14'),
(550, 17, 12, '2018-08-14'),
(551, 18, 12, '2018-08-14'),
(552, 22, 12, '2018-08-14'),
(553, 23, 12, '2018-08-14'),
(554, 24, 12, '2018-08-14'),
(555, 25, 12, '2018-08-14'),
(556, 26, 12, '2018-08-14'),
(557, 27, 12, '2018-08-14'),
(558, 28, 12, '2018-08-14'),
(559, 29, 12, '2018-08-14'),
(560, 30, 12, '2018-08-14'),
(561, 34, 12, '2018-08-14'),
(562, 35, 12, '2018-08-14'),
(563, 36, 12, '2018-08-14'),
(564, 37, 12, '2018-08-14'),
(565, 38, 12, '2018-08-14'),
(566, 39, 24, '2018-08-14'),
(567, 40, 12, '2018-08-14'),
(568, 41, 12, '2018-08-14'),
(569, 58, 8, '2018-08-14'),
(571, 59, 8, '2018-08-14'),
(572, 60, 8, '2018-08-14'),
(573, 61, 8, '2018-08-14'),
(575, 62, 8, '2018-08-14'),
(576, 51, 8, '2018-08-14'),
(577, 64, 8, '2018-08-14'),
(578, 65, 8, '2018-08-14'),
(579, 66, 8, '2018-08-14'),
(580, 67, 8, '2018-08-14'),
(581, 68, 8, '2018-08-14'),
(582, 69, 8, '2018-08-14'),
(583, 1, 12, '2018-08-27'),
(584, 2, 12, '2018-08-27'),
(585, 3, 12, '2018-08-27'),
(586, 4, 12, '2018-08-27'),
(587, 5, 12, '2018-08-27'),
(588, 6, 12, '2018-08-27'),
(589, 7, 12, '2018-08-27'),
(590, 8, 12, '2018-08-27'),
(591, 10, 12, '2018-08-27'),
(592, 11, 12, '2018-08-27'),
(593, 12, 12, '2018-08-27'),
(594, 13, 12, '2018-08-27'),
(595, 14, 12, '2018-08-27'),
(596, 15, 12, '2018-08-27'),
(597, 16, 12, '2018-08-27'),
(598, 17, 12, '2018-08-27'),
(599, 18, 12, '2018-08-27'),
(600, 22, 12, '2018-08-27'),
(601, 23, 12, '2018-08-27'),
(602, 24, 12, '2018-08-27'),
(603, 25, 12, '2018-08-27'),
(604, 26, 12, '2018-08-27'),
(605, 27, 12, '2018-08-27'),
(606, 28, 12, '2018-08-27'),
(607, 29, 12, '2018-08-27'),
(608, 30, 12, '2018-08-27'),
(609, 34, 12, '2018-08-27'),
(610, 35, 12, '2018-08-27'),
(611, 36, 12, '2018-08-27'),
(612, 37, 12, '2018-08-27'),
(613, 38, 12, '2018-08-27'),
(614, 39, 24, '2018-08-27'),
(615, 40, 12, '2018-08-27'),
(616, 41, 12, '2018-08-27'),
(617, 58, 8, '2018-08-27'),
(618, 59, 8, '2018-08-27'),
(619, 60, 8, '2018-08-27'),
(620, 61, 8, '2018-08-27'),
(621, 62, 8, '2018-08-27'),
(622, 63, 8, '2018-08-27'),
(623, 64, 8, '2018-08-27'),
(624, 65, 8, '2018-08-27'),
(625, 66, 8, '2018-08-27'),
(626, 67, 8, '2018-08-27'),
(627, 68, 8, '2018-08-27'),
(628, 69, 8, '2018-08-27'),
(629, 63, 8, '2018-08-14'),
(630, 1, 12, '2018-09-29'),
(631, 2, 12, '2018-09-29'),
(632, 3, 12, '2018-09-29'),
(633, 4, 12, '2018-09-29'),
(634, 5, 12, '2018-09-29'),
(635, 6, 12, '2018-09-29'),
(636, 7, 12, '2018-09-29'),
(637, 8, 12, '2018-09-29'),
(638, 10, 12, '2018-09-29'),
(639, 11, 12, '2018-09-29'),
(640, 12, 12, '2018-09-29'),
(641, 13, 12, '2018-09-29'),
(642, 14, 12, '2018-09-29'),
(643, 15, 12, '2018-09-29'),
(644, 16, 12, '2018-09-29'),
(645, 17, 12, '2018-09-29'),
(646, 18, 12, '2018-09-29'),
(647, 22, 12, '2018-09-29'),
(648, 23, 12, '2018-09-29'),
(649, 24, 12, '2018-09-29'),
(650, 25, 12, '2018-09-29'),
(651, 26, 12, '2018-09-29'),
(652, 27, 12, '2018-09-29'),
(653, 28, 12, '2018-09-29'),
(654, 29, 12, '2018-09-29'),
(655, 30, 12, '2018-09-29'),
(656, 34, 12, '2018-09-29'),
(657, 35, 12, '2018-09-29'),
(658, 36, 12, '2018-09-29'),
(659, 37, 12, '2018-09-29'),
(660, 38, 12, '2018-09-29'),
(661, 39, 24, '2018-09-29'),
(662, 40, 12, '2018-09-29'),
(663, 41, 12, '2018-09-29'),
(664, 58, 8, '2018-09-29'),
(665, 59, 8, '2018-09-29'),
(666, 60, 8, '2018-09-29'),
(667, 61, 8, '2018-09-29'),
(668, 62, 8, '2018-09-29'),
(669, 63, 8, '2018-09-29'),
(670, 64, 8, '2018-09-29'),
(671, 65, 8, '2018-09-29'),
(672, 66, 8, '2018-09-29'),
(673, 67, 8, '2018-09-29'),
(674, 68, 8, '2018-09-29'),
(675, 69, 8, '2018-09-29'),
(676, 1, 12, '2018-10-22'),
(677, 2, 12, '2018-10-22'),
(678, 3, 12, '2018-10-22'),
(679, 4, 12, '2018-10-22'),
(680, 5, 12, '2018-10-22'),
(681, 6, 12, '2018-10-22'),
(682, 7, 12, '2018-10-22'),
(683, 8, 12, '2018-10-22'),
(684, 10, 12, '2018-10-22'),
(685, 11, 12, '2018-10-22'),
(686, 12, 12, '2018-10-22'),
(687, 13, 12, '2018-10-22'),
(688, 14, 12, '2018-10-22'),
(689, 15, 12, '2018-10-22'),
(690, 16, 12, '2018-10-22'),
(691, 17, 12, '2018-10-22'),
(692, 18, 12, '2018-10-22'),
(693, 22, 12, '2018-10-22'),
(694, 23, 12, '2018-10-22'),
(695, 24, 12, '2018-10-22'),
(696, 25, 12, '2018-10-22'),
(697, 26, 12, '2018-10-22'),
(698, 27, 12, '2018-10-22'),
(699, 28, 12, '2018-10-22'),
(700, 29, 12, '2018-10-22'),
(701, 30, 12, '2018-10-22'),
(702, 34, 12, '2018-10-22'),
(703, 35, 12, '2018-10-22'),
(704, 36, 12, '2018-10-22'),
(705, 37, 12, '2018-10-22'),
(706, 38, 12, '2018-10-22'),
(707, 39, 24, '2018-10-22'),
(708, 40, 12, '2018-10-22'),
(709, 41, 12, '2018-10-22'),
(711, 58, 8, '2018-10-22'),
(712, 59, 8, '2018-10-22'),
(713, 60, 8, '2018-10-22'),
(714, 61, 8, '2018-10-22'),
(715, 62, 8, '2018-10-22'),
(716, 63, 8, '2018-10-22'),
(717, 64, 8, '2018-10-22'),
(718, 65, 8, '2018-10-22'),
(719, 66, 8, '2018-10-22'),
(720, 67, 8, '2018-10-22'),
(721, 68, 8, '2018-10-22'),
(723, 69, 8, '2018-10-22'),
(724, 58, 8, '2018-12-20'),
(725, 59, 8, '2018-12-20'),
(726, 60, 8, '2018-12-20'),
(727, 61, 8, '2018-12-20'),
(729, 63, 8, '2018-12-20'),
(730, 64, 8, '2018-12-20'),
(731, 65, 8, '2018-12-20'),
(732, 66, 8, '2018-12-20'),
(733, 67, 8, '2018-12-20'),
(734, 68, 8, '2018-12-20'),
(735, 69, 8, '2018-12-20'),
(736, 1, 12, '2018-12-20'),
(737, 2, 12, '2018-12-20'),
(738, 3, 12, '2018-12-20'),
(739, 4, 12, '2018-12-20'),
(740, 5, 12, '2018-12-20'),
(741, 6, 12, '2018-12-20'),
(742, 7, 12, '2018-12-20'),
(743, 8, 12, '2018-12-20'),
(744, 10, 12, '2018-12-20'),
(745, 11, 12, '2018-12-20'),
(746, 12, 12, '2018-12-20'),
(747, 13, 12, '2018-12-20'),
(748, 14, 12, '2018-12-20'),
(749, 15, 12, '2018-12-20'),
(750, 16, 12, '2018-12-20'),
(751, 17, 12, '2018-12-20'),
(752, 18, 12, '2018-12-20'),
(753, 22, 12, '2018-12-20'),
(754, 23, 12, '2018-12-20'),
(755, 24, 12, '2018-12-20'),
(756, 25, 12, '2018-12-20'),
(757, 26, 12, '2018-12-20'),
(759, 27, 12, '2018-12-20'),
(760, 28, 12, '2018-12-20'),
(761, 29, 12, '2018-12-20'),
(762, 30, 12, '2018-12-20'),
(763, 34, 12, '2018-12-20'),
(764, 35, 12, '2018-12-20'),
(765, 36, 12, '2018-12-20'),
(766, 37, 12, '2018-12-20'),
(768, 38, 12, '2018-12-20'),
(769, 39, 24, '2018-12-20'),
(770, 40, 12, '2018-12-20'),
(771, 41, 12, '2018-12-20'),
(775, 62, 8, '2018-12-20'),
(776, 1, 12, '2019-01-13'),
(777, 2, 12, '2019-01-13'),
(778, 3, 12, '2019-01-13'),
(779, 4, 12, '2019-01-13'),
(780, 5, 12, '2019-01-13'),
(781, 6, 12, '2019-01-13'),
(782, 7, 12, '2019-01-13'),
(783, 8, 12, '2019-01-13'),
(784, 10, 12, '2019-01-13'),
(785, 11, 12, '2019-01-13'),
(786, 12, 12, '2019-01-13'),
(787, 13, 12, '2019-01-13'),
(788, 14, 12, '2019-01-13'),
(789, 15, 12, '2019-01-13'),
(790, 16, 12, '2019-01-13'),
(791, 17, 12, '2019-01-13'),
(792, 18, 12, '2019-01-13'),
(793, 22, 12, '2019-01-13'),
(794, 23, 12, '2019-01-13'),
(795, 24, 12, '2019-01-13'),
(796, 25, 12, '2019-01-13'),
(797, 26, 12, '2019-01-13'),
(798, 27, 12, '2019-01-13'),
(799, 28, 12, '2019-01-13'),
(800, 29, 12, '2019-01-13'),
(801, 30, 12, '2019-01-13'),
(802, 34, 12, '2019-01-13'),
(803, 35, 12, '2019-01-13'),
(804, 36, 12, '2019-01-13'),
(805, 37, 12, '2019-01-13'),
(806, 38, 12, '2019-01-13'),
(807, 40, 12, '2019-01-13'),
(808, 41, 12, '2019-01-13'),
(809, 70, 24, '2019-01-13'),
(812, 58, 8, '2019-01-13'),
(813, 59, 8, '2019-01-13'),
(814, 60, 8, '2019-01-13'),
(815, 61, 8, '2019-01-13'),
(816, 62, 8, '2019-01-13'),
(817, 63, 8, '2019-01-13'),
(818, 64, 8, '2019-01-13'),
(819, 65, 8, '2019-01-13'),
(820, 66, 8, '2019-01-13'),
(821, 67, 8, '2019-01-13'),
(822, 68, 8, '2019-01-13'),
(823, 69, 8, '2019-01-13'),
(824, 1, 12, '2019-02-03'),
(825, 2, 12, '2019-02-03'),
(826, 3, 12, '2019-02-03'),
(827, 4, 12, '2019-02-03'),
(828, 5, 12, '2019-02-03'),
(829, 6, 12, '2019-02-03'),
(830, 7, 12, '2019-02-03'),
(831, 8, 12, '2019-02-03'),
(832, 10, 12, '2019-02-03'),
(833, 11, 12, '2019-02-03'),
(834, 12, 12, '2019-02-03'),
(835, 13, 12, '2019-02-03'),
(836, 14, 12, '2019-02-03'),
(837, 15, 12, '2019-02-03'),
(838, 16, 12, '2019-02-03'),
(839, 17, 12, '2019-02-03'),
(840, 18, 12, '2019-02-03'),
(841, 22, 12, '2019-02-03'),
(842, 23, 12, '2019-02-03'),
(843, 24, 12, '2019-02-03'),
(844, 25, 12, '2019-02-03'),
(845, 26, 12, '2019-02-03'),
(846, 27, 12, '2019-02-03'),
(847, 28, 12, '2019-02-03'),
(848, 29, 12, '2019-02-03'),
(849, 30, 12, '2019-02-03'),
(850, 34, 12, '2019-02-03'),
(851, 35, 12, '2019-02-03'),
(852, 36, 12, '2019-02-03'),
(853, 37, 12, '2019-02-03'),
(854, 38, 12, '2019-02-03'),
(855, 70, 24, '2019-02-03'),
(856, 40, 12, '2019-02-03'),
(857, 41, 12, '2019-02-03'),
(858, 58, 8, '2019-02-03'),
(859, 59, 8, '2019-02-03'),
(860, 60, 8, '2019-02-03'),
(861, 61, 8, '2019-02-03'),
(862, 62, 8, '2019-02-03'),
(863, 63, 8, '2019-02-03'),
(864, 64, 8, '2019-02-03'),
(865, 65, 8, '2019-02-03'),
(866, 66, 8, '2019-02-03'),
(867, 67, 8, '2019-02-03'),
(868, 68, 8, '2019-02-03'),
(869, 69, 8, '2019-02-03'),
(870, 1, 12, '2019-03-02'),
(871, 2, 12, '2019-03-02'),
(872, 3, 12, '2019-03-02'),
(873, 4, 12, '2019-03-02'),
(874, 5, 12, '2019-03-02'),
(875, 6, 12, '2019-03-02'),
(876, 7, 12, '2019-03-02'),
(877, 8, 12, '2019-03-02'),
(878, 10, 12, '2019-03-02'),
(879, 11, 12, '2019-03-02'),
(880, 12, 12, '2019-03-02'),
(881, 13, 12, '2019-03-02'),
(882, 14, 12, '2019-03-02'),
(883, 15, 12, '2019-03-02'),
(884, 16, 12, '2019-03-02'),
(885, 17, 12, '2019-03-02'),
(886, 18, 12, '2019-03-02'),
(887, 22, 12, '2019-03-02'),
(888, 23, 12, '2019-03-02'),
(889, 24, 12, '2019-03-02'),
(890, 25, 12, '2019-03-02'),
(891, 26, 12, '2019-03-02'),
(892, 27, 12, '2019-03-02'),
(893, 28, 12, '2019-03-02'),
(894, 29, 12, '2019-03-02'),
(895, 30, 12, '2019-03-02'),
(896, 34, 12, '2019-03-02'),
(897, 35, 12, '2019-03-02'),
(898, 36, 12, '2019-03-02'),
(899, 37, 12, '2019-03-02'),
(900, 38, 12, '2019-03-02'),
(901, 40, 12, '2019-03-02'),
(902, 41, 12, '2019-03-02'),
(903, 70, 24, '2019-03-02'),
(904, 58, 8, '2019-03-02'),
(905, 59, 8, '2019-03-02'),
(906, 60, 8, '2019-03-02'),
(907, 61, 8, '2019-03-02'),
(908, 62, 8, '2019-03-02'),
(909, 63, 8, '2019-03-02'),
(910, 64, 8, '2019-03-02'),
(911, 65, 8, '2019-03-02'),
(912, 66, 8, '2019-03-02'),
(913, 67, 8, '2019-03-02'),
(914, 68, 8, '2019-03-02'),
(915, 69, 8, '2019-03-02'),
(916, 1, 12, '2019-03-30'),
(917, 2, 12, '2019-03-30'),
(918, 3, 12, '2019-03-30'),
(919, 4, 12, '2019-03-30'),
(920, 5, 12, '2019-03-30'),
(921, 6, 12, '2019-03-30'),
(922, 7, 12, '2019-03-30'),
(923, 8, 12, '2019-03-30'),
(924, 10, 12, '2019-03-30'),
(925, 11, 12, '2019-03-30'),
(926, 12, 12, '2019-03-30'),
(927, 13, 12, '2019-03-30'),
(928, 14, 12, '2019-03-30'),
(929, 15, 12, '2019-03-30'),
(930, 16, 12, '2019-03-30'),
(931, 17, 12, '2019-03-30'),
(932, 18, 12, '2019-03-30'),
(933, 22, 12, '2019-03-30'),
(934, 23, 12, '2019-03-30'),
(935, 24, 12, '2019-03-30'),
(936, 25, 12, '2019-03-30'),
(937, 26, 12, '2019-03-30'),
(938, 27, 12, '2019-03-30'),
(939, 28, 12, '2019-03-30'),
(940, 29, 12, '2019-03-30'),
(941, 30, 12, '2019-03-30'),
(942, 34, 12, '2019-03-30'),
(943, 35, 12, '2019-03-30'),
(944, 36, 12, '2019-03-30'),
(945, 37, 12, '2019-03-30'),
(946, 38, 12, '2019-03-30'),
(947, 40, 12, '2019-03-30'),
(948, 41, 12, '2019-03-30'),
(949, 70, 24, '2019-03-30'),
(950, 58, 8, '2019-03-30'),
(951, 59, 8, '2019-03-30'),
(952, 60, 8, '2019-03-30'),
(953, 61, 8, '2019-03-30'),
(954, 62, 8, '2019-03-30'),
(955, 63, 8, '2019-03-30'),
(956, 64, 8, '2019-03-30'),
(957, 65, 8, '2019-03-30'),
(958, 66, 8, '2019-03-30'),
(959, 67, 8, '2019-03-30'),
(960, 68, 8, '2019-03-30'),
(961, 69, 8, '2019-03-30'),
(962, 1, 12, '2019-04-24'),
(963, 2, 12, '2019-04-24'),
(964, 3, 12, '2019-04-24'),
(965, 4, 12, '2019-04-24'),
(966, 5, 12, '2019-04-24'),
(967, 6, 12, '2019-04-24'),
(968, 7, 12, '2019-04-24'),
(969, 8, 12, '2019-04-24'),
(970, 10, 12, '2019-04-24'),
(971, 11, 12, '2019-04-24'),
(972, 12, 12, '2019-04-24'),
(973, 13, 12, '2019-04-24'),
(974, 14, 12, '2019-04-24'),
(975, 15, 12, '2019-04-24'),
(976, 16, 12, '2019-04-24'),
(977, 17, 12, '2019-04-24'),
(978, 18, 12, '2019-04-24'),
(979, 22, 12, '2019-04-24'),
(980, 23, 12, '2019-04-24'),
(981, 24, 12, '2019-04-24'),
(982, 25, 12, '2019-04-24'),
(983, 26, 12, '2019-04-24'),
(984, 27, 12, '2019-04-24'),
(985, 28, 12, '2019-04-24'),
(986, 29, 12, '2019-04-24'),
(987, 30, 12, '2019-04-24'),
(988, 34, 12, '2019-04-24'),
(989, 35, 12, '2019-04-24'),
(990, 36, 12, '2019-04-24'),
(991, 37, 12, '2019-04-24'),
(992, 38, 12, '2019-04-24'),
(994, 40, 12, '2019-04-24'),
(995, 41, 12, '2019-04-24'),
(996, 70, 24, '2019-04-24'),
(997, 58, 8, '2019-04-24'),
(998, 59, 8, '2019-04-24'),
(999, 60, 8, '2019-04-24'),
(1000, 61, 8, '2019-04-24'),
(1001, 62, 8, '2019-04-24'),
(1002, 63, 8, '2019-04-24'),
(1003, 64, 8, '2019-04-24'),
(1004, 65, 8, '2019-04-24'),
(1005, 66, 8, '2019-04-24'),
(1006, 67, 8, '2019-04-24'),
(1007, 68, 8, '2019-04-24'),
(1008, 69, 8, '2019-04-24'),
(1009, 1, 12, '2019-05-22'),
(1010, 2, 12, '2019-05-22'),
(1011, 3, 12, '2019-05-22'),
(1012, 4, 12, '2019-05-22'),
(1013, 5, 12, '2019-05-22'),
(1014, 6, 12, '2019-05-22'),
(1015, 7, 12, '2019-05-22'),
(1016, 8, 12, '2019-05-22'),
(1017, 10, 12, '2019-05-22'),
(1018, 11, 12, '2019-05-22'),
(1019, 12, 12, '2019-05-22'),
(1020, 13, 12, '2019-05-22'),
(1021, 14, 12, '2019-05-22'),
(1022, 15, 12, '2019-05-22'),
(1023, 16, 12, '2019-05-22'),
(1024, 17, 12, '2019-05-22'),
(1025, 18, 12, '2019-05-22'),
(1026, 22, 12, '2019-05-22'),
(1027, 23, 12, '2019-05-22'),
(1028, 24, 12, '2019-05-22'),
(1029, 25, 12, '2019-05-22'),
(1030, 26, 12, '2019-05-22'),
(1031, 27, 12, '2019-05-22'),
(1032, 28, 12, '2019-05-22'),
(1033, 29, 12, '2019-05-22'),
(1034, 30, 12, '2019-05-22'),
(1035, 34, 12, '2019-05-22'),
(1036, 35, 12, '2019-05-22'),
(1037, 36, 12, '2019-05-22'),
(1038, 37, 12, '2019-05-22'),
(1039, 38, 12, '2019-05-22'),
(1041, 40, 12, '2019-05-22'),
(1042, 41, 12, '2019-05-22'),
(1043, 70, 24, '2019-05-22'),
(1044, 58, 8, '2019-05-22'),
(1045, 59, 8, '2019-05-22'),
(1046, 60, 8, '2019-05-22'),
(1047, 61, 8, '2019-05-22'),
(1048, 62, 8, '2019-05-22'),
(1049, 63, 8, '2019-05-22'),
(1050, 64, 8, '2019-05-22'),
(1051, 65, 8, '2019-05-22'),
(1052, 66, 8, '2019-05-22'),
(1053, 67, 8, '2019-05-22'),
(1054, 68, 8, '2019-05-22'),
(1055, 69, 8, '2019-05-22'),
(1056, 1, 12, '2019-06-25'),
(1057, 2, 12, '2019-06-25'),
(1058, 3, 12, '2019-06-25'),
(1059, 4, 12, '2019-06-25'),
(1060, 5, 12, '2019-06-25'),
(1061, 6, 12, '2019-06-25'),
(1062, 7, 12, '2019-06-25'),
(1063, 8, 12, '2019-06-25'),
(1064, 10, 12, '2019-06-25'),
(1065, 11, 12, '2019-06-25'),
(1066, 12, 12, '2019-06-25'),
(1067, 13, 12, '2019-06-25'),
(1068, 14, 12, '2019-06-25'),
(1069, 15, 12, '2019-06-25'),
(1070, 16, 12, '2019-06-25'),
(1071, 17, 12, '2019-06-25'),
(1072, 18, 12, '2019-06-25'),
(1073, 22, 12, '2019-06-25'),
(1074, 23, 12, '2019-06-25'),
(1075, 24, 12, '2019-06-25'),
(1076, 25, 12, '2019-06-25'),
(1077, 26, 12, '2019-06-25'),
(1078, 27, 12, '2019-06-25'),
(1079, 28, 12, '2019-06-25'),
(1080, 29, 12, '2019-06-25'),
(1081, 30, 12, '2019-06-25'),
(1082, 34, 12, '2019-06-25'),
(1083, 35, 12, '2019-06-25'),
(1084, 36, 12, '2019-06-25'),
(1085, 37, 12, '2019-06-25'),
(1086, 38, 12, '2019-06-25'),
(1087, 40, 12, '2019-06-25'),
(1088, 41, 12, '2019-06-25'),
(1090, 58, 8, '2019-06-25'),
(1091, 59, 8, '2019-06-25'),
(1092, 60, 8, '2019-06-25'),
(1093, 61, 8, '2019-06-25'),
(1094, 62, 8, '2019-06-25'),
(1095, 63, 8, '2019-06-25'),
(1096, 64, 8, '2019-06-25'),
(1097, 65, 8, '2019-06-25'),
(1098, 66, 8, '2019-06-25'),
(1099, 67, 8, '2019-06-25'),
(1100, 68, 8, '2019-06-25'),
(1101, 69, 8, '2019-06-25'),
(1102, 39, 12, '2019-06-25'),
(1103, 42, 12, '2019-06-25');

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

--
-- Table structure for table `monthly_target`
--

CREATE TABLE `monthly_target` (
  `target_id` int(11) NOT NULL,
  `department_id` smallint(6) NOT NULL,
  `target_date` varchar(255) NOT NULL,
  `target_number` int(11) NOT NULL,
  `man_power` int(11) NOT NULL DEFAULT 0,
  `note` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `monthly_target`
--

INSERT INTO `monthly_target` (`target_id`, `department_id`, `target_date`, `target_number`, `man_power`, `note`) VALUES
(1, 1, '2017-10-29', 1, 4, NULL),
(2, 2, '2017-10-29', 1, 13, NULL),
(3, 4, '2017-10-29', 1, 6, NULL),
(4, 9, '2017-10-29', 1, 7, NULL),
(5, 3, '2017-10-29', 9, 175, NULL),
(6, 7, '2017-10-29', 1, 9, NULL),
(7, 8, '2017-10-29', 1, 12, NULL),
(8, 10, '2017-10-29', 14, 143, NULL),
(9, 12, '2017-10-29', 24, 597, NULL),
(10, 13, '2017-10-29', 27, 662, NULL),
(11, 14, '2017-10-29', 27, 671, NULL),
(12, 15, '2017-10-29', 27, 693, NULL),
(13, 16, '2017-10-29', 12, 273, NULL),
(14, 17, '2017-10-29', 12, 273, NULL),
(15, 18, '2017-10-29', 14, 125, NULL),
(16, 19, '2017-10-29', 10, 182, NULL),
(17, 20, '2017-10-29', 3, 32, NULL),
(18, 21, '2017-10-29', 8, 72, NULL),
(19, 22, '2017-10-29', 6, 25, NULL),
(20, 9, '2017-11-06', 1, 7, NULL),
(21, 1, '2017-11-06', 1, 4, NULL),
(22, 2, '2017-11-06', 1, 13, NULL),
(23, 3, '2017-11-06', 9, 175, NULL),
(24, 4, '2017-11-06', 1, 6, NULL),
(25, 7, '2017-11-06', 1, 9, NULL),
(26, 8, '2017-11-06', 1, 12, NULL),
(27, 10, '2017-11-06', 14, 143, NULL),
(28, 12, '2017-11-06', 24, 597, NULL),
(29, 13, '2017-11-06', 27, 662, NULL),
(30, 14, '2017-11-06', 27, 671, NULL),
(31, 15, '2017-11-06', 27, 693, NULL),
(32, 16, '2017-11-06', 12, 273, NULL),
(33, 17, '2017-11-06', 12, 273, NULL),
(34, 18, '2017-11-06', 14, 125, NULL),
(35, 19, '2017-11-06', 10, 182, NULL),
(36, 20, '2017-11-06', 3, 32, NULL),
(37, 21, '2017-11-06', 8, 72, NULL),
(38, 22, '2017-11-06', 6, 25, NULL),
(39, 1, '2017-11-13', 1, 4, NULL),
(40, 2, '2017-11-13', 1, 13, NULL),
(41, 3, '2017-11-13', 9, 175, NULL),
(42, 4, '2017-11-13', 1, 6, NULL),
(43, 7, '2017-11-13', 1, 9, NULL),
(44, 8, '2017-11-13', 1, 12, NULL),
(45, 9, '2017-11-13', 1, 7, NULL),
(46, 10, '2017-11-13', 14, 143, NULL),
(47, 12, '2017-11-13', 24, 597, NULL),
(48, 13, '2017-11-13', 27, 662, NULL),
(49, 14, '2017-11-13', 27, 671, NULL),
(50, 15, '2017-11-13', 27, 693, NULL),
(51, 16, '2017-11-13', 12, 273, NULL),
(52, 17, '2017-11-13', 12, 273, NULL),
(53, 18, '2017-11-13', 14, 125, NULL),
(54, 19, '2017-11-13', 10, 182, NULL),
(55, 20, '2017-11-13', 3, 32, NULL),
(56, 21, '2017-11-13', 8, 72, NULL),
(57, 22, '2017-11-13', 6, 25, NULL),
(58, 1, '2017-11-23', 1, 4, NULL),
(59, 2, '2017-11-23', 1, 13, NULL),
(60, 3, '2017-11-23', 9, 175, NULL),
(61, 4, '2017-11-23', 1, 6, NULL),
(62, 7, '2017-11-23', 1, 9, NULL),
(63, 8, '2017-11-23', 1, 12, NULL),
(64, 9, '2017-11-23', 1, 7, NULL),
(65, 10, '2017-11-23', 14, 143, NULL),
(66, 12, '2017-11-23', 24, 597, NULL),
(67, 13, '2017-11-23', 27, 662, NULL),
(68, 14, '2017-11-23', 27, 671, NULL),
(69, 15, '2017-11-23', 27, 693, NULL),
(70, 16, '2017-11-23', 12, 273, NULL),
(71, 17, '2017-11-23', 12, 273, NULL),
(72, 18, '2017-11-23', 14, 143, NULL),
(73, 19, '2017-11-23', 10, 182, NULL),
(74, 20, '2017-11-23', 3, 32, NULL),
(75, 21, '2017-11-23', 8, 72, NULL),
(76, 22, '2017-11-23', 5, 23, NULL),
(77, 1, '2017-11-29', 1, 4, NULL),
(78, 2, '2017-11-29', 1, 12, NULL),
(79, 3, '2017-11-29', 9, 175, NULL),
(80, 4, '2017-11-29', 1, 6, NULL),
(81, 7, '2017-11-29', 1, 9, NULL),
(82, 8, '2017-11-29', 1, 12, NULL),
(83, 9, '2017-11-29', 1, 7, NULL),
(84, 10, '2017-11-29', 14, 143, NULL),
(85, 12, '2017-11-29', 24, 597, NULL),
(86, 13, '2017-11-29', 27, 662, NULL),
(87, 14, '2017-11-29', 27, 671, NULL),
(88, 15, '2017-11-29', 27, 693, NULL),
(89, 16, '2017-11-29', 12, 275, NULL),
(90, 17, '2017-11-29', 12, 273, NULL),
(91, 18, '2017-11-29', 14, 125, NULL),
(92, 19, '2017-11-29', 10, 182, NULL),
(93, 20, '2017-11-29', 3, 32, NULL),
(94, 21, '2017-11-29', 8, 72, NULL),
(95, 22, '2017-11-29', 5, 25, NULL),
(96, 1, '2017-12-08', 1, 4, NULL),
(97, 1, '2017-12-17', 1, 4, NULL),
(98, 2, '2017-12-08', 1, 12, NULL),
(99, 2, '2017-12-18', 1, 12, NULL),
(100, 3, '2017-12-08', 9, 175, NULL),
(101, 3, '2017-12-18', 9, 175, NULL),
(102, 4, '2017-12-18', 1, 6, NULL),
(103, 4, '2017-12-08', 1, 6, NULL),
(104, 7, '2017-12-18', 1, 9, NULL),
(105, 7, '2017-12-08', 1, 9, NULL),
(106, 8, '2017-12-08', 1, 12, NULL),
(107, 8, '2017-12-18', 1, 12, NULL),
(108, 9, '2017-12-18', 1, 7, NULL),
(109, 9, '2017-12-08', 1, 7, NULL),
(110, 10, '2017-12-18', 14, 143, NULL),
(111, 10, '2017-12-08', 14, 143, NULL),
(112, 12, '2017-12-18', 24, 597, NULL),
(113, 12, '2017-12-08', 24, 597, NULL),
(114, 13, '2017-12-18', 27, 662, NULL),
(115, 13, '2017-12-08', 27, 662, NULL),
(116, 14, '2017-12-08', 27, 671, NULL),
(117, 14, '2017-12-18', 27, 671, NULL),
(118, 15, '2017-12-18', 27, 693, NULL),
(119, 15, '2017-12-08', 27, 693, NULL),
(120, 16, '2017-12-18', 12, 275, NULL),
(121, 17, '2017-12-08', 12, 275, NULL),
(122, 17, '2017-12-18', 12, 275, NULL),
(123, 16, '2017-12-08', 12, 275, NULL),
(124, 18, '2017-12-18', 14, 125, NULL),
(125, 18, '2017-12-08', 14, 125, NULL),
(126, 19, '2017-12-18', 10, 182, NULL),
(127, 19, '2017-12-08', 10, 182, NULL),
(128, 20, '2017-12-18', 3, 32, NULL),
(129, 20, '2017-12-08', 3, 32, NULL),
(130, 21, '2017-12-18', 8, 72, NULL),
(131, 21, '2017-12-08', 8, 72, NULL),
(132, 22, '2017-12-18', 5, 25, NULL),
(133, 22, '2017-12-08', 5, 25, NULL),
(134, 1, '2017-12-24', 1, 4, NULL),
(135, 2, '2017-12-24', 1, 12, NULL),
(136, 3, '2017-12-24', 9, 175, NULL),
(137, 4, '2017-12-24', 1, 6, NULL),
(138, 7, '2017-12-24', 1, 9, NULL),
(139, 8, '2017-12-24', 1, 12, NULL),
(140, 9, '2017-12-24', 1, 7, NULL),
(141, 10, '2017-12-24', 14, 143, NULL),
(142, 12, '2017-12-24', 24, 597, NULL),
(143, 13, '2017-12-24', 27, 662, NULL),
(144, 14, '2017-12-24', 27, 671, NULL),
(145, 15, '2017-12-24', 27, 693, NULL),
(146, 16, '2017-12-24', 12, 275, NULL),
(147, 17, '2017-12-24', 12, 275, NULL),
(148, 18, '2017-12-24', 14, 125, NULL),
(149, 19, '2017-12-24', 10, 182, NULL),
(150, 20, '2017-12-24', 3, 32, NULL),
(151, 21, '2017-12-24', 8, 72, NULL),
(152, 22, '2017-12-24', 5, 24, NULL),
(153, 1, '2017-12-31', 1, 4, NULL),
(154, 2, '2017-12-31', 1, 12, NULL),
(155, 3, '2017-12-31', 9, 175, NULL),
(156, 4, '2017-12-31', 1, 6, NULL),
(157, 7, '2017-12-31', 1, 9, NULL),
(158, 8, '2017-12-31', 1, 12, NULL),
(159, 9, '2017-12-31', 1, 6, NULL),
(160, 10, '2017-12-31', 14, 143, NULL),
(161, 12, '2017-12-31', 24, 597, NULL),
(162, 13, '2017-12-31', 27, 662, NULL),
(163, 14, '2017-12-31', 27, 671, NULL),
(164, 15, '2017-12-31', 27, 693, NULL),
(165, 16, '2017-12-31', 12, 275, NULL),
(166, 17, '2017-12-31', 12, 275, NULL),
(167, 18, '2017-12-31', 14, 125, NULL),
(168, 19, '2017-12-31', 10, 182, NULL),
(169, 20, '2017-12-31', 3, 33, NULL),
(170, 21, '2017-12-31', 8, 72, NULL),
(171, 22, '2017-12-31', 3, 24, NULL),
(172, 1, '2018-01-12', 1, 4, NULL),
(173, 2, '2018-01-12', 1, 12, NULL),
(174, 3, '2018-01-11', 9, 175, NULL),
(175, 4, '2018-01-11', 1, 6, NULL),
(176, 7, '2018-01-11', 1, 9, NULL),
(177, 8, '2018-01-11', 1, 12, NULL),
(178, 9, '2018-01-10', 1, 6, NULL),
(179, 10, '2018-01-12', 14, 143, NULL),
(180, 12, '2018-01-12', 24, 597, NULL),
(181, 13, '2018-01-12', 27, 662, NULL),
(182, 14, '2018-01-11', 27, 671, NULL),
(183, 15, '2018-01-12', 27, 693, NULL),
(184, 16, '2018-01-12', 12, 275, NULL),
(185, 17, '2018-01-11', 12, 275, NULL),
(186, 18, '2018-01-11', 14, 125, NULL),
(187, 19, '2018-01-11', 10, 181, NULL),
(188, 20, '2018-01-11', 3, 33, NULL),
(189, 21, '2018-01-11', 8, 72, NULL),
(190, 22, '2018-01-11', 3, 21, NULL),
(191, 1, '2018-01-17', 1, 4, NULL),
(192, 2, '2018-01-17', 1, 12, NULL),
(193, 3, '2018-01-17', 9, 175, NULL),
(194, 4, '2018-01-17', 1, 6, NULL),
(195, 7, '2018-01-17', 1, 9, NULL),
(196, 8, '2018-01-17', 1, 12, NULL),
(197, 9, '2018-01-17', 1, 6, NULL),
(198, 10, '2018-01-17', 14, 143, NULL),
(199, 12, '2018-01-17', 24, 597, NULL),
(200, 13, '2018-01-17', 27, 662, NULL),
(201, 14, '2018-01-17', 27, 671, NULL),
(202, 15, '2018-01-17', 27, 693, NULL),
(203, 16, '2018-01-17', 12, 275, NULL),
(204, 17, '2018-01-17', 12, 275, NULL),
(205, 18, '2018-01-17', 14, 125, NULL),
(206, 19, '2018-01-17', 10, 181, NULL),
(207, 20, '2018-01-17', 3, 32, NULL),
(208, 22, '2018-01-17', 4, 19, NULL),
(209, 21, '2018-01-17', 8, 72, NULL),
(210, 1, '2018-02-04', 1, 4, NULL),
(211, 2, '2018-02-04', 1, 12, NULL),
(212, 3, '2018-02-04', 9, 175, NULL),
(213, 4, '2018-02-04', 1, 6, NULL),
(214, 7, '2018-02-04', 1, 9, NULL),
(215, 8, '2018-02-04', 1, 12, NULL),
(216, 9, '2018-02-04', 1, 6, NULL),
(217, 10, '2018-02-04', 14, 143, NULL),
(218, 12, '2018-02-04', 24, 597, NULL),
(219, 13, '2018-02-04', 27, 662, NULL),
(220, 14, '2018-02-04', 27, 671, NULL),
(221, 15, '2018-02-04', 27, 693, NULL),
(222, 18, '2018-02-04', 14, 125, NULL),
(223, 19, '2018-02-04', 10, 181, NULL),
(224, 20, '2018-02-04', 3, 32, NULL),
(225, 21, '2018-02-04', 8, 72, NULL),
(226, 22, '2018-02-04', 4, 19, NULL),
(227, 23, '2018-02-04', 2, 9, NULL),
(228, 1, '2018-01-25', 1, 4, NULL),
(229, 2, '2018-01-25', 1, 12, NULL),
(230, 3, '2018-01-25', 9, 175, NULL),
(231, 4, '2018-01-24', 1, 6, NULL),
(232, 7, '2018-01-25', 1, 9, NULL),
(233, 9, '2018-01-24', 1, 6, NULL),
(234, 8, '2018-01-25', 1, 12, NULL),
(235, 10, '2018-01-24', 14, 143, NULL),
(236, 12, '2018-01-24', 24, 597, NULL),
(237, 13, '2018-01-24', 27, 662, NULL),
(238, 14, '2018-01-25', 27, 671, NULL),
(239, 15, '2018-01-25', 27, 693, NULL),
(240, 18, '2018-01-24', 14, 125, NULL),
(241, 19, '2018-01-24', 10, 181, NULL),
(242, 20, '2018-01-25', 3, 32, NULL),
(243, 21, '2018-01-25', 8, 72, NULL),
(244, 22, '2018-01-24', 5, 19, NULL),
(245, 23, '2018-01-25', 2, 9, NULL),
(246, 1, '2018-02-11', 1, 4, NULL),
(247, 2, '2018-02-11', 1, 12, NULL),
(248, 3, '2018-02-11', 9, 175, NULL),
(249, 4, '2018-02-11', 1, 6, NULL),
(250, 7, '2018-02-11', 1, 9, NULL),
(251, 8, '2018-02-11', 1, 12, NULL),
(252, 9, '2018-02-11', 1, 6, NULL),
(253, 10, '2018-02-11', 14, 143, NULL),
(254, 12, '2018-02-11', 24, 597, NULL),
(255, 13, '2018-02-11', 27, 662, NULL),
(256, 14, '2018-02-11', 27, 671, NULL),
(257, 15, '2018-02-11', 27, 693, NULL),
(258, 18, '2018-02-12', 14, 125, NULL),
(259, 19, '2018-02-12', 10, 181, NULL),
(260, 20, '2018-02-12', 3, 32, NULL),
(261, 21, '2018-02-12', 8, 72, NULL),
(262, 22, '2018-02-12', 3, 20, NULL),
(263, 23, '2018-02-12', 2, 9, NULL),
(264, 24, '2018-02-12', 24, 550, NULL),
(265, 24, '2018-02-02', 24, 550, NULL),
(266, 24, '2018-01-23', 24, 550, NULL),
(267, 1, '2018-02-18', 1, 4, NULL),
(268, 2, '2018-02-15', 1, 12, NULL),
(269, 3, '2018-02-15', 9, 175, NULL),
(270, 4, '2018-02-15', 1, 6, NULL),
(271, 7, '2018-02-15', 1, 9, NULL),
(272, 8, '2018-02-16', 1, 12, NULL),
(273, 9, '2018-02-16', 1, 6, NULL),
(274, 10, '2018-02-17', 14, 143, NULL),
(275, 12, '2018-02-16', 24, 597, NULL),
(276, 13, '2018-02-16', 27, 662, NULL),
(277, 14, '2018-02-16', 27, 671, NULL),
(278, 15, '2018-02-16', 27, 693, NULL),
(279, 18, '2018-02-16', 14, 125, NULL),
(280, 19, '2018-02-16', 10, 181, NULL),
(281, 20, '2018-02-16', 3, 32, NULL),
(282, 21, '2018-02-16', 8, 72, NULL),
(283, 22, '2018-02-16', 4, 20, NULL),
(284, 23, '2018-02-15', 2, 9, NULL),
(285, 24, '2018-02-16', 24, 550, NULL),
(286, 1, '2018-02-25', 1, 4, NULL),
(287, 2, '2018-02-25', 1, 12, NULL),
(288, 3, '2018-02-25', 9, 175, NULL),
(289, 4, '2018-02-25', 1, 6, NULL),
(290, 7, '2018-02-25', 1, 9, NULL),
(291, 8, '2018-02-25', 1, 12, NULL),
(292, 9, '2018-02-25', 1, 6, NULL),
(293, 10, '2018-02-25', 14, 143, NULL),
(294, 12, '2018-02-25', 24, 597, NULL),
(295, 13, '2018-02-25', 27, 662, NULL),
(296, 14, '2018-02-25', 27, 671, NULL),
(297, 15, '2018-02-25', 27, 693, NULL),
(298, 18, '2018-02-25', 14, 125, NULL),
(299, 19, '2018-02-25', 10, 181, NULL),
(300, 20, '2018-02-25', 3, 32, NULL),
(301, 21, '2018-02-25', 8, 72, NULL),
(302, 22, '2018-02-25', 3, 21, NULL),
(303, 23, '2018-02-25', 2, 9, NULL),
(304, 24, '2018-02-25', 24, 550, NULL),
(305, 1, '2018-03-01', 1, 4, NULL),
(306, 2, '2018-03-01', 1, 12, NULL),
(307, 3, '2018-03-01', 9, 175, NULL),
(308, 4, '2018-03-01', 1, 6, NULL),
(309, 7, '2018-03-01', 1, 9, NULL),
(310, 8, '2018-03-01', 1, 12, NULL),
(311, 9, '2018-03-01', 1, 6, NULL),
(312, 10, '2018-03-01', 14, 143, NULL),
(313, 12, '2018-03-01', 24, 597, NULL),
(314, 13, '2018-03-01', 27, 662, NULL),
(315, 14, '2018-03-01', 27, 671, NULL),
(316, 15, '2018-03-01', 27, 693, NULL),
(317, 18, '2018-03-01', 14, 125, NULL),
(318, 19, '2018-03-02', 10, 181, NULL),
(319, 20, '2018-03-01', 3, 32, NULL),
(320, 21, '2018-03-02', 8, 72, NULL),
(321, 22, '2018-03-02', 5, 21, NULL),
(322, 23, '2018-03-02', 2, 9, NULL),
(323, 24, '2018-03-02', 24, 550, NULL),
(324, 1, '2018-03-11', 1, 4, NULL),
(325, 2, '2018-03-11', 1, 12, NULL),
(326, 2, '2018-03-11', 1, 12, NULL),
(327, 3, '2018-03-11', 9, 175, NULL),
(328, 4, '2018-03-11', 1, 6, NULL),
(329, 7, '2018-03-11', 1, 9, NULL),
(330, 8, '2018-03-11', 1, 12, NULL),
(331, 9, '2018-03-11', 1, 6, NULL),
(332, 10, '2018-03-11', 14, 143, NULL),
(333, 12, '2018-03-11', 24, 597, NULL),
(334, 13, '2018-03-11', 27, 662, NULL),
(335, 14, '2018-03-11', 27, 671, NULL),
(336, 15, '2018-03-11', 27, 693, NULL),
(337, 18, '2018-03-11', 14, 125, NULL),
(338, 19, '2018-03-11', 10, 181, NULL),
(339, 20, '2018-03-11', 3, 32, NULL),
(340, 21, '2018-03-11', 8, 72, NULL),
(341, 22, '2018-03-11', 5, 21, NULL),
(342, 23, '2018-03-11', 1, 9, NULL),
(344, 1, '2018-03-15', 1, 4, NULL),
(345, 2, '2018-03-15', 1, 12, NULL),
(346, 3, '2018-03-14', 9, 175, NULL),
(347, 4, '2018-03-14', 1, 6, NULL),
(348, 7, '2018-03-15', 1, 9, NULL),
(349, 8, '2018-03-15', 1, 12, NULL),
(350, 9, '2018-03-15', 1, 6, NULL),
(351, 10, '2018-03-15', 14, 143, NULL),
(352, 12, '2018-03-15', 24, 597, NULL),
(353, 13, '2018-03-15', 27, 671, NULL),
(354, 14, '2018-03-15', 27, 671, NULL),
(355, 15, '2018-03-15', 27, 693, NULL),
(356, 18, '2018-03-15', 14, 125, NULL),
(357, 19, '2018-03-15', 10, 181, NULL),
(358, 20, '2018-03-15', 3, 32, NULL),
(359, 21, '2018-03-15', 8, 72, NULL),
(360, 22, '2018-03-15', 3, 21, NULL),
(361, 23, '2018-03-15', 1, 9, NULL),
(362, 24, '2018-03-11', 24, 550, NULL),
(363, 24, '2018-03-20', 24, 550, NULL),
(364, 1, '2018-03-24', 1, 4, NULL),
(365, 2, '2018-03-24', 1, 12, NULL),
(366, 3, '2018-03-24', 9, 175, NULL),
(367, 4, '2018-03-24', 1, 6, NULL),
(368, 7, '2018-03-24', 1, 9, NULL),
(369, 8, '2018-03-24', 1, 12, NULL),
(370, 9, '2018-03-24', 1, 6, NULL),
(371, 10, '2018-03-24', 14, 143, NULL),
(373, 12, '2018-03-24', 24, 597, NULL),
(374, 13, '2018-03-24', 27, 662, NULL),
(375, 14, '2018-03-24', 27, 671, NULL),
(376, 15, '2018-03-24', 27, 693, NULL),
(377, 24, '2018-03-24', 24, 500, NULL),
(378, 18, '2018-03-24', 14, 125, NULL),
(379, 19, '2018-03-24', 10, 181, NULL),
(380, 20, '2018-03-24', 3, 32, NULL),
(381, 21, '2018-03-24', 8, 72, NULL),
(382, 22, '2018-03-24', 5, 21, NULL),
(383, 23, '2018-03-24', 1, 9, NULL),
(384, 1, '2018-04-02', 1, 4, NULL),
(385, 2, '2018-04-02', 1, 12, NULL),
(386, 3, '2018-04-02', 9, 175, NULL),
(387, 4, '2018-04-02', 1, 6, NULL),
(388, 7, '2018-04-02', 1, 9, NULL),
(389, 8, '2018-04-02', 1, 12, NULL),
(390, 9, '2018-04-02', 1, 6, NULL),
(391, 10, '2018-04-02', 14, 143, NULL),
(392, 12, '2018-04-02', 24, 597, NULL),
(393, 13, '2018-04-02', 27, 662, NULL),
(394, 14, '2018-04-02', 27, 671, NULL),
(395, 15, '2018-04-02', 27, 693, NULL),
(396, 18, '2018-04-02', 14, 125, NULL),
(397, 19, '2018-04-02', 10, 181, NULL),
(398, 20, '2018-04-02', 3, 32, NULL),
(399, 21, '2018-04-02', 8, 72, NULL),
(400, 22, '2018-04-02', 3, 22, NULL),
(401, 23, '2018-04-02', 2, 9, NULL),
(402, 24, '2018-04-02', 24, 500, NULL),
(403, 1, '2018-04-09', 1, 6, NULL),
(404, 2, '2018-04-09', 1, 12, NULL),
(405, 3, '2018-04-09', 9, 175, NULL),
(406, 4, '2018-04-09', 1, 6, NULL),
(407, 7, '2018-04-09', 1, 9, NULL),
(408, 8, '2018-04-09', 1, 12, NULL),
(409, 9, '2018-04-09', 1, 6, NULL),
(410, 10, '2018-04-09', 14, 143, NULL),
(411, 12, '2018-04-09', 24, 597, NULL),
(412, 13, '2018-04-09', 27, 662, NULL),
(413, 14, '2018-04-09', 27, 671, NULL),
(414, 15, '2018-04-09', 27, 693, NULL),
(415, 18, '2018-04-09', 14, 125, NULL),
(416, 19, '2018-04-09', 10, 181, NULL),
(417, 20, '2018-04-09', 3, 32, NULL),
(418, 21, '2018-04-09', 8, 72, NULL),
(419, 22, '2018-04-09', 5, 22, NULL),
(420, 23, '2018-04-09', 2, 9, NULL),
(421, 24, '2018-04-09', 24, 500, NULL),
(422, 1, '2018-04-15', 1, 6, NULL),
(423, 2, '2018-04-15', 1, 12, NULL),
(424, 3, '2018-04-15', 9, 175, NULL),
(425, 4, '2018-04-15', 1, 6, NULL),
(426, 7, '2018-04-15', 1, 9, NULL),
(427, 8, '2018-04-15', 1, 12, NULL),
(428, 9, '2018-04-15', 1, 6, NULL),
(429, 10, '2018-04-15', 14, 143, NULL),
(430, 12, '2018-04-15', 24, 597, NULL),
(431, 13, '2018-04-15', 27, 662, NULL),
(432, 14, '2018-04-15', 27, 671, NULL),
(433, 15, '2018-04-15', 27, 693, NULL),
(434, 18, '2018-04-15', 14, 125, NULL),
(435, 19, '2018-04-15', 10, 181, NULL),
(436, 20, '2018-04-15', 3, 32, NULL),
(437, 21, '2018-04-15', 8, 72, NULL),
(438, 22, '2018-04-15', 5, 23, NULL),
(439, 23, '2018-04-15', 2, 9, NULL),
(440, 24, '2018-04-15', 24, 500, NULL),
(441, 1, '2018-04-23', 1, 7, NULL),
(442, 2, '2018-04-23', 1, 13, NULL),
(443, 4, '2018-04-23', 1, 6, NULL),
(444, 7, '2018-04-23', 1, 9, NULL),
(445, 8, '2018-04-23', 1, 12, NULL),
(446, 3, '2018-04-23', 8, 155, NULL),
(447, 9, '2018-04-23', 1, 6, NULL),
(448, 10, '2018-04-23', 14, 143, NULL),
(449, 12, '2018-04-23', 24, 597, NULL),
(450, 13, '2018-04-23', 27, 662, NULL),
(451, 14, '2018-04-23', 27, 671, NULL),
(452, 15, '2018-04-23', 27, 693, NULL),
(453, 18, '2018-04-23', 14, 125, NULL),
(454, 19, '2018-04-23', 10, 181, NULL),
(455, 20, '2018-04-23', 3, 32, NULL),
(456, 21, '2018-04-23', 10, 96, NULL),
(457, 22, '2018-04-23', 3, 25, NULL),
(458, 23, '2018-04-23', 2, 9, NULL),
(459, 24, '2018-04-23', 24, 500, NULL),
(460, 1, '2018-04-30', 1, 6, NULL),
(461, 2, '2018-04-30', 1, 12, NULL),
(462, 3, '2018-04-30', 8, 155, NULL),
(463, 4, '2018-04-30', 1, 6, NULL),
(464, 7, '2018-04-30', 1, 9, NULL),
(465, 8, '2018-04-30', 1, 12, NULL),
(466, 9, '2018-04-30', 1, 6, NULL),
(467, 10, '2018-04-30', 14, 143, NULL),
(468, 12, '2018-04-30', 24, 597, NULL),
(469, 13, '2018-04-30', 27, 662, NULL),
(470, 14, '2018-04-30', 27, 671, NULL),
(471, 15, '2018-04-30', 27, 693, NULL),
(472, 18, '2018-04-30', 14, 125, NULL),
(473, 19, '2018-04-30', 10, 181, NULL),
(474, 20, '2018-04-30', 3, 32, NULL),
(475, 21, '2018-04-30', 10, 96, NULL),
(476, 22, '2018-04-30', 5, 25, NULL),
(477, 23, '2018-04-30', 2, 9, NULL),
(478, 24, '2018-04-30', 24, 500, NULL),
(479, 1, '2018-05-06', 1, 7, NULL),
(480, 2, '2018-05-06', 1, 11, NULL),
(481, 3, '2018-05-06', 8, 155, NULL),
(482, 4, '2018-05-06', 1, 8, NULL),
(483, 7, '2018-05-06', 1, 9, NULL),
(484, 8, '2018-05-06', 1, 12, NULL),
(485, 9, '2018-05-06', 1, 6, NULL),
(486, 10, '2018-05-06', 14, 143, NULL),
(487, 12, '2018-05-06', 24, 597, NULL),
(488, 13, '2018-05-06', 27, 662, NULL),
(489, 14, '2018-05-06', 27, 671, NULL),
(490, 15, '2018-05-06', 27, 693, NULL),
(491, 18, '2018-05-06', 14, 125, NULL),
(492, 19, '2018-05-06', 10, 181, NULL),
(493, 20, '2018-05-06', 3, 32, NULL),
(494, 21, '2018-05-06', 10, 96, NULL),
(495, 22, '2018-05-06', 5, 25, NULL),
(496, 23, '2018-05-06', 2, 9, NULL),
(497, 24, '2018-05-06', 24, 500, NULL),
(498, 1, '2018-05-16', 1, 7, NULL),
(499, 2, '2018-05-16', 1, 11, NULL),
(500, 3, '2018-05-16', 8, 155, NULL),
(501, 4, '2018-05-16', 1, 8, NULL),
(502, 7, '2018-05-16', 1, 9, NULL),
(503, 8, '2018-05-16', 1, 12, NULL),
(504, 9, '2018-05-16', 1, 6, NULL),
(505, 10, '2018-05-16', 14, 143, NULL),
(506, 12, '2018-05-16', 24, 597, NULL),
(507, 13, '2018-05-16', 27, 662, NULL),
(508, 14, '2018-05-16', 27, 671, NULL),
(509, 15, '2018-05-16', 27, 693, NULL),
(510, 18, '2018-05-16', 14, 125, NULL),
(511, 19, '2018-05-16', 10, 181, NULL),
(512, 20, '2018-05-16', 3, 32, NULL),
(513, 21, '2018-05-16', 10, 96, NULL),
(514, 22, '2018-05-16', 5, 26, NULL),
(515, 23, '2018-05-16', 2, 9, NULL),
(516, 24, '2018-05-16', 24, 500, NULL),
(517, 1, '2018-05-21', 1, 7, NULL),
(518, 2, '2018-05-21', 1, 12, NULL),
(519, 3, '2018-05-21', 8, 155, NULL),
(520, 4, '2018-05-21', 1, 8, NULL),
(521, 7, '2018-05-21', 1, 9, NULL),
(522, 8, '2018-05-21', 1, 12, NULL),
(523, 9, '2018-05-21', 1, 6, NULL),
(524, 10, '2018-05-21', 10, 143, NULL),
(525, 12, '2018-05-21', 24, 597, NULL),
(526, 13, '2018-05-21', 27, 662, NULL),
(527, 14, '2018-05-21', 27, 671, NULL),
(528, 15, '2018-05-21', 27, 693, NULL),
(529, 18, '2018-05-21', 14, 125, NULL),
(530, 19, '2018-05-21', 10, 181, NULL),
(531, 20, '2018-05-21', 3, 32, NULL),
(532, 21, '2018-05-21', 10, 96, NULL),
(533, 22, '2018-05-21', 5, 25, NULL),
(534, 23, '2018-05-21', 2, 9, NULL),
(535, 24, '2018-05-21', 24, 500, NULL),
(536, 1, '2018-06-03', 1, 7, NULL),
(537, 2, '2018-06-03', 1, 12, NULL),
(538, 3, '2018-06-03', 8, 155, NULL),
(539, 4, '2018-06-03', 1, 6, NULL),
(540, 7, '2018-06-03', 1, 9, NULL),
(541, 8, '2018-06-03', 1, 12, NULL),
(542, 9, '2018-06-03', 1, 6, NULL),
(543, 10, '2018-06-03', 10, 143, NULL),
(544, 12, '2018-06-03', 24, 597, NULL),
(545, 13, '2018-06-03', 27, 662, NULL),
(546, 14, '2018-06-03', 27, 671, NULL),
(547, 15, '2018-06-03', 27, 693, NULL),
(548, 18, '2018-06-03', 14, 125, NULL),
(549, 19, '2018-06-03', 10, 181, NULL),
(550, 20, '2018-06-03', 3, 32, NULL),
(551, 21, '2018-06-03', 10, 96, NULL),
(552, 22, '2018-06-03', 5, 25, NULL),
(553, 23, '2018-06-03', 2, 9, NULL),
(554, 24, '2018-06-03', 24, 500, NULL),
(555, 1, '2018-06-10', 1, 7, NULL),
(556, 2, '2018-06-10', 1, 12, NULL),
(557, 3, '2018-06-10', 8, 155, NULL),
(558, 4, '2018-06-10', 1, 6, NULL),
(559, 7, '2018-06-10', 1, 9, NULL),
(560, 8, '2018-06-10', 1, 12, NULL),
(561, 9, '2018-06-10', 1, 6, NULL),
(562, 10, '2018-06-10', 10, 143, NULL),
(563, 12, '2018-06-10', 24, 597, NULL),
(564, 13, '2018-06-10', 27, 662, NULL),
(565, 14, '2018-06-10', 27, 671, NULL),
(566, 15, '2018-06-10', 27, 693, NULL),
(567, 18, '2018-06-10', 14, 125, NULL),
(568, 19, '2018-06-10', 10, 181, NULL),
(569, 20, '2018-06-10', 3, 32, NULL),
(570, 21, '2018-06-10', 10, 96, NULL),
(571, 22, '2018-06-10', 5, 25, NULL),
(572, 23, '2018-06-10', 2, 9, NULL),
(573, 24, '2018-06-10', 24, 500, NULL),
(574, 1, '2018-06-23', 1, 7, NULL),
(575, 2, '2018-06-23', 1, 12, NULL),
(576, 3, '2018-06-23', 8, 155, NULL),
(577, 4, '2018-06-23', 1, 8, NULL),
(578, 7, '2018-06-23', 1, 9, NULL),
(579, 8, '2018-06-23', 1, 12, NULL),
(580, 9, '2018-06-23', 1, 6, NULL),
(581, 10, '2018-06-23', 10, 143, NULL),
(582, 12, '2018-06-23', 24, 597, NULL),
(583, 13, '2018-06-23', 27, 662, NULL),
(584, 14, '2018-06-23', 27, 671, NULL),
(585, 15, '2018-06-23', 27, 693, NULL),
(586, 18, '2018-06-23', 14, 125, NULL),
(587, 19, '2018-06-23', 10, 181, NULL),
(588, 20, '2018-06-23', 3, 32, NULL),
(589, 21, '2018-06-23', 10, 96, NULL),
(590, 22, '2018-06-23', 5, 25, NULL),
(591, 23, '2018-06-23', 2, 9, NULL),
(592, 24, '2018-06-23', 24, 500, NULL),
(593, 1, '2018-07-11', 1, 7, NULL),
(594, 2, '2018-07-11', 1, 12, NULL),
(595, 3, '2018-07-11', 8, 155, NULL),
(596, 4, '2018-07-11', 1, 8, NULL),
(597, 7, '2018-07-11', 1, 9, NULL),
(598, 8, '2018-07-11', 1, 12, NULL),
(599, 9, '2018-07-11', 1, 6, NULL),
(600, 10, '2018-07-11', 10, 143, NULL),
(601, 12, '2018-07-11', 24, 597, NULL),
(602, 13, '2018-07-11', 27, 662, NULL),
(603, 14, '2018-07-11', 27, 671, NULL),
(604, 15, '2018-07-11', 27, 693, NULL),
(605, 18, '2018-07-11', 14, 125, NULL),
(606, 19, '2018-07-11', 10, 181, NULL),
(607, 20, '2018-07-11', 3, 32, NULL),
(608, 21, '2018-07-11', 10, 96, NULL),
(609, 22, '2018-07-11', 3, 25, NULL),
(610, 23, '2018-07-11', 2, 9, NULL),
(611, 24, '2018-07-11', 24, 500, NULL),
(612, 1, '2018-07-03', 1, 7, NULL),
(613, 2, '2018-07-01', 1, 12, NULL),
(614, 3, '2018-07-02', 8, 155, NULL),
(615, 4, '2018-07-02', 1, 8, NULL),
(616, 7, '2018-07-02', 1, 9, NULL),
(617, 8, '2018-07-02', 1, 12, NULL),
(618, 9, '2018-07-02', 1, 6, NULL),
(619, 10, '2018-07-02', 10, 143, NULL),
(620, 12, '2018-07-02', 24, 597, NULL),
(621, 13, '2018-07-02', 27, 662, NULL),
(622, 14, '2018-07-02', 27, 671, NULL),
(623, 15, '2018-07-02', 27, 693, NULL),
(624, 18, '2018-07-02', 14, 125, NULL),
(625, 19, '2018-07-02', 10, 181, NULL),
(626, 20, '2018-07-02', 3, 32, NULL),
(627, 21, '2018-07-02', 10, 96, NULL),
(628, 22, '2018-07-02', 5, 25, NULL),
(629, 23, '2018-07-02', 2, 9, NULL),
(630, 24, '2018-07-02', 24, 500, NULL),
(631, 1, '2018-07-17', 1, 7, NULL),
(632, 2, '2018-07-17', 1, 12, NULL),
(633, 3, '2018-07-17', 8, 155, NULL),
(634, 4, '2018-07-17', 1, 8, NULL),
(635, 7, '2018-07-17', 1, 9, NULL),
(636, 8, '2018-07-17', 1, 12, NULL),
(637, 9, '2018-07-17', 1, 6, NULL),
(638, 10, '2018-07-17', 10, 143, NULL),
(639, 12, '2018-07-17', 24, 597, NULL),
(640, 13, '2018-07-17', 27, 662, NULL),
(641, 14, '2018-07-17', 27, 671, NULL),
(642, 15, '2018-07-17', 27, 693, NULL),
(643, 18, '2018-07-17', 14, 143, NULL),
(644, 19, '2018-07-17', 10, 181, NULL),
(645, 20, '2018-07-17', 3, 32, NULL),
(646, 21, '2018-07-17', 10, 96, NULL),
(647, 22, '2018-07-17', 5, 25, NULL),
(648, 23, '2018-07-17', 2, 9, NULL),
(649, 24, '2018-07-17', 24, 500, NULL),
(650, 1, '2018-07-25', 1, 7, NULL),
(651, 2, '2018-07-25', 1, 12, NULL),
(652, 3, '2018-07-25', 8, 155, NULL),
(653, 4, '2018-07-25', 1, 8, NULL),
(654, 7, '2018-07-25', 1, 8, NULL),
(655, 8, '2018-07-25', 1, 12, NULL),
(656, 9, '2018-07-25', 1, 6, NULL),
(657, 10, '2018-07-25', 10, 143, NULL),
(658, 12, '2018-07-25', 24, 597, NULL),
(659, 13, '2018-07-25', 27, 662, NULL),
(660, 14, '2018-07-25', 27, 671, NULL),
(661, 15, '2018-07-25', 27, 693, NULL),
(662, 18, '2018-07-25', 14, 125, NULL),
(663, 19, '2018-07-25', 10, 181, NULL),
(664, 20, '2018-07-25', 3, 32, NULL),
(665, 21, '2018-07-25', 10, 96, NULL),
(666, 22, '2018-07-25', 5, 25, NULL),
(667, 23, '2018-07-25', 2, 9, NULL),
(668, 24, '2018-07-25', 24, 500, NULL),
(669, 1, '2018-07-31', 1, 7, NULL),
(670, 2, '2018-07-31', 1, 12, NULL),
(671, 3, '2018-07-31', 8, 155, NULL),
(672, 4, '2018-07-31', 1, 8, NULL),
(673, 7, '2018-07-31', 1, 8, NULL),
(674, 8, '2018-07-31', 1, 12, NULL),
(675, 9, '2018-07-31', 1, 6, NULL),
(676, 10, '2018-07-31', 10, 143, NULL),
(677, 12, '2018-07-31', 24, 597, NULL),
(678, 13, '2018-07-31', 27, 662, NULL),
(679, 14, '2018-07-31', 27, 671, NULL),
(680, 15, '2018-07-31', 27, 693, NULL),
(681, 18, '2018-07-31', 14, 125, NULL),
(682, 19, '2018-07-31', 10, 181, NULL),
(683, 20, '2018-07-31', 3, 32, NULL),
(684, 21, '2018-07-31', 10, 96, NULL),
(685, 22, '2018-07-31', 1, 5, NULL),
(686, 23, '2018-07-31', 2, 9, NULL),
(687, 24, '2018-07-31', 24, 500, NULL),
(688, 1, '2018-08-07', 1, 7, NULL),
(689, 2, '2018-08-07', 1, 12, NULL),
(690, 3, '2018-08-07', 8, 155, NULL),
(691, 4, '2018-08-07', 1, 8, NULL),
(692, 7, '2018-08-07', 1, 8, NULL),
(693, 8, '2018-08-07', 1, 12, NULL),
(694, 9, '2018-08-07', 1, 6, NULL),
(695, 10, '2018-08-07', 10, 143, NULL),
(696, 12, '2018-08-07', 24, 597, NULL),
(697, 13, '2018-08-07', 27, 662, NULL),
(698, 14, '2018-08-07', 27, 671, NULL),
(699, 15, '2018-08-07', 27, 693, NULL),
(700, 18, '2018-08-07', 14, 125, NULL),
(701, 19, '2018-08-07', 10, 181, NULL),
(702, 20, '2018-08-07', 3, 32, NULL),
(703, 21, '2018-08-07', 10, 96, NULL),
(704, 22, '2018-08-07', 1, 5, NULL),
(705, 23, '2018-08-07', 2, 9, NULL),
(706, 24, '2018-08-07', 24, 500, NULL),
(707, 1, '2018-08-14', 1, 7, NULL),
(708, 2, '2018-08-14', 1, 12, NULL),
(709, 3, '2018-08-14', 8, 155, NULL),
(710, 4, '2018-08-14', 1, 8, NULL),
(711, 7, '2018-08-14', 1, 8, NULL),
(712, 8, '2018-08-14', 1, 12, NULL),
(713, 9, '2018-08-14', 1, 6, NULL),
(714, 10, '2018-08-14', 10, 143, NULL),
(715, 12, '2018-08-14', 24, 597, NULL),
(716, 13, '2018-08-14', 27, 662, NULL),
(717, 14, '2018-08-14', 27, 671, NULL),
(718, 15, '2018-08-14', 27, 693, NULL),
(719, 18, '2018-08-14', 14, 125, NULL),
(720, 19, '2018-08-14', 10, 181, NULL),
(721, 20, '2018-08-14', 3, 32, NULL),
(722, 21, '2018-08-14', 10, 96, NULL),
(723, 22, '2018-08-14', 1, 5, NULL),
(724, 23, '2018-08-14', 2, 9, NULL),
(725, 24, '2018-08-14', 24, 500, NULL),
(726, 1, '2018-08-27', 1, 7, NULL),
(727, 2, '2018-08-27', 1, 12, NULL),
(728, 3, '2018-08-27', 8, 155, NULL),
(729, 4, '2018-08-27', 1, 8, NULL),
(730, 7, '2018-08-27', 1, 8, NULL),
(731, 8, '2018-08-27', 1, 12, NULL),
(732, 9, '2018-08-27', 1, 6, NULL),
(733, 10, '2018-08-27', 10, 143, NULL),
(734, 12, '2018-08-27', 24, 597, NULL),
(735, 13, '2018-08-27', 27, 662, NULL),
(736, 14, '2018-08-27', 27, 671, NULL),
(737, 15, '2018-08-27', 27, 693, NULL),
(738, 18, '2018-08-27', 14, 125, NULL),
(739, 19, '2018-08-27', 10, 181, NULL),
(740, 20, '2018-08-27', 3, 32, NULL),
(741, 21, '2018-08-27', 10, 96, NULL),
(742, 22, '2018-08-27', 1, 5, NULL),
(743, 23, '2018-08-27', 2, 9, NULL),
(744, 24, '2018-08-27', 24, 500, NULL),
(745, 1, '2018-09-08', 1, 7, NULL),
(746, 2, '2018-09-08', 1, 14, NULL),
(747, 3, '2018-09-08', 8, 155, NULL),
(748, 4, '2018-09-08', 1, 8, NULL),
(749, 7, '2018-09-08', 1, 8, NULL),
(750, 8, '2018-09-08', 1, 12, NULL),
(751, 9, '2018-09-08', 1, 6, NULL),
(752, 10, '2018-09-08', 10, 143, NULL),
(753, 12, '2018-09-08', 24, 597, NULL),
(754, 13, '2018-09-08', 27, 662, NULL),
(755, 14, '2018-09-08', 27, 671, NULL),
(756, 15, '2018-09-08', 27, 693, NULL),
(757, 18, '2018-09-08', 14, 125, NULL),
(758, 19, '2018-09-08', 10, 181, NULL),
(759, 20, '2018-09-08', 3, 32, NULL),
(760, 21, '2018-09-08', 10, 96, NULL),
(761, 22, '2018-09-08', 3, 10, NULL),
(762, 23, '2018-09-08', 2, 9, NULL),
(763, 24, '2018-09-08', 24, 500, NULL),
(764, 1, '2018-09-15', 1, 7, NULL),
(765, 2, '2018-09-15', 1, 14, NULL),
(766, 3, '2018-09-15', 8, 155, NULL),
(767, 4, '2018-09-15', 1, 8, NULL),
(768, 7, '2018-09-15', 1, 8, NULL),
(769, 8, '2018-09-15', 1, 12, NULL),
(770, 9, '2018-09-15', 1, 6, NULL),
(771, 10, '2018-09-15', 10, 143, NULL),
(772, 12, '2018-09-15', 24, 597, NULL),
(773, 13, '2018-09-15', 27, 662, NULL),
(774, 14, '2018-09-15', 27, 671, NULL),
(775, 15, '2018-09-15', 27, 693, NULL),
(776, 18, '2018-09-15', 14, 125, NULL),
(777, 19, '2018-09-15', 10, 181, NULL),
(778, 20, '2018-09-15', 3, 32, NULL),
(779, 21, '2018-09-15', 10, 96, NULL),
(780, 22, '2018-09-15', 3, 10, NULL),
(781, 23, '2018-09-15', 2, 9, NULL),
(782, 24, '2018-09-15', 24, 500, NULL),
(783, 1, '2018-09-22', 1, 7, NULL),
(784, 2, '2018-09-22', 1, 14, NULL),
(785, 3, '2018-09-22', 8, 155, NULL),
(786, 4, '2018-09-22', 1, 8, NULL),
(787, 7, '2018-09-22', 1, 8, NULL),
(788, 8, '2018-09-22', 1, 12, NULL),
(789, 8, '2018-09-22', 1, 12, NULL),
(790, 9, '2018-09-22', 1, 6, NULL),
(791, 10, '2018-09-22', 10, 143, NULL),
(792, 12, '2018-09-22', 24, 597, NULL),
(793, 13, '2018-09-22', 27, 662, NULL),
(794, 14, '2018-09-22', 27, 671, NULL),
(795, 15, '2018-09-22', 27, 693, NULL),
(796, 18, '2018-09-22', 14, 125, NULL),
(797, 19, '2018-09-22', 10, 181, NULL),
(798, 20, '2018-09-22', 3, 32, NULL),
(799, 21, '2018-09-22', 10, 96, NULL),
(800, 22, '2018-09-22', 2, 10, NULL),
(801, 23, '2018-09-22', 2, 9, NULL),
(802, 24, '2018-09-22', 24, 500, NULL),
(803, 2, '2018-09-29', 1, 15, NULL),
(804, 1, '2018-09-29', 1, 7, NULL),
(805, 3, '2018-09-29', 7, 147, NULL),
(806, 4, '2018-09-29', 1, 8, NULL),
(807, 7, '2018-09-29', 1, 10, NULL),
(808, 8, '2018-09-29', 1, 11, NULL),
(809, 9, '2018-09-29', 1, 6, NULL),
(810, 10, '2018-09-29', 10, 142, NULL),
(811, 12, '2018-09-29', 24, 597, NULL),
(812, 13, '2018-09-29', 27, 662, NULL),
(813, 14, '2018-09-29', 27, 671, NULL),
(814, 15, '2018-09-29', 27, 691, NULL),
(815, 18, '2018-09-29', 14, 148, NULL),
(816, 19, '2018-09-29', 10, 187, NULL),
(817, 20, '2018-09-29', 6, 62, NULL),
(818, 21, '2018-09-29', 9, 92, NULL),
(819, 22, '2018-09-29', 2, 9, NULL),
(820, 23, '2018-09-29', 4, 26, NULL),
(821, 24, '2018-09-29', 24, 500, NULL),
(822, 1, '2018-10-06', 1, 7, NULL),
(823, 2, '2018-10-06', 2, 15, NULL),
(824, 3, '2018-10-06', 7, 147, NULL),
(825, 4, '2018-10-06', 1, 8, NULL),
(826, 7, '2018-10-06', 1, 10, NULL),
(827, 8, '2018-10-06', 1, 11, NULL),
(828, 9, '2018-10-06', 1, 6, NULL),
(829, 10, '2018-10-06', 10, 142, NULL),
(830, 12, '2018-10-06', 24, 597, NULL),
(831, 13, '2018-10-06', 27, 662, NULL),
(832, 14, '2018-10-06', 27, 671, NULL),
(833, 15, '2018-10-06', 27, 691, NULL),
(834, 18, '2018-10-06', 14, 148, NULL),
(835, 19, '2018-10-06', 10, 187, NULL),
(836, 20, '2018-10-06', 6, 62, NULL),
(837, 21, '2018-10-06', 9, 92, NULL),
(838, 22, '2018-10-06', 2, 9, NULL),
(839, 23, '2018-10-06', 4, 26, NULL),
(840, 24, '2018-10-06', 24, 500, NULL),
(841, 1, '2018-10-14', 1, 7, NULL),
(842, 2, '2018-10-14', 2, 15, NULL),
(843, 3, '2018-10-14', 7, 147, NULL),
(844, 4, '2018-10-14', 1, 8, NULL),
(845, 7, '2018-10-14', 1, 10, NULL),
(846, 8, '2018-10-14', 1, 11, NULL),
(847, 9, '2018-10-14', 1, 6, NULL),
(848, 10, '2018-10-14', 10, 142, NULL),
(849, 12, '2018-10-14', 24, 597, NULL),
(850, 13, '2018-10-14', 27, 662, NULL),
(851, 14, '2018-10-14', 27, 671, NULL),
(852, 15, '2018-10-14', 27, 691, NULL),
(853, 18, '2018-10-14', 14, 148, NULL),
(854, 19, '2018-10-14', 10, 187, NULL),
(855, 20, '2018-10-14', 6, 62, NULL),
(856, 21, '2018-10-14', 9, 92, NULL),
(857, 22, '2018-10-14', 2, 9, NULL),
(858, 23, '2018-10-14', 3, 26, NULL),
(859, 24, '2018-10-14', 24, 500, NULL),
(860, 1, '2018-10-21', 1, 7, NULL),
(861, 2, '2018-10-21', 2, 15, NULL),
(862, 3, '2018-10-21', 7, 147, NULL),
(863, 4, '2018-10-21', 1, 8, NULL),
(864, 7, '2018-10-21', 1, 10, NULL),
(865, 8, '2018-10-21', 1, 11, NULL),
(866, 9, '2018-10-21', 1, 6, NULL),
(867, 10, '2018-10-21', 10, 142, NULL),
(868, 12, '2018-10-21', 24, 597, NULL),
(869, 13, '2018-10-21', 27, 662, NULL),
(870, 14, '2018-10-21', 27, 671, NULL),
(871, 15, '2018-10-21', 27, 691, NULL),
(872, 18, '2018-10-21', 14, 148, NULL),
(873, 19, '2018-10-21', 10, 187, NULL),
(874, 20, '2018-10-21', 6, 62, NULL),
(875, 21, '2018-10-21', 9, 92, NULL),
(876, 22, '2018-10-21', 2, 9, NULL),
(877, 23, '2018-10-21', 3, 26, NULL),
(878, 24, '2018-10-21', 24, 500, NULL),
(879, 1, '2018-10-29', 1, 7, NULL),
(880, 2, '2018-10-29', 2, 15, NULL),
(881, 3, '2018-10-29', 7, 147, NULL),
(882, 4, '2018-10-29', 1, 8, NULL),
(883, 7, '2018-10-29', 1, 10, NULL),
(884, 8, '2018-10-29', 1, 11, NULL),
(885, 9, '2018-10-29', 1, 6, NULL),
(886, 10, '2018-10-29', 10, 142, NULL),
(887, 12, '2018-10-29', 24, 597, NULL),
(888, 13, '2018-10-29', 27, 662, NULL),
(889, 14, '2018-10-29', 27, 671, NULL),
(890, 15, '2018-10-29', 27, 691, NULL),
(891, 18, '2018-10-29', 14, 148, NULL),
(892, 19, '2018-10-29', 10, 187, NULL),
(893, 20, '2018-10-29', 6, 62, NULL),
(894, 21, '2018-10-29', 9, 92, NULL),
(895, 22, '2018-10-29', 2, 9, NULL),
(896, 23, '2018-10-29', 3, 26, NULL),
(897, 24, '2018-10-29', 24, 500, NULL),
(898, 1, '2018-11-06', 1, 7, NULL),
(899, 2, '2018-11-06', 1, 15, NULL),
(900, 3, '2018-11-06', 7, 147, NULL),
(901, 4, '2018-11-06', 1, 8, NULL),
(902, 7, '2018-11-06', 1, 10, NULL),
(903, 8, '2018-11-06', 1, 11, NULL),
(904, 9, '2018-11-06', 1, 6, NULL),
(905, 10, '2018-11-06', 10, 142, NULL),
(906, 12, '2018-11-06', 24, 597, NULL),
(907, 13, '2018-11-06', 27, 662, NULL),
(908, 14, '2018-11-06', 27, 671, NULL),
(909, 15, '2018-11-06', 27, 691, NULL),
(910, 18, '2018-11-06', 14, 148, NULL),
(911, 19, '2018-11-06', 10, 187, NULL),
(912, 20, '2018-11-06', 6, 62, NULL),
(913, 21, '2018-11-06', 9, 92, NULL),
(914, 22, '2018-11-06', 2, 9, NULL),
(915, 23, '2018-11-06', 3, 26, NULL),
(916, 24, '2018-11-06', 24, 500, NULL),
(917, 1, '2018-11-13', 1, 7, NULL),
(918, 2, '2018-11-13', 1, 15, NULL),
(919, 3, '2018-11-13', 7, 147, NULL),
(920, 4, '2018-11-13', 1, 8, NULL),
(921, 7, '2018-11-13', 1, 10, NULL),
(922, 8, '2018-11-13', 1, 11, NULL),
(923, 9, '2018-11-13', 1, 6, NULL),
(924, 10, '2018-11-13', 10, 142, NULL),
(925, 12, '2018-11-13', 24, 597, NULL),
(926, 13, '2018-11-13', 27, 662, NULL),
(927, 14, '2018-11-13', 27, 671, NULL),
(928, 15, '2018-11-13', 27, 691, NULL),
(929, 18, '2018-11-13', 14, 148, NULL),
(930, 19, '2018-11-13', 10, 187, NULL),
(931, 20, '2018-11-13', 6, 62, NULL),
(932, 21, '2018-11-13', 9, 92, NULL),
(933, 22, '2018-11-13', 2, 9, NULL),
(934, 23, '2018-11-13', 4, 26, NULL),
(935, 24, '2018-11-13', 24, 500, NULL),
(936, 1, '2018-11-21', 1, 7, NULL),
(937, 2, '2018-11-21', 1, 15, NULL),
(938, 3, '2018-11-21', 7, 147, NULL),
(939, 4, '2018-11-21', 1, 8, NULL),
(940, 7, '2018-11-21', 1, 10, NULL),
(941, 8, '2018-11-21', 1, 11, NULL),
(942, 9, '2018-11-21', 1, 6, NULL),
(943, 10, '2018-11-21', 10, 142, NULL),
(944, 12, '2018-11-21', 24, 597, NULL),
(945, 13, '2018-11-21', 27, 662, NULL),
(946, 14, '2018-11-21', 27, 671, NULL),
(947, 15, '2018-11-21', 27, 691, NULL),
(948, 18, '2018-11-21', 14, 148, NULL),
(949, 19, '2018-11-21', 10, 187, NULL),
(950, 20, '2018-11-21', 6, 62, NULL),
(951, 21, '2018-11-21', 9, 92, NULL),
(952, 22, '2018-11-21', 2, 9, NULL),
(953, 23, '2018-11-21', 4, 26, NULL),
(954, 24, '2018-11-21', 24, 500, NULL),
(955, 1, '2018-12-01', 1, 7, NULL),
(956, 2, '2018-12-01', 1, 15, NULL),
(957, 3, '2018-12-01', 7, 147, NULL),
(958, 4, '2018-12-01', 1, 8, NULL),
(959, 7, '2018-12-01', 1, 10, NULL),
(960, 8, '2018-12-01', 1, 11, NULL),
(961, 9, '2018-12-01', 1, 6, NULL),
(962, 10, '2018-12-01', 10, 142, NULL),
(963, 12, '2018-12-01', 24, 597, NULL),
(964, 13, '2018-12-01', 27, 662, NULL),
(965, 14, '2018-12-01', 27, 671, NULL),
(966, 15, '2018-12-01', 27, 691, NULL),
(967, 18, '2018-12-01', 14, 148, NULL),
(968, 19, '2018-12-01', 10, 187, NULL),
(969, 20, '2018-12-01', 6, 62, NULL),
(970, 21, '2018-12-01', 9, 92, NULL),
(971, 22, '2018-12-01', 2, 9, NULL),
(972, 23, '2018-12-01', 3, 26, NULL),
(973, 24, '2018-12-01', 24, 500, NULL),
(974, 1, '2018-12-08', 1, 7, NULL),
(975, 2, '2018-12-08', 2, 15, NULL),
(976, 3, '2018-12-08', 7, 147, NULL),
(977, 4, '2018-12-08', 1, 8, NULL),
(978, 7, '2018-12-08', 1, 10, NULL),
(979, 8, '2018-12-08', 1, 11, NULL),
(980, 9, '2018-12-08', 1, 6, NULL),
(981, 10, '2018-12-08', 10, 142, NULL),
(982, 12, '2018-12-08', 24, 597, NULL),
(983, 13, '2018-12-08', 27, 662, NULL),
(984, 14, '2018-12-08', 27, 671, NULL),
(985, 15, '2018-12-08', 27, 691, NULL),
(986, 18, '2018-12-08', 14, 148, NULL),
(987, 19, '2018-12-08', 10, 187, NULL),
(988, 20, '2018-12-08', 6, 62, NULL),
(989, 21, '2018-12-08', 9, 92, NULL),
(990, 22, '2018-12-08', 2, 9, NULL),
(991, 23, '2018-12-08', 3, 26, NULL),
(992, 24, '2018-12-08', 24, 500, NULL),
(993, 1, '2018-12-17', 1, 7, NULL),
(994, 2, '2018-12-17', 2, 15, NULL),
(995, 3, '2018-12-17', 7, 147, NULL),
(996, 4, '2018-12-17', 1, 8, NULL),
(997, 7, '2018-12-17', 1, 10, NULL),
(998, 8, '2018-12-17', 1, 11, NULL),
(999, 9, '2018-12-17', 1, 6, NULL),
(1000, 10, '2018-12-17', 10, 142, NULL),
(1001, 12, '2018-12-17', 24, 597, NULL),
(1002, 13, '2018-12-17', 27, 662, NULL),
(1003, 14, '2018-12-17', 27, 671, NULL),
(1004, 15, '2018-12-17', 27, 691, NULL),
(1005, 18, '2018-12-17', 14, 148, NULL),
(1006, 19, '2018-12-17', 10, 187, NULL),
(1007, 20, '2018-12-17', 6, 62, NULL),
(1008, 21, '2018-12-17', 9, 92, NULL),
(1009, 22, '2018-12-17', 2, 9, NULL),
(1010, 23, '2018-12-17', 3, 26, NULL),
(1011, 24, '2018-12-17', 24, 500, NULL),
(1012, 1, '2018-12-22', 1, 7, NULL),
(1013, 2, '2018-12-22', 2, 15, NULL),
(1014, 3, '2018-12-22', 7, 147, NULL),
(1015, 4, '2018-12-22', 1, 8, NULL),
(1016, 7, '2018-12-22', 1, 10, NULL),
(1017, 8, '2018-12-22', 1, 11, NULL),
(1018, 9, '2018-12-22', 1, 6, NULL),
(1019, 10, '2018-12-22', 10, 142, NULL),
(1020, 12, '2018-12-22', 24, 597, NULL),
(1021, 13, '2018-12-22', 27, 662, NULL),
(1022, 14, '2018-12-22', 27, 671, NULL),
(1023, 15, '2018-12-22', 21, 546, NULL),
(1024, 18, '2018-12-22', 14, 148, NULL),
(1025, 19, '2018-12-22', 10, 187, NULL),
(1026, 20, '2018-12-22', 6, 62, NULL),
(1027, 21, '2018-12-22', 9, 92, NULL),
(1028, 22, '2018-12-22', 2, 9, NULL),
(1029, 23, '2018-12-22', 3, 26, NULL),
(1030, 24, '2018-12-22', 24, 500, NULL),
(1031, 25, '2018-12-22', 6, 145, NULL),
(1032, 1, '2019-01-01', 1, 7, NULL),
(1033, 2, '2019-01-01', 2, 15, NULL),
(1034, 3, '2019-01-01', 7, 147, NULL),
(1035, 4, '2019-01-01', 1, 8, NULL),
(1036, 7, '2019-01-01', 1, 10, NULL),
(1037, 8, '2019-01-01', 1, 11, NULL),
(1038, 9, '2019-01-01', 1, 6, NULL),
(1039, 10, '2019-01-01', 10, 142, NULL),
(1040, 12, '2019-01-01', 24, 597, NULL),
(1041, 13, '2019-01-01', 27, 662, NULL),
(1042, 14, '2019-01-01', 27, 671, NULL),
(1043, 15, '2019-01-02', 21, 546, NULL),
(1044, 18, '2019-01-02', 14, 148, NULL),
(1045, 19, '2019-01-02', 10, 187, NULL),
(1046, 20, '2019-01-02', 6, 62, NULL),
(1047, 21, '2019-01-02', 9, 92, NULL),
(1048, 22, '2019-01-02', 2, 9, NULL),
(1049, 23, '2019-01-02', 3, 26, NULL),
(1050, 24, '2019-01-02', 24, 500, NULL),
(1051, 25, '2019-01-02', 6, 145, NULL),
(1052, 1, '2019-01-12', 1, 6, NULL),
(1053, 2, '2019-01-12', 1, 15, NULL),
(1054, 3, '2019-01-12', 7, 147, NULL),
(1055, 4, '2019-01-12', 1, 8, NULL),
(1056, 7, '2019-01-12', 1, 10, NULL),
(1057, 8, '2019-01-12', 1, 11, NULL),
(1058, 9, '2019-01-12', 1, 7, NULL),
(1059, 10, '2019-01-12', 10, 142, NULL),
(1060, 12, '2019-01-12', 24, 597, NULL),
(1061, 13, '2019-01-12', 27, 662, NULL),
(1062, 14, '2019-01-12', 27, 671, NULL),
(1063, 15, '2019-01-12', 21, 546, NULL),
(1064, 18, '2019-01-12', 14, 148, NULL),
(1065, 19, '2019-01-12', 10, 187, NULL),
(1066, 20, '2019-01-12', 6, 62, NULL),
(1067, 21, '2019-01-12', 9, 90, NULL),
(1068, 22, '2019-01-12', 2, 10, NULL),
(1069, 23, '2019-01-12', 3, 26, NULL),
(1070, 24, '2019-01-12', 24, 500, NULL),
(1071, 25, '2019-01-12', 6, 145, NULL),
(1072, 1, '2019-01-16', 1, 6, NULL),
(1073, 2, '2019-01-16', 1, 15, NULL),
(1074, 3, '2019-01-16', 7, 147, NULL),
(1075, 4, '2019-01-16', 1, 8, NULL),
(1076, 7, '2019-01-16', 1, 10, NULL),
(1077, 8, '2019-01-16', 1, 11, NULL),
(1078, 9, '2019-01-16', 1, 7, NULL),
(1079, 10, '2019-01-16', 10, 142, NULL),
(1080, 12, '2019-01-16', 24, 597, NULL),
(1081, 13, '2019-01-16', 27, 662, NULL),
(1082, 14, '2019-01-16', 27, 671, NULL),
(1083, 25, '2019-01-16', 6, 145, NULL),
(1084, 15, '2019-01-16', 21, 546, NULL),
(1085, 24, '2019-01-16', 24, 500, NULL),
(1086, 18, '2019-01-16', 14, 148, NULL),
(1087, 19, '2019-01-16', 10, 187, NULL),
(1088, 20, '2019-01-16', 6, 62, NULL),
(1089, 21, '2019-01-16', 9, 90, NULL),
(1090, 22, '2019-01-16', 2, 10, NULL),
(1091, 23, '2019-01-16', 4, 26, NULL),
(1092, 1, '2019-01-22', 1, 6, NULL),
(1093, 2, '2019-01-22', 2, 15, NULL),
(1094, 3, '2019-01-22', 7, 147, NULL),
(1095, 4, '2019-01-22', 1, 8, NULL),
(1096, 7, '2019-01-22', 1, 10, NULL),
(1097, 8, '2019-01-22', 1, 11, NULL),
(1098, 9, '2019-01-22', 1, 7, NULL),
(1099, 10, '2019-01-22', 10, 142, NULL),
(1100, 12, '2019-01-22', 24, 597, NULL),
(1101, 13, '2019-01-23', 27, 662, NULL),
(1102, 14, '2019-01-23', 27, 671, NULL),
(1103, 15, '2019-01-23', 21, 546, NULL),
(1104, 18, '2019-01-23', 14, 148, NULL),
(1105, 19, '2019-01-23', 10, 187, NULL),
(1106, 20, '2019-01-23', 6, 62, NULL),
(1107, 21, '2019-01-23', 9, 90, NULL),
(1108, 22, '2019-01-23', 2, 10, NULL),
(1109, 23, '2019-01-23', 4, 26, NULL),
(1110, 24, '2019-01-23', 24, 500, NULL),
(1111, 25, '2019-01-23', 6, 145, NULL),
(1112, 1, '2019-01-31', 1, 6, NULL),
(1113, 2, '2019-01-31', 2, 15, NULL),
(1114, 3, '2019-01-31', 7, 147, NULL),
(1115, 4, '2019-01-31', 1, 8, NULL),
(1116, 7, '2019-01-31', 1, 10, NULL),
(1117, 8, '2019-01-31', 1, 11, NULL),
(1118, 9, '2019-01-31', 1, 7, NULL),
(1119, 10, '2019-01-31', 10, 142, NULL),
(1120, 12, '2019-01-31', 24, 597, NULL),
(1121, 13, '2019-01-31', 27, 662, NULL),
(1122, 14, '2019-01-31', 27, 671, NULL),
(1123, 15, '2019-01-31', 21, 546, NULL),
(1124, 18, '2019-01-31', 14, 148, NULL),
(1125, 19, '2019-01-31', 10, 187, NULL),
(1126, 20, '2019-01-31', 6, 62, NULL),
(1127, 21, '2019-01-31', 9, 90, NULL),
(1128, 22, '2019-01-31', 2, 10, NULL),
(1129, 23, '2019-01-31', 3, 26, NULL),
(1130, 24, '2019-01-31', 24, 500, NULL),
(1131, 25, '2019-01-31', 6, 145, NULL),
(1132, 1, '2019-02-06', 1, 6, NULL),
(1133, 2, '2019-02-06', 1, 15, NULL),
(1134, 3, '2019-02-06', 7, 147, NULL),
(1135, 4, '2019-02-06', 1, 8, NULL),
(1136, 7, '2019-02-06', 1, 10, NULL),
(1137, 8, '2019-02-06', 1, 11, NULL),
(1138, 9, '2019-02-06', 1, 7, NULL),
(1139, 10, '2019-02-06', 10, 142, NULL),
(1140, 12, '2019-02-06', 24, 597, NULL),
(1141, 13, '2019-02-06', 27, 662, NULL),
(1142, 14, '2019-02-06', 27, 671, NULL),
(1143, 15, '2019-02-06', 21, 546, NULL),
(1144, 18, '2019-02-06', 14, 148, NULL),
(1145, 19, '2019-02-06', 10, 187, NULL),
(1146, 20, '2019-02-06', 6, 62, NULL),
(1147, 21, '2019-02-06', 9, 90, NULL),
(1148, 22, '2019-02-06', 2, 10, NULL),
(1149, 23, '2019-02-06', 3, 26, NULL),
(1150, 24, '2019-02-06', 24, 500, NULL),
(1151, 25, '2019-02-06', 6, 145, NULL),
(1152, 1, '2019-02-17', 1, 6, NULL),
(1153, 2, '2019-02-17', 1, 15, NULL),
(1154, 3, '2019-02-17', 7, 147, NULL),
(1155, 4, '2019-02-17', 1, 8, NULL),
(1156, 7, '2019-02-17', 1, 10, NULL),
(1157, 8, '2019-02-17', 1, 11, NULL),
(1158, 9, '2019-02-17', 1, 7, NULL),
(1159, 10, '2019-02-17', 10, 142, NULL),
(1160, 12, '2019-02-17', 24, 597, NULL),
(1161, 13, '2019-02-17', 27, 662, NULL),
(1162, 14, '2019-02-17', 27, 671, NULL),
(1163, 15, '2019-02-17', 21, 546, NULL),
(1164, 18, '2019-02-17', 14, 148, NULL),
(1165, 19, '2019-02-17', 10, 187, NULL),
(1166, 20, '2019-02-17', 6, 62, NULL),
(1167, 21, '2019-02-17', 9, 90, NULL),
(1168, 22, '2019-02-17', 2, 10, NULL),
(1169, 23, '2019-02-17', 3, 26, NULL),
(1170, 24, '2019-02-17', 24, 500, NULL),
(1171, 25, '2019-02-17', 6, 145, NULL),
(1172, 1, '2019-02-23', 1, 6, NULL),
(1173, 2, '2019-02-23', 2, 15, NULL),
(1174, 3, '2019-02-23', 7, 147, NULL),
(1175, 4, '2019-02-23', 1, 8, NULL),
(1176, 7, '2019-02-23', 1, 10, NULL),
(1177, 8, '2019-02-23', 1, 11, NULL),
(1178, 9, '2019-02-23', 1, 7, NULL),
(1179, 10, '2019-02-23', 10, 142, NULL),
(1180, 12, '2019-02-23', 24, 597, NULL),
(1181, 13, '2019-02-23', 27, 662, NULL),
(1182, 14, '2019-02-23', 27, 671, NULL),
(1183, 15, '2019-02-23', 21, 546, NULL),
(1184, 18, '2019-02-23', 14, 148, NULL),
(1185, 19, '2019-02-23', 10, 187, NULL),
(1186, 20, '2019-02-23', 6, 62, NULL),
(1187, 21, '2019-02-23', 9, 90, NULL),
(1188, 22, '2019-02-23', 2, 10, NULL),
(1189, 23, '2019-02-23', 4, 26, NULL),
(1190, 24, '2019-02-23', 24, 500, NULL),
(1191, 25, '2019-02-23', 6, 145, NULL),
(1192, 1, '2019-03-02', 1, 6, NULL),
(1193, 2, '2019-03-02', 2, 15, NULL),
(1194, 3, '2019-03-02', 7, 147, NULL),
(1195, 4, '2019-03-02', 1, 8, NULL),
(1196, 7, '2019-03-02', 1, 10, NULL),
(1197, 8, '2019-03-02', 1, 11, NULL),
(1198, 9, '2019-03-02', 1, 7, NULL),
(1199, 10, '2019-03-02', 10, 142, NULL),
(1200, 12, '2019-03-02', 24, 597, NULL),
(1201, 13, '2019-03-02', 27, 662, NULL),
(1202, 14, '2019-03-02', 27, 671, NULL),
(1203, 15, '2019-03-02', 21, 546, NULL),
(1204, 18, '2019-03-02', 14, 148, NULL),
(1205, 19, '2019-03-02', 10, 187, NULL),
(1206, 20, '2019-03-02', 6, 62, NULL),
(1207, 21, '2019-03-02', 9, 90, NULL),
(1208, 22, '2019-03-02', 2, 10, NULL),
(1209, 23, '2019-03-02', 3, 26, NULL),
(1210, 24, '2019-03-02', 24, 500, NULL),
(1211, 25, '2019-03-02', 6, 145, NULL),
(1212, 1, '2019-03-08', 1, 6, NULL),
(1213, 2, '2019-03-08', 1, 15, NULL),
(1214, 3, '2019-03-08', 7, 147, NULL),
(1215, 4, '2019-03-08', 1, 8, NULL),
(1216, 7, '2019-03-08', 1, 10, NULL),
(1217, 8, '2019-03-08', 1, 11, NULL),
(1218, 9, '2019-03-08', 1, 7, NULL),
(1219, 10, '2019-03-08', 10, 142, NULL),
(1220, 12, '2019-03-08', 24, 597, NULL),
(1221, 13, '2019-03-08', 27, 662, NULL),
(1222, 14, '2019-03-08', 27, 671, NULL),
(1223, 15, '2019-03-08', 21, 546, NULL),
(1224, 18, '2019-03-08', 14, 148, NULL),
(1225, 19, '2019-03-08', 10, 187, NULL),
(1226, 20, '2019-03-08', 6, 62, NULL),
(1227, 21, '2019-03-08', 9, 90, NULL),
(1228, 22, '2019-03-08', 2, 10, NULL),
(1229, 23, '2019-03-08', 3, 26, NULL),
(1230, 24, '2019-03-08', 24, 500, NULL),
(1231, 25, '2019-03-08', 6, 145, NULL),
(1232, 1, '2019-03-14', 1, 6, NULL),
(1233, 2, '2019-03-14', 1, 15, NULL),
(1234, 3, '2019-03-14', 7, 147, NULL),
(1235, 4, '2019-03-14', 1, 8, NULL),
(1236, 7, '2019-03-14', 1, 10, NULL),
(1237, 8, '2019-03-14', 1, 11, NULL),
(1238, 9, '2019-03-14', 1, 7, NULL),
(1239, 10, '2019-03-14', 10, 142, NULL),
(1240, 12, '2019-03-14', 24, 597, NULL),
(1241, 13, '2019-03-14', 27, 662, NULL),
(1242, 14, '2019-03-14', 27, 671, NULL),
(1243, 15, '2019-03-14', 21, 546, NULL),
(1244, 18, '2019-03-14', 14, 148, NULL),
(1245, 19, '2019-03-14', 10, 187, NULL),
(1246, 20, '2019-03-14', 6, 62, NULL),
(1247, 21, '2019-03-14', 9, 90, NULL),
(1248, 22, '2019-03-14', 2, 10, NULL),
(1249, 23, '2019-03-14', 3, 26, NULL),
(1250, 24, '2019-03-14', 24, 500, NULL),
(1251, 25, '2019-03-14', 6, 145, NULL),
(1252, 1, '2019-03-23', 1, 6, NULL),
(1253, 2, '2019-03-23', 2, 15, NULL),
(1254, 3, '2019-03-23', 7, 147, NULL),
(1255, 4, '2019-03-23', 1, 8, NULL),
(1256, 7, '2019-03-23', 1, 10, NULL),
(1257, 8, '2019-03-23', 1, 11, NULL),
(1258, 9, '2019-03-23', 1, 7, NULL),
(1259, 10, '2019-03-23', 10, 142, NULL),
(1260, 12, '2019-03-23', 24, 597, NULL),
(1261, 13, '2019-03-23', 27, 662, NULL),
(1262, 14, '2019-03-23', 27, 671, NULL),
(1263, 15, '2019-03-23', 21, 546, NULL),
(1264, 18, '2019-03-23', 14, 148, NULL),
(1265, 19, '2019-03-23', 10, 187, NULL),
(1266, 20, '2019-03-23', 6, 62, NULL),
(1267, 21, '2019-03-23', 9, 90, NULL),
(1268, 22, '2019-03-23', 2, 10, NULL),
(1269, 23, '2019-03-23', 4, 26, NULL),
(1270, 24, '2019-03-23', 24, 500, NULL),
(1271, 25, '2019-03-23', 6, 145, NULL),
(1272, 1, '2019-03-30', 1, 6, NULL),
(1273, 2, '2019-03-30', 2, 15, NULL),
(1274, 3, '2019-03-30', 7, 147, NULL),
(1275, 4, '2019-03-30', 1, 8, NULL),
(1276, 7, '2019-03-30', 1, 10, NULL),
(1277, 8, '2019-03-30', 1, 11, NULL),
(1278, 9, '2019-03-30', 1, 7, NULL),
(1279, 10, '2019-03-30', 10, 142, NULL),
(1280, 12, '2019-03-30', 24, 597, NULL),
(1281, 13, '2019-03-30', 27, 662, NULL),
(1282, 14, '2019-03-30', 27, 671, NULL),
(1283, 15, '2019-03-30', 21, 546, NULL),
(1284, 18, '2019-03-30', 14, 148, NULL),
(1285, 19, '2019-03-30', 10, 187, NULL),
(1286, 20, '2019-03-30', 6, 62, NULL),
(1287, 21, '2019-03-30', 9, 90, NULL),
(1288, 22, '2019-03-30', 2, 10, NULL),
(1289, 23, '2019-03-30', 3, 26, NULL),
(1290, 24, '2019-03-30', 24, 500, NULL),
(1291, 25, '2019-03-30', 6, 145, NULL),
(1292, 1, '2019-04-07', 1, 6, NULL),
(1293, 2, '2019-04-07', 1, 15, NULL),
(1294, 4, '2019-04-07', 1, 8, NULL),
(1295, 3, '2019-04-07', 7, 147, NULL),
(1296, 7, '2019-04-07', 1, 10, NULL),
(1297, 8, '2019-04-07', 1, 11, NULL),
(1298, 9, '2019-04-07', 1, 7, NULL),
(1299, 10, '2019-04-07', 10, 142, NULL),
(1300, 12, '2019-04-07', 24, 597, NULL),
(1301, 13, '2019-04-07', 27, 662, NULL),
(1302, 14, '2019-04-07', 27, 671, NULL),
(1303, 15, '2019-04-07', 21, 546, NULL),
(1304, 18, '2019-04-07', 14, 148, NULL),
(1305, 19, '2019-04-07', 10, 187, NULL),
(1306, 20, '2019-04-07', 6, 62, NULL),
(1307, 21, '2019-04-07', 9, 90, NULL),
(1308, 22, '2019-04-07', 2, 10, NULL),
(1309, 23, '2019-04-07', 3, 26, NULL),
(1310, 24, '2019-04-07', 24, 500, NULL),
(1311, 25, '2019-04-07', 6, 145, NULL),
(1312, 1, '2019-04-15', 1, 6, NULL),
(1313, 2, '2019-04-15', 1, 15, NULL),
(1314, 3, '2019-04-15', 7, 147, NULL),
(1315, 4, '2019-04-15', 1, 8, NULL),
(1316, 7, '2019-04-15', 1, 10, NULL),
(1317, 8, '2019-04-15', 1, 11, NULL),
(1318, 9, '2019-04-15', 1, 7, NULL),
(1319, 10, '2019-04-15', 10, 142, NULL),
(1320, 12, '2019-04-15', 24, 597, NULL),
(1321, 13, '2019-04-15', 27, 662, NULL),
(1322, 14, '2019-04-15', 27, 671, NULL),
(1323, 15, '2019-04-15', 21, 546, NULL),
(1324, 18, '2019-04-15', 14, 148, NULL),
(1325, 19, '2019-04-15', 10, 187, NULL),
(1326, 20, '2019-04-15', 6, 62, NULL),
(1327, 21, '2019-04-15', 9, 90, NULL),
(1328, 22, '2019-04-15', 2, 10, NULL),
(1329, 23, '2019-04-15', 3, 26, NULL),
(1330, 24, '2019-04-15', 24, 500, NULL),
(1331, 25, '2019-04-15', 6, 145, NULL),
(1332, 1, '2019-04-24', 1, 6, NULL),
(1333, 2, '2019-04-24', 2, 15, NULL),
(1334, 3, '2019-04-24', 7, 147, NULL),
(1335, 4, '2019-04-24', 1, 8, NULL),
(1336, 7, '2019-04-24', 1, 10, NULL),
(1337, 8, '2019-04-24', 1, 11, NULL),
(1338, 9, '2019-04-24', 1, 7, NULL),
(1339, 10, '2019-04-24', 10, 142, NULL),
(1340, 12, '2019-04-24', 24, 597, NULL),
(1341, 13, '2019-04-24', 27, 662, NULL),
(1342, 14, '2019-04-24', 27, 671, NULL),
(1343, 15, '2019-04-24', 21, 546, NULL),
(1344, 18, '2019-04-24', 14, 148, NULL),
(1345, 19, '2019-04-24', 10, 187, NULL),
(1346, 20, '2019-04-24', 6, 62, NULL),
(1347, 21, '2019-04-24', 9, 90, NULL),
(1348, 22, '2019-04-24', 2, 9, NULL),
(1349, 23, '2019-04-24', 4, 26, NULL),
(1350, 24, '2019-04-24', 24, 500, NULL),
(1351, 25, '2019-04-24', 6, 145, NULL),
(1352, 1, '2019-04-30', 1, 6, NULL),
(1353, 2, '2019-04-30', 2, 15, NULL),
(1354, 3, '2019-04-30', 7, 147, NULL),
(1355, 4, '2019-04-30', 1, 8, NULL),
(1356, 7, '2019-04-30', 1, 10, NULL),
(1357, 8, '2019-04-30', 1, 11, NULL),
(1358, 9, '2019-04-30', 1, 7, NULL),
(1359, 10, '2019-04-30', 10, 142, NULL),
(1360, 12, '2019-04-30', 24, 597, NULL),
(1361, 13, '2019-04-30', 27, 662, NULL),
(1362, 14, '2019-04-30', 27, 671, NULL),
(1363, 15, '2019-04-30', 21, 546, NULL),
(1364, 18, '2019-04-30', 14, 148, NULL),
(1365, 19, '2019-04-30', 10, 187, NULL),
(1366, 20, '2019-04-30', 6, 62, NULL),
(1367, 21, '2019-04-30', 9, 90, NULL);
INSERT INTO `monthly_target` (`target_id`, `department_id`, `target_date`, `target_number`, `man_power`, `note`) VALUES
(1368, 22, '2019-04-30', 2, 9, NULL),
(1369, 23, '2019-04-30', 3, 26, NULL),
(1370, 24, '2019-04-30', 24, 500, NULL),
(1371, 25, '2019-04-30', 6, 145, NULL),
(1372, 1, '2019-05-09', 1, 6, NULL),
(1373, 2, '2019-05-09', 1, 15, NULL),
(1374, 3, '2019-05-09', 7, 147, NULL),
(1375, 4, '2019-05-09', 1, 8, NULL),
(1376, 7, '2019-05-09', 1, 10, NULL),
(1377, 8, '2019-05-09', 1, 11, NULL),
(1378, 9, '2019-05-09', 1, 7, NULL),
(1379, 10, '2019-05-09', 10, 142, NULL),
(1380, 12, '2019-05-09', 24, 597, NULL),
(1381, 13, '2019-05-09', 27, 662, NULL),
(1382, 14, '2019-05-09', 27, 671, NULL),
(1383, 15, '2019-05-09', 21, 546, NULL),
(1384, 18, '2019-05-09', 14, 148, NULL),
(1385, 19, '2019-05-09', 10, 187, NULL),
(1386, 20, '2019-05-09', 6, 62, NULL),
(1387, 21, '2019-05-09', 9, 90, NULL),
(1388, 22, '2019-05-09', 2, 9, NULL),
(1389, 23, '2019-05-09', 3, 26, NULL),
(1390, 24, '2019-05-09', 24, 500, NULL),
(1391, 25, '2019-05-09', 6, 145, NULL),
(1392, 1, '2019-05-14', 1, 6, NULL),
(1393, 2, '2019-05-14', 1, 15, NULL),
(1394, 3, '2019-05-14', 7, 147, NULL),
(1395, 4, '2019-05-14', 1, 8, NULL),
(1396, 7, '2019-05-14', 1, 10, NULL),
(1397, 8, '2019-05-14', 1, 11, NULL),
(1398, 9, '2019-05-14', 1, 7, NULL),
(1399, 10, '2019-05-14', 10, 142, NULL),
(1400, 12, '2019-05-14', 24, 597, NULL),
(1401, 13, '2019-05-14', 27, 662, NULL),
(1402, 14, '2019-05-14', 27, 671, NULL),
(1403, 15, '2019-05-14', 21, 546, NULL),
(1404, 18, '2019-05-14', 14, 148, NULL),
(1405, 19, '2019-05-14', 10, 187, NULL),
(1406, 20, '2019-05-14', 6, 62, NULL),
(1407, 21, '2019-05-14', 9, 90, NULL),
(1408, 22, '2019-05-14', 2, 9, NULL),
(1409, 23, '2019-05-14', 3, 26, NULL),
(1410, 24, '2019-05-14', 24, 500, NULL),
(1411, 25, '2019-05-14', 6, 145, NULL),
(1412, 1, '2019-05-22', 1, 6, NULL),
(1413, 2, '2019-05-22', 2, 15, NULL),
(1414, 3, '2019-05-22', 7, 147, NULL),
(1415, 4, '2019-05-22', 1, 8, NULL),
(1416, 7, '2019-05-22', 1, 10, NULL),
(1417, 8, '2019-05-22', 1, 11, NULL),
(1418, 9, '2019-05-22', 1, 7, NULL),
(1419, 10, '2019-05-22', 10, 142, NULL),
(1420, 12, '2019-05-22', 24, 597, NULL),
(1421, 13, '2019-05-22', 27, 662, NULL),
(1422, 14, '2019-05-22', 27, 671, NULL),
(1423, 15, '2019-05-22', 21, 546, NULL),
(1424, 18, '2019-05-22', 14, 148, NULL),
(1425, 19, '2019-05-22', 10, 187, NULL),
(1426, 20, '2019-05-22', 6, 62, NULL),
(1427, 21, '2019-05-22', 9, 90, NULL),
(1428, 22, '2019-05-22', 2, 9, NULL),
(1429, 23, '2019-05-22', 4, 26, NULL),
(1430, 24, '2019-05-22', 24, 500, NULL),
(1431, 25, '2019-05-22', 6, 145, NULL),
(1432, 1, '2019-05-29', 1, 6, NULL),
(1433, 2, '2019-05-29', 2, 15, NULL),
(1434, 3, '2019-05-29', 7, 147, NULL),
(1435, 4, '2019-05-29', 1, 8, NULL),
(1436, 7, '2019-05-29', 1, 10, NULL),
(1437, 8, '2019-05-29', 1, 11, NULL),
(1438, 9, '2019-05-29', 1, 7, NULL),
(1439, 10, '2019-05-29', 10, 142, NULL),
(1440, 12, '2019-05-29', 24, 597, NULL),
(1441, 13, '2019-05-29', 27, 662, NULL),
(1442, 14, '2019-05-29', 27, 671, NULL),
(1443, 15, '2019-05-29', 21, 546, NULL),
(1444, 18, '2019-05-29', 14, 148, NULL),
(1445, 19, '2019-05-29', 10, 187, NULL),
(1446, 20, '2019-05-29', 6, 62, NULL),
(1447, 21, '2019-05-29', 9, 90, NULL),
(1448, 22, '2019-05-29', 2, 9, NULL),
(1449, 23, '2019-05-29', 3, 26, NULL),
(1450, 24, '2019-05-29', 24, 500, NULL),
(1451, 25, '2019-05-29', 6, 145, NULL),
(1452, 1, '2019-06-09', 1, 6, NULL),
(1453, 2, '2019-06-09', 1, 15, NULL),
(1454, 3, '2019-06-09', 7, 147, NULL),
(1455, 4, '2019-06-09', 1, 8, NULL),
(1456, 7, '2019-06-09', 1, 10, NULL),
(1457, 8, '2019-06-09', 1, 11, NULL),
(1458, 9, '2019-06-09', 1, 7, NULL),
(1459, 10, '2019-06-09', 10, 142, NULL),
(1460, 12, '2019-06-09', 24, 597, NULL),
(1461, 13, '2019-06-09', 27, 662, NULL),
(1462, 14, '2019-06-09', 27, 671, NULL),
(1463, 15, '2019-06-09', 21, 546, NULL),
(1464, 18, '2019-06-09', 14, 148, NULL),
(1465, 19, '2019-06-09', 10, 187, NULL),
(1466, 20, '2019-06-09', 6, 62, NULL),
(1467, 21, '2019-06-09', 9, 90, NULL),
(1468, 22, '2019-06-09', 2, 9, NULL),
(1469, 23, '2019-06-09', 3, 26, NULL),
(1470, 24, '2019-06-09', 24, 500, NULL),
(1471, 25, '2019-06-09', 6, 145, NULL),
(1472, 1, '2019-06-15', 1, 6, NULL),
(1473, 2, '2019-06-15', 1, 15, NULL),
(1474, 3, '2019-06-15', 7, 147, NULL),
(1475, 4, '2019-06-15', 1, 8, NULL),
(1476, 7, '2019-06-15', 1, 10, NULL),
(1477, 8, '2019-06-15', 1, 11, NULL),
(1478, 9, '2019-06-15', 1, 7, NULL),
(1479, 10, '2019-06-15', 10, 142, NULL),
(1480, 12, '2019-06-15', 24, 597, NULL),
(1481, 13, '2019-06-15', 27, 662, NULL),
(1482, 14, '2019-06-15', 27, 671, NULL),
(1483, 15, '2019-06-15', 21, 546, NULL),
(1484, 18, '2019-06-15', 14, 148, NULL),
(1485, 19, '2019-06-15', 10, 187, NULL),
(1486, 20, '2019-06-15', 6, 62, NULL),
(1487, 21, '2019-06-15', 9, 90, NULL),
(1488, 22, '2019-06-15', 2, 9, NULL),
(1489, 23, '2019-06-15', 3, 26, NULL),
(1490, 24, '2019-06-15', 24, 500, NULL),
(1491, 25, '2019-06-15', 6, 145, NULL),
(1492, 1, '2019-06-25', 1, 6, NULL),
(1493, 2, '2019-06-25', 2, 15, NULL),
(1494, 3, '2019-06-25', 7, 147, NULL),
(1495, 4, '2019-06-25', 1, 8, NULL),
(1496, 7, '2019-06-25', 1, 10, NULL),
(1497, 8, '2019-06-25', 1, 11, NULL),
(1498, 9, '2019-06-25', 1, 7, NULL),
(1499, 10, '2019-06-25', 10, 142, NULL),
(1500, 12, '2019-06-25', 24, 597, NULL),
(1501, 13, '2019-06-25', 27, 662, NULL),
(1502, 14, '2019-06-25', 27, 671, NULL),
(1503, 15, '2019-06-25', 27, 691, NULL),
(1504, 18, '2019-06-25', 14, 148, NULL),
(1505, 19, '2019-06-25', 10, 187, NULL),
(1506, 20, '2019-06-25', 6, 62, NULL),
(1507, 21, '2019-06-25', 9, 90, NULL),
(1508, 22, '2019-06-25', 2, 9, NULL),
(1509, 23, '2019-06-25', 4, 26, NULL),
(1510, 24, '2019-06-25', 24, 500, NULL),
(1512, 1, '2019-06-30', 1, 6, NULL),
(1513, 2, '2019-06-30', 2, 15, NULL),
(1514, 3, '2019-06-30', 7, 147, NULL),
(1515, 4, '2019-06-30', 1, 8, NULL),
(1516, 7, '2019-06-30', 1, 10, NULL),
(1517, 8, '2019-06-30', 1, 11, NULL),
(1518, 9, '2019-06-30', 1, 7, NULL),
(1519, 10, '2019-06-30', 10, 142, NULL),
(1520, 12, '2019-06-30', 24, 597, NULL),
(1521, 13, '2019-06-30', 27, 662, NULL),
(1522, 14, '2019-06-30', 27, 671, NULL),
(1523, 15, '2019-06-30', 27, 691, NULL),
(1524, 18, '2019-06-30', 14, 148, NULL),
(1525, 19, '2019-06-30', 10, 187, NULL),
(1526, 20, '2019-06-30', 6, 62, NULL),
(1527, 21, '2019-06-30', 9, 90, NULL),
(1528, 22, '2019-06-30', 2, 9, NULL),
(1529, 23, '2019-06-30', 3, 26, NULL),
(1530, 24, '2019-06-30', 24, 500, NULL),
(1532, 1, '2019-07-06', 1, 6, NULL),
(1533, 2, '2019-07-06', 1, 15, NULL),
(1534, 3, '2019-07-06', 7, 147, NULL),
(1535, 4, '2019-07-06', 1, 8, NULL),
(1536, 7, '2019-07-06', 1, 10, NULL),
(1537, 8, '2019-07-06', 1, 11, NULL),
(1538, 9, '2019-07-06', 1, 7, NULL),
(1539, 10, '2019-07-06', 10, 142, NULL),
(1540, 12, '2019-07-06', 24, 597, NULL),
(1541, 13, '2019-07-06', 27, 662, NULL),
(1542, 14, '2019-07-06', 27, 671, NULL),
(1543, 15, '2019-07-06', 27, 691, NULL),
(1544, 18, '2019-07-06', 14, 148, NULL),
(1545, 19, '2019-07-06', 10, 187, NULL),
(1546, 20, '2019-07-06', 6, 62, NULL),
(1547, 21, '2019-07-06', 9, 90, NULL),
(1548, 22, '2019-07-06', 2, 9, NULL),
(1549, 23, '2019-07-06', 3, 26, NULL),
(1550, 24, '2019-07-06', 24, 500, NULL),
(1552, 1, '2019-07-14', 1, 6, NULL),
(1553, 2, '2019-07-14', 1, 15, NULL),
(1554, 3, '2019-07-14', 7, 147, NULL),
(1555, 4, '2019-07-14', 1, 8, NULL),
(1556, 7, '2019-07-14', 1, 10, NULL),
(1557, 8, '2019-07-14', 1, 11, NULL),
(1558, 9, '2019-07-14', 1, 7, NULL),
(1559, 10, '2019-07-14', 10, 142, NULL),
(1560, 12, '2019-07-14', 24, 597, NULL),
(1561, 13, '2019-07-14', 27, 662, NULL),
(1562, 14, '2019-07-14', 27, 671, NULL),
(1563, 15, '2019-07-14', 27, 691, NULL),
(1564, 18, '2019-07-14', 14, 148, NULL),
(1565, 19, '2019-07-14', 10, 187, NULL),
(1566, 20, '2019-07-14', 6, 62, NULL),
(1567, 21, '2019-07-14', 9, 90, NULL),
(1568, 22, '2019-07-14', 2, 9, NULL),
(1569, 23, '2019-07-14', 3, 26, NULL),
(1570, 24, '2019-07-14', 24, 500, NULL);

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

--
-- Table structure for table `org_info`
--

CREATE TABLE `org_info` (
  `org_id` tinyint(4) NOT NULL,
  `org_name` varchar(360) NOT NULL,
  `phone_no` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(750) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `org_info`
--

INSERT INTO `org_info` (`org_id`, `org_name`, `phone_no`, `email`, `address`) VALUES
(1, 'VLMBD', '01725888', 'opex@gmail.com', 'USA');

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

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `post_id` smallint(6) NOT NULL,
  `post_name` varchar(300) NOT NULL,
  `post_lavel` enum('Director','Employee') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`post_id`, `post_name`, `post_lavel`) VALUES
(2, 'Manager', 'Employee'),
(4, 'Asst. Manager', 'Employee'),
(5, 'Sr. Officer', 'Director'),
(6, 'Officer', 'Director'),
(7, 'Supervisor', 'Director'),
(8, 'QC', 'Director'),
(9, 'Office Peon', 'Employee'),
(10, 'Security Guard', 'Employee'),
(14, 'Excutive Officer', 'Employee'),
(15, 'PA of head of SCM', 'Director'),
(16, 'Jr Officer', 'Director');

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

--
-- Table structure for table `review_department_info`
--

CREATE TABLE `review_department_info` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `department_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `sys_menu`
--

CREATE TABLE `sys_menu` (
  `menu_id` int(11) NOT NULL,
  `menu_label` varchar(255) NOT NULL,
  `chinese_label` varchar(450) DEFAULT NULL,
  `link` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `parent` int(11) NOT NULL DEFAULT 0,
  `sort` int(11) NOT NULL,
  `head_office` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `sys_menu`
--

INSERT INTO `sys_menu` (`menu_id`, `menu_label`, `chinese_label`, `link`, `icon`, `parent`, `sort`, `head_office`) VALUES
(1, 'Dashboard', '主页', 'dashboard', 'fa fa-dashboard', 0, 1, 0),
(69, 'Configuration', '组态', '#', 'fa fa-gears', 0, 12, 0),
(70, 'Update Company Info', 'Update Company Info', 'configcontroller/changeCompanyInfo', 'fa fa-external-link-square', 69, 11, 0),
(71, 'Manage User', '用户管理', 'configcontroller/userList', 'fa fa-external-link-square', 69, 10, 0),
(72, 'Change Password', '修改密码', 'configcontroller/changePassword', 'fa fa-external-link-square', 0, 13, 0),
(78, 'Department List', '改善部门', 'department/lists', 'fa fa-puzzle-piece', 69, 6, 0),
(83, 'Submit KAIZEN', '提交改善', 'kaizen/lists', 'fa fa-snowflake-o', 90, 2, 0),
(85, 'Manage Designation', '职称管理', 'configcontroller/postList', 'fa fa-external-link-square', 69, 10, 0),
(87, 'Pending for Review', '待批改善清单', 'kaizenreceive/lists', 'fa fa-list', 90, 3, 0),
(88, 'Approved List', '已批改善清单', 'approved/lists', 'fa fa-check', 90, 4, 0),
(89, 'Rejected Lists', '拒批改善清单', 'rejected/lists', 'fa fa-ban', 90, 5, 0),
(90, 'General KAIZEN', '所有改善', '#', 'fa fa-bars', 0, 2, 0),
(91, 'Weekly Best KAIZEN', '横向推广改善', '#', 'fa fa-bars', 0, 3, 0),
(92, 'Pending Lists', '待批改善清单', 'ypending/lists', 'fa fa-bell', 91, 1, 0),
(93, 'Approved List', '已批改善清单', 'yapproved/lists', 'fa fa-check', 91, 2, 0),
(94, 'Rejected Lists', '拒批改善清单', 'yrejected/lists', 'fa fa-ban', 91, 3, 0),
(95, 'YOKOTEN Lists', '横向推广改善列表', 'yokoten/lists', 'fa fa-list', 91, 0, 0),
(96, 'Monthly Best KAIZEN', '最佳改善', '#', 'fa fa-usd', 0, 4, 0),
(97, 'Manage Target', '各部门改善目标管理', 'target/lists', 'fa fa-bullseye', 69, 0, 0),
(98, 'Manage Line', '各产线改善管理', 'floorline/lists', 'fa fa-bars', 69, 1, 0),
(99, 'Best KAIZEN List', '最佳改善清单', 'reward/lists', 'fa fa-list', 96, 1, 0),
(100, 'Pending Lists', '待批改善清单', 'bpending/lists', 'fa fa-clock-o', 96, 2, 0),
(101, 'Reports', '报告', '#', 'fa fa-paste', 0, 5, 0),
(102, 'QCPTMS  Report', '每日改善报告', 'datewise/searchForm', 'fa fa-paste', 101, 1, 0),
(103, 'Monthly Summary Report', '每月汇总报告', 'monthlysummary/searchForm', 'fa fa-paste', 101, 2, 0),
(104, 'Approved List', '已批改善清单', 'bapproved/lists', 'fa fa-check', 96, 3, 0),
(105, 'KPI Statistics', 'KPI统计', 'kpistatistic/searchForm', 'fa fa-paste', 101, 3, 0),
(106, 'Line Wise Target', '各产线改善目标', 'linetarget/lists', 'fa fa-bullseye', 69, 1, 0),
(107, 'Final Report', '历史改善报告', 'finalreport/searchForm', 'fa fa-paste', 101, 6, 0),
(108, 'KAIZEN Title', '改善主题', 'titles/lists', 'fa fa-check', 69, 1, 0),
(109, 'Rejected Lists', NULL, 'brejected/lists', 'fa fa-ban', 96, 4, 0);

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

--
-- Table structure for table `sys_user_role`
--

CREATE TABLE `sys_user_role` (
  `user_role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `sys_user_role`
--

INSERT INTO `sys_user_role` (`user_role_id`, `user_id`, `menu_id`) VALUES
(48, 5, 1),
(49, 5, 6),
(50, 5, 7),
(51, 5, 8),
(52, 5, 9),
(53, 5, 10),
(54, 5, 11),
(55, 5, 12),
(56, 5, 13),
(57, 5, 14),
(58, 5, 15),
(59, 5, 62),
(60, 5, 63),
(61, 5, 64),
(62, 5, 65),
(63, 5, 66),
(64, 5, 67),
(65, 5, 68),
(125, 6, 1),
(126, 6, 5),
(127, 6, 11),
(128, 6, 12),
(129, 6, 13),
(130, 6, 14),
(131, 6, 15),
(132, 6, 16),
(133, 6, 17),
(134, 6, 18),
(135, 6, 19),
(136, 6, 20),
(137, 6, 22),
(138, 6, 62),
(139, 6, 63),
(140, 6, 64),
(141, 6, 65),
(142, 6, 66),
(143, 6, 67),
(144, 6, 68),
(221, 4, 1),
(222, 4, 2),
(223, 4, 3),
(224, 4, 4),
(225, 4, 5),
(226, 4, 6),
(227, 4, 7),
(228, 4, 8),
(229, 4, 9),
(230, 4, 10),
(231, 4, 11),
(232, 4, 12),
(233, 4, 13),
(234, 4, 14),
(235, 4, 15),
(236, 4, 16),
(237, 4, 17),
(238, 4, 18),
(239, 4, 19),
(240, 4, 20),
(241, 4, 21),
(242, 4, 22),
(243, 4, 23),
(244, 4, 24),
(245, 4, 25),
(246, 4, 26),
(247, 4, 27),
(248, 4, 28),
(249, 4, 29),
(250, 4, 30),
(251, 4, 31),
(252, 4, 32),
(253, 4, 35),
(254, 4, 33),
(255, 4, 34),
(256, 4, 36),
(257, 4, 37),
(258, 4, 47),
(259, 4, 62),
(260, 4, 63),
(261, 4, 64),
(262, 4, 65),
(263, 4, 66),
(264, 4, 67),
(265, 4, 68),
(266, 4, 72),
(267, 1, 1),
(268, 1, 2),
(269, 1, 3),
(270, 1, 4),
(271, 1, 5),
(272, 1, 6),
(273, 1, 7),
(274, 1, 8),
(275, 1, 9),
(276, 1, 10),
(277, 1, 11),
(278, 1, 12),
(279, 1, 13),
(280, 1, 14),
(281, 1, 15),
(282, 1, 16),
(283, 1, 17),
(284, 1, 18),
(285, 1, 19),
(286, 1, 20),
(287, 1, 21),
(288, 1, 22),
(289, 1, 23),
(290, 1, 24),
(291, 1, 25),
(292, 1, 26),
(293, 1, 27),
(294, 1, 28),
(295, 1, 29),
(296, 1, 30),
(297, 1, 31),
(298, 1, 32),
(299, 1, 35),
(300, 1, 33),
(301, 1, 34),
(302, 1, 36),
(303, 1, 37),
(304, 1, 47),
(305, 1, 38),
(306, 1, 39),
(307, 1, 40),
(308, 1, 41),
(309, 1, 42),
(310, 1, 43),
(311, 1, 44),
(312, 1, 45),
(313, 1, 46),
(314, 1, 48),
(315, 1, 49),
(316, 1, 50),
(317, 1, 51),
(318, 1, 52),
(319, 1, 53),
(320, 1, 54),
(321, 1, 55),
(322, 1, 56),
(323, 1, 57),
(324, 1, 58),
(325, 1, 59),
(326, 1, 60),
(327, 1, 61),
(328, 1, 73),
(329, 1, 76),
(330, 1, 62),
(331, 1, 63),
(332, 1, 64),
(333, 1, 65),
(334, 1, 66),
(335, 1, 67),
(336, 1, 68),
(337, 1, 75),
(338, 1, 69),
(339, 1, 70),
(340, 1, 71),
(341, 1, 74),
(342, 1, 72),
(344, 9, 1),
(345, 9, 72),
(346, 9, 90),
(347, 9, 83),
(348, 9, 87),
(349, 9, 88),
(350, 9, 89),
(351, 9, 91),
(352, 9, 93),
(353, 9, 94),
(354, 9, 95),
(355, 9, 96),
(356, 9, 99),
(372, 11, 1),
(373, 11, 72),
(374, 11, 90),
(375, 11, 83),
(376, 11, 87),
(377, 11, 88),
(378, 11, 89),
(379, 11, 91),
(380, 11, 95),
(381, 11, 96),
(382, 11, 99),
(383, 12, 1),
(384, 12, 72),
(385, 12, 90),
(386, 12, 83),
(387, 12, 87),
(388, 12, 88),
(389, 12, 89),
(390, 12, 91),
(391, 12, 95),
(392, 12, 96),
(393, 12, 99),
(422, 16, 1),
(423, 16, 72),
(424, 16, 90),
(425, 16, 83),
(426, 16, 87),
(427, 16, 88),
(428, 16, 89),
(429, 16, 91),
(430, 16, 92),
(431, 16, 93),
(432, 16, 94),
(433, 16, 95),
(434, 16, 96),
(435, 16, 99),
(436, 16, 100),
(437, 16, 104),
(871, 27, 1),
(872, 27, 72),
(873, 27, 90),
(874, 27, 83),
(875, 27, 87),
(876, 27, 88),
(877, 27, 89),
(878, 27, 91),
(879, 27, 93),
(880, 27, 94),
(881, 27, 95),
(882, 27, 96),
(883, 27, 99),
(884, 27, 101),
(885, 27, 103),
(1383, 28, 1),
(1384, 28, 90),
(1385, 28, 83),
(1386, 28, 87),
(1387, 28, 88),
(1388, 28, 89),
(1389, 28, 91),
(1390, 28, 93),
(1391, 28, 94),
(1392, 28, 95),
(1393, 28, 96),
(1394, 28, 99),
(1395, 28, 104),
(1396, 28, 101),
(1397, 28, 102),
(1398, 28, 103),
(1399, 28, 105),
(1435, 32, 1),
(1436, 32, 72),
(1437, 32, 90),
(1438, 32, 88),
(1439, 32, 89),
(1440, 32, 91),
(1441, 32, 92),
(1442, 32, 93),
(1443, 32, 94),
(1444, 32, 95),
(1445, 32, 96),
(1446, 32, 99),
(1447, 32, 100),
(1448, 32, 104),
(1449, 32, 109),
(1450, 32, 101),
(1451, 32, 102),
(1452, 32, 103),
(1453, 32, 105),
(1454, 32, 107),
(1578, 13, 1),
(1579, 13, 72),
(1580, 13, 90),
(1581, 13, 83),
(1582, 13, 87),
(1583, 13, 88),
(1584, 13, 89),
(1585, 13, 91),
(1586, 13, 92),
(1587, 13, 93),
(1588, 13, 94),
(1589, 13, 95),
(1590, 13, 96),
(1591, 13, 99),
(1592, 13, 100),
(1593, 13, 104),
(1594, 13, 109),
(1595, 13, 101),
(1596, 13, 102),
(1597, 13, 103),
(1598, 13, 105),
(1599, 13, 107),
(2217, 35, 1),
(2218, 35, 72),
(2219, 35, 90),
(2220, 35, 83),
(2221, 35, 87),
(2222, 35, 88),
(2223, 35, 89),
(2224, 35, 91),
(2225, 35, 93),
(2226, 35, 94),
(2227, 35, 95),
(2228, 35, 96),
(2229, 35, 99),
(2230, 35, 104),
(2231, 35, 109),
(2232, 35, 101),
(2233, 35, 102),
(2234, 35, 103),
(2235, 35, 105),
(2236, 36, 1),
(2256, 33, 1),
(2257, 33, 72),
(2258, 33, 91),
(2259, 33, 92),
(2260, 33, 93),
(2261, 33, 94),
(2262, 33, 95),
(2263, 31, 1),
(2264, 31, 72),
(2265, 31, 90),
(2266, 31, 83),
(2267, 31, 87),
(2268, 31, 88),
(2269, 31, 89),
(2270, 31, 91),
(2271, 31, 93),
(2272, 31, 94),
(2273, 31, 95),
(2274, 31, 96),
(2275, 31, 99),
(2276, 31, 104),
(2277, 31, 101),
(2278, 31, 102),
(2279, 31, 103),
(2297, 29, 1),
(2298, 29, 72),
(2299, 29, 90),
(2300, 29, 83),
(2301, 29, 87),
(2302, 29, 88),
(2303, 29, 89),
(2304, 29, 91),
(2305, 29, 93),
(2306, 29, 94),
(2307, 29, 95),
(2308, 29, 96),
(2309, 29, 99),
(2310, 29, 104),
(2311, 29, 101),
(2312, 29, 102),
(2313, 29, 103),
(2314, 26, 1),
(2315, 26, 72),
(2316, 26, 90),
(2317, 26, 83),
(2318, 26, 87),
(2319, 26, 88),
(2320, 26, 89),
(2321, 26, 91),
(2322, 26, 93),
(2323, 26, 94),
(2324, 26, 95),
(2325, 26, 96),
(2326, 26, 99),
(2327, 26, 104),
(2328, 26, 101),
(2329, 26, 102),
(2330, 26, 103),
(2331, 26, 105),
(2332, 25, 1),
(2333, 25, 72),
(2334, 25, 90),
(2335, 25, 83),
(2336, 25, 87),
(2337, 25, 88),
(2338, 25, 89),
(2339, 25, 91),
(2340, 25, 93),
(2341, 25, 94),
(2342, 25, 95),
(2343, 25, 96),
(2344, 25, 99),
(2345, 25, 104),
(2346, 25, 101),
(2347, 25, 102),
(2348, 25, 103),
(2349, 25, 105),
(2350, 24, 1),
(2351, 24, 72),
(2352, 24, 90),
(2353, 24, 83),
(2354, 24, 87),
(2355, 24, 88),
(2356, 24, 89),
(2357, 24, 91),
(2358, 24, 93),
(2359, 24, 94),
(2360, 24, 95),
(2361, 24, 96),
(2362, 24, 99),
(2363, 24, 104),
(2364, 24, 101),
(2365, 24, 102),
(2366, 24, 103),
(2367, 24, 105),
(2368, 23, 1),
(2369, 23, 72),
(2370, 23, 90),
(2371, 23, 83),
(2372, 23, 87),
(2373, 23, 88),
(2374, 23, 89),
(2375, 23, 91),
(2376, 23, 93),
(2377, 23, 94),
(2378, 23, 95),
(2379, 23, 96),
(2380, 23, 99),
(2381, 23, 104),
(2382, 23, 101),
(2383, 23, 102),
(2384, 23, 103),
(2385, 23, 105),
(2386, 22, 1),
(2387, 22, 72),
(2388, 22, 90),
(2389, 22, 83),
(2390, 22, 87),
(2391, 22, 88),
(2392, 22, 89),
(2393, 22, 91),
(2394, 22, 93),
(2395, 22, 94),
(2396, 22, 95),
(2397, 22, 96),
(2398, 22, 99),
(2399, 22, 100),
(2400, 22, 104),
(2401, 22, 101),
(2402, 22, 103),
(2403, 21, 1),
(2404, 21, 72),
(2405, 21, 90),
(2406, 21, 83),
(2407, 21, 87),
(2408, 21, 88),
(2409, 21, 89),
(2410, 21, 91),
(2411, 21, 93),
(2412, 21, 94),
(2413, 21, 95),
(2414, 21, 96),
(2415, 21, 99),
(2416, 21, 104),
(2417, 21, 101),
(2418, 21, 103),
(2419, 20, 1),
(2420, 20, 72),
(2421, 20, 90),
(2422, 20, 83),
(2423, 20, 87),
(2424, 20, 88),
(2425, 20, 89),
(2426, 20, 91),
(2427, 20, 93),
(2428, 20, 94),
(2429, 20, 95),
(2430, 20, 96),
(2431, 20, 99),
(2432, 20, 104),
(2433, 20, 101),
(2434, 20, 103),
(2435, 19, 1),
(2436, 19, 72),
(2437, 19, 90),
(2438, 19, 83),
(2439, 19, 87),
(2440, 19, 88),
(2441, 19, 89),
(2442, 19, 91),
(2443, 19, 93),
(2444, 19, 94),
(2445, 19, 95),
(2446, 19, 96),
(2447, 19, 99),
(2448, 19, 104),
(2449, 19, 101),
(2450, 19, 103),
(2467, 17, 1),
(2468, 17, 72),
(2469, 17, 90),
(2470, 17, 83),
(2471, 17, 87),
(2472, 17, 88),
(2473, 17, 89),
(2474, 17, 91),
(2475, 17, 93),
(2476, 17, 94),
(2477, 17, 95),
(2478, 17, 96),
(2479, 17, 99),
(2480, 17, 104),
(2481, 17, 101),
(2482, 17, 103),
(2483, 18, 1),
(2484, 18, 72),
(2485, 18, 90),
(2486, 18, 83),
(2487, 18, 87),
(2488, 18, 88),
(2489, 18, 89),
(2490, 18, 91),
(2491, 18, 93),
(2492, 18, 94),
(2493, 18, 95),
(2494, 18, 96),
(2495, 18, 99),
(2496, 18, 104),
(2497, 18, 101),
(2498, 18, 103),
(2499, 15, 1),
(2500, 15, 72),
(2501, 15, 90),
(2502, 15, 83),
(2503, 15, 87),
(2504, 15, 88),
(2505, 15, 89),
(2506, 15, 91),
(2507, 15, 93),
(2508, 15, 94),
(2509, 15, 95),
(2510, 15, 96),
(2511, 15, 99),
(2512, 15, 104),
(2513, 15, 101),
(2514, 15, 102),
(2515, 15, 103),
(2516, 14, 1),
(2517, 14, 72),
(2518, 14, 90),
(2519, 14, 83),
(2520, 14, 87),
(2521, 14, 88),
(2522, 14, 89),
(2523, 14, 91),
(2524, 14, 93),
(2525, 14, 94),
(2526, 14, 95),
(2527, 14, 96),
(2528, 14, 99),
(2529, 14, 104),
(2530, 14, 101),
(2531, 14, 103),
(2563, 37, 1),
(2564, 37, 72),
(2565, 37, 90),
(2566, 37, 83),
(2567, 37, 87),
(2568, 37, 88),
(2569, 37, 89),
(2570, 37, 101),
(2571, 37, 102),
(2572, 37, 103),
(2649, 8, 1),
(2650, 10, 1),
(2651, 10, 72),
(2652, 10, 90),
(2653, 10, 83),
(2654, 10, 87),
(2655, 10, 88),
(2656, 10, 89),
(2657, 10, 91),
(2658, 10, 93),
(2659, 10, 94),
(2660, 10, 95),
(2661, 10, 96),
(2662, 10, 99),
(2663, 10, 104),
(2664, 10, 109),
(2665, 10, 101),
(2666, 10, 102),
(2667, 10, 103),
(2668, 10, 105),
(2669, 10, 107),
(2670, 38, 1),
(2671, 38, 72),
(2672, 38, 90),
(2673, 38, 83),
(2674, 38, 88),
(2675, 38, 101),
(2676, 38, 102),
(2677, 39, 1),
(2678, 39, 69),
(2679, 39, 97),
(2680, 39, 98),
(2681, 39, 106),
(2682, 39, 108),
(2683, 39, 72),
(2684, 39, 90),
(2685, 39, 83),
(2686, 39, 87),
(2687, 39, 88),
(2688, 39, 101),
(2689, 39, 102),
(2690, 39, 103),
(2691, 39, 105),
(2692, 39, 107),
(2693, 40, 1),
(2694, 40, 72),
(2695, 40, 90),
(2696, 40, 83),
(2697, 40, 87),
(2698, 40, 88),
(2699, 40, 89),
(2700, 40, 101),
(2701, 40, 102),
(2702, 40, 103),
(2703, 40, 105),
(2704, 40, 107),
(2705, 34, 1),
(2706, 34, 72),
(2707, 34, 90),
(2708, 34, 83),
(2709, 34, 87),
(2710, 34, 88),
(2711, 34, 89),
(2712, 34, 91),
(2713, 34, 93),
(2714, 34, 94),
(2715, 34, 95),
(2716, 34, 96),
(2717, 34, 99),
(2718, 34, 104),
(2719, 34, 109),
(2720, 34, 101),
(2721, 34, 102),
(2722, 34, 103),
(2723, 34, 105),
(2724, 30, 1),
(2725, 30, 72),
(2726, 30, 90),
(2727, 30, 83),
(2728, 30, 87),
(2729, 30, 88),
(2730, 30, 89),
(2731, 30, 91),
(2732, 30, 93),
(2733, 30, 94),
(2734, 30, 95),
(2735, 30, 96),
(2736, 30, 99),
(2737, 30, 104),
(2738, 30, 101),
(2739, 30, 102),
(2740, 30, 103);

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

--
-- Table structure for table `titles`
--

CREATE TABLE `titles` (
  `titles_id` int(11) NOT NULL,
  `titles_name` varchar(300) NOT NULL,
  `department_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `titles`
--

INSERT INTO `titles` (`titles_id`, `titles_name`, `department_id`) VALUES
(1, 'Manual Sytem to Automation System', 1),
(2, 'Record Export as per BL Date', 4),
(3, 'Tax Clearance Certificate of CN Staff', 4),
(4, 'Cash Disbursement', 4),
(5, 'Market Price Verification', 4),
(6, 'Material Reason Code Related', 4),
(7, 'Tax Return Format', 4),
(8, 'Monthly Report', 4),
(9, 'VAT related Work', 4),
(10, 'Cost Saving', 4),
(11, 'Time Saving', 4),
(12, 'Bill Checking Systems', 9),
(13, 'Controlling Cost', 9),
(14, 'Garbage Management Systems', 9),
(15, 'HR Related', 9),
(16, 'Machine Related.', 9),
(17, 'Production Control', 9),
(18, 'QC Related', 9),
(19, 'Reporting Systems', 9),
(20, 'Warehouse Control', 9),
(21, 'Work procedure/ workflow/ SOP', 9),
(22, 'Pattern Modification & Use', 13),
(23, 'working time save', 13),
(24, 'Support Form & Pot Use', 13),
(25, 'Sewing & Painting Time Save', 13),
(26, 'Leather Optimization', 13),
(27, 'Glue Save', 13),
(28, 'Leather Save', 13),
(29, 'Pattern Change', 13),
(30, 'Quality improvement.', 13),
(31, 'By Using Pattern to Improve Quality', 12),
(32, 'Pattern Modification & Use', 12),
(33, 'Line Balancing & Save Time', 12),
(34, 'Change of Sewing System', 12),
(35, 'Save Glue or Tape', 12),
(36, 'Using Masking Tape to improve Quality', 12),
(37, 'Using Cut mark of Pattern', 12),
(38, 'Leather Save', 12),
(39, 'Using  a Box to Improve S6S', 12),
(40, 'Making a new format of report.', 22),
(41, 'Sharing the proccess among the TMs to balance the line', 22),
(42, 'Save the unnecessary TMs', 22),
(43, 'Modifying the working patterns', 22),
(44, 'Making a new pattern to improve quality & productivity', 22),
(45, 'New System implementation', 22),
(46, 'Cutting Die Update', 18),
(47, 'Mold/Jigs Update.', 18),
(48, 'SOP Update', 18),
(49, 'Quality Improvement', 18),
(50, 'Working Process Changing.', 18),
(51, 'Tools Update', 18),
(52, 'Reinforcement Update', 18),
(53, 'Paper Pattern Update', 18),
(54, 'Pattern change', 15),
(55, 'Cut mark in knife', 15),
(56, 'Safety guard', 15),
(57, 'Quality improvement', 15),
(58, 'Reinforcement add', 15),
(59, 'Knife change', 15),
(60, 'Painting material placement', 15),
(61, 'Reduce/adjust the skiving and splitting measurement', 15),
(62, 'Using Pattern', 15),
(63, 'Process modification', 15),
(64, 'On Time Delivery Improvement', 20),
(65, 'Quality Improvement', 20),
(66, 'Production Cost Minimization', 20),
(67, 'Production Efficiency Improvement', 20),
(68, 'Man/Machine/Material/Method proper utilization', 20),
(69, 'Layout improvement to get more efficiency', 20),
(70, 'Safety Improvement', 20),
(71, 'Standardization Improvement (Higher Standard)', 20),
(72, 'Productivity Improvement', 20),
(73, 'Waste Minimize by reducing non value work', 20),
(74, 'About Manpower', 10),
(75, 'Improvement of imported materials and its system', 10),
(76, 'O\'way of  Incoming materials.', 10),
(77, 'Materials sending procidule.', 10),
(78, 'Materials receiving procidule.', 10),
(79, 'Improvement of the inspection process.', 10),
(80, 'Improvement of data report.', 10),
(81, 'About Materials Or Bag Test', 10),
(82, 'Materials storage system', 10),
(83, 'About Zipper management', 10),
(84, 'Punching press new system', 21),
(85, 'Switch Improve.', 21),
(86, 'Quality improve.', 21),
(87, 'Pressure feed change.', 21),
(88, 'Work process change.', 21),
(89, 'Tools improve.', 21),
(90, 'SOP stand update', 21),
(91, 'Delivery improve.', 21),
(92, 'Manual to auto system', 21),
(93, 'Stitch by folder.', 21),
(94, 'Pattern change according to the pilot bag.', 16),
(95, 'Pattern change according to the pilot bag.', 17),
(96, 'Mould change', 16),
(97, 'Mould change', 17),
(98, 'Knife change', 16),
(99, 'Knife change', 17),
(100, 'Skiving thickness change', 16),
(101, 'Skiving thickness change', 17),
(102, 'Hot mark improve always according to leather quality. Different leather not yet same pressure and also heat.', 16),
(103, 'Hot mark improve always according to leather quality. Different leather not yet same pressure and also heat.', 17),
(104, 'Material settings', 16),
(105, 'Material settings', 17),
(106, 'Computer pattern change', 16),
(107, 'Computer pattern change', 17),
(108, 'Safety', 16),
(109, 'Safety', 17),
(110, 'CC part wrinkle', 16),
(111, 'CC part wrinkle', 17),
(112, 'CC part settings', 16),
(113, 'CC part settings', 17),
(114, 'Net cut pattern always change to improvement.', 16),
(115, 'Net cut pattern always change to improvement.', 17),
(116, 'Punching press new system.', 21),
(117, 'Document format upgrade', 7),
(118, 'Time saving', 7),
(119, 'Stop Over process', 7),
(120, 'Reduce depend on China side', 7),
(121, 'Cost Saving', 7),
(122, 'Work process development', 7),
(123, 'Customer Satisfaction', 7),
(124, 'Lead time reduce', 7),
(125, 'Increase Work Efficiency', 7),
(126, 'Save demurrage from CTG logistics side', 8),
(127, 'Save demurrage from factory logistics side', 8),
(128, 'Development of container loading plan at CWH.', 8),
(129, 'Developing the online TRUCKING SYSTEM.', 8),
(130, 'Developing the check list sending record', 8),
(131, 'Developing the information of lead time', 8),
(132, 'Preventive action', 8),
(133, 'Quality work', 8),
(134, 'Developing the work process', 8),
(135, 'Cost save.', 8),
(136, 'Saving Hardware from been scrached.', 14),
(137, 'Skiving thickness change.', 14),
(138, 'Pattern Modify for better quality.', 14),
(139, 'Handle sewing pattern scraped for saving logo back plate from becoming scrached.', 14),
(140, 'Cost Saving', 14),
(141, 'Wastage Recycling.', 14),
(142, 'Gluing method Change.', 14),
(143, 'CNC Machine pattern modification', 14),
(144, 'Quality Improvement.', 14),
(145, 'Sewing method change.', 14),
(146, 'Work  quality improvement.', 2),
(147, 'Cost minimization.', 2),
(148, 'Process Improvement.', 2),
(149, 'Utilization of resources.', 2),
(150, 'Waste minimization.', 2),
(151, 'Improving morality.', 2),
(152, 'Creating a process.', 2),
(153, 'Documentation & formate updating', 19),
(154, 'Time Saving', 19),
(155, 'Quality Improving System', 19),
(156, 'Management Systems', 19),
(157, 'Reporting Systems', 19),
(158, 'SOP Updating', 19),
(159, 'Safety', 19),
(160, 'Checking Tools / Pattern', 19),
(161, 'Cost Saving', 19),
(162, 'Cost Saving', 3),
(163, 'SOP Update', 3),
(164, 'Repair and maintenance', 3),
(165, 'Man Power Allocation', 3),
(166, 'Awareness build up signage.', 3),
(167, 'Checking Register & guidline', 3),
(168, 'Structural Development.', 3),
(169, 'Disciplinary', 3),
(170, 'Safety', 3),
(171, 'Documentary', 3),
(172, 'Sewing', 16),
(173, 'Sewing', 17),
(174, 'ME- Some Adjustment', 16),
(175, 'ME- Some Adjustment', 17),
(176, 'ME- Rearrange', 16),
(177, 'ME- Rearrange', 17),
(178, 'Bottom Part Wrinkle', 16),
(179, 'Bottom Part Wrinkle', 17),
(180, 'Using skive or split to improve quality', 12),
(181, 'Adding Skiving Operation into the process', 12),
(182, 'Adding splitting operation into the process', 12),
(183, 'Adding Folding Process to improve Quality', 12),
(184, 'Save the Thread', 12),
(185, 'Quality Improvement', 12),
(186, 'Provide SOP for user.', 1),
(187, 'Prepared salary Certificate.', 4),
(188, 'Prepared Tax Certificate.', 4),
(189, 'Prepared separate excel sheet of performance bonus of CN Staff\'s', 4),
(190, 'Submit bill of Snack\'s for BD Staff within particular date', 4),
(191, 'Saving cost for printer', 1),
(192, 'Final Settlement amount booked in ERP.', 4),
(193, 'WIFI Configuration', 1),
(194, 'Bill Checking system improvement and Keeping Document.', 4),
(195, 'Project plan development.', 1),
(196, 'Developing the Invoice sending system & keep actual record', 4),
(197, 'Local Purchase Price List', 4),
(198, 'About MS Office', 1),
(199, 'Cloud Security Improved', 1),
(200, 'Printer Issue solve', 1),
(201, 'Quality Improvement', 23),
(202, 'Layout improvement continuously', 23),
(203, 'Optimum Utilization of resources', 23),
(204, 'Method development', 23),
(205, 'Reduce Cost', 23),
(206, 'New Method & Idea development', 23),
(207, 'Productivity Increase', 23),
(208, 'Prepared checklist for Final settlement bills', 4),
(209, 'Mould change', 24),
(210, 'Knife change', 24),
(211, 'Skiving thickness change', 24),
(212, 'Hot mark improve always according to leather quality. Different leather not yet same pressure and also heat.', 24),
(213, 'Material settings', 24),
(214, 'Computer pattern change', 24),
(215, 'Safety', 24),
(216, 'CC part wrinkle', 24),
(217, 'CC part settings', 24),
(218, 'Net cut pattern always change to improvement.', 24),
(219, 'Sewing', 24),
(220, 'ME- Some Adjustment', 24),
(221, 'ME- Rearrange', 24),
(222, 'Bottom Part Wrinkle', 24),
(223, 'Document Submission', 4),
(224, 'Pattern change according to pilot bag', 24),
(225, 'Inner settings', 24),
(226, 'Software Troubleshooting', 1),
(227, 'CCTV Work', 1),
(228, 'Process modification', 25),
(229, 'Pattern change', 25),
(230, 'Cut mark in knife', 25),
(231, 'Safety guard', 25),
(232, 'Quality improvement', 25),
(233, 'Reinforcement add', 25),
(234, 'Knife change', 25),
(235, 'Painting material placement', 25),
(236, 'Reduce/adjust the skiving and splitting measurement', 25),
(237, 'Using Pattern', 25),
(238, 'Process modification', 26),
(239, 'Pattern change', 26),
(240, 'Cut mark in knife', 26),
(241, 'Safety guard', 26),
(242, 'Quality improvement', 26),
(243, 'Reinforcement add', 26),
(244, 'Knife change', 26),
(245, 'Painting material placement', 26),
(246, 'Reduce/adjust the skiving and splitting measurement', 26),
(247, 'Using Pattern', 26);

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'ACTIVE',
  `user_name` varchar(255) DEFAULT NULL,
  `email_address` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `org_id` int(11) NOT NULL DEFAULT 0,
  `post_id` tinyint(4) NOT NULL,
  `role` varchar(255) DEFAULT NULL,
  `super_user` tinyint(4) NOT NULL DEFAULT 0,
  `photo` varchar(255) NOT NULL,
  `update` varchar(255) NOT NULL,
  `delete` varchar(255) NOT NULL,
  `number_sub` varchar(255) NOT NULL,
  `department_id` int(11) DEFAULT NULL,
  `review_department` varchar(255) DEFAULT NULL,
  `language` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `status`, `user_name`, `email_address`, `mobile`, `password`, `org_id`, `post_id`, `role`, `super_user`, `photo`, `update`, `delete`, `number_sub`, `department_id`, `review_department`, `language`) VALUES
(8, 'ACTIVE', 'Golam Mostofa', 'golam.mostofa@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 6, '1', 1, 'avatar5.png', 'YES', 'YES', 'IT', 1, '1,3,', 'english'),
(14, 'ACTIVE', 'Ashraf Ullah ', 'ashraf.ullah@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 5, NULL, 0, 'avatar5.png', 'YES', 'YES', 'HR', 2, '1', 'english'),
(15, 'ACTIVE', 'Aynal Hoque', 'aynal.haque@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 5, NULL, 0, 'avatar5.png', 'YES', 'YES', 'ADM', 3, '2', 'english'),
(17, 'ACTIVE', 'Jwel Ahmmed', 'jwel.ahmmed@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 2, NULL, 0, 'avatar5.png', 'YES', 'YES', 'F&A', 4, '9', 'english'),
(18, 'ACTIVE', 'Sarwar Hossen', 'sarwar.hossen@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 2, NULL, 0, 'Md._Sarwar_sir__.jpg', 'YES', 'YES', 'IA', 9, '4', 'english'),
(19, 'ACTIVE', 'Razebul Hasan Ruman ', 'razebul.hasan@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 6, NULL, 0, '732ead5965c6058c6610c2fbee794df3_1.jpg', 'YES', 'YES', 'MER', 7, '19', 'english'),
(20, 'ACTIVE', 'Arif Hossain', 'arif.hossain@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 5, NULL, 0, 'WeChat_Image_20171113104448.jpg', 'YES', 'YES', 'LOG', 8, '10', 'english'),
(21, 'ACTIVE', 'Rasaduzzaman Rasel', 'rasel@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 5, NULL, 0, 'avatar5.png', 'YES', 'YES', 'QC&QA', 19, '7', 'english'),
(22, 'ACTIVE', 'Mehadi Hasan', 'mehadi.hasan@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 15, NULL, 0, 'avatar5.png', 'YES', 'YES', 'SCM', 10, '8', 'english'),
(23, 'ACTIVE', 'Aminul Islam', 'aminul.islam@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 5, NULL, 0, '3878632802357902450.jpg', 'YES', 'YES', 'A', 12, '13', 'english'),
(24, 'ACTIVE', 'Asraful Rahman', 'asrafur.rahman@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 5, NULL, 0, 'avatar5.png', 'YES', 'YES', 'B', 13, '14', 'english'),
(25, 'ACTIVE', 'Sayed Tamzid', 'tamzid.hossain@bdventura.com', '01708134007', 'e10adc3949ba59abbe56e057f20f883e', 1, 6, NULL, 0, '9074.jpg', 'YES', 'YES', 'C', 14, '15', 'english'),
(26, 'ACTIVE', 'Kazi Mahmudul', 'kazi.mahmudul@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 5, NULL, 0, 'avatar5.png', 'YES', 'YES', 'D', 15, '24', 'english'),
(27, 'DEACTIVE', 'Anupam Paul ', 'anupam.paul@bdventura.com1', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 6, NULL, 0, 'avatar5.png', 'YES', 'YES', 'SLG-A', 16, '15', 'english'),
(28, 'DEACTIVE', 'Anupam Paul', 'anupam.paul@bdventura.com1', 'kaizen@bdventur', 'e10adc3949ba59abbe56e057f20f883e', 1, 6, NULL, 0, 'avatar5.png', 'YES', 'YES', 'SLG-B', 17, '15', 'english'),
(29, 'ACTIVE', 'Abul Kalam Azad ', 'azad.kalam@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 4, NULL, 0, 'WeChat_Image_20190307154901.jpg', 'YES', 'YES', 'PP', 20, '22', 'english'),
(30, 'ACTIVE', 'Imam Hossain', 'imam.hossain@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 6, NULL, 0, 'Rabbi-N.jpg', 'YES', 'YES', 'PE', 18, '21,', 'english'),
(31, 'ACTIVE', 'Faridul Islam', 'faridul.islam@bdventura.com', '', 'fcea920f7412b5da7be0cf42b8c93759', 1, 16, NULL, 0, 'WeChat_Image_20180527071315.jpg', 'YES', 'YES', 'ME', 21, '18', 'english'),
(33, 'ACTIVE', 'Evan Cheng', 'evan.chen@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 14, NULL, 0, 'avatar5.png', 'YES', 'NO', 'PE', 18, '0', 'chinese'),
(34, 'ACTIVE', 'Sharif Hossain', 'sharif.hossain@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 6, NULL, 0, 'avatar5.png', 'YES', 'YES', 'IM', 23, '23,', 'english'),
(35, 'ACTIVE', 'Anupam Paul', 'anupam.paul@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 5, NULL, 0, 'avatar5.png', 'YES', 'YES', 'SLG', 24, '12', 'english'),
(36, 'ACTIVE', 'Rezwanul Islam', 'kaizen@bdventura.com', '01708134093', 'e10adc3949ba59abbe56e057f20f883e', 1, 16, NULL, 1, 'avatar5.png', 'YES', 'YES', 'LEAN', 22, '23', 'english'),
(37, 'DEACTIVATED', 'Pavel Pasa', 'pavel.pasa@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 6, NULL, 0, 'avatar5.png', 'YES', 'NO', 'F', 25, '3', 'english'),
(38, 'ACTIVE', 'Amitave Saha', 'amitave.saha@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 6, NULL, 0, 'avatar5.png', 'YES', 'NO', 'QCO', 26, '22,', 'english'),
(39, 'ACTIVE', 'Naim Siddique', 'naim.siddique@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 6, NULL, 0, 'avatar5.png', 'YES', 'NO', 'LEAN', 22, '22,', 'english'),
(40, 'ACTIVE', 'Sanzu Hosen', 'sanzu.hosen@bdventura.com', '', 'e10adc3949ba59abbe56e057f20f883e', 1, 5, NULL, 0, 'avatar5.png', 'NO', 'NO', 'PRO', 12, '12,13,14,15,16,', 'english');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `department_info`
--
ALTER TABLE `department_info`
  ADD PRIMARY KEY (`department_id`);

--
-- Indexes for table `divisional_head`
--
ALTER TABLE `divisional_head`
  ADD PRIMARY KEY (`div_id`);

--
-- Indexes for table `floorline_info`
--
ALTER TABLE `floorline_info`
  ADD PRIMARY KEY (`line_id`);

--
-- Indexes for table `floor_info`
--
ALTER TABLE `floor_info`
  ADD PRIMARY KEY (`floor_id`);

--
-- Indexes for table `kaizen_information`
--
ALTER TABLE `kaizen_information`
  ADD PRIMARY KEY (`kaizen_id`);

--
-- Indexes for table `kaizen_type`
--
ALTER TABLE `kaizen_type`
  ADD PRIMARY KEY (`type_id`);

--
-- Indexes for table `line_target`
--
ALTER TABLE `line_target`
  ADD PRIMARY KEY (`target_id`);

--
-- Indexes for table `monthly_target`
--
ALTER TABLE `monthly_target`
  ADD PRIMARY KEY (`target_id`);

--
-- Indexes for table `org_info`
--
ALTER TABLE `org_info`
  ADD PRIMARY KEY (`org_id`);

--
-- Indexes for table `post`
--
ALTER TABLE `post`
  ADD PRIMARY KEY (`post_id`);

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

--
-- Indexes for table `sys_menu`
--
ALTER TABLE `sys_menu`
  ADD PRIMARY KEY (`menu_id`);

--
-- Indexes for table `sys_user_role`
--
ALTER TABLE `sys_user_role`
  ADD PRIMARY KEY (`user_role_id`);

--
-- Indexes for table `titles`
--
ALTER TABLE `titles`
  ADD PRIMARY KEY (`titles_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `company_info`
--
ALTER TABLE `company_info`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `department_info`
--
ALTER TABLE `department_info`
  MODIFY `department_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `divisional_head`
--
ALTER TABLE `divisional_head`
  MODIFY `div_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `floorline_info`
--
ALTER TABLE `floorline_info`
  MODIFY `line_id` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `floor_info`
--
ALTER TABLE `floor_info`
  MODIFY `floor_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `kaizen_information`
--
ALTER TABLE `kaizen_information`
  MODIFY `kaizen_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kaizen_type`
--
ALTER TABLE `kaizen_type`
  MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `line_target`
--
ALTER TABLE `line_target`
  MODIFY `target_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1104;

--
-- AUTO_INCREMENT for table `monthly_target`
--
ALTER TABLE `monthly_target`
  MODIFY `target_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1571;

--
-- AUTO_INCREMENT for table `org_info`
--
ALTER TABLE `org_info`
  MODIFY `org_id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `post`
--
ALTER TABLE `post`
  MODIFY `post_id` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `review_department_info`
--
ALTER TABLE `review_department_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_menu`
--
ALTER TABLE `sys_menu`
  MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;

--
-- AUTO_INCREMENT for table `sys_user_role`
--
ALTER TABLE `sys_user_role`
  MODIFY `user_role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2741;

--
-- AUTO_INCREMENT for table `titles`
--
ALTER TABLE `titles`
  MODIFY `titles_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=248;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
COMMIT;

