Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.0d3-5.2.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.0d3-5.2.0d4.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.0d3-5.2.0d4.sql 26 Apr 2004 18:50:51 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.0d3-5.2.0d4.sql 24 Jun 2004 15:03:55 -0000 1.2 @@ -4,6 +4,7 @@ version_id integer 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) 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 -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) Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d3-5.2.0d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d3-5.2.0d4.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d3-5.2.0d4.sql 26 Apr 2004 18:50:52 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d3-5.2.0d4.sql 24 Jun 2004 15:03:55 -0000 1.2 @@ -2,8 +2,9 @@ -- TODO: Migrate this to use acs_attributes instead? create table apm_package_version_attr ( 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)