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 -r1.7 --- openacs-4/packages/wp-slim/sql/postgresql/wp-slim-create.sql 21 Sep 2002 17:09:09 -0000 1.6 +++ openacs-4/packages/wp-slim/sql/postgresql/wp-slim-create.sql 17 May 2003 12:49:58 -0000 1.7 @@ -33,8 +33,8 @@ -- Style for presentation. We'll think more about this later if there's time -- maybe allow ADPs for more flexibility. -insert into cr_mime_types (mime_type) -select 'application/octet-stream' +insert into cr_mime_types (label, mime_type) +select 'Binary data', 'application/octet-stream' from dual where not exists (select 1 from cr_mime_types where mime_type ='application/octet-stream'); @@ -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,