Index: openacs-4/packages/ecommerce/www/admin/products/custom-field-add-3-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/custom-field-add-3-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/products/custom-field-add-3-oracle.xql 25 Aug 2001 05:34:13 -0000 1.1
@@ -0,0 +1,41 @@
+
+
+
+ oracle8.1.6
+
+
+
+ sysdate, :user_id, :peeraddr
+
+
+
+
+
+
+ alter table ec_custom_product_field_values add (
+ $field_identifier $column_type $end_of_alter)
+
+
+
+
+
+
+
+
+ alter table ec_custom_p_field_values_audit add (
+ $field_identifier $column_type)
+
+
+
+
+
+
+
+ alter table ec_custom_product_field_values drop column $field_identifier
+
+
+
+
+
+
+
Index: openacs-4/packages/ecommerce/www/admin/products/custom-field-add-3-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/custom-field-add-3-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/products/custom-field-add-3-postgresql.xql 25 Aug 2001 05:34:13 -0000 1.1
@@ -0,0 +1,41 @@
+
+
+
+ postgresql7.1
+
+
+
+ current_timestamp, :user_id, :peeraddr
+
+
+
+
+
+
+ alter table ec_custom_product_field_values add column
+ $field_identifier $column_type $end_of_alter
+
+
+
+
+
+
+
+ alter table ec_custom_p_field_values_audit add column
+ $field_identifier $column_type
+
+
+
+
+
+
+
+
+ alter table ec_custom_product_field_values drop column $field_identifier
+
+
+
+
+
+
+