1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
|
DROP TABLE phpbb_users;
CREATE TABLE `phpbb_users` (
`user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`user_type` tinyint(2) NOT NULL DEFAULT '0',
`group_id` mediumint(8) unsigned NOT NULL DEFAULT '3',
`user_permissions` mediumtext COLLATE utf8_bin NOT NULL,
`user_perm_from` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_regdate` int(11) unsigned NOT NULL DEFAULT '0',
`username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`username_clean` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_password` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_passchg` int(11) unsigned NOT NULL DEFAULT '0',
`user_pass_convert` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_email` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_email_hash` bigint(20) NOT NULL DEFAULT '0',
`user_birthday` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_lastvisit` int(11) unsigned NOT NULL DEFAULT '0',
`user_lastmark` int(11) unsigned NOT NULL DEFAULT '0',
`user_lastpost_time` int(11) unsigned NOT NULL DEFAULT '0',
`user_lastpage` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_last_confirm_key` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_last_search` int(11) unsigned NOT NULL DEFAULT '0',
`user_warnings` tinyint(4) NOT NULL DEFAULT '0',
`user_last_warning` int(11) unsigned NOT NULL DEFAULT '0',
`user_login_attempts` tinyint(4) NOT NULL DEFAULT '0',
`user_inactive_reason` tinyint(2) NOT NULL DEFAULT '0',
`user_inactive_time` int(11) unsigned NOT NULL DEFAULT '0',
`user_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_lang` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_timezone` decimal(5,2) NOT NULL DEFAULT '0.00',
`user_dst` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_dateformat` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'd M Y H:i',
`user_style` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_rank` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_new_privmsg` int(4) NOT NULL DEFAULT '0',
`user_unread_privmsg` int(4) NOT NULL DEFAULT '0',
`user_last_privmsg` int(11) unsigned NOT NULL DEFAULT '0',
`user_message_rules` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_full_folder` int(11) NOT NULL DEFAULT '-3',
`user_emailtime` int(11) unsigned NOT NULL DEFAULT '0',
`user_topic_show_days` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_topic_sortby_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
`user_topic_sortby_dir` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'd',
`user_post_show_days` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_post_sortby_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
`user_post_sortby_dir` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'a',
`user_notify` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_notify_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_notify_type` tinyint(4) NOT NULL DEFAULT '0',
`user_allow_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_allow_viewonline` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_allow_viewemail` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_allow_massemail` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_options` int(11) unsigned NOT NULL DEFAULT '230271',
`user_avatar` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_avatar_type` tinyint(2) NOT NULL DEFAULT '0',
`user_avatar_width` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_avatar_height` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_sig` mediumtext COLLATE utf8_bin NOT NULL,
`user_sig_bbcode_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_sig_bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_from` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_icq` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_aim` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_yim` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_msnm` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_jabber` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_website` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_occ` text COLLATE utf8_bin NOT NULL,
`user_interests` text COLLATE utf8_bin NOT NULL,
`user_actkey` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_newpasswd` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_form_salt` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_new` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_reminded` tinyint(4) NOT NULL DEFAULT '0',
`user_reminded_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `username_clean` (`username_clean`),
KEY `user_birthday` (`user_birthday`),
KEY `user_email_hash` (`user_email_hash`),
KEY `user_type` (`user_type`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
