From 4553293053ba5ccdd369a181adda30e6ee0159eb Mon Sep 17 00:00:00 2001
From: Graham Eames <grahamje@users.sourceforge.net>
Date: Mon, 21 Aug 2006 15:58:48 +0000
Subject: Initial batch of colourization changes. This includes:  - schema
 changes for first post and last post  - display in viewforum, search and ucp
 of first post  - update of database on posting Still outstanding  - display
 of last post

git-svn-id: file:///svn/phpbb/trunk@6309 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/mysql_schema.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'phpBB/install/schemas/mysql_schema.sql')

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,
-- 
cgit v1.2.1

