From fd1dcefa540a72bcb330d20f08005ff2ddb8298a Mon Sep 17 00:00:00 2001 From: Joel Uckelman Date: Mon, 26 Sep 2011 09:07:05 -0700 Subject: Added SQL schema for tests of phpbb3 users table. --- test/phpbb3_users.sql | 85 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 85 insertions(+) create mode 100644 test/phpbb3_users.sql diff --git a/test/phpbb3_users.sql b/test/phpbb3_users.sql new file mode 100644 index 0000000..4f6ba9e --- /dev/null +++ b/test/phpbb3_users.sql @@ -0,0 +1,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; -- cgit v1.2.1