Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql,v diff -u -r1.5.4.1 -r1.5.4.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql 21 Jan 2003 13:45:03 -0000 1.5.4.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-update.sql 1 Mar 2003 21:21:20 -0000 1.5.4.2 @@ -167,8 +167,8 @@ references cr_items constraint cr_release_periods_pk primary key, - start_when timestamp default now(), - end_when timestamp default now() + interval ''20 years'' + start_when timestamptz default current_timestamp, + end_when timestamptz default current_timestamp + interval ''20 years'' )''; end if; @@ -179,7 +179,7 @@ execute '' create table cr_scheduled_release_log ( - exec_date timestamp default now() not null, + exec_date timestamptz default current_timestamp not null, items_released integer not null, items_expired integer not null, err_num integer, @@ -195,7 +195,7 @@ execute '' create table cr_scheduled_release_job ( job_id integer, - last_exec timestamp + last_exec timestamptz )''; execute ''