Index: openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql	22 Jul 2001 04:51:03 -0000	1.3
+++ openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql	22 Jul 2001 06:13:37 -0000	1.4
@@ -19,6 +19,13 @@
 </fullquery>
 
  
+<fullquery name="ec_update_state_to_authorized.order_state_update">
+      <querytext>
+      update ec_orders set order_state=:new_state, authorized_date=current_timestamp where order_id=:order_id
+      </querytext>
+</fullquery>
+
+
 <fullquery name="ec_update_state_to_authorized.authorized_date_update">      
       <querytext>
       update ec_financial_transactions set authorized_date=current_timestamp where transaction_id=:transaction_id