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.5 -r1.5.4.1
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-core-create.sql	19 Nov 2001 18:20:33 -0000	1.5
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/wf-core-create.sql	2 Mar 2003 22:36:45 -0000	1.5.4.1
@@ -577,7 +577,7 @@
 			on delete cascade,
   workflow_key          varchar(100),
   transition_key        varchar(100),
-  deadline		timestamp
+  deadline		timestamptz
 			constraint wf_case_deadline_nn
 			not null,
   -- table constraints --
@@ -617,21 +617,21 @@
 			constraint wf_task_state_ck
 			check (state in ('enabled','started','canceled',
                                          'finished','overridden')),
-  enabled_date          timestamp default now(),
-  started_date          timestamp,
-  canceled_date         timestamp,
-  finished_date         timestamp,
-  overridden_date       timestamp,
+  enabled_date          timestamptz default now(),
+  started_date          timestamptz,
+  canceled_date         timestamptz,
+  finished_date         timestamptz,
+  overridden_date       timestamptz,
   /* -- TIME transition info */
-  trigger_time          timestamp,
+  trigger_time          timestamptz,
   /* -- USER transition info */
-  deadline              timestamp,
+  deadline              timestamptz,
   estimated_minutes	integer,
   holding_user          integer
 			constraint wf_task_holding_user_fk
 			references users(user_id)
 			on delete cascade,
-  hold_timeout          timestamp,
+  hold_timeout          timestamptz,
   -- table constraints --
   constraint wf_task_transition_fk
     foreign key (workflow_key, transition_key) references wf_transitions(workflow_key, transition_key)
@@ -687,10 +687,10 @@
 			constraint wf_token_task_fk
 			references wf_tasks(task_id),
   -- info on state changes
-  produced_date         timestamp default now(),
-  locked_date           timestamp,
-  canceled_date		timestamp,
-  consumed_date         timestamp,
+  produced_date         timestamptz default current_timestamp,
+  locked_date           timestamptz,
+  canceled_date		timestamptz,
+  consumed_date         timestamptz,
   produced_journal_id   integer
 			constraint wf_token_produced_journal_fk
 			references journal_entries(journal_id),
