Index: openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql,v
diff -u -r1.41 -r1.42
--- openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	7 Jun 2002 04:42:49 -0000	1.41
+++ openacs-4/packages/new-portal/sql/oracle/portal-core-create.sql	25 Jun 2002 21:47:15 -0000	1.42
@@ -180,6 +180,8 @@
 	unique(portal_id,sort_key)
 );
 
+create index portal_pages_prtl_page_idx on portal_pages (portal_id, page_id);
+
 -- **** Portal Elements (PEs) ****
 
 
@@ -244,7 +246,7 @@
 	value			varchar(200) 
 );
 
-create index p_element__prms_elem_id_idx on portal_element_parameters (element_id);
+create index p_element_prms_elem_id_idx on portal_element_parameters (element_id);
 create index p_element_prms_elem_key_idx on portal_element_parameters (element_id, key);
 
 -- This table maps the datasources that are available for portals to