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 -N -r1.1.2.3 -r1.1.2.4 --- openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.7-0.9.8.sql 18 Jan 2006 15:25:17 -0000 1.1.2.3 +++ openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9.7-0.9.8.sql 23 Jan 2006 15:39:59 -0000 1.1.2.4 @@ -58,9 +58,12 @@ -- no real feed owner at this point, with feeds being shared among packages alter table na_sources drop column owner_id; + -- this was not used and is available in acs_objects beginnning with 5.2 in any case -alter table na_sources - drop column package_id; +-- THIS IS DEADLY. DONT DO THIS. WRITE A PLSQL FUNCTION TO UPDATE THE PACKAGE_ID FIRST !!!! +-- +-- alter table na_sources +-- drop column package_id; -- add on delete cascade so packages can uninstall cleanly -- doing this for now, may eventually move this data to the user preferences package