6 files changed, 12 insertions, 0 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 6126af9549..6ff0ac3e97 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -1285,9 +1285,11 @@ CREATE TABLE phpbb_topics (
 	topic_type INTEGER DEFAULT 0 NOT NULL,
 	topic_first_post_id INTEGER DEFAULT 0 NOT NULL,
 	topic_first_poster_name VARCHAR(255) DEFAULT '' NOT NULL,
+	topic_first_poster_colour VARCHAR(6) DEFAULT '' NOT NULL,
 	topic_last_post_id INTEGER DEFAULT 0 NOT NULL,
 	topic_last_poster_id INTEGER DEFAULT 0 NOT NULL,
 	topic_last_poster_name VARCHAR(255) DEFAULT '' NOT NULL,
+	topic_last_poster_colour VARCHAR(6) DEFAULT '' NOT NULL,
 	topic_last_post_time INTEGER DEFAULT 0 NOT NULL,
 	topic_last_view_time INTEGER DEFAULT 0 NOT NULL,
 	topic_moved_id INTEGER DEFAULT 0 NOT NULL,
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 737ec7842f..d878f26473 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -1469,9 +1469,11 @@ CREATE TABLE [phpbb_topics] (
 	[topic_type] [int] DEFAULT (0) NOT NULL ,
 	[topic_first_post_id] [int] DEFAULT (0) NOT NULL ,
 	[topic_first_poster_name] [varchar] (255) DEFAULT ('') NOT NULL ,
+	[topic_first_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,
 	[topic_last_post_id] [int] DEFAULT (0) NOT NULL ,
 	[topic_last_poster_id] [int] DEFAULT (0) NOT NULL ,
 	[topic_last_poster_name] [varchar] (255) DEFAULT ('') NOT NULL ,
+	[topic_last_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,
 	[topic_last_post_time] [int] DEFAULT (0) NOT NULL ,
 	[topic_last_view_time] [int] DEFAULT (0) NOT NULL ,
 	[topic_moved_id] [int] DEFAULT (0) NOT NULL ,
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index a90917ccc6..0ed3de8167 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -886,9 +886,11 @@ CREATE TABLE phpbb_topics (
 	topic_type tinyint(3) DEFAULT '0' NOT NULL,
 	topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	topic_first_poster_name varchar(255) DEFAULT '' NOT NULL,
+	topic_first_poster_colour varchar(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 varchar(255) DEFAULT '' NOT NULL,
+	topic_last_poster_colour varchar(6) 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,
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index a5c0b9202e..c9574dda86 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -1653,9 +1653,11 @@ CREATE TABLE phpbb_topics (
 	topic_type number(3) DEFAULT '0' NOT NULL,
 	topic_first_post_id number(8) DEFAULT '0' NOT NULL,
 	topic_first_poster_name varchar2(255) DEFAULT '' ,
+	topic_first_poster_colour varchar2(6) DEFAULT '' ,
 	topic_last_post_id number(8) DEFAULT '0' NOT NULL,
 	topic_last_poster_id number(8) DEFAULT '0' NOT NULL,
 	topic_last_poster_name varchar2(255) DEFAULT '' ,
+	topic_last_poster_colour varchar2(6) DEFAULT '' ,
 	topic_last_post_time number(11) DEFAULT '0' NOT NULL,
 	topic_last_view_time number(11) DEFAULT '0' NOT NULL,
 	topic_moved_id number(8) DEFAULT '0' NOT NULL,
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index 7a4b3662b0..a7ea962311 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -1134,9 +1134,11 @@ CREATE TABLE phpbb_topics (
 	topic_type INT2 DEFAULT '0' NOT NULL,
 	topic_first_post_id INT4 DEFAULT '0' NOT NULL CHECK (topic_first_post_id >= 0),
 	topic_first_poster_name varchar(255) DEFAULT '' NOT NULL,
+	topic_first_poster_colour varchar(6) DEFAULT '' NOT NULL,
 	topic_last_post_id INT4 DEFAULT '0' NOT NULL CHECK (topic_last_post_id >= 0),
 	topic_last_poster_id INT4 DEFAULT '0' NOT NULL CHECK (topic_last_poster_id >= 0),
 	topic_last_poster_name varchar(255) DEFAULT '' NOT NULL,
+	topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL,
 	topic_last_post_time INT4 DEFAULT '0' NOT NULL CHECK (topic_last_post_time >= 0),
 	topic_last_view_time INT4 DEFAULT '0' NOT NULL CHECK (topic_last_view_time >= 0),
 	topic_moved_id INT4 DEFAULT '0' NOT NULL CHECK (topic_moved_id >= 0),
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index ae204d4be9..65b1d5c369 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -858,9 +858,11 @@ CREATE TABLE phpbb_topics (
 	topic_type tinyint(3) NOT NULL DEFAULT '0',
 	topic_first_post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
 	topic_first_poster_name varchar(255) NOT NULL DEFAULT '',
+	topic_first_poster_colour varchar(6) NOT NULL DEFAULT '',
 	topic_last_post_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
 	topic_last_poster_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
 	topic_last_poster_name varchar(255) NOT NULL DEFAULT '',
+	topic_last_poster_colour varchar(6) NOT NULL DEFAULT '',
 	topic_last_post_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
 	topic_last_view_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
 	topic_moved_id INTEGER UNSIGNED NOT NULL DEFAULT '0',