Index: openacs-4/packages/project-manager/project-manager.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/project-manager.info,v
diff -u -r1.40 -r1.41
--- openacs-4/packages/project-manager/project-manager.info	16 Nov 2005 17:40:43 -0000	1.40
+++ openacs-4/packages/project-manager/project-manager.info	18 Nov 2005 01:20:29 -0000	1.41
@@ -26,7 +26,7 @@
         <requires url="logger" version="1.1b2"/>
         <requires url="notifications" version="5.0.0a5"/>
         <requires url="organizations" version="0.3d"/>
-        <requires url="ratings" version="0.1d1"/>
+        <requires url="ratings" version="0.1d"/>
 
         <callbacks>
             <callback type="after-install"  proc="pm::install::package_install"/>
Index: openacs-4/packages/project-manager/sql/postgresql/upgrade/upgrade-3.0b4-3.1d12.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/sql/postgresql/upgrade/Attic/upgrade-3.0b4-3.1d12.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/project-manager/sql/postgresql/upgrade/upgrade-3.0b4-3.1d12.sql	26 Oct 2005 19:04:44 -0000	1.1
+++ openacs-4/packages/project-manager/sql/postgresql/upgrade/upgrade-3.0b4-3.1d12.sql	18 Nov 2005 01:20:29 -0000	1.2
@@ -29,15 +29,52 @@
     'varchar(100)' -- column_spec
 );
 
+select acs_rel_type__create_type (
+      'application_link',
+      '#Application_Link#',
+      '#Application_Links#',
+      'relationship',
+      'apm_package',
+      'package_id',
+      'application_link_rel',
+      'acs_object',
+      'user',
+      1,
+      1,
+      'acs_object',
+      'user',
+      1,
+      1
+);
+
+select acs_rel_type__create_type (
+      'application_data_link',
+      '#Application_Data_Link#',
+      '#Application_Data_Links#',
+      'relationship',
+      'apm_package_rel',
+      'package_id',
+      'application_data_link_rel',
+      'acs_object',
+      'user',
+      1,
+      1,
+      'acs_object',
+      'user',
+      1,
+      1
+);
+
 create function inline_0 ()
 returns integer as '
 DECLARE
         lp RECORD;
 BEGIN
         FOR lp IN
            SELECT distinct(item_id), logger_project
-           FROM pm_projectsx
+           FROM pm_projectsx where logger_project IS NOT NULL 
         LOOP
+        raise NOTICE ''item_id (%) | logger_project (%)'', lp.item_id, lp.logger_project;
         perform acs_rel__new (
                          null,
                          ''application_data_link'',
@@ -486,3 +523,5 @@
 
         return v_revision_id;
 end;' language 'plpgsql';
+
+select content_type__refresh_view('pm_project');
Index: openacs-4/packages/project-manager/tcl/install-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/tcl/install-procs.tcl,v
diff -u -r1.25 -r1.26
--- openacs-4/packages/project-manager/tcl/install-procs.tcl	26 Oct 2005 19:07:31 -0000	1.25
+++ openacs-4/packages/project-manager/tcl/install-procs.tcl	18 Nov 2005 01:20:29 -0000	1.26
@@ -184,10 +184,7 @@
         -spec {
 	    3.0b4 3.1d12 {
                 ns_log notice "Running Pre-Upgrade Routine"
-		db_transaction {
-                    rel_types::new "application_link" "Application Link" "Application Links" apm_package 0 "" apm_package 0 ""
-                    rel_types::new "application_data_link" "Application Data Link" "Application Data Links" acs_object 0 "" acs_object 0 ""
-                }
+		
             }
         }
 }