Index: openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql	21 Dec 2002 22:31:17 -0000	1.10
+++ openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql	17 May 2003 01:47:10 -0000	1.11
@@ -269,39 +269,7 @@
 -- PARTY PACKAGE --
 -------------------
 
--- create or replace package party
--- as
--- 
---  function new (
---   party_id	in parties.party_id%TYPE default null,
---   object_type	in acs_objects.object_type%TYPE
--- 		   default 'party',
---   creation_date	in acs_objects.creation_date%TYPE
--- 		   default sysdate,
---   creation_user	in acs_objects.creation_user%TYPE
--- 		   default null,
---   creation_ip	in acs_objects.creation_ip%TYPE default null,
---   email		in parties.email%TYPE,
---   url		in parties.url%TYPE default null,
---   context_id	in acs_objects.context_id%TYPE default null
---  ) return parties.party_id%TYPE;
--- 
---  procedure delete (
---   party_id	in parties.party_id%TYPE
---  );
--- 
---  function name (
---   party_id	in parties.party_id%TYPE
---  ) return varchar2;
--- 
--- end party;
-
--- show errors
-
-
--- create or replace package body party
--- function new
-create function party__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,integer)
+create function party__new (integer,varchar,timestamptz,integer,varchar,varchar,varchar,integer)
 returns integer as '
 declare
   new__party_id               alias for $1;  -- default null  
@@ -327,8 +295,6 @@
   
 end;' language 'plpgsql';
 
-
--- procedure delete
 create function party__delete (integer)
 returns integer as '
 declare
@@ -339,8 +305,6 @@
   return 0; 
 end;' language 'plpgsql';
 
-
--- function name
 create function party__name (integer)
 returns varchar as '
 declare
@@ -354,8 +318,6 @@
   
 end;' language 'plpgsql';
 
-
--- function email
 create function party__email (integer)
 returns varchar as '
 declare
@@ -371,7 +333,6 @@
   
 end;' language 'plpgsql';
 
-
 -- show errors
 
 -------------
@@ -430,7 +391,7 @@
 -- create or replace package body person
 -- function new
 select define_function_args('person__new','person_id,object_type;person,creation_date;now(),creation_user,creation_ip,email,url,first_names,last_name,context_id');
-create function person__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,varchar,varchar,integer)
+create function person__new (integer,varchar,timestamptz,integer,varchar,varchar,varchar,varchar,varchar,integer)
 returns integer as '
 declare
   new__person_id              alias for $1;  -- default null  
@@ -542,9 +503,9 @@
 	priv_email		integer default 5 not null,
 	email_verified_p	boolean default 't',
 	email_bouncing_p	boolean default 'f' not null,
-	no_alerts_until		timestamp,
-	last_visit		timestamp,
-	second_to_last_visit	timestamp,
+	no_alerts_until		timestamptz,
+	last_visit		timestamptz,
+	second_to_last_visit	timestamptz,
 	n_sessions		integer default 1 not null,
 	password_question	varchar(1000),
 	password_answer		varchar(1000)
@@ -667,7 +628,7 @@
 select define_function_args('user__new','user_id,object_type;user,creation_date;now(),creation_user,creation_ip,email,url,first_names,last_name,password,salt,password_question,password_answer,screen_name,email_verified_p;t,context_id');
 
 
-create function acs_user__new (integer,varchar,timestamp with time zone,integer,varchar,varchar,varchar,varchar,varchar,char,char,varchar,varchar,varchar,boolean,integer)
+create function acs_user__new (integer,varchar,timestamptz,integer,varchar,varchar,varchar,varchar,varchar,char,char,varchar,varchar,varchar,boolean,integer)
 returns integer as '
 declare
   new__user_id                  alias for $1;  -- default null