Rem drv: <migrate type="schema_upgrade" version="10.2.0.4"/>
Rem
Rem $Header: jobs_schema_upgrade.sql 23-jan-2008.00:21:49 jvishen Exp $
Rem
Rem jobs_schema_upgrade.sql
Rem
Rem Copyright (c) 2007, 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      jobs_schema_upgrade.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    jvishen     01/23/08 - fix index
Rem    kmanicka    05/24/07 - Implement 10.2.0.4 Trusted RemoteOp
Rem    kmanicka    05/24/07 - Created
Rem


ALTER TABLE MGMT_JOB_TYPE_INFO
    ADD trusted NUMBER(1) DEFAULT -1 NOT NULL;


ALTER TABLE MGMT_JOB_COMMAND ADD 
    is_trustable NUMBER(1) DEFAULT 0 NOT NULL;


ALTER TABLE MGMT_JOB_EXECPLAN ADD
    trusted NUMBER(1) DEFAULT -1 NOT NULL;

ALTER TYPE MGMT_JOB_STEP_RECORD ADD ATTRIBUTE
(trusted INTEGER) CASCADE ;

DECLARE
  pk_exists exception ;
  pragma exception_init(pk_exists, -2260);
BEGIN
  BEGIN
    EXECUTE IMMEDIATE
      'alter table MGMT_JOB_TYPE_PARAM_DSPLY_INFO add  CONSTRAINT PK_JOB_TYPE_PARAM_DSPLY_INFO PRIMARY KEY(job_type_id,parameter_name)';
  EXCEPTION
     WHEN pk_exists THEN
      NULL;
     WHEN OTHERS THEN
      RAISE;
  END;
END;
/