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.3 -r1.4 --- openacs-4/packages/imsld/sql/postgresql/imsld-cp-create.sql 15 Nov 2005 11:55:23 -0000 1.3 +++ openacs-4/packages/imsld/sql/postgresql/imsld-cp-create.sql 15 Nov 2005 12:28:39 -0000 1.4 @@ -72,16 +72,17 @@ type varchar(1000), href varchar(2000), -- pointer to the dotLRN services - object_id constarint imsld_cp_resources_ob_id_fk + acs_object_id integer + constraint 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); +create index imsld_cp_resources_obj_id_idx on imsld_cp_resources(acs_object_id); -comment on column imsld_cp_resources.object_id is ' +comment on column imsld_cp_resources.acs_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.';