-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Nov 19, 2016 at 06:05 PM
-- Server version: 10.0.27-MariaDB-cll-lve
-- PHP Version: 5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `lnkx10bz_cis`
--

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

--
-- Table structure for table `department`
--

CREATE TABLE IF NOT EXISTS `department` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dept` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`id`, `dept`) VALUES
(1, 'LSC P5'),
(2, 'KINSUS');

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

--
-- Table structure for table `hold_lot`
--

CREATE TABLE IF NOT EXISTS `hold_lot` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lot_id` int(11) NOT NULL,
  `proc_type` int(11) NOT NULL,
  `sub_id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `hold_reason` varchar(50) NOT NULL,
  `qa_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

--
-- Dumping data for table `hold_lot`
--

INSERT INTO `hold_lot` (`id`, `lot_id`, `proc_type`, `sub_id`, `start_time`, `end_time`, `hold_reason`, `qa_id`) VALUES
(10, 28, 7, 1, '2016-10-18 10:13:37', '2016-10-18 10:14:53', 'Operator Break', 0),
(11, 28, 7, 2, '2016-10-18 10:15:31', '2016-10-18 10:40:18', 'Operator Break', 0),
(12, 32, 7, 2, '2016-10-19 10:36:28', '2016-10-19 11:45:24', 'Operator Break', 0),
(13, 21, 7, 2, '2016-10-17 14:00:00', '2016-10-18 06:00:00', 'Operator Break', 0),
(14, 39, 7, 1, '2016-10-29 21:41:06', '2016-10-30 06:39:44', 'Operator Break', 0),
(15, 38, 7, 2, '2016-10-29 21:41:36', '2016-10-30 06:22:20', 'Operator Break', 0),
(16, 51, 7, 2, '2016-11-02 12:02:25', '2016-11-02 12:16:50', 'Operator Break', 0),
(17, 52, 7, 2, '2016-11-02 15:28:40', '2016-11-02 15:59:16', 'Operator Break', 0),
(18, 53, 7, 2, '2016-11-02 17:55:36', '0000-00-00 00:00:00', 'Operator Break', 0),
(19, 56, 7, 2, '2016-11-03 10:23:28', '2016-11-03 11:33:16', 'Operator Break', 0),
(20, 59, 7, 1, '2016-11-03 13:44:06', '2016-11-03 14:03:03', 'Operator Break', 0),
(21, 61, 7, 1, '2016-11-03 17:51:26', '2016-11-04 07:15:35', 'Operator Break', 0),
(22, 59, 7, 2, '2016-11-03 17:53:15', '2016-11-04 06:23:37', 'Operator Break', 0),
(23, 64, 7, 2, '2016-11-04 15:27:51', '2016-11-05 06:08:35', 'Operator Break', 0),
(24, 69, 7, 1, '2016-11-04 17:00:43', '2016-11-04 17:55:32', 'Operator Break', 0),
(25, 70, 7, 1, '2016-11-04 19:54:19', '2016-11-05 06:48:06', 'Operator Break', 0),
(26, 68, 7, 2, '2016-11-05 09:53:19', '2016-11-05 11:10:12', 'Operator Break', 0),
(27, 71, 7, 20, '2016-11-05 17:50:43', '0000-00-00 00:00:00', 'Operator Break', 0),
(28, 71, 7, 2, '2016-11-05 17:51:02', '0000-00-00 00:00:00', 'Operator Break', 0),
(29, 62, 7, 2, '2016-11-06 09:58:22', '0000-00-00 00:00:00', 'Operator Break', 0),
(30, 74, 7, 2, '2016-11-06 15:00:30', '2016-11-06 15:30:12', 'Operator Break', 0),
(31, 82, 7, 2, '2016-11-07 15:56:45', '0000-00-00 00:00:00', 'Operator Break', 0),
(32, 100, 7, 2, '2016-11-10 13:50:48', '0000-00-00 00:00:00', 'Operator Break', 0);

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

--
-- Table structure for table `item_desc`
--

CREATE TABLE IF NOT EXISTS `item_desc` (
  `item_code` int(11) NOT NULL AUTO_INCREMENT,
  `item` varchar(50) NOT NULL,
  `uom` varchar(10) NOT NULL,
  `proc_type` tinyint(4) NOT NULL,
  `item_class` varchar(10) NOT NULL,
  PRIMARY KEY (`item_code`),
  KEY `item_code` (`item_code`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

--
-- Dumping data for table `item_desc`
--

INSERT INTO `item_desc` (`item_code`, `item`, `uom`, `proc_type`, `item_class`) VALUES
(0, 'Default Item', 'pc', 0, 'RM'),
(35, 'FPC with LED', 'Piece', 7, 'RM'),
(36, 'Light Guide', 'Piece', 7, 'RM'),
(37, 'Light Source', 'Piece', 8, 'RM'),
(38, 'Case Assembled', 'Piece', 9, 'RM'),
(40, 'Rod Lens', 'Piece', 8, 'RM'),
(41, 'Plastic Case', 'Piece', 8, 'RM');

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

--
-- Table structure for table `lot`
--

CREATE TABLE IF NOT EXISTS `lot` (
  `lot_id` int(11) NOT NULL AUTO_INCREMENT,
  `proc` varchar(5) NOT NULL,
  `petsa` varchar(6) NOT NULL,
  `serye` int(11) NOT NULL,
  `date_create` date NOT NULL,
  PRIMARY KEY (`lot_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=160 ;

--
-- Dumping data for table `lot`
--

INSERT INTO `lot` (`lot_id`, `proc`, `petsa`, `serye`, `date_create`) VALUES
(20, 'LS', '161013', 50, '2016-10-13'),
(21, 'LS', '161013', 51, '2016-10-13'),
(22, 'LS', '161013', 52, '2016-10-13'),
(28, 'LS', '161014', 53, '2016-10-14'),
(29, 'LS', '161014', 54, '2016-10-14'),
(30, 'LS', '161014', 55, '2016-10-14'),
(31, 'LS', '161014', 56, '2016-10-14'),
(32, 'LS', '161014', 57, '2016-10-14'),
(33, 'LS', '161028', 58, '2016-10-28'),
(34, 'LS', '161028', 59, '2016-10-28'),
(35, 'LS', '161028', 60, '2016-10-28'),
(36, 'LS', '161028', 61, '2016-10-28'),
(37, 'LS', '161028', 62, '2016-10-28'),
(38, 'LS', '161029', 63, '2016-10-29'),
(39, 'LS', '161029', 64, '2016-10-29'),
(40, 'LS', '161029', 65, '2016-10-29'),
(41, 'LS', '161029', 66, '2016-10-29'),
(42, 'LS', '161029', 67, '2016-10-29'),
(43, 'LS', '161029', 68, '2016-10-29'),
(44, 'LS', '161029', 69, '2016-10-29'),
(45, 'LS', '161029', 70, '2016-10-29'),
(46, 'LS', '161030', 71, '2016-10-30'),
(47, 'LS', '161030', 72, '2016-10-30'),
(48, 'LS', '161030', 73, '2016-10-30'),
(49, 'LS', '161030', 74, '2016-10-30'),
(50, 'LS', '161030', 75, '2016-10-30'),
(51, 'LS', '161030', 76, '2016-10-30'),
(52, 'LS', '161030', 77, '2016-10-30'),
(53, 'LS', '161030', 78, '2016-10-30'),
(54, 'LS', '161031', 79, '2016-10-31'),
(55, 'LS', '161031', 80, '2016-10-31'),
(56, 'LS', '161031', 81, '2016-10-31'),
(57, 'LS', '161031', 82, '2016-10-31'),
(58, 'LS', '161031', 83, '2016-10-31'),
(59, 'LS', '161031', 84, '2016-10-31'),
(60, 'LS', '161031', 85, '2016-10-31'),
(61, 'LS', '161031', 86, '2016-10-31'),
(62, 'LS', '161102', 1, '2016-11-02'),
(64, 'LS', '161102', 2, '2016-11-02'),
(67, 'LS', '161102', 3, '2016-11-02'),
(68, 'LS', '161102', 4, '2016-11-02'),
(69, 'LS', '161102', 5, '2016-11-02'),
(70, 'LS', '161102', 6, '2016-11-02'),
(71, 'LS', '161102', 7, '2016-11-02'),
(72, 'LS', '161102', 8, '2016-11-02'),
(73, 'LS', '161103', 9, '2016-11-03'),
(74, 'LS', '161103', 10, '2016-11-03'),
(75, 'LS', '161103', 11, '2016-11-03'),
(76, 'LS', '161103', 12, '2016-11-03'),
(77, 'LS', '161103', 13, '2016-11-03'),
(78, 'LS', '161103', 14, '2016-11-03'),
(79, 'CA', '161102', 6, '2016-11-02'),
(80, 'CA', '161102', 7, '2016-11-02'),
(81, 'LS', '161103', 15, '2016-11-03'),
(82, 'LS', '161103', 16, '2016-11-03'),
(83, 'CA', '161102', 8, '2016-11-02'),
(84, 'CA', '161102', 9, '2016-11-02'),
(85, 'CA', '161102', 10, '2016-11-02'),
(86, 'CA', '161102', 11, '2016-11-02'),
(87, 'CA', '161102', 12, '2016-11-02'),
(88, 'CA', '161102', 13, '2016-11-02'),
(90, 'CA', '161103', 14, '2016-11-03'),
(91, 'CA', '161103', 94, '2016-11-03'),
(92, 'LS', '161103', 17, '2016-11-03'),
(93, 'LS', '161107', 18, '2016-11-07'),
(94, 'LS', '161107', 19, '2016-11-07'),
(95, 'LS', '161107', 20, '2016-11-07'),
(96, 'LS', '161107', 21, '2016-11-07'),
(97, 'LS', '161107', 22, '2016-11-07'),
(98, 'LS', '161108', 23, '2016-11-08'),
(99, 'LS', '161108', 24, '2016-11-08'),
(100, 'LS', '161108', 25, '2016-11-08'),
(101, 'LS', '161108', 26, '2016-11-08'),
(102, 'LS', '161108', 27, '2016-11-08'),
(103, 'LS', '161108', 28, '2016-11-08'),
(104, 'LS', '161108', 29, '2016-11-08'),
(105, 'CA', '161110', 95, '2016-11-10'),
(106, 'CA', '161110', 96, '2016-11-10'),
(107, 'CA', '161110', 97, '2016-11-10'),
(108, 'CA', '161110', 98, '2016-11-10'),
(109, 'CA', '161110', 99, '2016-11-10'),
(110, 'CA', '161110', 100, '2016-11-10'),
(111, 'CA', '161110', 101, '2016-11-10'),
(112, 'CA', '161110', 102, '2016-11-10'),
(113, 'CA', '161110', 103, '2016-11-10'),
(114, 'CA', '161110', 104, '2016-11-10'),
(115, 'CA', '161110', 105, '2016-11-10'),
(116, 'CA', '161110', 106, '2016-11-10'),
(117, 'CA', '161110', 107, '2016-11-10'),
(118, 'CA', '161117', 108, '2016-11-17'),
(119, 'CA', '161110', 109, '2016-11-10'),
(120, 'CA', '161110', 110, '2016-11-10'),
(121, 'CA', '161110', 111, '2016-11-10'),
(122, 'CA', '161111', 112, '2016-11-11'),
(123, 'CA', '161111', 113, '2016-11-11'),
(124, 'CA', '161111', 114, '2016-11-11'),
(125, 'CA', '161111', 115, '2016-11-11'),
(126, 'CA', '161111', 116, '2016-11-11'),
(127, 'CA', '161111', 117, '2016-11-11'),
(128, 'CA', '161111', 118, '2016-11-11'),
(129, 'CA', '161111', 119, '2016-11-11'),
(130, 'CA', '161111', 120, '2016-11-11'),
(131, 'CA', '161111', 121, '2016-11-11'),
(132, 'CA', '161111', 122, '2016-11-11'),
(133, 'CA', '161111', 123, '2016-11-11'),
(134, 'CA', '161112', 124, '2016-11-12'),
(135, 'CA', '161112', 125, '2016-11-12'),
(136, 'CA', '161112', 126, '2016-11-12'),
(137, 'CA', '161112', 127, '2016-11-12'),
(138, 'CA', '161112', 128, '2016-11-12'),
(139, 'CA', '161112', 129, '2016-11-12'),
(140, 'CA', '161112', 130, '2016-11-12'),
(141, 'CA', '161112', 131, '2016-11-12'),
(142, 'CA', '161112', 132, '2016-11-12'),
(143, 'CA', '161112', 133, '2016-11-12'),
(144, 'CA', '161114', 134, '2016-11-14'),
(145, 'CA', '161114', 135, '2016-11-14'),
(146, 'CA', '161114', 136, '2016-11-14'),
(147, 'LS', '161114', 30, '2016-11-14'),
(148, 'LS', '161114', 31, '2016-11-14'),
(149, 'LS', '161114', 32, '2016-11-14'),
(150, 'LS', '161115', 33, '2016-11-15'),
(151, 'LS', '161115', 34, '2016-11-15'),
(153, 'LS', '161114', 35, '2016-11-14'),
(154, 'LS', '161115', 36, '2016-11-15'),
(155, 'LS', '161117', 37, '2016-11-17'),
(156, 'LS', '161117', 38, '2016-11-17'),
(157, 'LS', '700101', 1, '0000-00-00'),
(158, 'LS', '700101', 2, '0000-00-00'),
(159, 'LS', '161117', 1, '2016-11-17');

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

--
-- Table structure for table `ng_logs`
--

CREATE TABLE IF NOT EXISTS `ng_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lot_id` int(11) NOT NULL,
  `proc_type` int(11) NOT NULL,
  `sub_id` int(11) NOT NULL,
  `ng_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `switch` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;

--
-- Dumping data for table `ng_logs`
--

INSERT INTO `ng_logs` (`id`, `lot_id`, `proc_type`, `sub_id`, `ng_id`, `qty`, `switch`) VALUES
(3, 21, 7, 1, 2, 7, 0),
(4, 28, 7, 1, 8, 2, 0),
(5, 29, 7, 1, 2, 1, 0),
(6, 31, 7, 2, 4, 1, 0),
(7, 35, 7, 2, 3, 1, 0),
(8, 39, 7, 1, 2, 19, 0),
(9, 46, 7, 1, 2, 1, 0),
(10, 47, 7, 1, 2, 2, 0),
(11, 50, 7, 1, 2, 2, 0),
(14, 52, 7, 1, 2, 1, 0),
(15, 53, 7, 1, 2, 8, 0),
(16, 57, 7, 1, 2, 2, 0),
(17, 54, 7, 2, 3, 1, 0),
(18, 55, 7, 2, 3, 1, 0),
(19, 58, 7, 1, 5, 2, 0),
(20, 56, 7, 2, 3, 1, 0),
(21, 59, 7, 1, 2, 5, 0),
(22, 60, 7, 1, 2, 2, 0),
(23, 67, 7, 1, 2, 2, 0),
(24, 61, 7, 2, 3, 2, 0),
(25, 69, 7, 1, 2, 3, 0),
(26, 67, 7, 2, 3, 3, 0),
(27, 72, 7, 1, 5, 1, 0),
(28, 73, 7, 1, 2, 1, 0),
(29, 70, 7, 2, 3, 1, 0),
(30, 75, 7, 1, 2, 2, 0),
(31, 77, 7, 1, 2, 2, 0),
(32, 82, 7, 1, 2, 2, 0),
(33, 75, 7, 2, 7, 1, 0),
(34, 93, 7, 2, 3, 5, 0),
(35, 94, 7, 1, 2, 2, 0),
(36, 92, 7, 1, 5, 2, 0),
(37, 97, 7, 1, 2, 2, 0),
(38, 103, 7, 1, 2, 2, 0),
(39, 102, 7, 1, 2, 4, 0),
(40, 104, 7, 1, 2, 2, 0),
(41, 100, 7, 2, 7, 1, 0),
(42, 104, 7, 2, 9, 2, 0),
(43, 99, 7, 2, 12, 10, 0),
(44, 104, 7, 2, 12, 10, 0);

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

--
-- Table structure for table `no_good`
--

CREATE TABLE IF NOT EXISTS `no_good` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ng_name` varchar(50) NOT NULL,
  `barcode_num` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `no_good`
--

INSERT INTO `no_good` (`id`, `ng_name`, `barcode_num`) VALUES
(2, 'Pin Apperance', 2),
(3, 'J Fail', 3),
(4, 'A Fail', 4),
(5, 'No FPC', 5),
(6, 'Broken Pin', 6),
(7, 'D Fail', 7),
(8, 'Pin Off set', 8),
(9, 'Up Bin 1', 9),
(10, 'Burn Case', 0),
(11, 'FM', 0),
(12, 'Scratch', 0),
(14, 'Scratch2', 0);

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

--
-- Table structure for table `process`
--

CREATE TABLE IF NOT EXISTS `process` (
  `proc_type` int(4) NOT NULL AUTO_INCREMENT,
  `process_code` varchar(10) NOT NULL,
  `process_name` varchar(50) NOT NULL,
  `def_qty` int(11) NOT NULL,
  `fg` int(11) NOT NULL,
  PRIMARY KEY (`proc_type`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `process`
--

INSERT INTO `process` (`proc_type`, `process_code`, `process_name`, `def_qty`, `fg`) VALUES
(7, 'LS', 'Light Source Assembly', 300, 37),
(8, 'CA', 'Case Assembly', 100, 38),
(9, 'FA', 'Final Assembly', 100, 0);

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

--
-- Table structure for table `qa_tact_time`
--

CREATE TABLE IF NOT EXISTS `qa_tact_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lot_id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `result` int(11) NOT NULL,
  `release_sw` tinyint(4) NOT NULL,
  `qa_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `quantity_stock`
--

CREATE TABLE IF NOT EXISTS `quantity_stock` (
  `qs_id` int(11) NOT NULL AUTO_INCREMENT,
  `lot_id` int(11) NOT NULL,
  `no_more_sw` tinyint(1) NOT NULL,
  `item_code` int(11) NOT NULL,
  `stock_qty` int(11) NOT NULL,
  `price` decimal(8,3) NOT NULL,
  `currency` varchar(10) NOT NULL,
  `manufacturer` varchar(50) NOT NULL,
  `exp_date` date NOT NULL,
  `date_acquired` datetime NOT NULL,
  PRIMARY KEY (`qs_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

--
-- Dumping data for table `quantity_stock`
--

INSERT INTO `quantity_stock` (`qs_id`, `lot_id`, `no_more_sw`, `item_code`, `stock_qty`, `price`, `currency`, `manufacturer`, `exp_date`, `date_acquired`) VALUES
(1, 0, 1, 36, 19600, '0.000', 'USD', 'LSC', '0000-00-00', '2016-10-13 14:56:31'),
(2, 0, 1, 35, 16900, '2.000', 'USD', 'LSC', '0000-00-00', '2016-10-13 14:57:13'),
(4, 20, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-10-18 14:46:17'),
(5, 21, 1, 37, 293, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-10-18 14:47:51'),
(6, 22, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-10-18 14:48:45'),
(7, 28, 1, 37, 298, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-10-18 14:49:04'),
(8, 29, 1, 37, 299, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-10-18 14:49:22'),
(9, 30, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-10-19 14:40:23'),
(10, 31, 1, 37, 299, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-10-19 14:40:33'),
(11, 32, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-10-20 16:00:24'),
(12, 0, 0, 40, 20000, '1.000', 'USD', 'LOH', '0000-00-00', '2016-10-28 17:37:17'),
(13, 0, 0, 41, 20000, '1.000', 'USD', 'LSC', '0000-00-00', '2016-10-28 17:37:55'),
(14, 0, 0, 35, 17000, '1.000', 'USD', 'LSC', '0000-00-00', '2016-11-02 10:18:59'),
(15, 0, 0, 36, 8800, '1.000', 'USD', 'LSC', '0000-00-00', '2016-11-02 10:19:37'),
(16, 34, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-03 11:17:32'),
(17, 35, 1, 37, 299, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-03 11:17:43'),
(18, 37, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-03 11:18:02'),
(19, 38, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-03 11:19:27'),
(20, 40, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-03 11:21:37'),
(21, 41, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-03 11:21:48'),
(22, 42, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-03 11:22:05'),
(23, 43, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-03 11:22:19'),
(24, 36, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-03 11:22:34'),
(25, 39, 1, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-03 11:23:04'),
(26, 95, 0, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-11 15:32:22'),
(27, 96, 0, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-11 15:32:37'),
(28, 97, 0, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-11 15:32:55'),
(29, 98, 0, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-11 15:33:14'),
(30, 99, 0, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-11 15:33:37'),
(32, 153, 0, 37, 0, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-14 16:03:33'),
(33, 154, 0, 37, 300, '0.000', 'PHP', 'L&K', '0000-00-00', '2016-11-15 14:26:17');

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

--
-- Table structure for table `quantity_usage`
--

CREATE TABLE IF NOT EXISTS `quantity_usage` (
  `qu_id` int(11) NOT NULL AUTO_INCREMENT,
  `lot_id` int(11) NOT NULL,
  `qs_id` int(11) NOT NULL,
  `usage_qty` int(11) NOT NULL,
  PRIMARY KEY (`qu_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=367 ;

--
-- Dumping data for table `quantity_usage`
--

INSERT INTO `quantity_usage` (`qu_id`, `lot_id`, `qs_id`, `usage_qty`) VALUES
(13, 20, 2, 300),
(14, 20, 1, 300),
(15, 21, 2, 300),
(16, 21, 1, 300),
(17, 22, 2, 300),
(18, 22, 1, 300),
(29, 28, 2, 300),
(30, 28, 1, 300),
(31, 29, 2, 300),
(32, 29, 1, 300),
(33, 30, 2, 300),
(34, 30, 1, 300),
(35, 31, 2, 300),
(36, 31, 1, 300),
(37, 32, 2, 300),
(38, 32, 1, 300),
(39, 33, 2, 300),
(40, 33, 1, 300),
(41, 34, 2, 300),
(42, 34, 1, 300),
(43, 33, 2, 300),
(44, 33, 1, 300),
(45, 34, 2, 300),
(46, 34, 1, 300),
(47, 35, 2, 300),
(48, 35, 1, 300),
(49, 36, 2, 300),
(50, 36, 1, 300),
(51, 37, 2, 300),
(52, 37, 1, 300),
(53, 38, 2, 300),
(54, 38, 1, 300),
(55, 39, 2, 300),
(56, 39, 1, 300),
(57, 40, 2, 300),
(58, 40, 1, 300),
(59, 41, 2, 300),
(60, 41, 1, 300),
(61, 42, 2, 300),
(62, 42, 1, 300),
(63, 43, 2, 300),
(64, 43, 1, 300),
(65, 44, 2, 300),
(66, 44, 1, 300),
(67, 45, 2, 300),
(68, 45, 1, 300),
(69, 46, 2, 300),
(70, 46, 1, 300),
(71, 47, 2, 300),
(72, 47, 1, 300),
(73, 48, 2, 300),
(74, 48, 1, 300),
(75, 49, 2, 300),
(76, 49, 1, 300),
(77, 50, 2, 300),
(78, 50, 1, 300),
(79, 51, 2, 300),
(80, 51, 1, 300),
(81, 52, 2, 300),
(82, 52, 1, 300),
(83, 53, 2, 300),
(84, 53, 1, 300),
(85, 54, 2, 300),
(86, 54, 1, 300),
(87, 55, 2, 300),
(88, 55, 1, 300),
(89, 56, 2, 300),
(90, 56, 1, 300),
(91, 57, 2, 300),
(92, 57, 1, 300),
(93, 58, 2, 300),
(94, 58, 1, 300),
(95, 59, 2, 300),
(96, 59, 1, 300),
(97, 60, 2, 300),
(98, 60, 1, 300),
(99, 61, 2, 300),
(100, 61, 1, 300),
(101, 62, 2, 300),
(102, 62, 1, 300),
(103, 63, 2, 300),
(104, 63, 1, 300),
(105, 64, 2, 300),
(106, 64, 1, 300),
(107, 65, 2, 300),
(108, 65, 1, 300),
(111, 67, 2, 300),
(112, 67, 1, 300),
(113, 68, 2, 300),
(114, 68, 1, 300),
(115, 69, 2, 300),
(116, 69, 1, 300),
(117, 70, 2, 300),
(118, 70, 1, 300),
(119, 71, 2, 300),
(120, 71, 1, 300),
(121, 72, 2, 300),
(122, 72, 1, 300),
(123, 73, 2, 300),
(124, 73, 1, 300),
(125, 74, 2, 300),
(126, 74, 1, 300),
(127, 75, 2, 300),
(128, 75, 1, 300),
(129, 76, 2, 300),
(130, 76, 1, 300),
(131, 77, 2, 300),
(132, 77, 1, 300),
(133, 78, 2, 300),
(134, 78, 1, 300),
(135, 79, 4, 100),
(136, 79, 12, 100),
(137, 79, 13, 100),
(138, 80, 4, 100),
(139, 80, 12, 100),
(140, 80, 13, 100),
(141, 81, 2, 100),
(142, 81, 14, 200),
(143, 81, 1, 300),
(144, 82, 14, 300),
(145, 82, 1, 300),
(146, 83, 4, 100),
(147, 83, 12, 100),
(148, 83, 13, 100),
(149, 84, 4, 0),
(150, 84, 5, 100),
(151, 84, 12, 100),
(152, 84, 13, 100),
(153, 85, 5, 100),
(154, 85, 12, 100),
(155, 85, 13, 100),
(156, 86, 5, 93),
(157, 86, 6, 7),
(158, 86, 12, 100),
(159, 86, 13, 100),
(160, 87, 6, 100),
(161, 87, 12, 100),
(162, 87, 13, 100),
(163, 88, 6, 100),
(164, 88, 12, 100),
(165, 88, 13, 100),
(166, 89, 6, 93),
(167, 89, 7, 7),
(168, 89, 12, 100),
(169, 89, 13, 100),
(170, 90, 7, 100),
(171, 90, 12, 100),
(172, 90, 13, 100),
(173, 91, 7, 100),
(174, 91, 12, 100),
(175, 91, 13, 100),
(176, 92, 14, 300),
(177, 92, 1, 300),
(178, 93, 14, 300),
(179, 93, 1, 300),
(180, 94, 14, 300),
(181, 94, 1, 300),
(182, 95, 14, 300),
(183, 95, 1, 300),
(184, 96, 14, 300),
(185, 96, 1, 300),
(186, 97, 14, 300),
(187, 97, 1, 300),
(188, 98, 14, 300),
(189, 98, 1, 300),
(190, 99, 14, 300),
(191, 99, 1, 100),
(192, 99, 15, 200),
(193, 100, 14, 300),
(194, 100, 15, 300),
(195, 101, 14, 300),
(196, 101, 15, 300),
(197, 102, 14, 300),
(198, 102, 15, 300),
(199, 103, 14, 256),
(200, 103, 15, 256),
(201, 104, 14, 256),
(202, 104, 15, 256),
(203, 105, 7, 91),
(204, 105, 8, 9),
(205, 105, 12, 100),
(206, 105, 13, 100),
(207, 106, 8, 100),
(208, 106, 12, 100),
(209, 106, 13, 100),
(210, 107, 8, 100),
(211, 107, 12, 100),
(212, 107, 13, 100),
(213, 108, 8, 90),
(214, 108, 9, 10),
(215, 108, 12, 100),
(216, 108, 13, 100),
(217, 109, 9, 100),
(218, 109, 12, 100),
(219, 109, 13, 100),
(220, 110, 9, 100),
(221, 110, 12, 100),
(222, 110, 13, 100),
(223, 111, 9, 90),
(224, 111, 10, 10),
(225, 111, 12, 100),
(226, 111, 13, 100),
(227, 112, 10, 100),
(228, 112, 12, 100),
(229, 112, 13, 100),
(230, 113, 10, 100),
(231, 113, 12, 100),
(232, 113, 13, 100),
(233, 114, 10, 89),
(234, 114, 11, 11),
(235, 114, 12, 100),
(236, 114, 13, 100),
(237, 115, 11, 100),
(238, 115, 12, 100),
(239, 115, 13, 100),
(240, 116, 11, 100),
(241, 116, 12, 100),
(242, 116, 13, 100),
(243, 117, 11, 89),
(244, 117, 16, 11),
(245, 117, 12, 100),
(246, 117, 13, 100),
(247, 118, 16, 100),
(248, 118, 12, 100),
(249, 118, 13, 100),
(250, 119, 16, 100),
(251, 119, 12, 100),
(252, 119, 13, 100),
(253, 120, 16, 89),
(254, 120, 17, 11),
(255, 120, 12, 100),
(256, 120, 13, 100),
(257, 121, 17, 100),
(258, 121, 12, 100),
(259, 121, 13, 100),
(260, 122, 17, 100),
(261, 122, 12, 100),
(262, 122, 13, 100),
(263, 123, 17, 88),
(264, 123, 18, 12),
(265, 123, 12, 100),
(266, 123, 13, 100),
(267, 124, 18, 100),
(268, 124, 12, 100),
(269, 124, 13, 100),
(270, 125, 18, 100),
(271, 125, 12, 100),
(272, 125, 13, 100),
(273, 126, 18, 88),
(274, 126, 19, 12),
(275, 126, 12, 100),
(276, 126, 13, 100),
(277, 127, 19, 100),
(278, 127, 12, 100),
(279, 127, 13, 100),
(280, 128, 19, 100),
(281, 128, 12, 100),
(282, 128, 13, 100),
(283, 129, 19, 88),
(284, 129, 20, 12),
(285, 129, 12, 100),
(286, 129, 13, 100),
(287, 130, 20, 100),
(288, 130, 12, 100),
(289, 130, 13, 100),
(290, 131, 20, 100),
(291, 131, 12, 100),
(292, 131, 13, 100),
(293, 132, 20, 88),
(294, 132, 21, 12),
(295, 132, 12, 100),
(296, 132, 13, 100),
(297, 133, 21, 100),
(298, 133, 12, 100),
(299, 133, 13, 100),
(300, 134, 21, 100),
(301, 134, 12, 100),
(302, 134, 13, 100),
(303, 135, 21, 88),
(304, 135, 22, 12),
(305, 135, 12, 100),
(306, 135, 13, 100),
(307, 136, 22, 100),
(308, 136, 12, 100),
(309, 136, 13, 100),
(310, 137, 22, 100),
(311, 137, 12, 100),
(312, 137, 13, 100),
(313, 138, 22, 88),
(314, 138, 23, 12),
(315, 138, 12, 100),
(316, 138, 13, 100),
(317, 139, 23, 100),
(318, 139, 12, 100),
(319, 139, 13, 100),
(320, 140, 23, 100),
(321, 140, 12, 100),
(322, 140, 13, 100),
(323, 141, 23, 88),
(324, 141, 24, 12),
(325, 141, 12, 100),
(326, 141, 13, 100),
(327, 142, 24, 100),
(328, 142, 12, 100),
(329, 142, 13, 100),
(330, 143, 24, 100),
(331, 143, 12, 100),
(332, 143, 13, 100),
(333, 144, 24, 88),
(334, 144, 25, 12),
(335, 144, 12, 100),
(336, 144, 13, 100),
(337, 145, 25, 100),
(338, 145, 12, 100),
(339, 145, 13, 100),
(340, 146, 25, 136),
(341, 146, 12, 136),
(342, 146, 13, 136),
(343, 147, 14, 300),
(344, 147, 15, 300),
(345, 148, 14, 300),
(346, 148, 15, 300),
(347, 149, 14, 300),
(348, 149, 15, 300),
(349, 150, 14, 300),
(350, 150, 15, 300),
(351, 151, 14, 300),
(352, 151, 15, 300),
(357, 153, 14, 300),
(358, 153, 15, 300),
(359, 154, 14, 300),
(360, 154, 15, 300),
(361, 155, 14, 300),
(362, 155, 15, 300),
(363, 156, 14, 300),
(364, 156, 15, 300),
(365, 159, 14, 300),
(366, 159, 15, 300);

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

--
-- Table structure for table `start_qty`
--

CREATE TABLE IF NOT EXISTS `start_qty` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lot_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=236 ;

--
-- Dumping data for table `start_qty`
--

INSERT INTO `start_qty` (`id`, `lot_id`, `qty`) VALUES
(103, 20, 300),
(104, 21, 300),
(105, 22, 300),
(106, 28, 300),
(107, 29, 300),
(108, 30, 300),
(109, 31, 300),
(110, 32, 300),
(111, 33, 300),
(112, 34, 300),
(113, 35, 300),
(114, 36, 300),
(115, 37, 300),
(116, 38, 300),
(117, 39, 300),
(118, 40, 300),
(119, 41, 300),
(120, 42, 300),
(121, 43, 300),
(122, 44, 300),
(123, 45, 300),
(124, 46, 300),
(125, 47, 300),
(126, 48, 300),
(127, 49, 300),
(128, 50, 300),
(129, 51, 300),
(130, 52, 300),
(131, 53, 300),
(132, 54, 300),
(133, 55, 300),
(134, 56, 300),
(135, 57, 300),
(136, 58, 300),
(137, 59, 300),
(138, 60, 300),
(139, 61, 300),
(140, 62, 300),
(141, 63, 300),
(142, 64, 300),
(143, 65, 300),
(144, 66, 300),
(145, 67, 300),
(146, 68, 300),
(147, 69, 300),
(148, 70, 300),
(149, 71, 300),
(150, 72, 300),
(151, 73, 300),
(152, 74, 300),
(153, 75, 300),
(154, 76, 300),
(155, 77, 300),
(156, 78, 300),
(157, 79, 100),
(158, 80, 100),
(159, 81, 100),
(160, 82, 300),
(161, 83, 100),
(162, 84, 0),
(163, 85, 100),
(164, 86, 93),
(165, 87, 100),
(166, 88, 100),
(167, 89, 93),
(168, 90, 100),
(169, 91, 100),
(170, 92, 300),
(171, 93, 300),
(172, 94, 300),
(173, 95, 300),
(174, 96, 300),
(175, 97, 300),
(176, 98, 300),
(177, 99, 300),
(178, 100, 300),
(179, 101, 300),
(180, 102, 300),
(181, 103, 300),
(182, 104, 256),
(183, 105, 100),
(184, 106, 100),
(185, 107, 100),
(186, 108, 100),
(187, 109, 100),
(188, 110, 100),
(189, 111, 100),
(190, 112, 100),
(191, 113, 100),
(192, 114, 100),
(193, 115, 100),
(194, 116, 100),
(195, 117, 100),
(196, 118, 100),
(197, 119, 100),
(198, 120, 100),
(199, 121, 100),
(200, 122, 100),
(201, 123, 100),
(202, 124, 100),
(203, 125, 100),
(204, 126, 100),
(205, 127, 100),
(206, 128, 100),
(207, 129, 100),
(208, 130, 100),
(209, 131, 100),
(210, 132, 100),
(211, 133, 100),
(212, 134, 100),
(213, 135, 100),
(214, 136, 100),
(215, 137, 100),
(216, 138, 100),
(217, 139, 100),
(218, 140, 100),
(219, 141, 100),
(220, 142, 100),
(221, 143, 100),
(222, 144, 100),
(223, 145, 100),
(224, 146, 136),
(225, 147, 300),
(226, 148, 300),
(227, 149, 300),
(228, 150, 300),
(229, 151, 300),
(230, 152, 100),
(231, 153, 300),
(232, 154, 300),
(233, 155, 300),
(234, 156, 300),
(235, 159, 300);

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

--
-- Table structure for table `sub_process`
--

CREATE TABLE IF NOT EXISTS `sub_process` (
  `sub_id` int(11) NOT NULL AUTO_INCREMENT,
  `process_name` varchar(50) NOT NULL,
  `process_id` int(11) NOT NULL,
  `priority` tinyint(4) NOT NULL,
  `line_up` int(11) NOT NULL,
  PRIMARY KEY (`sub_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `sub_process`
--

INSERT INTO `sub_process` (`sub_id`, `process_name`, `process_id`, `priority`, `line_up`) VALUES
(1, 'Caulking Process', 7, 1, 10),
(2, 'Functional Test', 7, 2, 20),
(3, 'PLASTIC CASE CLEANING', 8, 1, 10),
(4, 'WHITE GLUE APPLICATION', 8, 2, 20),
(5, 'ROD LENS INSTALLATION', 8, 3, 30),
(6, '3-POINT UV SILICON APPLICATION', 8, 4, 40),
(7, 'UV SILICON PRE-CURE', 8, 5, 50),
(8, 'UV FUSHION', 8, 6, 60),
(9, 'QA MEASUREMENT', 8, 7, 70),
(10, 'SMALL SILICON GLUE APPLICATION', 8, 8, 80),
(11, 'LIGHT SOURCE GLUE APPLICATION', 8, 9, 90),
(12, 'LIGHT SOURCE INSTALLATION', 8, 10, 100),
(13, 'LIGHT SOURCE STITCHING', 8, 11, 110),
(14, 'CASE WITH RL AND LS CLEANING', 8, 12, 120),
(15, 'VISUAL INSPECTION AND CLEAR TAPE STICKING', 8, 13, 130);

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

--
-- Table structure for table `tact_time`
--

CREATE TABLE IF NOT EXISTS `tact_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lot_id` int(10) NOT NULL,
  `sub_id` int(11) NOT NULL,
  `proc_type` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `operator_id` int(11) NOT NULL,
  `input_qty` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=636 ;

--
-- Dumping data for table `tact_time`
--

INSERT INTO `tact_time` (`id`, `lot_id`, `sub_id`, `proc_type`, `start_time`, `end_time`, `operator_id`, `input_qty`) VALUES
(4, 20, 1, 7, '2016-10-14 10:02:54', '2016-10-14 12:48:41', 89, 300),
(5, 21, 1, 7, '2016-10-14 12:49:29', '2016-10-14 16:04:20', 89, 300),
(6, 22, 1, 7, '2016-10-14 16:05:08', '2016-10-15 07:28:07', 89, 300),
(7, 28, 1, 7, '2016-10-15 07:30:17', '2016-10-15 09:01:53', 88, 300),
(8, 29, 1, 7, '2016-10-15 09:02:49', '2016-10-15 11:25:56', 88, 300),
(9, 30, 1, 7, '2016-10-15 11:26:39', '2016-10-15 12:56:55', 88, 300),
(10, 31, 1, 7, '2016-10-15 12:57:40', '2016-10-17 09:17:42', 88, 300),
(11, 32, 1, 7, '2016-10-17 09:19:15', '2016-10-17 10:50:40', 88, 300),
(12, 20, 2, 7, '2016-10-17 13:04:55', '2016-10-17 13:05:10', 90, 300),
(13, 21, 2, 7, '2016-10-17 13:05:25', '2016-10-18 07:02:09', 90, 293),
(14, 22, 2, 7, '2016-10-18 07:02:36', '2016-10-18 09:02:51', 90, 300),
(15, 28, 2, 7, '2016-10-18 10:15:08', '2016-10-18 11:59:35', 90, 298),
(16, 28, 10, 7, '2016-10-18 11:59:16', '0000-00-00 00:00:00', 90, 298),
(17, 29, 2, 7, '2016-10-18 12:00:04', '2016-10-18 14:00:58', 90, 299),
(18, 29, 10, 7, '2016-10-18 14:00:36', '0000-00-00 00:00:00', 90, 299),
(19, 30, 2, 7, '2016-10-19 06:31:35', '2016-10-19 08:16:28', 88, 300),
(20, 31, 2, 7, '2016-10-19 08:17:01', '2016-10-19 10:28:58', 88, 300),
(21, 32, 2, 7, '2016-10-19 10:29:47', '2016-10-19 14:43:01', 89, 300),
(22, 34, 1, 7, '2016-10-28 18:44:55', '2016-10-28 20:15:06', 88, 300),
(23, 34, 2, 7, '2016-10-28 19:11:10', '2016-10-28 21:13:43', 89, 300),
(24, 35, 1, 7, '2016-10-28 20:16:47', '2016-10-28 21:31:51', 88, 300),
(25, 36, 1, 7, '2016-10-28 21:32:30', '2016-10-29 14:51:14', 88, 300),
(26, 35, 2, 7, '2016-10-29 14:06:18', '2016-10-29 15:59:08', 88, 300),
(27, 36, 2, 7, '2016-10-29 14:53:01', '2016-10-29 16:00:05', 89, 300),
(28, 37, 1, 7, '2016-10-29 14:55:06', '2016-10-29 16:28:50', 89, 300),
(29, 35, 10, 7, '2016-10-29 15:58:14', '0000-00-00 00:00:00', 1, 300),
(30, 38, 1, 7, '2016-10-29 16:30:16', '2016-10-29 19:33:38', 89, 300),
(31, 37, 2, 7, '2016-10-29 18:58:58', '2016-10-29 21:01:03', 88, 300),
(32, 39, 1, 7, '2016-10-29 19:38:42', '2016-10-30 07:43:47', 89, 300),
(33, 37, 20, 7, '2016-10-29 20:59:58', '0000-00-00 00:00:00', 88, 300),
(34, 38, 2, 7, '2016-10-29 21:03:00', '2016-10-30 07:12:45', 88, 300),
(35, 38, 20, 7, '2016-10-30 07:12:24', '0000-00-00 00:00:00', 88, 300),
(36, 40, 1, 7, '2016-10-30 07:45:47', '2016-10-30 09:09:45', 89, 300),
(37, 39, 20, 7, '2016-10-30 08:00:52', '0000-00-00 00:00:00', 88, 300),
(38, 39, 2, 7, '2016-10-30 08:01:33', '2016-10-30 09:57:05', 88, 300),
(39, 40, 20, 7, '2016-10-30 11:05:12', '0000-00-00 00:00:00', 88, 300),
(40, 40, 2, 7, '2016-10-30 11:05:21', '2016-10-30 13:00:50', 88, 300),
(41, 41, 1, 7, '2016-11-02 08:42:20', '2016-11-02 08:42:26', 89, 300),
(42, 42, 1, 7, '2016-11-02 08:42:37', '2016-11-02 08:42:56', 89, 300),
(43, 41, 2, 7, '2016-11-02 08:43:07', '2016-11-02 08:43:16', 88, 300),
(44, 42, 2, 7, '2016-11-02 08:43:26', '2016-11-02 08:43:32', 88, 300),
(45, 51, 1, 7, '2016-11-02 10:24:52', '2016-11-02 10:24:58', 89, 300),
(46, 43, 1, 7, '2016-11-02 10:25:43', '2016-11-02 10:25:54', 89, 300),
(47, 43, 2, 7, '2016-11-02 10:26:05', '2016-11-02 10:26:12', 88, 300),
(48, 44, 1, 7, '2016-11-02 10:27:01', '2016-11-02 10:27:10', 89, 300),
(49, 44, 2, 7, '2016-11-02 10:27:21', '2016-11-02 10:27:25', 88, 300),
(50, 45, 1, 7, '2016-11-02 10:27:34', '2016-11-02 10:27:45', 89, 300),
(51, 45, 2, 7, '2016-11-02 10:27:52', '2016-11-02 10:27:57', 88, 300),
(52, 46, 1, 7, '2016-11-02 10:28:43', '2016-11-02 10:29:32', 89, 300),
(53, 46, 2, 7, '2016-11-02 10:29:41', '2016-11-02 10:29:51', 88, 300),
(54, 47, 1, 7, '2016-11-02 10:30:09', '2016-11-02 10:30:47', 89, 300),
(55, 47, 2, 7, '2016-11-02 10:30:56', '2016-11-02 10:31:11', 88, 300),
(56, 48, 1, 7, '2016-11-02 10:32:03', '2016-11-02 10:32:11', 89, 300),
(57, 48, 2, 7, '2016-11-02 10:32:17', '2016-11-02 10:32:22', 88, 300),
(58, 49, 1, 7, '2016-11-02 10:32:34', '2016-11-02 10:32:42', 89, 300),
(59, 49, 2, 7, '2016-11-02 10:32:51', '2016-11-02 10:32:57', 88, 300),
(60, 50, 1, 7, '2016-11-02 10:33:41', '2016-11-02 14:33:05', 89, 300),
(61, 50, 2, 7, '2016-11-02 10:36:40', '2016-11-02 10:36:47', 88, 300),
(62, 52, 1, 7, '2016-11-02 10:37:44', '2016-11-02 10:38:16', 89, 300),
(63, 53, 1, 7, '2016-11-02 10:38:35', '2016-11-02 10:40:00', 89, 300),
(64, 51, 2, 7, '2016-11-02 10:43:21', '2016-11-02 13:45:00', 88, 300),
(65, 79, 3, 8, '2016-11-02 11:47:23', '2016-11-02 11:48:29', 92, 100),
(66, 80, 3, 8, '2016-11-02 11:47:38', '2016-11-02 11:47:48', 92, 100),
(67, 54, 1, 7, '2016-11-02 12:04:11', '2016-11-02 14:09:02', 89, 300),
(68, 79, 4, 8, '2016-11-02 12:24:12', '2016-11-02 12:43:00', 87, 100),
(69, 80, 4, 8, '2016-11-02 12:43:55', '2016-11-02 13:00:05', 87, 100),
(70, 83, 3, 8, '2016-11-02 13:01:45', '2016-11-02 13:18:51', 92, 100),
(71, 84, 3, 8, '2016-11-02 13:19:36', '2016-11-02 13:33:19', 92, 0),
(72, 79, 5, 8, '2016-11-02 13:20:42', '2016-11-02 13:38:31', 94, 100),
(73, 83, 4, 8, '2016-11-02 13:40:03', '2016-11-02 13:55:23', 87, 100),
(74, 80, 5, 8, '2016-11-02 13:40:48', '2016-11-02 13:58:03', 94, 100),
(75, 52, 2, 7, '2016-11-02 13:45:27', '2016-11-02 16:15:25', 88, 300),
(76, 85, 3, 8, '2016-11-02 13:48:29', '2016-11-02 13:48:40', 92, 100),
(77, 79, 6, 8, '2016-11-02 13:51:29', '2016-11-02 14:42:49', 91, 100),
(78, 79, 7, 8, '2016-11-02 13:56:23', '2016-11-02 14:43:27', 91, 100),
(79, 84, 4, 8, '2016-11-02 13:57:34', '2016-11-02 14:12:39', 87, 0),
(80, 79, 8, 8, '2016-11-02 14:01:06', '2016-11-02 14:43:56', 91, 100),
(81, 55, 1, 7, '2016-11-02 14:10:06', '2016-11-02 15:49:45', 89, 300),
(82, 85, 4, 8, '2016-11-02 14:14:11', '2016-11-02 14:29:57', 87, 100),
(83, 79, 10, 8, '2016-11-02 14:46:51', '2016-11-02 15:02:30', 87, 100),
(84, 80, 6, 8, '2016-11-02 14:49:00', '2016-11-02 15:17:09', 91, 100),
(85, 80, 7, 8, '2016-11-02 14:53:43', '2016-11-02 15:18:04', 91, 100),
(86, 80, 8, 8, '2016-11-02 14:56:55', '2016-11-02 15:18:38', 91, 100),
(87, 83, 5, 8, '2016-11-02 16:10:23', '2016-11-02 16:28:36', 94, 100),
(88, 53, 2, 7, '2016-11-02 16:15:45', '2016-11-03 06:16:44', 88, 300),
(89, 83, 6, 8, '2016-11-02 16:22:27', '2016-11-02 16:50:02', 91, 100),
(90, 80, 10, 8, '2016-11-02 16:23:21', '2016-11-02 16:39:20', 87, 100),
(91, 83, 7, 8, '2016-11-02 16:28:03', '0000-00-00 00:00:00', 91, 100),
(92, 84, 5, 8, '2016-11-02 16:29:52', '2016-11-02 16:51:00', 94, 0),
(93, 83, 8, 8, '2016-11-02 16:31:04', '2016-11-02 16:52:14', 91, 100),
(94, 56, 1, 7, '2016-11-02 16:33:17', '2016-11-02 17:54:59', 89, 300),
(95, 84, 6, 8, '2016-11-02 16:51:36', '2016-11-02 17:16:44', 91, 0),
(96, 84, 7, 8, '2016-11-02 16:55:54', '2016-11-02 17:01:28', 87, 0),
(97, 79, 11, 8, '2016-11-02 16:59:30', '2016-11-02 17:27:39', 86, 100),
(98, 84, 8, 8, '2016-11-02 17:02:02', '2016-11-02 17:20:12', 87, 0),
(99, 85, 5, 8, '2016-11-02 17:02:42', '2016-11-02 17:16:04', 94, 100),
(100, 79, 12, 8, '2016-11-02 17:04:28', '2016-11-02 17:29:57', 94, 100),
(101, 79, 13, 8, '2016-11-02 17:04:40', '2016-11-03 06:19:06', 94, 100),
(102, 83, 10, 8, '2016-11-02 17:15:17', '2016-11-02 17:30:45', 87, 100),
(103, 85, 6, 8, '2016-11-02 17:21:56', '2016-11-02 17:57:55', 91, 100),
(104, 85, 7, 8, '2016-11-02 17:26:19', '2016-11-02 17:58:45', 91, 100),
(105, 80, 11, 8, '2016-11-02 17:28:39', '2016-11-02 17:56:37', 86, 100),
(106, 85, 8, 8, '2016-11-02 17:29:18', '2016-11-02 17:59:05', 91, 100),
(107, 84, 10, 8, '2016-11-02 17:31:05', '2016-11-02 17:48:56', 87, 0),
(108, 80, 12, 8, '2016-11-02 17:33:17', '2016-11-02 17:57:29', 94, 100),
(109, 80, 13, 8, '2016-11-02 17:33:40', '2016-11-03 06:19:46', 94, 100),
(110, 86, 3, 8, '2016-11-03 06:16:01', '2016-11-03 06:27:52', 89, 93),
(111, 79, 14, 8, '2016-11-03 06:17:52', '2016-11-03 06:37:58', 92, 100),
(112, 54, 2, 7, '2016-11-03 06:18:36', '2016-11-03 08:12:54', 88, 300),
(113, 85, 10, 8, '2016-11-03 06:21:30', '2016-11-03 06:36:09', 87, 100),
(114, 87, 3, 8, '2016-11-03 06:28:58', '2016-11-03 06:40:29', 89, 100),
(115, 83, 11, 8, '2016-11-03 06:37:16', '2016-11-03 07:20:02', 86, 100),
(116, 80, 14, 8, '2016-11-03 06:38:25', '2016-11-03 07:00:55', 92, 100),
(117, 86, 4, 8, '2016-11-03 06:38:57', '2016-11-03 06:52:40', 87, 93),
(118, 83, 12, 8, '2016-11-03 06:47:03', '2016-11-03 07:22:44', 86, 100),
(119, 83, 13, 8, '2016-11-03 06:48:17', '2016-11-03 07:58:20', 86, 100),
(120, 86, 5, 8, '2016-11-03 06:49:30', '2016-11-03 07:10:07', 94, 93),
(121, 87, 4, 8, '2016-11-03 06:53:59', '2016-11-03 07:09:00', 87, 100),
(122, 79, 15, 8, '2016-11-03 07:01:50', '2016-11-03 07:24:29', 92, 100),
(123, 87, 5, 8, '2016-11-03 07:10:46', '2016-11-03 07:30:41', 94, 100),
(124, 86, 6, 8, '2016-11-03 07:13:29', '2016-11-03 07:50:10', 91, 93),
(125, 86, 7, 8, '2016-11-03 07:18:13', '2016-11-03 07:52:55', 91, 93),
(126, 86, 8, 8, '2016-11-03 07:22:14', '2016-11-03 07:54:28', 91, 93),
(127, 80, 15, 8, '2016-11-03 07:24:59', '2016-11-03 07:47:33', 92, 100),
(128, 57, 1, 7, '2016-11-03 07:27:07', '2016-11-03 08:52:36', 89, 300),
(129, 84, 11, 8, '2016-11-03 07:28:39', '2016-11-03 08:10:45', 86, 0),
(130, 84, 12, 8, '2016-11-03 07:40:33', '2016-11-03 08:15:11', 86, 0),
(131, 86, 10, 8, '2016-11-03 08:03:37', '2016-11-03 08:18:55', 87, 93),
(132, 87, 6, 8, '2016-11-03 08:06:12', '2016-11-03 08:47:01', 91, 100),
(133, 87, 7, 8, '2016-11-03 08:09:34', '2016-11-03 08:10:01', 91, 100),
(134, 87, 8, 8, '2016-11-03 08:14:07', '2016-11-03 08:53:17', 91, 100),
(135, 84, 13, 8, '2016-11-03 08:15:43', '2016-11-03 08:51:53', 86, 0),
(136, 85, 11, 8, '2016-11-03 08:17:18', '2016-11-03 08:58:46', 86, 100),
(137, 55, 2, 7, '2016-11-03 08:17:54', '2016-11-03 10:15:57', 88, 300),
(138, 85, 12, 8, '2016-11-03 08:26:19', '2016-11-03 09:00:23', 86, 100),
(139, 83, 14, 8, '2016-11-03 08:30:00', '2016-11-03 08:48:49', 92, 100),
(140, 83, 15, 8, '2016-11-03 08:49:12', '2016-11-03 09:12:41', 92, 100),
(141, 58, 1, 7, '2016-11-03 08:57:25', '0000-00-00 00:00:00', 89, 300),
(142, 85, 13, 8, '2016-11-03 09:01:09', '2016-11-03 09:37:42', 86, 100),
(143, 87, 10, 8, '2016-11-03 09:02:00', '2016-11-03 09:17:46', 87, 100),
(144, 86, 11, 8, '2016-11-03 09:03:45', '2016-11-03 09:39:34', 86, 93),
(145, 86, 12, 8, '2016-11-03 09:07:05', '2016-11-03 09:41:18', 86, 93),
(146, 84, 14, 8, '2016-11-03 09:29:17', '2016-11-03 09:49:35', 92, 0),
(147, 86, 13, 8, '2016-11-03 09:41:47', '2016-11-03 10:19:29', 86, 93),
(148, 87, 11, 8, '2016-11-03 09:44:14', '2016-11-03 10:18:01', 86, 100),
(149, 87, 12, 8, '2016-11-03 09:48:23', '2016-11-03 10:19:59', 94, 100),
(150, 85, 14, 8, '2016-11-03 10:04:40', '2016-11-03 10:21:21', 92, 100),
(151, 56, 2, 7, '2016-11-03 10:16:26', '2016-11-03 13:17:14', 88, 300),
(152, 87, 13, 8, '2016-11-03 10:20:30', '0000-00-00 00:00:00', 94, 100),
(153, 84, 15, 8, '2016-11-03 11:19:32', '2016-11-03 11:44:39', 92, 0),
(154, 59, 1, 7, '2016-11-03 11:41:22', '2016-11-03 14:04:09', 93, 300),
(155, 85, 15, 8, '2016-11-03 11:45:34', '2016-11-03 12:06:24', 92, 100),
(156, 86, 14, 8, '2016-11-03 12:07:19', '2016-11-03 12:25:21', 92, 93),
(157, 87, 14, 8, '2016-11-03 12:27:08', '2016-11-03 12:47:08', 92, 100),
(158, 86, 15, 8, '2016-11-03 12:48:12', '2016-11-03 13:13:32', 92, 93),
(159, 87, 15, 8, '2016-11-03 13:14:59', '2016-11-03 13:48:26', 92, 100),
(160, 57, 2, 7, '2016-11-03 13:18:47', '2016-11-03 15:15:39', 88, 300),
(161, 60, 1, 7, '2016-11-03 14:07:30', '2016-11-03 16:27:33', 93, 300),
(162, 58, 20, 7, '2016-11-03 15:45:16', '0000-00-00 00:00:00', 88, 300),
(163, 58, 2, 7, '2016-11-03 15:45:23', '0000-00-00 00:00:00', 88, 300),
(164, 61, 1, 7, '2016-11-03 16:28:50', '2016-11-04 08:06:49', 89, 300),
(165, 59, 2, 7, '2016-11-03 17:40:10', '2016-11-04 07:50:20', 88, 300),
(166, 60, 2, 7, '2016-11-04 07:50:52', '2016-11-04 09:50:28', 88, 300),
(167, 64, 1, 7, '2016-11-04 08:11:08', '2016-11-04 09:55:17', 93, 300),
(168, 60, 20, 7, '2016-11-04 09:50:19', '0000-00-00 00:00:00', 88, 300),
(169, 67, 1, 7, '2016-11-04 09:59:17', '2016-11-04 12:59:39', 93, 300),
(170, 61, 2, 7, '2016-11-04 10:47:11', '2016-11-04 14:17:55', 89, 300),
(171, 68, 1, 7, '2016-11-04 13:42:16', '2016-11-04 15:24:04', 93, 300),
(172, 64, 2, 7, '2016-11-04 14:48:23', '2016-11-05 07:00:54', 89, 300),
(173, 69, 1, 7, '2016-11-04 15:45:01', '2016-11-04 18:34:24', 93, 300),
(174, 70, 1, 7, '2016-11-04 18:43:44', '2016-11-05 07:10:11', 93, 300),
(175, 67, 2, 7, '2016-11-05 07:01:25', '2016-11-05 09:02:10', 88, 300),
(176, 71, 1, 7, '2016-11-05 07:12:03', '2016-11-05 09:16:07', 89, 300),
(177, 68, 2, 7, '2016-11-05 09:02:24', '2016-11-05 11:57:17', 88, 300),
(178, 72, 1, 7, '2016-11-05 09:26:18', '2016-11-05 11:27:54', 89, 300),
(179, 73, 1, 7, '2016-11-05 11:29:14', '2016-11-05 13:01:23', 93, 300),
(180, 69, 2, 7, '2016-11-05 11:57:54', '2016-11-05 13:55:24', 88, 300),
(181, 74, 1, 7, '2016-11-05 13:18:07', '2016-11-05 15:11:57', 89, 300),
(182, 70, 2, 7, '2016-11-05 13:55:50', '2016-11-05 15:58:40', 88, 300),
(183, 75, 1, 7, '2016-11-05 15:26:37', '2016-11-05 16:50:59', 93, 300),
(184, 71, 20, 7, '2016-11-05 16:37:54', '0000-00-00 00:00:00', 88, 300),
(185, 71, 2, 7, '2016-11-05 16:38:01', '2016-11-06 06:27:11', 88, 300),
(186, 62, 1, 7, '2016-11-05 16:59:01', '2016-11-05 18:31:04', 89, 300),
(187, 76, 1, 7, '2016-11-05 18:34:49', '2016-11-05 20:02:06', 93, 300),
(188, 77, 1, 7, '2016-11-05 20:04:51', '2016-11-05 21:51:07', 93, 300),
(189, 72, 2, 7, '2016-11-06 06:27:40', '2016-11-06 08:20:26', 88, 300),
(190, 78, 1, 7, '2016-11-06 06:56:36', '2016-11-06 08:45:45', 89, 300),
(191, 62, 2, 7, '2016-11-06 08:20:43', '2016-11-06 11:20:45', 88, 300),
(192, 81, 1, 7, '2016-11-06 08:48:57', '2016-11-06 10:24:32', 93, 100),
(193, 82, 1, 7, '2016-11-06 10:27:26', '2016-11-06 12:07:40', 93, 300),
(194, 73, 2, 7, '2016-11-06 11:21:15', '2016-11-06 13:21:54', 88, 300),
(195, 74, 2, 7, '2016-11-06 13:22:06', '2016-11-06 15:50:22', 88, 300),
(196, 75, 2, 7, '2016-11-06 15:50:38', '2016-11-06 17:50:00', 88, 300),
(197, 76, 2, 7, '2016-11-07 06:42:37', '2016-11-07 08:40:28', 88, 300),
(198, 77, 2, 7, '2016-11-07 08:40:46', '2016-11-07 11:35:43', 88, 300),
(199, 78, 2, 7, '2016-11-07 11:36:04', '2016-11-07 13:30:25', 88, 300),
(200, 81, 2, 7, '2016-11-07 13:30:49', '2016-11-07 15:30:25', 88, 100),
(201, 82, 2, 7, '2016-11-07 15:30:36', '2016-11-08 11:00:41', 88, 300),
(202, 93, 1, 7, '2016-11-09 10:54:29', '2016-11-09 10:54:47', 93, 300),
(203, 93, 2, 7, '2016-11-09 10:55:02', '2016-11-09 10:55:46', 88, 300),
(204, 94, 1, 7, '2016-11-09 10:56:12', '2016-11-09 10:56:59', 93, 300),
(205, 94, 2, 7, '2016-11-09 10:57:12', '2016-11-09 10:57:20', 88, 300),
(206, 92, 1, 7, '2016-11-09 10:57:47', '2016-11-09 10:58:15', 93, 300),
(207, 92, 2, 7, '2016-11-09 10:58:22', '2016-11-09 10:58:31', 88, 300),
(208, 96, 20, 7, '2016-11-09 11:50:37', '0000-00-00 00:00:00', 88, 300),
(209, 96, 2, 7, '2016-11-09 11:50:43', '2016-11-09 13:50:23', 88, 300),
(210, 105, 3, 8, '2016-11-10 06:11:51', '2016-11-10 06:24:01', 89, 91),
(211, 97, 20, 7, '2016-11-10 06:23:36', '0000-00-00 00:00:00', 88, 300),
(212, 97, 2, 7, '2016-11-10 06:23:41', '2016-11-10 08:10:23', 88, 300),
(213, 106, 3, 8, '2016-11-10 06:28:12', '2016-11-10 06:40:59', 89, 100),
(214, 105, 4, 8, '2016-11-10 06:33:02', '2016-11-10 06:43:59', 87, 91),
(215, 105, 5, 8, '2016-11-10 06:38:18', '2016-11-10 06:58:34', 94, 91),
(216, 107, 3, 8, '2016-11-10 06:41:47', '2016-11-10 06:54:08', 89, 100),
(217, 106, 4, 8, '2016-11-10 06:45:51', '2016-11-10 07:01:02', 87, 100),
(218, 108, 3, 8, '2016-11-10 06:54:46', '2016-11-10 07:14:06', 89, 90),
(219, 106, 5, 8, '2016-11-10 06:59:21', '2016-11-10 07:22:06', 94, 100),
(220, 107, 4, 8, '2016-11-10 07:01:19', '2016-11-10 07:16:37', 87, 100),
(221, 105, 6, 8, '2016-11-10 07:09:23', '2016-11-10 07:52:18', 91, 91),
(222, 109, 3, 8, '2016-11-10 07:14:58', '2016-11-10 07:37:35', 89, 100),
(223, 108, 4, 8, '2016-11-10 07:16:58', '2016-11-10 07:34:29', 87, 90),
(224, 107, 5, 8, '2016-11-10 07:26:08', '2016-11-10 07:46:06', 94, 100),
(225, 109, 4, 8, '2016-11-10 07:38:02', '2016-11-10 07:55:48', 87, 100),
(226, 110, 3, 8, '2016-11-10 07:41:22', '2016-11-10 07:52:55', 89, 100),
(227, 108, 5, 8, '2016-11-10 07:46:33', '2016-11-10 08:05:32', 94, 90),
(228, 106, 6, 8, '2016-11-10 07:56:13', '2016-11-10 08:34:59', 91, 100),
(229, 111, 3, 8, '2016-11-10 07:58:10', '2016-11-10 08:11:05', 89, 90),
(230, 106, 7, 8, '2016-11-10 07:59:42', '2016-11-10 08:37:30', 91, 100),
(231, 105, 10, 8, '2016-11-10 08:01:08', '2016-11-10 08:17:14', 87, 91),
(232, 106, 8, 8, '2016-11-10 08:01:59', '2016-11-10 08:39:28', 91, 100),
(233, 109, 5, 8, '2016-11-10 08:06:10', '2016-11-10 08:26:03', 94, 100),
(234, 98, 2, 7, '2016-11-10 08:10:37', '2016-11-10 09:55:18', 88, 300),
(235, 112, 3, 8, '2016-11-10 08:14:13', '2016-11-10 08:29:48', 92, 100),
(236, 110, 4, 8, '2016-11-10 08:17:57', '2016-11-10 08:36:18', 87, 100),
(237, 110, 5, 8, '2016-11-10 08:26:30', '2016-11-10 08:46:32', 94, 100),
(238, 113, 3, 8, '2016-11-10 08:30:22', '2016-11-10 08:45:22', 92, 100),
(239, 111, 4, 8, '2016-11-10 08:32:52', '2016-11-10 08:47:20', 87, 90),
(240, 107, 6, 8, '2016-11-10 08:44:15', '2016-11-10 09:25:38', 91, 100),
(241, 114, 3, 8, '2016-11-10 08:45:44', '2016-11-10 09:00:03', 92, 89),
(242, 111, 5, 8, '2016-11-10 08:46:14', '2016-11-10 09:06:29', 94, 90),
(243, 106, 10, 8, '2016-11-10 08:48:26', '2016-11-10 09:03:50', 87, 100),
(244, 107, 7, 8, '2016-11-10 08:49:01', '2016-11-10 09:29:26', 91, 100),
(245, 107, 8, 8, '2016-11-10 08:52:10', '2016-11-10 09:31:13', 91, 100),
(246, 115, 3, 8, '2016-11-10 09:00:32', '2016-11-10 09:14:40', 92, 100),
(247, 112, 4, 8, '2016-11-10 09:04:44', '2016-11-10 09:20:07', 87, 100),
(248, 105, 11, 8, '2016-11-10 09:05:19', '2016-11-10 09:36:14', 86, 91),
(249, 105, 13, 8, '2016-11-10 09:11:06', '2016-11-10 09:42:14', 94, 91),
(250, 105, 12, 8, '2016-11-10 09:11:37', '2016-11-10 09:41:49', 94, 91),
(251, 116, 3, 8, '2016-11-10 09:15:04', '2016-11-10 09:29:52', 92, 100),
(252, 113, 4, 8, '2016-11-10 09:20:48', '2016-11-10 09:37:03', 87, 100),
(253, 97, 1, 7, '2016-11-10 09:27:07', '2016-11-10 09:27:26', 89, 300),
(254, 108, 6, 8, '2016-11-10 09:33:25', '2016-11-10 10:16:58', 91, 90),
(255, 108, 7, 8, '2016-11-10 09:36:10', '2016-11-10 10:19:23', 91, 90),
(256, 114, 4, 8, '2016-11-10 09:37:32', '2016-11-10 09:52:24', 87, 89),
(257, 108, 8, 8, '2016-11-10 09:39:03', '2016-11-10 10:22:01', 91, 90),
(258, 106, 11, 8, '2016-11-10 09:42:44', '2016-11-10 10:15:56', 86, 100),
(259, 106, 12, 8, '2016-11-10 09:46:57', '2016-11-10 10:17:45', 94, 100),
(260, 107, 10, 8, '2016-11-10 09:53:24', '2016-11-10 10:09:34', 87, 100),
(261, 99, 2, 7, '2016-11-10 09:55:31', '2016-11-10 12:30:46', 88, 300),
(262, 112, 5, 8, '2016-11-10 10:08:51', '2016-11-10 10:25:43', 94, 100),
(263, 108, 10, 8, '2016-11-10 10:13:02', '2016-11-10 10:22:57', 87, 90),
(264, 106, 13, 8, '2016-11-10 10:18:25', '2016-11-10 11:25:07', 94, 100),
(265, 115, 4, 8, '2016-11-10 11:37:03', '2016-11-10 11:52:33', 87, 100),
(266, 109, 6, 8, '2016-11-10 11:46:20', '2016-11-10 12:31:09', 91, 100),
(267, 116, 4, 8, '2016-11-10 11:52:59', '2016-11-10 12:12:02', 87, 100),
(268, 109, 7, 8, '2016-11-10 11:53:35', '2016-11-10 12:33:30', 91, 100),
(269, 107, 11, 8, '2016-11-10 11:54:38', '2016-11-10 12:27:24', 86, 100),
(270, 109, 8, 8, '2016-11-10 11:56:12', '2016-11-10 12:35:31', 91, 100),
(271, 105, 14, 8, '2016-11-10 11:56:49', '2016-11-10 12:17:26', 92, 91),
(272, 107, 12, 8, '2016-11-10 12:05:09', '2016-11-10 12:28:45', 94, 100),
(273, 108, 11, 8, '2016-11-10 12:30:22', '2016-11-10 12:58:15', 86, 90),
(274, 100, 2, 7, '2016-11-10 12:30:57', '2016-11-11 06:29:42', 88, 300),
(275, 103, 1, 7, '2016-11-10 12:32:27', '2016-11-10 12:33:12', 89, 256),
(276, 110, 6, 8, '2016-11-10 12:34:19', '2016-11-10 13:05:28', 91, 100),
(277, 108, 12, 8, '2016-11-10 12:34:45', '2016-11-10 13:00:36', 94, 90),
(278, 109, 10, 8, '2016-11-10 12:36:05', '2016-11-10 12:52:25', 87, 100),
(279, 110, 7, 8, '2016-11-10 12:38:06', '2016-11-10 13:06:42', 91, 100),
(280, 105, 15, 8, '2016-11-10 12:39:25', '2016-11-10 13:01:08', 92, 91),
(281, 110, 8, 8, '2016-11-10 12:41:37', '2016-11-10 13:07:24', 91, 100),
(282, 102, 1, 7, '2016-11-10 12:46:20', '2016-11-10 12:46:58', 93, 300),
(283, 101, 1, 7, '2016-11-10 12:51:09', '2016-11-10 12:51:13', 93, 300),
(284, 106, 14, 8, '2016-11-10 13:01:38', '2016-11-10 13:24:08', 92, 100),
(285, 113, 5, 8, '2016-11-10 13:03:44', '2016-11-10 13:25:17', 94, 100),
(286, 104, 1, 7, '2016-11-10 13:07:52', '2016-11-10 13:09:27', 93, 256),
(287, 111, 6, 8, '2016-11-10 13:09:52', '2016-11-10 13:35:14', 91, 90),
(288, 111, 7, 8, '2016-11-10 13:11:29', '2016-11-10 13:37:19', 87, 90),
(289, 111, 8, 8, '2016-11-10 13:14:43', '2016-11-10 13:39:00', 87, 90),
(290, 96, 1, 7, '2016-11-10 13:15:04', '2016-11-10 13:15:14', 89, 300),
(291, 95, 1, 7, '2016-11-10 13:16:02', '2016-11-10 13:16:13', 89, 300),
(292, 98, 1, 7, '2016-11-10 13:16:40', '2016-11-10 13:16:45', 89, 300),
(293, 99, 1, 7, '2016-11-10 13:17:55', '2016-11-10 13:18:03', 89, 300),
(294, 107, 13, 8, '2016-11-10 13:21:08', '2016-11-10 13:21:15', 94, 100),
(295, 109, 11, 8, '2016-11-10 13:22:28', '2016-11-10 14:02:34', 86, 100),
(296, 106, 15, 8, '2016-11-10 13:24:37', '2016-11-10 14:04:22', 92, 100),
(297, 107, 14, 8, '2016-11-10 13:25:00', '2016-11-10 13:46:33', 92, 100),
(298, 114, 5, 8, '2016-11-10 13:26:04', '2016-11-10 13:45:56', 94, 89),
(299, 109, 12, 8, '2016-11-10 13:27:47', '2016-11-10 14:03:05', 86, 100),
(300, 112, 6, 8, '2016-11-10 13:36:00', '2016-11-10 14:16:50', 91, 100),
(301, 112, 7, 8, '2016-11-10 13:40:03', '2016-11-10 14:19:55', 91, 100),
(302, 110, 10, 8, '2016-11-10 13:40:32', '2016-11-10 13:56:50', 87, 100),
(303, 112, 8, 8, '2016-11-10 13:43:25', '2016-11-10 14:21:59', 91, 100),
(304, 115, 5, 8, '2016-11-10 13:46:20', '2016-11-10 13:59:14', 94, 100),
(305, 108, 13, 8, '2016-11-10 13:48:24', '2016-11-10 13:48:49', 86, 90),
(306, 111, 10, 8, '2016-11-10 13:57:34', '2016-11-10 14:12:52', 87, 90),
(307, 108, 14, 8, '2016-11-10 13:58:14', '2016-11-10 14:22:54', 92, 90),
(308, 109, 13, 8, '2016-11-10 14:03:31', '2016-11-10 14:41:17', 86, 100),
(309, 116, 5, 8, '2016-11-10 14:03:52', '2016-11-10 14:27:37', 94, 100),
(310, 110, 11, 8, '2016-11-10 14:06:57', '2016-11-10 14:33:44', 86, 100),
(311, 110, 12, 8, '2016-11-10 14:11:54', '2016-11-10 14:36:39', 94, 100),
(312, 107, 15, 8, '2016-11-10 14:12:11', '2016-11-10 14:52:40', 92, 100),
(313, 112, 10, 8, '2016-11-10 14:23:07', '2016-11-10 14:39:30', 87, 100),
(314, 113, 6, 8, '2016-11-10 14:23:47', '2016-11-10 14:50:44', 91, 100),
(315, 113, 7, 8, '2016-11-10 14:26:53', '2016-11-10 14:52:13', 91, 100),
(316, 113, 8, 8, '2016-11-10 14:29:31', '2016-11-10 14:54:09', 91, 100),
(317, 108, 15, 8, '2016-11-10 14:32:16', '2016-11-10 14:59:54', 92, 90),
(318, 111, 11, 8, '2016-11-10 14:41:56', '2016-11-10 15:13:28', 86, 90),
(319, 110, 13, 8, '2016-11-10 14:44:11', '2016-11-10 14:44:16', 94, 100),
(320, 111, 12, 8, '2016-11-10 14:47:44', '2016-11-10 15:14:02', 94, 90),
(321, 114, 6, 8, '2016-11-10 14:51:41', '2016-11-10 15:16:16', 91, 89),
(322, 109, 14, 8, '2016-11-10 14:53:23', '2016-11-10 15:12:42', 92, 100),
(323, 114, 7, 8, '2016-11-10 14:54:48', '2016-11-10 15:17:37', 87, 89),
(324, 114, 8, 8, '2016-11-10 14:57:14', '2016-11-10 15:18:30', 87, 89),
(325, 109, 15, 8, '2016-11-10 15:13:10', '0000-00-00 00:00:00', 92, 100),
(326, 115, 6, 8, '2016-11-10 16:15:27', '2016-11-10 16:52:04', 91, 100),
(327, 115, 7, 8, '2016-11-10 16:18:33', '2016-11-10 16:53:31', 91, 100),
(328, 113, 10, 8, '2016-11-10 16:19:07', '2016-11-10 16:35:17', 87, 100),
(329, 112, 11, 8, '2016-11-10 16:20:22', '2016-11-10 16:59:08', 86, 100),
(330, 115, 8, 8, '2016-11-10 16:22:08', '2016-11-10 16:54:22', 91, 100),
(331, 111, 13, 8, '2016-11-10 16:23:03', '2016-11-10 16:23:08', 94, 90),
(332, 110, 14, 8, '2016-11-10 16:23:55', '2016-11-10 16:41:55', 92, 100),
(333, 114, 10, 8, '2016-11-10 16:35:53', '2016-11-10 16:51:01', 87, 89),
(334, 110, 15, 8, '2016-11-10 16:42:26', '2016-11-10 17:03:11', 92, 100),
(335, 116, 6, 8, '2016-11-10 16:56:38', '2016-11-10 17:23:17', 91, 100),
(336, 115, 10, 8, '2016-11-10 16:56:54', '2016-11-10 17:09:09', 87, 100),
(337, 116, 7, 8, '2016-11-10 17:00:15', '2016-11-10 17:25:28', 91, 100),
(338, 112, 12, 8, '2016-11-10 17:00:44', '2016-11-10 17:00:51', 94, 100),
(339, 113, 11, 8, '2016-11-10 17:01:14', '2016-11-10 17:29:59', 86, 100),
(340, 112, 13, 8, '2016-11-10 17:02:10', '2016-11-11 06:24:44', 94, 100),
(341, 111, 14, 8, '2016-11-10 17:03:40', '2016-11-10 17:24:49', 92, 90),
(342, 116, 8, 8, '2016-11-10 17:04:18', '2016-11-10 17:26:04', 87, 100),
(343, 113, 12, 8, '2016-11-10 17:05:37', '2016-11-10 17:35:56', 94, 100),
(344, 111, 15, 8, '2016-11-10 17:25:04', '2016-11-10 17:47:22', 92, 90),
(345, 116, 10, 8, '2016-11-10 17:26:26', '2016-11-10 17:43:14', 87, 100),
(346, 113, 13, 8, '2016-11-10 17:36:24', '2016-11-10 17:36:28', 94, 100),
(347, 117, 3, 8, '2016-11-11 06:11:17', '2016-11-11 06:30:26', 89, 89),
(348, 112, 14, 8, '2016-11-11 06:26:08', '2016-11-11 06:45:03', 92, 100),
(349, 117, 4, 8, '2016-11-11 06:30:58', '2016-11-11 06:46:46', 87, 89),
(350, 118, 3, 8, '2016-11-11 06:31:25', '2016-11-11 06:39:18', 89, 100),
(351, 101, 2, 7, '2016-11-11 06:31:37', '2016-11-11 08:25:26', 88, 300),
(352, 117, 5, 8, '2016-11-11 06:37:41', '2016-11-11 06:56:25', 94, 89),
(353, 114, 11, 8, '2016-11-11 06:38:48', '2016-11-11 07:20:27', 86, 89),
(354, 119, 3, 8, '2016-11-11 06:40:57', '2016-11-11 06:55:10', 89, 100),
(355, 113, 14, 8, '2016-11-11 06:45:21', '2016-11-11 07:06:13', 92, 100),
(356, 118, 4, 8, '2016-11-11 06:47:17', '2016-11-11 07:06:36', 87, 100),
(357, 120, 3, 8, '2016-11-11 06:56:08', '2016-11-11 07:07:58', 89, 89),
(358, 118, 5, 8, '2016-11-11 06:57:43', '2016-11-11 07:16:16', 94, 100),
(359, 117, 6, 8, '2016-11-11 06:59:48', '2016-11-11 07:39:35', 91, 89),
(360, 117, 7, 8, '2016-11-11 07:02:47', '2016-11-11 07:42:31', 91, 89),
(361, 114, 12, 8, '2016-11-11 07:04:56', '2016-11-11 07:26:31', 86, 89),
(362, 117, 8, 8, '2016-11-11 07:05:51', '2016-11-11 07:44:32', 91, 89),
(363, 112, 15, 8, '2016-11-11 07:06:23', '2016-11-11 07:28:28', 92, 100),
(364, 119, 4, 8, '2016-11-11 07:06:56', '2016-11-11 07:20:47', 87, 100),
(365, 121, 3, 8, '2016-11-11 07:08:30', '2016-11-11 07:21:48', 89, 100),
(366, 119, 5, 8, '2016-11-11 07:17:11', '2016-11-11 07:36:40', 94, 100),
(367, 120, 4, 8, '2016-11-11 07:21:07', '2016-11-11 07:35:24', 87, 89),
(368, 114, 13, 8, '2016-11-11 07:26:56', '2016-11-11 08:02:08', 86, 89),
(369, 113, 15, 8, '2016-11-11 07:28:43', '2016-11-11 07:55:41', 92, 100),
(370, 122, 3, 8, '2016-11-11 07:29:31', '2016-11-11 07:43:49', 89, 100),
(371, 115, 11, 8, '2016-11-11 07:30:10', '2016-11-11 08:17:21', 86, 100),
(372, 115, 12, 8, '2016-11-11 07:34:18', '2016-11-11 08:20:16', 86, 100),
(373, 121, 4, 8, '2016-11-11 07:36:05', '2016-11-11 07:51:20', 87, 100),
(374, 120, 5, 8, '2016-11-11 07:38:01', '2016-11-11 07:57:08', 94, 89),
(375, 118, 6, 8, '2016-11-11 07:45:22', '2016-11-11 08:25:11', 91, 100),
(376, 118, 7, 8, '2016-11-11 07:49:07', '2016-11-11 08:27:22', 91, 100),
(377, 118, 8, 8, '2016-11-11 07:50:36', '2016-11-11 08:29:53', 91, 100),
(378, 117, 10, 8, '2016-11-11 07:51:58', '2016-11-11 08:06:49', 87, 89),
(379, 121, 5, 8, '2016-11-11 07:57:23', '2016-11-11 08:19:51', 94, 100),
(380, 114, 14, 8, '2016-11-11 08:03:15', '2016-11-11 08:23:38', 92, 89),
(381, 123, 3, 8, '2016-11-11 08:04:21', '2016-11-11 08:31:24', 89, 88),
(382, 122, 4, 8, '2016-11-11 08:08:17', '2016-11-11 08:23:24', 87, 100),
(383, 115, 13, 8, '2016-11-11 08:20:36', '2016-11-11 08:56:26', 86, 100),
(384, 122, 5, 8, '2016-11-11 08:20:57', '2016-11-11 08:47:03', 94, 100),
(385, 116, 11, 8, '2016-11-11 08:22:35', '2016-11-11 09:03:23', 86, 100),
(386, 114, 15, 8, '2016-11-11 08:23:45', '2016-11-11 08:45:53', 92, 89),
(387, 102, 2, 7, '2016-11-11 08:25:39', '2016-11-11 11:21:17', 88, 300),
(388, 116, 12, 8, '2016-11-11 08:26:35', '2016-11-11 09:06:13', 86, 100),
(389, 118, 10, 8, '2016-11-11 08:30:53', '2016-11-11 08:46:04', 87, 100),
(390, 119, 6, 8, '2016-11-11 08:31:11', '2016-11-11 09:11:55', 91, 100),
(391, 119, 7, 8, '2016-11-11 08:34:55', '2016-11-11 09:14:05', 91, 100),
(392, 119, 8, 8, '2016-11-11 08:37:57', '2016-11-11 09:15:53', 91, 100),
(393, 123, 4, 8, '2016-11-11 08:46:14', '2016-11-11 09:01:11', 87, 88),
(394, 115, 14, 8, '2016-11-11 08:56:39', '2016-11-11 09:14:49', 92, 100),
(395, 116, 13, 8, '2016-11-11 09:06:28', '2016-11-11 09:40:44', 86, 100),
(396, 117, 11, 8, '2016-11-11 09:06:55', '2016-11-11 09:30:54', 86, 89),
(397, 117, 12, 8, '2016-11-11 09:13:00', '2016-11-11 09:33:21', 94, 89),
(398, 115, 15, 8, '2016-11-11 09:15:27', '2016-11-11 09:36:11', 92, 100),
(399, 119, 10, 8, '2016-11-11 09:16:24', '2016-11-11 09:30:13', 87, 100),
(400, 120, 6, 8, '2016-11-11 09:17:23', '2016-11-11 09:46:14', 91, 89),
(401, 120, 7, 8, '2016-11-11 09:19:44', '2016-11-11 09:48:15', 91, 89),
(402, 120, 8, 8, '2016-11-11 09:21:32', '2016-11-11 09:50:03', 91, 89),
(403, 117, 13, 8, '2016-11-11 09:33:34', '2016-11-11 10:07:15', 94, 89),
(404, 124, 3, 8, '2016-11-11 09:35:55', '2016-11-11 09:49:33', 89, 100),
(405, 116, 14, 8, '2016-11-11 09:46:27', '2016-11-11 10:00:37', 92, 100),
(406, 121, 6, 8, '2016-11-11 09:47:32', '2016-11-11 10:11:30', 91, 100),
(407, 121, 7, 8, '2016-11-11 09:48:52', '2016-11-11 10:13:20', 87, 100),
(408, 121, 8, 8, '2016-11-11 09:51:24', '2016-11-11 10:14:49', 87, 100),
(409, 118, 11, 8, '2016-11-11 09:53:37', '2016-11-11 10:20:37', 86, 100),
(410, 118, 12, 8, '2016-11-11 09:55:42', '2016-11-11 10:22:28', 94, 100),
(411, 116, 15, 8, '2016-11-11 10:00:45', '2016-11-11 10:20:49', 92, 100),
(412, 117, 14, 8, '2016-11-11 10:20:58', '2016-11-11 11:43:57', 92, 89),
(413, 118, 14, 8, '2016-11-11 10:22:50', '2016-11-11 12:40:33', 94, 100),
(414, 103, 2, 7, '2016-11-11 11:21:26', '2016-11-11 13:10:38', 88, 256),
(415, 122, 6, 8, '2016-11-11 11:44:38', '2016-11-11 12:26:59', 91, 100),
(416, 119, 11, 8, '2016-11-11 11:44:59', '2016-11-11 12:21:22', 86, 100),
(417, 125, 3, 8, '2016-11-11 11:45:24', '2016-11-11 12:01:54', 89, 100),
(418, 119, 12, 8, '2016-11-11 11:48:06', '2016-11-11 12:23:37', 94, 100),
(419, 122, 7, 8, '2016-11-11 11:48:36', '2016-11-11 12:29:23', 91, 100),
(420, 122, 8, 8, '2016-11-11 11:50:14', '2016-11-11 12:31:45', 91, 100),
(421, 121, 10, 8, '2016-11-11 11:51:47', '2016-11-11 12:11:14', 87, 100),
(422, 120, 10, 8, '2016-11-11 11:54:12', '2016-11-11 12:26:42', 87, 89),
(423, 117, 15, 8, '2016-11-11 12:14:22', '2016-11-11 12:40:13', 92, 89),
(424, 119, 13, 8, '2016-11-11 12:23:48', '2016-11-11 13:20:56', 94, 100),
(425, 123, 5, 8, '2016-11-11 12:24:52', '2016-11-11 12:41:00', 94, 88),
(426, 120, 11, 8, '2016-11-11 12:25:46', '2016-11-11 12:33:22', 86, 89),
(427, 124, 4, 8, '2016-11-11 12:27:59', '2016-11-11 12:42:15', 87, 100),
(428, 120, 12, 8, '2016-11-11 12:33:58', '2016-11-11 13:06:56', 86, 89),
(429, 123, 6, 8, '2016-11-11 12:34:44', '2016-11-11 13:15:03', 91, 88),
(430, 123, 7, 8, '2016-11-11 12:37:28', '2016-11-11 13:17:15', 91, 88),
(431, 123, 8, 8, '2016-11-11 12:41:28', '2016-11-11 13:19:30', 91, 88),
(432, 125, 4, 8, '2016-11-11 12:42:41', '2016-11-11 12:58:26', 87, 100),
(433, 118, 13, 8, '2016-11-11 12:42:57', '2016-11-11 12:43:03', 94, 100),
(434, 126, 3, 8, '2016-11-11 12:44:08', '2016-11-11 12:58:57', 89, 88),
(435, 124, 5, 8, '2016-11-11 12:45:14', '2016-11-11 13:06:18', 94, 100),
(436, 118, 15, 8, '2016-11-11 12:59:53', '2016-11-11 13:19:57', 92, 100),
(437, 122, 10, 8, '2016-11-11 13:00:06', '2016-11-11 13:15:27', 87, 100),
(438, 120, 13, 8, '2016-11-11 13:07:26', '2016-11-11 13:45:08', 86, 89),
(439, 125, 5, 8, '2016-11-11 13:10:10', '2016-11-11 13:30:15', 94, 100),
(440, 104, 2, 7, '2016-11-11 13:10:48', '2016-11-11 15:35:11', 88, 256),
(441, 126, 4, 8, '2016-11-11 13:15:52', '2016-11-11 13:30:46', 87, 88),
(442, 119, 14, 8, '2016-11-11 13:20:18', '2016-11-11 13:40:47', 92, 100),
(443, 124, 6, 8, '2016-11-11 13:21:18', '2016-11-11 14:01:53', 91, 100),
(444, 124, 7, 8, '2016-11-11 13:22:55', '2016-11-11 14:04:19', 91, 100),
(445, 124, 8, 8, '2016-11-11 13:25:11', '2016-11-11 14:07:00', 91, 100),
(446, 121, 11, 8, '2016-11-11 13:26:51', '2016-11-11 14:10:12', 86, 100),
(447, 125, 6, 8, '2016-11-11 13:30:03', '2016-11-11 14:51:49', 94, 100),
(448, 126, 5, 8, '2016-11-11 13:31:07', '2016-11-11 13:48:29', 94, 88),
(449, 121, 12, 8, '2016-11-11 13:33:21', '2016-11-11 14:13:25', 86, 100),
(450, 123, 10, 8, '2016-11-11 13:33:58', '2016-11-11 13:48:53', 87, 88),
(451, 127, 3, 8, '2016-11-11 13:39:58', '2016-11-11 13:40:09', 89, 100),
(452, 119, 15, 8, '2016-11-11 13:40:56', '2016-11-11 13:59:54', 92, 100),
(453, 128, 3, 8, '2016-11-11 13:41:46', '2016-11-11 13:58:07', 89, 100),
(454, 127, 4, 8, '2016-11-11 13:49:09', '2016-11-11 14:05:19', 87, 100),
(455, 120, 14, 8, '2016-11-11 14:00:17', '2016-11-11 14:20:50', 92, 89),
(456, 128, 4, 8, '2016-11-11 14:05:51', '2016-11-11 14:21:28', 87, 100),
(457, 127, 5, 8, '2016-11-11 14:10:34', '2016-11-11 14:29:08', 94, 100),
(458, 125, 7, 8, '2016-11-11 14:12:30', '2016-11-11 14:53:32', 91, 100),
(459, 121, 13, 8, '2016-11-11 14:13:44', '2016-11-11 14:46:33', 86, 100),
(460, 125, 8, 8, '2016-11-11 14:14:21', '2016-11-11 14:55:30', 91, 100),
(461, 122, 11, 8, '2016-11-11 14:19:14', '2016-11-11 15:00:35', 86, 100),
(462, 120, 15, 8, '2016-11-11 14:21:01', '2016-11-11 14:40:07', 92, 89),
(463, 122, 12, 8, '2016-11-11 14:24:27', '2016-11-11 15:06:54', 86, 100),
(464, 124, 10, 8, '2016-11-11 14:28:20', '2016-11-11 14:44:36', 87, 100),
(465, 128, 5, 8, '2016-11-11 14:29:48', '2016-11-11 14:30:07', 94, 100),
(466, 121, 14, 8, '2016-11-11 14:47:01', '2016-11-11 15:09:50', 92, 100),
(467, 123, 11, 8, '2016-11-11 15:06:07', '2016-11-11 15:33:24', 86, 88),
(468, 122, 13, 8, '2016-11-11 15:07:12', '2016-11-11 15:51:25', 86, 100),
(469, 121, 15, 8, '2016-11-11 15:10:08', '2016-11-11 16:27:17', 92, 100),
(470, 123, 12, 8, '2016-11-11 15:36:28', '2016-11-11 15:37:16', 86, 88),
(471, 123, 13, 8, '2016-11-11 15:37:57', '2016-11-11 16:21:43', 86, 88),
(472, 125, 10, 8, '2016-11-11 16:05:43', '2016-11-11 16:23:02', 87, 100),
(473, 126, 6, 8, '2016-11-11 16:06:01', '2016-11-11 16:36:17', 91, 88),
(474, 126, 7, 8, '2016-11-11 16:08:30', '2016-11-11 16:37:52', 91, 88),
(475, 126, 8, 8, '2016-11-11 16:11:45', '2016-11-11 16:40:09', 91, 88),
(476, 124, 11, 8, '2016-11-11 16:14:50', '2016-11-11 16:45:06', 86, 100),
(477, 124, 12, 8, '2016-11-11 16:17:22', '2016-11-11 16:49:29', 86, 100),
(478, 122, 14, 8, '2016-11-11 16:28:10', '2016-11-11 16:48:15', 92, 100),
(479, 127, 6, 8, '2016-11-11 16:39:55', '2016-11-11 17:02:19', 91, 100),
(480, 127, 7, 8, '2016-11-11 16:41:53', '2016-11-11 17:04:11', 87, 100),
(481, 127, 8, 8, '2016-11-11 16:42:45', '2016-11-11 17:05:27', 87, 100),
(482, 122, 15, 8, '2016-11-11 16:48:26', '2016-11-11 17:08:20', 92, 100),
(483, 124, 13, 8, '2016-11-11 16:50:00', '2016-11-12 06:26:45', 86, 100),
(484, 125, 11, 8, '2016-11-11 16:56:46', '2016-11-11 16:56:54', 86, 100),
(485, 125, 12, 8, '2016-11-11 17:02:57', '2016-11-11 17:26:21', 94, 100),
(486, 128, 6, 8, '2016-11-11 17:03:21', '2016-11-11 17:41:25', 91, 100),
(487, 128, 7, 8, '2016-11-11 17:06:03', '2016-11-11 17:43:52', 91, 100),
(488, 126, 10, 8, '2016-11-11 17:06:21', '2016-11-11 17:20:25', 87, 88),
(489, 128, 8, 8, '2016-11-11 17:07:16', '2016-11-11 17:46:15', 91, 100),
(490, 123, 14, 8, '2016-11-11 17:08:35', '2016-11-11 17:29:52', 92, 88),
(491, 127, 10, 8, '2016-11-11 17:21:11', '2016-11-11 17:37:16', 87, 100),
(492, 125, 13, 8, '2016-11-11 17:27:05', '2016-11-12 06:37:01', 94, 100),
(493, 123, 15, 8, '2016-11-11 17:30:00', '2016-11-11 17:44:10', 92, 88),
(494, 129, 3, 8, '2016-11-12 06:22:00', '2016-11-12 06:35:10', 89, 88),
(495, 128, 10, 8, '2016-11-12 06:26:06', '2016-11-12 06:40:56', 87, 100),
(496, 124, 14, 8, '2016-11-12 06:27:01', '2016-11-12 06:46:58', 92, 100),
(497, 130, 3, 8, '2016-11-12 06:36:32', '2016-11-12 06:51:05', 89, 100),
(498, 129, 4, 8, '2016-11-12 06:42:12', '2016-11-12 06:56:25', 87, 88),
(499, 125, 14, 8, '2016-11-12 06:47:11', '2016-11-12 07:07:42', 92, 100),
(500, 129, 5, 8, '2016-11-12 06:52:12', '2016-11-12 07:00:04', 94, 88),
(501, 131, 3, 8, '2016-11-12 06:52:33', '2016-11-12 07:09:47', 89, 100),
(502, 130, 4, 8, '2016-11-12 06:57:16', '2016-11-12 07:10:36', 87, 100),
(503, 130, 5, 8, '2016-11-12 07:00:34', '2016-11-12 07:22:54', 94, 100),
(504, 129, 6, 8, '2016-11-12 07:03:37', '2016-11-12 07:40:34', 91, 88),
(505, 124, 15, 8, '2016-11-12 07:07:51', '2016-11-12 07:27:11', 92, 100),
(506, 129, 7, 8, '2016-11-12 07:08:14', '2016-11-12 07:42:38', 91, 88),
(507, 132, 3, 8, '2016-11-12 07:10:16', '2016-11-12 07:28:13', 89, 88),
(508, 129, 8, 8, '2016-11-12 07:10:45', '2016-11-12 07:43:42', 91, 88),
(509, 131, 4, 8, '2016-11-12 07:11:10', '2016-11-12 07:25:24', 87, 100),
(510, 125, 15, 8, '2016-11-12 07:27:22', '2016-11-12 07:49:24', 92, 100),
(511, 133, 3, 8, '2016-11-12 07:32:16', '2016-11-12 07:55:34', 89, 100),
(512, 126, 11, 8, '2016-11-12 07:34:33', '2016-11-12 08:10:24', 94, 88),
(513, 126, 12, 8, '2016-11-12 07:39:08', '2016-11-12 08:17:26', 94, 88),
(514, 132, 4, 8, '2016-11-12 07:41:45', '2016-11-12 07:56:04', 87, 88),
(515, 130, 6, 8, '2016-11-12 07:42:00', '2016-11-12 08:25:01', 91, 100),
(516, 130, 8, 8, '2016-11-12 07:45:37', '2016-11-12 07:48:37', 91, 100),
(517, 130, 7, 8, '2016-11-12 07:45:45', '2016-11-12 08:27:10', 91, 100),
(518, 134, 3, 8, '2016-11-12 07:55:50', '2016-11-12 08:10:39', 92, 100),
(519, 133, 4, 8, '2016-11-12 07:59:15', '2016-11-12 08:15:09', 87, 100),
(520, 131, 5, 8, '2016-11-12 08:00:51', '2016-11-12 08:37:08', 89, 100),
(521, 135, 3, 8, '2016-11-12 08:10:53', '2016-11-12 08:27:42', 92, 88),
(522, 134, 4, 8, '2016-11-12 08:16:39', '2016-11-12 08:33:44', 87, 100),
(523, 127, 12, 8, '2016-11-12 08:17:03', '2016-11-12 08:17:11', 94, 100),
(524, 127, 11, 8, '2016-11-12 08:18:04', '2016-11-12 09:05:56', 94, 100),
(525, 136, 3, 8, '2016-11-12 08:27:53', '2016-11-12 08:40:15', 92, 100),
(526, 135, 4, 8, '2016-11-12 08:35:02', '2016-11-12 08:49:10', 87, 88),
(527, 131, 6, 8, '2016-11-12 08:39:02', '2016-11-12 09:19:27', 91, 100),
(528, 137, 3, 8, '2016-11-12 08:40:23', '2016-11-12 08:52:02', 92, 100),
(529, 131, 7, 8, '2016-11-12 08:40:59', '2016-11-12 09:21:38', 91, 100),
(530, 131, 8, 8, '2016-11-12 08:43:15', '2016-11-12 09:23:13', 91, 100),
(531, 132, 5, 8, '2016-11-12 08:48:34', '2016-11-12 09:02:47', 89, 88),
(532, 129, 10, 8, '2016-11-12 08:51:31', '2016-11-12 09:05:43', 87, 88),
(533, 138, 3, 8, '2016-11-12 08:52:11', '2016-11-12 09:06:36', 92, 88),
(534, 133, 5, 8, '2016-11-12 09:02:58', '2016-11-12 09:22:08', 89, 100),
(535, 139, 3, 8, '2016-11-12 09:06:45', '2016-11-12 09:21:00', 92, 100),
(536, 130, 10, 8, '2016-11-12 09:06:58', '2016-11-12 09:24:23', 87, 100),
(537, 127, 13, 8, '2016-11-12 09:10:28', '2016-11-12 09:39:59', 94, 100),
(538, 126, 14, 8, '2016-11-12 09:10:56', '2016-11-12 09:24:51', 92, 88),
(539, 140, 3, 8, '2016-11-12 09:21:10', '2016-11-12 09:33:18', 92, 100),
(540, 131, 10, 8, '2016-11-12 09:25:15', '2016-11-12 09:40:11', 87, 100),
(541, 132, 6, 8, '2016-11-12 09:25:36', '2016-11-12 09:56:39', 91, 88),
(542, 126, 15, 8, '2016-11-12 09:26:19', '2016-11-12 09:46:16', 92, 88),
(543, 132, 7, 8, '2016-11-12 09:28:53', '2016-11-12 09:59:19', 91, 88),
(544, 132, 8, 8, '2016-11-12 09:31:40', '2016-11-12 10:01:17', 91, 88),
(545, 127, 14, 8, '2016-11-12 09:40:40', '2016-11-12 09:59:57', 92, 100),
(546, 128, 11, 8, '2016-11-12 09:41:58', '2016-11-12 10:18:04', 94, 100),
(547, 128, 12, 8, '2016-11-12 09:46:00', '2016-11-12 10:20:28', 94, 100),
(548, 133, 6, 8, '2016-11-12 09:58:41', '2016-11-12 10:25:48', 91, 100),
(549, 127, 15, 8, '2016-11-12 10:00:06', '2016-11-12 10:23:18', 92, 100),
(550, 133, 7, 8, '2016-11-12 10:00:44', '2016-11-12 10:27:30', 87, 100),
(551, 133, 8, 8, '2016-11-12 10:02:33', '2016-11-12 10:28:18', 87, 100),
(552, 128, 13, 8, '2016-11-12 10:23:10', '2016-11-12 11:33:09', 94, 100),
(553, 134, 5, 8, '2016-11-12 11:35:18', '2016-11-12 11:51:10', 94, 100),
(554, 135, 5, 8, '2016-11-12 11:50:36', '2016-11-12 11:50:43', 94, 88),
(555, 132, 10, 8, '2016-11-12 11:59:57', '2016-11-12 12:14:34', 87, 88),
(556, 128, 14, 8, '2016-11-12 12:01:50', '2016-11-12 12:21:33', 92, 100),
(557, 134, 6, 8, '2016-11-12 12:02:47', '2016-11-12 12:41:19', 91, 100),
(558, 134, 7, 8, '2016-11-12 12:07:30', '2016-11-12 12:47:15', 91, 100),
(559, 129, 11, 8, '2016-11-12 12:09:41', '2016-11-12 12:51:05', 94, 88),
(560, 134, 8, 8, '2016-11-12 12:10:42', '2016-11-12 12:47:59', 91, 100),
(561, 136, 4, 8, '2016-11-12 12:15:47', '2016-11-12 12:28:20', 87, 100),
(562, 129, 12, 8, '2016-11-12 12:17:10', '2016-11-12 12:50:55', 94, 88),
(563, 128, 15, 8, '2016-11-12 12:21:45', '2016-11-12 12:41:55', 92, 100),
(564, 137, 4, 8, '2016-11-12 12:29:08', '2016-11-12 12:42:44', 87, 100),
(565, 138, 4, 8, '2016-11-12 12:44:12', '2016-11-12 12:58:10', 87, 88),
(566, 136, 5, 8, '2016-11-12 12:47:33', '2016-11-12 13:10:52', 89, 100),
(567, 135, 7, 8, '2016-11-12 12:49:53', '2016-11-12 13:33:29', 91, 88),
(568, 135, 8, 8, '2016-11-12 12:50:32', '2016-11-12 13:34:51', 91, 88),
(569, 135, 6, 8, '2016-11-12 12:51:31', '2016-11-12 13:30:29', 91, 88),
(570, 130, 11, 8, '2016-11-12 12:53:03', '2016-11-12 13:25:42', 94, 100),
(571, 139, 4, 8, '2016-11-12 12:59:02', '2016-11-12 13:13:40', 87, 100),
(572, 130, 12, 8, '2016-11-12 13:07:37', '2016-11-12 14:02:13', 94, 100),
(573, 133, 10, 8, '2016-11-12 13:14:00', '2016-11-12 13:29:41', 87, 100),
(574, 137, 5, 8, '2016-11-12 13:14:54', '2016-11-12 13:29:57', 89, 100),
(575, 131, 11, 8, '2016-11-12 13:30:10', '2016-11-12 14:00:14', 94, 100),
(576, 134, 10, 8, '2016-11-12 13:31:00', '2016-11-12 13:44:41', 87, 100),
(577, 129, 13, 8, '2016-11-12 13:32:28', '0000-00-00 00:00:00', 94, 88),
(578, 129, 14, 8, '2016-11-12 13:33:17', '2016-11-12 13:50:41', 92, 88),
(579, 138, 5, 8, '2016-11-12 13:35:22', '2016-11-12 13:50:25', 89, 88),
(580, 136, 6, 8, '2016-11-12 13:37:29', '2016-11-12 14:19:37', 91, 100),
(581, 129, 15, 8, '2016-11-12 13:39:54', '2016-11-12 14:01:13', 92, 88),
(582, 136, 7, 8, '2016-11-12 13:41:38', '2016-11-12 14:22:17', 91, 100),
(583, 136, 8, 8, '2016-11-12 13:43:49', '2016-11-12 14:24:33', 91, 100),
(584, 135, 10, 8, '2016-11-12 13:45:28', '2016-11-12 13:59:57', 87, 88),
(585, 139, 5, 8, '2016-11-12 13:53:50', '2016-11-12 14:19:09', 89, 100),
(586, 130, 13, 8, '2016-11-12 14:01:30', '2016-11-12 14:02:29', 94, 100),
(587, 130, 14, 8, '2016-11-12 14:03:02', '2016-11-12 14:20:38', 92, 100),
(588, 131, 12, 8, '2016-11-12 14:03:25', '2016-11-12 14:03:34', 94, 100),
(589, 131, 13, 8, '2016-11-12 14:03:56', '2016-11-12 14:34:56', 94, 100),
(590, 140, 4, 8, '2016-11-12 14:04:07', '2016-11-12 14:19:49', 87, 100),
(591, 132, 11, 8, '2016-11-12 14:12:15', '2016-11-12 14:43:13', 94, 88),
(592, 132, 12, 8, '2016-11-12 14:14:16', '2016-11-12 14:45:33', 94, 88),
(593, 130, 15, 8, '2016-11-12 14:20:47', '0000-00-00 00:00:00', 92, 100),
(594, 137, 7, 8, '2016-11-12 14:25:56', '2016-11-12 15:03:21', 91, 100),
(595, 137, 6, 8, '2016-11-12 14:26:02', '2016-11-12 15:01:29', 91, 100),
(596, 136, 10, 8, '2016-11-12 14:28:56', '2016-11-12 14:43:44', 87, 100),
(597, 137, 8, 8, '2016-11-12 14:29:11', '2016-11-12 15:05:17', 91, 100),
(598, 140, 5, 8, '2016-11-12 14:45:00', '2016-11-12 15:12:35', 89, 100),
(599, 132, 13, 8, '2016-11-12 14:45:42', '2016-11-12 16:24:08', 94, 88),
(600, 133, 11, 8, '2016-11-12 14:52:51', '2016-11-12 15:20:56', 94, 100),
(601, 133, 12, 8, '2016-11-12 14:53:02', '2016-11-12 15:26:21', 94, 100),
(602, 131, 14, 8, '2016-11-12 15:03:02', '2016-11-12 16:21:59', 92, 100),
(603, 133, 13, 8, '2016-11-12 15:26:35', '2016-11-12 16:24:40', 94, 100),
(604, 138, 6, 8, '2016-11-12 15:57:33', '2016-11-12 16:21:14', 91, 88),
(605, 138, 7, 8, '2016-11-12 16:01:38', '2016-11-12 16:23:09', 91, 88),
(606, 138, 8, 8, '2016-11-12 16:04:19', '2016-11-12 16:25:49', 87, 88),
(607, 131, 15, 8, '2016-11-12 16:22:31', '2016-11-12 16:40:42', 92, 100),
(608, 139, 6, 8, '2016-11-12 16:23:39', '2016-11-12 16:50:23', 91, 100),
(609, 139, 7, 8, '2016-11-12 16:26:56', '2016-11-12 16:52:43', 87, 100),
(610, 139, 8, 8, '2016-11-12 16:29:09', '2016-11-12 16:55:05', 87, 100),
(611, 132, 14, 8, '2016-11-12 16:40:58', '2016-11-12 17:00:04', 92, 88),
(612, 132, 15, 8, '2016-11-12 16:45:42', '2016-11-12 17:07:22', 92, 88),
(613, 140, 6, 8, '2016-11-12 16:52:18', '2016-11-12 17:31:46', 91, 100),
(614, 140, 7, 8, '2016-11-12 16:55:15', '2016-11-12 17:33:41', 91, 100),
(615, 137, 10, 8, '2016-11-12 16:56:10', '2016-11-12 17:11:01', 87, 100),
(616, 134, 11, 8, '2016-11-12 16:56:44', '2016-11-12 17:21:39', 94, 100),
(617, 134, 12, 8, '2016-11-12 16:57:04', '2016-11-12 17:23:57', 94, 100),
(618, 140, 8, 8, '2016-11-12 16:58:47', '2016-11-12 17:35:36', 91, 100),
(619, 133, 14, 8, '2016-11-12 17:00:20', '2016-11-12 17:20:39', 92, 100),
(620, 138, 10, 8, '2016-11-12 17:11:35', '2016-11-12 17:25:02', 87, 88),
(621, 133, 15, 8, '2016-11-12 17:20:46', '2016-11-12 17:39:53', 92, 100),
(622, 134, 13, 8, '2016-11-12 17:24:06', '0000-00-00 00:00:00', 94, 100),
(623, 135, 11, 8, '2016-11-12 17:24:20', '0000-00-00 00:00:00', 94, 88),
(624, 135, 12, 8, '2016-11-12 17:24:30', '0000-00-00 00:00:00', 94, 88),
(625, 139, 10, 8, '2016-11-12 17:25:27', '2016-11-12 17:40:05', 87, 100),
(626, 153, 1, 7, '2016-11-14 16:01:49', '2016-11-14 16:02:04', 88, 300),
(629, 154, 1, 7, '2016-11-15 14:25:43', '2016-11-15 14:25:52', 88, 300),
(630, 154, 2, 7, '2016-11-15 14:26:06', '2016-11-15 14:26:11', 88, 300),
(631, 145, 3, 8, '2016-11-16 10:22:22', '2016-11-16 10:27:06', 88, 100),
(632, 145, 4, 8, '2016-11-16 10:23:44', '2016-11-16 10:27:20', 88, 100),
(634, 145, 5, 8, '2016-11-16 10:24:26', '2016-11-16 10:27:31', 88, 100),
(635, 145, 7, 8, '2016-11-16 10:26:44', '2016-11-16 10:27:38', 88, 100);

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

--
-- Table structure for table `uom`
--

CREATE TABLE IF NOT EXISTS `uom` (
  `uom_id` int(11) NOT NULL AUTO_INCREMENT,
  `uom_name` varchar(11) NOT NULL,
  `unit_abbr` varchar(10) NOT NULL,
  PRIMARY KEY (`uom_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `uom`
--

INSERT INTO `uom` (`uom_id`, `uom_name`, `unit_abbr`) VALUES
(1, 'Piece', 'pc');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(50) NOT NULL,
  `pass` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `type` enum('admin','ppc','operator','qa','line_leader') NOT NULL,
  `dept` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=96 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `user`, `pass`, `email`, `type`, `dept`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', 'admin', 0),
(85, 'ppc', 'ppc123', '', 'ppc', 1),
(86, 'Mary Ant Rodriguez', '12345', '', 'operator', 1),
(87, 'Armi Valerie Guevarra', '12345', '', 'operator', 1),
(88, 'Grace Dayrit', '12345', '', 'operator', 1),
(89, 'Norilyn Villoso', '12345', '', 'operator', 1),
(90, 'Arriane Alimurong', '12345', '', 'operator', 1),
(91, 'Cindy Medina', '', '', 'operator', 1),
(92, 'Ludibeth Piamonde', '', '', 'operator', 1),
(93, 'Aiko Pangan', '', '', 'operator', 1),
(94, 'Christel Adona', '', '', 'operator', 1),
(95, 'lineleader', '1234', '', 'line_leader', 1);