Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement