Index: openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.6-0.7d.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/upgrade/Attic/upgrade-0.6-0.7d.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.6-0.7d.sql 12 Dec 2005 13:17:47 -0000 1.1.2.1 +++ openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.6-0.7d.sql 12 Dec 2005 13:24:40 -0000 1.1.2.2 @@ -48,14 +48,18 @@ -- alter table na_sources drop column package_id; -- alter table na_sources drop column owner_id; alter table na_sources add column last_modified_stamp timestamptz; -alter table na_sources add column last_scan_ok_p boolean default true; +alter table na_sources add column last_scan_ok_p boolean; +alter table na_sources alter column last_scan_ok_p set default true; alter table na_sources add column stacktrace text; alter table na_sources add column rss_source text; -alter table na_sources add column listed_p boolean default true; +alter table na_sources add column listed_p boolean; +alter table na_sources alter column listed_p set default true; alter table na_items add column guid varchar(500); alter table na_items add column original_guid varchar(500); -alter table na_items add column permalink_p boolean default true; +alter table na_items add column permalink_p boolean; +alter table na_items alter column permalink_p set default true; + alter table na_items add column content_encoded text; create index na_items_guid_idx on na_items(guid);