CREATE TABLE `ff_user` (
`user_id` int(10) UNSIGNED NOT NULL,
`username` varchar(50) NOT NULL,
`username_date` int(10) UNSIGNED NOT NULL DEFAULT '0',
`username_date_visible` int(10) UNSIGNED NOT NULL DEFAULT '0',
`email` varchar(120) NOT NULL,
`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',
`question_solution_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',
`last_summary_email_date` int(10) UNSIGNED DEFAULT NULL,
`trophy_points` int(10) UNSIGNED NOT NULL DEFAULT '0',
`alerts_unviewed` smallint(5) 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',
`avatar_highdpi` tinyint(3) 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','rejected','disabled') NOT NULL DEFAULT 'valid',
`security_lock` enum('','change','reset') NOT NULL DEFAULT '',
`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',
`reaction_score` int(11) NOT NULL DEFAULT '0',
`vote_score` int(11) NOT NULL DEFAULT '0',
`warning_points` int(10) UNSIGNED NOT NULL DEFAULT '0',
`is_staff` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`secret_key` varbinary(32) NOT NULL,
`privacy_policy_accepted` int(10) UNSIGNED NOT NULL DEFAULT '0',
`terms_accepted` int(10) UNSIGNED NOT NULL DEFAULT '0',
`mjst_ticket_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`mjst_department_ids` varbinary(255) DEFAULT NULL,
`siropu_rs_referrer_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
`siropu_rs_referral_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`siropu_rs_referral_rewards` blob,
`siropu_rs_referrer_credit` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`dbtech_credits_credits` decimal(65,8) NOT NULL DEFAULT '0.00000000',
`dbtech_credits_lastdaily` int(10) UNSIGNED NOT NULL DEFAULT '0',
`dbtech_credits_lastinterest` int(10) UNSIGNED NOT NULL DEFAULT '0',
`dbtech_credits_lastpaycheck` int(10) UNSIGNED NOT NULL DEFAULT '0',
`dbtech_credits_lasttaxation` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;