Index: openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-0.01d-1.0d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/upgrade/Attic/upgrade-0.01d-1.0d.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-0.01d-1.0d.sql	3 Nov 2006 14:40:39 -0000	1.1
@@ -0,0 +1,34 @@
+
+
+--create function inline_0 ()
+--returns integer as'
+--declare
+--  sel_rec record;
+--begin
+--  for sel_rec in select serv.username_property_id, serv.email_property_id, data.data_id 
+--    from imsld_send_mail_data data, imsld_send_mail_servicesi serv 
+--	where data.send_mail_id = serv.item_id
+--    and content_revision__is_live(serv.mail_id) = ''t''
+--  loop 
+--    update imsld_send_mail_data 
+--    set email_property_id = sel_rec.email_property_id,
+--    username_property_id = sel_rec.username_property_id
+--    where data_id = sel_rec.data_id;
+--  end loop;
+--return 0;
+--end;' language 'plpgsql';
+--select inline_0 ();
+--drop function inline_0 ();
+
+
+--drop index imsld_sm_data_sm_id_idx;
+--alter table imsld_send_mail_data drop column send_mail_id cascade;
+--select content_type__drop_attribute('imsld_send_mail_data','send_mail_id','f');
+
+--alter table imsld_send_mail_services drop column email_property_id cascade;
+--select content_type__drop_attribute('imsld_send_mail_service','email_property_id','f');
+
+--alter table imsld_send_mail_services drop column username_property_id cascade;
+--select content_type__drop_attribute('imsld_send_mail_service','username_property_id','f');
+
+\i ../imsld-level-c-create.sql