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

--
-- 資料表結構 `wr_dzp_user`
--

CREATE TABLE `wr_dzp_user` (
  `dzpUserId` int(11) NOT NULL,
  `dzpId` int(11) NOT NULL,
  `dzpItemId` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `url` varchar(200) DEFAULT NULL COMMENT '领奖URL',
  `openid` varchar(32) NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '领奖状态',
  `addtime` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `wr_dzp_user` (`dzpUserId`, `dzpId`, `dzpItemId`, `title`, `url`, `openid`, `state`, `addtime`) VALUES
(1, 1, 3, '5升纯净水', '', 'oSbDwvwoqgT3PnHPrDjcyZMGgipI', 1, 1510298239),
(2, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwvwoqgT3PnHPrDjcyZMGgipI', 0, 1510298253),
(3, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwvwoqgT3PnHPrDjcyZMGgipI', 0, 1510298328),
(4, 1, 3, '5升纯净水', '', 'oSbDwvyy8LerfRvwrLvS8bOKnC20', 1, 1510299071),
(5, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwvyy8LerfRvwrLvS8bOKnC20', 0, 1510299084),
(6, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwvyy8LerfRvwrLvS8bOKnC20', 0, 1510299139),
(7, 1, 3, '5升纯净水', '', 'oSbDwv0F2xNWbnIkSYHtq14AM0zM', 1, 1510312591),
(8, 1, 3, '5升纯净水', '', 'oSbDwv7E_VRBKRlbesk7Yhvi0nM0', 1, 1510397880),
(9, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv7E_VRBKRlbesk7Yhvi0nM0', 0, 1510397893),
(10, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv7E_VRBKRlbesk7Yhvi0nM0', 0, 1510397936),
(11, 1, 3, '5升纯净水', '', 'oSbDwv3J9p29hPKmUu5RWWYi8yT8', 1, 1510408056),
(12, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv3J9p29hPKmUu5RWWYi8yT8', 0, 1510408072),
(13, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv3J9p29hPKmUu5RWWYi8yT8', 0, 1510408128),
(14, 1, 3, '5升纯净水', '', 'oSbDwv8dDaMBXNkAVjFTLAgSIJyw', 1, 1510408847),
(15, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv8dDaMBXNkAVjFTLAgSIJyw', 0, 1510408881),
(16, 1, 3, '5升纯净水', '', 'oSbDwv00BCiispwW79OnBoJZR73s', 1, 1510411069),
(17, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv00BCiispwW79OnBoJZR73s', 0, 1510411091),
(18, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv00BCiispwW79OnBoJZR73s', 0, 1510411156),
(19, 1, 3, '5升纯净水', '', 'oSbDwvzhxOLiQ7OQVpIYOxVCrEoM', 1, 1510456177),
(20, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwvzhxOLiQ7OQVpIYOxVCrEoM', 0, 1510456190),
(21, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwvzhxOLiQ7OQVpIYOxVCrEoM', 0, 1510456254),
(22, 1, 3, '5升纯净水', '', 'oSbDwvxJZmpOAApvogEUxPy-5VFs', 1, 1510458319),
(23, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwvxJZmpOAApvogEUxPy-5VFs', 0, 1510458334),
(24, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwvxJZmpOAApvogEUxPy-5VFs', 0, 1510458388),
(25, 1, 3, '5升纯净水', '', 'oSbDwv1DR2r-q8qqmCx3eF2TGNt0', 1, 1510482367),
(26, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv1DR2r-q8qqmCx3eF2TGNt0', 0, 1510482385),
(27, 1, 3, '5升纯净水', '', 'oSbDwv1_9NXSgwhLhY8i_b-lQUuc', 1, 1510654198),
(28, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv1_9NXSgwhLhY8i_b-lQUuc', 0, 1510654212),
(29, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv1_9NXSgwhLhY8i_b-lQUuc', 0, 1510654279),
(30, 1, 3, '5升纯净水', '', 'oSbDwvwik5m9V2rEXTiI5lCcSA58', 1, 1510901572),
(31, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwvwik5m9V2rEXTiI5lCcSA58', 0, 1510901586),
(32, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwvwik5m9V2rEXTiI5lCcSA58', 0, 1510901624),
(36, 1, 3, '5升纯净水', '', 'oSbDwv4K6DqZ5Mer1_BFyutrDRPY', 1, 1511182878),
(37, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv4K6DqZ5Mer1_BFyutrDRPY', 0, 1511182893),
(38, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv4K6DqZ5Mer1_BFyutrDRPY', 0, 1511182949),
(39, 1, 3, '5升纯净水', '', 'oSbDwv2jt9GNDzhUqlo7DwUuw-Ig', 1, 1511880149),
(40, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv2jt9GNDzhUqlo7DwUuw-Ig', 0, 1511880497),
(41, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv2jt9GNDzhUqlo7DwUuw-Ig', 0, 1511880575),
(42, 1, 3, '5升纯净水', '', 'oSbDwv0gfKIa7uan0YpPZeGn2bnM', 1, 1512300340),
(43, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv0gfKIa7uan0YpPZeGn2bnM', 0, 1512300356),
(44, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv0gfKIa7uan0YpPZeGn2bnM', 0, 1512300483),
(45, 1, 3, '5升纯净水', '', 'oSbDwv2r3ajoRbgTsCOYIzBjt2zU', 1, 1512897784),
(46, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv2r3ajoRbgTsCOYIzBjt2zU', 0, 1512897797),
(47, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv2r3ajoRbgTsCOYIzBjt2zU', 0, 1512897858),
(48, 1, 3, '5升纯净水', '', 'oSbDwvwNd32Uf8tbZMkLQo1gUObY', 1, 1513086419),
(49, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwvwNd32Uf8tbZMkLQo1gUObY', 0, 1513086442),
(50, 1, 3, '5升纯净水', '', 'oSbDwv57xEvyjhtnJiSiy2CsQ5vI', 1, 1513418607),
(51, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv57xEvyjhtnJiSiy2CsQ5vI', 0, 1513418619),
(52, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv57xEvyjhtnJiSiy2CsQ5vI', 0, 1513418645),
(53, 1, 3, '5升纯净水', '', 'oSbDwv9XbPILRpB2BDJak0Pr0ejg', 1, 1513493973),
(54, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv9XbPILRpB2BDJak0Pr0ejg', 0, 1513493997),
(55, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv9XbPILRpB2BDJak0Pr0ejg', 0, 1513494041),
(56, 1, 3, '5升纯净水', '', 'oSbDwvwDmVU017LuVdoNhgTElQ2w', 1, 1513736322),
(57, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwvwDmVU017LuVdoNhgTElQ2w', 0, 1513736334),
(58, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwvwDmVU017LuVdoNhgTElQ2w', 0, 1513736358),
(59, 1, 3, '5升纯净水', '', 'oSbDwvzw4tnTKrEe8fmxoq-gmz0I', 1, 1514725684),
(60, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwvzw4tnTKrEe8fmxoq-gmz0I', 0, 1514725697),
(61, 1, 3, '5升纯净水', '', 'oSbDwvx5MVYkuB-zoUM_DgokpNRo', 1, 1516017123),
(62, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwvx5MVYkuB-zoUM_DgokpNRo', 0, 1516017138),
(63, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwvx5MVYkuB-zoUM_DgokpNRo', 0, 1516017226),
(64, 1, 3, '5升纯净水', '', 'oSbDwv4dEy94C9-9uXridyR8mMbs', 1, 1516069081),
(65, 1, 4, '好礼四选一', '/Home/index/getOpenid/act/usergift/', 'oSbDwv4dEy94C9-9uXridyR8mMbs', 0, 1516069101),
(66, 1, 5, '新会员大礼包', '/Home/index/getOpenid/act/newuserpay/', 'oSbDwv4dEy94C9-9uXridyR8mMbs', 0, 1516069144),
(67, 1, 3, '5升纯净水', '', 'oSbDwvzzUij6SqJRQHWD1b1bJsUo', 1, 1531710820);
