Index: openacs-4/packages/notifications/notifications.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/notifications.info,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/notifications/notifications.info	29 May 2002 05:12:01 -0000	1.2
+++ openacs-4/packages/notifications/notifications.info	29 May 2002 21:47:18 -0000	1.3
@@ -16,6 +16,7 @@
         <summary>Notification Management</summary>
 
         <provides url="notifications" version="0.1"/>
+        <requires url="acs-mail-lite" version="0.1d"/>
 
         <files>
             <file type="package_spec" path="notifications.info"/>
Index: openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	29 May 2002 05:12:01 -0000	1.2
+++ openacs-4/packages/notifications/sql/oracle/notifications-core-create.sql	29 May 2002 21:47:18 -0000	1.3
@@ -121,8 +121,8 @@
        response_id                      integer
                                         constraint notif_reponse_id_fk references acs_objects(object_id),
        notif_subject                    varchar(100),
-       notif_text                       varchar(4000),
-       notif_html                       varchar(4000)
+       notif_text                       clob,
+       notif_html                       clob
 );
 
 
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.2 -r1.3
--- openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql	29 May 2002 05:12:01 -0000	1.2
+++ openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql	29 May 2002 21:47:18 -0000	1.3
@@ -316,8 +316,9 @@
       object_id                         in notifications.object_id%TYPE,
       notif_date                        in notifications.notif_date%TYPE default sysdate,
       response_id                       in notifications.response_id%TYPE default null,
-      notif_text                        in notifications.notif_text%TYPE default null,
-      notif_html                        in notifications.notif_html%TYPE default null,
+      notif_subject                     in notifications.notif_subject%TYPE default null,
+      notif_text                        in varchar default null,
+      notif_html                        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,
@@ -344,8 +345,8 @@
       notif_date                        in notifications.notif_date%TYPE default sysdate,
       response_id                       in notifications.response_id%TYPE default null,
       notif_subject                     in notifications.notif_subject%TYPE default null,
-      notif_text                        in notifications.notif_text%TYPE default null,
-      notif_html                        in notifications.notif_html%TYPE default null,
+      notif_text                        in varchar default null,
+      notif_html                        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,