7 files changed, 14 insertions, 14 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index f1c74512eb..d0f9cf88d1 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -136,8 +136,8 @@ CREATE TABLE phpbb_banlist (
 	ban_start INTEGER DEFAULT 0 NOT NULL,
 	ban_end INTEGER DEFAULT 0 NOT NULL,
 	ban_exclude INTEGER DEFAULT 0 NOT NULL,
-	ban_reason BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,
-	ban_give_reason BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL
+	ban_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
+	ban_give_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
 );;
 
 ALTER TABLE phpbb_banlist ADD PRIMARY KEY (ban_id);;
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 6c2e2ee24d..7dd9c4e924 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -178,8 +178,8 @@ CREATE TABLE [phpbb_banlist] (
 	[ban_start] [int] DEFAULT (0) NOT NULL ,
 	[ban_end] [int] DEFAULT (0) NOT NULL ,
 	[ban_exclude] [int] DEFAULT (0) NOT NULL ,
-	[ban_reason] [varchar] (3000) DEFAULT ('') NOT NULL ,
-	[ban_give_reason] [varchar] (3000) DEFAULT ('') NOT NULL 
+	[ban_reason] [varchar] (255) DEFAULT ('') NOT NULL ,
+	[ban_give_reason] [varchar] (255) DEFAULT ('') NOT NULL 
 ) ON [PRIMARY]
 GO
 
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql
index 44b292b7e7..7fee7f696d 100644
--- a/phpBB/install/schemas/mysql_41_schema.sql
+++ b/phpBB/install/schemas/mysql_41_schema.sql
@@ -98,8 +98,8 @@ CREATE TABLE phpbb_banlist (
 	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 varchar(255) DEFAULT '' NOT NULL,
+	ban_give_reason varchar(255) DEFAULT '' NOT NULL,
 	PRIMARY KEY (ban_id),
 	KEY ban_end (ban_end),
 	KEY ban_user (ban_userid, ban_exclude),
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 489c7e7bc5..69889a3db2 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -220,8 +220,8 @@ CREATE TABLE phpbb_banlist (
 	ban_start number(11) DEFAULT '0' NOT NULL,
 	ban_end number(11) DEFAULT '0' NOT NULL,
 	ban_exclude number(1) DEFAULT '0' NOT NULL,
-	ban_reason varchar2(3000) DEFAULT '' ,
-	ban_give_reason varchar2(3000) DEFAULT '' ,
+	ban_reason varchar2(765) DEFAULT '' ,
+	ban_give_reason varchar2(765) DEFAULT '' ,
 	CONSTRAINT pk_phpbb_banlist PRIMARY KEY (ban_id)
 )
 /
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index b1ff1d1d11..c49423bcf9 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -199,8 +199,8 @@ CREATE TABLE phpbb_banlist (
 	ban_start INT4 DEFAULT '0' NOT NULL CHECK (ban_start >= 0),
 	ban_end INT4 DEFAULT '0' NOT NULL CHECK (ban_end >= 0),
 	ban_exclude INT2 DEFAULT '0' NOT NULL CHECK (ban_exclude >= 0),
-	ban_reason varchar(3000) DEFAULT '' NOT NULL,
-	ban_give_reason varchar(3000) DEFAULT '' NOT NULL,
+	ban_reason varchar(255) DEFAULT '' NOT NULL,
+	ban_give_reason varchar(255) DEFAULT '' NOT NULL,
 	PRIMARY KEY (ban_id)
 );
 
diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql
index 321cae118c..81e8c3cf80 100644
--- a/phpBB/install/schemas/schema_data.sql
+++ b/phpBB/install/schemas/schema_data.sql
@@ -138,7 +138,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_online_guests
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_online_time', '5');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_onlinetrack', '1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_search', '1');
-INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_tplcompile', '0');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_tplcompile', '1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_user_activity', '1');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments', '3');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_attachments_pm', '1');
@@ -205,7 +205,7 @@ INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page',
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('tpl_allow_php', '0');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');
-INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.0.RC2');
+INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.0.RC3');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');
 INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');
 
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 70b4f8de22..156e4bfc76 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -97,8 +97,8 @@ CREATE TABLE phpbb_banlist (
 	ban_start INTEGER UNSIGNED NOT NULL DEFAULT '0',
 	ban_end INTEGER UNSIGNED NOT NULL DEFAULT '0',
 	ban_exclude INTEGER UNSIGNED NOT NULL DEFAULT '0',
-	ban_reason text(65535) NOT NULL DEFAULT '',
-	ban_give_reason text(65535) NOT NULL DEFAULT ''
+	ban_reason varchar(255) NOT NULL DEFAULT '',
+	ban_give_reason varchar(255) NOT NULL DEFAULT ''
 );
 
 CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist (ban_end);