Index: openacs-4/packages/imsld/sql/postgresql/imsld-level-c-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/imsld-level-c-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/imsld/sql/postgresql/imsld-level-c-create.sql	21 Dec 2006 15:20:47 -0000	1.2
+++ openacs-4/packages/imsld/sql/postgresql/imsld-level-c-create.sql	23 Jan 2007 11:33:48 -0000	1.3
@@ -65,3 +65,4 @@
 
 comment on table imsld_runtime_activities_rels is '
 This table stores the relationships between run time assigned activities and roles.';
+
Index: openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-0.1d-1.0d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-0.1d-1.0d.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-0.1d-1.0d.sql	3 Jan 2007 09:14:54 -0000	1.1
+++ openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-0.1d-1.0d.sql	23 Jan 2007 11:33:49 -0000	1.2
@@ -1,56 +1,7 @@
--- upgrade script from 0.01d to 1.0d
+-- upgrade script from 0.1d to 1.0d
 
-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 ();
+-- all the sql is now done in the tcl upgrade script. just source the level c...
 
+\i ../imsld-level-c-create.sql
 
-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');
-
-create sequence t_imsld_rar_seq;
-create view imsld_rar_seq as
-select nextval('t_imsld_rar_seq') as nextval;
-
-create table imsld_runtime_activities_rels (
-    rel_id      integer
-                constraint imsld_rar_rels_pk
-                primary key,
-    run_id      integer
-                constraint imsld_rar_run_fk
-                references imsld_runs,
-    role_id     integer
-                constraint imsld_rar_role_fk
-                references cr_revisions,
-    activity_id integer
-                constraint imsld_rar_act_fk
-                references cr_revisions
-);
-
-comment on table imsld_runtime_activities_rels is '
-This table stores the relationships between run time assigned activities and roles.';
-
-\i ../imsld-level-c-create.sql
Index: openacs-4/packages/imsld/tcl/imsld-install-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/tcl/imsld-install-procs.tcl,v
diff -u -r1.41 -r1.42
--- openacs-4/packages/imsld/tcl/imsld-install-procs.tcl	21 Dec 2006 15:20:47 -0000	1.41
+++ openacs-4/packages/imsld/tcl/imsld-install-procs.tcl	23 Jan 2007 11:33:49 -0000	1.42
@@ -562,7 +562,7 @@
         -from_version_name $from_version_name \
         -to_version_name $to_version_name \
         -spec {
-            0.01d 1.0d {
+            0.1d 1.0d {
                 ### IMS-LD LEVEL C
                 
                 # notifications