Added SQL schema for tests of phpbb3 users table.

1 files changed, 85 insertions, 0 deletions

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;