Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-core-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-core-create.sql	9 Apr 2001 23:13:49 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-core-create.sql	13 Apr 2001 00:29:01 -0000	1.2
@@ -20,7 +20,7 @@
 create function inline_0 ()
 returns integer as '
 begin
-    select acs_object_type__create_type (
+    PERFORM acs_object_type__create_type (
 	''workflow'',
 	''Workflow'',
 	''Workflow'',
@@ -121,7 +121,7 @@
 			check (direction in ('','in','out')),
   /* Must be satisfied for the arc to be traveled by a token
    * This is the name of a PL/SQL function to execute, which must return t or f
-   * Signature: (case_id in number, workflow_key in varchar, transition_key in varchar2, 
+   * Signature: (case_id in integer, workflow_key in varchar, transition_key in varchar2, 
    *             place_key in varchar, direction in varchar2, custom_arg in varchar2) 
    * return char(1)
    */
@@ -225,7 +225,7 @@
 
 
 
-*
+/*
  * Contexts 
  */
 
@@ -249,7 +249,11 @@
   the call-backs, etc.
 ';
 
-* Insert a default context that all new cases will use if nothing else is defined */
+/*
+ * Insert a default context that all new cases will use if nothing else 
+ * is defined 
+ */
+
 insert into wf_contexts (context_key, context_name) values ('default', 'Default Context');
 
 commit;
@@ -264,11 +268,11 @@
 			  	references wf_workflows,
   transition_key          	varchar(100) default '' not null,
   /* information for the transition in the context */
-  /* The number of minutes this task is estimated to take */
+  /* The integer of minutes this task is estimated to take */
   estimated_minutes		integer,
   /*
    * Will be called when the transition is enabled/fired.
-   * signature: (case_id in number, transition_key in varchar, custom_arg in varchar2)
+   * signature: (case_id in integer, transition_key in varchar, custom_arg in varchar2)
    */
   enable_callback         	varchar(100) default '' not null,
   enable_custom_arg       	text default '' not null,
@@ -277,21 +281,21 @@
   /* 
    * Must insert rows into the wf_task_assignments table.
    * Will be called when the transition becomes enabled
-   * signature: (task_id in number, custom_arg in varchar)
+   * signature: (task_id in integer, custom_arg in varchar)
    */
   assignment_callback     	varchar(100) default '' not null,
   assignment_custom_arg   	text default '' not null,
   /* 
    * Must return the date that the timed transition should fire
    * Will be called when the transition is enabled
-   * signature: (case_id in number, transition_key in varchar, custom_arg in varchar2) return date
+   * signature: (case_id in integer, transition_key in varchar, custom_arg in varchar2) return date
    */
   time_callback           	varchar(100) default '' not null,
   time_custom_arg         	text default '' not null,
   /*
    * Returns the deadline for this task.
    * Will be called when the transition becomes enabled
-   * Signature: (case_id in number, transition_key in varchar, custom_arg in varchar2) return date
+   * Signature: (case_id in integer, transition_key in varchar, custom_arg in varchar2) return date
    */
   deadline_callback       	varchar(100) default '' not null,
   deadline_custom_arg     	text default '' not null,
@@ -300,15 +304,15 @@
   /*
    * Must return the date that the user's hold on the task times out.
    * called when the user starts the task.
-   * signature: (case_id in number, transition_key in varchar, custom_arg in varchar2) return date
+   * signature: (case_id in integer, transition_key in varchar, custom_arg in varchar2) return date
    */
   hold_timeout_callback   	varchar(100) default '' not null,
   hold_timeout_custom_arg 	text default '' not null,
   /* 
    * Notification callback
    * Will be called when a notification is sent i.e., when a transition is enabled,
    * or assignment changes.
-   * signature: (task_id 	in number, 
+   * signature: (task_id 	in integer, 
    *             custom_arg 	in varchar, 
    *             party_to 	in integer, 
    *             party_from 	in out integer, 
@@ -320,7 +324,7 @@
   /*
    * Unassigned callback
    * Will be called whenever a task becomes unassigned
-   * Signature: (case_id in number, transition_key in varchar, custom_arg in varchar2)
+   * Signature: (case_id in integer, transition_key in varchar, custom_arg in varchar2)
    */
   unassigned_callback       varchar(100) default '' not null,
   unassigned_custom_arg     text default '' not null,
@@ -622,7 +626,7 @@
 ';
 
 
-* Should evetually be done by acs_objects automatically */
+/* Should evetually be done by acs_objects automatically */
 
 create table wf_attribute_value_audit (
   case_id		integer
@@ -649,7 +653,7 @@
 ';
 
 
-*
+/*
  * This is the cartesian product of transitions and contexts.
  * We need this in order to compute the following wf_transition_info view,
  * because Oracle won't let us outer join against more than one table.
@@ -666,7 +670,7 @@
 
 
 
-*
+/*
  * Returns all the information stored about a certain transition
  * in all contexts. You'll usually want to use this with a 
  * "where context = " clause.
@@ -704,7 +708,7 @@
 
 
 
-*
+/*
  * This view makes it easy to get the input/output places of a transition
  */
 create view wf_transition_places as
@@ -724,7 +728,7 @@
 and    p.workflow_key   = a.workflow_key;
 
 
-*
+/*
  * This view returns information about all currently enabled transitions.
  * It does not include transitions that are started. This information, along
  * with additional, dynamic information, such as the user assignment or the 
@@ -787,12 +791,12 @@
 
 
 
-*
+/*
  * This view joins wf_tasks with the parties data model to figure out who can perform the tasks.
  * It should contain one row per ( user x task )
  */
 
-* Replaced 'unique' with 'distinct', because Stas had problems with Oracle behaving mysteriously */
+/* Replaced 'unique' with 'distinct', because Stas had problems with Oracle behaving mysteriously */
 
 create view wf_user_tasks as
 select distinct ta.task_id, 
