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,