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

--
-- 資料表結構 `wr_fang`
--

CREATE TABLE `wr_fang` (
  `FangId` int(11) NOT NULL,
  `openid` varchar(32) DEFAULT NULL COMMENT '房东openid',
  `AgentId` int(11) DEFAULT NULL COMMENT '代理ID',
  `City` varchar(10) DEFAULT NULL,
  `Username` varchar(10) NOT NULL,
  `Nickname` varchar(20) DEFAULT NULL,
  `headimgurl` varchar(250) DEFAULT NULL,
  `Mobile` varchar(20) NOT NULL,
  `Address` varchar(100) DEFAULT NULL,
  `house` varchar(50) NOT NULL COMMENT '房间号',
  `Addtime` int(11) NOT NULL,
  `SaleCommRate` float(6,4) NOT NULL DEFAULT '0.1200' COMMENT '售水提成元/升',
  `PromoCommRate` float(10,2) NOT NULL DEFAULT '5.00' COMMENT '推广獎金元/人',
  `FirstSaleComm` float(10,2) NOT NULL DEFAULT '4.00' COMMENT '大礼包獎金元/包',
  `IncomeBal` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '收益余额'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房东表';

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

INSERT INTO `wr_fang` (`FangId`, `openid`, `AgentId`, `City`, `Username`, `Nickname`, `headimgurl`, `Mobile`, `Address`, `house`, `Addtime`, `SaleCommRate`, `PromoCommRate`, `FirstSaleComm`, `IncomeBal`) VALUES
(2, 'oSbDwvyy8LerfRvwrLvS8bOKnC20', NULL, '东莞市长安镇乌沙', '邹先生', '强仔', '', '13620029778', '东莞长安乌沙镇李屋兴华东街6号聚福楼', '204号房间', 1508670255, 0.1200, 5.00, 4.00, 24.89),
(4, 'oSbDwv_TTEht2_hGsbTpOeFR5aRI', NULL, '东莞市长安镇厦岗', '许小姐', '许晓兰', 'http://wx.qlogo.cn/mmopen/WtHdpODgqQuYdNJ0t7vTmunyWQ9BIwT5gfhxVYA8HR3FrrzenP6TZwSuFcnBeL4hb6rmUUowJ5J9nfbCiaJIe6K33m0KZ8ib00/0', '13423458601', '东莞长安镇厦岗兴岗西路3巷10号', '兴发便利店', 1510818494, 0.1200, 5.00, 4.00, 11.97),
(5, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', NULL, '东莞市', 'DV', '蔡海涛¹⁶⁴⁴⁶⁷⁶¹⁶', 'http://wx.qlogo.cn/mmopen/j1OrURiarSSn35ZYDKe15xa0RhCXEDPowZELvJlLIhOiamjBVycC3xXiacv9v6BxtRiboIkjxXiadG19Ww6Q2QB3Wjzz03TzrO1vk/0', '13423458601', 'test', 'test', 1510818494, 0.1200, 5.00, 4.00, 112.12),
(6, 'oSbDwv55i5g31rPfV9R52z7-57rc', NULL, '东莞市虎门镇树田', '林小姐', '伟发五金店', 'http://wx.qlogo.cn/mmopen/WtHdpODgqQtZYIV6sXznhLkDwwkFgrmo1G5Skwdfa1oQkicATOg0NrTv7obLgia9SdLHgmxyQyvNYBFxpBtI6QUHVqbnfO63aib/0', '18038325281', '东莞市虎门镇树田市场口伟发五金店', '树田市场口伟发五金店', 1512891824, 0.0300, 4.00, 4.00, 3.25),
(7, 'oSbDwv3uGybLaBiZeh0XfD6g2680', NULL, '东莞市凤岗镇雁田', '许先生', '凯阳', 'http://thirdwx.qlogo.cn/mmopen/qGusKyb0IEfXr7ib3b3xMoN9sExMAFIia0Y5HSJBIro0BQb88uC6ibLQwTbb8kAf7XrTktKLKXSMGjIrljwZrXibfnUKqWlUpiae0/132', '13414389418', '东莞凤岗镇雁田祥新东路17巷17号', '雁田市场口芬惠商店', 1522811046, 0.0600, 4.00, 4.00, 12.25);
