Index: openacs-4/packages/acs-kernel/sql/oracle/site-node-object-map-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/site-node-object-map-create.sql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-kernel/sql/oracle/site-node-object-map-create.sql 27 Apr 2015 15:28:17 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/site-node-object-map-create.sql 3 Mar 2017 08:21:49 -0000 1.2.2.1 @@ -17,7 +17,7 @@ constraint snom_node_id_nn not null ); -create index site_node_object_mappings_node_id_idx on site_node_object_mappings(node_id); +create index site_node_obj_map_node_id_idx on site_node_object_mappings(node_id); create or replace package site_node_object_map as Index: openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql,v diff -u -r1.9 -r1.9.2.1 --- openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql 27 Apr 2015 15:28:17 -0000 1.9 +++ openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql 3 Mar 2017 08:21:49 -0000 1.9.2.1 @@ -47,7 +47,7 @@ ); create index site_nodes_object_id_idx on site_nodes (object_id); -create index site_nodes_parent_object_node_id_idx on site_nodes(parent_id, object_id, node_id); +create index site_nodes_parent_obj_node_idx on site_nodes(parent_id, object_id, node_id); create index site_nodes_parent_id_idx on site_nodes(parent_id); Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.8.3d1-5.8.3d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.8.3d1-5.8.3d2.sql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.8.3d1-5.8.3d2.sql 27 Apr 2015 15:28:17 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.8.3d1-5.8.3d2.sql 3 Mar 2017 08:21:49 -0000 1.2.2.1 @@ -1,6 +1,6 @@ drop index site_nodes_parent_id_idx; -create index site_nodes_parent_object_node_id_idx on site_nodes(parent_id, object_id, node_id); +create index site_nodes_parent_obj_node_idx on site_nodes(parent_id, object_id, node_id); create index site_nodes_parent_id_idx on site_nodes(parent_id); -create index site_node_object_mappings_node_id_idx on site_node_object_mappings(node_id); +create index site_node_obj_map_node_id_idx on site_node_object_mappings(node_id);