Index: openacs-4/packages/jabber/sql/oracle/jabber-notification-forum-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/jabber/sql/oracle/jabber-notification-forum-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/jabber/sql/oracle/jabber-notification-forum-create.sql	20 Oct 2004 19:36:47 -0000	1.1
+++ openacs-4/packages/jabber/sql/oracle/jabber-notification-forum-create.sql	12 Apr 2018 07:47:22 -0000	1.2
@@ -4,47 +4,42 @@
 -- @email bkiesbye@sussdorff-roy.com
 --
 
-
-
-
--- This code registers the forum (package) with the 
+-- This code registers the forum (package) with the
 -- new NotificationMethodImplementations from the jabber package.
 -- When the forum (package is re/installed after the jabber package)
 -- the code from this from this file should run after the forum instalation.
 -- This hack should be part of the forums package.
--- Comment: it should not be a hack like this anyway , the service contract is responsible 
+-- Comment: it should not be a hack like this anyway , the service contract is responsible
 -- ,to let every App., that is interested in making use of the NotificationDeliveryMethod interface,
 -- get access to all implementations of this interface. The Notification package is able to handle
--- more then one implementation of it's interface (like it schould by openacs definition) 
--- but the service contract package dosn't seem to be able to properly populate multiple implementations 
--- of the same interface (service contract). Even if it alowes multiple implementations to exist           
+-- more then one implementation of its interface (like it should by openacs definition)
+-- but the service contract package doesn't seem to be able to properly populate multiple implementations
+-- of the same interface (service contract). Even if it allows multiple implementations to exist
 
 declare
 v_type_id_message int;
 v_delivery_method_id_and  notification_types_del_methods.delivery_method_id%TYPE;
 v_type_id_thread notification_types_del_methods.type_id%TYPE;
 v_delivery_method_id_or notification_types_del_methods.delivery_method_id%TYPE;
-begin 
-         SELECT delivery_method_id INTO v_delivery_method_id_and FROM notification_delivery_methods WHERE short_name like('imessage_and_email');
-                                        
+begin
+        SELECT delivery_method_id INTO v_delivery_method_id_and FROM notification_delivery_methods WHERE short_name like('imessage_and_email');
 
-         SELECT delivery_method_id INTO v_delivery_method_id_or FROM notification_delivery_methods WHERE short_name like('imessage_or_email');
+        SELECT delivery_method_id INTO v_delivery_method_id_or FROM notification_delivery_methods WHERE short_name like('imessage_or_email');
 
-	 SELECT type_id INTO v_type_id_message FROM notification_types WHERE short_name like('forums_message_notif');
+        SELECT type_id INTO v_type_id_message FROM notification_types WHERE short_name like('forums_message_notif');
 
+        SELECT type_id INTO v_type_id_thread FROM notification_types WHERE short_name like('forums_forum_notif');
 
-	 SELECT type_id INTO v_type_id_thread FROM notification_types WHERE short_name like('forums_forum_notif');
-
-        insert into notification_types_del_methods  (type_id, delivery_method_id) 
+        insert into notification_types_del_methods  (type_id, delivery_method_id)
         values ( v_type_id_thread ,v_delivery_method_id_and);
 
-        insert into notification_types_del_methods  (type_id, delivery_method_id) 
+        insert into notification_types_del_methods  (type_id, delivery_method_id)
         values ( v_type_id_thread , v_delivery_method_id_or );
 
-        insert into notification_types_del_methods  (type_id, delivery_method_id) 
+        insert into notification_types_del_methods  (type_id, delivery_method_id)
         values ( v_type_id_message , v_delivery_method_id_and);
 
-        insert into notification_types_del_methods  (type_id, delivery_method_id) 
+        insert into notification_types_del_methods  (type_id, delivery_method_id)
         values ( v_type_id_message , v_delivery_method_id_or);
 end;
 /