-- Adds indexes for RI checking
--
--  cr_mime_types.mime_type
create index cr_cont_mimetypmap_mimetyp_idx ON cr_content_mime_type_map(mime_type);
--  acs_object_types.object_type
create index cr_folder_typ_map_cont_typ_idx ON cr_folder_type_map(content_type);
--  apm_packages.package_id
create index cr_folders_package_id_idx ON cr_folders(package_id);
--  cr_keywords.keyword_id
create index cr_item_keyword_map_kw_id_idx ON cr_item_keyword_map(keyword_id);
--  acs_objects.object_id
create index cr_item_rels_rel_obj_id_idx ON cr_item_rels(related_object_id);
--  cr_keywords.keyword_id
create index cr_keywords_parent_id_idx ON cr_keywords(parent_id);
--  cr_items.item_id
create index cr_revisions_item_id_idx ON cr_revisions(item_id);
--  acs_object_types.object_type
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);