Index: openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql,v diff -u -N -r1.11 -r1.12 --- openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql 29 Jun 2004 10:18:40 -0000 1.11 +++ openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql 28 Jun 2007 17:23:41 -0000 1.12 @@ -382,6 +382,7 @@ notif_subject in notifications.notif_subject%TYPE default null, notif_text in varchar default null, notif_html in varchar default null, + file_ids in varchar default null, creation_date in acs_objects.creation_date%TYPE default sysdate, creation_user in acs_objects.creation_user%TYPE, creation_ip in acs_objects.creation_ip%TYPE, @@ -400,9 +401,9 @@ ); insert into notifications - (notification_id, type_id, object_id, notif_date, response_id, notif_user, notif_subject, notif_text, notif_html) + (notification_id, type_id, object_id, notif_date, response_id, notif_user, notif_subject, notif_text, notif_html, file_ids) values - (v_notification_id, type_id, object_id, notif_date, response_id, notif_user, notif_subject, notif_text, notif_html); + (v_notification_id, type_id, object_id, notif_date, response_id, notif_user, notif_subject, notif_text, notif_html, file_ids); return v_notification_id; end new;