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.2.2.1 --- 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 26 Nov 2003 17:11:54 -0000 1.2.2.1 @@ -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, + header clob, + body clob );