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

--
-- 資料表結構 `wr_fanggift_log`
--

CREATE TABLE `wr_fanggift_log` (
  `FangGiftLogId` int(11) NOT NULL,
  `FangId` int(11) NOT NULL COMMENT '房东ID',
  `UserOpenid` varchar(32) NOT NULL COMMENT '用户OPENID',
  `GiftUnit` int(5) NOT NULL COMMENT '可领数量',
  `GiftType` tinyint(1) NOT NULL COMMENT '礼品类型(1-5)',
  `PayTmk` int(11) NOT NULL COMMENT '付款时间',
  `TookFlag` varchar(2) NOT NULL DEFAULT '0' COMMENT '1-已领取'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房东赠品管理';

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

INSERT INTO `wr_fanggift_log` (`FangGiftLogId`, `FangId`, `UserOpenid`, `GiftUnit`, `GiftType`, `PayTmk`, `TookFlag`) VALUES
(1, 6, '', 27, 1, 0, '1'),
(2, 6, '', 15, 2, 0, '1'),
(3, 5, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', -1, 0, 1527220658, '0'),
(4, 5, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', -1, 0, 1527229999, '1'),
(5, 5, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', -1, 0, 1527231630, '0'),
(6, 5, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', -1, 0, 1527231722, '1'),
(7, 5, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', -1, 0, 1527231984, '0'),
(8, 5, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', -1, 0, 1527233017, '0'),
(9, 5, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', -1, 0, 1527233100, '0'),
(10, 6, 'oSbDwv0grZK-sU-t4dJE_GoHXXME', -1, 1, 1527252531, '1'),
(11, 5, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', -1, 2, 1527254395, '0'),
(12, 6, 'oSbDwv4L2WICFeH3g9HSon9qr_mw', -1, 2, 1527687619, '1'),
(13, 6, 'oSbDwv7EpFLJl1yF6I3mnX8PZWj4', -1, 2, 1527687759, '1'),
(14, 6, 'oSbDwv45hvlnnDQ56twVxf2K_6aI', -1, 2, 1527693543, '1'),
(15, 6, 'oSbDwv3luWZA6J022XP18Z-wivTo', -1, 2, 1527769532, '1'),
(16, 6, 'oSbDwvys_C40reYvgb-T4kLd_JiI', -1, 2, 1527769607, '1'),
(17, 6, 'oSbDwv2LXJo2gn3KQQ0gxweFjfk0', -1, 2, 1527909943, '1'),
(18, 6, 'oSbDwvxkJd4WpIjmJR9YwerldMZo', -1, 2, 1528113755, '1'),
(19, 6, 'oSbDwv0bIZOhS60RUoUCLcNQpkuY', -1, 1, 1528118056, '1'),
(20, 7, 'oSbDwv6O6QAPUkG0csxgho-VLCfM', -1, 1, 1528760237, '1'),
(21, 7, 'oSbDwv4LhhK48qDCoa5IM7e8hP7Y', -1, 1, 1528760532, '1'),
(22, 6, 'oSbDwv0RTlt01H_N_7-s6LXjmCOY', -1, 2, 1528891697, '1'),
(23, 6, 'oSbDwv2w57z5mnOaLvCokEIKR5Y8', -1, 2, 1528892734, '1'),
(24, 6, 'oSbDwv5SJsBLvhGWf8eZW9_sSVN8', -1, 2, 1529022542, '1'),
(25, 6, 'oSbDwv0fKKImpHoGBfkfnIVY2caU', -1, 2, 1529061319, '1'),
(26, 6, 'oSbDwv44mINSFP0B-ij_NQitISBc', -1, 2, 1529415582, '1'),
(27, 6, 'oSbDwvysp54WXyjqmavZ-X7ESYDk', -1, 2, 1530112511, '1'),
(28, 6, 'oSbDwv-stf9Q92rp18eZ8sawKWG0', -1, 1, 1530542076, '1'),
(29, 6, 'oSbDwv-nlp2HPeZu_OR99rdwokIM', -1, 1, 1530848286, '1'),
(30, 6, 'oSbDwv19LRUODxn_UgiQCu9-zHBc', -1, 1, 1530958125, '1'),
(31, 6, 'oSbDwv92pBQ48sUf2ueknasjzHEA', -1, 1, 1531146435, '1'),
(32, 6, 'oSbDwv-iyxmEeePVI2ke4K6w560k', -1, 1, 1531146445, '1'),
(33, 7, 'oSbDwv6rcH6avtQ_pnh4W-1QEp0M', -1, 1, 1531273645, '1'),
(34, 6, 'oSbDwvzw4WC6-iqm7PgVn5X6hZRU', -1, 2, 1531493349, '1'),
(35, 6, 'oSbDwv82tOwBYWi3msJe_AgssT9w', -1, 1, 1531647353, '1'),
(36, 6, 'oSbDwvz1xBDctlvJkyb_ukWWrW9o', -1, 1, 1532267847, '1'),
(37, 6, 'oSbDwv-EU3joeYL1n4uxP53RQEfQ', -1, 2, 1532441971, '1'),
(38, 6, 'oSbDwvyizIEvQ5VKjFNjTcWIFhvA', -1, 1, 1532616043, '1'),
(39, 6, 'oSbDwv7vwDnW2nAlXANw9jmBhYx4', -1, 1, 1532783878, '1'),
(40, 6, 'oSbDwv1gQngyxrfOXsgLHVnpwP6Y', -1, 1, 1532860853, '1'),
(41, 6, 'oSbDwvyi1hgwSarAOYPMByJGhmEQ', -1, 1, 1532923441, '1'),
(42, 6, 'oSbDwv_0pARRy7k4eLfJDdmfSNX0', -1, 2, 1533045875, '1'),
(43, 6, 'oSbDwv6Mvqau8iHoECDDwT3RiXjw', -1, 2, 1533046322, '1'),
(44, 6, 'oSbDwv2tTz_1PD8h1QnJSoqLIDbg', -1, 2, 1533303759, '1'),
(45, 6, 'oSbDwv0GVuTwEKtRJmlt6DmSUTn4', -1, 1, 1533776678, '1'),
(46, 7, 'oSbDwv0ABQCmqLta1kwEb64aszWQ', -1, 1, 1533878183, '1'),
(47, 6, 'oSbDwv_VFM_pbbvW-pEuKpcuKQTE', -1, 1, 1535435287, '1'),
(48, 6, 'oSbDwv3pZIbLXXLzWK7x2cjuszng', -1, 1, 1536149552, '1'),
(49, 6, 'oSbDwv2-5ND6wyTwdLII086jgM2U', -1, 1, 1536406437, '1'),
(50, 7, 'oSbDwv5ZbjnmlmGJXR_wbJ6ITTa4', -1, 1, 1536850554, '1'),
(51, 6, 'oSbDwv_getSiSI1gRpUic4h5dlEc', -1, 1, 1537246912, '1'),
(52, 6, 'oSbDwv-lT4jud-PNEyrjPJx592zY', -1, 1, 1538046698, '1'),
(53, 6, 'oSbDwv0Uk7OMiGuKkAO48mr6qtDk', -1, 1, 1538131914, '1'),
(54, 6, 'oSbDwv80qfOEzIUzEgspqnNnWTUU', -1, 2, 1538311509, '1'),
(55, 6, 'oSbDwv92pBQ48sUf2ueknasjzHEA', -1, 2, 1538735313, '1'),
(56, 6, 'oSbDwv2vq2K8Pnnvp5whKfCymiAI', -1, 1, 1538979342, '1'),
(57, 7, 'oSbDwvw5T8dyN3zdNS_SU8dMcz4k', -1, 1, 1539946078, '1'),
(58, 6, 'oSbDwv1gQngyxrfOXsgLHVnpwP6Y', -1, 2, 1540557931, '1'),
(59, 6, 'oSbDwv5o5o4BDF3Ykk1nQg-K6e7E', -1, 1, 1540781818, '1'),
(60, 6, 'oSbDwv0NvsMunVG89v7FlZ8TNeO8', -1, 1, 1541078266, '1'),
(61, 6, 'oSbDwv7mo7CPaa0YCD_9ogf0yBW8', -1, 1, 1541078461, '1'),
(62, 6, 'oSbDwv0CKyxWSawHDbUoP9bJgGzU', -1, 1, 1541384809, '1'),
(63, 7, 'oSbDwv6HzPx3D2IVlM-PEmlD3Wyc', -1, 1, 1541481126, '1'),
(64, 6, 'oSbDwvz6y6v5C4FpIT1JQmG8mga0', -1, 1, 1541490219, '1'),
(65, 7, 'oSbDwv7YykZkxuFrXk91V6CqXiMU', -1, 1, 1541555233, '1'),
(66, 7, 'oSbDwvyOe7FyxDmkF7-jjpIOD-j0', -1, 1, 1541594125, '1'),
(67, 7, 'oSbDwvwrkRcLBjsIXDyF1anVE3FQ', -1, 1, 1541842044, '1'),
(68, 6, 'oSbDwv0RTlt01H_N_7-s6LXjmCOY', -1, 1, 1543493624, '1'),
(69, 7, 'oSbDwv0ABQCmqLta1kwEb64aszWQ', -1, 2, 1544146727, '1');
