diff options
| author | Graham Eames <grahamje@users.sourceforge.net> | 2006-08-21 15:58:48 +0000 |
|---|---|---|
| committer | Graham Eames <grahamje@users.sourceforge.net> | 2006-08-21 15:58:48 +0000 |
| commit | 4553293053ba5ccdd369a181adda30e6ee0159eb (patch) | |
| tree | 6da41f5ca45d8ed2feadb5dbff19da3c43f03d71 /phpBB/install/schemas/mysql_schema.sql | |
| parent | 1332ec033fa7e4a65895a245dbbf3e6ed0377f13 (diff) | |
| download | forums-4553293053ba5ccdd369a181adda30e6ee0159eb.tar forums-4553293053ba5ccdd369a181adda30e6ee0159eb.tar.gz forums-4553293053ba5ccdd369a181adda30e6ee0159eb.tar.bz2 forums-4553293053ba5ccdd369a181adda30e6ee0159eb.tar.xz forums-4553293053ba5ccdd369a181adda30e6ee0159eb.zip | |
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
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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, |