Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -N -r1.17.2.2 -r1.17.2.3
--- openacs-4/packages/acs-content-repository/acs-content-repository.info	22 Jan 2003 20:21:01 -0000	1.17.2.2
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info	3 Feb 2003 15:13:02 -0000	1.17.2.3
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="4.6.1" url="http://openacs.org/repository/download/apm/acs-content-repository-4.6.1.apm">
+    <version name="4.6.2" url="http://openacs.org/repository/download/apm/acs-content-repository-4.6.2.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
@@ -18,7 +18,7 @@
         <release-date>2002-10-27</release-date>
         <vendor url="http://openacs.org/">OpenACS</vendor>
 
-        <provides url="acs-content-repository" version="4.6.1"/>
+        <provides url="acs-content-repository" version="4.6.2"/>
         <requires url="acs-kernel" version="4.0"/>
         <requires url="acs-service-contract" version="4.2"/>
         <requires url="search" version="4.2"/>
@@ -59,6 +59,7 @@
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-4.1-4.1.2.sql"/>
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-4.5-4.6.sql"/>
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-4.6-4.6.1.sql"/>
+            <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql"/>
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/acs-content-repository-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/content-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/content-drop.sql"/>
@@ -89,6 +90,7 @@
             <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.1.2-4.5.sql"/>
             <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.5-4.6.sql"/>
             <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql"/>
+            <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql"/>
             <file type="query_file" db_type="oracle" path="tcl/acs-content-repository-init-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="tcl/acs-content-repository-init-postgresql.xql"/>
             <file type="tcl_init" path="tcl/acs-content-repository-init.tcl"/>
Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v
diff -u -N -r1.16.2.1 -r1.16.2.2
--- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	22 Jan 2003 20:21:22 -0000	1.16.2.1
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	3 Feb 2003 15:13:19 -0000	1.16.2.2
@@ -96,6 +96,8 @@
   content type.
 ';
 
+--RI Indexes 
+create index cr_cont_mimetypmap_mimetyp_idx ON cr_content_mime_type_map(mime_type);
 
 
 --------------------------------------------------------------
@@ -149,6 +151,9 @@
   primary key (parent_type, child_type, relation_tag)
 );
 
+--RI Indexes 
+create index cr_type_children_chld_type_idx ON cr_type_children(child_type);
+
 comment on table cr_type_children is '
   Constrains the allowable content types which a content type may
   contain.
@@ -168,6 +173,9 @@
   primary key (content_type, target_type, relation_tag)
 );
 
+-- RI Indexes 
+create index cr_type_relations_tgt_typ_idx ON cr_type_relations(target_type);
+
 comment on table cr_type_relations is '
   Constrains the allowable object types to which a content type may
   relate (see above).
@@ -298,6 +306,9 @@
   item_id, related_object_id, relation_tag
 );
 
+-- RI Indexes 
+create index cr_item_rels_rel_obj_id_idx ON cr_item_rels(related_object_id);
+
 comment on table cr_item_rels is '
   Describes all relations from one item to any number of other
   objects.
@@ -344,6 +355,8 @@
 
 create index cr_revisions_by_mime_type on cr_revisions(mime_type);
 create index cr_revisions_title_idx on cr_revisions(title);
+create index cr_revisions_item_id_idx ON cr_revisions(item_id);
+
 -- create index cr_revisions_lower_title_idx on cr_revisions(lower(title));
 -- create index cr_revisions_title_ltr_idx on cr_revisions(substr(lower(title), 1, 1));
 
@@ -478,6 +491,8 @@
   repository.
 ';
 
+--RI Indexes 
+create index cr_folders_package_id_idx ON cr_folders(package_id);
 
 create table cr_folder_type_map (
   folder_id	integer
@@ -497,9 +512,10 @@
   thos available for content types.  
 ';
 
+-- RI Indexes 
+create index cr_folder_typ_map_cont_typ_idx ON cr_folder_type_map(content_type);
 
 
-
 --------------------------------------------------------------
 -- CONTENT TEMPLATES
 --------------------------------------------------------------
@@ -666,6 +682,9 @@
                          check (has_children in ('t', 'f'))
 );
 
+-- RI Indexes 
+create index cr_keywords_parent_id_idx ON cr_keywords(parent_id);
+
 comment on table cr_keywords is '
   Stores a subject taxonomy for classifying content items, analogous
   to the system used by a library.
@@ -698,6 +717,8 @@
   primary key (item_id, keyword_id)
 );
 
+-- RI Indexes 
+create index cr_item_keyword_map_kw_id_idx ON cr_item_keyword_map(keyword_id);
 
 --------------------------------------------------------------
 -- TEXT SUBMISSION
Index: openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql	3 Feb 2003 15:13:38 -0000	1.1.2.1
@@ -0,0 +1,11 @@
+-- Adds indexes for RI checking
+--
+create index cr_cont_mimetypmap_mimetyp_idx ON cr_content_mime_type_map(mime_type); --  cr_mime_types.mime_type
+create index cr_folder_typ_map_cont_typ_idx ON cr_folder_type_map(content_type); --  acs_object_types.object_type
+create index cr_folders_package_id_idx ON cr_folders(package_id); --  apm_packages.package_id
+create index cr_item_keyword_map_kw_id_idx ON cr_item_keyword_map(keyword_id); --  cr_keywords.keyword_id
+create index cr_item_rels_rel_obj_id_idx ON cr_item_rels(related_object_id); --  acs_objects.object_id
+create index cr_keywords_parent_id_idx ON cr_keywords(parent_id); --  cr_keywords.keyword_id
+create index cr_revisions_item_id_idx ON cr_revisions(item_id); --  cr_items.item_id
+create index cr_type_children_chld_type_idx ON cr_type_children(child_type); --  acs_object_types.object_type
+create index cr_type_relations_tgt_typ_idx ON cr_type_relations(target_type); --  acs_object_types.object_type
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -N -r1.36.2.2 -r1.36.2.3
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	22 Jan 2003 20:21:47 -0000	1.36.2.2
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	3 Feb 2003 15:14:07 -0000	1.36.2.3
@@ -104,8 +104,10 @@
   content type.
 ';
 
+-- RI Index 
+-- fairly static, could probably omit this one.
+create index cr_cont_mimetypmap_mimetyp_idx ON cr_content_mime_type_map(mime_type);
 
-
 --------------------------------------------------------------
 -- LOCALES
 --------------------------------------------------------------
@@ -162,6 +164,10 @@
   contain.
 ';
 
+-- RI Indexes
+create index cr_type_children_chld_type_idx ON cr_type_children(child_type);
+
+
 create table cr_type_relations (
   content_type  varchar(100)
 		constraint cr_type_relations_parent_fk
@@ -181,6 +187,10 @@
   relate (see above).
 ';
 
+-- RI Indexes 
+create index cr_type_relations_tgt_typ_idx ON cr_type_relations(target_type);
+
+
 --------------------------------------------------------------
 -- CONTENT ITEMS
 --------------------------------------------------------------
@@ -413,6 +423,9 @@
   item_id, related_object_id, relation_tag
 );
 
+-- RI Indexes
+create index cr_item_rels_rel_obj_id_idx ON cr_item_rels(related_object_id);
+
 comment on table cr_item_rels is '
   Describes all relations from one item to any number of other
   objects.
@@ -459,6 +472,10 @@
   content_length  integer
 );
 
+-- RI Indexes 
+create index cr_revisions_lob_idx ON cr_revisions(lob);
+create index cr_revisions_item_id_idx ON cr_revisions(item_id);
+
 create trigger cr_revisions_lob_trig before delete or update or insert
 on cr_revisions for each row execute procedure on_lob_ref();
 
@@ -760,6 +777,8 @@
   repository.
 ';
 
+--RI Indexes
+create index cr_folders_package_id_idx ON cr_folders(package_id);
 
 create function cr_folder_ins_up_ri_trg() returns opaque as '
 declare
@@ -819,9 +838,9 @@
   thos available for content types.  
 ';
 
+-- RI Indexes 
+create index cr_folder_typ_map_cont_typ_idx ON cr_folder_type_map(content_type);
 
-
-
 --------------------------------------------------------------
 -- CONTENT TEMPLATES
 --------------------------------------------------------------
@@ -984,6 +1003,8 @@
   tree_sortkey           varbit
 );
 
+-- RI Indexes 
+create index cr_keywords_parent_id_idx ON cr_keywords(parent_id);
 
 create function cr_keywords_get_tree_sortkey(integer) returns varbit as '
 declare
@@ -1114,6 +1135,8 @@
   primary key (item_id, keyword_id)
 );
 
+-- RI Indexes
+create index cr_item_keyword_map_kw_id_idx ON cr_item_keyword_map(keyword_id);
 
 --------------------------------------------------------------
 -- TEXT SUBMISSION
Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql	3 Feb 2003 15:14:42 -0000	1.1.2.1
@@ -0,0 +1,12 @@
+-- Adds indexes for RI checking
+--
+create index cr_cont_mimetypmap_mimetyp_idx ON cr_content_mime_type_map(mime_type); --  cr_mime_types.mime_type
+create index cr_folder_typ_map_cont_typ_idx ON cr_folder_type_map(content_type); --  acs_object_types.object_type
+create index cr_folders_package_id_idx ON cr_folders(package_id); --  apm_packages.package_id
+create index cr_item_keyword_map_kw_id_idx ON cr_item_keyword_map(keyword_id); --  cr_keywords.keyword_id
+create index cr_item_rels_rel_obj_id_idx ON cr_item_rels(related_object_id); --  acs_objects.object_id
+create index cr_keywords_parent_id_idx ON cr_keywords(parent_id); --  cr_keywords.keyword_id
+create index cr_revisions_lob_idx ON cr_revisions(lob); --  lobs.lob_id
+create index cr_revisions_item_id_idx ON cr_revisions(item_id); --  cr_items.item_id
+create index cr_type_children_chld_type_idx ON cr_type_children(child_type); --  acs_object_types.object_type
+create index cr_type_relations_tgt_typ_idx ON cr_type_relations(target_type); --  acs_object_types.object_type