`member_id` mediumint(8) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`member_group_id` smallint(3) NOT NULL DEFAULT '0',
`email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`joined` int(10) NOT NULL DEFAULT '0',
`ip_address` varchar(46) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`skin` smallint(5) DEFAULT NULL,
`warn_level` int(10) DEFAULT NULL,
`warn_lastwarn` int(10) NOT NULL DEFAULT '0',
`language` mediumint(4) DEFAULT NULL,
`restrict_post` int(10) NOT NULL DEFAULT '0',
`bday_day` int(2) DEFAULT NULL,
`bday_month` int(2) DEFAULT NULL,
`bday_year` int(4) DEFAULT NULL,
`msg_count_new` int(2) NOT NULL DEFAULT '0',
`msg_count_total` int(3) NOT NULL DEFAULT '0',
`msg_count_reset` int(1) NOT NULL DEFAULT '0',
`msg_show_notification` int(1) NOT NULL DEFAULT '0',
`last_visit` int(10) DEFAULT '0',
`last_activity` int(10) DEFAULT '0',
`mod_posts` int(10) NOT NULL DEFAULT '0',
`auto_track` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0',
`temp_ban` int(10) DEFAULT '0',
`mgroup_others` varchar(245) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`member_login_key_expire` int(10) NOT NULL DEFAULT '0',
`members_seo_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`members_cache` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`failed_logins` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`failed_login_count` smallint(3) NOT NULL DEFAULT '0',
`members_profile_views` int(10) unsigned NOT NULL DEFAULT '0',
`members_pass_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`members_pass_salt` varchar(22) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`members_bitoptions` int(10) unsigned NOT NULL DEFAULT '0',
`members_day_posts` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0,0',
`notification_cnt` mediumint(9) NOT NULL DEFAULT '0',
`pp_last_visitors` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`pp_main_photo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`pp_main_width` int(5) DEFAULT NULL,
`pp_main_height` int(5) DEFAULT NULL,
`pp_thumb_photo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`pp_thumb_width` int(5) DEFAULT NULL,
`pp_thumb_height` int(5) DEFAULT NULL,
`pp_setting_count_comments` int(2) DEFAULT NULL,
`pp_reputation_points` int(10) DEFAULT NULL,
`pp_photo_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`signature` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`pconversation_filters` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`pp_customization` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`timezone` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pp_cover_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`profilesync` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`profilesync_lastsync` int(10) NOT NULL DEFAULT '0' COMMENT 'Indicates the last time any profile sync service was ran',
`allow_admin_mails` bit(1) DEFAULT b'0',
`members_bitoptions2` int(10) unsigned NOT NULL DEFAULT '0',
`create_menu` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Cached contents of the "Create" drop down menu.',
`members_disable_pm` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 - not disabled, 1 - disabled, member can re-enable, 2 - disabled',
`marked_site_read` int(10) unsigned DEFAULT '0',
`pp_cover_offset` int(10) NOT NULL DEFAULT '0',
`acp_skin` smallint(6) DEFAULT NULL,
`acp_language` mediumint(9) DEFAULT NULL,
`member_title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`member_posts` mediumint(7) NOT NULL DEFAULT '0',
`member_last_post` int(10) DEFAULT NULL,
`steamid` varchar(17) COLLATE utf8_unicode_ci DEFAULT NULL,
`vk_id` bigint(20) DEFAULT NULL,
`vk_token` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`member_streams` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`photo_last_update` int(10) DEFAULT NULL,
`vnc_preferences` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Stores VNC option preferences',
`failed_mfa_attempts` smallint(3) unsigned DEFAULT '0' COMMENT 'Number of times tried and failed MFA',
`mfa_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`permission_array` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'A cache of the clubs and social groups that the member is in',
`globalMessage_dismissed` bit(1) DEFAULT b'0' COMMENT 'If 1, the user has dismissed the global message',
`members_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`members_country_show` tinyint(1) NOT NULL DEFAULT '1',
`completed` bit(1) NOT NULL DEFAULT b'0' COMMENT 'Whether the account is completed or not',
0,'gvgkorben',NULL,'[]',0,167,'$2y$10$2/sbl5rZofBlG6jkfCh1PO0WXEeKrEv/wkc9AKnTTD2yVXASG2Haq',NULL,65537,'0,0',0,'{\"6416\":1523734526,\"3142\":1523738810}','c1c462',NULL,NULL,NULL,NULL,NULL,NULL,2,'none','',NULL,NULL,'Europe/Moscow','','[]',1530090249,'',16,'{\"menu_key\":1458455616,\"menu\"
