Index: openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql	20 Mar 2004 11:04:38 -0000	1.1
+++ openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql	31 May 2004 14:19:24 -0000	1.2
@@ -120,10 +120,13 @@
        permalink_p		    boolean 
                                     default true,
        title                        varchar(500),
+       author                       varchar(100),
+       comment_page                 varchar(200),
        description                  text,
        content_encoded              text,
        creation_date                timestamptz
-				    default current_timestamp
+				    default current_timestamp,
+    pub_date                        timestamptz
 );
 
 create sequence na_items_item_id_seq cache 1;
@@ -175,6 +178,11 @@
 	source_id		integer
                                 constraint na_subscriptions_sid_fk
                                 references na_sources(source_id),
+    source_title        varchar(100),
+    show_description_p  boolean
+                        constraint na_subscriptions_show_description_p_nn
+                        not null
+                        default true,
         creation_date		timestamptz
 				default current_timestamp,
         constraint na_subscriptions_pk primary key (aggregator_id, source_id)
Index: openacs-4/packages/news-aggregator/sql/postgresql/upgrade-0.7d-0.8d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/Attic/upgrade-0.7d-0.8d.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/news-aggregator/sql/postgresql/upgrade-0.7d-0.8d.sql	31 May 2004 14:19:24 -0000	1.1
@@ -0,0 +1,17 @@
+--
+-- News Aggregator upgrade script from 0.7d to 0.8d
+--
+-- @author Guan Yang (guan@unicast.org)
+-- @creation-date 2004-06-01
+-- @cvs-id $Id: upgrade-0.7d-0.8d.sql,v 1.1 2004/05/31 14:19:24 gyang Exp $
+--
+
+alter table na_subscriptions add source_title varchar(100);
+alter table na_subscriptions add show_description_p boolean;
+update na_subscriptions set show_description_p = true;
+alter table na_subscriptions alter column show_description_p set default true;
+alter table na_subscriptions alter column show_description_p set not null;
+
+alter table na_items add author varchar(100);
+alter table na_items add comment_page varchar(200);
+alter table na_items add pub_date timestamptz;