3 files changed, 8 insertions, 8 deletions
diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql
index 323b6865b0..1e278f6cb3 100644
--- a/phpBB/db/schemas/mssql_schema.sql
+++ b/phpBB/db/schemas/mssql_schema.sql
@@ -105,7 +105,7 @@ CREATE TABLE [phpbb_posts] (
 	[poster_id] [int] NOT NULL ,
 	[post_time] [int] NOT NULL ,
 	[poster_ip] [char] (8) NULL ,
-	[post_username] [varchar] (50) NULL ,
+	[post_username] [char] (25) NULL ,
 	[enable_bbcode] [smallint] NULL ,
 	[enable_html] [smallint] NULL ,
 	[enable_smilies] [smallint] NULL ,
@@ -118,7 +118,7 @@ GO
 CREATE TABLE [phpbb_posts_text] (
 	[post_id] [int] NOT NULL ,
 	[bbcode_uid] [char] (10) NULL ,
-	[post_subject] [varchar] (100) NULL ,
+	[post_subject] [char] (60) NULL ,
 	[post_text] [text] NULL 
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 GO
@@ -280,7 +280,7 @@ GO
 CREATE TABLE [phpbb_topics] (
 	[topic_id] [int] IDENTITY (1, 1) NOT NULL ,
 	[forum_id] [int] NOT NULL ,
-	[topic_title] [varchar] (100) NOT NULL ,
+	[topic_title] [varchar] (60) NOT NULL ,
 	[topic_poster] [int] NOT NULL ,
 	[topic_time] [int] NOT NULL ,
 	[topic_views] [int] NOT NULL ,
diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql
index 0b8fdf810c..719f6ce083 100644
--- a/phpBB/db/schemas/mysql_schema.sql
+++ b/phpBB/db/schemas/mysql_schema.sql
@@ -161,7 +161,7 @@ CREATE TABLE phpbb_posts (
    poster_id mediumint(8) DEFAULT '0' NOT NULL,
    post_time int(11) DEFAULT '0' NOT NULL,
    poster_ip char(8) NOT NULL, 
-   post_username varchar(30), 
+   post_username varchar(25), 
    enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
    enable_html tinyint(1) DEFAULT '0' NOT NULL,
    enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
@@ -183,7 +183,7 @@ CREATE TABLE phpbb_posts (
 CREATE TABLE phpbb_posts_text (
    post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
    bbcode_uid char(10) NOT NULL,
-   post_subject varchar(255),
+   post_subject char(60),
    post_text text,
    PRIMARY KEY (post_id)
 );
diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql
index 218dff49e4..cea66b3204 100644
--- a/phpBB/db/schemas/postgres_schema.sql
+++ b/phpBB/db/schemas/postgres_schema.sql
@@ -159,7 +159,7 @@ CREATE TABLE phpbb_posts (
    forum_id int4 DEFAULT '0' NOT NULL,
    poster_id int4 DEFAULT '0' NOT NULL,
    post_time int4 DEFAULT '0' NOT NULL,
-   post_username varchar(30),
+   post_username varchar(25),
    poster_ip char(8) DEFAULT '' NOT NULL,
    enable_bbcode int2 DEFAULT '1' NOT NULL,
    enable_html int2 DEFAULT '0' NOT NULL,
@@ -181,7 +181,7 @@ CREATE  INDEX topic_id_phpbb_posts_index ON phpbb_posts (topic_id);
 CREATE TABLE phpbb_posts_text (
    post_id int4 DEFAULT '0' NOT NULL,
    bbcode_uid varchar(10) DEFAULT '' NOT NULL,
-   post_subject varchar(255),
+   post_subject varchar(60),
    post_text text,
    CONSTRAINT phpbb_posts_text_pkey PRIMARY KEY (post_id)
 );
@@ -393,7 +393,7 @@ CREATE TABLE phpbb_themes_name (
 CREATE TABLE phpbb_topics (
    topic_id int4 DEFAULT nextval('phpbb_topics_id_seq'::text) NOT NULL,
    forum_id int4 DEFAULT '0' NOT NULL,
-   topic_title varchar(100) DEFAULT '' NOT NULL,
+   topic_title varchar(60) DEFAULT '' NOT NULL,
    topic_poster int4 DEFAULT '0' NOT NULL,
    topic_time int4 DEFAULT '0' NOT NULL,
    topic_views int4 DEFAULT '0' NOT NULL,