Index: openacs-4/contrib/obsolete-packages/mp3-jukebox/sql/postgresql/mp3-jukebox-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/mp3-jukebox/sql/postgresql/mp3-jukebox-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/mp3-jukebox/sql/postgresql/mp3-jukebox-create.sql	17 Oct 2001 19:44:08 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/mp3-jukebox/sql/postgresql/mp3-jukebox-create.sql	17 May 2003 10:48:47 -0000	1.2
@@ -117,7 +117,7 @@
 	user_id		integer
 				constraint mp3_mp3_stats_user_id_fk
 				references users(user_id),
-	access_date	timestamp
+	access_date	timestamptz
 				constraint mp3_mp3_stats_access_date_nn
 				not null
 );
@@ -129,7 +129,7 @@
 	user_id		integer
 				constraint mp3_playlists_stats_user_id_fk
 				references users(user_id),
-	access_date	timestamp
+	access_date	timestamptz
 				constraint mp3_playlist_stats_date_nn
 				not null
 );
@@ -147,7 +147,7 @@
 	vote		integer
 				constraint mp3_votes_vote_nn
 				not null,
-	vote_date	timestamp
+	vote_date	timestamptz
 );
 
 create view mp3_mp3_playlist_map_view as
@@ -187,7 +187,7 @@
 		p_title			alias for $3;       -- default null
 		p_deleted_p		boolean default ''f'';
 		p_object_type		varchar default ''mp3'';
-		p_creation_date		timestamp default now();
+		p_creation_date		timestamptz default current_timestamp;
 		p_creation_user		integer default null;
 		p_creation_ip		varchar default null;
 		p_context_id		integer default null;
@@ -238,7 +238,7 @@
 end;' language 'plpgsql';
 
 
-create function mp3_playlist__new (integer,varchar,boolean,integer,varchar,timestamp,integer,varchar,integer)
+create function mp3_playlist__new (integer,varchar,boolean,integer,varchar,timestamptz,integer,varchar,integer)
 returns integer as '
 declare
 		p_playlist_id		alias for $1;       -- default null
@@ -353,7 +353,7 @@
 end;' language 'plpgsql';
 
 
-create function mp3_playlist__vote_cast (integer,integer,integer,integer,timestamp)
+create function mp3_playlist__vote_cast (integer,integer,integer,integer,timestamptz)
 returns integer as '
 declare
 		p_user_id		alias for $1;
