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 -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)
