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 -r1.2.2.1 -r1.2.2.2 --- openacs-4/packages/notifications/sql/oracle/notifications-replies-extra-create.sql 26 Nov 2003 17:11:54 -0000 1.2.2.1 +++ openacs-4/packages/notifications/sql/oracle/notifications-replies-extra-create.sql 4 Dec 2003 07:44:19 -0000 1.2.2.2 @@ -4,6 +4,6 @@ constraint notif_email_hold_reply_id_ref references notification_replies(reply_id), to_addr clob, - header clob, + headers clob, body clob ); Index: openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-4.6.4-5.0d1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-4.6.4-5.0d1.sql,v diff -u -r1.2.2.1 -r1.2.2.2 --- openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-4.6.4-5.0d1.sql 27 Nov 2003 10:46:01 -0000 1.2.2.1 +++ openacs-4/packages/notifications/sql/oracle/upgrade/upgrade-4.6.4-5.0d1.sql 4 Dec 2003 07:44:21 -0000 1.2.2.2 @@ -4,6 +4,6 @@ constraint notif_email_hold_reply_id_ref references notification_replies(reply_id), to_addr clob, - header clob, + headers clob, body clob ); Index: openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-4.6.4-5.0d1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-4.6.4-5.0d1.sql,v diff -u -r1.1 -r1.1.2.1 --- openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-4.6.4-5.0d1.sql 6 Nov 2003 19:23:02 -0000 1.1 +++ openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-4.6.4-5.0d1.sql 4 Dec 2003 07:44:21 -0000 1.1.2.1 @@ -1,8 +1,9 @@ create table notification_email_hold ( reply_id integer - references notification_replies(reply_id) - primary key, + constraint notification_email_hold_pk primary key + constraint notif_email_hold_reply_id_ref + references notification_replies(reply_id), to_addr text, - header text, + headers text, body text );