Index: openacs-4/packages/acs-subsite/tcl/attribute-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/attribute-procs.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/acs-subsite/tcl/attribute-procs.xql 20 Aug 2001 05:15:28 -0000 1.4 +++ openacs-4/packages/acs-subsite/tcl/attribute-procs.xql 22 Nov 2017 14:50:28 -0000 1.5 @@ -106,16 +106,37 @@ - - insert into acs_enum_values - (attribute_id, sort_order, enum_value, pretty_name) - select :attribute_id, :sort_order, :enum_value, :enum_value - from dual - where not exists (select 1 - from acs_enum_values v2 - where v2.pretty_name = :enum_value - and v2.attribute_id = :attribute_id) - + + insert into acs_enum_values + (attribute_id, sort_order, enum_value, pretty_name) + select :attribute_id, :sort_order, :enum_value, :enum_value + from dual + where not exists (select 1 + from acs_enum_values v2 + where v2.pretty_name = :enum_value + and v2.attribute_id = :attribute_id) + - + + + + + alter table $table_name drop column $attribute_name + + + + + + + alter table $table_name add $attribute_name $sql_type + + + + + + + alter table $table_name drop column $column_name + + +