Index: openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql,v diff -u -N -r1.5 -r1.6 --- openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql 28 Sep 2003 01:24:26 -0000 1.5 +++ openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql 30 Oct 2003 11:14:47 -0000 1.6 @@ -148,6 +148,8 @@ constraint wf_acns_pretty_name_nn not null, pretty_past_tense varchar(200), + description clob, + description_mime_type varchar2(200) default 'text/plain', edit_fields varchar(4000), assigned_role constraint wf_acns_assigned_role_fk references workflow_roles(role_id) Index: openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.1d1-1.2d1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.1d1-1.2d1.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.1d1-1.2d1.sql 30 Oct 2003 11:14:47 -0000 1.1 @@ -0,0 +1,13 @@ +-- +-- Upgrade script +-- +-- Adds useful views +-- +-- @author Lars Pind (lars@collaboraid.biz) +-- +-- @cvs-id $Id: upgrade-1.1d1-1.2d1.sql,v 1.1 2003/10/30 11:14:47 joela Exp $ + +alter table workflow_actions add ( + description clob, + description_mime_type varchar2(200) default 'text/plain' +); 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.13 -r1.14 --- openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql 3 Oct 2003 10:12:46 -0000 1.13 +++ openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql 30 Oct 2003 11:14:47 -0000 1.14 @@ -158,6 +158,8 @@ constraint wf_acns_pretty_name_nn not null, pretty_past_tense varchar(200), + description text, + description_mime_type varchar(200) default 'text/plain', edit_fields varchar(4000), assigned_role integer constraint wf_acns_assigned_role_fk Index: openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.1d1-1.2d1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.1d1-1.2d1.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.1d1-1.2d1.sql 30 Oct 2003 11:14:47 -0000 1.1 @@ -0,0 +1,17 @@ +-- +-- Upgrade script +-- +-- Adds useful views +-- +-- @author Lars Pind (lars@collaboraid.biz) +-- +-- @cvs-id $Id: upgrade-1.1d1-1.2d1.sql,v 1.1 2003/10/30 11:14:47 joela Exp $ + +alter table workflow_actions + add description text; + +alter table workflow_actions + add description_mime_type varchar(200); + +alter table workflow_actions + alter column description_mime_type set default 'text/plain';