Index: openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql	15 May 2002 22:07:52 -0000	1.1
+++ openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql	28 Aug 2003 09:41:52 -0000	1.2
@@ -18,12 +18,6 @@
                                 default sysdate
                                 constraint bm_messages_send_date_nn
                                 not null,
-    sent_p                      char(1)
-                                default 'f'
-                                constraint bm_messages_sent_p_ck
-                                check (sent_p in ('t', 'f'))
-                                constraint bm_messages_sent_p_nn
-                                not null,
     from_addr                   varchar(4000)
                                 constraint bm_messages_from_addr_nn
                                 not null,
@@ -33,8 +27,14 @@
     message                     clob
                                 constraint bm_messages_message_nn
                                 not null,
-    query                       varchar(4000)
+    query                       clob
                                 constraint bm_messages_query_nn
+                                not null,
+    status                      varchar2(100)
+                                default 'pending'
+                                constraint bm_messages_status_ck
+                                check (status in ('pending', 'sent'))
+                                constraint bm_messages_status_nn
                                 not null
 );