Index: openacs-4/packages/dotlrn/sql/postgresql/classes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/classes-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/dotlrn/sql/postgresql/classes-create.sql	9 Aug 2002 18:39:25 -0000	1.4
+++ openacs-4/packages/dotlrn/sql/postgresql/classes-create.sql	29 May 2003 18:05:00 -0000	1.5
@@ -63,7 +63,7 @@
                                 constraint dotlrn_t_start_date_nn
                                 not null,
     end_date                    date
-                                default (now() + '180 days'::timespan)
+                                default (now() + '180 days'::interval)
                                 constraint dotlrn_t_end_date_nn
                                 not null
 );
@@ -161,7 +161,7 @@
 select define_function_args ('dotlrn_department__delete', 'department_key');
 
 
-create function dotlrn_department__new(varchar,varchar,varchar,varchar,integer,timestamp,integer,varchar,integer)
+create function dotlrn_department__new(varchar,varchar,varchar,varchar,integer,timestamptz,integer,varchar,integer)
 returns varchar as '
 DECLARE
         p_department_key                    alias for $1;
@@ -217,7 +217,7 @@
 select define_function_args('dotlrn_class__delete','class_key');
 
 
-create function dotlrn_class__new(varchar,varchar,varchar,varchar,varchar,integer,timestamp,integer,varchar,integer)
+create function dotlrn_class__new(varchar,varchar,varchar,varchar,varchar,integer,timestamptz,integer,varchar,integer)
 returns varchar as '
 DECLARE
         p_class_key                     alias for $1;
@@ -275,7 +275,7 @@
 select define_function_args('dotlrn_class_instance__delete','class_instance_id');
 
 
-create function dotlrn_class_instance__new(integer,varchar,integer,varchar,varchar,varchar,integer,integer,integer,varchar,timestamp,integer,varchar,integer)
+create function dotlrn_class_instance__new(integer,varchar,integer,varchar,varchar,varchar,integer,integer,integer,varchar,timestamptz,integer,varchar,integer)
 returns integer as '
 DECLARE
         p_class_instance_id                        alias for $1;
