· 9 years ago · Dec 02, 2016, 07:24 PM
1CREATE TABLE IF NOT EXISTS `members` (
2`member_id` mediumint(8) NOT NULL,
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 `conv_password` varchar(128) DEFAULT NULL,
75 `ipsconnect_id` int(10) NOT NULL DEFAULT '0',
76 `ipsconnect_revalidate_url` text
77) ENGINE=MyISAM AUTO_INCREMENT=20934 DEFAULT CHARSET=latin1;