Cloud 51.Com (Xx5.Com) 43M
Large dump from 51.com (xx5.com),
Date around 2016, 43m user lines total
Columns:
Sample:
Date around 2016, 43m user lines total
Columns:
CREATE TABLE `table_userinfo_00` (
`user_uin` int(15) NOT NULL,
`user_account` varchar(50) DEFAULT NULL,
`user_email` varchar(60) DEFAULT NULL,
`user_pwd_strong` int(3) DEFAULT NULL,
`user_sex` varchar(4) DEFAULT NULL,
`user_level` int(3) DEFAULT NULL,
`user_regdate` datetime DEFAULT NULL,
`user_vipdate` datetime DEFAULT NULL,
`user_vip_deadline` date DEFAULT NULL,
`user_province` varchar(12) DEFAULT NULL,
`user_city` varchar(50) DEFAULT NULL,
`user_town` varchar(50) DEFAULT NULL,
`user_stat` int(2) DEFAULT NULL,
`user_lock_begintime` datetime DEFAULT NULL,
`user_lock_reason` varchar(255) DEFAULT NULL,
`user_lock_days` int(3) DEFAULT NULL,
`user_name` varchar(12) DEFAULT NULL,
`user_idcard` varchar(255) DEFAULT NULL,
`user_write_idcard_ip` varchar(16) DEFAULT NULL,
`user_write_idcard_locate` varchar(60) DEFAULT NULL,
`user_write_idcard_time` datetime DEFAULT NULL,
`user_last_login_time` datetime DEFAULT NULL,
`user_last_login_ip` varchar(20) DEFAULT NULL,
`user_last_login_site` varchar(200) DEFAULT NULL,
`user_login_times` int(8) DEFAULT NULL,
`user_is_bind_email` smallint(2) DEFAULT '0',
`user_is_bind_phone` smallint(2) DEFAULT '0',
`user_is_set_question` smallint(2) DEFAULT '0',
`user_face_url` varchar(200) DEFAULT NULL,
`user_qq` varchar(16) NOT NULL DEFAULT '',
`user_isload` int(11) NOT NULL DEFAULT '0',
`user_uin` int(15) NOT NULL,
`user_account` varchar(50) DEFAULT NULL,
`user_email` varchar(60) DEFAULT NULL,
`user_pwd_strong` int(3) DEFAULT NULL,
`user_sex` varchar(4) DEFAULT NULL,
`user_level` int(3) DEFAULT NULL,
`user_regdate` datetime DEFAULT NULL,
`user_vipdate` datetime DEFAULT NULL,
`user_vip_deadline` date DEFAULT NULL,
`user_province` varchar(12) DEFAULT NULL,
`user_city` varchar(50) DEFAULT NULL,
`user_town` varchar(50) DEFAULT NULL,
`user_stat` int(2) DEFAULT NULL,
`user_lock_begintime` datetime DEFAULT NULL,
`user_lock_reason` varchar(255) DEFAULT NULL,
`user_lock_days` int(3) DEFAULT NULL,
`user_name` varchar(12) DEFAULT NULL,
`user_idcard` varchar(255) DEFAULT NULL,
`user_write_idcard_ip` varchar(16) DEFAULT NULL,
`user_write_idcard_locate` varchar(60) DEFAULT NULL,
`user_write_idcard_time` datetime DEFAULT NULL,
`user_last_login_time` datetime DEFAULT NULL,
`user_last_login_ip` varchar(20) DEFAULT NULL,
`user_last_login_site` varchar(200) DEFAULT NULL,
`user_login_times` int(8) DEFAULT NULL,
`user_is_bind_email` smallint(2) DEFAULT '0',
`user_is_bind_phone` smallint(2) DEFAULT '0',
`user_is_set_question` smallint(2) DEFAULT '0',
`user_face_url` varchar(200) DEFAULT NULL,
`user_qq` varchar(16) NOT NULL DEFAULT '',
`user_isload` int(11) NOT NULL DEFAULT '0',
Sample:
(284464079, 'chfodmz95543590', '792767478@qq.com', 1, '1', NULL, '2013-02-27 17:35:25', NULL, NULL, '广东', '广州', '广州市', 0, '1970-01-01 08:00:00', NULL, 0, '李晖', '450923199505167219', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '792767478', 0),
(284464104, 'chfodmz95549374', '502013611@qq.com', 1, '1', NULL, '2013-02-27 17:36:15', NULL, NULL, '', '', '', 0, '1970-01-01 08:00:00', NULL, 0, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0),
(284464137, 'chfodmz95549462', '1400124445@qq.com', 1, '1', NULL, '2013-02-27 17:37:11', NULL, NULL, '', '', '', 0, '1970-01-01 08:00:00', NULL, 0, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0),
(284467326, 'qianban218', '', 1, '1', NULL, '2013-02-27 19:24:32', NULL, NULL, '', '', '', 0, '1970-01-01 08:00:00', NULL, 0, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0),
(284464104, 'chfodmz95549374', '502013611@qq.com', 1, '1', NULL, '2013-02-27 17:36:15', NULL, NULL, '', '', '', 0, '1970-01-01 08:00:00', NULL, 0, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0),
(284464137, 'chfodmz95549462', '1400124445@qq.com', 1, '1', NULL, '2013-02-27 17:37:11', NULL, NULL, '', '', '', 0, '1970-01-01 08:00:00', NULL, 0, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0),
(284467326, 'qianban218', '', 1, '1', NULL, '2013-02-27 19:24:32', NULL, NULL, '', '', '', 0, '1970-01-01 08:00:00', NULL, 0, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '', '', 0),