Rem drv: <create type="indexes"/>
Rem
Rem $Header: user_model_indexes.sql 30-aug-2005.10:14:05 dcawley Exp $
Rem
Rem user_model_indexes.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      user_model_indexes.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    dcawley     08/30/05 - Remove index 
Rem    dcawley     08/29/05 - Add index on role grants 
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    gsbhatia    02/13/05 - updating repmgr header 
Rem    gsbhatia    02/09/05 - updating repmgr header 
Rem    gsbhatia    02/07/05 - updating repmgr header 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    scgrover    09/17/04 - add index to mgmt_priv_grants 
Rem    dcawley     09/08/04 - Add indexes for flat role grants 
Rem    rpinnama    05/15/02 - rpinnama_reorg_rep_scripts
Rem    rpinnama    05/14/02 - Created
Rem

Rem
Rem Indices for MGMT_PRIVS table
Rem
ALTER TABLE MGMT_PRIVS
  ADD CONSTRAINT mgmt_privs_pk
  PRIMARY KEY (priv_name);

CREATE UNIQUE INDEX mgmt_privs_idx1
  ON MGMT_PRIVS (priv_name, priv_type);


Rem
Rem Indices for MGMT_PRIV_INCLUDES table
Rem
ALTER TABLE MGMT_PRIV_INCLUDES
 ADD CONSTRAINT mgmt_priv_includes_fk_privname
 FOREIGN KEY (priv_name) REFERENCES MGMT_PRIVS (priv_name) 
 ON DELETE CASCADE;

ALTER TABLE MGMT_PRIV_INCLUDES
 ADD CONSTRAINT mgmt_priv_includes_fk_iprivnam
 FOREIGN KEY (ipriv_name) REFERENCES MGMT_PRIVS (priv_name) 
 ON DELETE CASCADE;


Rem
Rem Indices for MGMT_ROLES table
Rem
ALTER TABLE MGMT_ROLES
  ADD CONSTRAINT mgmt_roles_pk
  PRIMARY KEY (role_name);
 
Rem
Rem Indices for MGMT_ROLE_GRANTS table
Rem
CREATE INDEX mgmt_role_grants_idx1
  ON MGMT_ROLE_GRANTS (role_name);

ALTER TABLE MGMT_ROLE_GRANTS
 ADD CONSTRAINT mgmt_role_grants_fk_role_name 
 FOREIGN KEY (role_name) REFERENCES MGMT_ROLES (role_name) 
 ON DELETE CASCADE;

Rem
Rem Indices for MGMT_FLAT_ROLE_GRANTS table
Rem
ALTER TABLE MGMT_FLAT_ROLE_GRANTS
 ADD CONSTRAINT mgmt_flat_role_grants_fk
 FOREIGN KEY (role_name) REFERENCES MGMT_ROLES (role_name) 
 ON DELETE CASCADE;

Rem
Rem Indices for MGMT_PRIV_GRANTS table
Rem
CREATE INDEX mgmt_priv_grants_idx01
 ON MGMT_PRIV_GRANTS(guid, direct_grant) COMPRESS 1;

ALTER TABLE MGMT_PRIV_GRANTS
 ADD CONSTRAINT mgmt_priv_grants_fk_priv_name 
 FOREIGN KEY (priv_name) REFERENCES MGMT_PRIVS (priv_name) 
 ON DELETE CASCADE;