Index: openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-create.sql	20 Mar 2004 11:04:38 -0000	1.1
+++ openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-create.sql	1 Jun 2004 10:59:18 -0000	1.2
@@ -257,8 +257,10 @@
     varchar,      -- original_guid
     boolean,      -- permalink_p
     varchar,      -- title
-    varchar,      -- description,
-    varchar       -- content_encoded
+    varchar,      -- description
+    varchar,      -- content_encoded
+    varchar,      -- author
+    timestamptz   -- pub_date
 ) returns integer as '
 declare
     p_source_id                 alias for $1;
@@ -269,6 +271,8 @@
     p_title                     alias for $6;
     p_description               alias for $7;
     p_content_encoded           alias for $8;
+    p_author                    alias for $9;
+    p_pub_date                  alias for $10;
 begin
 
         insert into na_items (
@@ -279,7 +283,9 @@
            permalink_p,
            title, 
            description,
-           content_encoded, 
+           content_encoded,
+           author,
+           pub_date, 
            creation_date
         ) values (
            p_source_id,
@@ -290,6 +296,8 @@
            p_title, 
            p_description,
            p_content_encoded,
+           p_author,
+           p_pub_date,
            current_timestamp
         );
 
Index: openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-drop.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-drop.sql	20 Mar 2004 11:04:38 -0000	1.1
+++ openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-drop.sql	1 Jun 2004 10:59:18 -0000	1.2
@@ -24,8 +24,10 @@
     varchar,      -- original_guid 
     boolean,      -- permalink_p
     varchar,      -- title
-    varchar,       -- description,
-    varchar      -- content_encoded
+    varchar,       -- description
+    varchar,      -- content_encoded
+    varchar,      -- author
+    timestamptz     -- pub_date
 );
 
 --drop na_source functions
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 -r1.1 -r1.2
--- openacs-4/packages/news-aggregator/sql/postgresql/upgrade-0.7d-0.8d.sql	31 May 2004 14:19:24 -0000	1.1
+++ openacs-4/packages/news-aggregator/sql/postgresql/upgrade-0.7d-0.8d.sql	1 Jun 2004 10:59:18 -0000	1.2
@@ -15,3 +15,70 @@
 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;
+
+drop function na_item__new (
+    integer,      -- source_id
+    varchar,      -- link
+    varchar,      -- guid
+    varchar,      -- original_guid 
+    boolean,      -- permalink_p
+    varchar,      -- title
+    varchar,       -- description,
+    varchar      -- content_encoded
+);
+
+create or replace function na_item__new (
+    integer,      -- source_id
+    varchar,      -- link
+    varchar,      -- guid
+    varchar,      -- original_guid
+    boolean,      -- permalink_p
+    varchar,      -- title
+    varchar,      -- description
+    varchar,      -- content_encoded
+    varchar,      -- author
+    timestamptz   -- pub_date
+) returns integer as '
+declare
+    p_source_id                 alias for $1;
+    p_link                      alias for $2;
+    p_guid                      alias for $3;
+    p_original_guid             alias for $4;
+    p_permalink_p               alias for $5;
+    p_title                     alias for $6;
+    p_description               alias for $7;
+    p_content_encoded           alias for $8;
+    p_author                    alias for $9;
+    p_pub_date                  alias for $10;
+begin
+
+        insert into na_items (
+           source_id,
+           link, 
+           guid,
+           original_guid,
+           permalink_p,
+           title, 
+           description,
+           content_encoded,
+           author,
+           pub_date, 
+           creation_date
+        ) values (
+           p_source_id,
+           p_link, 
+           p_guid,
+           p_original_guid,
+           p_permalink_p,
+           p_title, 
+           p_description,
+           p_content_encoded,
+           p_author,
+           p_pub_date,
+           current_timestamp
+        );
+
+        return 1;
+
+end;' language 'plpgsql';
+