Index: openacs-4/packages/notifications/tcl/notification-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/notification-procs.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/notifications/tcl/notification-procs.xql	30 May 2002 06:26:09 -0000	1.3
+++ openacs-4/packages/notifications/tcl/notification-procs.xql	3 Jun 2002 22:27:00 -0000	1.4
@@ -1,61 +1,72 @@
 <?xml version="1.0"?>
+
 <queryset>
 
-<fullquery name="notification::get_interval_id.select_interval_id">
-<querytext>
-select interval_id from notification_intervals where name= :name
-</querytext>
-</fullquery>
+    <fullquery name="notification::get_interval_id.select_interval_id">
+        <querytext>
+            select interval_id
+            from notification_intervals
+            where name = :name
+        </querytext>
+    </fullquery>
 
-<fullquery name="notification::get_delivery_method_id.select_delivery_method_id">
-<querytext>
-select delivery_method_id from notification_delivery_methods where short_name= :name
-</querytext>
-</fullquery>
+    <fullquery name="notification::get_delivery_method_id.select_delivery_method_id">
+        <querytext>
+            select delivery_method_id
+            from notification_delivery_methods
+            where short_name = :name
+        </querytext>
+    </fullquery>
 
-<fullquery name="notification::get_all_intervals.select_all_intervals">
-<querytext>
-select name, interval_id from 
-notification_intervals
-order by n_seconds
-</querytext>
-</fullquery>
+    <fullquery name="notification::get_all_intervals.select_all_intervals">
+        <querytext>
+            select name,
+                   interval_id
+            from notification_intervals
+            order by n_seconds
+        </querytext>
+    </fullquery>
 
-<fullquery name="notification::get_intervals.select_intervals">
-<querytext>
-select name, notification_intervals.interval_id from 
-notification_intervals, notification_types_intervals
-where
-notification_intervals.interval_id = notification_types_intervals.interval_id
-and type_id= :type_id
-order by n_seconds
-</querytext>
-</fullquery>
+    <fullquery name="notification::get_intervals.select_intervals">
+        <querytext>
+            select name,
+                   notification_intervals.interval_id
+            from notification_intervals,
+                 notification_types_intervals
+            where notification_intervals.interval_id = notification_types_intervals.interval_id
+            and type_id = :type_id
+            order by n_seconds
+        </querytext>
+    </fullquery>
 
-<fullquery name="notification::get_delivery_methods.select_delivery_methods">
-<querytext>
-select pretty_name, notification_delivery_methods.delivery_method_id 
-from notification_delivery_methods, notification_types_del_methods
-where 
-notification_delivery_methods.delivery_method_id = notification_types_del_methods.delivery_method_id
-and type_id= :type_id
-order by pretty_name
-</querytext>
-</fullquery>
+    <fullquery name="notification::get_delivery_methods.select_delivery_methods">
+        <querytext>
+            select pretty_name,
+                   notification_delivery_methods.delivery_method_id
+            from notification_delivery_methods,
+                 notification_types_del_methods
+            where notification_delivery_methods.delivery_method_id = notification_types_del_methods.delivery_method_id
+            and type_id = :type_id
+            order by pretty_name
+        </querytext>
+    </fullquery>
 
-<fullquery name="notification::delete.delete_mappings">
-<querytext>
-delete from notification_user_map
-where notification_id= :notification_id
-</querytext>
-</fullquery>
+    <fullquery name="notification::delete.delete_mappings">
+        <querytext>
+            delete
+            from notification_user_map
+            where notification_id = :notification_id
+        </querytext>
+    </fullquery>
 
-<fullquery name="notification::mark_sent.insert_notification_user_map">
-<querytext>
-insert into notification_user_map
-(notification_id, user_id, sent_date) values
-(:notification_id, :user_id, sysdate)
-</querytext>
-</fullquery>
+    <fullquery name="notification::mark_sent.insert_notification_user_map">
+        <querytext>
+            insert
+            into notification_user_map
+            (notification_id, user_id, sent_date)
+            values
+            (:notification_id, :user_id, sysdate)
+        </querytext>
+    </fullquery>
 
 </queryset>