Index: openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql,v
diff -u -N -r1.11 -r1.12
--- openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql	17 May 2003 10:53:27 -0000	1.11
+++ openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql	28 Aug 2003 09:41:58 -0000	1.12
@@ -236,23 +236,24 @@
 end;
 ' language 'plpgsql';
 
-select define_function_args ('notification__new','notification_id,type_id,object_id,notif_date,response_id,notif_subject,notif_text,notif_html,creation_date,creation_user,creation_ip,context_id');
+select define_function_args ('notification__new','notification_id,type_id,object_id,notif_date,response_id,notif_user,notif_subject,notif_text,notif_html,creation_date,creation_user,creation_ip,context_id');
 
-create function notification__new(integer,integer,integer,timestamptz,integer,varchar,text,text,timestamptz,integer,varchar,integer)
+create or replace function notification__new(integer,integer,integer,timestamptz,integer,integer,varchar,text,text,timestamptz,integer,varchar,integer)
 returns integer as '
 declare
     p_notification_id               alias for $1;
     p_type_id                       alias for $2;
     p_object_id                     alias for $3;
     p_notif_date                    alias for $4;
     p_response_id                   alias for $5;
-    p_notif_subject                 alias for $6;
-    p_notif_text                    alias for $7;
-    p_notif_html                    alias for $8;
-    p_creation_date                 alias for $9;
-    p_creation_user                 alias for $10;
-    p_creation_ip                   alias for $11;
-    p_context_id                    alias for $12;
+    p_notif_user                    alias for $6;
+    p_notif_subject                 alias for $7;
+    p_notif_text                    alias for $8;
+    p_notif_html                    alias for $9;
+    p_creation_date                 alias for $10;
+    p_creation_user                 alias for $11;
+    p_creation_ip                   alias for $12;
+    p_context_id                    alias for $13;
     v_notification_id               integer;
     v_notif_date                    notifications.notif_date%TYPE;
 begin
@@ -273,9 +274,9 @@
 
     insert
     into notifications
-    (notification_id, type_id, object_id, notif_date, response_id, notif_subject, notif_text, notif_html)
+    (notification_id, type_id, object_id, notif_date, response_id, notif_user, notif_subject, notif_text, notif_html)
     values
-    (v_notification_id, p_type_id, p_object_id, v_notif_date, p_response_id, p_notif_subject, p_notif_text, p_notif_html);
+    (v_notification_id, p_type_id, p_object_id, v_notif_date, p_response_id, p_notif_user, p_notif_subject, p_notif_text, p_notif_html);
 
     return v_notification_id;
 end;
