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

--
-- 表的结构 `zjr_game_sign`
--

CREATE TABLE `zjr_game_sign` (
  `UserId` bigint(13) NOT NULL,
  `TransCat` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `TransTmk` datetime NOT NULL,
  `GameCat` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `TransAmt` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `zjr_game_sign`
--

INSERT INTO `zjr_game_sign` (`UserId`, `TransCat`, `TransTmk`, `GameCat`, `TransAmt`) VALUES
(4308211020302, '51', '2016-01-08 16:40:43', '101', 50000),
(4308211020302, '51', '2016-01-08 16:44:32', '102', 50000),
(4308211020314, '51', '2016-01-08 17:49:01', '202', 50000),
(4308211020302, '51', '2016-01-08 21:08:26', '103', 50000),
(4308211020302, '51', '2016-01-09 10:26:31', '101', 50000),
(4308211020302, '51', '2016-01-09 10:27:16', '102', 50000),
(4308211020306, '51', '2016-01-11 13:53:33', '101', 50000),
(4308211020320, '51', '2016-01-11 16:17:21', '101', 50000),
(4308211020328, '51', '2016-01-11 18:01:09', '101', 50000),
(4308211020328, '51', '2016-01-11 18:03:31', '102', 50000),
(4308211020302, '51', '2016-01-11 22:14:02', '101', 50000),
(4308211020327, '51', '2016-01-11 23:13:45', '201', 50000),
(4308211020327, '51', '2016-01-11 23:19:08', '101', 50000),
(4308211020327, '51', '2016-01-11 23:19:21', '202', 50000),
(4308211020327, '51', '2016-01-11 23:19:29', '103', 50000),
(4308211020328, '51', '2016-01-12 07:23:41', '102', 50000),
(4308211020328, '51', '2016-01-12 07:25:06', '202', 50000),
(4308211020328, '51', '2016-01-12 07:28:20', '201', 50000),
(4308211020328, '51', '2016-01-12 07:31:06', '301', 50000),
(4308211020328, '51', '2016-01-12 07:31:21', '103', 50000),
(4308211020320, '51', '2016-01-12 11:25:23', '101', 50000),
(4308211020326, '51', '2016-01-12 11:50:26', '101', 50000),
(4308211020322, '51', '2016-01-12 21:21:05', '101', 50000),
(4308211020320, '51', '2016-01-12 21:57:25', '202', 50000),
(4308211020320, '51', '2016-01-12 22:00:55', '103', 50000),
(4308211020335, '51', '2016-01-12 22:20:11', '103', 50000),
(4308211020335, '51', '2016-01-12 22:28:13', '201', 50000),
(4308211020335, '51', '2016-01-12 22:33:53', '301', 50000),
(4308211020335, '51', '2016-01-12 23:07:37', '102', 50000),
(4308211020302, '51', '2016-01-13 10:27:54', '202', 50000),
(4308211020337, '51', '2016-01-13 11:06:37', '101', 50000),
(4308211020337, '51', '2016-01-13 11:06:43', '102', 50000),
(4308211020337, '51', '2016-01-13 11:06:49', '103', 50000),
(4308211020339, '51', '2016-01-13 16:44:01', '201', 50000),
(4308211020339, '51', '2016-01-13 16:50:01', '102', 50000),
(4308211020339, '51', '2016-01-14 09:15:50', '201', 50000),
(4308211020339, '51', '2016-01-14 09:16:35', '101', 50000),
(4308211020312, '51', '2016-01-14 14:41:46', '101', 50000),
(4308211020303, '51', '2016-01-14 19:38:31', '201', 50000),
(4308211020339, '51', '2016-01-16 01:08:06', '201', 50000),
(4308211020339, '51', '2016-01-16 01:10:38', '102', 50000),
(4308211020339, '51', '2016-01-16 01:12:58', '101', 50000),
(4308211020327, '51', '2016-01-16 05:23:11', '202', 50000),
(4308211020327, '51', '2016-01-16 05:23:15', '201', 50000),
(4308211020327, '51', '2016-01-16 05:23:19', '301', 50000),
(4308211020327, '51', '2016-01-16 05:23:23', '101', 50000),
(4308211020327, '51', '2016-01-16 05:23:27', '102', 50000),
(4308211020327, '51', '2016-01-16 05:23:31', '103', 50000),
(4308211020344, '51', '2016-01-16 15:43:11', '301', 50000),
(4308211020344, '51', '2016-01-16 15:43:18', '201', 50000),
(4308211020344, '51', '2016-01-16 15:43:25', '101', 50000),
(4308211020344, '51', '2016-01-16 15:43:30', '102', 50000),
(4308211020344, '51', '2016-01-16 15:43:33', '103', 50000),
(4308211020344, '51', '2016-01-16 15:43:42', '202', 50000),
(4308211020346, '51', '2016-01-17 19:50:34', '103', 50000),
(4308211020302, '51', '2016-01-17 19:50:40', '103', 50000),
(4308211020302, '51', '2016-01-17 19:59:56', '102', 50000),
(4308211020346, '51', '2016-01-17 19:59:57', '202', 50000),
(4308211020346, '51', '2016-01-17 20:00:23', '201', 50000),
(4308211020346, '51', '2016-01-17 20:00:39', '102', 50000),
(4308211020346, '51', '2016-01-17 20:00:43', '301', 50000),
(4308211020327, '51', '2016-01-19 23:17:48', '101', 50000),
(4308211020327, '51', '2016-01-19 23:17:52', '102', 50000),
(4308211020327, '51', '2016-01-19 23:17:55', '103', 50000),
(4308211020327, '51', '2016-01-19 23:17:59', '201', 50000),
(4308211020327, '51', '2016-01-19 23:18:02', '202', 50000),
(4308211020327, '51', '2016-01-19 23:18:05', '301', 50000),
(4308211020303, '51', '2016-01-20 01:25:36', '202', 50000),
(4308211020343, '51', '2016-01-21 14:49:02', '202', 50000),
(4308211020302, '51', '2016-01-21 16:14:02', '103', 50000),
(4308211020304, '51', '2016-01-21 16:14:08', '103', 50000),
(4308211020302, '51', '2016-01-21 16:21:25', '102', 50000),
(4308211020304, '51', '2016-01-21 16:21:36', '102', 50000),
(4308211020327, '51', '2016-01-22 16:21:10', '101', 50000),
(4308211020327, '51', '2016-01-22 16:22:21', '102', 50000),
(4308211020327, '51', '2016-01-22 16:22:24', '103', 50000),
(4308211020327, '51', '2016-01-22 16:22:28', '201', 50000),
(4308211020327, '51', '2016-01-22 16:22:31', '202', 50000),
(4308211020327, '51', '2016-01-22 16:22:34', '301', 50000),
(4308211020313, '51', '2016-01-22 18:31:47', '102', 50000),
(4308211020342, '51', '2016-01-25 08:13:51', '101', 50000),
(4308211020302, '51', '2016-02-01 18:21:59', '101', 50000),
(4308211020313, '51', '2016-02-01 18:22:39', '101', 50000),
(4308211020304, '51', '2016-02-01 18:22:55', '101', 50000),
(4308211020304, '51', '2016-02-01 18:27:59', '103', 50000),
(4308211020302, '51', '2016-02-01 18:29:53', '103', 50000),
(4308211020313, '51', '2016-02-01 18:30:30', '103', 50000),
(4308211020352, '51', '2016-02-01 18:31:13', '103', 50000),
(4308211020352, '51', '2016-02-01 18:41:47', '101', 50000),
(4308211020302, '51', '2016-02-01 18:45:38', '301', 50000),
(4308211020327, '51', '2016-02-02 12:50:31', '101', 50000),
(4308211020327, '51', '2016-02-02 12:50:35', '102', 50000),
(4308211020327, '51', '2016-02-02 12:51:45', '103', 50000),
(4308211020327, '51', '2016-02-02 12:52:17', '201', 50000),
(4308211020327, '51', '2016-02-02 12:52:20', '202', 50000),
(4308211020327, '51', '2016-02-02 12:52:24', '301', 50000),
(4308211020343, '51', '2016-03-04 11:15:24', '202', 50000),
(4308211020302, '51', '2016-03-08 13:04:15', '101', 50000),
(4308211020321, '51', '2016-03-08 16:35:11', '102', 50000),
(4308211020321, '51', '2016-03-08 16:36:07', '101', 50000),
(4308211020321, '51', '2016-03-08 16:36:42', '202', 50000),
(4308211020354, '51', '2016-03-13 22:58:34', '202', 50000),
(4308211020354, '51', '2016-03-13 23:00:55', '102', 50000),
(4308211020354, '51', '2016-03-13 23:00:59', '101', 50000),
(4308211020354, '51', '2016-03-13 23:01:03', '201', 50000),
(4308211020354, '51', '2016-03-13 23:01:10', '301', 50000),
(4308211020354, '51', '2016-03-13 23:01:15', '103', 50000),
(0, '51', '2016-03-14 11:39:05', '', 50000),
(0, '51', '2016-04-08 15:28:52', '103', 50000),
(0, '51', '2016-04-08 15:31:26', '102', 50000),
(0, '51', '2016-04-09 07:07:19', '', 50000);

--
-- 触发器 `zjr_game_sign`
--
DELIMITER $$
CREATE TRIGGER `sign_update_game_score` AFTER INSERT ON `zjr_game_sign` FOR EACH ROW begin
      update zjr_game_score_balance set GameScore=GameScore+new.TransAmt where UserId=new.UserId and GameCat=new.GameCat;
end
$$
DELIMITER ;
