CREATE TABLE `bra_core_members` (
  `member_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `member_group_id` SMALLINT(3) NOT NULL DEFAULT '0',
  `email` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `joined` INT(10) NOT NULL DEFAULT '0',
  `ip_address` VARCHAR(46) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `allow_admin_mails` bit(1) DEFAULT b'0',
  `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',
  `misc` VARCHAR(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_visit` INT(10) DEFAULT '0',
  `last_activity` INT(10) DEFAULT '0',
  `mod_posts` INT(10) NOT NULL DEFAULT '0',
  `auto_track` VARCHAR(256) COLLATE utf8_unicode_ci DEFAULT '0',
  `temp_ban` INT(10) DEFAULT '0',
  `mgroup_others` VARCHAR(245) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `member_login_key` VARCHAR(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `member_login_key_expire` INT(10) NOT NULL DEFAULT '0',
  `has_blog` mediumtext COLLATE utf8_unicode_ci,
  `has_gallery` tinyint(1) NOT NULL DEFAULT '0',
  `members_seo_name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `members_cache` mediumtext COLLATE utf8_unicode_ci,
  `members_disable_pm` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 - not disabled, 1 - disabled, member can re-enable, 2 - disabled',
  `failed_logins` text COLLATE utf8_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(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `members_pass_salt` VARCHAR(22) COLLATE utf8_unicode_ci DEFAULT NULL,
  `members_bitoptions` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `fb_uid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `members_day_posts` VARCHAR(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0,0',
  `live_id` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `twitter_id` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `twitter_token` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `twitter_secret` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `notification_cnt` mediumint(9) NOT NULL DEFAULT '0',
  `fb_token` text COLLATE utf8_unicode_ci,
  `blogs_recache` tinyint(1) DEFAULT NULL,
  `ipsconnect_revalidate_url` text COLLATE utf8_unicode_ci,
  `ipsconnect_id` INT(10) NOT NULL DEFAULT '0',
  `cm_credits` text COLLATE utf8_unicode_ci,
  `cm_reg` INT(11) NOT NULL DEFAULT '0',
  `referred_by` INT(11) NOT NULL DEFAULT '0',
  `cm_no_sev` tinyint(1) DEFAULT '0',
  `cim_profile_id` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT '',
  `cim_payment_id` INT(10) DEFAULT '0',
  `cim_method` INT(5) NOT NULL DEFAULT '0',
  `cm_return_group` SMALLINT(3) DEFAULT '0',
  `google_id` VARCHAR(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `linkedin_id` VARCHAR(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pp_last_visitors` text COLLATE utf8_unicode_ci,
  `pp_main_photo` text COLLATE utf8_unicode_ci,
  `pp_main_width` INT(5) DEFAULT NULL,
  `pp_main_height` INT(5) DEFAULT NULL,
  `pp_thumb_photo` text COLLATE utf8_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_gravatar` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pp_photo_type` VARCHAR(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `signature` text COLLATE utf8_unicode_ci,
  `pconversation_filters` text COLLATE utf8_unicode_ci,
  `fb_photo` text COLLATE utf8_unicode_ci,
  `fb_photo_thumb` text COLLATE utf8_unicode_ci,
  `fb_bwoptions` INT(10) DEFAULT NULL,
  `tc_last_sid_import` VARCHAR(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tc_photo` text COLLATE utf8_unicode_ci,
  `tc_bwoptions` INT(10) DEFAULT NULL,
  `pp_customization` mediumtext COLLATE utf8_unicode_ci,
  `timezone` VARCHAR(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pp_cover_photo` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `profilesync` text COLLATE utf8_unicode_ci,
  `profilesync_lastsync` INT(10) NOT NULL DEFAULT '0' COMMENT 'Indicates the last time any profile sync service was ran',
  `google_token` text COLLATE utf8_unicode_ci,
  `linkedin_token` text COLLATE utf8_unicode_ci,
  `live_token` text COLLATE utf8_unicode_ci,
  `members_bitoptions2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `create_menu` text COLLATE utf8_unicode_ci COMMENT 'Cached contents of the "Create" drop down menu.',
  `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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `member_posts` mediumint(7) NOT NULL DEFAULT '0',
  `member_last_post` INT(10) DEFAULT NULL,
  `member_streams` text COLLATE utf8_unicode_ci,
  `photo_last_update` INT(10) DEFAULT NULL,
  `mfa_details` text COLLATE utf8_unicode_ci,
  `failed_mfa_attempts` SMALLINT(3) UNSIGNED DEFAULT '0' COMMENT 'Number of times tried and failed MFA',
  `pp_setting_count_visitors` tinyint(1) NOT NULL DEFAULT '0',
  `idm_block_submissions` tinyint(1) UNSIGNED DEFAULT '0' COMMENT 'Blocked from submitting Downloads files?',
  `failed_security_answers` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `tb_but_cache` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Holds the member cache for the (TB) Bump Up Topics plugin to work properly',
  PRIMARY KEY (`member_id`),
  KEY `bday_day` (`bday_day`),
  KEY `bday_month` (`bday_month`),
  KEY `members_bitoptions` (`members_bitoptions`),
  KEY `ip_address` (`ip_address`),
  KEY `failed_login_count` (`failed_login_count`),
  KEY `joined` (`joined`),
  KEY `fb_uid` (`fb_uid`),
  KEY `twitter_id` (`twitter_id`(191)),
  KEY `email` (`email`),
  KEY `member_groups` (`member_group_id`,`mgroup_others`(188)),
  KEY `google_id` (`google_id`),
  KEY `linkedin_id` (`linkedin_id`),
  KEY `mgroup` (`member_id`,`member_group_id`),
  KEY `allow_admin_mails` (`allow_admin_mails`),
  KEY `name_index` (`name`(191)),
  KEY `ipsconnect_id` (`ipsconnect_id`),
  KEY `mod_posts` (`mod_posts`),
  KEY `photo_last_update` (`photo_last_update`)
) ENGINE=MyISAM AUTO_INCREMENT=28898 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci