Index: openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql	4 Feb 2003 09:44:48 -0000	1.7
+++ openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql	12 Feb 2003 14:22:35 -0000	1.8
@@ -425,45 +425,20 @@
 -- Case level, Activity Log
 ---------------------------------
 
---begin;
---    select content_type__create_type (
---        'workflow_activity_log', -- content_type
---	'content_revision',      -- supertype
---	'Workflow Activity Log', -- pretty_name
---	'Workflow Activity Log', -- pretty_plural
---	'workflow_case_log',     -- table_name
---	'entry_id'              -- id_column
---    );
---end;
-
-
-create sequence workflow_case_log_seq;
-
 create table workflow_case_log (
   entry_id                integer
                           constraint wf_case_log_pk
-                          primary key,
+                          primary key
+                          constraint wf_case_log_cr_items_fk 
+                          references cr_items(item_id),
   case_id                 integer
                           constraint wf_case_log_case_id_fk 
                           references workflow_cases(case_id)
                           on delete cascade,
   action_id               integer
                           constraint wf_case_log_acn_id_fk
                           references workflow_actions(action_id)
-                          on delete cascade,
-  user_id                 integer
-                          constraint workflow_case_log_user_id_fk
-                          references users(user_id)
-                          on delete cascade,
-  action_date             timestamp
-                          constraint workflow_case_log_acn_date_nn
-                          not null 
-                          default now(),
-  comment                 text,
-  comment_format          varchar(50) 
-                          default 'text/plain'
-                          constraint wf_clog_comment_format_nn
-                          not null
+                          on delete cascade
 );
 
 create table workflow_case_log_data (
@@ -479,3 +454,12 @@
   primary key (entry_id, key)
 );
 
+select content_type__create_type (
+  'workflow_case_log_entry',         -- content_type
+  'content_revision',                -- supertype
+  'Workflow Case Log Entry',         -- pretty_name
+  'Workflow Case Log Entries',       -- pretty_plural
+  'workflow_case_log_rev',           -- table_name
+  'entry_rev_id',                    -- id_column
+  null                               -- name_method
+);