Index: openacs-4/packages/news/sql/oracle/news-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/oracle/news-create.sql,v
diff -u -r1.8 -r1.8.4.1
--- openacs-4/packages/news/sql/oracle/news-create.sql	6 Oct 2003 12:11:23 -0000	1.8
+++ openacs-4/packages/news/sql/oracle/news-create.sql	23 Dec 2004 07:41:13 -0000	1.8.4.1
@@ -925,7 +925,7 @@
     ci.item_id as item_id,
     cn.package_id as package_id,
     revision_id,        
-    title as publish_title,
+    cr.title as publish_title,
     content.blob_to_string(cr.content) as publish_body,
     decode(cr.mime_type,'text/html','t','f') as html_p,
     cr.publish_date,
Index: openacs-4/packages/news/sql/postgresql/news-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/news-create.sql,v
diff -u -r1.15 -r1.15.4.1
--- openacs-4/packages/news/sql/postgresql/news-create.sql	6 Oct 2003 12:11:23 -0000	1.15
+++ openacs-4/packages/news/sql/postgresql/news-create.sql	23 Dec 2004 07:41:13 -0000	1.15.4.1
@@ -887,7 +887,7 @@
     ci.item_id as item_id,
     cn.package_id as package_id,
     revision_id,        
-    title as publish_title,
+    cr.title as publish_title,
     cr.content as publish_body,
     (case when cr.mime_type = 'text/html' then 't' else 'f' end) as html_p,
     cr.publish_date,
Index: openacs-4/packages/news/sql/postgresql/news-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/news-drop.sql,v
diff -u -r1.5 -r1.5.4.1
--- openacs-4/packages/news/sql/postgresql/news-drop.sql	23 Aug 2003 20:23:17 -0000	1.5
+++ openacs-4/packages/news/sql/postgresql/news-drop.sql	23 Dec 2004 07:41:13 -0000	1.5.4.1
@@ -96,7 +96,7 @@
 drop view news_item_unapproved;
 drop view news_item_full_active;
 
-drop function news__status (integer);
+drop function news__status (timestamptz, timestamptz);
 
 
 -- drop attributes