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

--
-- 表的结构 `zjr_dealer_comm`
--

CREATE TABLE `zjr_dealer_comm` (
  `DealerId` varchar(13) NOT NULL,
  `TransTmk` datetime NOT NULL COMMENT 'wd-取出',
  `TransType` varchar(10) NOT NULL,
  `TransAmt` decimal(8,2) NOT NULL,
  `TransMemo` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `zjr_dealer_comm` (`DealerId`, `TransTmk`, `TransType`, `TransAmt`, `TransMemo`) VALUES
('9010013020132', '2016-03-13 23:00:00', 'wd', '-6.70', 'wx-chen'),
('9010013020124', '2016-03-16 10:39:05', 'wd', '-83.50', 'comm-buy'),
('9010013020239', '2016-03-23 12:55:41', 'wd', '-29.50', 'wx-chen'),
('9010013020228', '2016-03-28 10:47:24', 'wd', '-21.10', 'wx-chen'),
('9010013020260', '2016-03-30 09:59:58', 'wd', '-73.10', 'wx-chen'),
('9010013020283', '2016-04-05 15:15:49', 'wd', '-89.10', 'wx-chen'),
('9010013020124', '2016-04-11 09:07:31', 'wd', '-32.00', 'comm-buy'),
('9010013020109', '2016-04-11 14:56:12', 'wd', '-30.40', 'wx-chen'),
('9010013020317', '2016-04-12 10:46:22', 'wd', '-36.70', 'wx-chen'),
('9010013020124', '2016-04-17 12:54:13', 'wd', '-8.00', 'comm-buy'),
('9010013020283', '2016-04-18 09:37:38', 'wd', '-80.00', 'wx-chen'),
('9010013020320', '2016-04-20 15:58:28', 'wd', '-50.00', 'wx-chen'),
('9010013020327', '2016-04-25 14:10:17', 'wd', '-50.00', 'wx-cht'),
('9010013020395', '2016-04-26 09:58:23', 'wd', '-50.00', 'ali-chen'),
('9010013020283', '2016-04-27 13:30:32', 'wd', '-24.00', 'comm-buy'),
('9010013020110', '2016-04-27 13:52:48', 'wd', '-100.00', 'ali-chen'),
('9010013020317', '2016-04-27 14:02:43', 'wd', '-70.00', 'ali-chen'),
('9010013020418', '2016-05-24 12:00:08', 'wd', '-50.00', 'wx-chen'),
('9010013020845', '2016-05-26 15:00:42', 'wd', '-6.30', 'wx-chen'),
('9010013020418', '2016-06-01 09:32:58', 'wd', '-50.00', 'wx-cht'),
('9010013020509', '2016-06-02 10:32:41', 'wd', '-50.00', 'wx-chen'),
('9010013020110', '2016-06-04 15:49:51', 'wd', '-40.00', 'wx-chen'),
('9010013020771', '2016-06-07 00:00:00', 'wd', '-85.00', 'comm-buy'),
('9010013020771', '2016-09-27 15:11:53', 'wd', '-50.00', 'ali-chen');
