Index: openacs-4/packages/dotlrn-project-manager/tcl/dotlrn-project-manager-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-project-manager/tcl/dotlrn-project-manager-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn-project-manager/tcl/dotlrn-project-manager-procs-postgresql.xql	21 Jul 2005 16:43:01 -0000	1.1
+++ openacs-4/packages/dotlrn-project-manager/tcl/dotlrn-project-manager-procs-postgresql.xql	19 Aug 2005 22:53:22 -0000	1.2
@@ -12,5 +12,16 @@
   </querytext>
 </fullquery>
 
+<fullquery name="dotlrn_project_manager::upgrade.get_portal_templates">
+  <querytext>
+	select 
+		portal_id 
+	from 
+		portals 
+	where 
+		name in ('#dotlrn.subcommunities_pretty_plural# Portal','#dotlrn.class_instance_portal_pretty_name# Portal','#dotlrn.clubs_pretty_plural# Portal') 
+		and template_id is null;
+  </querytext>
+</fullquery>
 
 </queryset>
Index: openacs-4/packages/dotlrn-project-manager/tcl/dotlrn-project-manager-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-project-manager/tcl/dotlrn-project-manager-procs.tcl,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/dotlrn-project-manager/tcl/dotlrn-project-manager-procs.tcl	19 Aug 2005 21:01:52 -0000	1.8
+++ openacs-4/packages/dotlrn-project-manager/tcl/dotlrn-project-manager-procs.tcl	19 Aug 2005 22:53:22 -0000	1.9
@@ -355,3 +355,45 @@
 }
 
 # Some dotlrn_project_manager specific procs
+
+ad_proc -private dotlrn_project_manager::upgrade {
+    {-from_version_name:required }
+    {-to_version_name:required }
+} {
+    Procedures to upgrade dotlrn-project-manager
+    
+    @author Miguel Marin (miguelmarin@viaro.net)
+    @author Viaro Networks www.viaro.net
+} {
+    apm_upgrade_logic \
+	-from_version_name $from_version_name \
+	-to_version_name $to_version_name \
+	-spec {
+	    0.1d 0.1d1 {
+		# We are going to add all the portlets of project-manager to the 
+		# templates
+		
+		db_foreach get_portal_templates { } {
+		    project_manager_portlet::add_self_to_page \
+			-portal_id $portal_id \
+			-project_manager_id 0 \
+			-package_id 0
+
+		    project_manager_task_portlet::add_self_to_page \
+			-portal_id $portal_id \
+			-project_manager_id 0 \
+			-package_id 0
+		    
+		    project_manager_calendar_portlet::add_self_to_page \
+			-portal_id $portal_id \
+			-project_manager_id 0 \
+			-package_id 0
+		    
+		    project_manager_project_calendar_portlet::add_self_to_page \
+			-portal_id $portal_id \
+			-project_manager_id 0 \
+			-package_id 0
+		}
+	    }
+	}
+}
\ No newline at end of file