Rem
Rem $Header: license_indexes.sql 16-sep-2005.01:55:20 paachary Exp $
Rem
Rem license_indexes.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      license_indexes.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      This file contains indexes newly created for license functionality
Rem      as a part of 10gR2.
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    paachary    09/16/05 - Removed indexes mgmt_lcnsbl_tgt_tps_pktgt_fk AND mgmt_licnse_defntns_tgttype_fk
Rem    bram        08/22/05 - Bug-4564217-Removed Indexes -MGMT_LCNSD_TGTS_TGTGUID_FK and
Rem                           MGMT_LCNSD_TGTS_FRMTGTGUID_FK
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    bram        05/16/05 - Added Index on mgmt_licensed_targets
Rem    paachary    03/16/05 - Added reference key constraints for the foll tabls
Rem                           mgmt_license_definitions	target_type
Rem                           mgmt_licensable_target_types	pack_target_type
Rem                           mgmt_licensed_targets	target_guid
Rem                           mgmt_license_confirmation	target_guid
Rem                           Changed the name of MGMT_LICENSED_TARGETS_FK to MGMT_LCNSD_TGTS_FRMTGTGUID_FK constraint
Rem    paachary    03/08/05 - paachary_upgrdscrpts
Rem    paachary    03/03/05 - Created
Rem

ALTER TABLE mgmt_license_confirmation
ADD CONSTRAINT mgmt_lcns_cnfrmtn_tgtguid_fk
FOREIGN KEY (target_guid)
REFERENCES mgmt_targets(target_guid)
ON DELETE CASCADE ;

Rem
Rem Index Creation on mgmt_licensed_targets
Rem
CREATE INDEX mgmt_licensed_targets_idx_01
ON MGMT_LICENSED_TARGETS
(from_target_guid);