PlayStation Universe Database
Sep 2016
Domain:
psu.com
Breach Count:
226,612
Region:
Global
News Report:
-
Leak from:
File Size:
20.43 MB
Uncompressed File Size:
120.66 MB
File Count:
1
The PlayStation Universe Database (PSU) leak occurred in 2016, where an estimated 226,612 records were leaked, containing sensitive information about PlayStation users. The leaked data included email addresses, usernames, passwords, dates of birth, and IP addresses.
The leak was significant, as it exposed personal information of a large number of PlayStation enthusiasts and community members. The hackers responsible for the leak claimed that they had accessed the database through a vulnerability in the sites security system.
The leaked data included a range of personal details, including name and date of birth, as well as login credentials and IP addresses. This sensitive information could be used by malicious actors to impersonate users, access their accounts, and engage in fraudulent activities.
The PlayStation Universe community was shaken by the leak, and the sites administrators took immediate action to rectify the situation. The site was taken offline, and an investigation was launched to identify the source of the leak and assess the impact on affected users.
Leaked Information:
Email
User Name
Password
Date Of Birth
IP Address
We have loaded this breach into our database.
File List:
psu.com_user_201609.sql
File Content Sample:
CREATE TABLE `forum4_user` (
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`membergroupids` char(250) NOT NULL DEFAULT '',
`displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
`password` char(32) NOT NULL DEFAULT '',
`passworddate` date NOT NULL DEFAULT '0000-00-00',
`email` char(100) NOT NULL DEFAULT '',
`styleid` smallint(5) unsigned NOT NULL DEFAULT '0',
`parentemail` char(50) NOT NULL DEFAULT '',
`homepage` char(100) NOT NULL DEFAULT '',
`icq` char(20) NOT NULL DEFAULT '',
`aim` char(20) NOT NULL DEFAULT '',
`yahoo` char(32) NOT NULL DEFAULT '',
`msn` char(100) NOT NULL DEFAULT '',
`skype` char(32) NOT NULL DEFAULT '',
`showvbcode` smallint(5) unsigned NOT NULL DEFAULT '0',
`showbirthday` smallint(5) unsigned NOT NULL DEFAULT '2',
`usertitle` char(250) NOT NULL DEFAULT '',
`customtitle` smallint(6) NOT NULL DEFAULT '0',
`joindate` int(10) unsigned NOT NULL DEFAULT '0',
`daysprune` smallint(6) NOT NULL DEFAULT '0',
`lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`lastpost` int(10) unsigned NOT NULL DEFAULT '0',
`lastpostid` int(10) unsigned NOT NULL DEFAULT '0',
`posts` int(10) unsigned NOT NULL DEFAULT '0',
`reputation` int(11) NOT NULL DEFAULT '10',
`reputationlevelid` int(10) unsigned NOT NULL DEFAULT '1',
`timezoneoffset` char(4) NOT NULL DEFAULT '',
`pmpopup` smallint(6) NOT NULL DEFAULT '0',
`avatarid` smallint(6) NOT NULL DEFAULT '0',
`avatarrevision` int(10) unsigned NOT NULL DEFAULT '0',
`profilepicrevision` int(10) unsigned NOT NULL DEFAULT '0',
`sigpicrevision` int(10) unsigned NOT NULL DEFAULT '0',
`options` int(10) unsigned NOT NULL DEFAULT '33570831',
`birthday` char(10) NOT NULL DEFAULT '',
`birthday_search` date NOT NULL DEFAULT '0000-00-00',
`maxposts` smallint(6) NOT NULL DEFAULT '-1',
`startofweek` smallint(6) NOT NULL DEFAULT '1',
`ipaddress` char(15) NOT NULL DEFAULT '',
`referrerid` int(10) unsigned NOT NULL DEFAULT '0',
`languageid` smallint(5) unsigned NOT NULL DEFAULT '0',
`emailstamp` int(10) unsigned NOT NULL DEFAULT '0',
`threadedmode` smallint(5) unsigned NOT NULL DEFAULT '0',
`autosubscribe` smallint(6) NOT NULL DEFAULT '-1',
`pmtotal` smallint(5) unsigned NOT NULL DEFAULT '0',
`pmunread` smallint(5) unsigned NOT NULL DEFAULT '0',
`salt` char(30) NOT NULL DEFAULT '',
`ipoints` int(10) unsigned NOT NULL DEFAULT '0',
`infractions` int(10) unsigned NOT NULL DEFAULT '0',
`warnings` int(10) unsigned NOT NULL DEFAULT '0',
`infractiongroupids` varchar(255) NOT NULL DEFAULT '',
`infractiongroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`adminoptions` int(10) unsigned NOT NULL DEFAULT '0',
`profilevisits` int(10) unsigned NOT NULL DEFAULT '0',
`friendcount` int(10) unsigned NOT NULL DEFAULT '0',
`friendreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`vmunreadcount` int(10) unsigned NOT NULL DEFAULT '0',
`vmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`socgroupinvitecount` int(10) unsigned NOT NULL DEFAULT '0',
`socgroupreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`pcunreadcount` int(10) unsigned NOT NULL DEFAULT '0',
`pcmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`gmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`assetposthash` varchar(32) NOT NULL DEFAULT '',
`fbuserid` varchar(255) NOT NULL DEFAULT '',
`fbjoindate` int(10) unsigned NOT NULL DEFAULT '0',
`fbname` varchar(255) NOT NULL DEFAULT '',
`logintype` enum('vb','fb') NOT NULL DEFAULT 'vb',
`importuserid` bigint(20) NOT NULL DEFAULT '0',
`money` decimal(15,2) NOT NULL DEFAULT '0.00',
`kbank_nextpay` int(11) DEFAULT '0',
`kbank_awardedtimes` int(11) NOT NULL DEFAULT '0',
`kbank_awardedamount` int(11) NOT NULL DEFAULT '0',
`kbank_thanksenttimes` int(11) NOT NULL DEFAULT '0',
`kbank_thanksentamount` int(11) NOT NULL DEFAULT '0',
`kbank_thankreceivedtimes` int(11) NOT NULL DEFAULT '0',
`kbank_thankreceivedamount` int(11) NOT NULL DEFAULT '0',
`fbaccesstoken` varchar(255) NOT NULL,
`creditspermissions` text,
`dbtech_thanks_likes` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_liked` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_thanks` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_thanked` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_dislikes` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_disliked` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_settings2` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_points` int(10) NOT NULL DEFAULT '0',
`dbtech_thanks_settings` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_alertcount` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshop_points` double NOT NULL DEFAULT '0',
`dbtech_vbshop_purchase` mediumtext,
`dbtech_vbshop_immunity` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshop_usernamestyle` mediumtext,
`dbtech_vbshop_usertitlestyle` mediumtext,
`dbtech_vbshop_bank` double NOT NULL DEFAULT '0',
`dbtech_vbshout_banned` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_settings` int(10) unsigned NOT NULL DEFAULT '4095',
`dbtech_vbshout_shouts` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_shoutstyle` mediumtext,
`dbtech_vbshout_silenced` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_shoutarea` varchar(15) NOT NULL DEFAULT 'default',
`dbtech_vbshout_pm` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_soundsettings` mediumtext,
`dbtech_vbshout_shoutboxsize` int(10) NOT NULL DEFAULT '0',
`dbtech_vbshout_shoutboxsize_detached` int(10) NOT NULL DEFAULT '0',
`dbtech_vbshout_displayorder` mediumtext,
`dbtech_vbactivity_achievementcount` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbactivity_points` double NOT NULL DEFAULT '0',
`dbtech_vbactivity_pointscache` double NOT NULL DEFAULT '0',
`dbtech_vbactivity_pointscache_day` double NOT NULL DEFAULT '0',
`dbtech_vbactivity_pointscache_week` double NOT NULL DEFAULT '0',
`dbtech_vbactivity_pointscache_month` double NOT NULL DEFAULT '0',
`dbtech_vbactivity_rewardscache` mediumtext,
`dbtech_vbactivity_trophycount` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbactivity_medalcount` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbactivity_settings` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbactivity_autocollapse_stats` enum('-1','0','1') NOT NULL DEFAULT '-1',
`dbtech_vbactivity_autocollapse_bar` enum('-1','0','1') NOT NULL DEFAULT '-1',
`dbtech_vbactivity_excluded` enum('0','1') NOT NULL DEFAULT '0',
`dbtech_vbactivity_medalmoderatecount` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbactivity_excluded_tmp` enum('0','1') NOT NULL DEFAULT '0',
`bloggroupreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`showblogcss` int(11) NOT NULL DEFAULT '1',
`newrepcount` smallint(5) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_excluded` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_shouts_lifetime` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`),
KEY `importuser_index` (`importuserid`),
KEY `lastactivity` (`lastactivity`),
KEY `email` (`email`),
KEY `dbtech_vbactivity_excluded_tmp` (`dbtech_vbactivity_excluded_tmp`)
) ENGINE=MyISAM AUTO_INCREMENT=365681 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forum4_user`
--
LOCK TABLES `forum4_user` WRITE;
/*!40000 ALTER TABLE `forum4_user` DISABLE KEYS */;
INSERT INTO `forum4_user` VALUES (339169,2,'',0,'exotics03l','bfef0dfb661f65d21640c1c7ea451ddf','2015-01-03','[email protected]',0,'','','','','','','',1,0,'Newbie',0,1420313099,0,1420314106,1420314106,0,0,0,10,5,'0',0,0,0,0,0,45108311,'01-12-1988','1988-01-12',-1,-1,'103.23.60.126',0,1,0,0,0,0,0,'Y~o@iLXMvj{):S;*S-xPU`HzfwHmK3',0,0,0,'',0,0,45,0,0,0,0,0,0,0,0,0,'','',0,'','vb',0,0.00,0,0,0,0,0,0,0,'',NULL,0,0,0,0,0,0,0,0,0,0,204,NULL,0,NULL,NULL,0,0,4095,0,NULL,0,'default',0,NULL,0,0,NULL,0,311,311,0.5,2.5,8,'a:0:{}',0,0,0,'-1','-1','0',0,'0',0,1,0,0,0),(35,11,'',0,'DjMuZack','6e5408c4d719d00faa897e5895070161','2006-08-13','[email protected]',0,'','','','','','','',0,2,'Newbie',0,1073866413,0,0,1077214505,1082045937,0,40,57,7,'',0,0,0,0,0,45107287,'','0000-00-00',0,0,'',0,0,0,0,0,18,11,'wSV',0,0,0,'',0,0,767,0,0,0,0,0,0,0,0,0,'','',0,'','vb',18,0.00,0,0,0,0,0,0,0,'',NULL,0,0,0,0,0,0,0,0,0,0,0,'a:0:{}',0,NULL,NULL,0,0,8191,0,NULL,0,'default',0,NULL,0,0,NULL,0,2582.5,2582.5,0.5,2.5,8,'a:0:{}',0,0,0,'-1','-1','0',0,'0',0,1,0,0,0),(30,11,'',0,'stevoie','4377f4bfb3a57cf766d798102c53382d','2006-08-13','[email protected]',0,'','','','','','','',0,2,'Newbie',0,1073573221,0,0,1074544557,1088533214,0,9,28,6,'',0,0,0,0,0,45107287,'','0000-00-00',0,0,'',0,0,0,0,0,3,1,'#)9',0,0,0,'',0,0,562,0,0,0,0,0,0,0,0,0,'','',0,'','vb',13,0.00,0,0,0,0,0,0,0,'',NULL,0,0,0,0,0,0,0,0,0,0,0,'a:0:{}',0,NULL,NULL,0,0,8191,0,NULL,0,'default',0,NULL,0,0,NULL,0,2431.5,2431.5,0.5,2.5,8,'a:0:{}',0,0,0,'-1','-1','0',0,'0',0,1,0,0,0),(31,11,'',0,'Oxarion7','233cd593ea1f5bc7c46cef577b39b232','2010-06-04','[email protected]',0,'','http://hotmail.com','','none','none','none','',0,2,'Newbie',0,1073583368,0,0,1077212519,1077039418,0,17,42,6,'',0,0,0,0,0,45107287,'','0000-00-00',0,0,'',0,0,0,0,0,35,1,'\'S$=\'v,^+`8UiI*vPxf)+h{vY]9I%)',0,0,0,'',0,0,975,0,0,0,0,0,0,0,0,0,'','',0,'','vb',14,0.00,0,0,0,0,0,0,0,'',NULL,0,0,0,0,0,0,0,0,0,0,0,'a:0:{}',0,NULL,NULL,0,0,8191,0,NULL,0,'default',0,NULL,0,0,NULL,0,2367.5,2367.5,0.5,2.5,8,'a:0:{}',0,0,0,'-1','-1','0',0,'0',0,1,0,0,0),
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`membergroupids` char(250) NOT NULL DEFAULT '',
`displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
`password` char(32) NOT NULL DEFAULT '',
`passworddate` date NOT NULL DEFAULT '0000-00-00',
`email` char(100) NOT NULL DEFAULT '',
`styleid` smallint(5) unsigned NOT NULL DEFAULT '0',
`parentemail` char(50) NOT NULL DEFAULT '',
`homepage` char(100) NOT NULL DEFAULT '',
`icq` char(20) NOT NULL DEFAULT '',
`aim` char(20) NOT NULL DEFAULT '',
`yahoo` char(32) NOT NULL DEFAULT '',
`msn` char(100) NOT NULL DEFAULT '',
`skype` char(32) NOT NULL DEFAULT '',
`showvbcode` smallint(5) unsigned NOT NULL DEFAULT '0',
`showbirthday` smallint(5) unsigned NOT NULL DEFAULT '2',
`usertitle` char(250) NOT NULL DEFAULT '',
`customtitle` smallint(6) NOT NULL DEFAULT '0',
`joindate` int(10) unsigned NOT NULL DEFAULT '0',
`daysprune` smallint(6) NOT NULL DEFAULT '0',
`lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`lastpost` int(10) unsigned NOT NULL DEFAULT '0',
`lastpostid` int(10) unsigned NOT NULL DEFAULT '0',
`posts` int(10) unsigned NOT NULL DEFAULT '0',
`reputation` int(11) NOT NULL DEFAULT '10',
`reputationlevelid` int(10) unsigned NOT NULL DEFAULT '1',
`timezoneoffset` char(4) NOT NULL DEFAULT '',
`pmpopup` smallint(6) NOT NULL DEFAULT '0',
`avatarid` smallint(6) NOT NULL DEFAULT '0',
`avatarrevision` int(10) unsigned NOT NULL DEFAULT '0',
`profilepicrevision` int(10) unsigned NOT NULL DEFAULT '0',
`sigpicrevision` int(10) unsigned NOT NULL DEFAULT '0',
`options` int(10) unsigned NOT NULL DEFAULT '33570831',
`birthday` char(10) NOT NULL DEFAULT '',
`birthday_search` date NOT NULL DEFAULT '0000-00-00',
`maxposts` smallint(6) NOT NULL DEFAULT '-1',
`startofweek` smallint(6) NOT NULL DEFAULT '1',
`ipaddress` char(15) NOT NULL DEFAULT '',
`referrerid` int(10) unsigned NOT NULL DEFAULT '0',
`languageid` smallint(5) unsigned NOT NULL DEFAULT '0',
`emailstamp` int(10) unsigned NOT NULL DEFAULT '0',
`threadedmode` smallint(5) unsigned NOT NULL DEFAULT '0',
`autosubscribe` smallint(6) NOT NULL DEFAULT '-1',
`pmtotal` smallint(5) unsigned NOT NULL DEFAULT '0',
`pmunread` smallint(5) unsigned NOT NULL DEFAULT '0',
`salt` char(30) NOT NULL DEFAULT '',
`ipoints` int(10) unsigned NOT NULL DEFAULT '0',
`infractions` int(10) unsigned NOT NULL DEFAULT '0',
`warnings` int(10) unsigned NOT NULL DEFAULT '0',
`infractiongroupids` varchar(255) NOT NULL DEFAULT '',
`infractiongroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`adminoptions` int(10) unsigned NOT NULL DEFAULT '0',
`profilevisits` int(10) unsigned NOT NULL DEFAULT '0',
`friendcount` int(10) unsigned NOT NULL DEFAULT '0',
`friendreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`vmunreadcount` int(10) unsigned NOT NULL DEFAULT '0',
`vmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`socgroupinvitecount` int(10) unsigned NOT NULL DEFAULT '0',
`socgroupreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`pcunreadcount` int(10) unsigned NOT NULL DEFAULT '0',
`pcmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`gmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`assetposthash` varchar(32) NOT NULL DEFAULT '',
`fbuserid` varchar(255) NOT NULL DEFAULT '',
`fbjoindate` int(10) unsigned NOT NULL DEFAULT '0',
`fbname` varchar(255) NOT NULL DEFAULT '',
`logintype` enum('vb','fb') NOT NULL DEFAULT 'vb',
`importuserid` bigint(20) NOT NULL DEFAULT '0',
`money` decimal(15,2) NOT NULL DEFAULT '0.00',
`kbank_nextpay` int(11) DEFAULT '0',
`kbank_awardedtimes` int(11) NOT NULL DEFAULT '0',
`kbank_awardedamount` int(11) NOT NULL DEFAULT '0',
`kbank_thanksenttimes` int(11) NOT NULL DEFAULT '0',
`kbank_thanksentamount` int(11) NOT NULL DEFAULT '0',
`kbank_thankreceivedtimes` int(11) NOT NULL DEFAULT '0',
`kbank_thankreceivedamount` int(11) NOT NULL DEFAULT '0',
`fbaccesstoken` varchar(255) NOT NULL,
`creditspermissions` text,
`dbtech_thanks_likes` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_liked` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_thanks` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_thanked` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_dislikes` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_disliked` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_settings2` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_points` int(10) NOT NULL DEFAULT '0',
`dbtech_thanks_settings` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_alertcount` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshop_points` double NOT NULL DEFAULT '0',
`dbtech_vbshop_purchase` mediumtext,
`dbtech_vbshop_immunity` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshop_usernamestyle` mediumtext,
`dbtech_vbshop_usertitlestyle` mediumtext,
`dbtech_vbshop_bank` double NOT NULL DEFAULT '0',
`dbtech_vbshout_banned` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_settings` int(10) unsigned NOT NULL DEFAULT '4095',
`dbtech_vbshout_shouts` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_shoutstyle` mediumtext,
`dbtech_vbshout_silenced` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_shoutarea` varchar(15) NOT NULL DEFAULT 'default',
`dbtech_vbshout_pm` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_soundsettings` mediumtext,
`dbtech_vbshout_shoutboxsize` int(10) NOT NULL DEFAULT '0',
`dbtech_vbshout_shoutboxsize_detached` int(10) NOT NULL DEFAULT '0',
`dbtech_vbshout_displayorder` mediumtext,
`dbtech_vbactivity_achievementcount` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbactivity_points` double NOT NULL DEFAULT '0',
`dbtech_vbactivity_pointscache` double NOT NULL DEFAULT '0',
`dbtech_vbactivity_pointscache_day` double NOT NULL DEFAULT '0',
`dbtech_vbactivity_pointscache_week` double NOT NULL DEFAULT '0',
`dbtech_vbactivity_pointscache_month` double NOT NULL DEFAULT '0',
`dbtech_vbactivity_rewardscache` mediumtext,
`dbtech_vbactivity_trophycount` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbactivity_medalcount` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbactivity_settings` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbactivity_autocollapse_stats` enum('-1','0','1') NOT NULL DEFAULT '-1',
`dbtech_vbactivity_autocollapse_bar` enum('-1','0','1') NOT NULL DEFAULT '-1',
`dbtech_vbactivity_excluded` enum('0','1') NOT NULL DEFAULT '0',
`dbtech_vbactivity_medalmoderatecount` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbactivity_excluded_tmp` enum('0','1') NOT NULL DEFAULT '0',
`bloggroupreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`showblogcss` int(11) NOT NULL DEFAULT '1',
`newrepcount` smallint(5) unsigned NOT NULL DEFAULT '0',
`dbtech_thanks_excluded` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_shouts_lifetime` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`),
KEY `importuser_index` (`importuserid`),
KEY `lastactivity` (`lastactivity`),
KEY `email` (`email`),
KEY `dbtech_vbactivity_excluded_tmp` (`dbtech_vbactivity_excluded_tmp`)
) ENGINE=MyISAM AUTO_INCREMENT=365681 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forum4_user`
--
LOCK TABLES `forum4_user` WRITE;
/*!40000 ALTER TABLE `forum4_user` DISABLE KEYS */;
INSERT INTO `forum4_user` VALUES (339169,2,'',0,'exotics03l','bfef0dfb661f65d21640c1c7ea451ddf','2015-01-03','[email protected]',0,'','','','','','','',1,0,'Newbie',0,1420313099,0,1420314106,1420314106,0,0,0,10,5,'0',0,0,0,0,0,45108311,'01-12-1988','1988-01-12',-1,-1,'103.23.60.126',0,1,0,0,0,0,0,'Y~o@iLXMvj{):S;*S-xPU`HzfwHmK3',0,0,0,'',0,0,45,0,0,0,0,0,0,0,0,0,'','',0,'','vb',0,0.00,0,0,0,0,0,0,0,'',NULL,0,0,0,0,0,0,0,0,0,0,204,NULL,0,NULL,NULL,0,0,4095,0,NULL,0,'default',0,NULL,0,0,NULL,0,311,311,0.5,2.5,8,'a:0:{}',0,0,0,'-1','-1','0',0,'0',0,1,0,0,0),(35,11,'',0,'DjMuZack','6e5408c4d719d00faa897e5895070161','2006-08-13','[email protected]',0,'','','','','','','',0,2,'Newbie',0,1073866413,0,0,1077214505,1082045937,0,40,57,7,'',0,0,0,0,0,45107287,'','0000-00-00',0,0,'',0,0,0,0,0,18,11,'wSV',0,0,0,'',0,0,767,0,0,0,0,0,0,0,0,0,'','',0,'','vb',18,0.00,0,0,0,0,0,0,0,'',NULL,0,0,0,0,0,0,0,0,0,0,0,'a:0:{}',0,NULL,NULL,0,0,8191,0,NULL,0,'default',0,NULL,0,0,NULL,0,2582.5,2582.5,0.5,2.5,8,'a:0:{}',0,0,0,'-1','-1','0',0,'0',0,1,0,0,0),(30,11,'',0,'stevoie','4377f4bfb3a57cf766d798102c53382d','2006-08-13','[email protected]',0,'','','','','','','',0,2,'Newbie',0,1073573221,0,0,1074544557,1088533214,0,9,28,6,'',0,0,0,0,0,45107287,'','0000-00-00',0,0,'',0,0,0,0,0,3,1,'#)9',0,0,0,'',0,0,562,0,0,0,0,0,0,0,0,0,'','',0,'','vb',13,0.00,0,0,0,0,0,0,0,'',NULL,0,0,0,0,0,0,0,0,0,0,0,'a:0:{}',0,NULL,NULL,0,0,8191,0,NULL,0,'default',0,NULL,0,0,NULL,0,2431.5,2431.5,0.5,2.5,8,'a:0:{}',0,0,0,'-1','-1','0',0,'0',0,1,0,0,0),(31,11,'',0,'Oxarion7','233cd593ea1f5bc7c46cef577b39b232','2010-06-04','[email protected]',0,'','http://hotmail.com','','none','none','none','',0,2,'Newbie',0,1073583368,0,0,1077212519,1077039418,0,17,42,6,'',0,0,0,0,0,45107287,'','0000-00-00',0,0,'',0,0,0,0,0,35,1,'\'S$=\'v,^+`8UiI*vPxf)+h{vY]9I%)',0,0,0,'',0,0,975,0,0,0,0,0,0,0,0,0,'','',0,'','vb',14,0.00,0,0,0,0,0,0,0,'',NULL,0,0,0,0,0,0,0,0,0,0,0,'a:0:{}',0,NULL,NULL,0,0,8191,0,NULL,0,'default',0,NULL,0,0,NULL,0,2367.5,2367.5,0.5,2.5,8,'a:0:{}',0,0,0,'-1','-1','0',0,'0',0,1,0,0,0),