Format: full sql dump
users: 109k
rows: 218k
website: forums.softballfans.com
headers:
Quote: CREATE TABLE `xf_user` (
`user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`email` varchar(120) NOT NULL,
`gender` enum('','male','female') NOT NULL DEFAULT '' COMMENT 'Leave empty for ''unspecified''',
`custom_title` varchar(50) NOT NULL DEFAULT '',
`language_id` int(10) unsigned NOT NULL,
`style_id` int(10) unsigned NOT NULL COMMENT '0 = use system default',
`timezone` varchar(50) NOT NULL COMMENT 'Example: ''Europe/London''',
`visible` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Show browsing activity to others',
`activity_visible` tinyint(3) unsigned NOT NULL DEFAULT '1',
`user_group_id` int(10) unsigned NOT NULL,
`secondary_group_ids` varbinary(255) NOT NULL,
`display_style_group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User group ID that provides user styling',
`permission_combination_id` int(10) unsigned NOT NULL,
`message_count` int(10) unsigned NOT NULL DEFAULT '0',
`conversations_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
`register_date` int(10) unsigned NOT NULL DEFAULT '0',
`last_activity` int(10) unsigned NOT NULL DEFAULT '0',
`trophy_points` int(10) unsigned NOT NULL DEFAULT '0',
`alerts_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
`avatar_date` int(10) unsigned NOT NULL DEFAULT '0',
`avatar_width` smallint(5) unsigned NOT NULL DEFAULT '0',
`avatar_height` smallint(5) unsigned NOT NULL DEFAULT '0',
`gravatar` varchar(120) NOT NULL DEFAULT '' COMMENT 'If specified, this is an email address corresponding to the user''s ''Gravatar''',
`user_state` enum('valid','email_confirm','email_confirm_edit','moderated','email_bounce') NOT NULL DEFAULT 'valid',
`is_moderator` tinyint(3) unsigned NOT NULL DEFAULT '0',
`is_admin` tinyint(3) unsigned NOT NULL DEFAULT '0',
`is_banned` tinyint(3) unsigned NOT NULL DEFAULT '0',
`like_count` int(10) unsigned NOT NULL DEFAULT '0',
`warning_points` int(10) unsigned NOT NULL DEFAULT '0',
`is_staff` tinyint(3) unsigned NOT NULL DEFAULT '0',
`xengallery_media_count` int(10) unsigned NOT NULL DEFAULT '0',
`xengallery_album_count` int(10) unsigned NOT NULL DEFAULT '0',
`xengallery_media_quota` int(10) unsigned NOT NULL DEFAULT '0',
`resource_count` int(10) unsigned NOT NULL DEFAULT '0',
`cta_ft_featured_count` int(10) unsigned NOT NULL DEFAULT '0',
`socialgroups` blob,
`groupmoderator` blob,
`pendinggroups` blob,
sample:
Quote:(39, '18mike', '[email protected]', '', '', 1, 0, 'America/Chicago', 1, 1, 22, UNHEX('3331'), 22, 33, 188, 0, 1047741367, 1593659119, 16, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''),
(40, 'BIGJOE75', '[email protected]', '', '', 1, 0, 'Europe/London', 1, 1, 2, UNHEX(''), 2, 2, 0, 5, 1047743446, 1064914315, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''),
(41, 'ok#11', '[email protected]', '', '', 1, 0, 'America/New_York', 1, 1, 2, UNHEX(''), 2, 2, 0, 4, 1047781579, 1050173799, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''),
(42, 'Pifcan', '[email protected]', '', '', 1, 0, 'America/New_York', 1, 1, 2, UNHEX(''), 2, 2, 0, 1, 1047788393, 1047789167, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', ''),
INSERT INTO `xf_user_authenticate` (`user_id`, `scheme_class`, `data`, `remember_key`) VALUES
(1, 'XenForo_Authentication_Core12', 'a:1:{s:4:\"hash\";s:60:\"$2a$10$7mhXklZ4s9aN/rzRdiTuu.ghXVnMELqYEAxET8o0O0VubFqSuQxZi\";}', UNHEX('543657314E75624C6C4D626B5759514D424E5F746D6B6E4F354B346C31666668662D75584E684F64')),
(2, 'XenForo_Authentication_vBulletin', 'a:2:{s:4:\"hash\";s:32:\"e7529a8b85cb64335a7c50e5ea8b41f1\";s:4:\"salt\";s:3:\"#q@\";}', UNHEX('59705F7A77496B777A703643324864624A7550714D2D497765744D61474E47754F58376C4D493166')),
(3, 'XenForo_Authentication_Core12', 'a:1:{s:4:\"hash\";s:60:\"$2a$10$ZAMqVnC1O7p2cX/iaSwfeOEGxS.vMppAf4s1pa9X/kndQ/FLHw.6O\";}', UNHEX('6B73724D48424878464F4A30583051484C7533754253464249394C316D7068746163636464347346')),
(4, 'XenForo_Authentication_vBulletin', 'a:2:{s:4:\"hash\";s:32:\"85635c13e1cb78bebbbd7c6be6a647ce\";s:4:\"salt\";s:3:\"y<6\";}', UNHEX('547A306F44626A6646434F52504F31523862486C51776841676B776F43305954674E345F6D555374')),
(5, 'XenForo_Authentication_vBulletin', 'a:2:{s:4:\"hash\";s:32:\"f283db38c5e5f87d2dfdaaf78c77ea2e\";s:4:\"salt\";s:3:\"p%I\";}', UNHEX('707437464A754A6E562D4B4F4A6F574C7738595A6A65307569396350335F794A4C675F796E476555')),
(6, 'XenForo_Authentication_Core12', 'a:1:{s:4:\"hash\";s:60:\"$2a$10$hFOfcd..2sMmUatTI9JDM.svKxrUrUn8Lk8mTKyVqaK7upTPVzZba\";}', UNHEX('783930744B6A5A53524839336C4975583937676D6D4F5848486248306C6F32374442723178654A7A')),
(7, 'XenForo_Authentication_Core12', 'a:1:{s:4:\"hash\";s:60:\"$2a$10$MniCqE72B2hUMnEeGCfJeeCWmd8Zru/zxo92itBk56N54dHcvtctq\";}', UNHEX('534267485F384967377241366941306C715A4777574735595553487A685A34534F73596A776E326A')),
(8, 'XenForo_Authentication_vBulletin', 'a:2:{s:4:\"hash\";s:32:\"b4c599363bbe4d7daac3ba4bffd4128b\";s:4:\"salt\";s:3:\"WsL\";}', UNHEX('4D4B3973543156733068374B58566C33356364704D4366764C7370754D6E6C5046785A574A56746A'))
