CREATE TABLE `bra_members` (
  `member_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL DEFAULT '',
  `member_group_id` SMALLINT(3) NOT NULL DEFAULT '0',
  `email` VARCHAR(150) NOT NULL DEFAULT '',
  `joined` INT(10) NOT NULL DEFAULT '0',
  `ip_address` VARCHAR(46) NOT NULL,
  `posts` mediumint(7) DEFAULT '0',
  `title` VARCHAR(64) DEFAULT NULL,
  `allow_admin_mails` tinyint(1) DEFAULT NULL,
  `time_offset` VARCHAR(10) DEFAULT NULL,
  `skin` SMALLINT(5) DEFAULT NULL,
  `warn_level` INT(10) DEFAULT NULL,
  `warn_lastwarn` INT(10) NOT NULL DEFAULT '0',
  `language` mediumint(4) DEFAULT NULL,
  `last_post` INT(10) DEFAULT NULL,
  `restrict_post` VARCHAR(100) NOT NULL DEFAULT '0',
  `view_sigs` tinyint(1) DEFAULT '1',
  `view_img` tinyint(1) DEFAULT '1',
  `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) DEFAULT NULL,
  `last_visit` INT(10) DEFAULT '0',
  `last_activity` INT(10) DEFAULT '0',
  `dst_in_use` tinyint(1) DEFAULT '0',
  `coppa_user` tinyint(1) DEFAULT '0',
  `mod_posts` VARCHAR(100) NOT NULL DEFAULT '0',
  `auto_track` VARCHAR(50) DEFAULT '0',
  `temp_ban` VARCHAR(100) DEFAULT '0',
  `login_anonymous` CHAR(3) NOT NULL DEFAULT '0&0',
  `ignored_users` mediumtext,
  `mgroup_others` VARCHAR(255) NOT NULL DEFAULT '',
  `org_perm_id` VARCHAR(255) NOT NULL DEFAULT '',
  `member_login_key` VARCHAR(32) NOT NULL DEFAULT '',
  `member_login_key_expire` INT(10) NOT NULL DEFAULT '0',
  `has_blog` mediumtext,
  `has_gallery` tinyint(1) NOT NULL DEFAULT '0',
  `members_auto_dst` tinyint(1) NOT NULL DEFAULT '1',
  `members_display_name` VARCHAR(255) NOT NULL DEFAULT '',
  `members_seo_name` VARCHAR(255) NOT NULL DEFAULT '',
  `members_created_remote` tinyint(1) NOT NULL DEFAULT '0',
  `members_cache` longtext,
  `members_disable_pm` INT(1) NOT NULL DEFAULT '0',
  `members_l_display_name` VARCHAR(255) NOT NULL DEFAULT '',
  `members_l_username` VARCHAR(255) NOT NULL DEFAULT '',
  `failed_logins` mediumtext,
  `failed_login_count` SMALLINT(3) NOT NULL DEFAULT '0',
  `members_profile_views` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `members_pass_hash` VARCHAR(32) NOT NULL DEFAULT '',
  `members_pass_salt` VARCHAR(5) NOT NULL DEFAULT '',
  `member_banned` tinyint(1) NOT NULL DEFAULT '0',
  `member_uploader` VARCHAR(32) NOT NULL DEFAULT 'default',
  `members_bitoptions` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `fb_uid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `fb_emailhash` VARCHAR(60) NOT NULL DEFAULT '',
  `fb_lastsync` INT(10) NOT NULL DEFAULT '0',
  `members_day_posts` VARCHAR(32) NOT NULL DEFAULT '0,0',
  `live_id` VARCHAR(32) DEFAULT NULL,
  `twitter_id` VARCHAR(255) NOT NULL DEFAULT '',
  `twitter_token` VARCHAR(255) NOT NULL DEFAULT '',
  `twitter_secret` VARCHAR(255) NOT NULL DEFAULT '',
  `notification_cnt` mediumint(9) NOT NULL DEFAULT '0',
  `tc_lastsync` INT(10) NOT NULL DEFAULT '0',
  `fb_session` VARCHAR(200) NOT NULL DEFAULT '',
  `fb_token` mediumtext,
  `ips_mobile_token` VARCHAR(64) DEFAULT NULL,
  `unacknowledged_warnings` tinyint(1) DEFAULT NULL,
  `blogs_recache` tinyint(1) DEFAULT NULL,
  `ipsconnect_revalidate_url` mediumtext,
  `ipsconnect_id` INT(10) NOT NULL DEFAULT '0',
  `cm_credits` FLOAT NOT NULL DEFAULT '0',
  `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) DEFAULT '',
  `cim_payment_id` INT(10) DEFAULT '0',
  `cim_method` INT(5) NOT NULL DEFAULT '0',
  `cm_return_group` SMALLINT(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`member_id`),
  KEY `members_l_display_name` (`members_l_display_name`),
  KEY `members_l_username` (`members_l_username`),
  KEY `bday_day` (`bday_day`),
  KEY `bday_month` (`bday_month`),
  KEY `member_banned` (`member_banned`),
  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`),
  KEY `email` (`email`),
  KEY `mgroup` (`member_group_id`,`member_id`),
  KEY `blogs_recache` (`blogs_recache`),
  KEY `member_groups` (`member_group_id`,`mgroup_others`)
) ENGINE=MyISAM AUTO_INCREMENT=28329 DEFAULT CHARSET=utf8