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 -N -r1.1.1.1.2.1 -r1.1.1.1.2.2
--- openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql	11 Jun 2003 10:36:28 -0000	1.1.1.1.2.1
+++ openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql	23 Jun 2003 19:44:30 -0000	1.1.1.1.2.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,
@@ -35,6 +29,12 @@
                                 not null,
     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
 );