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
--- openacs-4/packages/news-aggregator/sql/postgresql/upgrade-0.7d-0.8d.sql	1 Jun 2004 10:59:18 -0000	1.2
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,84 +0,0 @@
---
--- 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.2 2004/06/01 10:59:18 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;
-
-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';
-