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

--
-- 資料表結構 `mq_flow_in_1`
--

CREATE TABLE `mq_flow_in_1` (
  `MqFlowInId` bigint(20) UNSIGNED NOT NULL,
  `GateId` varchar(10) NOT NULL,
  `Cnt` bigint(8) UNSIGNED DEFAULT '0',
  `RepTmk` varchar(19) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 傾印資料表的資料 `mq_flow_in_1`
--

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

--
-- 觸發器 `mq_flow_in_1`
--
DELIMITER $$
CREATE TRIGGER `qqq` AFTER UPDATE ON `mq_flow_in_1` FOR EACH ROW begin
 if NEW.RepTmk<>'' then
	SELECT CntRatIn INTO @CountRateIn FROM water_cht.wr_mach_1 WHERE MachNum=NEW.GateId;
  UPDATE water_cht.wr_mach_1 SET BankStock=BankStock+round((NEW.Cnt*1000/(@CountRateIn*60)),0) WHERE MachNum=NEW.GateId;
 end if;
end
$$
DELIMITER ;
