Index: openacs-4/packages/acs-subsite/tcl/attribute-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/attribute-procs-oracle.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/acs-subsite/tcl/attribute-procs-oracle.xql 7 Aug 2017 23:47:58 -0000 1.4 +++ openacs-4/packages/acs-subsite/tcl/attribute-procs-oracle.xql 22 Nov 2017 14:50:28 -0000 1.5 @@ -2,25 +2,10 @@ oracle8.1.6 - - + - select a.object_type, a.attribute_name, - case when a.storage = 'type_specific' then t.table_name else a.table_name end as table_name, - nvl(a.column_name, a.attribute_name) as column_name - from acs_attributes a, acs_object_types t - where a.attribute_id = :attribute_id - and t.object_type = a.object_type - - - - - - - - select nvl(a.column_name, a.attribute_name) as name, a.pretty_name, a.attribute_id, a.datatype, v.enum_value, v.pretty_name as value_pretty_name @@ -65,28 +50,10 @@ - - -alter table $table_name drop column $attribute_name - - - - - -alter table $table_name add $attribute_name $sql_type - - - begin acs_attribute.drop_attribute(:object_type, :attribute_name); end; - - -alter table $table_name drop column $column_name - - -