Index: openacs-4/packages/address-book/sql/postgresql/address-book-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/address-book/sql/postgresql/address-book-create.sql,v diff -u -N -r1.4 -r1.5 --- openacs-4/packages/address-book/sql/postgresql/address-book-create.sql 2 Sep 2001 17:06:29 -0000 1.4 +++ openacs-4/packages/address-book/sql/postgresql/address-book-create.sql 17 May 2003 10:10:13 -0000 1.5 @@ -154,7 +154,7 @@ -- type_key integer, -- ab_contact_attr_types.type_id%TYPE varchar, -- acs_objects.object_type%TYPE - timestamp, -- acs_objects.creation_date%TYPE + timestamptz, -- acs_objects.creation_date%TYPE integer, -- acs_objects.creation_user%TYPE varchar, -- acs_objects.creation_ip%TYPE integer, -- acs_objects.context_id%TYPE @@ -356,7 +356,7 @@ -- before_attr_id in ab_contact_attrs.attr_id%TYPE integer, -- ab_contact_attrs.attr_id%TYPE varchar, -- acs_objects.object_type%TYPE - timestamp, -- acs_objects.creation_date%TYPE + timestamptz, -- acs_objects.creation_date%TYPE integer, -- acs_objects.creation_user%TYPE varchar, -- acs_objects.creation_ip%TYPE integer, -- acs_objects.context_id%TYPE @@ -596,7 +596,7 @@ -- category integer, -- ab_contacts.contact_id%TYPE default null, varchar, -- acs_objects.object_type%TYPE - timestamp, -- acs_objects.creation_date%TYPE + timestamptz, -- acs_objects.creation_date%TYPE integer, -- acs_objects.creation_user%TYPE varchar, -- acs_objects.creation_ip%TYPE integer, -- acs_objects.context_id%TYPE