Rem drv: <create type="indexes"/>
Rem
Rem $Header: blackout_indexes.sql 27-may-2008.13:54:20 rrawat Exp $
Rem
Rem blackout_indexes.sql
Rem
Rem Copyright (c) 2002, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      blackout_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    rrawat      05/23/08 - Bug-7114090
Rem    rrawat      09/01/06 - Bug-5497331
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    pshishir    06/08/05 - Add index on MGMT_BLACKOUT_STATE
Rem    rzazueta    04/05/05 - Add index on mgmt_blackout_target_details 
Rem    rzazueta    02/21/05 - Add index on mgmt_blackout_windows 
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    skini       09/12/03 - Fix primary key for state table 
Rem    skini       08/19/03 - Move PKs to tables 
Rem    skini       07/26/02 - Change schedule table to refer to blackouts
Rem    skini       06/20/02 - Transfer indexes
Rem    skini       06/12/02 - Rename of table
Rem    rpinnama    05/14/02 - rpinnama_reorg_rep_scripts
Rem    rpinnama    05/14/02 - Created
Rem

Rem
Rem Indexes for MGMT_BLACKOUT_SCHEDULE
Rem
ALTER TABLE MGMT_BLACKOUT_SCHEDULE
    ADD CONSTRAINT PK_MGMT_BLACKOUT_SCHEDULE
        PRIMARY KEY(blackout_guid, schedule_index)
       USING INDEX STORAGE
                (FREELISTS 4)
                INITRANS 4;

Rem
Rem Indices for MGMT_BLACKOUT_TARGET_DETAILS table
Rem
ALTER TABLE MGMT_BLACKOUT_TARGET_DETAILS
   ADD CONSTRAINT bkt_tgt_dtls_primary_key
       PRIMARY KEY (blackout_guid, target_guid)
       USING INDEX STORAGE
                (FREELISTS 4)
                INITRANS 4;

CREATE INDEX MGMT_BLACKOUT_TGT_DET_IDX01
  ON MGMT_BLACKOUT_TARGET_DETAILS(target_guid);

Rem
Rem Indices for MGMT_BLACKOUT_TARGET_DETAILS table
Rem
ALTER TABLE MGMT_BLACKOUT_FLAT_TARGETS
   ADD CONSTRAINT bkt_flt_tgts_primary_key
       PRIMARY KEY (blackout_guid, target_guid)
       USING INDEX STORAGE
                (FREELISTS 4)
                INITRANS 4;


Rem
Rem Indices for MGMT_TARGET_BLACKOUTS table
Rem
ALTER TABLE MGMT_BLACKOUT_STATE
   ADD CONSTRAINT target_blackouts_primary_key
       PRIMARY KEY (blackout_guid, target_guid, blackout_code, collection_timestamp)
       USING INDEX STORAGE
                (FREELISTS 4)
                INITRANS 4;

CREATE INDEX MGMT_BLACKOUT_STATE_IDX01
  ON MGMT_BLACKOUT_STATE(target_guid);

Rem
Rem Indices for MGMT_BLACKOUT_WINDOWS table
Rem
CREATE INDEX MGMT_BLACKOUT_WINDOWS_IDX01
  ON MGMT_BLACKOUT_WINDOWS(target_guid);