Index: openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql	28 Jan 2004 09:39:33 -0000	1.10
+++ openacs-4/packages/workflow/sql/postgresql/upgrade/upgrade-1.2-2.0d1.sql	29 Jan 2004 11:10:55 -0000	1.11
@@ -43,8 +43,8 @@
 update workflow_deputies set start_date = start_date_old, end_date = end_date_old;
 alter table workflow_deputies alter column start_date set not null;
 alter table workflow_deputies alter column end_date set not null;
-alter table workflow_deputies drop column start_date_old;
-alter table workflow_deputies drop column end_date_old;
+alter table workflow_deputies drop column start_date_old cascade;
+alter table workflow_deputies drop column end_date_old cascade;
 
 -- adding foreign key/cascade and start/end date indices
 create index workflow_deputies_deputy_idx on workflow_deputies(deputy_user_id);