Index: openacs-4/packages/imsld/sql/postgresql/imsld-cp-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/imsld-cp-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/imsld/sql/postgresql/imsld-cp-create.sql	4 Oct 2005 13:45:40 -0000	1.2
+++ openacs-4/packages/imsld/sql/postgresql/imsld-cp-create.sql	15 Nov 2005 11:55:23 -0000	1.3
@@ -70,12 +70,21 @@
                     on delete cascade,
     identifier      varchar(100),
     type            varchar(1000),
-    href            varchar(2000)
+    href            varchar(2000),
+    -- pointer to the dotLRN services
+    object_id       constarint imsld_cp_resources_ob_id_fk
+                    references acs_objects
+                    on delete cascade
 );
 
 -- create index for imsld_cp_resources
 create index imsld_cp_resources_man_id_idx on imsld_cp_resources(manifest_id);
+create index imsld_cp_resources_obj_id_idx on imsld_cp_resources(object_id);
 
+comment on column imsld_cp_resources.object_id is '
+This field is used to map the resource with a dotLRN service. 
+The dotLRN service which the object_id points to depends on the resource_type.';
+
 -- Resource dependencies
 create table imsld_cp_dependencies (
     dependency_id   integer