Index: openacs-4/packages/lors/sql/postgresql/lors-imscp-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lors/sql/postgresql/lors-imscp-create.sql,v
diff -u -N -r1.8 -r1.9
--- openacs-4/packages/lors/sql/postgresql/lors-imscp-create.sql	20 May 2005 18:25:04 -0000	1.8
+++ openacs-4/packages/lors/sql/postgresql/lors-imscp-create.sql	27 May 2005 20:46:23 -0000	1.9
@@ -96,7 +96,20 @@
 );
 
 
+create or replace function ims_manifest__get_title (integer)
+returns varchar as '
+declare
+  get_title__man_id             alias for $1;  
+  get_title__course_name        varchar(200);  
+begin
+  return course_name
+  from ims_cp_manifests
+  where man_id = get_title__man_id;
 
+end;' language 'plpgsql';
+
+
+
 -- Organizations
 create table ims_cp_organizations (
     org_id          integer
@@ -133,7 +146,17 @@
        'ims_organization__get_title' -- name_method
 );
 
+create or replace function ims_organization__get_title (integer)
+returns varchar as '
+declare
+  get_title__org_id             alias for $1;  
+  get_title__identifier        varchar(200);  
+begin
+  return identifier
+  from ims_cp_organizations
+  where org_id = get_title__org_id;
 
+end;' language 'plpgsql';
 
 
 -- Items
@@ -184,8 +207,19 @@
        'ims_item__get_title' -- name_method
 );
 
+create or replace function ims_item__get_title (integer)
+returns varchar as '
+declare
+  get_title__ims_item_id       	alias for $1;  
+  get_title__item_title        varchar(200);  
+begin
+  return item_title
+  from ims_cp_items
+  where ims_item_id = get_title__ims_item_id;
 
+end;' language 'plpgsql';
 
+
 -- Resources
     
 create table ims_cp_resources (
@@ -223,7 +257,19 @@
        'ims_resource__get_title' -- name_method
 );
 
+create or replace function ims_resource__get_title (integer)
+returns varchar as '
+declare
+  get_title__res_id             alias for $1;  
+  get_title__identifier        varchar(200);  
+begin
+  return identifier
+  from ims_cp_resources
+  where res_id = get_title__res_id;
 
+end;' language 'plpgsql';
+
+
 -- An item can have reference to one of more resources
 -- therefore we need a table that takes care of this multiple
 -- relationship