Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql 16 Jul 2009 00:40:07 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql 22 Mar 2010 23:17:31 -0000 1.3 @@ -10,8 +10,11 @@ pretty_name => 'Modifying User' ); + acs_attribute.drop_attribute('person','bio'); + acs_attribute.drop_attribute('person','bio_mime_type'); + attr_id := acs_attribute.create_attribute ( - object_type => 'user', + object_type => 'person', attribute_name => 'bio', datatype => 'string', pretty_name => '#acs-kernel.Bio#', Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d6-5.6.0d7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d6-5.6.0d7.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d6-5.6.0d7.sql 15 Mar 2010 00:21:16 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d6-5.6.0d7.sql 22 Mar 2010 23:17:31 -0000 1.2 @@ -435,14 +435,17 @@ register_parameter.default_value, register_parameter.section_name, register_parameter.min_n_values, register_parameter.max_n_values); -- Propagate parameter to new instances. - for pkg in (select package_id from apm_packages where package_key = register_parameter.package_key) - loop - v_value_id := apm_parameter_value.new( - package_id => pkg.package_id, - parameter_id => v_parameter_id, - attr_value => register_parameter.default_value - ); - end loop; + if register_parameter.scope = 'instance' then + for pkg in (select package_id from apm_packages where package_key = register_parameter.package_key) + loop + v_value_id := apm_parameter_value.new( + package_id => pkg.package_id, + parameter_id => v_parameter_id, + attr_value => register_parameter.default_value + ); + end loop; + end if; + return v_parameter_id; end register_parameter;