Index: openacs-4/packages/forums/sql/oracle/forums-reading-info-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-reading-info-create.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/sql/oracle/forums-reading-info-create.sql	1 Jun 2007 15:56:57 -0000	1.1
@@ -0,0 +1,50 @@
+--
+-- The Forums Package
+--
+-- @author David Arroyo darroyo@innova.uned.es
+-- @creation-date 01-06-2007
+-- @version $Id: forums-reading-info-create.sql,v 1.1 2007/06/01 15:56:57 davidam Exp $
+--
+-- This is free software distributed under the terms of the GNU Public
+-- License version 2 or later.  Full text of the license is available from the GNU Project:
+-- http://www.fsf.org/copyleft/gpl.html
+
+
+-- Tables to reading information
+
+
+create table forums_reading_info (
+    root_message_id integer
+                    constraint forums_read_i_parent_id_fk
+                    references forums_messages (message_id)
+                    on delete cascade,
+    user_id         integer
+                    constraint forums_read_i_user_id_fk
+                    references users(user_id)
+                    constraint forums_read_i_user_id_nn
+                    not null,
+    reading_date    date
+                    default sysdate
+                    constraint forums_read_i_datetime_nn
+                    not null,
+		constraint forums_reading_info_pk primary key (root_message_id,user_id)
+);
+create index forums_reading_info_user_index on forums_reading_info (user_id);
+create index forums_reading_info_forum_idx on forums_reading_info (root_message_id);
+
+create table forums_reading_info_user (
+    forum_id        integer
+                    constraint forums_read_iu_forum_id_fk
+                    references forums_forums (forum_id) on delete cascade,
+    user_id         integer
+                    constraint forums_read_iu_user_id_fk
+                    references users(user_id) on delete cascade
+                    constraint forums_read_iu_user_id_nn
+                    not null,
+    threads_read    integer 
+                    default 0 
+                    not null,
+    constraint forums_reading_info_user_pk primary key (forum_id,user_id)  
+);
+
+
Index: openacs-4/packages/forums/sql/oracle/forums-reading-info-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-reading-info-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/sql/oracle/forums-reading-info-drop.sql	1 Jun 2007 15:59:02 -0000	1.1
@@ -0,0 +1,18 @@
+--
+-- The Forums Package
+--
+-- @author David Arroyo darroyo@innova.uned.es
+-- @creation-date 01-06-2007
+-- @version $Id: forums-reading-info-drop.sql,v 1.1 2007/06/01 15:59:02 davidam Exp $
+--
+-- This is free software distributed under the terms of the GNU Public
+-- License version 2 or later.  Full text of the license is available from the GNU Project:
+-- http://www.fsf.org/copyleft/gpl.html
+
+
+-- Tables to reading information
+
+drop table forums_reading_info_user;
+drop index forums_reading_info_forum_idx;
+drop index forums_reading_info_user_index;
+drop table forums_reading_info;
\ No newline at end of file