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 -r1.6 -r1.7 --- openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql 30 Oct 2003 11:14:47 -0000 1.6 +++ openacs-4/packages/workflow/sql/oracle/workflow-tables-create.sql 13 Nov 2003 14:22:03 -0000 1.7 @@ -67,6 +67,8 @@ constraint wfs_object_type_fk references acs_object_types(object_type) on delete cascade, + description clob, + description_mime_type varchar2(200) default 'text/plain', constraint wfs_oid_sn_un unique (package_key, object_id, short_name) ); Index: openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2d1.1.2d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2d1.1.2d2.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/workflow/sql/oracle/upgrade/upgrade-1.2d1.1.2d2.sql 13 Nov 2003 14:22:03 -0000 1.1 @@ -0,0 +1,13 @@ +-- +-- Upgrade script +-- +-- Adds new fields to workflows +-- +-- @author Lars Pind (lars@collaboraid.biz) +-- +-- @cvs-id $Id: upgrade-1.2d1.1.2d2.sql,v 1.1 2003/11/13 14:22:03 joela Exp $ + +alter table workflows 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 -r1.14 -r1.15 --- openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql 30 Oct 2003 11:14:47 -0000 1.14 +++ openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql 13 Nov 2003 14:22:03 -0000 1.15 @@ -66,6 +66,8 @@ constraint wfs_object_type_fk references acs_object_types(object_type) on delete cascade, + description text, + description_mime_type varchar(200) default 'text/plain', constraint wfs_oid_sn_un unique (package_key, object_id, short_name) ); Index: openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2d1-1.2d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2d1-1.2d2.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2d1-1.2d2.sql 13 Nov 2003 14:22:03 -0000 1.1 @@ -0,0 +1,17 @@ +-- +-- Upgrade script +-- +-- Adds fields to workflows +-- +-- @author Lars Pind (lars@collaboraid.biz) +-- +-- @cvs-id $Id: upgrade-1.2d1-1.2d2.sql,v 1.1 2003/11/13 14:22:03 joela Exp $ + +alter table workflows + add description text; + +alter table workflows + add description_mime_type varchar(200); + +alter table workflows + alter column description_mime_type set default 'text/plain';