Index: openacs-4/packages/bulk-mail/bulk-mail.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/bulk-mail.info,v
diff -u -N -r1.1.1.1.2.3 -r1.1.1.1.2.4
--- openacs-4/packages/bulk-mail/bulk-mail.info	5 May 2003 09:31:49 -0000	1.1.1.1.2.3
+++ openacs-4/packages/bulk-mail/bulk-mail.info	11 Jun 2003 10:35:56 -0000	1.1.1.1.2.4
@@ -6,17 +6,16 @@
     <pretty-plural>Bulk Mail</pretty-plural>
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
+    
+    <version name="0.2" url="http://openacs.org/repository/download/apm/bulk-mail-0.2.apm">
+        <owner url="mailto:yon@milliped.com">Yonatan Feldman</owner>
+        <release-date>2003-06-11</release-date>
 
-    <version name="0.1a" url="http://openacs.org/repository/download/apm/bulk-mail-0.1a.apm">
-    <database-support>
-        <database>oracle</database>
-        <database>postgresql</database>
-    </database-support>
-        <owner url="mailto:yon@openforce.net">Yonatan Feldman</owner>
-
-        <provides url="bulk-mail" version="0.1a"/>
+        <provides url="bulk-mail" version="0.2"/>
         <requires url="acs-mail-lite" version="0.1d"/>
 
+        <callbacks>
+        </callbacks>
         <parameters>
             <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="PrettyName"  default="Bulk Mail" description="Name of the package to display everywhere"/>
         </parameters>
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 -r1.1.1.1.2.1
--- openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql	15 May 2002 22:07:52 -0000	1.1.1.1
+++ openacs-4/packages/bulk-mail/sql/oracle/bulk-mail-create.sql	11 Jun 2003 10:36:28 -0000	1.1.1.1.2.1
@@ -33,7 +33,7 @@
     message                     clob
                                 constraint bm_messages_message_nn
                                 not null,
-    query                       varchar(4000)
+    query                       clob
                                 constraint bm_messages_query_nn
                                 not null
 );
Index: openacs-4/packages/bulk-mail/sql/oracle/upgrade/upgrade-0.1a-0.2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/oracle/upgrade/upgrade-0.1a-0.2.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/bulk-mail/sql/oracle/upgrade/upgrade-0.1a-0.2.sql	11 Jun 2003 10:37:15 -0000	1.1.2.1
@@ -0,0 +1,7 @@
+alter table bulk_mail_messages add (temp clob constraint temp_nn not null);
+update bulk_mail_messages set temp = query;
+alter table bulk_mail_messages drop column query cascade constraints;
+
+alter table bulk_mail_messages add (query clob constraint bm_messages_query_nn not null);
+update bulk_mail_messages set query = temp;
+alter table bulk_mail_messages drop column temp cascade constraints;
Index: openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql,v
diff -u -N -r1.2 -r1.2.2.1
--- openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql	12 Jun 2002 13:53:13 -0000	1.2
+++ openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql	11 Jun 2003 10:37:49 -0000	1.2.2.1
@@ -33,7 +33,7 @@
     message                     text
                                 constraint bm_messages_message_nn
                                 not null,
-    query                       varchar(4000)
+    query                       text
                                 constraint bm_messages_query_nn
                                 not null
 );
Index: openacs-4/packages/bulk-mail/sql/postgresql/upgrade/upgrade-0.1a-0.2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/postgresql/upgrade/Attic/upgrade-0.1a-0.2.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/bulk-mail/sql/postgresql/upgrade/upgrade-0.1a-0.2.sql	11 Jun 2003 10:38:13 -0000	1.1.2.1
@@ -0,0 +1,13 @@
+-- create the new query column as type 'text'
+alter table bulk_mail_messages add column query2 text;
+
+alter table bulk_mail_messages alter column query2 set not null;
+
+-- update the rows
+update bulk_mail_messages set query2 = query;
+
+-- drop the old column
+alter table bulk_mail_messages drop column query cascade;
+
+-- rename the new column ot the correct name
+alter table bulk_mail_messages rename column query2 to query;