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
+
+
+