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/oracle_schema.sql | 2 ++
 1 file changed, 2 insertions(+)

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

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

