Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql	21 Dec 2002 22:32:31 -0000	1.9
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql	17 May 2003 09:43:09 -0000	1.10
@@ -59,22 +59,6 @@
 
 end;
 
-
--- insert new MIME types
-insert into cr_mime_types (
-  label, mime_type, file_extension
-) values (
-  'Image - Jpeg', 'image/jpeg','jpg'
-);
-
-insert into cr_mime_types (
-  label, mime_type, file_extension
-) values (
-  'Image - Gif', 'image/gif','gif'
-);
-
-
-
 -- register MIME types to this content type
 begin;
 
@@ -120,7 +104,7 @@
 -- The Oracle version does allow a non-image type to be specified, as does my
 -- alternative down below.  This needs a little more straightening out.
 
-create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,boolean,timestamp with time zone,varchar,integer,integer,integer
+create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,boolean,timestamptz,varchar,integer,integer,integer
   ) returns integer as '
   declare
     new__name		alias for $1;
@@ -142,7 +126,7 @@
 
     new__locale          varchar default null;
     new__nls_language	 varchar default null;
-    new__creation_date	 timestamp default now();
+    new__creation_date	 timestamptz default current_timestamp;
     new__context_id      integer;	
 
     v_item_id		 cr_items.item_id%TYPE;
@@ -215,7 +199,7 @@
 -- DRB's version
 
 create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,varchar,
-                            varchar,timestamp,integer, integer) returns integer as '
+                            varchar,timestamptz,integer, integer) returns integer as '
   declare
     p_name              alias for $1;
     p_parent_id         alias for $2; -- default null
@@ -284,7 +268,8 @@
     return v_item_id;
 end; ' language 'plpgsql';
 
-create function image__new_revision(integer, integer, varchar, varchar, timestamp with time zone, varchar, varchar,
+
+create function image__new_revision(integer, integer, varchar, varchar, timestamptz, varchar, varchar,
                                     integer, varchar, integer, integer) returns integer as '
 declare
    p_item_id          alias for $1;
