Index: openacs-4/packages/bulk-mail/sql/postgresql/upgrade/upgrade-0.2-0.3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/postgresql/upgrade/Attic/upgrade-0.2-0.3.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/bulk-mail/sql/postgresql/upgrade/upgrade-0.2-0.3.sql	28 Aug 2003 09:41:52 -0000	1.2
@@ -0,0 +1,9 @@
+-- send_date needs to be of type timestampz
+
+alter table bulk_mail_messages alter column send_date drop not null;
+alter table bulk_mail_messages add column new_send_date timestamptz;
+alter table bulk_mail_messages alter column new_send_date set default now();
+update bulk_mail_messages set new_send_date = send_date;
+alter table bulk_mail_messages alter column new_send_date set not null;
+alter table bulk_mail_messages drop column send_date;
+alter table bulk_mail_messages rename column new_send_date to send_date;
