Index: openacs-4/packages/notifications/sql/postgresql/notifications-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/notifications-init.sql,v
diff -u -r1.4 -r1.4.2.1
--- openacs-4/packages/notifications/sql/postgresql/notifications-init.sql	9 Aug 2002 20:51:50 -0000	1.4
+++ openacs-4/packages/notifications/sql/postgresql/notifications-init.sql	12 Jun 2003 13:34:52 -0000	1.4.2.1
@@ -8,56 +8,32 @@
 -- GNU GPL v2
 --
 
--- initialize some stuff
-create function inline_0 ()
-returns integer as '
-begin
+select notification_interval__new (
+    null,
+    'daily',
+    3600 * 24,
+    now(),
+    null,
+    null,
+    null
+);
 
-    perform notification_interval__new (
-        null,
-        ''daily'',
-        3600 * 24,
-        now(),
-        null,
-        null,
-        null
-    );
+select notification_interval__new (
+    null,
+    'hourly',
+    3600,
+    now(),
+    null,
+    null,
+    null
+);
 
-    perform notification_interval__new (
-        null,
-        ''hourly'',
-        3600,
-        now(),
-        null,
-        null,
-        null
-    );
-
-    perform notification_interval__new (
-        null,
-        ''instant'',
-        0,
-        now(),
-        null,
-        null,
-        null
-    );
-           
--- This is now done by email-sc-impl-create.sql
---
---     perform notification_delivery_method__new (
---         null,
---         ''email'',
---         ''Email'',
---         now(),
---         null,
---         null,
---         null
---     );
-
-    return null;
-
-end;' language 'plpgsql';
-
-select inline_0();
-drop function inline_0 ();
+select notification_interval__new (
+    null,
+    'instant',
+    0,
+    now(),
+    null,
+    null,
+    null
+);