Sql Mix Legalizer.info Full Dump [5Gb]
SQL:
DROP TABLE IF EXISTS `xf_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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',
`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',
`epr_like_given` int(10) unsigned NOT NULL DEFAULT '0',
`warning_points` int(10) unsigned NOT NULL DEFAULT '0',
`taigachat_color` char(6) NOT NULL DEFAULT '',
`mood_id` int(10) unsigned NOT NULL DEFAULT '0',
`xf_bdreputation_given` int(11) DEFAULT '0',
`is_staff` tinyint(3) unsigned NOT NULL DEFAULT '0',
`friend_count` int(10) unsigned NOT NULL DEFAULT '0',
`personal_friend_count` int(10) unsigned NOT NULL DEFAULT '0',
`ragtek_referrer_userid` int(11) NOT NULL DEFAULT '0',
`activity_visible` tinyint(3) unsigned NOT NULL DEFAULT '1',
`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',
`manage_team_count` int(10) unsigned NOT NULL DEFAULT '0',
`team_ribbon_id` int(10) unsigned NOT NULL DEFAULT '0',
`confession_count` int(10) unsigned NOT NULL DEFAULT '0',
`credits` decimal(19,6) NOT NULL DEFAULT '0.000000',
`brc_points` decimal(19,6) NOT NULL DEFAULT '0.000000',
`brrs_referral_count` int(10) unsigned NOT NULL DEFAULT '0',
`brrs_referral_user_id` int(10) unsigned NOT NULL DEFAULT '0',
`brrs_referral_valid` tinyint(3) unsigned NOT NULL DEFAULT '0',
`sig_image_date` int(10) unsigned NOT NULL DEFAULT '0',
`sig_image_link` varchar(250) DEFAULT '',
ENGINE=InnoDB
Last edited: