Index: openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.7-0.9.8.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/upgrade/Attic/upgrade-0.9.7-0.9.8.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.7-0.9.8.sql 14 Jan 2006 23:27:59 -0000 1.1.2.1 +++ openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.7-0.9.8.sql 17 Jan 2006 23:07:28 -0000 1.1.2.2 @@ -55,13 +55,15 @@ end;' language 'plpgsql'; --- MS: remove owner_id and package_id from na_sources as they are not used --- title should be removed next if na_source remains an object (1/13/06) +-- no real feed owner at this point, with feeds being shared among packages alter table na_sources drop column owner_id; - +-- this is available in acs_objects beginnning with 5.2 alter table na_sources drop column package_id; +-- customizing this should be a per user option +alter table na_sources + drop column title; -- add on delete cascade so packages can uninstall cleanly -- doing this for now, may eventually move this data to the user preferences package