Index: openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql,v diff -u -r1.29 -r1.30 --- openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 26 Apr 2004 18:50:50 -0000 1.29 +++ openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 24 Jun 2004 15:05:15 -0000 1.30 @@ -356,8 +356,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) 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.2 -r1.3 --- 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 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.2.0d3-5.2.0d4.sql 24 Jun 2004 15:05:15 -0000 1.3 @@ -2,9 +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) - on delete cascade + 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)