Index: openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-create.sql,v diff -u -r1.2 -r1.2.4.1 --- openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-create.sql 9 Jul 2001 16:18:59 -0000 1.2 +++ openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-create.sql 2 Mar 2003 22:55:03 -0000 1.2.4.1 @@ -111,7 +111,7 @@ references persons(person_id) constraint ttkr_tkt_creation_user_nn not null, - creation_date timestamp default current_timestamp + creation_date timestamptz default current_timestamp constraint ttkr_tkt_date_nn not null, subject varchar(1000) Index: openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-drop.sql,v diff -u -r1.2 -r1.2.4.1 --- openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-drop.sql 9 Jul 2001 16:18:59 -0000 1.2 +++ openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-drop.sql 2 Mar 2003 22:55:03 -0000 1.2.4.1 @@ -69,7 +69,7 @@ drop function ttracker_callback__notification (integer,varchar,integer,integer,varchar,varchar); drop function ttracker_callback__notify_admin (integer,varchar); -drop function ttracker_category__new (integer,integer,varchar,timestamp,integer,varchar,integer,varchar,integer,varchar); +drop function ttracker_category__new (integer,integer,varchar,timestamptz,integer,varchar,integer,varchar,integer,varchar); drop function ttracker_category__delete (integer); drop function ttracker_category__name (integer); @@ -78,7 +78,7 @@ drop function ttracker_option__option_name (integer,varchar,integer); drop function ttracker_option__option_value (integer,varchar,varchar); -drop function ttracker_ticket__new (integer,varchar,integer,varchar,varchar,varchar,integer,integer,integer,timestamp,integer,varchar); +drop function ttracker_ticket__new (integer,varchar,integer,varchar,varchar,varchar,integer,integer,integer,timestamptz,integer,varchar); drop function ttracker_ticket__delete (integer); drop function ttracker_ticket__name (integer); drop function ttracker_ticket__id_valid_p (integer,integer); Index: openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql,v diff -u -r1.11 -r1.11.4.1 --- openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql 12 Feb 2002 01:35:16 -0000 1.11 +++ openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql 2 Mar 2003 22:55:03 -0000 1.11.4.1 @@ -18,7 +18,7 @@ -- Package: ttracker_ticket -create function ttracker_ticket__new (integer,varchar,integer,varchar,varchar,varchar,integer,integer,integer,timestamp,integer,varchar) +create function ttracker_ticket__new (integer,varchar,integer,varchar,varchar,varchar,integer,integer,integer,timestamptz,integer,varchar) returns integer as ' declare p_ticket_id alias for $1; -- default null @@ -176,7 +176,7 @@ -- Package: ttracker_category -create function ttracker_category__new (integer,integer,varchar,timestamp,integer,varchar,integer,varchar,integer,varchar) +create function ttracker_category__new (integer,integer,varchar,timestamptz,integer,varchar,integer,varchar,integer,varchar) returns integer as ' declare p_category_id alias for $1; -- default null Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql,v diff -u -r1.2 -r1.2.4.1 --- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql 13 Aug 2001 21:32:05 -0000 1.2 +++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-create.sql 2 Mar 2003 22:55:37 -0000 1.2.4.1 @@ -89,7 +89,7 @@ constraint ttl_tickets_status_fk references ttl_status, url varchar(400), - deadline timestamp, + deadline timestamptz, message text, message_format varchar(10) default 'formatted' constraint ttl_tickets_message_format_ck @@ -112,7 +112,7 @@ references users constraint ttl_comments_user_nn not null, - creation_date timestamp default current_timestamp, + creation_date timestamptz default current_timestamp, message text, message_format varchar(10) default 'formatted' constraint ttl_comments_message_format_ck @@ -128,7 +128,7 @@ references users, constraint ttl_assignments_pk primary key(ticket_id, user_id), - date_assigned timestamp default current_timestamp + date_assigned timestamptz default current_timestamp ); create table ttl_area_assignments ( @@ -140,7 +140,7 @@ references users, constraint ttl_area_assignments_pk primary key(area_id, user_id), - date_assigned timestamp default current_timestamp + date_assigned timestamptz default current_timestamp ); create table ttl_prefs ( Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-drop.sql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-drop.sql 28 May 2001 20:41:57 -0000 1.1 +++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/ticket-tracker-lite-drop.sql 2 Mar 2003 22:55:37 -0000 1.1.4.1 @@ -14,7 +14,7 @@ drop view ttl_v_comments_latest; drop view ttl_v_users; -drop function ttl_relative_date (timestamp); +drop function ttl_relative_date (timestamptz); drop function ttl_top_privilege_for_object (integer, integer); drop table ttl_prefs; Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql,v diff -u -r1.6 -r1.6.2.1 --- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql 19 Mar 2002 06:49:29 -0000 1.6 +++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql 2 Mar 2003 22:55:37 -0000 1.6.2.1 @@ -56,7 +56,7 @@ -- if the date is today, show just the time. Otherwise -- return the date. -- -create function ttl_relative_date (timestamp) +create function ttl_relative_date (timestamptz) returns varchar as ' declare relative_date alias for $1; Index: openacs-4/contrib/obsolete-packages/wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-create.sql,v diff -u -r1.3 -r1.3.4.1 --- openacs-4/contrib/obsolete-packages/wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-create.sql 4 Mar 2002 16:38:40 -0000 1.3 +++ openacs-4/contrib/obsolete-packages/wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-create.sql 2 Mar 2003 22:56:15 -0000 1.3.4.1 @@ -32,7 +32,7 @@ varchar, -- description in wf_tickets.description%TYPE, integer, -- severity in wf_tickets.severity%TYPE default 3, integer, -- priority in wf_tickets.priority%TYPE default 3, - timestamp, -- creation_date in acs_objects.creation_date%TYPE default sysdate, + timestamptz, -- creation_date in acs_objects.creation_date%TYPE default sysdate, integer, -- creation_user in acs_objects.creation_user%TYPE default null, varchar -- creation_ip in acs_objects.creation_ip%TYPE default null ) returns integer as ' @@ -45,7 +45,7 @@ new__creation_date alias for $6; new__creation_user alias for $7; new__creation_ip alias for $8; - v_creation_date timestamp; + v_creation_date timestamptz; v_ticket_id number; v_case_id number; begin @@ -107,4 +107,4 @@ from wf_tickets where ticket_id = name__ticket_id; return v_subject; - end;' language 'plpgsql'; \ No newline at end of file + end;' language 'plpgsql'; Index: openacs-4/packages/simple-survey/sql/postgresql/simple-survey-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simple-survey/sql/postgresql/simple-survey-create.sql,v diff -u -r1.5 -r1.5.2.1 --- openacs-4/packages/simple-survey/sql/postgresql/simple-survey-create.sql 19 Sep 2002 13:40:03 -0000 1.5 +++ openacs-4/packages/simple-survey/sql/postgresql/simple-survey-create.sql 2 Mar 2003 22:52:52 -0000 1.5.2.1 @@ -317,7 +317,7 @@ clob_answer text, number_answer numeric, varchar_answer text, - date_answer timestamp, + date_answer timestamptz, -- columns useful for attachments, column names -- lifted from file-storage.sql and bboard.sql -- this is where the actual content is stored Index: openacs-4/packages/spam/sql/postgresql/spam-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/spam/sql/postgresql/spam-create.sql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/packages/spam/sql/postgresql/spam-create.sql 4 Sep 2001 21:14:59 -0000 1.1 +++ openacs-4/packages/spam/sql/postgresql/spam-create.sql 2 Mar 2003 22:53:22 -0000 1.1.4.1 @@ -6,7 +6,7 @@ on delete cascade, -- date to send the spam out -- spam will be put in mail queue at that time - send_date timestamp not null, + send_date timestamptz not null, -- the sql query for selecting users. -- must be of the form "select party_id from ... where ..." sql_query varchar(4000) not null, Index: openacs-4/packages/spam/sql/postgresql/spam-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/spam/sql/postgresql/spam-drop.sql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/packages/spam/sql/postgresql/spam-drop.sql 4 Sep 2001 21:14:59 -0000 1.1 +++ openacs-4/packages/spam/sql/postgresql/spam-drop.sql 2 Mar 2003 22:53:22 -0000 1.1.4.1 @@ -12,10 +12,10 @@ ); -drop function spam__new (integer,varchar,timestamp,text,varchar,text,varchar,varchar,integer,timestamp,integer,varchar,varchar,boolean,varchar,timestamp); +drop function spam__new (integer,varchar,timestamptz,text,varchar,text,varchar,varchar,integer,timestamptz,integer,varchar,varchar,boolean,varchar,timestamptz); -drop function spam__edit (integer,text,varchar,varchar,varchar,timestamp); +drop function spam__edit (integer,text,varchar,varchar,varchar,timestamptz); -drop function spam__new_content (integer,timestamp,integer,varchar,varchar,varchar,varchar,integer); +drop function spam__new_content (integer,timestamptz,integer,varchar,varchar,varchar,varchar,integer); drop function spam__approve (integer); Index: openacs-4/packages/spam/sql/postgresql/spam-packages.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/spam/sql/postgresql/spam-packages.sql,v diff -u -r1.1.4.1 -r1.1.4.2 --- openacs-4/packages/spam/sql/postgresql/spam-packages.sql 21 Jan 2003 13:53:25 -0000 1.1.4.1 +++ openacs-4/packages/spam/sql/postgresql/spam-packages.sql 2 Mar 2003 22:53:22 -0000 1.1.4.2 @@ -2,7 +2,7 @@ -- -create function spam__new (integer,varchar,timestamp,text,varchar,text,varchar,varchar,integer,timestamp with time zone,integer,varchar,varchar,boolean,varchar,timestamp with time zone) +create function spam__new (integer,varchar,timestamptz,text,varchar,text,varchar,varchar,integer,timestamptz,integer,varchar,varchar,boolean,varchar,timestamptz) returns integer as ' declare p_spam_id alias for $1; -- default null @@ -124,7 +124,7 @@ -- procedure edit -create function spam__edit (integer,text,varchar,varchar,varchar,timestamp with time zone) returns integer as ' +create function spam__edit (integer,text,varchar,varchar,varchar,timestamptz) returns integer as ' declare p_spam_id alias for $1; -- spam_messages.spam_id%TYPE, p_title alias for $2; -- acs_mail_bodies.header_subject%TYPE default null @@ -249,7 +249,7 @@ -create function spam__new_content (integer,timestamp with time zone,integer,varchar,varchar,varchar,varchar,integer) +create function spam__new_content (integer,timestamptz,integer,varchar,varchar,varchar,varchar,integer) returns integer as ' declare context_id alias for $1; -- acs_objects.context_id%TYPE Index: openacs-4/packages/static-pages/sql/postgresql/static-page-pb.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/sql/postgresql/static-page-pb.sql,v diff -u -r1.1.2.3 -r1.1.2.4 --- openacs-4/packages/static-pages/sql/postgresql/static-page-pb.sql 16 Dec 2002 03:22:37 -0000 1.1.2.3 +++ openacs-4/packages/static-pages/sql/postgresql/static-page-pb.sql 2 Mar 2003 22:53:50 -0000 1.1.2.4 @@ -14,7 +14,7 @@ varchar, -- title in cr_revisions.title%TYPE default null, text, -- content in cr_revisions.content%TYPE default null, boolean, -- show_comments_p in static_pages.show_comments_p%TYPE default 't', - timestamp, -- creation_date in acs_objects.creation_date%TYPE + timestamptz, -- creation_date in acs_objects.creation_date%TYPE -- default sysdate, integer, -- creation_user in acs_objects.creation_user%TYPE -- default null, @@ -256,7 +256,7 @@ varchar, -- label in cr_folders.label%TYPE, text, -- description in cr_folders.description%TYPE default null, integer, -- parent_id in cr_items.parent_id%TYPE default null, - timestamp, -- creation_date in acs_objects.creation_date%TYPE + timestamptz, -- creation_date in acs_objects.creation_date%TYPE -- default sysdate, integer, -- creation_user in acs_objects.creation_user%TYPE -- default null, Index: openacs-4/packages/survey/sql/postgresql/survey-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/survey/sql/postgresql/survey-create.sql,v diff -u -r1.2.2.7 -r1.2.2.8 --- openacs-4/packages/survey/sql/postgresql/survey-create.sql 22 Nov 2002 20:06:36 -0000 1.2.2.7 +++ openacs-4/packages/survey/sql/postgresql/survey-create.sql 2 Mar 2003 22:54:30 -0000 1.2.2.8 @@ -283,7 +283,7 @@ clob_answer text, number_answer numeric, varchar_answer text, - date_answer timestamp, + date_answer timestamptz, attachment_answer integer constraint survey_q_response_item_id_fk references cr_revisions(revision_id) @@ -616,4 +616,4 @@ from survey_question_responses qr, survey_responses_latest r where qr.response_id=r.response_id; -\i survey-notifications-init.sql \ No newline at end of file +\i survey-notifications-init.sql Index: openacs-4/packages/wp-slim/sql/postgresql/wp-slim-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/wp-slim/sql/postgresql/wp-slim-create.sql,v diff -u -r1.6.2.1 -r1.6.2.2 --- openacs-4/packages/wp-slim/sql/postgresql/wp-slim-create.sql 6 Feb 2003 13:07:46 -0000 1.6.2.1 +++ openacs-4/packages/wp-slim/sql/postgresql/wp-slim-create.sql 2 Mar 2003 22:56:43 -0000 1.6.2.2 @@ -716,7 +716,7 @@ --jackp: To p_create each presentation create function wp_presentation__new ( - timestamp, + timestamptz, integer, varchar(400), varchar(400), @@ -1029,7 +1029,7 @@ create function wp_presentation__new_revision ( - timestamp, + timestamptz, integer, varchar, integer, @@ -1160,7 +1160,7 @@ create function wp_slide__new ( integer, - timestamp, + timestamptz, integer, varchar, varchar, @@ -1602,7 +1602,7 @@ end;' language 'plpgsql'; create function wp_slide__new_revision( - timestamp, + timestamptz, integer, varchar, integer, Index: openacs-4/packages/wp-slim/sql/postgresql/wp-slim-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/wp-slim/sql/postgresql/wp-slim-drop.sql,v diff -u -r1.3 -r1.3.2.1 --- openacs-4/packages/wp-slim/sql/postgresql/wp-slim-drop.sql 13 Mar 2002 22:50:53 -0000 1.3 +++ openacs-4/packages/wp-slim/sql/postgresql/wp-slim-drop.sql 2 Mar 2003 22:56:43 -0000 1.3.2.1 @@ -368,7 +368,7 @@ --drop package wp_slide; DROP FUNCTION wp_slide__new( integer, - timestamp, + timestamptz, integer, varchar, varchar, @@ -408,7 +408,7 @@ --drop package wp_presentation; DROP FUNCTION wp_presentation__new( - timestamp, + timestamptz, integer, varchar, varchar, @@ -450,7 +450,7 @@ ); drop function wp_slide__new_revision( - timestamp, + timestamptz, integer, varchar, integer, @@ -465,7 +465,7 @@ boolean); drop function wp_presentation__new_revision ( - timestamp, + timestamptz, integer, varchar, integer,