Index: openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql,v diff -u -r1.2.2.2 -r1.2.2.3 --- openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql 4 Jan 2006 16:48:04 -0000 1.2.2.2 +++ openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql 14 Jan 2006 23:27:59 -0000 1.2.2.3 @@ -209,6 +209,7 @@ package_id integer constraint na_user_preferences_pid_fk references apm_packages(package_id) + on delete cascade constraint na_user_preferences_pid_nn not null, constraint na_user_prefs_pk primary key (user_id, package_id)