Index: openacs-4/packages/lorsm/lorsm.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/lorsm.info,v
diff -u -N -r1.24 -r1.25
--- openacs-4/packages/lorsm/lorsm.info	10 Oct 2009 22:38:10 -0000	1.24
+++ openacs-4/packages/lorsm/lorsm.info	16 Apr 2010 19:29:35 -0000	1.25
@@ -7,13 +7,13 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
 
-    <version name="0.9d5" url="http://openacs.org/repository/download/apm/lorsm-0.9d5.apm">
+    <version name="0.10d2" url="http://openacs.org/repository/download/apm/lorsm-0.10d2.apm">
         <owner url="mailto:ernieg@mm.st">Ernie Ghiglione</owner>
         <summary>Application to manage the services from the Learning Object Repository. </summary>
         <release-date>2008-10-17</release-date>
         <description format="text/html">This application manages the services from the Learning Object Repository: upload courses, manage and create metadata, delete resources and courses. </description>
 
-        <provides url="lorsm" version="0.9d5"/>
+        <provides url="lorsm" version="0.10d2"/>
         <requires url="acs-datetime" version="5.2.2"/>
         <requires url="lors" version="0.7d2"/>
         <requires url="views" version="0.2d1"/>
Index: openacs-4/packages/lorsm/sql/postgresql/lorsm-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/sql/postgresql/lorsm-create.sql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/lorsm/sql/postgresql/lorsm-create.sql	9 Feb 2009 03:57:30 -0000	1.7
+++ openacs-4/packages/lorsm/sql/postgresql/lorsm-create.sql	16 Apr 2010 19:29:35 -0000	1.8
@@ -108,14 +108,14 @@
 
 create table lorsm_custom_pages (
 	man_id integer
-	constraint lors_st_end_pgs_man_id_pk
-        primary key 
-	constraint lors_st_end_pgs_man_id_fk
+    	constraint lors_st_end_pgs_man_id_fk
         references ims_cp_manifests (man_id),
 	page_id integer
-	constraint lors_st_end_pgs_start_id_fk
-	references cr_items (item_id),
-	type varchar(100)
+	    constraint lors_st_end_pgs_start_id_fk
+	    references cr_items (item_id),
+	type varchar(100),
+	constraint lcp_man_id_type_pk
+        primary key (man_id, type)
 );
 
 comment on table lorsm_custom_pages is '
Index: openacs-4/packages/lorsm/sql/postgresql/upgrade/upgrade-0.10d1-0.10d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/sql/postgresql/upgrade/upgrade-0.10d1-0.10d2.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/lorsm/sql/postgresql/upgrade/upgrade-0.10d1-0.10d2.sql	16 Apr 2010 19:29:35 -0000	1.1
@@ -0,0 +1,6 @@
+-- upgrade from 0.10d1 o 0.10d2
+--
+
+alter table lorsm_custom_pages drop constraint lors_st_end_pgs_man_id_pk;
+
+alter table lorsm_custom_pages add constraint lcp_man_id_type_pk primary key (man_id, type);