Index: openacs-4/packages/notifications/sql/oracle/notifications-replies-extra-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/notifications-replies-extra-create.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/notifications/sql/oracle/notifications-replies-extra-create.sql 6 Nov 2003 19:23:02 -0000 1.2 +++ openacs-4/packages/notifications/sql/oracle/notifications-replies-extra-create.sql 11 Dec 2003 21:40:08 -0000 1.3 @@ -1,8 +1,9 @@ create table notification_email_hold ( reply_id integer - references notification_replies(reply_id) - primary key, - to_addr text, - header text, - body text + constraint notification_email_hold_pk primary key + constraint notif_email_hold_reply_id_ref + references notification_replies(reply_id), + to_addr clob, + headers clob, + body clob );