Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql,v
diff -u -N -r1.2 -r1.2.4.1
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql	13 Aug 2001 21:32:05 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql	2 Mar 2003 22:55:37 -0000	1.2.4.1
@@ -89,7 +89,7 @@
                         constraint ttl_tickets_status_fk
                         references ttl_status,
   url                   varchar(400),
-  deadline              timestamp,
+  deadline              timestamptz,
   message               text,
   message_format        varchar(10) default 'formatted'
                         constraint ttl_tickets_message_format_ck
@@ -112,7 +112,7 @@
                         references users
                         constraint ttl_comments_user_nn
                         not null, 
-  creation_date         timestamp default current_timestamp,
+  creation_date         timestamptz default current_timestamp,
   message               text,
   message_format        varchar(10) default 'formatted'
                         constraint ttl_comments_message_format_ck
@@ -128,7 +128,7 @@
                         references users,
   constraint ttl_assignments_pk
   primary key(ticket_id, user_id),
-  date_assigned         timestamp default current_timestamp
+  date_assigned         timestamptz default current_timestamp
 );
 
 create table ttl_area_assignments (
@@ -140,7 +140,7 @@
                         references users,
   constraint ttl_area_assignments_pk
   primary key(area_id, user_id),
-  date_assigned         timestamp default current_timestamp
+  date_assigned         timestamptz default current_timestamp
 );
 
 create table ttl_prefs (