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

--
-- 資料表結構 `wr_fanggift-20171211`
--

CREATE TABLE `wr_fanggift-20171211` (
  `FangGiftId` int(11) NOT NULL,
  `FangId` int(11) NOT NULL COMMENT '房东ID',
  `UserOpenid` varchar(32) NOT NULL COMMENT '用户OPENID',
  `UserMobile` varchar(20) NOT NULL COMMENT '用户手机',
  `GiftUnit` int(5) NOT NULL DEFAULT '-1',
  `GiftType` tinyint(1) NOT NULL COMMENT '礼品类型(1-4)',
  `addtime` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房东赠品管理';

--
-- 傾印資料表的資料 `wr_fanggift-20171211`
--

INSERT INTO `wr_fanggift-20171211` (`FangGiftId`, `FangId`, `UserOpenid`, `UserMobile`, `GiftUnit`, `GiftType`, `addtime`) VALUES
(2, 2, 'oSbDwv7E_VRBKRlbesk7Yhvi0nM0', '18122922105', -1, 1, 1510409029),
(3, 2, 'oSbDwvzhxOLiQ7OQVpIYOxVCrEoM', '13712848257', -1, 4, 1510456451),
(4, 2, 'oSbDwv3J9p29hPKmUu5RWWYi8yT8', '13922502971', -1, 1, 1510485777),
(5, 5, 'oSbDwvw-I5VfMaNBYN_924JwYFUY', '15999770520', -1, 0, 1510902073),
(6, 5, 'oSbDwv5F80DZ-0OwmtvQyd1pwrtU', '18666877608', -1, 0, 1512171777),
(7, 2, 'oSbDwv8dDaMBXNkAVjFTLAgSIJyw', '0769-0001', -1, 1, 1512308574),
(8, 4, 'oSbDwv-cNy2wYqEikDHuv9BbyEhg', '13642938724', -1, 1, 1512525003),
(9, 4, 'oSbDwv_5hN1DC_YpbCDJWOz72_Jk', '13712251649', -1, 1, 1512526336),
(10, 4, 'oSbDwvzr3JMS93K6s3v54PBgQSyo', '18038325281', -1, 1, 1512545639),
(11, 4, 'oSbDwvyrptMHVJ_NvgDFwuoZmjL8', '13728339145', -1, 1, 1512548621),
(12, 4, 'oSbDwv_hwim4X22BSV5vFT2oITI4', '18566178783', -1, 4, 1512548636),
(13, 4, 'oSbDwv0uwWXOKSu3ieayjhs656eA', '13838766095', -1, 1, 1512549646),
(14, 4, 'oSbDwv7zQ-JrKwYbYbzJulhxQDB8', '0769-002', -1, 4, 1512626073),
(15, 4, 'oSbDwv9hb6mCuFzOLB6GZvibcCdc', '13725717933', -1, 1, 1512644082),
(16, 4, 'oSbDwv8gOLX_vCbCyRBt8_pMHEK8', '13949308515', -1, 1, 1512723220),
(17, 4, 'oSbDwvz9yPkkix-ypXCRt7b8YeCA', '13612722995', -1, 1, 1512728252),
(18, 4, 'oSbDwvzjshbkz18PzbAiBUEk-Fug', '15916855489', -1, 1, 1512728267),
(19, 4, 'oSbDwv3urJ-Ofwz592pb6QhOWYmg', '13450011002', -1, 1, 1512732336),
(20, 4, 'oSbDwv7S4qpsfM7B0F4WjFlBG7CA', '13537230623', -1, 1, 1512740929),
(21, 4, 'oSbDwv7MJ7ItDGbowQdU8oeEx69U', '13686122799', -1, 4, 1512831790),
(22, 4, 'oSbDwvxfmAOB1CCVxZmZOlz32E-M', '15899600587', -1, 1, 1512879956),
(23, 4, 'oSbDwv-7fx6OwQq2Vfm3rX2gk2GQ', '13428601599', -1, 4, 1512880580),
(24, 4, 'oSbDwv2kdSk1XmCA6kXdMuw4MaBA', '15017107740', -1, 1, 1512905683),
(25, 4, 'oSbDwvyti8F10DFPRg4bJ4HhzzXY', '18566580016', -1, 4, 1512905691),
(26, 4, 'oSbDwvx93AyAvDJAS9V-kxsK4vJg', '13688942449', -1, 4, 1512906063),
(27, 4, 'oSbDwvw_AY7X064Unks10UrZfh48', '18028996615', -1, 1, 1512915727),
(28, 4, 'oSbDwv2h7x_N3qPDy7HHr4j51AKU', '13798777672', -1, 1, 1512915734),
(29, 4, 'oSbDwv-bufbTFT36Qf4OaQHfF3lw', '13433027965', -1, 1, 1512915740),
(30, 4, 'oSbDwv4GN50cptNWz-fZRFgD2w6g', '17724861269', -1, 1, 1512916490),
(31, 2, '', '', 5, 1, 1510372800),
(32, 2, '', '', 5, 2, 1510372800),
(33, 2, '', '', 5, 3, 1510372800),
(34, 2, '', '', 5, 4, 1510372800),
(35, 2, '', '', 6, 1, 1510459200),
(36, 2, '', '', -4, 1, 1512619200),
(37, 4, '', '', 5, 1, 1512129600),
(38, 4, '', '', 3, 2, 1512129600),
(39, 4, '', '', 2, 3, 1512129600),
(40, 4, '', '', 5, 4, 1512129600),
(41, 4, '', '', 10, 1, 1512622800),
(42, 4, '', '', 6, 1, 1512968400);
