Index: openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql	15 Feb 2002 01:41:31 -0000	1.6
+++ openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql	15 Feb 2002 02:01:14 -0000	1.7
@@ -18,5 +18,17 @@
       </querytext>
 </fullquery>
 
- 
+
+<fullquery name="approve_email">
+	<querytext>
+	select acs_user__approve_email (:user_id);
+	</querytext>
+</fullquery>
+
+<fullquery name="unapprove_email">
+	<querytext>
+	select acs_user__unapprove_email (:user_id);
+	</querytext>
+</fullquery>
+
 </queryset>