Index: openacs-4/contrib/packages/events/sql/postgresql/events-events-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/sql/postgresql/events-events-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/packages/events/sql/postgresql/events-events-create.sql 9 Mar 2003 12:07:30 -0000 1.1 +++ openacs-4/contrib/packages/events/sql/postgresql/events-events-create.sql 18 Mar 2003 00:42:25 -0000 1.2 @@ -193,7 +193,7 @@ contact_user_id integer constraint events_cntct_usr_id_fk references users, - reg_deadline timestamp not null, + reg_deadline timestamptz not null, available_p boolean default 't', deleted_p boolean default 'f', reg_cancellable_p boolean default 't', Index: openacs-4/contrib/packages/events/sql/postgresql/events-orders-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/sql/postgresql/events-orders-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/packages/events/sql/postgresql/events-orders-create.sql 9 Mar 2003 12:07:30 -0000 1.1 +++ openacs-4/contrib/packages/events/sql/postgresql/events-orders-create.sql 18 Mar 2003 00:42:25 -0000 1.2 @@ -52,10 +52,10 @@ references users, paid_p boolean default null, payment_method varchar(50), - confirmed_date timestamp, + confirmed_date timestamptz, price_charged numeric, -- the date this registration was refunded, if it was refunded - refunded_date timestamp, + refunded_date timestamptz, price_refunded numeric ); Index: openacs-4/contrib/packages/events/sql/postgresql/events-prices-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/sql/postgresql/events-prices-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/packages/events/sql/postgresql/events-prices-create.sql 9 Mar 2003 12:07:30 -0000 1.1 +++ openacs-4/contrib/packages/events/sql/postgresql/events-prices-create.sql 18 Mar 2003 00:42:25 -0000 1.2 @@ -32,8 +32,8 @@ -- prices may be different for early, normal, late, on-site -- admission, -- depending on the date - expire_date timestamp not null, - available_date timestamp not null + expire_date timestamptz not null, + available_date timestamptz not null ); create index evnt_price_idx on events_prices(price_id, event_id); Index: openacs-4/contrib/packages/events/sql/postgresql/events-registrations-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/sql/postgresql/events-registrations-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/packages/events/sql/postgresql/events-registrations-create.sql 9 Mar 2003 12:07:30 -0000 1.1 +++ openacs-4/contrib/packages/events/sql/postgresql/events-registrations-create.sql 18 Mar 2003 00:42:25 -0000 1.2 @@ -240,7 +240,7 @@ -- reg_date date, -- when the registration was approved - approval_date timestamp, + approval_date timestamptz, -- org varchar(500), -- title_at_org varchar(500), -- attending_reason text,