Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v diff -u -N -r1.54 -r1.55 --- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 18 Jun 2004 18:21:57 -0000 1.54 +++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 24 Jun 2004 15:03:55 -0000 1.55 @@ -416,10 +416,11 @@ -- Use this table to make it easy to change the attribute set of package versions -- TODO: Migrate this to use acs_attributes instead? -create table apm_package_version_attr ( +create table apm_package_version_attrx ( version_id integer - constraint apm_package_vers_attr_vid_fk - references apm_package_versions(version_id) + constraint apm_package_vers_attr_vid_fk + references apm_package_versions(version_id) + on delete cascade constraint apm_package_vers_attr_vid_nn not null, attribute_name varchar(100)