Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v
diff -u -r1.36 -r1.37
--- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql	31 Jan 2003 14:02:24 -0000	1.36
+++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql	17 May 2003 01:47:10 -0000	1.37
@@ -267,7 +267,7 @@
 		       constraint apm_package_vers_desc_for_ck
 		         check (description_format in ('text/html', 'text/plain')),
     description        text,
-    release_date       timestamp,
+    release_date       timestamptz,
     vendor             varchar(500),
     vendor_uri         varchar(1500),
     enabled_p          boolean default 'f'
@@ -281,8 +281,8 @@
     data_model_loaded_p boolean default 'f'
                        constraint apm_package_vers_dml_p_nn not null,
     cvs_import_results text,
-    activation_date    timestamp,
-    deactivation_date  timestamp,
+    activation_date    timestamptz,
+    deactivation_date  timestamptz,
     -- FIXME: store the tarball in the content-repository
     -- distribution_tarball blob,
     item_id            integer,
@@ -292,8 +292,8 @@
                        -- references cr_items(item_id),
     content_length     integer,
     distribution_uri   varchar(1500),
-    distribution_date  timestamp,
-    auto_mount         varchar(50),
+    distribution_date  timestamptz,
+    auto_mount         varchar(50) default null,
     constraint apm_package_vers_id_name_un unique(package_key, version_name)
 );
 
@@ -1669,7 +1669,7 @@
 
 
 -- function new
-create function apm_package__new (integer,varchar,varchar,varchar,timestamp with time zone,integer,varchar,integer)
+create function apm_package__new (integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer)
 returns integer as '
 declare
   new__package_id             alias for $1;  -- default null  
@@ -1897,7 +1897,7 @@
 end;' language 'plpgsql';
 
 -- create or replace package body apm_package_version 
-create function apm_package_version__new (integer,varchar,varchar,varchar,varchar,varchar,varchar,timestamp with time zone,varchar,varchar,varchar,boolean,boolean) returns integer as '
+create function apm_package_version__new (integer,varchar,varchar,varchar,varchar,varchar,varchar,timestamptz,varchar,varchar,varchar,boolean,boolean) returns integer as '
 declare
       apm_pkg_ver__version_id           alias for $1;  -- default null
       apm_pkg_ver__package_key		alias for $2;
@@ -2054,7 +2054,7 @@
 
 
 -- function edit
-create function apm_package_version__edit (integer,integer,varchar,varchar,varchar,varchar,varchar,timestamp with time zone,varchar,varchar,varchar,boolean,boolean)
+create function apm_package_version__edit (integer,integer,varchar,varchar,varchar,varchar,varchar,timestamptz,varchar,varchar,varchar,boolean,boolean)
 returns integer as '
 declare
   edit__new_version_id         alias for $1;  -- default null  
@@ -2600,7 +2600,7 @@
 
 
 -- function new
-create function apm_application__new (integer,varchar,varchar,varchar,timestamp with time zone,integer,varchar,integer)
+create function apm_application__new (integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer)
 returns integer as '
 declare
   application_id         alias for $1;  -- default null  
@@ -2650,7 +2650,7 @@
 
 -- create or replace package body apm_service
 -- function new
-create function apm_service__new (integer,varchar,varchar,varchar,timestamp with time zone,integer,varchar,integer)
+create function apm_service__new (integer,varchar,varchar,varchar,timestamptz,integer,varchar,integer)
 returns integer as '
 declare
   service_id             alias for $1;  -- default null