Index: openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-package-create.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-package-create.sql 30 Sep 2003 12:10:04 -0000 1.3 +++ openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-package-create.sql 21 Oct 2003 21:31:22 -0000 1.4 @@ -19,7 +19,7 @@ reply_to in bulk_mail_messages.reply_to%TYPE default null, extra_headers in bulk_mail_messages.extra_headers%TYPE default null, message in varchar, - query in bulk_mail_messages.query%TYPE, + query in varchar, creation_date in acs_objects.creation_date%TYPE default sysdate, creation_user in acs_objects.creation_user%TYPE default null, creation_ip in acs_objects.creation_ip%TYPE default null, @@ -48,7 +48,7 @@ reply_to in bulk_mail_messages.reply_to%TYPE default null, extra_headers in bulk_mail_messages.extra_headers%TYPE default null, message in varchar, - query in bulk_mail_messages.query%TYPE, + query in varchar, creation_date in acs_objects.creation_date%TYPE default sysdate, creation_user in acs_objects.creation_user%TYPE default null, creation_ip in acs_objects.creation_ip%TYPE default null,