#7882

git-svn-id: file:///svn/phpbb/trunk@7073 89ea8834-ac86-4346-8a33-228a782c2dd0
author: David M <davidmj@users.sourceforge.net> 2007-02-25 21:03:14 +0000
committer: David M <davidmj@users.sourceforge.net> 2007-02-25 21:03:14 +0000
commit: 409904c8788949a765a591673003f511f6bf8ed0 (patch)
tree: ba5fdf2a75737f874683b7ea5ac8242ef2d140af
parent: 8494211a129f0dabe5747c6915871e40fdced8b2 (diff)
download: forums-409904c8788949a765a591673003f511f6bf8ed0.tar
forums-409904c8788949a765a591673003f511f6bf8ed0.tar.gz
forums-409904c8788949a765a591673003f511f6bf8ed0.tar.bz2
forums-409904c8788949a765a591673003f511f6bf8ed0.tar.xz
forums-409904c8788949a765a591673003f511f6bf8ed0.zip
8 files changed, 306 insertions, 307 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php
index f1a9dd1830..eede9a2bd1 100644
--- a/phpBB/develop/create_schema_files.php
+++ b/phpBB/develop/create_schema_files.php
@@ -60,22 +60,22 @@ $dbms_type_map = array(
 		'TINT:'		=> 'tinyint(%d)',
 		'USINT'		=> 'smallint(4) UNSIGNED',
 		'BOOL'		=> 'tinyint(1) UNSIGNED',
-		'VCHAR'		=> 'varchar(255)',
-		'VCHAR:'	=> 'varchar(%d)',
-		'CHAR:'		=> 'char(%d)',
-		'XSTEXT'	=> 'text',
-		'XSTEXT_UNI'=> 'text',
-		'STEXT'		=> 'text',
-		'STEXT_UNI'	=> 'text',
-		'TEXT'		=> 'text',
-		'TEXT_UNI'	=> 'text',
-		'MTEXT'		=> 'mediumtext',
-		'MTEXT_UNI'	=> 'mediumtext',
+		'VCHAR'		=> 'varbinary(255)',
+		'VCHAR:'	=> 'varbinary(%d)',
+		'CHAR:'		=> 'binary(%d)',
+		'XSTEXT'	=> 'blob',
+		'XSTEXT_UNI'=> 'blob',
+		'STEXT'		=> 'blob',
+		'STEXT_UNI'	=> 'blob',
+		'TEXT'		=> 'blob',
+		'TEXT_UNI'	=> 'blob',
+		'MTEXT'		=> 'mediumblob',
+		'MTEXT_UNI'	=> 'mediumblob',
 		'TIMESTAMP'	=> 'int(11) UNSIGNED',
 		'DECIMAL'	=> 'decimal(5,2)',
-		'VCHAR_UNI'	=> 'text',
-		'VCHAR_UNI:'=> array('varchar(%d)', 'limit' => array('mult', 3, 255, 'text')),
-		'VCHAR_CI'	=> 'text',
+		'VCHAR_UNI'	=> 'blob',
+		'VCHAR_UNI:'=> array('varbinary(%d)', 'limit' => array('mult', 3, 255, 'blob')),
+		'VCHAR_CI'	=> 'blob',
 		'VARBINARY'	=> 'varbinary(255)',
 	),
 
@@ -1903,7 +1903,7 @@ function get_schema_struct()
 			'user_birthday'				=> array('INDEX', 'user_birthday'),
 			'user_email_hash'			=> array('INDEX', 'user_email_hash'),
 			'user_type'					=> array('INDEX', 'user_type'),
-			'username_clean'			=> array('INDEX', 'username_clean'),
+			'username_clean'			=> array('UNIQUE', 'username_clean'),
 		),
 	);
 
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 9ab8594c01..6fb0318cf2 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -1437,7 +1437,7 @@ ALTER TABLE phpbb_users ADD PRIMARY KEY (user_id);;
 CREATE INDEX phpbb_users_user_birthday ON phpbb_users(user_birthday);;
 CREATE INDEX phpbb_users_user_email_hash ON phpbb_users(user_email_hash);;
 CREATE INDEX phpbb_users_user_type ON phpbb_users(user_type);;
-CREATE INDEX phpbb_users_username_clean ON phpbb_users(username_clean);;
+CREATE UNIQUE INDEX phpbb_users_username_clean ON phpbb_users(username_clean);;
 
 CREATE GENERATOR phpbb_users_gen;;
 SET GENERATOR phpbb_users_gen TO 0;;
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 9d4eb55505..e6da562358 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -1691,7 +1691,7 @@ GO
 CREATE  INDEX [user_type] ON [phpbb_users]([user_type]) ON [PRIMARY]
 GO
 
-CREATE  INDEX [username_clean] ON [phpbb_users]([username_clean]) ON [PRIMARY]
+CREATE  UNIQUE  INDEX [username_clean] ON [phpbb_users]([username_clean]) ON [PRIMARY]
 GO
 
 
diff --git a/phpBB/install/schemas/mysql_40_schema.sql b/phpBB/install/schemas/mysql_40_schema.sql
index 2b3022a875..37eaa095ce 100644
--- a/phpBB/install/schemas/mysql_40_schema.sql
+++ b/phpBB/install/schemas/mysql_40_schema.sql
@@ -12,12 +12,12 @@ CREATE TABLE phpbb_attachments (
 	in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
-	physical_filename varchar(255) DEFAULT '' NOT NULL,
-	real_filename varchar(255) DEFAULT '' NOT NULL,
+	physical_filename varbinary(255) DEFAULT '' NOT NULL,
+	real_filename varbinary(255) DEFAULT '' NOT NULL,
 	download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	attach_comment text NOT NULL,
-	extension varchar(100) DEFAULT '' NOT NULL,
-	mimetype varchar(100) DEFAULT '' NOT NULL,
+	attach_comment blob DEFAULT '' NOT NULL,
+	extension varbinary(100) DEFAULT '' NOT NULL,
+	mimetype varbinary(100) DEFAULT '' NOT NULL,
 	filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
 	filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
@@ -45,7 +45,7 @@ CREATE TABLE phpbb_acl_groups (
 # Table: 'phpbb_acl_options'
 CREATE TABLE phpbb_acl_options (
 	auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	auth_option varchar(50) DEFAULT '' NOT NULL,
+	auth_option varbinary(50) DEFAULT '' NOT NULL,
 	is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
@@ -57,9 +57,9 @@ CREATE TABLE phpbb_acl_options (
 # Table: 'phpbb_acl_roles'
 CREATE TABLE phpbb_acl_roles (
 	role_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	role_name text NOT NULL,
-	role_description text NOT NULL,
-	role_type varchar(10) DEFAULT '' NOT NULL,
+	role_name blob DEFAULT '' NOT NULL,
+	role_description blob DEFAULT '' NOT NULL,
+	role_type varbinary(10) DEFAULT '' NOT NULL,
 	role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (role_id),
 	KEY role_type (role_type),
@@ -92,17 +92,17 @@ CREATE TABLE phpbb_acl_users (
 CREATE TABLE phpbb_banlist (
 	ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 	ban_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	ban_ip varchar(40) DEFAULT '' NOT NULL,
-	ban_email text NOT NULL,
+	ban_ip varbinary(40) DEFAULT '' NOT NULL,
+	ban_email blob DEFAULT '' NOT NULL,
 	ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	ban_reason text NOT NULL,
-	ban_give_reason text NOT NULL,
+	ban_reason blob DEFAULT '' NOT NULL,
+	ban_give_reason blob DEFAULT '' NOT NULL,
 	PRIMARY KEY (ban_id),
 	KEY ban_end (ban_end),
 	KEY ban_user (ban_userid, ban_exclude),
-	KEY ban_email (ban_email(255), ban_exclude),
+	KEY ban_email (ban_email, ban_exclude),
 	KEY ban_ip (ban_ip, ban_exclude)
 );
 
@@ -110,15 +110,15 @@ CREATE TABLE phpbb_banlist (
 # Table: 'phpbb_bbcodes'
 CREATE TABLE phpbb_bbcodes (
 	bbcode_id tinyint(3) DEFAULT '0' NOT NULL,
-	bbcode_tag varchar(16) DEFAULT '' NOT NULL,
-	bbcode_helpline text NOT NULL,
+	bbcode_tag varbinary(16) DEFAULT '' NOT NULL,
+	bbcode_helpline blob DEFAULT '' NOT NULL,
 	display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	bbcode_match text NOT NULL,
-	bbcode_tpl mediumtext NOT NULL,
-	first_pass_match mediumtext NOT NULL,
-	first_pass_replace mediumtext NOT NULL,
-	second_pass_match mediumtext NOT NULL,
-	second_pass_replace mediumtext NOT NULL,
+	bbcode_match blob DEFAULT '' NOT NULL,
+	bbcode_tpl mediumblob DEFAULT '' NOT NULL,
+	first_pass_match mediumblob DEFAULT '' NOT NULL,
+	first_pass_replace mediumblob DEFAULT '' NOT NULL,
+	second_pass_match mediumblob DEFAULT '' NOT NULL,
+	second_pass_replace mediumblob DEFAULT '' NOT NULL,
 	PRIMARY KEY (bbcode_id),
 	KEY display_on_post (display_on_posting)
 );
@@ -138,10 +138,10 @@ CREATE TABLE phpbb_bookmarks (
 CREATE TABLE phpbb_bots (
 	bot_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 	bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
-	bot_name text NOT NULL,
+	bot_name blob DEFAULT '' NOT NULL,
 	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	bot_agent varchar(255) DEFAULT '' NOT NULL,
-	bot_ip varchar(255) DEFAULT '' NOT NULL,
+	bot_agent varbinary(255) DEFAULT '' NOT NULL,
+	bot_ip varbinary(255) DEFAULT '' NOT NULL,
 	PRIMARY KEY (bot_id),
 	KEY bot_active (bot_active)
 );
@@ -149,8 +149,8 @@ CREATE TABLE phpbb_bots (
 
 # Table: 'phpbb_config'
 CREATE TABLE phpbb_config (
-	config_name varchar(255) DEFAULT '' NOT NULL,
-	config_value text NOT NULL,
+	config_name varbinary(255) DEFAULT '' NOT NULL,
+	config_value blob DEFAULT '' NOT NULL,
 	is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (config_name),
 	KEY is_dynamic (is_dynamic)
@@ -159,10 +159,10 @@ CREATE TABLE phpbb_config (
 
 # Table: 'phpbb_confirm'
 CREATE TABLE phpbb_confirm (
-	confirm_id char(32) DEFAULT '' NOT NULL,
-	session_id char(32) DEFAULT '' NOT NULL,
+	confirm_id binary(32) DEFAULT '' NOT NULL,
+	session_id binary(32) DEFAULT '' NOT NULL,
 	confirm_type tinyint(3) DEFAULT '0' NOT NULL,
-	code varchar(8) DEFAULT '' NOT NULL,
+	code varbinary(8) DEFAULT '' NOT NULL,
 	seed int(10) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (session_id, confirm_id),
 	KEY confirm_type (confirm_type)
@@ -172,7 +172,7 @@ CREATE TABLE phpbb_confirm (
 # Table: 'phpbb_disallow'
 CREATE TABLE phpbb_disallow (
 	disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	disallow_username text NOT NULL,
+	disallow_username blob DEFAULT '' NOT NULL,
 	PRIMARY KEY (disallow_id)
 );
 
@@ -184,8 +184,8 @@ CREATE TABLE phpbb_drafts (
 	topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	save_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	draft_subject text NOT NULL,
-	draft_message mediumtext NOT NULL,
+	draft_subject blob DEFAULT '' NOT NULL,
+	draft_message mediumblob DEFAULT '' NOT NULL,
 	PRIMARY KEY (draft_id),
 	KEY save_time (save_time)
 );
@@ -195,7 +195,7 @@ CREATE TABLE phpbb_drafts (
 CREATE TABLE phpbb_extensions (
 	extension_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 	group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	extension varchar(100) DEFAULT '' NOT NULL,
+	extension varbinary(100) DEFAULT '' NOT NULL,
 	PRIMARY KEY (extension_id)
 );
 
@@ -203,13 +203,13 @@ CREATE TABLE phpbb_extensions (
 # Table: 'phpbb_extension_groups'
 CREATE TABLE phpbb_extension_groups (
 	group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	group_name text NOT NULL,
+	group_name blob DEFAULT '' NOT NULL,
 	cat_id tinyint(2) DEFAULT '0' NOT NULL,
 	allow_group tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
-	upload_icon varchar(255) DEFAULT '' NOT NULL,
+	upload_icon varbinary(255) DEFAULT '' NOT NULL,
 	max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
-	allowed_forums text NOT NULL,
+	allowed_forums blob DEFAULT '' NOT NULL,
 	allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (group_id)
 );
@@ -221,21 +221,21 @@ CREATE TABLE phpbb_forums (
 	parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	forum_parents mediumtext NOT NULL,
-	forum_name text NOT NULL,
-	forum_desc text NOT NULL,
-	forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
+	forum_parents mediumblob DEFAULT '' NOT NULL,
+	forum_name blob DEFAULT '' NOT NULL,
+	forum_desc blob DEFAULT '' NOT NULL,
+	forum_desc_bitfield varbinary(255) DEFAULT '' NOT NULL,
 	forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
-	forum_desc_uid varchar(5) DEFAULT '' NOT NULL,
-	forum_link text NOT NULL,
-	forum_password varchar(120) DEFAULT '' NOT NULL,
+	forum_desc_uid varbinary(5) DEFAULT '' NOT NULL,
+	forum_link blob DEFAULT '' NOT NULL,
+	forum_password varbinary(120) DEFAULT '' NOT NULL,
 	forum_style tinyint(4) DEFAULT '0' NOT NULL,
-	forum_image varchar(255) DEFAULT '' NOT NULL,
-	forum_rules text NOT NULL,
-	forum_rules_link text NOT NULL,
-	forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL,
+	forum_image varbinary(255) DEFAULT '' NOT NULL,
+	forum_rules blob DEFAULT '' NOT NULL,
+	forum_rules_link blob DEFAULT '' NOT NULL,
+	forum_rules_bitfield varbinary(255) DEFAULT '' NOT NULL,
 	forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
-	forum_rules_uid varchar(5) DEFAULT '' NOT NULL,
+	forum_rules_uid varbinary(5) DEFAULT '' NOT NULL,
 	forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,
 	forum_type tinyint(4) DEFAULT '0' NOT NULL,
 	forum_status tinyint(4) DEFAULT '0' NOT NULL,
@@ -244,10 +244,10 @@ CREATE TABLE phpbb_forums (
 	forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	forum_last_post_subject text NOT NULL,
+	forum_last_post_subject blob DEFAULT '' NOT NULL,
 	forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	forum_last_poster_name text NOT NULL,
-	forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,
+	forum_last_poster_name blob DEFAULT '' NOT NULL,
+	forum_last_poster_colour varbinary(6) DEFAULT '' NOT NULL,
 	forum_flags tinyint(4) DEFAULT '32' NOT NULL,
 	display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
@@ -267,7 +267,7 @@ CREATE TABLE phpbb_forums (
 CREATE TABLE phpbb_forums_access (
 	forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	session_id char(32) DEFAULT '' NOT NULL,
+	session_id binary(32) DEFAULT '' NOT NULL,
 	PRIMARY KEY (forum_id, user_id, session_id)
 );
 
@@ -297,18 +297,18 @@ CREATE TABLE phpbb_groups (
 	group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 	group_type tinyint(4) DEFAULT '1' NOT NULL,
 	group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	group_name text NOT NULL,
-	group_desc text NOT NULL,
-	group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
+	group_name blob DEFAULT '' NOT NULL,
+	group_desc blob DEFAULT '' NOT NULL,
+	group_desc_bitfield varbinary(255) DEFAULT '' NOT NULL,
 	group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
-	group_desc_uid varchar(5) DEFAULT '' NOT NULL,
+	group_desc_uid varbinary(5) DEFAULT '' NOT NULL,
 	group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	group_avatar varchar(255) DEFAULT '' NOT NULL,
+	group_avatar varbinary(255) DEFAULT '' NOT NULL,
 	group_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
 	group_avatar_width tinyint(4) DEFAULT '0' NOT NULL,
 	group_avatar_height tinyint(4) DEFAULT '0' NOT NULL,
 	group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	group_colour varchar(6) DEFAULT '' NOT NULL,
+	group_colour varbinary(6) DEFAULT '' NOT NULL,
 	group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
@@ -321,7 +321,7 @@ CREATE TABLE phpbb_groups (
 # Table: 'phpbb_icons'
 CREATE TABLE phpbb_icons (
 	icons_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	icons_url varchar(255) DEFAULT '' NOT NULL,
+	icons_url varbinary(255) DEFAULT '' NOT NULL,
 	icons_width tinyint(4) DEFAULT '0' NOT NULL,
 	icons_height tinyint(4) DEFAULT '0' NOT NULL,
 	icons_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
@@ -334,11 +334,11 @@ CREATE TABLE phpbb_icons (
 # Table: 'phpbb_lang'
 CREATE TABLE phpbb_lang (
 	lang_id tinyint(4) NOT NULL auto_increment,
-	lang_iso varchar(30) DEFAULT '' NOT NULL,
-	lang_dir varchar(30) DEFAULT '' NOT NULL,
-	lang_english_name text NOT NULL,
-	lang_local_name text NOT NULL,
-	lang_author text NOT NULL,
+	lang_iso varbinary(30) DEFAULT '' NOT NULL,
+	lang_dir varbinary(30) DEFAULT '' NOT NULL,
+	lang_english_name blob DEFAULT '' NOT NULL,
+	lang_local_name blob DEFAULT '' NOT NULL,
+	lang_author blob DEFAULT '' NOT NULL,
 	PRIMARY KEY (lang_id),
 	KEY lang_iso (lang_iso)
 );
@@ -352,10 +352,10 @@ CREATE TABLE phpbb_log (
 	forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	log_ip varchar(40) DEFAULT '' NOT NULL,
+	log_ip varbinary(40) DEFAULT '' NOT NULL,
 	log_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	log_operation text NOT NULL,
-	log_data mediumtext NOT NULL,
+	log_operation blob DEFAULT '' NOT NULL,
+	log_data mediumblob DEFAULT '' NOT NULL,
 	PRIMARY KEY (log_id),
 	KEY log_type (log_type),
 	KEY forum_id (forum_id),
@@ -369,9 +369,9 @@ CREATE TABLE phpbb_log (
 CREATE TABLE phpbb_moderator_cache (
 	forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	username text NOT NULL,
+	username blob DEFAULT '' NOT NULL,
 	group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	group_name text NOT NULL,
+	group_name blob DEFAULT '' NOT NULL,
 	display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	KEY disp_idx (display_on_index),
 	KEY forum_id (forum_id)
@@ -383,14 +383,14 @@ CREATE TABLE phpbb_modules (
 	module_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 	module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	module_display tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
-	module_basename varchar(255) DEFAULT '' NOT NULL,
-	module_class varchar(10) DEFAULT '' NOT NULL,
+	module_basename varbinary(255) DEFAULT '' NOT NULL,
+	module_class varbinary(10) DEFAULT '' NOT NULL,
 	parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	module_langname varchar(255) DEFAULT '' NOT NULL,
-	module_mode varchar(255) DEFAULT '' NOT NULL,
-	module_auth varchar(255) DEFAULT '' NOT NULL,
+	module_langname varbinary(255) DEFAULT '' NOT NULL,
+	module_mode varbinary(255) DEFAULT '' NOT NULL,
+	module_auth varbinary(255) DEFAULT '' NOT NULL,
 	PRIMARY KEY (module_id),
 	KEY left_right_id (left_id, right_id),
 	KEY module_enabled (module_enabled),
@@ -402,7 +402,7 @@ CREATE TABLE phpbb_modules (
 CREATE TABLE phpbb_poll_options (
 	poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
 	topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	poll_option_text text NOT NULL,
+	poll_option_text blob DEFAULT '' NOT NULL,
 	poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	KEY poll_opt_id (poll_option_id),
 	KEY topic_id (topic_id)
@@ -414,7 +414,7 @@ CREATE TABLE phpbb_poll_votes (
 	topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
 	vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	vote_user_ip varchar(40) DEFAULT '' NOT NULL,
+	vote_user_ip varbinary(40) DEFAULT '' NOT NULL,
 	KEY topic_id (topic_id),
 	KEY vote_user_id (vote_user_id),
 	KEY vote_user_ip (vote_user_ip)
@@ -428,7 +428,7 @@ CREATE TABLE phpbb_posts (
 	forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	poster_ip varchar(40) DEFAULT '' NOT NULL,
+	poster_ip varbinary(40) DEFAULT '' NOT NULL,
 	post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
@@ -436,16 +436,16 @@ CREATE TABLE phpbb_posts (
 	enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
-	post_username text NOT NULL,
-	post_subject text NOT NULL,
-	post_text mediumtext NOT NULL,
-	post_checksum varchar(32) DEFAULT '' NOT NULL,
+	post_username blob DEFAULT '' NOT NULL,
+	post_subject blob DEFAULT '' NOT NULL,
+	post_text mediumblob DEFAULT '' NOT NULL,
+	post_checksum varbinary(32) DEFAULT '' NOT NULL,
 	post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
-	bbcode_uid varchar(5) DEFAULT '' NOT NULL,
+	bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
+	bbcode_uid varbinary(5) DEFAULT '' NOT NULL,
 	post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	post_edit_reason text NOT NULL,
+	post_edit_reason blob DEFAULT '' NOT NULL,
 	post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 	post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
@@ -465,23 +465,23 @@ CREATE TABLE phpbb_privmsgs (
 	root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	author_ip varchar(40) DEFAULT '' NOT NULL,
+	author_ip varbinary(40) DEFAULT '' NOT NULL,
 	message_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
-	message_subject text NOT NULL,
-	message_text mediumtext NOT NULL,
-	message_edit_reason text NOT NULL,
+	message_subject blob DEFAULT '' NOT NULL,
+	message_text mediumblob DEFAULT '' NOT NULL,
+	message_edit_reason blob DEFAULT '' NOT NULL,
 	message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
-	bbcode_uid varchar(5) DEFAULT '' NOT NULL,
+	bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
+	bbcode_uid varbinary(5) DEFAULT '' NOT NULL,
 	message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
-	to_address text NOT NULL,
-	bcc_address text NOT NULL,
+	to_address blob DEFAULT '' NOT NULL,
+	bcc_address blob DEFAULT '' NOT NULL,
 	PRIMARY KEY (msg_id),
 	KEY author_ip (author_ip),
 	KEY message_time (message_time),
@@ -494,7 +494,7 @@ CREATE TABLE phpbb_privmsgs (
 CREATE TABLE phpbb_privmsgs_folder (
 	folder_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	folder_name text NOT NULL,
+	folder_name blob DEFAULT '' NOT NULL,
 	pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (folder_id),
 	KEY user_id (user_id)
@@ -507,7 +507,7 @@ CREATE TABLE phpbb_privmsgs_rules (
 	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	rule_check mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	rule_connection mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	rule_string text NOT NULL,
+	rule_string blob DEFAULT '' NOT NULL,
 	rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
@@ -538,15 +538,15 @@ CREATE TABLE phpbb_privmsgs_to (
 # Table: 'phpbb_profile_fields'
 CREATE TABLE phpbb_profile_fields (
 	field_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	field_name text NOT NULL,
+	field_name blob DEFAULT '' NOT NULL,
 	field_type tinyint(4) DEFAULT '0' NOT NULL,
-	field_ident varchar(20) DEFAULT '' NOT NULL,
-	field_length varchar(20) DEFAULT '' NOT NULL,
-	field_minlen varchar(255) DEFAULT '' NOT NULL,
-	field_maxlen varchar(255) DEFAULT '' NOT NULL,
-	field_novalue text NOT NULL,
-	field_default_value text NOT NULL,
-	field_validation varchar(60) DEFAULT '' NOT NULL,
+	field_ident varbinary(20) DEFAULT '' NOT NULL,
+	field_length varbinary(20) DEFAULT '' NOT NULL,
+	field_minlen varbinary(255) DEFAULT '' NOT NULL,
+	field_maxlen varbinary(255) DEFAULT '' NOT NULL,
+	field_novalue blob DEFAULT '' NOT NULL,
+	field_default_value blob DEFAULT '' NOT NULL,
+	field_validation varbinary(60) DEFAULT '' NOT NULL,
 	field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
@@ -572,7 +572,7 @@ CREATE TABLE phpbb_profile_fields_lang (
 	lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	field_type tinyint(4) DEFAULT '0' NOT NULL,
-	lang_value text NOT NULL,
+	lang_value blob DEFAULT '' NOT NULL,
 	PRIMARY KEY (field_id, lang_id, option_id)
 );
 
@@ -581,9 +581,9 @@ CREATE TABLE phpbb_profile_fields_lang (
 CREATE TABLE phpbb_profile_lang (
 	field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	lang_name text NOT NULL,
-	lang_explain text NOT NULL,
-	lang_default_value text NOT NULL,
+	lang_name blob DEFAULT '' NOT NULL,
+	lang_explain blob DEFAULT '' NOT NULL,
+	lang_default_value blob DEFAULT '' NOT NULL,
 	PRIMARY KEY (field_id, lang_id)
 );
 
@@ -591,10 +591,10 @@ CREATE TABLE phpbb_profile_lang (
 # Table: 'phpbb_ranks'
 CREATE TABLE phpbb_ranks (
 	rank_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	rank_title text NOT NULL,
+	rank_title blob DEFAULT '' NOT NULL,
 	rank_min mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	rank_special tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	rank_image varchar(255) DEFAULT '' NOT NULL,
+	rank_image varbinary(255) DEFAULT '' NOT NULL,
 	PRIMARY KEY (rank_id)
 );
 
@@ -608,7 +608,7 @@ CREATE TABLE phpbb_reports (
 	user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	report_text mediumtext NOT NULL,
+	report_text mediumblob DEFAULT '' NOT NULL,
 	PRIMARY KEY (report_id)
 );
 
@@ -616,8 +616,8 @@ CREATE TABLE phpbb_reports (
 # Table: 'phpbb_reports_reasons'
 CREATE TABLE phpbb_reports_reasons (
 	reason_id smallint(4) UNSIGNED NOT NULL auto_increment,
-	reason_title text NOT NULL,
-	reason_description mediumtext NOT NULL,
+	reason_title blob DEFAULT '' NOT NULL,
+	reason_description mediumblob DEFAULT '' NOT NULL,
 	reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (reason_id)
 );
@@ -625,10 +625,10 @@ CREATE TABLE phpbb_reports_reasons (
 
 # Table: 'phpbb_search_results'
 CREATE TABLE phpbb_search_results (
-	search_key varchar(32) DEFAULT '' NOT NULL,
+	search_key varbinary(32) DEFAULT '' NOT NULL,
 	search_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	search_keywords mediumtext NOT NULL,
-	search_authors mediumtext NOT NULL,
+	search_keywords mediumblob DEFAULT '' NOT NULL,
+	search_authors mediumblob DEFAULT '' NOT NULL,
 	PRIMARY KEY (search_key)
 );
 
@@ -636,10 +636,10 @@ CREATE TABLE phpbb_search_results (
 # Table: 'phpbb_search_wordlist'
 CREATE TABLE phpbb_search_wordlist (
 	word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	word_text text NOT NULL,
+	word_text blob DEFAULT '' NOT NULL,
 	word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (word_id),
-	UNIQUE wrd_txt (word_text(255))
+	UNIQUE wrd_txt (word_text)
 );
 
 
@@ -655,15 +655,15 @@ CREATE TABLE phpbb_search_wordmatch (
 
 # Table: 'phpbb_sessions'
 CREATE TABLE phpbb_sessions (
-	session_id char(32) DEFAULT '' NOT NULL,
+	session_id binary(32) DEFAULT '' NOT NULL,
 	session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	session_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	session_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	session_ip varchar(40) DEFAULT '' NOT NULL,
-	session_browser varchar(150) DEFAULT '' NOT NULL,
-	session_forwarded_for varchar(255) DEFAULT '' NOT NULL,
-	session_page text NOT NULL,
+	session_ip varbinary(40) DEFAULT '' NOT NULL,
+	session_browser varbinary(150) DEFAULT '' NOT NULL,
+	session_forwarded_for varbinary(255) DEFAULT '' NOT NULL,
+	session_page blob DEFAULT '' NOT NULL,
 	session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
@@ -675,9 +675,9 @@ CREATE TABLE phpbb_sessions (
 
 # Table: 'phpbb_sessions_keys'
 CREATE TABLE phpbb_sessions_keys (
-	key_id char(32) DEFAULT '' NOT NULL,
+	key_id binary(32) DEFAULT '' NOT NULL,
 	user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	last_ip varchar(40) DEFAULT '' NOT NULL,
+	last_ip varbinary(40) DEFAULT '' NOT NULL,
 	last_login int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (key_id, user_id),
 	KEY last_login (last_login)
@@ -687,8 +687,8 @@ CREATE TABLE phpbb_sessions_keys (
 # Table: 'phpbb_sitelist'
 CREATE TABLE phpbb_sitelist (
 	site_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	site_ip varchar(40) DEFAULT '' NOT NULL,
-	site_hostname varchar(255) DEFAULT '' NOT NULL,
+	site_ip varbinary(40) DEFAULT '' NOT NULL,
+	site_hostname varbinary(255) DEFAULT '' NOT NULL,
 	ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (site_id)
 );
@@ -697,9 +697,9 @@ CREATE TABLE phpbb_sitelist (
 # Table: 'phpbb_smilies'
 CREATE TABLE phpbb_smilies (
 	smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	code varchar(150) DEFAULT '' NOT NULL,
-	emotion varchar(150) DEFAULT '' NOT NULL,
-	smiley_url varchar(50) DEFAULT '' NOT NULL,
+	code varbinary(150) DEFAULT '' NOT NULL,
+	emotion varbinary(150) DEFAULT '' NOT NULL,
+	smiley_url varbinary(50) DEFAULT '' NOT NULL,
 	smiley_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 	smiley_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 	smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
@@ -712,14 +712,14 @@ CREATE TABLE phpbb_smilies (
 # Table: 'phpbb_styles'
 CREATE TABLE phpbb_styles (
 	style_id tinyint(4) NOT NULL auto_increment,
-	style_name text NOT NULL,
-	style_copyright text NOT NULL,
+	style_name blob DEFAULT '' NOT NULL,
+	style_copyright blob DEFAULT '' NOT NULL,
 	style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	template_id tinyint(4) DEFAULT '0' NOT NULL,
 	theme_id tinyint(4) DEFAULT '0' NOT NULL,
 	imageset_id tinyint(4) DEFAULT '0' NOT NULL,
 	PRIMARY KEY (style_id),
-	UNIQUE style_name (style_name(255)),
+	UNIQUE style_name (style_name),
 	KEY template_id (template_id),
 	KEY theme_id (theme_id),
 	KEY imageset_id (imageset_id)
@@ -729,23 +729,23 @@ CREATE TABLE phpbb_styles (
 # Table: 'phpbb_styles_template'
 CREATE TABLE phpbb_styles_template (
 	template_id tinyint(4) NOT NULL auto_increment,
-	template_name text NOT NULL,
-	template_copyright text NOT NULL,
-	template_path varchar(100) DEFAULT '' NOT NULL,
-	bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL,
+	template_name blob DEFAULT '' NOT NULL,
+	template_copyright blob DEFAULT '' NOT NULL,
+	template_path varbinary(100) DEFAULT '' NOT NULL,
+	bbcode_bitfield varbinary(255) DEFAULT 'kNg=' NOT NULL,
 	template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	PRIMARY KEY (template_id),
-	UNIQUE tmplte_nm (template_name(255))
+	UNIQUE tmplte_nm (template_name)
 );
 
 
 # Table: 'phpbb_styles_template_data'
 CREATE TABLE phpbb_styles_template_data (
 	template_id tinyint(4) NOT NULL auto_increment,
-	template_filename varchar(100) DEFAULT '' NOT NULL,
-	template_included text NOT NULL,
+	template_filename varbinary(100) DEFAULT '' NOT NULL,
+	template_included blob DEFAULT '' NOT NULL,
 	template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	template_data mediumtext NOT NULL,
+	template_data mediumblob DEFAULT '' NOT NULL,
 	KEY tid (template_id),
 	KEY tfn (template_filename)
 );
@@ -754,119 +754,119 @@ CREATE TABLE phpbb_styles_template_data (
 # Table: 'phpbb_styles_theme'
 CREATE TABLE phpbb_styles_theme (
 	theme_id tinyint(4) NOT NULL auto_increment,
-	theme_name text NOT NULL,
-	theme_copyright text NOT NULL,
-	theme_path varchar(100) DEFAULT '' NOT NULL,
+	theme_name blob DEFAULT '' NOT NULL,
+	theme_copyright blob DEFAULT '' NOT NULL,
+	theme_path varbinary(100) DEFAULT '' NOT NULL,
 	theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	theme_data mediumtext NOT NULL,
+	theme_data mediumblob DEFAULT '' NOT NULL,
 	PRIMARY KEY (theme_id),
-	UNIQUE theme_name (theme_name(255))
+	UNIQUE theme_name (theme_name)
 );
 
 
 # Table: 'phpbb_styles_imageset'
 CREATE TABLE phpbb_styles_imageset (
 	imageset_id tinyint(4) NOT NULL auto_increment,
-	imageset_name text NOT NULL,
-	imageset_copyright text NOT NULL,
-	imageset_path varchar(100) DEFAULT '' NOT NULL,
-	site_logo varchar(200) DEFAULT '' NOT NULL,
-	upload_bar varchar(200) DEFAULT '' NOT NULL,
-	poll_left varchar(200) DEFAULT '' NOT NULL,
-	poll_center varchar(200) DEFAULT '' NOT NULL,
-	poll_right varchar(200) DEFAULT '' NOT NULL,
-	icon_friend varchar(200) DEFAULT '' NOT NULL,
-	icon_foe varchar(200) DEFAULT '' NOT NULL,
-	forum_link varchar(200) DEFAULT '' NOT NULL,
-	forum_read varchar(200) DEFAULT '' NOT NULL,
-	forum_read_locked varchar(200) DEFAULT '' NOT NULL,
-	forum_read_subforum varchar(200) DEFAULT '' NOT NULL,
-	forum_unread varchar(200) DEFAULT '' NOT NULL,
-	forum_unread_locked varchar(200) DEFAULT '' NOT NULL,
-	forum_unread_subforum varchar(200) DEFAULT '' NOT NULL,
-	topic_moved varchar(200) DEFAULT '' NOT NULL,
-	topic_read varchar(200) DEFAULT '' NOT NULL,
-	topic_read_mine varchar(200) DEFAULT '' NOT NULL,
-	topic_read_hot varchar(200) DEFAULT '' NOT NULL,
-	topic_read_hot_mine varchar(200) DEFAULT '' NOT NULL,
-	topic_read_locked varchar(200) DEFAULT '' NOT NULL,
-	topic_read_locked_mine varchar(200) DEFAULT '' NOT NULL,
-	topic_unread varchar(200) DEFAULT '' NOT NULL,
-	topic_unread_mine varchar(200) DEFAULT '' NOT NULL,
-	topic_unread_hot varchar(200) DEFAULT '' NOT NULL,
-	topic_unread_hot_mine varchar(200) DEFAULT '' NOT NULL,
-	topic_unread_locked varchar(200) DEFAULT '' NOT NULL,
-	topic_unread_locked_mine varchar(200) DEFAULT '' NOT NULL,
-	sticky_read varchar(200) DEFAULT '' NOT NULL,
-	sticky_read_mine varchar(200) DEFAULT '' NOT NULL,
-	sticky_read_locked varchar(200) DEFAULT '' NOT NULL,
-	sticky_read_locked_mine varchar(200) DEFAULT '' NOT NULL,
-	sticky_unread varchar(200) DEFAULT '' NOT NULL,
-	sticky_unread_mine varchar(200) DEFAULT '' NOT NULL,
-	sticky_unread_locked varchar(200) DEFAULT '' NOT NULL,
-	sticky_unread_locked_mine varchar(200) DEFAULT '' NOT NULL,
-	announce_read varchar(200) DEFAULT '' NOT NULL,
-	announce_read_mine varchar(200) DEFAULT '' NOT NULL,
-	announce_read_locked varchar(200) DEFAULT '' NOT NULL,
-	announce_read_locked_mine varchar(200) DEFAULT '' NOT NULL,
-	announce_unread varchar(200) DEFAULT '' NOT NULL,
-	announce_unread_mine varchar(200) DEFAULT '' NOT NULL,
-	announce_unread_locked varchar(200) DEFAULT '' NOT NULL,
-	announce_unread_locked_mine varchar(200) DEFAULT '' NOT NULL,
-	global_read varchar(200) DEFAULT '' NOT NULL,
-	global_read_mine varchar(200) DEFAULT '' NOT NULL,
-	global_read_locked varchar(200) DEFAULT '' NOT NULL,
-	global_read_locked_mine varchar(200) DEFAULT '' NOT NULL,
-	global_unread varchar(200) DEFAULT '' NOT NULL,
-	global_unread_mine varchar(200) DEFAULT '' NOT NULL,
-	global_unread_locked varchar(200) DEFAULT '' NOT NULL,
-	global_unread_locked_mine varchar(200) DEFAULT '' NOT NULL,
-	pm_read varchar(200) DEFAULT '' NOT NULL,
-	pm_unread varchar(200) DEFAULT '' NOT NULL,
-	icon_contact_aim varchar(200) DEFAULT '' NOT NULL,
-	icon_contact_email varchar(200) DEFAULT '' NOT NULL,
-	icon_contact_icq varchar(200) DEFAULT '' NOT NULL,
-	icon_contact_jabber varchar(200) DEFAULT '' NOT NULL,
-	icon_contact_msnm varchar(200) DEFAULT '' NOT NULL,
-	icon_contact_pm varchar(200) DEFAULT '' NOT NULL,
-	icon_contact_yahoo varchar(200) DEFAULT '' NOT NULL,
-	icon_contact_www varchar(200) DEFAULT '' NOT NULL,
-	icon_post_delete varchar(200) DEFAULT '' NOT NULL,
-	icon_post_edit varchar(200) DEFAULT '' NOT NULL,
-	icon_post_info varchar(200) DEFAULT '' NOT NULL,
-	icon_post_quote varchar(200) DEFAULT '' NOT NULL,
-	icon_post_report varchar(200) DEFAULT '' NOT NULL,
-	icon_post_target varchar(200) DEFAULT '' NOT NULL,
-	icon_post_target_unread varchar(200) DEFAULT '' NOT NULL,
-	icon_topic_attach varchar(200) DEFAULT '' NOT NULL,
-	icon_topic_latest varchar(200) DEFAULT '' NOT NULL,
-	icon_topic_newest varchar(200) DEFAULT '' NOT NULL,
-	icon_topic_reported varchar(200) DEFAULT '' NOT NULL,
-	icon_topic_unapproved varchar(200) DEFAULT '' NOT NULL,
-	icon_user_online varchar(200) DEFAULT '' NOT NULL,
-	icon_user_offline varchar(200) DEFAULT '' NOT NULL,
-	icon_user_profile varchar(200) DEFAULT '' NOT NULL,
-	icon_user_search varchar(200) DEFAULT '' NOT NULL,
-	icon_user_warn varchar(200) DEFAULT '' NOT NULL,
-	button_pm_forward varchar(200) DEFAULT '' NOT NULL,
-	button_pm_new varchar(200) DEFAULT '' NOT NULL,
-	button_pm_reply varchar(200) DEFAULT '' NOT NULL,
-	button_topic_locked varchar(200) DEFAULT '' NOT NULL,
-	button_topic_new varchar(200) DEFAULT '' NOT NULL,
-	button_topic_reply varchar(200) DEFAULT '' NOT NULL,
-	user_icon1 varchar(200) DEFAULT '' NOT NULL,
-	user_icon2 varchar(200) DEFAULT '' NOT NULL,
-	user_icon3 varchar(200) DEFAULT '' NOT NULL,
-	user_icon4 varchar(200) DEFAULT '' NOT NULL,
-	user_icon5 varchar(200) DEFAULT '' NOT NULL,
-	user_icon6 varchar(200) DEFAULT '' NOT NULL,
-	user_icon7 varchar(200) DEFAULT '' NOT NULL,
-	user_icon8 varchar(200) DEFAULT '' NOT NULL,
-	user_icon9 varchar(200) DEFAULT '' NOT NULL,
-	user_icon10 varchar(200) DEFAULT '' NOT NULL,
+	imageset_name blob DEFAULT '' NOT NULL,
+	imageset_copyright blob DEFAULT '' NOT NULL,
+	imageset_path varbinary(100) DEFAULT '' NOT NULL,
+	site_logo varbinary(200) DEFAULT '' NOT NULL,
+	upload_bar varbinary(200) DEFAULT '' NOT NULL,
+	poll_left varbinary(200) DEFAULT '' NOT NULL,
+	poll_center varbinary(200) DEFAULT '' NOT NULL,
+	poll_right varbinary(200) DEFAULT '' NOT NULL,
+	icon_friend varbinary(200) DEFAULT '' NOT NULL,
+	icon_foe varbinary(200) DEFAULT '' NOT NULL,
+	forum_link varbinary(200) DEFAULT '' NOT NULL,
+	forum_read varbinary(200) DEFAULT '' NOT NULL,
+	forum_read_locked varbinary(200) DEFAULT '' NOT NULL,
+	forum_read_subforum varbinary(200) DEFAULT '' NOT NULL,
+	forum_unread varbinary(200) DEFAULT '' NOT NULL,
+	forum_unread_locked varbinary(200) DEFAULT '' NOT NULL,
+	forum_unread_subforum varbinary(200) DEFAULT '' NOT NULL,
+	topic_moved varbinary(200) DEFAULT '' NOT NULL,
+	topic_read varbinary(200) DEFAULT '' NOT NULL,
+	topic_read_mine varbinary(200) DEFAULT '' NOT NULL,
+	topic_read_hot varbinary(200) DEFAULT '' NOT NULL,
+	topic_read_hot_mine varbinary(200) DEFAULT '' NOT NULL,
+	topic_read_locked varbinary(200) DEFAULT '' NOT NULL,
+	topic_read_locked_mine varbinary(200) DEFAULT '' NOT NULL,
+	topic_unread varbinary(200) DEFAULT '' NOT NULL,
+	topic_unread_mine varbinary(200) DEFAULT '' NOT NULL,
+	topic_unread_hot varbinary(200) DEFAULT '' NOT NULL,
+	topic_unread_hot_mine varbinary(200) DEFAULT '' NOT NULL,
+	topic_unread_locked varbinary(200) DEFAULT '' NOT NULL,
+	topic_unread_locked_mine varbinary(200) DEFAULT '' NOT NULL,
+	sticky_read varbinary(200) DEFAULT '' NOT NULL,
+	sticky_read_mine varbinary(200) DEFAULT '' NOT NULL,
+	sticky_read_locked varbinary(200) DEFAULT '' NOT NULL,
+	sticky_read_locked_mine varbinary(200) DEFAULT '' NOT NULL,
+	sticky_unread varbinary(200) DEFAULT '' NOT NULL,
+	sticky_unread_mine varbinary(200) DEFAULT '' NOT NULL,
+	sticky_unread_locked varbinary(200) DEFAULT '' NOT NULL,
+	sticky_unread_locked_mine varbinary(200) DEFAULT '' NOT NULL,
+	announce_read varbinary(200) DEFAULT '' NOT NULL,
+	announce_read_mine varbinary(200) DEFAULT '' NOT NULL,
+	announce_read_locked varbinary(200) DEFAULT '' NOT NULL,
+	announce_read_locked_mine varbinary(200) DEFAULT '' NOT NULL,
+	announce_unread varbinary(200) DEFAULT '' NOT NULL,
+	announce_unread_mine varbinary(200) DEFAULT '' NOT NULL,
+	announce_unread_locked varbinary(200) DEFAULT '' NOT NULL,
+	announce_unread_locked_mine varbinary(200) DEFAULT '' NOT NULL,
+	global_read varbinary(200) DEFAULT '' NOT NULL,
+	global_read_mine varbinary(200) DEFAULT '' NOT NULL,
+	global_read_locked varbinary(200) DEFAULT '' NOT NULL,
+	global_read_locked_mine varbinary(200) DEFAULT '' NOT NULL,
+	global_unread varbinary(200) DEFAULT '' NOT NULL,
+	global_unread_mine varbinary(200) DEFAULT '' NOT NULL,
+	global_unread_locked varbinary(200) DEFAULT '' NOT NULL,
+	global_unread_locked_mine varbinary(200) DEFAULT '' NOT NULL,
+	pm_read varbinary(200) DEFAULT '' NOT NULL,
+	pm_unread varbinary(200) DEFAULT '' NOT NULL,
+	icon_contact_aim varbinary(200) DEFAULT '' NOT NULL,
+	icon_contact_email varbinary(200) DEFAULT '' NOT NULL,
+	icon_contact_icq varbinary(200) DEFAULT '' NOT NULL,
+	icon_contact_jabber varbinary(200) DEFAULT '' NOT NULL,
+	icon_contact_msnm varbinary(200) DEFAULT '' NOT NULL,
+	icon_contact_pm varbinary(200) DEFAULT '' NOT NULL,
+	icon_contact_yahoo varbinary(200) DEFAULT '' NOT NULL,
+	icon_contact_www varbinary(200) DEFAULT '' NOT NULL,
+	icon_post_delete varbinary(200) DEFAULT '' NOT NULL,
+	icon_post_edit varbinary(200) DEFAULT '' NOT NULL,
+	icon_post_info varbinary(200) DEFAULT '' NOT NULL,
+	icon_post_quote varbinary(200) DEFAULT '' NOT NULL,
+	icon_post_report varbinary(200) DEFAULT '' NOT NULL,
+	icon_post_target varbinary(200) DEFAULT '' NOT NULL,
+	icon_post_target_unread varbinary(200) DEFAULT '' NOT NULL,
+	icon_topic_attach varbinary(200) DEFAULT '' NOT NULL,
+	icon_topic_latest varbinary(200) DEFAULT '' NOT NULL,
+	icon_topic_newest varbinary(200) DEFAULT '' NOT NULL,
+	icon_topic_reported varbinary(200) DEFAULT '' NOT NULL,
+	icon_topic_unapproved varbinary(200) DEFAULT '' NOT NULL,
+	icon_user_online varbinary(200) DEFAULT '' NOT NULL,
+	icon_user_offline varbinary(200) DEFAULT '' NOT NULL,
+	icon_user_profile varbinary(200) DEFAULT '' NOT NULL,
+	icon_user_search varbinary(200) DEFAULT '' NOT NULL,
+	icon_user_warn varbinary(200) DEFAULT '' NOT NULL,
+	button_pm_forward varbinary(200) DEFAULT '' NOT NULL,
+	button_pm_new varbinary(200) DEFAULT '' NOT NULL,
+	button_pm_reply varbinary(200) DEFAULT '' NOT NULL,
+	button_topic_locked varbinary(200) DEFAULT '' NOT NULL,
+	button_topic_new varbinary(200) DEFAULT '' NOT NULL,
+	button_topic_reply varbinary(200) DEFAULT '' NOT NULL,
+	user_icon1 varbinary(200) DEFAULT '' NOT NULL,
+	user_icon2 varbinary(200) DEFAULT '' NOT NULL,
+	user_icon3 varbinary(200) DEFAULT '' NOT NULL,
+	user_icon4 varbinary(200) DEFAULT '' NOT NULL,
+	user_icon5 varbinary(200) DEFAULT '' NOT NULL,
+	user_icon6 varbinary(200) DEFAULT '' NOT NULL,
+	user_icon7 varbinary(200) DEFAULT '' NOT NULL,
+	user_icon8 varbinary(200) DEFAULT '' NOT NULL,
+	user_icon9 varbinary(200) DEFAULT '' NOT NULL,
+	user_icon10 varbinary(200) DEFAULT '' NOT NULL,
 	PRIMARY KEY (imageset_id),
-	UNIQUE imgset_nm (imageset_name(255))
+	UNIQUE imgset_nm (imageset_name)
 );
 
 
@@ -878,7 +878,7 @@ CREATE TABLE phpbb_topics (
 	topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	topic_title text NOT NULL,
+	topic_title blob DEFAULT '' NOT NULL,
 	topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL,
@@ -888,19 +888,19 @@ CREATE TABLE phpbb_topics (
 	topic_status tinyint(3) DEFAULT '0' NOT NULL,
 	topic_type tinyint(3) DEFAULT '0' NOT NULL,
 	topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	topic_first_poster_name text NOT NULL,
-	topic_first_poster_colour varchar(6) DEFAULT '' NOT NULL,
+	topic_first_poster_name blob DEFAULT '' NOT NULL,
+	topic_first_poster_colour varbinary(6) DEFAULT '' NOT NULL,
 	topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	topic_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	topic_last_poster_name text NOT NULL,
-	topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL,
-	topic_last_post_subject text NOT NULL,
+	topic_last_poster_name blob DEFAULT '' NOT NULL,
+	topic_last_poster_colour varbinary(6) DEFAULT '' NOT NULL,
+	topic_last_post_subject blob DEFAULT '' NOT NULL,
 	topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	poll_title text NOT NULL,
+	poll_title blob DEFAULT '' NOT NULL,
 	poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	poll_max_options tinyint(4) DEFAULT '1' NOT NULL,
@@ -963,23 +963,23 @@ CREATE TABLE phpbb_users (
 	user_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 	user_type tinyint(2) DEFAULT '0' NOT NULL,
 	group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL,
-	user_permissions mediumtext NOT NULL,
+	user_permissions mediumblob DEFAULT '' NOT NULL,
 	user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	user_ip varchar(40) DEFAULT '' NOT NULL,
+	user_ip varbinary(40) DEFAULT '' NOT NULL,
 	user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	username text NOT NULL,
-	username_clean text NOT NULL,
-	user_password varchar(120) DEFAULT '' NOT NULL,
+	username blob DEFAULT '' NOT NULL,
+	username_clean blob DEFAULT '' NOT NULL,
+	user_password varbinary(120) DEFAULT '' NOT NULL,
 	user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	user_pass_convert tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	user_email text NOT NULL,
+	user_email blob DEFAULT '' NOT NULL,
 	user_email_hash bigint(20) DEFAULT '0' NOT NULL,
-	user_birthday varchar(10) DEFAULT '' NOT NULL,
+	user_birthday varbinary(10) DEFAULT '' NOT NULL,
 	user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	user_lastpage text NOT NULL,
-	user_last_confirm_key varchar(10) DEFAULT '' NOT NULL,
+	user_lastpage blob DEFAULT '' NOT NULL,
+	user_last_confirm_key varbinary(10) DEFAULT '' NOT NULL,
 	user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	user_warnings tinyint(4) DEFAULT '0' NOT NULL,
 	user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL,
@@ -987,13 +987,13 @@ CREATE TABLE phpbb_users (
 	user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL,
 	user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	user_lang varchar(30) DEFAULT '' NOT NULL,
+	user_lang varbinary(30) DEFAULT '' NOT NULL,
 	user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
 	user_dst tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	user_dateformat varchar(90) DEFAULT 'd M Y H:i' NOT NULL,
+	user_dateformat varbinary(90) DEFAULT 'd M Y H:i' NOT NULL,
 	user_style tinyint(4) DEFAULT '0' NOT NULL,
 	user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	user_colour varchar(6) DEFAULT '' NOT NULL,
+	user_colour varbinary(6) DEFAULT '' NOT NULL,
 	user_new_privmsg tinyint(4) DEFAULT '0' NOT NULL,
 	user_unread_privmsg tinyint(4) DEFAULT '0' NOT NULL,
 	user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
@@ -1001,11 +1001,11 @@ CREATE TABLE phpbb_users (
 	user_full_folder int(11) DEFAULT '-3' NOT NULL,
 	user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	user_topic_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
-	user_topic_sortby_type varchar(1) DEFAULT 't' NOT NULL,
-	user_topic_sortby_dir varchar(1) DEFAULT 'd' NOT NULL,
+	user_topic_sortby_type varbinary(1) DEFAULT 't' NOT NULL,
+	user_topic_sortby_dir varbinary(1) DEFAULT 'd' NOT NULL,
 	user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
-	user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL,
-	user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL,
+	user_post_sortby_type varbinary(1) DEFAULT 't' NOT NULL,
+	user_post_sortby_dir varbinary(1) DEFAULT 'a' NOT NULL,
 	user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 	user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	user_notify_type tinyint(4) DEFAULT '0' NOT NULL,
@@ -1014,29 +1014,29 @@ CREATE TABLE phpbb_users (
 	user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 	user_options int(11) UNSIGNED DEFAULT '895' NOT NULL,
-	user_avatar varchar(255) DEFAULT '' NOT NULL,
+	user_avatar varbinary(255) DEFAULT '' NOT NULL,
 	user_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
 	user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 	user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
-	user_sig mediumtext NOT NULL,
-	user_sig_bbcode_uid varchar(5) DEFAULT '' NOT NULL,
-	user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
-	user_from text NOT NULL,
-	user_icq varchar(15) DEFAULT '' NOT NULL,
-	user_aim text NOT NULL,
-	user_yim text NOT NULL,
-	user_msnm text NOT NULL,
-	user_jabber text NOT NULL,
-	user_website text NOT NULL,
-	user_occ text NOT NULL,
-	user_interests text NOT NULL,
-	user_actkey varchar(32) DEFAULT '' NOT NULL,
-	user_newpasswd varchar(96) DEFAULT '' NOT NULL,
+	user_sig mediumblob DEFAULT '' NOT NULL,
+	user_sig_bbcode_uid varbinary(5) DEFAULT '' NOT NULL,
+	user_sig_bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
+	user_from blob DEFAULT '' NOT NULL,
+	user_icq varbinary(15) DEFAULT '' NOT NULL,
+	user_aim blob DEFAULT '' NOT NULL,
+	user_yim blob DEFAULT '' NOT NULL,
+	user_msnm blob DEFAULT '' NOT NULL,
+	user_jabber blob DEFAULT '' NOT NULL,
+	user_website blob DEFAULT '' NOT NULL,
+	user_occ blob DEFAULT '' NOT NULL,
+	user_interests blob DEFAULT '' NOT NULL,
+	user_actkey varbinary(32) DEFAULT '' NOT NULL,
+	user_newpasswd varbinary(96) DEFAULT '' NOT NULL,
 	PRIMARY KEY (user_id),
 	KEY user_birthday (user_birthday),
 	KEY user_email_hash (user_email_hash),
 	KEY user_type (user_type),
-	KEY username_clean (username_clean(255))
+	UNIQUE username_clean (username_clean)
 );
 
 
@@ -1054,8 +1054,8 @@ CREATE TABLE phpbb_warnings (
 # Table: 'phpbb_words'
 CREATE TABLE phpbb_words (
 	word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
-	word text NOT NULL,
-	replacement text NOT NULL,
+	word blob DEFAULT '' NOT NULL,
+	replacement blob DEFAULT '' NOT NULL,
 	PRIMARY KEY (word_id)
 );
 
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql
index bf884e1ed4..0b4a2ce1d5 100644
--- a/phpBB/install/schemas/mysql_41_schema.sql
+++ b/phpBB/install/schemas/mysql_41_schema.sql
@@ -1036,7 +1036,7 @@ CREATE TABLE phpbb_users (
 	KEY user_birthday (user_birthday),
 	KEY user_email_hash (user_email_hash),
 	KEY user_type (user_type),
-	KEY username_clean (username_clean)
+	UNIQUE username_clean (username_clean)
 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
 
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 970006a7c8..4e5cbb3da0 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -1841,7 +1841,8 @@ CREATE TABLE phpbb_users (
 	user_interests clob DEFAULT '' ,
 	user_actkey varchar2(32) DEFAULT '' ,
 	user_newpasswd varchar2(96) DEFAULT '' ,
-	CONSTRAINT pk_phpbb_users PRIMARY KEY (user_id)
+	CONSTRAINT pk_phpbb_users PRIMARY KEY (user_id),
+	CONSTRAINT u_phpbb_username_clean UNIQUE (username_clean)
 )
 /
 
@@ -1851,8 +1852,6 @@ CREATE INDEX phpbb_users_user_email_hash ON phpbb_users (user_email_hash)
 /
 CREATE INDEX phpbb_users_user_type ON phpbb_users (user_type)
 /
-CREATE INDEX phpbb_users_username_clean ON phpbb_users (username_clean)
-/
 
 CREATE SEQUENCE phpbb_users_seq
 /
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index e1dea496cf..f33fd7ec07 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -1298,7 +1298,7 @@ CREATE TABLE phpbb_users (
 CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday);
 CREATE INDEX phpbb_users_user_email_hash ON phpbb_users (user_email_hash);
 CREATE INDEX phpbb_users_user_type ON phpbb_users (user_type);
-CREATE INDEX phpbb_users_username_clean ON phpbb_users (username_clean);
+CREATE UNIQUE INDEX phpbb_users_username_clean ON phpbb_users (username_clean);
 
 /*
 	Table: 'phpbb_warnings'
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 93e916a234..2a1875945f 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -1008,7 +1008,7 @@ CREATE TABLE phpbb_users (
 CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday);
 CREATE INDEX phpbb_users_user_email_hash ON phpbb_users (user_email_hash);
 CREATE INDEX phpbb_users_user_type ON phpbb_users (user_type);
-CREATE INDEX phpbb_users_username_clean ON phpbb_users (username_clean);
+CREATE UNIQUE INDEX phpbb_users_username_clean ON phpbb_users (username_clean);
 
 # Table: 'phpbb_warnings'
 CREATE TABLE phpbb_warnings (
author	David M <davidmj@users.sourceforge.net>	2007-02-25 21:03:14 +0000
committer	David M <davidmj@users.sourceforge.net>	2007-02-25 21:03:14 +0000
commit	409904c8788949a765a591673003f511f6bf8ed0 (patch)
tree	ba5fdf2a75737f874683b7ea5ac8242ef2d140af
parent	8494211a129f0dabe5747c6915871e40fdced8b2 (diff)
download	forums-409904c8788949a765a591673003f511f6bf8ed0.tar forums-409904c8788949a765a591673003f511f6bf8ed0.tar.gz forums-409904c8788949a765a591673003f511f6bf8ed0.tar.bz2 forums-409904c8788949a765a591673003f511f6bf8ed0.tar.xz forums-409904c8788949a765a591673003f511f6bf8ed0.zip