· 6 years ago · Jul 06, 2019, 01:24 AM
1CREATE TABLE IF NOT EXISTS `ipb_members` (
2 `member_id` mediumint(8) NOT NULL AUTO_INCREMENT,
3 `name` varchar(255) NOT NULL DEFAULT '',
4 `member_group_id` smallint(3) NOT NULL DEFAULT '0',
5 `email` varchar(150) NOT NULL DEFAULT '',
6 `joined` int(10) NOT NULL DEFAULT '0',
7 `ip_address` varchar(46) NOT NULL DEFAULT '',
8 `posts` mediumint(7) DEFAULT '0',
9 `title` varchar(64) DEFAULT NULL,
10 `allow_admin_mails` tinyint(1) DEFAULT NULL,
11 `time_offset` varchar(10) DEFAULT NULL,
12 `skin` smallint(5) DEFAULT NULL,
13 `warn_level` int(10) DEFAULT NULL,
14 `warn_lastwarn` int(10) NOT NULL DEFAULT '0',
15 `language` mediumint(4) DEFAULT NULL,
16 `last_post` int(10) DEFAULT NULL,
17 `restrict_post` varchar(100) NOT NULL DEFAULT '0',
18 `view_sigs` tinyint(1) DEFAULT '1',
19 `view_img` tinyint(1) DEFAULT '1',
20 `bday_day` int(2) DEFAULT NULL,
21 `bday_month` int(2) DEFAULT NULL,
22 `bday_year` int(4) DEFAULT NULL,
23 `msg_count_new` int(2) NOT NULL DEFAULT '0',
24 `msg_count_total` int(3) NOT NULL DEFAULT '0',
25 `msg_count_reset` int(1) NOT NULL DEFAULT '0',
26 `msg_show_notification` int(1) NOT NULL DEFAULT '0',
27 `misc` varchar(128) DEFAULT NULL,
28 `last_visit` int(10) DEFAULT '0',
29 `last_activity` int(10) DEFAULT '0',
30 `dst_in_use` tinyint(1) DEFAULT '0',
31 `coppa_user` tinyint(1) DEFAULT '0',
32 `mod_posts` varchar(100) NOT NULL DEFAULT '0',
33 `auto_track` varchar(50) DEFAULT '0',
34 `temp_ban` varchar(100) DEFAULT '0',
35 `login_anonymous` char(3) NOT NULL DEFAULT '0&0',
36 `ignored_users` text,
37 `mgroup_others` varchar(255) NOT NULL DEFAULT '',
38 `org_perm_id` varchar(255) NOT NULL DEFAULT '',
39 `member_login_key` varchar(32) NOT NULL DEFAULT '',
40 `member_login_key_expire` int(10) NOT NULL DEFAULT '0',
41 `has_blog` text,
42 `blogs_recache` tinyint(1) DEFAULT NULL,
43 `has_gallery` tinyint(1) NOT NULL DEFAULT '0',
44 `members_auto_dst` tinyint(1) NOT NULL DEFAULT '1',
45 `members_display_name` varchar(255) NOT NULL DEFAULT '',
46 `members_seo_name` varchar(255) NOT NULL DEFAULT '',
47 `members_created_remote` tinyint(1) NOT NULL DEFAULT '0',
48 `members_cache` mediumtext,
49 `members_disable_pm` int(1) NOT NULL DEFAULT '0',
50 `members_l_display_name` varchar(255) NOT NULL DEFAULT '',
51 `members_l_username` varchar(255) NOT NULL DEFAULT '',
52 `failed_logins` text,
53 `failed_login_count` smallint(3) NOT NULL DEFAULT '0',
54 `members_profile_views` int(10) unsigned NOT NULL DEFAULT '0',
55 `members_pass_hash` varchar(32) NOT NULL DEFAULT '',
56 `members_pass_salt` varchar(5) NOT NULL DEFAULT '',
57 `member_banned` tinyint(1) NOT NULL DEFAULT '0',
58 `member_uploader` varchar(32) NOT NULL DEFAULT 'default',
59 `members_bitoptions` int(10) unsigned NOT NULL DEFAULT '0',
60 `fb_uid` bigint(20) unsigned NOT NULL DEFAULT '0',
61 `fb_emailhash` varchar(60) NOT NULL DEFAULT '',
62 `fb_lastsync` int(10) NOT NULL DEFAULT '0',
63 `members_day_posts` varchar(32) NOT NULL DEFAULT '0,0',
64 `live_id` varchar(32) DEFAULT NULL,
65 `twitter_id` varchar(255) NOT NULL DEFAULT '',
66 `twitter_token` varchar(255) NOT NULL DEFAULT '',
67 `twitter_secret` varchar(255) NOT NULL DEFAULT '',
68 `notification_cnt` mediumint(9) NOT NULL DEFAULT '0',
69 `tc_lastsync` int(10) NOT NULL DEFAULT '0',
70 `fb_session` varchar(200) NOT NULL DEFAULT '',
71 `fb_token` text,
72 `ips_mobile_token` varchar(64) DEFAULT NULL,
73 `unacknowledged_warnings` tinyint(1) DEFAULT NULL,
74 `ipsconnect_id` int(10) NOT NULL DEFAULT '0',
75 `ipsconnect_revalidate_url` text,
76 `member_premium_time` int(11) NOT NULL DEFAULT '0',
77 `member_game_points` int(11) NOT NULL DEFAULT '0',
78 `member_game_admin_perm` smallint(6) NOT NULL DEFAULT '0',
79 `member_game_ban` int(11) NOT NULL DEFAULT '0',
80 `game_door_objects` int(11) NOT NULL DEFAULT '0',
81 `game_char_block_three` int(11) NOT NULL DEFAULT '0',
82 `game_char_name_change` int(11) NOT NULL DEFAULT '0',
83 `game_unique_vehicle` int(11) NOT NULL DEFAULT '0',
84 `game_area_objects` int(11) NOT NULL DEFAULT '0',
85 `game_area` int(11) NOT NULL DEFAULT '0',
86 `member_block_run` int(11) NOT NULL DEFAULT '0',
87 `member_block_dmg` int(11) NOT NULL DEFAULT '0',
88 `member_block_veh` int(11) NOT NULL DEFAULT '0',
89 `member_block_ooc` int(11) NOT NULL DEFAULT '0',
90 `css` text NOT NULL,
91 PRIMARY KEY (`member_id`),
92 KEY `members_l_display_name` (`members_l_display_name`),
93 KEY `members_l_username` (`members_l_username`),
94 KEY `mgroup` (`member_group_id`,`member_id`),
95 KEY `member_groups` (`member_group_id`,`mgroup_others`),
96 KEY `bday_day` (`bday_day`),
97 KEY `bday_month` (`bday_month`),
98 KEY `member_banned` (`member_banned`),
99 KEY `members_bitoptions` (`members_bitoptions`),
100 KEY `ip_address` (`ip_address`),
101 KEY `failed_login_count` (`failed_login_count`),
102 KEY `joined` (`joined`),
103 KEY `fb_uid` (`fb_uid`),
104 KEY `twitter_id` (`twitter_id`),
105 KEY `email` (`email`),
106 KEY `blogs_recache` (`blogs_recache`)
107) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3261 ;