From b873b37607762868580bdd21b9c90f05db168921 Mon Sep 17 00:00:00 2001
From: Meik Sievertsen <acydburn@phpbb.com>
Date: Wed, 19 Oct 2005 18:00:10 +0000
Subject: - updated topic tracking code - additional changes (mostly bugfixes)
 - bart, if you update your user table with the user_lastmark field, set it to
 the user_lastvisit value ;) - and last but not least, introducing some bugs
 in ucp main front (regarding topic tracking)

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

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

diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index 9f7e4c4493..805001e2fc 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -1094,12 +1094,11 @@ CREATE INDEX topic_last_post_time_phpbb_topics_index ON phpbb_topics (topic_last
 
 SELECT SETVAL('phpbb_topics_topic_id_seq',(select case when max(topic_id)>0 then max(topic_id)+1 else 1 end from phpbb_topics));
 
-/* Table: phpbb_topic_marking */
+/* Table: phpbb_topics_marking */
 CREATE TABLE phpbb_topics_marking (
    user_id INT4  DEFAULT '0' NOT NULL,
    topic_id INT4  DEFAULT '0' NOT NULL,
    forum_id INT4  DEFAULT '0' NOT NULL,
-   mark_type INT2 DEFAULT '0' NOT NULL,
    mark_time INT4 DEFAULT '0' NOT NULL,
    PRIMARY KEY (user_id,topic_id),
   CHECK (user_id>=0),
@@ -1107,6 +1106,18 @@ CREATE TABLE phpbb_topics_marking (
   CHECK (forum_id>=0)
 );
 
+CREATE INDEX forum_id_phpbb_topics_marking_index ON phpbb_topics_marking (forum_id);
+
+/* Table: phpbb_topics_posted */
+CREATE TABLE phpbb_topics_posted (
+   user_id INT4  DEFAULT '0' NOT NULL,
+   topic_id INT4  DEFAULT '0' NOT NULL,
+   topic_posted INT2  DEFAULT '0' NOT NULL,
+   PRIMARY KEY (user_id,topic_id),
+  CHECK (user_id>=0),
+  CHECK (topic_id>=0)
+);
+
 /* Table: phpbb_topics_watch */
 CREATE TABLE phpbb_topics_watch (
   topic_id INT4  DEFAULT '0' NOT NULL,
@@ -1147,6 +1158,7 @@ CREATE TABLE phpbb_users (
    user_email_hash INT8 DEFAULT '0' NOT NULL,
    user_birthday varchar(10) DEFAULT '' NOT NULL,
    user_lastvisit INT4 DEFAULT '0' NOT NULL,
+   user_lastmark INT4 DEFAULT '0' NOT NULL,
    user_lastpost_time INT4 DEFAULT '0' NOT NULL,
    user_lastpage varchar(100) DEFAULT '' NOT NULL,
    user_last_confirm_key varchar(10) DEFAULT '' NOT NULL,
-- 
cgit v1.2.1

