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 );