Index: openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql	10 Jul 2001 20:38:43 -0000	1.1
+++ openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql	18 Jul 2001 23:46:14 -0000	1.2
@@ -17,76 +17,85 @@
 </fullquery>
 
  
-<fullquery name="email_log_insert">      
+<fullquery name="email_log_insert_1">
       <querytext>
-      
-	    insert into ec_automatic_email_log
-	    (user_identification_id, email_template_id, order_id, date_sent)
-	    values
-	    (:user_identification_id, 1, :order_id, current_timestamp)
-	
+
+            insert into ec_automatic_email_log
+            (user_identification_id, email_template_id, order_id, date_sent)
+            values
+            (:user_identification_id, 1, :order_id, current_timestamp)
+
       </querytext>
 </fullquery>
 
- 
-<fullquery name="email_log_insert">      
+
+<fullquery name="email_log_insert_2">
       <querytext>
-      
-	  insert into ec_automatic_email_log
-	  (user_identification_id, email_template_id, order_id, date_sent)
-	  values
-	  (:user_identification_id, 3, :order_id, current_timestamp)
-      
+
+          insert into ec_automatic_email_log
+          (user_identification_id, email_template_id, order_id, shipment_id, date_sent)
+          values
+          (:user_identification_id, 2, :order_id, :shipment_id, current_timestamp)
+
       </querytext>
 </fullquery>
 
- 
-<fullquery name="email_log_insert">      
+
+<fullquery name="email_log_insert_3">
       <querytext>
-      
-	  insert into ec_automatic_email_log
-	  (user_identification_id, email_template_id, order_id, date_sent)
-	  values
-	  (:user_identification_id, 3, :order_id, current_timestamp)
-      
+
+          insert into ec_automatic_email_log
+          (user_identification_id, email_template_id, order_id, date_sent)
+          values
+          (:user_identification_id, 3, :order_id, current_timestamp)
+
       </querytext>
 </fullquery>
 
- 
-<fullquery name="email_log_insert">      
+
+<fullquery name="email_log_insert_4">
       <querytext>
-      
-	  insert into ec_automatic_email_log
-	  (user_identification_id, email_template_id, order_id, date_sent)
-	  values
-	  (:user_identification_id, 3, :order_id, current_timestamp)
-      
+
+          insert into ec_automatic_email_log
+          (user_identification_id, email_template_id, gift_certificate_id, date_sent)
+          values
+          (:user_identification_id, 4, :gift_certificate_id, current_timestamp)
+
+
       </querytext>
 </fullquery>
 
- 
-<fullquery name="email_log_insert">      
+
+<fullquery name="email_log_insert_5">
       <querytext>
-      
-	  insert into ec_automatic_email_log
-	  (user_identification_id, email_template_id, order_id, date_sent)
-	  values
-	  (:user_identification_id, 3, :order_id, current_timestamp)
-      
+
+          insert into ec_automatic_email_log
+          (user_identification_id, email_template_id, gift_certificate_id, date_sent)
+          values
+          (:user_identification_id, 5, :gift_certificate_id, current_timestamp)
+
       </querytext>
 </fullquery>
 
+
+<fullquery name="email_log_insert_6">
+      <querytext>
+
+          insert into ec_automatic_email_log
+          (user_identification_id, email_template_id, gift_certificate_id, date_sent)
+          values
+          (:user_identification_id, 6, :gift_certificate_id, current_timestamp)
+
+      </querytext>
+</fullquery>
  
-<fullquery name="email_log_insert">      
+
+<fullquery name="user_identification_id_seq">
       <querytext>
-      
-	  insert into ec_automatic_email_log
-	  (user_identification_id, email_template_id, order_id, date_sent)
-	  values
-	  (:user_identification_id, 3, :order_id, current_timestamp)
-      
+
+	select ec_user_ident_id_seq.nextval 
+
       </querytext>
 </fullquery>
 
- 
 </queryset>