Index: openacs-4/packages/sloan-bboard/sql/oracle/bboard-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/sloan-bboard/sql/oracle/bboard-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/sloan-bboard/sql/oracle/bboard-create.sql	18 Feb 2002 20:56:18 -0000	1.2
+++ openacs-4/packages/sloan-bboard/sql/oracle/bboard-create.sql	23 Feb 2002 16:23:51 -0000	1.3
@@ -138,10 +138,13 @@
             not null
         constraint bboard_forums_moderated_p_ck
             check (moderated_p in ('t','f')),
-    format  varchar(200) default 'q-and-a' 
-        constraint bboard_forums_format_nn not null
-        constraint bboard_forums_format_ck
-                   check (format in ('q-and-a','thread')),
+    forum_type  varchar(200) default 'q-and-a' 
+        constraint bboard_forums_forum_type_nn not null
+        constraint bboard_forums_forum_type_ck
+                   check (forum_type in ('q-and-a','thread')),
+    track_new_postings_p   char(1) default 'f'
+        constraint bboard_forums_track_new_ck
+                   check (track_new_postings_p in ('t','f')),
     bboard_id integer
         constraint bboard_forums_bboard_id_nn
             not null
@@ -177,6 +180,24 @@
 create index bboard_fmm_status_idx
     on bboard_forum_message_map (status);
 
+--
+-- For tracking individual views on messages
+-- (This is a client request, but I still think this will be problematic - ben)
+--
+create table bboard_message_user_map (
+       message_id integer
+          constraint bboard_mum_message_id_fk
+            references acs_messages (message_id)
+            on delete cascade,
+       user_id integer
+          constraint bboard_mum_user_id_fk
+            references users (user_id)
+            on delete cascade,
+       view_date date default sysdate
+          constraint bboard_mum_view_date_nn
+          not null
+);
+
 -- bboard categories
 --
 -- these are for intra-forum categorization