
DBHunter
Advanced Member

- Joined
- August 23, 2025
- Messages
- 164
- Reaction score
- 116
- Points
- 28
- Thread Author
- #1
Large dump from 51.com (xx5.com),
Date around 2016, 43m user lines total
Columns:
Sample:
Date around 2016, 43m user lines total
Columns:
Spoiler: 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:
Spoiler: Sample
(284464079, 'chfodmz95543590', ' [email protected] ', 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', ' [email protected] ', 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', ' [email protected] ', 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', ' [email protected] ', 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', ' [email protected] ', 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),
To see this hidden content, you must reply and react with one of the following reactions :
Like,
Love,
Haha,
Wow